NTSB investigations
357 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '150') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '150') 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 ERA24LA144Accident · No injuriesClass 3 · LimitedFinal reportGlasair Sportsman 2+2 · Fort Meade, FLThe pilot’s inadequate inspection of the airplane following an inflight smoke event, which result in separation of the exhaust pipe and hot exhaust igniting the engine cowling, and a subsequent loss of engine power.NTSB ERA24FA104Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Clearwater, FLAn in-flight engine compartment fire due to a partially loose flexible fuel hose b-nut at the fuel metering unit. Contributing to the severity of the accident was the pilot’s inability to visually identify the destination airport at night, which prolonged the…NTSB DCA24LA079Incident · No injuriesClass 3 · LimitedFinal reportBoeing 747-87UF · Miami, FLMaintenance personnel’s improper installation and inspection of the port M borescope plug, which resulted in an engine fire.NTSB ENG24WA041OccurrenceClass 5 · ForeignBoeing 777 · Karachi, PakistanNTSB WPR24LA030Accident · No injuriesClass 3 · LimitedFinal reportArrow Falcon Exporters UH-1H · Firebaugh, CAAn on-ground fuel fire for reasons that could not be determined due to extensive thermal damage.NTSB ENG24FA003Incident · No injuriesClass 3 · FieldFinal reportBoeing 767-300F · Memphis, TNA high-pressure fuel leak from a gap in the bolted flange interface between the main fuel pump’s fuel crossover supply tube and the hydromechanical unit idler adapter pad, which resulted in the crossover tube flange bolts partially pulling out and allowing…NTSB DCA23LA468Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Denver, COOverheated brakes due to the extended taxi at a higher power setting in an attempt to burn off fuel to achieve the proper takeoff weight that resulted in a wheel fire during takeoff.NTSB CEN23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportRans S6 · LIberty, MOThe inflight fire and impact with terrain for reasons that could not be determined due to extensive fire damage.NTSB ENG23WA037IncidentClass 5 · ForeignAirbus A321 · Changi, Singapore, SingaporeNTSB ERA23FA352Accident · 2 fatalClass 3 · FieldFinal reportEurocopter EC135 · Pompano Beach, FLAn inflight fire outside of the engine firewalls, likely from overheating of the No. 1 engine for undetermined reasons, which resulted in a partial tailboom separation.NTSB ERA23LA347Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Knoxville, TNAn in-flight fire that resulted from an inadequate 100-hr inspection, which failed to detect and correct improper electrical cable routing in the engine compartment.NTSB DCA23WA420Incident · No injuriesClass 5 · ForeignAirbus A380 · Johannesburg, South AfricaNTSB CEN23LA294Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Lsa S R L Alpha Trainer · Lee's Summit, MOAn engine fire after landing for reasons that could not be determined.NTSB GAA23WA190Accident · No injuriesClass 5 · ForeignCessna 150 · Gualeguay, Entre Rios, ArgentinaNTSB ENG23LA031Incident · No injuriesClass 3 · LimitedFinal reportBoeing 737-9 · Newark, NJA No. 1 (left) engine fire due a fuel leak that originated from the fuel nozzle 17 b-nut connection that was not properly torqued in accordance with the aircraft maintenance manual procedure.NTSB GAA23WA192Incident · No injuriesClass 5 · ForeignCessna T303 · Naha, JapanNTSB GAA23WA156Incident · No injuriesClass 5 · ForeignCessna 650 · Aalborg, DenmarkNTSB GAA23WA154Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Norman's Cay, BahamasNTSB DCA23WA303Incident · No injuriesClass 5 · ForeignBoeing 777 · Abu Dhabi, United Arab EmiratesNTSB CEN23LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-C33A · Indianola, MSAn in-flight fire for undetermined reasons.NTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…NTSB WPR23LA176Accident · No injuriesClass 4 · LimitedFinal reportAkroTech Giles G-202 · Santa Barbara, CAA fire that resulted from venting fuel coming into contact with hot exhaust surfaces or exhaust gases. Contributing to the fire was the design and location of the main tank fuel vent.NTSB DCA23WA238Incident · No injuriesClass 5 · ForeignBoeing 747 · Nairobi, KenyaNTSB ENG23WA025Incident · No injuriesClass 5 · ForeignAirbus A321 · Cairo, EgyptNTSB GAA23WA109Accident · No injuriesClass 5 · ForeignPiper PA-31-350 · Bournemouth, United KingdomNTSB DCA23WA263IncidentClass 5 · ForeignBoeing 777 · Pacific Ocean, JapanNTSB ERA23FA137Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Lindenhurst, NYAn in-flight fire due to a compromised oil pressure line fitting, which resulted in a collision with terrain during a subsequent emergency landing.NTSB DCA23WA166OccurrenceClass 5 · ForeignBoeing 767-332 · Prestwick, United KingdomNTSB CEN23LA099Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-160 · Eau Claire, WIThe engine fire that began for undetermined reasons following numerous engine start attempts.NTSB ERA23LA118Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Raleigh/Durham, NCThe pilot's flooding the engine with fuel during a cold engine start, which resulted in an engine fire.NTSB CEN23FA079Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-301T · Kingfisher, OKAn oil leak of undetermined origin that resulted in an in-flight engine compartment fire and subsequent loss of airplane control.NTSB ERA23LA100Accident · No injuriesClass 3 · LimitedFinal reportFoutz Robert V Cozy Mark IV · Dublin, VAA fire of undetermined origin during an attempted engine restart while taxiing.NTSB WPR23FA044Accident · 1 fatalClass 3 · FieldFinal reportGallagher XLT-RG · Banning, CAAn inflight engine fire for reasons that could not be determined that resulted in impact with terrain.NTSB ENG23WA010Incident · No injuriesClass 5 · ForeignDassault/Sud FAN JET Falcon SER D · Toluca, Mex, MexicoNTSB ERA23LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Manassas, VAAn engine fire caused by chafing and subsequent electrical arcing of the alternator wire near a fuel source.NTSB GAA23WA028Incident · No injuriesClass 5 · ForeignBeech 200 · Oxfordshire, United KingdomNTSB DCA23WA042Incident · No injuriesClass 5 · ForeignBoeing 737 · Kitchener, CanadaNTSB WPR22LA219Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TR182 · Davis, CAAn in-flight fire during the initial takeoff climb for reasons that could not be determined based on the available evidence.NTSB ERA22LA224Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Somerville, TNThe inadequate inspection and maintenance of the engine exhaust system, which resulted in an in-flight fire.NTSB GAA22WA157Accident · Serious injuriesClass 5 · ForeignBeech BE58 · Kununurra, AustraliaNTSB ENG22WA026Incident · No injuriesClass 5 · ForeignAirbus A320 · Tambon Nong Prue, ThailandNTSB ENG22LA020IncidentClass 3 · LimitedFinal reportBombardier BD-700-2A12 · West Palm Beach, FLAn in-flight engine fire resulted from a fuel leak from fuel nozzle No. 16 pigtail-to-fuel manifold b-nut connection that contacted hot engine parts and ignited. Contributing to the manifold fuel leak was the misalignment between fuel manifold female ferrule…NTSB ENG22LA049IncidentClass 3 · LimitedFinal reportBombardier Global 7500 · Riyadh, Saudi ArabiaAn in-flight engine fire resulted from a fuel leak from fuel nozzle No. 18 pigtail-to-fuel manifold b-nut connection that contacted hot engine parts and ignited. Contributing to the manifold fuel leak was the misalignment between fuel manifold female ferrule…NTSB DCA22WA173IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomNTSB GAA22WA122Accident · No injuriesClass 5 · ForeignCessna 182 · Tumeremo, VenezuelaNTSB CEN22LA122Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Eldorado, ILOverheating of two lithium batteries in the paramedic’s flight suit pocket resulting in an explosion and fire that seriously injured the paramedic as the helicopter was about to take off.NTSB GAA22WA090Accident · No injuriesClass 5 · ForeignPiper PA28 · Port Alfred, South AfricaNTSB DCA22WA067Incident · No injuriesClass 5 · ForeignBoeing 787 · Warsaw, PolandNTSB ANC22LA007Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe improper installation of an avionics wire harness over a fuel line, which resulted in chafing of the wire harness, arcing, and a subsequent fire.NTSB GAA22WA014AccidentClass 5 · ForeignCessna 525 · Belgrade, Serbia