A berry aneurysm, which looks like a berry on a narrow stem, is the most common type of brain aneurysm. They make up 90 percent of all brain aneurysms, according to Stanford Health Care. Berry aneurysms tend to appear at the base of the brain where the major blood vessels meet, also known as the Circle of Willis.