NTSB investigations, 2008
20 cases where the sequence of events included Fire/smoke (non-impact).
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 26 |
| 2010 | 28 |
| 2011 | 26 |
| 2012 | 27 |
| 2013 | 23 |
| 2014 | 31 |
| 2015 | 23 |
| 2016 | 29 |
| 2017 | 35 |
| 2018 | 38 |
| 2019 | 33 |
| 2020 | 15 |
| 2021 | 22 |
| 2022 | 28 |
| 2023 | 34 |
| 2024 | 33 |
| 2025 | 24 |
| 2026 | 9 |
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\") = 2008
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '150' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2008 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '150' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA09WA214Accident · No injuriesForeign investigationPiper PA31-350 · Lorenzo, BrazilOn March 23, 2009, at 1700 Atlantic standard time, a Piper PA31-350 Chieftain, PT-EHG, sustained minor damage from a landing-gear brake fire after landing at Lorenzo Airport (SNCL), Cairu, Brazil. The pilot and seven passengers were not injured. Visual…NTSB WPR09IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-890 · Seattle, WAThe failure of the deicing crew to follow company procedures by not receiving confirmation from the flight crew before beginning to deice the airplane.NTSB WPR09WA249Incident · No injuriesForeign investigationEmbraer EMB145 · Kemi, FinlandOn December 11, 2008, at 2253 universal coordinated time, an Embraer EMB145, registration OH-EBE, sustained minor damage to the tailcone after the Auxillary Power Unit (APU) caught fire during taxi after landing at Kemi-Tornio Airport, Kemi, Finland. The…NTSB DCA09IA018Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD88 · Greer, SCThe overheating and arcing of the DC Ground Service Relay and Block Diodes component for undetermined reasons.NTSB CEN09WA073Accident · Minor injuriesForeign investigationBeech A100 · God's Lake Narrows, CanadaNone.NTSB CEN09IA057Incident · No injuriesIncident investigationFinal reportCessna T210N · Lubbock, TXAn unidentified anomaly within the airplane's electrical system. Contributing to the incident was the pilot's failure to manually extend the landing gear.NTSB WPR09LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORAn in-flight engine fire due to the fatigue fracture of an exhaust pipe that resulted from a failure of the pipe's slip joint.NTSB SEA08LA216Accident · No injuriesLimited investigationFinal reportBrennan RV-8 · Idaho Falls, IDThe on-ground fire during taxi due to a loose fuel line "B" nut.NTSB CHI08CA271Accident · No injuriesData collectionFinal reportCessna T182T · Munising, MIThe inadequate preflight planning/preparation by the pilot to carry a hazardous material aboard an airplane that resulted in a fire during an after-landing taxi.NTSB LAX08FA286Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Las Vegas, NVA loss of power in the right engine due to an in-flight fuel-fed fire in the right engine compartment that, while the exact origin could not be determined, was likely related to the right engine-driven fuel pump, its fuel supply line, or fitting. Contributing…NTSB DFW08LA206Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7-15 · Mountain Grove, MOAn on-board fire following a propane leak. Contributing to the accident was the lack of training/experience of the non-certificated pilot.NTSB NYC08FA292Accident · No injuriesField investigationFinal reportSteven A. Jones Lancair IV P · Stafford, VAThe pilot's decision to install voltage regulators in the engine compartment where they were susceptible to water intrusion, which resulted in a malfunction of the standby electrical system's voltage regulator and a subsequent in-flight fire.NTSB DCA08MA076Accident · No injuriesClass 1 · MajorFinal reportBoeing 767 · San Francisco, CAThe design of the supplemental oxygen system hoses and the lack of positive separation between electrical wiring and electrically conductive oxygen system components. The lack of positive separation allowed a short circuit to breach a combustible oxygen hose,…NTSB CHI08LA169Accident · No injuriesLimited investigationFinal reportMorrison E-Racer · Aurora, ILAn undetermined failure in the high-pressure fuel system, and the subsequent loss of engine power and in-flight fire. Contributing to the accident were the pilot's restricted visibility due to the smoke in the cockpit, failure of the aileron control during…NTSB MIA08LA123Accident · No injuriesLimited investigationFinal reportCirrus Design SR-20 · Williston, FLThe student pilot’s failure to follow the manufacturer's recommended taxiing procedures.NTSB CHI08FA146Accident · 2 fatalField investigationFinal reportPiper PA28 · Hillsboro, OHThe pilot's failure to maintain control of the airplane due to an in-flight fire as a result of a corrosion hole in the muffler that was not identified by the mechanic. Contributing to the accident was the improper emergency procedure performed for an…NTSB DFW08LA135Accident · Serious injuriesLimited investigationFinal reportBailey Varieze · Phillipsburg, KSThe pilots failure to maintain aircraft control during an emergency landing. Contributing factors were the reported smoke and prevailing gusty wind conditions.NTSB ENG08IA022Incident · No injuriesIncident investigationFinal reportBoeing 747 · Newark, NJAn engine fire in the No. 3 engine due to the failure of, and subsequent flammable fluid leak from, one of three fuel or hydraulic lines located in the engine's accessory raceway that ignited when the fluid came in contact with the hot engine cases.…NTSB NYC08LA144Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Covington, TNA fire of undetermined origin.NTSB CHI08IA085Incident · No injuriesIncident investigationFinal reportHawker Beechcraft 99 · Moline, ILThe arcing of the resistor and silicone controlled rectifier in the flap control circuit.