Skip to content

NTSB investigations, 2023

34 cases where the sequence of events included Fire/smoke (non-impact).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 year(c."eventDate") = 2023 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '150' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 year(c.\"eventDate\") = 2023
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '150' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 year(c."eventDate") = 2023
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '150' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 WPR24LA064Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Spanish Fork, UTMaintenance personnel’s improper installation of the left magneto, which resulted in oil starvation to the engine and a subsequent total loss of engine power.Dec 21, 2023 · N453DS · Substantial damage NTSB ENG24WA041OccurrenceClass 5 · ForeignBoeing 777 · Karachi, PakistanDec 2, 2023 · AP-BMH · No damage NTSB 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.Nov 4, 2023 · N3053Q · Substantial 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…Oct 18, 2023 · N287FE · Minor damage NTSB CEN24LA014Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Saginaw, MIThe failure of the right brake assembly due to excessive brake lining wear, which resulted in a thermally damaged piston O-ring, hydraulic fluid leak, and subsequent fire.Oct 6, 2023 · N969JB · Substantial damage 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.Sep 30, 2023 · N37560 · Substantial damage 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.Sep 15, 2023 · N853HT · Destroyed NTSB ENG23WA037IncidentClass 5 · ForeignAirbus A321 · Changi, Singapore, SingaporeSep 10, 2023 · B305J · Minor damage NTSB 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.Aug 28, 2023 · N109BC · Destroyed NTSB CEN23LA370Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Durant, OKThe loosening of a connecting rod cap nut for reasons that could not be determined, which resulted in a mechanical failure of the engine and an in-flight fire.Aug 21, 2023 · N3589X · Substantial damage NTSB ERA23LA327Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Leipsic, OHThe incorrect assembly of the turbine engine’s reduction gear box second-stage ring gear, which resulted in an internal failure of multiple engine components and a total loss of power.Aug 4, 2023 · N5048S · Substantial damage 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.Jul 27, 2023 · N15417 · Substantial damage NTSB DCA23WA420Incident · No injuriesClass 5 · ForeignAirbus A380 · Johannesburg, South AfricaJul 12, 2023 · G-XLEH · No damage NTSB 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.Jul 8, 2023 · N201ZM · Substantial damage NTSB GAA23WA190Accident · No injuriesClass 5 · ForeignCessna 150 · Gualeguay, Entre Rios, ArgentinaJun 28, 2023 · LV-JQA · Substantial damage NTSB 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.Jun 28, 2023 · N37516 · Minor damage NTSB CEN23LA246Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · College Station, TXThe mechanic’s failure to properly secure the oil suction screen plug during recent maintenance, which resulted in an oil leak and subsequent loss of engine power due to oil starvation.Jun 18, 2023 · N463HP · Substantial damage NTSB GAA23WA192Incident · No injuriesClass 5 · ForeignCessna T303 · Naha, JapanJun 16, 2023 · JA5309 · Substantial damage NTSB GAA23WA156Incident · No injuriesClass 5 · ForeignCessna 650 · Aalborg, DenmarkMay 27, 2023 · OY-JPJ · No damage NTSB GAA23WA154Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Norman's Cay, BahamasMay 26, 2023 · N522AR · Substantial damage NTSB DCA23WA303Incident · No injuriesClass 5 · ForeignBoeing 777 · Abu Dhabi, United Arab EmiratesMay 19, 2023 · A6-ETP NTSB CEN23LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-C33A · Indianola, MSAn in-flight fire for undetermined reasons.May 18, 2023 · N63B · Destroyed 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…May 10, 2023 · N56PA · Destroyed 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.May 2, 2023 · C-GXGS · Substantial damage NTSB DCA23WA238Incident · No injuriesClass 5 · ForeignBoeing 747 · Nairobi, KenyaApr 17, 2023 · 9V-SF0 · Minor damage NTSB ENG23WA025Incident · No injuriesClass 5 · ForeignAirbus A321 · Cairo, EgyptApr 15, 2023 · TC-LSZ · Minor damage NTSB CEN23LA165Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Lsa Sinus · Kingsford, MIThe failure of maintenance personnel to properly secure the left carburetor bowl cover, which resulted in an engine fire before takeoff.Apr 13, 2023 · N413EK · Substantial damage NTSB GAA23WA109Accident · No injuriesClass 5 · ForeignPiper PA-31-350 · Bournemouth, United KingdomMar 28, 2023 · G-FCSL · Substantial damage NTSB DCA23WA263IncidentClass 5 · ForeignBoeing 777 · Pacific Ocean, JapanMar 28, 2023 · 9V-SWQ NTSB 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.Mar 5, 2023 · N8149R · Destroyed NTSB DCA23WA166OccurrenceClass 5 · ForeignBoeing 767-332 · Prestwick, United KingdomFeb 10, 2023 · N197DN NTSB CEN23LA099Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-160 · Eau Claire, WIThe engine fire that began for undetermined reasons following numerous engine start attempts.Feb 5, 2023 · N9770J · Destroyed 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.Jan 23, 2023 · N747PK · Substantial damage 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.Jan 16, 2023 · N8266D · Destroyed