An eight-year-old boy has died following birthday celebrations in what has been declared the "most tragic of accidents".