NTSB investigations, 2009
10 cases where the sequence of events included Landing area undershoot.
Cases per year
| 2008 | 16 |
|---|---|
| 2009 | 10 |
| 2010 | 17 |
| 2011 | 13 |
| 2012 | 11 |
| 2013 | 7 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 17 |
| 2017 | 17 |
| 2018 | 14 |
| 2019 | 8 |
| 2020 | 11 |
| 2021 | 6 |
| 2022 | 12 |
| 2023 | 9 |
| 2024 | 9 |
| 2025 | 15 |
| 2026 | 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 year(c.\"eventDate\") = 2009
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 year(c."eventDate") = 2009 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 WPR10CA084Accident · No injuriesData collectionFinal reportGolden Circle Tierra I · Jensen, UTA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB WPR10CA020Accident · Minor injuriesData collectionFinal reportMooney M20J · Hesperia, CAThe pilot's improper glide path and failure to maintain clearance from the airport perimeter fence during the landing approach.NTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.NTSB CEN09CA453Accident · No injuriesData collectionFinal reportPiper PA28 · Malvern, ARThe pilot's failure to maintain adequate airspeed during the approach to landing.NTSB ERA09CA387Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Winder, GAThe pilot's failure to obtain the proper touchdown point during a practice forced landing, and the flight instructor's delayed decision to initiate a go-around.NTSB CEN09CA351Accident · No injuriesData collectionFinal reportBell 206B · Justin, TXThe instructor pilot's failure to add sufficient power early enough to compensate for the strong gusting headwinds.NTSB ERA09CA274Accident · No injuriesData collectionFinal reportCessna 150K · Waycross, GAThe student pilot's failure to maintain aircraft control during approach in gusty conditions. Contributing to the accident was the student pilot's misunderstanding of the airspeed indicator.NTSB ERA09CA232Accident · Minor injuriesData collectionFinal reportCessna 177RG · Ocean Isle Beach, NCThe pilot's failure to divert to an alternate airport resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot's incorrect determination of the fuel load prior to the flight, the lack of placards near the…NTSB WPR09CA148Accident · No injuriesData collectionFinal reportEurocopter AS350BA · Long Beach, CAThe pilot's misjudged speed and altitude, which resulted in an undershoot of the landing zone.NTSB CEN09CA166Accident · No injuriesData collectionFinal reportPiper PA-28 · Terrell, TXThe commercial pilot's failure to maintain adequate airspeed during the approach which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of recent flight experience.