# NTSB investigations, 2012, Outside the U.S.: Unknown or undetermined

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 ERA13WA080](https://openairdocs.org/ntsb/ERA13WA080.md): Piper PA-25-260 · El Viento, Colombia · Accident · 1 fatal · Foreign investigation · Nov 22, 2012 · HK588 · Substantial damage
  > On November 22, 2012, at 1705 Universal Coordinated Time (UTC), a Piper PA-25-260, Colombian registration HK588,operated by Fuminorte Ltda. Fumigaciones Aereas Norte, was substantially damaged when it collided with terrain during an agriculture spraying…
- [NTSB ERA12WA577](https://openairdocs.org/ntsb/ERA12WA577.md): Cessna 172R · Macapá, Brazil · Accident · 1 fatal · Foreign investigation · Sep 9, 2012 · PT-WYK · Destroyed
  > On September 12, 2012, about 2112 universal coordinated time, a Cessna 172R, Brazilian registration PT-WYK, was destroyed when it collided with terrain under unknown circumstances near Macapa ´, Brazil. The non-certificated pilot was fatally injured. The…
- [NTSB CEN12WA562](https://openairdocs.org/ntsb/CEN12WA562.md): Piper PA-38-112 · Bruera, Cheshire, United Kingdom · Accident · 2 fatal · Foreign investigation · Aug 16, 2012 · G-BODP · Substantial damage
  > On August 16, 2012, about 1940 universal coordinated time, a Piper PA-38-112 airplane, United Kingdom registration G-BODP, impacted terrain during an instructional flight near Bruera, Cheshire, United Kingdom. The flight instructor and student pilot were…
- [NTSB CEN12WA528](https://openairdocs.org/ntsb/CEN12WA528.md): Cessna 180G · Kenora, Canada · Accident · Serious injuries · Foreign investigation · Aug 1, 2012 · N4695U · Substantial damage
- [NTSB DCA12WA135](https://openairdocs.org/ntsb/DCA12WA135.md): Agusta A109 · Jiquipilco, Mexico · Accident · 3 fatal · Foreign investigation · Jul 28, 2012 · XA-UQH · Destroyed
  > The Mexican Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an accident involving a AgustaWestland 109SP helicopter that occurred on July 28, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation…
- [NTSB ERA12WA383](https://openairdocs.org/ntsb/ERA12WA383.md): Piper PA-28R-200 · São Paulo, Brazil · Accident · 1 fatal · Foreign investigation · Jun 2, 2012 · PT-KRF · Destroyed
- [NTSB WPR12WA446](https://openairdocs.org/ntsb/WPR12WA446.md): Hughes 369D · Lake Sumner, New Zealand, New Zealand · Accident · 1 fatal · Foreign investigation · May 21, 2012 · ZK-HXZ · Substantial damage
  > On May 21, 2012, at 0200 universal coordinated time, a Hughes 369D, ZK-HXZ, registered to and operated by Way to Go Heliservices, crashed into Lake Sumner, New Zealand, under unknown circumstances. The helicopter sank in 125 meters of water and was not…
- [NTSB ERA12WA372](https://openairdocs.org/ntsb/ERA12WA372.md): Cessna 182 · Veronica, Argentina · Accident · 1 fatal · Foreign investigation · May 19, 2012 · LV-GTF · Substantial damage
  > On May 19, 2012, about 2140 universal coordinated time, a Cessna 182C, Argentina registration LV-GTF, was substantially damaged when it impacted terrain during a missed approach at Veronica Airfield, Veronica, Buenos Aires, Argentina. The foreign certificated…
- [NTSB DCA12WA085](https://openairdocs.org/ntsb/DCA12WA085.md): Boeing 737 · Riga, Latvia · Incident · No injuries · Foreign investigation · May 19, 2012 · YL-BBN · No damage
  > On May 19, 2012, at approximately 0819 locat time, a Boeing 737-500 operated by AirBaltic was climbing after departure from Riga International Airport, and was cleared by ATC to climb to FL230. At the same time, an Airbus 320, operated by Aeroflot perfromed a…
- [NTSB DCA12WA074](https://openairdocs.org/ntsb/DCA12WA074.md): Dornier 228 · Jomson, Nepal · Accident · No injuries · Foreign investigation · May 14, 2012 · 9N-AIG · Destroyed
  > The Nepal Civil Aviation Authority (NCAA) has notified the NTSB of an accident involving a DO-228 that occurred on May 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the NCAA investigation under the provisions of ICAO Annex 13 as…
- [NTSB ERA12WA353](https://openairdocs.org/ntsb/ERA12WA353.md): Embraer EMB712 · Morro do Manduba Guaruja, Brazil · Accident · 2 fatal · Foreign investigation · Apr 26, 2012 · PT-NUH · Substantial damage
  > On April 26, 2012, about 1845 Universal Coordinated Time (UTC), an Embraer 712, Brazilian registration PT-NUH, operated by the Aeroclube de Itanhaem, crashed under unknown circumstances in a dense forest area in Morro do Manduba Guaruja Municipality, Sao…
- [NTSB ERA12WA298](https://openairdocs.org/ntsb/ERA12WA298.md): Agusta A119 · Leningradsky, Russia · Accident · 4 fatal · Foreign investigation · Apr 6, 2012 · RA-01980 · Substantial damage
  > On April 6, 2012, about 1240 Universal Coordinated Time (UTC), an AgustaWestland S.p.A., A119 helicopter, Russian registration RA-01980, crashed onto a frozen lake (Yanisyarvi), Sortavalsk district, Leningradsky region, about 5 KM from camp Chernye Kamni,…
- [NTSB DCA12WA055](https://openairdocs.org/ntsb/DCA12WA055.md): ATR ATR72 · Roshchino, Russia · Accident · No injuries · Foreign investigation · Apr 2, 2012 · VP-BYZ · Destroyed
  > The Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving an ATR-72 that occurred on April 2, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO Annex…
- [NTSB ERA12WA249](https://openairdocs.org/ntsb/ERA12WA249.md): Beech 300 · Puerto Aguiree, Chile · Accident · 8 fatal · Foreign investigation · Mar 22, 2012 · CC-AEB · Destroyed
  > On March 22, 2012, at 0358 UTC, a Beech BE 300, Chilean registration CC-AEB registered to Banco Popular Espanol, S.A. and operated by Inaer Helicopter Chile SA as an air ambulance flight, departed controlled flight at Flight level 280 while in radio contact…
- [NTSB ERA12WA221](https://openairdocs.org/ntsb/ERA12WA221.md): Piper PA-34 · Belém, Brazil · Accident · 3 fatal · Foreign investigation · Feb 25, 2012 · PR-LAB · Substantial damage
  > On February 25, 2012, about 1150 coordinated universal time, a Piper PA-34-220T, Brazilian registration PR-LAB, was substantially damaged when it impacted terrain shortly after departure from Belém-Brigadeiro Protásio de Oliveira Airport (SBJC), Belém,…
- [NTSB CEN12WA138](https://openairdocs.org/ntsb/CEN12WA138.md): Piper PA-31-235 · Powys, Wales, United Kingdom, United Kingdom · Accident · No injuries · Foreign investigation · Jan 18, 2012 · G-BWHF · Substantial damage
  > On January 18, 2012, about 1145 universal time (UTC), a United Kingdom registered Piper PA-31-235, G-BWHF, sustained substantial damage when it impacted terrain near Leighton Welshpool, Powys, Wales, United Kingdom. The pilot and the passenger were fatally…

## 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") = 2012
  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" = '000' 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/000/sequence?state=OF&year=2012

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