A memorial dedicated to two RAF aviators who lost their lives on a training exercise in Northumberland has been unveiled.