Skip to content

NTSB investigations, 2009

26 cases where the sequence of events included Fire/smoke (non-impact).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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") = 2009 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

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\") = 2009
    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") = 2009
  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 CEN10LA083Accident · No injuriesLimited investigationFinal reportBeech B35 · Santa Fe, NMAn engine overpressure condition that resulted in oil getting on the exhaust and producing smoke which entered the cockpit. Contributing to the accident was the pilot's obscured vision due to smoke.Dec 25, 2009 · N8828A · Substantial damage NTSB ERA10LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Durham, NCThe total loss of engine power in flight and a fire in the engine compartment for undetermined reasons.Nov 25, 2009 · N2758D · Destroyed NTSB WPR10FA056Accident · 1 fatalField investigationFinal reportBeech A36 · San Gabriel, CAFailure of the exhaust band V-clamp during cruise flight, which resulted in an in-flight fire and a subsequent forced landing.Nov 15, 2009 · N17803 · Substantial damage NTSB ERA09FA526Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Fort Lauderdale, FLFatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…Sep 20, 2009 · N2467Y · Substantial damage NTSB CEN09LA594Accident · No injuriesLimited investigationFinal reportMcclish Funk B85C · Coffeyville, KSAn in-flight fire for undetermined reasons.Sep 18, 2009 · N81167 · Destroyed NTSB ENG09IA017Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ 190-100 IGW · Nassau, Bahamasfailure of the engine high pressure turbine active clearance control valve fuel rod supply tube coupling seal due to a cross-threaded B-nut as installed during original manufacture.Sep 3, 2009 · N258JB · Minor damage NTSB WPR09LA418Accident · No injuriesLimited investigationFinal reportCessna 177 · Chandler, AZAn on-ground fire in the engine compartment for undetermined reasons.Aug 25, 2009 · N30715 · Destroyed NTSB WPR09LA361Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Redmond, ORAn undetermined hydraulic system malfunction in the engine compartment during descent from cruise flight which resulted in an in-flight fire.Jul 21, 2009 · N117KR · Substantial damage NTSB DCA09WA066Incident · No injuriesForeign investigationBoeing 767 · Keflavik, IcelandOn July 20, 2009, UAL flight 949, a B767 enroute from London Heathrow to Chicago O'Hare experienced smoke in the cockpit and the crew elected to divert to Keflavik, Iceland. The flight landed without further incident and no injuries among the 11 crew and 178…Jul 20, 2009 · N658UA · Minor damage NTSB WPR09LA341Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Westley, CAThe failure of the landing gear hydraulic line socket, which resulted in a hydraulic leak and in-flight fire. Contributing to the accident was the failure of the owner and/or maintenance facility to comply with the maintenance manual hose replacement schedule.Jul 14, 2009 · N330HT · Substantial damage NTSB WPR09LA307Accident · No injuriesLimited investigationFinal reportGunnoe Velocity · Livermore, CAThe failure of the right brake due to a restricted brake rotor and subsequent brake fluid line failure as a result of inadequate maintenance.Jun 19, 2009 · N92VA · Substantial damage NTSB ENG09IA007Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Denver, COThere was a malfunction of the electronic engine control (EEC) burner pressure (Pb) sensor that had an abnormally high indication that resulted in an excessive amount of fuel being pumped into the engine that was still at a sub-idle condition. Because the…Jun 10, 2009 · N570UA · Minor damage NTSB ERA09IA326Incident · No injuriesIncident investigationFinal reportIniziative Sky Arrow · Marietta, GAAn electrical fire due to the lack of a positive locking mechanism for the fuse retainer in the main fuse block, which resulted in voltage fluctuations that caused thermal damage to the avionics cooling fan. Contributing to the incident was the student…Jun 8, 2009 · N445SA · No damage NTSB CEN09LA324Accident · Serious injuriesLimited investigationFinal reportBell 47G · Kyle, TXThe ground crewmember's failure to assure that the fuel nozzle was closed before pressurizing the line. Contributing to the accident was the lack of an available fire extinguisher.May 30, 2009 · N4823 · Substantial damage NTSB WPR09LA247Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Joshua Tree, CAAn in-flight fire in the engine compartment for undetermined reasons.May 19, 2009 · N450JN · Substantial damage NTSB CEN09IA294Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Houston, TXThe pilot's inadvertent application of excessive braking after touchdown, which caused the right wheels to lock and several tires to blow and resulted in a subsequent brake fire.May 13, 2009 · N371SW · Minor damage NTSB ERA09LA266Accident · No injuriesLimited investigationFinal reportDouglas DC3 · San Juan, PRWorn electrical wires and a fuel pressure indicating system hose, which resulted in a ground fire during taxi.Apr 26, 2009 · N136FS · Substantial damage NTSB ERA09LA269Accident · No injuriesLimited investigationFinal reportCessna 208 · Frederick, MDA loss of engine power due to the failure of one or more compressor turbine blades for an undetermined reason.Apr 21, 2009 · N208JW · Substantial damage NTSB ERA09FA248Accident · 1 fatalField investigationFinal reportCessna 421B · Oakland Park, FLThe pilot's failure to maintain aircraft control and secure the right engine during an emergency return to the airport after takeoff. Contributing to the accident was an in-flight fire of the right engine for undetermined reasons.Apr 17, 2009 · N1935G · Substantial damage NTSB ERA09CA246Accident · No injuriesData collectionFinal reportPiper PA20 · Scranton, PAThe pilot’s inadequate compensation for wind conditions during landing. Contributing to the accident was the distraction of smoke in the cockpit.Apr 9, 2009 · N7653K · Substantial damage NTSB ERA09LA231Accident · 1 fatalLimited investigationFinal reportHoward William C KR-2 · Valdosta, GAAn in-flight fire for undetermined reasons.Apr 4, 2009 · N456CH · Destroyed NTSB ERA09LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLAn engine air induction explosion for an undetermined reason during repeated engine start attempts.Mar 17, 2009 · N613FT · Substantial damage NTSB ERA09LA199Accident · No injuriesLimited investigationFinal reportShniderman Ervin Stanley LONG-EZ · Manassas, VAA fire of undetermined origin in the engine compartment.Mar 14, 2009 · N770EZ · Substantial damage NTSB ERA09LA193Accident · 2 fatalLimited investigationFinal reportBurkholder Jimmy C Zodiac 601HD · Live Oak, FLThe pilot's loss of control of the airplane for undetermined reasons.Mar 10, 2009 · N601DE · Destroyed NTSB ERA09LA191Accident · Serious injuriesLimited investigationFinal reportGrumman TBM-3 · Millville, NJThe pilot/mechanic’s failure to properly torque the fuel pressure line B-nut to the carburetor fitting.Mar 7, 2009 · N188TD · Destroyed NTSB DCA09FA033Accident · No injuriesField investigationFinal reportBombardier CRJ · Tallahassee, FLAn electrical anomaly in the top portion of the JB-1 junction box resulting in ignition of adjacent combustible materials, including insulation blankets, and a flexible oxygen line.Feb 28, 2009 · N830AS · Substantial damage