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 DEN81DTK02Accident · No injuriesClosedCessna 172 · Faith, SDOct 24, 1980 · N84920 · Substantial damage NTSB DEN80FTK01Accident · Minor injuriesClosedCessna 414 · Corsica, SDOct 19, 1980 · N1596T · Substantial damage NTSB DEN80DTK22Accident · No injuriesClosedPiper PA-11 · Olsonville, SDSep 14, 1980 · N4818M · Substantial damage NTSB MKC80FA056Accident · 2 fatalClosedCessna T210N · Summit, SDSep 11, 1980 · N4972C · Destroyed NTSB MKC80FA055Accident · 1 fatalClosedMooney M20J · Summit, SDSep 9, 1980 · N3923H · Destroyed NTSB DEN80DTK21Accident · No injuriesClosedCessna 182 · Miranda, SDAug 30, 1980 · N735XX · Substantial damage NTSB DEN80FTK20Accident · Minor injuriesClosedCessna 172 · Kyle, SDAug 28, 1980 · N7976U · Substantial damage NTSB DEN80FTK19Accident · Minor injuriesClosedBeech B19 · Mobridge, SDAug 2, 1980 · N9745Q · Destroyed NTSB DEN80FTK18Accident · Serious injuriesClosedPiper PA-25 · Tulare, SDJul 24, 1980 · N7057Z · Substantial damage NTSB DEN80FTK17Accident · No injuriesClosedBeech C35 · Yankton, SDJul 20, 1980 · N475R · Substantial damage NTSB DEN80FTK16Accident · Minor injuriesClosedCessna 177B · Sturgis, SDJul 16, 1980 · N35092 · Substantial damage NTSB DEN80DTK15Accident · No injuriesClosedPiper PA-36 · Groton, SDJul 9, 1980 · N9910P · Substantial damage NTSB DEN80FTK14Accident · No injuriesClosedCessna 170A · Garrettson, SDJun 26, 1980 · N9926A · Substantial damage NTSB DEN80FTK13CaseClosedBellanca 8KCAB · Spearfish, SDJun 25, 1980 · N5030N NTSB DEN80DTK12Accident · No injuriesClosedCessna A188B · Pierre, SDJun 2, 1980 · N4487Q · Substantial damage NTSB DEN80FTK11Accident · No injuriesClosedCessna 170A · Britton, SDMay 17, 1980 · N1742D · Substantial damage NTSB MKC80DTK10Accident · No injuriesClosedCessna 150 · Watertown, SDApr 19, 1980 · N4685X · Substantial damage NTSB MKC80FTK09Accident · No injuriesClosedCessna 182 · Spearfish, SDMar 2, 1980 · N5161D · Substantial damage NTSB MKC80FTK08Accident · No injuriesClosedCessna 182M · Pukwana, SDFeb 24, 1980 · N71317 · Substantial damage NTSB MKC80FA021Accident · 4 fatalClosedBeech 95-B55 · Hot Springs, SDFeb 13, 1980 · N8592R · Substantial damage NTSB MKC80FA020Accident · 2 fatalClosedCessna 150 · Sioux Falls, SDFeb 11, 1980 · N17013 · Destroyed NTSB MKC80DTK07Accident · Serious injuriesClosedRaven RX-7 · Chancellor, SDDec 22, 1979 · N2910R · No damage NTSB MKC80FTK06Accident · No injuriesClosedBeech A23 · Tea, SDDec 9, 1979 · N3580R · Substantial damage NTSB MKC80FTK05Accident · No injuriesClosedGrumman AA-5A · Eureka, SDDec 1, 1979 · N26289 · Substantial damage NTSB MKC79FTK03Accident · No injuriesClosedAmer Avco AA-1A · Redfield, SDOct 21, 1979 · N9248L · Substantial damage NTSB MKC80FTK02Accident · No injuriesClosedVarieze Ratan · Aberdeen, SDOct 20, 1979 · N7WC · Substantial damage NTSB MKC80FTK01Accident · Serious injuriesClosedErco 415-C · Sturgis, SDOct 14, 1979 · N2200H · Substantial damage NTSB MKC80FTK04Accident · No injuriesClosedCessna 210 · Dixon, SDOct 11, 1979 · N9544T · Substantial damage NTSB MKC79DTK24Accident · No injuriesClosedCessna 188B · Ashton, SDAug 14, 1979 · N731CS · Substantial damage NTSB MKC79FTK23Accident · Minor injuriesClosedGrumman AA-1B · Brookings, SDAug 6, 1979 · N6333L · Substantial damage NTSB MKC79FTK21Accident · No injuriesClosedPiper PA-36 · Hayes, SDJul 27, 1979 · N9956P · Destroyed NTSB MKC79FTK20Accident · No injuriesClosedPiper PA-25 · Belvidere, SDJul 15, 1979 · N8628L · Substantial damage NTSB MKC79DTK22Accident · No injuriesClosedPiper PA-18 · Bath, SDJul 14, 1979 · N40359 · Substantial damage NTSB MKC79DTK19Accident · No injuriesClosedBellanca 7GCBC · Meadow, SDJul 14, 1979 · N53829 · Substantial damage NTSB MKC79DTK18Accident · Serious injuriesClosedRaven RX-6 · Sioux Falls, SDJul 10, 1979 · N1882R · No damage NTSB MKC79FA039Accident · 1 fatalClosedCessna 120 · Madison, SDJul 6, 1979 · N2777N · Destroyed NTSB MKC79FTK17Accident · No injuriesClosedCessna 152 · Delmont, SDJun 10, 1979 · N65583 · Substantial damage NTSB MKC79FTK17Accident · No injuriesClosedHughes 269B · Canistota, SDJun 7, 1979 · N9329F · Substantial damage NTSB MKC79FTK15Accident · No injuriesClosedNa Rockwell S-2R · Blunt, SDMay 26, 1979 · N8501V · Minor damage NTSB MKC79FTK14Accident · Serious injuriesClosedAero Comdr S2R · Vivian, SDMay 22, 1979 · N39766 · Substantial damage NTSB MKC79FA029Accident · 1 fatalClosedPiper PA-18 · Oelrichs, SDMay 19, 1979 · N240T · Destroyed NTSB MKC79FTK13Accident · No injuriesClosedAero Comdr 100 · Plate, SDMay 6, 1979 · N4114X · Substantial damage NTSB MKC79FTK12Accident · No injuriesClosedCessna 172 · Howard, SDApr 22, 1979 · N5602T · Substantial damage NTSB MKC79FTK11Accident · No injuriesClosedCessna 140 · Redowl, SDApr 22, 1979 · N77191 · Substantial damage NTSB MKC79FTK10Accident · No injuriesClosedBellanca 7GCBC · Long Lake, SDApr 19, 1979 · N31276 · Substantial damage NTSB MKC79FTK09Accident · No injuriesClosedPiper PA-24 · Pierre, SDMar 18, 1979 · N8916P · Substantial damage NTSB MKC79FTK08Accident · No injuriesClosedCessna 172 · Stockholm, SDMar 5, 1979 · N5428R · Substantial damage NTSB MKC79DTK07Accident · No injuriesClosedCessna 180 · Bullhead, SDFeb 19, 1979 · N2698Y · Substantial damage NTSB MKC79FTK06Accident · Serious injuriesClosedChampion 7ECA · Leola, SDDec 30, 1978 · N5142T · Substantial damage NTSB MKC79FTK05Accident · No injuriesClosedCessna 150 · Parkston, SDDec 8, 1978 · N19513 · Substantial damage