Forty-two African migrants have drowned when their boat capsized off the coast of Yemen, according to officials.