Skip to content

NTSB investigations, 1972, CA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 OAK73DVG39Accident · No injuriesClosedCessna 172H · Nut Tree, CADec 31, 1972 · N1641F · Destroyed NTSB LAX73FUM13Accident · No injuriesClosedBeech A35 · El Cajon, CADec 31, 1972 · N506B · Substantial damage NTSB OAK73DVG38Accident · No injuriesClosedPiper PA-28 · Grass Vally, CADec 30, 1972 · N6351J · Substantial damage NTSB OAK73DVD23Accident · No injuriesClosedChampion 7ECA · Sonoma, CADec 30, 1972 · N7512F · Substantial damage NTSB OAK73DVA36Accident · No injuriesClosedAeronca 7AC · Auberry, CADec 30, 1972 · N2566E · Substantial damage NTSB OAK73DVG36Accident · No injuriesClosedCessna 170B · Sacramento, CADec 28, 1972 · N2466D · Substantial damage NTSB OAK73FVG35Accident · No injuriesClosedCessna 210C · Davis, CADec 25, 1972 · N3682Y · Destroyed NTSB OAK73DVW12Accident · No injuriesClosedBell 47G3B1 · Bishop, CADec 25, 1972 · N73212 · Substantial damage NTSB LAX73DUQ19Accident · No injuriesClosedPiper PA-28 · Santa Paula, CADec 25, 1972 · N5898U · Substantial damage NTSB OAK73FVD22Accident · No injuriesClosedCessna U206 · Oakland, CADec 24, 1972 · N3867G · Destroyed NTSB OAK73AP018Accident · 1 fatalClosedBeech C35 · Middletown, CADec 23, 1972 · N5937C · Destroyed NTSB OAK73AP017Accident · 2 fatalClosedCessna 310 · Dublin, CADec 21, 1972 · N159R · Destroyed NTSB OAK73DVM20Accident · No injuriesClosedJungster II RK-2 · Soledad, CADec 18, 1972 · N4086K · Substantial damage NTSB LAX73DUM16Accident · No injuriesClosedCessna 177 · Imperial, CADec 18, 1972 · N3478T · Substantial damage NTSB LAX73DVA34Accident · No injuriesClosedCessna 150 · Taft, CADec 17, 1972 · N7729E · Substantial damage NTSB LAX73AL027Accident · 1 fatalClosedAmer Avco AA-1A · Pacoima, CADec 16, 1972 · N9358L · Destroyed NTSB OAK73DVM21Accident · No injuriesClosedBell 47G-2 · Salinas, CADec 15, 1972 · N6727D · Substantial damage NTSB LAX73DVA33Accident · Minor injuriesClosedCessna 150J · Bakersfield, CADec 14, 1972 · N61337 · Substantial damage NTSB OAK73IP016Incident · No injuriesClosedCessna 320A · Redding, CADec 12, 1972 · N3044R · Minor damage NTSB LAX73FUD06Accident · No injuriesClosedPiper PA-28 · Compton, CADec 11, 1972 · N7238J · Substantial damage NTSB OAK73FVG34Accident · No injuriesClosedAmer Avco AA-1A · Lincoln, CADec 10, 1972 · N9304L · Substantial damage NTSB OAK73DVD21Accident · No injuriesClosedCessna 172 · Livermore, CADec 10, 1972 · N5363T · Substantial damage NTSB LAX73FUA26Accident · No injuriesClosedBell 47D1 · Fountn Vlly, CADec 9, 1972 · N9637Z · Substantial damage NTSB OAK73FVA32Accident · Serious injuriesClosedAmer Avco AA1 · Chowchilla, CADec 5, 1972 · N7265L · Substantial damage NTSB LAX73AL025Accident · 1 fatalClosedStinson 108 · Ukiah, CADec 5, 1972 · N97366 · Destroyed NTSB OAK73FVA31Accident · Minor injuriesClosedNavion L-17A · Atwater, CADec 3, 1972 · N5419V · Destroyed NTSB LAX73DVA30Accident · No injuriesClosedBell 47G-2 · Richgrove, CANov 30, 1972 · N10194 · Substantial damage NTSB OAK73DVG33Accident · No injuriesClosedCessna 150 · Davis, CANov 29, 1972 · N3476J · Substantial damage NTSB OAK73FVG32Accident · Serious injuriesClosedBellanca 17-30 · Auburn, CANov 26, 1972 · N4717V · Destroyed NTSB OAK73AP013Accident · 1 fatalClosedCessna 150D · Auburn, CANov 26, 1972 · N4107U · Destroyed NTSB OAK73AP012Accident · 2 fatalClosedCessna A150L · Yorkville, CANov 25, 1972 · N5949J · Destroyed NTSB LAX73DUM11Accident · No injuriesClosedCessna 180 · Calexico, CANov 25, 1972 · N1626C · Substantial damage NTSB LAX73DUM10Accident · No injuriesClosedCessna 140 · Borrego Sgs, CANov 25, 1972 · N3113N · Substantial damage NTSB LAX73FUQ17Accident · Minor injuriesClosedPiper PA-28 · Goleta, CANov 24, 1972 · N403FL · Destroyed NTSB LAX73FUG26Accident · No injuriesClosedCessna 206 · El Monte, CANov 24, 1972 · N8756Z · Substantial damage NTSB LAX73FUM12Accident · Minor injuriesClosedMooney M20E · Calexico, CANov 22, 1972 · N3363X · Substantial damage NTSB LAX73FUA24Accident · No injuriesClosedCessna 170B · Santa Ana, CANov 18, 1972 · N3534C · Substantial damage NTSB LAX73FUA23Accident · No injuriesClosedCessna 150 · Santa Ana, CANov 18, 1972 · N22025 · Substantial damage NTSB LAX73FUG25Accident · No injuriesClosedLuscombe 8A · Chino, CANov 17, 1972 · N28545 · Substantial damage NTSB LAX73DVM19Accident · Serious injuriesClosedCessna 150 · Oceano, CANov 17, 1972 · N1527Q · Substantial damage NTSB LAX75AL053Accident · 1 fatalClosedBeech 35 · Tehachapi, CANov 16, 1972 · N4515V · Destroyed NTSB OAK73AP010Accident · 2 fatalClosedPiper PA-22 · Winters, CANov 15, 1972 · N2857P · Destroyed NTSB LAX73ALO24Accident · 1 fatalClosedPiper PA-18 · Gorman, CANov 12, 1972 · N8352P · Destroyed NTSB OAK73DVG30Accident · No injuriesClosedCessna 210 · Calistoga, CANov 11, 1972 · N7371E · Substantial damage NTSB LAX73FUG22Accident · Serious injuriesClosedCessna 182 · Rialto, CANov 11, 1972 · N9127G · Substantial damage NTSB LAX73FUA25Accident · No injuriesClosedCessna 150G · Santa Ana, CANov 10, 1972 · N3225J · Substantial damage NTSB LAX73DUG23Accident · Serious injuriesClosedSchweizer 2-22 · Hemet, CANov 10, 1972 · N2410W · Substantial damage NTSB OAK73DVM17Accident · No injuriesClosedCessna 140 · Lahonda, CANov 9, 1972 · N725X · Substantial damage NTSB OAK73DVG29Accident · No injuriesClosedBeech 35 · San Andreas, CANov 8, 1972 · N3388V · Substantial damage NTSB LAX73FUM08Accident · Minor injuriesClosedCessna 170B · Niland, CANov 8, 1972 · N1628D · Substantial damage