NTSB investigations, 2013
7 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\") = 2013
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") = 2013 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 ERA14LA072Accident · No injuriesLimited investigationFinal reportCessna 182T · Burlington, NCA loss of airplane control during takeoff for reasons that could not be determined due to the postaccident condition of the elevator control system.NTSB ERA14CA025Accident · No injuriesData collectionFinal reportMooney M20TN · Tylertown, MSThe pilot's misjudgment of speed and distance on final approach resulting in touchdown prior to the runway, a runway excursion down the right side of the runway, and a collision with an embankment.NTSB CEN13CA569Accident · No injuriesData collectionFinal reportRans RV 12 · Hatley, WIThe pilot did not maintain control of the airplane while landing with a crosswind.NTSB WPR13CA418Accident · No injuriesData collectionFinal reportGrob G 103 Twin II · Morgan, UTAn incorrect descent rate while on final approach as a result of the flight instructor's delayed remedial action, which lead to an off-field landing and impact with terrain.NTSB WPR13CA401Accident · No injuriesData collectionFinal reportScheel Stanley K KITFOX-SERIES 7 · Cascade, IDThe pilot's failure to maintain a proper glide path, which resulted in a touchdown short of the runway.NTSB ERA13CA352Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Erwinna, PAThe student pilot's improper altitude and energy management in the landing pattern which resulted in the glider impacting a tree and landing short of the runway.NTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.