I too have witnessed the phenomenon of the mystery flat. On two occasions my wife's rear tire has gone flat while sitting idle on the balcony of our apartment. Both times I pumped it up and it held the air just fine. The flats occurred about two months apart, the last one something like six months ago.

Might this have something to do with rise and/or fall of barometric pressure?