The search for fugitive gunman Stanley Turvey is over after police shot him dead at Ardmona, near the northern Victorian city of Shepparton.