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 MKC74DTK15Accident · Serious injuriesClosedGrumman G-164 · Hayes, SDMay 12, 1974 · N615U · Substantial damage NTSB MKC74AK065Accident · 1 fatalClosedCessna 150L · Kranzburg, SDMay 9, 1974 · N11949 · Destroyed NTSB MKC74DTK16Accident · No injuriesClosedBellanca 7GCBC · Lemmon, SDApr 30, 1974 · N68572 · Substantial damage NTSB MKC74FTK14Accident · No injuriesClosedPiper PA-30 · Rapid City, SDApr 26, 1974 · N8127Y · Substantial damage NTSB MKC74DTK13Accident · No injuriesClosedBellanca 17-30A · Kyle, SDMar 13, 1974 · N6592V · Substantial damage NTSB MKC74DTK12Accident · No injuriesClosedBellanca 300 · Kyle, SDMar 9, 1974 · N6592V · Substantial damage NTSB MKC74DTK11Accident · No injuriesClosedPiper PA-28 · Stickney, SDFeb 20, 1974 · N1753T · Substantial damage NTSB MKC74DTK0DAccident · No injuriesClosedCessna 182 · Gettysburg, SDFeb 17, 1974 · N71045 · Substantial damage NTSB MKC74AK049Accident · No injuriesClosedVolpar D18S · Tea, SDFeb 15, 1974 · N603LS · Substantial damage NTSB MKC74AK048Accident · Minor injuriesClosedBeech F33A · Gettysburg, SDFeb 12, 1974 · N6DH · Substantial damage NTSB MKC74DTK10Accident · No injuriesClosedCessna 172F · Hot Springs, SDFeb 8, 1974 · N8307U · Substantial damage NTSB MKC74DTK08Accident · No injuriesClosedCessna 170A · Bemis, SDJan 20, 1974 · N1279D · Substantial damage NTSB MKC74DTK07Accident · No injuriesClosedCessna 170B · Cedar Butte, SDJan 16, 1974 · N2716C · Substantial damage NTSB MKC74FTK06Accident · No injuriesClosedPiper PA-18 · Midland, SDJan 8, 1974 · N4485Z · Substantial damage NTSB MKC74AK034Accident · 1 fatalClosedCessna 150L · Turton, SDDec 23, 1973 · N7020G · Substantial damage NTSB MKC74AK032Accident · 1 fatalClosedBellanca 7GCBC · Lebanon, SDDec 15, 1973 · N12201 · Destroyed NTSB MKC74DTK05Accident · Serious injuriesClosedCessna 150 · Sturgis, SDNov 13, 1973 · N8209S · Substantial damage NTSB MKC74AK011Accident · 1 fatalClosedCessna 180 · Wessington, SDSep 8, 1973 · N9170C · Destroyed NTSB MKC74DTK04Accident · No injuriesClosedCessna 182 · Onida, SDSep 2, 1973 · N92823 · Substantial damage NTSB DEN74AD009Accident · Serious injuriesClosedBoeing 737 · Rapid City, SDAug 22, 1973 · N7381F · No damage NTSB MKC74DTK03Accident · No injuriesClosedCessna 172G · Monroe, SDAug 18, 1973 · N4444L · Substantial damage NTSB MKC74IK005Incident · No injuriesClosedBeech D18S · Mitchell, SDAug 10, 1973 · N80201 · Minor damage NTSB MKC74DTK02Accident · No injuriesClosedLuscombe 8A · Estelline, SDJul 27, 1973 · N72014 · Destroyed NTSB MKC74DTK01Accident · No injuriesClosedCessna 305A · Spearfish, SDJul 8, 1973 · N5283G · Substantial damage NTSB MKC73FTK18Accident · No injuriesClosedPiper PA-25 · Gettysburg, SDJun 22, 1973 · N7620Z · Substantial damage NTSB MKC73FTK17Accident · 1 fatalClosedSnow S2A · Fort Pierre, SDJun 11, 1973 · N9457R · Substantial damage NTSB MKC73FTK14Accident · Serious injuriesClosedAero Comdr 600S2R · Pierre, SDJun 4, 1973 · N39767 · Destroyed NTSB MKC73FTK16Accident · No injuriesClosedStinson 108-3 · Pierre, SDMay 8, 1973 · N6402M · Substantial damage NTSB MKC73DTK15Accident · Minor injuriesClosedPiper PA-18 · Winner, SDMay 6, 1973 · N3598Z · Substantial damage NTSB MKC73FTK13Accident · No injuriesClosedPiper PA-24 · Mud Butte, SDApr 18, 1973 · N6574P · Substantial damage NTSB MKC73FTG10Accident · No injuriesClosedCessna 305A · Bismarck, SDApr 4, 1973 · N5210G · Substantial damage NTSB MKC73FTK12Accident · No injuriesClosedForney F-1A · Mobridge, SDMar 25, 1973 · N3028G · Substantial damage NTSB MKC73AK049Accident · 2 fatalClosedPiper PA-28 · Mitchell, SDJan 26, 1973 · N7280J · Destroyed NTSB MKC73FTK11Accident · Serious injuriesClosedPiper PA-18 · Mclaughlin, SDJan 11, 1973 · N8176D · Substantial damage NTSB MKC73DTK10Accident · No injuriesClosedPiper J3C · Volga, SDNov 26, 1972 · N35124 · Substantial damage NTSB MKC73AK030Accident · 2 fatalClosedTaylorcraft BC12-D · Eagle Butte, SDNov 1, 1972 · N6601N · Substantial damage NTSB MKC73FTK08Accident · No injuriesClosedCallair A-9A · Murdo, SDOct 20, 1972 · N8288H · Substantial damage NTSB MKC73DTK07Accident · Minor injuriesClosedPiper PA-22 · Mioland, SDOct 7, 1972 · N1426A · Destroyed NTSB MKC73FTK06Accident · No injuriesClosedNardi FN-333 · Canton, SDOct 3, 1972 · N623 · Substantial damage NTSB DEN73DTC08Accident · No injuriesClosedPiper PA-18 · Bell Fourch, SDSep 1, 1972 · N8254C · Substantial damage NTSB MKC73DTK05Accident · No injuriesClosedMooney MK20 · Pierre, SDAug 20, 1972 · N5206B · Substantial damage NTSB MKC73FTK04Accident · Minor injuriesClosedCessna 170A · Lemmon, SDAug 18, 1972 · N5740C · Substantial damage NTSB MKC73FTK03Accident · Serious injuriesClosedAeronca 7BCM · Sisseton, SDAug 14, 1972 · N3174C · Destroyed NTSB MKC73FTK02Accident · Minor injuriesClosedCessna 180 · Watertown, SDAug 6, 1972 · N9033C · Substantial damage NTSB DEN73DTC02Accident · No injuriesClosedPiper PA-18 · Belle Frche, SDJul 21, 1972 · N1636A · Substantial damage NTSB MKC73FTK01Accident · No injuriesClosedGrumman G-164 · Pukwana, SDJul 12, 1972 · N607U · Substantial damage NTSB MKC72DTK30Accident · No injuriesClosedPiper PA-25 · Conde, SDJun 3, 1972 · N7326Z · Substantial damage NTSB MKC72FTK29Accident · Serious injuriesClosedPiper PA-18 · Fort Pierre, SDMay 23, 1972 · N3471Z · Substantial damage NTSB MKC72FTK28Accident · Serious injuriesClosedLuscombe 8A · Martin, SDMay 14, 1972 · N1222K · Substantial damage NTSB MKC72FTK27Accident · Minor injuriesClosedBell 47G-5 · Pierre, SDApr 6, 1972 · N7870S · Substantial damage