⚠️ Offence types

All offence categories ranked by frequency. 'Driving without Due Care and Attention' is the most common, followed by pavement obstruction and red light offences.

Custom SQL query returning 82 rows (hide) 

select offence as Offence, count(*) as [Total reports], round(100.0 * sum(case when disposal not in ('NFA', 'Duplicate Submission') then 1 else 0 end) / count(*), 0) as [Action rate %] from reports where offence is not null group by offence order by [Total reports] desc

Edit SQL

This data as json, CSV

OffenceTotal reportsAction rate %
Driving without Due Care and Attention 7151 58.0
Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 3713 78.0
Contravening a Red Traffic Light 3208 61.0
Cause vehicle to be left in a dangerous position 2132 77.0
Using a Mobile Phone Whilst Driving 1872 73.0
Driving without Reasonable Consideration 1763 54.0
Stop a vehicle within pelican pedestrian crossing limits 1333 86.0
Misc - Non Traffic Offences 979 20.0
Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 582 82.0
Stop a vehicle on pedestrian crossing 485 75.0
Cause unnecessary obstruction by motor vehicle 427 87.0
Use a vehicle / cycle on a road and contravene a local traffic order other than parking 285 67.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 228 76.0
VRM fails to conform to Regulations 140 84.0
Driving a vehicle wholly or partly on a footpath 128 68.0
Contravene Lane Closure Red X 111 73.0
Dangerous Driving 106 62.0
Drive on hard shoulder 99 60.0
Motor vehicle fail to accord precedence at a pelican crossing 77 77.0
Use a motor vehicle / trailer in a condition likely to cause danger of injury 66 70.0
No Insurance 65 72.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 50 56.0
No Seat Belt 48 42.0
Driver not in position to have Proper Control 46 52.0
Drive a vehicle other than on the carriageway of a motorway 39 79.0
Vehicle overtake within crossing limits 36 94.0
Prohibited vehicle in offside lane of motorway 31 68.0
Fail to display front VRM plate 30 67.0
Motor vehicle fail to comply with solid white line road markings 27 22.0
/C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 24 79.0
Fail to Conform to Cycle Lane 24 67.0
Drive / Ride / Lead an animal on a footpath 23 52.0
Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 23 43.0
Motor vehicle fail to comply with endorsable sect 22 73.0
Use vehicle on a road without valid test certificate 22 77.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 19 16.0
Duplicate Submission 18 6.0
Motor vehicle fail to comply with a non endorsab 17 65.0
Use a vehicle / cycle on a road and contravene a l 15 87.0
Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 14 50.0
Offence to be added 10 20.0
Waiting on a road in a prohibited area 10 80.0
/ trailer outside of the Greater London area 9 67.0
Keeping a vehicle with registration marks obscured 9 56.0
No vehicle excise licence 9 22.0
Drive a vehicle on common land 8 75.0
Drive a vehicle other than on the carriageway of a 7 86.0
Fail to display rear VRM plate 7 43.0
Motor vehicle fail to accord precedence at a pelic 6 67.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 6 33.0
Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 6 67.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 5 80.0
Stop a vehicle within pelican pedestrian crossing l 5 80.0
Motor vehicle fail to comply with a directional arrow sign 4 100.0
CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 3 67.0
DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 3 67.0
Drive / stop / cause to remain at rest a motor veh 3 67.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq 3 33.0
Motor vehicle fail to comply with solid white line 3 33.0
Person in charge cause veh / trailer to be left to involve danger to road user 3 100.0
Use a motor vehicle / trailer in a condition likely t 3 33.0
Use on a road a motor vehicle / trailer in such a c 3 33.0
section 36 traffic sign -other than manned or 3 67.0
Driver parked on pedestrian road marked by a white “Zig-zag line” 2 0.0
MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 2 0.0
CCaauussee vuenhniecclee stsoa brye olebfstt irnu cat dioann gbeyr mouost opro vseithioicnle 1 0.0
Contravene a Red Traffic Light 1 100.0
Contravene local traffic order 1 100.0
DCariuvsee o unn hnaercde ssshaoruyl doebrstruction by motor vehicle 1 0.0
DCariuvsineg u wnnitehcoeusts aDruye o Cbasrteru acntido nA tbtye nmtiootnor vehicle 1 100.0
Dangerous driving 1 0.0
Drive a motor vehicle when the VRM fails to conform to regulations. 1 100.0
Drive mechanically propelled vehicle without reasonable consideration 1 100.0
Drive motor vehicle on a footpath/ Unnecessary Obstruction 1 100.0
Fail to accord precedence to pedestrian at zebra crossing 1 100.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equ 1 100.0
No Insurance Motor vehicle fail to co 1 100.0
Use a motor vehicle / trailer the number of passenger / manner carried likely to cause danger 1 0.0
VCaRuMse f auinlsn teoc ceossnaforyr mob tsot rRuecgtiuolnat bioyn msotor vehicle 1 100.0
driving without due care/attention 1 0.0
fail to comply with a non endorsable traffic sign 1 100.0
sMeocttioorn v 3e6h itcrlaef ffiaci ls tigon c o-omthpelyr wthiathn emnadnonrseadb oler 1 100.0