Skip to content

NTSB investigations, 1965, IA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1965, IA per year, 1962–2026: 2,216 cases
1962	2
1963	2
1964	72
1965	74
1966	108
1967	129
1968	87
1969	98
1970	101
1971	105
1972	76
1973	53
1974	60
1975	49
1976	55
1977	57
1978	65
1979	51
1980	41
1981	60
1982	52
1983	53
1984	39
1985	35
1986	26
1987	30
1988	27
1989	24
1990	24
1991	23
1992	23
1993	22
1994	16
1995	12
1996	15
1997	22
1998	20
1999	18
2000	11
2001	7
2002	14
2003	20
2004	13
2005	13
2006	8
2007	17
2008	18
2009	17
2010	27
2011	23
2012	21
2013	15
2014	9
2015	13
2016	13
2017	16
2018	12
2019	9
2020	12
2021	16
2022	14
2023	17
2024	7
2025	13
2026	15

Where

Latest cases

Query with 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 year(c."eventDate") = 1965 AND c."eventStateOrRegion" = 'IA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 year(c.\"eventDate\") = 1965
    AND c.\"eventStateOrRegion\" = 'IA' AND c.\"eventCountry\" = 'USA'
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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 year(c."eventDate") = 1965
  AND c."eventStateOrRegion" = 'IA' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MKC66D0364Accident · No injuriesClosedCessna 182 · Centerville, IADec 30, 1965 · N8304S · Substantial damage NTSB MKC66D0366Accident · No injuriesClosedBeech A23 · Marion, IADec 29, 1965 · N8857M · Substantial damage NTSB MKC66D0370Accident · No injuriesClosedForney 415-C · Allerton, IADec 27, 1965 · N94041 · Substantial damage NTSB MKC66F0351Accident · No injuriesClosedPiper PA-24 · Jefferson, IADec 1, 1965 · N6455P · Substantial damage NTSB MKC66F0359Accident · No injuriesClosedPiper PA-24 · Estherville, IANov 29, 1965 · N8606P · Substantial damage NTSB MKC66A0032Accident · 1 fatalClosedBeech 35-33 · Hills, IANov 26, 1965 · N829R · Destroyed NTSB MKC66D0362Accident · No injuriesClosedTaylorcraft L-2 · Adair, IANov 21, 1965 · N48247 · Substantial damage NTSB MKC66D0324Accident · No injuriesClosedPiper PA-24 · Mt Ayr, IANov 14, 1965 · N8847P · Substantial damage NTSB MKC66F0301Accident · No injuriesClosedCessna 172D · Des Moines, IANov 12, 1965 · N2580U · Substantial damage NTSB MKC66A0030Accident · 2 fatalClosedUniversal GC-1B · Council Bluffs, IANov 6, 1965 · N3832K · Destroyed NTSB MKC66F0352Accident · No injuriesClosedCessna 210D · Ottumwa, IANov 5, 1965 · N3745Y · Substantial damage NTSB MKC66F0322Accident · No injuriesClosedPiper PA-30 · Des Moines, IANov 5, 1965 · N7545Y · Substantial damage NTSB MKC66F0322Accident · Minor injuriesClosedPiper PA-12 · Fort Dodge, IANov 2, 1965 · N3812M · Substantial damage NTSB MKC66D0330Accident · Minor injuriesClosedCessna 172 · Waukon, IAOct 29, 1965 · N5491R · Substantial damage NTSB MKC66F0388Accident · No injuriesClosedCessna 210D · Corning, IAOct 20, 1965 · N3764Y · Substantial damage NTSB MKC66D0298Accident · No injuriesClosedPiper PA-24 · Guthrie Cntr, IAOct 19, 1965 · N7189P · Substantial damage NTSB DEN66A0027Accident · 1 fatalClosedCessna 150E · Newton, IAOct 14, 1965 · N8883S · Destroyed NTSB MKC66D0305Accident · No injuriesClosedAeronca 7FC · Washburn, IAOct 13, 1965 · N9897B · Substantial damage NTSB MKC66D0287Accident · No injuriesClosedBeechcraft 35 · Council Bluffs, IAOct 12, 1965 · N3217V · Substantial damage NTSB MKC66F0248Accident · Minor injuriesClosedPiper PA-12 · Lemars, IAOct 9, 1965 · N4035M · Substantial damage NTSB MKC66D0276Accident · No injuriesClosedPiper PA-22 · Algona, IAOct 5, 1965 · N3386A · Substantial damage NTSB MKC66D0230Accident · No injuriesClosedCessna 175 · Boone, IASep 26, 1965 · N8372T · Substantial damage NTSB MKC66A0020Accident · Serious injuriesClosedDouglas DC-6B · Des Moines, IASep 22, 1965 · N3759 · Substantial damage NTSB MKC66F0229Accident · Serious injuriesClosedPiper PA-28 · Pacific Jctn, IASep 21, 1965 · N8282W · Substantial damage NTSB MKC66D0237Accident · No injuriesClosedPiper PA-23 · Iowa Falls, IASep 17, 1965 · N3325P · Substantial damage NTSB MKC66F0206Accident · No injuriesClosedPiper PA-28 · Joice, IASep 12, 1965 · N6461W · Substantial damage NTSB MKC66D0236Accident · No injuriesClosedCessna 210 · Mapleton, IASep 9, 1965 · N9454T · Substantial damage NTSB MKC66D0221Accident · No injuriesClosedCessna 150 · West Point, IASep 7, 1965 · N3948U · Substantial damage NTSB MKC66D0205Accident · No injuriesClosedWaco RNF · Prairie City, IASep 4, 1965 · N140Y · Substantial damage NTSB MKC66D0213Accident · No injuriesClosedPiper PA-12 · Marion, IAAug 23, 1965 · N7502H · Substantial damage NTSB MKC66F0160Accident · No injuriesClosedCessna 172 · Adel, IAAug 21, 1965 · N6917X · Substantial damage NTSB MKC66D0168Accident · No injuriesClosedBeechcraft P-35 · Okoboji, IAAug 17, 1965 · N8625M · Substantial damage NTSB MKC66F0146Accident · No injuriesClosedPiper PA-18 · Ft Dodge, IAAug 12, 1965 · N2774P · Substantial damage NTSB MKC66D0219Accident · No injuriesClosedRobinson Mere M · Davis City, IAAug 8, 1965 · N6827D · Substantial damage NTSB MKC66D0166Accident · No injuriesClosedTaylorcraft 19 · Eagle Grove, IAAug 4, 1965 · N6630N · Substantial damage NTSB MKC66F0114Accident · No injuriesClosedGlobe GC-1B · Wellman, IAJul 31, 1965 · N78062 · Substantial damage NTSB MKC66A0007Accident · 1 fatalClosedPiper J3C-65 · Indianola, IAJul 27, 1965 · N38561 · Destroyed NTSB MKC66D0133Accident · Minor injuriesClosedCessna P206 · Oakland, IAJul 23, 1965 · N2569X · Substantial damage NTSB MKC66D0102Accident · No injuriesClosedBeechcraft H-35 · Cresco, IAJul 21, 1965 · N5565D · Substantial damage NTSB MKC66A0003Accident · Minor injuriesClosedBrantly B-2 · Cedar Rapids, IAJul 13, 1965 · N4990C · Substantial damage NTSB MKC66F0088Accident · No injuriesClosedPiper PA-28 · Newton, IAJun 25, 1965 · N6588W · Substantial damage NTSB MKC66F0073Accident · No injuriesClosedPiper PA-23 · Des Moines, IAJun 17, 1965 · N3348P · Substantial damage NTSB MKC66D0025Accident · No injuriesClosedPiper PA-15 · Riceville, IAJun 13, 1965 · N4189H · Destroyed NTSB MKC66D0068Accident · No injuriesClosedPiper PA-11 · Algona, IAJun 10, 1965 · N78751 · Destroyed NTSB MKC66D0076Accident · No injuriesClosedPiper PA-24 · Waterloo, IAJun 4, 1965 · N5455P · Substantial damage NTSB MKC66F0048Accident · Serious injuriesClosedAeronca 7AC · Richville, IAJun 1, 1965 · N85101 · Destroyed NTSB MKC66D0029Accident · No injuriesClosedBeechcraft P-35 · Spencer, IAMay 28, 1965 · N1538S · Substantial damage NTSB MKC65D0152Accident · Minor injuriesClosedNavion B-260 · Charles City, IAMay 19, 1965 · N5260K · Destroyed NTSB MKC65F0137Accident · No injuriesClosedPiper PA-22 · Ames, IAMay 13, 1965 · N2627P · Substantial damage NTSB MKC65D0127Accident · No injuriesClosedTaylorcraft DCO · Pacific Junct, IAMay 3, 1965 · N57922 · Destroyed