National Collision Database (2020) (English, CSV)
National Collision Database (2020): live English CSV table with 198,745 rows and 23 fields. Filter, chart and export up to 10,000 rows as CSV. From Transport Canada, updated Jan 2025.
- Format
- CSV
- Access
- Live table (filter, chart, export)
- Rows
- 198,745
- Fields
- 23
- Publisher-reported update
- 2025-01-17
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.
Data overview
- Formats
- CSV
- File languages
- English
- Available actions
- Query table · Access original file
Available fields (20/23)
Fields from the loaded table schema.
| Field | Recorded type |
|---|---|
| C_YEAR | INTEGER |
| C_MNTH | TEXT |
| C_WDAY | TEXT |
| C_HOUR | TEXT |
| C_SEV | INTEGER |
| C_VEHS | TEXT |
| C_CONF | TEXT |
| C_RCFG | TEXT |
| C_WTHR | TEXT |
| C_RSUR | TEXT |
| C_RALN | TEXT |
| C_TRAF | TEXT |
| V_ID | TEXT |
| V_TYPE | TEXT |
| V_YEAR | TEXT |
| P_ID | TEXT |
| P_SEX | TEXT |
| P_AGE | TEXT |
| P_PSN | TEXT |
| P_ISEV | TEXT |