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 UNK64X4162Accident · No injuriesClosedCessna 182B · Fargo, NDSep 26, 1964 · N8422T · Substantial damage NTSB UNK64X4124Accident · No injuriesClosedCessna 140A · Milnor, NDSep 24, 1964 · N5381C · Substantial damage NTSB UNK64X3743Accident · No injuriesClosedCessna 182 · Stanley, NDSep 2, 1964 · N2100R · Substantial damage NTSB UNK64X3614Accident · Serious injuriesClosedPiper PA11 · Anter, NDAug 26, 1964 · N5026H · Destroyed NTSB UNK64X3595Accident · No injuriesClosedPiper J3 · Lucca, NDAug 25, 1964 · N1565N · Minor damage NTSB UNK64X3418Accident · No injuriesClosedCessna 150 · Jamestown, NDAug 16, 1964 · N2074Z · Substantial damage NTSB UNK64X3073Accident · No injuriesClosedCessna 180 · Fordville, NDJul 27, 1964 · N2195Z · Substantial damage NTSB UNK64X3069Accident · No injuriesClosedBeech K35 · Bismark, NDJul 27, 1964 · N6099E · Substantial damage NTSB UNK64X2861Accident · No injuriesClosedPiper PA24 · Mott, NDJul 16, 1964 · N7637P · Substantial damage NTSB UNK64X2582Accident · Minor injuriesClosedBenson B8M · Valley City, NDJun 30, 1964 · N1065Z · Destroyed NTSB UNK64X2483Accident · 1 fatalClosedPiper PA18A · Jamestown, NDJun 25, 1964 · N4870A · Destroyed NTSB UNK64X2432Accident · No injuriesClosedCessna 172B · Upham, NDJun 22, 1964 · N7645X · Substantial damage NTSB UNK64X2410Accident · No injuriesClosedPiper PA18 · Goodrich, NDJun 21, 1964 · N1252A · Destroyed NTSB MKC66D0051Accident · No injuriesClosedCessna 180F · Petersburg, NDJun 18, 1964 · N2134Z · Substantial damage NTSB UNK64X2337Accident · No injuriesClosedChampion 7DC · Ryder, NDJun 17, 1964 · N4352E · Destroyed NTSB UNK64X2324Accident · No injuriesClosedPiper PA24 · Mandan, NDJun 16, 1964 · N7309P · Substantial damage NTSB UNK64X2293Accident · 1 fatalClosedPiper PA18 · Ryder, NDJun 14, 1964 · N2678P · Destroyed NTSB UNK64X2226Accident · No injuriesClosedPiper PA-11 · Lincoln Vly, NDJun 11, 1964 · N5075H · Substantial damage NTSB UNK64X2206Accident · 1 fatalClosedAeronca 7BCM · Elgin, NDJun 9, 1964 · N83537 · Destroyed NTSB UNK64X2149Accident · No injuriesClosedPiper PA11 · Churchs Ferry, NDJun 6, 1964 · N4842M · Substantial damage NTSB UNK64X2096Accident · No injuriesClosedChampion 7FC · West Fargo, NDJun 3, 1964 · N7544B · Substantial damage NTSB UNK64X2077Accident · No injuriesClosedPiper PA28 · Williston, NDJun 2, 1964 · N7167W · Substantial damage NTSB UNK64X2063Accident · No injuriesClosedPiper PA18A · Rolla, NDJun 1, 1964 · N1076A · Substantial damage NTSB UNK64X1767Accident · No injuriesClosedCougar D1M · Michigan, NDMay 14, 1964 · N6835D · Substantial damage NTSB UNK64X1752Accident · No injuriesClosedCessna 182 · Edgeley, NDMay 13, 1964 · N5422B · Substantial damage NTSB UNK64X0906Accident · No injuriesClosedMooney M20A · Minot, NDMar 14, 1964 · N6590B · Destroyed