# NTSB investigations, 2015, Outside the U.S.: Aircraft structural failure

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 CEN15WA364](https://openairdocs.org/ntsb/CEN15WA364.md): MX MX2 · Châteauneuf-sur-Cher, France · Accident · Minor injuries · Foreign investigation · Aug 16, 2015 · N88MX · Destroyed
- [NTSB ENG15RA012](https://openairdocs.org/ntsb/ENG15RA012.md): Robinson R44 - II · Waikaia, New Zealand · Accident · No injuries · Foreign investigation · Jan 23, 2015 · ZK-HPC · Substantial damage
  > On January 23, 2015, a Robinson R44 II experienced a severe in-flight vibration, after which the pilot successfully landed the helicopter. A subsequent inspection found a crack on one of the main rotor blades. This incident is being investigated by the New…

## 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") = 2015
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '337')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/337/cases?state=OF&year=2015

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
