NTSB investigations, 2018, CA
12 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\") = 2018
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") = 2018 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 GAA19CA073Accident · No injuriesData collectionFinal reportBeech C23 · Porterville, CAThe pilot's improper landing flare, which resulted in an abnormal landing and subsequent porpoise.NTSB GAA18CA555Accident · No injuriesData collectionFinal reportHimmeroeder Hansgeorg Bearhawk · Williams, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA474Accident · No injuriesData collectionFinal reportDiamond DA20 · Van Nuys, CAThe student pilot's failure to maintain directional control during landing in a left quartering headwind, which resulted in a ground loop.NTSB GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.NTSB ANC18LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Ramona, CAThe failure of the engine-driven hydraulic pump due to the installation of improper cap screws, which resulted in a gap in the pump housing, a subsequent hydraulic leak, and the landing gear collapsing.NTSB WPR18CA146Accident · No injuriesData collectionFinal reportAyres S2R G10 · Marysville, CAThe pilot’s failure to maintain clearance from a truck while on final approach after the airplane encountered a downdraft, which resulted in the subsequent failure of the right main landing gear and loss of directional control.NTSB WPR18LA153Accident · No injuriesLimited investigationFinal reportPiper PA24 · San Jose, CAA landing gear retraction during the landing rollout for reasons that could not be determined based on the available evidence.NTSB WPR18LA129Accident · No injuriesClass 3 · LimitedFinal reportGulfstream AM Corp Comm Div 695A · Bishop, CAThe failure of the left main landing gear upper arm forging due to fatigue cracking and subsequent overstress, which resulted in the collapse of the landing gear during the landing roll.NTSB GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.NTSB GAA18CA190Accident · No injuriesData collectionFinal reportCessna 180 · Salina, CAThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA169Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Mammoth Lakes, CAThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind conditions, which exceeded the airplane’s maximum demonstrated crosswind and resulted in the collapse of the left main landing gear.NTSB GAA18CA103Accident · Minor injuriesData collectionFinal reportHarrop Blake RV 7 · Death Valley National Park, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.