NTSB investigations, 2009, TX
10 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
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\" = '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") = 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" = '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 CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.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 CEN09CA457Accident · No injuriesData collectionFinal reportCessna 310 · Fort Worth, TXThe failure of the pivot pin in the side brace of the right main landing gear resulting in the gear collapse during taxi for undetermined reasons.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 CEN09CA315Accident · No injuriesData collectionFinal reportHolsclaw Francis E Starduster · Ranger, TXThe pilot's inability to maintain directional control due to the buckling of the right landing gear as a result of corrosion.NTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.NTSB CEN09CA268Accident · No injuriesData collectionFinal reportLuscombe 8 · Terrell, TXThe failure of the landing gear due to undetected corrosion.NTSB CEN09LA250Accident · Minor injuriesLimited investigationFinal reportJordan Don R Vans RV-6A · Arlington, TXA total loss of engine power due to the failure of both magnetos. Contributing to the accident was the lack of preventative maintenance/inspection of the magnetos.NTSB CEN09CA226Accident · No injuriesData collectionFinal reportCessna 172A · Corsicana, TXThe pilot's improper flare.NTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.