# Fatal NTSB investigations, Outside the U.S.: Aerodynamic stall/spin

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 GAA24WA270](https://openairdocs.org/ntsb/GAA24WA270.md): Piper PA18 · Defford, United Kingdom · Accident · 1 fatal · Class 4 · Foreign · Aug 27, 2024 · G-CUBX · Destroyed
- [NTSB GAA24WA122](https://openairdocs.org/ntsb/GAA24WA122.md): Beech C90 · Santa Rosa de Osos, Colombia · Accident · 4 fatal · Class 3 · Foreign · Mar 21, 2024 · HK4684 · Destroyed
- [NTSB ERA21WA118](https://openairdocs.org/ntsb/ERA21WA118.md): Beech 95 · Porto Nacional, Brazil · Accident · 6 fatal · Class 5 · Foreign · Jan 24, 2021 · PT-LYG · Substantial damage
- [NTSB CEN18WA279](https://openairdocs.org/ntsb/CEN18WA279.md): Cessna 150 · Tortola, British Virgin Islands · Accident · 1 fatal · Foreign investigation · Jul 18, 2018 · N66778 · Substantial damage
- [NTSB CEN18FA063](https://openairdocs.org/ntsb/CEN18FA063.md): Cessna 208 · Punta Islita, Costa Rica · Accident · 12 fatal · Field investigation · Final report · Dec 31, 2017 · TI-BEI · Destroyed
  > The flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…
- [NTSB CEN16WA226](https://openairdocs.org/ntsb/CEN16WA226.md): Zivko Aeronautics Edge 540 · Kyviškes, Lithuania · Accident · 1 fatal · Foreign investigation · Jun 16, 2016 · N13VU · Destroyed
- [NTSB ERA14WA393](https://openairdocs.org/ntsb/ERA14WA393.md): Cessna 340A · Freeport, Bahamas · Accident · 4 fatal · Foreign investigation · Aug 18, 2014 · N340MM · Destroyed
- [NTSB CEN14WA535](https://openairdocs.org/ntsb/CEN14WA535.md): Alpi Pioneer · Evora, Portugal · Accident · 2 fatal · Foreign investigation · Apr 30, 2014 · CS-UOV · Destroyed
  > On April 30, 2014, at 1851 coordinated universal time, an Alpi Aviation Pioneer 300J airplane, Portuguese registered CS-UOV, impacted terrain after a low pass near the Evora Airport (LPEV), Evora, Portugal. The two pilots were fatally injured and the airplane…
- [NTSB ERA13WA296](https://openairdocs.org/ntsb/ERA13WA296.md): Extra Flugzeugbau EA-330SC · Bolshoye Gryzlovo, Russia · Accident · 1 fatal · Foreign investigation · Jun 2, 2013 · RA-0327G · Substantial damage
- [NTSB CEN13WA311](https://openairdocs.org/ntsb/CEN13WA311.md): Saab 91C · Söderhamn, Sweden · Accident · 1 fatal · Foreign investigation · Jun 1, 2013 · SE-KVZ · Substantial damage
  > On June 1, 2013, at 1215 universal coordinated time, a SAAB model 91C (Safir) airplane, Swedish registration SE-KVC, collided with terrain shortly after takeoff from the Söderhamn Airport (ESNY), near Söderhamn, Sweden. A postimpact fire destroyed the…
- [NTSB ERA09WA335](https://openairdocs.org/ntsb/ERA09WA335.md): Piper Aerostar 6 · Minga Guazu, Paraguay · Accident · 1 fatal · Foreign investigation · Jun 9, 2009 · N601RP · Substantial damage
  > On June 9, 2009, at 1903 local time, a Piper PA-60, N601RP, was destroyed during collision with terrain and a post crash fire on approach to Guarani International Airport (SGES), Minga Guazu, Paraguay. The pilot was fatally injured. Instrument meteorological…

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '241' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/241/sequence?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.