# NTSB investigations, 2014, KY

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 ERA14CA407](https://openairdocs.org/ntsb/ERA14CA407.md): Piper PA-28-140 · Taylorsville, KY · Accident · No injuries · Data collection · Final report · Aug 23, 2014 · N41224 · Substantial damage
  > The pilot's decision to land on a wet runway and delayed go-around attempt, which resulted in a collision with terrain.
- [NTSB ERA14CA291](https://openairdocs.org/ntsb/ERA14CA291.md): Cessna 172B · Frankfort, KY · Accident · No injuries · Data collection · Final report · Jun 13, 2014 · N7540X · Substantial damage
  > The pilot's failure to maintain directional control during landing in crosswind conditions, resulting in a loss of control and runway excursion.
- [NTSB ERA14LA253](https://openairdocs.org/ntsb/ERA14LA253.md): Piper J3C - 65 · Hopkinsville, KY · Accident · Serious injuries · Limited investigation · Final report · May 22, 2014 · N46777 · Substantial damage
  > The failure of the pilot to identify poor engine performance during the engine run-up before takeoff. Also causal to the accident was the mistimed right magneto and the poor condition of the spark plugs in the No. 4 cylinder.
- [NTSB ERA14LA222](https://openairdocs.org/ntsb/ERA14LA222.md): Champion 7GCAA · Bardwell, KY · Accident · Minor injuries · Limited investigation · Final report · May 4, 2014 · N9588S · Substantial damage
  > The failure of the pilot to maintain airspeed while maneuvering shortly after takeoff, resulting in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, uncontrolled descent, and impact with the ground.
- [NTSB ERA14LA218](https://openairdocs.org/ntsb/ERA14LA218.md): Beech V35B · Middlesboro, KY · Accident · Serious injuries · Limited investigation · Final report · May 2, 2014 · N702JS · Substantial damage
  > The pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…

## 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") = 2014
  AND c."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=KY&year=2014

---
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.
