Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 OAK67F0239Accident · No injuriesClosedPiper PA-28 · Carmel Valley, CADec 31, 1966 · N6022W · Substantial damage NTSB LAX67F0225Accident · No injuriesClosedPiper PA-24 · Hawthorne, CADec 31, 1966 · N8550P · Substantial damage NTSB OAK67F0202Accident · No injuriesClosedPiper PA-24 · Sacramento, CADec 29, 1966 · N6627P · Substantial damage NTSB OAK67D0180Accident · No injuriesClosedCessna 150 · Vallejo, CADec 29, 1966 · N4781X · Substantial damage NTSB OAK67A0055Accident · 2 fatalClosedCessna 140 · Garberville, CADec 29, 1966 · N89981 · Destroyed NTSB OAK67A0054Accident · No injuriesClosedHughes 269A · Hayward, CADec 29, 1966 · N8832F · Substantial damage NTSB OAK67F0216Accident · Serious injuriesClosedBoeing B75N1 · Paso Robles, CADec 28, 1966 · N67343 · Destroyed NTSB OAK67F0211Accident · No injuriesClosedBeech J35 · Oceano, CADec 28, 1966 · N8259D · Substantial damage NTSB LAX67D0256Accident · No injuriesClosedCessna 150G · Essex, CADec 27, 1966 · N3861J · Substantial damage NTSB LAX67D0237Accident · No injuriesClosedSchweizer I-26 · Torrey Pine, CADec 26, 1966 · N8608R · Destroyed NTSB LAX67D0236Accident · No injuriesClosedPiper PA-32 · El Centro, CADec 26, 1966 · N3575W · Substantial damage NTSB OAK67D0186Accident · No injuriesClosedCessna 210 · Adin, CADec 23, 1966 · N7328E · Substantial damage NTSB OAK67D0184Accident · No injuriesClosedStinson 108 · Columbia, CADec 23, 1966 · N97358 · Substantial damage NTSB LAX67F0250Accident · No injuriesClosedFairchild 24 · Pacoima, CADec 23, 1966 · N77618 · Substantial damage NTSB LAX67F0242Accident · No injuriesClosedMooney M20E · Torrance, CADec 23, 1966 · N2651W · Substantial damage NTSB LAX67D0232Accident · No injuriesClosedBeech B35 · Hawthorne, CADec 23, 1966 · N5008C · Substantial damage NTSB LAX67A0061Accident · 1 fatalClosedBeech 23 · Chatsworth, CADec 23, 1966 · N3556R · 2 aircraft · Substantial damage NTSB OAK67F0209Accident · No injuriesClosedCessna 172 · Bishop, CADec 22, 1966 · N3579S · Destroyed NTSB LAX67F0258Accident · Minor injuriesClosedFairchild 24H · Burbank, CADec 20, 1966 · N19126 · Substantial damage NTSB OAK67A0053Accident · Minor injuriesClosedPiper PA-32 · Cloverdale, CADec 19, 1966 · N3675W · Substantial damage NTSB LAX67A0060Accident · 1 fatalClosedGlobe GC-1B · Moorpark, CADec 18, 1966 · N3818K · Substantial damage NTSB LAX67D0245Accident · No injuriesClosedCessna 182 · Hesperia, CADec 16, 1966 · N2822F · Substantial damage NTSB OAK67D0179Accident · Minor injuriesClosedAeronca 11AC · Hilt, CADec 15, 1966 · N3509E · Substantial damage NTSB LAX67D0248Accident · No injuriesClosedCessna 172 · Shafter, CADec 15, 1966 · N6228E · Substantial damage NTSB OAK67F0203Accident · No injuriesClosedCessna 175 · Fair Oaks, CADec 14, 1966 · N8170T · Substantial damage NTSB LAX67F0231Accident · No injuriesClosedBeech 95-A55 · Compton, CADec 13, 1966 · N821B · Substantial damage NTSB LAX67D0249Accident · No injuriesClosedHelio H-250 · New Cuyama, CADec 13, 1966 · N5444E · Substantial damage NTSB LAX67D0219Accident · No injuriesClosedBeech A23 · Santa Susan, CADec 13, 1966 · N5667S · Substantial damage NTSB OAK67F0198Accident · Serious injuriesClosedTaylorcraft BC12-D · Fair Oaks, CADec 11, 1966 · N43515 · Substantial damage NTSB LAX67F0228Accident · No injuriesClosedBeech A35 · San Diego, CADec 10, 1966 · N482B · Substantial damage NTSB LAX67D0257Accident · No injuriesClosedGlobe GC-1B · Riverside, CADec 10, 1966 · N80664 · Substantial damage NTSB OAK67F0189Accident · Serious injuriesClosedCessna 150 · Antioch, CADec 9, 1966 · N1218Y · Destroyed NTSB LAX67A0057Accident · 1 fatalClosedPiper J-3C · Carlsbad, CADec 8, 1966 · N92032 · Substantial damage NTSB OAK67D0187Accident · Minor injuriesClosedCessna 150 · Sunnyvale, CADec 7, 1966 · N5937T · Substantial damage NTSB OAK67A0051Accident · No injuriesClosedContinental MII · Madera, CADec 7, 1966 · N6355X · Substantial damage NTSB LAX67F0234Accident · No injuriesClosedBeech B35 · Long Beach, CADec 7, 1966 · N399R · Substantial damage NTSB LAX67F0230Accident · No injuriesClosedN.American SNJ-6 · Shafter, CADec 7, 1966 · N611F · Substantial damage NTSB LAX67D0221Accident · No injuriesClosedCessna 172 · Mojave, CADec 7, 1966 · N8848U · Substantial damage NTSB OAK67F0230Accident · Serious injuriesClosedPiper PA-28 · Vacaville, CADec 4, 1966 · N7854W · Destroyed NTSB OAK67D0174Accident · No injuriesClosedPiper PA-28 · Red Top, CADec 3, 1966 · N6345W · Substantial damage NTSB LAX67I0056IncidentClosedBoeing 720B · Los Angeles, CADec 2, 1966 · N57205 · Substantial damage NTSB LAX67F0251Accident · Serious injuriesClosedCessna 210E · Blythe, CADec 2, 1966 · N2348F · Destroyed NTSB OAK67D0178Accident · Minor injuriesClosedPiper PA-28 · Snelling, CADec 1, 1966 · N6330W · Substantial damage NTSB LAX67A0054Accident · 1 fatalClosedCessna 150 · Santee, CANov 30, 1966 · N6955F · Destroyed NTSB LAX67F0224Accident · No injuriesClosedBeech G35 · Van Nuys, CANov 27, 1966 · N4502D · Substantial damage NTSB LAX67D0201Accident · No injuriesClosedErcoupe 415C · Chino, CANov 27, 1966 · N99257 · Substantial damage NTSB OAK67A0049Accident · No injuriesClosedBoeing 707 · Oakland, CANov 26, 1966 · N7521A · Substantial damage NTSB LAX67F0212Accident · No injuriesClosedPiper PA-22 · San Diego, CANov 26, 1966 · N1720P · Substantial damage NTSB OAK67F0196Accident · No injuriesClosedPiaggio 136-L2 · Oakland, CANov 25, 1966 · N40034 · Substantial damage NTSB OAK67D0172Accident · No injuriesClosedPiper PA-28 · Turlock, CANov 25, 1966 · N8403W · Substantial damage