Coventry Rugby Union Club snatched a last gasp 23-22 win at Tynedale in their furthest National League One game of the season.
Coventry led 13-5 at the break with a maiden try for Scott Morgan and two penalties and a conversion for Hodgson.
Hodgson kicked another penalty but the home side attacked to lead before Coventry won with a last gasp converted try.