Here's an audio slideshow from the Times, narrated by a Coast Guard petty officer, describing the lighthouses of New York. Particular mention is made of Stepping Stones off City Island and Execution Rocks off Sands Point.
Here's the link to the NY Times