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 MKC74DTG10Accident · No injuriesClosedCessna 182 · Jamestown, NDOct 17, 1973 · N3336F · Substantial damage NTSB MKC74DTG08Accident · No injuriesClosedCessna 150 · Fargo, NDOct 16, 1973 · N1728Q · Substantial damage NTSB MKC74FTG07Accident · No injuriesClosedPiper PA-28 · Fargo, NDOct 10, 1973 · N8825N · Substantial damage NTSB MKC74AK016Accident · No injuriesClosedBeech D18S · Jamestown, NDOct 4, 1973 · N119L · Substantial damage NTSB MKC74FTG06Accident · Minor injuriesClosedAmer Avco AA-1B · Fargo, NDSep 25, 1973 · N9939L · Substantial damage NTSB MKC74DTG05Accident · Minor injuriesClosedCessna 140A · Minot, NDAug 14, 1973 · N1118P · Substantial damage NTSB MKC74DTG04Accident · No injuriesClosedCessna 150 · Mayville, NDAug 10, 1973 · N5956J · Substantial damage NTSB MKC74DK009Accident · No injuriesClosedCessna 182 · Hatton, NDJul 29, 1973 · N2352R · Substantial damage NTSB MKC74DTG02Accident · No injuriesClosedCessna 170 · Jamestown, NDJul 14, 1973 · N1949C · Substantial damage NTSB MKC74DTG01Accident · No injuriesClosedCessna 150 · Tuttle, NDJul 3, 1973 · N1743Q · Substantial damage NTSB MKC73DTG24Accident · No injuriesClosedPiper PA-28 · Minot, NDJun 29, 1973 · N8721N · Substantial damage NTSB MKC73DTG23Accident · No injuriesClosedPiper PA-18 · Sawyer, NDJun 28, 1973 · N7223K · Substantial damage NTSB MKC73DTG22Accident · No injuriesClosedCessna 140 · Grafton, NDJun 28, 1973 · CF-YNC · Substantial damage NTSB MKC73DTG21Accident · No injuriesClosedCessna 188 · Streeter, NDJun 25, 1973 · N8001V · Substantial damage NTSB IAD73DKM48Accident · Minor injuriesClosedGlasflugel H301B · Cherryville, NDJun 22, 1973 · N1811T · 2 aircraft · Substantial damage NTSB MKC73DTG20Accident · No injuriesClosedPiper PA-18 · Minto, NDJun 8, 1973 · N8999D · Substantial damage NTSB MKC73FTG19Accident · Minor injuriesClosedSirocco MJ5 · Minot, NDJun 6, 1973 · N213P · Substantial damage NTSB MKC73FTG18Accident · No injuriesClosedCessna 172 · Grand Forks, NDJun 4, 1973 · N5596R · Substantial damage NTSB MKC73FTG17Accident · No injuriesClosedStearman A75 · Northwood, NDMay 30, 1973 · N75664 · Substantial damage NTSB MKC73FTG16Accident · No injuriesClosedPiper PA-32 · Bismarck, NDMay 29, 1973 · N3340W · Substantial damage NTSB MKC73FTG15Accident · Minor injuriesClosedCessna 177A · Sterling, NDMay 27, 1973 · N30541 · Substantial damage NTSB MKC73DTG14Accident · No injuriesClosedPiper PA-25 · Kindred, NDMay 23, 1973 · N7308Z · Substantial damage NTSB MKC73DTG13Accident · No injuriesClosedCessna 172 · Grace City, NDMay 21, 1973 · N7423A · Substantial damage NTSB MKC73FTG12Accident · No injuriesClosedCessna 172 · Fargo, NDMay 3, 1973 · N1892Y · Substantial damage NTSB MKC73FTG11Accident · Serious injuriesClosedCessna 140 · Hillsboro, NDApr 22, 1973 · N1971N · Destroyed NTSB MKC73AK062Accident · 2 fatalClosedCessna 150L · Medinan, NDApr 16, 1973 · N5243Q · Destroyed NTSB MKC73FTG09Accident · No injuriesClosedPiper PA-23 · Grand Forks, NDDec 22, 1972 · CF-TWW · Substantial damage NTSB MKC73AK041Accident · 1 fatalClosedCessna 172K · Dickinson, NDDec 18, 1972 · N84887 · Destroyed NTSB MKC73FTG08Accident · No injuriesClosedCessna 150K · Cavalier, NDOct 13, 1972 · N5785G · Substantial damage NTSB MKC73AK023Accident · 2 fatalClosedPiper PA-28R · Lawton, NDSep 23, 1972 · N2900R · Destroyed NTSB MKC73FTG07Accident · No injuriesClosedPiper PA-20 · Nekoma, NDAug 30, 1972 · N6922K · Substantial damage NTSB MKC73FTG04Accident · No injuriesClosedPiper PA-20 · Jamestown, NDJul 30, 1972 · N7300K · Substantial damage NTSB MKC73FTG03Accident · No injuriesClosedCessna 170A · Mott, NDJul 28, 1972 · N9193A · Substantial damage NTSB MKC73DTG02Accident · No injuriesClosedCessna 120 · Kindred, NDJul 22, 1972 · N2510N · Substantial damage NTSB MKC73DTG01Accident · No injuriesClosedPiper PA-18 · Minot, NDJul 2, 1972 · N7585K · Substantial damage NTSB MKC73AK001Accident · 2 fatalClosedAmer Avco AA-1A · Oakes, NDJul 2, 1972 · N1SU · Destroyed NTSB MKC72FTG25Accident · Serious injuriesClosedChampion 7GCBC · Maddock, NDJun 29, 1972 · N9639S · Substantial damage NTSB MKC72FTG24Accident · No injuriesClosedPiper PA-28 · Lisbon, NDJun 22, 1972 · N9032W · Substantial damage NTSB MKC72FTG23Accident · No injuriesClosedBoeing A75N1 · Argusville, NDJun 20, 1972 · N51125 · Substantial damage NTSB MKC72DTC22Accident · No injuriesClosedCessna 172 · Woodworth, NDMay 26, 1972 · N3919Q · Substantial damage NTSB MKC72FTG21Accident · Serious injuriesClosedStinson 108-1 · Williston, NDMay 21, 1972 · N8639K · Substantial damage NTSB MKC72FTG20Accident · No injuriesClosedWaco VKS-6 · Lisbon, NDApr 30, 1972 · N4676T · Substantial damage NTSB MKC72FTG19Accident · No injuriesClosedBeech A23 · Wahpeton, NDMar 24, 1972 · N4767J · Substantial damage NTSB MKC72AK053Accident · Serious injuriesClosedBeech D18S · Bismarck, NDMar 2, 1972 · N375C · Destroyed NTSB MKC72AK047Accident · Serious injuriesClosedBeech D18S · Bismarck, NDFeb 2, 1972 · N57CC · Destroyed NTSB MKC72FTG16Accident · No injuriesClosedPiper J-3 · Crosby, NDJan 17, 1972 · N24705 · Substantial damage NTSB MKC72DTG17Accident · No injuriesClosedCessna 172F · Cando, NDJan 16, 1972 · N8567U · Substantial damage NTSB MKC72DTG15Accident · No injuriesClosedPiper J-3 · Mott, NDJan 11, 1972 · N7135H · Substantial damage NTSB MKC72FTG18Accident · No injuriesClosedBeech A23-19 · Fargo, NDJan 8, 1972 · N6915Q · Substantial damage NTSB MKC72DTG14Accident · No injuriesClosedPiper J-3 · Colgan, NDDec 10, 1971 · N24705 · Substantial damage