Uncovering Issues in Connecticut’s Vehicle Towing and Sale Process
A recent investigation by CT Mirror and propublica has revealed potential problems within Connecticut’s Department of Motor Vehicles (DMV) regarding the towing and sale of vehicles. This deep dive into over 6,000 DMV forms from 2022-23 highlights concerns about vehicle valuations and potential discrepancies in the process. Here’s a breakdown of what we found and how we arrived at these conclusions.
(Image: Harvey was lucky enough to get her luxury range Rover back, but it still needs expensive repairs. Shahrzad Rasekh/The Connecticut Mirror)
The Challenge of Analyzing DMV Forms
Analyzing the data wasn’t easy. Obtaining and processing over 10,000 scanned documents through public records requests presented notable hurdles. The forms, known as H-100s, were often difficult to decipher due to:
* Illegible handwriting.
* Inconsistent redactions.
* Numerous duplicates across multiple batches of documents.
Despite these challenges, our team meticulously reviewed each form to build a thorough database.
How We Built Our Database
Reporters manually extracted and entered key information from each H-100 form. This included:
* DMV-listed book value.
* Towing company name and license number.
* Tow date.
* Tower’s sale timeframe (15 or 45 days).
* Tower’s estimated vehicle value.
* DMV employee signature date.
While the vehicle identification number (VIN) was on each form, it was sometimes obscured or redacted, adding to the complexity.
Addressing Data Accuracy and Duplicates
Ensuring data accuracy was paramount. We implemented several steps to minimize errors and refine the dataset:
- Removing Non-Unique Rows: We eliminated duplicate entries to avoid inflating the numbers.
- Manual Review of Near-Duplicates: Nearly 2,000 rows with almost identical information were re-examined, resulting in the removal of an additional 900 duplicates.
- Handling Resubmissions: When a towing company submitted multiple forms for the same vehicle, we retained the most recent submission based on tow date and VIN.
- Interpreting Illegible Data: When handwritten numbers were unclear, we used our best judgment, prioritizing interpretations consistent with other dates on the form.
it’s significant to note that manual transcription inevitably introduces some level of error. We acknowledge the possibility of undercounting situations where multiple cars were towed and submitted for sale approval on the same day with identical valuations.
Connecting Vehicle Sales to Crash Data
To understand if high-value luxury cars were being sold in disrepair, we cross-referenced our database with the Connecticut Crash Data Repository. This allowed us to identify vehicles involved in accidents.
Though,this process had limitations. We could only match data by tow date, make, and year, meaning our count of cars not involved in crashes is likely an underestimate.
this investigation underscores the importance of openness and accountability in the vehicle towing and sale process. You deserve to know that your vehicle is being valued fairly and handled responsibly if it’s ever towed.We hope this data sheds light on potential issues and prompts further review and advancement within the Connecticut DMV.