Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 OAK66F0179Accident · No injuriesClosedMooney 20A · Hayward, CADec 31, 1965 · N6552B · Substantial damage NTSB OAK66D0178Accident · Minor injuriesClosedPiper PA-22 · Mammoth Lake, CADec 31, 1965 · N3954P · Substantial damage NTSB LAX66A0052Accident · Minor injuriesClosedBell 47G-2 · Piru, CADec 31, 1965 · N972B · Substantial damage NTSB LAX66A0051Accident · 4 fatalClosedPiper PA-22 · S.Luis Obispo, CADec 30, 1965 · N7707D · Destroyed NTSB LAX66A0050Accident · Minor injuriesClosedHughes 269B · Bakersfield, CADec 30, 1965 · N9374F · Substantial damage NTSB OAK66D0170Accident · No injuriesClosedCessna 210C · Antioch, CADec 29, 1965 · N3682Y · Substantial damage NTSB LAX66F0201Accident · Serious injuriesClosedTaylorcraft BC12 · Tehachapi, CADec 26, 1965 · N29517 · Destroyed NTSB LAX66F0197Accident · No injuriesClosedGrumman G-164 · Buttonwillow, CADec 26, 1965 · N10220 · Substantial damage NTSB LAX66D0208Accident · No injuriesClosedCessna 150F · Santee, CADec 26, 1965 · N8861S · Substantial damage NTSB LAX66D0192Accident · No injuriesClosedCessna 180 · Big Bear, CADec 26, 1965 · N9005C · Substantial damage NTSB OAK66A0029Accident · No injuriesClosedDouglas DC-8 · San Francisco, CADec 25, 1965 · JA-8006 · Substantial damage NTSB LAX66D0206Accident · No injuriesClosedCessna 170A · El Cajon, CADec 25, 1965 · N9781A · Substantial damage NTSB OAK66F0167Accident · No injuriesClosedBeechcraft 55 · Livermore, CADec 24, 1965 · N3018S · Substantial damage NTSB LAX66F0251Accident · No injuriesClosedCessna 195 · Pomona, CADec 24, 1965 · N3429V · Substantial damage NTSB LAX66D0209Accident · Minor injuriesClosedChampion 7FC · San Diego, CADec 23, 1965 · N9896B · Substantial damage NTSB LAX66A0049Accident · Serious injuriesClosedDouglas DC-8 · San Diego, CADec 22, 1965 · N8061U · No damage NTSB LAX66F0198Accident · No injuriesClosedCessna 150E · Compton, CADec 21, 1965 · N3548J · Substantial damage NTSB OAK66D0161Accident · No injuriesClosedSnow S2C · San Ardo, CADec 20, 1965 · N1636S · Substantial damage NTSB LAX66F0189Accident · No injuriesClosedCessna 150 · Santa Ana, CADec 20, 1965 · N2528J · Substantial damage NTSB LAX66D0216Accident · No injuriesClosedCessna 140A · Lancaster, CADec 20, 1965 · N9475A · Substantial damage NTSB LAX66D0199Accident · No injuriesClosedCessna 140 · San Diego, CADec 19, 1965 · N76403 · Substantial damage NTSB OAK66F0181Accident · No injuriesClosedCessna 150D · Lincoln, CADec 18, 1965 · N4316U · 2 aircraft · Substantial damage NTSB LAX66F0202Accident · No injuriesClosedCessna 150 · Catalina Is, CADec 18, 1965 · N3980U · Substantial damage NTSB OAK66D0166Accident · No injuriesClosedCessna 210 · Tracy, CADec 17, 1965 · N3805Y · Substantial damage NTSB LAX66F0235Accident · No injuriesClosedPiper PA-28 · Laverne, CADec 17, 1965 · N4533R · Substantial damage NTSB OAK66D0159Accident · No injuriesClosedNavion L-17B · Livermore, CADec 16, 1965 · N7733C · Substantial damage NTSB OAK66F0172Accident · Minor injuriesClosedCessna 182 · Tahoe Valley, CADec 15, 1965 · N9078X · Substantial damage NTSB OAK66D0168Accident · No injuriesClosedPiper PA-28 · Modesto, CADec 15, 1965 · N6701W · Substantial damage NTSB LAX66F0207Accident · No injuriesClosedBeechcraft 35 · Oxnard, CADec 15, 1965 · N306B · Substantial damage NTSB OAK66A0027Accident · No injuriesClosedHughes 269A · Sonoma, CADec 14, 1965 · N8823F · Substantial damage NTSB LAX66F0191Accident · Minor injuriesClosedCessna 182B · Ocotillo, CADec 13, 1965 · N2780G · Substantial damage NTSB LAX66D0200Accident · No injuriesClosedCessna 170B · Carlsbad, CADec 13, 1965 · N8261A · Substantial damage NTSB LAX66D0196Accident · No injuriesClosedPiper PA-28 · Santa Monica, CADec 12, 1965 · N139SF · Substantial damage NTSB LAX66D0174Accident · No injuriesClosedCessna 150 · Torrance, CADec 12, 1965 · N3560J · Substantial damage NTSB OAK66A0028Accident · 3 fatalClosedCessna 182E · El Portal, CADec 11, 1965 · N3167Y · Destroyed NTSB LAX66A0047Accident · 2 fatalClosedCessna 172 · Winterhaven, CADec 9, 1965 · N8242U · Destroyed NTSB LAX66D0233Accident · No injuriesClosedStinson 108 · Hemet, CADec 6, 1965 · N97648 · Substantial damage NTSB OAK66D0183Accident · No injuriesClosedPiper PA-28 · Ravendale, CADec 5, 1965 · N6559W · Substantial damage NTSB OAK66A0026Accident · 1 fatalClosedMidget-Mstg MM-1 · Hollister, CADec 5, 1965 · N18G · Destroyed NTSB LAX66F0169Accident · No injuriesClosedPiper PA-24 · Long Beach, CADec 4, 1965 · N5327P · Substantial damage NTSB LAX66F0167Accident · No injuriesClosedFairchild 24 · Santa Paula, CADec 4, 1965 · N25327 · Substantial damage NTSB LAX66D0190Accident · No injuriesClosedPiper PA-16 · Compton, CADec 4, 1965 · N5852H · Substantial damage NTSB LAX66A0046Accident · No injuriesClosedHughes 269A · Lompoc, CADec 4, 1965 · N8900F · Substantial damage NTSB LAX66F0175Accident · No injuriesClosedPiper PA-28 · Hawthorne, CADec 3, 1965 · N5757W · Substantial damage NTSB LAX66F0171Accident · No injuriesClosedCessna 210C · Van Nuys, CADec 3, 1965 · N3681Y · Substantial damage NTSB LAX66D0228Accident · No injuriesClosedCessna 182 · Norton Afb, CADec 3, 1965 · N5008D · Substantial damage NTSB OAK66F0149Accident · No injuriesClosedCessna U-206 · Napa, CADec 1, 1965 · N2189F · Substantial damage NTSB OAK66D0154Accident · No injuriesClosedCessna 182 · Concord, CADec 1, 1965 · N2173R · Substantial damage NTSB OAK66A0025Accident · 1 fatalClosedCessna 182 · Stock, CADec 1, 1965 · N2430R · Destroyed NTSB LAX66I0045Incident · No injuriesClosedDouglas DC-3 · La Verne, CADec 1, 1965 · N29 · Minor damage