NTSB investigations, 2011
6 cases where NTSB found Misc hardware.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 9 |
| 2010 | 6 |
| 2011 | 6 |
| 2012 | 10 |
| 2013 | 9 |
| 2014 | 4 |
| 2015 | 5 |
| 2016 | 10 |
| 2017 | 11 |
| 2018 | 7 |
| 2019 | 8 |
| 2020 | 7 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 10 |
| 2025 | 2 |
| 2026 | 4 |
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\") = 2011
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010714'))
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") = 2011 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010714')) 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 DCA12MA020Accident · 5 fatalClass 1 · MajorFinal reportEurocopter France AS350B2 · Las Vegas, NVSundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…NTSB ERA11LA469Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 180A · Lewiston, METhe separation of the inflation tank gas line due to an improperly positioned valve o-ring. Contributing to the accident was the use of an unapproved inflation tank.NTSB WPR11CA309Accident · Minor injuriesData collectionFinal reportCessna 182A · Vancouver, WAThe pilot's failure to properly engage the banner tow rope with the airplane's tail hook.NTSB WPR11FA258Accident · No injuriesField investigationFinal reportBowley Murphy · Aguila, AZA fire that originated from a fuel leak at an undetermined location in the engine compartment. Contributing to the accident was the builder's use of non-aviation hardware for engine fluid fittings and lines.NTSB ANC11CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Sterling, AKThe airplane owner improper fabrication of a fuel line, and subsequent inadequate inspection by an aviation mechanic, resulting in a loss of engine power.NTSB WPR11LA135Accident · No injuriesLimited investigationFinal reportCessna 172H · Wikieup, AZA total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.