Fatal NTSB investigations, 1978, ND

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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

Fatal NTSB investigations, 1978, ND per year, 1964–2026: 129 cases
1964	4
1965	7
1966	2
1967	5
1968	2
1969	2
1970	3
1971	5
1972	3
1973	2
1974	4
1975	5
1976	5
1977	1
1978	7
1979	3
1980	2
1981	6
1982	3
1983	1
1984	2
1986	3
1987	1
1989	1
1990	4
1991	2
1992	4
1994	1
1995	3
1996	1
1997	1
1998	4
1999	2
2000	1
2001	2
2002	1
2004	2
2005	1
2006	2
2007	1
2008	1
2009	1
2011	1
2012	2
2014	1
2016	2
2017	1
2018	2
2020	2
2021	2
2023	2
2026	1

Where

Open the map

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") = 1978 AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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\") = 1978
    AND c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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") = 1978
  AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
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 MKC78FA054Accident · 1 fatalClosedCessna 175B · Turtle Lake, NDJul 9, 1978 · N8126T · Destroyed NTSB MKC78FTG09Accident · 1 fatalClosedCessna 188B · Sheyenne, NDJun 3, 1978 · N84677 · Destroyed NTSB MKC78FA036Accident · 1 fatalClosedBeech UC45J · Spiritwood, NDMay 2, 1978 · N94460 · Destroyed NTSB MKC78FA033Accident · 2 fatalClosedBeech A24R · Mandan, NDApr 17, 1978 · N8051R · Destroyed NTSB MKC78FA028Accident · 4 fatalClosedPiper PA-32R · Belfield, NDMar 15, 1978 · N75089 · Destroyed NTSB MKC78FA022Accident · 1 fatalClosedBeech D95A · Amidon, NDFeb 7, 1978 · N88GS · Destroyed NTSB MKC78FA021Accident · 2 fatalClosedChampion 7EC · Marmarth, NDJan 21, 1978 · N8931R · Destroyed