# NTSB investigations: Piper PA-22-135, 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 MKC84LA140](https://openairdocs.org/ntsb/MKC84LA140.md): Piper PA-22-135 · Dubuque, IA · Accident · No injuries · Limited investigation · Final report · May 18, 1984 · N2390A · Substantial damage
  > While manuevering over a university a ttl loss of pwr was experienced. Attempts to restart the engine failed. The plt made a hard forced landing which resulted in substantial damage. Inspection of the engine did not reveal any mechanical failure/malfunction.
- [NTSB MKC81FA021](https://openairdocs.org/ntsb/MKC81FA021.md): Piper PA-22 · Lohrville, IA · Accident · 1 fatal · Closed · Feb 21, 1981 · N3402A · Destroyed
- [NTSB MKC80DCD05](https://openairdocs.org/ntsb/MKC80DCD05.md): Piper PA-22 · Des Moines, IA · Accident · No injuries · Closed · Oct 27, 1979 · N8194C · 2 aircraft · Substantial damage
- [NTSB MKC77DCD40](https://openairdocs.org/ntsb/MKC77DCD40.md): Piper PA-22 · Pocahontas, IA · Accident · No injuries · Closed · Aug 12, 1977 · N2371A · Substantial damage
- [NTSB MKC71DCD96](https://openairdocs.org/ntsb/MKC71DCD96.md): Piper PA-23 · Newton, IA · Accident · No injuries · Closed · Jun 27, 1971 · N8025C · Substantial damage
- [NTSB MKC70DCD13](https://openairdocs.org/ntsb/MKC70DCD13.md): Piper PA-22 · Guthrie Cntr, IA · Accident · No injuries · Closed · Jan 30, 1970 · N2692A · Substantial damage
- [NTSB MKC70D0013](https://openairdocs.org/ntsb/MKC70D0013.md): Piper PA-22 · Des Moines, IA · Accident · No injuries · Closed · Jun 8, 1969 · N3739A · Substantial damage
- [NTSB MKC69D0365](https://openairdocs.org/ntsb/MKC69D0365.md): Piper PA-22 · Ankeny, IA · Accident · No injuries · Closed · Mar 1, 1969 · N1209C · Substantial damage
- [NTSB MKC68F0526](https://openairdocs.org/ntsb/MKC68F0526.md): Piper PA-22 · Lynnville, IA · Accident · Minor injuries · Closed · Apr 27, 1968 · N3401A · Substantial damage
- [NTSB MKC68D0397](https://openairdocs.org/ntsb/MKC68D0397.md): Piper PA-22 · Forest City, IA · Accident · No injuries · Closed · Dec 24, 1967 · N2655A · Substantial damage
- [NTSB MKC67D0477](https://openairdocs.org/ntsb/MKC67D0477.md): Piper PA-22 · Denison, IA · Accident · No injuries · Closed · Mar 28, 1967 · N3415A · Substantial damage
- [NTSB MKC67D0429](https://openairdocs.org/ntsb/MKC67D0429.md): Piper PA-22 · Iowa City, IA · Accident · No injuries · Closed · Feb 4, 1967 · N8867C · Substantial damage
- [NTSB MKC67F0319](https://openairdocs.org/ntsb/MKC67F0319.md): Piper PA-22 · Ames, IA · Accident · Serious injuries · Closed · Nov 26, 1966 · N1517P · Destroyed
- [NTSB MKC67D0013](https://openairdocs.org/ntsb/MKC67D0013.md): Piper PA-22 · Manson, IA · Accident · No injuries · Closed · Jun 9, 1966 · N8516C · Substantial damage
- [NTSB MKC66D0449](https://openairdocs.org/ntsb/MKC66D0449.md): Piper PA-22 · Perry, IA · Accident · No injuries · Closed · Feb 27, 1966 · N2609A · Substantial damage
- [NTSB UNK64X1681](https://openairdocs.org/ntsb/UNK64X1681.md): Piper PA22 · Davenport, IA · Accident · No injuries · Closed · May 9, 1964 · N2297A · Substantial damage
- [NTSB UNK64X1399](https://openairdocs.org/ntsb/UNK64X1399.md): Piper PA22 · Davenport, IA · Accident · No injuries · Closed · Apr 21, 1964 · N3202B · Substantial damage
- [NTSB UNK64X1223](https://openairdocs.org/ntsb/UNK64X1223.md): Piper PA22 · Traer, IA · Accident · No injuries · Closed · Apr 8, 1964 · N8871C · 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 ('7102206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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