Skip to content

NTSB investigations, 1964, CA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, CA per year, 1962–2026: 19,366 cases
1962	10
1963	11
1964	659
1965	654
1966	755
1967	799
1968	668
1969	613
1970	617
1971	605
1972	510
1973	499
1974	523
1975	488
1976	484
1977	497
1978	548
1979	473
1980	472
1981	403
1982	391
1983	441
1984	388
1985	329
1986	316
1987	315
1988	322
1989	289
1990	318
1991	291
1992	277
1993	260
1994	242
1995	237
1996	223
1997	182
1998	212
1999	186
2000	222
2001	183
2002	176
2003	182
2004	171
2005	191
2006	187
2007	207
2008	158
2009	187
2010	158
2011	141
2012	134
2013	128
2014	117
2015	118
2016	119
2017	162
2018	119
2019	114
2020	105
2021	94
2022	111
2023	103
2024	101
2025	91
2026	80

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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 UNK65X1201Accident · No injuriesClosedPiper PA-24 · Apple Valley, CADec 31, 1964 · N6506P · Substantial damage NTSB LAX65A0058Accident · 2 fatalClosedBeechcraft T34A · Wrightwood, CADec 31, 1964 · N5506V · Destroyed NTSB UNK65X1192Accident · 3 fatalClosedCessna 182E · Ventura, CADec 30, 1964 · N9256X · Destroyed NTSB UNK65X1191Accident · 4 fatalClosedPiper PA-28 · Gorman, CADec 30, 1964 · N7023W · Destroyed NTSB UNK65X1188Accident · Minor injuriesClosedConvair CV-340 · Saugus, CADec 30, 1964 · N73102 · Substantial damage NTSB UNK65X1182Accident · Serious injuriesClosedStinson 108-3 · Van Nuys, CADec 29, 1964 · N6641M · Destroyed NTSB UNK65X1168Accident · No injuriesClosedBeechraft D35 · San Diego, CADec 28, 1964 · N2070D · Substantial damage NTSB UNK65X1164Accident · 5 fatalClosedCessna 182G · Boulder Creek, CADec 27, 1964 · N3187S · Destroyed NTSB UNK65X1157Accident · No injuriesClosedLuscombe 8E · Auburn, CADec 27, 1964 · N2779K · Substantial damage NTSB UNK65X1156Accident · No injuriesClosedBellanca 14-19 · Santa Monica, CADec 27, 1964 · N9828B · Substantial damage NTSB UNK65X1149Accident · 2 fatalClosedPiper PA16 · La Habra, CADec 26, 1964 · N5859H · Destroyed NTSB UNK65X1144Accident · Minor injuriesClosedPiper PA-22 · Lucerne Vally, CADec 26, 1964 · N5298Z · Destroyed NTSB UNK65X1136Accident · No injuriesClosedChampion 7GCB · Seiad, CADec 26, 1964 · N8982R · Substantial damage NTSB UNK65X1124Accident · Serious injuriesClosedHughes 269A · Castiac, CADec 24, 1964 · N8723F · Destroyed NTSB UNK65X1117Accident · 3 fatalClosedLockheed L-1049 · San Francisco, CADec 24, 1964 · N6915C · Destroyed NTSB UNK65X1110Accident · No injuriesClosedCessna 140 · Inyokern, CADec 24, 1964 · N76736 · Substantial damage NTSB UNK65X1091Accident · No injuriesClosedPiper PA-22 · Palm Springs, CADec 22, 1964 · N2678A · Destroyed NTSB UNK65X1082Incident · No injuriesClosedBoeing 707 351C · Travis Afb, CADec 21, 1964 · N356U · Minor damage NTSB UNK65X1078Accident · No injuriesClosedBeechraft M35 · Van Nuys, CADec 21, 1964 · N9775R · Substantial damage NTSB UNK65X1064Accident · 2 fatalClosedPiper PA-24 · Huntington Lk, CADec 19, 1964 · N5552P · Destroyed NTSB UNK65X1063Accident · No injuriesClosedPiper PA24 · Santa Monica, CADec 19, 1964 · N6633P · Substantial damage NTSB UNK65X1060Accident · 1 fatalClosedCessna 175 · Cloverdale, CADec 19, 1964 · N7226M · Destroyed NTSB UNK65X1056Accident · No injuriesClosedCessna 150 · San Carlos, CADec 19, 1964 · N5973E · 2 aircraft · Substantial damage NTSB UNK65X1047Accident · 2 fatalClosedBeechcraft C-50 · Altadena, CADec 18, 1964 · N4931B · Destroyed NTSB UNK65X1043Accident · No injuriesClosedHughes 269B · Davis, CADec 18, 1964 · N9374F · Substantial damage NTSB UNK65X1030Accident · No injuriesClosedMooney M20C · San Jose, CADec 16, 1964 · N6998U · Substantial damage NTSB UNK65X1013Accident · No injuriesClosedCamair 480 · Van Nuys, CADec 14, 1964 · N188V · Substantial damage NTSB UNK65X1007Accident · 1 fatalClosedCessna 120 · Anaheim, CADec 13, 1964 · N1708V · 2 aircraft · Substantial damage NTSB UNK65X1002Accident · No injuriesClosedAero Cmdr 560A · Santee, CADec 13, 1964 · N2736B · Substantial damage NTSB UNK65X0990Accident · 1 fatalClosedDerringer D-1 · Palos Verdes, CADec 12, 1964 · N88941 · Destroyed NTSB UNK65X0989Accident · Minor injuriesClosedPiper PA-22 · Blythe, CADec 12, 1964 · N5861Z · Substantial damage NTSB UNK65X0978Accident · No injuriesClosedLuscombe 8-A · San Diego, CADec 11, 1964 · N71263 · Substantial damage NTSB UNK65X0977Accident · No injuriesClosedCessna 182 · Mendota, CADec 11, 1964 · N5704B · Substantial damage NTSB UNK65X0972Accident · 1 fatalClosedCessna 310 · Napa, CADec 10, 1964 · N3016D · Destroyed NTSB UNK65X0971Accident · 4 fatalClosedCessna 172 · Torrance, CADec 10, 1964 · N8022B · Destroyed NTSB UNK65X0970Accident · 1 fatalClosedHughes 269A · Moraga, CADec 10, 1964 · N8811F · Destroyed NTSB UNK65X0961Accident · No injuriesClosedPiper PA-28 · Burbank, CADec 9, 1964 · N7490W · Substantial damage NTSB UNK65X0958Accident · No injuriesClosedPiper PA28 · Bakersfield, CADec 9, 1964 · N6069W · Substantial damage NTSB UNK65X0947Accident · No injuriesClosedCessna 172 · Riverside, CADec 7, 1964 · N3090U · Substantial damage NTSB UNK65X0937Accident · Minor injuriesClosedCessna 182 · Calif Valley, CADec 6, 1964 · N3719U · Substantial damage NTSB UNK65X0926Accident · Minor injuriesClosedStits SA3A · Eureka, CADec 5, 1964 · N3354G · Substantial damage NTSB UNK65X0924Accident · No injuriesClosedAeronca 7AC · Rialto, CADec 5, 1964 · N2559E · Substantial damage NTSB UNK65X0919Accident · No injuriesClosedPiper PA28 · Franklin, CADec 5, 1964 · N5506W · Substantial damage NTSB UNK65X0916Accident · No injuriesClosedSnow S2C · Chowchilla, CADec 4, 1964 · N1600S · Substantial damage NTSB UNK65X0914Accident · No injuriesClosedChampion 7EC · Pacoima, CADec 4, 1964 · N4328C · Substantial damage NTSB UNK65X0903Accident · No injuriesClosedCessna 172 · Inyokern, CADec 2, 1964 · N7882X · Substantial damage NTSB UNK65X0899Accident · No injuriesClosedBeechraft AT11 · Pacoima, CADec 2, 1964 · N75589 · Minor damage NTSB UNK65X0883Accident · No injuriesClosedCessna 182 · March Afb, CANov 29, 1964 · N7197E · Substantial damage NTSB UNK65X0882Accident · No injuriesClosedCessna 150 · San Bernardino, CANov 29, 1964 · N7965E · Substantial damage NTSB UNK65X0863Accident · No injuriesClosedCessna 182C · Vacaville, CANov 28, 1964 · N8781T · Substantial damage