Skip to content

NTSB investigations, 1976, CA

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1976, CA per year, 1962–2026: 19,367 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	81

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") = 1976 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\") = 1976
    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") = 1976
  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 OAK77FVM05Accident · No injuriesClosedPiper PA-24 · San Carlos, CADec 31, 1976 · N6642P · Substantial damage NTSB OAK77FVA13Accident · Minor injuriesClosedCessna 150L · Madera, CADec 31, 1976 · N5419Q · Destroyed NTSB OAK77FVA12Accident · 1 fatalClosedBoeing A75N1 · Oakdale, CADec 31, 1976 · N53039 · Destroyed NTSB LAX77FUG17Accident · No injuriesClosedMooney M20C · Big Bear City, CADec 31, 1976 · N6423U · Substantial damage NTSB LAX77FA018Accident · 4 fatalClosedBeech 95-B55 · Barstow, CADec 31, 1976 · N4635S · Destroyed NTSB LAX77FA017Accident · No injuriesClosedDehavilland DHC-6 · Los Angeles, CADec 29, 1976 · N66191 · 2 aircraft · Substantial damage NTSB LAX77DUQ12Accident · No injuriesClosedCessna 150 · California Cty, CADec 28, 1976 · N3986U · Substantial damage NTSB LAX77DVM04Accident · Minor injuriesClosedPiper PA-28 · Paso Robles, CADec 27, 1976 · N440FL · Substantial damage NTSB LAX77FUG20Accident · No injuriesClosedKR 1 · Chino, CADec 26, 1976 · N65117 · Substantial damage NTSB LAX77FA016Accident · 1 fatalClosedErco 415-C · Murrieta, CADec 26, 1976 · N87406 · Destroyed NTSB LAX77FUQ13Accident · Minor injuriesClosedCessna 177B · Burbank, CADec 21, 1976 · N34100 · Substantial damage NTSB OAK77FVG16Accident · Serious injuriesClosedGrum Amer AA1A · Willows, CADec 19, 1976 · N6321L · Substantial damage NTSB OAK77FA008Accident · 2 fatalClosedCessna 150G · Escalon, CADec 19, 1976 · N2630J · Destroyed NTSB LAX77DUG16Accident · No injuriesClosedPiper PA-28 · Palm Springs, CADec 19, 1976 · N33378 · Substantial damage NTSB OAK77FA007Accident · 4 fatalClosedBeech H-35 · Vacaville, CADec 18, 1976 · N5458D · Destroyed NTSB LAX77FUA03Accident · No injuriesClosedBeech A35 · Avalon, CADec 18, 1976 · N304Q · Destroyed NTSB LAX77FUM10Accident · Serious injuriesClosedPiper J5A · Brawley, CADec 17, 1976 · N41SB · Destroyed NTSB LAX77FA015Accident · 1 fatalClosedPiper PA-23 · Blythe, CADec 15, 1976 · N5590Y · Destroyed NTSB LAX77FUA02Accident · No injuriesClosedHughes 269B · Long Beach, CADec 14, 1976 · N9566F · Substantial damage NTSB LAX77DUG15Accident · No injuriesClosedCessna 172 · Riverside, CADec 10, 1976 · N84343 · Substantial damage NTSB OAK77FA015Accident · 2 fatalClosedLockheed PV-1 · Yosemite, CADec 9, 1976 · N80BD · Destroyed NTSB LAX77FUG14Accident · Serious injuriesClosedCessna 150 · Etiwanda, CADec 7, 1976 · N66012 · Substantial damage NTSB OAK77FVG15Accident · No injuriesClosedPiper PA-23 · Jackson, CADec 6, 1976 · N5381Y · Substantial damage NTSB LAX77FA014Accident · 5 fatalClosedAerostar 601P · Costa Mesa, CADec 5, 1976 · N7485S · Destroyed NTSB LAX77FUQ11Accident · No injuriesClosedCessna 340 · Santa Ynez, CADec 4, 1976 · N69476 · Substantial damage NTSB LAX77FUJ10Accident · 1 fatalClosedScorpion TOO · Corona, CADec 4, 1976 · N21DD · Destroyed NTSB LAX77FUD01Accident · Serious injuriesClosedCessna 150B · Baldwin Hills, CADec 4, 1976 · N1136Y · Substantial damage NTSB LAX77DUG13Accident · No injuriesClosedGrumman F6F-5 · Elsinore, CADec 4, 1976 · N100TF · Substantial damage NTSB OAK77FVG14Accident · Serious injuriesClosedCessna 172N · Auburn, CANov 30, 1976 · N21754 · Substantial damage NTSB LAX77FUG11Accident · No injuriesClosedCessna 150D · Riverside, CANov 29, 1976 · N4539U · Substantial damage NTSB LAX77FA012Accident · 1 fatalClosedBell 47J · Glen Ivy, CANov 28, 1976 · N62883 · Destroyed NTSB OAK77DVA11Accident · No injuriesClosedLuscombe 8A · Visalia, CANov 27, 1976 · N1093K · Substantial damage NTSB OAK77FVD06Accident · No injuriesClosedCessna T210 · Eureka, CANov 26, 1976 · N1650X · Substantial damage NTSB OAK77DVD08Accident · Serious injuriesClosedCessna 182 · Orleans, CANov 26, 1976 · N7348S · Destroyed NTSB LAX77FUG12Accident · No injuriesClosedCessna 120 · Corona, CANov 26, 1976 · N2239N · Substantial damage NTSB OAK77DVD07Accident · No injuriesClosedPiper PA-28R · Santa Rosa, CANov 24, 1976 · N75044 · Destroyed NTSB LAX77FUQ09Accident · No injuriesClosedBellanca 17-30 · Van Nuys, CANov 22, 1976 · N4807V · Destroyed NTSB OAK77IA006Incident · No injuriesClosedBeech A36 · San Francisco, CANov 21, 1976 · N124TW · 2 aircraft · Minor damage NTSB OAK77FVW04Accident · Minor injuriesClosedCessna 150 · Stovepipe Well, CANov 21, 1976 · N60695 · Destroyed NTSB OAK77DVG12Accident · No injuriesClosedAero Comdr 600S2R · Arbuckle, CANov 21, 1976 · N4860X · Substantial damage NTSB LAX77FQU10Accident · No injuriesClosedGlobe GC-1B · Pearblossom, CANov 21, 1976 · N3785K · Substantial damage NTSB LAX77FA011Accident · 2 fatalClosedCessna 182 · San Marcos, CANov 20, 1976 · N9186M · Destroyed NTSB LAX77FUM09Accident · No injuriesClosedBeech 95-B55 · Carlsbad, CANov 19, 1976 · N4191S · Substantial damage NTSB OAK77DVG11Accident · No injuriesClosedGrumman G-164 · Williams, CANov 17, 1976 · N10211 · Substantial damage NTSB OAK77FVG10Accident · 1 fatalClosedCessna T210K · Davis, CANov 16, 1976 · N8289M · Destroyed NTSB OAK77FA029Accident · 2 fatalClosedCessna 182L · Bell Station, CANov 14, 1976 · N3187R · Destroyed NTSB LAX77FA010Accident · 1 fatalClosedAero Comdr 112A · Trabuco Canyon, CANov 14, 1976 · N1450J · Destroyed NTSB OAK77DVG09Accident · No injuriesClosedGrumman G-164 · Live Oak, CANov 13, 1976 · N704Y · Substantial damage NTSB LAX77FUQ07Accident · Minor injuriesClosedTaylor Mono · Lancaster, CANov 13, 1976 · N172L · Substantial damage NTSB LAX77DUQ08Accident · No injuriesClosedChampion 7ACA · Pacoima, CANov 13, 1976 · N62965 · Substantial damage