A Northern Ireland woman died and her husband was left seriously injured after the couple crashed while on a motorcycling holiday in Germany.