NTSB investigations, NY
20 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1992 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 1 |
| 1999 | 3 |
| 2003 | 2 |
| 2004 | 2 |
| 2007 | 1 |
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\" = 320)
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" = 320) 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 NYC07CA069Accident · No injuriesData collectionFinal reportCessna 172 · Utica, NYThe pilot's failure to maintain directional control of the airplane, during an aborted takeoff, which resulted in a collision with a snowbank.NTSB NYC04CA096Accident · No injuriesData collectionFinal reportHughes 269B · Farmingdale, NYThe pilot's failure to maintain aircraft control while hover-taxiing. A factor in this accident was the high wind condition.NTSB NYC04CA080Accident · No injuriesData collectionFinal reportBellanca 7ECA · Hornell, NYAn inadvertent encounter with soft snow during takeoff.NTSB NYC03CA202Accident · Serious injuriesData collectionFinal reportCessna 182B · Spencerport, NYPilot's failure to perform a go-around.NTSB NYC03FA162Accident · 1 fatalField investigationFinal reportStart & Flug H101 · Rock Hill, NYThe pilot's selection of an unsuitable area for landing.NTSB IAD00LA001Accident · No injuriesLimited investigationFinal reportCessna 182S · Staatsburg, NYwas the pilot's encounter with an unseen embankment while maneuvering to avoid a deer on the runway.NTSB NYC99LA179Accident · No injuriesLimited investigationFinal reportAllen-Charles Barracuda · Hermon, NYThe pilot's inadequate preflight planning which resulted in a precautionary landing. A factor in this accident was the pilot's selection of unsuitable terrain for the precautionary landing.NTSB NYC99LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mattituck, NYThe pilot's failure to maintain control of the airplane, and the flight instructor's inadequate supervision of the solo flight.NTSB NYC97LA012Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Laurens, NYthe student pilot's selection of an unsuitable area for a precautionary landing. Factors relating to the accident were: the student becoming lost, the subsequent low fuel condition, and the embankment in the emergency landing area.NTSB NYC95LA199Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Mayville, NYthe pilot's improper flight control input during the landing roll in high grass, which resulted in a ground loop and subsequent wingtip damage.NTSB NYC95LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180C · Nunda, NYthe pilot-in-command's failure to assure that an adequate runway length was available.NTSB NYC94LA079Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Hempstead, NYThe inadvertent collision with a hidden obstruction after swerving to avoid birds during a water takeoff.NTSB NYC94LA070Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Albion, NYthe pilot's loss of directional control during the landing roll, and the subsequent collision with soft terrain and nose over. Factors related to the accident were: the snowbanks on either side of the runway, and the pilot's lack of recent flight experience.NTSB BFO92FA020Accident · Serious injuriesField investigationFinal reportDouglas DC-9-30 · Horseheads, NYThe aircraft encountered a sudden wind gust during landing flare, which resulted in a hard landing.NTSB DEN90LA046Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · New York, NYOverrotation of the aircraft during takeoff. Factors related to the accident were: the first officer's improper use of the flight manual, which resulted in his improper calculations of the rotation speed, and inadequate supervision concerning verification of…NTSB NYC90DFJ01Accident · No injuriesFinal reportSteele Acrosport II · Penn Yan, NYFailure of the pilot to maintain directional control during the takeoff ground run. His lack of experience & the snowbank were related factors.NTSB NYC88LA242Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Roscoe, NYThe plt said the eng lost power during takeoff past mid-field and he initiated an abort. The acft was unable to stop in the remaining rwy and collided with a dirt embankment past the end of the rwy. The owner of the acft is a student plt and was the passenger…NTSB NYC87LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Duanesburg, NYOn lndg the acft ran into a snowbank causing minor dmg to the acft. Aft determining it airworthy the plt elected to depart and ran into another snowbank on the takeoff. He stated that the accd occurred because of poor judgement to attempt a takeoff from an…NTSB NYC84LA284Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Fishers Island, NYThe certified flt instructor (CFI) stated that he was teaching his student autorotation's to touchdown. He continued to state that his student applied too much left pedal just prior to touchdown. This caused the helicopter to yaw to the left. The CFI stated…NTSB NYC83LA163Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Argyle, NYThe plt attempted to start the eng by hand propping for aprx 20 min. The eng finally started & continued to rev up. During this time, the passenger was in the rear seat. As the plt was returning to the cockpit, the acft began to roll forward. The plt was…