I have been an engineer for 37 years. 12 of those years was working for a company that made high pressure (up to 10,000 psi) measuring equipment, every hard line connection was made up with compression fittings and they were 100% proof tested to 1 1/2 times the working pressure before leaving the factory. I can tell you absolutely that the line will fail before it will pull out of the fitting.
If you have seen a line pull out of a compression fitting its either; a) the wrong fitting for the application, or b) the fitting wasn't assemblied per the manufactuers instructions.
I would say the vast majority of stories relating to the failure of compression fittings is from using hardware store fittings that are design for soft tubing. These in the 3/16 tubing size are rated for around 500 psi and are easily identified by the barrel shaped ferrule. Most high pressure compression fittings use a two piece ferrule.
If you find your self needing to use a compression fitting on your brake lines and you are offered a brass fitting that costs $3-$4 its likely not the correct fitting for the application.
Another thing to consider is it takes more skill to double flare a tube than to make up a compression fitting properly. I have seen flares that so called mechanics have done that have an uneven flare or cracks in the flare and they didn't even recognize they were defective.