NTSB investigations, 2009, TX
10 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 10 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 10 |
| 2017 | 7 |
| 2018 | 7 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 6 |
| 2025 | 7 |
| 2026 | 5 |
Where
Latest 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.\"eventStateOrRegion\" = 'TX' 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\" = '090' 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."eventStateOrRegion" = 'TX' 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" = '090' 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 CEN10CA075Accident · No injuriesData collectionFinal reportCessna 172 · Pearland, TXThe student pilot's failure to control the airplane's descent rate during the short-field landing, resulting in a hard landing. Contributing to the accident was the flight examiner's delayed response.NTSB CEN09CA604Accident · No injuriesData collectionFinal reportBell 407 · Fort Worth, TXFailure of the pilot to maintain control during landing.NTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.NTSB CEN09CA495Accident · No injuriesData collectionFinal reportCessna 172S · New Braunfels, TXThe student pilot's improper flare resulting in a bounced landing.NTSB CEN09CA521Accident · No injuriesData collectionFinal reportMaule M-4-220C · Abernathy, TXThe failure of the fuselage's tube structure due to corrosion during a hard landing.NTSB CEN09CA458Accident · No injuriesData collectionFinal reportCessna 172M · New Braunfels, TXThe pilot's inadequate recovery from a bounced landing.NTSB CEN09CA394Accident · Minor injuriesData collectionFinal reportSidler Mike Rotorway · Waxahachie, TXThe pilot’s failure to control his rate of descent during autorotation, which required an aggressive recovery maneuver and resulted in a sudden loss of tail rotor effectiveness.NTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.NTSB CEN09CA336Accident · No injuriesData collectionFinal reportBeech F33A · Midland, TXThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the inadequate oversight of the flight by the instructor pilot.NTSB CEN09CA304Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · San Antonio, TXThe instructor pilot’s improper landing flare.