The remnants of Hurricane Ida triggered spectacular flash flooding and a rare state of emergency in New York City overnight into Thursday, killing at least eight people in what was called a historic weather event.