Skip to content

NTSB investigations, 2012

16 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") = 2012 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\") = 2012
    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") = 2012
  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 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…Dec 2, 2012 · G-VIIK · Minor damage 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.Oct 21, 2012 · N6839R · Substantial damage 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…Oct 19, 2012 · G-GDFJ · Minor damage 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…Oct 14, 2012 · TC-TJK · Substantial damage 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.Sep 21, 2012 · N125PS · No damage 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.Sep 20, 2012 · N265Q · Substantial damage 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.Aug 17, 2012 · N8546P · Substantial damage 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.Jul 29, 2012 · N904DB · Substantial damage 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…Jul 28, 2012 · D-ABOK · No damage 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…Jul 2, 2012 · A6-EGQ · No damage 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.Jun 26, 2012 · N18TN · Substantial damage 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.Jun 25, 2012 · N2528N · Substantial damage 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.Jun 24, 2012 · N9043N · Substantial damage 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.Mar 7, 2012 · N6974L · Substantial damage 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.Feb 21, 2012 · N72PD · Substantial damage 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…Feb 8, 2012 · N360AA · No damage