The text spearheaded by Britain repeatedly condemned Syrian President Bashar al-Assad's offensive to retake east Aleppo from rebel forces, while also admonishing "terrorist acts" by the Islamic State group and other extremists in the Syrian conflict.
Russia, an ally in Syria's east Aleppo campaign, condemned the resolution which was approved in a majority vote.
Moscow's envoy to the council, Aleksei Goltiaev, also described criticism of Syria and Russia as "pathetic".
The resolution called for the UN's existing Commission of Inquiry for Syria (COI) to "conduct a comprehensive, independent special inquiry into the events in Aleppo", and to identify individuals responsible for the most serious violations.
More From This Section
The resolution demanded that warring parties "in particular the Syrian authorities and their allies", allow unrestricted humanitarian access to desperate civilians and "end immediately all bombardments and military flights over Aleppo city".
It also condemned "the starvation of civilians as a means of combat". East Aleppo, captured by the rebels in 2012, has not received aid since July 7 when regime forces seized the last supply route.
John Fisher of Human Rights Watch said the resolution passed at a special session on Aleppo "sent a clear message that illegal attacks on civilians must end and that those responsible will be held to account".
A so-called "humanitarian pause", initiated by Russia, has been broadly holding since yesterday in east Aleppo but the UN and Red Cross have not yet gained access to the rebel side of the city.
The UN had voiced hope it could begin medical evacuations today before bringing in dozens of aid-filled trucks, but said the security guarantees needed to mobilise had not yet been provided.