--- title: Road crashes, ACT resource: https://publicdata.au/d/act-road-crashes/ publisher: Roads ACT, City and Environment Directorate licence: CC BY 4.0 licence_url: https://creativecommons.org/licenses/by/4.0/ version: 2026-10-01 rows: 76657 fields: 27 source: https://www.data.act.gov.au/api/views/6jn4-m8rx/rows.csv?accessType=DOWNLOAD source_sha256: 45dbb9445b51fdbd831d2c89efa8965f5a3071d50ccf04e0e63374a49ed39a00 language: en-AU operator: National Digital not_endorsed: true --- # Road crashes, ACT Every crash in the ACT since 2015 reported through the AFP Crash Report Form, one row per crash, with its coordinates, suburb, severity, type, lighting, road and weather conditions. Published by Roads ACT, City and Environment Directorate under CC BY 4.0 and republished here in other formats, with cells typed and suppressed values made null. Roads ACT, City and Environment Directorate has not endorsed this site. Also called: ACT Road Crash Data, Canberra car accident data, AFP Crash Report Form data, Roads ACT crash statistics. ## Download Latest version, redirects to `https://publicdata.au/d/act-road-crashes/v/2026-10-01/`: - csv: https://publicdata.au/d/act-road-crashes/latest/data.csv (25 MB) - xlsx: https://publicdata.au/d/act-road-crashes/latest/data.xlsx (12 MB) - json: https://publicdata.au/d/act-road-crashes/latest/data.json (57 MB) - geojson: https://publicdata.au/d/act-road-crashes/latest/data.geojson (65 MB) - parquet: https://publicdata.au/d/act-road-crashes/latest/data.parquet (3.2 MB) - sqlite: https://publicdata.au/d/act-road-crashes/latest/data.sqlite (23 MB) - duckdb: https://publicdata.au/d/act-road-crashes/latest/data.duckdb (4.0 MB) - gpkg: https://publicdata.au/d/act-road-crashes/latest/data.gpkg (28 MB) - geo.parquet: https://publicdata.au/d/act-road-crashes/latest/data.geo.parquet (3.8 MB) - ndjson: https://publicdata.au/d/act-road-crashes/latest/data.ndjson (57 MB) - arrow: https://publicdata.au/d/act-road-crashes/latest/data.arrow (8.2 MB) - csv.gz: https://publicdata.au/d/act-road-crashes/latest/data.csv.gz (3.4 MB) Pinned version 2026-10-01: `https://publicdata.au/d/act-road-crashes/v/2026-10-01/data.`. Dated versions never change. ## Query The query API returns only the rows you ask for, as JSON, NDJSON or CSV, from the same typed rows as the files. It needs no key. Rows: https://publicdata.au/api/v1/datasets/act-road-crashes/rows. Counts and sums: https://publicdata.au/api/v1/datasets/act-road-crashes/aggregate. - Rows: https://publicdata.au/api/v1/datasets/act-road-crashes/rows?crash_severity=eq.Fatal&limit=5 - Aggregate: https://publicdata.au/api/v1/datasets/act-road-crashes/aggregate?group=crash_type&metric=count&crash_severity=eq.Fatal Each filter is `field=operator.value` in the query string, and every filter must match. A number or date field compares as a number or date, and a text field compares as text. Values are case-sensitive except with `ilike`. Prefix `not.` to negate a filter, as `not.eq.value`. Operators: `eq.value`, `neq.value`, `gt.value`, `gte.value`, `lt.value`, `lte.value`, `like.*text*`, `ilike.*text*`, `in.(a,b,c)`, `is.null`. - `select`: Fields to return, comma-separated. Every field when absent. - `order`: `field.asc` or `field.desc`, comma-separated. The publisher's row order when absent. - `limit`: Rows per page, 1 to 10,000. 100 when absent. - `offset`: Rows to skip. The `next` URL in each answer sets it for you. - `group`: On `aggregate`, fields to group by, comma-separated. - `metric`: On `aggregate`, `count`, `sum.field`, `avg.field`, `min.field` or `max.field`, comma-separated. `count` when absent. - `format`: `json`, `ndjson` or `csv`. JSON carries the provenance header, and the others carry it in response headers. Without a version the API answers from the newest loaded version, and that answer changes when the publisher releases again. Put `versions//` before `rows` or `aggregate` for an answer that never changes. `/api/v1/datasets//versions` lists the loaded versions. The API allows 60 requests in 10 seconds from one address. Above that it answers 429 for 10 seconds with a `Retry-After` header, a `RateLimit-Policy` header and a JSON body that gives the limit. Every API answer carries the same `RateLimit-Policy`. A client should wait the `Retry-After` seconds, or read the files, which have no limit. OpenAPI for this dataset: https://publicdata.au/d/act-road-crashes/openapi.json ## Explore Charts and dashboards in the browser: https://publicdata.au/d/act-road-crashes/explore/. A dashboard can be shared as a link or embedded. ## Smaller files - by `crash_severity`: https://publicdata.au/d/act-road-crashes/v/2026-10-01/by/crash_severity/index.json lists 3 files ## Fields | field | type | publisher's header | note | |---|---|---|---| | `crash_id` | integer | CRASH_ID | The publisher's identifier for the crash. | | `crash_date` | date | CRASH_DATE | | | `crash_time` | string | CRASH_TIME | 12-hour time as the publisher types it, for example 5:44 PM. | | `suburb_location` | string | SUBURB_LOCATION | | | `longitude` | number | LONGITUDE | Decimal degrees. | | `latitude` | number | LATITUDE | Decimal degrees. | | `intersection` | boolean | INTERSECTION | | | `midblock` | boolean | MIDBLOCK | | | `crash_direction` | string | CRASH_DIRECTION | | | `crash_type` | string | CRASH_TYPE | | | `crash_severity` | string | CRASH_SEVERITY | Fatal, Injury or Property damage only. | | `lighting_condition` | string | LIGHTING_CONDITION | | | `road_condition` | string | ROAD_CONDITION | | | `weather_condition` | string | WEATHER_CONDITION | | | `location` | string | Location | The publisher's own text of the coordinates, as (latitude, longitude). | | `sa2_2021_code` | string | (spine: sa2) | Code of the Statistical Area Level 2 (2021) the point falls in. Joined by location from abs-sa2-2021, not published by the publisher. | | `sa2_2021_name` | string | (spine: sa2) | Name of the Statistical Area Level 2 (2021) the point falls in. Joined by location from abs-sa2-2021, not published by the publisher. | | `lga_2025_code` | string | (spine: lga) | Code of the Local Government Area (2025) the point falls in. Joined by location from abs-lga-2025, not published by the publisher. | | `lga_2025_name` | string | (spine: lga) | Name of the Local Government Area (2025) the point falls in. Joined by location from abs-lga-2025, not published by the publisher. | | `sal_2021_code` | string | (spine: suburb) | Code of the Suburb and Locality (2021) the point falls in. Joined by location from abs-suburbs-localities-2021, not published by the publisher. | | `sal_2021_name` | string | (spine: suburb) | Name of the Suburb and Locality (2021) the point falls in. Joined by location from abs-suburbs-localities-2021, not published by the publisher. | | `poa_2021_code` | string | (spine: postcode) | Code of the Postal Area (2021) the point falls in. Joined by location from abs-postal-areas-2021, not published by the publisher. | | `poa_2021_name` | string | (spine: postcode) | Name of the Postal Area (2021) the point falls in. Joined by location from abs-postal-areas-2021, not published by the publisher. | | `sed_2025_code` | string | (spine: state_electorate) | Code of the State Electoral Division (2025) the point falls in. Joined by location from abs-state-electoral-divisions-2025, not published by the publisher. | | `sed_2025_name` | string | (spine: state_electorate) | Name of the State Electoral Division (2025) the point falls in. Joined by location from abs-state-electoral-divisions-2025, not published by the publisher. | | `ced_2025_code` | string | (spine: federal_electorate) | Code of the Commonwealth Electoral Division (2025) the point falls in. Joined by location from abs-federal-electoral-divisions-2025, not published by the publisher. | | `ced_2025_name` | string | (spine: federal_electorate) | Name of the Commonwealth Electoral Division (2025) the point falls in. Joined by location from abs-federal-electoral-divisions-2025, not published by the publisher. | Key: `crash_id`. ## Versions - 2026-10-01: 76657 rows, 27 fields, sha256 45dbb9445b51 (0 added, 0 removed, 0 changed). https://publicdata.au/d/act-road-crashes/v/2026-10-01/ - 2026-09-30: 76657 rows, 27 fields, sha256 562d854d4e03 (0 added, 0 removed, 0 changed). https://publicdata.au/d/act-road-crashes/v/2026-09-30/ - 2026-09-29: 76657 rows, 27 fields, sha256 70b3fcfb628d. https://publicdata.au/d/act-road-crashes/v/2026-09-29/ Machine-readable: https://publicdata.au/d/act-road-crashes/versions.json, https://publicdata.au/d/act-road-crashes/changes.json, https://publicdata.au/d/act-road-crashes/datapackage.json, https://publicdata.au/d/act-road-crashes/schema.json, https://publicdata.au/d/act-road-crashes/history.tar.zst ## Same subject, other publishers - [Road crash locations, Queensland](https://publicdata.au/d/qld-road-crash-locations/) (Qld) - [Road crashes, Tasmania](https://publicdata.au/d/tas-road-crashes/) (Tas) - [Road crashes, Victoria](https://publicdata.au/d/vic-road-crashes/) (Vic) - [Road crashes, New South Wales](https://publicdata.au/d/nsw-road-crashes/) (NSW) - [Road crash locations, South Australia](https://publicdata.au/d/sa-road-crash-locations/) (SA) - [Seatbelt and helmet use in road crash casualties, Queensland](https://publicdata.au/d/qld-road-crash-restraint-helmet-use/) (Qld) - [Mobile speed camera visits, ACT](https://publicdata.au/d/act-mobile-speed-camera-visits/) (ACT) - [Australian Road Deaths Database, fatalities](https://publicdata.au/d/au-road-deaths/) (Cth) - [Road casualties, Queensland](https://publicdata.au/d/qld-road-casualties/) (Qld) - [Driver demographics in road crashes, Queensland](https://publicdata.au/d/qld-road-crash-driver-demographics/) (Qld) - [Factors in road crashes, Queensland](https://publicdata.au/d/qld-road-crash-factors/) (Qld) - [Vehicle types in road crashes, Queensland](https://publicdata.au/d/qld-road-crash-vehicle-types/) (Qld) ## Attribution and citation Roads ACT, City and Environment Directorate, ACT Government, ACT Road Crash Data, https://www.data.act.gov.au/d/6jn4-m8rx, accessed 30 September 2026, licensed under CC BY 4.0. The licence requires the publisher's attribution. We ask that you also name publicdata.au and link to the version you used. Plain text: Roads ACT, City and Environment Directorate, ACT Government, ACT Road Crash Data, https://www.data.act.gov.au/d/6jn4-m8rx, accessed 30 September 2026, licensed under CC BY 4.0. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/act-road-crashes/v/2026-10-01/ Harvard: Roads ACT, City and Environment Directorate (2026) Road crashes, ACT, version 2026-10-01 [data set], CC BY 4.0, sourced 30 September 2026. Serialised and versioned by National Digital at publicdata.au. Available at: https://publicdata.au/d/act-road-crashes/v/2026-10-01/ Markdown: Data: [Road crashes, ACT](https://www.data.act.gov.au/d/6jn4-m8rx), Roads ACT, City and Environment Directorate, [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), sourced 30 September 2026. Files: [publicdata.au](https://publicdata.au/d/act-road-crashes/v/2026-10-01/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Road crashes as a CSV file? Open https://publicdata.au/d/act-road-crashes/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/act-road-crashes/v/2026-10-01/data.csv today. The same path serves Excel, JSON, GeoJSON, Parquet, SQLite, DuckDB, GeoPackage, GeoParquet, NDJSON, Arrow. A dated URL never changes, so use it when the file must stay the same. ### Can I open Road crashes in Excel? Yes. https://publicdata.au/d/act-road-crashes/v/2026-10-01/data.xlsx is a workbook with the 76,657 rows on a records sheet, the field list on a second sheet and the provenance on a third. The CSV also opens in Excel. https://publicdata.au/d/act-road-crashes/v/2026-10-01/data.csv.gz is the CSV at about a tenth of the size. ### What years does Road crashes cover? The current version covers 2015 to 2025. Each release from Roads ACT becomes a new dated version here, and earlier versions stay online. ### How often is Road crashes updated? Roads ACT releases it through the year. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Road crashes commercially? Yes. CC BY 4.0 allows commercial use, redistribution and derived works as long as the attribution is kept. The attribution string is in this page's side column and inside every file. ### Is this the official source for Road crashes? No. The publisher is Roads ACT, City and Environment Directorate, and its page is https://www.data.act.gov.au/d/6jn4-m8rx. This site republishes the publisher's file without changing its content. The original sits beside every version as source.csv with its SHA-256, so the two can be compared. ### How do I get only the rows for one crash severity? Every version has one JSON file per value of crash_severity, 3 files in the current version, listed with row counts at https://publicdata.au/d/act-road-crashes/v/2026-10-01/by/crash_severity/index.json. For example https://publicdata.au/d/act-road-crashes/v/2026-10-01/by/crash_severity/property-damage-only.json holds the 69,976 rows where crash_severity is Property damage only. A GeoJSON file sits beside each one. ### What coordinate system does Road crashes use? Longitude and latitude in decimal degrees as published. The publisher does not name the datum; GDA94 differs from GDA2020 and WGS84 by under 2 metres. The GeoJSON file uses the same coordinates, which is what GeoJSON expects. ### Which SA2, council area, suburb, postcode, state electorate and federal electorate is each row of Road crashes in? Each row with coordinates carries the SA2 (2021), Council area (LGA 2025), Suburb or locality (2021), Postcode (postal area 2021), State electorate (2025) and Federal electorate (2025) its point falls in, with the code of each. This site joins them by location against the ABS boundaries, https://publicdata.au/d/abs-sa2-2021/, https://publicdata.au/d/abs-lga-2025/, https://publicdata.au/d/abs-suburbs-localities-2021/, https://publicdata.au/d/abs-postal-areas-2021/, https://publicdata.au/d/abs-state-electoral-divisions-2025/, https://publicdata.au/d/abs-federal-electoral-divisions-2025/, and Roads ACT did not publish them. The schema marks each one as joined and names the boundary version. A row without coordinates, or a point outside every area, has them blank. Place columns from Australian Statistical Geography Standard (ASGS) Edition 3 boundaries, Australian Bureau of Statistics, licensed under CC BY 4.0. ### Does it include every crash in the ACT? No. The publisher includes crashes reported by police or the public through the AFP Crash Report Form. A crash reported another way, or not reported, is not here. The publisher also notes a backlog of entries, so recent months rise in later releases. ### How accurate are the locations? The publisher says a crash location is indicative and may not be the exact position of the people involved. ### How often is it updated? The publisher adds rows to the portal through the year. This site checks it weekly and adds a dated version when the rows change. ## What this site did to the data Cells were typed, headers were renamed to snake_case and the encoding was made UTF-8. Rows were left alone. Nothing is derived. The publisher's file is beside every version as `source.csv`. ## Improve this dataset This page is built from [register/act-road-crashes.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/act-road-crashes.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.