# NTSB investigations: Cessna 170A, 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 CEN16LA343](https://openairdocs.org/ntsb/CEN16LA343.md): Cessna 170A · Hibbing, MN · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 2016 · N1726D · Substantial damage
  > The pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.
- [NTSB CHI98LA144](https://openairdocs.org/ntsb/CHI98LA144.md): Cessna 170A · Emily, MN · Accident · Minor injuries · Limited investigation · Final report · May 10, 1998 · N1491D · Substantial damage
  > The pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).
- [NTSB CHI87LA192](https://openairdocs.org/ntsb/CHI87LA192.md): Cessna 170A · Monticello, MN · Accident · No injuries · Limited investigation · Final report · Aug 18, 1987 · N1354D · Substantial damage
  > Drg the takeoff roll, the plt lost directional control of the tailwheel equipped acft. It then swerved to the left & went into a soybean field. Drg the occurrence, the rgt main gear collapsed & the rgt wing, rgt horizontal stabilizer, prop & eng cowling were…
- [NTSB CHI83LER04](https://openairdocs.org/ntsb/CHI83LER04.md): Cessna 170A · Crystal, MN · Accident · No injuries · Final report · Aug 14, 1983 · N9707A · Substantial damage
  > As the plt applied brakes the acft veered off to the right. He applied left rudder & left brake to no avail, & the acft ground-looped off the right side of the rwy. The left brake outer lining was missing. There were two rivets missing & one rivet had broken.…
- [NTSB MKC76AER24](https://openairdocs.org/ntsb/MKC76AER24.md): Cessna 170A · Carlos, MN · Accident · No injuries · Closed · Sep 6, 1975 · N5772C · Substantial damage
- [NTSB MKC76AK015](https://openairdocs.org/ntsb/MKC76AK015.md): Cessna 170 · Mahtowa, MN · Accident · 3 fatal · Closed · Aug 29, 1975 · N69TT · Destroyed
- [NTSB MKC7KDER79](https://openairdocs.org/ntsb/MKC7KDER79.md): Cessna 170A · Duluth, MN · Accident · No injuries · Closed · Jun 28, 1975 · N1792D · Substantial damage
- [NTSB MKC72DER58](https://openairdocs.org/ntsb/MKC72DER58.md): Cessna 170A · Anoka, MN · Accident · No injuries · Closed · May 6, 1972 · N1403D · Substantial damage
- [NTSB MKC72DER48](https://openairdocs.org/ntsb/MKC72DER48.md): Cessna 170A · Anoka, MN · Accident · No injuries · Closed · Apr 1, 1972 · N9707A · Substantial damage
- [NTSB MKC68D0566](https://openairdocs.org/ntsb/MKC68D0566.md): Cessna 170 · Watertown, MN · Accident · No injuries · Closed · Feb 12, 1968 · N9125A · Substantial damage
- [NTSB MKC66D0376](https://openairdocs.org/ntsb/MKC66D0376.md): Cessna 170A · New Ulm, MN · Accident · No injuries · Closed · Dec 7, 1965 · N9277A · Substantial damage
- [NTSB MKC66F0254](https://openairdocs.org/ntsb/MKC66F0254.md): Cessna 170A · So St Paul, MN · Accident · No injuries · Closed · Oct 4, 1965 · N9503A · Substantial damage
- [NTSB MKC65F0091](https://openairdocs.org/ntsb/MKC65F0091.md): Cessna 170 · Minneapolis, MN · Accident · No injuries · Closed · Jan 16, 1965 · N3852V · Substantial damage
- [NTSB UNK65X0995](https://openairdocs.org/ntsb/UNK65X0995.md): Cessna 170A · Rosemount, MN · Accident · No injuries · Closed · Dec 13, 1964 · N9965A · Substantial damage
- [NTSB UNK64X3422](https://openairdocs.org/ntsb/UNK64X3422.md): Cessna 170 · East Bethel, MN · Accident · No injuries · Closed · Aug 16, 1964 · N1242D · Destroyed
- [NTSB UNK64X2167](https://openairdocs.org/ntsb/UNK64X2167.md): Cessna 170A · Roseau, MN · Accident · Minor injuries · Closed · Jun 7, 1964 · N9570A · Substantial damage
- [NTSB UNK64X0233](https://openairdocs.org/ntsb/UNK64X0233.md): Cessna 170A · Rushford, MN · Accident · No injuries · Closed · Jan 12, 1964 · N5795C · 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 ('2072304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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