Basically if you ask to go into the cockpit, I think they might tackle you

Nick

No, they don't.

For serious: It was on my last flight, Paris (CDG) to Hamburg (HAM). We waited 1 hour on the taxyway and I had nothing better to do as to ask the cute stewardess if I could get into the cockpit. She said she would have to talk to the captain, he had to agree before. So we started. After about 1 hour, the stewardess came and told me to "follow me to the cockpit please?". Then I was in and couldn't even speak german. I was so nervous because I love all this stuff (and want to do it myself in future). I sat down on the jump seat an talked to the First Officer. Rick, the pilot, was quit the whole time.
And because I fly Flight Simulator for over 8 years now, I understood every single word that came out of the speakers of the cockpit (was the ATC). By the way, it was a flight in an Air France Airbus A318. Suddenly I heard: "Air France 1410, descending to FL190". There I knew the stewardess would come back to lead me back to my seat. And she came. But first, she talked to the pilot (in french, I couldn't get a word of it). Then she said to me: "Wanna stay for landing?" <<<<<<<Happiest moment of my life (until now ). So I could stay for landing (the First Officer even gave me one of these cool headsets). That was (for sure), one of my best moments. I learned a lot about Airbus in just half an hour. That whole thing happened on 08-07-2006 - the day I will never forget!

It was exacly that airplane: http://jetphotos.net/viewphoto.php?id=5861803 F-GUGA

..and I'm not tackled!

Yes 2 a home built ultra-light, and a Cessna C150 that I got to fly

Most memorable would be watching the sunrise from the deck of a Britannia 767 on our way back from Gran Canaria to East Midlands in the summer of 2000. I can still vividly remeber the pilot showing me all the cockpit instruments and having a good old chin wag about flying!

The first though, would be when I was around 5-6 travelling on a charter 757 to Mallorca when I got to visit the cockpit. It was dark when I went into the cockpit and all I can vaguely remeber is seeing all the panel and instrument lights, and how beautiful the greens reds and oranges were. And ever since that little visit to the cockpit of a 757 10 years ago i've wanted to be a pilot!

Nothing as cool as staying in the cockpit for landing but i've had my moments of shear delight on visiting a cockpit!

Nowadays I just sneakily peer into the cockpits of Tu-154's and 737's that I travel on as I board or disembark the aircraft! 

Conan: I'm surprised. What airline was that? *Quite* relaxed security on their part, or maybe you just don't look like a terrorist. 

Does a citabrea decathelon count?

Never bothered before 9/11, but I always have a look... but I still get more excited about visiting, or better yet parking my fanny in the left seat of a classic flight deck, even if it's no longer operational.
So far:
B29 (operational)
B17 (operational)
DC3 (operational)
Avro Lancaster (operational)
Lockheed Constellation (static)
Lockheed Electra(static)
Martin 202 (static)

Just my preference... I'm more intrigued by the older ships.
The B17 was the inly one I've flown on... got to roam all over it, but not allowed to sit on the flight deck. Which was no big deal- the view from the bombadier's seat is much better!