NTSB investigations, NY
8 cases where the sequence of events included Landing area undershoot.
Cases per year
| 2008 | 2 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2021 | 1 |
| 2025 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '370' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '370' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA25LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · White Plains, NYThe pilot’s failure to maintain proper glidepath during a night visual approach, which resulted in a collision with the runway lighting system. Contributing to the outcome was the pilot’s momentary disorientation due to glare from the runway approach lighting…NTSB ERA21LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Warwick, NYThe pilot’s failure to attain a proper touchdown point, which resulted in the airplane contacting the ground short of the runway.NTSB GAA16CA124Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe pilot's failure to maintain adequate terrain clearance while landing, which resulted in a collision with a snow berm, nose gear collapse, and postimpact fire.NTSB GAA15CA069Accident · No injuriesData collectionFinal reportBuhlmann Howard HB-1 · Canandaigua, NYThe pilot's failure to land beyond the marked runway threshold, which resulted in a collision with a culvert and a loss of control on the ground.NTSB ERA12CA311Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Eaton, NYThe pilot's improper approach to landing, which resulted in the airplane touching down short of the runway.NTSB ERA11CA294Accident · Minor injuriesData collectionFinal reportPiper PA-23-250 · Clayton, NYThe pilot's failure to obtain a proper touchdown point while landing with a gusting tailwind.NTSB MIA08CA136Accident · No injuriesData collectionFinal reportSchleicher ASK-21 · Elmira, NYThe glider pilot's misjudged distance/altitude while soaring.NTSB NYC08LA168Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Dansville, NYThe pilot's failure to attain the proper glide path and the flight instructor's delayed remedial action. Contributing to the accident was the encountered headwind.