Skip to content

NTSB investigations, 1967, ND

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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, ND per year, 1964–2026: 1,129 cases
1964	32
1965	51
1966	49
1967	44
1968	50
1969	35
1970	33
1971	33
1972	23
1973	28
1974	27
1975	24
1976	22
1977	13
1978	21
1979	17
1980	21
1981	25
1982	29
1983	24
1984	27
1985	22
1986	30
1987	34
1988	5
1989	13
1990	18
1991	14
1992	17
1993	14
1994	24
1995	18
1996	18
1997	16
1998	22
1999	11
2000	12
2001	13
2002	7
2003	10
2004	8
2005	12
2006	14
2007	15
2008	7
2009	10
2010	8
2011	13
2012	13
2013	4
2014	6
2015	6
2016	9
2017	3
2018	10
2019	5
2020	6
2021	6
2022	7
2023	10
2024	4
2025	5
2026	2

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" = 'ND' 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\" = 'ND' 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" = 'ND' 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 MKC68F0418Accident · No injuriesClosedCessna 170 · Tioga, NDDec 24, 1967 · N1298D · Substantial damage NTSB MKC68F0396Accident · No injuriesClosedPiper PA-22 · Enderlin, NDDec 23, 1967 · N6054D · Substantial damage NTSB MKC68F0340Accident · No injuriesClosedCessna 172 · Gwinner, NDNov 23, 1967 · N8170L · Substantial damage NTSB MKC68D0354Accident · Minor injuriesClosedPiper PA-22 · Bismarck, NDNov 11, 1967 · N3223Z · Substantial damage NTSB MKC68F0323Accident · No injuriesClosedPiper J-3 · Douglas, NDOct 13, 1967 · N88186 · Substantial damage NTSB MKC68F0292Accident · No injuriesClosedPiper PA-22 · New Town, NDOct 3, 1967 · N3560A · Substantial damage NTSB MKC68F0233Accident · Minor injuriesClosedChampion ECA · Jamestown, NDOct 1, 1967 · N9976Y · Substantial damage NTSB MKC68F0303Accident · No injuriesClosedAeronca 65-TC · Langdon, NDSep 25, 1967 · N31794 · Substantial damage NTSB MKC68A0025Accident · 2 fatalClosedChampion 7ECA · Minot, NDSep 21, 1967 · N8328V · Destroyed NTSB MKC68F0232Accident · Minor injuriesClosedCessna 172 · Mercer, NDSep 10, 1967 · N8165B · Substantial damage NTSB MKC68F0290Accident · No injuriesClosedPiper PA-24 · Ashley, NDSep 3, 1967 · N5088P · Substantial damage NTSB MKC68F0330Accident · Minor injuriesClosedChampion 7AC · Rugby, NDAug 20, 1967 · N84045 · Substantial damage NTSB MKC68A0011Accident · No injuriesClosedPiper PA-24 · Grand Forks, NDAug 16, 1967 · N8803P · Substantial damage NTSB MKC68F0158Accident · Serious injuriesClosedPiper PA-28 · Napoleon, NDAug 14, 1967 · N8727W · Substantial damage NTSB MKC68F0151Accident · No injuriesClosedTaylorcraft BC12-D · Rolette, NDAug 4, 1967 · N43612 · Substantial damage NTSB MKC68F0114Accident · 1 fatalClosedPiper PA-28 · West Fargo, NDJul 27, 1967 · N8347R · Destroyed NTSB MKC68F0095Accident · No injuriesClosedCessna 172 · Devils Lake, NDJul 22, 1967 · N6225E · No damage NTSB MKC68A0005Accident · No injuriesClosedBeech C-18S · Grand Forks, NDJul 15, 1967 · N61388 · Substantial damage NTSB MKC68F0096Accident · No injuriesClosedAeronca 11AC · Grafton, NDJul 10, 1967 · N3619E · Substantial damage NTSB MKC68D0116Accident · No injuriesClosedCessna 140 · Rutland, NDJul 10, 1967 · N81065 · Substantial damage NTSB MKC68F0077Accident · No injuriesClosedPiper PA-11 · Chaffee, NDJul 8, 1967 · N4923M · Destroyed NTSB MKC68F0125Accident · No injuriesClosedPiper PA-25 · Regent, NDJul 7, 1967 · N6035Z · Substantial damage NTSB MKC68F0075Accident · No injuriesClosedBeech V35 · Fargo, NDJul 3, 1967 · N911V · Substantial damage NTSB MKC68F0101Accident · Minor injuriesClosedPiper PA-18 · Lidgerwood, NDJun 30, 1967 · N3781P · Destroyed NTSB MKC68F0120Accident · Minor injuriesClosedPiper PA-11 · N.Rockford, NDJun 26, 1967 · N4758H · Substantial damage NTSB MKC67A0087Accident · 1 fatalClosedPiper PA-11 · Fessenden, NDJun 26, 1967 · N5018H · Destroyed NTSB MKC68F0064Accident · No injuriesClosedPiper PA-25 · Harvey, NDJun 22, 1967 · N6248Z · Substantial damage NTSB MKC68F0063Accident · Serious injuriesClosedPiper PA-18 · Grand Forks, NDJun 17, 1967 · N4067Z · Substantial damage NTSB MKC68F0057Accident · No injuriesClosedMooney M20C · Minot, NDJun 10, 1967 · N3386X · Substantial damage NTSB MKC67A0079Accident · 1 fatalClosedCessna 337A · Medora, NDJun 10, 1967 · N5376S · Destroyed NTSB MKC67F0615Accident · Minor injuriesClosedCessna 180 · Westfield, NDMay 19, 1967 · N133ND · Substantial damage NTSB MKC67D0573Accident · No injuriesClosedCessna 170 · Larimore, NDMay 4, 1967 · N8105A · Substantial damage NTSB MKC67D0512Accident · No injuriesClosedAeronca 7AC · Bowman, NDMay 2, 1967 · N81782 · Substantial damage NTSB MKC68D0061Accident · No injuriesClosedCessna 140 · Harvey, NDApr 25, 1967 · N2063V · Substantial damage NTSB MKC67F0492Accident · No injuriesClosedErcoupe 415C · Devils Lake, NDMar 26, 1967 · N2850H · Substantial damage NTSB MKC67D0516Accident · No injuriesClosedPiper PA-28 · Cooperstown, NDMar 23, 1967 · N9282J · Substantial damage NTSB MKC67A0054Accident · 1 fatalClosedCessna 150F · Argusville, NDMar 9, 1967 · N6890F · Substantial damage NTSB MKC67F0458Accident · No injuriesClosedCessna 182 · Edgeley, NDMar 5, 1967 · N3521U · Substantial damage NTSB MKC67D0461Accident · No injuriesClosedPiper PA-23 · Wahpeton, NDFeb 26, 1967 · N5925Y · Substantial damage NTSB MKC67D0459Accident · No injuriesClosedPiper PA-22 · Grand Forks, NDFeb 3, 1967 · N5136Z · Substantial damage NTSB MKC67A0046Accident · No injuriesClosedCessna 205 · Minot, NDFeb 3, 1967 · N8309Z · No damage NTSB MKC67D0521Accident · No injuriesClosedPiper PA-18 · Wabek, NDJan 25, 1967 · N4253Z · Substantial damage NTSB MKC67F0442Accident · No injuriesClosedPiper PA-20 · Wimbledon, NDJan 11, 1967 · N5598H · Substantial damage NTSB MKC67D0377Accident · No injuriesClosedAeronca 7AC · Cooperstown, NDJan 11, 1967 · N84323 · Substantial damage