NTSB investigations, 2015, CA
8 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 10 |
| 2010 | 11 |
| 2011 | 5 |
| 2012 | 5 |
| 2013 | 7 |
| 2014 | 7 |
| 2015 | 8 |
| 2016 | 10 |
| 2017 | 14 |
| 2018 | 12 |
| 2019 | 7 |
| 2020 | 5 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 5 |
| 2025 | 4 |
| 2026 | 6 |
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\") = 2015
AND c.\"eventStateOrRegion\" = 'CA' 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" = 'CA' 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 GAA16CA089Accident · No injuriesData collectionFinal reportWaco YMF · Fullerton, CAThe pilot's failure to maintain directional control during the landing roll.NTSB GAA16CA074Accident · No injuriesData collectionFinal reportCessna 177 · Palm Springs, CAThe failure of a shaft seal at the nose gear retraction/extension actuator, which resulted in a loss of hydraulic fluid and a main landing gear collapse during landing.NTSB WPR16IA025Incident · No injuriesIncident investigationFinal reportCirrus Design SR22T · Paso Robles, CAThe failure of the nose landing gear due to unanticipated fatigue loads.NTSB WPR15LA184Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Sacramento, CAA manufacturing defect that resulted in fatigue failure of the left main landing gear trunnion.NTSB GAA15LA092Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Fresno, CAThe failure of the nose landing gear (NLG) leg due to fatigue fractures, which resulted in the NLG collapsing during landing.NTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB WPR15IA105Incident · No injuriesIncident investigationFinal reportEvo13 Lancair Evolution · San Carlos, CAThe collapse of the nose landing gear (NLG) due to the separation of the right trunnion pin from the NLG strut as a result of reverse-bending fatigue.NTSB WPR15LA113Accident · No injuriesLimited investigationFinal reportMooney M20E - NO Series · Bakersfield, CAThe collapse of all three landing gear during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.