That Sand Van was in the yard through the 80s. It was often the casualty of some overly zealous shunting, as I remember seeing it at 45 degrees to the horizontal, sat on the buffer stops a few times. I presume it was cut up on site when the yard was cleared for sell off. Never saw it move from that spot, and the proximity to the loco stabling roads would support its use as a store for the loco sand.
There were a few instances of enthusiastic shunting at BG: every now and then something in the sidings which were the old Hornsea/Withernsea lines would get pushed across the crossing over Spring Bank towards the old Botanic Gardens Station. Trouble was, the lines had been lifted a decade before. Headline stuff in the Hull Daily Mail!