One person has died in hospital after an underground steam pipe explosion tore through a New York street.