National Collision Database

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.

Resources

Resource Name Resource Type Format Language Links
National Collision Database 1999 to 2012 Dataset CSV English
French
Access
Data Dictionary NCDB Dataset DOC English
French
Access
National Collision Database 1999 to 2012 Dataset ZIP English
French
Access
National Collision Database 2012 Dataset CSV English
French
Access
National Collision Database 2012 Dataset ZIP English
French
Access

Comments

  • meaneych

    2013-09-12

    Would be really cool if you could add two fields: longitude/latitude of vehicle involved in collisions. You could make some really interesting maps with these data. Make it easier to identify collision hot spots. Could also link this to time component to see how collision location trends change over time.

  • open-ouvert

    2013-09-26

    [The following comment is posted on behalf of Transport Canada.] A good comment. Unfortunately, in our current database, the longitude and latitude are not available. It is something we hope the jurisdictions (who supply the collision data) will eventually be able to send us in the future.

  • Ahmad

    2014-02-27

    The file is HUGE. It will be good if you separate it by year or API that makes it searchable by specific value as most people would like to view data with regard to specific type :car type, certain age, certain year...etc

  • Alieda

    2014-03-07

    It would also be great, if longitude and latitude are not available, to get some sense of where these collisions took place - even by province. Especially since motor vehicle licensing is by province, this way you could compare laws and policies with changes in collision rates over time.

  • Data.gc.ca

    2014-04-03

    The follow response has been posted on behalf of Transport Canada : "It has been determined by the jurisdictions that provide this data that province/territory is among a number of variables that cannot be shared. As a result, the information that is published must remain at the national summary level.” Thank you, Data.gc.ca

  • saquib

    2014-11-20

    What does each record in the dataset represent? Does it represent a car involved in the accident or a person involved? I mean if two cars collided, each carrying two people, will there be 4 records associated to that accident, or only two? I have ruled out the possibility that each record represents one collision.

  • open-ouvert

    2015-01-30

    Thank you for your comment. The following is a response from the data owner: The National Collision Database is a hierarchal dataset with three main segments containing collision-level, vehicle-level and person-level information. Each record represents a person involved. In the example provided, where 2 vehicles each have 2 persons, there would be 4 records.

  • mdmck

    2014-12-16

    more clarification is needed about the data elements. medical fatalities versus collision severity fatalities is not clearly defined

  • open-ouvert

    2015-01-30

    Thank you for your comment. The following is a response from the data owner : If we understand the comment correctly, our response is that the difference between C_SEV and P_ISEV can be found in the data dictionary provided to the portal (and copied below). For clarification purposes, please note that C_SEV is at the collision level and that P_ISEV is at the person level. If there was something else, please re-phrase the comment/question. C_SEV Code Description 1 Collision producing at least one fatality 2 Collision producing non-fatal injury U Unknown X Jurisdiction does not provide this data element P_ISEV Code Description 1 No Injury 2 Injury 3 Fatality Died immediately or within the time limit. N Data element is not applicable e.g. “dummy" person record created for parked cars U Unknown e.g. applies to runaway cars X Jurisdiction does not provide this data element

  • david

    2015-01-22

    This table is at the person level. this data is really hard to work with. I would really like to see the creation of a Incident level ID and a vehicle level ID so I can see how many vehicles/persons were involves in a collision. The IDs in the dataset are merely counts of number of people and vehicles.

  • open-ouvert

    2015-02-11

    Thank you for your comment. The following is a response from the data owner : Thank you for your comments. We will look into the feasibility of incorporating collision and vehicle level IDs into future iterations of this data product. In the meantime, please feel free to visit our online data tool at http://www.tc.gc.ca/VehicleCollisions. You could also contact Transport Canada’s Evaluation and Data Systems team directly via ncdb-bndc@tc.gc.ca

  • Engineer

    2015-04-14

    294MB file size? Surely there's a better way to present this data.

  • James Liu

    2015-05-02

    To my understand from the previous reply, there are multiple rows representing same incidents(one collision will possible generate multiple rows due to multiple injuries. Is there a way to identify which multiple row represents the same incidents so i can summarize them into one?

  • Ray H

    2015-11-08

    Fantastic Dataset. I echo the wish for Jurisdiction or provincial information but understand if that needs to be limited. Do you know if this will be updated past 2012? Thank you!

  • open-ouvert

    2015-11-25

    Hi Ray, the response from Transport Canada: "Thank you for your inquiry. At this time, the data are limited to national-level only. We are in the process of compiling the 2013 data so we expect to make these data available in the near future. Thank you."

  • Robert

    2016-02-11

    I notice you state Bilingual in the various formats of the dataset, but don't see any French values. Do you have a list of all elements with French values?

  • Dave

    2016-05-19

    In this day and age of open data (open gov), the lat/lon information should be made available. May police departments are starting to provide their crime data (not just collisions) via open data portals. Check out http://data.vancouver.ca/datacatalogue/crime-data.htm as an example.

  • open-ouvert

    2016-05-19

    Dave, Thanks for your comment. I have shared your views with the data holder for their consideration. Karin from the open-ouvert team

  • Dave

    2016-05-19

    Thank you!

  • open-ouvert

    2016-06-15

    Hi Dave, The following response has been posted on behalf of the data owner: "Thank you for your comment. The National Collision Database is in the process of trying to collect and report on additional data elements including ‘Collision Location – Geocode’. However, at this time the jurisdictions responsible for collecting these data have not been able to collect the location data on a sufficiently complete basis, so we are unable to compile and release location data at this time." -Tasha, the Open Government Team

  • vinalert.com

    2016-05-30

    will there be a way to search for vehicles themselves? ie search for the VIN to find out if a car was in an accident?

  • open-ouvert

    2016-05-31

    Hello, Thank you for your question. I have sent this to the data owner for clarification. Thanks, Tasha, the Open Government Team