Home Aviation Reports and Queries   AirLine Reports and Queries   Fee Based Services   Database Description
  Airman Query   Aircraft Query   SDR Queries   Accident Queries   Aircraft Operator Query            Comprehensive E-Mailed Aircraft Report

Home
NTSB Accident Query

The NTSB aviation accident database contains information from 1962 and later about civil aviation accidents and selected X29 incidents within the United States, its territories and possessions, and in international waters. Related accident information can be found at the FAA Accident query.

Many more data items are available for NTSB Accidents than are displayed on this query. See our custom solutions for more details to access the full set of information.

If this is your first time or you are not sure how to generate this NTSB Accident report, help is available. In addition, help is provided for a data item when it is displayed as a link.

Should you require custom reports or queries using this data on a one time or periodic basis or would like to integrate this database into your application, please contact us.


Data Item Display Criteria Value(s)
Event Date - Latest is 2008-06-30 checked
Event Id
Damage
Phase of Flight
Accident Occurrences
Total Killed
Total Seriously Injured
Total Minor Injured
Event Site City
Event Site State Code
Event Site Zip Code
Event Site Country
Flight Number
Owner Name
Owner Street
Owner City
Owner State Code
Owner Zip Code
Owner Country
Operator Name
Operator DBA Name
Operator Street
Operator City
Operator State Code
Operator Zip Code
Operator Country
Operator Code
Airframe Hours
Airframe Hours Since Last Inspection
Date of Last Inspection
Registration Number (use leading "N")
Aircraft Make
Aircraft Model
Aircraft Serial Number
Narratives    

Output Type: HTML Spreadsheet Text
Maximum rows to return:
   
E-Mail address is required if not previously registered

General Help

The fields can be used to choose the data items to be returned, restrict the number of results to be returned, choose the output format, select the number of results to return, and to reset the fields to their default values. For best results, start with the fewest values and broadest criteria ( for instance "contains" instead of "equals"). If there are too many results, use more values and narrower criteria. Depending on the criteria used, it could take as much as 2 minutes to return the results of the query.

Display
Click on the boxes to select or unselect items to be shown on the report.

Criteria
One and only one may be chosen per data item and take effect if any entries are made into the "value(s)" column. Comparisons are not case sensitive and the data item need not be selected for display to be used as criteria. The selections are:
Equal (default)
Exactly matches the specified value. Multiple values, separated by a comma, may be entered.
Not Equal
Does not match the specified value. One and only value may be entered.
Equal or Less
Matches the specified value and any values less than that entered. One and only value may be entered.
Equal or More
Matches the specified value and any values more than that entered. One and only value may be entered.
Between
Equal to or greater than and equal to or less than the specified values (two are required).
Starts With
Matches all items that start with this value. One and only value may be entered.
Contains
Matches all items that contain this value. One and only value may be entered.

Value(s)
Dates can be entered in many formats including "YYYY-MM-DD" or "MM/DD/YYYY".
Are not case sensitive.
Can be drop down list boxes or entered values.
Multiple values can be selected in drop down list boxes using the "control" or "shift" keys.
Values in drop down list boxes can be de-selected by click on the value while pressing the "control" key.
If more than one value is entered, separated them with a comma (stuff,more stuff).

Output format
The output can be formatted as HTML (default), text, or spreadsheet.
If the spreadsheet option is selected and MS Excel is identified to your browser, Excel will automatically open with the results of the query. If your browser does not know about Excel, a prompt to save the data will be displayed.

Maximum rows to return
Accepts any numeric value up to 100 and defaults to 10.

Data Item Help


Event Date
The date the event occurred.
Always displayed and cannot be deselected.
Output is sorted by this field.

Event Identification
A character field, assigned by the NTSB uniquely identifying the event.

Total Killed
Total fatalities as a result of this event for this aircraft.
Includes ground fatalities.

Total Seriously Injured
Total serious injuries as a result of this event for this aircraft.
Includes ground serious injuries.

Total Minor Injured
Total minor injuries as a result of this event for this aircraft.
Includes ground minor injuries.

Flight Number
Present only for scheduled airlines.
The identification of the flight.
Not consistently present or coded.

Operator DBA Name
The "Doing Business As" name of the aircraft operator when not the same as the corporate name.

Operator Code
An abbreviation of the aircraft operator.
Not consistently present or coded.

Aircraft Serial Number
Manufactor's assigned serial number for this aircraft.

Narratives
Free form text.
Can only be displayed, not searched on.
Legal Copyright 2001 - 2008 AviationDB.com Corp. All Rights Reserved Contact Us