Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 SEA74DYA18Accident · No injuriesClosedPiper PA-22 · Bone, IDDec 29, 1973 · N8002D · Substantial damage NTSB SEA74DYA17Accident · No injuriesClosedBell 47G-3B · Twin Falls, IDDec 17, 1973 · N8588F · Substantial damage NTSB SEA74DYG21Accident · No injuriesClosedCessna 150 · Priest River, IDDec 2, 1973 · N7711E · Substantial damage NTSB SEA74DYA16Accident · No injuriesClosedCessna 150F · Rexburg, IDNov 30, 1973 · N8292F · Substantial damage NTSB SEA74DYA15Accident · No injuriesClosedCessna 210 · Bellevue, IDNov 4, 1973 · N9507X · Substantial damage NTSB SEA74AS002Accident · 4 fatalClosedAmer Avco AA5 · Shelley, IDOct 27, 1973 · N9267L · Destroyed NTSB SEA74FYA14Accident · Minor injuriesClosedPiper PA-22 · Boise, IDOct 17, 1973 · N996A · Substantial damage NTSB SEA74FYA13Accident · No injuriesClosedBell 47G-3B · Marsing, IDOct 15, 1973 · N73230 · Destroyed NTSB SEA74DYA12Accident · Serious injuriesClosedBell 47G-3B · New Meadows, IDOct 2, 1973 · N73909 · Destroyed NTSB SEA74DYA11Accident · No injuriesClosedGrumman G-164A · Idaho Falls, IDSep 10, 1973 · N7369 · Destroyed NTSB SEA74FYG15Accident · Serious injuriesClosedCessna 182P · Dixie, IDSep 9, 1973 · N9386G · Substantial damage NTSB SEA74AS014Accident · 4 fatalClosedPiper PA-28 · Idaho Cty, IDSep 9, 1973 · N1742T · Destroyed NTSB SEA74DYA10Accident · No injuriesClosedCessna 140 · Preston, IDAug 30, 1973 · N76057 · Substantial damage NTSB SEA74DYG11Accident · No injuriesClosedBellanca 14-193 · Orofino, IDAug 26, 1973 · N74450 · Substantial damage NTSB SEA74DVA09Accident · No injuriesClosedHiller UH-12E · S.Glenns Ferry, IDAug 26, 1973 · N7755 · Substantial damage NTSB SEA74AS007Accident · 4 fatalClosedCessna 182 · Salmon, IDAug 19, 1973 · N3280U · Destroyed NTSB SEA74DYA08Accident · No injuriesClosedPiper PA-18A · Mud Lake, IDAug 13, 1973 · N3707A · Substantial damage NTSB SEA74FYG09Accident · Serious injuriesClosedPiper PA-28 · St.Maries, IDAug 12, 1973 · N2198T · Destroyed NTSB DEN74AD007Accident · 1 fatalClosedCessna 172L · Preston, IDAug 11, 1973 · N7725G · Substantial damage NTSB SEA74FYA07Accident · Serious injuriesClosedPiper PA-25 · Goshen, IDAug 2, 1973 · N8586L · Destroyed NTSB SEA74DYG07Accident · No injuriesClosedBell 47G3B · Orofino, IDAug 1, 1973 · N73249 · Substantial damage NTSB SEA74DYA05Accident · No injuriesClosedPiper PA-25 · Nampa, IDJul 30, 1973 · N6748Z · Substantial damage NTSB SEA74FYA03Accident · No injuriesClosedDouglas B-26B · Idaho Falls, IDJul 10, 1973 · N5426E · Substantial damage NTSB SEA74FYA02Accident · Minor injuriesClosedAero Comdr 600S2R · Homedale, IDJul 7, 1973 · N5553X · Substantial damage NTSB SEA74FYA01Accident · 1 fatalClosedSchleicher ASW-15 · Eagle, IDJul 7, 1973 · N88JM · Destroyed NTSB SEA73DYA36Accident · No injuriesClosedBeech A35 · Stanley, IDJun 26, 1973 · N590B · Substantial damage NTSB SEA73DYA35Accident · No injuriesClosedCessna 180C · Burley, IDJun 23, 1973 · N6406X · Substantial damage NTSB SEA73DYA34Accident · No injuriesClosedCessna 172 · Preston, IDJun 23, 1973 · N2508L · Substantial damage NTSB SEA73AS039Accident · No injuriesClosedBeech 95-B55 · Hailey, IDJun 23, 1973 · N332N · Substantial damage NTSB SEA73DYA33Accident · No injuriesClosedCessna 180 · Boise, IDJun 22, 1973 · N4700U · Substantial damage NTSB SEA73DYA32Accident · No injuriesClosedPiper PA-25 · Mountain Home, IDJun 16, 1973 · N6836Z · Destroyed NTSB SEA73DYA31Accident · No injuriesClosedGrumman G-164 · Idaho Falls, IDJun 12, 1973 · N745Y · Destroyed NTSB SEA73DYA30Accident · No injuriesClosedPiper PA-24 · American Falls, IDJun 9, 1973 · N944P · Substantial damage NTSB SEA73FYA27Accident · No injuriesClosedPiper PA-20 · Caldwell, IDMay 22, 1973 · N69F · Substantial damage NTSB SEA73DYA25Accident · No injuriesClosedMooney M20E · American Falls, IDMay 13, 1973 · N5614Q · Substantial damage NTSB SEA73DYA24Accident · Minor injuriesClosedCessna 150F · Pine, IDMay 13, 1973 · N6478F · Destroyed NTSB SEA73DYA28Accident · No injuriesClosedBeech J35 · Cascade, IDMay 11, 1973 · N3005C · Substantial damage NTSB SEA73DYA23Accident · No injuriesClosedCessna U206A · Star, IDMay 3, 1973 · N8069Z · Substantial damage NTSB SEA73DYA22Accident · No injuriesClosedBoeing E75 · Roberts, IDMay 2, 1973 · N5307N · Substantial damage NTSB SEA73DYG32Accident · No injuriesClosedPiper PA-18 · Doumecy, IDApr 18, 1973 · N7574P · Substantial damage NTSB SEA73DYA20Accident · No injuriesClosedCessna 210 · Burley, IDApr 6, 1973 · N9666T · Substantial damage NTSB SEA73AS028Accident · 1 fatalClosedPiper PA-32 · Rogerson, IDApr 1, 1973 · N1208T · Destroyed NTSB SEA73DYA19Accident · No injuriesClosedDehavilland DH114 · Hailey, IDFeb 25, 1973 · N509FW · Substantial damage NTSB SEA73DYA18Accident · Serious injuriesClosedPiper PA-18 · Weston, IDFeb 24, 1973 · N13951 · Destroyed NTSB SEA73FYA17Accident · No injuriesClosedPiper PA-28 · Jerome, IDFeb 19, 1973 · N9488W · Substantial damage NTSB SEA73DYA16Accident · Minor injuriesClosedStinson 108-3 · New Meadows, IDFeb 3, 1973 · N771C · Substantial damage NTSB SEA73AS020Accident · 1 fatalClosedCessna 170B · Headquarters, IDJan 27, 1973 · N3181F · Destroyed NTSB SEA73FYG22Accident · Minor injuriesClosedCessna 120 · Sandpoint, IDJan 23, 1973 · N2074V · Destroyed