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

## Cases, newest first

- [NTSB MKC80FCD21](https://openairdocs.org/ntsb/MKC80FCD21.md): Hughes 269C · Council Bluffs, IA · Accident · No injuries · Closed · Jul 23, 1980 · N8644F · Substantial damage
- [NTSB MKC80FA047](https://openairdocs.org/ntsb/MKC80FA047.md): Pitts S1 · Centerville, IA · Accident · 1 fatal · Closed · Jul 22, 1980 · N1012S · Destroyed
- [NTSB MKC80FCD26](https://openairdocs.org/ntsb/MKC80FCD26.md): Cessna 152 · Ames, IA · Accident · No injuries · Closed · Jul 19, 1980 · N4793B · Substantial damage
- [NTSB MKC80FCD25](https://openairdocs.org/ntsb/MKC80FCD25.md): Cessna U206 · Burlington, IA · Accident · No injuries · Closed · Jul 17, 1980 · N7562N · Substantial damage
- [NTSB MKC80FA043](https://openairdocs.org/ntsb/MKC80FA043.md): Cessna 401A · Spirit Lake, IA · Accident · Serious injuries · Closed · Jul 11, 1980 · N3249Q · Destroyed
- [NTSB MKC80FCD20](https://openairdocs.org/ntsb/MKC80FCD20.md): Cessna 182Q · Milford, IA · Accident · No injuries · Closed · Jul 10, 1980 · N759RC · Substantial damage
- [NTSB MKC80DCD19](https://openairdocs.org/ntsb/MKC80DCD19.md): Mooney M20F · Ft.Dodge, IA · Accident · No injuries · Closed · Jul 7, 1980 · N6397Q · Substantial damage
- [NTSB MKC80FCD18](https://openairdocs.org/ntsb/MKC80FCD18.md): Beech 95-D55 · Mason City, IA · Accident · No injuries · Closed · Jun 13, 1980 · N7952R · Substantial damage
- [NTSB MKC80FCD17](https://openairdocs.org/ntsb/MKC80FCD17.md): Boeing A75 · Sioux City, IA · Accident · No injuries · Closed · Jun 8, 1980 · N5568V · Substantial damage
- [NTSB MKC80FCD16](https://openairdocs.org/ntsb/MKC80FCD16.md): Piper J3C-65 · Danville, IA · Accident · Minor injuries · Closed · May 29, 1980 · N9814 · Substantial damage
- [NTSB MKC80DA033](https://openairdocs.org/ntsb/MKC80DA033.md): Raven S55A · Council Bluffs, IA · Accident · Serious injuries · Closed · May 3, 1980 · N1089R · Substantial damage
- [NTSB MKC80DA032](https://openairdocs.org/ntsb/MKC80DA032.md): Beech 18S · Cedar Rapids, IA · Accident · No injuries · Closed · Apr 24, 1980 · N166H · Substantial damage
- [NTSB MKC80FCD15](https://openairdocs.org/ntsb/MKC80FCD15.md): Mcculley Quicki · Muscatine, IA · Accident · Minor injuries · Closed · Apr 17, 1980 · N9038Z · Substantial damage
- [NTSB MKC80FCD14](https://openairdocs.org/ntsb/MKC80FCD14.md): Cessna 210L · Clear Lake, IA · Accident · Serious injuries · Closed · Apr 2, 1980 · N59168 · Substantial damage
- [NTSB MKC80AA026](https://openairdocs.org/ntsb/MKC80AA026.md): Aerospatle AS350D · Webster City, IA · Accident · 3 fatal · Closed · Mar 3, 1980 · N353RM · Destroyed
- [NTSB MKC80FA024](https://openairdocs.org/ntsb/MKC80FA024.md): Grum-Amer AA-5B · Spencer, IA · Accident · 2 fatal · Closed · Feb 21, 1980 · N74028 · Destroyed
- [NTSB MKC80FCD13](https://openairdocs.org/ntsb/MKC80FCD13.md): Beech E33A · Carroll, IA · Accident · Minor injuries · Closed · Feb 20, 1980 · N29880 · Substantial damage
- [NTSB MKC80FA022](https://openairdocs.org/ntsb/MKC80FA022.md): Beech A35 · Creston, IA · Accident · Serious injuries · Closed · Feb 14, 1980 · N71RT · Destroyed
- [NTSB MKC80FCD12](https://openairdocs.org/ntsb/MKC80FCD12.md): Cessna 185 · Creston, IA · Accident · No injuries · Closed · Feb 7, 1980 · N7377H · Substantial damage
- [NTSB MKC80FCD11](https://openairdocs.org/ntsb/MKC80FCD11.md): Piper PA-28R · Ankeny, IA · Accident · No injuries · Closed · Jan 27, 1980 · N57305 · Substantial damage
- [NTSB MKC80FA019](https://openairdocs.org/ntsb/MKC80FA019.md): Piper PA-28 · Clare, IA · Accident · 4 fatal · Closed · Jan 25, 1980 · N9421C · Destroyed
- [NTSB MKC80DCD10](https://openairdocs.org/ntsb/MKC80DCD10.md): Cessna U206 · West Union, IA · Accident · No injuries · Closed · Jan 11, 1980 · N733WF · Substantial damage
- [NTSB MKC80FCD09](https://openairdocs.org/ntsb/MKC80FCD09.md): Cessna 177RG · Greenfield, IA · Accident · No injuries · Closed · Dec 22, 1979 · N52195 · Substantial damage
- [NTSB MKC80FCD08](https://openairdocs.org/ntsb/MKC80FCD08.md): Cessna 150 · Maquoketa, IA · Accident · No injuries · Closed · Dec 9, 1979 · N16129 · Substantial damage
- [NTSB MKC80FA012](https://openairdocs.org/ntsb/MKC80FA012.md): Aerospatle 319B · Baxter, IA · Accident · No injuries · Closed · Dec 7, 1979 · N90825 · Substantial damage
- [NTSB MKC80FCD07](https://openairdocs.org/ntsb/MKC80FCD07.md): Beech C35 · Somers, IA · Accident · No injuries · Closed · Nov 30, 1979 · N8976A · Substantial damage
- [NTSB UNK80X0102](https://openairdocs.org/ntsb/UNK80X0102.md): Piper PA-28 · Melvin, IA · Accident · 1 fatal · Closed · Nov 11, 1979 · N2181D · Destroyed
- [NTSB MKC80FCD06](https://openairdocs.org/ntsb/MKC80FCD06.md): Luscombe 8A · Winterset, IA · Accident · No injuries · Closed · Nov 4, 1979 · N41961 · Substantial damage
- [NTSB MKC80FCD04](https://openairdocs.org/ntsb/MKC80FCD04.md): Piper PA-22 · Des Moines, IA · Accident · No injuries · Closed · Oct 28, 1979 · N8731C · Substantial damage
- [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 MKC80DCD03](https://openairdocs.org/ntsb/MKC80DCD03.md): Piper PA-28 · Oelwein, IA · Accident · No injuries · Closed · Oct 24, 1979 · N538FL · Substantial damage
- [NTSB MKC80DCD02](https://openairdocs.org/ntsb/MKC80DCD02.md): Aeronca 7AC · Lamotte, IA · Accident · No injuries · Closed · Oct 17, 1979 · N83589 · Substantial damage
- [NTSB MKC80DCD01](https://openairdocs.org/ntsb/MKC80DCD01.md): Cessna 150 · New Hampton, IA · Accident · No injuries · Closed · Oct 7, 1979 · N5937J · Substantial damage
- [NTSB MKC79DCD44](https://openairdocs.org/ntsb/MKC79DCD44.md): Piper PA-25 · Lost Nation, IA · Accident · No injuries · Closed · Sep 30, 1979 · N4957Y · Destroyed
- [NTSB MKC79DCD43](https://openairdocs.org/ntsb/MKC79DCD43.md): Piper PA-28 · Wever, IA · Accident · No injuries · Closed · Sep 29, 1979 · N5556F · Substantial damage
- [NTSB MKC79DCD42](https://openairdocs.org/ntsb/MKC79DCD42.md): Cessna 182P · Kossuth, IA · Accident · No injuries · Closed · Sep 27, 1979 · N7337Q · Substantial damage
- [NTSB MKC79FCD45](https://openairdocs.org/ntsb/MKC79FCD45.md): Piper J-3 · Madrid, IA · Accident · Minor injuries · Closed · Sep 25, 1979 · N98602 · Substantial damage
- [NTSB MKC79FCD41](https://openairdocs.org/ntsb/MKC79FCD41.md): Bell 47G-3B · Pierson, IA · Accident · Serious injuries · Closed · Sep 25, 1979 · N8471E · Substantial damage
- [NTSB MKC79DCD40](https://openairdocs.org/ntsb/MKC79DCD40.md): Cessna 152 · Oxford, IA · Accident · No injuries · Closed · Sep 12, 1979 · N65465 · Substantial damage
- [NTSB MKC79DCD38](https://openairdocs.org/ntsb/MKC79DCD38.md): Mooney M20C · Waverly, IA · Accident · No injuries · Closed · Sep 9, 1979 · N6419U · Substantial damage
- [NTSB MKC79DCD37](https://openairdocs.org/ntsb/MKC79DCD37.md): Piper PA-36 · Manning, IA · Accident · No injuries · Closed · Sep 7, 1979 · N3881E · Substantial damage
- [NTSB MKC79DCD36](https://openairdocs.org/ntsb/MKC79DCD36.md): Grumman G-164 · Masonville, IA · Accident · No injuries · Closed · Aug 29, 1979 · N13MZ · Destroyed
- [NTSB MKC79DCD34](https://openairdocs.org/ntsb/MKC79DCD34.md): Luscombe 8E · Oskaloosa, IA · Accident · No injuries · Closed · Aug 28, 1979 · N2518K · Substantial damage
- [NTSB MKC79DCD35](https://openairdocs.org/ntsb/MKC79DCD35.md): Cessna 152 · Mt Pleasant, IA · Accident · No injuries · Closed · Aug 27, 1979 · N24366 · Substantial damage
- [NTSB MKC79DCD39](https://openairdocs.org/ntsb/MKC79DCD39.md): Cessna 172B · Council Bluffs, IA · Accident · No injuries · Closed · Aug 20, 1979 · N7521X · Substantial damage
- [NTSB MKC79FCD33](https://openairdocs.org/ntsb/MKC79FCD33.md): Cessna 210 · Fostoria, IA · Accident · Serious injuries · Closed · Aug 19, 1979 · N732WZ · Destroyed
- [NTSB MKC79DCD32](https://openairdocs.org/ntsb/MKC79DCD32.md): Piper PA-28 · Davenport, IA · Accident · Minor injuries · Closed · Aug 17, 1979 · N4360F · Substantial damage
- [NTSB MKC79FA043](https://openairdocs.org/ntsb/MKC79FA043.md): Cessna 150F · Independence, IA · Accident · 1 fatal · Closed · Jul 26, 1979 · N6879F · Destroyed
- [NTSB MKC79DCD31](https://openairdocs.org/ntsb/MKC79DCD31.md): Cessna 180 · Lawton, IA · Accident · No injuries · Closed · Jul 14, 1979 · N4626B · Substantial damage
- [NTSB MKC79DCD29](https://openairdocs.org/ntsb/MKC79DCD29.md): Piper PA-38 · Ladora, IA · Accident · No injuries · Closed · Jul 10, 1979 · N2313A · Substantial damage

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

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