The area that TWA 800 went doen is a VERY busy place, aircraft wise. I cannot imagine that the Navy was testing any missile in the area. They have places that they test this stuff, and it is nowhere near Long Island.
Go to a General Aviation airport shop and buy yourself a copy of the "New York Sectional." Look at the map, and then get back to the group.