Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MKC69D0335Accident · No injuriesClosedPiper PA-11 · Velva, NDDec 28, 1968 · N78816 · Substantial damage NTSB MKC69D0341Accident · No injuriesClosedPiper PA-18A · Fingal, NDDec 21, 1968 · N3350A · Substantial damage NTSB MKC69F0292Accident · No injuriesClosedBeech A45 · Valley City, NDNov 13, 1968 · N9087C · Substantial damage NTSB MKC69F0262Accident · No injuriesClosedCessna 172 · Cavalier, NDNov 11, 1968 · N1619F · Substantial damage NTSB MKC69F0330Accident · No injuriesClosedCessna 150G · Langdon, NDOct 22, 1968 · N2420J · Substantial damage NTSB MKC69F0280Accident · No injuriesClosedPiper PA-12 · Beach, NDOct 19, 1968 · N3191M · 2 aircraft · Substantial damage NTSB MKC69D0229Accident · No injuriesClosedPiper PA-28 · Crosby, NDOct 13, 1968 · N5553W · Substantial damage NTSB MKC69D0296Accident · Minor injuriesClosedPiper PA-22 · Devils Lake, NDOct 6, 1968 · N6054D · Substantial damage NTSB MKC69F0297Accident · No injuriesClosedPiper PA-11 · Harvey, NDOct 2, 1968 · N87986 · Substantial damage NTSB MKC69F0258Accident · No injuriesClosedPiper PA-28 · Mayville, NDSep 29, 1968 · N8007W · Substantial damage NTSB MKC69F0276Accident · Serious injuriesClosedMooney M20C · Kenmare, NDSep 24, 1968 · N1366W · Destroyed NTSB MKC69F0198Accident · No injuriesClosedCessna 140 · Fargo, NDAug 20, 1968 · N1648V · Substantial damage NTSB MKC69A0011Accident · Serious injuriesClosedPiper PA-32 · Hazen, NDAug 16, 1968 · N4172W · Destroyed NTSB MKC69D0228Accident · No injuriesClosedAeronca 11BC · Manfred, NDAug 11, 1968 · N4029E · Substantial damage NTSB MKC69F0145Accident · No injuriesClosedMooney M20C · Park River, NDAug 9, 1968 · N6334Q · Substantial damage NTSB MKC69D0184Accident · No injuriesClosedPiper PA-22 · Velva, NDAug 6, 1968 · N7717D · Substantial damage NTSB MKC69F0191Accident · No injuriesClosedBeech T-34A · Fargo, NDJul 25, 1968 · N9087C · Substantial damage NTSB MKC69F0093Accident · Minor injuriesClosedStinson 108-3 · Grassy Bute, NDJul 24, 1968 · N891C · Substantial damage NTSB MKC69F0127Accident · No injuriesClosedCessna 140 · Foxholm, NDJul 22, 1968 · N76579 · Substantial damage NTSB MKC69D0057Accident · Minor injuriesClosedStearman A75 · Northwood, NDJul 22, 1968 · N5578N · Destroyed NTSB MKC69D0128Accident · No injuriesClosedBeech S35 · Elgin, NDJul 21, 1968 · N8824M · Substantial damage NTSB MKC69D0053Accident · No injuriesClosedPiper PA-32 · Fairmount, NDJul 19, 1968 · N4067R · Substantial damage NTSB MKC69D0219Accident · No injuriesClosedCessna 150 · Fort Rice, NDJul 17, 1968 · N50059 · Substantial damage NTSB MKC69D0144Accident · No injuriesClosedAlon A-2 · Steele, NDJul 16, 1968 · N5478F · Substantial damage NTSB MKC69D0107Accident · No injuriesClosedPiper PA-28 · Hazen, NDJul 7, 1968 · N8994J · Substantial damage NTSB MKC69F0047Accident · No injuriesClosedPiper J3-65 · Carrington, NDJul 3, 1968 · N35228 · Substantial damage NTSB MKC69F0124Accident · No injuriesClosedSchweizer SGS233 · Dunseith, NDJun 29, 1968 · N5709S · Substantial damage NTSB MKC69F0094Accident · 1 fatalClosedPiper PA-18 · Edmore, NDJun 24, 1968 · N7787D · Destroyed NTSB MKC69D0003Accident · No injuriesClosedPiper PA-25 · Bismarck, NDJun 14, 1968 · N7208Z · Substantial damage NTSB MKC68A0071Accident · 1 fatalClosedLuscombe 8E · Cooperstown, NDJun 8, 1968 · N1801B · Destroyed NTSB MKC69F0036Accident · Serious injuriesClosedCessna 210-5 · Cleveland, NDJun 6, 1968 · N8307Z · Destroyed NTSB MKC69F0046Accident · No injuriesClosedCessna 195A · Minot, NDJun 3, 1968 · N1048D · Substantial damage NTSB MKC69D0020Accident · No injuriesClosedMooney M20E · Bottineau, NDJun 3, 1968 · N5570Q · Substantial damage NTSB MKC68F0572Accident · No injuriesClosedPiper PA-18 · Tyler, NDMay 29, 1968 · N4102Z · Destroyed NTSB MKC69F0049Accident · No injuriesClosedCessna 140A · Mandan, NDMay 24, 1968 · N9619A · Substantial damage NTSB MKC69D0001Accident · No injuriesClosedCessna 182 · Underwood, NDMay 22, 1968 · N2063G · Substantial damage NTSB MKC68D0600Accident · No injuriesClosedAeronca 7EC · Benedict, NDMay 17, 1968 · N4670E · Substantial damage NTSB MKC68F0581Accident · Minor injuriesClosedCessna 177 · Venturia, NDMay 12, 1968 · N3358T · Destroyed NTSB MKC68F0553Accident · No injuriesClosedAlon A-2A · Minot, NDMay 12, 1968 · N5470F · Substantial damage NTSB MKC69F0002Accident · No injuriesClosedCessna 150 · Fargo, NDMay 5, 1968 · N8525G · Substantial damage NTSB MKC68F0512Accident · No injuriesClosedCessna 150 · Grand Forks, NDApr 27, 1968 · N8642G · Substantial damage NTSB MKC68D0539Accident · No injuriesClosedPiper PA-28 · Langdon, NDApr 26, 1968 · N7526W · Substantial damage NTSB MKC68D0554Accident · No injuriesClosedN.American AT-6 · Minot, NDApr 23, 1968 · N55897 · Substantial damage NTSB MKC68F0577Accident · No injuriesClosedPiper PA-25 · Ft.Clark, NDApr 17, 1968 · N7017Z · Substantial damage NTSB MKC68F0557Accident · No injuriesClosedPiper PA-18A · Bucyrus, NDApr 8, 1968 · N3674P · Substantial damage NTSB MKC68F0465Accident · No injuriesClosedPiper PA-28 · Windsor, NDMar 1, 1968 · N7549W · Substantial damage NTSB MKC68D0496Accident · No injuriesClosedPiper PA-28 · Oakes, NDFeb 27, 1968 · N8687W · Substantial damage NTSB MKC68F0458Accident · No injuriesClosedPiper PA-22 · Minot, NDFeb 7, 1968 · N6936B · Substantial damage NTSB MKC68F0043Accident · No injuriesClosedPiper PA-28 · Langdon, NDJan 30, 1968 · N7000W · Substantial damage NTSB MKC68F0456Accident · No injuriesClosedCessna 310H · Minot, NDJan 6, 1968 · N1045Q · Substantial damage