NTSB investigations, 2017, Outside the U.S.

9 cases where the defining event was Fire/smoke (non-impact).

Cases per year

20082026
NTSB investigations, 2017, Outside the U.S. per year, 2008–2026: 156 cases
20083
20092
20106
20113
20125
20138
20148
20155
20169
20179
201813
201918
20205
20218
202210
202313
202412
202515
20264

Latest cases

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 year(c.\"eventDate\") = 2017
    AND c.\"eventCountry\" <> 'USA'
    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.

NTSB DCA18WA020Incident · No injuriesForeign investigationBoeing 777 · Oceanic, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on November 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB-UK's investigation under the provisions of ICAO…Nov 13, 2017 · G-VIIJ · No damageNTSB DCA18WA015Incident · No injuriesForeign investigationBoeing 777 · Adelaide, AustraliaThe government of Australia has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on October 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…Oct 14, 2017 · A6-ETR · No damageNTSB CEN17WA308Accident · No injuriesForeign investigationAmerican Champion 8GCBC · Dunaujvaros, HungaryThe government of Hungary has notified the National Transportation Safety Board (NTSB) of an accident involving an American Champion 8GCBC airplane that occurred on August 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…Aug 4, 2017 · HA-KYL · DestroyedNTSB DCA17WA158Incident · No injuriesForeign investigationBoeing Boeing 777-236 · London, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 777-236 airplane that occurred on July 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation under the…Jul 23, 2017 · G-YMMC · No damageNTSB DCA17WA161Incident · No injuriesForeign investigationBoeing 767 · Newcastle, United KingdomThe UK AAIB has notified the NTSB of an incident involving a Boeing767 airplane that occurred on July 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO Annex 13 as the…Jul 22, 2017 · D-ABUK · Minor damageNTSB DCA17WA126Incident · No injuriesForeign investigationBoeing 777 · Multan, PakistanThe government of Pakistan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on May 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…May 23, 2017 · AP-BGK · No damageNTSB DCA17WA070Incident · No injuriesForeign investigationBoeing 777 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau (AIB) of Saudi Arabia has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on February 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AIB's investigation under…Feb 11, 2017 · YI-AQZ · Minor damageNTSB ENG17WA013Incident · No injuriesForeign investigationBritish Aerospace Avro 146-RJ100 · London, United KingdomThe United Kingdom's Air Accidents Investigation Board (AAIB) has notified the NTSB of an incident involving an AVRO 146-RJ100 that occurred on February 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…Feb 10, 2017 · HB-IXO · No damageNTSB DCA17WA067Incident · No injuriesForeign investigationBoeing 737 · Edinburgh, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's…Feb 3, 2017 · TF-BBB · Minor damage