# 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 29 of 45 · 2,216 cases ## Cases, newest first - [NTSB MKC73FCD10](https://openairdocs.org/ntsb/MKC73FCD10.md): Piper PA-30 · Sully, IA · Accident · Serious injuries · Closed · Jul 30, 1972 · N8798Y · Destroyed - [NTSB MKC73DCD14](https://openairdocs.org/ntsb/MKC73DCD14.md): Piper PA-28 · Moorland, IA · Accident · No injuries · Closed · Jul 30, 1972 · N8663W · Substantial damage - [NTSB MKC73FCD24](https://openairdocs.org/ntsb/MKC73FCD24.md): Cessna 150H · Oskaloosa, IA · Accident · No injuries · Closed · Jul 25, 1972 · N23448 · Substantial damage - [NTSB MKC73DCD06](https://openairdocs.org/ntsb/MKC73DCD06.md): Cessna 140 · Toledo, IA · Accident · No injuries · Closed · Jul 23, 1972 · N1859V · Substantial damage - [NTSB MKC73DCD05](https://openairdocs.org/ntsb/MKC73DCD05.md): Mooney M20C · Radcliffe, IA · Accident · No injuries · Closed · Jul 20, 1972 · N9322V · Substantial damage - [NTSB MKC73FCD03](https://openairdocs.org/ntsb/MKC73FCD03.md): Cessna 180 · Iowa City, IA · Accident · No injuries · Closed · Jul 16, 1972 · N1508C · 2 aircraft · Minor damage - [NTSB MKC73DCD08](https://openairdocs.org/ntsb/MKC73DCD08.md): Stinson 10A · Kiron, IA · Accident · No injuries · Closed · Jul 16, 1972 · N39492 · Substantial damage - [NTSB MKC73DCD02](https://openairdocs.org/ntsb/MKC73DCD02.md): Mooney M20C · Belle Plaine, IA · Accident · Minor injuries · Closed · Jul 16, 1972 · N6295U · Substantial damage - [NTSB MKC73FCD04](https://openairdocs.org/ntsb/MKC73FCD04.md): Grumman G164 · Northwood, IA · Accident · Serious injuries · Closed · Jul 15, 1972 · N7228 · Destroyed - [NTSB MKC73DCD07](https://openairdocs.org/ntsb/MKC73DCD07.md): Cessna 172I · Traer, IA · Accident · No injuries · Closed · Jul 14, 1972 · N8344L · Substantial damage - [NTSB MKC73DCD01](https://openairdocs.org/ntsb/MKC73DCD01.md): Cessna 172H · Cresco, IA · Accident · No injuries · Closed · Jul 8, 1972 · N1433F · Substantial damage - [NTSB MKC72DCD74](https://openairdocs.org/ntsb/MKC72DCD74.md): Grumman G-164A · Ottumwa, IA · Accident · Minor injuries · Closed · Jun 6, 1972 · N8384 · Destroyed - [NTSB MKC72DCD75](https://openairdocs.org/ntsb/MKC72DCD75.md): Beech V35 · Akron, IA · Accident · No injuries · Closed · Jun 4, 1972 · N5453U · Substantial damage - [NTSB MKC72DCD73](https://openairdocs.org/ntsb/MKC72DCD73.md): Stinson 10A · Troy Mills, IA · Accident · Minor injuries · Closed · Jun 4, 1972 · N39485 · Substantial damage - [NTSB MKC72DCD72](https://openairdocs.org/ntsb/MKC72DCD72.md): Luscombe 8A · Missouri Vly, IA · Accident · No injuries · Closed · May 27, 1972 · N71365 · Substantial damage - [NTSB MKC72FCD70](https://openairdocs.org/ntsb/MKC72FCD70.md): Cessna 172K · Des Moines, IA · Accident · No injuries · Closed · May 25, 1972 · N46498 · Substantial damage - [NTSB MKC72FCD68](https://openairdocs.org/ntsb/MKC72FCD68.md): Cessna 172 · Storm Lake, IA · Accident · No injuries · Closed · May 20, 1972 · N7497A · Substantial damage - [NTSB MKC72AK061](https://openairdocs.org/ntsb/MKC72AK061.md): Cessna 150K · Grimes, IA · Accident · 2 fatal · Closed · May 18, 1972 · N8461M · Destroyed - [NTSB MKC72DCD69](https://openairdocs.org/ntsb/MKC72DCD69.md): Beech B35 · Garner, IA · Accident · No injuries · Closed · May 12, 1972 · N1177 · Substantial damage - [NTSB MKC72DCD71](https://openairdocs.org/ntsb/MKC72DCD71.md): Cessna 150G · Marion, IA · Accident · No injuries · Closed · May 11, 1972 · N2979J · Substantial damage - [NTSB MKC72DCD67](https://openairdocs.org/ntsb/MKC72DCD67.md): Cessna 185 · Council Blfs, IA · Accident · No injuries · Closed · Apr 17, 1972 · N4010Y · Destroyed - [NTSB MKC72DCD66](https://openairdocs.org/ntsb/MKC72DCD66.md): Cessna 170 · Paullina, IA · Accident · No injuries · Closed · Apr 6, 1972 · N3101B · Substantial damage - [NTSB MKC72AK057](https://openairdocs.org/ntsb/MKC72AK057.md): Beech C35 · Alta, IA · Accident · 4 fatal · Closed · Mar 26, 1972 · N5844C · Destroyed - [NTSB MKC72FCD64](https://openairdocs.org/ntsb/MKC72FCD64.md): Luscombe 8E · Adel, IA · Accident · No injuries · Closed · Mar 25, 1972 · N1306B · Substantial damage - [NTSB MKC72FCD65](https://openairdocs.org/ntsb/MKC72FCD65.md): Piper PA-30 · Des Moines, IA · Accident · No injuries · Closed · Mar 23, 1972 · N948SB · Substantial damage - [NTSB MKC72FCD63](https://openairdocs.org/ntsb/MKC72FCD63.md): Bell 47G-2 · Fremont, IA · Accident · Minor injuries · Closed · Mar 20, 1972 · N976B · Substantial damage - [NTSB MKC72DCD62](https://openairdocs.org/ntsb/MKC72DCD62.md): Aeronca 11AC · Shenandoah, IA · Accident · No injuries · Closed · Feb 20, 1972 · N3380E · Substantial damage - [NTSB MKC72DCD57](https://openairdocs.org/ntsb/MKC72DCD57.md): Cessna 150 · Maurice, IA · Accident · No injuries · Closed · Feb 15, 1972 · N3552L · Substantial damage - [NTSB MKC72DCD61](https://openairdocs.org/ntsb/MKC72DCD61.md): Cessna 172 · Gilman, IA · Accident · No injuries · Closed · Feb 13, 1972 · N4375Q · Substantial damage - [NTSB MKC72DCD58](https://openairdocs.org/ntsb/MKC72DCD58.md): Beech 23 · Waterloo, IA · Accident · No injuries · Closed · Feb 11, 1972 · N8702M · Substantial damage - [NTSB MKC72DCD60](https://openairdocs.org/ntsb/MKC72DCD60.md): Cessna 182 · Sioux City, IA · Accident · No injuries · Closed · Feb 5, 1972 · N2720F · Substantial damage - [NTSB MKC72DCD59](https://openairdocs.org/ntsb/MKC72DCD59.md): Champion 7ECA · Mediapolis, IA · Accident · No injuries · Closed · Feb 5, 1972 · N11055 · Substantial damage - [NTSB MKC72DCD56](https://openairdocs.org/ntsb/MKC72DCD56.md): Beech B23 · Davenport, IA · Accident · No injuries · Closed · Feb 3, 1972 · N2315L · Substantial damage - [NTSB MKC72DCD53](https://openairdocs.org/ntsb/MKC72DCD53.md): Cessna 150E · Marion, IA · Accident · No injuries · Closed · Jan 22, 1972 · N2571J · Substantial damage - [NTSB MKC72DCD55](https://openairdocs.org/ntsb/MKC72DCD55.md): Cessna 120 · Forest City, IA · Accident · No injuries · Closed · Jan 9, 1972 · N2075V · Substantial damage - [NTSB MKC72DCD52](https://openairdocs.org/ntsb/MKC72DCD52.md): Cessna 150L · Garner, IA · Accident · No injuries · Closed · Jan 6, 1972 · N1616Q · Substantial damage - [NTSB MKC72DCD51](https://openairdocs.org/ntsb/MKC72DCD51.md): Cessna 172 · Belmond, IA · Accident · No injuries · Closed · Jan 6, 1972 · N7059A · Substantial damage - [NTSB MKC72FCD50](https://openairdocs.org/ntsb/MKC72FCD50.md): Piper PA-32 · Mason City, IA · Accident · No injuries · Closed · Jan 4, 1972 · N4215T · Substantial damage - [NTSB MKC72AK041](https://openairdocs.org/ntsb/MKC72AK041.md): Piper PA-28R · Davenport, IA · Accident · 2 fatal · Closed · Dec 25, 1971 · N7477J · Destroyed - [NTSB MKC72FCD49](https://openairdocs.org/ntsb/MKC72FCD49.md): Mitsubishi MU-2B · Lemars, IA · Accident · Serious injuries · Closed · Dec 22, 1971 · N251M · No damage - [NTSB MKC72AK038](https://openairdocs.org/ntsb/MKC72AK038.md): Erco 415C · Lake Mills, IA · Accident · 1 fatal · Closed · Dec 19, 1971 · N93703 · Destroyed - [NTSB MKC72DCD48](https://openairdocs.org/ntsb/MKC72DCD48.md): Piper PA-20 · Woodbine, IA · Accident · No injuries · Closed · Dec 10, 1971 · N7044K · Substantial damage - [NTSB MKC73DCD19](https://openairdocs.org/ntsb/MKC73DCD19-164776.md): Aeronca 7AC · Decorah, IA · Accident · No injuries · Closed · Dec 4, 1971 · N85286 · Substantial damage - [NTSB MKC72DCD47](https://openairdocs.org/ntsb/MKC72DCD47.md): Piper PA-32 · Dubuque, IA · Accident · No injuries · Closed · Nov 17, 1971 · N4139W · Substantial damage - [NTSB MKC72FCD44](https://openairdocs.org/ntsb/MKC72FCD44.md): Piper PA-28 · Newton, IA · Accident · No injuries · Closed · Nov 14, 1971 · N6649J · Substantial damage - [NTSB MKC72DCD45](https://openairdocs.org/ntsb/MKC72DCD45.md): Piper PA-32 · Ida Grove, IA · Accident · No injuries · Closed · Nov 14, 1971 · N4063R · Substantial damage - [NTSB MKC72DCD46](https://openairdocs.org/ntsb/MKC72DCD46.md): Cessna 140 · Chillicothe, IA · Accident · No injuries · Closed · Nov 7, 1971 · N1621V · Substantial damage - [NTSB MKC72DCD43](https://openairdocs.org/ntsb/MKC72DCD43.md): Cessna 140 · Mapleton, IA · Accident · Minor injuries · Closed · Nov 6, 1971 · N89093 · Substantial damage - [NTSB MKC72DCD42](https://openairdocs.org/ntsb/MKC72DCD42.md): Cessna 170A · Marion, IA · Accident · No injuries · Closed · Oct 31, 1971 · N9145A · Substantial damage - [NTSB MKC72DCD40](https://openairdocs.org/ntsb/MKC72DCD40.md): Aero Comdr 500-B · Waterloo, IA · Accident · No injuries · Closed · Oct 18, 1971 · N553HH · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=IA&page=30 ## 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=29&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.