Narrative:

I entered right 45 degrees for runway 14 and was making radio calls on what I thought was CTAF. I saw an aircraft coming north from the river 4 mi out. I lost the traffic on downwind. I saw the aircraft again directly below me on short final and immediately initiated a go around and offset to the right. Other aircraft offset to the left and rest of flight went without incident. My error was communicating on wrong CTAF frequency.

Google
 

Original NASA ASRS Text

Title: C172 PLT HAS NMAC DURING FINAL APCH.

Narrative: I ENTERED R 45 DEGS FOR RWY 14 AND WAS MAKING RADIO CALLS ON WHAT I THOUGHT WAS CTAF. I SAW AN ACFT COMING N FROM THE RIVER 4 MI OUT. I LOST THE TFC ON DOWNWIND. I SAW THE ACFT AGAIN DIRECTLY BELOW ME ON SHORT FINAL AND IMMEDIATELY INITIATED A GAR AND OFFSET TO THE R. OTHER ACFT OFFSET TO THE L AND REST OF FLT WENT WITHOUT INCIDENT. MY ERROR WAS COMMUNICATING ON WRONG CTAF FREQ.

Data retrieved from NASA's ASRS site as of July 2007 and automatically converted to unabbreviated mixed upper/lowercase text. This report is for informational purposes with no guarantee of accuracy. See NASA's ASRS site for official report.