my $.02.....
Pretty obvious a compass problem ONBOARD with it rotating and no matching motion rotate. Think about it... Your drone is pretty steady yet the compass begins a 300+ degree rotation. the mcu must have good feedback before you can command it to do something. It is cause and affect. Saying it is NOT a compass issue is like saying the ball fell from the sky BEFORE it was thrown up in the air. Your compass messed up.
NOTHING to do with transmitter - the compass went crazy FIRST; you cannot make that happen with the RC transmitter.
Not ESC issue as 2nd flight ran all 4 motors, and ESC failure will not cause compass to go haywire before a crash like yours.
If your compass sender was not broke (and we have no clue since your second flight recording had no compass radar indicator!?!? I would never fly without the radar circle showing, but that's just me. Anyway, if the compass sensor was not broke or way out of alignment, and the MCU not broke, then it is potentially highly likely that this location you never flew before (yes, I heard your friend did - but SAME EXACT spot?) has some magnetic anomaly.
What does your flight log look like? Hmmm? You said you are professional and don't have a flight log running? I don't understand?
Since you live close, install a free tesla meter on your phone and go back and walk around where you were and as close as you can to where the drone was and see if you don't find the anomaly. If you do, please let us know!
PS: I understand lithium batteries are sorta toxic..... will he local city have to drain then refill the reservoir to remove the contamination?