NTSB investigations, 1974, CA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.

Cases per year

19622026
NTSB investigations, 1974, CA per year, 1962–2026: 19,368 cases
196210
196311
1964659
1965654
1966755
1967799
1968668
1969613
1970617
1971605
1972510
1973499
1974523
1975488
1976484
1977497
1978548
1979473
1980472
1981403
1982391
1983441
1984388
1985329
1986316
1987315
1988322
1989289
1990318
1991291
1992277
1993260
1994242
1995237
1996223
1997182
1998212
1999186
2000222
2001183
2002176
2003182
2004171
2005191
2006187
2007207
2008158
2009187
2010158
2011141
2012134
2013128
2014117
2015118
2016119
2017162
2018119
2019114
2020105
202194
2022111
2023103
2024101
202591
202682

Latest cases

Query with SQL
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\") = 1974
    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.

NTSB OAK75DVA38Accident · No injuriesClosedHiller Acft UH-12C · Kettlmn Cty, CADec 31, 1974 · N4785C · DestroyedNTSB LAX75FUA19Accident · No injuriesClosedCessna 172K · Avalon, CADec 31, 1974 · N84754 · Substantial damageNTSB OAK75AP030Accident · 2 fatalClosedCessna 172L · 3 Rivers, CADec 30, 1974 · N7840G · DestroyedNTSB LAX75FUD03Accident · No injuriesClosedCessna 172M · Snta Monica, CADec 30, 1974 · N13723 · Substantial damageNTSB LAX75FUA20Accident · Minor injuriesClosedCessna 182G · Buena Park, CADec 30, 1974 · C-GWBF · Substantial damageNTSB OAK75FVM18Accident · No injuriesClosedGlobe GC-1B · Palo Alto, CADec 29, 1974 · N78200 · Substantial damageNTSB OAK75DVD30Accident · No injuriesClosedCulver V · Sonoma, CADec 29, 1974 · N6545C · Substantial damageNTSB OAK75AP028Accident · 1 fatalClosedAmer Avco AA1-A · Newark, CADec 29, 1974 · N9443L · DestroyedNTSB LAX75DVA40Accident · No injuriesClosedBeech B35 · Bakersfield, CADec 29, 1974 · N5234C · Substantial damageNTSB LAX75DUG25Accident · Minor injuriesClosedPiper PA-20 · Rubidoux, CADec 29, 1974 · N7382K · Substantial damageNTSB OAK75AP027Accident · 6 fatalClosedPiper PA-32 · Hlf Moon By, CADec 27, 1974 · N7705J · DestroyedNTSB LAX75FUG24Accident · Serious injuriesClosedAeronca 7BCM · Elsinore, CADec 27, 1974 · N82757 · DestroyedNTSB OAK75DVD28Accident · Minor injuriesClosedCessna 182 · Santa Rosa, CADec 26, 1974 · N182CT · Substantial damageNTSB OAK75FVG42Accident · No injuriesClosedCessna 150 · Chico, CADec 25, 1974 · N3315J · DestroyedNTSB OAK75DXQ32Accident · No injuriesClosedCessna 172 · Truckee, CADec 22, 1974 · N1460V · Substantial damageNTSB OAK75AP026Accident · 8 fatalClosedCessna 414 · Chester, CADec 22, 1974 · N414ZM · DestroyedNTSB OAK75DXQ31Accident · Minor injuriesClosedCessna 182 · Mammoth Lks, CADec 21, 1974 · N3408U · Substantial damageNTSB OAK75AP025Accident · 1 fatalClosedBell 47G3B1 · Auburn, CADec 21, 1974 · N409RG · DestroyedNTSB LAX75FUQ19Accident · Serious injuriesClosedPiper PA-28 · Van Nuys, CADec 18, 1974 · N9520W · DestroyedNTSB OAK75DVD25Accident · No injuriesClosedCessna 150 · Danville, CADec 16, 1974 · N50596 · Substantial damageNTSB OAK75FVM17Accident · No injuriesClosedCessna 172D · San Carlos, CADec 15, 1974 · N79893 · Substantial damageNTSB OAK75DVD26Accident · No injuriesClosedFairchild PT-26B · Livermore, CADec 14, 1974 · N249FZ · DestroyedNTSB OAK75FVA36Accident · No injuriesClosedPiper PA-31P · Fresno, CADec 9, 1974 · N111JK · Substantial damageNTSB OAK75DVG41Accident · No injuriesClosedBeech 35 · Gridley, CADec 8, 1974 · N2996V · Substantial damageNTSB OAK75DVG40Accident · No injuriesClosedCessna 172 · Orland, CADec 8, 1974 · N5722A · Substantial damageNTSB OAK75AP031Accident · 2 fatalClosedAmer Avco AA1-B · Vacaville, CADec 8, 1974 · N8999L · DestroyedNTSB OAK75FVM15Accident · No injuriesClosedCessna 150 · Woodside, CADec 7, 1974 · N6048J · Substantial damageNTSB LAX75DUG27Accident · No injuriesClosedCessna 150 · Colton, CADec 7, 1974 · N2623J · Substantial damageNTSB LAX75FUG21Accident · No injuriesClosedCessna 150F · Ontario, CADec 5, 1974 · N3524L · Substantial damageNTSB OAK75DVD36Accident · No injuriesClosedCessna 172M · Stockton, CADec 4, 1974 · N20666 · Substantial damageNTSB LAX75AL031Accident · 4 fatalClosedCessna 172 · S.Luis Obsp, CADec 3, 1974 · N20184 · 2 aircraft · DestroyedNTSB OAK75AP021Accident · 3 fatalClosedBeech H35 · Hayward, CADec 1, 1974 · N5419D · DestroyedNTSB OAK75AP020Accident · 1 fatalClosedCessna 170B · Santa Cruz, CADec 1, 1974 · N3237A · DestroyedNTSB LAX75D4G23Accident · No injuriesClosedStinson 108-1 · Rubidoux, CADec 1, 1974 · N8358K · Substantial damageNTSB OAK75DVG39Accident · No injuriesClosedCessna 150 · Alleghany, CANov 30, 1974 · N17215 · Substantial damageNTSB OAK75DVG38Accident · No injuriesClosedChampion 7AC · Manton, CANov 30, 1974 · N4995 · Substantial damageNTSB LAX75FVM14Accident · Minor injuriesClosedCessna 177 · Paso Robles, CANov 30, 1974 · N30349 · Substantial damageNTSB LAX75FUQ18Accident · No injuriesClosedBeech B19 · Lancaster, CANov 30, 1974 · N1984W · Substantial damageNTSB OAK75DVG37Accident · No injuriesClosedCessna 150 · Pope Valley, CANov 29, 1974 · N8956S · Substantial damageNTSB LAX75FUA16Accident · No injuriesClosedStarduster TOO · Long Beach, CANov 29, 1974 · N2MW · Substantial damageNTSB LAX75FNG20Accident · No injuriesClosedCessna 150F · La Verne, CANov 25, 1974 · N8099S · Substantial damageNTSB LAX75DUM11Accident · Minor injuriesClosedPiper PA-18 · Imperial, CANov 25, 1974 · N4711A · Substantial damageNTSB OAK75DVG36Accident · No injuriesClosedCessna 150 · Yuba City, CANov 24, 1974 · N66548 · Substantial damageNTSB LAX75DUM12Accident · Minor injuriesClosedMooney M20A · Oceanside, CANov 22, 1974 · N8198D · Substantial damageNTSB LAX75AL028Accident · 3 fatalClosedBeech D18S · Tustin, CANov 22, 1974 · N2085D · DestroyedNTSB LAX75DUG22Accident · No injuriesClosedBell 47G3B1 · Joshua Tree, CANov 21, 1974 · N3084G · Substantial damageNTSB LAX75AL029Accident · 1 fatalClosedBeech B19 · Tehachapi, CANov 21, 1974 · N9743Q · DestroyedNTSB LAX75DVA34Accident · No injuriesClosedAero Comdr 680E · Bakersfield, CANov 19, 1974 · N6000S · Substantial damageNTSB LAX75DUM10Accident · No injuriesClosedCessna 150 · Banner, CANov 19, 1974 · N10568 · Substantial damageNTSB OAK75FVA35Accident · No injuriesClosedAlouette SA315B · Bear Valley, CANov 18, 1974 · N62886 · Substantial damage