While it's possible for a pebble to cause a flat tire, it's not very likely. More often, flats are caused by things like nails, glass, or other sharp objects that puncture the tire. Even then, it takes quite a bit of force to puncture a tire - so a pebble probably wouldn't be able to do it on its own.