# Fatal NTSB investigations, Outside the U.S.: Part(s) separation from AC

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB GAA23WA139](https://openairdocs.org/ntsb/GAA23WA139.md): Cessna 206 · Santa Ana del Yucuma, Bolivia · Accident · 5 fatal · Class 5 · Foreign · Apr 26, 2023 · CP-2625 · Destroyed
- [NTSB GAA22WA173](https://openairdocs.org/ntsb/GAA22WA173.md): Rockwell 690 · Charallave, Venezuela · Accident · 1 fatal · Class 3 · Foreign · Apr 30, 2022 · YV3502 · Substantial damage
- [NTSB CEN19WA289](https://openairdocs.org/ntsb/CEN19WA289.md): Capella XS · San Juan del Puerto, Spain · Accident · 1 fatal · Foreign investigation · Aug 23, 2019 · EC-YTA · Substantial damage
  > On 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…
- [NTSB CEN15WA193](https://openairdocs.org/ntsb/CEN15WA193.md): Rans S6 - ES · Tan Rouge, Réunion · Accident · 2 fatal · Foreign investigation · Mar 30, 2015 · N974GQ · Destroyed
  > On 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…
- [NTSB ERA11WA470](https://openairdocs.org/ntsb/ERA11WA470.md): Piper PA30 · Region del Bio Bio, Chile · Accident · 2 fatal · Foreign investigation · Aug 20, 2011 · CC-CTT · Substantial damage
  > On 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…
- [NTSB CEN09WA612](https://openairdocs.org/ntsb/CEN09WA612.md): Eurocopter AS350 · Barcelona, Spain · Accident · 2 fatal · Foreign investigation · Jun 22, 2009 · EC-IOJ · Destroyed
  > On 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 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
```

This list as a web page: https://openairdocs.org/ntsb-events/338/cases?fatal=1&state=OF

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
