New York City mayor Eric Adams says two people have died after a Mexican navy tall ship hit the Brooklyn Bridge.