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 GAA21WA265AccidentClass 5 · ForeignPiper PA-19 · Lille Marcq en Baro, FranceNTSB ERA21LA309Accident · Serious injuriesClass 3 · LimitedFinal reportEnstrom 280 · Colchester, VTAn in-flight fire originating in the engine compartment near the turbocharger from a source that could not be determined, which resulted in a loss of engine power and led to an autorotation and a hard landing.NTSB ENG21WA033IncidentClass 5 · ForeignBoeing 747-8F · Hone Kong, Hong Kong SAR ChinaNTSB GAA21WA252Incident · No injuriesClass 5 · ForeignDiamond HK36 · Locarno, SwitzerlandNTSB CEN21LA211Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Spring, TXAn engine fire that resulted from a fuel leak into the carburetor air box due to the electric fuel pump over-pressurizing the carburetor needle/seat assembly. Contributing to the severity of the fire was the flight instructor’s failure to turn off the…NTSB ENG21LA023IncidentClass 3 · LimitedFinal reportBombardier CL-600-2C10 · North Canton, OHMoisture ingression thru the window humpseal coming into contact with the terminal block braid wires.NTSB ERA21LA211Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Burlington, VTA fire that originated in the right main landing gear brake assembly for reasons that could not be determined based on the available information.NTSB ENG21WA019IncidentClass 5 · ForeignBoeing 747 · Dubai, United Arab EmiratesNTSB GAA21WA041Incident · No injuriesClass 5 · ForeignAirbus Helicopters AS355 · Buckinghamshire, United KingdomNTSB DCA21WA090Incident · No injuriesClass 4 · ForeignBoeing 767-316 · Panama City, PanamaNTSB DCA21WA177Incident · No injuriesClass 5 · ForeignBoeing 777 · London, United KingdomNTSB CEN21LA129Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC42-550FG · Larned, KSThe pilot’s failure to allow sufficient time for the brakes to cool after a previous aborted takeoff, resulting in a runway excursion during a second aborted takeoff due to degraded braking performance. Contributing to the accident was the contact of the hot…NTSB ENG21LA013IncidentClass 3 · LimitedFinal reportBoeing 767-338 · Ontario, CAThe fatigue fracture and liberation of two airfoils from a low pressure turbine stage 5 nozzle segment that impacted and damaged the downstream low pressure stage 5 blades creating an initial imbalance load in the engine’s low pressure turbine rotor…NTSB ERA21LA099Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA 40 · Portsmouth, NHThe instructor’s multiple applications of the airplane’s brakes during high-speed taxi over a short duration, which overheated and ignited the right main landing gear wheel brake assembly.NTSB GAA21WA128Incident · No injuriesClass 5 · ForeignCessna 525 · Port Moresby, Papua New GuineaNTSB CEN20LA336Accident · 2 fatalClass 3 · LimitedFinal reportCirrus SR22 · Osage Beach, MOAn in-flight fire and subsequent loss of airplane control shortly after takeoff. The source of the in-flight fire or the reason for the loss of airplane control could not be determined based on the available information.NTSB ERA20LA285Accident · Serious injuriesClass 3 · LimitedFinal reportLake LA4 · West Palm Beach, FLAn on-ground engine fire, the source of which could not be determined based on the available evidence.NTSB ENG20LA043Incident · No injuriesClass 3 · LimitedFinal reportBombardier CL-600-2D24 · Charlotte, NCThe windshield failed due to arcing from an inadequate solder connection at the anti-ice power terminal block.NTSB DCA20WA128Accident · No injuriesForeign investigationBoeing 777 · Shanghai, ChinaThe Civil Aviation Administration (CAAC) of China has notified the NTSB of an accident involving a Boeing 777, which occurred on July 22, 2020. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13 as the State…NTSB WPR20LA228Accident · No injuriesClass 3 · LimitedFinal reportMd Helicopter 600 · San Andreas, CAThe failure of the output shaft of the overrunning clutch inner race due to frictional overheating of the shaft, which resulted from the failure of the output bearing’s stainless-steel grease seal.NTSB ENG20WA039Incident · No injuriesForeign investigationHawker Siddeley HS125 · Port Harcourt, NigeriaOn July 16, 2020 a Hawker-Siddeley (Textron Aviation), powered by two Honeywell TFE731 5R-1H turbofan engines experienced a No. 1 (left engine) audible fire warning during cruise. The flight crew declared an emergency and made an uneventful landing at Port…NTSB GAA20WA131Accident · No injuriesForeign investigationDaher TB10 · Visby, SwedenThe government of Sweden has notified the NTSB of an accident involving a DAHER TB10 airplane that occurred on June 19, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB CEN20LA208Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Fargo, NDFailure of the engine driven fuel pump which led to a fuel leak and subsequent fire in the engine compartment.NTSB ENG20RA030Incident · No injuriesClass 5 · ForeignAirbus A320 · Budapest, HungaryimportNTSB CEN20LA058Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Bandera, TXThe in-flight electrical fire, which resulted in smoke in the cabin and an emergency landing. Contributing to the accident was the unsuitable terrain for the emergency landing.NTSB WPR20FA051Accident · No injuriesClass 3 · FieldFinal reportCirrus SF50 · Santa Monica, CAThe improper design of the audio interface system, which caused an electrical short circuit that led to a ground fire.NTSB ENG20IA006Incident · No injuriesClass 3 · IncidentFinal reportDe Havilland DHC8 · Keene, NHThe arcing failure of the windshield heat L2 power wire on the right windshield due to unknown reasons.NTSB GAA20WA123Incident · No injuriesForeign investigationBombardier CL600 2B19 · Madrid, SpainThe government of Spain has notified the NTSB of an accident involving a BOMBARDIER CL600 2B19 airplane that occurred on November 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the…NTSB ENG20WA008Incident · No injuriesForeign investigationAirbus A321 · Raipur, IndiaThe AAIB of India has notified the NTSB of an incident involving an Airbus A321 airplane with CFMI CFM56-5 engines that occurred on November 8, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB DCA20WA009Incident · No injuriesForeign investigationBoeing 737 · Paris, FranceThe BEA of France has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of France's investigation under the provisions of ICAO Annex…NTSB ENG20WA007Incident · No injuriesForeign investigationBAE AVRO146RJ · Cape Town, South AfricaOn October 9, 2019, a South African Airlink British Aerospace Avro 146-RJ85, registered in South Africa as ZS-TCP, experienced a No. 3 engine fire warning on departure from Cape Town International Aerodrome, Cape Town, South Africa. The airplane is equipped…NTSB DCA20WA001Incident · No injuriesClass 4 · ForeignBoeing 767 · Bamako, MaliNTSB CEN19LA324Accident · No injuriesClass 3 · LimitedFinal reportBest Off Skyranger · Duncan, OKA fire during the engine run-up for undetermined reasons.NTSB ENG19WA035Incident · No injuriesForeign investigationBoeing B777 200ER · Lahore, Pakistan, PakistanOn September 15, 2019, while in flight at approximately 5 miles northwest of Lahore, Pakistan, the pilot of a Pakistani International Airlines Boeing 777-200ER, registration AP-BGK, powered by two General Electric GE90 turbofan engines, initiated a Mayday…NTSB WPR19LA259Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Marana, AZExcessive fuel pressure and temperature throughout the fuel system due to heat soaking, which resulted in an engine fire during engine start.NTSB DCA19WA216Incident · No injuriesForeign investigationAirbus A321 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Airbus A321 airplane that occurred on September 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…NTSB CEN19LA314Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Colorado Springs, COThe pilot's improper taxi speed and his excessive use of brakes, which resulted in a brake fire and substantial thermal damage to the airplane.NTSB DCA19WA211Accident · No injuriesForeign investigationAirbus A330 · Beijing, ChinaThe government of China has notified the NTSB of an incident involving a AIRBUS A330 airplane that occurred on August 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…NTSB WPR19LA237Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Eugene, ORThe failure of the landing gear electric motor to shut off after landing gear retraction, which resulted in the motor overheating, burning out, and producing smoke in the cockpit. The pilot’s decision to land with the landing gear retracted resulted in…NTSB ERA19FA251Accident · Serious injuriesField investigationFinal reportCirrus SR22 · Tappahannock, VAThe pilot's inability to land on the runway in dark night conditions with reported smoke in the cockpit, which necessitated the deployment of the airplane's parachute system.NTSB ENG19WA030Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Warsaw, PolandThe government of Poland has notified the NTSB of an incident involving a Boeing (McDonnel-Douglas) MD-11F operated by UPS and powered by three Pratt & Whitney PW 4460 turbofan engines. During cruise, the No. 2 engine (right) experienced fluctuations and…NTSB DCA19WA202Incident · Minor injuriesForeign investigationBoeing 767 · Shannon, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions of ICAO…NTSB ENG19RA038Incident · No injuriesForeign investigationRaytheon 390 · Hamburg, GermanyOn August 7, 2019, about 1408 coordinated universal time (UTC), a Raytheon 390 Premier 1A airplane, Czech Republic registration OK-EJH, experienced smoke/fire in the cockpit from the windshield heat system during takeoff from Hamburg Airport, Hamburg,…NTSB ENG19WA031Incident · No injuriesForeign investigationAirbus A321 · Valencia, SpainThe government of Spain has notified the NTSB of an incident involving a AIRBUS A321 airplane that occurred on August 5, 2019 operated by British Airways. The airplane was powered by two International Aero Engines V2533-A5 turbofan engines. During landing, it…NTSB WPR19LA189Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV14 · Aumsville, ORAn inflight fire that originated in the engine compartment for reasons that could not be determined based on available evidence.NTSB DCA19WA190Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe Air Accident Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…NTSB DCA19WA181Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex…NTSB ENG19RA027Accident · No injuriesForeign investigationAerospatiale AS355 · Dryden, Ontario, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving an Aerospatiale AS355 F2 rotorcraft that occurred on June 19, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the TSB under the provisions…NTSB DCA19WA148Accident · 41 fatalForeign investigationSukhoi RRJ95 · Moscow, RussiaThe MAK of Russia has notified the NTSB of an accident involving a Sukhoi RRJ95 airplane that occurred on May 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the MAK's investigation under the provisions of ICAO Annex 13 as State of…NTSB ENG19WA024Incident · No injuriesForeign investigationBoeing 767 · London, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 767-322, which occurred on April 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…