# NTSB investigations: Cessna 170, MN

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 CHI94LA336](https://openairdocs.org/ntsb/CHI94LA336.md): Cessna 170 · Lakeville, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 1994 · N4271V · Substantial damage
  > An inadequate pre-flight inspection by the pilot when he did not insure that all the water was drained from the airplane's fuel tanks. Factors associated with this accident were contaminated fuel and powerlines.
- [NTSB CHI87LA172](https://openairdocs.org/ntsb/CHI87LA172.md): Cessna 170 · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · Jul 17, 1987 · N4649V · Substantial damage
  > The plt rprtd the wind was varying plus or minus 30 deg from 200 deg at 10 gusting 25 KTS. Drg the takeoff roll on rwy 29, the acft enctrd a gust of wind. The acft swerved & the plt recovered, but the acft enctrd another gust which raised the left wing.…
- [NTSB CHI86LA055](https://openairdocs.org/ntsb/CHI86LA055.md): Cessna 170A · Grygla, MN · Accident · No injuries · Limited investigation · Final report · Dec 31, 1985 · N3828V · Substantial damage
  > The aircraft had been fitted with owner installd skis. During landing the left ski separates from its mount allowing the left ski mount to dig into the snow covered runway. The right wingtip struck a snowbank and the aircraft came to rest on its nose. The…
- [NTSB MKC76DER08](https://openairdocs.org/ntsb/MKC76DER08.md): Cessna 170 · Preston, MN · Accident · No injuries · Closed · Jul 14, 1975 · N3907V · Substantial damage
- [NTSB MKC74DER18](https://openairdocs.org/ntsb/MKC74DER18.md): Cessna 170 · Anoka, MN · Accident · No injuries · Closed · Oct 15, 1973 · N2632V · Substantial damage
- [NTSB MKC73FER11](https://openairdocs.org/ntsb/MKC73FER11.md): Cessna 170 · Rosemount, MN · Accident · No injuries · Closed · Aug 16, 1972 · N3824V · Substantial damage
- [NTSB MKC69D0246](https://openairdocs.org/ntsb/MKC69D0246.md): Cessna 170 · Almelund, MN · Accident · No injuries · Closed · Oct 19, 1968 · N2632V · Substantial damage
- [NTSB MKC69A0009](https://openairdocs.org/ntsb/MKC69A0009.md): Cessna 170 · Howard Lake, MN · Accident · 2 fatal · Closed · Aug 7, 1968 · N3901V · Destroyed
- [NTSB MKC66F0238](https://openairdocs.org/ntsb/MKC66F0238.md): Cessna 170 · Cottonwood, MN · Accident · No injuries · Closed · Aug 15, 1965 · N4038V · Substantial damage
- [NTSB MKC65F0009](https://openairdocs.org/ntsb/MKC65F0009.md): Cessna 170 · Isle, MN · Accident · No injuries · Closed · Jan 16, 1965 · N3803V · Substantial damage
- [NTSB UNK64X2140](https://openairdocs.org/ntsb/UNK64X2140.md): Cessna 170 · Montevideo, MN · Accident · No injuries · Closed · Jun 6, 1964 · N2601V · Substantial damage
- [NTSB UNK64X1433](https://openairdocs.org/ntsb/UNK64X1433.md): Cessna 170 · Tracy, MN · Accident · No injuries · Closed · Apr 24, 1964 · N4038V · 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" = 'MN' 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 ('2072302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072302&state=MN

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