NTSB investigations, WY
27 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1994 | 2 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 3 |
| 2003 | 2 |
| 2005 | 1 |
| 2006 | 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\" = 'WY' 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" = 'WY' 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 DEN06CA073Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cody, WYthe pilot's failure to maintain clearance with a parked vehicle during the approach to land on a dirt road. Contributing factors were the pilot's improper decision to land near an unsuitable landing area, and the parked vehicle.NTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.NTSB DEN03LA112Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Glendo, WYthe pilot's failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the high density altitude, and the trees.NTSB DEN03LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Afton, WYthe pilot's failure to achieve an adequate climb rate, resulting in an inflight collision with the sign. Contributing factors were the pilot's improper mixture leaning procedure, the high density altitude, his failure to abort the takeoff in a timely manner,…NTSB DEN01LA145Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B-2 · Cody, WYthe pilot's inadequate in-flight planning for an off site landing, which resulted in failure of the tail rotor drive shaft due to entanglement of his long-line in the drive shaft.NTSB DEN01FA135Accident · 1 fatalField investigationFinal reportBeech V-35A · Lusk, WYthe pilot's inadequate visual lookout, which resulted in an inadvertent collision with transmission wires.NTSB DEN01LA084Accident · No injuriesLimited investigationFinal reportBell 222UT · Alcova, WYthe pilot's failure to maintain tail rotor clearance during a right pedal turn while hovering.NTSB DEN00LA058Accident · No injuriesLimited investigationFinal reportBeech A23A · Rawlins, WYThe pilot's failure to abort the landing in a timely manner. Factors were the tailwind and high density altitude, resulting in inadequate climb performance.NTSB DEN99FA148Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Newcastle, WYThe pilot's inadequate visual lookout and inadequate altitude/clearance from the transmission wires.NTSB FTW98LA391Accident · No injuriesLimited investigationFinal reportCessna 180F · Douglas, WYA collision with a deer during take-off.NTSB FTW98LA309Accident · Serious injuriesLimited investigationFinal reportOverton Mustang M-II · Hillsdale, WYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance from obstacles. Factors were an intentional low altitude flight maneuver, wires, and low light conditions.NTSB SEA96LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gillette, WYfailure of the pilot to see-and-avoid the obstruction (power line). The powerline was a related factor.NTSB SEA94LA145Accident · No injuriesLimited investigationFinal reportMooney M20C · Wamsutter, WYClearance not maintained. A factor to the accident was: transmission wire.NTSB SEA94LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Casper, WYThe pilot's failure to maintain proper alignment with the runway. The crosswind was of factor.NTSB SEA93LA003Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Powell, WYThe pilot in command's failure to assure clearance from the radio tower. Factors contributing to the accident were the marked tower and the pilot in command's inadequate visual lookout.NTSB SEA92LA078Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aravada, WYThe pilot's failure to maintain a visual lookout, and his diverted attention. Factors include a low pass, and a transmission wire in the path of flight.NTSB SEA91LA254Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kaycee, WYInadequate clearance with the vehicle and the pilot's failure to obtain proper assistance for the takeoff. Factors contributing to the accident were 1) the pilot's inadequate preflight planning, 2) the vehicle, and 3) high density altitude conditions.NTSB DEN89LA186Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lovell, WYImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to continue out of the canyon or turn around. The terrain and high density altitude were related factors.NTSB DEN89IA071Incident · No injuriesIncident investigationFinal reportBeech E90 · Lander, WYDeer on the runway.NTSB DEN89LA044Accident · No injuriesLimited investigationFinal reportCessna 150E · Basin, WYThe private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…NTSB DEN88LA123Accident · Serious injuriesLimited investigationFinal reportHelio H-295 · Encampment, WYThe plt stated he calculated the density altitude to have been 11,300 ft at takeoff. He said the acft was near max gross wt and that the grass strip he departed from was approx 1,500 ft long. The plt stated 'I was on the on the back side of the pwr curve as…NTSB DEN85FA007Accident · No injuriesField investigationFinal reportBell 206B · Cheyenne, WYThe helicopter's tail rotor section contacted a pwr line during an attempted takeoff. A section of tail rotor blade tipwas found beneath the pwr lines. The pilot reported a vibration in the tail rotor control pedals. He attempted a landing into an open field.…NTSB DEN83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hulett, WYThe acft struck a deer while landing into the sun at a private ranch strip. The animal was seen just before touchdown but not in time to avoid hitting it.NTSB DEN82DA130Accident · Serious injuriesFinal reportAerospatiale SA316B · Meeteetse, WYPrior to this flight, a long line had been attached to the helicopter for an external load operation. However, there wasa change in the schedule and the pilot was instructed to return to the base camp with six passengers. When the pilot took off, he was…NTSB DEN82FTC05Accident · Minor injuriesFinal reportBell 47G-3B · Douglas, WYThe pilot reported that he made a normal approach to the landing site near his loading dock. When he touched down, the helicopter as on a slope, so he picked the craft back up to a hover. Reportedly, he was moving the helicopter about 4 ft forward to a more…NTSB DEN82FTC04Accident · 1 fatalFinal reportCessna 172P · Osage, WYThe aircraft departed gillette, Wyoming on a pipeline patrol mission. This was the pilot's first pipeline patrol over the line that he was patrolling. During the flight, the aircraft struck three powerlines and crashed. The passenger stated that he saw the…NTSB DEN82FTC02Accident · Minor injuriesFinal reportCessna 210M · Cheyenne, WYThe pilot initiated his takeoff on runway 12 from an intersection with runway 16. From this intersection, there was 2175 ft or runway remaining. During the takeoff, the aircraft struck the roof of a garage about 360 ft from the departure end of the runway.…