# NTSB investigations, 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.

Page 34 of 45 · 2,216 cases

## Cases, newest first

- [NTSB MKC70DCD18](https://openairdocs.org/ntsb/MKC70DCD18.md): Piper PA-18 · Clarinda, IA · Accident · No injuries · Closed · Dec 8, 1969 · N1387A · 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 MKC70D0280](https://openairdocs.org/ntsb/MKC70D0280.md): Piper PA-22 · Quasqueton, IA · Accident · No injuries · Closed · Nov 30, 1969 · N9431D · Substantial damage
- [NTSB MKC70D0289](https://openairdocs.org/ntsb/MKC70D0289.md): Piper PA-28 · Creston, IA · Accident · No injuries · Closed · Nov 26, 1969 · N4139J · Substantial damage
- [NTSB MKC70A0029](https://openairdocs.org/ntsb/MKC70A0029.md): Champion 7ECA · Royal, IA · Accident · 1 fatal · Closed · Nov 25, 1969 · N9634S · Destroyed
- [NTSB MKC70F0278](https://openairdocs.org/ntsb/MKC70F0278.md): Aeronca 7AC · Harlan, IA · Accident · Serious injuries · Closed · Nov 23, 1969 · N84331 · Destroyed
- [NTSB MKC70F0281](https://openairdocs.org/ntsb/MKC70F0281.md): Cessna 120 · Riverton, IA · Accident · Serious injuries · Closed · Nov 15, 1969 · N1878N · Destroyed
- [NTSB MKC70D0264](https://openairdocs.org/ntsb/MKC70D0264.md): Piper PA-28R · Muscatine, IA · Accident · No injuries · Closed · Nov 9, 1969 · N4696J · Substantial damage
- [NTSB MKC70D0242](https://openairdocs.org/ntsb/MKC70D0242.md): Cessna 150J · Waterloo, IA · Accident · No injuries · Closed · Oct 26, 1969 · N50473 · Substantial damage
- [NTSB MKC70D0234](https://openairdocs.org/ntsb/MKC70D0234.md): Piper PA-23 · Des Moines, IA · Accident · No injuries · Closed · Oct 13, 1969 · N6385Y · Substantial damage
- [NTSB MKC70F0230](https://openairdocs.org/ntsb/MKC70F0230.md): Beech V35 · Dows, IA · Accident · No injuries · Closed · Oct 5, 1969 · N563DB · Substantial damage
- [NTSB MKC70A0020](https://openairdocs.org/ntsb/MKC70A0020.md): Cessna 402A · Decorah, IA · Accident · Serious injuries · Closed · Oct 2, 1969 · N4554Q · No damage
- [NTSB MKC70A0014](https://openairdocs.org/ntsb/MKC70A0014.md): Cessna 140 · Hartley, IA · Accident · 2 fatal · Closed · Oct 1, 1969 · N1984V · Destroyed
- [NTSB MKC70F0218](https://openairdocs.org/ntsb/MKC70F0218.md): Piper PA-22 · Cedar Falls, IA · Accident · No injuries · Closed · Sep 27, 1969 · N5970Z · Substantial damage
- [NTSB MKC70D0236](https://openairdocs.org/ntsb/MKC70D0236.md): Cessna 150 · Council Bluf, IA · Accident · Minor injuries · Closed · Sep 21, 1969 · N2846S · Substantial damage
- [NTSB MKC70F0217](https://openairdocs.org/ntsb/MKC70F0217.md): Piper PA-32 · Carroll, IA · Accident · No injuries · Closed · Sep 19, 1969 · N5540J · Substantial damage
- [NTSB MKC70D0215](https://openairdocs.org/ntsb/MKC70D0215.md): Cessna 177 · Des Moines, IA · Accident · No injuries · Closed · Sep 17, 1969 · N3499T · Substantial damage
- [NTSB MKC70F0216](https://openairdocs.org/ntsb/MKC70F0216.md): Cessna 177 · Polk City, IA · Accident · No injuries · Closed · Sep 13, 1969 · N29490 · Substantial damage
- [NTSB MKC70F018O](https://openairdocs.org/ntsb/MKC70F018O.md): Breezy 17A · Washington, IA · Accident · Serious injuries · Closed · Sep 10, 1969 · N1683 · Minor damage
- [NTSB MKC70D0206](https://openairdocs.org/ntsb/MKC70D0206.md): Piper PA-18 · West Liberty, IA · Accident · No injuries · Closed · Sep 7, 1969 · N3838Z · Substantial damage
- [NTSB MKC70D0199](https://openairdocs.org/ntsb/MKC70D0199.md): Rose A M A-1 · Ottumwa, IA · Accident · Minor injuries · Closed · Sep 7, 1969 · N14843 · Substantial damage
- [NTSB MKC70F0192](https://openairdocs.org/ntsb/MKC70F0192.md): Callair A9 · Yale, IA · Accident · 1 fatal · Closed · Sep 3, 1969 · N7276V · Destroyed
- [NTSB MKC70D0185](https://openairdocs.org/ntsb/MKC70D0185.md): Callair A-9 · Greattinger, IA · Accident · No injuries · Closed · Sep 1, 1969 · N7240V · Destroyed
- [NTSB MKC70D0173](https://openairdocs.org/ntsb/MKC70D0173.md): Cessna 150 · Council Blfs, IA · Accident · Minor injuries · Closed · Aug 31, 1969 · N8547G · Substantial damage
- [NTSB MKC70A0008](https://openairdocs.org/ntsb/MKC70A0008.md): Cessna 172H · Newton, IA · Accident · 3 fatal · Closed · Aug 31, 1969 · N3149X · Destroyed
- [NTSB MKC70F0153](https://openairdocs.org/ntsb/MKC70F0153.md): Rose A-M A-1 · Ottumwa, IA · Accident · No injuries · Closed · Aug 30, 1969 · N18252 · 2 aircraft · Substantial damage
- [NTSB MKC70D0235](https://openairdocs.org/ntsb/MKC70D0235.md): Piper PA-28 · Guttenberg, IA · Accident · No injuries · Closed · Aug 29, 1969 · N7235W · Substantial damage
- [NTSB MKC70D0149](https://openairdocs.org/ntsb/MKC70D0149.md): Fournier RF-4D · Pella, IA · Accident · No injuries · Closed · Aug 28, 1969 · N7752 · Substantial damage
- [NTSB MKC70F0191](https://openairdocs.org/ntsb/MKC70F0191.md): Piper PA-18A · Gillett Grve, IA · Accident · 1 fatal · Closed · Aug 26, 1969 · N9901D · Destroyed
- [NTSB MKC70D0204](https://openairdocs.org/ntsb/MKC70D0204.md): Bell 47G-5 · Irwin, IA · Accident · No injuries · Closed · Aug 26, 1969 · N7801S · Substantial damage
- [NTSB MKC70D0157](https://openairdocs.org/ntsb/MKC70D0157.md): Cessna 177 · Marshallton, IA · Accident · No injuries · Closed · Aug 25, 1969 · N2295Y · Substantial damage
- [NTSB MKC70D0224](https://openairdocs.org/ntsb/MKC70D0224.md): Cessna 172 · Missouri Val, IA · Accident · No injuries · Closed · Aug 24, 1969 · N5806R · Substantial damage
- [NTSB MKC70D0147](https://openairdocs.org/ntsb/MKC70D0147.md): Beech S35 · Spirit Lake, IA · Accident · No injuries · Closed · Aug 23, 1969 · N171H · Substantial damage
- [NTSB MKC70D0162](https://openairdocs.org/ntsb/MKC70D0162.md): Beech B35 · Clinton, IA · Accident · No injuries · Closed · Aug 17, 1969 · N3399V · Substantial damage
- [NTSB MKC70I0141](https://openairdocs.org/ntsb/MKC70I0141.md): Beech B95A · Oskaloosa, IA · Incident · No injuries · Closed · Aug 12, 1969 · N9697Y · Minor damage
- [NTSB MKC70D0144](https://openairdocs.org/ntsb/MKC70D0144.md): Stinson 108-3 · Mcgregor, IA · Accident · No injuries · Closed · Aug 12, 1969 · N6427M · Substantial damage
- [NTSB MKC70D0142](https://openairdocs.org/ntsb/MKC70D0142.md): Beech 35-B33 · Grinnell, IA · Accident · No injuries · Closed · Aug 11, 1969 · N9703Y · Substantial damage
- [NTSB MKC70D0131](https://openairdocs.org/ntsb/MKC70D0131.md): Piper PA-24 · Laporte City, IA · Accident · No injuries · Closed · Aug 8, 1969 · N7481P · Substantial damage
- [NTSB MKC70D0105](https://openairdocs.org/ntsb/MKC70D0105.md): Cessna 150 · Davenport, IA · Accident · No injuries · Closed · Aug 6, 1969 · N8613S · Substantial damage
- [NTSB MKC70D0123](https://openairdocs.org/ntsb/MKC70D0123.md): Piper PA-28 · Sac City, IA · Accident · No injuries · Closed · Aug 5, 1969 · N5497W · Substantial damage
- [NTSB MKC70D0143](https://openairdocs.org/ntsb/MKC70D0143.md): Boeing A75 · Hawarden, IA · Accident · No injuries · Closed · Jul 29, 1969 · N54545 · Substantial damage
- [NTSB MKC70D0139](https://openairdocs.org/ntsb/MKC70D0139.md): Piper PA-28 · Atlantic, IA · Accident · No injuries · Closed · Jul 26, 1969 · N8243N · Substantial damage
- [NTSB MKC70D0104](https://openairdocs.org/ntsb/MKC70D0104.md): Piper PA-28 · Epworth, IA · Accident · No injuries · Closed · Jul 24, 1969 · N4839L · Substantial damage
- [NTSB MKC70F0096](https://openairdocs.org/ntsb/MKC70F0096.md): Piper PA-23 · Newton, IA · Accident · Serious injuries · Closed · Jul 22, 1969 · N5246Y · Destroyed
- [NTSB MKC70D0068](https://openairdocs.org/ntsb/MKC70D0068.md): Cessna 150J · Polk City, IA · Accident · No injuries · Closed · Jul 15, 1969 · N50588 · Substantial damage
- [NTSB MKC70D0111](https://openairdocs.org/ntsb/MKC70D0111.md): Piper PA-32 · Eagle Grove, IA · Accident · No injuries · Closed · Jul 10, 1969 · N3805W · Substantial damage
- [NTSB MKC70D0050](https://openairdocs.org/ntsb/MKC70D0050.md): Ryan ST-A · Ackley, IA · Accident · No injuries · Closed · Jul 7, 1969 · N17352 · Substantial damage
- [NTSB MKC70F0040](https://openairdocs.org/ntsb/MKC70F0040.md): Beech A23 · Cedar Rapids, IA · Accident · No injuries · Closed · Jul 2, 1969 · N8857M · Substantial damage
- [NTSB MKC70D0055](https://openairdocs.org/ntsb/MKC70D0055.md): Taylorcraft BC12-D · Grinnell, IA · Accident · No injuries · Closed · Jun 29, 1969 · N95254 · Substantial damage
- [NTSB MKC70F0039](https://openairdocs.org/ntsb/MKC70F0039.md): Douglas B-26C · Ames, IA · Accident · No injuries · Closed · Jun 28, 1969 · N91356 · Substantial damage

Next page: https://openairdocs.org/ntsb.md?state=IA&page=35

## 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'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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