# 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 39 of 45 · 2,216 cases ## Cases, newest first - [NTSB MKC68D0047](https://openairdocs.org/ntsb/MKC68D0047.md): Cessna 150 · Red Oak, IA · Accident · No injuries · Closed · Jun 19, 1967 · N8106S · Substantial damage - [NTSB MKC68F0026](https://openairdocs.org/ntsb/MKC68F0026.md): Cessna 170 · Larrabee, IA · Accident · No injuries · Closed · Jun 16, 1967 · N2614D · Substantial damage - [NTSB MKC68F0019](https://openairdocs.org/ntsb/MKC68F0019.md): Callair A-5 · Algona, IA · Accident · Serious injuries · Closed · Jun 16, 1967 · N9978C · Destroyed - [NTSB MKC68D0031](https://openairdocs.org/ntsb/MKC68D0031.md): Piper PA-28 · Iowa City, IA · Accident · No injuries · Closed · Jun 11, 1967 · N6426W · Substantial damage - [NTSB MKC67D0619](https://openairdocs.org/ntsb/MKC67D0619.md): Cessna 170B · Stratford, IA · Accident · No injuries · Closed · Jun 10, 1967 · N1887C · Substantial damage - [NTSB MKC68D0041](https://openairdocs.org/ntsb/MKC68D0041.md): Bellanca 14-192 · Hawarden, IA · Accident · No injuries · Closed · Jun 8, 1967 · N9803B · Substantial damage - [NTSB MKC67A0077](https://openairdocs.org/ntsb/MKC67A0077.md): Piper PA-11 · Farragut, IA · Accident · 1 fatal · Closed · Jun 5, 1967 · N4704H · Destroyed - [NTSB MKC68D0005](https://openairdocs.org/ntsb/MKC68D0005.md): Alon A-2 · Shenandoah, IA · Accident · No injuries · Closed · Jun 4, 1967 · N6588Q · Substantial damage - [NTSB MKC68D0002](https://openairdocs.org/ntsb/MKC68D0002.md): Luscombe 8E · Grundy Centr, IA · Accident · Minor injuries · Closed · May 31, 1967 · N28612 · Substantial damage - [NTSB MKC67D0601](https://openairdocs.org/ntsb/MKC67D0601-116054.md): Cessna 182A · Ottumwa, IA · Accident · No injuries · Closed · May 31, 1967 · N2187G · Substantial damage - [NTSB MKC67A0074](https://openairdocs.org/ntsb/MKC67A0074.md): Mooney M20D · Boone, IA · Accident · 2 fatal · Closed · May 31, 1967 · N5713Q · Destroyed - [NTSB MKC68D0001](https://openairdocs.org/ntsb/MKC68D0001.md): Cessna 172 · Marion, IA · Accident · No injuries · Closed · May 24, 1967 · N2526Y · Substantial damage - [NTSB MKC68D0006](https://openairdocs.org/ntsb/MKC68D0006.md): Piper J-3 · Denison, IA · Accident · No injuries · Closed · May 21, 1967 · N24603 · Substantial damage - [NTSB MKC67D0590](https://openairdocs.org/ntsb/MKC67D0590.md): Luscombe 8E · Creston, IA · Accident · No injuries · Closed · May 16, 1967 · N1977K · Substantial damage - [NTSB MKC68D0109](https://openairdocs.org/ntsb/MKC68D0109.md): Mooney M20C · Treynor, IA · Accident · No injuries · Closed · May 14, 1967 · N6716U · Substantial damage - [NTSB MKC67D0577](https://openairdocs.org/ntsb/MKC67D0577.md): Beech 35-C33 · Dubuque, IA · Accident · No injuries · Closed · May 13, 1967 · N9493S · Substantial damage - [NTSB MKC67D0583](https://openairdocs.org/ntsb/MKC67D0583.md): Cessna 172 · Pella, IA · Accident · Minor injuries · Closed · May 7, 1967 · N8871B · Destroyed - [NTSB MKC67D0570](https://openairdocs.org/ntsb/MKC67D0570.md): Cessna 172 · Grimes, IA · Accident · No injuries · Closed · May 7, 1967 · N1338F · Substantial damage - [NTSB MKC67D0518](https://openairdocs.org/ntsb/MKC67D0518.md): Piper PA-22 · Van Meter, IA · Accident · No injuries · Closed · May 7, 1967 · N9039D · Substantial damage - [NTSB MKC67D0595](https://openairdocs.org/ntsb/MKC67D0595.md): Cessna 206 · Hancock, IA · Accident · No injuries · Closed · May 3, 1967 · N5265U · Substantial damage - [NTSB MKC67D0571](https://openairdocs.org/ntsb/MKC67D0571.md): Piper PA-22 · Ankeny, IA · Accident · No injuries · Closed · May 1, 1967 · N4526Z · Substantial damage - [NTSB MKC67D0553](https://openairdocs.org/ntsb/MKC67D0553.md): Cessna 310C · Waterloo, IA · Accident · No injuries · Closed · May 1, 1967 · N911D · Substantial damage - [NTSB MKC67D0582](https://openairdocs.org/ntsb/MKC67D0582.md): Cessna 185 · Pella, IA · Accident · No injuries · Closed · Apr 30, 1967 · N2694Z · Substantial damage - [NTSB MKC67D0526](https://openairdocs.org/ntsb/MKC67D0526.md): Piper PA-28 · Des Moines, IA · Accident · No injuries · Closed · Apr 25, 1967 · N4266J · Substantial damage - [NTSB MKC67D0565](https://openairdocs.org/ntsb/MKC67D0565.md): Piper PA-12 · Mantelle, IA · Accident · No injuries · Closed · Apr 24, 1967 · N3448M · Substantial damage - [NTSB MKC68A0061](https://openairdocs.org/ntsb/MKC68A0061-201141.md): Piper PA-30 · Charles City, IA · Accident · 1 fatal · Closed · Apr 23, 1967 · N7784Y · Destroyed - [NTSB MKC67D0541](https://openairdocs.org/ntsb/MKC67D0541.md): Piper PA-28 · Shenandoah, IA · Accident · No injuries · Closed · Apr 22, 1967 · N8210W · Substantial damage - [NTSB MKC67D0558](https://openairdocs.org/ntsb/MKC67D0558.md): Cessna 150 · Dubuque, IA · Accident · No injuries · Closed · Apr 14, 1967 · N3228J · Substantial damage - [NTSB MKC67D0503](https://openairdocs.org/ntsb/MKC67D0503.md): Piper PA-22 · Nevada, IA · Accident · No injuries · Closed · Apr 11, 1967 · N6875B · Substantial damage - [NTSB MKC67F0525](https://openairdocs.org/ntsb/MKC67F0525.md): N. American P-51D · Des Moines, IA · Accident · Serious injuries · Closed · Apr 6, 1967 · N169MD · Substantial damage - [NTSB MKC67D0527](https://openairdocs.org/ntsb/MKC67D0527.md): Cessna 182 · Mason City, IA · Accident · No injuries · Closed · Apr 5, 1967 · N7114E · Substantial damage - [NTSB MKC67D0500](https://openairdocs.org/ntsb/MKC67D0500.md): Piper PA-28 · Oskaloosa, IA · Accident · No injuries · Closed · Apr 3, 1967 · N7884W · Substantial damage - [NTSB MKC67D0531](https://openairdocs.org/ntsb/MKC67D0531.md): Cessna 150F · Sioux City, IA · Accident · No injuries · Closed · Apr 2, 1967 · N8093F · Substantial damage - [NTSB MKC67F0484](https://openairdocs.org/ntsb/MKC67F0484.md): Aeronca 7AC · Plainfield, IA · Accident · 1 fatal · Closed · Apr 1, 1967 · N1866A · Destroyed - [NTSB MKC67D0477](https://openairdocs.org/ntsb/MKC67D0477.md): Piper PA-22 · Denison, IA · Accident · No injuries · Closed · Mar 28, 1967 · N3415A · Substantial damage - [NTSB MKC67D0535](https://openairdocs.org/ntsb/MKC67D0535.md): Aeronca 7EC · Washburn, IA · Accident · No injuries · Closed · Mar 24, 1967 · N4660E · Substantial damage - [NTSB MKC67D0499](https://openairdocs.org/ntsb/MKC67D0499.md): Piper PA-24 · Ralston, IA · Accident · No injuries · Closed · Mar 22, 1967 · N5839P · Substantial damage - [NTSB MKC67D0523](https://openairdocs.org/ntsb/MKC67D0523.md): Ercoupe 415-C · Jefferson, IA · Accident · No injuries · Closed · Mar 16, 1967 · N93667 · Substantial damage - [NTSB MKC67D0470](https://openairdocs.org/ntsb/MKC67D0470.md): Piper PA-28 · Newton, IA · Accident · No injuries · Closed · Mar 11, 1967 · N6332W · Substantial damage - [NTSB MKC67F0457](https://openairdocs.org/ntsb/MKC67F0457.md): Beech A23 · Cedar Rapids, IA · Accident · No injuries · Closed · Mar 10, 1967 · N5959S · Substantial damage - [NTSB MKC67D0491](https://openairdocs.org/ntsb/MKC67D0491.md): Cessna 175 · Laurens, IA · Accident · No injuries · Closed · Mar 10, 1967 · N6566E · Substantial damage - [NTSB MKC67D0478](https://openairdocs.org/ntsb/MKC67D0478.md): Cessna 172 · Eldora, IA · Accident · No injuries · Closed · Mar 6, 1967 · N4186L · Substantial damage - [NTSB MKC67A0053](https://openairdocs.org/ntsb/MKC67A0053.md): Cessna 182 · Des Moines, IA · Accident · No injuries · Closed · Mar 6, 1967 · N2448X · No damage - [NTSB MKC67A0051](https://openairdocs.org/ntsb/MKC67A0051.md): Brantly B-2B · Cedar Rapids, IA · Accident · No injuries · Closed · Mar 3, 1967 · N2175U · Substantial damage - [NTSB MKC67D0462](https://openairdocs.org/ntsb/MKC67D0462.md): Piper PA-22 · Sac City, IA · Accident · No injuries · Closed · Feb 26, 1967 · N3533Z · Substantial damage - [NTSB MKC67F0472](https://openairdocs.org/ntsb/MKC67F0472.md): Mooney M20B · Grimes, IA · Accident · No injuries · Closed · Feb 24, 1967 · N74723 · Substantial damage - [NTSB MKC67A0049](https://openairdocs.org/ntsb/MKC67A0049.md): Beech 23 · Maquoketa, IA · Accident · 3 fatal · Closed · Feb 15, 1967 · N2318Q · Destroyed - [NTSB MKC67D0444](https://openairdocs.org/ntsb/MKC67D0444.md): Piper PA-28 · Davenport, IA · Accident · No injuries · Closed · Feb 9, 1967 · N5427W · Substantial damage - [NTSB MKC67D0429](https://openairdocs.org/ntsb/MKC67D0429.md): Piper PA-22 · Iowa City, IA · Accident · No injuries · Closed · Feb 4, 1967 · N8867C · Substantial damage - [NTSB MKC67D0490](https://openairdocs.org/ntsb/MKC67D0490.md): Cessna 182B · Mt. Pleasant, IA · Accident · No injuries · Closed · Feb 3, 1967 · N2319G · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=IA&page=40 ## 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=39&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.