Final NTSB investigations, 2012
11 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\") = 2012
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") = 2012 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 ERA13LA048Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pahokee, FLA main landing gear wheel fire for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operations.NTSB CEN12IA662Incident · No injuriesIncident investigationFinal reportCanadair CL-600 Challenger · Denver, COThe internal failure of the galley heater mat’s thermostat, which resulted in an overheat condition.NTSB CEN12LA652Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · (Gulf of Mexico)An in-flight fire, which resulted in the airplane’s forced landing in water. The source of the fire could not be determined because the airplane wreckage was not recovered.NTSB CEN12LA551Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Holton, KSThe mechanic's failure to adequately torque the right magneto attachment nuts, allowing the right magneto to come loose, which allowed engine oil to escape, causing the engine to seize.NTSB CEN12CA496Accident · No injuriesData collectionFinal reportBlack Donald Cozy III · Los Lunas, NMA loose oil line, which allowed oil to leak onto the hot engine turbocharger and resulted in a fire.NTSB CEN12FA395Accident · 1 fatalField investigationFinal reportNappi Tito C Lancair 235M · Monroe Center, ILThe in-flight fire for a reason that could not be determined due to extensive damage from the fire.NTSB ERA12FA412Accident · 1 fatalField investigationFinal reportSocata TB21 · Gold Hill, NCAn inflight fire, the origin of which could not be determined because of postaccident fire damage. Contributing to the accident was the pilot's improper modifications to the airplane.NTSB WPR12LA292Accident · No injuriesLimited investigationFinal reportSikorsky S-58B · Brewster, WAAn in-flight fire during hover for reasons that could not be determined due to the extent of fire damage that subsequently consumed the structure.NTSB ERA12LA217Accident · No injuriesLimited investigationFinal reportCessna 310K · Olive Branch, MSFuel leaking from the left engine fuel strainer onto electrical connections after engine start, which resulted in a fire.NTSB WPR12LA113Accident · No injuriesLimited investigationFinal reportHaycraft Sport Hornet · Mariposa, CAImproper clearance and inadequate heat shielding between engine components and the exhaust system, which resulted in an in-flight fire.NTSB ENG12IA010Incident · No injuriesIncident investigationFinal reportBoeing 767 · Jamaica, NYThe failure of the American Airlines aviation maintenance technicians to properly reassemble the two-piece bracket and spray shield on the integrated drive generator fuel-oil heat exchanger that caused a fuel leak that sprayed out and ignited on hot engine…