NTSB investigations, 2008, TX
8 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 11 |
| 2010 | 19 |
| 2011 | 12 |
| 2012 | 13 |
| 2013 | 9 |
| 2014 | 16 |
| 2015 | 14 |
| 2016 | 24 |
| 2017 | 10 |
| 2018 | 15 |
| 2019 | 13 |
| 2020 | 12 |
| 2021 | 13 |
| 2022 | 13 |
| 2023 | 21 |
| 2024 | 18 |
| 2025 | 10 |
| 2026 | 11 |
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\") = 2008
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\" = '300' 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") = 2008 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" = '300' 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 CEN09CA020Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lufkin, TXThe student pilot's improper decision to takeoff with a known brake problem. Contributing to the accident were the malfunctioning brake and the rough terrain in the excursion area.NTSB DFW08LA231Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Roanoke, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's lack of flight experience in the make and model of airplane.NTSB DFW08CA165Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Taylor, TXThe student pilot's improper flare during landing. Contributing to the accident was the gusty winds.NTSB DFW08CA107Accident · Minor injuriesData collectionFinal reportTecnam P2002 Sierra · La Porte, TXThe student pilot's improper recovery from the bounced landing and the instructor's delayed remedial action.NTSB DFW08CA102Accident · No injuriesData collectionFinal reportNorth American T-6G · Dallas, TXThe pilot's failure to maintain directional control while landing.NTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.NTSB DFW08CA072Accident · No injuriesData collectionFinal reportBeech 58P · Hereford, TXThe pilot's loss of control on landing. A factor was a gusting crosswind component.NTSB DFW08CA054Accident · No injuriesData collectionFinal reportMicco MAC-145B · Arcola, TXThe pilot's failure to maintain directional control. A contributing factor was the prevailing crosswind.