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 UNK67X0105Accident · No injuriesClosedCessna 180 · Strasburg, NDOct 31, 1966 · N4775U · Substantial damage NTSB MKC67F0266Accident · No injuriesClosedPiper PA22 · Lisbon, NDOct 26, 1966 · N2306P · Substantial damage NTSB MKC67F0224Accident · No injuriesClosedPiper PA-22 · Grand Forks, NDSep 25, 1966 · N3625A · Substantial damage NTSB UNK66X0176Accident · No injuriesClosedCessna 120 · Grand Forks, NDSep 21, 1966 · N2428N · Substantial damage NTSB MKC67F0202Accident · No injuriesClosedErcoupe 415-C · Blaisdell, NDSep 10, 1966 · N28953 · Substantial damage NTSB MKC67D0203Accident · No injuriesClosedErcoupe 415-C · Langdon, NDSep 8, 1966 · N93364 · Substantial damage NTSB MKC67D0161Accident · No injuriesClosedCessna 195 · Dunseith, NDSep 4, 1966 · N1562D · Substantial damage NTSB MKC67A0020Accident · 1 fatalClosedBoeing A75 · Hatton, NDAug 31, 1966 · N75664 · Destroyed NTSB MKC67F0128Accident · No injuriesClosedCessna 172 · Gilby, NDJul 31, 1966 · N4124F · Substantial damage NTSB MKC67F0125Accident · No injuriesClosedCessna 172 · Rock Lake, NDJul 31, 1966 · N7423A · Substantial damage NTSB MKC67D0106Accident · No injuriesClosedPiper PA-28 · Bottineau, NDJul 30, 1966 · N6488R · Substantial damage NTSB MKC67F0359Accident · No injuriesClosedPiper PA-11 · N.Rockford, NDJul 27, 1966 · N4758H · Substantial damage NTSB MKC67D0126Accident · No injuriesClosedFunk F-23B · Devils Lake, NDJul 19, 1966 · N1132Z · Substantial damage NTSB MKC67F0040Accident · No injuriesClosedBeech S35 · Wahpeton, NDJul 12, 1966 · N198Q · Substantial damage NTSB MKC67D0096Accident · No injuriesClosedPiper PA-11 · Adams, NDJul 11, 1966 · N5023H · Destroyed NTSB MKC67F0075Accident · Minor injuriesClosedPiper PA-25 · Fargo, NDJun 28, 1966 · N7318Z · Substantial damage NTSB MKC67D0088Accident · No injuriesClosedPiper PA-18 · Marion, NDJun 24, 1966 · N3281Z · Substantial damage NTSB MKC67D0058Accident · No injuriesClosedPiper PA-24 · Stanton, NDJun 24, 1966 · N8573P · Substantial damage NTSB MKC67F0011Accident · No injuriesClosedPiper PA-18A · Elgin, NDJun 21, 1966 · N8995D · Substantial damage NTSB MKC67F0010Accident · No injuriesClosedPiper PA-25 · Jamestown, NDJun 21, 1966 · N7356Z · Substantial damage NTSB MKC67F0007Accident · Minor injuriesClosedPiper PA-11 · Grafton, NDJun 20, 1966 · N5012H · Destroyed NTSB MKC67F0046Accident · No injuriesClosedPiper J3C-65 · Regent, NDJun 19, 1966 · N42277 · Substantial damage NTSB MKC67F0034Accident · Serious injuriesClosedPiper J3C · New England, NDJun 19, 1966 · N37916 · Substantial damage NTSB MKC67F0127Accident · No injuriesClosedCessna 150 · Mandan, NDJun 18, 1966 · N6251R · Substantial damage NTSB MKC67F0020Accident · No injuriesClosedPiper PA-25 · Westhope, NDJun 18, 1966 · N6189Z · Substantial damage NTSB MKC67D0189Accident · No injuriesClosedPiper PA-25 · Rhame, NDJun 18, 1966 · N6203Z · Substantial damage NTSB MKC67D0004Accident · No injuriesClosedCessna 170 · Grand Forks, NDJun 16, 1966 · N5410C · Substantial damage NTSB MKC67F0019Accident · No injuriesClosedPiper PA-18 · Carrington, NDJun 14, 1966 · N6187D · Substantial damage NTSB MKC67D0039Accident · No injuriesClosedPiper J3C-65 · Mercer, NDJun 13, 1966 · N30948 · Substantial damage NTSB MKC66D0588Accident · No injuriesClosedNavion A · Minot, NDJun 2, 1966 · N4312K · Substantial damage NTSB MKC66D0561Accident · No injuriesClosedPiper PA-22 · Northwood, NDJun 1, 1966 · N8024D · Substantial damage NTSB MKC66F0589Accident · No injuriesClosedCessna 170 · Rocsglen, NDMay 24, 1966 · N1904C · Substantial damage NTSB MKC66A0057Accident · 1 fatalClosedPiper PA-18 · De Smet, NDMay 9, 1966 · N1962P · Destroyed NTSB MKC66F0511Accident · No injuriesClosedDowner 14-19 · Fargo, NDApr 29, 1966 · N8802R · Substantial damage NTSB MKC66A0051Accident · No injuriesClosedBrantly B-2 · Bismark, NDMar 5, 1966 · N5932X · Substantial damage NTSB MKC66D0466Accident · Minor injuriesClosedPiper PA-12 · Oakes, NDFeb 10, 1966 · N3015M · Substantial damage NTSB MKC66F0471Accident · No injuriesClosedPiper PA-18 · Upham, NDFeb 4, 1966 · N4724A · Substantial damage NTSB MKC66F0457Accident · Serious injuriesClosedPiper PA-11 · Hurdsfield, NDFeb 4, 1966 · N5021H · Substantial damage NTSB MKC66D0418Accident · No injuriesClosedAeronca 7AC · Kenmare, NDFeb 4, 1966 · N2774E · Substantial damage NTSB MKC66D0462Accident · No injuriesClosedPiper PA-28 · Cooperstown, NDFeb 2, 1966 · N5147W · Substantial damage NTSB MKC66D0417Accident · No injuriesClosedPiper PA-11 · Rugby, NDFeb 1, 1966 · N87986 · Substantial damage NTSB MKC66F0400Accident · No injuriesClosedPiper PA-30 · Minot, NDJan 28, 1966 · N7610Y · Substantial damage NTSB MKC66D0403Accident · No injuriesClosedPiper PA-18A · Jamestown, NDJan 24, 1966 · N1574P · Substantial damage NTSB MKC66D0338Accident · No injuriesClosedCessna 182 · Lisbon, NDDec 8, 1965 · N8575T · Substantial damage NTSB MKC66F0374Accident · No injuriesClosedCessna 120 · Grand Forks, NDDec 5, 1965 · N76219 · Substantial damage NTSB MKC66D0426Accident · No injuriesClosedCessna 182 · Rolette, NDNov 23, 1965 · N8483T · Substantial damage NTSB MKC66F0226Accident · Minor injuriesClosedRyan PT-22 · Valley City, NDNov 21, 1965 · N46751 · Substantial damage NTSB MKC66D0404Accident · No injuriesClosedLuscombe 8A · Fessenden, NDNov 21, 1965 · N77859 · Substantial damage NTSB MKC66F0295Accident · No injuriesClosedCessna 180 · West Fargo, NDNov 9, 1965 · N555F · Substantial damage NTSB MKC66F0316Accident · No injuriesClosedCessna 210D · Fargo, NDNov 4, 1965 · N3764Y · Substantial damage