NTSB investigations, SD
20 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 4 |
| 1988 | 2 |
| 1990 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 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\" = 240)
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" = 240) 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 CHI03FA141Accident · 1 fatalField investigationFinal reportCessna 182Q · Gettysburg, SDThe pilot not maintaining aircraft control in cruise flight leading to his inadvertent spiral. A factor was the pilot's in-flight encounter with moderate to heavy rain.NTSB CHI01LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mitchell, SDThe pilot disregarded the aircraft limitation placard, and attempted flight into known adverse weather after receiving a hazardous weather advisory. Factors to the accident were the ice-covered cockpit windshield, the ice-covered runway, and the snowbank.NTSB CHI98LA109Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Whitewood, SDfailure of the pilot to maintain clearance from obstructions (wires) during an approach for a precautionary landing. Factors associated with the accident were: the pilot's inadequate evaluation of the weather conditions, low ceilings, icing conditions, and…NTSB CHI96FA038Accident · 4 fatalField investigationFinal reportPiper PA-28-201T · Belvidere, SDthe pilot's attempted visual flight into instrument meteorological conditions, his failure to maintain control of the airplane, and exceeding the design stress limits of the airplane. Factors in the accident were: the snow and fog, and the aft airplane center…NTSB CHI94FA155Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Mcintosh, SDVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) from rising terrain. Factors related to the accident were: failure of the pilot to update his weather…NTSB CHI94LA056Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Mcintosh, SDwas continued VFR flight into IMC and the failure to maintain clearance with the terrain. Factors associated with this accident were an inaccurate weather evaluation by the pilot, snow and the rising terrain.NTSB DEN90FA076Accident · 4 fatalField investigationFinal reportCessna 182N · Caputa, SDImproper planning/decision by the pilot, accumulation of structural ice and the pilot's failure to maintain control of the aircraft. The adverrse weather was a related factor.NTSB DEN90LA084Accident · No injuriesLimited investigationFinal reportCessna 172I · Isabel, SDPilot's inadequate compensation for the wind conditions.NTSB DEN88DTK01Accident · Serious injuriesFinal reportEagle DW-1 · Ferney, SDThe ag plt reported that he encountered a 'dust devil' while in a climbing turn during a turnaround at the end of a swath run. He said he attempted to counter the turbulence enduced roll with appropriate flt control inputs but the acft did not recover and…NTSB DEN88FA100Accident · 2 fatalField investigationFinal reportCessna 182J · Rapid City, SDThe plt received a wx briefing prior to departure from miles city, MT. The briefing indicated wx conditions less than VFR with icing conditions. The plt departed and landed approximately 1 hour later to remove ice from his acft. The plt departed a second time…NTSB DEN87FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Stugis, SDThe plt agreed to ferry the acft for another plt who was not IFR rated & who had been forced to land at kadoka on the previous evening due to low fuel & apchg darkness. IMC prevailed thru-out the area. The commercial/ifr rated plt did not obtain a wx briefing…NTSB DEN86LA176Accident · No injuriesLimited investigationFinal reportCessna T188 · Kimball, SDAccording to the plt, the acft he was piloting encountered unfavorable winds during the aerial application maneuver and stalled. The plt indicated that during the touchdown, the main gear collapsed and the acft was substantially damaged.NTSB DEN86LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wessington, SDAccording to the plt, during maneuvering on a swath run, the acft he was piloting encountered a downdraft, forcing the acft down until contact with the ground.NTSB DEN86LA116Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Wall, SDAccording to the plt he was making a precautionary landing due to wx, when the acft he was piloting encountered an unexpected crosswind just prior to touchdown. The plt said the left wing dipped & made contact with the ground. The impact resulted in…NTSB DEN86LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Buffalo, SDAccording to officials, the plt was searching for hunters when the acft he was flying contacted the ground. Witnesses stated that blowing snow, low overcast clouds & visibility of less than 1/2 mi prevailed at the time of the acdnt. A blood sample was taken…NTSB DEN84LA256Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Kennebec, SDThe plt stated that shortly after takeoff when the aircraft was 25 feet in the air a downdraft was encountered near a small hill at the end of the runway. The descent caused by the downdraft could not be arrested and the aircraft collided with the ground. The…NTSB DEN84LA237Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wessington, SDPlt stated that during loading for aerial application, he failed to note approaching roll cloud which usually signifies localized turbulence and strong, gusting winds. On takeoff roll, wind shift noted and at 100 ft altitude, heavy turbulence was encountered.…NTSB DEN84FA010Accident · 2 fatalField investigationFinal reportCessna 182F · Burke, SDPrior to the flt, the plt obtained a wx briefing & was advised that VFR flt was not recommended. At the end of the briefing, he indicated he would 'be getting back with' the fss specialist. The plt then told the arpt manager that he would 'go up & take a look…NTSB DEN83FA049Accident · 1 fatalField investigationFinal reportRobinson R22 · Sisseton, SDThe helicopter crashed in an open field shortly after takeoff in adverse weather. The pilot was not instrument rated andhad received weather briefings by telephone from a flight service station. The forecast was not favorable, but the pilotstated 'well I…NTSB DEN82FA034Accident · No injuriesField investigationFinal reportPiper PA-23 · Mitchell, SDAs the pilot approached sioux falls he received information that it was below minimums, so he started to divert. As he passed over sioux falls he could see Mitchell, SD, which appeared to be clear, therefore, he elected to land there. It continued to look…