# NTSB investigations: Cessna 120, 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 NYC06CA188](https://openairdocs.org/ntsb/NYC06CA188.md): Cessna 120 · Ashland, KY · Accident · No injuries · Data collection · Final report · Jul 30, 2006 · N1981V · Substantial damage
  > The pilot's improper fuel tank selection, which resulted in fuel starvation and a subsequent loss of engine power. A factor in the accident was the trees.
- [NTSB ATL90LA005](https://openairdocs.org/ntsb/ATL90LA005.md): Cessna 120 · Maysville, KY · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1989 · N1829N · Substantial damage
  > The improper inspection of the airplanes engine by the pilot/owner resulting in five rocker box cover screws being missing and subsequent loss of engine oil due to the cover vibrating and causing a hole to be worn in it. Subsequent loss of engine power due to…
- [NTSB ATL86LA151](https://openairdocs.org/ntsb/ATL86LA151.md): Cessna 120 · Magnolia, KY · Accident · Serious injuries · Limited investigation · Final report · May 31, 1986 · N76730 · Substantial damage
  > The plt was using the acft to drop a tool to a mechanic friend and was flying at low alt toward rising terrain to verify the location where the tool fell. Witnesses said that when the plt exited the acft after the accident he stated he was too low, too slow,…
- [NTSB CHI69D0122](https://openairdocs.org/ntsb/CHI69D0122.md): Cessna 120 · Mannsville, KY · Accident · Minor injuries · Closed · Aug 2, 1968 · N2536N · Substantial damage
- [NTSB CHI65F0204](https://openairdocs.org/ntsb/CHI65F0204.md): Cessna 120 · Monticello, KY · Accident · No injuries · Closed · May 23, 1965 · N72892 · 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 ('2071402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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