Two women die in Aberdeen beach tragedy