Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 OAK76AP039Accident · 1 fatalClosedCessna A150K · Oakland, CADec 29, 1975 · N8430M · Destroyed NTSB OAK76AP036Accident · 2 fatalClosedCessna 150L · Etna, CADec 29, 1975 · N6028J · Destroyed NTSB OAK76DVG38Accident · Serious injuriesClosedPiper PA-18A · Tulelake, CADec 28, 1975 · N1452C · Destroyed NTSB OAK76AP035Accident · 5 fatalClosedMooney M20A · Stockton, CADec 28, 1975 · N8120E · Destroyed NTSB OAK76DVA33Accident · No injuriesClosedCessna 140 · Shaver Lake, CADec 27, 1975 · N2703N · Destroyed NTSB LAX76IL043Incident · No injuriesClosedAero Star 601 · San Diego, CADec 27, 1975 · N97Q · Minor damage NTSB OAK76DVG40Accident · No injuriesClosedPiper PA-22 · Angwin, CADec 26, 1975 · N162 · Substantial damage NTSB LAX76DVA31Accident · No injuriesClosedCessna T210L · Bakersfield, CADec 25, 1975 · N5148Q · Substantial damage NTSB OAK76DVW10Accident · No injuriesClosedPiper PA-22 · Bishop, CADec 24, 1975 · N8689D · Destroyed NTSB LAX76FUQ19Accident · No injuriesClosedCessna 150 · Lancaster, CADec 23, 1975 · N7314X · Substantial damage NTSB OAK76DVD19Accident · No injuriesClosedCessna 177 · Livermore, CADec 22, 1975 · N30097 · Substantial damage NTSB LAX76FUD06Accident · No injuriesClosedPiper J-3 · Santa Monica, CADec 22, 1975 · N30558 · Substantial damage NTSB LAX76FUA17Accident · No injuriesClosedRobinson R22 · Torrance, CADec 22, 1975 · N67010 · Substantial damage NTSB LAX76AL041Accident · 3 fatalClosedPiper PA-28 · Banning, CADec 22, 1975 · N7997N · Destroyed NTSB OAK76DVD18Accident · Minor injuriesClosedPiper PA-28 · Santa Rosa, CADec 21, 1975 · N134SF · Substantial damage NTSB OAK76AP034Accident · 1 fatalClosedNavion A · Maxwell, CADec 21, 1975 · N91441 · Destroyed NTSB LAX76DUG27Accident · Minor injuriesClosedErco 415-C · Needles, CADec 20, 1975 · N93457 · Substantial damage NTSB LAX76AL040Accident · 2 fatalClosedRearwin 185 · Etiwanda, CADec 20, 1975 · N33392 · Destroyed NTSB LAX76FUQ18Accident · No injuriesClosedCessna 150L · Morthridge, CADec 19, 1975 · N18020 · Substantial damage NTSB OAK76DVG36Accident · No injuriesClosedCessna 175A · Fair Oaks, CADec 18, 1975 · N7059E · Substantial damage NTSB OAK76FVG37Accident · No injuriesClosedCessna 337E · Sacramento, CADec 17, 1975 · N414SG · Substantial damage NTSB LAX76FUM16Accident · No injuriesClosedHiller Acft UH-12B · San Diego, CADec 16, 1975 · N57U · Substantial damage NTSB OAK76FVM19Accident · No injuriesClosedPiper J-3 · Saratoga, CADec 15, 1975 · N3614K · Substantial damage NTSB OAK76DVM20Accident · No injuriesClosedBell 47G-2 · Salinas, CADec 14, 1975 · N2874B · Substantial damage NTSB LAX76FUQ25Accident · No injuriesClosedCessna 210B · Santa Susana, CADec 14, 1975 · N9719X · Substantial damage NTSB LAX75DUG28Accident · No injuriesClosedPiper PA-22 · Chino, CADec 14, 1975 · N5806Z · Substantial damage NTSB OAK76DVD21Accident · Minor injuriesClosedBeech B19 · Rohnerville, CADec 13, 1975 · N2183W · Destroyed NTSB OAK76DVA32Accident · No injuriesClosedCessna 182P · Visalia, CADec 13, 1975 · N7332D · Substantial damage NTSB OAK76AP033Accident · Minor injuriesClosedCessna TU206D · Cantua Creek, CADec 12, 1975 · N72148 · Substantial damage NTSB LAX76DVG24Accident · No injuriesClosedCessna 150 · Riverside, CADec 9, 1975 · N63007 · Substantial damage NTSB OAK76AP032Accident · No injuriesClosedBeech D18S · Oakland, CADec 8, 1975 · N4861 · Substantial damage NTSB OAK76FVM18Accident · Minor injuriesClosedCessna T210L · San Jose, CADec 7, 1975 · N30224 · Substantial damage NTSB OAK76DVD17Accident · Minor injuriesClosedCessna 182 · Oakland, CADec 7, 1975 · N79889 · Destroyed NTSB LAX76FUM15Accident · Serious injuriesClosedBeech 95-E55 · San Marcos, CADec 6, 1975 · N4555S · Destroyed NTSB LAX76DUG22Accident · No injuriesClosedCessna 210E · 29 Palms, CADec 4, 1975 · N4908U · Destroyed NTSB OAK76AP031Accident · 2 fatalClosedMooney M22 · Davis, CADec 3, 1975 · N7713M · Destroyed NTSB LAX75DUQ17Accident · No injuriesClosedChampion 7GCBC · Van Nuys, CADec 2, 1975 · N88165 · Substantial damage NTSB OAK76AP030Accident · 4 fatalClosedCessna 210L · Mt.Shasta, CADec 1, 1975 · N1MG · Destroyed NTSB LAX75DUG25Accident · No injuriesClosedCessna 177A · 29 Palms, CADec 1, 1975 · N30351 · Substantial damage NTSB OAK76FVM15Accident · Serious injuriesClosedCessna 120 · Morgan Hill, CANov 30, 1975 · N76396 · Substantial damage NTSB LAX76FUG21Accident · No injuriesClosedPiper PA-24 · Diamond Bar, CANov 29, 1975 · N7971P · Destroyed NTSB OAK76DVD16Accident · Minor injuriesClosedCessna 170 · Tamales, CANov 28, 1975 · N3159A · Destroyed NTSB LAX76AL039Accident · 3 fatalClosedBeech P35 · Big Bear City, CANov 28, 1975 · N1528Z · Destroyed NTSB LAX76AL038Accident · 1 fatalClosedCessna 172E · Corona, CANov 27, 1975 · N5342T · Destroyed NTSB LAX76DUG23Accident · Serious injuriesClosedCessna P206A · Baker, CANov 26, 1975 · N4609F · Destroyed NTSB LAX76DVA30Accident · No injuriesClosedCessna 182 · Bakersfield, CANov 24, 1975 · N70946 · Substantial damage NTSB LAX7LDUG20Accident · No injuriesClosedCessna A185F · Bermuda Dunes, CANov 19, 1975 · N4871C · Substantial damage NTSB OAK76DXQ25Accident · No injuriesClosedErco 415-C · Blue Canyon, CANov 18, 1975 · N935N · Substantial damage NTSB LAX76IL036Incident · No injuriesClosedPiper PA-32 · Bermuda Dunes, CANov 18, 1975 · N198GM · Minor damage NTSB LAX76FUD05Accident · No injuriesClosedCessna TU206 · Santa Monica, CANov 16, 1975 · N3952G · Substantial damage