I've had several close ones over the years, but typically on shallow, well-controlled dives where I was knowingly sucking the walls of the tank in. Anyone who has dove Euclid Beach Pier in Cleveland can understand the circumstances. I have, however, had one notable out-of-air experience. One of those, "how could I be so stupid" events. Second dive of the day in about 60-65' - obviously 70' as I was diving tables (or should say that it was before computers). Dropped in on a solo dive (half-dozen divers on board plus another boat-load nearby) to check out a side-scan sonar hit that my buddy had been wanting to check out.
Lake Erie was flat calm. Vis was fair to good - at least 25' in mid-water; perhaps 10-15' on the bottom. What I found was a series of fishing nets that were hung up on the railings of a wreck. The wreck was not visible in the muck bottom, but the nets provided a perfect outline of the bow of a ship. Not much to dive on, so I did not alert the divers topside. However, there were many floats that were keeping the nets in the water column - still catching fish. There were quite a few walleye and perch caught up, so I figured I'd cut a few of the floats loose to try and get the nets down. Well, one thing led to another and I lost track of time. Ended up checking my air when I hit about 300 or 400 and realized I had been down for quite some time - and it was my 2nd dive to nearly 70 feet - without much SI. As I was only going to do a bounce dive to check it out, I hadn't calulated the tables beyond knowing I had enough time to do a short recon. No tables, low on air, by myself. How stupid can you get... I sucked the walls in, nursing the tank as long as I could, trying all the time to wave someone to get me another tank and tables. I could see people diving off the boat (the platform was my friend's 65' tug), swimming between the boats, but no-one took notice. Everything came out fine. I calculated the tables once I surfaced and determined that my profile was okay, but I spent a very frantic few minutes working to sort things out. Can't say as I've had a close "low-on-air" call since...