# NTSB investigations, 2017, Outside the U.S.: Controlled flight into terr/obj (CFIT)

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 ERA18WA028](https://openairdocs.org/ntsb/ERA18WA028.md): Cessna 208 · Ngorongoro, Tanzania · Accident · 11 fatal · Foreign investigation · Nov 15, 2017 · 5H-EGG · Substantial damage
  > On November 15, 2017, about 0805 coordinated universal time, Cessna 208B, Tanzanian registration 5H-EGG, operated by Coastal Aviation LTD., was substantially damaged when it impacted terrain near Ngorongoro, Tanzania. The pilot and 10 passengers were fatally…
- [NTSB CEN17WA370](https://openairdocs.org/ntsb/CEN17WA370.md): Cessna 150J · Goderich, Canada · Accident · 2 fatal · Foreign investigation · Sep 21, 2017 · C-FHPU · Substantial damage
  > On September 20, 2017, about 2036 eastern daylight time, a Cessna 150J single-engine airplane, Canadian registration C-FHPU, serial number 15070602, crashed in Lake Huron about 1.1 nautical miles west of Goderich Municipal Airport (CYGD), Goderich, Ontario,…
- [NTSB ERA17WA321](https://openairdocs.org/ntsb/ERA17WA321.md): Piper Piper PA-34-200T · Cerrione, Italy · Accident · 1 fatal · Foreign investigation · Sep 9, 2017 · G-STZA · Destroyed
- [NTSB ERA17WA273](https://openairdocs.org/ntsb/ERA17WA273.md): Bell 206 · Algiers, Algeria · Accident · 4 fatal · Foreign investigation · Aug 10, 2017 · 7T-WUF · Substantial damage
  > On August 10, 2017, about 0930 coordinated universal time, Bell 206L3 helicopter, Algerian registration 7T-WUF, was substantially damaged when it impacted terrain while maneuvering in Algiers, Algeria. The pilot and three passengers were fatally injured. The…
- [NTSB CEN17WA310](https://openairdocs.org/ntsb/CEN17WA310.md): Piper PA28 · Berghaus Diavolezza, Switzerland · Accident · 3 fatal · Foreign investigation · Aug 4, 2017 · HB-PER · Substantial damage
  > On August 4, 2017, at 0720 UTC, a Piper PA-28-181, Swiss registration HB-PER, owned and operated by a private individual, impacted mountainous terrain near Berghaus Diavolezza, Switzerland. The pilot and two passengers on board were fatally injured. A third…
- [NTSB WPR17WA178](https://openairdocs.org/ntsb/WPR17WA178.md): Robinson Helicopter R22 Beta · Cloncurry, Australia · Accident · 1 fatal · Foreign investigation · Aug 2, 2017 · VH-HGU · Destroyed
  > On August 2, 2017, at 0740 local time, a Robinson R22, VH-HGU, was destroyed by a post-impact fire following a collision with power lines during cruise flight near Cloncurry Aerodrome, Australia. The helicopter was operated under the pertinent civil…
- [NTSB CEN17WA289](https://openairdocs.org/ntsb/CEN17WA289.md): Cessna U206 · Culiacan, Mexico · Accident · 7 fatal · Foreign investigation · Jul 23, 2017 · XB-MUM · Substantial damage
- [NTSB CEN17WA214](https://openairdocs.org/ntsb/CEN17WA214.md): Piper PA-28-140 · Sacatepequez, Guatemala · Accident · 1 fatal · Foreign investigation · Jun 1, 2017 · TG-GYV · Destroyed
  > On June 1, 2017, at 1824 coordinated universal time, a Piper PA-24-140, Guatemalan registration TG-GYV, owned by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Volcán de Agua, Departamento de…
- [NTSB ERA17WA192](https://openairdocs.org/ntsb/ERA17WA192.md): Robinson R22 · Kwa-Zulu Natal, South Africa · Accident · 1 fatal · Foreign investigation · May 20, 2017 · ZS-RIT · Substantial damage
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R22 helicopter that occurred on May 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…
- [NTSB CEN17WA175](https://openairdocs.org/ntsb/CEN17WA175.md): Socata-Groupe Aerospatiale TB 20 · Malaga, Spain · Accident · 3 fatal · Foreign investigation · Apr 29, 2017 · D-ECJP · Substantial damage
  > On April 29, 2017, at 1632 UTC, a Socata TB-20, D-ECJP, impacted terrain near Canillas de Aceituno in Malaga, Spain. The aircraft was destroyed, and the pilot and two passengers were fatally injured. The flight departed Mutxamel Airfield (LEMU) in Alicante,…
- [NTSB CEN17WA143](https://openairdocs.org/ntsb/CEN17WA143.md): Aerospatiale AS355 · Snowdonia, United Kingdom · Accident · 5 fatal · Foreign investigation · Mar 29, 2017 · G-OHCP · Destroyed
  > On March 29, 2017, about 1500 coordinated universal time, an Aerospatiale AS355 F1 helicopter, G-OHCP, collided with Rhinog Fawr mountain in Snowdonia, Wales, United Kingdom. The pilot and four passengers were fatally injured.The accident investigation is…
- [NTSB CEN17WA130](https://openairdocs.org/ntsb/CEN17WA130.md): Bell 206 · Figeac, France · Accident · 1 fatal · Foreign investigation · Mar 15, 2017 · F-GPPH · Destroyed
  > On March 15, 2017, about 2100 universal coordinated time (UTC), a Bell 206 helicopter, F-GPPH, impacted terrain near Figeac, France. The pilot was fatally injured and the helicopter was destroyed. The flight originated from Poiters Biard (LFBI), France, and…
- [NTSB CEN17WA213](https://openairdocs.org/ntsb/CEN17WA213.md): Piper PA28 · Petit Bourg, Guadeloupe · Accident · 1 fatal · Foreign investigation · Feb 20, 2017 · F-OGPJ · Destroyed
  > On February 20, 2017, about 1225 UTC, a Piper PA-28-161, French registration F-OGPJ, owned and operated by Aeroclub Les Ailes Guadeloupeenes, collided with a house while conducting low altitude cruise flight near Petit Bourg, Guadeloupe, French Antilles. 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 year(c."eventDate") = 2017
  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" = '120' 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/120/sequence?state=OF&year=2017

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