publicdataau
Published by Department of Transport and Main Roads under CC BY 4.0 and republished here without change to the content. Department of Transport and Main Roads has not endorsed this site.
Datasets / Queensland / Transport and Main Roads / Crash data from Queensland roads

Road crash locations, Queensland

live
Publisher Department of Transport and Main RoadsUpdated about twice a yearLicence CC BY 4.0Latest 2026-04-24As at 30 June 2025Rows 415,407Fields 52

One row per reported road traffic crash in Queensland from 1 January 2001. The publisher includes a crash when a person was killed or injured, a vehicle was towed away, or property damage met its reporting threshold. Property damage only crashes stop after 31 December 2010. Crashes in the last 12 months of a release are preliminary because police investigations can take up to a year. Coordinates are GDA2020.

This is the largest of six tables the publisher releases together. The other five are aggregate counts by year and police region.

Part of Crash data from Queensland roads, 6 tables the publisher releases together: Road casualties, Queensland, Driver demographics in road crashes, Queensland, Seatbelt and helmet use in road crash casualties, Queensland, Vehicle types in road crashes, Queensland, Factors in road crashes, Queensland.

Format
"Latest" redirects to the newest version and will change when the publisher releases again. A dated version never changes.
https://publicdata.au/d/qld-road-crash-locations/latest/data.parquet
Download

What is in it

Column names are made snake_case and the publisher's original header is kept beside each one. Blank cells are null. Nothing is added, removed, ranked or summarised. Cells were typed and headers were made snake_case. The publisher's header is kept beside every field in schema.json. Rows were left alone.

FieldTypePublisher's headerNote
crash_ref_numberintegerCrash_Ref_NumberThe publisher's identifier for the crash. Unique within a release.
crash_severitystringCrash_SeverityFatal, Hospitalisation, Medical treatment, Minor injury or Property damage only. Property damage only crashes stop after 31 December 2010.
crash_yearintegerCrash_Year
crash_monthstringCrash_MonthMonth name.
crash_day_of_weekstringCrash_Day_Of_Week
crash_hourintegerCrash_HourHour of the day, 0 to 23.
crash_naturestringCrash_NatureFor example Angle, Rear-end, Hit pedestrian.
crash_typestringCrash_TypeSingle Vehicle, Multi-Vehicle, Hit pedestrian or Other.
crash_longitudenumberCrash_LongitudeDecimal degrees, GDA2020. Blank for 598 crashes in the April 2026 release.
crash_latitudenumberCrash_LatitudeDecimal degrees, GDA2020.
crash_streetstringCrash_Street
crash_street_intersectingstringCrash_Street_IntersectingBlank when the crash was not at an intersection.
state_road_namestringState_Road_NameBlank on locally controlled roads.
loc_suburbstringLoc_Suburb
loc_local_government_areastringLoc_Local_Government_Area
loc_post_codestringLoc_Post_CodeKept as text.
loc_police_divisionstringLoc_Police_Division
loc_police_districtstringLoc_Police_District
loc_police_regionstringLoc_Police_Region
loc_queensland_transport_regionstringLoc_Queensland_Transport_Region
loc_main_roads_regionstringLoc_Main_Roads_Region
loc_abs_statistical_area_2stringLoc_ABS_Statistical_Area_2ABS SA2 name.
loc_abs_statistical_area_3stringLoc_ABS_Statistical_Area_3ABS SA3 name.
loc_abs_statistical_area_4stringLoc_ABS_Statistical_Area_4ABS SA4 name.
loc_abs_remotenessstringLoc_ABS_RemotenessABS remoteness class.
loc_state_electoratestringLoc_State_Electorate
loc_federal_electoratestringLoc_Federal_Electorate
crash_controlling_authoritystringCrash_Controlling_AuthorityState-controlled, Locally-controlled, Other or Not coded.
crash_roadway_featurestringCrash_Roadway_Feature
crash_traffic_controlstringCrash_Traffic_Control
crash_speed_limitstringCrash_Speed_LimitA band such as 60 km/h or 100 - 110 km/h. Kept as text because the publisher uses bands.
crash_road_surface_conditionstringCrash_Road_Surface_Condition
crash_atmospheric_conditionstringCrash_Atmospheric_Condition
crash_lighting_conditionstringCrash_Lighting_Condition
crash_road_horiz_alignstringCrash_Road_Horiz_AlignHorizontal alignment.
crash_road_vert_alignstringCrash_Road_Vert_AlignVertical alignment.
crash_dca_codestringCrash_DCA_CodeDCA (Definitions for Coding Accidents) code. Kept as text to preserve leading zeros.
crash_dca_descriptionstringCrash_DCA_Description
crash_dca_group_descriptionstringCrash_DCA_Group_Description
dca_key_approach_dirstringDCA_Key_Approach_DirCompass direction of the key vehicle. Blank in about 8,000 rows.
count_casualty_fatalityintegerCount_Casualty_Fatality
count_casualty_hospitalisedintegerCount_Casualty_Hospitalised
count_casualty_medically_treatedintegerCount_Casualty_MedicallyTreated
count_casualty_minor_injuryintegerCount_Casualty_MinorInjury
count_casualty_totalintegerCount_Casualty_Total
count_unit_carintegerCount_Unit_CarNumber of cars involved.
count_unit_motorcycle_mopedintegerCount_Unit_Motorcycle_Moped
count_unit_truckintegerCount_Unit_Truck
count_unit_busintegerCount_Unit_Bus
count_unit_bicycleintegerCount_Unit_Bicycle
count_unit_pedestrianintegerCount_Unit_Pedestrian
count_unit_otherintegerCount_Unit_Other

