NTSB investigations, 2018, TX
12 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\") = 2018
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") = 2018 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 GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.NTSB ERA18LA270Accident · No injuriesLimited investigationFinal reportMaule M7 · Floresville, TXThe separation of the left inboard main landing gear (MLG) attachment bolt due to insufficient torque, which resulted in the collapse of the left MLG.NTSB GAA18CA551Accident · No injuriesData collectionFinal reportPiper PA28 · Cypress, TXThe student pilot’s improper approach path after the airplane encountered turbulence, which resulted in the airplane landing hard short of the runway.NTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18LA271Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Lexington, TXThe fatigue failure of the main landing gear (MLG) truss, which resulted in the MLG spreading apart.NTSB GAA18CA390Accident · No injuriesData collectionFinal reportCessna 421 · Clifton, TXThe pilot's improper landing flare in crosswind conditions, which resulted in a hard landing.NTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.NTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.NTSB GAA18CA347Accident · No injuriesData collectionFinal reportPiper PA28 · Pine Spring, TXThe pilot’s failure to maintain adequate altitude while flying over mountainous terrain in turbulent wind conditions at night, which resulted in a tree strike.NTSB CEN18LA152Accident · No injuriesLimited investigationFinal reportGrumman G 164A · Garwood, TXA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA18CA205Accident · No injuriesData collectionFinal reportLuscombe 8 · Vernon, TXThe pilot’s failure to maintain directional control during landingNTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.