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 MKC70FDD15Accident · No injuriesClosedCallair B-1A · Grand Forks, NDMay 22, 1970 · N7200V · Destroyed NTSB MKC70DDD14Accident · Minor injuriesClosedPiper PA-25 · Walhalla, NDMay 20, 1970 · N7193Z · Destroyed NTSB MKC70FDD17Accident · Serious injuriesClosedCessna 172I · Steele, NDMay 6, 1970 · N46136 · Substantial damage NTSB MKC70AK059Accident · No injuriesClosedCessna 402 · Pembina, NDApr 22, 1970 · CF-ATW · Substantial damage NTSB MKC70FDD11Accident · No injuriesClosedMooney M20G · Forbes, NDApr 4, 1970 · N3640N · Substantial damage NTSB MKC70DDD10Accident · No injuriesClosedCessna 150 · Fonda, NDMar 7, 1970 · CF-SZE · Substantial damage NTSB MKC70DDD12Accident · No injuriesClosedStinson 108-1 · Belfield, NDFeb 25, 1970 · N8364K · Substantial damage NTSB MKC70FDD09Accident · No injuriesClosedPiper PA-28 · Kulm, NDFeb 9, 1970 · N5932W · Substantial damage NTSB MKC70FDD07Accident · No injuriesClosedCessna 172I · Lamoure, NDJan 31, 1970 · N46232 · Substantial damage NTSB MKC70DDD05Accident · No injuriesClosedPiper PA-18 · Noonan, NDJan 23, 1970 · N8895D · Substantial damage NTSB MKC70FDD06Accident · No injuriesClosedCessna 150G · Minot, NDJan 18, 1970 · N2420J · Substantial damage NTSB MKC70DDD04Accident · No injuriesClosedPiper PA-18 · Moffit, NDJan 10, 1970 · N7587K · Substantial damage NTSB MKC70DDD02Accident · No injuriesClosedAeronca 7EC · Benedict, NDJan 10, 1970 · N4670E · Substantial damage NTSB MKC70DDD08Accident · No injuriesClosedPiper PA-18 · Langdon, NDJan 4, 1970 · N9925D · Substantial damage NTSB MKC70FDD03Accident · No injuriesClosedChampion 7CCM · Verona, NDJan 1, 1970 · N4449E · Substantial damage NTSB MKC70F0308Accident · No injuriesClosedPiper PA-18 · Grand Forks, NDDec 23, 1969 · N2205A · Substantial damage NTSB MKC70D0249Accident · Minor injuriesClosedCessna 182 · Edgely, NDNov 6, 1969 · N1913X · Substantial damage NTSB MKC70F0250Accident · No injuriesClosedPiper PA-18 · Kindred, NDOct 19, 1969 · N1184A · Substantial damage NTSB MKC70D0258Accident · No injuriesClosedPiper PA-18A · Towner, NDOct 5, 1969 · N1944A · Substantial damage NTSB MKC70D0282Accident · No injuriesClosedCessna 172 · Columbus, NDOct 1, 1969 · N5672A · Substantial damage NTSB MKC70A0013Accident · 4 fatalClosedMooney M20E · Williston, NDSep 25, 1969 · N6763U · Destroyed NTSB MKC70D0273Accident · No injuriesClosedCessna 172 · Carpio, NDSep 13, 1969 · N5672A · Substantial damage NTSB MKC70D0196Accident · No injuriesClosedCessna 120 · Valley City, NDSep 3, 1969 · N2533N · Substantial damage NTSB MKC70D0195Accident · No injuriesClosedPiper PA-28R · Bartlett, NDAug 31, 1969 · N3984T · Substantial damage NTSB MKC70F0176Accident · No injuriesClosedPiper PA-28R · Grand Forks, NDAug 14, 1969 · N4529J · Substantial damage NTSB MKC70D0163Accident · No injuriesClosedBoeing E75 · Mohall, NDJul 14, 1969 · N3993B · Substantial damage NTSB MKC70D0083Accident · No injuriesClosedCessna 182G · Garrison, NDJul 13, 1969 · N2074R · Substantial damage NTSB MKC70D0076Accident · No injuriesClosedCessna 150 · Fryburg, NDJul 10, 1969 · N22170 · Substantial damage NTSB MKC70D0151Accident · No injuriesClosedPiper PA-18 · Crary, NDJul 2, 1969 · N4355Z · Substantial damage NTSB MKC70D0066Accident · Minor injuriesClosedPiper PA-18 · Blaisdell, NDJun 30, 1969 · N1595P · Destroyed NTSB MKC70F0059Accident · Serious injuriesClosedBoeing A75 · Argusville, NDJun 27, 1969 · N63880 · Substantial damage NTSB MKC70D0100Accident · No injuriesClosedCessna T210G · Dunn Center, NDJun 20, 1969 · N6878R · Substantial damage NTSB MKC70F0177Accident · No injuriesClosedCessna 177 · Bowdon, NDJun 15, 1969 · N3368T · Substantial damage NTSB MKC70F0034Accident · No injuriesClosedCessna 170A · Fargo, NDJun 11, 1969 · N1718D · Substantial damage NTSB MKC70F0037Accident · No injuriesClosedLuscombe T-8F · Hillsboro, NDMay 25, 1969 · N1583B · Substantial damage NTSB MKC69D0465Accident · No injuriesClosedPiper PA-12 · Valley City, NDMay 21, 1969 · N3491M · Substantial damage NTSB MKC69D0466Accident · No injuriesClosedCessna 172 · Harvey, NDMay 6, 1969 · N35643 · Substantial damage NTSB MKC69D0404Accident · No injuriesClosedPiper PA-18 · Buffalo, NDApr 13, 1969 · N3892Z · Substantial damage NTSB MKC69D0435Accident · No injuriesClosedPiaggio 136-L1 · Grand Forks, NDApr 12, 1969 · N40026 · Substantial damage NTSB MKC70D0020Accident · No injuriesClosedTaylorcraft BC12-D · Minot, NDMar 30, 1969 · N95077 · Substantial damage NTSB MKC69D0424Accident · No injuriesClosedLuscombe 8A · Wahpeton, NDMar 9, 1969 · N2760K · Substantial damage NTSB MKC69A0051Accident · 1 fatalClosedMooney M20F · Jamestown, NDMar 2, 1969 · N9720M · Destroyed NTSB MKC69D0389Accident · No injuriesClosedAeronca 7AC · Cando, NDFeb 28, 1969 · N2543E · Substantial damage NTSB MKC69F0351Accident · No injuriesClosedPiper PA-30 · Fargo, NDFeb 18, 1969 · N7573Y · Substantial damage NTSB MKC69D0337Accident · No injuriesClosedPiper J-3 · Stanley, NDFeb 13, 1969 · N38948 · Substantial damage NTSB MKC69F0375Accident · No injuriesClosedCessna 195 · Fargo, NDFeb 5, 1969 · N3043B · Substantial damage NTSB MKC69D0350Accident · No injuriesClosedCessna 172 · Harvey, NDFeb 2, 1969 · N35643 · Substantial damage NTSB MKC69D0467Accident · No injuriesClosedChampion 7EC · Plaza, NDJan 29, 1969 · N4653E · Substantial damage NTSB MKC69F0334Accident · No injuriesClosedCessna 310H · Bowman, NDJan 20, 1969 · N1018Q · Substantial damage NTSB MKC69D0311Accident · No injuriesClosedPiper PA-18A · Hankinson, NDJan 7, 1969 · N6792B · Substantial damage