# 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 200 of 420 · 20,992 cases ## Cases, newest first - [NTSB CHI84LA312](https://openairdocs.org/ntsb/CHI84LA312.md): Burns Soneria II · Woodsfield, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1984 · N423ST · Substantial damage > The a/c departed clinton, MD, for a VFR flt to Woodsfield, OH, with a planned refueling stop at manassas, VA. En route the plt observed an abnormal fuel comsumption rate but still attempted to reach the destination arpt. About 3NM out the eng quit due to fuel… - [NTSB MKC84LA230](https://openairdocs.org/ntsb/MKC84LA230.md): Mooney M20C · Hannibal, MO · Accident · No injuries · Limited investigation · Final report · Jul 25, 1984 · N7702M · 2 aircraft · Substantial damage > N7702M experienced an electrical failure en route & diverted to Hannibal. Plt stated he circled the arpt, saw no traffic& decided to land to the south. N38455 had just landed to the north and was on the rwy when the plt saw N7702M attempting to land in the… - [NTSB CHI84FU008](https://openairdocs.org/ntsb/CHI84FU008.md): Mattison MAC Ultralight · Three Lakes, WI · Accident · 1 fatal · Final report · Jul 24, 1984 · UNREG · Destroyed > The recently purchased ultralight was taxied for about 40 minutes prior to the new owner trying his first flt. He had been advised by the former owner to make short hops at low altitude during a familiarization period. The former owner wanted to be present… - [NTSB NYC84LA251](https://openairdocs.org/ntsb/NYC84LA251.md): Cessna C172 · Bloomsburg, PA · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1984 · N2627L · Substantial damage > The acft was ditched in a river during an attempted go-around. The plt said he approached the arpt with full flaps at about 70 mph. During the aborted landing he applied full power and then experienced a sudden low left wing, a mushy control feeling and a… - [NTSB SEA84LA180](https://openairdocs.org/ntsb/SEA84LA180.md): Cessna 150K Aerobat · Blaine, WA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N8315M · Substantial damage > The student pilot had just returned to his home airport after a x-country flight. He had not refueled at the last airport and was aware that both fuel gages were below one quarter tank. He said that his first approach was two high. The second approach was… - [NTSB MIA84LA207](https://openairdocs.org/ntsb/MIA84LA207.md): Mosley High School Acro - Sport #1 · Panama City, FL · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N3783G · Substantial damage > The plt inadvertantly shut off the mixture when he retarded the throttle for landing. When the throttle was later advanced the engine did not respond. The plt took no corrective action to restart the engine and made a forced landing short of the arpt. The plt… - [NTSB SEA84LA181](https://openairdocs.org/ntsb/SEA84LA181.md): Piper PA-28-151 · Creswell, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 1984 · N8732E · Substantial damage > The acft was on a night VFR flt from san carlos, CA, to eugene, OR, when the plt asked apch control how for away the arpt was. ATC informed the plt that the arpt was 16 miles further. About 3 minutes later, the left fuel tank was emptied. The plt switched to… - [NTSB NYC84LA253](https://openairdocs.org/ntsb/NYC84LA253.md): Piper PA-18 · Seboomook Lake, ME · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1984 · N9276D · Substantial damage > The acft was on final for a water landing when a bird hit the windscreen according to the plts statement. A witness who observed a dark object (thought to be a cormorant, since several were seen in the area before & after the accident) saidthe object floated… - [NTSB LAX84FA415](https://openairdocs.org/ntsb/LAX84FA415.md): de Havilland DHC-6-300 · Tau, Antarctica · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1984 · N43SP · Substantial damage > The acft crash landed after the plt used flaps and power to semi-control pitch after the elevator down control cable failed at about 300 ft AGL on final approach. The left wing of the acft hit the terminal roof during the stall mush FROM50 ft AGL. The company… - [NTSB MIA84FA204](https://openairdocs.org/ntsb/MIA84FA204.md): Piper PA-28-235 · St.Simons Is., GA · Accident · Serious injuries · Field investigation · Final report · Jul 20, 1984 · N8553N · Substantial damage > The acft crashed during a forced landing after a power loss on final apch. The plt reported to fss on a 3 mile final and then reported the power loss and said he would make a 'dead stick' landing. Shortly thereafter, fss received an ELT signal. The acft was… - [NTSB ATL84LA228](https://openairdocs.org/ntsb/ATL84LA228.md): Cessna 175 · Enterprise, AL · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N7278M · Substantial damage > A witness observed the airplane slipping on final apch. The aircraft lost too much altitude and hit the terrain short of the runway. The airplane damage indicated that the pilot failed to correct the slip condition in time to arrest the descent. - [NTSB MKC84FA221](https://openairdocs.org/ntsb/MKC84FA221.md): Morgan T. Melton SKY Rider · West Plains, MO · Accident · 1 fatal · Field investigation · Final report · Jul 19, 1984 · N39963 · Destroyed > The owner/bulder stated that he & his brother had been having an eng problem which they assumed was due to a vapor lock. They had installed a metal box around the electric fuel pump to insulate it from the heat of the exhaust pipe. The brother initiated a hi… - [NTSB MKC84IA220](https://openairdocs.org/ntsb/MKC84IA220.md): Beech C-45H · Columbia, MO · Incident · No injuries · Incident investigation · Final report · Jul 18, 1984 · N492DM · Minor damage > The plt reported that he was unable to get a down & locked indication on the main landing gear when arriving at Columbia. He stated that he went thru the emergency procedures & made two landing attempts but felt the gear was about to collapse & made… - [NTSB SEA84LA176](https://openairdocs.org/ntsb/SEA84LA176.md): Cessna 182D · Eugene, OR · Accident · No injuries · Limited investigation · Final report · Jul 17, 1984 · N8820X · Substantial damage > The plt estimated that the acft had about 1 hr of fuel remaining in the tanks prior to departure. However, after he had flown about 15 min, the eng lost power & would not restart. An emergency landing was made in a meadow about 2 mi from the arpt. The acft… - [NTSB SEA84FA175](https://openairdocs.org/ntsb/SEA84FA175.md): Cessna 182H · Elko, NV · Accident · 1 fatal · Field investigation · Final report · Jul 17, 1984 · N1828X · Destroyed > About 5 min after taking off on rwy 23, the plt reported on a downwind leg of the traffic pattern. Shortly after that, the acft crashed about 2 mi south of the arpt while on a southerly heading in a left wing low attitude. During impact, the left wing tip hit… - [NTSB NYC84FFJ03](https://openairdocs.org/ntsb/NYC84FFJ03.md): Raven S55A · Lakeville, NY · Accident · Serious injuries · Final report · Jul 15, 1984 · N40238 · Destroyed > Witnesses stated that as the balloon approached a field for landing, in dim light, it became apparent that the gondola was going to hit power lines. The wooden gondola hit the top wire and the plt jumped approximately 33 ft to the ground sustaining serious… - [NTSB FTW84LA303](https://openairdocs.org/ntsb/FTW84LA303.md): Smith Miniplane DSA-1 · Brookshire, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1984 · N1674 · Substantial damage > The acft collided with an unmarked wire after the engine quit on final apch. After the collision the plt was able to level the acft and crash landed about 250 ft short of the rwy. The impact snapped off one gear and folded the other. Theacft skidded to a stop… - [NTSB LAX84MA392](https://openairdocs.org/ntsb/LAX84MA392.md): Piper PA-31T · Concord, CA · Accident · 6 fatal · Major investigation · Final report · Jul 14, 1984 · DIKKS · Destroyed > The Piper PA-31T was a foreign registered acft (federal republic of germany). The owner/plt in the left front seat held a german commercial certificate with airplane instrument, single eng land & multi-eng land ratings. The plt in the right front seat held an… - [NTSB CHI84LA298](https://openairdocs.org/ntsb/CHI84LA298.md): Piper PA-38-112 · Almont, MI · Accident · No injuries · Limited investigation · Final report · Jul 14, 1984 · N2492B · Substantial damage > On 7/13, the plt departed fraser, MI, with full fuel tanks & flew to lakes of the north. The next day he flew to mackinac island. He then departed mackinac island without refueling. Near flint, MI, the plt contacted apch control & informed them he was low on… - [NTSB CHI84LA295](https://openairdocs.org/ntsb/CHI84LA295.md): Cessna 172M · Southgate, MI · Accident · No injuries · Limited investigation · Final report · Jul 14, 1984 · N20218 · Substantial damage > After takeoff, the plt climbed to 8500 ft MSL to practice maneuvers. He then made a descent to 4500 ft & began heading back to the arpt, then continued descending to 1800 ft & entered the tca. The eng lost power aprx 7 miles from the airport. Later, during an… - [NTSB NYC84LA241](https://openairdocs.org/ntsb/NYC84LA241.md): Cessna 152 · Mountville, PA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1984 · N757ER · Substantial damage > The student plt landed in a corn field short of the rwy on his 3rd solo landing. The plt stated that he 'misjudged the end of the rwy.' He also said he should have had a 'higher approach speed.' - [NTSB CHI84LA293](https://openairdocs.org/ntsb/CHI84LA293.md): Bellanca 17-30A · Richmond Hts, OH · Accident · No injuries · Limited investigation · Final report · Jul 13, 1984 · N93752 · Substantial damage > The aircraft was being flown back from an annual inspection. The pilot stated after the accident that he experienced a loss of power while on downwind leg for landing on rwy 23. The pilot attempted a landing on rwy 5 but the acft landed 1500 feet short.… - [NTSB LAX84LA386](https://openairdocs.org/ntsb/LAX84LA386.md): Let L-13 · Llano, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1984 · N99966 · Substantial damage > According to the plt, the glider did not sink as fast as expected on the downwind leg, so he extended flaps to 30 to 40 deg, used spoilers & extended the downwind. On base leg he entered an area of high sink; therefore, he closed the spoilers & angled toward… - [NTSB NYC84LA237](https://openairdocs.org/ntsb/NYC84LA237.md): Schleicher ASW-15 · Fairfield, PA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1984 · N111SP · Substantial damage > The glider was landed off arpt during a return from a round robin flt after experiencing a high sink rate. During the landing approach power lines hidden in a tree line were not cleared and the collision caused the acft to yaw about 45 degrees. The acft… - [NTSB NYC84LA236](https://openairdocs.org/ntsb/NYC84LA236.md): Beech 58 · Oneonta, NY · Accident · No injuries · Limited investigation · Final report · Jul 8, 1984 · N66534 · Substantial damage > Plt stated he was making multiple communications on base leg, talking on company freq as well as UNICOM, while adjusting his pattern to accomodate slow traffic on the runway and maintaing acft handling in gusty wind conditions. Gear handle was selected to… - [NTSB CHI84LA284](https://openairdocs.org/ntsb/CHI84LA284.md): Cessna 172M · Lake Geneva, WI · Accident · No injuries · Limited investigation · Final report · Jul 8, 1984 · N6700H · Substantial damage > According to the plt, he was on a short final apch to land when the acft encountered sudden turbulence. At that time, the passenger in the right front seat lurched against the control wheel, causing the nose to pitch down & the acft to bank left.… - [NTSB CHI84LA271](https://openairdocs.org/ntsb/CHI84LA271.md): Cessna 152 · Flint, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1984 · N49185 · Substantial damage > The plt stated that during preflight, he noticed that after straining the fuel sump, the strainer handle did not go backin as FAR as it should have. He checked to make sure no fuel was leaking & decided to take off. En route, he smelled fuel vapors. The eng… - [NTSB FTW84LA305](https://openairdocs.org/ntsb/FTW84LA305.md): Schweizer SGS 1-26E · Welch, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1984 · N2961H · Destroyed > The plt was participating in a national x-country contest. After aprx 6 hrs of flt, he elected to land in a circular irrigated cotton field. During a 2nd 360 deg turn over the intended landing area, at aprx 100 ft AGL, the glider's left wing dropped about 60… - [NTSB DEN84LA212](https://openairdocs.org/ntsb/DEN84LA212.md): Cessna 172 · Minnewaukan, ND · Accident · No injuries · Limited investigation · Final report · Jul 7, 1984 · N8917V · Substantial damage > The pilot of this aircraft overflew his intended landing site, a gravel road, in an attempt to observe any power lines or other obstructions that might be in his way. He did not see anything that would prevent a safe landing. While turning to make the actual… - [NTSB ANC84LA113](https://openairdocs.org/ntsb/ANC84LA113.md): Maule M-4 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Jul 7, 1984 · N4606T · Substantial damage > The acft landed short of the rwy during a forced landing. The plt said he switched fuel tanks 3 minutes piror to landingand the engine quit on downwind leg. Restart attempts were unsuccessful. Attempts to further question the plt have been unsuccessful. - [NTSB DEN84LA210](https://openairdocs.org/ntsb/DEN84LA210.md): Schweizer SGS 2-33 · Eagle, CO · Accident · No injuries · Limited investigation · Final report · Jul 5, 1984 · N2463W · Substantial damage > The acft was turned at a low alt in high density alt on final approach and stalled at about 20 ft AGL. The glider contacted the rwy and ground looped. - [NTSB NYC84LA229](https://openairdocs.org/ntsb/NYC84LA229.md): Maule M5-180C · Millbrook, NY · Accident · No injuries · Limited investigation · Final report · Jul 3, 1984 · N56424 · Substantial damage > Plt was practicing touch-&-go landings. On final apch a high sink rate developed. Plt added full pwr but sink rate was not arrested. Acft contacted terrain before apch end of rwy. - [NTSB MIA84LA198](https://openairdocs.org/ntsb/MIA84LA198.md): Piper PA-28-180 · Port St. Joe, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1984 · N4980L · Substantial damage > While on final apch to land at a private arpt, the acft collided with power lines near the apch end of the rwy. The plt stated that he did not see the power lines until just prior to impact. He attempted to fly under the lines, but the vertical stabilizer of… - [NTSB LAX84LA380](https://openairdocs.org/ntsb/LAX84LA380.md): Grumman G-164A · El Mirage, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1984 · N7202 · Substantial damage > The plt was practicing takeoffs & landings with about 800 lbs of water on board. After turning downwind for his second landing, he experienced a loss of airspeed & the acft started to sink into power lines. He released the emergency dump gate, at which time,… - [NTSB FTW84LA299](https://openairdocs.org/ntsb/FTW84LA299.md): Bell 222UT · E Brake Blk 397 · Accident · No injuries · Limited investigation · Final report · Jul 3, 1984 · N222PV · Substantial damage > While in a hovering approach to land on the deck of an oil platform in the gulf of Mexico a piece of plastic sheeting flew up from the platform into the tail rotor blades. The aircraft then slid in to a building on the deck following a hovering autorotation. - [NTSB SEA84LA153](https://openairdocs.org/ntsb/SEA84LA153.md): Hughes 269C · Mt. St. Helens, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1984 · N58397 · Destroyed > This accident occurred at the 5500 ft level on Mt. St. Helens. Density alt at the time was 7500 ft. at aprx 40-50 ft aglengine and rotor RPM began to decay rapidly. The acft landed hard on a rock ledge with one skid partially off the ledge. As rotor RPM… - [NTSB DEN84FA207](https://openairdocs.org/ntsb/DEN84FA207.md): Bell 206B · Englewood, CO · Accident · 2 fatal · Field investigation · Final report · Jul 2, 1984 · N3173L · Destroyed > Witnesses stated the helicopter entered a 'hard left turn' into a near inverted position before 'it went down hard and fast.' Inspection disclosed the metal connection for the left cyclic stick was broken in half. (Plt was flying from left seat.) Exam of the… - [NTSB DEN84LA205](https://openairdocs.org/ntsb/DEN84LA205.md): Mooney 20E · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 1984 · N2166X · Destroyed > The pilot fueled the aircraft with minimum fuel for the intended flight and did not recalculate consumption after a route change which extended flight. Power loss occurred about 1/4 mile from destination. The pilot attempted to glide to the rwy, but was… - [NTSB ATL84LA215](https://openairdocs.org/ntsb/ATL84LA215.md): Piper PA-34-200 · Hickory, NC · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N4886T · Substantial damage > Acft landed with the nose gear retracted. Examination revealed that the nose gear was hung up in the wheel well because an AN4-12 bolt, which secured the nose gear centering spring ass'y, was hung up in the gear door linkage. An annual inspection was… - [NTSB NYC84FA227](https://openairdocs.org/ntsb/NYC84FA227.md): Cessna 402C · Boston, MA · Accident · 1 fatal · Field investigation · Final report · Jun 30, 1984 · N120PB · Destroyed > During arrival, the flt was cleared for an ils/dme apch to rwy 27. While on the apch, the acft crashed in the ocean about 2.7 mi east of the rwy threshold. The plt reported that he was making the apch, using instruments, & landed short for unknown reasons. He… - [NTSB MIA84FA196](https://openairdocs.org/ntsb/MIA84FA196.md): Piper PA-32-300 · Niceville, FL · Accident · Serious injuries · Field investigation · Final report · Jun 30, 1984 · N32538 · Destroyed > The acft crashed into trees short of the rwy after the engine quit on final approach. The engine failed from internal failure of the crankshaft gear retention system. A teardown revealed that the crankshaft gear bolt had backed out & the bolt head was noted… - [NTSB FTW84LA293](https://openairdocs.org/ntsb/FTW84LA293.md): Mooney M20C · Marshall, TX · Accident · No injuries · Limited investigation · Final report · Jun 30, 1984 · N6261U · Substantial damage > The plt reported initial landing extension indicated an unsafe condition. The landing gear was recycled & a safe down & locked position was indicated. On landing roll the acft veered left off of the rwy & collided with trees. Tire marks on the rwy indicated… - [NTSB ATL84LA212](https://openairdocs.org/ntsb/ATL84LA212.md): Cessna 172G · Grenada, MS · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1984 · N4650L · Substantial damage > During arrival to an uncontrolled arpt, the plt made an apch while following about 1/4 mi behind a UH-1 helicopter. At that time, there was a quartering head wind at about 4 KTS. While on final apch at an alt of about 200 ft AGL, the Cessna 172 encountered… - [NTSB FTW84FA290](https://openairdocs.org/ntsb/FTW84FA290.md): Griffin FG-1A · Mt Pleasant, TX · Accident · 1 fatal · Field investigation · Final report · Jun 29, 1984 · N455FG · Destroyed > According to witnesses, the gyrocopter plt took off & turned onto a left downwind to stay in the traffic pattern for rwy 17. One witness stated that the gyrocopter turned onto final apch at about 300 to 400 ft AGL. Two other witnesses, who reside aprx 1/4 mi… - [NTSB DEN84LA201](https://openairdocs.org/ntsb/DEN84LA201.md): Cessna 177RG · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Jun 29, 1984 · N33215 · Substantial damage > The aircraft collided with a tree during an emergency landing following loss of throttle control at a low RPM. Examination revealed that an uncertified throttle cable had been installed, it failed at the attachment to the throttle body. - [NTSB NYC84FU005](https://openairdocs.org/ntsb/NYC84FU005.md): CGS Hawk B · Neshanic, NJ · Accident · 1 fatal · Final report · Jun 28, 1984 · UNREG · Destroyed > This ultralight was being flown by a plt who had about 80 hours of flt time in a C-172 and C-150 acft. He had soloed, but most of his time was dual and the last recorded flt was about 11 years ago. There are no records of any flt instruction in an ultralight.… - [NTSB LAX84FA367](https://openairdocs.org/ntsb/LAX84FA367.md): Piper PA-28-181 · Weaverville, CA · Accident · Serious injuries · Field investigation · Final report · Jun 26, 1984 · N3070G · Destroyed > When the plt filed a VFR flt plan, he stated that he was aware that the arpt at Weaverville, CA, was a one way strip & that he had a guide book which showed this info. Published procedures called for acft to 'land on rwy 36, take-off rwy 18.' A caution note… - [NTSB DEN84LA195](https://openairdocs.org/ntsb/DEN84LA195.md): Bellanca 7GCBC · Dillon, MT · Accident · No injuries · Limited investigation · Final report · Jun 26, 1984 · N88399 · Substantial damage > The plt reported that a nature movie was being made & he was making a short field landing for a film sequence. On the 3rd apch, he made a shorter base leg than normal, then on final apch, the acft stalled & 'slid in'. The left maincollapsed and the left wing… - [NTSB ANC84IA103](https://openairdocs.org/ntsb/ANC84IA103.md): Fairchild C-82A · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Jun 26, 1984 · N4753C · Minor damage > During arrival at the destination arpt, the aircrew was unable to extend the landing gear by using either the normal or emergency systems. They elected to return to Anchorage where emergency equipment was available. Fuel was reduced & subsequently a wheels up… - [NTSB LAX84LA366](https://openairdocs.org/ntsb/LAX84LA366.md): Bell 47G-2 · Concord, CA · Accident · No injuries · Limited investigation · Final report · Jun 25, 1984 · N953 · Destroyed > According to a plt/operator statement, the student plt was cleared for a downwind apch to land on 'pad 3.' The student stated that the apch was normal until he slowed to 40 mph & 'made left turn to final approach into a cross wind.' During the turn to final… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=201 ## 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=200 --- 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.