Skip to content

NTSB investigations, 1964, 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, 1964, 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") = 1964 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\") = 1964
    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") = 1964
  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 UNK65X1094Accident · No injuriesClosedMooney M21 · Grinnell, IADec 22, 1964 · N6679U · Substantial damage NTSB UNK65X1011Accident · No injuriesClosedBeechraft N35 · Centerville, IADec 14, 1964 · N545T · Substantial damage NTSB UNK65X0994Accident · No injuriesClosedCessna 175 · Mt Pleasant, IADec 13, 1964 · N9365B · Destroyed NTSB UNK65X0857Accident · No injuriesClosedBeechcraft D35 · Cedar Rapids, IANov 27, 1964 · N2973B · Substantial damage NTSB UNK65X0656Accident · No injuriesClosedCessna 210 · Knoxville, IANov 11, 1964 · N9657T · Substantial damage NTSB UNK65X0472Accident · No injuriesClosedPiper PA22 · What Cheer, IAOct 29, 1964 · N4556Z · Substantial damage NTSB UNK65X0371Accident · No injuriesClosedCessna 180 · Des Moines, IAOct 22, 1964 · N4868A · Substantial damage NTSB UNK65X0305Accident · Minor injuriesClosedAeronca 7AC · Floris, IAOct 17, 1964 · N84762 · Destroyed NTSB UNK65X0277Accident · No injuriesClosedPiper PA28 · Ft Dodge, IAOct 14, 1964 · N7557W · Substantial damage NTSB UNK65X0115Accident · No injuriesClosedBeechcraft 35 · Spencer, IAOct 2, 1964 · N270H · Substantial damage NTSB UNK64X4193Accident · No injuriesClosedPiper PA22 · Council Bluff, IASep 28, 1964 · N3664P · Substantial damage NTSB UNK64X4183Accident · No injuriesClosedCessna 140 · Ames, IASep 27, 1964 · N77075 · Destroyed NTSB UNK64X4112Accident · No injuriesClosedPiper PA22 · Webster City, IASep 23, 1964 · N5708D · Substantial damage NTSB UNK64X3987Accident · No injuriesClosedCessna 205 · Red Oak, IASep 14, 1964 · N8257Z · Substantial damage NTSB UNK64X3961Accident · No injuriesClosedPiper PA28 · Woolstock, IASep 13, 1964 · N5286W · Substantial damage NTSB UNK64X3917Accident · No injuriesClosedCessna 182 · Lemars, IASep 11, 1964 · N5113D · Substantial damage NTSB UNK64X3876Accident · No injuriesClosedBeechcraft T34 · Elkader, IASep 8, 1964 · N7611B · Substantial damage NTSB UNK64X3772Accident · No injuriesClosedBeechcraft B55 · Oskaloosa, IASep 4, 1964 · N8849M · Substantial damage NTSB UNK64X3752Accident · No injuriesClosedBeechcraft B35 · Perry, IASep 3, 1964 · N8916A · Substantial damage NTSB UNK64X3749Accident · No injuriesClosedFairchild 24J · Ottumwa, IASep 3, 1964 · N19177 · Substantial damage NTSB UNK64X3690Accident · No injuriesClosedMooney MK20A · Leon, IAAug 30, 1964 · N8102E · Substantial damage NTSB UNK64X3588Accident · Minor injuriesClosedGrumman SCAN30 · Fairfield, IAAug 25, 1964 · N7916C · Destroyed NTSB UNK64X3538Accident · No injuriesClosedStinson 108 · Marion, IAAug 22, 1964 · N97656 · Substantial damage NTSB UNK64X3517Accident · No injuriesClosedStinson 108-2 · Des Moines, IAAug 21, 1964 · N9478K · Substantial damage NTSB UNK64X3509Accident · No injuriesClosedCessna 310 · Red Oak, IAAug 21, 1964 · N5839X · Substantial damage NTSB UNK64X3428Accident · No injuriesClosedChampion 75C · Waukon, IAAug 16, 1964 · N9843Y · Substantial damage NTSB UNK64X3361Accident · No injuriesClosedBeechcraft F35 · Shenandoah, IAAug 13, 1964 · N3840B · Substantial damage NTSB UNK64X3355Accident · No injuriesClosedPiper PA28 · Clarion, IAAug 13, 1964 · N7372W · Substantial damage NTSB UNK64X3343Accident · No injuriesClosedBeechcraft A45 · Des Moines, IAAug 12, 1964 · N74009 · Substantial damage NTSB UNK64X3342Accident · No injuriesClosedPiper PA24 · Kalona, IAAug 12, 1964 · N6890P · Substantial damage NTSB UNK64X3317Accident · No injuriesClosedChampion 7FC · Forest City, IAAug 10, 1964 · N9897B · Substantial damage NTSB UNK64X3259Accident · No injuriesClosedPiper PA22 · Crescent, IAAug 7, 1964 · N7019B · Substantial damage NTSB UNK64X3200Accident · Minor injuriesClosedPiper PA16 · Grimes, IAAug 3, 1964 · N5728H · Substantial damage NTSB UNK64X3148Accident · No injuriesClosedPiper PA28 · Spencer, IAAug 1, 1964 · N5239W · Substantial damage NTSB UNK64X3103Accident · No injuriesClosedCessna 120 · Laporte City, IAJul 29, 1964 · N2081V · Substantial damage NTSB UNK64X3091Accident · No injuriesClosedHughes 269A · Audubon, IAJul 28, 1964 · N8841F · Substantial damage NTSB UNK64X3082Accident · No injuriesClosedPiper PA28 · Iowa City, IAJul 28, 1964 · N8558W · Substantial damage NTSB UNK64X3010Accident · No injuriesClosedPiper PA24 · Keosauqua, IAJul 24, 1964 · N5748P · Substantial damage NTSB UNK64X2774Accident · No injuriesClosedBeechcraft 35 · Okoboji, IAJul 12, 1964 · N2859V · Substantial damage NTSB UNK64X2748Accident · Minor injuriesClosedCessna 140A · St Ansgar, IAJul 10, 1964 · N14310 · Substantial damage NTSB UNK64X2588Accident · No injuriesClosedNavion G · Des Moines, IAJul 1, 1964 · N2417T · Substantial damage NTSB UNK64X2310Accident · Serious injuriesClosedPiper PA-24 · Corning, IAJun 15, 1964 · N7681P · Destroyed NTSB UNK64X2289Accident · No injuriesClosedCessna 210 · Dubuque, IAJun 14, 1964 · N9440T · Substantial damage NTSB UNK64X2151Accident · Minor injuriesClosedAeronca 7AC · Red Oak, IAJun 6, 1964 · N84230 · Destroyed NTSB UNK64X1959Accident · Serious injuriesClosedCessna 182 · Grinnell, IAMay 26, 1964 · N5562B · Destroyed NTSB UNK64X1932Accident · No injuriesClosedAeronca 15AC · Eldora, IAMay 24, 1964 · N1103H · Substantial damage NTSB UNK64X1905Accident · No injuriesClosedCessna 140 · Marion, IAMay 23, 1964 · N81030 · Substantial damage NTSB UNK64X1786Accident · No injuriesClosedStinson 108-3 · Burlington, IAMay 16, 1964 · N6103M · Substantial damage NTSB UNK64X1770Accident · No injuriesClosedBeechcraft 23 · Denison, IAMay 15, 1964 · N2344Z · Substantial damage NTSB UNK64X1754Accident · Minor injuriesClosedPiper PA22 · Charles City, IAMay 13, 1964 · N3365Z · Substantial damage