# NTSB investigations: Cessna 170B, IA

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 CHI91LA021](https://openairdocs.org/ntsb/CHI91LA021.md): Cessna 170B · Maquoketa, IA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1990 · N1692D · Substantial damage
  > The pilot's inadequate commpensation for wind conditions.
- [NTSB MKC86LA100](https://openairdocs.org/ntsb/MKC86LA100.md): Cessna 170B · Monticello, IA · Accident · No injuries · Limited investigation · Final report · May 4, 1986 · N66F · Substantial damage
  > The plt stated that following a normal touchdown the wind picked up and overturned the acft. He had recently purchased the acft and was ferrying it home when the accident occurred. He further stated that he owned a tailwheel acft prior to purchasing this one,…
- [NTSB MKC84FA256](https://openairdocs.org/ntsb/MKC84FA256.md): Cessna 170B · Oskaloosa, IA · Accident · 2 fatal · Field investigation · Final report · Aug 17, 1984 · N516PC · Destroyed
  > Several witnesses viewed the acft circling over a bean field at an alt of 200 to 300 ft AGL. The plt and pax were reportedly looking for a radio-controlled airplane lost in the field. Witnesses continued to state an increase of power occurred and the acft…
- [NTSB MKC83LA125](https://openairdocs.org/ntsb/MKC83LA125.md): Cessna 170B · Ottumwa, IA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1983 · N8077A · Substantial damage
  > During arrival, the plt canceled his VFR flt plan when he was about 3 mi from the arpt. At that time, fss personnel advised him that the wind was from 190 deg at 14 KTS & that the wind favored rwy 22. There was a tetrahedron wind indicator north of the…
- [NTSB MKC82FA096](https://openairdocs.org/ntsb/MKC82FA096.md): Cessna 170B · Tama, IA · Accident · 1 fatal · Field investigation · Final report · Jun 6, 1982 · N8187A · Destroyed
  > The purpose of the flight was to take a family friend on a night airplane ride to see the lights of a neighboring city. The takeoff was made from a soft wet grass runway with an aircraft exceeding the maximum allowable gross weight and the center of gravity…
- [NTSB MKC81DCD27](https://openairdocs.org/ntsb/MKC81DCD27.md): Cessna 170B · Red Oak, IA · Accident · No injuries · Closed · Jul 22, 1981 · N2356D · Substantial damage
- [NTSB MKC78DCD40](https://openairdocs.org/ntsb/MKC78DCD40.md): Cessna 170B · Mason City, IA · Accident · No injuries · Closed · Jul 28, 1978 · N2757D · Substantial damage
- [NTSB MKC77FCD35](https://openairdocs.org/ntsb/MKC77FCD35-201264.md): Cessna 170B · Dubuque, IA · Accident · No injuries · Closed · Jul 21, 1977 · N2788D · Substantial damage
- [NTSB MKC70D0288](https://openairdocs.org/ntsb/MKC70D0288.md): Cessna 170B · Holstein, IA · Accident · No injuries · Closed · Dec 1, 1969 · N2356D · Substantial damage
- [NTSB MKC69D0290](https://openairdocs.org/ntsb/MKC69D0290.md): Cessna 170B · Oakland, IA · Accident · No injuries · Closed · Dec 9, 1968 · N4581C · Substantial damage
- [NTSB MKC68D0111](https://openairdocs.org/ntsb/MKC68D0111.md): Cessna 170B · Garnavillo, IA · Accident · No injuries · Closed · Aug 5, 1967 · N4628C · Substantial damage
- [NTSB MKC68F0026](https://openairdocs.org/ntsb/MKC68F0026.md): Cessna 170 · Larrabee, IA · Accident · No injuries · Closed · Jun 16, 1967 · N2614D · Substantial damage
- [NTSB MKC67D0619](https://openairdocs.org/ntsb/MKC67D0619.md): Cessna 170B · Stratford, IA · Accident · No injuries · Closed · Jun 10, 1967 · N1887C · 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" = 'IA' 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 ('2072306', '2072307'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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