---
title: Road crashes, New South Wales
resource: https://publicdata.au/d/nsw-road-crashes/
publisher: Transport for NSW
licence: CC BY 3.0 AU
licence_url: https://creativecommons.org/licenses/by/3.0/au/
version: 2025-10-10
rows: 92189
fields: 62
source: https://opendata.transport.nsw.gov.au/data/dataset/06f9cf3d-0a9d-4098-b0f0-fa9efbdd3921/resource/c6351d27-b1b0-48e9-93a6-a612cba88f99/download/nsw_road_crash_data_2020-2024_crash.xlsx
source_sha256: 7345189f017d9c842429674ecf2196cee728de46c0572ce2a85220f9bef49aa9
language: en-AU
operator: National Digital
not_endorsed: true
---

# Road crashes, New South Wales

Every road crash reported to NSW Police that killed or injured someone or needed a tow, one row per crash, with date, location, road conditions and the number killed and injured.

Published by Transport for NSW under CC BY 3.0 AU and republished here in other formats, with cells typed and suppressed values made null. Transport for NSW has not endorsed this site.

Also called: NSW Crash Data, NSW road toll and crash statistics, Transport for NSW road crash data by crash, NSW car accident statistics.

## Download

Latest version, redirects to `https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/`:

- csv: https://publicdata.au/d/nsw-road-crashes/latest/data.csv (58 MB)
- xlsx: https://publicdata.au/d/nsw-road-crashes/latest/data.xlsx (32 MB)
- json: https://publicdata.au/d/nsw-road-crashes/latest/data.json (157 MB)
- geojson: https://publicdata.au/d/nsw-road-crashes/latest/data.geojson (166 MB)
- parquet: https://publicdata.au/d/nsw-road-crashes/latest/data.parquet (5.0 MB)
- sqlite: https://publicdata.au/d/nsw-road-crashes/latest/data.sqlite (53 MB)
- duckdb: https://publicdata.au/d/nsw-road-crashes/latest/data.duckdb (10 MB)
- gpkg: https://publicdata.au/d/nsw-road-crashes/latest/data.gpkg (60 MB)
- geo.parquet: https://publicdata.au/d/nsw-road-crashes/latest/data.geo.parquet (5.7 MB)
- ndjson: https://publicdata.au/d/nsw-road-crashes/latest/data.ndjson (157 MB)
- arrow: https://publicdata.au/d/nsw-road-crashes/latest/data.arrow (19 MB)
- csv.gz: https://publicdata.au/d/nsw-road-crashes/latest/data.csv.gz (10 MB)

Pinned version 2025-10-10: `https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/data.<format>`. 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/nsw-road-crashes/rows. Counts and sums: https://publicdata.au/api/v1/datasets/nsw-road-crashes/aggregate.

- Rows: https://publicdata.au/api/v1/datasets/nsw-road-crashes/rows?degree_of_crash=eq.Fatal&limit=5
- Aggregate: https://publicdata.au/api/v1/datasets/nsw-road-crashes/aggregate?group=speed_limit&metric=count&degree_of_crash=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/<date>/` before `rows` or `aggregate` for an answer that never changes. `/api/v1/datasets/<slug>/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/nsw-road-crashes/openapi.json

## Explore

Charts and dashboards in the browser: https://publicdata.au/d/nsw-road-crashes/explore/. A dashboard can be shared as a link or embedded.

## Smaller files

- by `year_of_crash`: https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/by/year_of_crash/index.json lists 6 files

## Fields

