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

## Cases, newest first

- [NTSB MKC78DCD40](https://openairdocs.org/ntsb/MKC78DCD40.md): Cessna 170B · Mason City, IA · Accident · No injuries · Closed · Jul 28, 1978 · N2757D · Substantial damage
- [NTSB CHI78IA050](https://openairdocs.org/ntsb/CHI78IA050.md): Boeing 727 · Lamoni, IA · Incident · No injuries · Closed · Jul 15, 1978 · N7409U · No damage
- [NTSB MKC78FCD39](https://openairdocs.org/ntsb/MKC78FCD39.md): Skylark WC-3 · Eagle Grove, IA · Accident · 2 fatal · Closed · Jul 10, 1978 · N214JC · Destroyed
- [NTSB MKC78DCD37](https://openairdocs.org/ntsb/MKC78DCD37.md): Cessna 152 · Emmetsburg, IA · Accident · No injuries · Closed · Jul 6, 1978 · N49154 · Substantial damage
- [NTSB MKC78DCD38](https://openairdocs.org/ntsb/MKC78DCD38.md): Piper PA-36 · Steamboat Rock, IA · Accident · No injuries · Closed · Jul 5, 1978 · N57703 · Destroyed
- [NTSB MKC78FCD36](https://openairdocs.org/ntsb/MKC78FCD36.md): Piper PA-23 · Olin, IA · Accident · No injuries · Closed · Jul 2, 1978 · N21CG · Substantial damage
- [NTSB MKC78FA053](https://openairdocs.org/ntsb/MKC78FA053.md): Piper PA-32 · Denison, IA · Accident · 4 fatal · Closed · Jul 1, 1978 · N5510J · Destroyed
- [NTSB MKC78DCD35](https://openairdocs.org/ntsb/MKC78DCD35.md): Piper PA-28 · Paullina, IA · Accident · Minor injuries · Closed · Jun 27, 1978 · N5276S · Substantial damage
- [NTSB MKC78DCD34](https://openairdocs.org/ntsb/MKC78DCD34.md): Bell 47J-2 · Burlington, IA · Accident · No injuries · Closed · Jun 18, 1978 · N23MA · Destroyed
- [NTSB MKC78FCD33](https://openairdocs.org/ntsb/MKC78FCD33.md): Piper PA-28 · Washington, IA · Accident · No injuries · Closed · Jun 4, 1978 · N8835N · Substantial damage
- [NTSB MKC78DCD32](https://openairdocs.org/ntsb/MKC78DCD32.md): Starduster 11 · Davenport, IA · Accident · No injuries · Closed · Jun 4, 1978 · N50JB · Substantial damage
- [NTSB MKC78FA033](https://openairdocs.org/ntsb/MKC78FA033-140593.md): Bellanca 8KCAB · Council Bluffs, IA · Accident · 1 fatal · Closed · Jun 2, 1978 · N57463 · Destroyed
- [NTSB MKC78DCD30](https://openairdocs.org/ntsb/MKC78DCD30.md): Cessna 188 · Atlantic, IA · Accident · No injuries · Closed · May 31, 1978 · N9921G · Substantial damage
- [NTSB MKC78FCD31](https://openairdocs.org/ntsb/MKC78FCD31.md): Piper PA-28R · Iowa City, IA · Accident · No injuries · Closed · May 30, 1978 · N2895T · Substantial damage
- [NTSB MKC78FCD29](https://openairdocs.org/ntsb/MKC78FCD29.md): Grumman AA-5 · Goldfield, IA · Accident · Minor injuries · Closed · May 28, 1978 · N7135L · Substantial damage
- [NTSB MKC78FCD28](https://openairdocs.org/ntsb/MKC78FCD28.md): Jungster 1 · Monticello, IA · Accident · Minor injuries · Closed · May 24, 1978 · N47M · Substantial damage
- [NTSB MKC78FCD27](https://openairdocs.org/ntsb/MKC78FCD27.md): Piper PA-28 · Anamosa, IA · Accident · No injuries · Closed · May 24, 1978 · N5192W · Substantial damage
- [NTSB MKC78FCD26](https://openairdocs.org/ntsb/MKC78FCD26.md): Cessna 150 · Ladora, IA · Accident · No injuries · Closed · May 24, 1978 · N16117 · Substantial damage
- [NTSB MKC78FCD25](https://openairdocs.org/ntsb/MKC78FCD25.md): Piper PA-11 · Terril, IA · Accident · Serious injuries · Closed · May 23, 1978 · N78615 · Substantial damage
- [NTSB MKC79FCD24](https://openairdocs.org/ntsb/MKC79FCD24-202544.md): Campbell KR-1 · Boone, IA · Accident · No injuries · Closed · May 20, 1978 · N21KC · Substantial damage
- [NTSB MKC78FCD23](https://openairdocs.org/ntsb/MKC78FCD23.md): Cessna 150L · Des Moines, IA · Accident · Serious injuries · Closed · May 12, 1978 · N11474 · Substantial damage
- [NTSB MKC78FCD22](https://openairdocs.org/ntsb/MKC78FCD22.md): Cessna 402B · Keokuk, IA · Accident · No injuries · Closed · May 11, 1978 · N44NC · Substantial damage
- [NTSB MKC78FCD20](https://openairdocs.org/ntsb/MKC78FCD20.md): Cessna 177 · Des Moines, IA · Accident · No injuries · Closed · May 10, 1978 · N3158T · Substantial damage
- [NTSB MKC78FCD21](https://openairdocs.org/ntsb/MKC78FCD21.md): Piper PA-28 · Fairfield, IA · Accident · Minor injuries · Closed · May 9, 1978 · N1490X · Substantial damage
- [NTSB MKC78FCD19](https://openairdocs.org/ntsb/MKC78FCD19.md): Piper PA-32 · Washington, IA · Accident · No injuries · Closed · May 4, 1978 · N2DP · Substantial damage
- [NTSB MKC78FCD18](https://openairdocs.org/ntsb/MKC78FCD18.md): Luscombe 8A · 0ttumwa, IA · Accident · No injuries · Closed · May 2, 1978 · N1282B · Substantial damage
- [NTSB MKC78FA034](https://openairdocs.org/ntsb/MKC78FA034.md): Beech S-35 · Audubon, IA · Accident · 5 fatal · Closed · Apr 29, 1978 · N7971K · Destroyed
- [NTSB MKC78DCD17](https://openairdocs.org/ntsb/MKC78DCD17.md): Cessna 150 · Cumberland, IA · Accident · No injuries · Closed · Apr 14, 1978 · N714KJ · Substantial damage
- [NTSB MKC78FCD16](https://openairdocs.org/ntsb/MKC78FCD16.md): Piper PA-28 · Bedford, IA · Accident · No injuries · Closed · Apr 13, 1978 · N5812W · Substantial damage
- [NTSB MKC78FCD14](https://openairdocs.org/ntsb/MKC78FCD14.md): Cessna 175A · Mason City, IA · Accident · No injuries · Closed · Mar 21, 1978 · N111JJ · Substantial damage
- [NTSB MKC78FA030](https://openairdocs.org/ntsb/MKC78FA030.md): Convair 340 · Elma, IA · Accident · No injuries · Closed · Mar 21, 1978 · N4807C · Destroyed
- [NTSB MKC78DCD13](https://openairdocs.org/ntsb/MKC78DCD13.md): Cessna A185F · Muscatine, IA · Accident · No injuries · Closed · Mar 1, 1978 · N2045Q · Substantial damage
- [NTSB MKC78IA023](https://openairdocs.org/ntsb/MKC78IA023.md): Piper PA-23 · Marshalltown, IA · Incident · No injuries · Closed · Feb 22, 1978 · N88SS · Minor damage
- [NTSB MKC78DCD12](https://openairdocs.org/ntsb/MKC78DCD12.md): Cessna 152 · Ankeny, IA · Accident · No injuries · Closed · Feb 18, 1978 · N24374 · Substantial damage
- [NTSB MKC78DCD11](https://openairdocs.org/ntsb/MKC78DCD11.md): Beech A24 · Des Moines, IA · Accident · No injuries · Closed · Feb 15, 1978 · N6927Q · Substantial damage
- [NTSB MKC78DCD15](https://openairdocs.org/ntsb/MKC78DCD15.md): Cessna 140 · Shenandoah, IA · Accident · No injuries · Closed · Jan 28, 1978 · N72750 · Substantial damage
- [NTSB MKC78FA020](https://openairdocs.org/ntsb/MKC78FA020.md): Piper PA-22 · Tama, IA · Accident · 3 fatal · Closed · Jan 15, 1978 · N6819B · Destroyed
- [NTSB MKC78DA019](https://openairdocs.org/ntsb/MKC78DA019.md): Cessna 310R · Muscatine, IA · Accident · No injuries · Closed · Jan 12, 1978 · N5080J · Substantial damage
- [NTSB MKC78DCD10](https://openairdocs.org/ntsb/MKC78DCD10.md): Cessna 150 · Tipton, IA · Accident · Minor injuries · Closed · Dec 22, 1977 · N66055 · Substantial damage
- [NTSB MKC78FA014](https://openairdocs.org/ntsb/MKC78FA014.md): Piper PA-28R · Waukon, IA · Accident · 1 fatal · Closed · Dec 16, 1977 · N44988 · Destroyed
- [NTSB MKC78FA013](https://openairdocs.org/ntsb/MKC78FA013.md): Piper PA-34 · Davenport, IA · Accident · 2 fatal · Closed · Dec 14, 1977 · N1634H · Destroyed
- [NTSB MKC78FA008](https://openairdocs.org/ntsb/MKC78FA008.md): Bellanca 8KCAB · Inwood, IA · Accident · 2 fatal · Closed · Nov 28, 1977 · N12PG · Destroyed
- [NTSB MKC78FCD09](https://openairdocs.org/ntsb/MKC78FCD09.md): Piper PA-31T · Des Moines, IA · Accident · Minor injuries · Closed · Oct 26, 1977 · N35RT · Substantial damage
- [NTSB MKC78FCD08](https://openairdocs.org/ntsb/MKC78FCD08.md): Cessna 172M · Lamoni, IA · Accident · Serious injuries · Closed · Oct 21, 1977 · N21210 · Substantial damage
- [NTSB MKC78FCD06](https://openairdocs.org/ntsb/MKC78FCD06.md): Cessna 140 · Ankeny, IA · Accident · No injuries · Closed · Oct 19, 1977 · N2419V · Substantial damage
- [NTSB MKC78DCD07](https://openairdocs.org/ntsb/MKC78DCD07.md): Cessna 150 · Des Moines, IA · Accident · Minor injuries · Closed · Oct 14, 1977 · N714EF · Substantial damage
- [NTSB MKC78FCD03](https://openairdocs.org/ntsb/MKC78FCD03.md): Ryan Navion · Moulton, IA · Accident · Serious injuries · Closed · Oct 13, 1977 · N4801K · Destroyed
- [NTSB MKC78DCD04](https://openairdocs.org/ntsb/MKC78DCD04.md): Erco 415C · Alton, IA · Accident · Minor injuries · Closed · Oct 13, 1977 · N87272 · Substantial damage
- [NTSB MKC78DCD01](https://openairdocs.org/ntsb/MKC78DCD01.md): Beech B33 · Des Moines, IA · Accident · No injuries · Closed · Oct 5, 1977 · N3EM · Substantial damage
- [NTSB MKC77DCD49](https://openairdocs.org/ntsb/MKC77DCD49.md): Piper PA-12 · Denison, IA · Accident · No injuries · Closed · Sep 13, 1977 · N2758M · Substantial damage

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

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