In my experience, the most common causes of Aloe plant leaves turning yellow or brown are due to environmental conditions like cold temperatures, excessive direct sunlight, and overwatering.