The man, in his 30s, passed away following the collision near Alnwick on Monday