Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 MKC66D0338Accident · No injuriesClosedCessna 182 · Lisbon, NDDec 8, 1965 · N8575T · Substantial damage NTSB MKC66F0374Accident · No injuriesClosedCessna 120 · Grand Forks, NDDec 5, 1965 · N76219 · Substantial damage NTSB MKC66D0426Accident · No injuriesClosedCessna 182 · Rolette, NDNov 23, 1965 · N8483T · Substantial damage NTSB MKC66F0226Accident · Minor injuriesClosedRyan PT-22 · Valley City, NDNov 21, 1965 · N46751 · Substantial damage NTSB MKC66D0404Accident · No injuriesClosedLuscombe 8A · Fessenden, NDNov 21, 1965 · N77859 · Substantial damage NTSB MKC66F0295Accident · No injuriesClosedCessna 180 · West Fargo, NDNov 9, 1965 · N555F · Substantial damage NTSB MKC66F0316Accident · No injuriesClosedCessna 210D · Fargo, NDNov 4, 1965 · N3764Y · Substantial damage NTSB MKC66F0321Accident · No injuriesClosedPiper PA-18 · Hope, NDNov 2, 1965 · N1098A · Substantial damage NTSB MKC66F0271Accident · Minor injuriesClosedCessna 150 · Grand Forks, NDOct 4, 1965 · N2085Z · 2 aircraft · Substantial damage NTSB MKC66F0255Accident · No injuriesClosedCessna 140 · Michigan, NDSep 19, 1965 · N89525 · Substantial damage NTSB MKC66F0241Accident · No injuriesClosedMaule M-4 · Minot, NDSep 13, 1965 · N4602T · Substantial damage NTSB MIA66A0015Accident · 2 fatalClosedAeronca 7AC · Rolla, NDSep 7, 1965 · N1721E · Destroyed NTSB MKC66F0243Accident · No injuriesClosedPiper PA-24 · Ashley, NDAug 27, 1965 · N7314P · Substantial damage NTSB MKC66F0218Accident · No injuriesClosedCessna 140 · Grand Forks, NDAug 21, 1965 · N2302N · Substantial damage NTSB MKC66F0196Accident · No injuriesClosedBeechraft 35 · Stanley, NDAug 15, 1965 · N3841N · Substantial damage NTSB MKC66F0147Accident · No injuriesClosedPiper PA-16 · Max, NDAug 14, 1965 · N5389H · Substantial damage NTSB UNK65X1525Accident · No injuriesClosedCessna 170A · Mandan, NDAug 13, 1965 · CF-GPU · Substantial damage NTSB MKC66F0129Accident · No injuriesClosedBoeing A75 · Grand Forks, NDAug 11, 1965 · N62598 · Substantial damage NTSB MKC66F0142Accident · No injuriesClosedCessna 140 · Williston, NDAug 7, 1965 · N3075N · Substantial damage NTSB MKC66F0170Accident · No injuriesClosedPiper PA-18 · Bathgate, NDJul 28, 1965 · N3572Z · Substantial damage NTSB MKC66F0197Accident · No injuriesClosedLuscombe 8A · Minot, NDJul 18, 1965 · N1136K · Substantial damage NTSB MKC66A0004Accident · 1 fatalClosedCallair A-9 · Souris, NDJul 14, 1965 · N3569G · Substantial damage NTSB MKC66F0082Accident · Serious injuriesClosedPiper PA-11 · Emmet, NDJul 7, 1965 · N4990H · Destroyed NTSB MKC66F0186Accident · Minor injuriesClosedPiper PA-22 · Edgeley, NDJul 4, 1965 · N7118D · Substantial damage NTSB MKC66F0169Accident · No injuriesClosedPiper PA-11 · Amidon, NDJul 3, 1965 · N8769 · Substantial damage NTSB MKC66F0106Accident · No injuriesClosedPiper PA-18 · Park River, NDJul 2, 1965 · N9925D · Substantial damage NTSB DEN66A0002Accident · 1 fatalClosedPiper PA-14 · Jamestown, NDJul 2, 1965 · N4298H · Destroyed NTSB DEN65A0088Accident · 1 fatalClosedPiper PA18 · Carpio, NDJun 30, 1965 · N8186D · Destroyed NTSB MKC66F0148Accident · Serious injuriesClosedPiper PA-11 · Bisbee, NDJun 29, 1965 · N78765 · Substantial damage NTSB MKC66F0124Accident · No injuriesClosedCessna 150 · Hatton, NDJun 27, 1965 · N2074Z · Substantial damage NTSB MKC66D0360Accident · No injuriesClosedPiper PA-18A · Lefor, NDJun 25, 1965 · N2688P · Substantial damage NTSB MKC66D0185Accident · No injuriesClosedCessna 180 · Mcville, NDJun 25, 1965 · N2192Z · Substantial damage NTSB MKC66F0113Accident · Serious injuriesClosedPiper PA-18 · Binford, NDJun 19, 1965 · N4377A · Destroyed NTSB MKC66F0041Accident · Serious injuriesClosedPiper PA-11 · Churchsferry, NDJun 16, 1965 · N4842M · Substantial damage NTSB MKC66F0050Accident · No injuriesClosedPiper PA-28 · Grand Forks, NDJun 7, 1965 · N8597W · Substantial damage NTSB MKC66F0042Accident · No injuriesClosedCessna 180 · Mapes, NDJun 1, 1965 · N3253D · Substantial damage NTSB MKC66D0026Accident · No injuriesClosedCessna 150 · Michigan, NDMay 22, 1965 · N6520T · Substantial damage NTSB MKC65A0068Accident · Serious injuriesClosedBell 47J2 · Grand Forks, NDMay 22, 1965 · N253PH · Destroyed NTSB MKC65D0151Accident · No injuriesClosedCessna 180F · Nekoma, NDMay 13, 1965 · N2166Z · Substantial damage NTSB MKC66F0030Accident · No injuriesClosedCessna 180 · Williston, NDMay 6, 1965 · N5095E · Substantial damage NTSB MKC66F0179Accident · No injuriesClosedCessna 140A · Almo, NDApr 30, 1965 · N9619A · Substantial damage NTSB MKC65A0061Accident · 1 fatalClosedPiper PA-18 · Selfridge, NDApr 20, 1965 · N8178D · Destroyed NTSB MKC65A0058Accident · 2 fatalClosedPiper PA-23 · Grand Forks, NDApr 8, 1965 · N4021P · Destroyed NTSB MKC65F0044Accident · Minor injuriesClosedCessna 172 · Bartlett, NDFeb 27, 1965 · N8714B · Destroyed NTSB MKC65A0050Accident · 2 fatalClosedCessna 172D · Blaisdell, NDFeb 18, 1965 · N2460U · Destroyed NTSB MKC65D0058Accident · No injuriesClosedChampion 7FC · Lakota, NDFeb 6, 1965 · N8512E · Substantial damage NTSB MKC65D0050Accident · No injuriesClosedCessna 170B · Forman, NDFeb 6, 1965 · N3136A · Substantial damage NTSB MKC65D0048Accident · No injuriesClosedAeronca 15AC · Carson, NDFeb 5, 1965 · N1411H · Substantial damage NTSB MKC65F0030Accident · Minor injuriesClosedPiper PA-18 · Oakes, NDJan 21, 1965 · N1070A · Substantial damage NTSB MKC65F3003Accident · No injuriesClosedCessna 120 · Harvey, NDJan 16, 1965 · N76770 · Substantial damage