Community in Waterford shocked at death of pilot who had flown from Sligo