Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 SEA71AS031Accident · 2 fatalClosedDehavilland DH125 · B0ise, IDDec 28, 1970 · N36MK · Destroyed NTSB SEA71DWG35Accident · No injuriesClosedPiper PA-22 · Hayden Lake, IDDec 12, 1970 · N5372Z · Substantial damage NTSB SEA71FXM17Accident · No injuriesClosedBeech G35 · Caldwell, IDDec 11, 1970 · N4469D · Substantial damage NTSB SEA71DXM16Accident · No injuriesClosedCessna 182D · American Falls, IDNov 28, 1970 · N8761X · Substantial damage NTSB SEA71AS028Accident · 1 fatalClosedPiper PA-24 · Kimberly, IDNov 26, 1970 · N6703P · Destroyed NTSB SEA71AS027Accident · 4 fatalClosedPiper PA-24 · St.Charles, IDNov 25, 1970 · N8724P · Destroyed NTSB SEA71DXM15Accident · Minor injuriesClosedCessna 172H · Twin Falls, IDOct 31, 1970 · N1665F · Substantial damage NTSB SEA71FWG27Accident · Serious injuriesClosedPiper PA-23 · Weippe, IDOct 15, 1970 · N3155P · Destroyed NTSB SEA71AS022Accident · 2 fatalClosedCessna A150K · Eagle, IDOct 15, 1970 · N8321M · Substantial damage NTSB SEA71DXM14Accident · No injuriesClosedErco 415-C · Council, IDOct 14, 1970 · N3724H · Substantial damage NTSB SEA71FXM13Accident · Serious injuriesClosedCessna 180 · Hailey, IDOct 5, 1970 · N3144C · Destroyed NTSB SEA71DXM12Accident · No injuriesClosedCessna 177 · American Falls, IDOct 3, 1970 · N29442 · Substantial damage NTSB SEA71DWG26Accident · No injuriesClosedLuscombe 8F · Lewiston, IDOct 3, 1970 · N831B · Substantial damage NTSB SEA71DWG24Accident · No injuriesClosedPiper PA-28R · Kamiah, IDOct 2, 1970 · N3887T · Substantial damage NTSB SEA71DXM11Accident · No injuriesClosedCessna 210D · Montpelier, IDSep 30, 1970 · N3957Y · Substantial damage NTSB SEA71FXM10Accident · Serious injuriesClosedCessna 182B · Sun Valley, IDSep 21, 1970 · N8441T · Destroyed NTSB SEA71AS017Accident · 2 fatalClosedCessna 210 · Spencer, IDSep 20, 1970 · N9628T · Destroyed NTSB SEA71AS016Accident · 3 fatalClosedBeech K35 · Pocatello, IDSep 18, 1970 · N6067E · Destroyed NTSB SEA71FXM09Accident · Serious injuriesClosedPiper PA-12 · Rigby, IDSep 4, 1970 · N2965M · Destroyed NTSB SEA71DWG19Accident · No injuriesClosedPiper PA-23 · Hayden Lake, IDSep 1, 1970 · N4186P · Substantial damage NTSB SEA71DXM07Accident · No injuriesClosedCessna 182 · Carey, IDAug 30, 1970 · N3002Q · Substantial damage NTSB SEA71DXM08Accident · No injuriesClosedPiper PA-25 · Nampa, IDAug 11, 1970 · N4573Y · Substantial damage NTSB SEA71FXM06Accident · Minor injuriesClosedPiper PA-25 · Homedale, IDJul 31, 1970 · N6936Z · Substantial damage NTSB SEA71FXM05Accident · Serious injuriesClosedCallair A-9 · Grand View, IDJul 24, 1970 · N9617Z · Destroyed NTSB SEA71DWG10Accident · No injuriesClosedPiper PA-25 · Genesee, IDJul 17, 1970 · N6354Z · Substantial damage NTSB SEA71DXM03Accident · No injuriesClosedCessna 180 · Boise, IDJul 12, 1970 · N3127C · Substantial damage NTSB SEA71AS001Accident · No injuriesClosedLockheed TV-2 · Marsing, IDJul 10, 1970 · N156 · Substantial damage NTSB SEA71DXM01Accident · No injuriesClosedBell 47G-3B · Hailey, IDJul 6, 1970 · N68645 · Substantial damage NTSB SEA70AS048Accident · 1 fatalClosedCessna 182 · Shoshone, IDJun 27, 1970 · N6446A · Destroyed NTSB SEA70FXM20Accident · 1 fatalClosedGrumman TBM · Boise, IDJun 19, 1970 · N7026C · Destroyed NTSB SEA70DWG20Accident · No injuriesClosedTemco D-16 · Clark Fork, IDJun 15, 1970 · N2522B · Substantial damage NTSB SEA70DXM18Accident · No injuriesClosedPiper PA-25 · Idaho Falls, IDJun 3, 1970 · N5843L · Substantial damage NTSB SEA70DXM15Accident · No injuriesClosedAero Comdr A-9B · Rupert, IDJun 1, 1970 · N7668V · Substantial damage NTSB SEA70DWG17Accident · No injuriesClosedBoeing E75 · Craigmont, IDMay 23, 1970 · N3960B · Substantial damage NTSB SEA71DWG09Accident · No injuriesClosedBensen B-8M · Lewiston, IDMay 22, 1970 · NONE · Substantial damage NTSB SEA70DXM14Accident · No injuriesClosedPiper PA-28 · Oxford, IDMay 15, 1970 · N5787F · Substantial damage NTSB SEA70DWG11Accident · No injuriesClosedBeech 19A · Genesee, IDApr 30, 1970 · N7608R · Substantial damage NTSB SEA70DXM13Accident · No injuriesClosedBoeing D75N1 · Pocatello, IDApr 9, 1970 · N59260 · Substantial damage NTSB SEA70DXM11Accident · No injuriesClosedPiper PA-18 · Salmon, IDApr 9, 1970 · N1370A · Substantial damage NTSB SEA70DWG09Accident · No injuriesClosedBoeing E75 · Southwick, IDApr 8, 1970 · N5685N · Substantial damage NTSB SEA70DXM12Accident · No injuriesClosedCessna 150H · Victor, IDApr 6, 1970 · N6648S · Substantial damage NTSB SEA70FWG07Accident · Minor injuriesClosedBeech 35 · Sandpoint, IDApr 5, 1970 · N3797N · Substantial damage NTSB SEA70DWG08Accident · No injuriesClosedGrumman G-164 · Genesee, IDApr 1, 1970 · N10231 · Substantial damage NTSB SEA70DXM10Accident · No injuriesClosedCessna 170 · Hailey, IDMar 30, 1970 · N3144B · Substantial damage NTSB SEA70AS037Accident · 2 fatalClosedTaylorcraft BC12-D · Middleton, IDMar 20, 1970 · N95088 · Destroyed NTSB SEA70AS035Accident · 1 fatalClosedBeech 95-B55 · Orofino, IDMar 17, 1970 · N8903M · Destroyed NTSB SEA70DXM07Accident · No injuriesClosedPiper PA-18 · Twin Falls, IDMar 7, 1970 · N1145A · Substantial damage NTSB SEA70DXM06Accident · No injuriesClosedCessna 195A · Burley, IDFeb 28, 1970 · N1560D · Substantial damage NTSB SEA70AS034Accident · No injuriesClosedCessna 190 · Lewiston, IDFeb 25, 1970 · N1035D · Substantial damage NTSB SEA70DXM05Accident · Serious injuriesClosedStinson 108 · Rexburg, IDFeb 22, 1970 · N9527K · Substantial damage