Assessing agricultural risk management using historic crop insurance loss data over the ogallala aquifer

•Drought and hail are the leading causes of crop loss over the Ogallala Aquifer.•Divergent patterns of risk emerge given seasonal and county-level patterns.•Northern and southern portions of the Ogallala perceive hail losses differently.•Crop insurance loss data link long-term trends with near-term decision making.