# NTSB investigations, KY: Preflight or dispatch event

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 ERA21LA292](https://openairdocs.org/ntsb/ERA21LA292.md): Robinson Helicopter R44 II · Princeton, KY · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 16, 2021 · N512RT · Substantial damage
  > The pilot’s inadequate preflight planning in that he failed to accurately determine the takeoff weight of the helicopter, which resulted in exceeding the helicopter’s maximum weight capability.
- [NTSB ERA18LA158](https://openairdocs.org/ntsb/ERA18LA158.md): Bellanca 7ECA · Warsaw, KY · Accident · No injuries · Class 3 · Limited · Final report · Jun 3, 2018 · N8698 · Substantial damage
  > The pilot’s inadequate preflight performance planning, and his delayed decision to abort the takeoff, which resulted in a ground loop.
- [NTSB ERA12LA294](https://openairdocs.org/ntsb/ERA12LA294.md): Cessna 172R · Richmond, KY · Accident · No injuries · Limited investigation · Final report · Apr 19, 2012 · N28BC · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s failure to supervise the student’s preflight inspection, his inadequate fuel management and preflight and in-flight fuel planning, and the operator’s…
- [NTSB ERA10FA148](https://openairdocs.org/ntsb/ERA10FA148.md): Piper PA-28-180 · Springfield, KY · Accident · 1 fatal · Field investigation · Final report · Feb 23, 2010 · N7778W · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '030' 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/030/sequence?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.