# NTSB investigations: Continental C145 series, 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 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 MKC83LA006](https://openairdocs.org/ntsb/MKC83LA006.md): Cessna 170A · Le Mars, IA · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1982 · N9035A · Destroyed
  > The pilot was on a power line patrol mission with an observer on board. According to him, the wind was from the west at about 20 KTS and he was flying east along a line that made a 90 degree turn to the north. At that point, he began a 270 degree turn to the…
- [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 MKC76FCD05](https://openairdocs.org/ntsb/MKC76FCD05.md): Cessna 170A · Centerville, IA · Accident · No injuries · Closed · Aug 23, 1975 · N9223A · Substantial damage
- [NTSB MKC75FCD47](https://openairdocs.org/ntsb/MKC75FCD47.md): Aeronca 15AC · Johnston, IA · Accident · Serious injuries · Closed · Jun 24, 1975 · N1039H · Substantial damage
- [NTSB MKC75FCD40](https://openairdocs.org/ntsb/MKC75FCD40.md): Cessna 170A · Montezuma, IA · Accident · No injuries · Closed · Apr 5, 1975 · N1493D · Substantial damage
- [NTSB MKC72DCD42](https://openairdocs.org/ntsb/MKC72DCD42.md): Cessna 170A · Marion, IA · Accident · No injuries · Closed · Oct 31, 1971 · N9145A · Substantial damage
- [NTSB MKC71FCD62](https://openairdocs.org/ntsb/MKC71FCD62.md): Cessna 170A · Leclaire, IA · Accident · No injuries · Closed · Mar 4, 1971 · N9735A · 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 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.engine_model_code IN ('17012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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