Final NTSB investigations, 2016
10 cases where the defining event was Fire/smoke (non-impact).
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 18 |
| 2010 | 17 |
| 2011 | 14 |
| 2012 | 11 |
| 2013 | 11 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 10 |
| 2017 | 12 |
| 2018 | 11 |
| 2019 | 9 |
| 2020 | 6 |
| 2021 | 8 |
| 2022 | 8 |
| 2023 | 15 |
| 2024 | 9 |
| 2025 | 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\") = 2016
AND c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '150')
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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '150') 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 ERA17LA071Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palm Bay, FLUnknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.NTSB CEN17FA045Accident · 1 fatalField investigationFinal reportCessna 340 · Fargo, NDThe loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.NTSB CEN17LA034Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Baton Rouge, LAA clamp rubbing a hole in a fuel drain line, which resulted in an engine compartment fuel leak and subsequent engine fire.NTSB WPR16FA153Accident · 4 fatalField investigationFinal reportPiper PA-31T · McKinleyville, CAAn inflight fire in the floor area near the main bus tie circuit breaker panel that resulted from chafing between an electrical wire and a hydraulic line and/or airplane structure.NTSB ENG16IA027Incident · No injuriesIncident investigationFinal reportBoeing 757 · Jamaica, NYMaintenance personnel's failure to ensure proper installation of a fuel tube O-ring, which resulted in an undercowl engine fire during initial climb.NTSB CEN16IA238Incident · No injuriesIncident investigationFinal reportEnstrom 280 · Zeeland, MIThe exhaust band clamp failure, which resulted in an engine fire due to hot exhaust gases entering the engine compartment.NTSB CEN16LA201Accident · No injuriesLimited investigationFinal reportCessna 402B · Sioux Falls, SDThe failure of the No. 4 cylinder head, which resulted in an engine fire and subsequent damage to the wing structure.NTSB ERA16LA183Accident · No injuriesLimited investigationFinal reportPiper PA 22 · Gallatin, TNThe pilot's inadequate preflight inspection, which resulted in an inflight fire due to the presence of a bird nest in the engine compartment.NTSB ERA16LA154Accident · No injuriesLimited investigationFinal reportPiper PA28 · West Mifflin, PAThe pilot's failure to follow checklist procedures for an engine fire during start.NTSB ERA16LA119Accident · No injuriesLimited investigationFinal reportPiper PA28 151 · St. Augustine, FLThe flight instructor's overpriming of the engine during start, which resulted in a carburetor fire. Contributing to the severity of accident was the flight instructor's failure to follow the Pilot Operating Handbook's engine fire during start emergency…