Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 MKC67D0385Accident · No injuriesClosedPiper PA-18 · Kempton, NDDec 31, 1966 · N9469D · Substantial damage NTSB MKC67F0344Accident · No injuriesClosedCessna 150 · Cleveland, NDDec 22, 1966 · N5912E · Substantial damage NTSB MKC67F0365Accident · Serious injuriesClosedChampion 7AC · Jamestown, NDDec 20, 1966 · N82279 · Destroyed NTSB MKC67F0299Accident · No injuriesClosedBeech J35 · Grand Forks, NDNov 19, 1966 · N636T · Substantial damage NTSB MKC67F0313Accident · No injuriesClosedCessna 172H · Fargo, NDNov 17, 1966 · N1633F · Substantial damage NTSB MKC67F0358Accident · Minor injuriesClosedCessna 150A · Tioga, NDNov 5, 1966 · N7114X · Substantial damage NTSB UNK67X0105Accident · No injuriesClosedCessna 180 · Strasburg, NDOct 31, 1966 · N4775U · Substantial damage NTSB MKC67F0266Accident · No injuriesClosedPiper PA22 · Lisbon, NDOct 26, 1966 · N2306P · Substantial damage NTSB MKC67F0224Accident · No injuriesClosedPiper PA-22 · Grand Forks, NDSep 25, 1966 · N3625A · Substantial damage NTSB UNK66X0176Accident · No injuriesClosedCessna 120 · Grand Forks, NDSep 21, 1966 · N2428N · Substantial damage NTSB MKC67F0202Accident · No injuriesClosedErcoupe 415-C · Blaisdell, NDSep 10, 1966 · N28953 · Substantial damage NTSB MKC67D0203Accident · No injuriesClosedErcoupe 415-C · Langdon, NDSep 8, 1966 · N93364 · Substantial damage NTSB MKC67D0161Accident · No injuriesClosedCessna 195 · Dunseith, NDSep 4, 1966 · N1562D · Substantial damage NTSB MKC67A0020Accident · 1 fatalClosedBoeing A75 · Hatton, NDAug 31, 1966 · N75664 · Destroyed NTSB MKC67F0128Accident · No injuriesClosedCessna 172 · Gilby, NDJul 31, 1966 · N4124F · Substantial damage NTSB MKC67F0125Accident · No injuriesClosedCessna 172 · Rock Lake, NDJul 31, 1966 · N7423A · Substantial damage NTSB MKC67D0106Accident · No injuriesClosedPiper PA-28 · Bottineau, NDJul 30, 1966 · N6488R · Substantial damage NTSB MKC67F0359Accident · No injuriesClosedPiper PA-11 · N.Rockford, NDJul 27, 1966 · N4758H · Substantial damage NTSB MKC67D0126Accident · No injuriesClosedFunk F-23B · Devils Lake, NDJul 19, 1966 · N1132Z · Substantial damage NTSB MKC67F0040Accident · No injuriesClosedBeech S35 · Wahpeton, NDJul 12, 1966 · N198Q · Substantial damage NTSB MKC67D0096Accident · No injuriesClosedPiper PA-11 · Adams, NDJul 11, 1966 · N5023H · Destroyed NTSB MKC67F0075Accident · Minor injuriesClosedPiper PA-25 · Fargo, NDJun 28, 1966 · N7318Z · Substantial damage NTSB MKC67D0088Accident · No injuriesClosedPiper PA-18 · Marion, NDJun 24, 1966 · N3281Z · Substantial damage NTSB MKC67D0058Accident · No injuriesClosedPiper PA-24 · Stanton, NDJun 24, 1966 · N8573P · Substantial damage NTSB MKC67F0011Accident · No injuriesClosedPiper PA-18A · Elgin, NDJun 21, 1966 · N8995D · Substantial damage NTSB MKC67F0010Accident · No injuriesClosedPiper PA-25 · Jamestown, NDJun 21, 1966 · N7356Z · Substantial damage NTSB MKC67F0007Accident · Minor injuriesClosedPiper PA-11 · Grafton, NDJun 20, 1966 · N5012H · Destroyed NTSB MKC67F0046Accident · No injuriesClosedPiper J3C-65 · Regent, NDJun 19, 1966 · N42277 · Substantial damage NTSB MKC67F0034Accident · Serious injuriesClosedPiper J3C · New England, NDJun 19, 1966 · N37916 · Substantial damage NTSB MKC67F0127Accident · No injuriesClosedCessna 150 · Mandan, NDJun 18, 1966 · N6251R · Substantial damage NTSB MKC67F0020Accident · No injuriesClosedPiper PA-25 · Westhope, NDJun 18, 1966 · N6189Z · Substantial damage NTSB MKC67D0189Accident · No injuriesClosedPiper PA-25 · Rhame, NDJun 18, 1966 · N6203Z · Substantial damage NTSB MKC67D0004Accident · No injuriesClosedCessna 170 · Grand Forks, NDJun 16, 1966 · N5410C · Substantial damage NTSB MKC67F0019Accident · No injuriesClosedPiper PA-18 · Carrington, NDJun 14, 1966 · N6187D · Substantial damage NTSB MKC67D0039Accident · No injuriesClosedPiper J3C-65 · Mercer, NDJun 13, 1966 · N30948 · Substantial damage NTSB MKC66D0588Accident · No injuriesClosedNavion A · Minot, NDJun 2, 1966 · N4312K · Substantial damage NTSB MKC66D0561Accident · No injuriesClosedPiper PA-22 · Northwood, NDJun 1, 1966 · N8024D · Substantial damage NTSB MKC66F0589Accident · No injuriesClosedCessna 170 · Rocsglen, NDMay 24, 1966 · N1904C · Substantial damage NTSB MKC66A0057Accident · 1 fatalClosedPiper PA-18 · De Smet, NDMay 9, 1966 · N1962P · Destroyed NTSB MKC66F0511Accident · No injuriesClosedDowner 14-19 · Fargo, NDApr 29, 1966 · N8802R · Substantial damage NTSB MKC66A0051Accident · No injuriesClosedBrantly B-2 · Bismark, NDMar 5, 1966 · N5932X · Substantial damage NTSB MKC66D0466Accident · Minor injuriesClosedPiper PA-12 · Oakes, NDFeb 10, 1966 · N3015M · Substantial damage NTSB MKC66F0471Accident · No injuriesClosedPiper PA-18 · Upham, NDFeb 4, 1966 · N4724A · Substantial damage NTSB MKC66F0457Accident · Serious injuriesClosedPiper PA-11 · Hurdsfield, NDFeb 4, 1966 · N5021H · Substantial damage NTSB MKC66D0418Accident · No injuriesClosedAeronca 7AC · Kenmare, NDFeb 4, 1966 · N2774E · Substantial damage NTSB MKC66D0462Accident · No injuriesClosedPiper PA-28 · Cooperstown, NDFeb 2, 1966 · N5147W · Substantial damage NTSB MKC66D0417Accident · No injuriesClosedPiper PA-11 · Rugby, NDFeb 1, 1966 · N87986 · Substantial damage NTSB MKC66F0400Accident · No injuriesClosedPiper PA-30 · Minot, NDJan 28, 1966 · N7610Y · Substantial damage NTSB MKC66D0403Accident · No injuriesClosedPiper PA-18A · Jamestown, NDJan 24, 1966 · N1574P · Substantial damage