Skip to content

Final NTSB investigations, 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, 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 DEN81DTG06Accident · No injuriesClosedCessna 182G · Alama, NDFeb 27, 1981 · N2452R · Substantial damage NTSB DEN81FA019Accident · 1 fatalClosedCessna 182RG · Grand Forks, NDFeb 17, 1981 · N4773S · 2 aircraft · Substantial damage NTSB DEN81FA018Accident · No injuriesClosedBoeing 747 · Fargo, NDFeb 11, 1981 · N610US · Substantial damage NTSB DEN81DTG05Accident · No injuriesClosedCessna 172 · Oakes, NDDec 18, 1980 · N5692A · Substantial damage NTSB DEN81FTG04Accident · Minor injuriesClosedBellanca 7ECA · Grand Forks, NDNov 23, 1980 · N5047G · Substantial damage NTSB DEN81DTG03Accident · No injuriesClosedHiller Acft UH-12E · Watford City, NDNov 21, 1980 · N5343V · Substantial damage NTSB DEN81DTG02Accident · Minor injuriesClosedCessna A185F · Minot, NDNov 7, 1980 · N1475F · Substantial damage NTSB DEN81FTG01Accident · No injuriesClosedHiller UH12E · Argusville, NDOct 3, 1980 · N5594N · Substantial damage NTSB DEN80DTG17Accident · No injuriesClosedCessna 150 · Oakes, NDSep 21, 1980 · N4814X · Substantial damage NTSB DEN80FA061Accident · 1 fatalClosedBell 206B · Grassy Butte, NDSep 4, 1980 · N58005 · Substantial damage NTSB DEN80FTG15Accident · Minor injuriesClosedCessna U206G · Grand Forks, NDAug 2, 1980 · N734QK · Substantial damage NTSB DEN80FTG14Accident · No injuriesClosedPiper PA-24 · Devils Lake, NDJul 29, 1980 · N5558P · Substantial damage NTSB DEN80FTG13Accident · No injuriesClosedCessna 310 · Pembina, NDJun 28, 1980 · N69724 · Substantial damage NTSB DEN80FTG16Accident · No injuriesClosedCessna T188 · Starkweather, NDJun 11, 1980 · N2087J · Substantial damage NTSB DEN80FTG12Accident · 1 fatalClosedPiper PA-25 · Englevale, NDJun 3, 1980 · N9706P · Destroyed NTSB DEN80FTG11Accident · Minor injuriesClosedCessna 188 · Fairmount, NDMay 27, 1980 · N731WG · Substantial damage NTSB DEN80FTG10Accident · No injuriesClosedDehavilland DHC-3 · Noonan, NDMay 25, 1980 · CFDJA · Substantial damage NTSB DEN80FTG09Accident · Minor injuriesClosedPiper PA-25 · Davenport, NDMay 23, 1980 · N4860Y · Substantial damage NTSB MKC80FTG08Accident · No injuriesClosedCessna 170B · Grand Forks, NDMar 22, 1980 · N1678D · Substantial damage NTSB MKC80FTG06Accident · No injuriesClosedCessna 152 · New Rockford, NDMar 2, 1980 · N68943 · Substantial damage NTSB MKC80FTG07Accident · No injuriesClosedCessna 182RG · Minot, NDMar 1, 1980 · N756BF · Substantial damage NTSB MKC80DTG05Accident · No injuriesClosedPiper PA-24 · Grand Forks, NDFeb 24, 1980 · N5471P · Substantial damage NTSB MKC80FTG03Accident · No injuriesClosedCessna 172 · Grand Forks, NDFeb 21, 1980 · CFRFR · Substantial damage NTSB MKC80DTG04Accident · No injuriesClosedCessna 177B · Rolette, NDFeb 17, 1980 · N30652 · Substantial damage NTSB MKC80FTG02Accident · Serious injuriesClosedBeech C35 · Grand Forks, NDDec 23, 1979 · N692D · Substantial damage NTSB MKC79DTG15Accident · Minor injuriesClosedCommonwlth 185 · Bottineau, NDAug 26, 1979 · N73825 · Substantial damage NTSB MKC79DTG14Accident · No injuriesClosedPiper PA-18 · Leeds, NDAug 22, 1979 · N2515A · Substantial damage NTSB MKC79FA050Accident · 1 fatalClosedCessna 150 · St Anthony, NDAug 19, 1979 · N714HX · Destroyed NTSB MKC79FTG13Accident · No injuriesClosedBeech V35 · Bismarck, NDAug 3, 1979 · N911V · Substantial damage NTSB MKC79FTG12Accident · No injuriesClosedHiller UH-12D · Minot, NDJul 21, 1979 · N62397 · Substantial damage NTSB MKC79DTG11Accident · No injuriesClosedCessna A188B · Garsky, NDJul 5, 1979 · N2172J · Substantial damage NTSB MKC79DTG10Accident · No injuriesClosedSwearingen SA26AT · Minot, NDJul 1, 1979 · N711SA · Substantial damage NTSB MKC79FTG09Accident · No injuriesClosedPiper PA-30 · Minot, NDJun 27, 1979 · N8013Y · Substantial damage NTSB MKC79FTG08Accident · No injuriesClosedCessna 150M · Mercer, NDJun 27, 1979 · N45232 · Substantial damage NTSB MKC79FA037Accident · 1 fatalClosedCessna 182Q · Dawson, NDJun 22, 1979 · N456LH · Destroyed NTSB MKC79DTG07Accident · No injuriesClosedCessna 140 · Bowman, NDMay 26, 1979 · N1677V · Substantial damage NTSB MKC79FTG06Accident · No injuriesClosedPiper PA-28 · Fargo, NDMay 15, 1979 · N1696H · Substantial damage NTSB MKC79FA028Accident · 1 fatalClosedMaule M-4 · Bowman, NDMay 3, 1979 · N2078U · Destroyed NTSB MKC79DTG05Accident · No injuriesClosedPiper PA-28 · Pingree, NDApr 19, 1979 · N4090Q · Substantial damage NTSB MKC79FTG04Accident · Serious injuriesClosedPiper PA-18 · Goodrich, NDMar 9, 1979 · N9730P · Destroyed NTSB MKC79FTG03Accident · No injuriesClosedPiper PA-30 · Bowman, NDFeb 19, 1979 · N8312Y · Substantial damage NTSB MKC79FTG02Accident · Serious injuriesClosedBeech C24R · Grand Forks, NDDec 11, 1978 · N18950 · Substantial damage NTSB MKC79IA002Incident · No injuriesClosedBeech B100 · Dickinson, NDNov 7, 1978 · N1WD · Minor damage NTSB MKC79FTG01Accident · No injuriesClosedCessna 152 · Grand Forks, NDOct 31, 1978 · N757SH · Substantial damage NTSB MKC78DTG16Accident · No injuriesClosedBellanca 7GCBC · Mandan, NDSep 15, 1978 · N5508N · Substantial damage NTSB MKC78DTG15Accident · No injuriesClosedCessna A188B · Brocket, NDSep 9, 1978 · N4865R · Substantial damage NTSB MKC78DTG14Accident · No injuriesClosedPiper PA-12 · Rugby, NDSep 1, 1978 · N3752M · Substantial damage NTSB MKC78FA054Accident · 1 fatalClosedCessna 175B · Turtle Lake, NDJul 9, 1978 · N8126T · Destroyed NTSB MKC78FTG13Accident · No injuriesClosedPiper PA-25C · Minot, NDJul 5, 1978 · N8686L · Substantial damage NTSB MKC78FTG12Accident · Serious injuriesClosedBellanca 7GCBC · Voltaire, NDJun 24, 1978 · N41824 · Substantial damage