Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 LAX80DVG12Accident · Minor injuriesClosedAir Tractor AT-301 · Woodland, CADec 28, 1979 · N87695 · Substantial damage NTSB LAX80DVG11Accident · No injuriesClosedCessna 172RG · Grass Valley, CADec 27, 1979 · N5552R · Substantial damage NTSB LAX80FUA06Accident · No injuriesClosedPiper PA-22 · Dana Point, CADec 25, 1979 · N3328Z · Substantial damage NTSB LAX80FVM11Accident · No injuriesClosedCessna 172 · Salinas, CADec 23, 1979 · N73138 · Substantial damage NTSB LAX80FVM10Accident · No injuriesClosedBeech 65-90 · Monterey, CADec 23, 1979 · N700S · Substantial damage NTSB LAX80FVD07Accident · Minor injuriesClosedBeech B24R · Cloverdale, CADec 23, 1979 · N6991R · Destroyed NTSB LAX80DUG14Accident · Serious injuriesClosedCessna 182 · Needles, CADec 23, 1979 · N52315 · Substantial damage NTSB LAX80FA031Accident · 2 fatalClosedBellanca 8KCAB · San Fernando, CADec 22, 1979 · N5032K · Substantial damage NTSB LAX80FA027Accident · 5 fatalClosedCessna 172M · Lebec, CADec 21, 1979 · N6714H · Destroyed NTSB LAX80FUG15Accident · Serious injuriesClosedBell 47G3B1 · Yucaipa, CADec 19, 1979 · N7923S · Destroyed NTSB LAX80FVA08Accident · No injuriesClosedBeech 60 · Fresno, CADec 18, 1979 · N1873S · Substantial damage NTSB LAX80DUG12Accident · No injuriesClosedBeech E18S · Laverne, CADec 16, 1979 · N471CM · Substantial damage NTSB LAX80FVM09Accident · No injuriesClosedPiper J-3C · New Cuyana, CADec 15, 1979 · N71066 · Substantial damage NTSB LAX80FA025Accident · 1 fatalClosedMooney M20J · Palo Alto, CADec 15, 1979 · N201UN · Destroyed NTSB LAX80DVD06Accident · No injuriesClosedCessna 210 · Santa Rosa, CADec 15, 1979 · N6866R · Substantial damage NTSB LAX80DVA07Accident · No injuriesClosedGrumman G-164A · Lemoore, CADec 15, 1979 · N4728 · Substantial damage NTSB LAX80DVD05Accident · No injuriesClosedCessna 152 · Santa Rosa, CADec 14, 1979 · N5085B · Substantial damage NTSB LAX80FUD03Accident · No injuriesClosedCessna 441 · Los Angeles, CADec 12, 1979 · N26226 · Substantial damage NTSB LAX80DVA06Accident · No injuriesClosedEnstrom F-28A · Woodlake, CADec 12, 1979 · N521H · Substantial damage NTSB LAX80FUA05Accident · Serious injuriesClosedPiper PA-28 · Avalon, CADec 10, 1979 · N8432C · Destroyed NTSB LAX80DVG09Accident · No injuriesClosedCessna 172 · Sacramento, CADec 10, 1979 · N8173L · Substantial damage NTSB LAX80FVM13Accident · No injuriesClosedPiper PA-38 · Sn Luis Obspo, CADec 9, 1979 · N2456L · Substantial damage NTSB LAX80FA024Accident · 1 fatalClosedAerostar 601P · Bishop, CADec 9, 1979 · N600WW · Destroyed NTSB LAX80FA023Accident · 3 fatalClosedCessna 172M · Huntington Bch, CADec 9, 1979 · N20647 · Destroyed NTSB LAX80DVG10Accident · No injuriesClosedLuscombe 8A · Fort Bidwell, CADec 8, 1979 · N1186K · Substantial damage NTSB LAX80FUG11Accident · Serious injuriesClosedCessna 172N · La Verne, CADec 7, 1979 · N739JX · Minor damage NTSB LAX80FUA04Accident · Minor injuriesClosedCessna 175 · Huntington Bch, CADec 7, 1979 · N7355M · Substantial damage NTSB LAX80FVM08Accident · No injuriesClosedBeech H35 · San Jose, CADec 5, 1979 · N391B · Substantial damage NTSB LAX80FUQ06Accident · Minor injuriesClosedCessna 182 · Piru, CADec 5, 1979 · N7271N · Destroyed NTSB LAX80FUQ05Accident · Minor injuriesClosedCessna 182 · Valencia, CADec 5, 1979 · N92063 · Substantial damage NTSB LAX80FUG09Accident · Serious injuriesClosedBellanca 17-30 · Ontario, CADec 1, 1979 · N7318V · Substantial damage NTSB LAX80DVG08Accident · No injuriesClosedPiper PA-18 · Colusa, CADec 1, 1979 · N2663A · Substantial damage NTSB LAX80DUG10Accident · No injuriesClosedPiper J-2 · El Monte, CADec 1, 1979 · N17579 · Substantial damage NTSB LAX80DVD04Accident · No injuriesClosedCessna 188 · Courtland, CANov 29, 1979 · N4722Q · Substantial damage NTSB LAX80DVA05Accident · No injuriesClosedPiper PA-25 · Porterville, CANov 28, 1979 · N9640P · Substantial damage NTSB LAX80DUG08Accident · No injuriesClosedLuscombe 8A · Barstow, CANov 26, 1979 · N1095K · Substantial damage NTSB LAX80FVD0OAccident · No injuriesClosedBellanca 7GCBC · Fremont, CANov 25, 1979 · N5518K · Substantial damage NTSB LAX80FA018Accident · 5 fatalClosedCessna 180H · Weaverville, CANov 25, 1979 · N7984V · Destroyed NTSB LAX80FA020Accident · 3 fatalClosedPiper PA-24 · Alturas, CANov 24, 1979 · N5664P · Destroyed NTSB LAX80FA017Accident · 3 fatalClosedCessna 182R · Napa, CANov 24, 1979 · N2681C · Destroyed NTSB LAX80FA019Accident · 4 fatalClosedCessna 172RG · Lassen Peak, CANov 22, 1979 · N4760R · Destroyed NTSB LAX80DUM07Accident · Serious injuriesClosedAero Comdr 100 · Santee, CANov 22, 1979 · N4084X · Substantial damage NTSB LAX80FA016Accident · 1 fatalClosedPiper PA-28 · Santa Barbara, CANov 20, 1979 · N9042K · Destroyed NTSB LAX80FXQ05Accident · No injuriesClosedCessna 210 · Beckwourth, CANov 19, 1979 · N78MC · Substantial damage NTSB LAX80FA015Accident · No injuriesClosedCessna 152 · Bakersfield, CANov 18, 1979 · N24906 · 2 aircraft · Substantial damage NTSB LAX80DUG13Accident · No injuriesClosedCessna 310J · Banning, CANov 18, 1979 · N3103L · Substantial damage NTSB LAX80FA014Accident · 3 fatalClosedCessna 182Q · Livermore, CANov 16, 1979 · N97430 · Destroyed NTSB LAX80FA013Accident · 2 fatalClosedPiper PA-28 · Livermore, CANov 16, 1979 · N2962C · Destroyed NTSB LAX80DVG07Accident · No injuriesClosedCessna 401 · Colusa, CANov 16, 1979 · N3184K · Substantial damage NTSB LAX80DVG06Accident · Minor injuriesClosedAero Comdr 100 · Napa, CANov 16, 1979 · N3689X · Destroyed