# 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 33 of 45 · 2,216 cases ## Cases, newest first - [NTSB MKC70FCD37](https://openairdocs.org/ntsb/MKC70FCD37.md): Beech D55 · Cncl Bluffs, IA · Accident · No injuries · Closed · Jun 7, 1970 · N6814A · Substantial damage - [NTSB MKC71DCD08](https://openairdocs.org/ntsb/MKC71DCD08.md): Piper PA-28 · Maquoketa, IA · Accident · No injuries · Closed · Jun 6, 1970 · N9662J · Substantial damage - [NTSB MKC70AK067](https://openairdocs.org/ntsb/MKC70AK067.md): Piper PA-28 · Newton, IA · Accident · 3 fatal · Closed · May 31, 1970 · N1702J · Destroyed - [NTSB MKC70FCD33](https://openairdocs.org/ntsb/MKC70FCD33.md): Piper PA-22 · Atlantic, IA · Accident · Serious injuries · Closed · May 30, 1970 · N2549A · Substantial damage - [NTSB MKC70DCD36](https://openairdocs.org/ntsb/MKC70DCD36.md): Cessna 177 · Nevada, IA · Accident · No injuries · Closed · May 30, 1970 · N29513 · Substantial damage - [NTSB MKC70DCD39](https://openairdocs.org/ntsb/MKC70DCD39.md): Cessna 150G · Maxwell, IA · Accident · No injuries · Closed · May 28, 1970 · N3012S · Substantial damage - [NTSB MKC70DCD35](https://openairdocs.org/ntsb/MKC70DCD35.md): Beech A35 · Newton, IA · Accident · No injuries · Closed · May 24, 1970 · N473AB · Substantial damage - [NTSB MKC70AK064](https://openairdocs.org/ntsb/MKC70AK064.md): Beech S35 · Guthrie Cntr, IA · Accident · No injuries · Closed · May 24, 1970 · N8684Q · Substantial damage - [NTSB MKC70AK062](https://openairdocs.org/ntsb/MKC70AK062.md): Beech E18S · Sioux City, IA · Accident · 2 fatal · Closed · May 19, 1970 · N139K · Destroyed - [NTSB MKC70DCD31](https://openairdocs.org/ntsb/MKC70DCD31.md): Cessna 182M · Atlantic, IA · Accident · Minor injuries · Closed · May 18, 1970 · N91814 · Substantial damage - [NTSB MKC70DCD32](https://openairdocs.org/ntsb/MKC70DCD32.md): Piper PA-28 · Des Moines, IA · Accident · No injuries · Closed · May 17, 1970 · N5739U · Substantial damage - [NTSB MKC70FCD30](https://openairdocs.org/ntsb/MKC70FCD30.md): Aeronca 11AC · So.Amana, IA · Accident · Serious injuries · Closed · May 10, 1970 · N86350 · Substantial damage - [NTSB MKC70DCD29](https://openairdocs.org/ntsb/MKC70DCD29.md): Piper PA-24 · Ames, IA · Accident · Minor injuries · Closed · May 8, 1970 · N5266N · Substantial damage - [NTSB MKC71DCD22](https://openairdocs.org/ntsb/MKC71DCD22.md): Cessna 120 · Gravity, IA · Accident · No injuries · Closed · May 3, 1970 · N76806 · Substantial damage - [NTSB MKC70DCD34](https://openairdocs.org/ntsb/MKC70DCD34.md): Cessna 150E · Manson, IA · Accident · No injuries · Closed · May 3, 1970 · N3597J · Substantial damage - [NTSB MKC70DGD40](https://openairdocs.org/ntsb/MKC70DGD40.md): Cessna 150A · Maysville, IA · Accident · No injuries · Closed · Apr 26, 1970 · N4738X · Substantial damage - [NTSB MKC70DCD27](https://openairdocs.org/ntsb/MKC70DCD27.md): Bellanca 14-19 · Creston, IA · Accident · No injuries · Closed · Apr 12, 1970 · N9849B · Substantial damage - [NTSB MKC70AK053](https://openairdocs.org/ntsb/MKC70AK053.md): Cessna 182M · Adair, IA · Accident · 4 fatal · Closed · Apr 12, 1970 · N91598 · Destroyed - [NTSB MKC70DCD26](https://openairdocs.org/ntsb/MKC70DCD26.md): Cessna 170 · Onawa, IA · Accident · No injuries · Closed · Apr 7, 1970 · N1259D · Substantial damage - [NTSB MKC70DCD25](https://openairdocs.org/ntsb/MKC70DCD25.md): Piper PA-28 · Cherokee, IA · Accident · No injuries · Closed · Apr 5, 1970 · N1767J · Substantial damage - [NTSB MKC70DCD28](https://openairdocs.org/ntsb/MKC70DCD28.md): Cessna 182B · Burlington, IA · Accident · No injuries · Closed · Mar 28, 1970 · N2487G · Substantial damage - [NTSB MKC70FCD24](https://openairdocs.org/ntsb/MKC70FCD24.md): Piper PA-39 · Cedar Rapids, IA · Accident · No injuries · Closed · Mar 26, 1970 · N8871Y · Substantial damage - [NTSB MKC70DCD23](https://openairdocs.org/ntsb/MKC70DCD23.md): Luscombe 8A · Jefferson, IA · Accident · No injuries · Closed · Mar 17, 1970 · N25346 · Substantial damage - [NTSB MKC70AK049](https://openairdocs.org/ntsb/MKC70AK049.md): Piper PA-28 · Newton, IA · Accident · 4 fatal · Closed · Mar 9, 1970 · N7704N · Destroyed - [NTSB MKC70DCD22](https://openairdocs.org/ntsb/MKC70DCD22.md): Cessna 182F · Davenport, IA · Accident · Serious injuries · Closed · Mar 7, 1970 · N3204U · No damage - [NTSB MKC70FCD20](https://openairdocs.org/ntsb/MKC70FCD20.md): Piper PA-28R · Crescent, IA · Accident · No injuries · Closed · Mar 1, 1970 · N7665J · Substantial damage - [NTSB MKC70AK045](https://openairdocs.org/ntsb/MKC70AK045.md): Cessna 172 · Muscatine, IA · Accident · 1 fatal · Closed · Feb 22, 1970 · N8913B · Destroyed - [NTSB MKC70DCD19](https://openairdocs.org/ntsb/MKC70DCD19.md): Cessna 150 · Jefferson, IA · Accident · No injuries · Closed · Feb 21, 1970 · N6999F · Substantial damage - [NTSB MKC70DCD17](https://openairdocs.org/ntsb/MKC70DCD17.md): Piper PA-24 · Monticello, IA · Accident · No injuries · Closed · Feb 8, 1970 · N6888P · Substantial damage - [NTSB MKC70DCD10](https://openairdocs.org/ntsb/MKC70DCD10.md): Beech K35 · Spirit Lake, IA · Accident · No injuries · Closed · Feb 4, 1970 · N646Q · Substantial damage - [NTSB MKC70DCD14](https://openairdocs.org/ntsb/MKC70DCD14.md): Cessna 150G · Oskaloosa, IA · Accident · No injuries · Closed · Feb 3, 1970 · N3050S · Substantial damage - [NTSB MKC70DCD16](https://openairdocs.org/ntsb/MKC70DCD16.md): Cessna 150A · Missouri Vly, IA · Accident · No injuries · Closed · Feb 1, 1970 · N2809S · Substantial damage - [NTSB MKC70DCD12](https://openairdocs.org/ntsb/MKC70DCD12.md): Piper PA-22 · Maysville, IA · Accident · No injuries · Closed · Jan 31, 1970 · N7742D · Substantial damage - [NTSB MKC70DCD11](https://openairdocs.org/ntsb/MKC70DCD11.md): Cessna 150J · Riverside, IA · Accident · No injuries · Closed · Jan 31, 1970 · N61075 · Substantial damage - [NTSB MKC70DCD13](https://openairdocs.org/ntsb/MKC70DCD13.md): Piper PA-22 · Guthrie Cntr, IA · Accident · No injuries · Closed · Jan 30, 1970 · N2692A · Substantial damage - [NTSB MKC70FCD07](https://openairdocs.org/ntsb/MKC70FCD07.md): Aeronca 7AC · Nevada, IA · Accident · Serious injuries · Closed · Jan 24, 1970 · N1991E · Substantial damage - [NTSB MKC70DCD08](https://openairdocs.org/ntsb/MKC70DCD08.md): Piper PA-16 · Carlisle, IA · Accident · No injuries · Closed · Jan 24, 1970 · N5932H · Substantial damage - [NTSB MKC70DCD06](https://openairdocs.org/ntsb/MKC70DCD06.md): Piper PA-28 · Fairfield, IA · Accident · No injuries · Closed · Jan 18, 1970 · N8423R · Substantial damage - [NTSB MKC70DCD05](https://openairdocs.org/ntsb/MKC70DCD05.md): Cessna 150D · Gilman, IA · Accident · No injuries · Closed · Jan 18, 1970 · N4279U · Substantial damage - [NTSB MKC70DCD04](https://openairdocs.org/ntsb/MKC70DCD04.md): Cessna 182J · Traer, IA · Accident · No injuries · Closed · Jan 14, 1970 · N2773F · Substantial damage - [NTSB MKC70DCD02](https://openairdocs.org/ntsb/MKC70DCD02.md): Piper PA-22 · West Liberty, IA · Accident · No injuries · Closed · Jan 10, 1970 · N7125B · Substantial damage - [NTSB MKC70DCD01](https://openairdocs.org/ntsb/MKC70DCD01.md): Cessna 177 · Osage, IA · Accident · No injuries · Closed · Jan 10, 1970 · N3358T · Substantial damage - [NTSB MKC70FCD09](https://openairdocs.org/ntsb/MKC70FCD09.md): Piper PA-14 · Gravity, IA · Accident · No injuries · Closed · Jan 9, 1970 · N5184H · Substantial damage - [NTSB MKC70DCD03](https://openairdocs.org/ntsb/MKC70DCD03.md): Piper PA-24 · West Union, IA · Accident · No injuries · Closed · Jan 9, 1970 · N5698P · Substantial damage - [NTSB MKC70D0315](https://openairdocs.org/ntsb/MKC70D0315.md): Cessna 310N · Monticello, IA · Accident · No injuries · Closed · Dec 31, 1969 · N4115Q · Substantial damage - [NTSB MKC70F0303](https://openairdocs.org/ntsb/MKC70F0303.md): Cessna 140 · Newton, IA · Accident · No injuries · Closed · Dec 19, 1969 · N72363 · Substantial damage - [NTSB MKC70A0033](https://openairdocs.org/ntsb/MKC70A0033.md): Alon A-2A · Clear Lake, IA · Accident · 2 fatal · Closed · Dec 15, 1969 · N5646F · Destroyed - [NTSB MKC70F0290](https://openairdocs.org/ntsb/MKC70F0290.md): Cessna 150H · Winterset, IA · Accident · No injuries · Closed · Dec 13, 1969 · N6796S · Substantial damage - [NTSB MKC70D0302](https://openairdocs.org/ntsb/MKC70D0302.md): Cessna 182G · Marshalltown, IA · Accident · No injuries · Closed · Dec 13, 1969 · N2467R · Substantial damage - [NTSB MKC70D0301](https://openairdocs.org/ntsb/MKC70D0301.md): Cessna 310P · Pocahontas, IA · Accident · No injuries · Closed · Dec 9, 1969 · N5733M · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=IA&page=34 ## 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=33&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.