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 FTW04LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Cleveland, TXThe in-flight fire that resulted from an electrical arc in the main battery cable near the main power bus. The cause of the arcing event could not be determined.NTSB FTW04IA104Incident · No injuriesIncident investigationFinal reportCessna 414 · Midland, TXThe in-flight wing fire for undetermined reasons.NTSB CHI04LA078Accident · No injuriesLimited investigationFinal reportCessna R182 · Elberfeld, INThe in-flight and on-ground fires in the cabin and engine compartment for undetermined reasons during the flight's cruise and emergency landing.NTSB NYC04LA060Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sanford, MEAn engine fire for undetermined reasons during start-up.NTSB CHI04LA050Accident · No injuriesLimited investigationFinal reportCessna 182A · West Chicago, ILThe inadequate starting and flooded engine procedure used by certified flight instructor while providing instruction to the dual student.NTSB NYC04LA047Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's improper procedure with regard to the cabin heater, which resulted in the over temperature of the heater and subsequent fire.NTSB NYC04IA037Incident · No injuriesIncident investigationFinal reportDassault-Breguet Falcon 50 · Windsor Locks, CTAn in-flight fire, originating from electrical arcing, which subsequently created a hole in an oxygen line.NTSB LAX04FA001Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Corona, CAfailure of the turbocharger exhaust clamp due to a pre-existing weld crack, which allowed the release of high temperature exhaust gasses in the engine compartment, causing an in-flight fire.NTSB MIA03LA118Accident · No injuriesLimited investigationFinal reportCessna 210E · Tallahassee, FLThe arching of the battery electric wire which was chaffing against the main steel braided fuel hose resulting in fire in the engine compartment.NTSB MIA03LA072Accident · Serious injuriesLimited investigationFinal reportMooney M20M · Destin, FLThe inadequate annual/100-hour inspection of the engine by the mechanic for his failure to properly secure the tailpipe assembly to the turbocharger resulting in separation of the tailpipe and subsequent in-flight fire. Contributing factors in the accident…NTSB CHI03IA066Incident · No injuriesIncident investigationFinal reportBombardier BD 100-1A10 · Wichita, KSThe uninterrupted current overload of the cabin outlet system static inverter leading to ignition and sustained fire. The cause of the initiating overload condition could not be determined. Contributing factors were the lack of adequate current overload…NTSB IAD03FA024Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Woodbury, CTAn engine fire for undetermined reasons, which resulted in the pilot's loss of control, and the airplane's subsequent impact with terrain.NTSB MIA03FA024Accident · 2 fatalField investigationFinal reportAaa Aircraft Leasing 192 · Miami, FLThe inflight fire of undetermined origin, which resulted in pilot incapacitation, loss of aircraft control and an inflight collision with a building.NTSB LAX03LA034Accident · Minor injuriesLimited investigationFinal reportCessna T210 L · Williams, AZAn in-flight fire for undetermined reasons.NTSB ATL03LA016Accident · 1 fatalLimited investigationFinal reportChance Vought F4U-4 · Columbia, SCAn in-flight engine fire for undetermined reasonsNTSB ATL02LA174Accident · No injuriesLimited investigationFinal reportBeech B-55 · Jackson, MSThe left wing tank fuel quantity transmitter unit was leaking fuel, and the leaking fuel was ignited by engine exhaust during engine start.NTSB LAX02FA259Accident · No injuriesField investigationFinal reportCessna 172N · Mesa, AZAn electrical fire of unknown origin centered near the circuit breaker/throttle area of the instrument panel.NTSB IAD02FA086Accident · 2 fatalField investigationFinal reportCessna 172S · Plainville, CTAn in-flight engine compartment fire of unknown origin, and a loss of engine power for undetermined reasons. Also causal, was the pilot's failure to maintain airspeed during a turn back to the airfield, which resulted in an inadvertent stall and subsequent…NTSB NYC02FA160Accident · Serious injuriesField investigationFinal reportBoeing 747-256 · Jamaica, NYAn accessory gearbox fire of the number 2 engine, due to hot air bypassing a damaged compressor air seal stack, which resulted in an emergency evacuation.NTSB CHI02LA213Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Malta, ILThe inflight fire and loss of engine power due to undetermined reasons. Factors associated with the accident were the lack of suitable terrain on which to land and the corn crop which was contacted during the landing.NTSB MIA02LA118Accident · No injuriesLimited investigationFinal reportCessna 150D · Louisburg, NCthe failure of the pilot-in-command to follow emergency procedures after smelling smoke that resulted in an electrical fire, damage to the airplane, and a forced landing.NTSB ANC02LA043Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Galena, AKThe pilot's selection of unsuitable terrain for landing which precipitated a grass fire. Factors contributing to the accident were the manufacturer's inadequate design of the helicopter's exhaust system, placing it low to the ground, and terrain conditions…NTSB CHI02LA099Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · South St. Paul, MNA loss of engine power due to an electrical short of the P-lead, and loose fuel line connection as a result of improper maintenance.NTSB FTW02LA098Accident · Serious injuriesLimited investigationFinal reportRepublic P-47N-20-RE · Albuquerque, NMthe pilot/mechanic's failure to properly re-install the engine's #10 cylinder exhaust interconnect tube, which resulted in an in-flight fire and forced landing. Contributing factors were the burned fuel and oil supply lines, which were not fire shielded.NTSB CHI02LA069Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-41 · Indianapolis, INThe passenger fell off the side of the slide during the emergency evacuation. Factors were the emergency evacuation and the erratic ignition exciter.NTSB SEA02FA023Accident · No injuriesField investigationFinal reportBeech 58P · Boise, IDImproper clearance between an alternator wire and a pneumatic line and fuel fumes. The alternator wire chafe and arcing were factors.NTSB IAD02LA020Accident · No injuriesLimited investigationFinal reportCessna 401A · Martinsburg, WVthe owner/mechanic's failure to comply with an Airworthiness Directive, which resulted in a cracked fuel supply line and subsequent in-flight fire.NTSB NYC02LA038Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Wilmington, DEA ruptured oil line, which resulted in oil spraying onto the APU exhaust and a subsequent fire.NTSB CHI01LA284Accident · Minor injuriesLimited investigationFinal reportCameron Balloons Shuttle 90 · Centralia, ILThe balloon envelope fire. A contributing factor was the flammability of the envelope.NTSB LAX01LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Chandler, AZThe failure of maintenance personnel to properly tighten a fuel line fitting during an engine installation resulting in a fuel leak and fire during the maintenance checkflight. A factor in the accident was inadequate inspection of the installation prior to…NTSB MIA01LA171Accident · No injuriesLimited investigationFinal reportLockheed P-38L-5LD · Greenwood, MSthe failure and uncontained separation of supercharger impeller blades for undetermined reasons during normal descent, resulting in a punctured fuel line and the subsequent in-flight engine fire and emergency descent and forced landing to a farm field.NTSB LAX01LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sedona, AZthe induction manifold fire resulting from an engine backfire during engine start. The reason for the engine backfire was not determined.NTSB SEA01LA112Accident · No injuriesLimited investigationFinal reportCessna 150F · Arlington, WAA fire that originated in the aircraft's carburetor.NTSB DEN01LA109Accident · Serious injuriesLimited investigationFinal report2001 Mcgirl Questair Venture · Ogden, UTan in-flight fire, which originated from a fuel leak of unknown origin.NTSB SEA01IA093Incident · No injuriesIncident investigationFinal reportBeech C-99 · Salem, ORA short to electrical wiring while in cruise flight.NTSB SEA01FA085Accident · No injuriesField investigationFinal reportMBB BO-105C · Medford, ORA leaking engine oil outlet line fitting in the #1 engine compartment, resulting in an oil fire in the engine compartment.NTSB FTW01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Washington, OKthe in-flight fire for an undetermined reason, which resulted in a forced landing. A contributory factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA102Accident · No injuriesLimited investigationFinal reportCap 232 · Laporte, TXFailure of the brake system during taxi. A contributing factor was the pilot's decision to continue taxiing after discovering the brakes were not functioning normally.NTSB NYC01IA126Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Newark, OHThe company maintenance personnel's failure to comply with the service bulletin, which resulted in a fuel boost pump leakage and subsequent fire during taxi. A factor was the manufacturer's confusing service bulletin.NTSB DEN01LA077Accident · No injuriesLimited investigationFinal reportBell UH-1H · Zuni, NMa hard landing due to the pilot's failure to maintain aircraft control during autorotation/flare. A factor was the total loss of engine power due to mechanical failure.NTSB MIA01LA097Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Orlando, FLa fire due to a broken and separated turbocharger exhaust which allowed hot exhaust to ignite the engine shroud.NTSB MIA01LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lakeland, FLThe pilot's failure to disengage the parking brake prior to taxi and his failure to stop and investigate the brakes when they malfunctioned during taxi for takeoff resulting in the wheel brakes heating and starting the tires on fire.NTSB ATL01LA026Accident · Serious injuriesLimited investigationFinal reportCessna 172 F · Greenwood, MSAn in-flight fire for undetermined reasons. Finding: A factor is the maintenance modification was performed by company personnel prior to the flight.NTSB IAD01IA017Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Dulles, VAthe operator's inadequate maintenance procedure to disconnect the Omega navigational system, which resulted in coaxial cables being cut and not properly protected. A factor in the incident was the lightning strike.NTSB FTW01FA015Accident · 2 fatalField investigationFinal reportBeech BE-76 · Tulsa, OKthe instructor pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around, which resulted in his loss of control of the airplane. Contributory factors were the engine fire, the pilot's failure to follow the…NTSB ATL01IA001Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Birmingham, ALThe failure of maintenace personnel to follow fleet campaign directive on how to install a certificate holder.NTSB FTW00LA251Accident · No injuriesLimited investigationFinal reportBeech BE58 · Bethany, OKthe fire, which ignited in the engine compartment for undetermined reasons while taxiing.NTSB FTW00LA250Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Farwell, TXThe loss of engine power for undetermined reasons. Factors were the smoke in the cockpit, and the lack of suitable terrain for the forced landing.NTSB CHI00LA278Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Des Moines, IAA hydraulic fluid leak which resulted in a landing gear brake fire.NTSB CHI00LA267Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · North Platte, NEthe brake fire while taxiing for undetermined reasons.