Skip to content

NTSB investigations, 1980, 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, 1980, 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") = 1980 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\") = 1980
    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") = 1980
  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 LAX81FVM08Accident · No injuriesClosedRobertson T210 · Palo Alto, CADec 30, 1980 · N92711 · Substantial damage NTSB LAX81DVG10Accident · No injuriesClosedCessna T210 · Red Bluff, CADec 29, 1980 · N761RE · Substantial damage NTSB LAX81DUQ10Accident · Minor injuriesClosedVarga 2150A · Simi Valley, CADec 29, 1980 · N8260J · Destroyed NTSB LAX81DA028Accident · 1 fatalClosedPiper PA-44 · Oceanside, CADec 29, 1980 · N18KC · Destroyed NTSB LAX81FUM09Accident · 1 fatalClosedCessna 150 · Crest, CADec 27, 1980 · N50236 · Destroyed NTSB LAX81DVW06Accident · Minor injuriesClosedCessna 180 · Stove Pipe Wls, CADec 27, 1980 · N4970A · Destroyed NTSB LAX81FVD08Accident · No injuriesClosedEnstrom F-28-C · Eureka, CADec 26, 1980 · N541H · Substantial damage NTSB LAX81FUG06Accident · No injuriesClosedHiller Acft UH-12B · Rialto, CADec 25, 1980 · N94731 · Substantial damage NTSB LAX81FA025Accident · 1 fatalClosedCessna 172M · Sierraville, CADec 21, 1980 · N1330U · Destroyed NTSB LAX81FA024Accident · Minor injuriesClosedRobinson R-22 · Malibu, CADec 20, 1980 · CG-POD · Destroyed NTSB LAX81FA023Accident · 1 fatalClosedCitabria 7KCAB · Truckee, CADec 20, 1980 · N9144L · Destroyed NTSB LAX81DVD07Accident · No injuriesClosedCessna 340A · Gasquet, CADec 17, 1980 · N2700M · Substantial damage NTSB LAX81IA022Incident · No injuriesClosedBoeing 747SP · San Francisco, CADec 15, 1980 · N537PA · Minor damage NTSB LAX81FVA16Accident · Minor injuriesClosedPiper PA-28 · Fresno, CADec 15, 1980 · N9390W · Substantial damage NTSB LAX81DVM07Accident · No injuriesClosedPitts S-1S · Paso Robles, CADec 14, 1980 · N3TG · Substantial damage NTSB LAX81DUM07Accident · No injuriesClosedCessna 150M · San Diego, CADec 14, 1980 · N63164 · 2 aircraft · Substantial damage NTSB LAX81DVM06Accident · No injuriesClosedPiper PA-38 · San Martin, CADec 13, 1980 · N2359G · Substantial damage NTSB LAX81DUM08Accident · No injuriesClosedCessna 180 · Carlsbad, CADec 13, 1980 · N52111 · Substantial damage NTSB LAX81FVG09Accident · No injuriesClosedStits SA11A · Red Bluff, CADec 12, 1980 · N9708A · Substantial damage NTSB LAX81FA031Accident · No injuriesClosedBeech 65-88 · Goleta, CADec 10, 1980 · N884S · Substantial damage NTSB LAX81DVG08Accident · No injuriesClosedPiper PA-12 · Lincoln, CADec 10, 1980 · N4218M · Substantial damage NTSB LAX81DXQ05CaseClosedPiper PA-32 · So.Lake Tahoe, CADec 8, 1980 · N31872 NTSB LAX81DVA15Accident · No injuriesClosedBoeing A75N-1 · Lemoore, CADec 5, 1980 · N62630 · Substantial damage NTSB LAX81DVA14Accident · No injuriesClosedCessna 188 · Huron, CADec 5, 1980 · N9335R · Substantial damage NTSB LAX81FVA13Accident · 1 fatalClosedAero Comdr S2R · Huron, CADec 4, 1980 · N5536X · Destroyed NTSB LAX81FUM06Accident · No injuriesClosedCessna 150 · Leucadia, CADec 3, 1980 · N6505G · Substantial damage NTSB LAX81DVG07Accident · No injuriesClosedBellanca 7ECA · Red Bluff, CADec 1, 1980 · N5067C · Substantial damage NTSB LAX81FUQ04Accident · 1 fatalClosedBakeng Double · Rosamond, CANov 30, 1980 · N71DD · Destroyed NTSB LAX81DVA17Accident · No injuriesClosedErco 415-C · Strathmore, CANov 30, 1980 · N99785 · Substantial damage NTSB LAX81FUA02Accident · Minor injuriesClosedGrumman AA-5B · Torrance, CANov 29, 1980 · N74494 · Destroyed NTSB LAX81FVG06Accident · Minor injuriesClosedCessna 172A · San Andreas, CANov 28, 1980 · N7614T · Substantial damage NTSB LAX81DUQ05Accident · No injuriesClosedCessna 150 · Lancaster, CANov 28, 1980 · N3529J · Substantial damage NTSB LAX81DVM05Accident · No injuriesClosedBeech C23 · San Jose, CANov 27, 1980 · N6708N · Substantial damage NTSB LAX81DXQ03Accident · No injuriesClosedCessna 180 · Truckee, CANov 26, 1980 · N9232C · Substantial damage NTSB LAX81FA019Accident · 1 fatalClosedCessna 210 · Sanger, CANov 24, 1980 · N444CT · Destroyed NTSB LAX81FVM04Accident · Minor injuriesClosedPiper PA-28 · Carmel Valley, CANov 23, 1980 · N6607W · Substantial damage NTSB LAX81DUQ03Accident · Minor injuriesClosedCessna 172K · Inyokern, CANov 23, 1980 · N78595 · Substantial damage NTSB LAX81DUQ07Accident · Minor injuriesClosedCessna 150 · Pacoima, CANov 22, 1980 · N3304J · Substantial damage NTSB LAX81FA018Accident · 4 fatalClosedBeech E33A · Montague, CANov 21, 1980 · N528Q · Destroyed NTSB LAX81DUG04Accident · No injuriesClosedCessna 152 · La Verne, CANov 20, 1980 · N6105B · Destroyed NTSB LAX81DUQ06Accident · No injuriesClosedCessna 150 · Van Nuys, CANov 19, 1980 · N66484 · Substantial damage NTSB LAX81DUG05Accident · No injuriesClosedHiller Acft UH-12B · Rialto, CANov 18, 1980 · N5310V · Destroyed NTSB LAX81FA016Accident · 1 fatalClosedCessna 172N · Fillmore, CANov 17, 1980 · N5259J · Destroyed NTSB LAX81FA015Accident · 2 fatalClosedPiper PA-38 · Santa Rosa, CANov 17, 1980 · N2553P · Destroyed NTSB LAX81FUM04Accident · No injuriesClosedCessna 182 · San Diego, CANov 16, 1980 · N96528 · Substantial damage NTSB LAX81FA014Accident · 1 fatalClosedBeech K35 · Big Bear Lake, CANov 16, 1980 · N5362E · Destroyed NTSB LAX81FUM05Accident · Minor injuriesClosedCessna 150 · El Cajon, CANov 15, 1980 · N63604 · Substantial damage NTSB LAX81DVM03Accident · No injuriesClosedPiper PA-28 · Sn Luis Obspo, CANov 15, 1980 · N2726M · Substantial damage NTSB LAX81DVA10Accident · No injuriesClosedCessna 150 · Shafter, CANov 15, 1980 · N19284 · Substantial damage NTSB LAX81FVA09Accident · No injuriesClosedBeech B90 · Fresno, CANov 4, 1980 · N88RP · Substantial damage