Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 LAX68D0281Accident · Minor injuriesClosedPiper PA-28 · Lancaster, CADec 31, 1967 · N5952W · Substantial damage NTSB LAX68D0255Accident · No injuriesClosedBellanca 14-13 · Compton, CADec 31, 1967 · N74368 · Substantial damage NTSB OAK68F0288Accident · Minor injuriesClosedCessna 170 · Lodi, CADec 30, 1967 · N4422V · Substantial damage NTSB OAK68D0267Accident · Minor injuriesClosedLuscombe 8A · Half Moon Bay, CADec 30, 1967 · N71151 · Substantial damage NTSB OAK68D0262Accident · No injuriesClosedCessna 170A · Morgan Hill, CADec 30, 1967 · N9240A · Substantial damage NTSB OAK68D0258Accident · Minor injuriesClosedPiper PA-28 · Mariposa, CADec 30, 1967 · N8963J · Substantial damage NTSB LAX68D0242Accident · No injuriesClosedCessna 150 · Riverside, CADec 30, 1967 · N8840S · Substantial damage NTSB OAK68D0309Accident · No injuriesClosedCessna 172 · Corning, CADec 29, 1967 · N5421T · Substantial damage NTSB LAX68D0332Accident · Minor injuriesClosedPiper PA-24 · Goleta, CADec 29, 1967 · N7250P · Substantial damage NTSB LAX68D0268Accident · Minor injuriesClosedCessna 150 · Rialto, CADec 29, 1967 · N6414T · Substantial damage NTSB OAK68F0297Accident · Minor injuriesClosedCessna 170B · Petaluma, CADec 28, 1967 · N2590C · Destroyed NTSB LAX68D0276Accident · No injuriesClosedCessna 402 · Ontario, CADec 27, 1967 · N3299Q · Substantial damage NTSB LAX68D0267Accident · No injuriesClosedCessna 182C · Big Bear City, CADec 26, 1967 · N8889T · Substantial damage NTSB LAX68F0260Accident · Serious injuriesClosedCessna 140 · Redlands, CADec 25, 1967 · N72100 · Destroyed NTSB OAK68D0340Accident · Minor injuriesClosedCessna 182 · Fair Oaks, CADec 24, 1967 · N4924D · Substantial damage NTSB OAK68D0261Accident · No injuriesClosedPiper PA-28 · Modesto, CADec 24, 1967 · N9817W · Substantial damage NTSB LAX68A0063Accident · 1 fatalClosedGlendening Stits · Corona, CADec 24, 1967 · N6050C · Destroyed NTSB LAX68F0264Accident · No injuriesClosedBeech E35 · Calipatria, CADec 23, 1967 · N7390B · Substantial damage NTSB LAX68D0269Accident · No injuriesClosedBeech A35 · Oxnard, CADec 23, 1967 · N8595A · Substantial damage NTSB LAX68D0253Incident · No injuriesClosedDehaviland DHC-2 · Llano, CADec 23, 1967 · CF-ROM · Substantial damage NTSB LAX68A0062Accident · Minor injuriesClosedBensen B8M · Rialto, CADec 23, 1967 · N1659 · Substantial damage NTSB OAK68F0260Accident · No injuriesClosedPiper PA-32 · Truckee, CADec 22, 1967 · N1099J · Substantial damage NTSB LAX68D0306Accident · Minor injuriesClosedCessna 150 · Calif.City, CADec 22, 1967 · N3589J · Substantial damage NTSB OAK68D0314Accident · No injuriesClosedPiper PA-22 · Travis Afb, CADec 21, 1967 · N4901Z · Substantial damage NTSB OAK68F0265Accident · No injuriesClosedCessna 310B · Concord, CADec 20, 1967 · N5365A · Substantial damage NTSB LAX68F0256Accident · No injuriesClosedLuscombe 8E · Fullerton, CADec 20, 1967 · N2243B · Substantial damage NTSB OAK68D0306Accident · No injuriesClosedPiper PA-18 · Davis, CADec 17, 1967 · N3374B · Substantial damage NTSB OAK68D0233Accident · No injuriesClosedPiper PA-22 · Crescnt Cty, CADec 17, 1967 · N3959P · Substantial damage NTSB LAX68F0251Accident · Serious injuriesClosedBeech A45 · Corona, CADec 17, 1967 · N6978C · Destroyed NTSB LAX68D0302Accident · No injuriesClosedCessna 150 · Johannesburg, CADec 17, 1967 · N7178F · Substantial damage NTSB LAX68D0246Accident · No injuriesClosedPiper PA-28 · Carlsbad, CADec 17, 1967 · N5738W · Substantial damage NTSB OAK68D0316Accident · No injuriesClosedBeech 35 · Milford, CADec 16, 1967 · N3702N · Substantial damage NTSB LAX68D0262Accident · No injuriesClosedCessna 172A · Baker, CADec 16, 1967 · N7211T · Substantial damage NTSB OAK68A0051Accident · No injuriesClosedHughes 269A · Salinas, CADec 15, 1967 · N8837F · Destroyed NTSB LAX68F0270Accident · No injuriesClosedAero Comdr 680 · Van Nuys, CADec 15, 1967 · N680S · Substantial damage NTSB OAK68D0247Accident · No injuriesClosedGrumman G-164 · Merced, CADec 14, 1967 · N703Y · Substantial damage NTSB OAK68D0304Accident · No injuriesClosedCessna 150 · Vacaville, CADec 13, 1967 · N2400J · Substantial damage NTSB OAK68D0232Accident · No injuriesClosedCessna 210 · Oakland, CADec 13, 1967 · N450A · Substantial damage NTSB OAK68D0228Accident · No injuriesClosedCessna 172 · Vacaville, CADec 13, 1967 · N6850X · Substantial damage NTSB LAX68D0239Accident · No injuriesClosedPiper PA-28 · Torrance, CADec 12, 1967 · N6466W · Substantial damage NTSB OAK68D0248Accident · No injuriesClosedBeech H35 · Monterey, CADec 11, 1967 · N4634D · Substantial damage NTSB OAK68D0290Accident · No injuriesClosedErco 415-C · Monterey, CADec 10, 1967 · N93359 · Substantial damage NTSB OAK68D0287Accident · No injuriesClosedMooney M21 · Truckee, CADec 10, 1967 · N74567 · Substantial damage NTSB OAK68D0263Accident · No injuriesClosedStinson 108-2 · Santa Cruz, CADec 10, 1967 · N9403K · Substantial damage NTSB LAX68D0257Accident · No injuriesClosedPiper PA-16 · Imperial, CADec 10, 1967 · N5847H · Substantial damage NTSB LAX68D0241Accident · No injuriesClosedSchweizer SGS126 · Elsinore, CADec 10, 1967 · N3865A · Substantial damage NTSB LAX68A0060Accident · 2 fatalClosedChampion 7GCAA · Lucerne Vly, CADec 10, 1967 · N9683S · Destroyed NTSB OAK68D0344Accident · No injuriesClosedCessna 170A · Half Mon By, CADec 9, 1967 · N3843V · Substantial damage NTSB LAX68F0240Accident · No injuriesClosedCessna 310G · Santa Monca, CADec 9, 1967 · N8904Z · Substantial damage NTSB LAX68D0235Accident · No injuriesClosedCassna 182 · Escondido, CADec 9, 1967 · N5966B · Substantial damage