# NTSB investigations: Piper PA-12, 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 CHI99LA034](https://openairdocs.org/ntsb/CHI99LA034.md): Piper PA-12 · Carrol, IA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1998 · N92585 · Substantial damage
  > the pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.
- [NTSB CHI91LA213](https://openairdocs.org/ntsb/CHI91LA213.md): Piper PA-12 · Stockton, IA · Accident · No injuries · Limited investigation · Final report · Jul 7, 1991 · N7847H · Substantial damage
  > Compensation for wind conditions not performed, wrong runway selected and aircraft control not maintained by the pilot. Factors related to the accident were a tailwind/crosswind component and a rough runway.
- [NTSB MKC77DCD49](https://openairdocs.org/ntsb/MKC77DCD49.md): Piper PA-12 · Denison, IA · Accident · No injuries · Closed · Sep 13, 1977 · N2758M · Substantial damage
- [NTSB MKC73DCD66](https://openairdocs.org/ntsb/MKC73DCD66.md): Piper PA-12 · Davenport, IA · Accident · No injuries · Closed · May 13, 1973 · N4014M · Substantial damage
- [NTSB MKC73DCD20](https://openairdocs.org/ntsb/MKC73DCD20.md): Piper PA-12 · Maysville, IA · Accident · Minor injuries · Closed · Aug 13, 1972 · N7847H · Substantial damage
- [NTSB MKC72DCD41](https://openairdocs.org/ntsb/MKC72DCD41.md): Piper PA-12 · Harlan, IA · Accident · No injuries · Closed · Oct 15, 1971 · N7982H · Substantial damage
- [NTSB MKC67D0565](https://openairdocs.org/ntsb/MKC67D0565.md): Piper PA-12 · Mantelle, IA · Accident · No injuries · Closed · Apr 24, 1967 · N3448M · Substantial damage
- [NTSB MKC67F0124](https://openairdocs.org/ntsb/MKC67F0124.md): Piper PA-12 · Allison, IA · Accident · No injuries · Closed · Aug 14, 1966 · N2674M · Substantial damage
- [NTSB MKC66F0322](https://openairdocs.org/ntsb/MKC66F0322-174344.md): Piper PA-12 · Fort Dodge, IA · Accident · Minor injuries · Closed · Nov 2, 1965 · N3812M · Substantial damage
- [NTSB MKC66F0248](https://openairdocs.org/ntsb/MKC66F0248.md): Piper PA-12 · Lemars, IA · Accident · Minor injuries · Closed · Oct 9, 1965 · N4035M · Substantial damage
- [NTSB MKC66D0213](https://openairdocs.org/ntsb/MKC66D0213.md): Piper PA-12 · Marion, IA · Accident · No injuries · Closed · Aug 23, 1965 · N7502H · 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 ('7101202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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