# NTSB investigations, 2017: Near midair/TCAS alert/loss of separation

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 DCA18IA026](https://openairdocs.org/ntsb/DCA18IA026.md): Boeing 737-932ER · Atlanta, GA · Incident · No injuries · Class 3 · Incident · Final report · Nov 29, 2017 · N852DN · No damage
  > The flight crewmembers’ failure to properly monitor the airplane’s flightpath, which caused the approach to become unstabilized and resulted in the airplane’s descent below the decision altitude while misaligned with the localizer course. Contributing to the…
- [NTSB DCA17WA172](https://openairdocs.org/ntsb/DCA17WA172.md): Boeing 787-9 · Madrid, Spain · Incident · No injuries · Foreign investigation · Aug 8, 2017 · N825AA · No damage
  > The government of Spain has notified the NTSB of an incident involving a BOEING 787-9 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB DCA17WA113](https://openairdocs.org/ntsb/DCA17WA113.md): Boeing 737 · Palma de Mallorca, Spain · Incident · No injuries · Foreign investigation · Apr 20, 2017 · EC-JBK · 2 aircraft · No damage
  > The Comision de Investigacion de Accidenties E Incidentes de Aviacion Civil of Spain has notified the NTSB of an incident involving a CESSNA 510 airplane that occurred on April 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB DCA17WA107](https://openairdocs.org/ntsb/DCA17WA107.md): Airbus A320 · New Delhi, India · Incident · No injuries · Foreign investigation · Apr 17, 2017 · VT-IDB · No damage
  > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…

## 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '260' 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/260/sequence?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.