# 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 35 of 45 · 2,216 cases ## Cases, newest first - [NTSB MKC70F0094](https://openairdocs.org/ntsb/MKC70F0094.md): Beech 35 · Logan, IA · Accident · Minor injuries · Closed · Jun 26, 1969 · N3005V · Substantial damage - [NTSB MKC70F0015](https://openairdocs.org/ntsb/MKC70F0015.md): Callair A-9 · Jefferson, IA · Accident · No injuries · Closed · Jun 23, 1969 · N7276V · Substantial damage - [NTSB MKC70D0031](https://openairdocs.org/ntsb/MKC70D0031.md): Luscombe 8A · Rock Rapids, IA · Accident · No injuries · Closed · Jun 18, 1969 · N45534 · Substantial damage - [NTSB MKC70D0044](https://openairdocs.org/ntsb/MKC70D0044.md): Cessna 150 · Woodbine, IA · Accident · No injuries · Closed · Jun 15, 1969 · N8807S · Substantial damage - [NTSB MKC69F0472](https://openairdocs.org/ntsb/MKC69F0472.md): Cessna 172 · Winterset, IA · Accident · No injuries · Closed · Jun 10, 1969 · N1478F · Substantial damage - [NTSB MKC70D0013](https://openairdocs.org/ntsb/MKC70D0013.md): Piper PA-22 · Des Moines, IA · Accident · No injuries · Closed · Jun 8, 1969 · N3739A · Substantial damage - [NTSB MKC70D0004](https://openairdocs.org/ntsb/MKC70D0004.md): Cessna 180 · Cumming, IA · Accident · No injuries · Closed · Jun 3, 1969 · N2432C · Substantial damage - [NTSB MKC69D0477](https://openairdocs.org/ntsb/MKC69D0477.md): Piper PA-28 · Des Moines, IA · Accident · No injuries · Closed · Jun 3, 1969 · N6300J · Substantial damage - [NTSB MKC69D0476](https://openairdocs.org/ntsb/MKC69D0476.md): Champion 7ECA · Atlantic, IA · Accident · No injuries · Closed · May 31, 1969 · N11051 · Substantial damage - [NTSB MKC70F0016](https://openairdocs.org/ntsb/MKC70F0016.md): Cessna 310 · Sac City, IA · Accident · No injuries · Closed · May 22, 1969 · CF-KUL · Substantial damage - [NTSB MKC69I0060](https://openairdocs.org/ntsb/MKC69I0060.md): Aero Comdr 500-B · Iowa City, IA · Incident · No injuries · Closed · May 22, 1969 · N6308U · No damage - [NTSB MKC70D0002](https://openairdocs.org/ntsb/MKC70D0002.md): Mooney M20B · Stout, IA · Accident · No injuries · Closed · May 19, 1969 · N74765 · Substantial damage - [NTSB MKC69D0452](https://openairdocs.org/ntsb/MKC69D0452.md): Cessna 150B · Thompson, IA · Accident · No injuries · Closed · May 18, 1969 · N7360X · Substantial damage - [NTSB MKC69D0445](https://openairdocs.org/ntsb/MKC69D0445.md): Cessna 177 · Clermont, IA · Accident · Minor injuries · Closed · May 12, 1969 · N2923X · Substantial damage - [NTSB MKC69F0428](https://openairdocs.org/ntsb/MKC69F0428.md): Piper PA-16 · Adel, IA · Accident · Serious injuries · Closed · May 11, 1969 · N5710H · Destroyed - [NTSB MKC69F0417](https://openairdocs.org/ntsb/MKC69F0417.md): Cessna 210 · Des Moines, IA · Accident · No injuries · Closed · May 1, 1969 · N9699T · Substantial damage - [NTSB MKC69F0429](https://openairdocs.org/ntsb/MKC69F0429.md): Cessna 177 · Jefferson, IA · Accident · No injuries · Closed · Apr 27, 1969 · N2605Q · Substantial damage - [NTSB MKC69D0423](https://openairdocs.org/ntsb/MKC69D0423.md): Cessna 150 · Irwin, IA · Accident · Serious injuries · Closed · Apr 27, 1969 · N60064 · Destroyed - [NTSB MKC69F0414](https://openairdocs.org/ntsb/MKC69F0414.md): Cessna 182 · Monticello, IA · Accident · No injuries · Closed · Apr 18, 1969 · N2580Q · Substantial damage - [NTSB MKC69D0406](https://openairdocs.org/ntsb/MKC69D0406.md): Piper PA-22 · Anamosa, IA · Accident · No injuries · Closed · Apr 18, 1969 · N3903P · Substantial damage - [NTSB MKC69D0400](https://openairdocs.org/ntsb/MKC69D0400.md): Beech V35 · Sac City, IA · Accident · No injuries · Closed · Apr 7, 1969 · N5727V · Substantial damage - [NTSB MKC69F0396](https://openairdocs.org/ntsb/MKC69F0396.md): Cessna 150 · Cedar Rapids, IA · Accident · No injuries · Closed · Apr 6, 1969 · N4326U · Substantial damage - [NTSB MKC69F0397](https://openairdocs.org/ntsb/MKC69F0397.md): Piper PA-28 · New Liberty, IA · Accident · No injuries · Closed · Mar 19, 1969 · N561CC · Substantial damage - [NTSB MKC69D0352](https://openairdocs.org/ntsb/MKC69D0352-190865.md): Beech 19A · Perry, IA · Accident · No injuries · Closed · Mar 16, 1969 · N6066N · Substantial damage - [NTSB MKC69D0392](https://openairdocs.org/ntsb/MKC69D0392.md): Cessna 150 · Mt.Pleasant, IA · Accident · No injuries · Closed · Mar 15, 1969 · N4028U · Substantial damage - [NTSB MKC69D0380](https://openairdocs.org/ntsb/MKC69D0380.md): Aeronca 7AC · Osage, IA · Accident · No injuries · Closed · Mar 14, 1969 · N81844 · Substantial damage - [NTSB MKC69D0374](https://openairdocs.org/ntsb/MKC69D0374.md): Piper PA-28 · Perry, IA · Accident · No injuries · Closed · Mar 12, 1969 · N4886L · Substantial damage - [NTSB MKC69F0339](https://openairdocs.org/ntsb/MKC69F0339.md): Piper PA-28 · Iowa City, IA · Accident · No injuries · Closed · Mar 9, 1969 · N6426W · Substantial damage - [NTSB MKC69D0361](https://openairdocs.org/ntsb/MKC69D0361-190850.md): Piper PA-28 · Fort Dodge, IA · Accident · No injuries · Closed · Mar 7, 1969 · N7591R · Substantial damage - [NTSB MKC69D0359](https://openairdocs.org/ntsb/MKC69D0359-190851.md): Cessna 140 · Emmetsburg, IA · Accident · No injuries · Closed · Mar 7, 1969 · N2320V · Substantial damage - [NTSB MKC69D0365](https://openairdocs.org/ntsb/MKC69D0365.md): Piper PA-22 · Ankeny, IA · Accident · No injuries · Closed · Mar 1, 1969 · N1209C · Substantial damage - [NTSB MKC69D0355](https://openairdocs.org/ntsb/MKC69D0355-190842.md): Piper PA-22 · Grimes, IA · Accident · No injuries · Closed · Mar 1, 1969 · N7801D · Substantial damage - [NTSB MKC69F0338](https://openairdocs.org/ntsb/MKC69F0338.md): Cessna 150A · Denison, IA · Accident · No injuries · Closed · Feb 18, 1969 · N7236X · Substantial damage - [NTSB MKC69D0346](https://openairdocs.org/ntsb/MKC69D0346-191148.md): Piper PA-30 · Osceola, IA · Accident · No injuries · Closed · Feb 10, 1969 · N7243Y · Substantial damage - [NTSB MKC69F0344](https://openairdocs.org/ntsb/MKC69F0344.md): Piper PA-32 · Chariton, IA · Accident · No injuries · Closed · Feb 9, 1969 · N3645W · Substantial damage - [NTSB MKC69D0350](https://openairdocs.org/ntsb/MKC69D0350-191142.md): Piper PA-25 · Dubuque, IA · Accident · Minor injuries · Closed · Feb 7, 1969 · N4352Y · Substantial damage - [NTSB MKC69D0345](https://openairdocs.org/ntsb/MKC69D0345-191139.md): Piper J-3 · Plymouth, IA · Accident · No injuries · Closed · Feb 2, 1969 · N3245N · Substantial damage - [NTSB MKC69D0339](https://openairdocs.org/ntsb/MKC69D0339.md): Aero Comdr 500-B · Waterloo, IA · Accident · No injuries · Closed · Jan 27, 1969 · N553HH · Substantial damage - [NTSB MKC69D0316](https://openairdocs.org/ntsb/MKC69D0316.md): Cessna 190 · Osage, IA · Accident · No injuries · Closed · Jan 11, 1969 · N1500D · Substantial damage - [NTSB MKC69F0317](https://openairdocs.org/ntsb/MKC69F0317.md): Piper PA-23 · Estherville, IA · Accident · No injuries · Closed · Jan 10, 1969 · N2289P · Substantial damage - [NTSB MKC69F0315](https://openairdocs.org/ntsb/MKC69F0315.md): Mooney M20A · Williams, IA · Accident · 1 fatal · Closed · Jan 5, 1969 · N5531Q · Destroyed - [NTSB MKC69F0307](https://openairdocs.org/ntsb/MKC69F0307.md): Beech A35 · Burlington, IA · Accident · No injuries · Closed · Jan 2, 1969 · N8666A · Substantial damage - [NTSB MKC69F0308](https://openairdocs.org/ntsb/MKC69F0308.md): Cessna 172I · Floris, IA · Accident · No injuries · Closed · Dec 31, 1968 · N46242 · Substantial damage - [NTSB MKC69D0300](https://openairdocs.org/ntsb/MKC69D0300.md): Piper PA-22 · Nashua, IA · Accident · No injuries · Closed · Dec 29, 1968 · N2657P · Substantial damage - [NTSB MKC69D0327](https://openairdocs.org/ntsb/MKC69D0327.md): Piper PA-11 · Hampton, IA · Accident · No injuries · Closed · Dec 28, 1968 · N4866M · Substantial damage - [NTSB DCA69A0009](https://openairdocs.org/ntsb/DCA69A0009.md): Douglas DC- 9 · Sioux City, IA · Accident · Serious injuries · Closed · Dec 27, 1968 · N974Z · Destroyed - [NTSB MKC69F0326](https://openairdocs.org/ntsb/MKC69F0326.md): Piper PA-23 · Creston, IA · Accident · No injuries · Closed · Dec 26, 1968 · N3341P · Substantial damage - [NTSB MKC69D0290](https://openairdocs.org/ntsb/MKC69D0290.md): Cessna 170B · Oakland, IA · Accident · No injuries · Closed · Dec 9, 1968 · N4581C · Substantial damage - [NTSB MKC69D0285](https://openairdocs.org/ntsb/MKC69D0285.md): Cessna 310 · Estherville, IA · Accident · No injuries · Closed · Dec 6, 1968 · N3688D · Substantial damage - [NTSB MKC69D0286](https://openairdocs.org/ntsb/MKC69D0286.md): Cessna 172 · Charles City, IA · Accident · No injuries · Closed · Dec 5, 1968 · N1769F · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=IA&page=36 ## 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=35&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.