# NTSB investigations, 2017: 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 OPS18IA003](https://openairdocs.org/ntsb/OPS18IA003.md): Bombardier CL600 2D24 · Medford, OR · Incident · Class 3 · Incident · Final report · Dec 25, 2017 · N162PQ · No damage
  > The incident was caused by the air traffic controller assigning an altitude below the published procedure altitude for the approach segment to be flown prior to the aircraft being established on a published portion of the approach. Contributing to the…
- [NTSB DCA18LA024](https://openairdocs.org/ntsb/DCA18LA024.md): Boeing 777 · Jamaica, NY · Accident · Class 3 · Limited · Final report · Nov 28, 2017 · SU-GDL · 2 aircraft · Substantial damage
  > The air traffic controller's improper instruction to the Egypt Air airplane flight crew to pass in an area where passing is prohibited, which led to a ground collision.
- [NTSB DCA18WA028](https://openairdocs.org/ntsb/DCA18WA028.md): Boeing 737 · Latvia, Latvia · Incident · No injuries · Foreign investigation · Nov 23, 2017 · LNN-II · No damage
  > The Transport Accident and Incident Investigation Bureau of Latvia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 23, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…
- [NTSB OPS17IA021](https://openairdocs.org/ntsb/OPS17IA021.md): Cessna 172S · New Orleans, LA · Incident · Class 3 · Incident · Final report · May 9, 2017 · N520ER · 2 aircraft · No damage
  > The air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.
- [NTSB OPS17IA014](https://openairdocs.org/ntsb/OPS17IA014.md): Embraer S A ERJ 170-200 LR · San Francisco, CA · Incident · Class 3 · Incident · Final report · Feb 16, 2017 · N214NN · 2 aircraft · No damage
  > The local controller's issuance of a landing clearance for runway 28L to the ERJ170, and the subsequent issuance of line up and wait instructions to the A320 for runway 28L, resulting in a runway incursion.

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