Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 SEA69D0157Accident · No injuriesClosedCessna 140 · Weiser, IDDec 25, 1968 · N3177N · Substantial damage NTSB SEA69D0145Accident · No injuriesClosedPiper PA-22 · Leadore, IDNov 28, 1968 · N4807Z · Substantial damage NTSB SEA69D0154Accident · Minor injuriesClosedStearman A75 · Deary, IDNov 27, 1968 · N5685N · Substantial damage NTSB SEA69F0134Accident · No injuriesClosedCessna 182 · Lewiston, IDNov 23, 1968 · N5070D · Substantial damage NTSB SEA69D0138Accident · No injuriesClosedBeech B95A · Hailey, IDNov 18, 1968 · N1301Z · Substantial damage NTSB SEA69D0139Accident · No injuriesClosedCessna 120 · Cataldo, IDNov 9, 1968 · N2439N · Substantial damage NTSB SEA69D0141Accident · No injuriesClosedLuscombe 8A · Sandpoint, IDNov 4, 1968 · N2087K · Substantial damage NTSB CHI69D0369Accident · No injuriesClosedCessna 182 · Evansville, IDNov 1, 1968 · N3317F · Substantial damage NTSB SEA69D0127Accident · No injuriesClosedCessna 182 · Yellow Pine, IDOct 27, 1968 · N2324R · Substantial damage NTSB SEA69A0025Accident · 3 fatalClosedPiper PA-28 · Cataldo, IDOct 22, 1968 · N1740J · Destroyed NTSB SEA69A0024Accident · 1 fatalClosedCessna 310C · Burley, IDOct 17, 1968 · N1761H · Substantial damage NTSB SEA69D0113Accident · No injuriesClosedStinson 108-3 · Gooding, IDOct 13, 1968 · N4017C · Substantial damage NTSB SEA69D0112Accident · No injuriesClosedBeech 35 · Burley, IDOct 7, 1968 · N4242Y · Destroyed NTSB SEA69D0116Accident · No injuriesClosedCessna 150 · Orofino, IDSep 28, 1968 · N8567G · Substantial damage NTSB SEA69D0107Accident · No injuriesClosedCessna 185 · Elk City, IDSep 22, 1968 · N9989X · Substantial damage NTSB SEA68D0103Accident · No injuriesClosedCessna 177 · Malad City, IDSep 22, 1968 · N29319 · Substantial damage NTSB SEA69A0020Accident · 4 fatalClosedCessna 180 · Big Creek, IDSep 8, 1968 · N7940V · Destroyed NTSB SEA69F0085Accident · No injuriesClosedCessna 210 · Boise, IDSep 4, 1968 · N3735Y · Substantial damage NTSB SEA69F0084Accident · No injuriesClosedBeech K35 · Boise, IDSep 3, 1968 · N630Q · Substantial damage NTSB SEA69D0097Accident · No injuriesClosedCessna 150G · Juniper, IDSep 3, 1968 · N4814X · Substantial damage NTSB SEA69D0088Accident · No injuriesClosedPiper PA-16 · Sandpoint, IDAug 31, 1968 · N6826K · Substantial damage NTSB SEA69D0083Accident · No injuriesClosedCessna 177 · Montpelier, IDAug 25, 1968 · N2866X · Substantial damage NTSB SEA69D0093Accident · Minor injuriesClosedSchweizer SGS126 · Hailey, IDAug 24, 1968 · N2736Z · Substantial damage NTSB SEA69D0079Accident · No injuriesClosedSchweizer SGS2-8 · Boise, IDAug 24, 1968 · N50796 · Substantial damage NTSB SEA69D0067Accident · Minor injuriesClosedCessna 170 · Stanley, IDAug 13, 1968 · N68586 · Substantial damage NTSB SEA69A0012Accident · No injuriesClosedBell 47G-3B · Twin Falls, IDAug 13, 1968 · N8491E · Substantial damage NTSB SEA69D0071Accident · 1 fatalClosedBeech A23-19 · Mccall, IDAug 12, 1968 · N4831B · Substantial damage NTSB SEA69D0066Accident · No injuriesClosedPiper PA-28 · Montpelier, IDAug 12, 1968 · N6043W · Substantial damage NTSB SEA69D0057Accident · No injuriesClosedBell 47G3B1 · Garden Valley, IDAug 11, 1968 · N73972 · Destroyed NTSB SEA69F0065Accident · 1 fatalClosedGrumman TBF · Graham, IDAug 9, 1968 · N5635N · Destroyed NTSB SEA69F0074Accident · Serious injuriesClosedMooney M20F · Bernard, IDAug 2, 1968 · N6340Q · Destroyed NTSB SEA69D0052Accident · No injuriesClosedCallair A-9 · Osgood, IDAug 1, 1968 · N7243V · Destroyed NTSB SEA69D0080Accident · No injuriesClosedPiper PA-28 · Oakley, IDJul 30, 1968 · N9163W · Substantial damage NTSB SEA69D0043Accident · No injuriesClosedHiller UH-12E · Rockford, IDJul 27, 1968 · N4414 · Substantial damage NTSB SEA69D0048Accident · No injuriesClosedConvair L-13 · Genesee, IDJul 23, 1968 · N66370 · Substantial damage NTSB SEA69A0008Accident · 1 fatalClosedBell 47G3B1 · North Fork, IDJul 23, 1968 · N8537F · Destroyed NTSB SEA69F0106Accident · 1 fatalClosedPitts Spec · Arco, IDJul 21, 1968 · N86G · Destroyed NTSB SEA69D0038Accident · No injuriesClosedErcoupe 415-C · Nampa, IDJul 20, 1968 · N87283 · Substantial damage NTSB SEA69D0018Accident · No injuriesClosedPiper PA-25 · Glenns Ferry, IDJul 2, 1968 · N4609Y · Destroyed NTSB SEA68A0074Accident · Minor injuriesClosedBell 47G3B1 · Lewiston, IDJun 27, 1968 · N73284 · Destroyed NTSB SEA68A0073Accident · 3 fatalClosedBeech G35 · Potlatch, IDJun 22, 1968 · N4497D · Destroyed NTSB SEA69D0008Accident · No injuriesClosedCallair A-9 · Fort Hall, IDJun 20, 1968 · N7235V · Substantial damage NTSB SEA68D0329Accident · Minor injuriesClosedCessna 150G · Rigby, IDJun 10, 1968 · N2455J · Substantial damage NTSB SEA68D0328Accident · No injuriesClosedSchweizer 222E · Horseshoe Bend, IDJun 9, 1968 · N9943J · Substantial damage NTSB SEA68A0071Accident · 1 fatalClosedBell 47G3B1 · Bonners Ferry, IDJun 7, 1968 · N1323X · Destroyed NTSB SEA68D0330Accident · No injuriesClosedCallair A-9 · Inkon, IDJun 5, 1968 · N8262H · Substantial damage NTSB SEA69D0017Accident · No injuriesClosedCessna 205 · Gooding, IDJun 1, 1968 · N4810U · Substantial damage NTSB SEA68F0327Accident · No injuriesClosedPiper PA-25 · Tabor, IDJun 1, 1968 · N7236Z · Substantial damage NTSB SEA68D0309Accident · No injuriesClosedPiper PA-12 · Grangeville, IDMay 22, 1968 · N2402M · Substantial damage NTSB SEA68D0308Accident · No injuriesClosedPiper PA-18 · Pocatello, IDMay 20, 1968 · N8489D · Substantial damage