NTSB investigations, 2015
4 cases where NTSB found Manufacture/production.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 3 |
| 2010 | 11 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 3 |
| 2023 | 8 |
| 2024 | 6 |
| 2025 | 1 |
Where
Latest 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\") = 2015
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '040130'))
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") = 2015 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '040130')) 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 WPR15LA184Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Sacramento, CAA manufacturing defect that resulted in fatigue failure of the left main landing gear trunnion.NTSB CEN15LA238Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Omega, OKImproper base metal preparation or contamination of the No. 5 cylinder wall before it was coated, which resulted in the coating peeling off of the cylinder wall and contaminating the engine oil and the subsequent partial loss of engine power.NTSB WPR15LA109Accident · No injuriesLimited investigationFinal reportBell/Garlick UH 1H · Shelton, WAThe fatigue failure of the engine-to-transmission driveshaft adapter attachment bolt due to the application of inadequate torque on the bolt during assembly.NTSB CEN15FA126Accident · 2 fatalField investigationFinal reportEnstrom 280FX · Erie, COAn in-flight failure of the helicopter's #2 main rotor spindle due to undetected fatigue cracking, which resulted in an in-flight breakup. Contributing to failure were the nonconforming thread root radius of the spindle and the manufacturer's failure to…