# NTSB investigations, 2017: Alertness/Fatigue

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 CEN18FA053](https://openairdocs.org/ntsb/CEN18FA053.md): Cessna T210M · Oldenburg, IN · Accident · 3 fatal · Field investigation · Final report · Dec 17, 2017 · N761YZ · Destroyed
  > A total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…
- [NTSB ANC18LA005](https://openairdocs.org/ntsb/ANC18LA005.md): Raytheon B200 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Oct 21, 2017 · N363JH · Substantial damage
  > The pilot's failure to extend the landing gear before landing, which resulted in a gear-up landing. Contributing to the accident was the pilot's fatigue and complacency.
- [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 ERA17LA189](https://openairdocs.org/ntsb/ERA17LA189.md): Beech 58 · Augusta, GA · Accident · No injuries · Limited investigation · Final report · May 24, 2017 · N9132S · Substantial damage
  > The pilot’s failure to properly configure the airplane for landing. Contributing to the accident were the pilot’s fatigue and self-induced distractions.
- [NTSB ERA17FA181](https://openairdocs.org/ntsb/ERA17FA181.md): Mitsubishi MU2B · Eleuthera, Bahamas · Accident · 4 fatal · Field investigation · Final report · May 15, 2017 · N220N · Destroyed
  > The pilot's intentional flight into an area of known icing and convective thunderstorm activity, which resulted in a loss of control of the airplane.
- [NTSB ERA17LA096](https://openairdocs.org/ntsb/ERA17LA096.md): Beech 200 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 27, 2017 · N60RA · Substantial damage
  > The pilot's failure to ensure that the landing gear were down and locked before touchdown. Contributing to the accident was the pilot’s self-reported fatigue at the time of the accident.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020135'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/020135/cases?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.
