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 FTW96FA183Accident · 4 fatalField investigationFinal reportPiper PA-28-151 · Vera, OKimproper installation by unknown person(s) of incorrect exhaust system clamps, which led to an exhaust system disconnect and a subsequent engine compartment fire.NTSB SEA96LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Jordan, UTimproper installation of the airplane's carburetor fuel lines by maintenance personnel.NTSB MIA96LA080Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Boynton Beach, FLan engine loss of power and fire for undetermined reasons.NTSB LAX96TA046Accident · No injuriesFinal reportPiper PA-28-181 · Edwards, CAthe pilot's failure to completely release the parking brakes prior to taxi, which produced a brake over temperature condition and brake fire.NTSB SEA96LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Salt Lake City, UTa carburetor fire.NTSB CHI96LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Anderson, INinadequate maintenance in that an engine oil line was not properly tightened after routine maintenance. A factor was the disconnected oil line.NTSB BFO96IA012Incident · No injuriesIncident investigationFinal reportPiper PA-23 · Beckley, WVan in-flight fire (behind the right side of the instrument panel), which occurred for undetermined reason(s).NTSB BFO96LA009Accident · No injuriesLimited investigationFinal reportAerostar Raven S49A · Ark, VAthe flight instructor's improper procedures while inflating the balloon using an external fuel source, and the fuel leak.NTSB MIA95LA227Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Vero Beach, FLFailure of company maintenance personnel to comply with a required airworthiness directive, resulting in an in-flight fire and emergency landing. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB MIA95LA215Accident · 1 fatalLimited investigationFinal reportBeech E-18S · Atlantic Ocean (Atlantic Ocean)Undetermined.NTSB SEA95LA194Accident · No injuriesLimited investigationFinal reportCessna 421 · Creswell, ORthe company mechanic's failure to properly fabricate a fuel line.NTSB BFO95LA081Accident · No injuriesLimited investigationFinal reportBeech 55 · Mansfield, OHthe inflight and postimpact fire due to a short circuit in the main power distribution cable.NTSB MIA95LA190Accident · No injuriesLimited investigationFinal reportMaule MX7-235 · Polk City, FLA fire for an undetermined reason(s).NTSB ATL95LA109Accident · No injuriesLimited investigationFinal reportCessna 188 · Red Springs, NCInadequate maintenance that overlooked corrosion of the exhaust manifold, which resulted in an exhaust manifold leak, an in flight fire, and a complete loss of engine power.NTSB ATL95FA099Accident · 2 fatalField investigationFinal reportSchlagenhauf Lancair IV · Gastonia, NCAn in-flight fire of undetermined origin that resulted in a loss of control and impact with the ground.NTSB CHI95LA234Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Michigan City, INreason for the occurrence was undetermined.NTSB FTW95FA184Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Porter, TXThe pilot's failure to identify the unsafe condition created by carrying a battery with jumper cables attached in the baggage compartment and the ensuing fire in the baggage compartment.NTSB ATL95LA091Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Huntsville, ALA loose wire which shorted between an exposed terminal on the avionics bus relay and the oil line to the oil pressure gage, and the failure of maintenance personnel to tie up loose wires.NTSB FTW95LA154Accident · No injuriesLimited investigationFinal reportBeech G18S · Springdale, AREngine compartment fire due to undetermined reasons.NTSB FTW95LA127Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124 · Denver, COAn oxygen leak at the oxygen system pressure reducer-regulator assembly, resulting in a crew compartment fire.NTSB MIA95LA069Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · St. Augustine, FLThe improper adjustment of the turbocharger inlet pipe securing clamp by unknown maintenance personnel.NTSB FTW95LA089Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Amarillo, TXAn inflight fire, the reason for which was undetermined.NTSB ATL95LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Foley, ALAn engine fire for undetermined reasons.NTSB NYC95FA027Accident · 1 fatalField investigationFinal reportCessna 195A · Broadview Hts, OHthe improper installation of a cabin heater system, resulting in an in-flight fire and subsequent loss of control and collision with trees.NTSB CHI95IA028Incident · No injuriesIncident investigationFinal reportBoeing 747-251B · Chicag0, ILinattentive maintenance service of the airplane by the mechanic who failed to disengage the constant speed drive (CSD) after the engine runup had been completed. A factor in this incident was the lead mechanic not performing maintenance record keeping after…NTSB ATL95FA007Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Newville, ALFailure of maintenance personnel to properly install the marmon clamp on the discharge side of the turbocharger.NTSB FTW95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fredericksburg, TXImproper maintenance resulting in an engine fire, and the pilot's improper propeller feathering procedure, causing the propeller not to feather and the airplane's engine out capability to be exceeded. A factor was the unsuitable terrain conditions.NTSB LAX95LA005Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAan in-flight engine compartment fire for undetermined reasons.NTSB FTW95LA012Accident · No injuriesLimited investigationFinal reportCessna 172H · Moro, AREngine compartment fire due to undetermined reasons.NTSB LAX94LA283Accident · Minor injuriesLimited investigationFinal reportMeyers ME 200 · Chico, CAA separation of the exhaust pipe from the cabin heat control valve and the lack of insulation on electrical wiring between the ammeter and the avionics bus.NTSB LAX94LA268Accident · 1 fatalLimited investigationFinal reportRockwell S2-R · Firebaugh, CAThe pilot's loss of aircraft control as a result of incapacitation from an in-flight sulfur fire.NTSB BFO94FA121Accident · 3 fatalField investigationFinal reportBeech 58TC · St Marys, WVAn in-flight fire of undetermined origin, prior to the in-flight breakup.NTSB FTW94IA198Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Caddo, OKThe fuel nozzle drain leak due to a defective o-ring.NTSB CHI94LA198Accident · No injuriesLimited investigationFinal reportBeech 18 · Belleville, MIthe failure of the fuel line on the unique STC'd engine installation. A related factor is the improper installation of a fuel line by company maintenance personnel.NTSB LAX94LA247Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Bakersfield, CAThe in-flight fire due to the spontaneous combustion of sulfur dust and subsequent forced landing. A factor was the high temperature.NTSB SEA94FA124Accident · 2 fatalField investigationFinal reportRyan Navion L-17B · Olympia, WAAn inflight fire for an undetermined reason.NTSB ATL94FA093Accident · 1 fatalField investigationFinal reportNord 1101 · Spartanburg, SCThe pilot's failure to maintain adequate airspeed while maneuvering for an emergency landing. A factor in the accident was an inflight fire from an undetermined source.NTSB FTW94LA130Accident · No injuriesLimited investigationFinal reportBeech 95 · Greeley, COA failure of the right engine propeller governor oil line which was the incorrect line and improperly installed by maintenance personnel.NTSB CHI94IA134Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-200 · Chicago, ILa loose fuel nozzle.NTSB MIA94LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sebring, FLThe failure of the muffler in flight for unknown reasons, allowing hot exhaust gasses to impinge on the carburetor igniting the fuel and the subsequent fire.NTSB FTW94IA099Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72 · Dfw Airport, TXThe blocked numer 1 engine drain manifold.NTSB LAX94LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Phoenix, AZThe loose main fuel line 'b' nut due to the improper installation of the right engine by company maintenance personnel.NTSB CHI94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Newberry, MIan engine fire which started as the result of an oil leak around the engine oil filter.NTSB ATL94LA042Accident · No injuriesLimited investigationFinal reportCessna 182D · Donalsonville, GAThe pilot's failure to clear the induction systems of excessive fuel.NTSB CHI94IA066Incident · No injuriesIncident investigationFinal reportBritish Aerospace ATP · South Bend, INan internal failure of the auxiliary power unit.NTSB NYC94LA041Accident · No injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, MEA disconnected fuel line with the carburetor not installed, and improper dispatch of the aircraft.NTSB FTW93LA266Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe fuel leak which resulted from the mechanic's improper installation of the fuel line. A factor was the lead mechanic's inadequate post run up inspection.NTSB ANC93IA183Incident · No injuriesIncident investigationFinal reportCessna 180C · Anchorage, AKA frayed fuel hose.NTSB BFO93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Williamson, WVA fire in the cockpit area for undetermined reasons.NTSB LAX93LA325Accident · No injuriesLimited investigationFinal reportGlassair SH-2R · Bakersfield, CAThe improper maintenance by the pilot the night before the accident which resulted in an oil line leak near the airplane's exhaust system.