# NTSB investigations: Cessna 140, 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 ERA17LA268](https://openairdocs.org/ntsb/ERA17LA268.md): Cessna 140 · Mount Sterling, KY · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 2017 · N89738 · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ATL87LA183](https://openairdocs.org/ntsb/ATL87LA183.md): Cessna 140 · Falmouth, KY · Accident · No injuries · Limited investigation · Final report · Jun 23, 1987 · N89784 · Substantial damage
  > The pilot was on a cross-country flight and had made several refueling stops during the day. He stated that during landing he experienced a crosswind of approximately 7 to 10 knots. The aircraft bounced, rocked up on the left main landing gear, departed the…
- [NTSB ATL85FA140](https://openairdocs.org/ntsb/ATL85FA140.md): Cessna 140 · Hawesville, KY · Accident · 2 fatal · Field investigation · Final report · Apr 19, 1985 · N72587 · Destroyed
  > The acft collided with and sunk into the Ohio river following a wing separation after contacting the lowest wire in a set of 3 power lines which spanned the river. Two other wires were located above the set of 3 power lines. Witnesses on and near the river…
- [NTSB ATL85LA130](https://openairdocs.org/ntsb/ATL85LA130.md): Cessna 140 · Hawesville, KY · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N89128 · Substantial damage
  > The plt was on a flt from lordsburg, NM, to mansfield, OH, and could not find hancock county airport, Hawesville, KY. While searching for the airport the engine lost total power due to fuel exhaustion. The plt said that he planned to refuel at hancock co.…
- [NTSB IAD79DLQ06](https://openairdocs.org/ntsb/IAD79DLQ06.md): Cessna 140 · Shelbyville, KY · Accident · No injuries · Closed · Nov 22, 1978 · N90143 · Substantial damage
- [NTSB IAD76FLQ16](https://openairdocs.org/ntsb/IAD76FLQ16-151543.md): Cessna 140 · Bardstown, KY · Accident · Minor injuries · Closed · Mar 18, 1976 · N2216N · Substantial damage
- [NTSB IAD75FLQ01](https://openairdocs.org/ntsb/IAD75FLQ01.md): Cessna 140 · Symsonia, KY · Accident · No injuries · Closed · Jul 6, 1974 · N73052 · Destroyed
- [NTSB CHI73FLQ07](https://openairdocs.org/ntsb/CHI73FLQ07.md): Cessna 140 · Monticello, KY · Accident · No injuries · Closed · Jul 21, 1972 · N2466V · Substantial damage
- [NTSB CHI70D0001](https://openairdocs.org/ntsb/CHI70D0001.md): Cessna 140 · Shepherdsville, KY · Accident · No injuries · Closed · May 4, 1969 · N3598V · Substantial damage
- [NTSB CHI69F0583](https://openairdocs.org/ntsb/CHI69F0583.md): Cessna 140 · West Paducah, KY · Accident · Minor injuries · Closed · Apr 12, 1969 · N72616 · Destroyed
- [NTSB CHI67F0542](https://openairdocs.org/ntsb/CHI67F0542.md): Cessna 140 · Pine Top, KY · Accident · Serious injuries · Closed · Feb 22, 1967 · N89499 · Destroyed
- [NTSB UNK64X2701](https://openairdocs.org/ntsb/UNK64X2701.md): Cessna 140 · Bowling Green, KY · Accident · No injuries · Closed · Jul 7, 1964 · N2403V · Substantial damage

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2071602&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.
