`tn_dmv_impaired_driving_crashes`

Pack: tn-dmv · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/tn_dmv_impaired_driving_crashes for the schema, then POST the same URL with its arguments for the data.

Count Tennessee injury and fatal traffic crashes involving alcohol or drugs, from the Department of Safety and Homeland Security crash file for calendar year ${CRASH_YEAR}. Each record is one person involved in an impaired-driving crash, carrying crash severity (fatal, suspected serious injury, suspected minor injury), the driver age group and gender, the investigating law-enforcement agency, date, time and coordinates. Answers “how many fatal DUI crashes in Tennessee”, “which age group is involved in the most alcohol-related crashes in Tennessee”, “drug-involved crashes by police agency”, or “impaired driving crashes by month”. Group results by age_group, gender, severity, agency, substance or month, and get a sample of the underlying records with latitude and longitude for mapping.

Parameters

Name	Type	Required	Description
`substance`	string	no	”alcohol”, “drugs”, “both” (alcohol and drugs together), or “either” (default — any impairment).
`severity`	string	no	Crash severity substring: “fatal”, “serious injury”, “minor injury”.
`age_group`	string	no	Age band substring as published, e.g. “21 to 24”, “80 & Up”, “16 to 17”.
`gender`	string	no	Published as “M” or “F”; “male”/“female” are accepted.
`agency`	string	no	Investigating agency substring. State troopers are published as “THP District 3 - Nashville” and similar, so “THP” selects all of them; city forces read “METROPOLITAN NASHVILLE POLICE DEPT”, “MEMPHIS POLICE DEPT”; counties read “SHERIFF”.
`group_by`	string	no	Breakdown dimension: ${Object.keys(CRASH_GROUPS).join(’, ’)}. Defaults to age_group.
`limit`	number,string	no	Max sample records returned alongside the counts (default 10, max 200).

Example call

Arguments

{
  "group_by": "substance"
}

curl

curl -X POST https://gateway.pipeworx.io/tn-dmv/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"tn_dmv_impaired_driving_crashes","arguments":{"group_by":"substance"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('tn_dmv_impaired_driving_crashes', {
  "group_by": "substance"
});

More examples

{
  "substance": "alcohol",
  "severity": "fatal",
  "group_by": "age_group"
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the tn-dmv pack

{
  "mcpServers": {
    "tn-dmv": {
      "url": "https://gateway.pipeworx.io/tn-dmv/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

tn_dmv_impaired_driving_crashes