# NTSB investigations, 2016, Outside the U.S.: Air traffic event

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 DCA16WA188](https://openairdocs.org/ntsb/DCA16WA188.md): Boeing 737 · Sofia, Bulgaria · Incident · No injuries · Foreign investigation · Jun 4, 2016 · TC-JGE · No damage
  > The Aircraft Accident Investigation Unit (AAIU) of Bulgaria has notified the NTSB of an incident involving a Boeing 737 that occurred on June 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…
- [NTSB DCA16WA079](https://openairdocs.org/ntsb/DCA16WA079.md): Boeing 737 · Gran Canaria, Spain · Incident · No injuries · Foreign investigation · Jan 7, 2016 · D-ABLB · No damage
  > The Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on January 07, 2016. The NTSB has appointed a U.S. Accredited Representative to…

## 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") = 2016
  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" = '100')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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