# NTSB investigations, 2014, Outside the U.S.: Miscellaneous/other

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 ERA15WA082](https://openairdocs.org/ntsb/ERA15WA082.md): Cessna T207 - A · Piedecuesta, Colombia · Accident · 7 fatal · Foreign investigation · Dec 24, 2014 · HK4892 · Destroyed
  > On December 24, 2014, about 1950 UTC, a Cessna T207A, HK4892, collided with mountainous terrain near Vereda Cabreras, Punto el Guanabanazo, Pescadero Piedecuesta, Santander, Colombia. The commercial pilot and six passengers were fatally injured. The airplane…
- [NTSB DCA15WA013](https://openairdocs.org/ntsb/DCA15WA013.md): Boeing 777 · Dubai, United Arab Emirates · Incident · No injuries · Foreign investigation · Oct 22, 2014 · A6-EMJ · No damage
  > The GCAA of United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on October 22, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO Annex 13 as…
- [NTSB DCA15WA014](https://openairdocs.org/ntsb/DCA15WA014.md): Boeing 737 · Hat Yai, Thailand · Incident · No injuries · Foreign investigation · Aug 20, 2014 · HS-LTL · No damage
  > The Department of Civil Aviation of Thailand has notified the NTSB of an accident involving a Boeing 737 that occurred on August 05, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DCA's investigation under the provisions of ICAO…
- [NTSB ERA14WA296](https://openairdocs.org/ntsb/ERA14WA296.md): Beech 300 · Pucallpa, Peru · Incident · No injuries · Foreign investigation · Jun 10, 2014 · OB-1181P · Minor damage
  > On June 10, 2014, at 1212 universal coordinated time, a Beech 300, Peruvian registration OB-1881P, operated by Aero Transporte S.A., sustained minor damage when its No. 1 engine experienced vibrations and was subsequently shutdown, while on approach to the…
- [NTSB ERA14WA241](https://openairdocs.org/ntsb/ERA14WA241.md): Cessna T210N · Para, Brazil · Accident · 2 fatal · Foreign investigation · Apr 30, 2014 · PR-WCO · Destroyed
  > On April 30, 2014, about 2215 UTC, a Cessna T210N, Brazilian Registration PR-WCO, registered to and operated by Mineradora Bom Jesus Ltda, collided with trees during a go-around from landing at an airstrip located in Para, Brazil. Visual 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 year(c."eventDate") = 2014
  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" = '900' 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/900/sequence?state=OF&year=2014

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