National Collision Database (2019) (English, CSV)

National Collision Database (2019): English CSV file (17 MB) you can open as a table, filter, chart and export up to 10,000 rows. From Transport Canada, updated Nov 2022.

Format
CSV
Access
Table on demand (prepared when opened)
Size
17,398,658 bytes
Publisher-reported update
2022-11-02

National Collision Database (NCDB) – a database containing all police-reported motor vehicle collisions on public roads in Canada. Selected variables (data elements) relating to fatal and injury collisions for the collisions from 1999 to the most recent available data.

Access original file

Data overview

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

Sample rows

The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-01. Showing 20 of 23 columns.

C_YEARC_MNTHC_WDAYC_HOURC_SEVC_VEHSC_CONFC_RCFGC_WTHRC_RSURC_RALNC_TRAFV_IDV_TYPEV_YEARP_IDP_SEXP_AGEP_PSNP_ISEV
2019111122321154181120151M56QQ1
201911112232115418112015UUUUUUUU
2019111122321154182120101F30112
2019111122321154182120102U1QQN
2019111622321253181120071F27112
2019111622321253181120072F5331
2019111622321253182120091M18112
201911202141221121120111M38112
2019112021412211299NNNNNNUUUUUUUU
2019112021412211299NNNNNNUUUUUUUU

Official sources and licences

Related open data