Water intoxication, also known as hyponatremia, occurs when excessive water consumption dilutes the sodium levels in the bloodstream, leading to potentially life-threatening disruptions in brain function. This condition is rare but can result from activities involving excessive water intake without adequate electrolyte balance, such as endurance sports or certain psychiatric conditions.