I've had exactly the same pain when flying in unpressurised freighters on the descent phase. Something like a handful of hot needles rammed into my forehead. As you say, it's incapacitating. Blocked sinuses in my case.
Caused by the rate of descent (and pressurisation settings in passenger aircraft).