The hospital has apologised after a woman was left on a ventilator following a serious error during brain tumour surgery.