# 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 185 of 420 · 20,992 cases ## Cases, newest first - [NTSB ATL86LA145](https://openairdocs.org/ntsb/ATL86LA145.md): Langeford Midget Mustang MM-1 · Fayetteville, GA · Accident · Minor injuries · Limited investigation · Final report · May 24, 1986 · N8276 · Substantial damage > The plt had flown the acft for about 20 minutes in the local area after which he returned to the airfield and made an apch. He initiated a go-around and reached about 400 ft AGL when the eng quit. He made a forced landing in a field and the acft nosed over.… - [NTSB LAX86LA229](https://openairdocs.org/ntsb/LAX86LA229.md): Piper PA-28-140 · Springerville, AZ · Accident · No injuries · Limited investigation · Final report · May 22, 1986 · N3505K · Destroyed > The acft collided with two parked acft after the student pilot lost control during a go-around. The student stated that during his first landing of the day the acft started to 'slide sideways' and he elected to go-around. He increased the throttle and the… - [NTSB MKC86FPG04](https://openairdocs.org/ntsb/MKC86FPG04.md): Homebuilt Jodel F-9 · N. Little Rock, AR · Accident · Serious injuries · Final report · May 21, 1986 · N28QW · Substantial damage > The acft stalled and impacted the terrain in a nose low attitude during an attempted forced landing following an eng failure. Post accident inspection revealed the magneto drive coupling had failed. There was evidence present which indicated wear on the… - [NTSB MKC86LA114](https://openairdocs.org/ntsb/MKC86LA114.md): Grumman-Schweizer G-164A · Winona, KS · Accident · No injuries · Limited investigation · Final report · May 20, 1986 · N6680Q · Substantial damage > The pilot stated that he borrowed the airplane from his father to practice takeoffs and landings at his father's private, crop dusting airstrip. There were no chemicals onboard, according to the pilot. He further stated that on a go-around maneuver, and as he… - [NTSB MKC86FA113](https://openairdocs.org/ntsb/MKC86FA113.md): Swearingen SA226 · Hutchinson, KS · Accident · No injuries · Field investigation · Final report · May 20, 1986 · N514SS · Substantial damage > The capt rprtd that during arrival, the apch seemed normal until he flared to land on rwy 17. At that time, he heard a loud 'pop' as the landing gear contacted the rwy surface. Subsequently, the left main gear collapsed & the acft veered off the rwy. An exam… - [NTSB NYC86LA129](https://openairdocs.org/ntsb/NYC86LA129.md): Cessna 150K · North Hampton, NH · Accident · Minor injuries · Limited investigation · Final report · May 18, 1986 · N5744G · Substantial damage > The acft settled into trees during a landing apch. The plt reported that he added full power with the carburetor heat off and was still unable to stop the descent. When flt checked by the FAA, the plts slow flt and stall recovery procedures were found to be… - [NTSB LAX86FA222](https://openairdocs.org/ntsb/LAX86FA222.md): Cessna 320D · Van Nuys, CA · Accident · 6 fatal · Field investigation · Final report · May 18, 1986 · N320SD · Destroyed > The acft was returning from a x-country flt when the accident occurred. Witnesses observed the acft on a low downwind leg and made two sudden steep turns, one to the east followed by a sudden steep turn to the north prior to a nose down impact into the… - [NTSB DEN86LA139](https://openairdocs.org/ntsb/DEN86LA139.md): Pitts S-1S · Denver, CO · Accident · Minor injuries · Limited investigation · Final report · May 18, 1986 · N2DE · Destroyed > The plt report that he entered normal traffic for landing at front range airport. There were 3 or 4 acft preceding him so he extended his traffic pattern. After turning onto final approach about 1 mile from end of rwy, the plt said the eng quit abruptly. The… - [NTSB LAX86FA221](https://openairdocs.org/ntsb/LAX86FA221.md): Aerospatiale TB20 · Van Nuys, CA · Accident · 1 fatal · Field investigation · Final report · May 17, 1986 · N67TTB · Destroyed > While in the traffic pattern for rwy 16L the light acft plt was cautioned about possible wake turbulence from an arriving C-130 hercules acft landing on rwy 16R. The light acft plt acknowledged observing the C-130, which was above him. The C-130 landed on rwy… - [NTSB LAX86FA220](https://openairdocs.org/ntsb/LAX86FA220.md): Piper PA-28-160 · Chino, CA · Accident · 3 fatal · Field investigation · Final report · May 17, 1986 · N5412W · Destroyed > At the end of a 5.3 hr flt, the plt entered the traffic pattern & was hi on base & final apch. He elected to go around, but the eng lost power due to fuel exhaustion at about 200' AGL, just past the dep end of the rwy. The plt attempted to return to the rwy.… - [NTSB ATL86LA135](https://openairdocs.org/ntsb/ATL86LA135.md): Cessna T210N · Dothan, AL · Accident · No injuries · Limited investigation · Final report · May 17, 1986 · N1239U · Substantial damage > While on final approach for landing the aircraft lost total power and the pilot attempted a forced landing on a road. The aircraft landed across the road and ran into an open field. The pilot stated that the aircraft ran out of fuel. - [NTSB ATL86LA131](https://openairdocs.org/ntsb/ATL86LA131.md): Piper PA-28-140 · Lawrenceburg, TN · Accident · Serious injuries · Limited investigation · Final report · May 17, 1986 · N98387 · Substantial damage > The student plt had asked a pvt plt to ride with him while he (the student) took his son in law up for a ride. When approaching the rwy for landing, the student plt allowed the acft to collide with the berm short of the rwy. The acft came to a stop on the… - [NTSB LAX86LA218](https://openairdocs.org/ntsb/LAX86LA218.md): Cessna 152 · Julian, CA · Accident · Serious injuries · Limited investigation · Final report · May 16, 1986 · N89357 · Destroyed > The acft collided with wires on final apch to a private airstrip while on a personal VFR x-country flt. The plt stated that he was concerned about his fuel quanity and decided to make a precautionary landing at an arpt other than his dest. The plt realized he… - [NTSB MIA86LA159](https://openairdocs.org/ntsb/MIA86LA159.md): Piper PA-24-260 · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · May 15, 1986 · N9491P · Substantial damage > While in the traffic pattern the acft's electrical system failed due to internal failure of the alternator. The plt failed to extend the landing gear by the emergency gear extension handle and a gear up landing resulted. - [NTSB ATL86LA128](https://openairdocs.org/ntsb/ATL86LA128.md): Piper PA-28RT-201T · Toccoa, GA · Accident · No injuries · Limited investigation · Final report · May 15, 1986 · N2115Z · Substantial damage > The pilot made three unsuccessful attempts to land the aircraft on the runway. During the third attempt the aircraft bounced on the runway and the pilot applied power to go-around. During the attempted go-around the aircraft collided with trees on the left… - [NTSB MIA86LA157](https://openairdocs.org/ntsb/MIA86LA157.md): Cessna 182F · Sanford, FL · Accident · No injuries · Limited investigation · Final report · May 14, 1986 · N3516U · Substantial damage > The plt stated that as he attempted to land he did not notice the apch lights at the end of the rwy. The left wing and windshield struck the lights, after which, the acft landed without further incident. - [NTSB NYC86LA125](https://openairdocs.org/ntsb/NYC86LA125.md): Cessna 172P · Spring Valley, NY · Accident · Minor injuries · Limited investigation · Final report · May 12, 1986 · N55352 · Substantial damage > The plt was making an apch to rwy 08 which is 2185 ft long and 50 ft wide. The last 1/3 of the rwy slopes down noticeably. The acft struck parked cars in a parking lot located off the departure end of the rwy. There were no witnesses to the accident. The arpt… - [NTSB FTW86LA084](https://openairdocs.org/ntsb/FTW86LA084.md): Bellanca 14-13 · Pearland, TX · Accident · Serious injuries · Limited investigation · Final report · May 12, 1986 · N86874 · Destroyed > The plt was practicing touch & go landings at a local arpt. While making his apch, he undershot the rwy and the acft collided with a ravine. The plt reported that the airspeed was too slow and alt was too low. He continued to state that he should have made a… - [NTSB FTW86FA085](https://openairdocs.org/ntsb/FTW86FA085.md): Bell 206B · Pine Spring, TX · Accident · 2 fatal · Field investigation · Final report · May 12, 1986 · N27785 · Destroyed > The helicopter was on a flt to a site nr guadalupe pass, an area known for erratic & gusty wnds. As the plt was on an apch to a hi meadow (elev aprx 5460'), the helicopter entered a dscnt & crashed well short of the intended lndg area. A witness rprtd the… - [NTSB NYC86LA123](https://openairdocs.org/ntsb/NYC86LA123.md): Cessna 152 · Hallstead, PA · Accident · Minor injuries · Limited investigation · Final report · May 10, 1986 · N65618 · Destroyed > The airport is located in a valley between two rows of mountains on the ny/pa border. The plt had completed two takeoff and landings to a full stop at night for night currency. After takeoff and leveling off at 2,000 feet MSL and downwind for a left base to… - [NTSB MKC86FA101](https://openairdocs.org/ntsb/MKC86FA101.md): Aero Commander 680FL · Grand Island, NE · Accident · 1 fatal · Field investigation · Final report · May 9, 1986 · N1198Z · Destroyed > The twin eng acft crashed and burned 4 miles north of the arpt while on an instrument apch. The plt had transmitted that he had an engine problem. The #5 cylinder was found detached from the left engine but the left propeller was not feathered. An engine… - [NTSB MIA86LA152](https://openairdocs.org/ntsb/MIA86LA152.md): Bell 47G-3B-1 · Panama City, FL · Accident · No injuries · Limited investigation · Final report · May 9, 1986 · N1159W · Substantial damage > While approaching to land during a sightseeing flt a loss of eng pwr was experienced and an autorotation was made 70 ft short of the helipad. During touchdown, the main rotor struck and severed the tail boom. The plt stated after touchdown the eng continued… - [NTSB LAX86LA213](https://openairdocs.org/ntsb/LAX86LA213.md): Cessna 172M · Crescent City, CA · Accident · Minor injuries · Limited investigation · Final report · May 9, 1986 · N4450R · Destroyed > The pilot reported due to severe turbulence he decided to land long. Upon realizing that the airplane was too high he added full flaps. Shortly after touchdown the plt began to lose control of the airplane and elected to takeoff. During the initial climb the… - [NTSB DEN86FA128](https://openairdocs.org/ntsb/DEN86FA128.md): Swearingen SA226AT · Billings, MT · Accident · 1 fatal · Field investigation · Final report · May 8, 1986 · N577KA · Destroyed > While on an IFR flt plan in IMC, the plt executed a missed approach after flying a localizer back course 27 approach. During a subsequent ILS rwy 09L approach, radio and radar contact with the acft was lost lost. The acft wreckage was located on the inbound… - [NTSB FTW86LA081](https://openairdocs.org/ntsb/FTW86LA081.md): Mooney M-10 · Abilene, TX · Accident · No injuries · Limited investigation · Final report · May 6, 1986 · N9538V · Substantial damage > While on final approach for runway 17 at elmdale airpark, Abilene, TX, the student pilot lost control of the aircraft when he flared the aircraft and it began to descend. The student attempted to pull back on the wheel, causing the aircraft to enter a stall… - [NTSB LAX86LA209](https://openairdocs.org/ntsb/LAX86LA209.md): Mooney M20C · La Verne, CA · Accident · No injuries · Limited investigation · Final report · May 4, 1986 · N9099V · Substantial damage > A total loss of eng power was experienced while on base leg for landing at brakett field. The acft was landed short of the rwy and a fence was contacted. Post accident inspection revealed the acft's fuel supply had been exhausted. - [NTSB ATL86LA123](https://openairdocs.org/ntsb/ATL86LA123.md): Aero Commander 112 · Roanoke, AL · Accident · No injuries · Limited investigation · Final report · May 4, 1986 · N55VH · Substantial damage > The plt lost control of the acft during an attempted go-around. While on final apch, full flaps were lowered and power was added to maintain 80 KTS. The acft continued descending, the airspeed decreased to 65-70 KTS and the stall warning activated. The plt… - [NTSB ATL86LA122](https://openairdocs.org/ntsb/ATL86LA122.md): Cessna 172E · Clyde, OH · Accident · Minor injuries · Limited investigation · Final report · May 3, 1986 · N3960S · Substantial damage > The acft was approaching a grass airstrip when the eng quit.a landing short of the rwy in a wheat field resulted in a collapsed nose gear. Exam of the acft revealed a birds nest inside the eng cowling, a dead magneto, reversed 'p' leads, and one shorted… - [NTSB ATL86LA121](https://openairdocs.org/ntsb/ATL86LA121.md): Ayres S-2D-600 · Walterboro, SC · Accident · No injuries · Limited investigation · Final report · May 3, 1986 · N1653S · Substantial damage > The acft was returning to arpt for fuel then was to resume fighting a forest fire by water dispersal. The acft experienced total fuel exhaustion on short final and force landed 500 ft from rwy. - [NTSB FTW86MA074](https://openairdocs.org/ntsb/FTW86MA074.md): Cessna 310Q · Houston, TX · Accident · Serious injuries · Major investigation · Final report · May 2, 1986 · N69668 · Destroyed > Drg ngt visual apch, plt enctrd dtrtg wx, got vectors for ILS rwy 8 apch, was clrd for apch at 0511 CDT. On final apch, he noted his #1 & #2 ils's giving erratic LOC & g/s info (but functioning) & that his LOC course deviation info didn't agree with adf, but… - [NTSB LAX86LA210](https://openairdocs.org/ntsb/LAX86LA210.md): Cessna 172N · Clearlake, CA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1986 · N738JE · Substantial damage > The flt instructor (CFI) said he was instructing the student in how to judge a straight-in approach and landing to a dock with minimal taxiing required. During the approach, the CFI determined that the student was overshooting the desired touchdown point, so… - [NTSB CHI86FER06](https://openairdocs.org/ntsb/CHI86FER06.md): Cessna 180 · Brainerd, MN · Accident · 1 fatal · Final report · Apr 30, 1986 · N6559A · Destroyed > A witness reported seeing the floatplane descending 'abnormally' in a nose low attitude just prior to water impact. The plt reported making the apch to the lake in a nose up attitude with partial power on. The plt remembers no further events leading up to the… - [NTSB FTW86LQG15](https://openairdocs.org/ntsb/FTW86LQG15.md): Aviation ADV. Mustang Psid · Midland, TX · Accident · No injuries · Final report · Apr 29, 1986 · N51JR · Substantial damage > The experimental acft on a test flt suffered an engine failure during the final approach to land. The plt said that he did not believe he could make the arpt so he turned right to an open field to land downwind. Investigation after the accident revealed that… - [NTSB SEA86LA113](https://openairdocs.org/ntsb/SEA86LA113.md): Cessna 172 · Hubbard, OR · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N65654 · Substantial damage > During practice simulated forced landing with the power reduced to idle and gusting crosswinds airspeed was lost. The aircraft entered into an approach stall striking the ground nose first and then nosing over inverted. - [NTSB MKC86LA097](https://openairdocs.org/ntsb/MKC86LA097.md): Cessna 172F · Van Buren, MO · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N7921U · Substantial damage > The pilot states that he had been advised of utility lines on both ends of the airstrip, and that several aircraft had previously experienced landing problems there. He further states that as he initiated a go-around he was caught in a downdraft he could not… - [NTSB CHI86LA131](https://openairdocs.org/ntsb/CHI86LA131.md): Piper PA-28-140 · Midlothian, IL · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N33822 · Substantial damage > The acft was being operated on a student instructional flt. On initial run up the CFI stated he had an excessive mag drop that cleared up. The acft was flown to an adjacent field to make two touch and go landings. During the last takeoff the CFI suspected a… - [NTSB LAX86LA198](https://openairdocs.org/ntsb/LAX86LA198.md): Cessna 501 · Bermuda Dunes, CA · Accident · No injuries · Limited investigation · Final report · Apr 26, 1986 · N46MT · Substantial damage > Based on the flt's landing weight, an approach ref speed of 99 knots was calculated by the pilot. He reported that 115 knots was used during the approach. The pilot said that during the descent to the airport, one aircraft was heard to make a go-around 'due… - [NTSB NYC86FA111](https://openairdocs.org/ntsb/NYC86FA111.md): Piper PA-28-140 · Spring Valley, NY · Accident · Serious injuries · Field investigation · Final report · Apr 23, 1986 · N44331 · Destroyed > The pax stated that he & the plt were at a bar where they had about three beers rpior to this flight. During the flight the pilot did several stalls and some aerobatic maneuvers. The pax was unnerved and told the plt that he wanted to return to the arpt.… - [NTSB CHI86LA130](https://openairdocs.org/ntsb/CHI86LA130.md): Cessna 150 · Gregory, MI · Accident · No injuries · Limited investigation · Final report · Apr 23, 1986 · N16047 · Substantial damage > The CFI stated that the purpose of the flight was to look at property and give a bfr to his dual student. The aircraft struck wires while on approach to runway 23 at the smith farm airport. The CFI stated this accident could have been prevented had he used a… - [NTSB CHI86FEP04](https://openairdocs.org/ntsb/CHI86FEP04.md): Day Skybolt DB · Wisconsin Rapid, WI · Accident · No injuries · Final report · Apr 21, 1986 · N23DA · Substantial damage > The plt thought he had sufficient fuel for a 'short trip around the pattern.' However, shortly after taking off from rwy 29, the eng began to lose power. The plt attempted to land on rwy 2, but all power was lost & he was unable to reach the rwy. He landed… - [NTSB MKC86LA094](https://openairdocs.org/ntsb/MKC86LA094.md): Beech A-90 · West Memphis, AR · Accident · No injuries · Limited investigation · Final report · Apr 20, 1986 · N772K · Substantial damage > The plt made a landing to a rain slick rwy at West Memphis, Arkansas. The plt stated the acft hydroplaned and that braking was negligible. The pic's attempts to use the reversers resulted in the acft yawing. Wind shifts in the rain showers extended the acft's… - [NTSB MKC86LA093](https://openairdocs.org/ntsb/MKC86LA093.md): Beech M-35 · Marshall, MO · Accident · No injuries · Limited investigation · Final report · Apr 20, 1986 · N9726R · Substantial damage > The pilot stated that all the tanks were full when he departed springdale, Arkansas and he flew en route for one hour on the left tank and thirty minutes on the auxiliary tank. The aircraft performed routinely en route and during letdown to the Marshall… - [NTSB LAX86LA185](https://openairdocs.org/ntsb/LAX86LA185.md): Cessna 150M · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · Apr 20, 1986 · N66459 · Substantial damage > The plt reported that he intended to fly to Lancaster to refuel. After being airborne for about 44 minutes & while entering the traffic pattern, the acft's engine exhausted its usable fuel. The plt attempted to glide to the rwy, but had insufficient altitude.… - [NTSB FTW86LA068](https://openairdocs.org/ntsb/FTW86LA068.md): Cessna 177 · Lubbock, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 1986 · N29612 · Substantial damage > During an attempted go-around, after touching down past the runway mid-point, the pilot stated he was unable to obtain sufficient power during the go-around. The aircraft crashed 200 feet off the end of the runway. FAA inspectors on the scene stated that they… - [NTSB DEN86LA118](https://openairdocs.org/ntsb/DEN86LA118.md): Cessna 180G · Roosevelt, UT · Accident · No injuries · Limited investigation · Final report · Apr 20, 1986 · N180BK · Substantial damage > The plt stated that after 'landing long', he decided to initiate a go-around. The plt said the aircraft he was piloting contacted a parked aircraft during the go-around which resulted in the accident. - [NTSB LAX86FUJ01](https://openairdocs.org/ntsb/LAX86FUJ01.md): Piper PA-25-235 · Phoenix, AZ · Accident · No injuries · Final report · Apr 19, 1986 · N6661Z · Substantial damage > The acft collided with the ground rt wing first after a high sink rate developed in a 45 degree intercept to final with 30 degrees of bank and full flaps. The plt felt the acft sinking and attemtped to stop it with power and reduced angle of bank. He stated… - [NTSB BFO86FID03](https://openairdocs.org/ntsb/BFO86FID03.md): Taylor Lonsdale KR-2 · Waynesboro, VA · Accident · 2 fatal · Final report · Apr 19, 1986 · N99PT · Destroyed > The airport operator, caleb glick, was driving on a road adjacent to the airport when he observed the aircraft turning base for runway 23 at Waynesboro airport. Shortly therafter he lost sight of N99PT and next observed it as it collided with the ground in… - [NTSB ATL86LA117](https://openairdocs.org/ntsb/ATL86LA117.md): Bellanca 7-GCAA · Chester, SC · Accident · No injuries · Limited investigation · Final report · Apr 19, 1986 · N9030L · Substantial damage > Aircraft was being repositioned on airport for glider tow. Tow rope was attached and pilot concentrated his attention on avoiding entangling tow rope on runway lights. When pilot noticed the aircraft was too low he attempted a go-around with insufficient… - [NTSB NYC86LA105](https://openairdocs.org/ntsb/NYC86LA105.md): Piper PA-28R-200 · Westhampton Bch, NY · Accident · No injuries · Limited investigation · Final report · Apr 15, 1986 · N4559X · Substantial damage > The instrument instructional flight returned to the airport late at night and successfully completed two instrument approaches with missed approaches. The pilots had been advised of a low layer of fog on the airport. On the third and final approach, after… - [NTSB LAX86LA179](https://openairdocs.org/ntsb/LAX86LA179.md): Cessna 150H · Hesperia, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 1986 · N22134 · Destroyed > The acft collided with wires after an attempted go-around on apch to rwy 21. On short final to rwy 21 at aprx 20 ft AGL, a gust of wind blew the acft off the centerline of the rwy. The plt initiated a go-around by applying full power and rising the flaps from… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=186 ## 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=185 --- 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.