I took a serious fall close to 30 years ago, about a 60ft drop onto a rocky surface. Fortunately I sort of bounced off some earthen outcrops on the way down, so I wasn't traveling deadly fast when I landed. Naturally, I had a couple of surgeries very soon after. Also I have a spinal deformity, fairly minor but the military rejected me because of it, saying it made me susceptible to meningitis and that carrying heavy stuff on my back, as soldiers do, could cause permanent injury.
After the initial surgeries I did just fine until 2010. I went to a doctor who prescribed Vicodin but I stopped taking it after a month. Just didn't like the idea. Pretty soon the problems in my back started effecting my legs; extremely painful muscle contractions, numbness, tingling and this horrible sensation of extreme heat that made my back, hips, legs and feet feel like they were literally on fire. I went to the hospital ER with that problem 3 times, but they just gave me Vicodin and had me lay on a gurney for a few hours. I took the Vicodin while at the hospital but never filled the prescriptions. Stuff I was reading about opioids and all that had me scared. Finally, in 2011 or 12, I totally lost all feeling in my legs and feet and my doctor ordered me a wheelchair and I had to stop working.
I was living in a small mountain town at the time. My sons moved me to Sacramento and I started going to the university medical center. My doctors there did all kinds of imaging and tests, signed me up for pain management, sent me to physical therapy, and put me back on pain medication; Norco. With a LOT of work, I got myself out of a wheelchair thanks to an excellent physical therapist and some spinal injections to control pain. I got around the house pretty well but I had to use a walker whenever I went outside, like out to the mailbox (couple hundred yards away) and to the store and stuff. Then, in 2017, I had major spinal surgery that included disk replacement, some rods and pins put in place (I'd developed scoliosis), and the removal of a bunch of arthritis. I had no idea arthritis could be removed.
That surgery was life-changing. And I'm not afraid of pain meds anymore. I like to keep dosage minimal, but I ask for what I need and I get what I ask for. My PCP totally trusts that I am conscientious about it.
I wonder if riding your motorcycle exacerbated an issue that was already in there. Like, maybe the vibration and bumps in the road and whatnot caused a collapse somewhere in there. I think it's likely.