NTSB investigations, 2016
5 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\") = 2016
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") = 2016 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 ANC16LA046Accident · No injuriesLimited investigationFinal reportCessna A185 · Illiamna, AKThe overstress fracture of the left main landing (MLG) gear axle attachment bolts and the subsequent separation of the left MLG wheel, which resulted in the pilot’s inability to control the airplane.NTSB ERA16LA260Accident · No injuriesLimited investigationFinal reportSorensen Danny Pitts S1 S · Somerville, TNThe failure of the left landing gear leg due to fatigue, which resulted in a ground loop during landing. Contributing to the accident was the airplane builder's installation of a custom-built landing gear rather than the landing gear included with the…NTSB WPR16LA117Accident · No injuriesLimited investigationFinal reportHowell Bob Howell Special · Minden, NVThe failure of the right main landing gear assembly due to overstress fracture.NTSB ANC16LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe overstress fracture and subsequent separation of the left main landing gear axle due to a hard landing, which resulted in the pilot’s inability to maintain directional control of the airplane.NTSB WPR16LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Independence, ORThe failure of the left main landing gear wheel axle due to a fatigue crack.