Fatal NTSB investigations, Outside the U.S.

6 cases where the defining event was Part(s) separation from AC.

Cases per year

20092026
Fatal NTSB investigations, Outside the U.S. per year, 2009–2026: 6 cases
20091
20111
20151
20191
20221
20231

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 c.\"eventCountry\" <> 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '338')
  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 GAA23WA139Accident · 5 fatalClass 5 · ForeignCessna 206 · Santa Ana del Yucuma, BoliviaApr 26, 2023 · CP-2625 · DestroyedNTSB GAA22WA173Accident · 1 fatalClass 3 · ForeignRockwell 690 · Charallave, VenezuelaApr 30, 2022 · YV3502 · Substantial damageNTSB CEN19WA289Accident · 1 fatalForeign investigationCapella XS · San Juan del Puerto, SpainOn August 23, 2019, about 1905 hours universal coordinated time, an amateur-built Capella XS airplane, Spanish registration EC-YTA, impacted terrain after an inflight separation of a wing near San Juan del Puerto, Spain. The pilot was fatally injured, and the…Aug 23, 2019 · EC-YTA · Substantial damageNTSB CEN15WA193Accident · 2 fatalForeign investigationRans S6 - ES · Tan Rouge, RéunionOn March 30, 2015, about 0630 universal coordinated time (UTC), a Rans S6-ES airplane, French registration 974-GQ, impacted terrain near Tan Rouge, Reunion. The pilot and passenger on board were fatally injured. The airplane was destroyed. The local flight…Mar 30, 2015 · N974GQ · DestroyedNTSB ERA11WA470Accident · 2 fatalForeign investigationPiper PA30 · Region del Bio Bio, ChileOn August 20, 2011, at 1650 universal coordinated time, a Piper PA-30, Chilean registration CC-CTT, was substantially damaged when it impacted terrain, after its right wing separated in-flight while maneuvering, over Region del Bio Bio, Chile. The pilot and…Aug 20, 2011 · CC-CTT · Substantial damageNTSB CEN09WA612Accident · 2 fatalForeign investigationEurocopter AS350 · Barcelona, SpainOn June 22, 2009 a Eurocopter AS350B3, Spanish registration EC-IOJ was destroyed while filling the fire attack system with water during a fire extinguishing operation. The pilot and passenger both were killed. According to several witness statements, the…Jun 22, 2009 · EC-IOJ · Destroyed