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 CEN17LA034Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Baton Rouge, LAA clamp rubbing a hole in a fuel drain line, which resulted in an engine compartment fuel leak and subsequent engine fire.NTSB CEN16WA400Accident · No injuriesForeign investigationPiper PA-28-161 · Sevilla, SpainOn September 9, 2017, at 1918 local time, a Piper PA-28-161, Spanish registration EC-JCI, had a brake failure while taxiing at Sevilla Airport, Sevilla, Spain. There were no injuries to the private pilot and one passenger, The airplane was substantially…NTSB CEN16WA367Accident · No injuriesForeign investigationUNknown Hummingbird 300LS · Rzeszow, PolandOn September 6, 2016, at 1125 UTC, an amateur built Hummingbird 300LS helicopter, Polish registration SP-YLN, caught fire during the on-ground cool down period following the first hovering flight of the helicopter after being built. The accident occurred at…NTSB WPR16FA153Accident · 4 fatalField investigationFinal reportPiper PA-31T · McKinleyville, CAAn inflight fire in the floor area near the main bus tie circuit breaker panel that resulted from chafing between an electrical wire and a hydraulic line and/or airplane structure.NTSB ENG16IA027Incident · No injuriesIncident investigationFinal reportBoeing 757 · Jamaica, NYMaintenance personnel's failure to ensure proper installation of a fuel tube O-ring, which resulted in an undercowl engine fire during initial climb.NTSB CEN16IA238Incident · No injuriesIncident investigationFinal reportEnstrom 280 · Zeeland, MIThe exhaust band clamp failure, which resulted in an engine fire due to hot exhaust gases entering the engine compartment.NTSB DCA16WA191Incident · No injuriesForeign investigationAirbus Industrie A330 323 · London, United KingdomAir Accident Investigation Branch (AAIB) notified the NTSB of a serious incident involving a AIRBUS INDUSTRIE A330 323 airplane that occurred on June 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…NTSB DCA16RA190Accident · No injuriesForeign investigationBoeing 777 · Singapore, SingaporeThe Air Accident Investigations Bureau (AAIB) of Singapore has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on June 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under…NTSB DCA16WA194Incident · No injuriesForeign investigationBoeing 747 · Los Angeles, CAAustralian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on June 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…NTSB ENG16WA025Incident · No injuriesForeign investigationBAE JETSTREAM3100 · Buenos Aires, Argentina, ArgentinaOn June 16, 2016, a Jetstream BA-32, registration number LV-ZST, powered by Honeywell TPE331 turbo propeller engines experienced an engine fire during an engine test. The incident is being investigated by the Argentinian Junta de Investigacion de Accidentes…NTSB CEN16LA201Accident · No injuriesLimited investigationFinal reportCessna 402B · Sioux Falls, SDThe failure of the No. 4 cylinder head, which resulted in an engine fire and subsequent damage to the wing structure.NTSB ERA16LA183Accident · No injuriesLimited investigationFinal reportPiper PA 22 · Gallatin, TNThe pilot's inadequate preflight inspection, which resulted in an inflight fire due to the presence of a bird nest in the engine compartment.NTSB DCA16WA159Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe government of Pakistan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…NTSB ERA16LA154Accident · No injuriesLimited investigationFinal reportPiper PA28 · West Mifflin, PAThe pilot's failure to follow checklist procedures for an engine fire during start.NTSB ERA16WA132Incident · No injuriesForeign investigationLearjet 60 · Doha, QatarOn March 9, 2016, about 1800 universal coordinated time, a Learjet 60 XR, United Arab Emirates registration A6RJE, incurred minor damage during cruise flight near Hamad International Airport (OTHH), Doha, Qatar. The two pilots, one flight attendant and four…NTSB ERA16LA119Accident · No injuriesLimited investigationFinal reportPiper PA28 151 · St. Augustine, FLThe flight instructor's overpriming of the engine during start, which resulted in a carburetor fire. Contributing to the severity of accident was the flight instructor's failure to follow the Pilot Operating Handbook's engine fire during start emergency…NTSB DCA16WA099Incident · No injuriesForeign investigationBombardier DHC8 · Calgary, Alberta, CanadaThe Transportation Safety Board (TSB) of Canada has notified the NTSB of an incident involving a Bombardier DHC8-402 that occurred on February 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…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 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 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 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 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 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 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 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 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 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 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 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.NTSB DCA14WA086Incident · No injuriesForeign investigationEmbraer ERJ 190 100 IGW · Kingston, Jamaica