Little Carter Walsh had 'the best day ever' with his family before tragedy struck