# 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 37 of 45 · 2,216 cases

## Cases, newest first

- [NTSB MKC68D0593](https://openairdocs.org/ntsb/MKC68D0593.md): Cessna 120 · Dallas Ctr., IA · Accident · No injuries · Closed · May 21, 1968 · N72715 · Substantial damage
- [NTSB MKC68D0586](https://openairdocs.org/ntsb/MKC68D0586.md): Piper PA-28 · Mount Vernon, IA · Accident · No injuries · Closed · May 17, 1968 · N5172L · Substantial damage
- [NTSB OAK68A0067](https://openairdocs.org/ntsb/OAK68A0067.md): Boeing 720B · Mason City, IA · Accident · Serious injuries · Closed · May 13, 1968 · N7549AA · No damage
- [NTSB MKC68F0546](https://openairdocs.org/ntsb/MKC68F0546.md): Beech S35 · Knoxville, IA · Accident · No injuries · Closed · May 13, 1968 · N5660K · Substantial damage
- [NTSB MKC68F0549](https://openairdocs.org/ntsb/MKC68F0549.md): Piper PA-23 · Des Moines, IA · Accident · No injuries · Closed · May 10, 1968 · N4040P · Substantial damage
- [NTSB MKC68F0547](https://openairdocs.org/ntsb/MKC68F0547.md): Piper PA-22 · Forest City, IA · Accident · Minor injuries · Closed · May 8, 1968 · N8047C · Destroyed
- [NTSB MKC68D0555](https://openairdocs.org/ntsb/MKC68D0555.md): Cessna 150 · St.Paul, IA · Accident · Minor injuries · Closed · May 5, 1968 · N4030J · Substantial damage
- [NTSB MKC68D0543](https://openairdocs.org/ntsb/MKC68D0543.md): Cessna 172 · Jefferson, IA · Accident · No injuries · Closed · Apr 30, 1968 · N7474A · Substantial damage
- [NTSB MKC68D0563](https://openairdocs.org/ntsb/MKC68D0563.md): Cessna 172 · Keokuk, IA · Accident · No injuries · Closed · Apr 28, 1968 · N35344 · 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 MKC68F0514](https://openairdocs.org/ntsb/MKC68F0514.md): Beech F35 · Des Moines, IA · Accident · No injuries · Closed · Apr 23, 1968 · N4244B · Substantial damage
- [NTSB MKC68F0559](https://openairdocs.org/ntsb/MKC68F0559.md): Piper PA-23 · Thornton, IA · Accident · Serious injuries · Closed · Apr 22, 1968 · N3287P · Destroyed
- [NTSB MKC68D0524](https://openairdocs.org/ntsb/MKC68D0524.md): Cessna 206 · Shenandoah, IA · Accident · No injuries · Closed · Apr 13, 1968 · N5244U · Substantial damage
- [NTSB MKC68D0517](https://openairdocs.org/ntsb/MKC68D0517.md): Beech A23-24 · Leon, IA · Accident · No injuries · Closed · Apr 12, 1968 · N7907L · Substantial damage
- [NTSB MKC68A0060](https://openairdocs.org/ntsb/MKC68A0060.md): Cessna 182 · Shenandoah, IA · Accident · No injuries · Closed · Apr 12, 1968 · N3347R · Substantial damage
- [NTSB MKC68D0516](https://openairdocs.org/ntsb/MKC68D0516.md): Piper PA-28 · Storm Lake, IA · Accident · No injuries · Closed · Apr 11, 1968 · N8949J · Substantial damage
- [NTSB MKC68D0552](https://openairdocs.org/ntsb/MKC68D0552.md): Beech A23 · Dubuque, IA · Accident · No injuries · Closed · Apr 9, 1968 · N1418L · Substantial damage
- [NTSB MKC68D0518](https://openairdocs.org/ntsb/MKC68D0518.md): Cessna 172 · Chariton, IA · Accident · No injuries · Closed · Mar 23, 1968 · N1647Y · Substantial damage
- [NTSB MKC68D0486](https://openairdocs.org/ntsb/MKC68D0486.md): Cessna 177 · Mt Ayr, IA · Accident · No injuries · Closed · Mar 16, 1968 · N2605Q · Substantial damage
- [NTSB MKC68D0477](https://openairdocs.org/ntsb/MKC68D0477.md): Piper PA-28 · Ogden, IA · Accident · No injuries · Closed · Mar 8, 1968 · N9971J · Substantial damage
- [NTSB MKC68D0479](https://openairdocs.org/ntsb/MKC68D0479.md): Piper PA-22 · Marshalltown, IA · Accident · No injuries · Closed · Mar 3, 1968 · N8807D · Substantial damage
- [NTSB CHI68D0623](https://openairdocs.org/ntsb/CHI68D0623.md): Cessna 177 · Dodgeville, IA · Accident · No injuries · Closed · Feb 23, 1968 · N2363Y · Substantial damage
- [NTSB MKC68D0464](https://openairdocs.org/ntsb/MKC68D0464.md): Piper PA-32 · Denison, IA · Accident · No injuries · Closed · Feb 20, 1968 · N3447W · Substantial damage
- [NTSB MKC68A0054](https://openairdocs.org/ntsb/MKC68A0054.md): Bensen B8M · West Liberty, IA · Accident · 1 fatal · Closed · Feb 19, 1968 · N5315 · Destroyed
- [NTSB MKC68D0444](https://openairdocs.org/ntsb/MKC68D0444.md): Cessna 172F · Indianola, IA · Accident · No injuries · Closed · Feb 16, 1968 · N8272U · Destroyed
- [NTSB MKC68A0052](https://openairdocs.org/ntsb/MKC68A0052.md): Cessna P206A · Fort Madison, IA · Accident · Serious injuries · Closed · Feb 12, 1968 · N4653F · Substantial damage
- [NTSB MKC68A0049](https://openairdocs.org/ntsb/MKC68A0049.md): Bell 47G · Onawa, IA · Accident · No injuries · Closed · Feb 6, 1968 · N970B · Destroyed
- [NTSB MKC68D0439](https://openairdocs.org/ntsb/MKC68D0439.md): Cessna 150G · Dubuque, IA · Accident · Minor injuries · Closed · Jan 30, 1968 · N3954J · Substantial damage
- [NTSB MKC68D0437](https://openairdocs.org/ntsb/MKC68D0437.md): Piper PA-28 · Fairfield, IA · Accident · No injuries · Closed · Jan 26, 1968 · N8423R · Substantial damage
- [NTSB MKC68F0395](https://openairdocs.org/ntsb/MKC68F0395.md): Stinson 10 · Grimes, IA · Accident · No injuries · Closed · Dec 28, 1967 · N26290 · Substantial damage
- [NTSB MKC68D0399](https://openairdocs.org/ntsb/MKC68D0399.md): Cessna 172E · Agency, IA · Accident · No injuries · Closed · Dec 28, 1967 · N3684S · Substantial damage
- [NTSB MKC68A0042](https://openairdocs.org/ntsb/MKC68A0042.md): Cessna 210 · Ute, IA · Accident · No injuries · Closed · Dec 28, 1967 · N3672Y · 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 MKC68D0372](https://openairdocs.org/ntsb/MKC68D0372.md): Piper PA-22 · Marshalltown, IA · Accident · No injuries · Closed · Dec 16, 1967 · N6724B · Substantial damage
- [NTSB MKC68F0420](https://openairdocs.org/ntsb/MKC68F0420.md): Beech 65-A90 · Iowa City, IA · Accident · Minor injuries · Closed · Dec 12, 1967 · N772K · Substantial damage
- [NTSB MKC68D0373](https://openairdocs.org/ntsb/MKC68D0373.md): Piper PA-28 · Iowa City, IA · Accident · No injuries · Closed · Dec 12, 1967 · N6426W · Substantial damage
- [NTSB MKC68F0386](https://openairdocs.org/ntsb/MKC68F0386.md): Mooney M20E · Mt.Pleasant, IA · Accident · Serious injuries · Closed · Dec 6, 1967 · N1386W · Destroyed
- [NTSB MKC68A0036](https://openairdocs.org/ntsb/MKC68A0036.md): Mooney M20C · Davenport, IA · Accident · 3 fatal · Closed · Dec 3, 1967 · N5940Q · Destroyed
- [NTSB MKC68F0367](https://openairdocs.org/ntsb/MKC68F0367.md): Cessna 310L · Des Moines, IA · Accident · No injuries · Closed · Nov 26, 1967 · N2233F · Substantial damage
- [NTSB MKC68F0362](https://openairdocs.org/ntsb/MKC68F0362.md): Piper PA-22 · Ralston, IA · Accident · Minor injuries · Closed · Nov 26, 1967 · N947A · Destroyed
- [NTSB MKC68D0328](https://openairdocs.org/ntsb/MKC68D0328.md): Cessna 150 · Washington, IA · Accident · No injuries · Closed · Nov 17, 1967 · N7799F · Substantial damage
- [NTSB MKC68D0394](https://openairdocs.org/ntsb/MKC68D0394.md): Piper PA-28 · Davenport, IA · Accident · No injuries · Closed · Nov 15, 1967 · N5427W · Substantial damage
- [NTSB MKC68D0344](https://openairdocs.org/ntsb/MKC68D0344.md): Piper PA-22 · Maquoketa, IA · Accident · No injuries · Closed · Nov 12, 1967 · N6749B · Substantial damage
- [NTSB MKC68D0343](https://openairdocs.org/ntsb/MKC68D0343.md): Erco 415-D · Oelwein, IA · Accident · No injuries · Closed · Nov 11, 1967 · N94642 · Substantial damage
- [NTSB MKC68D0312](https://openairdocs.org/ntsb/MKC68D0312.md): Mooney 20F · Lamoni, IA · Accident · No injuries · Closed · Nov 11, 1967 · N9573M · Substantial damage
- [NTSB MKC68D0277](https://openairdocs.org/ntsb/MKC68D0277.md): Cessna 150 · Hamburg, IA · Accident · No injuries · Closed · Nov 6, 1967 · N3128J · Substantial damage
- [NTSB MKC68D0302](https://openairdocs.org/ntsb/MKC68D0302.md): Piper PA-28 · Creston, IA · Accident · No injuries · Closed · Nov 5, 1967 · N5256W · Substantial damage
- [NTSB MKC68F0281](https://openairdocs.org/ntsb/MKC68F0281.md): Mooney M20A · Indianola, IA · Accident · No injuries · Closed · Nov 3, 1967 · N6556B · Substantial damage
- [NTSB MKC68A0032](https://openairdocs.org/ntsb/MKC68A0032.md): Erco 415-C · Toledo, IA · Accident · 1 fatal · Closed · Oct 27, 1967 · N93588 · Destroyed
- [NTSB MKC68D0327](https://openairdocs.org/ntsb/MKC68D0327.md): Cessna 182 · Lamoni, IA · Accident · No injuries · Closed · Oct 21, 1967 · N3205U · Substantial damage

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

## 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=37&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.