# NTSB investigations, 2017: Oversight of operation

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 CEN17LA350](https://openairdocs.org/ntsb/CEN17LA350.md): Embraer EMB 120ER · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Sep 13, 2017 · N121CZ · Substantial damage
  > The bus driver's failure to maintain clearance from the standing airplane during dark night conditions. Contributing to the accident was the airport's lack of an escort for the bus.
- [NTSB ANC17LA051](https://openairdocs.org/ntsb/ANC17LA051.md): Leonardo AW139 · Tujunga, CA · Accident · No injuries · Class 3 · Limited · Final report · Sep 2, 2017 · N304FD · Substantial damage
  > A yaw excursion and uncontrolled descent due to loss of tail rotor effectiveness during aerial firefighting operations resulting in an impact with trees. A contributing factor was the pilot’s failure to maintain sufficient airspeed, coupled with a quartering…
- [NTSB ANC17FA039](https://openairdocs.org/ntsb/ANC17FA039.md): Cessna U206 · Port Alsworth, AK · Accident · 1 fatal · Class 2 · Field · Final report · Jul 27, 2017 · N1749R · Destroyed
  > The pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was (1) the inadequate preflight…
- [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…

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

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