# NTSB investigations, KY: Task environment

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 ERA23FA048](https://openairdocs.org/ntsb/ERA23FA048.md): Beech A36 · Harlan, KY · Accident · 1 fatal · Class 3 · Field · Final report · Nov 3, 2022 · N84R · Destroyed
  > The pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…
- [NTSB ERA09CA156](https://openairdocs.org/ntsb/ERA09CA156.md): Robinson Helicopter R22 Beta · Lexington, KY · Accident · No injuries · Data collection · Final report · Feb 1, 2009 · N2620C · Substantial damage
  > The pilot's failure to maintain control of the helicopter during takeoff. Contributing to this accident was the interference of the flight controls by the heavy coat and boots the pilot was wearing.
- [NTSB MIA08LA180](https://openairdocs.org/ntsb/MIA08LA180.md): Cessna 182A · Elizabethtown, KY · Accident · No injuries · Limited investigation · Final report · Aug 30, 2008 · N5927B · Substantial damage
  > A loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.
- [NTSB MIA08CA065](https://openairdocs.org/ntsb/MIA08CA065.md): Embraer EMB-145LR · Covington, KY · Accident · Serious injuries · Data collection · Final report · Feb 15, 2008 · N569RP · No damage
  > The flight attendant's inadvertent slip on the galley's contaminated floor and falling during climb to cruise.

## 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 c."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/0304/cases?state=KY

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