NTSB investigations, 2016
3 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
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\", '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") = 2016 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 ANC17FA009Accident · 1 fatalClass 3 · FieldFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot’s decision to operate the airplane at an altitude too low to allow for recovery from an intentional aerodynamic stall. Contributing to the accident was the pilot’s lack of knowledge of the stall performance characteristics of the airplane modified…NTSB DCA17FA021Accident · Serious injuriesClass 1 · FieldFinal reportBoeing 767 · Chicago, ILThe failure of the high-pressure turbine (HPT) stage 2 disk, which severed the main engine fuel feed line and breached the right main wing fuel tank, releasing fuel that resulted in a fire on the right side of the airplane during the takeoff roll. The HPT…NTSB CEN16LA401Accident · No injuriesLimited investigationFinal reportAgustawestland Philadelphia AW139 · Galliano, LAThe fatigue failure of a tail rotor blade erosion shield extension, which resulted in in-flight damage to a main rotor blade.