NTSB investigations
357 cases where the defining event was Fire/smoke (non-impact).
Cases, newest first
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 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 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 ERA11LA179Accident · No injuriesLimited investigationFinal reportBeech C23 · Carrollton, GAThe mechanic's failure to re-connect a fuel line following an annual inspection. Contributing to the accident was the pilot's improper decision to depart with a known mechanical deficiency.NTSB ENG11IA016Incident · No injuriesIncident investigationFinal reportBoeing 757-2Q8 · Minneapolis, MNthe failure of the right engine's fuel control unit to operate correctly when the fuel metering valve became frozen in the full open position because of corrosion on the fuel metering valve slide and sleeve, which caused the engine to be overfueled during…NTSB ERA11LA124Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pittsburg, PAThe pilot’s excessive engine rpm and speed during taxi and subsequent braking, which resulted in a wheel brake fire.NTSB ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.NTSB DCA11WA031Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyOn November 9, 2010, a Boeing 747-400, German registration D-ABVT, operated by Lufthansa, experienced a fire in the APU compartment. There were no injuries, and minor damage to the airplane. This incident is being investigated by the BFU of Germany.…NTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.NTSB DCA10RA092Accident · 2 fatalClass 5 · ForeignBoeing 747-44AF · Dubai, United Arab EmiratesNTSB DCA10IA082Incident · Minor injuriesIncident investigationFinal reportBoeing 767-322 · Chicago, ILthe brake fire after landing was caused by hydraulic fluid leaking on to hot brakes.NTSB ERA10LA387Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33AK · Windsor, VAThe unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.NTSB CEN10CA456Accident · No injuriesData collectionFinal reportLindstrand 69A · Longview, TXThe the pilot's inadvertent movement of the burner assembly off center resulting in an in-flight fire of the skirt and envelope of the balloon. Contributing to the accident was the pilot's attention being diverted to venting the envelope to avoid an obstacle…NTSB ENG10IA041Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe cause of the right wing landing light switch fire is undetermined.NTSB ERA10WA371Accident · 1 fatalForeign investigationRobinson R44 · Novo Horizonte, BrazilOn July 16, 2010, about 1645 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Brazilian registration PR-TNB, operated by Pereira Alvim Participacoes e Empreendimentos Ltda, was destroyed by fire after landing in a cane field at Novo Horizonte,…NTSB WPR10LA319Accident · No injuriesLimited investigationFinal reportPridmore Lancair IV · Caldwell, IDThe failure of maintenance personnel to ensure that a hydraulic line fitting was adequately secured during a conditional inspection, which resulted in a leak and subsequent on-ground fire.NTSB WPR10LA308Accident · No injuriesLimited investigationFinal reportHughes 369HS · Paicines, CAAn in-flight fire for undetermined reasons.NTSB ENG10IA038Incident · No injuriesIncident investigationFinal reportBoeing 767 · Athens, GreeceA short circuit involving the light in position L3 on the squib test panel. The specific cause of the short circuit could not be determined.NTSB CEN10LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Wellington, KSA fire of undetermined cause that originated in the airplane's cabin.NTSB WPR10FA264Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Chandler, AZFailure of the maintenance personnel to ensure adequate torque of a fuel line fitting, which resulted in an in-flight fire.NTSB ENG10IA029Incident · No injuriesIncident investigationFinal reportBoeing 757 · Chantilly, VAThe ignition of the J5 power terminal located on the captain’s No. 1 windshield due to a loose electrical connection between the terminal connector lug and its respective terminal block. The loose connection resulted from a missing lock washer that allowed…NTSB ERA10LA210Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Pittsburgh, PAA fire of undetermined origin behind the left instrument panel.NTSB CEN10LA186Accident · No injuriesLimited investigationFinal reportCessna 182F · Wichita Falls, TXA fire of undetermined origin.NTSB DCA10WA041Incident · No injuriesForeign investigationBoeing 747 · Paris, FranceOn March 18, 2010, at 0700 local time (0600 UTC), a Thai Airways International Boeing 747-4D7, registered in Thailand as HS-TGL, experienced a fire in its avionics bay while parked at Charles de Gaulle International Airport (CDG), Paris, France. No injuries…NTSB ERA10IA147Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Nashville, TNA loss of engine power due to the mechanic’s failure to properly secure the fuel control unit fuel lines after replacement of the starter adapter.NTSB CEN10CA111Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Reserve, NMAn in-flight fire due to a fuel leak from the No. 5 cylinder's broken fuel injector/line.NTSB ENG10IA010Incident · No injuriesIncident investigationFinal reportATR ATR72 · St. CroixThe sealing failure between the fuel nozzle adapter assembly and fuel transfer tubes that allowed fuel to leak into the nacelle fire zone where it was subsequently ignited by the hot combustor case. Contributing to the failure was a combination of…NTSB DCA10WA019Incident · Minor injuriesForeign investigationBoeing 737 · Hahn, GermanyOn January 4, 2010, at 0940 UTC, a Boeing 737-800, Irish registration EI-DAK, operated by Ryan Air, experienced fire and smoke in a ground power unit connector prior to takeoff at Hahn, Germany. The aircraft had minor damage and 5 of the 6 crew members…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.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.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…NTSB CEN09LA594Accident · No injuriesLimited investigationFinal reportMcclish Funk B85C · Coffeyville, KSAn in-flight fire for undetermined reasons.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.NTSB WPR09LA418Accident · No injuriesLimited investigationFinal reportCessna 177 · Chandler, AZAn on-ground fire in the engine compartment for undetermined reasons.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.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…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…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…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.NTSB WPR09LA247Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Joshua Tree, CAAn in-flight fire in the engine compartment for undetermined reasons.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.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.NTSB ERA09LA231Accident · 1 fatalLimited investigationFinal reportHoward William C KR-2 · Valdosta, GAAn in-flight fire for undetermined reasons.NTSB ERA09LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLAn engine air induction explosion for an undetermined reason during repeated engine start attempts.NTSB ERA09LA199Accident · No injuriesLimited investigationFinal reportShniderman Ervin Stanley LONG-EZ · Manassas, VAA fire of undetermined origin in the engine compartment.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.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.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 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 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.