# 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 38 of 45 · 2,216 cases ## Cases, newest first - [NTSB MKC68D0288](https://openairdocs.org/ntsb/MKC68D0288.md): Beech B35 · Hamburg, IA · Accident · No injuries · Closed · Oct 21, 1967 · N5187C · Substantial damage - [NTSB MKC68D0285](https://openairdocs.org/ntsb/MKC68D0285.md): Piper PA-28 · Marshalltown, IA · Accident · No injuries · Closed · Oct 21, 1967 · N3422K · Substantial damage - [NTSB MKC68F0282](https://openairdocs.org/ntsb/MKC68F0282.md): Piper PA-30 · Waterloo, IA · Accident · Serious injuries · Closed · Oct 17, 1967 · N8306Y · Destroyed - [NTSB MKC68D0287](https://openairdocs.org/ntsb/MKC68D0287.md): Cessna 170 · Waukon, IA · Accident · No injuries · Closed · Oct 17, 1967 · N1243D · Substantial damage - [NTSB MKC68F0274](https://openairdocs.org/ntsb/MKC68F0274.md): Cessna 180A · Rockwell Cty, IA · Accident · No injuries · Closed · Oct 7, 1967 · N9731B · Substantial damage - [NTSB MKC68F0229](https://openairdocs.org/ntsb/MKC68F0229.md): Piper PA-18 · Henderson, IA · Accident · Minor injuries · Closed · Oct 2, 1967 · N4117Z · Substantial damage - [NTSB MKC68D0235](https://openairdocs.org/ntsb/MKC68D0235.md): Piper PA-28 · Chariton, IA · Accident · No injuries · Closed · Sep 25, 1967 · N9428J · Destroyed - [NTSB MKC68D0234](https://openairdocs.org/ntsb/MKC68D0234.md): Piper PA-28 · Swea City, IA · Accident · No injuries · Closed · Sep 25, 1967 · N8655W · Substantial damage - [NTSB MKC68D0227](https://openairdocs.org/ntsb/MKC68D0227.md): Beech P35 · Spencer, IA · Accident · No injuries · Closed · Sep 24, 1967 · N8625M · Substantial damage - [NTSB MKC68D0221](https://openairdocs.org/ntsb/MKC68D0221.md): Piper PA-28 · Chariton, IA · Accident · No injuries · Closed · Sep 21, 1967 · N9428J · Substantial damage - [NTSB MKC68D0187](https://openairdocs.org/ntsb/MKC68D0187.md): Cessna 172 · Corydon, IA · Accident · No injuries · Closed · Sep 15, 1967 · N6800A · Substantial damage - [NTSB MKC68F0230](https://openairdocs.org/ntsb/MKC68F0230.md): Piper PA-16 · Oskaloosa, IA · Accident · Serious injuries · Closed · Sep 12, 1967 · N5310H · Destroyed - [NTSB MKC68A0022](https://openairdocs.org/ntsb/MKC68A0022.md): Hughes 269A · Silver City, IA · Accident · No injuries · Closed · Sep 8, 1967 · N8841F · Substantial damage - [NTSB MKC68D0210](https://openairdocs.org/ntsb/MKC68D0210.md): Fairchild M-62 · Gilmore City, IA · Accident · No injuries · Closed · Sep 6, 1967 · N1134Z · Substantial damage - [NTSB MKC68A0020](https://openairdocs.org/ntsb/MKC68A0020.md): Miniplane Smith · Eldridge, IA · Accident · 1 fatal · Closed · Sep 4, 1967 · N47P · Destroyed - [NTSB MKC68F0195](https://openairdocs.org/ntsb/MKC68F0195.md): Stits SA6-B · Grinnell, IA · Accident · Serious injuries · Closed · Sep 2, 1967 · N4801E · Substantial damage - [NTSB MKC68F0206](https://openairdocs.org/ntsb/MKC68F0206.md): Cessna 172 · Adel, IA · Accident · No injuries · Closed · Aug 31, 1967 · N6408B · Substantial damage - [NTSB MKC68D0213](https://openairdocs.org/ntsb/MKC68D0213.md): Mooney M20C · Oelwein, IA · Accident · No injuries · Closed · Aug 28, 1967 · N2646W · Substantial damage - [NTSB MKC68D0163](https://openairdocs.org/ntsb/MKC68D0163.md): Mooney M20C · Webster City, IA · Accident · No injuries · Closed · Aug 28, 1967 · N78961 · Substantial damage - [NTSB MKC68D0166](https://openairdocs.org/ntsb/MKC68D0166.md): Cessna 182 · Oskaloosa, IA · Accident · No injuries · Closed · Aug 24, 1967 · N2611G · Substantial damage - [NTSB MKC68F0185](https://openairdocs.org/ntsb/MKC68F0185.md): Piper PA-24 · Des Moines, IA · Accident · No injuries · Closed · Aug 23, 1967 · N6001P · Substantial damage - [NTSB MKC68D0162](https://openairdocs.org/ntsb/MKC68D0162.md): Cessna 182 · George, IA · Accident · No injuries · Closed · Aug 20, 1967 · N2867F · Substantial damage - [NTSB MKC68D0186](https://openairdocs.org/ntsb/MKC68D0186.md): Piper PA-11 · Pocahontas, IA · Accident · No injuries · Closed · Aug 19, 1967 · N4985M · Substantial damage - [NTSB MKC68D0164](https://openairdocs.org/ntsb/MKC68D0164.md): Beech A55 · Harlan, IA · Accident · Minor injuries · Closed · Aug 18, 1967 · N1590Z · Substantial damage - [NTSB MKC68F0127](https://openairdocs.org/ntsb/MKC68F0127.md): Piper PA-32 · Des Moines, IA · Accident · No injuries · Closed · Aug 16, 1967 · N3344W · Substantial damage - [NTSB MKC68D0504](https://openairdocs.org/ntsb/MKC68D0504.md): Piper PA-11 · Terril, IA · Accident · No injuries · Closed · Aug 16, 1967 · N5010H · Substantial damage - [NTSB MKC68D0154](https://openairdocs.org/ntsb/MKC68D0154.md): Piper PA-30 · Waterloo, IA · Accident · No injuries · Closed · Aug 13, 1967 · N8306Y · Substantial damage - [NTSB MKC68D0143](https://openairdocs.org/ntsb/MKC68D0143.md): Cessna 182 · Newton, IA · Accident · No injuries · Closed · Aug 13, 1967 · N8540T · Substantial damage - [NTSB MKC68D0142](https://openairdocs.org/ntsb/MKC68D0142.md): Globe GC-1B · Larchwood, IA · Accident · No injuries · Closed · Aug 13, 1967 · N78009 · Substantial damage - [NTSB MKC68D0136](https://openairdocs.org/ntsb/MKC68D0136.md): Cessna 210 · Sioux City, IA · Accident · No injuries · Closed · Aug 9, 1967 · N9496X · Substantial damage - [NTSB MKC68F0283](https://openairdocs.org/ntsb/MKC68F0283.md): Cessna 140 · Boone, IA · Accident · No injuries · Closed · Aug 6, 1967 · N1978N · Substantial damage - [NTSB MKC68D0111](https://openairdocs.org/ntsb/MKC68D0111.md): Cessna 170B · Garnavillo, IA · Accident · No injuries · Closed · Aug 5, 1967 · N4628C · Substantial damage - [NTSB MKC68F0126](https://openairdocs.org/ntsb/MKC68F0126.md): Mooney M20D · Ames, IA · Accident · Serious injuries · Closed · Aug 3, 1967 · N6631U · Substantial damage - [NTSB MKC68D0098](https://openairdocs.org/ntsb/MKC68D0098.md): Piper PA-22 · Des Moines, IA · Accident · No injuries · Closed · Aug 3, 1967 · N4526Z · Substantial damage - [NTSB MKC68F0083](https://openairdocs.org/ntsb/MKC68F0083.md): Cessna 210 · Ottumwa, IA · Accident · No injuries · Closed · Aug 1, 1967 · N6713R · Substantial damage - [NTSB MKC68A0008](https://openairdocs.org/ntsb/MKC68A0008.md): Taylorcraft BC12-D · Le Mars, IA · Accident · 1 fatal · Closed · Aug 1, 1967 · N43350 · 2 aircraft · Destroyed - [NTSB MKC68D0135](https://openairdocs.org/ntsb/MKC68D0135.md): Beech B35 · Clio, IA · Accident · No injuries · Closed · Jul 27, 1967 · N5120C · Substantial damage - [NTSB MKC68A0006](https://openairdocs.org/ntsb/MKC68A0006.md): Convair 340 · Des Moines, IA · Accident · No injuries · Closed · Jul 23, 1967 · N3427 · Substantial damage - [NTSB MKC68D0080](https://openairdocs.org/ntsb/MKC68D0080.md): Cessna 182 · Oskaloosa, IA · Accident · No injuries · Closed · Jul 15, 1967 · N2611G · 2 aircraft · No damage - [NTSB MKC68F0082](https://openairdocs.org/ntsb/MKC68F0082.md): Beech 35 · Newton, IA · Accident · No injuries · Closed · Jul 13, 1967 · N3858N · Substantial damage - [NTSB MKC68D0079](https://openairdocs.org/ntsb/MKC68D0079.md): Cessna 150 · Cedar Rapids, IA · Accident · No injuries · Closed · Jul 12, 1967 · N8802S · Substantial damage - [NTSB MKC68D0078](https://openairdocs.org/ntsb/MKC68D0078.md): Piper PA-18 · Battlecreek, IA · Accident · No injuries · Closed · Jul 10, 1967 · N8972D · Substantial damage - [NTSB MKC68D0049](https://openairdocs.org/ntsb/MKC68D0049.md): Erco 415-C · Clarinda, IA · Accident · Minor injuries · Closed · Jul 9, 1967 · N3469H · Substantial damage - [NTSB MKC68D0030](https://openairdocs.org/ntsb/MKC68D0030.md): Mooney M20E · Des Moines, IA · Accident · No injuries · Closed · Jul 7, 1967 · N79331 · Substantial damage - [NTSB MKC68D0068](https://openairdocs.org/ntsb/MKC68D0068.md): Cessna 182 · Mason City, IA · Accident · No injuries · Closed · Jul 1, 1967 · N3506Y · Substantial damage - [NTSB MKC68F0048](https://openairdocs.org/ntsb/MKC68F0048.md): Cessna 182 · Grimes, IA · Accident · Serious injuries · Closed · Jun 28, 1967 · N3449F · Substantial damage - [NTSB MKC68D0069](https://openairdocs.org/ntsb/MKC68D0069.md): Snow S2C · Clarinda, IA · Accident · No injuries · Closed · Jun 26, 1967 · N1674S · Substantial damage - [NTSB MKC68F0119](https://openairdocs.org/ntsb/MKC68F0119.md): Luscombe 8A · Grimes, IA · Accident · No injuries · Closed · Jun 25, 1967 · N1966B · Substantial damage - [NTSB MKC68A0038](https://openairdocs.org/ntsb/MKC68A0038.md): Bell 47G · Creston, IA · Accident · No injuries · Closed · Jun 25, 1967 · N163B · Substantial damage - [NTSB MKC68D0084](https://openairdocs.org/ntsb/MKC68D0084.md): Mooney M20E · Sioux City, IA · Accident · No injuries · Closed · Jun 23, 1967 · N5534Q · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=IA&page=39 ## 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=38&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.