NTSB investigations, 2016
17 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\") = 2016
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") = 2016 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 GAA17LA090Accident · No injuriesLimited investigationFinal reportPiper PA28R · Watertown, WIThe pilot’s failure to attain a proper glidepath on approach for landing, which resulted in impact with trees. Contributing to the accident was a partial, temporary loss of engine power for reasons that could not be determined because postaccident examination…NTSB GAA16CA520Accident · No injuriesData collectionFinal reportCessna 182 · Lakeport, CAThe pilot's delayed action to add power during the approach, which resulted in an impact with terrain prior to the approach end of the runway.NTSB GAA16CA490Accident · No injuriesData collectionFinal reportPiper PA 28 · Parkersburg, WVThe flight instructor’s delayed remedial action during the approach for landing, which resulted in impact with terrain short of the runway threshold. Contributing to the accident was the student pilot’s failure to maintain an appropriate descent rate during…NTSB CEN16LA350Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Upham, NDThe pilot's failure to obtain a proper aimpoint during landing due to reduced visibility from the setting sun.NTSB GAA16CA439Accident · No injuriesData collectionFinal reportBell 206 L4 · Broussard, LAThe pilot's failure to attain a proper touchdown point, which resulted in the helicopter sliding off the aft end of the transport dolly.NTSB CEN16CA317Accident · No injuriesData collectionFinal reportErcoupe 415 · Eminence, INThe pilot's failure to maintain a proper glide path during the landing approach and his failure to use available engine power to arrest the descent, resulting in an undershoot and collision with terrain.NTSB GAA16CA471Accident · No injuriesData collectionFinal reportPiper PA24 · Hillsboro, OHThe pilot's descent below the intended glidepath during the approach, which resulted in an impact with a ditch prior to the runway.NTSB ANC16CA055Accident · No injuriesData collectionFinal reportKirbybilt Xcalibur · Valdez, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the airstrip, a landing gear collapse, and subsequent substantial damage to the fuselage.NTSB GAA16CA377Accident · No injuriesData collectionFinal reportPiper PA 44 · Keene, NHThe flight instructor’s failure to use carburetor heat during the approach while operating in atmospheric conditions that were conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing.NTSB CEN16LA246Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonder Lake, ILThe flight instructor's inadequate supervision and lack of remedial action due to his diverted attention to a radio call, which resulted in the airplane landing short of the runway.NTSB ANC16CA040Accident · No injuriesData collectionFinal reportCessna 180 · Nome, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and impacting a barricade. Contributing to the accident was the airport manager's improper placement and marking of a metal…NTSB GAA16CA327Accident · No injuriesData collectionFinal reportCessna R172 · Craig, COThe student pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and the nose wheel impacting the runway edge and substantial damage to the firewall.NTSB GAA16CA326Accident · No injuriesData collectionFinal reportSchweizer G 164 · Cummings, NDThe pilot's failure to maintain an adequate rate of descent while landing, which resulted in a hard landing, short of the runway.NTSB GAA16CA278Accident · No injuriesData collectionFinal reportPiper PA24 · Wadsworth, OHThe pilot's inadvertent power reduction during landing, which resulted in a runway undershoot, collision with the runway threshold, nose and right main landing gear collapse, and runway excursion.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 GAA16CA122Accident · No injuriesData collectionFinal reportCessna 175 · Gold Beach, ORThe pilot's failure to maintain an approach angle of descent to avoid obstacles, resulting in the airplane striking the airport perimeter fence.NTSB WPR16LA049Accident · No injuriesLimited investigationFinal reportKai Engstad RV-8A · Salem, ORA total loss of engine power for undetermined reasons, because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation.