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 MKC77DTK32Accident · No injuriesClosedBellanca 7GCBC · Camp Crook, SDJul 12, 1977 · N5132X · Substantial damage NTSB MKC77FTK30Accident · No injuriesClosedPiper PA-28 · Plankinton, SDJul 5, 1977 · N5590W · Substantial damage NTSB MKC77DTK28Accident · Serious injuriesClosedCessna 188B · Turton, SDJun 27, 1977 · N91974 · Substantial damage NTSB MKC77DKT29Accident · No injuriesClosedCessna 172 · Camp Crook, SDJun 27, 1977 · N2763U · Substantial damage NTSB MKC77FTK27Accident · 1 fatalClosedPiper PA-20 · Onida, SDJun 17, 1977 · N1507A · Destroyed NTSB MKC77DTK26Accident · No injuriesClosedPiper PA-24 · Philip, SDJun 15, 1977 · N8916P · Substantial damage NTSB MKC77FA025CaseClosedMooney M20J · Madison, SDJun 13, 1977 NTSB MKC77DTK25Accident · No injuriesClosedStinson 108-2 · Ft Thompson, SDJun 11, 1977 · N392C · Substantial damage NTSB MKC77FTK24Accident · No injuriesClosedPiper PA-36 · Hayes, SDJun 7, 1977 · N40983 · Substantial damage NTSB MKC77FTK23Accident · Serious injuriesClosedCessna 170 · Murdo, SDJun 6, 1977 · N2573C · Substantial damage NTSB MKC77DTK22Accident · No injuriesClosedCessna 172 · Ethan, SDMay 29, 1977 · N4144F · Substantial damage NTSB MKC77DTK21Accident · No injuriesClosedPiper PA-18 · Ft Pierre, SDMay 26, 1977 · N6999V · Substantial damage NTSB MKC77FTK20Accident · Serious injuriesClosedAeronca 7GCB · Northville, SDMay 19, 1977 · N9871Y · Destroyed NTSB MKC77FTK18Accident · No injuriesClosedGrumman G-164A · Martin, SDMay 8, 1977 · N8367 · Substantial damage NTSB MKC77DTK19Accident · No injuriesClosedPiper PA-18 · Pierre, SDMay 8, 1977 · N4582A · Substantial damage NTSB MKC77FTK17Accident · No injuriesClosedPiper PA-28 · Mclaughlin, SDMay 2, 1977 · N5025W · Substantial damage NTSB MKC77FTK16Accident · Minor injuriesClosedCessna 172H · Hot Springs, SDApr 28, 1977 · N3893R · Substantial damage NTSB MKC77FA022Accident · 1 fatalClosedPiper PA-36 · Pierre, SDApr 26, 1977 · N57821 · 2 aircraft · Substantial damage NTSB MKC77FTK15Accident · No injuriesClosedCessna 195A · Sturgis, SDApr 25, 1977 · C-GXAV · Substantial damage NTSB MKC77FA021Accident · 1 fatalClosedCessna 182M · Aberdeen, SDApr 22, 1977 · N91622 · Destroyed NTSB MKC77DTK14Accident · No injuriesClosedPiper PA-18 · Redfield, SDApr 18, 1977 · N40359 · Substantial damage NTSB MKC7MFTK13Accident · No injuriesClosedBellanca 8GCBC · Lemmon, SDMar 23, 1977 · N8635V · Substantial damage NTSB MKC77PTK12Accident · Minor injuriesClosedCessna 172 · Chamberlain, SDMar 17, 1977 · N8237X · Substantial damage NTSB MKC77FTK11Accident · No injuriesClosedGrumann AA-5 · Rapid City, SDMar 13, 1977 · N74878 · Substantial damage NTSB MKC77FTK10Accident · No injuriesClosedPiper PA-18 · Hayes, SDMar 13, 1977 · N3236P · Substantial damage NTSB MKC77DTK09Accident · No injuriesClosedCessna 140 · Philip, SDMar 6, 1977 · N1962N · Substantial damage NTSB MKC77FTK07Accident · No injuriesClosedCessna 170B · Gettysburg, SDFeb 27, 1977 · N1997C · Substantial damage NTSB MKC77DTK08Accident · No injuriesClosedCessna 170A · Lemmon, SDFeb 18, 1977 · N5468C · Substantial damage NTSB MKC77FTK06Accident · Serious injuriesClosedCessna 177 · Kadoka, SDFeb 5, 1977 · N2273Y · Substantial damage NTSB MKC77FTK05Accident · No injuriesClosedCessna 150 · Holabird, SDJan 2, 1977 · N8433G · Substantial damage NTSB MKC77FA009Accident · 2 fatalClosedPiper PA-28R · Kadoka, SDDec 25, 1976 · N2943R · Destroyed NTSB MKC77FTK04Accident · No injuriesClosedPiper PA-11 · Lake Preston, SDDec 16, 1976 · N4528M · Substantial damage NTSB MKC77FTK02Accident · No injuriesClosedPiper PA-32 · Dell Rapids, SDOct 24, 1976 · N16415 · Substantial damage NTSB MKC77DTK03Accident · Minor injuriesClosedPiper PA-22 · Freeman, SDOct 10, 1976 · N3008Z · Substantial damage NTSB MKC77DTK01Accident · No injuriesClosedPiper PA-22 · Huron, SDOct 9, 1976 · N5292Z · 2 aircraft · Substantial damage NTSB MKC76FTK33Accident · No injuriesClosedCessna 310L · Carpenter, SDAug 21, 1976 · N3331X · Substantial damage NTSB MKC76DTK32Accident · No injuriesClosedBeech A23A · Prairie City, SDAug 10, 1976 · N3541R · Substantial damage NTSB MKC76FTK31Accident · Serious injuriesClosedPiper J3C-65 · Onida, SDJul 10, 1976 · N3423N · Substantial damage NTSB MKC76DTK30Accident · No injuriesClosedCessna 170B · Pierre, SDJul 6, 1976 · N8191A · Substantial damage NTSB MKC76FTK29Accident · No injuriesClosedPiper PA-30 · Rapid City, SDJun 13, 1976 · N7982Y · Substantial damage NTSB MKC76FTK28Accident · Minor injuriesClosedPiper PA-25 · Sturgis, SDJun 11, 1976 · N7500Z · Destroyed NTSB MKC76FTK27Accident · Minor injuriesClosedBell 47G-2 · Cactus Flats, SDJun 1, 1976 · N46R · Substantial damage NTSB MKC76FTK26Accident · No injuriesClosedAeronca 7AC · Philip, SDMay 30, 1976 · N85149 · Substantial damage NTSB MKC76FTK24Accident · Serious injuriesClosedCessna 177RG · Yale, SDMay 9, 1976 · N1169M · Destroyed NTSB MKC76DTK25Accident · No injuriesClosedAeronca 15AC · Union Center, SDMay 4, 1976 · N1240H · Substantial damage NTSB MKC76AK055Accident · 1 fatalClosedPiper PA-18 · Hayes, SDApr 25, 1976 · N4405Z · Destroyed NTSB MKC76FTK23Accident · Serious injuriesClosedPiper PA-39 · Mitchell, SDApr 23, 1976 · N8884Y · Destroyed NTSB MKC76DTK22Accident · No injuriesClosedCessna 172E · Sioux Falls, SDApr 16, 1976 · N3883S · Substantial damage NTSB MKC76FTK21Accident · No injuriesClosedPiper PA-28 · Clear Lake, SDApr 2, 1976 · N5205W · Substantial damage NTSB MKC76FTK20Accident · Serious injuriesClosedCessna 210L · Faulkton, SDFeb 11, 1976 · N5157Q · Substantial damage