NTSB investigations, SD
28 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 3 |
| 2003 | 1 |
| 2006 | 2 |
| 2007 | 2 |
Where
Open the mapLatest cases
Query with SQL
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 CHI07TA241Accident · Minor injuriesFinal reportChristen Industries A-1 · Elm Springs, SDThe pilot not maintaining clearance from the rising terrain. A factor contributing to the accident was the rising terrain.NTSB CHI07TA201Accident · Minor injuriesFinal reportWSK PZL Mielec PZL M18B · Kyle, SDThe pilot's failure to maintain clearance from terrain during an aerial application maneuver. Contributing to the accident were wind gusts, low altitude, and the reported downdraft.NTSB CHI07LA050Accident · Minor injuriesLimited investigationFinal reportBeech B-99 · Rapid City, SDThe pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.NTSB CHI06CA234Accident · No injuriesData collectionFinal reportBeech 19A · Yankton, SDThe dual student's premature retraction of the flaps during the attempted go-around which resulted in the impact with the ground. The flight instructor's delay in calling for the go-around was an additional cause.NTSB CHI03LA133Accident · 1 fatalLimited investigationFinal reportAir & Space 18A · South Shore, SDThe pilot's failure to maintain clearance from the terrain. The pilot's lack of experience, the rain, the dark night, the low ceiling, and the rising terrain were contributing factors to the accident.NTSB CHI01FA001Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Rapid City, SDSuicideNTSB CHI00FA265Accident · 3 fatalField investigationFinal reportCessna 340A · Mission, SDthe aircraft control not maintained by the pilot. A contributing factor was pilot fatigue.NTSB CHI00LA131Accident · No injuriesLimited investigationFinal reportHughes 269C · Aberdeen, SDthe ground resonance encountered by the pilot.NTSB CHI97LA254Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Britton, SDthe pilot's failure to maintain clearance with the terrain during the spray run and his failure to maintain adequate airspeed during the turn after having contacted the terrain. A factor was the pilot's diverted attention.NTSB CHI95DTK01Accident · 1 fatalFinal reportGay RV-4 · Lennox, SDThe pilot's failure to maintain adequate altitude while performing aerobatic maneuvers. The pilot's impairment of judgment and performance due to drugs was a factor.NTSB CHI94LA139Accident · No injuriesLimited investigationFinal reportCessna 172K · Howes, SDThe diverted attention of the pilot-in-command and his failure to maintain proper altitude.NTSB CHI94LA034Accident · 1 fatalLimited investigationFinal reportCessna 175 · Hot Springs, SDThe failure of the pilots to maintain sufficient altitude to ensure terrain clearance. Factors which contributed to the accident were: the dark night and rising terrain.NTSB CHI92LA233Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · Madison, SDThe pilot's inadequate visual lookout and inadvertent descent.NTSB CHI92DTK02Accident · No injuriesFinal reportWeatherly 201C · Timber Lake, SDThe pilot's improper use of the propeller control during takeoff and initial climb.NTSB DEN88LA035Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newell, SDThe plt reported that he was surveying a field of winter wheat at approximately 100 feet AGL in slow flight. The wind was strong and gusty and the acft began to settle toward the ground. The plt added full power, however, the left main landing gear struck the…NTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…NTSB DEN87FA167Accident · 1 fatalField investigationFinal reportMooney M20F · Mitchell, SDThis non-licensed plt made an unauthorized flt at night. The acft crashed one half mile north of the arpt. The occupant of the acft was fatally injured. No records of the plt's flt experience was found.NTSB DEN87LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Eureka, SDAfter normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.NTSB DEN86FTK04Accident · Serious injuriesFinal reportPiper PA-25-235 · Clear Lake, SDThere was a power line across the approach to the field being treated. The plt reports that he got too low during the flare out for entry to the swath run. The wheels contacted the sunflower crop and the acft impacted the ground. A fire developed during…NTSB DEN85FTK01Accident · Serious injuriesFinal reportBoeing A75 · Tea, SDThe owner/plt-in-command (PIC) took off on a local flt with another occupant in the front seat. The front seat occupant was a commercial, single-eng, multi-eng plt with an instructor rating, but he had no previous experience in A75 acft. While in flt, the PIC…NTSB DEN84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Canton, SDDuring a descending apch to an unfamiliar cornfield for a swath run, the plt stated he had 'a flashing vision of wires.' The plt pushed the control stick forward to avoid hitting the wires at which time the acft contacted a corn crop in a slight nose down…NTSB DEN84FA008Accident · No injuriesField investigationFinal reportConvair 340/440 · Pierre, SDAfter landing at Pierre, SD, 2070 lbs of cargo was off-loaded from the aft section of the aft & a new wt & balance was calculated. The aircrew then prepared to takeoff in conditions of low ceiling & fog. The plt-in-command (PIC) initiated the takeoff roll,…NTSB DEN83LA065Accident · No injuriesLimited investigationFinal reportSwearingen SA-26T · Madison, SDThe aircraft collided with a snowbank 10 feet beyond the threshold during landing. After the accident the pilot reportedthat during the final approach to a landing on runway 32, the left main landing gear contacted a 2 foot high snowbank just beyond the…NTSB DEN83FA027Accident · 2 fatalField investigationFinal reportCessna P210 · Sioux Falls, SDAt 1915 while enroute the plt was advised that the destination wx was 100 ft obscured, 3/8 mi in fog. At 2140 the plt contacted approach control & was advised the wx was 100 ft obscured & 1/8 mi with an RVR for rwy 3 of 2,400 ft. he was cleared for an ILS rwy…NTSB DEN83FA001Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wolsey, SDThe pilot had been issued an instrument rating on 8/6/82 and had logged 5.6 hrs since that time. The pilot's instructor believed this would have been his first low approach in actual instrument conditions since he completed his check flight. A witness stated…NTSB DEN82DA187Accident · No injuriesFinal reportCessna 150 · Faith, SDThe pilot reported that the aircraft lifted off the runway nicely, but after climbing to about 75 ft AGL, it started to lose lift and airspeed. He elected to land on a gravel road, but reported that a car was on the roadway. The aircraft was damaged during a…NTSB DEN82DA156Accident · No injuriesFinal reportCessna 172M · Fairburn, SDThe aircraft tookoff with 4 occupants, baggage and 50 gallons of fuel. The density altitude was 4,963 feet. After takeoff, the pilot could not maintain altitude and stalled the aircraft into a field of high grass. The flaps were not used.NTSB DEN82DTK05Accident · No injuriesFinal reportGrumman G-164 · Murdo, SDDuring a spraying operation the landing gear collided with a dirt bank. The pilot returned to the airport and during landing the right wing contacted the runway because of a missing right landing gear. The aircraft ground looped and nosed over.