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 ERA12LA217Accident · No injuriesLimited investigationFinal reportCessna 310K · Olive Branch, MSFuel leaking from the left engine fuel strainer onto electrical connections after engine start, which resulted in a fire.NTSB WPR12LA113Accident · No injuriesLimited investigationFinal reportHaycraft Sport Hornet · Mariposa, CAImproper clearance and inadequate heat shielding between engine components and the exhaust system, which resulted in an in-flight fire.NTSB ENG12IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-10-30F · Portland, ORThe fracture of the fan mid shaft due to a stress corrosion cracking initiated by local regions of corrosion pitting, which resulted from oil migration within the shaft and its subsequent degradation.NTSB ENG12IA010Incident · No injuriesIncident investigationFinal reportBoeing 767 · Jamaica, NYThe failure of the American Airlines aviation maintenance technicians to properly reassemble the two-piece bracket and spray shield on the integrated drive generator fuel-oil heat exchanger that caused a fuel leak that sprayed out and ignited on hot engine…NTSB CEN12FA100Accident · 4 fatalField investigationFinal reportCessna 421C · Sioux Falls, SDThe pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…NTSB ENG12IA004Incident · No injuriesIncident investigationFinal reportBombardier CL600 2C10 · Atlanta, GAThe Start Operability Bleed Valve (OBV) fuel return adapter-fitting fractured and separated in cyclic fatigue, which allowed fuel to spill onto a hot engine case that ignited the undercowl fire. The OBV fuel adapter-fitting was dropped and the damage reduced…NTSB CEN12CA035Accident · Minor injuriesData collectionFinal reportHouts Avid Mark IV · Hibbing, MNThe improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.NTSB CEN11LA669Accident · Serious injuriesLimited investigationFinal reportOwen Vans RV-10 · Marietta, OHThe in-flight engine fire and loss of engine power due to an improperly installed fuel injector nozzle during a recent engine overhaul.NTSB WPR11RA480Incident · No injuriesForeign investigationAirbus A319 · Hassi Messaoud, AlgeriaOn September 22, 2011, about 2300 Coordinated Universal Time (UTC), Air France flight 558, an Airbus A319, F-GRXN, declared an emergency during cruise flight following an indication of smoke in the lavatory. The crew and passengers were not injured, and the…NTSB ERA11CA474Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe student pilot's landing at an unapproved location, which resulted in a ground fire from the engine exhaust.NTSB ERA11LA469Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 180A · Lewiston, METhe separation of the inflation tank gas line due to an improperly positioned valve o-ring. Contributing to the accident was the use of an unapproved inflation tank.NTSB CEN11LA574Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-310 · Perryton, TXThe explosion and subsequent fire in the airplane for undetermined reasons because an examination of the burned airplane could not identify any preaccident anomolies.NTSB DCA11WA090Incident · No injuriesForeign investigationBoeing 777 · Cairo, EgyptOn July 29, 2011, a Boeing B777-200, registration SU-GBP, operated by EgyptAir, experienced a fire in the right hand lower portion of the cockpit area, adjacent to the electronic flight bag and an electrical power panel. The aircraft was in the process of…NTSB DCA11RA087Accident · 2 fatalClass 5 · ForeignBoeing 747 · Jeju Island, South KoreaNTSB CEN11LA504Accident · No injuriesLimited investigationFinal reportQuasar Acft 214SL · Fort Worth, TXA fuel leak in the engine compartment, which resulted in an engine fire.NTSB WPR11WA488Accident · No injuriesForeign investigationEurocopter BO105 · Tari, Papua New GuineaOn July 7, 2011, about 1200 local time, a Eurocopter BO-105C, Papua New Guinea registry P2-LAE, sustained an uncontained engine failure in one of its Rolls-Ropyce 250-C20B engines. A fire consumed the helicopter following a forced landing. The helicopter was…NTSB ENG11IA035Incident · Minor injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAFuel leaking from the fuel flow transmitter that ignited on contact with the engine’s hot cases which resulted in an engine undercowl fire. The fuel leak resulted from the fuel flow transmitter end housing backing off from the main housing, creating a gap…NTSB CEN11FA383Accident · Minor injuriesField investigationFinal reportBoeing B-17G · Oswego, ILAn inadequate repair of the fuel tank that allowed the fuel leak to continue, ultimately resulting in an in-flight fire.NTSB ERA11FA312Accident · 4 fatalField investigationFinal reportBeech 58 · Murphy, NCAn in-flight fire that mostly likely occurred in the right front cockpit area behind the instrument panel and below the glare shield; the origin of the fire could not be determined because of the extensive fire damage.NTSB CEN11LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Frederick, OKAn in-flight fire for undetermined reasons.NTSB CEN11LA327Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Chico, TXThe mechanic's improper installation of the turbocharger's exhaust balance system, which resulted in an in-flight fire.NTSB CEN11FA324Accident · 2 fatalField investigationFinal reportWoodward Harold L Ravin 500 · Conroe, TXAn in-flight smoke event on takeoff and the pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall.NTSB CEN11CA321Accident · No injuriesData collectionFinal reportChang RV-10 · Minford, OHA loose fuel line fitting, which caused a fuel leak and subsequent in-flight fire.NTSB DCA11IA040Incident · No injuriesIncident investigationFinal reportAirbus A320 · New Orleans, LAthe captain's failure to properly recognize and manage the abnormal condition, resulting in it escalating to an in-flight emergency.NTSB DCA11FA072Accident · No injuriesField investigationFinal reportBombardier CL600 2B19 · Phoenix, AZinadequate clearance between the Integrated Drive Generator (IDG) power cables and hydraulic lines in the aft equipment bay that resulted in chaffing of the IDG power cables and hydraulic lines, arcing, and fire.NTSB ENG11IA021Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 402 · Pittsburgh, PAthe flight crew's delay in shutting down the left engine following an engine oil pressure master warning, which led to a hard rub inside the engine that served as an ignition point for a titanium fire. Contributing to the event was a PW150 No. 5 seal design…NTSB ERA11LA179Accident · No injuriesLimited investigationFinal reportBeech C23 · Carrollton, GAThe mechanic's failure to re-connect a fuel line following an annual inspection. Contributing to the accident was the pilot's improper decision to depart with a known mechanical deficiency.NTSB ENG11IA016Incident · No injuriesIncident investigationFinal reportBoeing 757-2Q8 · Minneapolis, MNthe failure of the right engine's fuel control unit to operate correctly when the fuel metering valve became frozen in the full open position because of corrosion on the fuel metering valve slide and sleeve, which caused the engine to be overfueled during…NTSB ERA11LA124Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pittsburg, PAThe pilot’s excessive engine rpm and speed during taxi and subsequent braking, which resulted in a wheel brake fire.NTSB ERA11LA117Accident · No injuriesLimited investigationFinal reportConvair 340-71 · Charlotte AmalieThe captain’s decision to continue the flight with the left engine backfiring, resulting in an engine fire shortly after takeoff. Contributing to the accident were the captain’s decision to continue the flight following a report of black smoke trailing the…NTSB ENG11IA011Incident · No injuriesIncident investigationFinal reportBoeing 737 · San Francisco, CAThe probable cause of the undercowl in-flight engine fire was the insufficient installation torque of the bolts that secure the fuel manifold cover to the fuel manifold. Engine vibrations and fuel pressure cycles caused the bolts to gradually loosen further…NTSB ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.NTSB DCA11WA031Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyOn November 9, 2010, a Boeing 747-400, German registration D-ABVT, operated by Lufthansa, experienced a fire in the APU compartment. There were no injuries, and minor damage to the airplane. This incident is being investigated by the BFU of Germany.…NTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.NTSB DCA10RA092Accident · 2 fatalClass 5 · ForeignBoeing 747-44AF · Dubai, United Arab EmiratesNTSB WPR10CA437Accident · No injuriesData collectionFinal reportHolt Herbert L Long EZ · Afton, WYThe pilot's failure to securely lock the canopy prior to takeoff, which allowed the contents of the cabin to exit the airplane and damage the propeller. Contributing to the severity of the damage was the subsequent fire that ensued.NTSB DCA10IA082Incident · Minor injuriesIncident investigationFinal reportBoeing 767-322 · Chicago, ILthe brake fire after landing was caused by hydraulic fluid leaking on to hot brakes.NTSB ERA10LA387Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33AK · Windsor, VAThe unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.NTSB CEN10CA456Accident · No injuriesData collectionFinal reportLindstrand 69A · Longview, TXThe the pilot's inadvertent movement of the burner assembly off center resulting in an in-flight fire of the skirt and envelope of the balloon. Contributing to the accident was the pilot's attention being diverted to venting the envelope to avoid an obstacle…NTSB ENG10IA041Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe cause of the right wing landing light switch fire is undetermined.NTSB ERA10WA371Accident · 1 fatalForeign investigationRobinson R44 · Novo Horizonte, BrazilOn July 16, 2010, about 1645 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Brazilian registration PR-TNB, operated by Pereira Alvim Participacoes e Empreendimentos Ltda, was destroyed by fire after landing in a cane field at Novo Horizonte,…NTSB ERA10LA357Accident · No injuriesLimited investigationFinal reportBeech 58 · LaGrange, GAThe pilot not allowing sufficient time for fuel spill vapors to dissipate before starting the engine. Contributing to the accident was the inadequate maintenance of the fuel cap.NTSB WPR10LA319Accident · No injuriesLimited investigationFinal reportPridmore Lancair IV · Caldwell, IDThe failure of maintenance personnel to ensure that a hydraulic line fitting was adequately secured during a conditional inspection, which resulted in a leak and subsequent on-ground fire.NTSB WPR10LA308Accident · No injuriesLimited investigationFinal reportHughes 369HS · Paicines, CAAn in-flight fire for undetermined reasons.NTSB ENG10IA038Incident · No injuriesIncident investigationFinal reportBoeing 767 · Athens, GreeceA short circuit involving the light in position L3 on the squib test panel. The specific cause of the short circuit could not be determined.NTSB CEN10LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Wellington, KSA fire of undetermined cause that originated in the airplane's cabin.NTSB CEN10LA295Accident · Minor injuriesLimited investigationFinal reportPitts Aerobatics S-2B · Amarillo, TXThe fracture of the fuel pump housing for undetermined reasons.NTSB WPR10FA264Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Chandler, AZFailure of the maintenance personnel to ensure adequate torque of a fuel line fitting, which resulted in an in-flight fire.NTSB ENG10IA029Incident · No injuriesIncident investigationFinal reportBoeing 757 · Chantilly, VAThe ignition of the J5 power terminal located on the captain’s No. 1 windshield due to a loose electrical connection between the terminal connector lug and its respective terminal block. The loose connection resulted from a missing lock washer that allowed…NTSB ERA10LA210Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Pittsburgh, PAA fire of undetermined origin behind the left instrument panel.