Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 SEA68D0221Accident · No injuriesClosedPiper PA-18 · Preston, IDDec 10, 1967 · N1148A · Substantial damage NTSB SEA68D0187Accident · No injuriesClosedCessna P206 · Grace, IDNov 4, 1967 · N2677X · Substantial damage NTSB SEA68D0186Accident · No injuriesClosedPiper PA-28 · Picabo, IDNov 2, 1967 · N6655W · Substantial damage NTSB SEA68D0183Accident · No injuriesClosedPiper PA-24 · Burley, IDOct 19, 1967 · N5109P · Substantial damage NTSB SEA68D0157Accident · No injuriesClosedNavion A · Burley, IDOct 13, 1967 · N91188 · Substantial damage NTSB SEA68D0145Accident · No injuriesClosedCessna 150 · Rexburg, IDOct 10, 1967 · N8292F · Substantial damage NTSB SEA68D0162Accident · Minor injuriesClosedTaylorcraft BC12-D · Ketchum, IDOct 6, 1967 · N95561 · Substantial damage NTSB SEA68A0028Accident · No injuriesClosedHiller UH-12E · Priest River, IDSep 27, 1967 · N90465 · Substantial damage NTSB SEA68D0146Accident · No injuriesClosedCessna 170A · Montpelier, IDSep 23, 1967 · N1351D · Substantial damage NTSB SEA68D0124Accident · No injuriesClosedBeech H35 · Caldwell, IDSep 13, 1967 · N5490D · Substantial damage NTSB SEA68D0090Accident · No injuriesClosedNavion A · Burley, IDSep 4, 1967 · N5123K · Substantial damage NTSB SEA68D0129Accident · No injuriesClosedCessna 182 · Bridge, IDSep 2, 1967 · N8644T · Substantial damage NTSB SEA68D0105Accident · No injuriesClosedPiper PA-32 · Stanley, IDSep 1, 1967 · N3669W · Substantial damage NTSB SEA68D0101Accident · No injuriesClosedGrumman TBM-3E · Elk City, IDAug 25, 1967 · N4173A · Substantial damage NTSB SEA68D0086Accident · No injuriesClosedGrumman G-164 · Jerome, IDAug 25, 1967 · N654U · Substantial damage NTSB SEA68D0104Accident · No injuriesClosedCessna 182 · Bovill, IDAug 24, 1967 · N3739U · Substantial damage NTSB SEA68D0100Accident · No injuriesClosedGrumman TBM · Grangeville, IDAug 23, 1967 · N68683 · Substantial damage NTSB SEA68D0108Accident · No injuriesClosedPiper PA-24 · Gannett, IDAug 20, 1967 · N6319P · Substantial damage NTSB SEA68A0017Accident · 2 fatalClosedCessna 170 · Avery, IDAug 17, 1967 · N3420C · Destroyed NTSB SEA68D0107Accident · No injuriesClosedGrumman TBM · Coeur D Alene, IDAug 14, 1967 · N7157C · Substantial damage NTSB SEA68D0074Accident · No injuriesClosedPiper PA-28 · Caldwell, IDAug 7, 1967 · N9225W · Substantial damage NTSB SEA68D0084Accident · No injuriesClosedWaco UMF · Mccall, IDAug 6, 1967 · N14076 · Substantial damage NTSB SEA68F0065Accident · No injuriesClosedCessna 172 · St.Maries, IDAug 3, 1967 · N4299L · Substantial damage NTSB SEA68D0113Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDAug 1, 1967 · N7049R · Substantial damage NTSB SEA68D0053Accident · No injuriesClosedPiper PA-23 · Caldwell, IDJul 31, 1967 · N6194Y · Substantial damage NTSB SEA68D0119Accident · Minor injuriesClosedCessna 182 · Downey, IDJul 30, 1967 · N6000B · Destroyed NTSB SEA68D0063Accident · No injuriesClosedPiper PA-18 · Burley, IDJul 25, 1967 · N73890 · Substantial damage NTSB SEA68F0060Accident · Minor injuriesClosedTaylorcraft DC-65 · Mountain Home, IDJul 21, 1967 · N62798 · Substantial damage NTSB SEA68D0035Accident · No injuriesClosedStinson 108 · Challis, IDJul 18, 1967 · N252C · Destroyed NTSB SEA68D0034Accident · No injuriesClosedPiper PA-18 · Challis, IDJul 14, 1967 · N4030Z · Substantial damage NTSB SEA68D0042Accident · Serious injuriesClosedFairchild PC-6CH · Mccall, IDJul 9, 1967 · N358F · Substantial damage NTSB SEA68D0041Accident · Minor injuriesClosedPiper PA-25 · Genesee, IDJul 5, 1967 · N4535Y · Destroyed NTSB SEA68D0117Accident · No injuriesClosedPiper PA-24 · Rockland, IDJul 3, 1967 · N7535P · Substantial damage NTSB SEA68F0024Accident · No injuriesClosedMooney M20C · Peck, IDJul 2, 1967 · N6822U · Substantial damage NTSB SEA68D0023Accident · No injuriesClosedCessna 182 · Elk River, IDJun 24, 1967 · N3200U · Substantial damage NTSB SEA67A0075Accident · 2 fatalClosedNavion L-17A · Ketchum, IDJun 21, 1967 · N9645C · Destroyed NTSB SEA68F0038Accident · No injuriesClosedNavion A · Mayfield, IDJun 20, 1967 · N91189 · Substantial damage NTSB SEA68D0036Accident · No injuriesClosedPiper PA-25 · Glenns Ferry, IDJun 19, 1967 · N7719Z · Destroyed NTSB SEA68D0005Accident · Minor injuriesClosedBoeing PT-17 · Idaho Falls, IDJun 19, 1967 · N58985 · Substantial damage NTSB MKC68F0382Accident · No injuriesClosedPiper PA-25 · Wardell, IDJun 19, 1967 · N6679Z · Substantial damage NTSB SEA68D0033Accident · No injuriesClosedNavion A · Twin Falls, IDJun 18, 1967 · N5562V · Substantial damage NTSB SEA67D0358Accident · No injuriesClosedCessna 185 · Gooding, IDJun 18, 1967 · N9862X · Substantial damage NTSB SEA67A0072Accident · 2 fatalClosedPiper PA-18 · Parma, IDJun 10, 1967 · N2879P · Destroyed NTSB SEA67D0338Accident · No injuriesClosedPiper PA-28 · Salmon, IDJun 3, 1967 · N9640J · Substantial damage NTSB SEA67D0349Accident · Minor injuriesClosedCallair A-9 · American Falls, IDJun 1, 1967 · N7210V · Destroyed NTSB SEA67D0340Accident · Minor injuriesClosedPiper PA-28 · Aberdeen, IDMay 31, 1967 · N4130U · Substantial damage NTSB SEA67D0351Accident · No injuriesClosedCallair A-9 · Arimo, IDMay 28, 1967 · N8270H · Substantial damage NTSB SEA67D0336Accident · No injuriesClosedPiper PA-18 · Malad City, IDMay 28, 1967 · N3599Z · Substantial damage NTSB SEA67D0318Accident · No injuriesClosedCessna 195A · Carey, IDMay 27, 1967 · N1512D · Substantial damage NTSB SEA67D0348Accident · No injuriesClosedPiper PA-18 · Burley, IDMay 22, 1967 · N7668D · Substantial damage