E N D
Management Advisory Counsel Using Data To Understand Existing Risk and Emerging Risk. With CAST addressing commercial aviation and the Joint Steering Committee (JSC) addressing GA and On-demand Part 135 operations, the aviation community has assessed the so-called “forensic” data to understand existing sources of risk and to develop interventions to alleviate those risks. The JSC has developed initiatives to address weather, CFIT, aeronautical decision making, runway safety and automation management. The JSC now is shifting its focus a bit to address specific sectors in the aviation community in addition to its past emphasis on personal flying. As noted above, FAA too has developed some recent initiatives based on what the data identify as the most appropriate targets, as in the Capstone Program and other elements in the Flight Plan. The challenge facing FAA and the aviation community today in GA is to make better use of data and its analysis to prepare for major changes that are underway in the industry. For several decades, the technological base in GA was essentially stagnant. That is no longer the case. Change in the technological base suddenly is rapid and broadly based. The pace of change in technology and even in industry structure likely will accelerate.
What is a Data Mart? • A database, or collection of integrated databases, designed to help managers make strategic decisions about their business • Data marts are usually smaller subsets of data and they focus on a particular subject or department
Goal for FPM Data Mart To develop an on-line tool that will allow FPMs to view NTSB events by the • Pilot-in-Command’s home-base FSDO or • By theevent location FSDO
FPM Data Mart: Potential Benefits FPMs will have the ability to: • Use data to drive the development of local and regional safety programs • Compare event activity among other FSDOs within and across FAA Regions • Identify top causes and factors that contribute to an event by (final reports only): • PIC home-base FSDO • Event location FSDO
What is the NASDAC? • National Aviation Safety Data Anaylsis Center • AFS-900 • NASDAC mission: “To enhance system safety decision making by providing high quality safety information, analytical capabilities, services, and technology to the aerospace community.”
Why the NASDAC? • Quality of Data--NASDAC works on Constraints that limit the value of safety information: • Fragmentation of Safety Information • Difficult Access Problems • Lack of Data Standards • Data Quality Deficiencies
Accessing NASDAC • The NASDAC Facility • Walk-in facility at FAA Headquarters, Washington, DC - Room 1006 • Analysts available for assistance and specialized analyses • Assistance available by phone at 202.493.4247 or email at nasdac@faa.gov • Hours of Operation: Monday – Friday, 7:30 AM to 5:30 PM ET • NASDAC Website • https://extranet.nasdac.faa.gov
The workgroup • Felice Brunner • Rich Mileham • Richard Stednitz • Jim Hein • Dennis Pratte • Jim King • Guy Minor
FPM Data Mart: Status • Collecting end-user requirements for data mart prototype • User group assembled for beta testing - Dec 2005. • Access granted for user group testing - Jan 2006. • Feed end user requirements to NASDAC developers – Feb 2006.
FPM Data Mart: Status • Phased approach to development • Identified three classes of end-users • Class one – “give me everything” approach (pros = get everything, user specified query, manip data using MS Excel) • Class two – give me online analytical functions (not a lot of supporting data) aggregate data • Class three – Executive reporting (no clicks, download -
Very Static, National Program Specified Query, Aggregate Rich, charts Graphs, canned reports, Information, Predefined (counts) Manipulate data at aggregate Very Dynamic, user defined queries, data rich (details)