This eye witness account claims that the missile came from the shore while most of the other ones came it claim from the sea. And if from shore, what kind of missile could hit the 747 a number of miles out to sea?
From the article: "I was talking to one of the many men working with me when I saw what looked like a cheap firework rising from beyond the houses along the beach."
It doesn't say it arose from the shore, he says from his point of view, it arose from beyond the houses along the beach. A Bing Maps view of Beach Lane Bridge shows the bridge to be north of a small house-lined beach, separated by the main part of Long Island by a small inlet. If he was on the bridge, he was north of the houses, and a missile launched on the other side of the houses would have certainly been on the water.
Bing Maps view: http://www.bing.com/mapspreview?&cp=40.799705~-72.628933&lvl=16&style=h&v=2&sV=1&form=S00027