May I ask, how often or common do AIO coolers leak ?
That depends. Everything has a failure rate, but there's no way to accurately assess real failures except for those reported or rma'd.
Also must take into consideration the numbers. Last I saw, Corsair had a 0.1% failure rate for aios, according to what was rma'd. There's also an unknown number of failures where ppl simply tossed the aio in the trash and got something different, and never said a word. But, that's also offset by the sheer amount of rma's that had nothing to do with a leak, like the pump was bad or it didn't fit, or they got freaked by a video or even hooked it up wrong but returned it anyway after being told they leak.
0.1% seems like a minute number, but consider the amount of sales Corsair has, and Corsair is the largest supplier/seller worldwide of aios and has multiple different models. If they sold 10M AIO's around the world last year, thats 10,000 units returned. That number sounds a lot larger than 0.1%. But most are thinking about that 10,000 possible leak situations, and forget about the 9,990,000 perfectly happy customers with no leaks, no dead pumps, works just as they intended.
If Fractal Design sold 500,000 aios, that's just 500 units returned, but add all the units from all the companies (not counting cheap Chinese knockoffs) and you might be looking at worldwide returns in excess of 30,000 units, but that's compared to the 30Million actually sold.
Can aios leak? Yep, they can. And 90% ish of the ones that do were not caused by factory quality or manufacturing defects, they are caused by the installer.
Ppl worry about leaks far too much, they are essentially harmless in almost all cases, the coolant used is non-conductive, if it was conductive then nobody would build custom loops because those are almost guaranteed to leak during initial startup. It's a fluke if you can put a loop together and not have a leak, anywhere, no matter how carefully it's built.
Can aircoolers leak? Yep, they leak too, even Noctua. Warped bases, fans that don't work, fins not soldered well, aircoolers have their own failures as well, but nothing scares ppl like liquid in an expensive pc where it's entirely possible to get drips on the single most expensive component that sits directly under the pump, your gpu.
For decent cooling, you want 2x the actual cpu power (not TDP) used. For adequate cooling, 1.5x. A 120mm AIO is roughly 150w. 240mm is 250w, 280mm is 300w, 360mm is 350w and a 420mm is 400w. Roughly. There are no exact measurements because it's a liquid transport and liquids become more or less efficient depending on coolant temp.
Considering that a 13900k/KS can hit 300w+, a 360mm is a minimum recommended, even a NH-D15 can't tame that beast if actually pushed to that wattage, but that's rare with the amount of cores and Intels turbo mechanisms. So a NH-D15 can work ok just for gaming, you aren't using all the P-cores and all the E-cores simultaneously. But I'd not use it for stuff like folding@home or heavy rendering projects, I'd use a 360/420mm instead, or preferably a well designed custom loop that'll hit @ 500w or better in capacity.
Also got to figure boosts in all that. If the 13900k can hit 80° on a 5.2GHz turbo, it's going to supercede that boost and hit 5.3GHz instead, raising the temp to 90°, just because it feels like it can. So you may get 90° with a NH-D15, and also 90° with a 360mm AIO, the difference being the NH-D15 cpu is at 5.2GHz and the 360mm is at 5.35GHz instead. The temp isn't always a reflection of the ability of the cooler, but temp combined with speed, is.