Skip to content

NTSB investigations, 1981, CA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1981, CA per year, 1962–2026: 19,365 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	79

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") = 1981 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\") = 1981
    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") = 1981
  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 LAX82FUA08Accident · Minor injuriesClosedCessna 172K · Laguna Beach, CADec 27, 1981 · N79965 · Destroyed NTSB LAX82DVM07Accident · No injuriesClosedCessna 150 · Ipomo, CADec 27, 1981 · N50528 · Substantial damage NTSB LAX82FVM08Accident · Serious injuriesClosedPiper PA-22 · Half Moon Bay, CADec 24, 1981 · N8899C · Substantial damage NTSB LAX82FA031Accident · 1 fatalClosedRobertson A185F · Lake Oroville, CADec 23, 1981 · N4644E · Substantial damage NTSB LAX82FVG11Accident · Minor injuriesClosedGrum Amer AA-1B · Vacaville, CADec 22, 1981 · N1632R · 2 aircraft · Substantial damage NTSB LAX82DVD08Accident · Minor injuriesClosedCessna T210 · Stockton, CADec 18, 1981 · N6479Y · Substantial damage NTSB LAX82FVM06Accident · No injuriesClosedCessna 172 · San Carlos, CADec 17, 1981 · N5440J · Substantial damage NTSB LAX82FA027Accident · 4 fatalClosedCessna 182L · Coalinga, CADec 13, 1981 · N42864 · Destroyed NTSB LAX82FUA07Accident · No injuriesClosedCessna 150 · Laguna Beach, CADec 12, 1981 · N8193V · Substantial damage NTSB LAX82FA026Accident · 2 fatalClosedHughes 369HS · Lakeside, CADec 11, 1981 · N90525 · Destroyed NTSB LAX82FVG10Accident · No injuriesClosedHiller Acft UH-12E · Angels Camp, CADec 10, 1981 · N93478 · Substantial damage NTSB LAX82FVD07Accident · No injuriesClosedCessna T210F · Penngrove, CADec 10, 1981 · N6171R · Destroyed NTSB LAX82FUA06Accident · No injuriesClosedHughes 269B · Torrance, CADec 9, 1981 · N13470 · Substantial damage NTSB LAX82FA025Accident · 2 fatalClosedCessna 150M · Antioch, CADec 8, 1981 · N704XM · Destroyed NTSB LAX82DUG04Accident · Minor injuriesClosedCessna 150F · Adelanto, CADec 5, 1981 · N8043F · Substantial damage NTSB LAX82DUM05Accident · Minor injuriesClosedHughes 369 · Winterhaven, CADec 4, 1981 · N58184 · Destroyed NTSB LAX82FVM04Accident · No injuriesClosedCessna 402 · Pacific Grove, CADec 3, 1981 · N2611C · Destroyed NTSB LAX82FVM03Accident · Minor injuriesClosedCessna T210N · San Francisco, CADec 3, 1981 · N765DS · Substantial damage NTSB LAX82FVA09Accident · No injuriesClosedAero Comdr S-2R · Corcoran, CADec 3, 1981 · N4248X · Substantial damage NTSB LAX82FVD06Accident · No injuriesClosedBeech C23 · Hayward, CANov 30, 1981 · N67035 · Destroyed NTSB LAX82FVM02Accident · No injuriesClosedBeech 95-B55 · King City, CANov 28, 1981 · N18ER · Substantial damage NTSB LAX82DVG09Accident · Serious injuriesClosedCessna 182 · Redding, CANov 28, 1981 · N94322 · Destroyed NTSB LAX82FUM04Accident · No injuriesClosedRobinson R22 · Santee, CANov 27, 1981 · N9065L · Substantial damage NTSB LAX82DVM05Accident · No injuriesClosedPiper PA-38 · Hollister, CANov 27, 1981 · N25198 · Substantial damage NTSB LAX82IA022Incident · No injuriesClosedBell 206L-1 · Avalon, CANov 26, 1981 · N57397 · No damage NTSB LAX82FVG08Accident · Serious injuriesClosedMooney M20D · Napa, CANov 26, 1981 · N1920Y · Substantial damage NTSB LAX82FVG07Accident · Serious injuriesClosedCessna 182H · Sacramento, CANov 25, 1981 · N2361X · Substantial damage NTSB LAX82FVG06Accident · No injuriesClosedPiper PA-32 · Woodland, CANov 24, 1981 · N9292K · Substantial damage NTSB LAX82FA019Accident · 3 fatalClosedCessna 210 · Susanville, CANov 22, 1981 · N5181V · Destroyed NTSB LAX82FA018Accident · 2 fatalClosedPiper PA-34 · Oceanside, CANov 22, 1981 · N8371U · Destroyed NTSB LAX82IA020Incident · No injuriesClosedCessna 421B · Long Beach, CANov 20, 1981 · N421PT · No damage NTSB LAX82FVD05Accident · No injuriesClosedCessna 172 · Ukiah, CANov 19, 1981 · N5609A · Substantial damage NTSB LAX82DUM03Accident · No injuriesClosedCessna 140 · Barrett Lake, CANov 19, 1981 · N76403 · Substantial damage NTSB LAX81IA015Incident · No injuriesClosedBeech D18S · Long Beach, CANov 18, 1981 · N104J · Minor damage NTSB LAX82DUJ08Accident · No injuriesClosedPiper PA-28 · Mesa, CANov 15, 1981 · N8089R · Destroyed NTSB LAX82FUM02Accident · 1 fatalClosedRockwell S-2R · Calipatria, CANov 14, 1981 · N8862Q · Destroyed NTSB LAX82FA014Accident · 1 fatalClosedBell 206B · Napa, CANov 12, 1981 · N49756 · Destroyed NTSB LAX82FA012Accident · 2 fatalClosedRobinson R22 · Livermore, CANov 11, 1981 · N9073Q · Destroyed NTSB LAX82DUQ02Accident · No injuriesClosedGrum Amer AA-5A · Van Nuys, CANov 11, 1981 · N26353 · Substantial damage NTSB LAX82FUA05CaseClosedCessna 172 · Avalon, CANov 10, 1981 · N7554G NTSB LAX82DVA07Accident · No injuriesClosedCessna 152 · Bakersfield, CANov 10, 1981 · N4646L · Substantial damage NTSB LAX82FUQ03Accident · No injuriesClosedPiper 601P · Burbank, CANov 9, 1981 · N9774Q · Substantial damage NTSB LAX82FUD02Accident · No injuriesClosedCessna 172N · Santa Monica, CANov 8, 1981 · N2140E · 2 aircraft · Substantial damage NTSB LAX81FVG04Accident · No injuriesClosedEnstrom F-28A · Elk Grove, CANov 7, 1981 · N9268 · Substantial damage NTSB LAX82FUD01Accident · No injuriesClosedCessna T210L · Compton, CANov 6, 1981 · N59100 · Substantial damage NTSB LAX82FA010Accident · 2 fatalClosedPiper PA-23 · San Fernando, CANov 4, 1981 · N1099P · Destroyed NTSB LAX82FVD04Accident · 1 fatalClosedPitts S1-C · Livermore, CANov 1, 1981 · N3194 · Destroyed NTSB LAX82FVD03Accident · 1 fatalClosedStits SA3A · Tracy, CAOct 31, 1981 · N7758C · Destroyed NTSB LAX82DVD02Accident · No injuriesClosedWilder OFA-1 · Livermore, CAOct 31, 1981 · N42308 · Substantial damage NTSB LAX82FA009Accident · 3 fatalClosedCessna 310R · Elsinore, CAOct 28, 1981 · N5467J · Destroyed