# NTSB investigations, 2017, KY: Loss of control in flight

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 ERA18FA022](https://openairdocs.org/ntsb/ERA18FA022.md): Piper PA32 · Fountain Run, KY · Accident · 4 fatal · Field investigation · Final report · Nov 12, 2017 · N3371W · Destroyed
  > The noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete…
- [NTSB ERA17LA297](https://openairdocs.org/ntsb/ERA17LA297.md): Tukan Trike · Nicholasville, KY · Accident · 1 fatal · Limited investigation · Final report · Aug 27, 2017 · UNREG · Substantial damage
  > The noncertificated pilot's failure to maintain control of the weight-shift-control aircraft during takeoff.
- [NTSB GAA17CA488](https://openairdocs.org/ntsb/GAA17CA488.md): Charles D Walker Walker Curtiss JN4D · Bowling Green, KY · Accident · Minor injuries · Data collection · Final report · Aug 12, 2017 · N8262 · Substantial damage
  > The pilot’s exceedance of the biplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall and collision with trees.
- [NTSB GAA17CA402](https://openairdocs.org/ntsb/GAA17CA402.md): Bell 206 · Uniontown, KY · Accident · No injuries · Data collection · Final report · Jun 30, 2017 · N60KH · Substantial damage
  > The pilot's failure to maintain adequate separation from power lines, which resulted in a loss of helicopter control.
- [NTSB ERA17FA180](https://openairdocs.org/ntsb/ERA17FA180.md): Beech A36TC · Hopkinsville, KY · Accident · 2 fatal · Field investigation · Final report · May 12, 2017 · N1804E · Destroyed
  > The noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident were the pilot's overreliance on his…
- [NTSB GAA17CA254](https://openairdocs.org/ntsb/GAA17CA254.md): Cessna 172 · Columbia, KY · Accident · No injuries · Data collection · Final report · Apr 28, 2017 · N64144 · Substantial damage
  > The pilot’s failure to maintain a flare during landing in variable, gusting wind conditions.

## 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."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' 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/240/sequence?state=KY&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.
