It's not just the Celts.
Blowing a double digit lead only takes 4 possessions. Heck, throw in a Technical foul and you can do it in three.
On average, you are going to score on roughly half of your possessions just with 'normal' play. An average NBA team will 'normally' commit a TO once every 8 or 9 possessions so that means about of your 4 possessions, you have about 3.5 possessions on which to score.
So, over a 4 possession span, if you screw things up just a little extra bad ... perhaps you commit that one extra TO. Perhaps a travel. Or a moving pick. Or a push off or hold by someone away from the ball. None of those are even 'basketball' moves (like a bad pass or lost dribble). They are mental errors. AAARGH! Or maybe you get a bad call (a charge that should have been a block, etc.). It's not like bad officiating ever happens ...
Now you are down to 2.5 possessions.
On any possession, the most important shot is the first shot. Once it leaves your hand, defenses grab, on average, 73% of the rebounds. So in your remaing 2.5 possessions, you are on average going to get just a hair over 3 shots with which to score.
It is very easy to miss 3 shots in a row, unfortunately.
So one anomalous, stupid mental error and a cold shooting glitch and just like that - scoreless for 4 possessions.
Meanwhile, the flip side is that it is very easy for a team to NOT make that 'normal' TO during a stretch. So they get the full 4 possessions worth of shots. And maybe they get a little hot streak and make all 4 first shots. Hell, they don't even need to grab any offensive rebounds.
Boom! Just like that, a double digit lead is gone.
For exhibit A: I present the long span of the 3rd period of last night's BOS vs NOH game: During which the C's did everything they could to blow this game. They turned the ball over a couple of extra times. Probably the worst things is: They missed FIVE layup/dunk shots!!!!!!
Those 5 gimme shots should have been 10 points. Even WITH the ugly turnovers, we'd have won easily if we could just put the [dang] ball in the hoop on layups and dunks.
Ugh.