# NTSB investigations: Approach NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 176 of 420 · 20,992 cases ## Cases, newest first - [NTSB SEA87LA176](https://openairdocs.org/ntsb/SEA87LA176.md): Cessna 150 · Oak Harbor, WA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1987 · N19092 · Destroyed > The plt had not slept the night of the flt. He was wearing contact lens and had closed his eyes several times during the flt to alleviate stinging. While on short final approach to land the plt closed his eyes and fell asleep. When he awoke he was left of the… - [NTSB MIA87LA232](https://openairdocs.org/ntsb/MIA87LA232.md): Cessna 152 · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Aug 25, 1987 · N4745A · Substantial damage > The student plt had completed about 3.4 hrs of a solo cross-country training flt and was about 6 miles se of the airport, when the aircraft sustained a loss of power. A forced landing was performed in a celery field. Investigation revealed no usable fuel in… - [NTSB ANC87LA129](https://openairdocs.org/ntsb/ANC87LA129.md): Piper PA-12 · Montague Island, AK · Accident · No injuries · Limited investigation · Final report · Aug 25, 1987 · N3842M · Substantial damage > The plt was making an apch for a soft/short field landing at a strip which paralleled the ocean shoreline on Montague Island. He stated that when he came in to land, he misjudged the height & position of bushes nr the apch end of the strip. Subsequently, the… - [NTSB SEA87LA174](https://openairdocs.org/ntsb/SEA87LA174.md): Lutz Flying Dutchman · Twin Falls, ID · Accident · 1 fatal · Limited investigation · Final report · Aug 23, 1987 · N38Z · Destroyed > The purpose of the flt was to check the acft after replacing a wooden prop with an all metal prop & to prepare for entry in the reno air races. Bfr entering the air races. The plt needed to demonstrate his ability to make a 'barrel roll' & to make 3 lndgs.… - [NTSB NYC87FAMS2](https://openairdocs.org/ntsb/NYC87FAMS2.md): Piper PA-28-161 · Nantucket, MA · Accident · 2 fatal · Missing aircraft · Final report · Aug 23, 1987 · N83232 · Destroyed > The Piper PA-28-161 with a pilot and passenger onboard disappeared from the radar scope while being vectored to an ILS approach to rwy 24 at Nantucket, MA. The controller observed the aircraft in a southeasterly heading and asked the tower controller to… - [NTSB LAX87LA311](https://openairdocs.org/ntsb/LAX87LA311.md): Piper PA-28-181 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N9144T · Substantial damage > The plt indicated that 10 min from his destination he became concerned that the fuel gauges read 'near zero.' The plt elected to divert to another aprt, which was closed. The plt maintained his alt in case of power loss. The plt stated, 'I also became glued… - [NTSB CHI87NA194](https://openairdocs.org/ntsb/CHI87NA194.md): Boeing 767-231ER · Belleville, IL · Incident · Minor injuries · Final report · Aug 22, 1987 · N609TW · Minor damage - [NTSB MKC87LA166](https://openairdocs.org/ntsb/MKC87LA166.md): Beech B23 · Creston, IA · Accident · No injuries · Limited investigation · Final report · Aug 21, 1987 · N6078N · Substantial damage > The PIC had planned his flt with departure originating in Iowa city, Iowa. Scattered thunderstorms were fcst and the PIC delayed his departure for abt 3 hrs. Aft assessing wx fm several sources the PIC dptd for Creston, Iowa around 9 pm LCL time. The flt… - [NTSB LAX87DUG07](https://openairdocs.org/ntsb/LAX87DUG07.md): Quickie Q-200 · Redlands, CA · Accident · 2 fatal · Final report · Aug 21, 1987 · N2GQ · Destroyed > During a demo flt the acft was observed on final approach when it collided with the terrain and was consumed by fire. There were no mechanical failures or malfunctions reported. The plt made a radio call as he turned to the base leg. There was no report of… - [NTSB ANC87LA126](https://openairdocs.org/ntsb/ANC87LA126.md): Cessna 172 · Clear, AK · Accident · No injuries · Limited investigation · Final report · Aug 20, 1987 · N5530T · Substantial damage > The pilot stated that he elected to go-around and during the go-around he lost control of the aircraft causing the plane to stall. - [NTSB SEA87LA169](https://openairdocs.org/ntsb/SEA87LA169.md): Mooney M20-K · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 1987 · N233BG · Substantial damage > The pilot was cleared to land on runway 19R but was attempting to land on runway 19L. The tower noted the mistake and asked the aircraft to side step to runway 19R. During the pilot's attempt to land on runway 19R, the tower told the pilot to go-around.… - [NTSB BFO87FA056](https://openairdocs.org/ntsb/BFO87FA056.md): Cessna 190 · Hedgesville, WV · Accident · 2 fatal · Field investigation · Final report · Aug 17, 1987 · N9827A · Destroyed > There were no eyewitnesses to the acdnt, but 3 persons heard the eng rev up to a high power setting before the plane crashed. Subsequently, it crashed in a wooded area north of the plt's 2600' pvt strip. There was a wooded hill north of the strip. The plt's… - [NTSB LAX87LA305](https://openairdocs.org/ntsb/LAX87LA305.md): Cessna 172P · Covelo, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 1987 · N98782 · Substantial damage > The plt rprtd that when she was landing, the acft ballooned, entered a porpoise & drifted to the left of the rwy. She applied power to 'fly out of the situation,' but the acft pitched up. The right seat occupant (pax) pulled the control yoke back &… - [NTSB ATL87LA232](https://openairdocs.org/ntsb/ATL87LA232.md): Piper PA-60-602P · Ravenna, OH · Accident · No injuries · Limited investigation · Final report · Aug 15, 1987 · N6898Z · Substantial damage > The plt rprtd that drg a lndg on rwy 27, the acft touched down just short of the rwy lip. He stated that the rgt main gear hit a hole in the grass about 25 ft short of the rwy, then hit the lip. Subsequently, the rgt main gear failed & the acft veered off the… - [NTSB CHI87LA213](https://openairdocs.org/ntsb/CHI87LA213.md): Mooney 20K · Crestwood, IL · Accident · No injuries · Limited investigation · Final report · Aug 14, 1987 · N10816 · Substantial damage > Upon arrival at howell airport the pilot set up a close approach for landing on runway 36 because of deteriorating weather conditions. The pilot was unable to get current wind conditions at the airport from UNICOM but decided to continue the approach. During… - [NTSB ATL87DEK03](https://openairdocs.org/ntsb/ATL87DEK03.md): Embree Sonerai II · Cambridge, OH · Accident · No injuries · Final report · Aug 14, 1987 · N348KE · Substantial damage > While in the traffic pattern, the plt retarded the throttle to idle & established a glide speed. When he re-advanced the throttle, there was no response from the eng. The plt said he 'headed straight for the overrun to runway 4, but could not make it that… - [NTSB FTW87FA196](https://openairdocs.org/ntsb/FTW87FA196.md): Cessna P210N · Pearland, TX · Accident · Minor injuries · Field investigation · Final report · Aug 11, 1987 · N731TT · Destroyed > Drg arrival, the plt made a nr half circle ovr the arpt & entered a dwnwnd for rwy 14R. Drg the entry, he reduced pwr & noted 2 or 3 sputters fm the eng. Just bfr turning to a base leg, he advanced the throttle for adnl power, but there wasno response fm the… - [NTSB ANC87LA119](https://openairdocs.org/ntsb/ANC87LA119.md): Piper PA-18 · Fairbanks, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1987 · N7561D · Substantial damage > The pilot stated that during a right turn on approach the aircraft stalled and crashed into the river. - [NTSB NYC87IA227](https://openairdocs.org/ntsb/NYC87IA227.md): Boeing 747 · New York, NY · Incident · No injuries · Incident investigation · Final report · Aug 9, 1987 · N93109 · 2 aircraft · No damage > Acft with similar call signs (twa flts 843H & 834; Boeing 747 & Boeing 727) apchd jfk intl arpt for ldg. Flt 843H was 22MIN late & flt 834 was 12 min early, causing same arr time. NY TRACON vctrd flt 834 bhnd flt 843H. While ctlg the acft, jfk final ctlr,… - [NTSB BFO87LA051](https://openairdocs.org/ntsb/BFO87LA051.md): Maule M-4-210C · Burnt Chimney, VA · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1987 · N51436 · Destroyed > The plt attempted to land on a 1400 ft grass airstrip. The plt later stated that during the lndg roll the passg alerted him to the fact that they would not stop on the rwy. This caused the plt to start a go-around followed by a 2nd attempt to stop. The plt… - [NTSB MIA87LA224](https://openairdocs.org/ntsb/MIA87LA224.md): Bell 47J-2A · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Aug 7, 1987 · N8523F · Substantial damage > During the apch to land the tail rotor drive assy failed resulting in a momentary loss of control. The plt then autorotated & landed on the company helipad, during which the helicopter sustained substantial damage. Examination of the tail rotor drive assy… - [NTSB LAX87LA297](https://openairdocs.org/ntsb/LAX87LA297.md): Piper PA28-161 · Redding, CA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1987 · N81200 · Substantial damage > During an air race, the plt was attempting a landing when on final approach the acft flew through updrafts. The plt landed the acft aprx 600 ft from the threshold and applied heavy braking. Just prior to running off the runway the pilot added full power and… - [NTSB LAX87IA303](https://openairdocs.org/ntsb/LAX87IA303.md): Boeing 747-300 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Aug 7, 1987 · J8163 · No damage > Drg arr, japan airline flt 62 (Boeing 747, JA-8163) was initially vectored (by lax ARTCC) for an ILS rwy 24R apch in reduced visibility (haze). Bfr turning final, flt 62 was adzd of an acft that was 4 mi ahead. Flt 62 rprtd that they had the acft in sight.… - [NTSB DEN87LA210](https://openairdocs.org/ntsb/DEN87LA210.md): Cessna T210N · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1987 · N4743Y · Substantial damage > The private plt was returning from a business flight. The plt reported that the engine quit during the approach to landing. An emergency landing was made in an open field. The right wing hit a sign and skidded to rest across a paved road and into another open… - [NTSB LAX87LA293](https://openairdocs.org/ntsb/LAX87LA293.md): Cessna TU206G · Chinle, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1987 · N756UN · Substantial damage > At the end of a cross country flt, the plt reported that on the first attempt to land on a dirt road the airspeed and alt were high so he elected to go-around. On the second attempt the approach was too slow and the acft stalled aprx 8 ft AGL. The acft… - [NTSB NYC87LA223](https://openairdocs.org/ntsb/NYC87LA223.md): Piper PA-28 · Prospectville, PA · Accident · No injuries · Limited investigation · Final report · Aug 4, 1987 · N33791 · Substantial damage > The student plt was practicing takeoffs & landings. He rprtd that on the 2nd apch, he appeared to be landing too long, so he initiated a go-around. However, he said the acft then entered a departure stall & settled into shrubs & trees adjacent to the rwy. - [NTSB LAX87LA292](https://openairdocs.org/ntsb/LAX87LA292.md): Piper PA-34-200T · El Monte, CA · Accident · No injuries · Limited investigation · Final report · Aug 4, 1987 · N477BL · Substantial damage > An instructor (CFI) was giving an airline transport plt (ATP) a check-out in the PA-34. The ATP checked the fuel quantity & questioned the CFI about the lvl in the left tank. The CFI acknowledged that the fuel tank was not full. The ATP stated the fuel gauges… - [NTSB BFO87FA050](https://openairdocs.org/ntsb/BFO87FA050.md): Cessna 172P · Whitemarsh, MD · Accident · Minor injuries · Field investigation · Final report · Aug 2, 1987 · N54905 · Substantial damage > The pilot stated that he touched down near the end of the 22OO foot runway. However, witnesses said he landed so FAR down the runway that they did not believe he could stop on the runway. The pilot delayed his go around attempt to the point where it was not… - [NTSB MIA87FA217](https://openairdocs.org/ntsb/MIA87FA217.md): Cessna 185F · Hollywood, FL · Accident · Serious injuries · Field investigation · Final report · Jul 29, 1987 · N9003H · Substantial damage > The plt stated that he performed a thorough preflight of the acft to include the draining of the sumps & fuel strainer and no water was found. After takeoff while on the downwind leg, the eng quit. The plt attempted to return to the airport; however, the acft… - [NTSB DEN87LA201](https://openairdocs.org/ntsb/DEN87LA201.md): Cessna 152 · Lafayette, CO · Accident · No injuries · Limited investigation · Final report · Jul 29, 1987 · N714YF · Substantial damage > CFI was demonstrating eng out emerg landing and allowed acft to descend into tall weeds before adding power which was insufficient to overcome drag of weeds on gear. Acft struck bank and fence separating prop and right main gear. Hull and cowling were buckled… - [NTSB LAX87LA285](https://openairdocs.org/ntsb/LAX87LA285.md): Cessna 172P · Kernville, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1987 · N52331 · Substantial damage > During a solo instructional flight, the student plt was attempting a landing with a 6-10 knot crosswind. While on final approach with full flaps and pwr off, the plt stated that over the threshold at aprx 10 ft AGL in the flare configuration, a gust of wind… - [NTSB NYC87LA211](https://openairdocs.org/ntsb/NYC87LA211.md): Cessna 310 · Wrightstown, NJ · Accident · No injuries · Limited investigation · Final report · Jul 26, 1987 · N5077Y · Substantial damage > The instructor (CFI) & multi-eng commercial plt (student) were on a flt for a check-out in the Cessna 310. Drg a single eng go-around, the student increased the pitch attitude excessively & the airspeed decayed. The CFI took control of the acft & increased… - [NTSB NYC87LA206](https://openairdocs.org/ntsb/NYC87LA206.md): Cessna 210 · Palmyra, PA · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1987 · N2317F · Substantial damage > The Cessna 210 was cruising enroute when it experienced a loss of power which the pilot attributed to low fuel/ exhaustion. He then attempted an approach at reigle fld but was too long and went around. On his second approach, he was again high and long, and… - [NTSB ANC87LA108](https://openairdocs.org/ntsb/ANC87LA108.md): Piper PA-18-150 · Dillingham, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1987 · N4454Z · Substantial damage > During an approach for landing the float equipped airplane stalled at a higher than normal indicated airspeed. The pilot was unable to effect recovery and the airplane crashed in wet tundra. The wind at shannon pond at the time of the accident was described… - [NTSB LAX87FA281](https://openairdocs.org/ntsb/LAX87FA281.md): Piper PA-32R-301T · Monterey, CA · Accident · 4 fatal · Field investigation · Final report · Jul 24, 1987 · N82793 · Destroyed > Loss of control of the aircraft, by the pilot, while excuting a missed approach. - [NTSB FTW87LA188](https://openairdocs.org/ntsb/FTW87LA188.md): Beech 35 · Richwood, TX · Accident · No injuries · Limited investigation · Final report · Jul 24, 1987 · N470MC · Substantial damage > The acft impacted a tree after a forced landing to a field near Richwood, Texas. The pilot stated that he was on final approach to the airport when the engine quit due to fuel starvation. The fuel selector was on the right tank at the time of the accident.… - [NTSB CHI87DER11](https://openairdocs.org/ntsb/CHI87DER11.md): Hendrickson Polliwagon · Ely, MN · Accident · 1 fatal · Final report · Jul 24, 1987 · N48876 · Destroyed > While on downwind to the airport the aircraft departed level flight and impacted in a wooded area in an approximate 80 degree nose down attitude. The aircraft was destroyed and the plt who was the sole occupant, received fatal injuries. This was an… - [NTSB SEA87LA144](https://openairdocs.org/ntsb/SEA87LA144.md): Piper PA-11 · The Dalles, OR · Accident · No injuries · Limited investigation · Final report · Jul 22, 1987 · N5030H · Substantial damage > The pilot was at 50 feet AGL on final approach to land at his private airstrip when he lost control. Reportedly, a gust of wind turned the aircraft 180 degrees. The aircraft descended and struck trees and the ground. Winds were reported variable at 40 to 45… - [NTSB CHI87DEP10](https://openairdocs.org/ntsb/CHI87DEP10.md): Robinson Avid Flyer · Tomah, WI · Accident · Serious injuries · Final report · Jul 21, 1987 · N228MC · Destroyed > The homebuilt, hiwing acft had just been assembled by the owner/plt & was readied for its 1st flt. After takeoff from rwy 25, the acft entered a climb, turned back over the arpt & crossed over the rwy. Subsequently, it was maneuveredabout 500 to 800 ft south… - [NTSB LAX87DVD03](https://openairdocs.org/ntsb/LAX87DVD03.md): Temco TT-1 · Hayward, CA · Accident · Serious injuries · Final report · Jul 20, 1987 · N8K · Destroyed > While on final approach after an extended descent at idle, the engine flamed out as the pilot advanced the throttle to reduce the rate of descent. During a forced landing short of the airport, the aircraft struck a light pole and telephone wires. After coming… - [NTSB ANC87LA103](https://openairdocs.org/ntsb/ANC87LA103.md): Piper PA-18 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Jul 20, 1987 · N9131D · Substantial damage > After several passes ovr the airstrip the plt set up to lnd on the 600 ft long dirt rwy located on a mtn ridge. He stated that on final he lost sight of the strip and elected not to land. The acft was unable to outclimb the rising terrain. - [NTSB SEA87FA141](https://openairdocs.org/ntsb/SEA87FA141.md): Beech B200 · Crystal Bay, NV · Accident · 4 fatal · Field investigation · Final report · Jul 18, 1987 · N1870S · Destroyed > While on an instrument flight plan in IMC, the flight was cleared for an instrument approach to the south lake tahoe airport, the intended destination. The aircraft departed the initial approach fix on the published transition to the final approach course.… - [NTSB ATL87LA217](https://openairdocs.org/ntsb/ATL87LA217.md): Cessna 182A · Warm Springs, GA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1987 · N169DP · Substantial damage > PIC dpted, intending to fly 0.5 hours on tach. Acft had 11 gals of fuel, 5 in left tank & 6 in right tank. PIC made left climbing spiral to 9000 feet and maneuvered in left turn around airport. On a long staight in, final appch eng quit at about 500 feet AGL.… - [NTSB NYC87DNC08](https://openairdocs.org/ntsb/NYC87DNC08.md): Cessna R172K · Cantebury, NH · Accident · 1 fatal · Final report · Jul 17, 1987 · N4673K · Destroyed > A local CFI heard the plt transmit over the UNICOM freq that he was 'north of the airport at 1100 ft & out of gas, so I guess I'm going to crash.' Attempts to contact the plt were unsuccessful. The CFI flew north of the airport & located the plane where it… - [NTSB LAX87LA269](https://openairdocs.org/ntsb/LAX87LA269.md): Piper J-3 · Buckeye, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1987 · N42507 · Substantial damage > The acdnt occurred as the plt was maneuvering to land on a pvt airstrip located on a ranch. He rprtd that while in a right turn toward the rwy, the acft stalled & fell to the ground. No preimpact mechanical failure or malfunction was evident. - [NTSB ATL87LA219](https://openairdocs.org/ntsb/ATL87LA219.md): Mitsubishi MU-2B-36A · Winchester, TN · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N702H · Substantial damage > The pilot stated he circled over the airport to check for traffic then made a turn to base. He was too near the runway and too high for a normal approach. The pilot used full flaps and decreased power; however, the aircraft began to descend rapidly. The… - [NTSB FTW87FA170](https://openairdocs.org/ntsb/FTW87FA170.md): Bellanca 17-30A · Mc Kinney, TX · Accident · Serious injuries · Field investigation · Final report · Jul 15, 1987 · N28157 · Substantial damage > On the third touch and go landing, while on the downwind leg of the approach, the pilot switched fuel tanks and shortly thereafter the engine failed. The pilot attempted 3 to 4 times to restart the engine by switching fuel tanks and activating the boost pump.… - [NTSB NYC87FA204](https://openairdocs.org/ntsb/NYC87FA204.md): Piper PA-30 · Lincolnville, ME · Accident · 4 fatal · Field investigation · Final report · Jul 14, 1987 · N7617Y · Destroyed > The plt was making an approach to knox county arpt, rockland me and after receiving a wx report from UNICOM that the local wx was below approach minimums he indicated that he would make a missed approach. There was no further communications from the acft. A… - [NTSB ATL87LA211](https://openairdocs.org/ntsb/ATL87LA211.md): Cessna 172M · Raleigh, NC · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 1987 · N80929 · Destroyed > The pilot was vectored for landing on runway 23R behind a Boeing 727. The approach controller advised the pilot that he could land on 23L if he preferred but the pilot elected to continue with the approach to 23R. The tower controller cleared the flight to… - [NTSB NYC87IA202](https://openairdocs.org/ntsb/NYC87IA202.md): Boeing 767-232 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Jul 13, 1987 · N106DA · No damage > Delta flt 752, a Boeing 767, was nr the outer marker (om) on an ILS rwy 22L apch when the flt control sys sensed an uncommanded go-arnd. The acft drifted rgt of the localizer for ovr 1 min. At abt 1000' AGL, rwy 22R was sighted to the left & a normal landing… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=177 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=176 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.