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 FTW00LA231Accident · No injuriesLimited investigationFinal reportCessna T210L · Addison, TXthe electrical wire bundle fire during approach, which tripped the hydraulic motor circuit breaker resulting in collapse of the landing gear on landing.NTSB DEN00LA103Accident · No injuriesLimited investigationFinal reportCessna 185B · Moab, UTThe fire in the engine compartment for unknown reason.NTSB ANC00IA063Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Tanana, AKAn in-flight oil leak due to the deterioration of oil filter adapter plate gasket material, and the supplier's distribution of inadequate material. A factor associated with the accident was the engine manufacturer's inadequate quality control.NTSB NYC00IA131Incident · No injuriesIncident investigationFinal reportBeech BE-58 · Windsor Locks, CTInadequate screw length information provided by the manufacturer, which allowed an inadvertent installation of a holding screw that was too long, and the subsequent fracture of the switch/circuit breaker. Factors included a short circuit of the beacon motor,…NTSB MIA00LA079Accident · No injuriesLimited investigationFinal reportBeech D50E · Myrtle Beach, SCThe on-ground fire caused by fuel flowing out the fuel vent and near the exhaust of the left engine resulting in the on-ground fire and substantial damage to the airplane. A finding in the investigation was that all four fuel tanks had been filled before the…NTSB MIA00LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberry, SCa fire in the cockpit caused by the exhaust muffler, which resulted in a forced landing in a field, and subsequent impact with a berm.NTSB NYC99IA231Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYDeteriorated wire insulation and shorting at a short radius bend to the electrical wiring in the right side alternate static port heater, which resulted in electrical arcing and a fire sustained by overlaying thermal acoustic insulation.NTSB ATL99LA103Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Woodstock, GAA loose connection between the fuel line fitting and the burner assembly which resulted in a fire.NTSB CHI99LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · Cloquet, MNa fire which initiated from an undetermined origin.NTSB CHI99FA164Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Great Bend, KSthe chafed through turbocharger oil supply hose, the failure of maintenance personnel to install a clamp on the turbocharger oil supply hose, and the inability of the pilot to maintain aircraft control.NTSB CHI99LA139Accident · No injuriesLimited investigationFinal reportCessna 182C · Loraine, ILA fuel system related fire in the engine compartment.NTSB LAX99FA106Accident · Minor injuriesField investigationFinal reportCessna 172N · El Monte, CAAn in-flight fuel fire in the left forward doorpost due to an electrical arc from an adjacent map light switch puncturing a main fuel feed line. The manufacturer's inadequate design in routing the fuel line in close proximity to electrical arc sources in the…NTSB ATL99LA047Accident · No injuriesLimited investigationFinal reportBalloon Works AX-8 · Beech Island, SCThe pilot's failure to follow the balloon checklist that resulted in a ground fire that destroyed the balloon envelope.NTSB MIA99LA068Accident · No injuriesLimited investigationFinal reportCessna 310N · Clearwater, FLa ground fire in the left wing due to an undetermined ignition source.NTSB LAX99LA063Accident · Serious injuriesLimited investigationFinal reportRichard Young Harmon Rocket II · Esparto, CAThe owner's inadequate condition (annual) inspection, which failed to detect a loose fuel pump output line attachment fitting, which resulted in an in-flight fire. A factor in the hard landing and ground loop was the pilot's inability to see through the smoke…NTSB FTW99LA054Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Dfw Airport, TXA passenger sustained a hairline fracture during an emergency evacuation of the airplane.NTSB MIA99FA038Accident · No injuriesField investigationFinal reportBoeing 747-259B · Miami, FLa fire that started under the fuel truck's cab from an undetermined fuel leak, resulting in fire damage to the airplane.NTSB ATL99FA016Accident · 1 fatalField investigationFinal reportCessna 152 · Daytona Beach, FLAn interior cabin fire of undetermined origin. A factor was the power lines impacted during the emergency descent.NTSB MIA99LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Lawrenceville, GAA fire from an undetermined origin.NTSB MIA98LA228Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Ruleville, MSA fire of undetermined origin.NTSB CHI98LA266Accident · No injuriesLimited investigationFinal reportCessna R182 · Bismarck, NDThe fatigue failure of the fuel system line fitting.NTSB NYC98LA114Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Strasburg, PAA fire of undetermined origin.NTSB CHI98LA127Accident · Serious injuriesLimited investigationFinal reportBoeing 727-227 · Chicago, ILthe passenger initiated evacuation of the airplane. A factor was the auxiliary power unit fire.NTSB FTW98LA182Accident · No injuriesLimited investigationFinal reportFroberg Rotorway Executive · Sand Springs, OKThe failure of the owner/pilot to complete maintenance on the helicopter.NTSB CHI98LA114Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Benton, MOan engine fire for undetermined reasons.NTSB FTW98FA156Accident · 2 fatalField investigationFinal reportBell 206-A · Rio Hondo, TXThe engine compartment fire due to undetermined reasons, which resulted in the in-flight separation of the tailboom.NTSB FTW98LA131Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Lafayette, LAThe unsecured squat switch wires located in the nose gear that were crimped (damaged) when the landing gear was retracted and shorted, resulting in an in-flight fire. A factor was the failure of the landing gear to extend during the emergency descent/landing.NTSB ATL98LA012Accident · No injuriesLimited investigationFinal reportRoebuck Rans S-10 Sakota · Columbia, SCthe airplane builder's improper routing of vinyl/plastic cooling/vent line(s) for the engine oil system, and improper materials supplied by the manufacturer, which led to overheating of the line(s) in the engine compartment and an in-flight fire.NTSB CHI98LA041Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Burlington, KSan undetermined event resulting in the door seal inflation pump catching fire, the pilot's failure to close the cockpit air vents allowing heat and flames from the airplane's nose section to melt electrical wiring behind the instrument panel, and the pilot…NTSB MIA98LA028Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCimproper installation of an auto battery cable which led to an in-flight fire due to the chaffed cable.NTSB NYC97LA190Accident · No injuriesLimited investigationFinal reportBeech 58TC · E. Farmingdale, NYthe pilot's improper starting procedure, which led to an engine fire; and his failure to follow the emergency checklist, which contributed to the level of damage that the airplane received.NTSB CHI97LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft L2A · Shelbyville, INthe inadequate preflight by the pilot and the loose fuel line fitting.NTSB ANC97LA093Accident · No injuriesLimited investigationFinal reportDouglas DC-4 · Venetie, AKA fire associated with the number 2 engine for undetermined reasons.NTSB FTW97LA309Accident · No injuriesLimited investigationFinal reportBeech F33A · Monroe, LAan electrical short, which burned a hole in a fuel line, and subsequent fire from the burning fuel.NTSB FTW97IA222Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-12 · Dallas, TXthe engine fire during descent resulting from a loose, leaking fuel transfer tube due to improper installation and alignment of the transfer tube's retaining clip. Contributing factors were the inadequate design of the clamp, the failure of the operator to…NTSB ATL97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sparta, TNA fire in the left engine started by a leak in the fuel pump.NTSB MIA97LA159Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · San Juan, PRan on ground engine fire in the No. 3 (right) engine resulting from a failed heat exchanger, and subsequent fuel leak. A factor in this accident was the cabin crew's improper handling of the evacuation which resulted in serious injury to a passenger.NTSB FTW97IA160Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Colorado Spgs, COAn oil leak around the APU aft bearing seal which resulted in a fire in the APU exhaust.NTSB ANC97LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Quinhagak, AKA disconnected exhaust manifold collector, improper maintenance of the airplane by company maintenance personnel, and the pilot's poor judgement in electing to initiate another flight after observing smoke in the cockpit.NTSB MIA97LA134Accident · No injuriesLimited investigationFinal reportNavion A · Quincy, FLchafing of an electrical cable that was routed through the firewall, which resulted in electrical arching and an in-flight fire.NTSB NYC97LA068Accident · No injuriesLimited investigationFinal reportCessna 650 · Buffalo, NYA combination hydraulic fluid and fuel-fed fire which originated from electrical arcing, due to the lack of an adequate production standard from Cessna for the separation of flammable fluid lines and electrical lines. A factor was the lack of oversight from…NTSB ATL97LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Memphis, TNfailure of maintenance personnel to properly inspect (and repair) the brake assembly, which allowed a subsequent brake fluid leak and eventual fire.NTSB SEA97FA034Accident · 2 fatalField investigationFinal reportDouglas DC-3C · Boise, IDA fire within the right engine compartment of undetermined cause and the pilot-in-command's failure to maintain airspeed above the aircraft's minimum control speed. A factor contributing to the accident was the dark night environmental conditions.NTSB DCA96MA079Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas DC-10-10CF · Newburgh, NYan in-flight cargo fire of undetermined origin. (NTSB Report AAR-98/03)NTSB LAX96FA284Accident · 1 fatalField investigationFinal reportCessna 210M · Corning, CAimproper installation of an electrical component, during an alteration of the aircraft electrical system; and subsequent electrical insulation failure, which resulted in electrical shorting, arcing, and an electrical fire. Factors relating to the accident…NTSB CHI96LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Parker, SDengine compartment fire from accumulated fuel in the carburetor, and failure of the pilot to follow the emergency checklist procedure.NTSB LAX96LA233Accident · 1 fatalLimited investigationFinal reportVan Horn Velocity · Goodyear, AZan engine compartment fire, which originated in flight from loose fuel and/or oil lines near the engine's firewall.NTSB CHI96IA191Incident · No injuriesIncident investigationFinal reportBeech 1900 · Lansing, MIthe short in the windshield anti-ice low power braided copper lead wire caused a fire that had resulted from the manufacturer's inadequate design.NTSB SEA96FA094Accident · 2 fatalField investigationFinal reportCessna 320A · Provo, UTA fuel leak most probably ignited by hot exhaust gases from the leaking right engine manifold exhaust system, the decision by the pilots to operate the aircraft with knowledge of the fuel leak, and the pilot-in-command's failure to maintain adequate clearance…NTSB DCA96MA054Accident · 110 fatalClass 1 · MajorFinal reportDouglas DC-9-32 · Miami, FLwhich resulted from a fire in the airplane's class D cargo compartment that was initiated by the actuation of one or more oxygen generators being improperly carried as cargo, were (1) the failure of SabreTech to properly prepare, package, and identify…