NTSB investigations, SD
39 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1983 | 3 |
|---|---|
| 1984 | 1 |
| 1985 | 4 |
| 1986 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 3 |
| 2005 | 2 |
| 2007 | 1 |
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\" = 220)
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" = 220) 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 CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.NTSB CHI05LA164Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bristol, SDThe pilot's failure to maintain clearance with the static lines between the transmission towers. A factor associated with the accident were the static lines.NTSB CHI05CA147Accident · Minor injuriesData collectionFinal reportBell 47G · Twin Brooks, SDThe pilot's inadequate lookout and his failure to maintain clearance with the power lines. A factor was the low altitude at which the helicopter was operating.NTSB CHI03LA254Accident · No injuriesLimited investigationFinal reportWeatherly 620A · Doland, SDThe pilot's failure to maintain clearance from the wires and directional control not being possible due to the failure of the brake system. Factors contributing to the accident were the wires, the trees, and the failure of the brake system.NTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.NTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.NTSB CHI01LA251Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pierre, SDclearance not obtained by the pilot. A contributing factor was the transmission line.NTSB CHI01LA033Accident · Minor injuriesLimited investigationFinal reportSaab 340-B · Aberdeen, SDthe impact with the flock of snow geese.NTSB CHI00FA288Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Custer, SDThe pilot not maintaining clearance from the tree. Factors relating to this accident were the pilot's inadequate preflight planning and preparation, the high density altitude, the inadequate rate of climb, the pilot's improper in-flight decision to fly into…NTSB CHI99FA285Accident · 2 fatalField investigationFinal reportBell 206B · Custer, SDThe pilot's failure to maintain adequate altitude/clearance from the trees. Contributing to the accident was the pilot's inadvertent settling with power.NTSB CHI99LA214Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Timber Lake, SDthe pilots selection of the shorter runway and his failure to abort the takeoff. Factors to the accident were the high density altitude, the fence and the fence posts.NTSB CHI98LA368Accident · 2 fatalLimited investigationFinal reportGrumman American AA-5B · Deadwood, SDThe pilot's failure to maintain adequate clearance from the trees.NTSB CHI98LA219Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Mobridge, SDThe pilot's failure to maintain clearance from the power lines. Factors associated with the accident were the power lines, and the separation of the vertical stabilizer and rudder which resulted in the pilot's inability to maintain directional control of the…NTSB CHI97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Castlewood, SDThe pilot's failure to maintain adequate clearance from the trees.NTSB CHI97LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Faulkton, SDthe pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.NTSB CHI97LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Huron, SDThe pilot's failure to maintain clearance from known transmission lines.NTSB CHI97LA106Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDa premature lift-off of the airplane by the pilot in command.NTSB CHI95LA077Accident · No injuriesLimited investigationFinal reportCessna 150F · Castlewood, SDthe pilot's inadequate preflight planning and preparation. Factors associated with the accident are the snow covered/drifted runway, and a fence.NTSB CHI94LA191Accident · 1 fatalLimited investigationFinal reportHiller HU-12E · Watertown, SDthe pilot's failure to maintain a visual lookout. A factor associated with the accident was the powerlines.NTSB CHI94LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Woonsocket, SDthe pilot misjudging the airplane's clearance under the wires. Factors related to the accident were the performance of a low pass and the wires which were contacted.NTSB CHI93LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mc Laughlin, SDPilot in command's failure to maintain proper clearance.NTSB CHI93LA148Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Yankton, SDThe pilot in command's failure to maintain proper clearance. Gusty wind conditions were a factor.NTSB CHI92DTK03Accident · Serious injuriesFinal reportPiper PA-25-235/250 · Ramona, SDFailure of the pilot to maintain a visual lookout while maneuvering during aerial application of agricultural chemicals.NTSB CHI92LA114Accident · Minor injuriesLimited investigationFinal reportBellanca 7 Gcbc · Quinn, SDThe pilot's inadequate visual lookout.NTSB CHI93LA381Accident · No injuriesLimited investigationFinal reportCessna 172 · Union Center, SDImproper planning/decision by the pilot, and his failure to abort the takeoff, while there was sufficient runway remaining. Factors related to the accident were: the soft runway condition & fence at the end of the runway.NTSB CHI91DTK05Accident · No injuriesFinal reportEagle DW1 · Hurley, SDThe failure of the pilot to maintain a visual lookout.NTSB CHI91LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hill City, SDPoor preflight planning by the pilot and over confidence in the aircrafts ability. Factors related to the accident were a high density altitude and a proper climb rate not attained.NTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.NTSB DEN89DTK01Accident · 1 fatalFinal reportPiper PA-36-300 · Agar, SDThe pilot's failure to maintain an adequate clearance with the powerlines. The powerline is considered to be a contributing factor to the accident.NTSB DEN89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Milbank, SDFailure by the pilot to assure adequate removal of frost from the aircraft which resulted in a stall/mush.NTSB DEN86FTK01Accident · Serious injuriesFinal reportBellanca 7GCBC · Huron, SDThe acft contacted powerlines and descended uncontrolled to ground impact. The plt reported that he was checking fields when the accident occurred. The acft was traveling to the west into the setting sun when accident occurred.NTSB DEN86FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Chamberlain, SDThe plt and his passenger friend were looking for stray cattle when aprx at 142 ft above the ground their acft struck an antennae mounted on a microwave tower. The acft descended and was destroyed on ground impact.NTSB DEN85LTK02Accident · Minor injuriesFinal reportPiper PA-25-235 · Yankton, SDThe acft descended uncontrolled into the terrain after it contacted a power line during an aerial application flt. Witnesses reported the acft appeared to pull up at the west end of the 40 acre fld, however, it did not clear the lines and it nosed over into…NTSB DEN85LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Platte, SDWhile the plt was spraying a field, the landing gear of the acft struck the center pivot of an irrigation structure. Later, when the acft was landed, the gear collapsed.NTSB DEN85LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Claire City, SDThe acft collided with power lines during an aerial application flt. The power lines were located in the middle of the field being sprayed and during the last spray run, while flying into the sun, the acft contacted the lines.NTSB DEN84LA186Accident · 1 fatalLimited investigationFinal reportCessna 188 · Groton, SDDuring aerial application flight, the aircraft passed beneath two power lines. The top of the vertical fin and collision avoidance beacon light apparently made contact with the first wire, as they were found separated near that location. After contact, the…NTSB DEN84FA021Accident · Serious injuriesField investigationFinal reportConvair 580 · Sioux Falls, SDThe acft collided with a bird during the landing approach at night. The captain who was flying the acft was struck in the face by the bird and flying glass. The co-plt completed the landing due to incapacitation of the capt. investigationrevealed the…NTSB DEN83LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-25B-235 · Montrose, SDThe pilot stated that he was spraying a field that was divided in half by a 60 foot high powerline. As he made a turn to enter the south side of the field, parallel to the powerlines, flying east into the sun, he struck the unseen guy cables out in the field.…NTSB DEN83FTK03Accident · Serious injuriesFinal reportBeech V35A · Sioux Falls, SDDuring an ILS approach to rwy 3 the acft collided with 50 ft powerlines 3 mi sw of the arpt. The acft then collided witha mobile home & pickup truck. Half of the 60 ft mobile home & the truck were destroyed. Minimum altitude at the lim, located 5.2 mi from…