# 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 178 of 420 · 20,992 cases ## Cases, newest first - [NTSB CHI87LA142](https://openairdocs.org/ntsb/CHI87LA142.md): Schleicher KA-6-CR · Staunton, IL · Accident · No injuries · Limited investigation · Final report · Jun 4, 1987 · N9398 · Substantial damage > The plt stated that he climbed to 6000 feet MSL and proceeded on course to Staunton, Illinois. According to the plt in a telephone interview, he was approximately 800-900 feet above willhoit airport when he made a 360 degree turn to enter base. He further… - [NTSB CHI87DEP06](https://openairdocs.org/ntsb/CHI87DEP06.md): Zank Challenger II · Redgranite, WI · Accident · 1 fatal · Final report · Jun 4, 1987 · N56DZ · Destroyed > The student pilot had purchased this amateur built aircraft earlier in the day and had made one successful flight and was on the downwind leg of the second flight. The aircraft was at an estimated altitude of 150' to 200' AGL, when witnesses stated that the… - [NTSB NYC87LA166](https://openairdocs.org/ntsb/NYC87LA166.md): North American B-25N · Stow, MA · Accident · No injuries · Limited investigation · Final report · Jun 3, 1987 · N3476G · Substantial damage > The acft touched down hard on the grassy area 5 to 10 ft short of the rwy. The plt stated at the time that he felt and heard the hydraulic line burst in the cabin which left the aircraft without brakes. The acft failed to stop and continued to roll off the… - [NTSB LAX87LA224](https://openairdocs.org/ntsb/LAX87LA224.md): Bellanca 7KCAB · Fremont, CA · Accident · No injuries · Limited investigation · Final report · May 30, 1987 · N88314 · 2 aircraft · Substantial damage > While on final apch to lnd on rwy 28, a glider (Schweizer sgs 2-32, N242DB) & a tow plane (Bellanca 7KCAB, N88314) collided in flt at an alt of about 200' AGL. The tow plane was returning fm a LCL tow mission & the glider was returningfm a LCL sightseeing… - [NTSB DEN87LA139](https://openairdocs.org/ntsb/DEN87LA139.md): Piper PA-18-150 · Wolf Point, MT · Accident · No injuries · Limited investigation · Final report · May 30, 1987 · N9128D · Substantial damage > The pilot was on approach to his private strip at approxiamtely 25 feet AGL when the aircraft stalled. The aircraft dropped onto the runway, the pilot added full power attempting to recover, the left wing dipped and struck the ground. - [NTSB DEN87LA137](https://openairdocs.org/ntsb/DEN87LA137.md): Cessna 140 · Sawyer, ND · Accident · Minor injuries · Limited investigation · Final report · May 30, 1987 · N1677V · Substantial damage > The commercial plt and his wife were on a cross country flt and were landing for refueling. On final, the acft began an uncommanded left turn as landing flaps were selected. The plt was unable to correct the turn and struck trees short of the private… - [NTSB CHI87LA136](https://openairdocs.org/ntsb/CHI87LA136.md): Piper PA-34-200T · Plymouth, IN · Accident · No injuries · Limited investigation · Final report · May 30, 1987 · N8231D · Substantial damage > While on final approach about 200 feet from the end of the runway, the right front seat passenger told the pilot she thought she saw a deer. The pilot added power for a possible go-around. Since he did not see any deer, the pilot continued his landing. He… - [NTSB ATL87LA153](https://openairdocs.org/ntsb/ATL87LA153.md): Cessna 152 · Trenton, KY · Accident · No injuries · Limited investigation · Final report · May 29, 1987 · N68163 · Destroyed > The dual instruction flight was practicing soft field landings at a private grass strip. The aircraft stalled during a go-around attempt on the second approach when the student pilot executed a steep pullup to clear powerlines. The aircraft pitched down,… - [NTSB MIA87LA165](https://openairdocs.org/ntsb/MIA87LA165.md): Cessna 210L · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · May 28, 1987 · N121PL · Substantial damage > The eng quit aprx 6 miles from the arpt. During the landing roll following the forced landing the nose gear collapsed & the acft collided with trees. Imspection of the acft revealed that the fuel selector was positioned to the left tank which did not contain… - [NTSB LAX87LA218](https://openairdocs.org/ntsb/LAX87LA218.md): Cessna 150L · San Jose, CA · Accident · Serious injuries · Limited investigation · Final report · May 27, 1987 · N6669G · Substantial damage > While on final apch to land on rwy 31R at night, the acft flew too low, struck trees, then collided with the terrain. The plt was taken to a hospital with serious injuries & a blood sample was drawn at 0205 PDT. A check of his blood showed an alcohol level of… - [NTSB ATL87LA152](https://openairdocs.org/ntsb/ATL87LA152.md): Piper PA-28-140 · Erwin, NC · Accident · No injuries · Limited investigation · Final report · May 27, 1987 · N1696T · Substantial damage > The acft impacted level grassy terrain short of rwy 04, while on short final during a practice short-field ldg. The CFI reported that the student plt had stabilized the acft on the appch at 70 mph; a high sink rate was subsequently encountered as the acft… - [NTSB NYC87LA154](https://openairdocs.org/ntsb/NYC87LA154.md): Cessna 172 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · May 24, 1987 · N65482 · Substantial damage > Drg a night flt from new bedford to bridgeport, the plt enctrd visibility problems & believed that fuel consumption was higher than normal. He obtained radar vectors to New Haven. After seeing the arpt, he flew over to establish the runway pattern. However,… - [NTSB FTW87LA132](https://openairdocs.org/ntsb/FTW87LA132.md): Piper PA-28-140 · Port Aransas, TX · Accident · No injuries · Limited investigation · Final report · May 24, 1987 · N6426W · Substantial damage > The engine lost power while on the downwind leg of the traffic pattern. The pilot made a 180 degree turn and attempted to reach the runway. Touchdown occurred about 15 feet short and the landing gear impacted a sandy embankment. The aircraft then slid to a… - [NTSB ATL87LA145](https://openairdocs.org/ntsb/ATL87LA145.md): Cessna 172RG · Ozark, AL · Accident · Minor injuries · Limited investigation · Final report · May 22, 1987 · N6363R · Substantial damage > The inst plt indicated that during airwork procedures practice in the LCL area, the right wing seemed to be heavy. He indicated that he switched the fuel selector from both to right tank. After about 20-30 minutes, they returned to the airport and entered… - [NTSB DEN87FA130](https://openairdocs.org/ntsb/DEN87FA130.md): Piper PA-31T-620II · Cody, WY · Accident · 3 fatal · Field investigation · Final report · May 20, 1987 · N2336X · Destroyed > N2336X was on a business flt to Cody, WY. The pilot executed a missed approach on the first attempt of the vor-a approach. A pilot who landed at Cody minutes before the accident said the visibility had decreased to 3/4 of a mi when N2336X made the first… - [NTSB MKC87LA104](https://openairdocs.org/ntsb/MKC87LA104.md): Cessna 182C · Wamego, KS · Accident · Minor injuries · Limited investigation · Final report · May 17, 1987 · N8789T · Substantial damage > The PIC had been airborne in the LCL area to let parachute jumpers jump fm his acft. To lose alt quickly the PIC performed a prolonged slip. On the final app the eng quit and alt was insufficient to reach the rwy for lndg. The off arpt lndg was unsuccessful.… - [NTSB CHI87LA130](https://openairdocs.org/ntsb/CHI87LA130.md): Cessna 172P · Lansing, IL · Accident · Serious injuries · Limited investigation · Final report · May 16, 1987 · N97193 · Destroyed > During an attempted go-around, the right wing struck a tree, the left wing then contacted a building and the aircraft impacted in a freshly plowed field. Witnesses report the aircraft was high and fast and drifting to the right of runway centerline. Also… - [NTSB LAX87LA205](https://openairdocs.org/ntsb/LAX87LA205.md): Cessna 150M · Honolulu, HI · Accident · No injuries · Limited investigation · Final report · May 14, 1987 · N704QH · Substantial damage > The student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for… - [NTSB ATL87FA135](https://openairdocs.org/ntsb/ATL87FA135.md): Beech 35 · Avon, OH · Accident · 3 fatal · Field investigation · Final report · May 10, 1987 · N2988V · Destroyed > Acft was seen heading east on a downwind for the private airstrip where it was based. It was turned onto the base leg and as a turn was begun for the final approach course for rwy 27 it stalled, spun, and collided with the ground. The acft wreckage was found… - [NTSB CHI87LA126](https://openairdocs.org/ntsb/CHI87LA126.md): Cessna 150E · St. Johns, MI · Accident · No injuries · Limited investigation · Final report · May 9, 1987 · N3039J · Substantial damage > The plt reported that a gust of wind caught the acft during landing and he immediately added full power in a go-around attempt. The plt stated that the acft then stalled in trees and a fence row. - [NTSB BFO87LA035](https://openairdocs.org/ntsb/BFO87LA035.md): Beech A23 · Ravenswood, WV · Accident · Serious injuries · Limited investigation · Final report · May 9, 1987 · N3543R · Destroyed > The pilot was providing free promotional rides for a flight school. He was on the fourth flight of the day, on final approach, in a nose high attitude when the aircraft's left wing struck small trees. The aircraft impacted the ground 250FEET short of the… - [NTSB MIA87LA158](https://openairdocs.org/ntsb/MIA87LA158.md): Cessna 337E · San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · May 8, 1987 · N1253M · Substantial damage > The plt stated that during the base leg with 2/3 flaps lowered the acft entered an uncontrolled left bank. Control was partially regained, however, the acft then entered a spin to the left. Control was not established before the acft crashed into the ocean… - [NTSB DCA87MA030](https://openairdocs.org/ntsb/DCA87MA030.md): CASA C-212-CC · Mayaguez, PR · Accident · 2 fatal · Major investigation · Final report · May 8, 1987 · N432CA · Destroyed > After several maintenance adjustments of the right propeller and flight idle fuel flow, the aircraft was test flown and released for flight. Several pilots continued to note descrepancies concerning the right propeller system. Adjustments were made and the… - [NTSB ATL87LA137](https://openairdocs.org/ntsb/ATL87LA137.md): Moss Timothy C Quicksilver MX · Monroe, NC · Accident · Serious injuries · Limited investigation · Final report · May 8, 1987 · N53317 · Substantial damage > The student plt reported that the engine lost power while the ultralight-type acft was on final approach to a mowed field owned by him. The acft subsequently impacted a tree at the end of the field and fell to the terrain nose-down. The student pilot noted… - [NTSB CHI87LA123](https://openairdocs.org/ntsb/CHI87LA123.md): Cessna A152 · Gobles, MI · Accident · Minor injuries · Limited investigation · Final report · May 6, 1987 · N761ED · Destroyed > During the third leg of a cross-country flight, the pilot reported that the sun was directly in his eyes while on final approach to rwy 27. He stated he first saw the set of power lines when they were about 25 feet ahead of the aircraft. While attempting to… - [NTSB CHI87LA120](https://openairdocs.org/ntsb/CHI87LA120.md): Cessna 150J · Detroit, MI · Accident · No injuries · Limited investigation · Final report · May 3, 1987 · N60023 · Substantial damage > While on approach to Detroit city airport the #1 cylinder fractured and separated resulting in engine failure. The pilot made a forced landing in a field approx. four miles west of the airport. Examination of the broken cylinder revealed the mode of the… - [NTSB MIA87FA153](https://openairdocs.org/ntsb/MIA87FA153.md): Cessna 152 · Lantana, FL · Accident · No injuries · Field investigation · Final report · May 2, 1987 · N152LG · 2 aircraft · Minor damage > The plt stated that he was at 60 KTS. With full flaps & just about to flare when somthing forced the nose down. He then pulled back on the controls, hit the ground, veered off the left side of the runway & collided with a C152 that was holding for takeoff,… - [NTSB NYC87LA137](https://openairdocs.org/ntsb/NYC87LA137.md): Stearman PT-17 · Hampton, NH · Accident · No injuries · Limited investigation · Final report · May 1, 1987 · N3993P · Substantial damage > While on final approach, the plt stated that the acft encountered a moderate crosswind. At abt mid-field, the plt elected to make a go-around, however, due to windshear and/or downdrafts, the acft was unable to climb. The Stearman collided with several tall… - [NTSB LAX87FA198](https://openairdocs.org/ntsb/LAX87FA198.md): Mooney M20K · Long Beach, CA · Accident · No injuries · Field investigation · Final report · Apr 30, 1987 · N231MW · Substantial damage > On 4/28/87, after a flt from Long Beach to las vegas, the plt requested the left wing tank be svcd with 15 gal of fuel; no fuel was added to the rgt tank. Two days later, the plt took off on the return flt. Drg arrival at Long Beach, he was vectored for an… - [NTSB DEN87LA116](https://openairdocs.org/ntsb/DEN87LA116.md): Weatherly 620 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Apr 30, 1987 · N9256W · Substantial damage > The plt departed with full fuel in the acft to practice aerial spraying techniques. After 45 mins of practice he returned to the arpt for landing. He said that prior to entering the traffic pattern he switched from the half-full right tank to the full left… - [NTSB LAX87LA195](https://openairdocs.org/ntsb/LAX87LA195.md): Cessna 402A · Kahului, HI · Accident · Serious injuries · Limited investigation · Final report · Apr 29, 1987 · N4588Q · Destroyed > Shortly after takeoff, the plt reqd an 'immediate downwind' to rtrn to the arpt & was clrd to land. When asked if equip-ment was needed, he replied, 'negative, sir, a little matter of fuel.' A witness said the acft appeared very low on final apch with both… - [NTSB ATL87FA130](https://openairdocs.org/ntsb/ATL87FA130.md): Cessna 182R · Kennesaw, GA · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1987 · N5511N · 2 aircraft · Destroyed > N5511N was in the traffic pattern at cobb county airport-mc collum field and was near the turning point from crosswind to dwnd when it was struck by N52995. N52995 was making a straight-in entry into the downwind leg of the traffic pattern from the west with… - [NTSB NYC87LA135](https://openairdocs.org/ntsb/NYC87LA135.md): Piper PA-23-250 · Portland, ME · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1987 · N13808 · Destroyed > The pilot of the PA-23 was attempting an NDB approach into the Portland, ME. Int'l jetport. The wx was rpt'd as moderate turbulence and moderate or greater icing, the icing level was rpt'd from the surface to 16000 ft. prior to this NDB approach the pilot had… - [NTSB BFO87LA033](https://openairdocs.org/ntsb/BFO87LA033.md): Cessna 150G · Roanoke, VA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N3043S · Substantial damage > While enroute from gaithersburg, MD, to blacksburg, VA, the plt decided to divert to Roanoke, VA, due to thunderstorms in the area. On x-wind leg to rwy 33 at Roanoke the eng started to run rough. Aft carb heat was applied it smoothed out but quit completely… - [NTSB LAX87DVA06](https://openairdocs.org/ntsb/LAX87DVA06.md): North American F-86F · Shafter, CA · Accident · 1 fatal · Final report · Apr 25, 1987 · N86Z · Destroyed > Following an airshow, the pilot transmitted while on final approach to the runway, that the engine had seized. The aircraft was landed with the landing gear retracted. During the flare the aircraft became uncontrollable, bounced several times on the runway,… - [NTSB FTW87FA105](https://openairdocs.org/ntsb/FTW87FA105.md): Grumman AA-5B · Eagle Lake, TX · Accident · 2 fatal · Field investigation · Final report · Apr 25, 1987 · N28846 · Destroyed > On April 25,1987 a Grumman American AA5B, N28846, impacted the terrain near Eagle Lake, Texas. The private pilot and her husband received fatal injuries. The aircraft was destroyed. Visual meteorological conditions prevailed at the time of the accident. The… - [NTSB BFO87FA031](https://openairdocs.org/ntsb/BFO87FA031.md): Piper PA-24-250 · Salisbury, MD · Accident · 1 fatal · Field investigation · Final report · Apr 21, 1987 · N5821P · Destroyed > On a flt from hilton head, SC to woodstown, NJ, the plt enctrd headwinds & diverted to Salisbury, MD, a less distant arpt. Drg arrival at 1944, he was provided wx info concerning a low ceiling & visibility. At 1955, he was instructed to hold upon reaching a… - [NTSB MIA87LA138](https://openairdocs.org/ntsb/MIA87LA138.md): Cremer VP-1 · Tupelo, MS · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 1987 · N70PJ · Destroyed > Acft lost engine power on short final approach. Acft stalled and touched down hard short of the runway. The acft then collided with the raised edge of the runway collapsing the main gear and then nosing over. The pilot attributed the loss of engine power to a… - [NTSB NYC87FA127](https://openairdocs.org/ntsb/NYC87FA127.md): Piper PA-28-180 · York, PA · Accident · 4 fatal · Field investigation · Final report · Apr 18, 1987 · N7987W · Destroyed > The Piper PA-28-180 was making an NDB instrument approach under instrument meteorological conditions at night. The pilot manuevered the aircraft over the airport several times in an apparent attempt to acquire visual contact with the runway, lost control of… - [NTSB MIA87LA137](https://openairdocs.org/ntsb/MIA87LA137.md): Cessna 152 · Gainesville, FL · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N89627 · Substantial damage > The plt elected to land the acft on a taxiway after the eng quit aprx 5 miles from the arpt. During the flare, the wing stalled, followed by a hard landing on the nose gear causing it to collapse. Post crash examination of the acft revealed that the eng quit… - [NTSB LAX87LA180](https://openairdocs.org/ntsb/LAX87LA180.md): Cessna 182M · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N71736 · Substantial damage > At the end of a pleasure cross country flt, while on long final to the rwy, the plt had to add pwr to compensate for a crosswind. Prior to reaching short final the plt had reduced pwr again. Upon reaching the threshold, the acft was aprx 300 ft AGL. The plt… - [NTSB NYC87LA123](https://openairdocs.org/ntsb/NYC87LA123.md): Piper PA-23-250 · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1987 · N40395 · Substantial damage > The Piper PA-23-250 attempted a go-around after crossing the threshold and observing the runway lights were not on during a night instrument approach. The pilot reported that he added full power and retracted the wing flaps. The procedure in the Piper manual… - [NTSB NYC87FA126](https://openairdocs.org/ntsb/NYC87FA126.md): Beech 58P · Pleasantville, NY · Accident · 1 fatal · Field investigation · Final report · Apr 17, 1987 · N721WW · Destroyed > The plt rept his auto-pilot was malfunctioning on the apch and he was having aileron problems. He rept a loss of pwr, got the eng started, and then rept a double pwr loss. Prior to disappearing from radar he rept that he was starting one engine. The acft… - [NTSB FTW87LA099](https://openairdocs.org/ntsb/FTW87LA099.md): Aircoupe 415D · Lakeway, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1987 · N93884 · Substantial damage > The commercial pilot of an Aircoupe with one passenger on board attempted to execute an overhead 360 degree turn to land on runway 16 at Lakeway airport near austin, TX. The pilot did not have adequate altitude to complete the maneuver. The aircraft impacted… - [NTSB DEN87LA102](https://openairdocs.org/ntsb/DEN87LA102.md): Aero Commander S-2D · Columbus, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1987 · N1714S · Substantial damage > The plt departed deming, NM and flew to a ranch 15 mi n of Columbus, NM, to position the acft for aerial spraying that day. It was still dark when the plt made his apch to a road paralleled by power lines on the left and telephone cable marker posts on the… - [NTSB ATL87LA115](https://openairdocs.org/ntsb/ATL87LA115.md): Cessna 182Q · Meridianville, AL · Accident · No injuries · Limited investigation · Final report · Apr 17, 1987 · N4798N · Substantial damage > The plt completed the vor/dme-b appch to the arpt and cancelled his IFR flt plan. The plt reported observing that the acft was to the right of the rwy while on final appch to rwy 36. He then initiated a go-around, and began a right turn after 'passing' a tree… - [NTSB ATL87DLT01](https://openairdocs.org/ntsb/ATL87DLT01.md): Schleicher ASK-21 · Eagleville, TN · Accident · No injuries · Final report · Apr 17, 1987 · N174KS · Substantial damage > During a landing attempt, N174KS collided with a treeline on final approach to the airport. The instructor reported that the flight was normal until the student encountered a downdraft on final approach. The instructor took control of the controls, but was… - [NTSB CHI87FA114](https://openairdocs.org/ntsb/CHI87FA114.md): Cessna 182G · West Point, IN · Accident · 1 fatal · Field investigation · Final report · Apr 16, 1987 · N2382R · Destroyed > Drg an IFR arrival, the plt was clrd for an ILS rwy 10 apch. No radar facilities were available, but at 1026 EST, he rprtd he was established on the localizer. Aprx 4 min later, he declared a missed apch & was cleared back to the outer marker (om), then was… - [NTSB LAX87LA177](https://openairdocs.org/ntsb/LAX87LA177.md): Cessna T303 · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Apr 14, 1987 · N2225C · Substantial damage > A Cessna T303 collided w the LOC antenna aft a total loss of pwr in both engs while on final app to rwy 30. The plt indicated that the engs failed due to fuel exhaustion. The flt made 5 stops to pick-up and drop off cargo and is normally flown daily by… - [NTSB DCA87MA026](https://openairdocs.org/ntsb/DCA87MA026.md): Boeing 707-351C · Kansas City, MO · Accident · 4 fatal · Major investigation · Final report · Apr 14, 1987 · N144SP · Destroyed > Drg arr, buffalo airways flt 721 was vectored for an ILS rwy 1 apch. Except for deviations to avoid tstms, dscnt to the terminal area was routine. At 2151:01, the flt was adzd it was 5 mi fm the outer marker (om), was given a final vector to intercept the ILS… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=179 ## 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=178 --- 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.