Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 OAK74AP027Accident · 4 fatalClosedNavion A · Firebaugh, CADec 31, 1973 · N4582K · Destroyed NTSB LAX74AL047Accident · 5 fatalClosedCessna 210-5 · Hesperia, CADec 28, 1973 · N8263Z · Destroyed NTSB OAK74AP025Accident · 3 fatalClosedBeech C35 · Kings Ldg, CADec 26, 1973 · N68626 · Destroyed NTSB OAK74DVM15Accident · Minor injuriesClosedCessna 150G · San Jose, CADec 24, 1973 · N2249J · Substantial damage NTSB LAX74FUQ25Accident · No injuriesClosedLuscombe 8A · Pacoima, CADec 24, 1973 · N71464 · Substantial damage NTSB OAK74AP024Accident · 3 fatalClosedCessna 150C · Stockton, CADec 23, 1973 · N7925Z · Destroyed NTSB LAX74DUG33Accident · No injuriesClosedStinson 108-3 · Apple Vally, CADec 23, 1973 · N6206M · Substantial damage NTSB LAX74IL046Incident · No injuriesClosedCessna 310P · Riverside, CADec 22, 1973 · N3175K · Minor damage NTSB LAX74FUQ24Accident · Serious injuriesClosedLaister LP-49 · Santa Brbra, CADec 22, 1973 · N275LP · Destroyed NTSB OAK74AP026Accident · 3 fatalClosedCessna 172I · Callahan, CADec 21, 1973 · N35578 · Destroyed NTSB LAX74AL045Accident · 2 fatalClosedCessna A150L · Lucerne Vly, CADec 20, 1973 · N6043J · Destroyed NTSB LAX74AL044Accident · 2 fatalClosedPiper PA-28 · Corona, CADec 20, 1973 · N5382W · Substantial damage NTSB OAK74AP023Accident · 2 fatalClosedPiper PA-22 · Concord, CADec 19, 1973 · N8245C · Destroyed NTSB OAK74DXQ18Accident · No injuriesClosedCessna 150 · Chester, CADec 18, 1973 · N51135 · Substantial damage NTSB OAK74DVG28Accident · No injuriesClosedBoeing A75N1 · Woodland, CADec 18, 1973 · N56225 · Substantial damage NTSB OAK74DVD18Accident · No injuriesClosedCessna 172 · Novato, CADec 18, 1973 · N19886 · Substantial damage NTSB LAX74FUM15Accident · No injuriesClosedCessna 310D · San Diego, CADec 18, 1973 · N488SS · Substantial damage NTSB OAK74DVA38Accident · No injuriesClosedBoeing A75N1 · Hanford, CADec 17, 1973 · N4768V · Substantial damage NTSB LAX74FUA14Accident · No injuriesClosedCessna 182 · Torrance, CADec 17, 1973 · N2415Q · Substantial damage NTSB OAK74DXQ17Accident · Minor injuriesClosedPiper PA-28R · Lake Tahoe, CADec 16, 1973 · N5146S · Substantial damage NTSB LAX74FUA15Accident · No injuriesClosedBeech E55 · Fullerton, CADec 13, 1973 · N305T · Substantial damage NTSB LAX74DUM14Accident · Serious injuriesClosedSchweizer SGU222 · San Diego, CADec 11, 1973 · N2718Z · Substantial damage NTSB LAX74DUG34Accident · No injuriesClosedBeech A35 · Boron, CADec 10, 1973 · N597B · Substantial damage NTSB OAK74DVD19Accident · Minor injuriesClosedBeech A35 · Stockton, CADec 9, 1973 · N8630A · Substantial damage NTSB OAK74FVG20Accident · 1 fatalClosedSemco T · Chico, CADec 8, 1973 · N9975 · Substantial damage NTSB OAK74DVM16Accident · No injuriesClosedBeech 35 · Moss Beach, CADec 8, 1973 · N11E · Substantial damage NTSB LAX74DUG28Accident · No injuriesClosedSchweizer SGS126 · Llano, CADec 8, 1973 · N7582 · Substantial damage NTSB LAX74AUQ22Accident · No injuriesClosedPiper PA-28 · Valencia, CADec 8, 1973 · N6852W · Substantial damage NTSB OAK74DVA37Accident · No injuriesClosedPiper PA-25 · Merced, CADec 5, 1973 · N4769Y · Substantial damage NTSB OAK74AP022Accident · 2 fatalClosedCessna 120 · Columbia, CADec 5, 1973 · N1719N · Destroyed NTSB OAK74DVM14Accident · No injuriesClosedRyan PT-22 · Morgan Hill, CADec 2, 1973 · N22JK · No damage NTSB OAK74AP021Accident · 2 fatalClosedBeech H35 · Georgetown, CADec 2, 1973 · N5581D · Destroyed NTSB LAX74DUG31Accident · No injuriesClosedBell 47G-5 · La Verne, CANov 30, 1973 · N4741R · Substantial damage NTSB LAX74AL043Accident · 3 fatalClosedBeech 23 · Gorman, CANov 30, 1973 · N2360Z · Destroyed NTSB OAK74DVA36Accident · No injuriesClosedCessna 150L · Modesto, CANov 29, 1973 · N18160 · Destroyed NTSB LAX74DVA35Accident · Minor injuriesClosedCessna 182 · Kernville, CANov 27, 1973 · N3485F · Substantial damage NTSB LAX74AL042Accident · 3 fatalClosedCessna 310C · San Diego, CANov 27, 1973 · N1732H · 2 aircraft · Destroyed NTSB LAX74FUG30Accident · No injuriesClosedSchmidt JR II · Chino, CANov 25, 1973 · N17RS · Destroyed NTSB LAX74DUG26Accident · No injuriesClosedCessna TU206C · Perris, CANov 25, 1973 · N3958G · 2 aircraft · Substantial damage NTSB LAX74AL041Accident · 3 fatalClosedMooney M-20 · Fillmore, CANov 24, 1973 · N5259B · Destroyed NTSB OAK74DXQ15Accident · No injuriesClosedCessna 120 · Emigrnt Gap, CANov 23, 1973 · N77212 · Substantial damage NTSB LAX74FUG27Accident · No injuriesClosedCessna 150 · Rialto, CANov 23, 1973 · N2978J · Substantial damage NTSB LAX74DUG25Accident · No injuriesClosedWhigham GW-4 · Elsinore, CANov 23, 1973 · N3705 · Substantial damage NTSB LAX74FUM13Accident · Minor injuriesClosedRyan ST-3KR · Ramona, CANov 22, 1973 · N46705 · Substantial damage NTSB LAX74FUA13Accident · No injuriesClosedBeech B35 · Long Beach, CANov 22, 1973 · N3019V · Substantial damage NTSB LAX74FUQ20Accident · No injuriesClosedBeech A35 · Burbank, CANov 21, 1973 · N5058C · Substantial damage NTSB LAX74FUM12Accident · No injuriesClosedHiller Acft UH-12E · Brawley, CANov 19, 1973 · N9770C · Substantial damage NTSB OAK74FVA34Accident · Minor injuriesClosedBellanca 17-30 · Los Banos, CANov 18, 1973 · N4936V · Substantial damage NTSB OAK73IP020Incident · No injuriesClosedSikorsky S-61N · Oakland, CANov 17, 1973 · N4606G · Minor damage NTSB LAX74AL037Accident · 1 fatalClosedPiper PA-24 · San Dimas, CANov 17, 1973 · N5531P · Destroyed