Heh.. I kinda meant just any/all that occur in the games.
I have here a list of all the console instances that I could think of. This is by no means comprehensive, and I know a few games are missing. To be honest, I ran out of paper. Anyway, to the list! Feel free to correct me if I'm wrong.. **this list will contain spoilers such as the Mario theme being used during the ending to Luigi's Mansion**
Note: Bold indicates new instance.
NES
Super Mario Bros: One instance
- Overworld
SMB2: once
- Subspace
SMB3: once
- Music Box item
SNES
Super Mario World: once
- Special Zone (wait about five minutes or so on the map screen)
Super Mario All*Stars: once
- Game selection
Super Mario Kart: twice
- Track Opener (when the camera flies over the track and settles behind your driver)
- Mario's victory
Super Mario RPG: five
- file select
- Mario's Pad
- Booster's Tower (behind the curtain. Only works once)
- Marrymore (take a shower while staying in the suite)
- The End screen (wait after the parade)
N64
Super Mario 64: twice
- title sceen
- Choosing a Star (the first six notes play when entering a level)
Mario Golf 64: three
- Title screen (starts off with the first six notes)
- Speed golf
- Get Character Mode (During Mario's)
Mario Party: four
- intro
-"How to Play"
-Peach's Birthday Cake board
- ending
Mario Party 3
- During the intro
- Cellular Shopper item
Mario Tennis 64: once
- Mario Bros court (and Peach's Castle court [same song])
Super Smash Bros: twice
- Peach's Castle
- Classic Kingdom
Paper Mario: three
- Chapter intros (wait about five seconds or so)
- Record player in Bow's Mansion
- Vase in Bow's Mansion (also during the 8bit cameo)
Gamecube
Luigi's Mansion: Twice
- the.. Music Room (where the piano playing ghost appears)
- the ending
Super Mario Sunshine: three times
- intro (don't press any buttons and allow the demo to run at the title screen)
- Secret levels (ie: The Sandbuds Secret)
- Noki kid (plays a conch horn) *spray him for comical results*
Mario Party 5: six
- Chance Time spaces (or whatever the MP5 equivalent is)
- Popstar Pirahnas (three mixes of the song are in the minigame)
- Card Party
- ending credits
Mario Kart Double Dash!!: once
- Tilt-a-Kart (the first six notes play as the battle starts)
Mario Golf: Toadstool Tour: once
- Character select (Peach sings the first six notes when you have your cursor on her)
DDR: Mario Mix: twice? *check it*
- (I'm not sure where it is. I haven't played the game and only own a homemade soundtrack)
- Again, unsure
Paper Mario 2: nine
- Chapter Titles
- Mario's house
- normal battles (it can be heard floating around the battle theme)
- Petal Meadows (the first six notes can be heard when you enter this area)
- Luigi's Adventure (when you talk to Luigi)
- Glitzville (outside the Glitz Pit)
- X-Naut Base (during the 8Bit cameo)
- Super Bowser Bros (during the first 'stage' of SBB, where you play as Bowser)
- Casino (the first six notes play at the start of each minigame)
SSB Melee: Two
- Adventure Stage one and Classic Kingdom one (Peach's Castle during VS matches[same song])
- Luigi's Intro (when you unlock the fight with Luigi during the first stage, the mix from the SSB Peach's Castle plays. It's not in the sound test..)
Mario Power Tennis: three
- credits theme
- Wario's cellphone (during the second set of outtakes, Wario's cellphone rings and the ringtone is the SMB-theme)
- During Mario's trophy celebration
Mario Superstar Baseball: once
- Peach's Castle field
Wii
Super Mario Galaxy: three
- Toy Time Galaxy
- Mushroom Powerup (the first six notes play upon collection of a Super Mushroom)
- During some Comet Stars (Cosmic Mario and Speedy)
Super Paper Mario: Twice
- World 1-1 (remixed in with the SMW theme too)
- World 3 (All through it)
Wario Ware Smooth Moves: twice
- Super Mario Bros minigame
- Conducting the Orchestra minigame (that's not the real minigame name. I made it up)
Mario Kart Wii: once
- Horns (karts/bikes sometimes play the first six notes when you bump other racers)
New Super Mario Bros
- Intro screen (when selecting the game from the Wii menu)
- mushroom houses