# NTSB investigations, 2014, Outside the U.S.: Sys/Comp malf/fail (non-power)

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 CEN14WA538](https://openairdocs.org/ntsb/CEN14WA538.md): Piper PA12 · Reykjavik, Iceland · Incident · No injuries · Foreign investigation · Aug 12, 2014 · TF-ROD · Minor damage
- [NTSB ERA14WA381](https://openairdocs.org/ntsb/ERA14WA381.md): Piper PA-25-260 · Tolima, Colombia · Accident · Serious injuries · Foreign investigation · Aug 8, 2014 · HK1680 · Substantial damage
  > On August 8, 2014, about 2215 coordinated universal time, a Piper PA-25-260, Colombian registration HK1680, was substantially damaged when it impacted terrain near Tolimo, Colombia. The pilot was seriously injured. The local aerial application flight was…
- [NTSB DCA14WA103](https://openairdocs.org/ntsb/DCA14WA103.md): Airbus A300 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Jun 1, 2014 · N137UP · No damage
  > The Mexican Directorate General of Civil Aviation (DGAC) has notified the NTSB of an incident involving an Airbus A300 operated by United Parcel Service (UPS), that occurred on June 1, 2014. The NTSB has appointed a U.S. Accredited Representative to assist…
- [NTSB WPR14WA128](https://openairdocs.org/ntsb/WPR14WA128.md): Hughes 369D · Moonlight Creek, New Zealand, New Zealand · Accident · No injuries · Foreign investigation · Feb 25, 2014 · ZK-IQQ · Substantial damage
  > On February 25, 2014, at 2055 universal coordinated time, a Hughes 369D, ZK-IQQ, was substantially damaged when the main rotor blades contacted and severed the tailboom at the conclusion of an autorotation and landing near Moonlight Creek, New Zealand. The…
- [NTSB ERA14WA114](https://openairdocs.org/ntsb/ERA14WA114.md): Cessna 140 · Cachoeira do Sul, Brazil · Accident · 2 fatal · Foreign investigation · Jan 29, 2014 · PP-DFW · Substantial damage
  > On January 29, 2014, about 1340 universal coordinated time, a Cessna 140, Brazilian registration PP-DFW, was substantially damaged during impact with terrain, following a loss of control on approach to Cachoeira do Sul Airport (SSKS), Cachoeira do Sul, Rio…

## 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" = '330' 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/330/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.