Skip to content

Final NTSB investigations, ND

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, newest first

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 c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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 c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
  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 c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
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 MKC78DTG10Accident · No injuriesClosedCessna A188B · Wahpeton, NDJun 14, 1978 · N4794Q · Substantial damage NTSB MKC78FTG09Accident · 1 fatalClosedCessna 188B · Sheyenne, NDJun 3, 1978 · N84677 · Destroyed NTSB MKC78FTG08Accident · No injuriesClosedBeech C55 · Grand Forks, NDJun 1, 1978 · N101CU · Destroyed NTSB MKC78FTG07Accident · No injuriesClosedFairchild FH1100 · Larimore, NDMay 22, 1978 · N82791 · Destroyed NTSB MKC78FA036Accident · 1 fatalClosedBeech UC45J · Spiritwood, NDMay 2, 1978 · N94460 · Destroyed NTSB MKC78FA033Accident · 2 fatalClosedBeech A24R · Mandan, NDApr 17, 1978 · N8051R · Destroyed NTSB MKC78FTG05Accident · No injuriesClosedCessna 150 · Minot, NDMar 31, 1978 · CFESS · Substantial damage NTSB MKC78FA028Accident · 4 fatalClosedPiper PA-32R · Belfield, NDMar 15, 1978 · N75089 · Destroyed NTSB MKC78DTG04Accident · No injuriesClosedPiper PA-22 · Pembina, NDMar 8, 1978 · CFEAT · Substantial damage NTSB MKC78FTG03Accident · No injuriesClosedCessna 150K · Cavalier, NDFeb 16, 1978 · N5785G · Substantial damage NTSB MKC78FA022Accident · 1 fatalClosedBeech D95A · Amidon, NDFeb 7, 1978 · N88GS · Destroyed NTSB MKC78FA021Accident · 2 fatalClosedChampion 7EC · Marmarth, NDJan 21, 1978 · N8931R · Destroyed NTSB MKC78DTG02Accident · No injuriesClosedCessna R172K · Dickinson, NDNov 26, 1977 · N736EM · Substantial damage NTSB MKC78FTG01Accident · Minor injuriesClosedCessna 172F · Fargo, NDNov 15, 1977 · N8669U · Substantial damage NTSB MKC77FA038Accident · 1 fatalClosedPiper PA-18 · Jamestown, NDSep 6, 1977 · N1168A · Destroyed NTSB MKC77FTG11Accident · No injuriesClosedLuscombe 8A · Reynolds, NDAug 27, 1977 · N72082 · Substantial damage NTSB MKC77FTG10Accident · Minor injuriesClosedBoeing A75N1 · Grand Forks, NDJul 15, 1977 · N59249 · Substantial damage NTSB MKC77FTG09Accident · No injuriesClosedCessna 182G · West Fargo, NDJul 7, 1977 · N2020R · Substantial damage NTSB MKC77DTG08Accident · No injuriesClosedPiper J-3 · Kenmare, NDJun 5, 1977 · N32668 · Substantial damage NTSB MKC77FTG07Accident · Serious injuriesClosedMooney M20F · Lawton, NDMay 20, 1977 · N9510M · Destroyed NTSB MKC77FTG06Accident · No injuriesClosedCessna 305A · Minot, NDMay 16, 1977 · N5303G · Substantial damage NTSB MKC77FTG05Accident · Serious injuriesClosedCessna 172 · Stanton, NDMay 14, 1977 · N7778X · Substantial damage NTSB MKC77FTG04Accident · No injuriesClosedCessna 185 · Bismarck, NDApr 27, 1977 · N102WC · Substantial damage NTSB MKC77DTG03Accident · No injuriesClosedCessna 150 · Wahpeton, NDFeb 27, 1977 · N704XG · Substantial damage NTSB MKC77FTG02Accident · No injuriesClosedCessna 172F · Driscoll, NDFeb 11, 1977 · N8358U · Substantial damage NTSB MKC77DTG01Accident · No injuriesClosedCessna 150 · Keene, NDDec 18, 1976 · N8563J · Substantial damage NTSB MKC76FTG28Accident · Serious injuriesClosedChampion 7GCBC · Rhame, NDSep 25, 1976 · N5164X · Destroyed NTSB MKC76FTG27Accident · No injuriesClosedPiper PA-28 · Maddock, NDAug 24, 1976 · N4405T · Substantial damage NTSB MKC76FTG26Accident · 1 fatalClosedGrumman G-164A · Minto, NDAug 19, 1976 · N9920 · Destroyed NTSB MKC76AK077Accident · 4 fatalClosedCessna 172 · Mandan, NDAug 16, 1976 · N3783F · Destroyed NTSB MKC76DTG24Accident · No injuriesClosedGrumman G-164A · Cavalier, NDJul 19, 1976 · N600T · Substantial damage NTSB MKC76FTG25Accident · No injuriesClosedPiper PA-28 · Minot, NDJul 18, 1976 · N41661 · Substantial damage NTSB MKC76FTG23Accident · No injuriesClosedCessna T210G · Flasher, NDJul 2, 1976 · N6863R · Substantial damage NTSB MKC76FTG22Accident · Serious injuriesClosedCessna A188B · Langdon, NDJun 28, 1976 · N9622G · Substantial damage NTSB MKC76DTG19Accident · Minor injuriesClosedCessna 150M · Rolette, NDJun 28, 1976 · N3749V · Substantial damage NTSB MKC76DTG20Accident · No injuriesClosedCallair A9B · Minot, NDJun 25, 1976 · N2851F · Destroyed NTSB MKC76DTG21Accident · Serious injuriesClosedPiper PA-25 · Mcleod, NDJun 18, 1976 · N6714Z · Destroyed NTSB MKC76AK061Accident · 1 fatalClosedCallair A-9 · Larimore, NDJun 18, 1976 · N3588G · Destroyed NTSB MKC76DTG17Accident · No injuriesClosedCessna 185 · Devils Lake, NDJun 14, 1976 · N1096F · Substantial damage NTSB MKC76FTG18Accident · No injuriesClosedCessna 207 · Fargo, NDJun 12, 1976 · N1688U · Substantial damage NTSB MKC76DTG16Accident · No injuriesClosedPiper PA-18 · Crosby, NDJun 10, 1976 · N9661P · Substantial damage NTSB MKC76AK059Accident · 4 fatalClosedCessna 182 · Dickinson, NDJun 8, 1976 · C-GOMA · Destroyed NTSB MKC76DTG15Accident · No injuriesClosedBellanca 8GCBC · New Leipzig, NDApr 29, 1976 · N53819 · Substantial damage NTSB MKC76DTG14Accident · Minor injuriesClosedPiper PA-36 · Argusville, NDApr 22, 1976 · N57580 · Destroyed NTSB MKC76DTG13Accident · No injuriesClosedPiper PA-18 · Napoleon, NDMar 15, 1976 · N54190 · Substantial damage NTSB MKC76AK044Accident · Serious injuriesClosedCessna 182P · Rolla, NDFeb 19, 1976 · N9872G · Destroyed NTSB MKC76AK039Accident · 1 fatalClosedMooney M20F · Lakota, NDJan 23, 1976 · N7746M · Destroyed NTSB MKC76FK035Accident · 2 fatalClosedAeronca 11CC · Elgin, NDDec 28, 1975 · N4131E · Substantial damage NTSB MKC76DTG12Accident · Serious injuriesClosedBellanca 7ECA · Goodrich, NDDec 21, 1975 · N90992 · Minor damage NTSB MKC76DTG11Accident · No injuriesClosedBellanca 8KCAB · Minot, NDNov 8, 1975 · N62979 · Substantial damage