Lord-Lieutenant for North Yorkshire Barry Dodd CBE was piloting the helicopter when it crashed near Boroughbridge yesterday.