# Major NTSB investigations, 2017

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 ERA17MA316](https://openairdocs.org/ntsb/ERA17MA316.md): Eurocopter Deutschland MBB BK 117 · Hertford, NC · Accident · 4 fatal · Class 2 · Major · Final report · Sep 8, 2017 · N146DU · Destroyed
  > A failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…
- [NTSB DCA17IA148](https://openairdocs.org/ntsb/DCA17IA148.md): Airbus A320-211 · San Francisco, CA · Incident · No injuries · Class 1 · Incident · Final report · Jul 8, 2017 · C-FKCK · No damage
  > The flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…
- [NTSB CEN17MA183](https://openairdocs.org/ntsb/CEN17MA183.md): Learjet 35A · Teterboro, NJ · Accident · 2 fatal · Class 1 · Major · Final report · May 15, 2017 · N452DA · Destroyed
  > The pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…
- [NTSB DCA17FA076](https://openairdocs.org/ntsb/DCA17FA076.md): Mcdonnell Douglas MD80 · Ypsilanti, MI · Accident · Minor injuries · Class 1 · Field · Final report · Mar 8, 2017 · N786TW · Substantial damage
  > the jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…

## 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&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.