NTSB investigations, 2008
11 cases where NTSB found Main gear strut/axle/truck.
Cases per year
| 2008 | 11 |
|---|---|
| 2009 | 8 |
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 8 |
| 2013 | 2 |
| 2014 | 5 |
| 2015 | 2 |
| 2016 | 5 |
| 2017 | 4 |
| 2018 | 7 |
| 2019 | 5 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 4 |
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\") = 2008
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 year(c."eventDate") = 2008 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 CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…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.NTSB MIA08LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksdale, MSThe mechanic’s failure to torque check the axle-to-spring gear attachment bolts per the manufacturer's Annual/100-Hour Airframe Inspection Checklist, resulting in fatigue failure of the bolts.NTSB DFW08CA172Accident · No injuriesData collectionFinal reportTaylorcraft DCO-65 · Somerset, TXThe right main landing gear strut failure due to metal fatigue.NTSB DFW08TA128Accident · No injuriesFinal reportBeech C90 · Baton Rouge, LAStructural failure of the right main landing gear torque knee. A contributing factor was the failure to inspect the torque knee at the designated interval.NTSB DFW08LA115Accident · No injuriesLimited investigationFinal reportCessna 421C · Sterling, COFailure and separation of the upper and lower right main gear torque links links, which resulted in a loss of directional control on landing roll-out.NTSB CHI08LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Romeo, MIThe misjudged landing flare by the pilot, and the inadequate landing gear inspection/repair procedure used by other maintenance personnel, resulting in the failure of the main landing gear strut during landing.NTSB ANC08LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKA loss of control during the landing roll due to a failure or malfunction of the brake system, resulting in a loss of control, and structural damage to the airplane.NTSB DEN08LA064Accident · No injuriesLimited investigationFinal reportSpartan 7W · Santa Fe, NMFatigue failure of the right main landing gear, rendering directional control impossible and causing an overload failure of the left main landing gear.NTSB SEA08LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Moab, UTThe pilot's failure to maintain directional control of the tail wheel-equipped airplane during the flare/touchdown phase of a three-point landing.NTSB LAX08LA060Accident · No injuriesLimited investigationFinal reportCessna 305-A · Mokuleia, HIThe failure of the left main landing gear strut due to fatigue. Contributing to the failure was the side load placed on the landing gear while making a crosswind landing.