# NTSB investigations: Cessna 120, IN

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 CHI89LA187](https://openairdocs.org/ntsb/CHI89LA187.md): Cessna 120 · Shelbyville, IN · Accident · No injuries · Limited investigation · Final report · Sep 16, 1989 · N1844N · Substantial damage
  > The pilot failed to maintain proper alignment during the landing roll.
- [NTSB CHI83FET02](https://openairdocs.org/ntsb/CHI83FET02.md): Cessna 120 · Fort Wayne, IN · Accident · No injuries · Final report · Aug 13, 1983 · N77372 · Substantial damage
  > The engine quit at about 50 ft AGL during the second takeoff near mid rwy. The pilot tried to restart the engine and lost the opportunity to try to land on the remaining rwy. The acft landed in an adjoining soybean field. The left fuel tank was empty. The…
- [NTSB CHI77FET18](https://openairdocs.org/ntsb/CHI77FET18.md): Cessna 120 · Logansport, IN · Accident · No injuries · Closed · Jun 11, 1977 · N73066 · Substantial damage
- [NTSB CHI75FET19](https://openairdocs.org/ntsb/CHI75FET19.md): Cessna 120 · Topeka, IN · Accident · Minor injuries · Closed · May 15, 1975 · N73058 · Substantial damage
- [NTSB CHI72DET04](https://openairdocs.org/ntsb/CHI72DET04.md): Cessna 120 · Warsaw, IN · Accident · No injuries · Closed · Aug 8, 1971 · N1831V · Substantial damage
- [NTSB CHI71FBA23](https://openairdocs.org/ntsb/CHI71FBA23.md): Cessna 120 · Monticello, IN · Accident · No injuries · Closed · Jan 9, 1971 · N4236N · Substantial damage
- [NTSB CHI68D0186](https://openairdocs.org/ntsb/CHI68D0186.md): Cessna 120 · Lebanon, IN · Accident · No injuries · Closed · Jul 18, 1967 · N2357N · Substantial damage
- [NTSB UNK64X3862](https://openairdocs.org/ntsb/UNK64X3862.md): Cessna 120 · South Bend, IN · Accident · No injuries · Closed · Sep 7, 1964 · N1791N · Substantial damage
- [NTSB UNK64X3184](https://openairdocs.org/ntsb/UNK64X3184.md): Cessna 120 · Danville, IN · Accident · Serious injuries · Closed · Aug 2, 1964 · N1764V · Destroyed
- [NTSB UNK64X0427](https://openairdocs.org/ntsb/UNK64X0427.md): Cessna 120 · Wabash, IN · Accident · No injuries · Closed · Feb 1, 1964 · N76782 · 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" = 'IN' 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=IN

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