Skip to content

NTSB investigations, 2015

15 cases where the defining event was 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") = 2015 AND 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

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\") = 2015
    AND 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 year(c."eventDate") = 2015
  AND 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 DCA16FA013Accident · Serious injuriesField investigationFinal reportBoeing 767 · Fort Lauderdale, FLthe separation of the flexible fuel line coupling and subsequent fuel leak due to the failure of maintenance personnel to install the required safety lockwire. Contributing to the severity of the accident was the initiation of the evacuation before the right…Oct 29, 2015 · N251MY · Substantial damage NTSB CEN16LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Century, KSThe pilot’s application of excessive brake pressure to maintain a safe taxi speed during a long, slightly downhill taxi with a strong quartering tailwind, which resulted in a brake fire.Oct 24, 2015 · N8227L · Substantial damage NTSB CEN16LA021Accident · No injuriesLimited investigationFinal reportPiper PA 28-235 · Winneconne, WIAn engine compartment fire during landing, which resulted in extensive fire damage, for reasons that could not be determined during examinations of the remaining wreckage.Oct 24, 2015 · N3979X · Substantial damage NTSB WPR15LA267Accident · No injuriesLimited investigationFinal reportCessna 177 · Thermal, CAA fire in the engine compartment due to the pilot overpriming the hot engine.Sep 24, 2015 · N3416T · Substantial damage NTSB WPR15IA263Incident · Minor injuriesIncident investigationFinal reportCessna T206H · Idaho Falls, IDAn in-flight fire during initial climb due to the separation of the engine's turbocharger wastegate overboard exhaust tailpipe. Contributing to the accident was the owner's decision to not comply with a service bulletin that addressed the tailpipe separation.Sep 21, 2015 · N7269T · Minor damage NTSB ERA15LA369Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Pittsburg, PAAn engine fire, which resulted from the overpriming of a hot engine.Sep 19, 2015 · N9887K · Substantial damage NTSB ERA16WA039Incident · No injuriesForeign investigationCessna 650 · Corlu, TürkiyeOn August 1, 2015, at 2317 coordinated universal time, a Cessna 650; N691BE, incurred minor damage after the main landing gear tires deflated during takeoff roll and a fire ensued in the area of the main landing gear at Tekirdag Çorlu Airport (LTBU), Corlu,…Aug 1, 2015 · N692BE · Minor damage NTSB ENG15WA027Incident · No injuriesForeign investigationAirbus A330 - 323 · Incheon, Republic of Korea, South KoreaOn July 14, 2015 at about 0832 universal coordinated time, an Airbus A330-300, HL8282, operated by Asiana Airlines experienced No. 2 (right) engine fire and oil pressure warnings shortly after takeoff from Incheon International Airport (ICN), Incheon,…Jul 14, 2015 · HL8282 · No damage NTSB WPR15LA180Accident · No injuriesLimited investigationFinal reportMooney M20C · Reno, NVThe in-flight separation of the exhaust tube at a weld joint due to erosion and corrosion, which resulted in a subsequent in-flight fire.Jun 8, 2015 · N7887V · Destroyed NTSB ENG15IA024Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 · Windsor Locks, CTThe arcing failure of the windshield heat power wire on the right windshield due to unknown reasons. Contributing to the severity of the fire was the lack of training or guidance provided to the crew for selecting the windshield heat to off that would cut…Jun 5, 2015 · N363PH · Minor damage NTSB ERA15FA181Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Fort Lauderdale, FLA rapid onset of smoke and/or fire inflight for reasons that could not be determined due to the postimpact fire and the condition of the wreckage.Apr 12, 2015 · N119RL · Destroyed NTSB DCA15WA156Incident · No injuriesForeign investigationBoeing Boeing 737-530 · Zurich, SwitzerlandThe BFU of Switzerland (BFU-CH) has notified the NTSB of an incident involving a Boeing 737-530 airplane that occurred on April 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU-CH's investigation under the provisions of ICAO…Apr 12, 2015 · D-ABJB · No damage NTSB DCA15WA097Incident · No injuriesForeign investigationBoeing 777-306er 300 · Bangkok, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving a Boeing 777-306ER that occurred on March 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Aircraft Accident Investigation…Mar 15, 2015 · PH-BVB · Minor damage NTSB CEN15IA139Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G IV · Eagle, COThe pilot's rejected takeoff due to perceived flight control system anomalies, which led to excessive brake temperatures and resulted in a right main landing gear brake fire.Feb 8, 2015 · N701DB · Minor damage NTSB DCA15WA074Incident · No injuriesForeign investigationBoeing 747 - 406 · Novosibirisk, RussiaThe Republic of South Korea Aviation and Railway Accident Investigation Board (ARAIB) has notified the NTSB of an incident involving a BOEING 747 that occurred on January 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB in…Jan 13, 2015 · HL7417 · No damage