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 CEN14LA159Accident · No injuriesLimited investigationFinal reportCessna 310Q · Wapakoneta, OHA fire due to a fuel leak of the cabin heater system. Contributing to the accident was the inadequate maintenance of the airplane, which failed to identify leaks in the heater system.NTSB WPR14LA049Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Firefly 10 · Temecula, CAThe pilot's failure to follow the Landing checklist and his inadvertent contact with the blast valve after landing, which released propane that was then ignited by an undetermined source.NTSB ENG14WA003Incident · No injuriesForeign investigationBAE Systems Limit Avro 146-RJ85 · Norwich, Norfolk, UK, United KingdomOn October 24, 2013, a British Aerospace (BAE) 146 experienced an engine fire during a power check at Norwich International Airport (NWI), Norwich, Norfolk, UK. After receiving the fire warning maintenance crews successfully shut down the engine and…NTSB DCA14WA005Incident · No injuriesForeign investigationBoeing 757 223 · Providenciales, Turks & Caicos IslandsThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757, which occurred on October 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB CEN14LA021Accident · No injuriesLimited investigationFinal reportPohoski RV 4 · New Waverly, TXAn in-flight fire for reasons that could not be determined because the wreckage was consumed by fire.NTSB WPR14LA014Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L 1 · Seeley, CAThe total loss of engine power due to the failure of the No. 4 bearing.NTSB CEN13LA561Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Ulysses, KSAn in-flight fire and subsequent loss of engine power for reasons that could not be determined due to extensive fire damage to the airplane and its fuel and electrical systems.NTSB DCA13WA158Incident · No injuriesForeign investigationBoeing 757 223 · San Andreas, ColombiaThe CAA of Colombia has notified the NTSB of an incident involving a Boeing 757-223 airplane that occurred on September 19, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of Colombia's investigation under the provisions of…NTSB CEN13LA490Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Eastport, MIA fuel leak in the engine compartment and subsequent fire, the source of which could not be determined because of extensive postaccident fire damage.NTSB ENG13WA040Incident · No injuriesForeign investigationSikorsky S76 - A · Macae, BrazilWhile the helicopter was running on the runway, the pilots noticed that the number two engine parameters were below prescribed values and decided to abort the take-off. After leaving the runway and entering the company apron, the pilots saw company mechanics…NTSB CEN13WA577Incident · No injuriesForeign investigationCessna Cessna 525B · Paris, FranceOn July 22, 2013, at 0610 UTC, a Cessna 525B Citation CJ3, French registration F-HCIC, experienced smoke in the cabin and cockpit while passing FL 140 during an enroute climb southeast of Paris, France. The number one engine was shut down, the crew declared…NTSB DCA13RA127Accident · No injuriesForeign investigationBoeing 787 · London, United KingdomThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B787 that occurred on July 7, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO Annex…NTSB CEN13LA408Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXThe pilot’s failure to use the proper taxi procedure, which resulted in a brake system fire.NTSB WPR13FA294Accident · 1 fatalField investigationFinal reportCessna 172 · Birdseye, UT***This report was modified on August 18, 2015. Please see the docket for this accident to view the original report.*** The operator's improper installation of a supplemental electrical power supply, which caused a short circuit due to inadequate vibration…NTSB CEN13LA365Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Lansing, MIThe pilot’s failure to follow the airplane checklist, which resulted in the parking brake not being released before taxi and a subsequent brake fire.NTSB DCA13WA104Incident · No injuriesForeign investigationBoeing 747-400 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an incident involving a Boeing 747-400 that occurred on June 9, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB WPR13IA144Incident · No injuriesIncident investigationFinal reportBombardier DHC-8-402 · Danville, CAThe failure and separation of a section of the No. 2 engine's combustion chamber's small exit duct (SED), which created an airflow disruption that led to an engine surge and subsequent fire. Contributing to the accident was the insufficient weld penetration…NTSB DCA13WA113Incident · No injuriesForeign investigationBoeing 737-300 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an incident involving a Boeing 737-300 that occurred on March 1, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB ENG13IA016Incident · No injuriesIncident investigationFinal reportBoeing 747 · Dallas, TXFuel leaking from a fractured fuel manifold feeder line that ignited on contact with the engine’s hot compressor rear frame, which resulted in an engine undercowl fire. The fuel manifold feeder line failed due to high amplitude fatigue because the fuel…NTSB DCA13IA037Incident · No injuriesClass 1 · IncidentFinal reportBoeing 787 · Boston, MAan internal short circuit within a cell of the auxiliary power unit (APU) lithium-ion battery, which led to thermal runaway that cascaded to adjacent cells, resulting in the release of smoke and fire. The incident resulted from Boeing's failure to incorporate…NTSB DCA13WA160Incident · No injuriesForeign investigationBoeing Boeing 777-236 · Shannon, IrelandThe Air Accident Investigations Unit of Ireland has notified the NTSB of an incident involving a Boeing 777 that occurred on December 02, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU-I investigation under the provisions of…NTSB ERA13LA048Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pahokee, FLA main landing gear wheel fire for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operations.NTSB DCA13WA005Incident · No injuriesForeign investigationBoeing 737 · Glasgow, United KingdomOn October 19, 2012, at 0655 UTC time, a Boeing 737-800, registration G-GDFJ, operated by Jet2.com as a scheduled passenger flight LS177 between Glasgow, Scotland and Alicante, Spain, rejected the takeoff due to smoke in the cabin. The aircraft stopped on the…NTSB DCA13RA001Accident · Serious injuriesForeign investigationBoeing 737 · Antalya, TürkiyeThe Directorate General of Civil Aviation (DGCA), of the Republic of Turkey, has notified the NTSB of an accident involving a Boeing 737-800 that occurred on October 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA…NTSB CEN12IA662Incident · No injuriesIncident investigationFinal reportCanadair CL-600 Challenger · Denver, COThe internal failure of the galley heater mat’s thermostat, which resulted in an overheat condition.NTSB CEN12LA652Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · (Gulf of Mexico)An in-flight fire, which resulted in the airplane’s forced landing in water. The source of the fire could not be determined because the airplane wreckage was not recovered.NTSB CEN12LA551Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Holton, KSThe mechanic's failure to adequately torque the right magneto attachment nuts, allowing the right magneto to come loose, which allowed engine oil to escape, causing the engine to seize.NTSB CEN12CA496Accident · No injuriesData collectionFinal reportBlack Donald Cozy III · Los Lunas, NMA loose oil line, which allowed oil to leak onto the hot engine turbocharger and resulted in a fire.NTSB DCA12WA117Incident · No injuriesForeign investigationBoeing 757 · Linz, AustriaThe Austrian Civil Aviation Safety Investigation Authority (CASIA) has notified the NTSB of an accident involving a BOEING 757 airplane that occurred on July 28, 2012. The CASIA delegated the investigation to the German Federal Bureau of Aircraft Accidents…NTSB DCA12WA107Incident · No injuriesForeign investigationBoeing 777 · Urumqi, ChinaThe Civil Aviation Authority of China (CAAC) has notified the NTSB of an incident involving a Boeing 777-300 that occurred on July 2, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CAAC investigation under the provisions of ICAO…NTSB CEN12FA395Accident · 1 fatalField investigationFinal reportNappi Tito C Lancair 235M · Monroe Center, ILThe in-flight fire for a reason that could not be determined due to extensive damage from the fire.NTSB ERA12FA412Accident · 1 fatalField investigationFinal reportSocata TB21 · Gold Hill, NCAn inflight fire, the origin of which could not be determined because of postaccident fire damage. Contributing to the accident was the pilot's improper modifications to the airplane.NTSB WPR12LA292Accident · No injuriesLimited investigationFinal reportSikorsky S-58B · Brewster, WAAn in-flight fire during hover for reasons that could not be determined due to the extent of fire damage that subsequently consumed the structure.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 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 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 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 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 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 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.