Skip to content

NTSB investigations, 1964, ID

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

19642026

NTSB investigations, 1964, ID per year, 1964–2026: 2,504 cases
1964	70
1965	49
1966	62
1967	64
1968	65
1969	47
1970	54
1971	57
1972	41
1973	48
1974	63
1975	56
1976	63
1977	48
1978	43
1979	56
1980	44
1981	40
1982	47
1983	41
1984	41
1985	46
1986	50
1987	25
1988	29
1989	22
1990	30
1991	30
1992	37
1993	26
1994	39
1995	35
1996	33
1997	31
1998	41
1999	46
2000	34
2001	24
2002	48
2003	52
2004	40
2005	38
2006	30
2007	40
2008	34
2009	37
2010	37
2011	33
2012	40
2013	32
2014	30
2015	27
2016	22
2017	31
2018	28
2019	33
2020	24
2021	39
2022	27
2023	29
2024	35
2025	22
2026	19

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" = 'ID' 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\" = 'ID' 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" = 'ID' 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 UNK65X1205Accident · No injuriesClosedBrantly B2 · Peck, IDDec 31, 1964 · N5917X · Substantial damage NTSB UNK65X1161Accident · Serious injuriesClosedCessna 172 · Swan Valley, IDDec 27, 1964 · N7026A · Destroyed NTSB UNK65X0900Accident · No injuriesClosedBeechcraft B33 · Arco, IDDec 2, 1964 · N8631M · Substantial damage NTSB UNK65X0634Accident · No injuriesClosedPiper PA18 · Valley County, IDNov 9, 1964 · N2267A · Substantial damage NTSB UNK65X0621Accident · Minor injuriesClosedSchweizer 126A · Cedar Falls, IDNov 8, 1964 · N2714Z · Substantial damage NTSB UNK65X0434Accident · No injuriesClosedPiper PA23 · Payette, IDOct 25, 1964 · N4075P · Substantial damage NTSB UNK65X0362Accident · No injuriesClosedMooney M20E · Idaho Falls, IDOct 21, 1964 · N1984Y · Substantial damage NTSB UNK65X0298Accident · 1 fatalClosedCessna 185A · Fish Lake, IDOct 16, 1964 · N1687Z · Destroyed NTSB UNK65X0189Accident · No injuriesClosedCessna 180 · Gooding, IDOct 8, 1964 · N2864A · Substantial damage NTSB UNK64X4189Accident · Serious injuriesClosedSchweizer 126A · Hollister, IDSep 27, 1964 · N27082 · Destroyed NTSB UNK64X4184Accident · No injuriesClosedCessna 180 · Boise, IDSep 27, 1964 · N1698C · Destroyed NTSB UNK64X4182Accident · No injuriesClosedPiper PA18 · Salmon River, IDSep 27, 1964 · N7533K · Substantial damage NTSB UNK64X4134Incident · Minor injuriesClosedBoeing 707 300 · Malad City, IDSep 25, 1964 · N759PA · No damage NTSB UNK64X4130Accident · No injuriesClosedCessna 175 · Blackfoot, IDSep 24, 1964 · N7397M · Substantial damage NTSB UNK64X4099Accident · No injuriesClosedPiper PA28 · Montpelier, IDSep 22, 1964 · N6043W · Substantial damage NTSB UNK64X4022Accident · No injuriesClosedAeronca 7EC · Cavendish, IDSep 17, 1964 · N4317C · Substantial damage NTSB UNK64X4013Accident · Serious injuriesClosedBell 47G3 · Elk River, IDSep 16, 1964 · N8417E · Destroyed NTSB UNK64X3895Accident · No injuriesClosedAeronca 7AC · Firth, IDSep 10, 1964 · N85635 · Substantial damage NTSB UNK64X3662Accident · No injuriesClosedBeechcraft E35 · Gooding, IDAug 29, 1964 · N7399B · Substantial damage NTSB UNK64X3520Accident · No injuriesClosedInterstate S1A · Grace, IDAug 21, 1964 · N37341 · Substantial damage NTSB UNK64X3512Accident · No injuriesClosedCessna 150 · Mountain Home, IDAug 21, 1964 · N6653T · Substantial damage NTSB UNK64X3333Accident · Minor injuriesClosedPiper PA11 · Moscow, IDAug 11, 1964 · N4546M · Destroyed NTSB UNK64X3273Accident · No injuriesClosedStinson 108 · Montour, IDAug 8, 1964 · N97935 · Substantial damage NTSB UNK64X3255Accident · No injuriesClosedCessna 150 · Home, IDAug 7, 1964 · N4434U · Destroyed NTSB UNK64X3118Accident · No injuriesClosedPiper PA22 · Bonners Ferry, IDJul 30, 1964 · N9612D · Substantial damage NTSB UNK64X3084Accident · No injuriesClosedCessna 140 · Weiser, IDJul 28, 1964 · N2370V · Substantial damage NTSB UNK64X3034Accident · No injuriesClosedBoeing E75 · Craigmont, IDJul 25, 1964 · N5685N · Substantial damage NTSB UNK64X3031Accident · No injuriesClosedCessna 180 · Hegler, IDJul 25, 1964 · N4923A · Substantial damage NTSB UNK64X3025Accident · Serious injuriesClosedPiper PA25 · Shoshone, IDJul 25, 1964 · N7040Z · Destroyed NTSB UNK64X3024Accident · Serious injuriesClosedPiper PA22 · Loon Creek, IDJul 25, 1964 · N2676A · Destroyed NTSB UNK64X2964Accident · No injuriesClosedPiper PA-18 · Filer, IDJul 21, 1964 · N9104D · Substantial damage NTSB UNK64X2954Accident · 1 fatalClosedPiper PA-11 · Cottonwood, IDJul 21, 1964 · N78639 · Destroyed NTSB UNK64X2948Accident · 1 fatalClosedGrumman TBM-3 · Gibbonsville, IDJul 20, 1964 · N7016C · Destroyed NTSB UNK64X2940Accident · 1 fatalClosedPiper PA18A · Hansen, IDJul 20, 1964 · N8687D · Destroyed NTSB UNK64X2916Accident · No injuriesClosedBoeing PT17 · Roberts, IDJul 19, 1964 · N53479 · Substantial damage NTSB UNK64X2887Accident · No injuriesClosedConvair PB4Y2 · Challis, IDJul 17, 1964 · N9681C · Substantial damage NTSB UNK64X2882Accident · No injuriesClosedStearman E75 · Hansen, IDJul 17, 1964 · N58983 · Substantial damage NTSB UNK64X2844Accident · No injuriesClosedPiper PA18 · Garden Valley, IDJul 15, 1964 · N7195D · Substantial damage NTSB UNK64X2836Accident · Serious injuriesClosedCessna 182 · Cascade, IDJul 14, 1964 · N3443U · Substantial damage NTSB UNK64X2835Accident · Serious injuriesClosedCallair A9 · Malta, IDJul 14, 1964 · N3607G · Destroyed NTSB UNK64X2690Accident · No injuriesClosedBoeing A75N1 · Brangeville, IDJul 6, 1964 · N75321 · Substantial damage NTSB UNK64X2679Accident · No injuriesClosedBoeing A75N1 · Genesee, IDJul 6, 1964 · N58712 · Substantial damage NTSB UNK64X2597Accident · No injuriesClosedCessna 180 · Hamet, IDJul 1, 1964 · N3144C · Substantial damage NTSB UNK64X2554Accident · Minor injuriesClosedTravel Aire 6000B · Mccall, IDJun 28, 1964 · N9038 · Destroyed NTSB UNK64X2434Accident · No injuriesClosedBeechcraft AT11 · Chamberlin, IDJun 22, 1964 · N8069H · Substantial damage NTSB UNK64X2433Accident · No injuriesClosedPiper PA18A · Swan Valley, IDJun 22, 1964 · N7172D · Substantial damage NTSB UNK64X2415Accident · No injuriesClosedBeechcraft D35 · Kimberly, IDJun 21, 1964 · N2918B · Destroyed NTSB UNK64X2392Accident · No injuriesClosedNavion NAV4 · Lewiston, IDJun 20, 1964 · N91786 · Substantial damage NTSB UNK64X2334Accident · No injuriesClosedAeronca 11AC · Minidoka, IDJun 17, 1964 · N86116 · Substantial damage NTSB UNK64X2152Accident · Minor injuriesClosedPiper PA24 · Boise, IDJun 6, 1964 · N5109P · Destroyed