NTSB investigations, NY
73 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 1 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 8 |
| 2002 | 3 |
| 2003 | 3 |
| 2005 | 2 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC05CA135Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Hancock, NYThe pilot's inadequate compensation for wind conditions, which resulted in the airplane impacting the ground. A factor in the accident was the downdraft wind condition, as reported by the pilot.NTSB NYC05FA075Accident · 2 fatalField investigationFinal reportCessna 172R · Armonk, NYThe flight instructor's failure to maintain the proper altitude\clearance during the approach, which resulted in an in-flight collision with trees. Factors in this accident were low ceilings, fog, and gusty wind conditions.NTSB NYC04LA021Accident · 2 fatalLimited investigationFinal reportFleet 16B · Fishers Island, NYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in a collision with water.NTSB NYC04CA009Accident · No injuriesData collectionFinal reportCessna 182C · Clarence Center, NYThe pilot's delayed go-around decision. A factor in this accident was the night light condition.NTSB NYC03LA093Accident · No injuriesLimited investigationFinal reportCessna R182 · Monticello, NYThe pilot's premature raising of the flaps during the aborted landing. A factor in this accident was the crosswind condition.NTSB IAD03LA012Accident · 1 fatalLimited investigationFinal reportWestland Helicopters Gazelle AH-MK1 · East Hampton, NYThe pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with water. Factors included the pilot's decision to fly over water on a moonless night, his lack of experience in that environment, and the dark night lighting…NTSB NYC02LA086Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe flight instructors failure to maintain aircraft control during a wind gust. A factor in the accident was a sudden gust of wind.NTSB NYC02FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Gardiner, NYThe pilot-in-command's failure to maintain sufficient altitude while maneuvering in a mountainous area, which resulted in a collision with terrain. Factors in the accident were, mountainous terrain, clouds, and the pilot's decision to continue the flight in…NTSB NYC02LA024Accident · No injuriesLimited investigationFinal reportCessna 172D · Argyle, NYThe pilot's failure to maintain aircraft control while maneuvering.NTSB NYC01LA210Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Brockport, NYThe pilot's delayed go-around during the landing attempt. Factors included the dark night conditions and the pilot's inadequate preflight decision to fly to an airport with inoperative surface lighting.NTSB NYC01LA209Accident · 2 fatalLimited investigationFinal reportDominiak Kitfox · Byron, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the physiological impairment of the pilot due to the consumption of alcohol.NTSB NYC01FA178Accident · 3 fatalField investigationFinal reportBeech 58-TC · Sidney, NYThe pilot's failure to follow IFR procedures which resulted in a collision with rising terrain. Factors related to the accident were the rising terrain and fog.NTSB NYC01LA148Accident · 1 fatalLimited investigationFinal reportCessna 182P · Oswego, NYThe pilot's inadequate altitude clearance above water while conducting low level flight maneuvers. A factor related to the accident was the pilot's impairment of judgment due to alcohol consumption.NTSB NYC01LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ithaca, NYThe pilot's failure to follow the published instrument approach procedure.NTSB NYC01LA108Accident · 1 fatalLimited investigationFinal reportBensen Gyroplane · Watertown, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in rotary wing aircraft.NTSB NYC01LA065Accident · No injuriesLimited investigationFinal reportCessna 182P · Angola, NYThe pilot's misjudged clearance over an obstacle.NTSB NYC00LA215Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Taberg, NYThe pilot's improper decision to attempt a second takeoff from the short grass runway at maximum gross weight, which resulted in the inadvertent stall/mush. Factors in this accident were the airplane's high gross weight and the short grass surface runway.NTSB NYC99FA100Accident · 1 fatalField investigationFinal reportStock S-1S · Westtown, NYThe pilot's inability to recover from an intentional stall spin maneuver. A factor in the accident was the change in the airplane's center of gravity which made the airplane more difficult to recover from a spin.NTSB IAD97LA108Accident · 1 fatalLimited investigationFinal reportRiekkenen Ryelong LE · Wurtsboro, NYThe pilot performed an aerobatic maneuver and misjudged the altitude.NTSB NYC97FA030Accident · 3 fatalField investigationFinal reportCessna 425 · Bohemia, NYthe pilot's early descent to decision height and his failure to perform the missed approach procedure. A factor was the failure of air traffic control to issue a safety advisory.NTSB IAD97FA032Accident · 3 fatalField investigationFinal reportMbb BO-105CBS · Penn Yan, NYthe pilot's failure to maintain altitude/clearance from the terrain. Factors relating to the accident were: the pilot's diverted attention to the GPS, darkness, low ceiling, rising terrain, and high wind condition.NTSB NYC96LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Shirley, NYthe pilot's prematurely retraction of flaps during the go-around, which resulted in settling (mushing) of the airplane and a collision with the ground.NTSB IAD96LA129Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Adirondack, NYthe pilot's improper in-flight planning/decision, which resulted in his failure to ensure that he could maintain sufficient altitude and clearance from mountainous terrain after entering a blind canyon. Haze and the terrain were related factors.NTSB NYC96FA126Accident · 3 fatalField investigationFinal reportPiper PA-23-150 · Cortland, NYthe pilot failure to maintain directional control of the airplane which resulted in the airplane striking trees. Contributing factors were the pilot's spatial disorientation, dark night conditions, fog, and the pilot's self induced pressure to reach the…NTSB NYC96FA002Accident · 2 fatalField investigationFinal reportCessna 172N · Caton, NYThe pilot's improper IFR procedure by failing to maintain proper altitude, while on the initial approach for an ILS. A factor relating to the accident was: failure of the tower controller to issue a safety advisory.NTSB NYC95LA209Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Frankfort, NYInflight collision with the ground for undetermined reasons.NTSB BFO95LA062Accident · 1 fatalLimited investigationFinal reportBerg Steen Skybolt · Bath, NYthe pilot's failure to maintain sufficient altitude/clearance to avoid trees while performing aerobatic maneuvers. Related factors are the low altitude at which the maneuver was initiated and the delayed recovery/pull-up.NTSB NYC94LA049Accident · 3 fatalLimited investigationFinal reportMooney M20J · Jones Beach, NYwas the pilot's failure to maintain control of the airplane, resulting in the airplane impacting with the water. Also casual in this accident was the pilot's total lack of experience in this type of aircraft, and operations. A factor in this accident was the…NTSB NYC93LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Quaker Street, NYThe failure of the pilot to determine runway conditions prior to landing which resulted in the airplane being damaged upon touchdown on the snow covered runway.NTSB BFO92LA155Accident · No injuriesLimited investigationFinal reportTroy Bellah Rotorway Executive · Endicott, NYThe pilot did not attain the proper touchdown point.NTSB BFO92LA072Accident · 1 fatalLimited investigationFinal reportPiper J3C · Camillus, NYThe pilot's failure to properly judge the ground clearance required to perform an aerobatic manuever.NTSB NYC92FA062Accident · 1 fatalField investigationFinal reportCessna 150 · White Lake, NYThe pilot's improper decision to fly into known adverse weather conditions, his failure to maintain control of the airplane, and his impairment of judgement due to drugs. Factors which contributed to the accident were: the dark night, the adverse weather…NTSB DCA92MA016Accident · 2 fatalMajor investigationFinal reportBeech 1900C · Gabriels, NYFailure of the captain to establish a stabilized approach, his inadequate cross-check of instruments, his descent below specified minimum altitude at the final approach fix, and failure of the copilot to monitor the approach. Factors related to the accident…NTSB NYC91FA196Accident · 2 fatalField investigationFinal reportCessna 152 · New Paltz, NYFailure of the instructor pilot (CFI) to assure that the proper altitude was maintained. A factor related to the accident was: the cfi's lack of experience in the type of operation.NTSB NYC91LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rhinebeck, NYThe pilot did not calculated the airplane's performance data to insure that he had enough runway to clear an obstacle at the end of the field, which resulted in the airplane's landing gear striking high hedges, subsequently the pilot elected to land in a…NTSB NYC91LA152Accident · Serious injuriesLimited investigationFinal reportGlasflugel Libelle 201B · Saratoga, NYThe failure of the pilot to adequately flare when making an uphill landing. Factors related to the accident were the pilot continued attempts at finding lift which reduced his landing options when he decided to land.NTSB NYC90FA192Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Saltaire, NYThe pilot misjudged his altitude.NTSB NYC90GA105Accident · 4 fatalFinal reportBellanca 17-31A · Davis Park, NYThe airplane impacting the water at a high speed for unknown reason(s).NTSB NYC90FA039Accident · 6 fatalField investigationFinal reportPiper PA-31-350 · Cairo Township, NYThe pilot's decision to fly into the known adverse weather and his failure to select an altitude that would provide terrain clearance. Factors were: the adverse weather and the pilot's disregard for the forecasted conditions.NTSB NYC89FA089Accident · Minor injuriesField investigationFinal reportAerospatiale AS-350D · Spring Valley, NYFailure of the FAA flight examiner (f/e) to follow proper procedures concerning the autorotation, and improper remedial action by the pilot-in-command (PIC). Factors related to the accident were: lack of information in the flight manual concerning…NTSB NYC88LA250Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Sodus Bay, NYWhile on a low level pleasure flt over water the plt failed to maintain adequate terrain clearance and the left wing contacted the water. The acft crashed into the water and remained upright. The plt and pax exited the acft and were picked up by a passing…NTSB NYC88LA247Accident · Minor injuriesLimited investigationFinal reportCessna 172P · New York, NYWhile on a night personal pleasure flt along the hudson river between New York and new jersey, at 300 feet AGL, the plt turned the acft toward an unlighted shore area and lost visual cues. The plt inadvertently flew the acft into the water. The acft sunk and…NTSB NYC88LA241Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Millbrook, NYThe private plt-in-command was seated in the right seat and his commercial plt-pax was seated in the left seat. The plt in command was at the controls. The acft was on final apch. The plt said the wind was from 170 deg. He did not give the wind velocity. He…NTSB NYC88FA248Accident · 2 fatalField investigationFinal reportPiper PA-39-30 · Margaretville, NYThe acft departed block island, RI en route to stewart international airport, newburgh, new york, the aircraft never arrived and was reported missing August 2, 1988. The aircraft was missing until November 21, 1988 when it was found near Margaretville, NY by…NTSB NYC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172H · Oneonta, NYThe plt rprtd he started to depart from rwy 13 with the wind from the south at 15 gusting 25 KTS. He stated the acft was not climbing as expected so he elected to land on the remaining rwy. He stated the wind gusts were strong from the right rear. He said he…NTSB NYC87LA193Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Sandy Creek, NYThe pilot of the PA-23-250 attempted a takeoff on a 2200 ft long private airstrip with a grass runway. Witnesses reported the aircraft was airborne further down the runway than normal. The aircraft did not clear the trees on the departure end of the runway.…NTSB NYC87FA192Accident · 4 fatalField investigationFinal reportCessna 182P · Ellenville, NYThe acft collided with rising terrain in a mountainous area of minnewaska state park while climbing to cruise on a VFR flight. The crash site was about 1,430 feet higher in elevation than the departure airport. The weather at the departure airport was 1000…NTSB NYC87FA188Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Tannersville, NYWhile on a VFR air taxi cargo flight, the aircraft collided with trees on the east side of high peak mountain, elevation 3,655 feet. The accident site elevation was 3080 feet. A witness said it was heavy overcast, not raining and the clouds were not below the…NTSB NYC87LA104Accident · No injuriesLimited investigationFinal reportSwearingen SA-226AT · Jamaica, NYThe flight landed at kennedy international airport with the landing gears retracted due to a failure of the right main landing gear extension system.NTSB NYC87FA138Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Lanesville, NYThe plt and his family dptd 2/8/87 on a ski trip to VT. The flt did not arrive. The acft was fnd on a mtn plateau on 5/2/87. Wx conditions rptdly deteriorated and darkness was apching at the estimated time of the acdt, shortly after sunset. The acft impacted…