NTSB investigations, 2014
4 cases where NTSB found Design.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 9 |
| 2010 | 4 |
| 2011 | 9 |
| 2012 | 7 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 5 |
| 2017 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 3 |
| 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\") = 2014
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '040110'))
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") = 2014 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '040110')) 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 DCA15MA019Accident · 1 fatalClass 1 · MajorFinal reportScaled Composites 339 · Koehn Dry Lake, CAScaled Composites' failure to consider and protect against the possibility that a single human error could result in a catastrophic hazard to the SpaceShipTwo vehicle. This failure set the stage for the copilot's premature unlocking of the feather system as a…NTSB OPS14IA011Incident · No injuriesIncident investigationFinal reportBoeing 777 - 236 · Shemya, AKThe air traffic controller’s failure to identify a conflict between two aircraft and to issue an adequate clearance, which resulted in a loss of required separation. Contributing to the incident was the Federal Aviation Administration’s failure to provide…NTSB WPR14LA201Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Biggs, CAThe assembler’s improper fabrication of a fuel line (hose) and the subsequent failure to verify that it was not occluded, which resulted in fuel starvation and a total loss of engine power during takeoff.NTSB ERA14LA202Accident · No injuriesLimited investigationFinal reportOconnor Paul A Ultimate Aero 10-200 · Saint Albans, VTThe propeller blade’s failure due to fatigue cracks that initiated from pitch change pin attachment holes that had been drilled too deep during manufacture.