NTSB investigations
450 cases where the first occurrence was “Fire”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 171) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 171) 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 BFO93LA118Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Flemington, NJThe passenger's inadvertent activation of the burner after the landing, causing the terrain to burn and subsequently igniting the Balloon envelope.NTSB ANC93IA115Incident · No injuriesIncident investigationFinal reportCessna 207 · Nome, AKThe chafed fuel line and chafed electrical wire and the improper maintenance procedure used to secure the electrical wire with a tie wrap.NTSB MIA93LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tampa, FLthe improper welding/repair by maintenence personnel of the exhaust system, which eventually failed allowing hot exhaust gasses and flame to burn a fuel line and start a fire.NTSB LAX93GA270Accident · Minor injuriesFinal reportBell 206L-3 · Agoura Hills, CAThe improper configuration of the aerial ignition device by the crew chief and an inadvertent activation of the unit by the pilot. The improper installation and configuration of the unit by maintenance personnel, inadequate crew coordination, and insufficient…NTSB ATL93IA113Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Savannah, GALeakage of the number 7 fuel nozzle, which resulted in an in flight engine fire.NTSB DEN93FA066Accident · Minor injuriesField investigationFinal reportCessna 310J · Broomfield, COFriction of escaping oxygen under high pressure igniting a lubricant in the nosewheel well area, and improper aircraft servicing by maintenance personnel.NTSB CHI93IA124Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Moline, ILThe passenger's failure to extinguish a cigarette before placing it into the lavatory waste bin. Factors related to the incident were: an inoperative smoke detector in the lavatory, the manufacturer's inadequate maintenance program, and inadequate review of…NTSB LAX93LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Fresno, CAthe improper installation of an electrical wire bundle, and, the chaffing and subsequent arcing of the wires against a fuel line which resulted in a fire.NTSB NYC93LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Danbury, CTThe pilot's improper emergency procedures for an engine fire during starting which resulted in the substantial damage. Factors related to the accident were the pilot's improper starting procedure and his lack of total experience.NTSB LAX93LA083Accident · No injuriesLimited investigationFinal reportRotorway Executive · Chandler, AZAn engine compartment fire for undetermined reasons.NTSB MIA93LA016Accident · No injuriesLimited investigationFinal reportCessna 172N · Ormond Beach, FLA fire of an undetermined source which erupted in the left cabin area during takeoff.NTSB NYC93IA017Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Pittsburgh, PAThe high cycle fatigue failure of blades on the stage 1 high pressure compressor, which resulted in blade fracture and subsequent internal engine damage and fire.NTSB ANC92LA157Accident · No injuriesLimited investigationFinal reportSikorsky S-58G · Port Alsworth, AKInflight engine compartment fire and post landing fire of undetermined origin.NTSB LAX92LA325Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Visalia, CAThe pilot's improper stowage of an aerosol spray can in the cockpit which caused an electrical short and an ensuing fire, and his failure to maintain directional control of the aircraft during the subsequent aborted takeoff.NTSB ANC92LA109Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Mcgrath, AKThe fire in the engine accessory drive assembly. Factor was the rough an uneven forced landing area.NTSB FTW92DRG02Accident · No injuriesFinal reportAero Commander Callair A-9B · Harlingen, TXAn inflight fire due to a loose fuel fitting and fuel line due to improper maintenance.NTSB LAX92LA274Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tulare, CAAn inflight hopper compartment fire due to the incompatibility of the chemical loads, and, the failure of the operator follow the cautionary directives of the chemical manufacturer.NTSB MIA92LA143Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · St. ThomasIn-flight fire for undetermined reasons, and in-flight collision with the water.NTSB NYC92LA124Accident · No injuriesLimited investigationFinal reportCessna 421B · Columbus, OHThe electrical fire which started in a component that was part of a door seal modification. Also causal to the accident was the installation of this unapproved airplane modification.NTSB FTW92DQA02Accident · Serious injuriesFinal reportFantasy Sky Promotions AX-7 · Rio Rancho, NMThe pilot's improper inspection of the balloon following removal of two of the fuel tanks which resulted in vented fuel due to a fuel line being left loose and a fuel valve locked open.NTSB ATL92LA089Accident · No injuriesLimited investigationFinal reportBeech 23A-19 · Orangeburg, SCThe deterioration of the exhaust muffler which resulted in an inflight fire.NTSB MIA92FA114Accident · 1 fatalField investigationFinal reportCessna 401 · New Port Richey, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering for a forced landing following an in flight left engine fire for undetermined reasons. Contributing to the accident was the pilot in command's inadvertent shutdown of the wrong engine.NTSB DEN92IA046Incident · No injuriesIncident investigationFinal reportCessna 310-L · Hugo, COFailure of the left voltage regulator. Factors were: failure of the pilot/mechanic to properly maintain the aircraft, and failure of the right alternator circuit breaker.NTSB FTW92GA111Accident · 1 fatalFinal reportPiper PA-32R-301T · Albuquerque, NMFuel line failure due to vibratory fatigue. Factors were improper maintenance, manufacturer information for fuel line not available, and the pilots' failure to follow emergency procedures.NTSB MIA92IA075Incident · No injuriesIncident investigationFinal reportPiper PA-28-180 · Destin, FLImproper procedures/directives by the pilot-in-command while attempting to restart the engine, resulting in the engine compartment fire.NTSB DEN92IA025Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Denver, COAn electrical short circuit in a main wire bundle due to chafing of the bundle on airframe structural members.NTSB FTW92IA009Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 3100 · Dfw Int'L Arpt, TXThe partial disconnection of the electrical connector at the torque sensing unit.NTSB NYC91LA247Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · East Boston, MAThe malfunction of an electrical component in the cockpit, which resulted in smoke and the subsequent emergency evacuation of the passengers from the airplane.NTSB CHI91DCQ09Accident · No injuriesFinal reportHispano Aviacion HA200 · Liberal, KSA disconnected ignition harness resulting in an inflight fire during maneuvering flight.NTSB SEA91IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 747-151 · Seattle, WAA fire in the number 4 engine, resulting from a fuel leak at the main fuel control unit, due to improper maintenance by unknown/undetermined person. The L5 emergency exit failed to operatee due to a broken plastic pulley guard in the slide release mechanism.NTSB ATL91FA155Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Cartersville, GAThe mechanic's improper replacement of the fuel line b-nut, and the inadequate inspection of the repair work by the quality assurance inspector.NTSB DEN91LA101Accident · No injuriesLimited investigationFinal reportCessna 421B · Colorado Spring, COA fractured fuel line and an improperly performed annual inspection.NTSB FTW91DPG14Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARPartial failure of the hopper, chemical fire, and the failure of the landing gear. A factor ws the loss of visual outside reference.NTSB LAX91LA293Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Shoshone, CAAn electrical short of the battery cable.NTSB SEA91LA123Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · St. Xavier, MTThe pilot's improper use of the fuel system, and the overfilling of the fuel tank. Contributing to the accident was: aerobatics performed, the pilot's inattention and the design of the fuel system.NTSB LAX91LA235Accident · No injuriesLimited investigationFinal reportBeech B95-B55 · Glendale, AZThe pilot's failure to secure the fuel cap during his preflight inspection. As a result, fuel leaked out of the wing tank onto the wing and ignited during the engine start procedures.NTSB LAX91LA233Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Point Magu, CAA short circuit in the airplane's strobe light electrical system which ignited the plastic tubing of the pitot static system causing an inflight fire and subsequent forced landing.NTSB MIA91LA151Accident · Minor injuriesLimited investigationFinal reportBeech 80 · Fort Lauderdale, FLThe improper maintenance work by an unknown person who crossthreaded a fuel nozzle injector fitting which allowed fuel to leak on the exhaust system initiating a fire. No reason for the right engine not to develop full power was found.NTSB LAX91LA195Accident · Serious injuriesLimited investigationFinal reportCessna U206 · Tulare, CAAn in-flight fire in the cabin/crew compartment area of the aircraft, due to failure of a fuel line located in the left doorpost area.NTSB CHI91LA138Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Millard, NEImproper use of APU by unknown personnel which resulted in the airplane's electrical wiring melting and subsequent short.NTSB LAX91LA102Accident · No injuriesLimited investigationFinal reportCurtiss-Wright E-4000 · Watsonville, CAThe inadequate design and length of the tailwheel assembly cable.NTSB ATL91LA045Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAAn electrical short related to the alternator from an undetermined source.NTSB FTW91LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Plano, TXThe pilot's failure to follow the approved start procedures which resulted in an induction fire and the destruction of the airplane.NTSB ATL91LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Summerville, SCAn eroded exhaust stack which allowed hot gases to impinge upon the firewall, and ignite cabin insulation.NTSB NYC91LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Dayton, OHA carburetor fire due to an engine backfire. A factor relating to the accident was improper remedial action taken by the pilot to extinguish the engine fire.NTSB SEA91IA003Incident · No injuriesIncident investigationFinal reportCessna 551 · Elma, WAInadequate inspection of the electrical wire bundle assembly by maintenance personnel, and chafing/burning of the wire bundle.NTSB LAX91FA001Accident · 1 fatalField investigationFinal reportMooney M20K · Flagstaff, AZThe pilot's decision to operate the aircraft with a known discrepancy; inadequate maintenance procedures; and the pilot's inflight loss of control due to smoke and fumes in the cockpit.NTSB NYC90IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · New York City, NYThe exhaust pipe fire in the APU which resulted in an unauthorized evacuation of the airplane by the passengers.NTSB ATL90DKG05Accident · No injuriesFinal reportAyres Bull Thrush · Americus, GAFailure of the engine main oil line which allowed the engine oil to be ignited by the hot engine.NTSB LAX90FA248Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369HS · Modesto, CAIn-flight engine fire of undetermined origin.