Project Info

Project Request Date: 07/17/2019
Project Requested By: Nikiforos Stamatiadis
Principle Investigator: Eric Green and Tony Fields

Initial Inquiry

The request was for an analysis of crash severity for the most recent five year period summarized for intersection related vs non-intersection related crashes for 1) all Kentucky crashes; 2) crashes involving young drivers (age 16-20); and 3) crashes involving mature drivers (age 65 and over).

Project Write-up & Data Provided

A custom SQL query was written to retrieve data from the on-premises SQL database and to produce summary counts of the applicable crash types. The results were exported to a spreadsheet and delivered to the requestor.


The Kentucky Traffic Safety Data Service (KTSDS) is a program of the Kentucky Transportation Center.
176 Raymond Building, University of Kentucky, Lexington KY 40506.

Copyright © 2022 Kentucky Transportation Center, University of Kentucky.