Skip to content

NTSB investigations, 2018, Outside the U.S.

13 cases where the sequence of events included Fire/smoke (non-impact).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

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") = 2018 AND c."eventCountry" <> 'USA' AND 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

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\") = 2018
    AND c.\"eventCountry\" <> 'USA'
    AND 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 year(c."eventDate") = 2018
  AND c."eventCountry" <> 'USA'
  AND 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 ENG19WA011Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on December 10, 2018. An Indigo Airbus A320 experienced an ECAM warning for 'Lavatory Smoke' while descending through FL170 to land Kolkata Airport…Dec 10, 2018 · VT-ITR · No damage NTSB DCA19WA009Incident · Minor injuriesForeign investigationBoeing 737 · Zagreb, CroatiaThe AIN of Croatia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIN of Croatia's investigation under the provisions of ICAO Annex…Oct 2, 2018 · TC-AMP · No damage NTSB CEN18RA397Incident · No injuriesForeign investigationCirrus SF50 · Zurich, SwitzerlandOn September 22, 2018, about 1615 UTC, a Cirrus Design Corporation SF50 VisionJet, N474CG, owned by Southern Aircraft Consultancy Incorporated Trustee, and operated I-FLY AG, c/o Aximos Treuhand AG, experienced an electrical fire in the air conditioning unit…Sep 22, 2018 · N474CG · Minor damage NTSB DCA18WA280Incident · No injuriesForeign investigationBoeing 737 · Los Cabos, MexicoThe government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Aug 18, 2018 · N337PJ · No damage NTSB ERA18WA216Incident · No injuriesForeign investigationCessna 501 · Catamarca, ArgentinaThe government of Argentina has notified the NTSB of an incident involving a CESSNA 501 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…Jul 12, 2018 · LV-CGO · Minor damage NTSB DCA18WA247Incident · No injuriesForeign investigationDouglas DC9 · Chichen Itza, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a Douglas DC9 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…Jul 11, 2018 · N802WA · No damage NTSB DCA18WA229Incident · No injuriesForeign investigationBoeing 737 · Koln, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…Jun 26, 2018 · D-ABKM · Minor damage NTSB ENG18RA032Incident · No injuriesForeign investigationDassault FALCON7X · Singapore, SingaporeThe Singapore TSIB has notified the NTSB of an incident involving a Dassault Falcon 7X, VQ-BLP, which occurred on June 25, 2018. There was a fire in the mechanical service compartment while passengers were on board. The NTSB has appointed a U.S. Accredited…Jun 25, 2018 · VQ-BLP NTSB ERA18WA159Accident · 3 fatalForeign investigationCessna 421B · Rock Sound, BahamasJun 5, 2018 · N421MM · Destroyed NTSB ENG18WA041Incident · No injuriesForeign investigationBoeing 777 · Bangkok, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving a Boeing 777-212 airplane on April 30, 2018. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO Annex 13 as the…Apr 30, 2018 · HS-XBD NTSB DCA18WA137Incident · No injuriesForeign investigationBoeing 737 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…Apr 5, 2018 · unknown · No damage NTSB DCA18WA317Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Budapest, HungaryMar 23, 2018 · OK-TVP · No damage NTSB DCA18WA135Incident · No injuriesForeign investigationAirbus A320 · abeam Cooma Aerodome, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on February 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…Feb 18, 2018 · unknown · No damage