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 MKC76DTG10Accident · No injuriesClosedCessna 170 · Warsaw, NDNov 8, 1975 · N4230V · Substantial damage NTSB MKC76DTG09Accident · Minor injuriesClosedCessna 150 · Kulm, NDOct 28, 1975 · N8502G · Substantial damage NTSB MKC76AK022Accident · 2 fatalClosedAeronca 7CCM · Hillsboro, NDSep 28, 1975 · N85006 · Substantial damage NTSB MKC76DTG08Accident · No injuriesClosedPiper J-3 · Rolette, NDSep 25, 1975 · N3393N · Substantial damage NTSB MKC76FTG07Accident · No injuriesClosedCessna 172 · Turtle Lake, NDAug 19, 1975 · N7094T · Substantial damage NTSB MKC76DTG06Accident · No injuriesClosedPiper PA-18 · Crosby, NDAug 10, 1975 · N7376D · Substantial damage NTSB MKC76DTG05Accident · No injuriesClosedCallair A-9 · Hebron, NDJul 23, 1975 · N7206V · Substantial damage NTSB MKC76DTG04Accident · Minor injuriesClosedCessna 150 · Walhalla, NDJul 20, 1975 · N22008 · Substantial damage NTSB MKC76DTG03Accident · No injuriesClosedPiper PA-25 · Mohall, NDJul 9, 1975 · N9708P · Substantial damage NTSB MKC76DTG02Accident · Minor injuriesClosedPiper PA-25 · Rhame, NDJul 8, 1975 · N6861Z · Destroyed NTSB MKC76DTG01Accident · No injuriesClosedPiper PA-25 · Max, NDJul 7, 1975 · N7219A · Substantial damage NTSB MKC76AK004Accident · 4 fatalClosedBeech 35 · Bismarck, NDJul 5, 1975 · N3310V · Destroyed NTSB MKC75FTG27Accident · No injuriesClosedPiper PA-22 · Fargo, NDJun 26, 1975 · N8918D · Substantial damage NTSB MKC75FTG25Accident · No injuriesClosedPiper PA-18 · Fessenden, NDJun 21, 1975 · N7115K · Substantial damage NTSB MKC7KAK062Accident · 1 fatalClosedCessna 150L · Minot, NDJun 16, 1975 · N1508Q · Destroyed NTSB MKC75DTG23Accident · Minor injuriesClosedPiper PA-25 · Manvel, NDJun 7, 1975 · N7204Z · Substantial damage NTSB MKC75FTG21Accident · No injuriesClosedCessna 336 · Hannaford, NDJun 3, 1975 · N1781Z · Substantial damage NTSB MKC75DTG22Accident · No injuriesClosedPiper PA-25 · Lisbon, NDJun 3, 1975 · N7198Z · Substantial damage NTSB MKC75AK056Accident · 2 fatalClosedBeech A45 · Northwood, NDMay 25, 1975 · N9087C · Destroyed NTSB MKC75FTG19Accident · No injuriesClosedCessna 150 · Reynolds, NDMay 9, 1975 · N6249G · Substantial damage NTSB MKC75FTG17Accident · No injuriesClosedCessna 172I · Pettibone, NDJan 24, 1975 · N46252 · Substantial damage NTSB MKC75D1G16Accident · No injuriesClosedPiper J3C-65 · Esmond, NDDec 22, 1974 · N98755 · Substantial damage NTSB MKC75FTG15Accident · No injuriesClosedCessna 150 · Devils Lake, NDNov 7, 1974 · N4706X · Substantial damage NTSB MKC75FTG14Accident · No injuriesClosedPitts S1C · Erie, NDOct 26, 1974 · N7422 · Substantial damage NTSB MKC75FTG12Accident · No injuriesClosedPiper PA-23 · Bowman, NDSep 4, 1974 · N1136P · Substantial damage NTSB MKC75FTG11Accident · Minor injuriesClosedBeech 23 · Minot, NDAug 19, 1974 · N2320Q · Substantial damage NTSB MKC75DTG10Accident · No injuriesClosedPiper PA-18 · Cooperstown, NDAug 4, 1974 · N167T · Substantial damage NTSB MKC75DTG07Accident · No injuriesClosedInterstate S-1B1 · Williston, NDJul 28, 1974 · N49066 · Substantial damage NTSB MKC75DTG08Accident · No injuriesClosedCessna 172 · Fordville, NDJul 26, 1974 · N20335 · Substantial damage NTSB MKC75FTG06Accident · No injuriesClosedCessna 188 · Cummings, NDJul 25, 1974 · N8119G · Substantial damage NTSB MKC75FTG05Accident · No injuriesClosedAmer Avco AA1-B · Fargo, NDJul 21, 1974 · N4SU · Substantial damage NTSB MKC75DTG03Accident · No injuriesClosedPiper PA-11 · Maddock, NDJul 13, 1974 · N5573H · Substantial damage NTSB MKC75FTG02Accident · No injuriesClosedPiper PA-18 · Nw Rockford, NDJul 12, 1974 · N1190C · Substantial damage NTSB MKC75FTG13Accident · No injuriesClosedPiper PA-25 · Kenmare, NDJul 3, 1974 · N6719Z · Substantial damage NTSB MKC75FTG01Accident · 1 fatalClosedPiper PA-11 · Rolla, NDJul 2, 1974 · N5099H · Substantial damage NTSB MKC74FTG22Accident · No injuriesClosedPiper PA-25 · Hazelton, NDJun 27, 1974 · N7358Z · Substantial damage NTSB MKC74DTG21Accident · No injuriesClosedPiper PA-25 · Reeder, NDJun 24, 1974 · N6625Z · Substantial damage NTSB MKC74FTG20Accident · Minor injuriesClosedPiper PA-25 · Arthur, NDJun 23, 1974 · N4368Y · Substantial damage NTSB MKC74FTG19Accident · No injuriesClosedCessna 188 · Crete, NDJun 22, 1974 · N8075G · Substantial damage NTSB MKC74AK068Accident · 1 fatalClosedBellanca 7KCAB · Glenburn, NDJun 8, 1974 · N86812 · Destroyed NTSB MKC74FTG18Accident · Serious injuriesClosedPiper PA-25 · Ayr, NDJun 6, 1974 · N4733Y · Substantial damage NTSB MKC74FTG17Accident · No injuriesClosedBeech B55 · Minot, NDJun 2, 1974 · N8407N · Substantial damage NTSB MKC74FTG16Accident · Minor injuriesClosedPiper PA-12 · Oakes, NDJun 1, 1974 · N3896M · Substantial damage NTSB MKC74FTG15Accident · 1 fatalClosedPiper PA-18 · Ryder, NDApr 30, 1974 · N9888D · Destroyed NTSB MKC74FTG14Accident · No injuriesClosedCessna 172 · Harvey, NDApr 24, 1974 · N4371R · Substantial damage NTSB MKC74FTG13Accident · No injuriesClosedCessna 150J · Grand Forks, NDFeb 9, 1974 · N60667 · Substantial damage NTSB MKC74AK041Accident · 1 fatalClosedPiper PA-28 · Christine, NDJan 26, 1974 · N6617J · Destroyed NTSB MKC74DTG12Accident · No injuriesClosedAmer Avco AA1-B · Cooperstown, NDJan 21, 1974 · N9990L · Substantial damage NTSB MKC74AK035Accident · 6 fatalClosedBeech 95-55 · New Salem, NDDec 24, 1973 · N9385Y · Destroyed NTSB MKC74DTG11Accident · No injuriesClosedCessna 172 · Bowman, NDDec 8, 1973 · N5076A · Substantial damage