Skip to content

Fatal NTSB investigations, 1975

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

Fatal NTSB investigations, 1975 per year, 1962–2026: 30,836 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	248

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") = 1975 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\") = 1975
    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") = 1975
  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 OAK76AP039Accident · 1 fatalClosedCessna A150K · Oakland, CADec 29, 1975 · N8430M · Destroyed NTSB OAK76AP036Accident · 2 fatalClosedCessna 150L · Etna, CADec 29, 1975 · N6028J · Destroyed NTSB MKC76AK036Accident · 1 fatalClosedAero-Comdr 680F · Owensville, MODec 29, 1975 · N108E · Destroyed NTSB CHI76AC042Accident · 1 fatalClosedPiper J-3 · Hopedale, OHDec 29, 1975 · N3331N · Substantial damage NTSB OAK76AP035Accident · 5 fatalClosedMooney M20A · Stockton, CADec 28, 1975 · N8120E · Destroyed NTSB NYC76AN062Accident · 2 fatalClosedCessna 150M · Buena, NJDec 28, 1975 · N2928V · 2 aircraft · Destroyed NTSB MKC76FK035Accident · 2 fatalClosedAeronca 11CC · Elgin, NDDec 28, 1975 · N4131E · Substantial damage NTSB IAD76AI045Accident · 1 fatalClosedMooney M20E · Mt Olivet, KYDec 28, 1975 · N1263X · Destroyed NTSB FTW76AF053Accident · 2 fatalClosedCessna 182C · Pencil Bluff, ARDec 28, 1975 · N8494T · Destroyed NTSB DEN76AD026Accident · 4 fatalClosedAero Comdr 680 · Pagosa Spgs, CODec 28, 1975 · N6221D · Destroyed NTSB CHI76FEC16Accident · 1 fatalClosedCessna 182 · Detroit, MIDec 28, 1975 · N6054B · No damage NTSB FTW76AF052Accident · 4 fatalClosedMooney M20C · Strawberry, ARDec 27, 1975 · N6413U · Destroyed NTSB SEA76AS032Accident · 4 fatalClosedPiper PA-24 · Palmer, WADec 26, 1975 · N7288P · Destroyed NTSB HAY76AL042Accident · 9 fatalClosedMitsubishi MU-2B · Rollinsville, CODec 26, 1975 · N133MA · Destroyed NTSB FTW76AF055Accident · 5 fatalClosedCessna U206 · Harrison, ARDec 26, 1975 · N138ND · Destroyed NTSB ANC76AA056Accident · 2 fatalClosedBellanca 7GCAA · Soldotna, AKDec 26, 1975 · N6339N · Substantial damage NTSB IAD76AI044Accident · 4 fatalClosedBellanca 17-31 · Butler, TNDec 25, 1975 · N14707 · Destroyed NTSB CHI76AC041Accident · 5 fatalClosedBeech P35 · Ft Pierre, SDDec 25, 1975 · N1480G · Destroyed NTSB NYC76AN060Accident · 1 fatalClosedBeech D18S · Bloserville, PADec 24, 1975 · N91A · Destroyed NTSB MKC76AK034Accident · 1 fatalClosedCessna 337B · St Paul, MNDec 24, 1975 · N2393S · Substantial damage NTSB MKC76AK033Accident · 2 fatalClosedBeech E18S · Kansas City, MODec 24, 1975 · N7010 · Destroyed NTSB OAK76AP038Accident · 3 fatalClosedBeech 35 · Incline Vlg, NVDec 23, 1975 · N379Z · Destroyed NTSB FTW76AF051Accident · 1 fatalClosedPiper PA-28R · Abernathy, TXDec 23, 1975 · N16479 · Destroyed NTSB LAX76AL041Accident · 3 fatalClosedPiper PA-28 · Banning, CADec 22, 1975 · N7997N · Destroyed NTSB SEA76AS031Accident · 3 fatalClosedCessna R172 · Klamath Falls, ORDec 21, 1975 · N12987 · Destroyed NTSB OAK76AP034Accident · 1 fatalClosedNavion A · Maxwell, CADec 21, 1975 · N91441 · Destroyed NTSB MIA76AM054Accident · 1 fatalClosedCessna 150 · Jupiter, FLDec 21, 1975 · N17228 · Destroyed NTSB LAX26O0011Accident · 5 fatalClosedAero Comdr 500A · Baja Ca Norte, MexicoDec 21, 1975 · N9392R · Destroyed NTSB MKC76AK031Accident · 3 fatalClosedBellanca 17-31A · Garrison, IADec 20, 1975 · N8200R · Destroyed NTSB MIA76AM053Accident · 5 fatalClosedNavion B · Cross City, FLDec 20, 1975 · N5275K · Destroyed NTSB LAX76AL040Accident · 2 fatalClosedRearwin 185 · Etiwanda, CADec 20, 1975 · N33392 · Destroyed NTSB CHI76AC040Accident · 2 fatalClosedPiper PA-30 · Monrovia, INDec 20, 1975 · N7785Y · Destroyed NTSB ANC76AA054Accident · 1 fatalClosedBellanca 7GCBC · Bettles, AKDec 18, 1975 · N5137T · Destroyed NTSB ANC76AA053Accident · 1 fatalClosedBellanca 8GCBC · Fairbanks, AKDec 17, 1975 · N88328 · Substantial damage NTSB NYC76AN055Accident · 1 fatalClosedPiper PA-28R · Erie, PADec 14, 1975 · N393HP · Destroyed NTSB MIA76RM050Accident · 1 fatalClosedCessna 150G · Nassau Np, Burkina FasoDec 13, 1975 · N4836X · Destroyed NTSB FTW76AF050Accident · 4 fatalClosedCessna T310Q · Lewisville, TXDec 12, 1975 · N888DB · Destroyed NTSB MIA76AM052Accident · 1 fatalClosedCessna 172 · Missing AircraftDec 9, 1975 · N5182R · Destroyed NTSB CHI76AC038Accident · 4 fatalClosedBeech C50 · Chicago, ILDec 8, 1975 · N3500U · Destroyed NTSB IAD76AI038Accident · 1 fatalClosedPiper PA-32R · Topping, VADec 6, 1975 · N200HM · Destroyed NTSB DEN76AD024Accident · 4 fatalClosedCessna 172M · Beaver, UTDec 6, 1975 · N13730 · Destroyed NTSB NYC76AN052Accident · 1 fatalClosedPiper PA-23 · Spring Valley, NYDec 4, 1975 · N2191P · Destroyed NTSB OAK76AP031Accident · 2 fatalClosedMooney M22 · Davis, CADec 3, 1975 · N7713M · Destroyed NTSB SEA76AS029Accident · 1 fatalClosedMooney M20C · Mount Hood, ORDec 1, 1975 · N9746M · Destroyed NTSB OAK76AP030Accident · 4 fatalClosedCessna 210L · Mt.Shasta, CADec 1, 1975 · N1MG · Destroyed NTSB MIA76AM049Accident · 3 fatalClosedMooney M20C · Cross City, FLDec 1, 1975 · N78974 · Destroyed NTSB OAK76AP029Accident · 2 fatalClosedCessna 402 · Elko, NVNov 30, 1975 · N52SA · Destroyed NTSB SEA76AS028Accident · 2 fatalClosedPiper PA-24 · Myrtle Creek, ORNov 29, 1975 · N9451P · Destroyed NTSB MIA76AM048Accident · 2 fatalClosedCessna 337G · Boca Raton, FLNov 29, 1975 · N97C · Destroyed NTSB FTW76AF048Accident · 3 fatalClosedBeech M35 · Jena, LANov 29, 1975 · N1169R · Destroyed