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 ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.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 WPR19LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Hurricane, UTThe mechanic’s failure to properly align the engine exhaust crossover pipe during replacement, and his supervisor’s failure to properly inspect the installation, which resulted in an in-flight fire and the loss of engine power.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 CEN18LA392Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Addison, TXMaintenance personnel’s improper installation of the muffler attachment hardware, which resulted in the muffler separating in flight, thermal damage that interrupted the magnetos’ function, and the subsequent total loss of engine power.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 CEN18LA349Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Minneapolis, MNThe fire during approach for reasons that could not be determined based on the available evidence, which resulted in impact with terrain during approach for a precautionary landing.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 WPR18TA223Accident · No injuriesFinal reportZenair Zenith Stol CH750 · Napa, CAThe pilot's use of fuel below the required octane rating, which caused engine detonation and damage and subsequently led to oil exhaustion and a total loss of engine power in flight. Contributing to the accident was the pilot's inadequate service/maintenance…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 CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot'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 WPR18CA172Accident · No injuriesData collectionFinal reportDornier Alpha JET · Sacramento, CAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s and the flight instructor’s failure to adequately monitor the workload.NTSB CEN18LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Baton Rouge, LAThe improper insulation of the anticollision light wiring, which resulted in the ignition of combustible fuel vapors in the outboard section of the right wing; the source of the fuel leak could not be determined due to fire damage.NTSB CEN18LA213Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Uvalde, TXThe loose oil filter, which resulted in oil starvation and a total loss of engine power in flight.NTSB ERA18WA159Accident · 3 fatalForeign investigationCessna 421B · Rock Sound, BahamasNTSB WPR18LA158Accident · No injuriesClass 3 · LimitedFinal reportRhoads Autogyro MTO Sport · San Manuel, AZThe fracture of the propeller hub due to corrosion pitting along the propeller blade root seat, which led to cracking that was propagated due to high-cycle fatigue.NTSB 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 ANC18LA034Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman TBM-3 · Fort Apache, AZA partial loss of engine power for reasons that could not be determined based on the available information.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 WPR18LA107Accident · Serious injuriesLimited investigationFinal reportCubcrafters CC11-160 · Browns Valley, CAThe pilot’s failure to adequately monitor the environment and maintain a sufficient altitude to avoid power lines.NTSB CEN18FA116Accident · 2 fatalField investigationFinal reportPiper PA 31P · Laredo, TXAn engine malfunction for undetermined reasons and the subsequent loss of control, due to the pilot's improper decision to maneuver the airplane below minimum controllable airspeed and his improper response to the loss of engine power.NTSB 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 GAA18CA115Accident · No injuriesData collectionFinal reportCessna 210 · Sussex, NJThe pilot’s inadvertent landing gear retraction during approach.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 WPR18LA037Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC41 550FG · Oro Valley, AZThe inadequate cooling time between repeated heavy braking applications, which resulted in the brakes overheating and a subsequent brake fire during the aborted takeoff sequence.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 ENG18IA003Incident · No injuriesClass 3 · IncidentFinal reportAirbus A330-243 · Seattle, WAThe loss of control of the left-hand engine and the subsequent thermal damage to the left wing on landing during engine reverse operation was due to a blockage of the variable stator vane torque motor filter that resulted in the engine’s electronic engine…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 GAA18CA011Accident · No injuriesData collectionFinal reportDehavilland DHC 1 · Cedartown, GAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA563Accident · No injuriesData collectionFinal reportPiper PA 22 · Orangeburg, SCA failed main landing gear tire for reasons that could not be determined due to postcrash fire damage.NTSB WPR17LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · TamuningThe pilot's inadequate preflight inspection, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.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 ENG17IA036Incident · No injuriesIncident investigationFinal reportBoeing 757 232 · Las Vegas, NVA No. 1 (left) engine undercowl fire caused by a fuel nozzle installation error during engine overhaul at Delta TechOps. A fuel nozzle b-nut was cross threaded, which allowed fuel to leak on hot engine case surfaces and subsequently ignite.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.