NTSB investigations, CA
12 cases where NTSB found Main gear strut/axle/truck.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2018 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01023213'))
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01023213')) 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 WPR25LA300Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Firebaugh, CAA loss of directional control during landing due to the partial separation of the right main landing gear oleo strut from a failed weld.NTSB WPR23LA270Accident · No injuriesClass 3 · LimitedFinal reportSling Sling LSA · Palm Springs, CAFailure of the landing gear strut during takeoff due to a preexisting cracks that were caused by a manufacturing anomaly during the composite fiber layup process.NTSB WPR22LA159Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Long Beach, CAThe failure of the right main landing gear brace rib for reasons that could not be determined based on available information.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 WPR16LA018Accident · No injuriesLimited investigationFinal reportCessna 120 · Lone Pine, CAThe fracture of the left main landing gear (MLG) wheel axle due to fatigue, which resulted in the separation of the left MLG wheel during takeoff from a dirt airstrip.NTSB WPR15LA184Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Sacramento, CAA manufacturing defect that resulted in fatigue failure of the left main landing gear trunnion.NTSB WPR14LA253Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Santa Monica, CAThe fracture of the right aft landing gear strut due to undetected fatigue cracking in an inboard rivet hole.NTSB WPR14LA130Accident · No injuriesLimited investigationFinal reportGrumman G164 - A · Caruthers, CAAn undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…NTSB WPR11LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAFatigue cracking of the upper torque-link attach lugs on the left main landing gear strut, which resulted in separation of the left main landing gear during taxi.NTSB ENG09IA014Incident · No injuriesIncident investigationFinal reportBoeing 737 · Los Angeles, CAThe failure of the right main landing gear inboard axle due to fatigue cracking as a result of fretting damage in one of the brake mounting bolt holes.NTSB WPR09CA429Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR · San Diego, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB SEA08CA202Accident · No injuriesData collectionFinal reportMooney M20K · Trinity Center, CAThe complete loss of engine power due to fuel exhaustion as a result of a leak in the fuel system. Contributing to the accident was the rough terrain the airplane encountered during the forced landing.