ftg is the closest so far, but further down the thread it got muddled. So Here is a roundup of most of the possibilities…
Water Main - The water main break that the OP mentions that gets noticed on the news in Detroit is a broken city water main. These are the large diameter (typically 8" in a residential area but up to 48" for large transmission lines) city water main that is typically buried under the street. These pipes were made out of cast iron before the late 60’s, ductile iron from the 60’s on, and now can also be PVC. Some large transmission lines were actually made from asbestos cement. They are almost all below the frost line. These pipes almost never freeze.
In Detroit there are likely miles of 70 year old cast iron pipe still in use. Cast iron resists corrosion well underground in good soil, but is very brittle. One failure mode is radial cracking, occasionally but not usually completely severing the pipe, from exactly the reasons ftg mentions. This is the most common winter break. Internal pipe pressure is not a factor in this break.
Another common mode of failure is localized external corrosion from a soil hot spot (often something like a place where old cinders were dumped). This causes pitting that gets deeper and deeper and eventually eats all the way through. Pressure does make a difference here, but the pressure change your toilet can inflict on an 8" line is unmeasurable. This type of break can happen any time of year, but is slightly more common at times of soil motion adding just a little more stress on the pipe (ie, when there is freezing or thawing going on.)
Either of these breaks can pump thousands of gallons of water rapidly to the surface and flood basements for a block. They are capable of hollowing out all the dirt under a road and causing a giant sinkhole. They make the news.
OK, then on to the water line coming into your house… A 3/4" to 1-1/4" line is tapped into the side of the city water main and run through your yard up to your basement. This is either galvanized steel, copper, or PVC. It is installed by the plumber who worked on your house. It is supposed to be below the frost line but cheap contractors have been known to bury them a little shy in the past. Steel and PVC can break from soil pressure, copper not so often. Steel and copper can both be hit with corrosion. These types of leaks will cause you personally great distress and expense, but likely won’t affect your neighbors and won’t make the news. Water pressure will make a neglible difference.
Lastly, if the line to your house is buried too shallow it CAN freeze, and leaving water running will prevent this. Constant running from a faucet is much more useful than flushing the toilet. But if the line to your house freezes it will not always flood your yard. It will freeze the water in the pipe, break the pipe, and then… it might sit there until it thaws. The ice occasionally forms a good plug.
So there you have it from someone who wishes he played a civil engineer on TV rather than actually being one.
(And as hammerbach notes, a snowless unusually cold winter can drive frost deeper than usual and bite the folks who have water lines that were just barely deep enough for a normal winter. Hey! Preview IS my friend!)