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 CEN21WA093Accident · No injuriesClass 4 · ForeignCessna 401B · Toussus-le-Noble, FranceNTSB GAA21WA128Incident · No injuriesClass 5 · ForeignCessna 525 · Port Moresby, Papua New GuineaNTSB ERA20LA324Accident · 1 fatalClass 3 · LimitedFinal reportVans RV 8 · Hilliard, FLA total loss of engine power due to oil starvation.NTSB 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 CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.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 ERA20LA212Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA32RT · Selma, ALThe mechanic’s failure to clean the oil suction screen during the most recent maintenance, which resulted in oil starvation and subsequent total loss of engine power.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 ERA20CA036Accident · Minor injuriesData collectionFinal reportPiper PA32 · Venice, FLA stuck brake caliper, which overheated while the pilot was taxiing the airplane, caught fire, and subsequently destroyed the airplane.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 GAA20CA037Accident · No injuriesData collectionFinal reportUltramagic N 250 · Albuquerque, NMThe pilot's failure maintain clearance from power lines, which resulted in an explosion and preimpact fire.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 WPR19TA186Accident · No injuriesClass 3Final reportGlasair SH II · San Bernardino, CAA fuel leak caused by age-degraded fuel hoses, which resulted in a total loss of engine power and fire before takeoff. Contributing to the accident was inadequate maintenance.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 GAA19CA339Accident · No injuriesData collectionFinal reportAir Tractor AT502 · San Benito, TXThe pilot's improper decision to take off with the airplane near its maximum allowable gross takeoff weight and his subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB CEN19FA143Accident · 1 fatalField investigationFinal reportBeech 60 · Loveland, COA loss of control due to an inflight right engine fire due to the loose fuel hose between the engine-driven fuel pump and the flow transducer.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…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 CEN19LA055Accident · 1 fatalClass 3 · LimitedFinal reportBeech 36 · Fredericksburg, TXThe loss of engine power due to fatigue failure of the crankshaft.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…