Skip to content

Final NTSB investigations, 1975

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

Final NTSB investigations, 1975 per year, 1962–2026: 171,584 cases
1962	72
1963	78
1964	5,253
1965	5,377
1966	5,912
1967	6,339
1968	5,199
1969	5,027
1970	4,915
1971	4,825
1972	4,430
1973	4,398
1974	4,565
1975	4,403
1976	4,314
1977	4,412
1978	4,624
1979	4,165
1980	3,921
1981	3,836
1982	3,545
1983	3,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,139
2025	779
2026	365

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."completionStatus" = 'Completed' 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.\"completionStatus\" = 'Completed'
  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."completionStatus" = 'Completed'
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 NYC76FNA24Accident · No injuriesClosedPiper PA-28R · Fall River, MADec 31, 1975 · N9483N · Substantial damage NTSB MIA76IM055Incident · No injuriesClosedDouglas DC9-31 · Greer, SCDec 31, 1975 · N8933E · Minor damage NTSB MIA76FKJ40Accident · No injuriesClosedBeech 65-80 · Birmingham, ALDec 31, 1975 · N1110P · Substantial damage NTSB FTW76FRG36Accident · No injuriesClosedBeech 58 · Wimberly, TXDec 31, 1975 · N80KC · Substantial damage NTSB FTW76FPJ21Accident · No injuriesClosedPiper PA-32 · Stroud, OKDec 31, 1975 · N8640N · Substantial damage NTSB MIA76FLD37Accident · Minor injuriesClosedPiper PA-28 · Vero Beach, FLDec 30, 1975 · N1966T · Destroyed NTSB MIA76DKT39Accident · Minor injuriesClosedCessna 182E · Miami, FLDec 30, 1975 · N3204Y · Destroyed NTSB DEN76FTE45Accident · Serious injuriesClosedPiper PA-32 · Saint Elmo, CODec 30, 1975 · N4291T · Destroyed NTSB DEN76FQA32Accident · No injuriesClosedPiper PA-34 · Albuquerque, NMDec 30, 1975 · N44311 · Substantial damage NTSB OAK76AP039Accident · 1 fatalClosedCessna A150K · Oakland, CADec 29, 1975 · N8430M · Destroyed NTSB OAK76AP036Accident · 2 fatalClosedCessna 150L · Etna, CADec 29, 1975 · N6028J · Destroyed NTSB NYC76DNC34Accident · No injuriesClosedCessna 150 · Nashua, NHDec 29, 1975 · N66586 · Substantial damage NTSB NYC76DFA21Accident · No injuriesClosedCessna 150 · Lexington, NYDec 29, 1975 · N66252 · Substantial damage NTSB MKC76DER44Accident · Minor injuriesClosedPiper PA-28 · Windom, MNDec 29, 1975 · N471XT · Substantial damage 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 OAK76DVG38Accident · Serious injuriesClosedPiper PA-18A · Tulelake, CADec 28, 1975 · N1452C · Destroyed NTSB OAK76AP035Accident · 5 fatalClosedMooney M20A · Stockton, CADec 28, 1975 · N8120E · Destroyed NTSB NYC76DHD15Accident · No injuriesClosedCessna 150L · West Chester, PADec 28, 1975 · N1240Q · 2 aircraft · Substantial damage 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 CHI76FEI17Accident · No injuriesClosedCessna 180H · Fremont, OHDec 28, 1975 · N2467F · Substantial damage NTSB CHI76FEC16Accident · 1 fatalClosedCessna 182 · Detroit, MIDec 28, 1975 · N6054B · No damage NTSB OAK76DVA33Accident · No injuriesClosedCessna 140 · Shaver Lake, CADec 27, 1975 · N2703N · Destroyed NTSB NYC76DNA23Accident · No injuriesClosedMooney M-18C · Falmouth, MADec 27, 1975 · N4094 · Substantial damage NTSB LAX76IL043Incident · No injuriesClosedAero Star 601 · San Diego, CADec 27, 1975 · N97Q · Minor damage NTSB LAX76DUJ50Accident · Minor injuriesClosedCessna 206 · Holbrook, AZDec 27, 1975 · N3927G · Substantial damage NTSB FTW76AF052Accident · 4 fatalClosedMooney M20C · Strawberry, ARDec 27, 1975 · N6413U · Destroyed NTSB DEN76DTE44Accident · No injuriesClosedCessna 210 · Blanca, CODec 27, 1975 · N9683T · Substantial damage NTSB CHI76FEC18Accident · Serious injuriesClosedRyan Navion · Jackson, MIDec 27, 1975 · N4216K · Destroyed NTSB SEA76AS032Accident · 4 fatalClosedPiper PA-24 · Palmer, WADec 26, 1975 · N7288P · Destroyed NTSB OAK76DVG40Accident · No injuriesClosedPiper PA-22 · Angwin, CADec 26, 1975 · N162 · Substantial damage NTSB MIA76DKT53Accident · Minor injuriesClosedGrum Amer AA1-B · Pompano Beach, FLDec 26, 1975 · N9868L · Substantial damage NTSB LAX76O0009Accident · Minor injuriesClosedPiper PA-24 · Palenque, MexicoDec 26, 1975 · N7888P · Substantial damage NTSB LAX76DUJ51Accident · Minor injuriesClosedCessna U206B · Queen Creek, AZDec 26, 1975 · N3805G · Substantial damage NTSB HAY76AL042Accident · 9 fatalClosedMitsubishi MU-2B · Rollinsville, CODec 26, 1975 · N133MA · Destroyed NTSB FTW76FPG39Accident · Serious injuriesClosedCessna 150F · Monticello, ARDec 26, 1975 · N6447F · Destroyed NTSB FTW76FPA14Accident · No injuriesClosedCessna 310J · Addison, TXDec 26, 1975 · N49AM · Substantial damage NTSB FTW76FPA13Accident · Minor injuriesClosedCessna 150 · Rice, TXDec 26, 1975 · N8393J · Substantial damage NTSB FTW76DQG40Accident · Minor injuriesClosedCessna 180 · Borger, TXDec 26, 1975 · N9210C · Destroyed NTSB FTW76AF055Accident · 5 fatalClosedCessna U206 · Harrison, ARDec 26, 1975 · N138ND · Destroyed NTSB CHI76FEC17Accident · No injuriesClosedPiper PA-28 · Detroit, MIDec 26, 1975 · N56889 · Substantial damage NTSB ANC76AA056Accident · 2 fatalClosedBellanca 7GCAA · Soldotna, AKDec 26, 1975 · N6339N · Substantial damage NTSB NYC76DNC33Accident · No injuriesClosedCessna 182 · Rutland, VTDec 25, 1975 · N2342R · Substantial damage NTSB NYC76DHA19Accident · No injuriesClosedBellanca 7ECA · Califon, NJDec 25, 1975 · N57668 · Substantial damage NTSB LAX76DVA31Accident · No injuriesClosedCessna T210L · Bakersfield, CADec 25, 1975 · N5148Q · Substantial damage NTSB LAX7600014Accident · No injuriesClosedCessna 210 · Culiacan, MexicoDec 25, 1975 · N5279V · Substantial damage