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

## Cases, newest first

- [NTSB MKC77DCD48](https://openairdocs.org/ntsb/MKC77DCD48.md): Piper PA-28 · Lamoni, IA · Accident · Minor injuries · Closed · Sep 11, 1977 · N2945Q · Substantial damage
- [NTSB MKC77DCD47](https://openairdocs.org/ntsb/MKC77DCD47.md): Beech B19 · Akron, IA · Accident · No injuries · Closed · Sep 11, 1977 · N9174S · Substantial damage
- [NTSB MKC77DCD46](https://openairdocs.org/ntsb/MKC77DCD46.md): Piper PA-28 · Indianola, IA · Accident · No injuries · Closed · Sep 9, 1977 · N453 · Substantial damage
- [NTSB MKC77DCD45](https://openairdocs.org/ntsb/MKC77DCD45.md): Cessna 177 · Rock Rapids, IA · Accident · No injuries · Closed · Sep 7, 1977 · N30407 · Substantial damage
- [NTSB MKC77FCD43](https://openairdocs.org/ntsb/MKC77FCD43.md): Piper PA-24 · Blakesburg, IA · Accident · No injuries · Closed · Sep 4, 1977 · N5071P · Substantial damage
- [NTSB MKC77FCD44](https://openairdocs.org/ntsb/MKC77FCD44.md): Cessna 210M · Knoxville, IA · Accident · No injuries · Closed · Sep 1, 1977 · N732WX · Substantial damage
- [NTSB MKC77DCD42](https://openairdocs.org/ntsb/MKC77DCD42.md): Piper PA-28 · Burlington, IA · Accident · No injuries · Closed · Aug 27, 1977 · N15203 · Substantial damage
- [NTSB MKC77FCD41](https://openairdocs.org/ntsb/MKC77FCD41.md): Bell 47G5 · Denison, IA · Accident · Serious injuries · Closed · Aug 23, 1977 · N4095G · Destroyed
- [NTSB MKC77DCD40](https://openairdocs.org/ntsb/MKC77DCD40.md): Piper PA-22 · Pocahontas, IA · Accident · No injuries · Closed · Aug 12, 1977 · N2371A · Substantial damage
- [NTSB MKC77DCD39](https://openairdocs.org/ntsb/MKC77DCD39.md): Piper PA-24 · Council Bluffs, IA · Accident · No injuries · Closed · Aug 10, 1977 · N5368P · Substantial damage
- [NTSB MKC77FCD38](https://openairdocs.org/ntsb/MKC77FCD38.md): Bellanca 7GCBC · Fort Madison, IA · Accident · No injuries · Closed · Aug 2, 1977 · N88050 · Substantial damage
- [NTSB MKC77FCD36](https://openairdocs.org/ntsb/MKC77FCD36.md): Beech 23 · Runnells, IA · Accident · No injuries · Closed · Jul 29, 1977 · N9213S · Substantial damage
- [NTSB MKC77FCD35](https://openairdocs.org/ntsb/MKC77FCD35-201264.md): Cessna 170B · Dubuque, IA · Accident · No injuries · Closed · Jul 21, 1977 · N2788D · Substantial damage
- [NTSB MKC77FCD34](https://openairdocs.org/ntsb/MKC77FCD34.md): Piper PA-28 · New Liberty, IA · Accident · No injuries · Closed · Jul 20, 1977 · N5508U · Substantial damage
- [NTSB MKC77DCD32](https://openairdocs.org/ntsb/MKC77DCD32.md): Piper PA-25 · Minden, IA · Accident · No injuries · Closed · Jul 16, 1977 · N4826Y · Substantial damage
- [NTSB MKC77FCD35](https://openairdocs.org/ntsb/MKC77FCD35-146553.md): Grumman G-164 · Boone, IA · Accident · Serious injuries · Closed · Jul 15, 1977 · N12LW · Destroyed
- [NTSB MKC77FCD30](https://openairdocs.org/ntsb/MKC77FCD30.md): Beech 35 · Clinton, IA · Accident · No injuries · Closed · Jul 13, 1977 · N3191V · Substantial damage
- [NTSB MKC77FCD29](https://openairdocs.org/ntsb/MKC77FCD29.md): Hiller Acft 12E · Reasoner, IA · Accident · No injuries · Closed · Jul 11, 1977 · N3351F · Substantial damage
- [NTSB MKC77FCD27](https://openairdocs.org/ntsb/MKC77FCD27.md): Piper PA-25 · Woodbine, IA · Accident · 1 fatal · Closed · Jul 6, 1977 · N8800L · Destroyed
- [NTSB MKC77FCD33](https://openairdocs.org/ntsb/MKC77FCD33.md): Amer Avco AA-5A · Osage, IA · Accident · No injuries · Closed · Jul 4, 1977 · N9580U · Substantial damage
- [NTSB MKC77FCD25](https://openairdocs.org/ntsb/MKC77FCD25.md): Erco 415C · Runnells, IA · Accident · Minor injuries · Closed · Jul 4, 1977 · N99259 · Destroyed
- [NTSB MKC77FCD28](https://openairdocs.org/ntsb/MKC77FCD28.md): Amer Avco AA-5A · Boone, IA · Accident · No injuries · Closed · Jul 3, 1977 · N9873U · Substantial damage
- [NTSB MKC77FCD26](https://openairdocs.org/ntsb/MKC77FCD26.md): Cessna 421 · Cedar Rapids, IA · Accident · No injuries · Closed · Jul 1, 1977 · N4048L · Substantial damage
- [NTSB MKC77DCD37](https://openairdocs.org/ntsb/MKC77DCD37.md): Hughes 269B · Hawkeye, IA · Accident · No injuries · Closed · Jun 29, 1977 · N9357F · Substantial damage
- [NTSB MKC77DCD24](https://openairdocs.org/ntsb/MKC77DCD24.md): Bellanca 7GCAA · Moulton, IA · Accident · No injuries · Closed · Jun 27, 1977 · N8739 · Substantial damage
- [NTSB MKC77FCD22](https://openairdocs.org/ntsb/MKC77FCD22.md): Grum Amer AA5B · Lake Mills, IA · Accident · No injuries · Closed · Jun 20, 1977 · N74864 · Substantial damage
- [NTSB MKC77FA027](https://openairdocs.org/ntsb/MKC77FA027.md): Cessna 172 · Cedar Rapids, IA · Accident · 2 fatal · Closed · Jun 18, 1977 · N5172F · Substantial damage
- [NTSB MKC77FCD23](https://openairdocs.org/ntsb/MKC77FCD23.md): Morris Cass 111M · Winterset, IA · Accident · 1 fatal · Closed · Jun 17, 1977 · N90RM · Destroyed
- [NTSB MKC77FCD21](https://openairdocs.org/ntsb/MKC77FCD21.md): Cessna 206 · Ames, IA · Accident · No injuries · Closed · May 25, 1977 · N188AS · Substantial damage
- [NTSB MKC77FCD20](https://openairdocs.org/ntsb/MKC77FCD20.md): Piper PA-28 · Oskaloosa, IA · Accident · No injuries · Closed · May 22, 1977 · N4646J · Substantial damage
- [NTSB MKC77FCD19](https://openairdocs.org/ntsb/MKC77FCD19.md): Cessna 150M · Council Bluffs, IA · Accident · Serious injuries · Closed · May 14, 1977 · N66248 · Destroyed
- [NTSB MKC77FCD18](https://openairdocs.org/ntsb/MKC77FCD18.md): Piper PA-28 · Iowa City, IA · Accident · Serious injuries · Closed · May 12, 1977 · N5177S · Substantial damage
- [NTSB MKC77FCD17](https://openairdocs.org/ntsb/MKC77FCD17.md): Beech E55 · Davenport, IA · Accident · No injuries · Closed · May 5, 1977 · N1587W · Substantial damage
- [NTSB MKC77FCD16](https://openairdocs.org/ntsb/MKC77FCD16.md): Cessna 150 · West Union, IA · Accident · No injuries · Closed · May 1, 1977 · N19379 · Substantial damage
- [NTSB MKC77FCD15](https://openairdocs.org/ntsb/MKC77FCD15.md): Piper PA-18 · Ankeny, IA · Accident · No injuries · Closed · Apr 1, 1977 · N4367Z · Substantial damage
- [NTSB MKC77FCD14](https://openairdocs.org/ntsb/MKC77FCD14.md): Piper PA-24 · Spirit Lake, IA · Accident · Serious injuries · Closed · Mar 20, 1977 · N8623P · Substantial damage
- [NTSB MKC77FA017](https://openairdocs.org/ntsb/MKC77FA017.md): Cessna T210L · Atkins, IA · Accident · 3 fatal · Closed · Mar 19, 1977 · N2231S · Destroyed
- [NTSB MKC77FCD13](https://openairdocs.org/ntsb/MKC77FCD13.md): Cessna 150H · Belmond, IA · Accident · Minor injuries · Closed · Mar 6, 1977 · N22595 · Substantial damage
- [NTSB MKC77FA014](https://openairdocs.org/ntsb/MKC77FA014.md): Beech S-35 · Sioux City, IA · Accident · 1 fatal · Closed · Feb 17, 1977 · N5694K · Destroyed
- [NTSB MKC77DCD12](https://openairdocs.org/ntsb/MKC77DCD12.md): Cessna 182 · Clarion, IA · Accident · No injuries · Closed · Feb 17, 1977 · N2508R · Substantial damage
- [NTSB MKC77FCD10](https://openairdocs.org/ntsb/MKC77FCD10.md): Piper PA-24 · Waterloo, IA · Accident · Serious injuries · Closed · Feb 10, 1977 · N5196P · Destroyed
- [NTSB MKC77DCD11](https://openairdocs.org/ntsb/MKC77DCD11.md): Cessna 150 · Oxford, IA · Accident · No injuries · Closed · Feb 10, 1977 · N7996F · Substantial damage
- [NTSB MKC77DCD09](https://openairdocs.org/ntsb/MKC77DCD09.md): Cessna 172XP · Harlan, IA · Accident · No injuries · Closed · Feb 10, 1977 · N6115K · Substantial damage
- [NTSB MKC77FCD08](https://openairdocs.org/ntsb/MKC77FCD08.md): Bellanca 17-30A · Des Moines, IA · Accident · No injuries · Closed · Feb 6, 1977 · N9531E · Substantial damage
- [NTSB MKC77FCD07](https://openairdocs.org/ntsb/MKC77FCD07.md): Stinson 108 · Griswold, IA · Accident · No injuries · Closed · Jan 7, 1977 · N8035K · Substantial damage
- [NTSB MKC77FCD06](https://openairdocs.org/ntsb/MKC77FCD06.md): Aero-Star 600 · Pella, IA · Accident · Minor injuries · Closed · Dec 29, 1976 · N7468S · Substantial damage
- [NTSB MKC77IA008](https://openairdocs.org/ntsb/MKC77IA008.md): Piper PA-28 · Muscatine, IA · Incident · No injuries · Closed · Dec 16, 1976 · N6474W · 2 aircraft · Minor damage
- [NTSB MKC77DCD05](https://openairdocs.org/ntsb/MKC77DCD05.md): Cessna 150H · Solon, IA · Accident · No injuries · Closed · Dec 12, 1976 · N22938 · Substantial damage
- [NTSB MKC77FA003](https://openairdocs.org/ntsb/MKC77FA003.md): Beech B99 · Spencer, IA · Accident · Serious injuries · Closed · Nov 19, 1976 · N8099R · Substantial damage
- [NTSB MKC77DCD04](https://openairdocs.org/ntsb/MKC77DCD04.md): Piper PA-28 · Atlantic, IA · Accident · No injuries · Closed · Nov 15, 1976 · N8701N · Substantial damage

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

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