nagatalluri....
A good treatment of this subject is found in "Buried Pipe Design" by A.P. Moser. See
The 3rd edition is current. If you run across the 1st edition (which I have), please note that Equation 2.3 (shown twice on page 12) has an error: the K term should be Ku' (where u = the Greek letter mu). A friend told me a while back that this error had been corrected in the 2nd edition, so it should be correct in the 3rd edition also. BTW, a quick internet search indicates that .PDFs of the 2nd edition are available on some file sharing sites.
Developing a solution isn't difficult and the math isn't hard, but there are a lot of pieces to put together. So, I offer the following to jump-start your work.
First, however, you need to know if the buried pipe you are concerned with is rigid (e.g. concrete, vitrified clay, etc.) or flexible (PVC, HDPE, ductile iron, corrugated steel, etc.), because it matters. BTW, almost all utility water pipes are flexible.
Second, you need to know the burial condition of the pipe (trench condition, embankment condition, etc.), because that matters, too. BTW, almost all utility water pipes were installed in a trench condition.
Now to the jump-start: several years ago, I created Mathcad Prime 3.0 worksheets to solve this problem for both rigid and flexible pipes in a trench condition. You can find these worksheets on the PTC website at the following links:
Even if you don't have Mathcad Prime 3.0 or later, I suggest you download these two .ZIP file anyway. The .ZIP files include .PDF versions of the worksheets, so at least you can see static versions of the calculations. It should be a simple, though perhaps tedious, exercise to translate these calculations to Excel if you need to. If your pipe was installed in any other manner than in the trench condition, then you would need to modify a couple things in the procedure. Moser's book covers these differences.
Also, many years ago I developed an Excel spreadsheet specifically to evaluate buried ASTM C76 RCP in a trench condition, which I have attached to this post.
One final point: because construction vehicles use large tires (typically at low pressures) or caterpillar tracks, they typically have much lower ground pressures than road vehicles. This is why the typical design vehicle for buried pipe design is H-20/HS-20 and not construction vehicles. In my experience, the only time construction vehicles would govern is when depth of cover is less than the ultimate because the soil cover is a work in progress.
So, I doubt that a water pipe buried six feet down is going to be a problem. BUT, run the numbers to be certain. Also, if the water pipe is pressurized during the time the crane rolls over it, I would be even less concerned because the internal pressure supports the pipe from collapse. All of the calculations I am sharing assume an empty pipe because that is the critical condition for failure due to an imposed vertical load.
I hope this helps.
Fred
==========
"Is it the only lesson of history that mankind is unteachable?"
--Winston S. Churchill