# 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 42 of 45 · 2,216 cases ## Cases, newest first - [NTSB MKC66D0550](https://openairdocs.org/ntsb/MKC66D0550.md): Piper PA-22 · Mason City, IA · Accident · No injuries · Closed · Mar 26, 1966 · N8421D · Substantial damage - [NTSB MKC66F0475](https://openairdocs.org/ntsb/MKC66F0475.md): Piper PA-22 · Des Moines, IA · Accident · No injuries · Closed · Mar 18, 1966 · N8876D · Substantial damage - [NTSB MKC66D0512](https://openairdocs.org/ntsb/MKC66D0512.md): Beech S35 · Hawarden, IA · Accident · No injuries · Closed · Mar 14, 1966 · N198Q · Substantial damage - [NTSB MKC66D0500](https://openairdocs.org/ntsb/MKC66D0500.md): Piper PA-28 · Sioux City, IA · Accident · No injuries · Closed · Mar 12, 1966 · N6802W · Substantial damage - [NTSB MKC66D0476](https://openairdocs.org/ntsb/MKC66D0476.md): Cessna 320C · Mason City, IA · Accident · No injuries · Closed · Mar 11, 1966 · N3051T · Substantial damage - [NTSB MKC66D0449](https://openairdocs.org/ntsb/MKC66D0449.md): Piper PA-22 · Perry, IA · Accident · No injuries · Closed · Feb 27, 1966 · N2609A · Substantial damage - [NTSB MKC66F0419](https://openairdocs.org/ntsb/MKC66F0419.md): Cessna P206 · Des Moines, IA · Accident · No injuries · Closed · Feb 26, 1966 · N2530X · Substantial damage - [NTSB MKC66A0043](https://openairdocs.org/ntsb/MKC66A0043.md): Hawker-Sdly DH-125 · Des Moines, IA · Accident · Serious injuries · Closed · Feb 24, 1966 · N1135K · Substantial damage - [NTSB MKC66F0447](https://openairdocs.org/ntsb/MKC66F0447.md): Beech E18S · Des Moines, IA · Accident · No injuries · Closed · Feb 23, 1966 · N3333C · Substantial damage - [NTSB MKC66D0416](https://openairdocs.org/ntsb/MKC66D0416.md): Piper PA-28 · Storm Lake, IA · Accident · No injuries · Closed · Feb 7, 1966 · N7321W · Substantial damage - [NTSB MKC66F0458](https://openairdocs.org/ntsb/MKC66F0458.md): Bellanca 14-13 · Grimes, IA · Accident · No injuries · Closed · Feb 1, 1966 · N86798 · Substantial damage - [NTSB MKC66F0392](https://openairdocs.org/ntsb/MKC66F0392.md): Piper PA-23 · Garner, IA · Accident · No injuries · Closed · Jan 27, 1966 · N3325P · Substantial damage - [NTSB MKC66F0402](https://openairdocs.org/ntsb/MKC66F0402.md): Cessna 310H · Des Moines, IA · Accident · No injuries · Closed · Jan 19, 1966 · N1142Q · Substantial damage - [NTSB MKC66F0397](https://openairdocs.org/ntsb/MKC66F0397.md): Cessna 310J · Des Moines, IA · Accident · No injuries · Closed · Jan 14, 1966 · N3100L · Substantial damage - [NTSB MKC66D0385](https://openairdocs.org/ntsb/MKC66D0385.md): Cessna 120 · Des Moines, IA · Accident · No injuries · Closed · Jan 9, 1966 · N72715 · Substantial damage - [NTSB MKC66D0337](https://openairdocs.org/ntsb/MKC66D0337.md): Stinson 108-2 · Panoro, IA · Accident · No injuries · Closed · Jan 1, 1966 · N9551K · Substantial damage - [NTSB MKC66D0364](https://openairdocs.org/ntsb/MKC66D0364.md): Cessna 182 · Centerville, IA · Accident · No injuries · Closed · Dec 30, 1965 · N8304S · Substantial damage - [NTSB MKC66D0366](https://openairdocs.org/ntsb/MKC66D0366.md): Beech A23 · Marion, IA · Accident · No injuries · Closed · Dec 29, 1965 · N8857M · Substantial damage - [NTSB MKC66D0370](https://openairdocs.org/ntsb/MKC66D0370.md): Forney 415-C · Allerton, IA · Accident · No injuries · Closed · Dec 27, 1965 · N94041 · Substantial damage - [NTSB MKC66F0351](https://openairdocs.org/ntsb/MKC66F0351.md): Piper PA-24 · Jefferson, IA · Accident · No injuries · Closed · Dec 1, 1965 · N6455P · Substantial damage - [NTSB MKC66F0359](https://openairdocs.org/ntsb/MKC66F0359.md): Piper PA-24 · Estherville, IA · Accident · No injuries · Closed · Nov 29, 1965 · N8606P · Substantial damage - [NTSB MKC66A0032](https://openairdocs.org/ntsb/MKC66A0032.md): Beech 35-33 · Hills, IA · Accident · 1 fatal · Closed · Nov 26, 1965 · N829R · Destroyed - [NTSB MKC66D0362](https://openairdocs.org/ntsb/MKC66D0362.md): Taylorcraft L-2 · Adair, IA · Accident · No injuries · Closed · Nov 21, 1965 · N48247 · Substantial damage - [NTSB MKC66D0324](https://openairdocs.org/ntsb/MKC66D0324.md): Piper PA-24 · Mt Ayr, IA · Accident · No injuries · Closed · Nov 14, 1965 · N8847P · Substantial damage - [NTSB MKC66F0301](https://openairdocs.org/ntsb/MKC66F0301.md): Cessna 172D · Des Moines, IA · Accident · No injuries · Closed · Nov 12, 1965 · N2580U · Substantial damage - [NTSB MKC66A0030](https://openairdocs.org/ntsb/MKC66A0030.md): Universal GC-1B · Council Bluffs, IA · Accident · 2 fatal · Closed · Nov 6, 1965 · N3832K · Destroyed - [NTSB MKC66F0352](https://openairdocs.org/ntsb/MKC66F0352.md): Cessna 210D · Ottumwa, IA · Accident · No injuries · Closed · Nov 5, 1965 · N3745Y · Substantial damage - [NTSB MKC66F0322](https://openairdocs.org/ntsb/MKC66F0322-201518.md): Piper PA-30 · Des Moines, IA · Accident · No injuries · Closed · Nov 5, 1965 · N7545Y · Substantial damage - [NTSB MKC66F0322](https://openairdocs.org/ntsb/MKC66F0322-174344.md): Piper PA-12 · Fort Dodge, IA · Accident · Minor injuries · Closed · Nov 2, 1965 · N3812M · Substantial damage - [NTSB MKC66D0330](https://openairdocs.org/ntsb/MKC66D0330.md): Cessna 172 · Waukon, IA · Accident · Minor injuries · Closed · Oct 29, 1965 · N5491R · Substantial damage - [NTSB MKC66F0388](https://openairdocs.org/ntsb/MKC66F0388.md): Cessna 210D · Corning, IA · Accident · No injuries · Closed · Oct 20, 1965 · N3764Y · Substantial damage - [NTSB MKC66D0298](https://openairdocs.org/ntsb/MKC66D0298.md): Piper PA-24 · Guthrie Cntr, IA · Accident · No injuries · Closed · Oct 19, 1965 · N7189P · Substantial damage - [NTSB DEN66A0027](https://openairdocs.org/ntsb/DEN66A0027.md): Cessna 150E · Newton, IA · Accident · 1 fatal · Closed · Oct 14, 1965 · N8883S · Destroyed - [NTSB MKC66D0305](https://openairdocs.org/ntsb/MKC66D0305.md): Aeronca 7FC · Washburn, IA · Accident · No injuries · Closed · Oct 13, 1965 · N9897B · Substantial damage - [NTSB MKC66D0287](https://openairdocs.org/ntsb/MKC66D0287.md): Beechcraft 35 · Council Bluffs, IA · Accident · No injuries · Closed · Oct 12, 1965 · N3217V · Substantial damage - [NTSB MKC66F0248](https://openairdocs.org/ntsb/MKC66F0248.md): Piper PA-12 · Lemars, IA · Accident · Minor injuries · Closed · Oct 9, 1965 · N4035M · Substantial damage - [NTSB MKC66D0276](https://openairdocs.org/ntsb/MKC66D0276.md): Piper PA-22 · Algona, IA · Accident · No injuries · Closed · Oct 5, 1965 · N3386A · Substantial damage - [NTSB MKC66D0230](https://openairdocs.org/ntsb/MKC66D0230.md): Cessna 175 · Boone, IA · Accident · No injuries · Closed · Sep 26, 1965 · N8372T · Substantial damage - [NTSB MKC66A0020](https://openairdocs.org/ntsb/MKC66A0020.md): Douglas DC-6B · Des Moines, IA · Accident · Serious injuries · Closed · Sep 22, 1965 · N3759 · Substantial damage - [NTSB MKC66F0229](https://openairdocs.org/ntsb/MKC66F0229.md): Piper PA-28 · Pacific Jctn, IA · Accident · Serious injuries · Closed · Sep 21, 1965 · N8282W · Substantial damage - [NTSB MKC66D0237](https://openairdocs.org/ntsb/MKC66D0237.md): Piper PA-23 · Iowa Falls, IA · Accident · No injuries · Closed · Sep 17, 1965 · N3325P · Substantial damage - [NTSB MKC66F0206](https://openairdocs.org/ntsb/MKC66F0206.md): Piper PA-28 · Joice, IA · Accident · No injuries · Closed · Sep 12, 1965 · N6461W · Substantial damage - [NTSB MKC66D0236](https://openairdocs.org/ntsb/MKC66D0236.md): Cessna 210 · Mapleton, IA · Accident · No injuries · Closed · Sep 9, 1965 · N9454T · Substantial damage - [NTSB MKC66D0221](https://openairdocs.org/ntsb/MKC66D0221.md): Cessna 150 · West Point, IA · Accident · No injuries · Closed · Sep 7, 1965 · N3948U · Substantial damage - [NTSB MKC66D0205](https://openairdocs.org/ntsb/MKC66D0205.md): Waco RNF · Prairie City, IA · Accident · No injuries · Closed · Sep 4, 1965 · N140Y · Substantial damage - [NTSB MKC66D0213](https://openairdocs.org/ntsb/MKC66D0213.md): Piper PA-12 · Marion, IA · Accident · No injuries · Closed · Aug 23, 1965 · N7502H · Substantial damage - [NTSB MKC66F0160](https://openairdocs.org/ntsb/MKC66F0160.md): Cessna 172 · Adel, IA · Accident · No injuries · Closed · Aug 21, 1965 · N6917X · Substantial damage - [NTSB MKC66D0168](https://openairdocs.org/ntsb/MKC66D0168.md): Beechcraft P-35 · Okoboji, IA · Accident · No injuries · Closed · Aug 17, 1965 · N8625M · Substantial damage - [NTSB MKC66F0146](https://openairdocs.org/ntsb/MKC66F0146.md): Piper PA-18 · Ft Dodge, IA · Accident · No injuries · Closed · Aug 12, 1965 · N2774P · Substantial damage - [NTSB MKC66D0219](https://openairdocs.org/ntsb/MKC66D0219.md): Robinson Mere M · Davis City, IA · Accident · No injuries · Closed · Aug 8, 1965 · N6827D · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=IA&page=43 ## 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=42&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.