Skip to content

NTSB investigations, SD

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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" = 'SD' AND c."eventCountry" = 'USA' 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\" = 'SD' AND c.\"eventCountry\" = 'USA'
  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" = 'SD' AND c."eventCountry" = 'USA'
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 MKC67D0345Accident · No injuriesClosedPiper PA-18 · Kadoka, SDDec 4, 1966 · N9884D · Substantial damage NTSB MKC67D0314Accident · No injuriesClosedCessna 172 · Rapid City, SDNov 29, 1966 · N7004A · Substantial damage NTSB MKC67D0293Accident · No injuriesClosedPiper PA-22 · Spearfish, SDNov 16, 1966 · N4966Z · Substantial damage NTSB MKC67F0306Accident · 1 fatalClosedCessna 182 · Plankinton, SDOct 27, 1966 · N8829T · Destroyed NTSB MKC67F0237Accident · No injuriesClosedBellanca 14-19 · New Underwood, SDSep 28, 1966 · N8537R · Substantial damage NTSB MKC67A0022Accident · 5 fatalClosedAero Comdr 1121 · Nplatte, SDSep 26, 1966 · N500JR · Destroyed NTSB MKC67D0226Accident · No injuriesClosedMooney M20C · Pickstown, SDSep 24, 1966 · N6430U · Substantial damage NTSB MKC67A0026Accident · Serious injuriesClosedDouglas DC-3 · Rapid City, SDSep 23, 1966 · N4996E · No damage NTSB MKC67A0025Accident · 2 fatalClosedCessna 172E · Wakpala, SDSep 20, 1966 · N3751S · Destroyed NTSB MKC67A0023Accident · 1 fatalClosedPiper J3C-65 · Faith, SDSep 14, 1966 · N87964 · Destroyed NTSB MKC67F0179Accident · No injuriesClosedPiper PA-18 · Hermosa, SDSep 4, 1966 · N6098D · Substantial damage NTSB MKC67F0234Accident · No injuriesClosedAeronca 7AC · Tuthill, SDAug 28, 1966 · N82894 · Substantial damage NTSB MKC67F0182Accident · No injuriesClosedMooney M20A · Ellsworth Afb, SDAug 28, 1966 · N8168E · Substantial damage NTSB MKC67D0256Accident · No injuriesClosedPiper PA-22 · Ft.Thompson, SDAug 3, 1966 · N1790P · Substantial damage NTSB MKC67D0101Accident · No injuriesClosedBeech 95-B55 · Yankton, SDJul 30, 1966 · N192Q · Substantial damage NTSB MKC67D0100Accident · No injuriesClosedPiper PA-22 · Milesville, SDJul 28, 1966 · N2639P · Substantial damage NTSB MKC67F0136Accident · No injuriesClosedHelio H-250 · Hot Springs, SDJul 22, 1966 · N6318V · Substantial damage NTSB MKC67D0143Accident · No injuriesClosedPiper PA-28 · Redig, SDJul 15, 1966 · N6340R · Substantial damage NTSB MKC67F0129Accident · Serious injuriesClosedMooney M20C · Murdo, SDJul 7, 1966 · N6095Q · Destroyed NTSB MKC67F0080Accident · No injuriesClosedPiper PA-28 · Maurine, SDJul 2, 1966 · N5187W · Substantial damage NTSB MKC67F0081Accident · Serious injuriesClosedPiper J-3 · Bonilla, SDJun 14, 1966 · N98098 · Destroyed NTSB MKC67F0038Accident · Minor injuriesClosedPiper J3C · Parkston, SDJun 14, 1966 · N6318H · Destroyed NTSB MKC67D0041Accident · No injuriesClosedAeronca 15AC · Barnard, SDJun 10, 1966 · N1233H · Substantial damage NTSB MKC66F0590Accident · No injuriesClosedPiper PA-25 · Groton, SDJun 6, 1966 · N6132Z · Substantial damage NTSB MKC67F0009Accident · Minor injuriesClosedCessna 182 · Rapid City, SDMay 28, 1966 · N6381B · Substantial damage NTSB MKC66F0591Accident · No injuriesClosedCessna 172 · Pierre, SDMay 28, 1966 · N8239X · Substantial damage NTSB MKC66F0554Accident · No injuriesClosedBeech P35 · Brookings, SDMay 25, 1966 · N9773Y · Substantial damage NTSB MKC66F0551Accident · Minor injuriesClosedPiper PA-18 · Martin, SDMay 7, 1966 · N3794Z · Substantial damage NTSB MKC66F0540Accident · No injuriesClosedBeech V35 · Watertown, SDMay 2, 1966 · N9518Q · Substantial damage NTSB MKC66D0524Accident · No injuriesClosedCessna 172 · Yankton, SDMar 31, 1966 · N5600A · Substantial damage NTSB MKC66D0504Accident · No injuriesClosedPiper PA-20 · Mitchell, SDMar 19, 1966 · N1591A · Substantial damage NTSB MKC66D0520Accident · No injuriesClosedEroupe 415-C · Murdo, SDMar 12, 1966 · N94330 · Substantial damage NTSB MKC66F0503Accident · Serious injuriesClosedAeronca 7AC · Alcester, SDMar 1, 1966 · N2261E · Destroyed NTSB MKC66F0443Accident · No injuriesClosedPiper J-3 · Sturgis, SDFeb 26, 1966 · N88392 · Substantial damage NTSB MKC66D0432Accident · No injuriesClosedPiper PA-18 · Summit, SDFeb 18, 1966 · N6980D · Substantial damage NTSB MKC66F0434Accident · No injuriesClosedBellanca 14-19 · Huron, SDFeb 13, 1966 · N7666B · Substantial damage NTSB MKC66D0433Accident · No injuriesClosedPiper J-3 · Bijou Hills, SDFeb 13, 1966 · N70542 · Substantial damage NTSB MKC66F0454Accident · No injuriesClosedPiper PA-28 · Sioux Falls, SDFeb 10, 1966 · N6102W · Substantial damage NTSB MKC66D0459Accident · No injuriesClosedMooney M20C · Chamberlain, SDJan 28, 1966 · N60359 · Substantial damage NTSB MKC66F0454Accident · Serious injuriesClosedPiper PA-11 · Tolstoy, SDJan 25, 1966 · N78820 · Substantial damage NTSB MKC66A0035Accident · 1 fatalClosedMooney M-20C · Timber Lake, SDDec 22, 1965 · N7880V · Destroyed NTSB MKC66F0372Accident · No injuriesClosedCessna 150 · Springfield, SDDec 4, 1965 · N8225S · Substantial damage NTSB MKC66F0355Accident · No injuriesClosedMooney M20A · Rapid City, SDNov 23, 1965 · N1045B · Substantial damage NTSB MKC66A0031Accident · 2 fatalClosedCessna 150 · Mitchell, SDNov 7, 1965 · N7956E · Destroyed NTSB MKC66D0327Accident · No injuriesClosedCessna 170B · Pierre, SDOct 24, 1965 · N2484D · Substantial damage NTSB MKC66A0027Accident · 5 fatalClosedCessna 310C · Highmore S, SDOct 18, 1965 · N1802H · Destroyed NTSB MKC66F0270Accident · No injuriesClosedPiper PA-24 · Wagner, SDOct 16, 1965 · N7440P · Substantial damage NTSB MKC66F0297Accident · No injuriesClosedMooney M20B · Mission, SDOct 15, 1965 · N74747 · Substantial damage NTSB MKC66D0387Accident · No injuriesClosedPiper PA-28 · Sioux Falls, SDOct 15, 1965 · N8963W · Substantial damage NTSB MKC66F0260Accident · No injuriesClosedMooney M21 · Mitchell, SDSep 14, 1965 · N5544Q · Substantial damage