NTSB investigations
16 cases where NTSB found Gear attach fittings (on fus).
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 1 |
| 2012 | 3 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2023 | 1 |
| 2025 | 2 |
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01035343')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01035343')) 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 ERA25LA337Accident · No injuriesClass 4 · LimitedFinal reportLarocca Roch B Eracer MK II · Mount Pleasant, SCThe failure of the nose gear actuator bolt during the landing roll, which resulted in the collapse of the nose landing gear and subsequent runway excursion.NTSB ANC25LA096Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Haines, AKThe pilot’s selection of an unsuitable landing area resulting in an on-ground collision with an obscured log and a main landing gear separation.NTSB DCA23LA409AccidentClass 4 · LimitedFinal reportBoeing 767-322 · Chantilly, VAImproper overhaul of the trunnion cross-pin hole that resulted in the development of stress corrosion cracking and eventual failure of the right forward trunnion.NTSB WPR21LA037Accident · No injuriesClass 3 · LimitedFinal reportRemos Aircraft Gmbh Flugzeugbau GX · Glendale, AZThe material overstress failure of the airframe’s aluminum carry-through of the main landing gear.NTSB ANC20LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · King Salmon, AKThe fatigue fracture failure of the left main landing gear U-bolt during landing, which resulted in the collapse and separation of the left main landing gear spring.NTSB ANC19LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Talkeetna, AKA fracture of the right outboard landing gear bracket for undetermined reasons.NTSB ANC19LA024Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC · Nome Creek, AKThe failure of the airplane's structural tubing due to corrosion, which resulted in a tailwheel separation and a subsequent loss of control. Also causal was the mechanic's failure to perform a detailed inspection of the aft fuselage during the most recent…NTSB WPR19LA020Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Burns, ORThe failure of the left main landing gear due to fatigue cracking of a bolt that initiated at a corrosion pit, which formed in the absence of a required protective cadmium coating.NTSB ERA17LA253Accident · No injuriesLimited investigationFinal reportWaco UPF 7 · Brunswick, GAThe failure of the right main landing gear strut brace for reasons that could not be determined based on the available evidence.NTSB GAA16CA374Accident · Minor injuriesData collectionFinal reportCessna 150 · Cleveland, GAFailure of the left main landing gear attachment during the landing roll, which resulted in a left landing gear collapse, and damage to the left wing and aileron.NTSB WPR13LA063Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Billings, MTThe pilot’s inability to maintain directional control during the landing roll because of the failure of the tailwheel support bracket.NTSB CEN13LA071Accident · Minor injuriesLimited investigationFinal reportScott Ironsides · East Troy, WIFailure of the steel weld fittings on the right main landing gear.NTSB ERA13CA044Accident · No injuriesData collectionFinal reportCessna 172R · Miami, FLThe flight instructor's improper power management during a steep, obstacle-clearance approach, which resulted in a hard landing.NTSB CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.NTSB WPR10LA060Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Heli 369E · Kahuku, HIThe fatigue failure of the landing gear strut and maintenance personnel’s failure to perform an adequate inspection of the landing gear.NTSB ANC09CA033Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the main landing gear collapsing during taxi.