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 MKC72FTG13Accident · No injuriesClosedErco 415-C · Buxton, NDOct 24, 1971 · N94107 · Substantial damage NTSB MKC72AK022Accident · 2 fatalClosedPiper PA-22 · Kenmare, NDSep 30, 1971 · N8946D · Destroyed NTSB MKC72FTG12Accident · No injuriesClosedCessna 172 · Rolette, NDSep 23, 1971 · N2552Y · Substantial damage NTSB MKC72FTG10Accident · No injuriesClosedCessna 180 · Minot, NDSep 9, 1971 · N709 · Substantial damage NTSB MKC72FTG09Accident · 1 fatalClosedAeronca 7AC · Alamo, NDSep 6, 1971 · N81751 · Destroyed NTSB MKC72AK018Accident · 1 fatalClosedCessna 172B · Forbes, NDAug 30, 1971 · N7982X · Destroyed NTSB MKC72FTG11Accident · No injuriesClosedAero Comr 200D · Carpio, NDAug 27, 1971 · N2979T · Substantial damage NTSB MKC72FTG06Accident · No injuriesClosedCessna 170B · Rhame, NDAug 25, 1971 · N4652C · Substantial damage NTSB MKC72FTG08Accident · No injuriesClosedPiper PA-18 · Upham, NDAug 1, 1971 · N8666C · Substantial damage NTSB MKC72FTG07Accident · No injuriesClosedCallair A-9 · Mekinock, NDJul 20, 1971 · N3569G · Substantial damage NTSB MKC72FTG05Accident · Minor injuriesClosedBell 47G-2 · Ellendale, NDJul 11, 1971 · N4735S · Substantial damage NTSB MKC72FTG04Accident · No injuriesClosedCessna 172 · Des Lacs, NDJul 11, 1971 · N9880G · Substantial damage NTSB MKC72FTG03Accident · 1 fatalClosedN.American AT-6G · Stanley, NDJul 6, 1971 · N2822G · Destroyed NTSB MKC72FTG02Accident · No injuriesClosedSikorsky S-52-3 · New Rockfrd, NDJul 4, 1971 · N54060 · Substantial damage NTSB MKC72FTG01Accident · No injuriesClosedCessna 188 · Grafton, NDJul 1, 1971 · N9946G · Destroyed NTSB MKC71FTG36Accident · No injuriesClosedCallair A-9 · Reeder, NDJun 30, 1971 · N7206V · Destroyed NTSB MKC71FTG35Accident · Minor injuriesClosedCessna 172G · Alexander, NDJun 26, 1971 · N3844L · Substantial damage NTSB MKC71FTG34Accident · No injuriesClosedPiper PA-18 · Langdon, NDJun 25, 1971 · N3887Z · Substantial damage NTSB MKC71FTG33Accident · Serious injuriesClosedPiper PA-18 · Bremen, NDJun 23, 1971 · N3497Z · Substantial damage NTSB MKC71FTG32Accident · No injuriesClosedPiper PA-18 · Rolla, NDJun 22, 1971 · N4110Z · Substantial damage NTSB MKC71FTG31Accident · No injuriesClosedMooney M20C · Minot, NDJun 8, 1971 · N6839U · Substantial damage NTSB MKC71FTG30Accident · Minor injuriesClosedPiper PA-11 · Petersburg, NDJun 3, 1971 · N4709H · Substantial damage NTSB MKC71DTG28Accident · Serious injuriesClosedPiper PA-25 · Devils Lake, NDJun 1, 1971 · N4812Y · Substantial damage NTSB MKC71FTG29Accident · No injuriesClosedPiper PA-25 · Fairmount, NDMay 28, 1971 · N4845Y · Substantial damage NTSB MKC71DTG27Accident · No injuriesClosedPiper PA-25 · Mountain, NDMay 17, 1971 · N6228Z · Substantial damage NTSB MKC71FTG25Accident · No injuriesClosedCessna 170B · Williston, NDMay 6, 1971 · N1769D · Substantial damage NTSB MKC71DTG26Accident · No injuriesClosedCessna 172L · Bucyrus, NDMay 6, 1971 · N7571G · Substantial damage NTSB MKC71DDD24Accident · No injuriesClosedPiper PA-28 · Langdon, NDMar 30, 1971 · N6352W · Substantial damage NTSB MKC71FDD21Accident · No injuriesClosedMooney M20C · Mcclusky, NDFeb 24, 1971 · N6777N · Substantial damage NTSB MKC71DDD19Accident · No injuriesClosedPiper J3C-65 · Crosby, NDFeb 16, 1971 · N25835 · Destroyed NTSB MKC71AK045Accident · 2 fatalClosedPiper J3-C · Mcleod, NDFeb 10, 1971 · N92429 · Destroyed NTSB MKC71DDD18Accident · No injuriesClosedCessna 172 · Watford Cty, NDJan 21, 1971 · N35583 · Substantial damage NTSB MKC71DDD16Accident · No injuriesClosedCessna 150F · Cooperstown, NDDec 30, 1970 · N8219F · Substantial damage NTSB MKC71AK030Accident · Serious injuriesClosedPiper PA-24 · Bismarck, NDNov 30, 1970 · N8908P · Substantial damage NTSB MKC71AK022Accident · 1 fatalClosedCessna 180 · Belden, NDOct 24, 1970 · N2338C · Destroyed NTSB MKC71FDD14Accident · No injuriesClosedPiper PA-24 · Bismarck, NDOct 15, 1970 · N8551P · Substantial damage NTSB MKC71FDD12Accident · No injuriesClosedAlon A2-A · Napoleon, NDSep 8, 1970 · N5470F · Substantial damage NTSB MKC71DDD11Accident · No injuriesClosedErco 415-C · Verona, NDSep 5, 1970 · N99826 · Substantial damage NTSB MKC71FDD10Accident · Serious injuriesClosedAero Comdr 100 · Glenburn, NDAug 18, 1970 · N5531M · Destroyed NTSB MKC71FDD04Accident · No injuriesClosedCessna 172 · Garrison, NDAug 9, 1970 · N3912L · Substantial damage NTSB MKC71DDD07Accident · No injuriesClosedCessna 150 · Mandan, NDAug 8, 1970 · N6949S · Substantial damage NTSB MKC71DDD05Accident · No injuriesClosedPiper PA-11 · Michigan, NDAug 8, 1970 · N4709H · Substantial damage NTSB MKC71FDD02Accident · Minor injuriesClosedPiper PA-24 · Warsaw, NDJul 17, 1970 · N6252P · Substantial damage NTSB MKC70FDD21Accident · 1 fatalClosedPiper PA-18 · Maddock, NDJun 26, 1970 · N8567D · Destroyed NTSB MKC70FDD18Accident · No injuriesClosedPiper PA-25 · Casselton, NDJun 20, 1970 · N6265Z · Substantial damage NTSB MKC70DDD22Accident · No injuriesClosedFairchild M-62 · Warwick, NDJun 20, 1970 · N73414 · Substantial damage NTSB MKC70FDD16Accident · 1 fatalClosedPiper PA-18 · Lehr, NDJun 19, 1970 · N3281Z · Destroyed NTSB MKC70FDD19Accident · Minor injuriesClosedCessna 180 · Pembina, NDJun 18, 1970 · N185E · Substantial damage NTSB MKC70DDD24Accident · No injuriesClosedCessna 120 · Crary, NDJun 6, 1970 · N2908N · Substantial damage NTSB MKC70DDD23Accident · Minor injuriesClosedPiper PA-25 · Wahpeton, NDJun 5, 1970 · N7618Z · Substantial damage