Skip to content

Fatal NTSB investigations, 1969

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

Fatal NTSB investigations, 1969 per year, 1962–2026: 30,835 cases
1962	11
1963	13
1964	539
1965	560
1966	581
1967	625
1968	718
1969	655
1970	643
1971	664
1972	697
1973	731
1974	727
1975	692
1976	707
1977	713
1978	800
1979	691
1980	672
1981	705
1982	638
1983	651
1984	617
1985	555
1986	507
1987	496
1988	502
1989	484
1990	499
1991	482
1992	494
1993	437
1994	445
1995	456
1996	421
1997	402
1998	422
1999	404
2000	443
2001	412
2002	417
2003	440
2004	418
2005	428
2006	408
2007	387
2008	373
2009	359
2010	363
2011	398
2012	389
2013	344
2014	360
2015	365
2016	341
2017	338
2018	361
2019	381
2020	294
2021	321
2022	330
2023	295
2024	292
2025	275
2026	247

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") = 1969 AND c."highestInjuryLevel" = 'Fatal' 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\") = 1969
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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") = 1969
  AND c."highestInjuryLevel" = 'Fatal'
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 MIA70A0051Accident · 4 fatalClosedBeech V35A · Tampa, FLDec 31, 1969 · N8351N · Destroyed NTSB FTW70A0044Accident · 1 fatalClosedPiper PA-24 · Boynton, OKDec 31, 1969 · N6011P · Destroyed NTSB OAK70F0212Accident · 1 fatalClosedBell 47G3B1 · Hamiltn Afb, CADec 30, 1969 · N1320X · Substantial damage NTSB DEN70A0042Accident · 2 fatalClosedCessna 177 · Monticello, UTDec 30, 1969 · N2335Y · Destroyed NTSB MKC70A0037Accident · 2 fatalClosedPiper PA-30 · Vermillion, SDDec 29, 1969 · N7201Y · Destroyed NTSB MKC70A0036Accident · 2 fatalClosedCessna 180 · Pierce, NEDec 28, 1969 · N9117C · Destroyed NTSB OAK70A0034Accident · 2 fatalClosedCessna 177 · Lake Tahoe, CADec 27, 1969 · N29500 · Destroyed NTSB OAK70A0033Accident · 3 fatalClosedBeech B23 · Angels Camp, CADec 26, 1969 · N3565R · Destroyed NTSB MIA70A0050Accident · 2 fatalClosedPiper PA-18 · Belzoni, MSDec 24, 1969 · N4892A · Destroyed NTSB MIA70A0049Accident · 1 fatalClosedPiper PA-30 · Crossville, TNDec 23, 1969 · N7884Y · Destroyed NTSB LAX70A0038Accident · 1 fatalClosedCessna 182L · El Cajon, CADec 23, 1969 · N42622 · Destroyed NTSB SEA70A0027Accident · 2 fatalClosedCessna 182 · Boise, IDDec 22, 1969 · N5657B · Destroyed NTSB MKC70A0035Accident · 1 fatalClosedBeech 65-80 · Republic, MODec 21, 1969 · N1539S · Destroyed NTSB CHI70A0041Accident · 2 fatalClosedPiper PA-28 · Franklin, INDec 21, 1969 · N7738N · 2 aircraft · Substantial damage NTSB ANC70A0048Accident · 2 fatalClosedPiper PA-12 · Juneau, AKDec 21, 1969 · N3013M · Substantial damage NTSB SEA70A0026Accident · 4 fatalClosedCessna 180 · Conrad, MTDec 19, 1969 · N4951A · Destroyed NTSB MKC70A0034Accident · 3 fatalClosedMooney M-20C · Pittsburg, KSDec 19, 1969 · N9101V · Destroyed NTSB FTW70A0043Accident · 4 fatalClosedPiper PA-23 · Norwood, LADec 19, 1969 · N4723P · Destroyed NTSB NYC70A0064Accident · 1 fatalClosedCessna 150H · Woodbury, CTDec 18, 1969 · N6730S · Destroyed NTSB FTW70A0042Accident · 1 fatalClosedBeech A35 · Valley View, TXDec 18, 1969 · N8502A · Destroyed NTSB LAX70A0037Accident · 3 fatalClosedCessna 310 · Sepulveda, CADec 17, 1969 · N6635B · Destroyed NTSB CHI70AC040Accident · 5 fatalClosedCessna 401 · Piketon, OHDec 17, 1969 · N8167F · Destroyed NTSB DEN70A0041Accident · 2 fatalClosedAero Comdr 1121B · Salt Lake City, UTDec 16, 1969 · N403M · Destroyed NTSB MKC70A0033Accident · 2 fatalClosedAlon A-2A · Clear Lake, IADec 15, 1969 · N5646F · Destroyed NTSB LAX70A0036Accident · 1 fatalClosedBell 206A · Grnd Canyon, AZDec 15, 1969 · N1479W · Destroyed NTSB FTW70A0041Accident · 1 fatalClosedChampion 7ECA · Jeanerette, LADec 12, 1969 · N1875G · Destroyed NTSB OAK72AP007Accident · 2 fatalClosedNavion B · Etna, CADec 11, 1969 · N4600K · Destroyed NTSB MIA70A0048Accident · 1 fatalClosedCessna 210B · Mountain Cty, TNDec 11, 1969 · N38T · Destroyed NTSB LAX70A0035Accident · 2 fatalClosedCessna 150 · Sn Clemente, CADec 11, 1969 · N2426J · Destroyed NTSB LAX70A0033Accident · 2 fatalClosedBeech D95A · Big Sur, CADec 11, 1969 · N8619M · Destroyed NTSB NYC70A0061Accident · 3 fatalClosedPiper PA-23 · Passadumkeag, MEDec 10, 1969 · N5090Y · Destroyed NTSB MKC70A0032Accident · 2 fatalClosedBeech J35 · Barnesville, MNDec 10, 1969 · N8325D · Destroyed NTSB MIA70A0044Accident · 2 fatalClosedCessna 210G · Valdosta, GADec 9, 1969 · N5919F · Destroyed NTSB LAX70A0034Accident · 1 fatalClosedBeech K35 · Reno, NVDec 9, 1969 · N6014E · Destroyed NTSB OAK70A0032Accident · 4 fatalClosedBeech J35 · Benton Sta, CADec 8, 1969 · N669B · Destroyed NTSB FTW70A0039Accident · 4 fatalClosedCessna 172K · Bellville, TXDec 8, 1969 · N84307 · Destroyed NTSB FTW70A0040Accident · 1 fatalClosedBeech J35 · Fulton, TXDec 6, 1969 · N3013C · Minor damage NTSB DEN70A0039Accident · 1 fatalClosedBeech B35 · Tucumcari, NMDec 6, 1969 · N5092C · Destroyed NTSB MIA70A0043Accident · 1 fatalClosedCessna 170B · Ft.Lauderdale, FLDec 5, 1969 · N3001W · Destroyed NTSB DEN70A0038Accident · 11 fatalClosedLockheed 18 · Albuquerque, NMDec 5, 1969 · N410M · Destroyed NTSB NYC70A0060Accident · 1 fatalClosedCessna 150G · Miller Place, NYDec 4, 1969 · N2924S · Destroyed NTSB MKC70A0031Accident · 2 fatalClosedCessna 172K · Ulysses, KSDec 3, 1969 · N78585 · Destroyed NTSB NYC70A0059Accident · 1 fatalClosedMooney M20E · Poughkeepsie, NYDec 2, 1969 · N79367 · Destroyed NTSB SEA70A0023Accident · 5 fatalClosedCessna 310B · Miltn-Frewtr, ORDec 1, 1969 · N401T · Destroyed NTSB UNK70X0105Accident · 2 fatalClosedNpiper PA-22 · Brockville, CanadaNov 30, 1969 · N3934P · Destroyed NTSB NYC70A0057Accident · 3 fatalClosedCessna 172 · Gorham, NHNov 29, 1969 · N6416E · Destroyed NTSB NYC70A0056Accident · 1 fatalClosedCessna 150 · La Grangeville, NYNov 29, 1969 · N61086 · Destroyed NTSB IAD70F0120Accident · 1 fatalClosedPiper PA-28 · Rohrersville, MDNov 29, 1969 · N7204F · Destroyed NTSB IAD70A0034Accident · 1 fatalClosedPiper J3C · Apex, NCNov 29, 1969 · N42348 · Destroyed NTSB UNK70X0104Accident · 4 fatalClosedPiper PA-23 · Inagua, Burkina FasoNov 27, 1969 · N4408P · Destroyed