At least three people have been confirmed dead after a gas leak triggered an earth-shaking explosion that flattened two apartment buildings in New York City.