Here in SE PA, that does in just about all my zucchini plants each year. One of these days I will look up what causes it, I just plant them every three weeks to accommodate.
I know about the insect that bores into the stalk and kills squash and zucchini plants, but this was totally different. I’ve never seen that type of rot on a main stalk. It was doing great one day and dead the next.