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 MKC66D0225Accident · No injuriesClosedStinson 108-2 · Huron, SDSep 1, 1965 · N9532K · Substantial damage NTSB MKC66D0198Accident · No injuriesClosedCessna 172 · Kaylor, SDAug 22, 1965 · N7499X · Substantial damage NTSB MKC66F0176Accident · Minor injuriesClosedCessna 170B · Skyranch, SDAug 14, 1965 · N3405C · Substantial damage NTSB MKC66D0265Accident · No injuriesClosedMooney M20C · Iona, SDAug 11, 1965 · N79334 · Substantial damage NTSB MKC66D0234Accident · Serious injuriesClosedCessna 172D · Lak Preston, SDAug 11, 1965 · N8585X · Substantial damage NTSB MKC66D0272Accident · No injuriesClosedLuscombe 8A · Wessingtn Sps, SDAug 9, 1965 · N71922 · Substantial damage NTSB MKC66F0151Accident · Serious injuriesClosedPiper J3C · Pukwana, SDAug 5, 1965 · N88647 · Destroyed NTSB MKC66F0150Accident · Minor injuriesClosedCessna 172 · Aberdeen, SDAug 4, 1965 · N3617S · Substantial damage NTSB MKC66F0162Accident · No injuriesClosedBellanca 14-19 · Bison, SDJul 30, 1965 · N7676B · Substantial damage NTSB MKC66D0199Accident · No injuriesClosedPiper PA-18A · Redfield, SDJul 30, 1965 · N9774D · Substantial damage NTSB MKC66A0005Accident · No injuriesClosedBell 47G2 · Keystone, SDJul 22, 1965 · N262MV · Substantial damage NTSB MKC66F0100Accident · No injuriesClosedMooney M20E · No Sioux City, SDJul 13, 1965 · N79369 · Substantial damage NTSB MKC66F0132Accident · No injuriesClosedAeronca 15AC · Ft Pierre, SDJul 12, 1965 · N1127H · Substantial damage NTSB MKC66F0036Accident · No injuriesClosedCessna 210 · Sioux Falls, SDJun 16, 1965 · N9599T · Substantial damage NTSB MKC66F0067Accident · No injuriesClosedCessna 140 · Columbia, SDJun 10, 1965 · N2341N · Substantial damage NTSB MKC65A0073Accident · 2 fatalClosedAeronca 7AC · Winner, SDJun 10, 1965 · N2042E · Destroyed NTSB MKC66F0104Accident · Minor injuriesClosedPiper PA-18 · Tulare, SDJun 8, 1965 · N1011A · Destroyed NTSB MKC66F0105Accident · No injuriesClosedCessna 195 · Aberdeen, SDJun 6, 1965 · N1561D · Substantial damage NTSB MKC66F0047Accident · No injuriesClosedMooney 721 · Pierre, SDJun 3, 1965 · N79369 · Substantial damage NTSB MKC66F0115Accident · No injuriesClosedPiper J3C · Viewfield, SDMay 29, 1965 · N70927 · Substantial damage NTSB MKC66F0049Accident · Minor injuriesClosedPiper PA-11 · Frankfort, SDMay 28, 1965 · N4777H · Substantial damage NTSB MKC65F0136Accident · Minor injuriesClosedCessna 172 · Sioux Falls, SDMay 9, 1965 · N2758U · Substantial damage NTSB MKC65F0141Accident · No injuriesClosedPiper PA-15 · Rapid City, SDMay 4, 1965 · N4481H · Substantial damage NTSB MKC65F0110Accident · No injuriesClosedCessna 172 · Sioux Falls, SDMay 2, 1965 · N3898S · Substantial damage NTSB MKC65D0096Accident · No injuriesClosedCessna 182 · Yankton, SDMay 1, 1965 · N5558B · Substantial damage NTSB MKC65A0062Accident · 2 fatalClosedBeechcraft T-34 · Hermosa, SDApr 22, 1965 · N4988E · Destroyed NTSB MKC65D0103Accident · No injuriesClosedCessna 182 · Huron, SDApr 15, 1965 · N9333X · Substantial damage NTSB MKC65F0076Accident · No injuriesClosedPiper PA-30 · Huron, SDApr 8, 1965 · N7150Y · Substantial damage NTSB MKC65F0066Accident · No injuriesClosedCessna 140 · Rapid City, SDMar 20, 1965 · N2335V · Substantial damage NTSB MKC65F0067Accident · No injuriesClosedCessna 195A · Aberdeen, SDMar 19, 1965 · N1540D · Substantial damage NTSB MKC65F0111Accident · No injuriesClosedPiper PA-23 · Huron, SDFeb 5, 1965 · N3008P · Substantial damage NTSB MKC65F0010Accident · No injuriesClosedMooney M20 · Pierre, SDJan 10, 1965 · N5206B · Substantial damage NTSB MKC65F0011Accident · No injuriesClosedCessna 182 · Fort Thompson, SDJan 6, 1965 · N5306B · Substantial damage NTSB UNK65X1181Accident · Minor injuriesClosedPiper PA17 · Strandburg, SDDec 29, 1964 · N5548H · Substantial damage NTSB UNK65X1147Accident · No injuriesClosedCessna 210 · Winner, SDDec 26, 1964 · N9456T · Substantial damage NTSB UNK65X1122Accident · 2 fatalClosedPiper PA-24 · Philip, SDDec 24, 1964 · N8489P · Destroyed NTSB UNK65X1106Accident · No injuriesClosedMaule M4 · Rosholt, SDDec 23, 1964 · N4734T · Substantial damage NTSB UNK65X1087Accident · No injuriesClosedBeechraft 35B33 · Gregory, SDDec 22, 1964 · N1548Z · Substantial damage NTSB UNK65X0836Accident · No injuriesClosedCessna 170 · Freeman, SDNov 25, 1964 · N3947V · Destroyed NTSB UNK65X0579Accident · No injuriesClosedBeechcraft 65 · Sioux Falls, SDNov 6, 1964 · N956B · Substantial damage NTSB UNK65X0275Accident · No injuriesClosedMooney M20A · Rapid City, SDOct 14, 1964 · N8108E · Substantial damage NTSB UNK64X4114Accident · No injuriesClosedChampion 7FC · Sioux Falls, SDSep 23, 1964 · N9866B · Substantial damage NTSB UNK64X4113Accident · No injuriesClosedPiper PA22 · Watertown, SDSep 23, 1964 · N2464A · Substantial damage NTSB UNK64X4049Accident · No injuriesClosedCessna 170 · Clear Lake, SDSep 19, 1964 · N2232D · Substantial damage NTSB UNK64X4018Accident · No injuriesClosedCessna 182 · Eureka, SDSep 17, 1964 · N5931B · Substantial damage NTSB UNK64X3966Accident · No injuriesClosedCessna 170 · Hot Springs, SDSep 13, 1964 · N3828V · Substantial damage NTSB UNK64X3802Accident · Serious injuriesClosedMooney M20 · Huron, SDSep 5, 1964 · N6534B · Destroyed NTSB UNK64X3790Accident · Minor injuriesClosedStits SA3B · Mobridge, SDSep 5, 1964 · N4985E · Destroyed NTSB UNK64X3708Accident · No injuriesClosedPiper PA28 · Pine Ridge, SDAug 31, 1964 · N8699W · Substantial damage NTSB UNK64X3706Accident · No injuriesClosedCessna 120 · White River, SDAug 31, 1964 · N3044N · Substantial damage