# 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 28 of 45 · 2,216 cases ## Cases, newest first - [NTSB MKC73DCD55](https://openairdocs.org/ntsb/MKC73DCD55.md): Piper PA-28 · Wapello, IA · Accident · No injuries · Closed · Apr 14, 1973 · N8502W · Substantial damage - [NTSB MKC73DCD56](https://openairdocs.org/ntsb/MKC73DCD56.md): Cessna 150 · Jefferson, IA · Accident · No injuries · Closed · Apr 11, 1973 · N7148S · Substantial damage - [NTSB MKC73DCD53](https://openairdocs.org/ntsb/MKC73DCD53.md): Piper PA-25 · Hornick, IA · Accident · No injuries · Closed · Mar 20, 1973 · N8800L · Substantial damage - [NTSB MKC73DCD52](https://openairdocs.org/ntsb/MKC73DCD52.md): Bell 47G-2 · Hanlontown, IA · Accident · No injuries · Closed · Mar 20, 1973 · N12412 · Substantial damage - [NTSB MKC73DCD54](https://openairdocs.org/ntsb/MKC73DCD54.md): Erco 415-C · Amana, IA · Accident · No injuries · Closed · Mar 12, 1973 · N2395H · Substantial damage - [NTSB MKC73DCD50](https://openairdocs.org/ntsb/MKC73DCD50.md): Cessna 150K · Mitchellvile, IA · Accident · No injuries · Closed · Mar 7, 1973 · N5913G · Substantial damage - [NTSB MKC73FCD49](https://openairdocs.org/ntsb/MKC73FCD49.md): Piper PA-30 · Sioux City, IA · Accident · Serious injuries · Closed · Feb 28, 1973 · N7150Y · Destroyed - [NTSB MKC73AK051](https://openairdocs.org/ntsb/MKC73AK051.md): Cessna 180H · Mt.Vernon, IA · Accident · 2 fatal · Closed · Feb 19, 1973 · N9058M · Destroyed - [NTSB MKC73DCD51](https://openairdocs.org/ntsb/MKC73DCD51.md): Cessna 150 · Waterloo, IA · Accident · No injuries · Closed · Feb 17, 1973 · N1264Q · Substantial damage - [NTSB MKC73FCD48](https://openairdocs.org/ntsb/MKC73FCD48.md): Cessna 310D · Des Moines, IA · Accident · No injuries · Closed · Jan 17, 1973 · N6999T · Substantial damage - [NTSB MKC73DCD47](https://openairdocs.org/ntsb/MKC73DCD47.md): Cessna 172 · Newton, IA · Accident · No injuries · Closed · Jan 14, 1973 · N8527U · Substantial damage - [NTSB DEN73AD030](https://openairdocs.org/ntsb/DEN73AD030.md): Beech C90 · Blairstown, IA · Accident · 5 fatal · Closed · Jan 3, 1973 · N936K · Destroyed - [NTSB MKC73DCD42](https://openairdocs.org/ntsb/MKC73DCD42.md): Piper PA-28 · Davenport, IA · Accident · No injuries · Closed · Dec 27, 1972 · N5739U · Substantial damage - [NTSB MKC73DCD45](https://openairdocs.org/ntsb/MKC73DCD45.md): Piper PA-24 · Cedar Rapids, IA · Accident · No injuries · Closed · Dec 25, 1972 · N5469P · Substantial damage - [NTSB MKC73DCD41](https://openairdocs.org/ntsb/MKC73DCD41.md): Cessna 150K · Waterloo, IA · Accident · No injuries · Closed · Dec 15, 1972 · N6404G · Substantial damage - [NTSB MKC73DCD46](https://openairdocs.org/ntsb/MKC73DCD46.md): Cessna 150 · Farson, IA · Accident · No injuries · Closed · Dec 6, 1972 · N60624 · Substantial damage - [NTSB MKC73DCD44](https://openairdocs.org/ntsb/MKC73DCD44.md): Cessna 172 · Fontanelle, IA · Accident · No injuries · Closed · Nov 22, 1972 · N7814 · Substantial damage - [NTSB MKC73DCD43](https://openairdocs.org/ntsb/MKC73DCD43.md): Cessna 150L · Ames, IA · Accident · No injuries · Closed · Nov 22, 1972 · N1339Q · Substantial damage - [NTSB MKC73FCD39](https://openairdocs.org/ntsb/MKC73FCD39.md): Cessna 172 · Des Moines, IA · Accident · No injuries · Closed · Nov 19, 1972 · N1604Q · Substantial damage - [NTSB MKC73DCD40](https://openairdocs.org/ntsb/MKC73DCD40.md): Piper PA-28 · Waterloo, IA · Accident · No injuries · Closed · Nov 19, 1972 · N2189T · Substantial damage - [NTSB MKC73AK038](https://openairdocs.org/ntsb/MKC73AK038.md): Cessna 150D · Wellman, IA · Accident · 1 fatal · Closed · Nov 9, 1972 · N5913T · Destroyed - [NTSB MKC73DCD38](https://openairdocs.org/ntsb/MKC73DCD38.md): Stinson 108-3 · Mason City, IA · Accident · No injuries · Closed · Nov 5, 1972 · N4097C · Substantial damage - [NTSB MKC73AKO29](https://openairdocs.org/ntsb/MKC73AKO29.md): Cessna 150L · Ames, IA · Accident · No injuries · Closed · Oct 24, 1972 · N16107 · 2 aircraft · Substantial damage - [NTSB MKC73AK028](https://openairdocs.org/ntsb/MKC73AK028.md): Piper PA-28 · Dubuque, IA · Accident · 2 fatal · Closed · Oct 21, 1972 · N8837W · Destroyed - [NTSB MKC73DCD35](https://openairdocs.org/ntsb/MKC73DCD35.md): Cessna 182 · Iowa Falls, IA · Accident · No injuries · Closed · Oct 13, 1972 · N3093F · Substantial damage - [NTSB MKC73DCD36](https://openairdocs.org/ntsb/MKC73DCD36.md): Cessna 172 · Columbus Jct, IA · Accident · No injuries · Closed · Oct 8, 1972 · N6403E · Substantial damage - [NTSB MKC73FCD33](https://openairdocs.org/ntsb/MKC73FCD33.md): Piper PA-18 · Guthrie Ctr, IA · Accident · 1 fatal · Closed · Oct 6, 1972 · N9933D · Destroyed - [NTSB MKC73DCD34](https://openairdocs.org/ntsb/MKC73DCD34.md): Cessna 182 · West Union, IA · Accident · No injuries · Closed · Oct 4, 1972 · N3056F · Substantial damage - [NTSB MKC73FCD32](https://openairdocs.org/ntsb/MKC73FCD32.md): Navion B · Davenport, IA · Accident · Serious injuries · Closed · Sep 24, 1972 · N5312K · Substantial damage - [NTSB MKC73DCD31](https://openairdocs.org/ntsb/MKC73DCD31.md): Piper PA-32 · Carroll, IA · Accident · No injuries · Closed · Sep 14, 1972 · N4806S · Substantial damage - [NTSB MKC73DCD37](https://openairdocs.org/ntsb/MKC73DCD37.md): Cessna 150 · Anita, IA · Accident · No injuries · Closed · Sep 13, 1972 · N60302 · Substantial damage - [NTSB MKC73FCD27](https://openairdocs.org/ntsb/MKC73FCD27.md): Luscombe 8F · Blakesburg, IA · Accident · Minor injuries · Closed · Sep 3, 1972 · N2163B · Substantial damage - [NTSB MKC73DCD29](https://openairdocs.org/ntsb/MKC73DCD29.md): Perth-Amboy CK · Ottumwa, IA · Accident · No injuries · Closed · Sep 3, 1972 · N914V · Substantial damage - [NTSB MKC73AK020](https://openairdocs.org/ntsb/MKC73AK020.md): Amer Avco AA-1A · Waterloo, IA · Accident · 1 fatal · Closed · Sep 3, 1972 · N9377L · Minor damage - [NTSB MKC73AK019](https://openairdocs.org/ntsb/MKC73AK019.md): Johnson 185 · Blakesburg, IA · Accident · 2 fatal · Closed · Sep 3, 1972 · N90201 · Destroyed - [NTSB MKC73DCD23](https://openairdocs.org/ntsb/MKC73DCD23.md): Piper PA-11 · Eagle Grove, IA · Accident · No injuries · Closed · Aug 29, 1972 · N4631M · Substantial damage - [NTSB MKC73DCD22](https://openairdocs.org/ntsb/MKC73DCD22.md): Piper PA-24 · Nevada, IA · Accident · No injuries · Closed · Aug 28, 1972 · N9207P · Substantial damage - [NTSB MKC73DCD18](https://openairdocs.org/ntsb/MKC73DCD18.md): Piper PA-25 · Pocahontas, IA · Accident · No injuries · Closed · Aug 28, 1972 · N6097Z · Destroyed - [NTSB MKC73DCD17](https://openairdocs.org/ntsb/MKC73DCD17.md): Navion A · Creston, IA · Accident · No injuries · Closed · Aug 19, 1972 · N4801K · Substantial damage - [NTSB MKC73DCD25](https://openairdocs.org/ntsb/MKC73DCD25.md): Piper PA-25 · Rodes, IA · Accident · No injuries · Closed · Aug 16, 1972 · N4641Y · Substantial damage - [NTSB MKC73DCD21](https://openairdocs.org/ntsb/MKC73DCD21.md): Piper PA-30 · Des Moines, IA · Accident · No injuries · Closed · Aug 15, 1972 · N7938Y · Substantial damage - [NTSB MKC73DCD20](https://openairdocs.org/ntsb/MKC73DCD20.md): Piper PA-12 · Maysville, IA · Accident · Minor injuries · Closed · Aug 13, 1972 · N7847H · Substantial damage - [NTSB MKC73DCD16](https://openairdocs.org/ntsb/MKC73DCD16.md): Bowers Fly Baby · Osage, IA · Accident · No injuries · Closed · Aug 12, 1972 · N48ML · Substantial damage - [NTSB MKC73DCD15](https://openairdocs.org/ntsb/MKC73DCD15.md): Champion 7ECA · Liberty Ctr, IA · Accident · No injuries · Closed · Aug 12, 1972 · N11697 · Substantial damage - [NTSB MKC73DCD28](https://openairdocs.org/ntsb/MKC73DCD28.md): Aeronca 7AC · Carroll, IA · Accident · No injuries · Closed · Aug 9, 1972 · N1790E · Substantial damage - [NTSB MKC73DCD12](https://openairdocs.org/ntsb/MKC73DCD12.md): Brantly B-2B · Marshalltown, IA · Accident · No injuries · Closed · Aug 6, 1972 · N2161U · Destroyed - [NTSB MKC73AK014](https://openairdocs.org/ntsb/MKC73AK014.md): Beech H35 · Marion, IA · Accident · No injuries · Closed · Aug 4, 1972 · N7940D · Substantial damage - [NTSB MKC73DCD11](https://openairdocs.org/ntsb/MKC73DCD11.md): Cessna 150 · Fort Dodge, IA · Accident · No injuries · Closed · Aug 2, 1972 · N1613Q · Substantial damage - [NTSB MKC73DCD13](https://openairdocs.org/ntsb/MKC73DCD13.md): Piper PA-28R · Ottumwa, IA · Accident · No injuries · Closed · Aug 1, 1972 · N3866T · Substantial damage - [NTSB MKC73DCD09](https://openairdocs.org/ntsb/MKC73DCD09.md): Beech V35B · Ames, IA · Accident · No injuries · Closed · Jul 31, 1972 · N3041C · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=IA&page=29 ## 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=28&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.