|
The simple
answer that using those methods can help you generate strong original stories
which often would not, or could not, be researched in any other way, or
within a particular time.
Some basic CAR-researched articles have been included here as
examples of how different computer-assisted reporting methods can help
you. They were selected because they demonstrate the results that can be
obtained by using a variety of techniques ranging from relatively simple
online research through to complex "number crunching". They also
reflect the fact that although journalists in many nations do not have the
same media freedoms as their United States' counterparts, it is
still possible, practical and sometimes just plain good fun producing
worthwhile stories by working with whatever information is actually
available.
The tricks are to learn to understand what to look for, where
to find good information, and how to weave it into a story.
Story 1: After attending the scene of a
fatal ultralight aircraft crash and reporting on the accident, the writer
became curious about the safety record of ultralights. A search of
official web sites relating to air safety in Australia revealed there
were no published statistics that could be used to directly compare
accident rates of ultralights with accident rates of "normal" light
aircraft. In response to inquiries with the Bureau of Transport Economics
I was sent hard copies of raw statistics listing the dates of fatal
ultralight accidents. The information did not mean much by itself, so from
there it was a matter of going to the web and gathering freely
available data which could be used to develop a meaningful statistical
comparison. The biggest problem was that the statistics were scattered.
The task was to find them, bring them together and then do the mathematics.
That was some years ago now but it has been relatively simple keeping the story up-to-date by conducting annual searches of media archives to gather statistics about the number of accidents in the preceding year - something that has revealed an escalating toll in lives and injuries.
Ultralight death toll spinning out of control
By STEPHEN LAMBLE
AUSTRALIAN
ultralight aircraft
pilots are killing themselves and their passengers at an
alarming rate.
Research indicates that Australian ultralight fliers are about six
times more likely to die for every hour flown than if they flew in general
aviation aircraft.
At least 65 ultralight pilots and passengers died as a result of air crashes between March 2001 and May 2009. Many others were seriously injured.
Some were left severely mentally and physically disabled.
There is no single
Australian Government register containing data about the death toll per flying
hour in ultralights.
But an in-depth
analysis of official crash statistics and news reports gathered from different
sources shows that in the years from 1992 to 2007 an average
of 7.25 ultralight pilots or passengers were killed for every
100,000 hours flown.
That figure is in
stark contrast with the general aviation
death rate in 2007 of 0.73 deaths per 100,000
flying hours.
Further, while Australian Transport Safety Bureau statistics
indicate that agricultural flying is the most dangerous form of general
aviation flying in Australia, it is still nearly three times less likely
to result in a death per number of hours flown than ultralight flying.
The comparison is
even worse for ultralights when it is considered that the fragile aircraft are only
permitted to fly in good weather, during daylight hours and for
recreational purposes. In addition, the total
number of ultralights in use in Australia is roughly one-third the number
of general aviation aircraft, they are typically airborne for shorter
periods, fly over much shorter distances, and carry fewer passengers.
Australian Transport
Safety Bureau records show that a total of 78 people died in ultralight
accidents between 1985 and 1999 - an average death toll of nearly six a
year.
At least 72 more died in
ultralight crashes between January 2000 and April 2009 - a total of 150 deaths from 1985 to April 2009 - with the average number of deaths per year increasing to more than eight a year in the six years and nine months to
September 2006, increasing to 10 in the year to September 2007, and 11 between September 2007 and September 2008.
As well as those killed, many others have been maimed. For example, 70 were seriously injured in 324
ultralight crashes reported to the Australian Transport Safety Bureau by
the Australian Ultralight Federation from 1985 to 2001. In
addition to those killed in 2003, at least five sustained major injuries. In 2006-2007 injuries included burns, lacerations when an pilot was sliced by a propeller, and multiple bone fractures.
Other injuries over the years have ranged from
shattered bones to catastrophic burns, amputated limbs, spinal fractures, and brain damage.
Beside
the personal and family tragedies associated with each death and life-changing injury, the
Australian Bureau of Transport and Regional Economics estimated in a report it released
in 2006 that every aircraft fatality in Australia in 2003/04 cost the community
$A2.17 million.
The report said the bureau arrived at the figure: "based on the human capital methodology, which puts
the major value of a life as the productive output of an individual over their working life. To this has been added an estimate of the value of work in the
household and volunteer work, and a value for quality of life."
Extrapolating from those outdated estimates, deaths in ultralight accidents from 1985 until April
2009 cost the Australian community a minimum of $A325.5 million - a tiny figure compared with the cost in personal and family tragedies.
TOP
Story 2: The following article about
crime rates resulted from a "number crunching" exercise by journalism
students at the University of the Sunshine Coast. The object was to find credible
publicly available Australian data online which could be entered
into a Microsoft Excel spreadsheet and then processed to see what
newsworthy information could be extracted from it.
The statistics
which were found and downloaded – "recorded offences per 100,000
population, by offence type 1993/94 to 2003/04 " – while quite detailed,
were in raw form. As a starting point, and working within Excel, it was
relatively simple to produce figures showing if reports of particular
crimes had increased or decreased. The results were then sorted to find
which offences were most common at the start of the decade and which were most common at the end.
The picture
that emerged from an analysis of the statistics could be used as a stand-alone news story, as it is here, or "fleshed out" by seeking comment from
authorities, victim groups and criminologists.
Violence, sex and drug
crimes at 10-year high
The number of serious assaults reported to police in the Australian state of Queensland doubled in the decade to 2004.
So, too, did reports of breaches of domestic violence orders.
In the same 10-year period, reports of rapes
and attempted rapes increased by 56 per cent, while there was a 33 per cent increase in reports of all sexual offences.
A 10-year snapshot
of crime trends emerged from a study of
official crime statistics published by Queensland Treasury’s
Office of Economic and Statistical Research.
The results were
drawn from recorded reports to Queensland police of offences from 1994 to
2004 and from information supplied by the Australian Bureau of Statistics.
The raw data was adjusted to take account of population increases. It
compared offence types per 100,000 people over the decade.
The figures were
analysed by University of the Sunshine Coast journalism students using advanced
computer-assisted reporting techniques.
The study also revealed
that reports of theft and unlawful entry doubled over the
10 years, as did reports of handling stolen goods.
Reported weapons offences also doubled. The incidence of reported prostitution related
offences increased 64 per cent, fraud was up 40 per cent, livestock related crime 87 per cent, and drug offences 30 per cent - from 810 reports per 100,000
people in 1994 to 1147 offences per 100,000 in 2004.
Reported traffic offences were up 26 per cent across the decade, and 25 per cent in the five years to 2004. On the other hand
reports of unlawful use of motor vehicles fell 38 per cent, something which probably reflects improvements in vehicle security over the decade.
Reports of extortion were down 45 per cent; gaming offences 44 per cent; kidnapping abduction and depravation of liberty dropped 30 per cent; homicides were down 17 per cent; and robbery 13 per cent.
The most commonly
reported crimes overall in 2004 were properly offences - with a rate of 6826 per 100,000 people. The least common was
extortion, with a rate of 2 per 100,000.
Discrepancies in the
ways different Australian states collect and collate their crime
statistics, difficulties accessing those figures and differences in the
way particular crimes are defined from state to state made it impossible
to directly compare Queensland’s 10-year crime statistics with those from
other states.
TOP
Story 3: It is highly unlikely that an eventual
sequel to this story could have been written without CAR. The example
shows how using CAR part-time during quiet "down-time" periods over
several months helped solve a mystery for a reader which not even police had been able to solve.


|