NTSB investigations, 2016, TX
17 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\") = 2016
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") = 2016 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 ENG17IA005Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ170 200LR · San Antonio, TXA failure of the nose landing gear down lock spring which precluded normal downlock operation of the nose landing gear. The spring failure was due to the presence of too much retained austenite which led to the formation of progressive cracking and subsequent…NTSB CEN17LA036Accident · Minor injuriesLimited investigationFinal reportStinson L 5 · San Marcos, TXThe pilot’s improper fuel management before landing, which resulted in fuel starvation and the subsequent total loss of engine power during a subsequent go-around when the fuel became unported during the climbing turn.NTSB CEN17LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Pflugerville, TXLanding gear collapse upon landing due to a hydraulic leak that led to insufficient pressure to fully extend and lock the gear in a down position.NTSB CEN17LA015Accident · No injuriesLimited investigationFinal reportMilholland Kelly D · Livingston, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA467Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Atlanta, TXThe pilot's failure to attain the proper touchdown point on a grass airstrip and the airplane's subsequent collision with trees during an attempted aborted landing.NTSB CEN16LA356Accident · No injuriesLimited investigationFinal reportCessna P210N · Waco, TXThe failure of the right main landing gear (MLG) down-lock mechanism, which resulted in the collapse of the landing gear. The root cause of the right MLG down-lock mechanism could not be determined because the components were not available for examination.NTSB GAA16CA398Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper approach descent rate and landing flare attitude, which resulted in a hard landing and collapse of the nose landing gear.NTSB GAA16CA359Accident · No injuriesData collectionFinal reportPiper PA28 · Amarillo, TXThe pilot's failure to attain an adequate rate of climb, which resulted in off airport landing and substantial damage to the fuselage and right wing.NTSB CEN16LA249Accident · No injuriesLimited investigationFinal reportAero Commander 100 180 · Port Lavaca, TXLoss of engine power due to failure of a connecting rod.NTSB CEN16LA219Accident · No injuriesLimited investigationFinal reportFlohr David J R 80 Tiger Moth · Decatur, TXA failure of the electric fuel boost pump, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB GAA16CA269Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Midland, TXThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a ground-loop, main landing gear collapse and collision with terrain.NTSB GAA16CA223Accident · No injuriesData collectionFinal reportCessna T206 · Jasper, TXThe pilot's failure to maintain pitch control during the landing flare, which resulted in abnormal runway contact, a nose wheel landing gear collapse, and runway excursion.NTSB GAA16CA225Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Harlingen, TXThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop and substantial damage to the right wing.NTSB CEN16LA153Accident · No injuriesLimited investigationFinal reportGill Craig Lancair IV P Propjet · Addison, TXCollapse of the nose landing gear during landing for reasons that could not be determined, because postaccident examination did not detect any anomalies consistent with a preimpact failure or malfunction.NTSB GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB GAA16CA103Accident · No injuriesData collectionFinal reportAviat A-1C · Breckenridge, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.