Skip to content

NTSB investigations, 1975, ID

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

19642026

NTSB investigations, 1975, ID per year, 1964–2026: 2,504 cases
1964	70
1965	49
1966	62
1967	64
1968	65
1969	47
1970	54
1971	57
1972	41
1973	48
1974	63
1975	56
1976	63
1977	48
1978	43
1979	56
1980	44
1981	40
1982	47
1983	41
1984	41
1985	46
1986	50
1987	25
1988	29
1989	22
1990	30
1991	30
1992	37
1993	26
1994	39
1995	35
1996	33
1997	31
1998	41
1999	46
2000	34
2001	24
2002	48
2003	52
2004	40
2005	38
2006	30
2007	40
2008	34
2009	37
2010	37
2011	33
2012	40
2013	32
2014	30
2015	27
2016	22
2017	31
2018	28
2019	33
2020	24
2021	39
2022	27
2023	29
2024	35
2025	22
2026	19

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."eventStateOrRegion" = 'ID' 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\") = 1975
    AND c.\"eventStateOrRegion\" = 'ID' 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") = 1975
  AND c."eventStateOrRegion" = 'ID' 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 SEA76FYG25Accident · Minor injuriesClosedNa Rockwell 112 · Sandpoint, IDDec 19, 1975 · N1078J · Substantial damage NTSB SEA76DYG24Accident · No injuriesClosedCessna 182 · Orofino, IDNov 25, 1975 · N3069Q · Substantial damage NTSB SEA75DYG22Accident · No injuriesClosedBell 47G3B2 · Sandpoint, IDOct 24, 1975 · N4070J · Destroyed NTSB SEA76FYA14Accident · Minor injuriesClosedCessna 182G · Marsing, IDOct 8, 1975 · N2479R · Substantial damage NTSB SEA76DYA13Accident · No injuriesClosedCessna 170B · Mccall, IDSep 9, 1975 · N3476D · Substantial damage NTSB SEA76DYG10Accident · No injuriesClosedCessna 172 · Deary, IDAug 24, 1975 · N3925R · Substantial damage NTSB SEA76AS011Accident · 5 fatalClosedBeech 95-C55 · Murphy, IDAug 19, 1975 · N2066W · Destroyed NTSB SEA76AS009Accident · Minor injuriesClosedBell 206B · Indian Creek, IDAug 8, 1975 · N1428W · Substantial damage NTSB SEA76DYA12Accident · No injuriesClosedCessna 175 · Yellow Pine, IDAug 5, 1975 · N6990F · Substantial damage NTSB SEA76DYG06Accident · No injuriesClosedPiper PA-20 · Coeur D'Alene, IDAug 2, 1975 · N1018Z · Substantial damage NTSB SEA76DYA10Accident · No injuriesClosedCessna 150 · Jerome, IDAug 2, 1975 · N7820F · Destroyed NTSB SEA76DYA11Accident · No injuriesClosedRiley Super 340 · Boise, IDAug 1, 1975 · N1597G · Substantial damage NTSB SEA76FYA09Accident · Serious injuriesClosedBoeing PT-17 · Idaho Falls, IDJul 31, 1975 · N62906 · Destroyed NTSB SEA76DYA08Accident · No injuriesClosedPiper PA-20 · Mccall, IDJul 27, 1975 · N2698A · Substantial damage NTSB SEA76FYA07Accident · No injuriesClosedChampion 7GCAA · Boise, IDJul 26, 1975 · N8305V · Substantial damage NTSB SEA76FYA06Accident · 1 fatalClosedPiper PA-25 · Fruitland, IDJul 23, 1975 · N7592Z · Destroyed NTSB SEA76FYA05Accident · Minor injuriesClosedSikorsky S-61L · Garden Valley, IDJul 22, 1975 · N301Y · Substantial damage NTSB SEA76DYA03Accident · No injuriesClosedStinson 108-3 · Idaho Falls, IDJul 13, 1975 · N511C · Substantial damage NTSB SEA76DYA02Accident · Minor injuriesClosedPiper PA-18 · Ketchum, IDJul 8, 1975 · N1370A · Substantial damage NTSB SEA76AYA01Accident · Minor injuriesClosedVolksplane VP-2 · Boise, IDJul 5, 1975 · N48196 · Substantial damage NTSB SEA76DYA04Accident · No injuriesClosedGrumman G-164 · Rupert, IDJul 2, 1975 · N6397 · Substantial damage NTSB SEA75DYG47Accident · No injuriesClosedGrumman G-164A · Deary, IDJun 29, 1975 · N5286 · Substantial damage NTSB SEA75DYA51Accident · No injuriesClosedCallair A-9 · Glenns Ferry, IDJun 29, 1975 · N3555G · Destroyed NTSB SEA75DYA52Accident · No injuriesClosedEnstrom F-28A1 · Boise, IDJun 23, 1975 · N9077 · Substantial damage NTSB SEA75FYG44Accident · Serious injuriesClosedErco 415-C · Priest River, IDJun 21, 1975 · N99752 · Substantial damage NTSB SEA7KFYA50Accident · Serious injuriesClosedPiper PA-22 · Blackfoot, IDJun 11, 1975 · N2602P · Substantial damage NTSB SEA75FYA49Accident · No injuriesClosedCessna 150 · Firth, IDJun 10, 1975 · N22281 · Substantial damage NTSB SEA75FYA48Accident · No injuriesClosedHelicom Comutr · Arco, IDJun 8, 1975 · N8425 · Substantial damage NTSB SEA7KDYG46Accident · No injuriesClosedCessna 337 · Mackey Bar, IDJun 7, 1975 · N55CS · Substantial damage NTSB SEA76DYA46Accident · Minor injuriesClosedPiper PA-22 · Burley, IDJun 2, 1975 · N3413Z · Substantial damage NTSB SEA7KDYA45Accident · No injuriesClosedCessna 177 · Idaho City, IDMay 31, 1975 · N34553 · Substantial damage NTSB SEA75DYA44Accident · No injuriesClosedCessna A188B · Fairfield, IDMay 22, 1975 · N9845G · Substantial damage NTSB SEA75DYA42Accident · No injuriesClosedHughes 269A1A · Burley, IDMay 18, 1975 · N8859F · Substantial damage NTSB SEA75AS041Accident · 2 fatalClosedStinson 108-2 · Gimlet, IDMay 17, 1975 · N9632K · Destroyed NTSB SEA75DYA43Accident · No injuriesClosedPiper PA-18 · Paul, IDMay 16, 1975 · N5771D · Substantial damage NTSB SEA75DYA41Accident · No injuriesClosedCessna 150 · Mountain Home, IDMay 12, 1975 · N10517 · Substantial damage NTSB SEA7KDYA40Accident · No injuriesClosedPiper PA-12 · Homedale, IDMay 11, 1975 · N4018H · Destroyed NTSB SEA75DYA39Accident · No injuriesClosedCessna 180 · Mccall, IDMay 3, 1975 · N699HR · Substantial damage NTSB SEA75DYA38Accident · No injuriesClosedPiper PA-22 · Gooding, IDMay 3, 1975 · N4626Z · Substantial damage NTSB SEA7KFYA37Accident · No injuriesClosedBeech B24R · Carey, IDApr 29, 1975 · N2549W · Substantial damage NTSB SEA75DYG29Accident · No injuriesClosedWeatherly 201B · Genesee, IDApr 19, 1975 · N1273W · Substantial damage NTSB SEA75DYA36Accident · No injuriesClosedCessna 150 · Boise, IDApr 19, 1975 · N7815E · Substantial damage NTSB SEA75AS039Accident · 2 fatalClosedPiper PA-28 · Riddle, IDApr 17, 1975 · N40952 · Destroyed NTSB SEA75DYG35Accident · No injuriesClosedCessna TU206F · Mccall, IDApr 12, 1975 · N1912U · Substantial damage NTSB SEA75DYA35Accident · No injuriesClosedPiper PA-22 · Fairfield, IDApr 10, 1975 · N9309D · Substantial damage NTSB SEA75DYG27Accident · No injuriesClosedChampion 7GCBC · Sandpoint, IDMar 30, 1975 · N8330V · Substantial damage NTSB SEA75DYA34Accident · No injuriesClosedCessna T337 · Dubois, IDMar 18, 1975 · N11RA · Substantial damage NTSB SEA75DYG24Accident · No injuriesClosedCessna 185 · Kamiah, IDMar 15, 1975 · N70060 · Substantial damage NTSB SEA75DYA33Accident · No injuriesClosedCessna 150 · Salmon, IDMar 14, 1975 · N61087 · Substantial damage NTSB SEA75DYG23Accident · No injuriesClosedStearman E75N1 · Craigmont, IDMar 8, 1975 · N1720B · Substantial damage