NTSB investigations, 2023
4 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\") = 2023
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") = 2023 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 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 ERA23LA284Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Macclenny, FLThe improper maintenance of the landing gear dampers and main rotor elastomeric dampers, resulting in ground resonance during an unsuccessful takeoff attempt with the helicopter near its maximum gross weight for the density altitude.NTSB CEN23LA227Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Twinstar · Starbuck, MNThe pilot’s improper landing flare and hard landing, which resulted in the left axle fracturing from bending overstress.NTSB CEN23LA217Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Pellston, MIThe failure of the left main landing gear strut and clevises due to fatigue cracks that initiated at multiple casting solidification voids.