Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 SEA70A0027Accident · 2 fatalClosedCessna 182 · Boise, IDDec 22, 1969 · N5657B · Destroyed NTSB SEA40D0135Accident · Serious injuriesClosedPiper J-3 · Nez Perce, IDDec 16, 1969 · N33593 · Substantial damage NTSB SEA70D0120Accident · No injuriesClosedPiper PA-22 · Burley, IDDec 10, 1969 · N6729B · Substantial damage NTSB SEA70D0111Accident · Minor injuriesClosedCessna 150H · Oakley, IDNov 22, 1969 · N6653S · Destroyed NTSB SEA70F0117Accident · No injuriesClosedAero-Comdr 100 · Spirit Lake, IDNov 18, 1969 · N3871X · Substantial damage NTSB SEA70A0018Accident · 3 fatalClosedCessna 177 · Caldwell, IDOct 28, 1969 · N29461 · Destroyed NTSB SEA70D0101Accident · No injuriesClosedCessna 140 · Eagle, IDOct 23, 1969 · N89290 · Destroyed NTSB SEA70D0091Accident · No injuriesClosedCessna 150 · Idaho Falls, IDOct 13, 1969 · N6421F · Substantial damage NTSB SEA70D0104Accident · No injuriesClosedPiper PA-28 · Lewiston, IDOct 10, 1969 · N7098R · Substantial damage NTSB SEA70F0114Accident · No injuriesClosedCessna 182 · Mccall, IDSep 18, 1969 · N71136 · Substantial damage NTSB SEA70F0080Accident · Serious injuriesClosedHiller FH1100 · Boise, IDSep 10, 1969 · N376FH · Substantial damage NTSB SEA70D0072Accident · No injuriesClosedBell 47G-2 · Wilder, IDAug 31, 1969 · N10194 · Destroyed NTSB SEA70D0068Accident · No injuriesClosedCessna 150 · Twin Falls, IDAug 31, 1969 · N3907J · Substantial damage NTSB SEA70A0011Accident · 3 fatalClosedCessna 180 · Harrison, IDAug 24, 1969 · N3633C · Destroyed NTSB SEA70F0071Accident · No injuriesClosedPiper PA-24 · Grangeville, IDAug 20, 1969 · N8559P · Substantial damage NTSB SEA70F0057Accident · Minor injuriesClosedStinson 108-2 · Donnelly, IDAug 18, 1969 · N9664K · Substantial damage NTSB SEA70D0045Accident · Serious injuriesClosedPiper PA-25 · Lewisville, IDAug 14, 1969 · N6160Z · Destroyed NTSB SEA70D0048Accident · No injuriesClosedGrumman G-164A · Twin Falls, IDAug 9, 1969 · N654U · Substantial damage NTSB SEA70D0038Accident · No injuriesClosedCessna 180 · Boise, IDJul 31, 1969 · N4688U · Substantial damage NTSB SEA70A0006Accident · 6 fatalClosedCessna 210D · Boise, IDJul 30, 1969 · N3735Y · 2 aircraft · Destroyed NTSB SEA70D0039Accident · No injuriesClosedPiper PA-25 · Pocatello, IDJul 29, 1969 · N4860Y · Substantial damage NTSB SEA70D0030Accident · No injuriesClosedGrumman G-164 · Minidoka, IDJul 23, 1969 · N5270 · Destroyed NTSB SEA70D0036Accident · Minor injuriesClosedPiper PA-25 · Kimberly, IDJul 18, 1969 · N7738Z · Destroyed NTSB SEA70F0026Accident · No injuriesClosedCessna 180 · Buhl, IDJul 15, 1969 · N2963C · Substantial damage NTSB SEA70D0020Accident · No injuriesClosedPiper PA-28 · Stanley, IDJul 9, 1969 · N9340J · Substantial damage NTSB SEA70D0022Accident · No injuriesClosedCessna 336 · Coolin, IDJul 7, 1969 · N3845U · Substantial damage NTSB SEA70D0043Accident · Serious injuriesClosedCessna 150 · Grangeville, IDJul 4, 1969 · N8652G · Substantial damage NTSB SEA70F0008Accident · Serious injuriesClosedPiper PA-25 · Homedale, IDJun 22, 1969 · N6855Z · Destroyed NTSB SEA69D0269Accident · No injuriesClosedPiper PA-18A · Grasmere, IDJun 14, 1969 · N2891P · Substantial damage NTSB SEA69D0265Accident · No injuriesClosedPiper PA-18A · Weston, IDJun 6, 1969 · N8489D · Destroyed NTSB SEA69D0262Accident · No injuriesClosedCallair A-9 · Rexburg, IDJun 6, 1969 · N3608G · Substantial damage NTSB SEA69D0258Accident · No injuriesClosedFairchild M-62 · Bruneau, IDMay 22, 1969 · N56110 · Substantial damage NTSB SEA69D0245Accident · No injuriesClosedStearman A75 · Lewiston, IDMay 6, 1969 · N58712 · Substantial damage NTSB SEA69D0239Accident · No injuriesClosedCessna 210 · Wendell, IDMay 3, 1969 · N9447X · Substantial damage NTSB SEA69D0232Accident · No injuriesClosedMaule M4-210 · Dubois, IDMay 3, 1969 · N4621T · Substantial damage NTSB SEA69D0235Accident · No injuriesClosedStearman PT-17 · Craigmont, IDApr 26, 1969 · N5685N · Substantial damage NTSB SEA69D0222Accident · No injuriesClosedCessna 140 · Idaho Falls, IDApr 22, 1969 · N1926V · Substantial damage NTSB SEA69D0224Accident · No injuriesClosedCessna 140 · Kellogg, IDApr 14, 1969 · N76978 · Substantial damage NTSB SEA69D0230Accident · Serious injuriesClosedCessna 188 · Genesee, IDApr 11, 1969 · N8024V · Substantial damage NTSB SEA69D0205Accident · No injuriesClosedCessna 140 · Midvale, IDApr 10, 1969 · N72758 · Substantial damage NTSB SEA69D0219Accident · No injuriesClosedCessna 172C · Mccall, IDApr 9, 1969 · N8268X · Substantial damage NTSB SEA69D0225Accident · No injuriesClosedCessna 180 · Elk City, IDMar 25, 1969 · N2865A · Substantial damage NTSB SEA69A0047Accident · 1 fatalClosedBeech S35 · Leadore, IDMar 5, 1969 · N7914K · Substantial damage NTSB SEA69D0189Accident · No injuriesClosedPiper PA-22 · Coeur D Alene, IDFeb 23, 1969 · N3744P · Substantial damage NTSB SEA69D0172Accident · No injuriesClosedBeech K35 · Hailey, IDFeb 3, 1969 · N6023E · Substantial damage NTSB SEA69D0171Accident · No injuriesClosedCessna 182K · New Plymouth, IDJan 12, 1969 · N2538Q · Substantial damage NTSB SEA69A0038Accident · Serious injuriesClosedPiper PA-28 · Bellevue, IDJan 1, 1969 · N5163L · Substantial damage