| field | type | publisher's header | note |
|---|---|---|---|
| `crash_id` | integer | Crash ID |  |
| `degree_of_crash` | string | Degree of crash |  |
| `degree_of_crash_detailed` | string | Degree of crash - detailed |  |
| `reporting_year` | integer | Reporting year |  |
| `year_of_crash` | integer | Year of crash |  |
| `month_of_crash` | string | Month of crash |  |
| `day_of_week_of_crash` | string | Day of week of crash |  |
| `two_hour_intervals` | string | Two-hour intervals |  |
| `street_of_crash` | string | Street of crash |  |
| `street_type` | string | Street type |  |
| `distance` | integer | Distance |  |
| `direction` | string | Direction |  |
| `identifying_feature` | string | Identifying feature |  |
| `identifying_feature_type` | string | Identifying feature type |  |
| `town` | string | Town |  |
| `route_no` | integer | Route no. |  |
| `school_zone_location` | string | School zone location |  |
| `school_zone_active` | string | School zone active |  |
| `type_of_location` | string | Type of location |  |
| `latitude` | number | Latitude | As published. The publisher's data manual does not state the datum. |
| `longitude` | number | Longitude | As published. The publisher's data manual does not state the datum. |
| `lga` | string | LGA |  |
| `urbanisation` | string | Urbanisation |  |
| `conurbation_1` | string | Conurbation 1 |  |
| `alignment` | string | Alignment |  |
| `primary_permanent_feature` | string | Primary permanent feature |  |
| `primary_temporary_feature` | string | Primary temporary feature |  |
| `primary_hazardous_feature` | string | Primary hazardous feature |  |
| `street_lighting` | string | Street lighting |  |
| `road_surface` | string | Road surface |  |
| `surface_condition` | string | Surface condition |  |
| `weather` | string | Weather |  |
| `natural_lighting` | string | Natural lighting |  |
| `signals_operation` | string | Signals operation |  |
| `other_traffic_control` | string | Other traffic control |  |
| `speed_limit` | string | Speed limit |  |
| `road_classification_admin` | string | Road classification (admin) |  |
| `rum_code` | integer | RUM - code |  |
| `rum_description` | string | RUM - description |  |
| `dca_code` | integer | DCA - code |  |
| `dca_description` | string | DCA - description |  |
| `dca_supplement` | string | DCA supplement |  |
| `first_impact_type` | string | First impact type |  |
| `key_tu_type` | string | Key TU type |  |
| `other_tu_type` | string | Other TU type |  |
| `traffic_units` | integer | No. of traffic units involved |  |
| `killed` | integer | No. killed |  |
| `seriously_injured` | integer | No. seriously injured |  |
| `moderately_injured` | integer | No. moderately injured |  |
| `minor_other_injured` | integer | No. minor-other injured |  |
| `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

- 2025-10-10: 92189 rows, 62 fields, sha256 7345189f017d. https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/

Machine-readable: https://publicdata.au/d/nsw-road-crashes/versions.json, https://publicdata.au/d/nsw-road-crashes/changes.json, https://publicdata.au/d/nsw-road-crashes/datapackage.json, https://publicdata.au/d/nsw-road-crashes/schema.json, https://publicdata.au/d/nsw-road-crashes/history.tar.zst

## Same subject, other publishers

- [Road crashes, ACT](https://publicdata.au/d/act-road-crashes/) (ACT)
- [Road crash locations, Queensland](https://publicdata.au/d/qld-road-crash-locations/) (Qld)
- [Road crash locations, South Australia](https://publicdata.au/d/sa-road-crash-locations/) (SA)
- [Road crashes, Tasmania](https://publicdata.au/d/tas-road-crashes/) (Tas)
- [Road crashes, Victoria](https://publicdata.au/d/vic-road-crashes/) (Vic)
- [Australian Road Deaths Database, fatalities](https://publicdata.au/d/au-road-deaths/) (Cth)
- [Seatbelt and helmet use in road crash casualties, Queensland](https://publicdata.au/d/qld-road-crash-restraint-helmet-use/) (Qld)
- [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)
- [Mobile speed camera visits, ACT](https://publicdata.au/d/act-mobile-speed-camera-visits/) (ACT)

## Attribution and citation

Transport for NSW, NSW Government, NSW Crash Data, sourced 29 September 2026, https://data.nsw.gov.au/data/dataset/2-nsw-crash-data, licensed under CC BY 3.0 AU.

The licence requires the publisher's attribution. We ask that you also name publicdata.au and link to the version you used.

Plain text: Transport for NSW, NSW Government, NSW Crash Data, sourced 29 September 2026, https://data.nsw.gov.au/data/dataset/2-nsw-crash-data, licensed under CC BY 3.0 AU. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/

Harvard: Transport for NSW (2025) Road crashes, New South Wales, version 2025-10-10 [data set], CC BY 3.0 AU, sourced 29 September 2026. Serialised and versioned by National Digital at publicdata.au. Available at: https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/

Markdown: Data: [Road crashes, New South Wales](https://data.nsw.gov.au/data/dataset/2-nsw-crash-data), Transport for NSW, [CC BY 3.0 AU](https://creativecommons.org/licenses/by/3.0/au/), sourced 29 September 2026. Files: [publicdata.au](https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/) by [National Digital](https://nationaldigital.com.au/).

## Questions

### How do I download Road crashes as a CSV file?

Open https://publicdata.au/d/nsw-road-crashes/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/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/nsw-road-crashes/v/2025-10-10/data.xlsx is a workbook with the 92,189 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/nsw-road-crashes/v/2025-10-10/data.csv.gz is the CSV at about a tenth of the size.

### What years does Road crashes cover?

The current version covers 2020 to 2024. Each release from TfNSW becomes a new dated version here, and earlier versions stay online.

### How often is Road crashes updated?

TfNSW releases it yearly. 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 3.0 AU 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 Transport for NSW, and its page is https://data.nsw.gov.au/data/dataset/2-nsw-crash-data. This site republishes the publisher's file without changing its content. The original sits beside every version as source.xlsx with its SHA-256, so the two can be compared.

### How do I get only the rows for one year of crash?

Every version has one JSON file per value of year_of_crash, 6 files in the current version, listed with row counts at https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/by/year_of_crash/index.json. For example https://publicdata.au/d/nsw-road-crashes/v/2025-10-10/by/year_of_crash/2024.json holds the 18,939 rows where year_of_crash is 2024. A GeoJSON file sits beside each one.

### What coordinate system does Road crashes use?

Latitude and longitude in decimal degrees as published. The publisher's data manual does not state the datum; GDA94 is the NSW Government's standard and 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 TfNSW 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.

### Which crashes are included?

The crashes reported to NSW Police on a public road in the five reporting years of the release, in which a person was killed or injured or a vehicle was towed away. Each row is one crash, with its location, road and conditions and the number of people killed or injured.

### Why does each version cover only five years?

Transport for NSW publishes a rolling five years each October and adds the release as a new file. This entry follows the newest file, so each version is one release. Earlier releases stay here as earlier versions.

### Can I count the road toll from this?

The killed column counts people who died within 30 days of the crash, as the publisher reports them. Add it across the crashes of a year to get the deaths the publisher counted for that year.

## 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.xlsx`.

## Improve this dataset

This page is built from [register/nsw-road-crashes.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/nsw-road-crashes.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.