schema.json has the same list as a Frictionless Table Schema. The key is crash_ref_number.

A sample record

The first row of the latest version, as it appears in data.json.

GET https://publicdata.au/d/qld-road-crash-locations/latest/data.json
{
  "crash_ref_number": 1,
  "crash_severity": "Medical treatment",
  "crash_year": 2006,
  "crash_month": "November",
  "crash_day_of_week": "Saturday",
  "crash_hour": 17,
  "crash_nature": "Hit parked vehicle",
  "crash_type": "Single Vehicle",
  "crash_longitude": 153.549734259921,
  "crash_latitude": -28.165244516642,
  "crash_street": "Boundary St",
  "crash_street_intersecting": null,
  "state_road_name": null,
  "loc_suburb": "Coolangatta",
  "loc_local_government_area": "Gold Coast City",
  "loc_post_code": "4225",
  "loc_police_division": "Coolangatta",
  "loc_police_district": "Gold Coast",
  "loc_police_region": "South Eastern",
  "loc_queensland_transport_region": "SEQ South",
  "loc_main_roads_region": "South Coast",
  "loc_abs_statistical_area_2": "Coolangatta",
  "loc_abs_statistical_area_3": "Coolangatta",
  "loc_abs_statistical_area_4": "Gold Coast",
  "loc_abs_remoteness": "Major Cities",
  "loc_state_electorate": "Currumbin",
  "loc_federal_electorate": "Mcpherson",
  "crash_controlling_authority": "Locally-controlled",
  "crash_roadway_feature": "No Roadway Feature",
  "crash_traffic_control": "No traffic control",
  "crash_speed_limit": "0 - 50 km/h",
  "crash_road_surface_condition": "Sealed - Dry",
  "crash_atmospheric_condition": "Clear",
  "crash_lighting_condition": "Daylight",
  "crash_road_horiz_align": "Straight",
  "crash_road_vert_align": "Grade",
  "crash_dca_code": "703",
  "crash_dca_description": "Off Path-Straight: Left Off Cway Hit Obj",
  "crash_dca_group_description": "16: Off Carriageway on Straight Hit Object",
  "dca_key_approach_dir": "E",
  "count_casualty_fatality": 0,
  "count_casualty_hospitalised": 0,
  "count_casualty_medically_treated": 1,
  "count_casualty_minor_injury": 0,
  "count_casualty_total": 1,
  "count_unit_car": 2,
  "count_unit_motorcycle_moped": 1,
  "count_unit_truck": 0,
  "count_unit_bus": 0,
  "count_unit_bicycle": 0,
  "count_unit_pedestrian": 0,
  "count_unit_other": 0
}

Smaller files

The same rows split by a field, one JSON file each with a GeoJSON beside it. Each file carries the same provenance header.

By crash_year (25 files)

by/crash_year/index.json lists every file with its row count.

By loc_local_government_area (79 files)

by/loc_local_government_area/index.json lists every file with its row count.

What changed

One version for every release the publisher has made since this site started following the dataset. The date is the day the file changed on the portal. The "as at" date is the publisher's own.

  • 2026-04-24as at 30 June 2025
    415,407 rows52 fieldsutf-8-sig975be4b02a23

versions.json · changes.json · history.tar.zst (17 MB, every version's Parquet and manifest)

What this site did to the data. Cells were typed, headers were renamed and the encoding was made UTF-8. Rows were left alone. The publisher's file sits beside every version as source.csv so the change can be checked.

The publisher releases Crash data from Queensland roads as 6 files at once, so all 6 tables here share a version date.