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 GAA19CA176Accident · No injuriesData collectionFinal reportPiper PA28 · Savannah, GAThe pilot's failure to conduct the engine starting procedures in accordance with the Pilot’s Operating Handbook, which resulted in an engine fire.NTSB ENG19WA045Incident · No injuriesForeign investigationEmbraer ERJ190 · Devon, United Kingdom, United KingdomOn February 28, 2019, an Embraer ERJ 190-200 LR powered by two General Electric CF34 10E7 turbofan engines, experienced smoke filling the cabin during the takeoff roll from Exeter International Airport, Devon, United Kingdom. The takeoff was aborted and an…NTSB CEN19LA048Accident · No injuriesClass 3 · LimitedFinal reportVans RV 6 · Watkins, COThe pilot’s failure to apply adequate torque to a fuel line during recent maintenance, which allowed the line to loosen in flight and fuel to enter the hot engine compartment and resulted in an in-flight fire that consumed the airplane.NTSB ENG19WA011Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on December 10, 2018. An Indigo Airbus A320 experienced an ECAM warning for 'Lavatory Smoke' while descending through FL170 to land Kolkata Airport…NTSB ERA19FA039Accident · 1 fatalField investigationFinal reportCessna 310 · Walton, NYAn in-flight fire of undetermined origin. Contributing to the accident were the severe icing conditions encountered during the final minutes of the flight, which led to a loss of airplane control.NTSB DCA19WA009Incident · Minor injuriesForeign investigationBoeing 737 · Zagreb, CroatiaThe AIN of Croatia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIN of Croatia's investigation under the provisions of ICAO Annex…NTSB CEN18RA397Incident · No injuriesForeign investigationCirrus SF50 · Zurich, SwitzerlandOn September 22, 2018, about 1615 UTC, a Cirrus Design Corporation SF50 VisionJet, N474CG, owned by Southern Aircraft Consultancy Incorporated Trustee, and operated I-FLY AG, c/o Aximos Treuhand AG, experienced an electrical fire in the air conditioning unit…NTSB DCA18WA280Incident · No injuriesForeign investigationBoeing 737 · Los Cabos, MexicoThe government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ERA18LA214Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Sinus 912 · West Palm Beach, FLThe fatigue failure of the exhaust system manifold, which resulted in a ground fire after landing.NTSB WPR18LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mount Vernon, OHAn in-flight fuel-fed fire from an unknown source for reasons that could not be determined due to the extensive fire damage to the airplane.NTSB CEN18LA272Accident · No injuriesLimited investigationFinal reportCessna 182 · Odessa, TXAn on-ground fire for reasons that could not be determined based on the available information.NTSB ERA18WA216Incident · No injuriesForeign investigationCessna 501 · Catamarca, ArgentinaThe government of Argentina has notified the NTSB of an incident involving a CESSNA 501 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…NTSB DCA18WA247Incident · No injuriesForeign investigationDouglas DC9 · Chichen Itza, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a Douglas DC9 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…NTSB DCA18WA229Incident · No injuriesForeign investigationBoeing 737 · Koln, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…NTSB ANC18LA049Accident · No injuriesClass 3 · LimitedFinal reportLearjet 60 · Salt Lake City, UTThe flight crew’s failure to fully disengage the parking brake before taxi, which resulted in a brake fire.NTSB ENG18RA032Incident · No injuriesForeign investigationDassault FALCON7X · Singapore, SingaporeThe Singapore TSIB has notified the NTSB of an incident involving a Dassault Falcon 7X, VQ-BLP, which occurred on June 25, 2018. There was a fire in the mechanical service compartment while passengers were on board. The NTSB has appointed a U.S. Accredited…NTSB ERA18WA159Accident · 3 fatalForeign investigationCessna 421B · Rock Sound, BahamasNTSB ERA18FA146Accident · 1 fatalField investigationFinal reportBeech 35A33 · Jacksonville, ALThe pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…NTSB ERA18FA138Accident · 1 fatalField investigationFinal reportPiper PA32 · West Milford, NJAn in-flight fire and total loss of engine power after takeoff due to a loose fuel line. Contributing to the accident was the installation of an unapproved fuel line by unknown personnel.NTSB ENG18WA041Incident · No injuriesForeign investigationBoeing 777 · Bangkok, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving a Boeing 777-212 airplane on April 30, 2018. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO Annex 13 as the…NTSB DCA18LA163Accident · No injuriesClass 3 · LimitedFinal reportAirbus A330 323 · Atlanta, GAThe flight crew’s delayed landing after an in-flight engine fire, which reignited after both fire bottles were discharged and resulted in substantial damage to an engine pylon. Contributing to the delayed landing was likely the flight crew’s perception that…NTSB CEN18FA139Accident · 1 fatalField investigationFinal reportWittman W10 · San Antonio, TXAn in-flight fire and subsequent total loss of engine power for reasons that could not be determined due to extensive impact and fire damage, followed by a loss of airplane control.NTSB DCA18WA137Incident · No injuriesForeign investigationBoeing 737 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB GAA18CA185Accident · No injuriesData collectionFinal reportUltramagic N 300 · Cave Creek, AZThe balloon pilot’s decision to add heat to the envelope with a tree branch protruding into the envelope that caught fire.NTSB DCA18WA317Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Budapest, HungaryNTSB DCA18WA135Incident · No injuriesForeign investigationAirbus A320 · abeam Cooma Aerodome, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on February 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB ERA18LA053Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S76 · Islamorada, FLThe pilot's activation of the rotor brake while the No. 2 engine was still set to govern the power turbine speed, which resulted in continuous power being applied to the rotor while the rotor brake was engaged and led to excessive friction, heat, and a…NTSB WPR18LA043Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Rio Oso, CAAn in-flight fire due to electrical arc corrosion of the fuel line.NTSB ERA18LA033Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Presque Isle, METhe in-flight leakage of fuel from the fuel injection system's mixture shaft onto the hot turbocharger, which resulted in an in-flight fire, and the pilot's inability to see the runway due to reduced visibility conditions and conduct a successful landing.NTSB DCA18WA020Incident · No injuriesForeign investigationBoeing 777 · Oceanic, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on November 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB-UK's investigation under the provisions of ICAO…NTSB DCA18WA015Incident · No injuriesForeign investigationBoeing 777 · Adelaide, AustraliaThe government of Australia has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on October 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB ERA17LA338Accident · No injuriesLimited investigationFinal reportParks Richard A Starduster SA 100 · Southfields, NYA loose oil line that allowed oil to drip on the exhaust system, which resulted in smoke during cruise flight and a subsequent precautionary landing.NTSB ERA17CA295Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Palatka, FLThe student pilot's overpriming of the engine and the flight instructor's delayed remedial action, which resulted in an engine fire.NTSB WPR17IA198Incident · No injuriesIncident investigationFinal reportEnstrom F 28F · Glendale, AZAn internal failure of the turbo-compressor, which resulted in oil leaking into the turbo-compressor’s exhaust.NTSB CEN17WA308Accident · No injuriesForeign investigationAmerican Champion 8GCBC · Dunaujvaros, HungaryThe government of Hungary has notified the National Transportation Safety Board (NTSB) of an accident involving an American Champion 8GCBC airplane that occurred on August 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA17WA158Incident · No injuriesForeign investigationBoeing Boeing 777-236 · London, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 777-236 airplane that occurred on July 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation under the…NTSB DCA17WA161Incident · No injuriesForeign investigationBoeing 767 · Newcastle, United KingdomThe UK AAIB has notified the NTSB of an incident involving a Boeing767 airplane that occurred on July 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO Annex 13 as the…NTSB DCA17LA182Accident · No injuriesClass 3 · LimitedFinal reportBombardier CL 600 2C10 · Denver, COThe fuel supply tube fitting pulling out of the left engine’s operability bleed valve (OBV) during the landing rollout, allowing fuel to leak and contact hot engine cases, which ignited a fire that caused thermal damage to the engine pylon. Contributing to…NTSB DCA17WA126Incident · No injuriesForeign investigationBoeing 777 · Multan, PakistanThe government of Pakistan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on May 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…NTSB ANC17LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Noatak, AKA fire in the airplane's cabin, which initiated for reasons that could not be determined due to extensive thermal damage.NTSB CEN17LA151Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Nome, TXAn in-flight fire for reasons that could not be determined based on available information.NTSB ERA17FA117Accident · 1 fatalField investigationFinal reportLavender Alan P Sonex · Methuen, MAThe pilot's failure to properly secure oil and fuel line fittings during maintenance, which resulted in an inflight engine fire, and his subsequent loss of control while maneuvering for landing. Contributing to the accident was the pilot's diverted attention…NTSB ERA17LA126Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 · San Juan, PRThe flight instructor's incorrect manipulations of the twist grip throttle control during a practice autorotation, which resulted in an engine overspeed and subsequent fire.NTSB DCA17WA070Incident · No injuriesForeign investigationBoeing 777 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau (AIB) of Saudi Arabia has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on February 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AIB's investigation under…NTSB ENG17WA013Incident · No injuriesForeign investigationBritish Aerospace Avro 146-RJ100 · London, United KingdomThe United Kingdom's Air Accidents Investigation Board (AAIB) has notified the NTSB of an incident involving an AVRO 146-RJ100 that occurred on February 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB DCA17WA067Incident · No injuriesForeign investigationBoeing 737 · Edinburgh, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's…NTSB ERA17LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA22 · Georgetown, DEAn in-flight fire for reasons that could not be determined due to extensive thermal damage to the airplane.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 WPR17WA040Accident · No injuriesForeign investigationCessna 350 · Singapore, SingaporeOn December 8, 2016, about 1743 local time, a Cessna 350, N1222G, had the brakes catch fire during taxi following an aborted takeoff at Seletar Airport, Singapore. The owner/pilot was operating the airplane under the provisions of the Singapore Civil Aviation…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.