What would cause a speedometer on a 1998 Honda Accord to freak out?

It sounds like your speed sensor has gone bad. You can pick one up at a salvage yard for about $50 +/- (Take it to a shop and make sure.) If the sensor is not bad check your electrical wiring.