NTSB investigations, 2015, TX
5 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2008 | 11 |
|---|---|
| 2009 | 10 |
| 2010 | 11 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 6 |
| 2014 | 10 |
| 2015 | 5 |
| 2016 | 17 |
| 2017 | 7 |
| 2018 | 12 |
| 2019 | 6 |
| 2020 | 9 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 3 |
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\") = 2015
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\" = '094' 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") = 2015 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" = '094' 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 GAA16CA042Accident · No injuriesData collectionFinal reportCessna 421 · Amarillo, TXThe loss of directional control during taxi to the runway as a result of insufficient brake fluid level in the right brake master cylinder, resulting in a taxiway excursion and collision with a drainage culvert.NTSB GAA15CA104Accident · No injuriesData collectionFinal reportCessna 150F · Harlingen, TXThe student pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN15LA252Accident · No injuriesLimited investigationFinal reportMichael Wilson Murphy Spirit · Livingston, TXThe pilot’s failure to maintain adequate airspeed, which increased the induced drag and led to the engine having insufficient power to overcome the drag and climb the airplane and resulted in a forced landing and the subsequent collapse of the main landing…NTSB GAA15CA023Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Ropesville, TXThe pilot's failure to maintain directional control during landing.NTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.