NTSB investigations
504 cases where the sequence of events included 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 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 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 ERA16LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Opa Locka, FLMaintenance personnel's inadequate inspection of the exhaust system, which resulted in the escape of exhaust gases into the engine compartment and a subsequent total loss of engine power.NTSB DCA16FA013Accident · Serious injuriesField investigationFinal reportBoeing 767 · Fort Lauderdale, FLthe separation of the flexible fuel line coupling and subsequent fuel leak due to the failure of maintenance personnel to install the required safety lockwire. Contributing to the severity of the accident was the initiation of the evacuation before the right…NTSB CEN16LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Century, KSThe pilot’s application of excessive brake pressure to maintain a safe taxi speed during a long, slightly downhill taxi with a strong quartering tailwind, which resulted in a brake fire.NTSB CEN16LA021Accident · No injuriesLimited investigationFinal reportPiper PA 28-235 · Winneconne, WIAn engine compartment fire during landing, which resulted in extensive fire damage, for reasons that could not be determined during examinations of the remaining wreckage.NTSB WPR15LA267Accident · No injuriesLimited investigationFinal reportCessna 177 · Thermal, CAA fire in the engine compartment due to the pilot overpriming the hot engine.NTSB WPR15IA263Incident · Minor injuriesIncident investigationFinal reportCessna T206H · Idaho Falls, IDAn in-flight fire during initial climb due to the separation of the engine's turbocharger wastegate overboard exhaust tailpipe. Contributing to the accident was the owner's decision to not comply with a service bulletin that addressed the tailpipe separation.NTSB ERA15LA369Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Pittsburg, PAAn engine fire, which resulted from the overpriming of a hot engine.NTSB WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.NTSB ERA16WA039Incident · No injuriesForeign investigationCessna 650 · Corlu, TürkiyeOn August 1, 2015, at 2317 coordinated universal time, a Cessna 650; N691BE, incurred minor damage after the main landing gear tires deflated during takeoff roll and a fire ensued in the area of the main landing gear at Tekirdag Çorlu Airport (LTBU), Corlu,…NTSB ERA15FA277Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Lake Wales, FLA partial loss of engine power due to oil starvation. Contributing was the flight instructor's failure to maintain control of the airplane during an aborted emergency landing, and his delayed decision to deploy the airplane's parachute system.NTSB ENG15WA027Incident · No injuriesForeign investigationAirbus A330 - 323 · Incheon, Republic of Korea, South KoreaOn July 14, 2015 at about 0832 universal coordinated time, an Airbus A330-300, HL8282, operated by Asiana Airlines experienced No. 2 (right) engine fire and oil pressure warnings shortly after takeoff from Incheon International Airport (ICN), Incheon,…NTSB WPR15LA180Accident · No injuriesLimited investigationFinal reportMooney M20C · Reno, NVThe in-flight separation of the exhaust tube at a weld joint due to erosion and corrosion, which resulted in a subsequent in-flight fire.NTSB DCA15CA129Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · St Petersburg, FLevacuation of the aircraft due to reported, but unverified, aircraft condition and poor communication between Aircraft Rescue and Firefighting personnel and the flight crew.NTSB ENG15IA024Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 · Windsor Locks, CTThe arcing failure of the windshield heat power wire on the right windshield due to unknown reasons. Contributing to the severity of the fire was the lack of training or guidance provided to the crew for selecting the windshield heat to off that would cut…NTSB ERA15LA189Accident · No injuriesLimited investigationFinal reportCessna LC41-550FG · Titusville, FLAn inflight fire and a total loss of engine power due to oil starvation, after separation of the No. 3 cylinder exhaust valve rocker box cover for reasons that could not be determined based on the available information.NTSB ERA15IA198Incident · No injuriesClass 2 · IncidentFinal reportDassault-Breguet Mystere Falcon 900 · Orlando, FLUnknown maintenance personnel’s inadequate securing of a wiring bundle during a maintenance, repair, or modification event, which led to chafing of the wiring bundle, an electrical short and arcing, and a subsequent in-flight fire.NTSB ERA15FA181Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Fort Lauderdale, FLA rapid onset of smoke and/or fire inflight for reasons that could not be determined due to the postimpact fire and the condition of the wreckage.NTSB DCA15WA156Incident · No injuriesForeign investigationBoeing Boeing 737-530 · Zurich, SwitzerlandThe BFU of Switzerland (BFU-CH) has notified the NTSB of an incident involving a Boeing 737-530 airplane that occurred on April 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU-CH's investigation under the provisions of ICAO…NTSB DCA15WA097Incident · No injuriesForeign investigationBoeing 777-306er 300 · Bangkok, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving a Boeing 777-306ER that occurred on March 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Aircraft Accident Investigation…NTSB ERA15LA138Accident · No injuriesLimited investigationFinal reportBell 206 · Sevierville, TNAn uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.NTSB ANC15LA011Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKAn in-flight fire and a partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN15IA139Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G IV · Eagle, COThe pilot's rejected takeoff due to perceived flight control system anomalies, which led to excessive brake temperatures and resulted in a right main landing gear brake fire.NTSB DCA15WA074Incident · No injuriesForeign investigationBoeing 747 - 406 · Novosibirisk, RussiaThe Republic of South Korea Aviation and Railway Accident Investigation Board (ARAIB) has notified the NTSB of an incident involving a BOEING 747 that occurred on January 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB in…NTSB ENG15RA010Incident · No injuriesForeign investigationBombardier DHC-8-402 · Belfast, N Ireland, United KingdomOn December 16, 2014, about 1839 UTC, a DeHavilland DHC-8-400Q, powered by two Pratt & Whitney Canada (PWC) PW150A turboprop engines, experienced an engine casing burn-through and in-flight shutdown near Belfast International Airport. Belfast, N. Ireland.…NTSB WPR15CA026Accident · No injuriesData collectionFinal reportRockwell 690B · Mesa, AZThe failure of the nose gear tire, which resulted in the vibration of the nose landing gear and subsequent fire to the tire and forward section of the fuselage structure.NTSB CEN15LA018Accident · Serious injuriesLimited investigationFinal reportViguie G/Viguie M Lancair Legacy · Livingston, TXA catastrophic and uncontained engine failure due to oil starvation. Contributing to the accident was the missing No. 3 cylinder intake rocker cover for reasons that could not be determined based on the available evidence.NTSB DCA15WA021Incident · No injuriesForeign investigationAirbus 330-200 · Karachi, PakistanThe United Arab Emirates General Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving an Emirates AIRBUS 330-200 that occurred on October 04, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA…NTSB ANC14LA085Accident · No injuriesLimited investigationFinal reportCessna TU206 · Deadhorse, AKThe application of insufficient torque to the engine cylinder through bolts during the replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 bearing, oil starvation, and a catastrophic engine failure.NTSB ENG14IA027Incident · No injuriesIncident investigationFinal reportBoeing 747 · Atlanta, GATurbine Overhaul Service's aggressive grit blasting and incomplete masking of the blade root neck that allowed the no grit blast area being exposed during the overhaul of the blade resulting in blasting media being embedded in the blade root from which a…NTSB ENG14IA028Incident · No injuriesIncident investigationFinal reportAirbus A320 232 · Long Beach, CAThe probable cause of the engine failure and subsequent undercowl engine fire was due to the fatigue fracture of a high pressure turbine stage 2 disk blade retaining lug that released two blades which impacted the low pressure turbine case causing a fuel line…NTSB DCA14WA163Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · Stanstead, United KingdomThe Air Accidents Investigation Branch of the United Kingdom has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on September 18, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's…NTSB CEN14LA504Accident · 2 fatalLimited investigationFinal reportSaccio Thomas A Seawind 3000 · Bloomington, INAn in-flight fire for reasons that could not be determined because the examination of the airplane did not reveal the source of the fire.NTSB WPR14LA394Accident · No injuriesLimited investigationFinal reportLorentzen Lancair Legacy · Reno, NVThe shearing of mounting bolts that attached the right turbocharger to its mounting bracket during an air race, which resulted in hot exhaust gases leaking into the engine compartment and starting a fire.NTSB ENG14IA029Incident · No injuriesIncident investigationFinal reportBombardier CRJ700 · Hodeida, YemenThe probable cause of the undercowl engine fire was the burn-through of the combustion chamber inner liner from the accumulation of dust that became molten during operating and infiltrated the combustion chamber thermal barrier coating causing it to spall off…NTSB CEN14WA473Incident · No injuriesForeign investigationCessna 560 XL · Geneva, SwitzerlandNTSB ERA14CA420Accident · No injuriesData collectionFinal reportMooney M20K · Vero Beach, FLThe failure of the pilot and personnel from the fixed base operator to assure the correct ground power unit was utilized to provide external power, resulting in damage to the aircraft's electrical wiring and subsequent damage to structure adjacent to the…NTSB ERA14LA390Accident · No injuriesLimited investigationFinal reportCessna R182 · Farmingdale, NYThe failure of the aluminum nipple fuel supply line fitting, which resulted in an engine compartment fire.NTSB CEN14FA389Accident · 2 fatalField investigationFinal reportFedersen Walter Lancair IVP · Findlay, OHAn in-flight fire for reasons that could not be determined due to the extent of impact and fire damage.NTSB ENG14IA019Incident · No injuriesIncident investigationFinal reportBoeing 767 332 · Los Angeles, CAThe combination of fuel leaking from the integrated drive generator (IDG) fuel/oil heat exchanger and the coincident arcing of the IDG power feeder cables that ignited the leaking fuel. Contributing to the ignition of the fuel was the misrouting of the IDG…NTSB ENG14IA018Incident · No injuriesIncident investigationFinal reportPiper PA46 500TP · Denver, COThe pilots' incorrect activation of the Manual Override Lever, during ground operation, in an attempt to correct a sub-idle speed condition of the engine, resulting in an over-temperature of the CT blades, their subsequent distress and failure of the engine.…NTSB WPR14FA258Accident · 1 fatalField investigationFinal reportParker Loehle Mustang T5151 · Livermore, CAAn in-flight fire of unknown origin for reasons that could not be determined because of impact damage and postimpact fire damage.NTSB CEN14LA263Accident · No injuriesLimited investigationFinal reportAero Commander 200D · La Grange, TXThe loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.NTSB ERA14WA246Accident · Serious injuriesForeign investigationCessna T206H · Macas, EcuadorOn May 14, 2014, about 1600 local time, a Cessna T206H, Ecuadorian registration HC-CFE, was substantially damaged when it impacted power lines while returning to land at Edmundo Carvajal Airport (SEMC), Macas, Ecuador, with smoke in the cockpit. The…NTSB ANC14IA028Incident · No injuriesIncident investigationFinal reportPiper PA 28-181 · South Naknek, AKA fire in the airplane’s engine compartment that initiated for reasons that could not be determined due to extensive fire damage.NTSB ENG14IA013Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Sugar Land, TXThe probable cause of the uncontained No. 2 engine failure on the Raytheon Beechjet 400A was a yellow-crowned night-heron birdstrike that resulted in fan blade contact with the inlet case and rub induced excitation of a previously unidentified natural…NTSB DCA14WA095Incident · No injuriesForeign investigationBoeing 737-800 · Bangkok, ThailandThe Aviation Safety Council (ASC) of Taiwan has notified the NTSB of an incident involving a Boeing 737-800 that occurred on 11 May, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO…NTSB CEN14LA239Accident · No injuriesLimited investigationFinal reportCessna 525C · Columbus, OHThe flight crew’s decision to attempt an engine start in conditions that exceeded the engine's maximum allowable ground start crosswind component limitation.NTSB ENG14RA014Incident · No injuriesForeign investigationBAE AVRO146RJ - 100 · Perth, Australia, AustraliaOn April 29, 2014, a British Aerospace BAE AVRO 146-RJ100, registration VH-NJI, experienced a No. 2 engine (left inboard) fire from the Honeywell LF507-1F turbofan engine during climb from Perth, Australia. The airplane was returned to Perth where an…NTSB CEN14LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Searcy, ARThe pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.NTSB ERA14LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe flight instructor’s overpriming of the engine during multiple unsuccessful engine start attempts on an active runway, which resulted in an engine compartment fire.