NTSB investigations
504 cases where the sequence of events included 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 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 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 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 CEN22LA438Accident · No injuriesClass 4 · LimitedFinal reportShirey David A Fisher Celebrity · Haskell, OKThe inflight fire for reasons that could not be determined.NTSB CEN22FA433Accident · 1 fatalClass 3 · FieldFinal reportAirgyro AG915 · Yankton, SDA loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.NTSB CEN22LA430Accident · No injuriesClass 3 · LimitedFinal reportAgusta AW139 · Houma, LAThe inflight loss of collective control of the helicopter due to thermal damage of a collective control torque tube that abraded with misrouted electrical wiring, which resulted in an electrical short and inflight fire. Contributing to the accident were the…NTSB CEN22LA356Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 150A · Indianola, IAThe pilot’s failure to maintain clearance from power lines during low-level maneuvering.NTSB CEN22LA334Accident · Minor injuriesClass 3 · LimitedFinal reportVan's RV-10 · Beaver Dam, WIThe improperly secured spark plug boot that resulted in smoke in the cockpit and a subsequent off-airport landing.NTSB ERA22LA317Accident · No injuriesClass 3 · LimitedFinal reportCessna T210F · Monticello, NYMaintenance personnel’s improper torque of the engine through-bolts during maintenance, which resulted in a bearing shift, oil starvation, and a total loss of engine power.NTSB 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 CEN22LA256Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Madison, MSThe failure of a muffler weld due to inadequate maintenance, which resulted in a fire.NTSB CEN22LA253Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T206H · Austin, TXA total loss of engine power due to an engine fire that resulted from failure of the turbocharger exhaust clamp, which allowed hot exhaust gases to damage other vital engine components.NTSB ERA22LA275Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Gulf Shores, ALThe improper maintenance of the brake system, which resulted in the brakes overheating and catching fire and subsequent substantial damage to the airplane.NTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…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 CEN22LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Twin Lakes, COThe failure of the left turbocharger at FL230, which resulted in a rapid loss of manifold pressure and subsequent complete loss of engine power due to an overly rich fuel-air mixture setting. Contributing was the smoke in the cabin in IMC, which caused the…NTSB 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 CEN22LA072Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL18 · Abbeville, LAAn electrical fire for reasons that could not be determined.NTSB 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, SerbiaNTSB ENG22LA002Incident · Minor injuriesClass 3 · LimitedFinal reportAirbus A320-271N · Atlantic City, NJThe ingestion of a bird into the right engine during the takeoff roll caused a fan blade to fracture near the blade platform resulting in high fan blade off loads and engine vibrations sufficient to result in an eventual failure of a fuel tube in the right…NTSB GAA21WA265AccidentClass 5 · ForeignPiper PA-19 · Lille Marcq en Baro, FranceNTSB ERA21LA309Accident · Serious injuriesClass 3 · LimitedFinal reportEnstrom 280 · Colchester, VTAn in-flight fire originating in the engine compartment near the turbocharger from a source that could not be determined, which resulted in a loss of engine power and led to an autorotation and a hard landing.NTSB WPR21LA294Accident · No injuriesClass 3 · LimitedFinal reportKuykendall Charles Lancair IV · Indian Springs, NVAn in-flight fire due to an undetermined electrical malfunction.NTSB ENG21WA033IncidentClass 5 · ForeignBoeing 747-8F · Hone Kong, Hong Kong SAR ChinaNTSB GAA21WA252Incident · No injuriesClass 5 · ForeignDiamond HK36 · Locarno, SwitzerlandNTSB ERA21FA253Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Buckingham, PAAn exhaust system leak that resulted in failure of the oil quick drain, a loss of oil lubrication, an in-flight fire, and the pilot’s subsequent loss of airplane control.NTSB CEN21LA211Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Spring, TXAn engine fire that resulted from a fuel leak into the carburetor air box due to the electric fuel pump over-pressurizing the carburetor needle/seat assembly. Contributing to the severity of the fire was the flight instructor’s failure to turn off the…NTSB GAA21WA085Accident · No injuriesClass 5 · ForeignCessna 550 · Eelde, NetherlandsNTSB ENG21LA023IncidentClass 3 · LimitedFinal reportBombardier CL-600-2C10 · North Canton, OHMoisture ingression thru the window humpseal coming into contact with the terminal block braid wires.NTSB ERA21LA211Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Burlington, VTA fire that originated in the right main landing gear brake assembly for reasons that could not be determined based on the available information.NTSB ENG21WA019IncidentClass 5 · ForeignBoeing 747 · Dubai, United Arab EmiratesNTSB GAA21WA041Incident · No injuriesClass 5 · ForeignAirbus Helicopters AS355 · Buckinghamshire, United KingdomNTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB DCA21WA090Incident · No injuriesClass 4 · ForeignBoeing 767-316 · Panama City, PanamaNTSB DCA21WA177Incident · No injuriesClass 5 · ForeignBoeing 777 · London, United KingdomNTSB CEN21LA129Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC42-550FG · Larned, KSThe pilot’s failure to allow sufficient time for the brakes to cool after a previous aborted takeoff, resulting in a runway excursion during a second aborted takeoff due to degraded braking performance. Contributing to the accident was the contact of the hot…NTSB ENG21LA013IncidentClass 3 · LimitedFinal reportBoeing 767-338 · Ontario, CAThe fatigue fracture and liberation of two airfoils from a low pressure turbine stage 5 nozzle segment that impacted and damaged the downstream low pressure stage 5 blades creating an initial imbalance load in the engine’s low pressure turbine rotor…NTSB ERA21LA099Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA 40 · Portsmouth, NHThe instructor’s multiple applications of the airplane’s brakes during high-speed taxi over a short duration, which overheated and ignited the right main landing gear wheel brake assembly.