A three-storey building collapsed in Brooklyn, New York, killing at least two people and injuring several others.