Traffic Collisions by Location 2017-2024 (excluding 2023) (English, CSV)

Explore the interactive map. Traffic Collisions by Location 2017-2024 (excluding 2023): English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Ottawa, updated Aug 2026.

Format
CSV
Access
Table on demand (prepared when opened) and interactive map
Fields
20
Publisher-reported update
2026-08-15

Accuracy : The City of Ottawa provides this information in good faith but provides no warranty, nor accepts any liability arising from any incorrect, incomplete, or misleading information or its improper use. Collision Data Accuracy: Each reportable collision occurring on public roadways is sent to the City of Ottawa and is validated at least once. Approximately 50% of the records are validated once again by a senior staff. Additionally, many queries are run on the database looking for errors. X & Y Accuracy: Collisions are pinned according to information provided by the officer on the Motor Vehicle Collision Report. In some cases, insufficient information was provided, and the collision location is an estimate. Update Frequency : Annually Attributes : X and Y Coordinate (MTM Zone 9, NAD83) ID Geo ID Accident year Location (RD1 @ RD2 or RD from RD 1 to RD 2) Classification of collision (non-fatal, fatal, property damage only) Initial impact type (Angle, turning movement, rear-end…) Road surface condition (Ice, wet, dry snow...) Environment (Clear, rain, snow…) Light (daylight, dawn, dusk…) Traffic control (stop, traffic signal, no control…) Number of Vehicles Number of…

Access original file

Data overview

Formats
CSV
File languages
English
Available actions
Explore table (prepared automatically) · Explore map · Access original file

Available fields (20/20)

Fields from the recorded map schema.

FieldRecorded type
ObjectIdesriFieldTypeOID
X_CoordinateesriFieldTypeDouble
Y_CoordinateesriFieldTypeDouble
LatesriFieldTypeDouble
LongesriFieldTypeDouble
IDesriFieldTypeString
Geo_IDesriFieldTypeString
Accident_YearesriFieldTypeInteger
Accident_DateesriFieldTypeDateOnly
LocationesriFieldTypeString
Classification_Of_AccidentesriFieldTypeString
Initial_Impact_TypeesriFieldTypeString
Road_1_Surface_ConditionesriFieldTypeString
Environment_ConditionesriFieldTypeString
LightesriFieldTypeString
Traffic_ControlesriFieldTypeString
num_of_vehiclesesriFieldTypeInteger
num_of_pedestriansesriFieldTypeString
num_of_bicyclesesriFieldTypeString
num_of_motorcyclesesriFieldTypeString

Official sources and licences

Related open data