Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 LAX72DVA41Accident · No injuriesClosedPiper PA-24 · Bakersfield, CADec 28, 1971 · N9085P · Substantial damage NTSB OAK72FVM18Accident · No injuriesClosedDehavilland DH104 · San Carlos, CADec 27, 1971 · N6307T · Substantial damage NTSB LAX72FUD05Accident · No injuriesClosedErco 415-CD · Pasadena, CADec 26, 1971 · N3148H · Substantial damage NTSB LAX72DUQ53Accident · No injuriesClosedCessna 140 · Van Nuys, CADec 26, 1971 · N3585V · Substantial damage NTSB LAX72DUG50Accident · No injuriesClosedCessna 150 · Perris, CADec 26, 1971 · N22940 · Substantial damage NTSB OAK72FVD29Accident · Serious injuriesClosedCessna 150 · Livermore, CADec 24, 1971 · N6675G · Substantial damage NTSB LAX72FUG42Accident · Serious injuriesClosedBeech 23 · Big Bear, CADec 22, 1971 · N2366Q · Substantial damage NTSB LAX72AL042Accident · 3 fatalClosedCessna 172K · Newhall, CADec 22, 1971 · N46509 · Destroyed NTSB OAK72FVA38Accident · No injuriesClosedCessna 150 · Selma, CADec 21, 1971 · N6684G · Substantial damage NTSB OAK72AP020Accident · 1 fatalClosedCessna 182G · Fresno, CADec 20, 1971 · N3180S · Destroyed NTSB OAK72DVA39Accident · No injuriesClosedPiper PA-24 · Porterville, CADec 19, 1971 · N6564P · Substantial damage NTSB LAX72FUA29Accident · No injuriesClosedAerostar 601 · Santa Ana, CADec 19, 1971 · N7494S · Substantial damage NTSB LAX72DUG43Accident · No injuriesClosedHughes 269A · Ontario, CADec 18, 1971 · N8846F · Substantial damage NTSB LAX72FVA37Accident · Serious injuriesClosedBell 47G5 · Mcfarland, CADec 17, 1971 · N8557F · Destroyed NTSB LAX72DUG46Accident · No injuriesClosedChampion 7GCBC · La Verne, CADec 17, 1971 · N7590F · Substantial damage NTSB LAX72FUG39Accident · No injuriesClosedBell 47B · La Verne, CADec 15, 1971 · N514SF · Substantial damage NTSB OAK72FVM20Accident · 1 fatalClosedN.American SNJ-5B · Gonzales, CADec 14, 1971 · N3437G · Destroyed NTSB OAK72DVG30Accident · No injuriesClosedCessna 182 · Tulelake, CADec 12, 1971 · N2396G · Substantial damage NTSB LAX72DUG41Accident · No injuriesClosedCessna 150 · Apple Vally, CADec 12, 1971 · N8182S · Substantial damage NTSB LAX72AL071Accident · Minor injuriesClosedGrumman G-21 · Long Beach, CADec 12, 1971 · N11CS · Substantial damage NTSB LAX72FUG40Accident · No injuriesClosedRearwin 185 · Chino, CADec 10, 1971 · N92902 · Substantial damage NTSB OAK72FVA36Accident · No injuriesClosedCessna 172 · Layton, CADec 5, 1971 · N78286 · Substantial damage NTSB LAX72DUG38Accident · No injuriesClosedCessna 150 · Chino, CADec 5, 1971 · N5927J · Substantial damage NTSB OAK72DVM17Accident · No injuriesClosedBeech 35 · San Jose, CADec 4, 1971 · N3009V · 2 aircraft · Substantial damage NTSB OAK72DVM16Accident · No injuriesClosedPiper PA-28 · Salinas, CADec 4, 1971 · N8176W · Substantial damage NTSB OAK72AP017Accident · 1 fatalClosedTaylorcraft DC-65 · Mariposa, CADec 4, 1971 · N47545 · Destroyed NTSB OAK72FVG29Accident · No injuriesClosedMeyers 200-D · Sacramento, CADec 3, 1971 · N2903T · Substantial damage NTSB LAX72FUA26Accident · No injuriesClosedCessna 150H · Santa Ana, CADec 1, 1971 · N50273 · Substantial damage NTSB LAX72AL040Accident · 2 fatalClosedPiper PA-28 · Caliente, CANov 30, 1971 · N8899W · Destroyed NTSB LAX72AL036Accident · 1 fatalClosedPiper PA-28 · Lebec, CANov 30, 1971 · N5929U · Destroyed NTSB LAX72FUA28Accident · No injuriesClosedCessna 177 · Long Beach, CANov 27, 1971 · N29343 · Substantial damage NTSB OAK72DVD30Accident · No injuriesClosedCessna 337 · Hayward, CANov 26, 1971 · N6214F · Destroyed NTSB LAX72FUG36Accident · Minor injuriesClosedN.American P-51D · Chino, CANov 26, 1971 · N3333E · 2 aircraft · Substantial damage NTSB LAX72AL039Accident · 1 fatalClosedCessna 182A · Big Bear, CANov 24, 1971 · N3715D · Destroyed NTSB LAX72FUG35Accident · Minor injuriesClosedCessna 205 · El Mirage, CANov 23, 1971 · N8460Z · Substantial damage NTSB ANC72AA026Accident · 4 fatalClosedCessna 175 · Willits, CANov 23, 1971 · N7055M · Destroyed NTSB OAK72FVA35Accident · Serious injuriesClosedHargis JT · Madera, CANov 22, 1971 · N3804 · Substantial damage NTSB LAX72FUG37Accident · No injuriesClosedCessna 150 · El Monte, CANov 22, 1971 · N4035J · Substantial damage NTSB OAK72DVA47Accident · No injuriesClosedErco 415-C · Merced, CANov 20, 1971 · N2601H · Substantial damage NTSB LAX72FUA24Accident · No injuriesClosedCessna 150H · Hntngtn Bch, CANov 20, 1971 · N50441 · Substantial damage NTSB LAX72AL037Accident · 1 fatalClosedGlobe GC-1B · Palos Vrdes, CANov 20, 1971 · N250B · Destroyed NTSB OAK72AP016Accident · 2 fatalClosedPiper PA-22 · Bodega Bay, CANov 18, 1971 · N2503P · Destroyed NTSB LAX72FUG34Accident · No injuriesClosedCessna 182 · Chriaco Smt, CANov 17, 1971 · N92380 · Substantial damage NTSB OAK72DVM15Accident · No injuriesClosedLuscombe 8A · Palo Alto, CANov 16, 1971 · N1439K · Substantial damage NTSB LAX72DUQ45Accident · No injuriesClosedPiper PA-22 · Lancaster, CANov 16, 1971 · N2241A · Substantial damage NTSB LAX72AL034Accident · 4 fatalClosedPiper PA-28 · Bonita, CANov 16, 1971 · N5721U · 2 aircraft · Destroyed NTSB OAK72DVM14Accident · No injuriesClosedBeech C35 · Palo Alto, CANov 15, 1971 · N5836C · Substantial damage NTSB OAKM2FVD28Accident · No injuriesClosedBeech 99 · Oakland, CANov 14, 1971 · N931GP · Substantial damage NTSB OAK72FVA34Accident · No injuriesClosedCessna 210J · Columbia, CANov 14, 1971 · N350TM · Substantial damage NTSB LAX72FUQ41Accident · No injuriesClosedHawker Fury Mark 2 · Mojave, CANov 13, 1971 · N878M · Destroyed