I was browsing the Leaky Cauldron and came upon this in the Book 7 FAQ: We will find out what happened to Sirius's flying motorbike, "but the real sleuths among you might be able to guess." (World Book Day)
I totally know what happened.
Hagrid sunk it in the lake and now the giant squid rides it around scaring the merfolk.
Totally.