Skip to content

NTSB investigations, SD

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" = '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 MKC76FTK19Accident · Serious injuriesClosedPiper PA-18 · Milbank, SDJan 24, 1976 · N6980D · Substantial damage NTSB CHI76AC041Accident · 5 fatalClosedBeech P35 · Ft Pierre, SDDec 25, 1975 · N1480G · Destroyed NTSB MKC76FTK18Accident · Minor injuriesClosedCessna 210 · Brookings, SDDec 12, 1975 · N9677X · Substantial damage NTSB MKC76DTK14Accident · No injuriesClosedAeronca 11AC · Oelrichs, SDNov 30, 1975 · N86333 · Substantial damage NTSB MKC76FTK15Accident · Serious injuriesClosedAeronca 7BCM · Watertown, SDNov 28, 1975 · N4293E · Substantial damage NTSB MKC76DTK17Accident · No injuriesClosedCessna 185 · Hot Springs, SDNov 12, 1975 · N9832X · Substantial damage NTSB MKC76DTK12Accident · No injuriesClosedCessna 180 · Chelsea, SDOct 20, 1975 · N101A · Substantial damage NTSB MKC76AK028Accident · 1 fatalClosedPiper PA-28 · Yankton, SDOct 17, 1975 · N8303R · Destroyed NTSB MKC76DTK10Accident · No injuriesClosedPiper PA-32 · Flandreau, SDOct 14, 1975 · N5216S · Substantial damage NTSB MKC76FTK11Accident · Serious injuriesClosedSchreder HP-16 · Lennox, SDOct 12, 1975 · N16DH · Destroyed NTSB MKC76FTK08Accident · No injuriesClosedCessna 182A · Spearfish, SDOct 4, 1975 · N4826D · Substantial damage NTSB MKC76FTK07Accident · No injuriesClosedCessna 180 · Rapid City, SDSep 23, 1975 · N4707B · Substantial damage NTSB MKC76FTK06Accident · No injuriesClosedCessna 172M · Rapid City, SDSep 19, 1975 · N6782H · Substantial damage NTSB MKC76FTK05Accident · Minor injuriesClosedPiper PA-22 · Rapid City, SDSep 6, 1975 · N9169D · Substantial damage NTSB MKC76AK019Accident · 2 fatalClosedPiper PA-18 · Hayes, SDSep 5, 1975 · N5487H · Destroyed NTSB MKC76DTK04Accident · No injuriesClosedWaco UPF-7 · N Sioux City, SDAug 30, 1975 · N29974 · Substantial damage NTSB MKC76AK014Accident · 1 fatalClosedCessna 210J · Summit, SDAug 29, 1975 · N3392S · Destroyed NTSB MKC76FTK03Accident · Serious injuriesClosedLuscombe 8E · Watertown, SDAug 5, 1975 · N1820K · Destroyed NTSB MKC76AK012Accident · 3 fatalClosedBell 47G-5 · Keystone, SDAug 5, 1975 · N4753R · Substantial damage NTSB MKC76FTK02Accident · Minor injuriesClosedBell 47-G2A · Keystone, SDJul 25, 1975 · N7578 · Substantial damage NTSB MKC76DTK01Accident · No injuriesClosedCessna 180 · Buffalo, SDJul 23, 1975 · N6453X · Substantial damage NTSB MKC76AK007Accident · 1 fatalClosedCessna 150F · Plankinton, SDJul 9, 1975 · N5643G · Destroyed NTSB MKC76AK003Accident · Minor injuriesClosedSikorsky S-55B · Pine Ridge, SDJul 4, 1975 · N111RS · Substantial damage NTSB MKC75AK061Accident · Serious injuriesClosedN.American NA-265 · Watertown, SDJun 14, 1975 · N67KM · Substantial damage NTSB MKC75DTK21Accident · No injuriesClosedLuscombe 8A · Hoven, SDJun 6, 1975 · N77859 · Substantial damage NTSB MKC75DTK20Accident · No injuriesClosedPiper J3C-65 · Scenic, SDJun 6, 1975 · N3400N · Substantial damage NTSB MKC75DTK19Accident · No injuriesClosedCessna 140 · Wall, SDJun 4, 1975 · N2335V · Substantial damage NTSB MKC75DTF17Accident · No injuriesClosedPiper PA-18 · Hayes, SDMay 27, 1975 · N3941Z · Substantial damage NTSB MKC75DTK18Accident · Minor injuriesClosedAeronca 7AC · Canton, SDMay 18, 1975 · N85133 · Substantial damage NTSB MKC75FTK16Accident · No injuriesClosedCessna 188T · Freeman, SDMay 1, 1975 · N9246G · Substantial damage NTSB MKC75DTK15Accident · No injuriesClosedMaule M5-210 · Wood, SDApr 27, 1975 · N51590 · Substantial damage NTSB MKC75DTK14Accident · No injuriesClosedBellanca 7ACA · Madison, SDMar 4, 1975 · N9156L · Substantial damage NTSB MKC75DTK13Accident · No injuriesClosedPiper PA-18A · Quinn, SDFeb 22, 1975 · N6886B · Substantial damage NTSB MKC75DTK12Accident · No injuriesClosedPiper PA-18 · Milbank, SDFeb 2, 1975 · N6980D · Substantial damage NTSB MKC75DTK11Accident · No injuriesClosedPiper PA-28 · Iroquis, SDJan 17, 1975 · N5141W · Substantial damage NTSB MKC75DTK10Accident · Minor injuriesClosedCessna 172 · Herreid, SDJan 14, 1975 · N7054G · Destroyed NTSB MKC75DTK09Accident · Minor injuriesClosedCessna 172F · Warner, SDDec 29, 1974 · CF-JIE · Substantial damage NTSB MKC75DTK08Accident · Minor injuriesClosedPiper PA-28 · Dupree, SDDec 3, 1974 · N7738N · Substantial damage NTSB MKC75AK028Accident · 1 fatalClosedPiper PA-18A · Newell, SDNov 25, 1974 · N9884D · Destroyed NTSB MKC75DTK07Accident · No injuriesClosedPiper PA-18 · Cresbard, SDNov 13, 1974 · N1861A · Substantial damage NTSB MKC75FTK06Accident · No injuriesClosedCessna 150H · Timber Lake, SDOct 18, 1974 · N6913S · Substantial damage NTSB MKC75DTK05Accident · No injuriesClosedPiper PA-28 · Pierre, SDOct 16, 1974 · N5767U · Substantial damage NTSB MKC75DTK04Accident · No injuriesClosedAmer Avco AA-1 · N Sioux Cty, SDOct 4, 1974 · N5962L · Substantial damage NTSB MKC75AK022Accident · 2 fatalClosedPiper PA-30 · Bel Fourche, SDSep 22, 1974 · N8307Y · Destroyed NTSB MKC75DTK03Accident · No injuriesClosedCessna 180 · Rapid City, SDSep 21, 1974 · N4644A · Substantial damage NTSB MKC75DTK02Accident · No injuriesClosedCessna 170 · Vermillion, SDSep 17, 1974 · N5732C · Substantial damage NTSB MKC75FTK01Accident · Serious injuriesClosedAeronca 7CCM · Faith, SDAug 30, 1974 · N83540 · Substantial damage NTSB MKC75AK003Accident · 2 fatalClosedMooney M20E · Custer, SDJul 20, 1974 · N9613V · Destroyed NTSB MKC74DTK19Accident · No injuriesClosedPiper PA-28 · Bryant, SDJun 13, 1974 · N3534K · Substantial damage NTSB MKC74DTK17Accident · No injuriesClosedPiper PA-25 · Mobridge, SDJun 4, 1974 · N16502 · Substantial damage