Table description for EVENTS in subject area ACCIDENT
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| EV_ID | varchar | 14 | 0 | NO | |
| EV_TYPE | varchar | 3 | 0 | YES | |
| EV_DATE | date | 4 | 0 | YES | |
| EV_DOW | varchar | 2 | 0 | YES | |
| EV_TIME | numeric | 5 | 0 | YES | |
| EV_TMZN | varchar | 3 | 0 | YES | |
| EV_CITY | varchar | 15 | 0 | YES | |
| EV_STATE | varchar | 2 | 0 | YES | |
| EV_COUNTRY | varchar | 4 | 0 | YES | |
| EV_SITE_ZIPCODE | varchar | 10 | 0 | YES | |
| EV_YEAR | numeric | 5 | 0 | YES | |
| EV_MONTH | numeric | 65535 | 65531 | YES | |
| MID_AIR | varchar | 1 | 0 | YES | |
| ON_GROUND_COLLISION | varchar | 1 | 0 | YES | |
| LATITUDE | varchar | 7 | 0 | YES | |
| LONGITUDE | varchar | 8 | 0 | YES | |
| BIOHAZARD_AREA | varchar | 1 | 0 | YES | |
| APT_NAME | varchar | 30 | 0 | YES | |
| AIRPORT_TYPE | varchar | 4 | 0 | YES | |
| AIRPORT_INVOLVEMENT | varchar | 4 | 0 | YES | |
| EV_NR_APT_ID | varchar | 4 | 0 | YES | |
| EV_NR_APT_LOC | varchar | 4 | 0 | YES | |
| APT_DIST | numeric | 65535 | 65531 | YES | |
| APT_DIR | numeric | 5 | 0 | YES | |
| APT_ELEV | numeric | 5 | 0 | YES | |
| RWY_BRAKE_COND | varchar | 4 | 0 | YES | |
| WX_BRIEF_COMP | varchar | 4 | 0 | YES | |
| WX_SRC_IIC | varchar | 4 | 0 | YES | |
| WX_OBS_TIME | numeric | 65535 | 65531 | YES | |
| WX_OBS_DIR | numeric | 65535 | 65531 | YES | |
| WX_OBS_FAC_ID | varchar | 4 | 0 | YES | |
| WX_OBS_ELEV | numeric | 10 | 0 | YES | |
| WX_OBS_DIST | numeric | 5 | 0 | YES | |
| WX_OBS_TMZN | varchar | 3 | 0 | YES | |
| LIGHT_COND | varchar | 4 | 0 | YES | |
| SKY_COND_NONCEIL | varchar | 4 | 0 | YES | |
| SKY_NONCEIL_HT | numeric | 10 | 0 | YES | |
| SKY_CEIL_HT | numeric | 10 | 0 | YES | |
| SKY_COND_CEIL | varchar | 4 | 0 | YES | |
| VIS_RVR | numeric | 65535 | 65531 | YES | |
| VIS_RVV | numeric | 5 | 0 | YES | |
| VIS_SM | numeric | 65535 | 65531 | YES | |
| WX_TEMP | numeric | 5 | 0 | YES | |
| WX_DEW_PT | numeric | 5 | 0 | YES | |
| WIND_DIR_DEG | numeric | 5 | 0 | YES | |
| WIND_DIR_IND | varchar | 1 | 0 | YES | |
| WIND_VEL_KTS | numeric | 65535 | 65531 | YES | |
| WIND_VEL_IND | varchar | 4 | 0 | YES | |
| GUST_IND | varchar | 1 | 0 | YES | |
| GUST_KTS | numeric | 5 | 0 | YES | |
| ALTIMETER | numeric | 65535 | 65531 | YES | |
| WX_DENS_ALT | numeric | 10 | 0 | YES | |
| WX_INT_PRECIP | varchar | 3 | 0 | YES | |
| EV_HIGHEST_INJURY | varchar | 4 | 0 | YES | |
| INJ_F_GRND | numeric | 5 | 0 | YES | |
| INJ_M_GRND | numeric | 5 | 0 | YES | |
| INJ_N_GRND | numeric | 5 | 0 | YES | |
| INJ_S_GRND | numeric | 5 | 0 | YES | |
| INJ_TOT_F | numeric | 5 | 0 | YES | |
| INJ_TOT_M | numeric | 5 | 0 | YES | |
| INJ_TOT_N | numeric | 5 | 0 | YES | |
| INJ_TOT_S | numeric | 5 | 0 | YES | |
| INJ_TOT_T | numeric | 5 | 0 | YES | |
| INVEST_AGY | varchar | 1 | 0 | YES | |
| FAA_REGION | varchar | 2 | 0 | YES | |
| FSDO | varchar | 4 | 0 | YES | |
| IICF_FNAME | varchar | 20 | 0 | YES | |
| IICF_INIT | varchar | 1 | 0 | YES | |
| IICF_LNAME | varchar | 25 | 0 | YES | |
| NOTF | varchar | 4 | 0 | YES | |
| NTSB_DOCKET | numeric | 5 | 0 | YES | |
| NTSB_NOTF_FROM | varchar | 30 | 0 | YES | |
| NTSB_NOTF_DATE | date | 4 | 0 | YES | |
| NTSB_NOTF_TM | numeric | 5 | 0 | YES | |
| IICN_FNAME | varchar | 20 | 0 | YES | |
| IICN_INIT | varchar | 1 | 0 | YES | |
| IICN_LNAME | varchar | 25 | 0 | YES | |
| REPORT_STATUS | varchar | 1 | 0 | YES | |
| FICHE_NUMBER | varchar | 5 | 0 | YES | |
| APPROVAL_DATE | date | 4 | 0 | YES | |
| STATUS_FLAG | varchar | 1 | 0 | YES | |
| DELETE_FLAG | varchar | 1 | 0 | YES | |
| LATEST_SRC | varchar | 4 | 0 | YES | |
| LCHG_DATE | date | 4 | 0 | YES | |
| LCHG_USERID | varchar | 18 | 0 | YES | |
| WX_COND_BASIC | varchar | 3 | 0 | YES | |
| FAA_DIST_OFFICE | varchar | 50 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| PROP_DMG | varchar | 4 | 0 | YES | |
| VIS_RESTRCT | varchar | 4 | 0 | YES | |
| WX_BRIEF_MTHD | varchar | 4 | 0 | YES | |
| WX_BRIEF_SRC | varchar | 4 | 0 | YES | |
| WX_COND | varchar | 4 | 0 | YES | |
| WX_BRIEF | varchar | 4 | 0 | YES | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES | |
| CICTT | varchar | 4 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |