Background Bicycling is healthy but needs to be safer for more to bike. Police crash templates are designed for reporting crashes between motor vehicles, but not between vehicles/bicycles. If written/drawn bicycle-crash-scene details exist, these are not entered into spreadsheets.
Objective To assess which bicycle-crash-scene data might be added to spreadsheets for analysis.
Methods Police crash templates from 50 states were analysed. Reports for 3350 motor vehicle/bicycle crashes (2011) were obtained for the New York City area and 300 cases selected (with drawings and on roads with sharrows, bike lanes, cycle tracks and no bike provisions). Crashes were redrawn and new bicycle-crash-scene details were coded and entered into the existing spreadsheet. The association between severity of injuries and bicycle-crash-scene codes was evaluated using multiple logistic regression.
Results Police templates only consistently include pedal-cyclist and helmet. Bicycle-crash-scene coded variables for templates could include: 4 bicycle environments, 18 vehicle impact-points (opened-doors and mirrors), 4 bicycle impact-points, motor vehicle/bicycle crash patterns, in/out of the bicycle environment and bike/relevant motor vehicle categories. A test of including these variables suggested that, with bicyclists who had minor injuries as the control group, bicyclists on roads with bike lanes riding outside the lane had lower likelihood of severe injuries (OR, 0.40, 95% CI 0.16 to 0.98) compared with bicyclists riding on roads without bicycle facilities.
Conclusions Police templates should include additional bicycle-crash-scene codes for entry into spreadsheets. Crash analysis, including with big data, could then be conducted on bicycle environments, motor vehicle potential impact points/doors/mirrors, bicycle potential impact points, motor vehicle characteristics, location and injury.
This is an Open Access article distributed in accordance with the Creative Commons Attribution Non Commercial (CC BY-NC 4.0) license, which permits others to distribute, remix, adapt, build upon this work non-commercially, and license their derivative works on different terms, provided the original work is properly cited and the use is non-commercial. See: http://creativecommons.org/licenses/by-nc/4.0/
Statistics from Altmetric.com
From 2000 to 2013, the number of commuting bicyclists in the USA increased by 61.6%.1 This may be due in part to the health benefits of bicycling2–13 and the desire for a cleaner environment.14–18 While the health benefits outweigh the risks, including crashes,9 many individuals may still choose not to bicycle due to risk.19 If environments were safer for bicyclists, perhaps more individuals would bicycle.20 Having accurate crash data about bicyclists would be useful, especially since accurate motor vehicle crash (MVC) data produced better roadways and safer motor vehicles which, in turn, resulted in decreased crash-related morbidity and mortality.21–23
Police have recorded bicycle crashes since the introduction of the bicycle in 1890 when crashes were written in police journals.24 ,25 Crash reports are now entered by police officers on a state crash report template that includes spaces for a written description of the crash and free drawn diagrams plus boxes for coded information. Some of the data on the template, including the coded information, is later entered by a police officer or a staff person into a spreadsheet about that individual crash. The information requested on the template, and thus the data entered later into the spreadsheet, focuses primarily on crashes between motor vehicles.26
Diagrammatically, a motor vehicle most closely resembles a rectangle while a bicycle most closely resembles a line (figure 1). Consequently, the points of impact could be very different when two motor vehicles collide versus when a motor vehicle and a bicycle collide. For example, in a crash between a bicycle and a motor vehicle, a bicycle could strike an opened car door or a side mirror, or come alongside a motor vehicle in a narrow space between the motor vehicle and the road's edge. To describe a bicycle crash in a useful way, police crash report templates should be modified to include bicycle-crash-scene reporting fields. The current state crash report template does include a category for pedal cyclist/bicyclist, who is considered a non-motorist, but there are very few codes specific to bicyclists. Bicycle-crash-scene details can be found in the written crash description and drawing on the template but these details are not coded for entry into a spreadsheet. Therefore, when analyses require large existing data sets and the combining of many reports, bicycle-crash-scene details are not available.
Many state police are now entering crash reports into an electronic tablet, allowing the information to be automatically transferred, thus lessening errors from manual entry and improving timeliness. Advances are also being made through the Model Minimum Uniform Crash Criteria (MMUCC), a minimum and standardised data set for MVCs that describes the motor vehicles, people involved and environments.27 The Federal government, state agencies, local government officials, engineers, hospitals and researchers have proposed combining electronic data into the Crash Outcome Data Evaluation System (CODES) that includes police crash data, emergency medical services reports, hospital records and insurance claims.28 As these advances are being made and big data are being generated, perhaps the crash report entered into the electronic tablet could include a drop-down bike-only template with bicycle-crash-scene spreadsheet-coded data points. The issue then becomes what might be most informative as bicycle-crash-scene coded data in a spreadsheet.
No study has analysed police templates and crash report text/drawings to determine if the templates could be improved to more fully report motor vehicle/bicycle crashes. Therefore, this study first explored what bicycle-crash-scene coded information is in the existing state and MMUCC templates. Second, using police text and drawings from 300 motor vehicle/bicycle crashes in New York City (NYC), crashes were redrawn using Google street view and the vehicle identification number (VIN) studied to investigate what additional variables to consider as bicycle-crash-scene coded data. These new bicycle-crash-scene variables were added to the original spreadsheet crash file of 300 crashes and analysed to demonstrate the value of these new variables. If detailed and bicycle-crash-scene motor vehicle/bicycle crash information could be entered into a spreadsheet as coded data, combined with the other data in a spreadsheet (CODES),28 and used as part of the Pedestrian and Bicycle Crash Analysis Tool29 and bicycle road safety audits,30 the results might better inform changes to environments, motor vehicles, and bicycles to lower motor vehicle/bicycle crashes and severity of injury.
State and MMUCC crash report templates were studied and data in motor vehicle/bicycle crash report text and drawings in NYC analysed to determine which bicycle-crash-scene data might be informative to add as spreadsheet coded variables to police crash report templates to use in the analysis for improving safety.
Crash report template content comparisons
Crash templates were obtained from the individual state Departments of Motor Vehicles, state websites, and websites with templates.31 ,32 The templates studied for requested information (ie, what information was requested for the fill-in-the blank spaces and the small boxes for which there were codes) included 49 full crash templates dated 2000–2013, 2 full crash templates dated 1988–1991 and the MMUCC template. Then, the state templates were compared to identify what bicycle-crash-scene information was requested, or not, on each state template.
Motor vehicle/bicycle crashes in NYC selected for analysis (300 cases)
Full crash reports of 3350 motor vehicle/bicycle crashes in the NYC area for the year 2011 were obtained that had x/y coordinates (crash location) from the New York State Department of Transportation (NYSDOT). Using the geographical codes available in the spreadsheet file, we first identified the motor vehicle/bicycle crashes only in NYC (n=1080). With a bicycle facilities map for NYC, a map was generated designating the roads with four different bicycle environments ((1) roads; (2) sharrows—bike stencil designations on the street; (3) bike lanes; and (4) cycle tracks—barrier protected, bicycle exclusive paths beside sidewalks) and crash locations were superimposed on this map.
From NYSDOT, full copies of reports were requested for 46 crashes on sharrows (all sharrow crashes), 79 crashes on roads with cycle tracks (all cycle track crashes), 188 crashes on roads with bike lanes (all bike lane crashes) and, using a probability sampling programme, 188 crashes on roads with no bike facilities to match the number of crashes on roads with bike lanes (n=501 crashes). NYSDOT sent us 600 full crash reports (private information redacted) to better guarantee that we would have 300 crash reports with diagrams (83 out of the 600 crash reports had no crash diagrams). The maximum of 300 crashes was due to the significant amount of time involved in the reanalysis of each crash. For analysis, the selected crashes included all the crashes on roads with sharrows (n=44), all the crashes on roads with cycle tracks (n=65), and using a probability sampling programme, a random sample of crashes on roads with bike lanes (n=95) and a random sample of the crashes on roads without bicycle provisions (n=96).
Motor vehicle/bicycle crashes redrawn for impact, turns, and in or out of environment
Using the text and drawings in the crash reports and Google street views, each of the 300 motor vehicle/bicycle crashes were redrawn including streets and their directions, number of lanes, presence of parking, bicycle environment if one existed, motor vehicle/s location and bicycle location (figure 2). Then, an X was drawn to identify the impact location on the motor vehicle and the bicycle and a Google street view saved of the crash scene.
From the state templates and the web, the variety of diagrams was collected that depicted the turning direction and impact location (head-on crash with two arrows pointing towards each other) and similar turns/impact diagrams merged. The different turn/impact diagrams were matched to the 300 redrawn crash drawings (that had included the vehicle and bicycle turning directions), grouping all similar diagrams most relevant to motor vehicle/bicycle crash turns to achieve a manageable number (10). For example, if only two of the 300 bike crash scenarios were related to a turn/impact diagram, those two cases were merged with another similar scenario (figure 3).
The location of the bicyclist was also determined in relation to a bicycle environment, if an environment existed. These variables then included if the bicyclists were: (1) on a road with no designated bicycle environment; (2) on a road with sharrows; (3) in a street with bike lanes and inside the bike lane; (4) in a street with bike lanes but outside the lane; (5) in a street with cycle tracks and inside the cycle track; and (6) in a street with cycle tracks but outside the cycle track. The 300 redrawn vehicle/bicycle crashes then provided the following for each crash: (1) motor vehicle impact point; (2) bicycle impact point; (3) vehicle and bicycle turning directions (crash patterns); and (4) bicyclist's location and in or out of a bicycle environment.
VINs and motor vehicle configuration
The first 11 digits in the 17 motor vehicle code VIN were requested for the 300 crashes to reveal general motor vehicle characteristics but not owner identity. Using the digits and pictures of the motor vehicles from the web, the motor vehicle types were recategorised into bicycle crash/relevant characteristics based on an expert determination ((1) car sedan; (2) car sport utility vehicle (SUV); (3) hatchback; (4) van; (5) pick-up truck; (6) medium truck; (7) large truck; and (8) bus). This content could then be used in the analysis to determine if one type of vehicle was more likely to be involved in a crash with a bicycle.
Content in the different motor vehicle/bicycle crash report formats
From the NYSDOT the crash reports in all three formats were obtained that are available to the public. These reports include: (1) original police report with the text and diagram (private information redacted); (2) spreadsheet; and (3) shorter typed report. Having the three formats allowed us to determine and compare the level of detail in each of the formats.
Analysis was conducted using the new bicycle-crash-scene variables that were entered into the existing spreadsheet for the 300 NYC vehicle/bicycle crashes. This analysis provided the opportunity to begin to assess if having these bicycle-crash-scene variables might be worthwhile. Frequency of motor vehicle impact point, bicycle impact point, bicycle environments, bicycling inside or outside of the environments, motor vehicle type, and crash patterns (turn/impact diagrams) were analysed. Because the existing spreadsheet included the variables, as reported by the police, of bicyclists with minor injuries and bicyclists with severe injuries and it would be time-consuming to obtain bike counts for all the streets studied in NYC, bicyclists with minor injuries were used as the control group and bicyclists with severe injuries/fatalities as the case group. Based on injuries/fatalities, the groups then included: Group 1 (control group)—Minor injury included non-incapacitating injuries (n=99); and Group 2 (case group)—Severe injury included incapacitating injuries, possible injuries and killed (n=191). Variables were compared based on injury type by t test for quantitative variables and χ2 tests for qualitative variables. Logistic regression was also performed for independent variables which had been estimated as strongly affecting injury; ORs with 95% CIs were reported. Two models were constructed to examine the association between motor vehicle potential impact points, in/out (whether the crash happened inside or outside a bike lane or cycle track) and injury severity. Model 1A and 1B are unadjusted models. In Model 2A, potential confounders were adjusted including age (years), gender, road surface condition (dry, wet, muddy, snow/ice, slush, flooded water, other), crash pattern, motor vehicle type (motorcycle, car/van/pick-up truck, bus, bicycle, pedestrian, other, unknown), light condition (daylight, dawn, dusk, dark-road lighted, dark-road unlighted) and intersection. We did a sensitivity analysis by excluding crashes for which the vehicle in the existing spreadsheet was listed as unknown (Model 1B and 2B). Thus, Model 2B did not include possible hit-and-run crashes in which the vehicle driver would have left the scene. All analyses used SPSS V.21 (Chicago, Illinois, USA).
Analysis of the state police and MMUCC crash templates and 300 motor vehicle/bicycle crashes in NYC (impact points, crash patterns, in/out of environment, VINs and content in report formats) revealed motor vehicle/bicycle specific crash variables that, as spreadsheet-coded data, could be useful for analysis.
Existing crash report templates
Content analysis of state police templates indicated that pedal-cyclist (labelled under non-motorist Vehicle #2) and helmet (except for three states with motorcycle helmet) were standard, but other bicycle-crash-scene categories were not consistently included (table 1). Motor vehicle drawings ranged from having 8 to 16 potential impact points but did not include opened doors or side mirrors. States with a motorcycle/pedal cyclist drawings included Nevada (eight potential impact points), Arizona (six potential impact points), and North and South Carolina (four potential impact points). Only a few states included pedal-cyclist action, location, reflective clothing, lighting, direction or manoeuvre. Some states are issuing electronic citations using an online template, but some did not include a bicycle category. The standardised MMUCC included a motor vehicle drawing (12 potential impact points), a motorcycle drawing (12 potential impact points), reflective clothing and lighting. Of the templates that listed bicycle facilities, only bike lanes or shared use paths were included.
Motor vehicle/bicycle crashes in NYC selected for analysis
Three hundred vehicle/bicycle crashes in NYC that included drawings were redrawn, studied and analysed to test if having bicycle-crash-scene variables to enter into crash spreadsheets might be informative for analysing vehicle/bicycle crashes.
Motor vehicle/bicycle crashes redrawn for in/out of environment, impact points and turns
Though bicycle environments may exist, bicyclists do not have to ride in these facilities unless a side path law exists (must ride in a parallel bicycle environment). Based on the new bicycle-crash-scene codes, numbers of minor or severe crashes differ (table 2).
For the bicycle, four potential impact points were identified because of the difficulty in discerning from the crash report more than four potential impact points (figure 1). For motor vehicles, 18 possible impact points were identified (including a for mirror and b and c for opened doors). The bicycle front (side 1) and the motor vehicle front (side 2) had the greatest frequency of crash and injury severity (table 2). A test was conducted to assess the usefulness of having these new bicycle-crash-scene data entered into the existing spreadsheet. In Model 2B (that did not include possible hit-and-runs and that had bicyclists who had minor injuries as the control group), bicyclists on roads with bike lanes who were riding outside the lane had lower likelihood of severe injuries (OR, 0.40, 95% CI 0.16 to 0.99) compared with bicyclists riding on roads without bicycle facilities (table 3).
Under the merged similar turns/impact diagrams most likely in a motor vehicle/bicycle crash, the 300 crash drawings were sorted. For example, all head-on motor vehicle/bicycle crashes were together. (figure 3). The highest frequencies for motor vehicle/bicycle crashes were motor vehicles turning left and sideswipe (motor vehicle and bicycle same direction) (table 2).
VINs and motor vehicle configuration
VINs and pictures of the motor vehicles allowed for classification of eight different types of motor vehicles and sedans, which can include taxis, that were most involved with crashes and severely injured bicyclists (table 2).
Content in the different motor vehicle/bicycle crash report formats
Data about the NYC motor vehicle/bicycle crashes can be requested in spreadsheet form but for bicycle-crash-scene data, only body type (bicyclist), vehicle type (bicycle) and helmet are coded for spreadsheet entry. The typed crash report can also be obtained but this is a text version of the spreadsheet information. The original redacted crash report with text and drawings (if the crash was drawn) can be requested. With this full crash report and Google street view, the scenario, though time-consuming, can be redrawn to reveal motor vehicle-side impact, bicycle-side impact, if the bicyclist was most likely riding in the bicycle facility, or the unique motor vehicle/bicycle turning directions. These bicycle-crash-scene data then have to be entered into the existing spreadsheet to conduct an analysis more focused on the bicyclist.
Fifty-one state crash report templates and the MMUCC template were analysed and pedal-cyclist/bicyclist and helmet are the only bicycle-relevant information consistently entered as coded data into the state spreadsheet about each crash. To conduct more analysis, full crash reports with the text and drawings were obtained and redrawn using Google street view. This process was labour-intensive, the extracted variables were only available to this team, and the Google street views changed during the analysis as some of the cycle tracks were under construction.
Because improvements are being made to crash reporting, bicyclist-crash-scene variables could be coded on a police electronic tablet with a drop-down template for motor vehicle/bicycle crashes and uploaded automatically into the state spreadsheet database. Our research suggests that new bicycle-crash-scene variables might be informative for analysis including: 4 bicycle environments (roads, sharrows, bike lanes and cycle tracks); 18 motor vehicle potential impact points including opened car doors and mirrors; 4 bicycle potential impact points; whether in or out of the bicycle environment; 10 bicycle-crash-scene patterns (turn/impact); and motor vehicle types relevant to bicyclists. Having these new variables revealed higher crash frequency on motor vehicle fronts, bicycle fronts, no bike facility, sedan and as sideswipes.
Compared with bicyclists hitting the back of the motor vehicle, opened motor vehicle doors and mirrors resulted in higher risk of severe injury and, compared with riding on roads without bicycle facilities, riding on roads with bike lanes but not riding on the lane resulted in lower risk of severe injury. These analyses were possible because the new bicycle variables were entered into the existing spreadsheet that already contained the categories for minor and severe/fatal injuries. While studying circumstances surrounding crashes using bicycle counts is valuable,33–36 collecting bicycle counts can be difficult, especially if counts are needed on all streets involved. If these new bicycle-crash-scene variables were entered into the existing spreadsheets, bicycling could be analysed with minor injuries as the control and severe injuries as the case. Though not as ideal as a comparison between no injury and injury, using the data in the spreadsheet at least enables a comparison between minor injury and severe injury.
Entering new bicycle-crash-scene variables can be worthwhile because in the USA the focus has been on bike lanes37 ,38 while recent research has suggested the safety of cycle tracks.33 ,34 ,39–41 With bicycle-crash-scene spreadsheet codes, associations could be found between environments plus motor vehicle/bicycle potential impact points, motor vehicles and injuries, especially when merged with big data including emergency medical services, insurance, etc.28 ,42 These bicycle-crash-scene data are informative because, unlike a motor vehicle, a bicyclist can be negatively impacted by opened car doors43 or by the direction of travel or turning of a motor vehicle.36 ,44–46 Additionally, before a crash 11% of car drivers saw the bicyclist while 68% of the bicyclists saw the car.47 If environments and crash patterns were coded for motor vehicle/bicyclist crashes, intersections might be better understood and designed to lessen the looked-but-failed-to-see-errors.48–50 Better data leading to better analysis would also inform bicyclist and driver education efforts.44 ,51
With bicycle-crash-scene spreadsheet codes, access to and use of data would be improved. Now, a research team can request the VIN's first 11 digits but this information is then only available to that team. Current codes include the chassis size, yet many vehicle descriptors are less relevant to bicycle safety. Motor vehicles have been improved to protect the occupants23 and perhaps, with the 11 digit VIN more widely available and different motor vehicle categories, motor vehicles could also be designed to better protect bicyclists.
Adding bicycle categories has been recommended but with fewer specifics. Researchers in Minnesota only recommended the addition of on-street and off-street bicycle facilities.52 Analysis of bicycle crash types in North Carolina (2006–2010) suggested the addition of environments but only bike lanes or multiuse paths were recommended in the study for the North Carolina Department of Transportation.53 Because having no side path law means a bicyclist could ride in the road, cycle track or lane, a code could identify whether the bicyclist was in or out of that facility.
Since the invention of the bicycle in 1890, transportation research has focused on motor vehicle risk54 yet the bicyclist is far more vulnerable.55–57 Multiple data sets are available to study MVCs,58 ,59 and multiple data sets should be available to study bicycle crashes. Safety should not be the sole responsibility of the bicyclist and their choice of location for riding or clothing while riding.60 Besides a code for helmet, a bicycle light should be coded61 ,62 along with other bicycle-crash-scene codes to help design the safest environment.63 With the advantages of coded bicycle-crash-scene data identified, moderation will still be necessary. North Carolina bicycle and pedestrian crash data were analysed and 78 crash types developed.53 When at a crash scene, police might be less willing or unable to enter multiple codes, but a bicycle-crash-scene drop-down menu on an electronic table may serve as a useful tool.
Recent crash templates were not available from all states, yet some older templates included useful information, such as a motorcycle/pedal cycle with four potential impact points. Crash details were analysed from NYC, a unique urban environment. The analysis involved only 300 crashes, due to complexity in redrawing, and only crashes with drawings were analysed. Due to the need to understand the four different bicycle environments, the analysis was not a random sample of all motor vehicle/bicycle crashes, but the maximum number of crashes in the different environments to equalise sample sizes. Bicycle counts would have been ideal for the four environments, but this would have been a large undertaking in NYC. Minor and severe injuries had been identified by the police but these data allowed minor injuries to serve as the control. The sample size limited power in each variable, however, the data allowed inferences to be drawn about the value of bicycle-crash-scene variables being coded for inclusion in the spreadsheet.
The motor vehicle resembles a rectangle while a bicycle resembles a line, making motor vehicle/bicycle crashes different. Data can be found in the full police crash report, yet obtaining and extracting the information is labour-intensive, data are sometimes available only to the researchers, and Google street views change. Therefore, the Federal and State officials responsible for creating the state crash report templates could consider inclusion of bicycle-crash-scene spreadsheet coded variables that could be entered electronically on a tablet with a drop-down template for bicycle crashes only. Variables worthy of consideration include: 4 bicycle environments; 18 car potential impact points (including 4 opened door locations and side mirrors); 4 bicycle potential impact points; turning directions appropriate for motor vehicle/bicycle interactions; in or out of the bicycle environment; and motor vehicle categories relevant to bicyclists. More coded variables could be considered in future research, especially as combinations with big data.
What is already known on the subject
Many states are making changes to the crash report templates, but the emphasis still is on motor vehicles.
Detailed information is available in individual reports’ text and drawing, yet, it takes considerable time to analyse.
Google street views are useful, however, in years to come the view may change, eliminating identification of that bicycle environment.
What this study adds
Motor vehicle/bicycle crash variables that could be entered into a spreadsheet include 4 bicycle environments, 18 motor vehicle potential impact points (opening doors and mirrors), 4 bicycle potential impact points, 10 bicycle-crash-scene patterns, in/out of the bicycle environment and motor vehicle types relevant to bicyclists.
With these new data, analysis could determine that, compared with bicyclists hitting the back of motor vehicles, motor vehicle doors and mirrors posed a greater risk of severe injury.
With these new data, analyses could determine that, compared with riding on roads without bicycle facilities, riding on roads with bike lanes but not riding in the lane had lower likelihood of severe injury.
The authors thank the New York State Department of Transportation for providing the data for analysis.
ACL and MA are first coauthors.
Contributors ACL, MA and MSF had full access to the data in the study and take responsibility for the integrity of the data and the accuracy of the data analysis. Conception and design: ACL and MA. Acquisition of the data: ACL and MA. Analysis and interpretation of the data: ACL, MA and MSF. Drafting of the manuscript: ACL. Critical revision of the intellectual content: ACL, MA and MF. Statistical expertise: ACL, MA and MSF. Administrative or technical or material support: ACL. Study supervision: ACL.
Funding ACL and MA were supported by the Nissan Motor Co., Ltd.
Competing interests None.
Ethics approval The Harvard School of Public Health IRB found that this protocol meets the criteria for exemption and additional review by IRB was not required.
Provenance and peer review Not commissioned; externally peer reviewed.
Data sharing statement The original crash data are the property of the New York State Department of Transportation. The information about the police crash report templates is available to the general public on the web or through contacts to the state police departments. There is no unpublished data from the study other than the individual drawings of the 300 crashes and the resulting data entered as Excel codes. To give these data to others, we would first seek approval from NYSDOT.
If you wish to reuse any or all of this article please use the link below which will take you to the Copyright Clearance Center’s RightsLink service. You will be able to get a quick price and instant permission to reuse the content in many different ways.