# NTSB investigations, 2017, Outside the U.S.: Part(s) separation from AC

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 DCA17WA205](https://openairdocs.org/ntsb/DCA17WA205.md): Boeing 777 · Osaka, Japan · Incident · No injuries · Foreign investigation · Sep 23, 2017 · PHBQC · Minor damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 777 airplane that occurred on September 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…
- [NTSB DCA17WA098](https://openairdocs.org/ntsb/DCA17WA098.md): Boeing 737 · Dublin, Ireland · Incident · No injuries · Foreign investigation · Apr 11, 2017 · EI-DAS · Minor damage
  > The Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's…
- [NTSB DCA17WA055](https://openairdocs.org/ntsb/DCA17WA055.md): Boeing 737 · Brisbane, Australia · Incident · No injuries · Foreign investigation · Jan 6, 2017 · VH-VUH · Minor damage
  > The Australian Transport Safety Bureau has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on January 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…

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

This list as a web page: https://openairdocs.org/ntsb-events/338/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
