Skip to content

NTSB investigations, 1972, ID

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

19642026

NTSB investigations, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 SEA73FYA15Accident · No injuriesClosedCessna 182P · Gooding, IDDec 26, 1972 · N20785 · Substantial damage NTSB SEA73AS036Accident · 5 fatalClosedPiper PA-24 · Malad City, IDDec 17, 1972 · N5774P · Destroyed NTSB SEA73AS016Accident · 1 fatalClosedCessna 206D · Kamian, IDNov 29, 1972 · N8768Z · Destroyed NTSB SEA73DYA14Accident · No injuriesClosedErco 415C · Boise, IDOct 14, 1972 · N94057 · Substantial damage NTSB SEA73FYA13Accident · Serious injuriesClosedBeech 35-A33 · Hailey, IDOct 3, 1972 · N9403Y · Substantial damage NTSB SEA73DYA12Accident · No injuriesClosedPiper PA-25 · Amer Falls, IDSep 9, 1972 · N4736Y · Substantial damage NTSB SEA73FYA11Accident · 1 fatalClosedPiper PA-25 · St. Anthony, IDSep 8, 1972 · N8567L · Destroyed NTSB SEA73DYA09Accident · Minor injuriesClosedCessna 205 · Blackfoot, IDSep 4, 1972 · N1843Z · Substantial damage NTSB SEA73DYG17Accident · No injuriesClosedMooney M20-C · Priest Lake, IDAug 28, 1972 · N9345V · Substantial damage NTSB SEA73DYA08Accident · No injuriesClosedAeronca 11AC · Rupert, IDAug 18, 1972 · N86363 · Substantial damage NTSB SEA73DYA07Accident · No injuriesClosedCallair A-9 · Hamer, IDAug 18, 1972 · N9668Z · Substantial damage NTSB SEA73FYA06Accident · Serious injuriesClosedPiper PA-25 · Menan, IDAug 13, 1972 · N6054Z · Destroyed NTSB SEA73DYA05Accident · Serious injuriesClosedBell 47G · Murtaugh, IDAug 6, 1972 · N1071Z · Substantial damage NTSB SEA73DYA03Accident · Serious injuriesClosedCessna 172 · Ketchum, IDJul 29, 1972 · N7006G · Destroyed NTSB SEA73DYA02Accident · No injuriesClosedPiper PA-25 · Terreton, IDJul 24, 1972 · N7844Z · Substantial damage NTSB SEA73FYG01Accident · No injuriesClosedPiper PA-28R · St.Maries, IDJul 9, 1972 · N3887T · Substantial damage NTSB SEA73DYA01Accident · No injuriesClosedBoeing B75N1 · Idaho Falls, IDJul 9, 1972 · N5132N · Substantial damage NTSB SEA72DYA42Accident · No injuriesClosedCessna 150 · Dubois, IDJun 30, 1972 · N50907 · Substantial damage NTSB SEA72DYA41Accident · No injuriesClosedPiper PA-12 · Middleton, IDJun 28, 1972 · N4401M · Substantial damage NTSB SEA72AS054Accident · No injuriesClosedPiper PA-28 · Blackfoot, IDJun 17, 1972 · N8775N · Substantial damage NTSB SEA72DYA39Accident · No injuriesClosedCessna 172 · Fort Hall, IDJun 8, 1972 · N6135E · Destroyed NTSB SEA72DYA38Accident · No injuriesClosedCessna 170A · Cambridge, IDJun 7, 1972 · N9513A · Destroyed NTSB SEA72DYA36Accident · No injuriesClosedCessna 305A · Twin Falls, IDJun 4, 1972 · N5239G · Substantial damage NTSB SEA72FYG39Accident · No injuriesClosedPiper PA-25 · Troy, IDMay 23, 1972 · N7436Z · Substantial damage NTSB SEA72DYA35Accident · No injuriesClosedHiller Acft UH-12E · Dubois, IDMay 17, 1972 · N90465 · Substantial damage NTSB SEA72FYA33Accident · Serious injuriesClosedPiper PA-25 · Oakley, IDMay 15, 1972 · N8707L · Destroyed NTSB SEA72DYA32Accident · No injuriesClosedBoeing E75 · Driggs, IDMay 6, 1972 · N5307N · Substantial damage NTSB SEA72DYG34Accident · Minor injuriesClosedCessna 188 · Cameron, IDApr 24, 1972 · N3557Q · Substantial damage NTSB SEA72DYA30Accident · Minor injuriesClosedBeech C-18S · Blackfoot, IDApr 20, 1972 · N4289A · Substantial damage NTSB SEA72DYG33Accident · No injuriesClosedKaman K-600 · Worley, IDApr 19, 1972 · N5181Q · Substantial damage NTSB SEA72DYA29Accident · No injuriesClosedHughes 269C · Soda Springs, IDApr 9, 1972 · N9620F · Substantial damage NTSB SEA72AS043Accident · No injuriesClosedPiper PA-25 · St.Anthony, IDMar 31, 1972 · N8567L · Substantial damage NTSB SEA72DYA28Accident · No injuriesClosedPiper PA-25 · Preston, IDMar 27, 1972 · N6820Z · Substantial damage NTSB SEA72D!A27Accident · No injuriesClosedPiper PA-18 · Irwin, IDMar 23, 1972 · N4716A · Substantial damage NTSB SEA72FYA26Accident · No injuriesClosedPiper PA-28 · Caldwell, IDMar 9, 1972 · N9340J · Substantial damage NTSB SEA72FYA24Accident · Serious injuriesClosedBeech V35 · Ketchum, IDFeb 26, 1972 · N843BW · Substantial damage NTSB SEA72AS033Accident · 5 fatalClosedBeech 65-B80 · Fairfield, IDFeb 20, 1972 · N1027C · Destroyed NTSB SEA72AS031Accident · 1 fatalClosedChampion 7GCBC · Holbrook, IDFeb 13, 1972 · N7520F · Destroyed NTSB SEA72AS034Accident · 2 fatalClosedCessna 182H · Lowman, IDFeb 11, 1972 · CF-SZT · Destroyed NTSB SEA72DYA23Accident · No injuriesClosedTaylorcraft DCO-65 · Boise, IDFeb 5, 1972 · N49122 · Substantial damage NTSB SEA72DYG25Accident · No injuriesClosedCessna 140 · Lewiston, IDJan 15, 1972 · N89336 · Destroyed