# NTSB investigations: Initial climb 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 170 of 412 · 20,559 cases ## Cases, newest first - [NTSB BFO87DIG03](https://openairdocs.org/ntsb/BFO87DIG03.md): Piper PA-28-161 · Frederick, MD · Accident · Minor injuries · Final report · May 6, 1987 · N8149P · Destroyed > Shortly after liftoff the pilot stated that the left wing dropped and the aircraft began to turn to the left. He appliedright aileron and raised the nose to clear parked aircraft but the aircraft struck an automobile that was parked in front of a hangar and… - [NTSB CHI87LA122](https://openairdocs.org/ntsb/CHI87LA122.md): Cessna 152 · Footville, WI · Accident · No injuries · Limited investigation · Final report · May 5, 1987 · N49752 · Substantial damage > Pilot landed in a field to practice an emergency landing. After two unsuccessful attempts to takeoff from the soft, plowed field, the pilot taxiied onto a two-lane road. On lift off the left wing struck a road sign. - [NTSB ANC87LA065](https://openairdocs.org/ntsb/ANC87LA065.md): Lake LA-4-200 · North Pole, AK · Accident · No injuries · Limited investigation · Final report · May 4, 1987 · N65678 · Substantial damage > The pilot stated that shortly after lifting off the water the engine quit; the aircraft crashed on the gravel bar. The pilot also stated that he ran out of fuel. The plts flt time was not reported or available. - [NTSB NYC87LA139](https://openairdocs.org/ntsb/NYC87LA139.md): Robinson R-22B · Valatie, NY · Accident · No injuries · Limited investigation · Final report · May 2, 1987 · N2442A · Substantial damage > The Robinson R-22B took off from a open field, traveled 600 feet and struck suspended utility lines at approximately 25-30 ft. afterward, the helicopter was landed successfully. Other lines were approximately 1000 ft from the departure point. The pilot was… - [NTSB NYC87DHM02](https://openairdocs.org/ntsb/NYC87DHM02.md): Fokker DR-1 · Rhinebeck, NY · Accident · Serious injuries · Final report · May 2, 1987 · N2009R · Substantial damage > The plt was making his first takeoff in a Fokker DR-1 tri-plane. After becoming airborne he yawed right, then left, followed by the acft nose falling below the horizon. The acft was destroyed in the crash landing which followed. After the crash, the plt… - [NTSB MKC87LA099](https://openairdocs.org/ntsb/MKC87LA099.md): Piper PA-11 · Meade, KS · Accident · Minor injuries · Limited investigation · Final report · May 2, 1987 · N38687 · Substantial damage > After takeoff, the engine started losing power. During the turn toward a landing area, the airplane stalled, hit the ground to the right of the runway and flipped forward to the inverted position. A partial tear down inspection revealed that the intake valve… - [NTSB DEN87LA117](https://openairdocs.org/ntsb/DEN87LA117.md): Piper PA-36-375 · Lamar, CO · Accident · No injuries · Limited investigation · Final report · May 1, 1987 · N2335X · Substantial damage > The commercial plt was on takeoff from a dirt strip with a fully loaded ag acft, for an aerial application flt. After lifting off prematurely, the acft settled to the rwy. The left wing struck a post skidding the acft to the left. After crossing an irrigation… - [NTSB CHI87LA119](https://openairdocs.org/ntsb/CHI87LA119.md): Piper PA-38-112 · Kentland, IN · Accident · No injuries · Limited investigation · Final report · May 1, 1987 · N23781 · Substantial damage > Pilot reported a loss of power approx. 10 to 30 feet above the runway. The aircraft came to rest along the left side and approx. 1500 feet down the 3500-foot runway. Inspection of the aircraft after the accident did not reveal any evidence of engine problems.… - [NTSB ATL87DEG05](https://openairdocs.org/ntsb/ATL87DEG05.md): Enstrom F-28A · Wilmington, OH · Accident · No injuries · Final report · Apr 30, 1987 · N180Q · Substantial damage > During a climbout the pilot reported a power reduction. The engine continued operating and the rotor RPM dropped as the helicopter climbed to 10 feet. The wreckage examination failed to disclose any system malfunction or failures. The pilot was attempting to… - [NTSB MKC87FA094](https://openairdocs.org/ntsb/MKC87FA094.md): Piper PA-28-140 · Neelyville, MO · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1987 · N44213 · Destroyed > Witnesses stated that the p.I.c. had aborted several takeoff attempts while trying to depart to the north--the winds were originating from the southwest at approximately 5 mph. The aircraft eventually departed from, and almost used the full length of, runway… - [NTSB LAX87DVA07](https://openairdocs.org/ntsb/LAX87DVA07.md): Grumman G-164A · Tulare, CA · Accident · No injuries · Final report · Apr 29, 1987 · N8366 · Substantial damage > During a climbing 180 degree turn to the left, the engine lost power. The pilot attempted to land in a nearby field that had just been plowed. With insufficient altitude to turn FAR enough to line the aircraft up with the rows, the pilot touched down at a '20… - [NTSB DEN87LA114](https://openairdocs.org/ntsb/DEN87LA114.md): Piper PA-25 · Valley City, ND · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N6749Z · Substantial damage > The commercial pilot was trying out an acft with the stated intention of leasing it. A takeoff was planned from a stretch of gravel road. During the takeoff ground run, the acft became airborne then touched down in a field, bounced across an intersecting road… - [NTSB LAX87DUG03](https://openairdocs.org/ntsb/LAX87DUG03.md): Frimelt Werner Moni 164 · Lake Riverside, CA · Accident · Serious injuries · Final report · Apr 25, 1987 · N189L · Substantial damage > Just after take off of a homebuilt, experimental acft, a witness observed the acft at aprx 150 ft AGL initiate a 15 deg turn to the right. Immediately thereafter the acft pitched down slightly and began to lose altitude, then abruptly entered a spin and… - [NTSB CHI87LA117](https://openairdocs.org/ntsb/CHI87LA117.md): Cessna 172P · Terre Haute, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 25, 1987 · N51881 · Substantial damage > Aircraft stalled on takeoff during an instructional flight. No malfunctions or mechanical problems were reported by either pilot. Witnesses reported that the engine sounded smooth but did not seem to be developing full power. Inspection of aircraft after the… - [NTSB ATL87FA123](https://openairdocs.org/ntsb/ATL87FA123.md): Swearingen SA-226TC · Wilmington, NC · Accident · 2 fatal · Field investigation · Final report · Apr 23, 1987 · N505LB · Destroyed > The right engine failed during takeoff immediately after rotation 3000' down the 7,002' rwy 16. The plt continued the flt and the landing gear remained extended. The unauthorized plt rated pax made xmissions to the tower. Witnesses rpted that the acft reached… - [NTSB ATL87DEG04](https://openairdocs.org/ntsb/ATL87DEG04.md): Mclane Moni · Hillsboro, OH · Accident · Minor injuries · Final report · Apr 22, 1987 · N329RM · Substantial damage > Aft tkof fm the 3520 foot rwy, the plt stated that at abt midpoint with approx 1700 ft of rwy remaining, the eng sputtered and stopped. He was able to restart it again but aft several seconds it stopped again and he could not restart it. The plt then devoted… - [NTSB DEN87FA110](https://openairdocs.org/ntsb/DEN87FA110.md): Piper PA-23 · Craig, CO · Accident · Serious injuries · Field investigation · Final report · Apr 21, 1987 · N3231P · Substantial damage > The plt and his wife were on a cross country flt to visit relatives in north carolina. Several witnesses observed the aircraft depart Craig-moffet airport with the engine(s) running rough and using almost the entire runway to get airborne. Once airborne the… - [NTSB LAX87LA184](https://openairdocs.org/ntsb/LAX87LA184.md): Piper PA-24-250 · Catalina, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 1987 · N5596P · Substantial damage > Just after takeoff, the plt stated that he heard a loud bang. The acft began to vibrate severely with the engine developing partial power. The acft would not climb and the plt was able to maintain 100 fpm descent. Unable to return to the arpt, the plt ditched… - [NTSB DEN87LA105](https://openairdocs.org/ntsb/DEN87LA105.md): Cessna TR182 · Santa Rosa, NM · Accident · No injuries · Limited investigation · Final report · Apr 20, 1987 · N9145R · Substantial damage > An a & p acft mechanic who additionally was a commercial plt was operating a borrowed acft on a local flt. He landed on an island in a lake and shut down. Later, when airborne on takeoff, the right elevator struck a small tree and the acft yawed right. The… - [NTSB LAX87LA182](https://openairdocs.org/ntsb/LAX87LA182.md): Piper PA-32-300 · Lincoln, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 1987 · N15259 · Substantial damage > The aircraft collided with a ditch after a loss of pwr during t/o climb at aprx 350 to 400 ft AGL. The plt described the loss of pwr as 'like taking the throttle and pulling off in a rapid motion.' He noticed during his preflt check that the fuel in the right… - [NTSB CHI87DET03](https://openairdocs.org/ntsb/CHI87DET03.md): Jagger Tierra II · Columbia City, IN · Accident · Serious injuries · Final report · Apr 19, 1987 · N5541C · Substantial damage > Shortly after takeoff at about 100 feet AGL the engine lost power. The aircraft stalled and impacted the ground in a plowed area adjacent to the runway. The owner/pilot stated that an unidentified substance almost totally blocked the fuel filter closest to… - [NTSB LAX87LA181](https://openairdocs.org/ntsb/LAX87LA181.md): Grumman AA1C · Redlands, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1987 · N9545U · Destroyed > During an instructional flight, the plt stated that the estimated fuel capacity in the acft was aprx 12 gals prior to departure. The plt took-off on the right fuel tank and flew in the local area for aprx 15 minutes then returned to the arpt for touch-and-go… - [NTSB DEN87LA107](https://openairdocs.org/ntsb/DEN87LA107.md): Bell 206L-3 · Denver, CO · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N38886 · Substantial damage > An ATP plt was conducting a sight seeing flt over Denver. The plt had 9 hours total time in this model helicopter, 6 hours as PIC. A hovering takeoff was initiated to the north with left turn to the west after takeoff. Current winds were reported from 220… - [NTSB DEN87LA104](https://openairdocs.org/ntsb/DEN87LA104.md): Devore Sunbird 100 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N100VL · Substantial damage > An experimental designed prototype acft was being flown on its first flt. The acft took off and flew in ground effect beyond the arpt boundary. At full pwr, the acft could not maintain altitude and descended uncontrolled to an impact with the terrain. The… - [NTSB DEN87FA103](https://openairdocs.org/ntsb/DEN87FA103.md): Cessna 172 M · Ellicott, CO · Accident · 1 fatal · Field investigation · Final report · Apr 18, 1987 · N64415 · Destroyed > The acft was equipped with hand operated rudder controls. The plt had an artificial rt leg. On a previous flt that day the plt had attempted to spin the acft but was unsuccessful due to lack of rudder travel with the hand-operated controls. The plt was not… - [NTSB CHI87DEE08](https://openairdocs.org/ntsb/CHI87DEE08.md): Bede BD5 A-B · Kankakee, IL · Accident · 1 fatal · Final report · Apr 18, 1987 · N501RM · Destroyed > The pilot took off on the first test flight in his homebuilt aircraft and after climbing to approximately 1000 ft. AGL, stalled the aircraft. The aircraft then subsequently entered a spin and collided with the ground. There were reports of the aircraft's… - [NTSB FTW87LA095](https://openairdocs.org/ntsb/FTW87LA095.md): Cessna 182Q · Midland, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1987 · N95610 · Substantial damage > On April 15, 1987, at approximatly 1910 CDT, the private pilot of a Cessna 182Q attempted to land on a 2650 ft dirt runway near Midland, TX. Witness stated she landed long and fast. The brakes failed due to a pre-existing crack in the left brake line. The… - [NTSB NYC87FA124](https://openairdocs.org/ntsb/NYC87FA124.md): Bellanca 8KCAB · New Milford, CT · Accident · 2 fatal · Field investigation · Final report · Apr 15, 1987 · N377SW · Destroyed > After taking off on runway 16 at the candlelight farms airport, the flight remained low over the runway while gaining airspeed. As the aircraft approached the upwind end of the runway, witnesses observed it enter a steep climb that continued to an estimated… - [NTSB LAX87LA175](https://openairdocs.org/ntsb/LAX87LA175.md): Beech C35 · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1987 · N271F · Substantial damage > The plt stated he had flown the acft the day prior to the accident on the left fuel tank only. No fuel had been added on the day of the accident and the plt stated that the left tank was three quarters full and the right tank was full. The plt positioned the… - [NTSB NYC87FA121](https://openairdocs.org/ntsb/NYC87FA121.md): Cessna 402C · Hyannis, MA · Accident · Minor injuries · Field investigation · Final report · Apr 12, 1987 · N87PB · Destroyed > Shortly after the initial pwr reduction drg tkof, the plt noted a partial loss of pwr in the rgt eng. He said he 'went to full power on both engines' & noted an 'extremely high' fuel flow indcn to the rgt eng. He said, 'thinking that the engine was flooding,… - [NTSB FTW87LA094](https://openairdocs.org/ntsb/FTW87LA094.md): Piper PA-25 · Jackson, LA · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1987 · N6166Z · Substantial damage > Engine failed due to fuel exhaustion. Aircraft collided with trees short of rwy 33. - [NTSB ATL87FA111](https://openairdocs.org/ntsb/ATL87FA111.md): Aeronca 7AC · Sharpsburg, GA · Accident · 1 fatal · Field investigation · Final report · Apr 12, 1987 · N1823E · Destroyed > Plt dep a pvt grass airstrip for a LCL VFR flt. Acft was observed to lift off the grass rwy at about 1000 ft. it climbed to about 30 ft AGL and leveled off. At about the end of the 1800 ft rwy the acft nosed up into a 'fairly steep' climb attitude. The ground… - [NTSB NYC87FA119](https://openairdocs.org/ntsb/NYC87FA119.md): Cessna 172N · Ferguson Twnshp, PA · Accident · 4 fatal · Field investigation · Final report · Apr 11, 1987 · N5535E · Destroyed > The pilot, who had not completed his checkout in a Cessna 172, was observed to make a long landing and lift off with approximately 750 ft of runway remaining. The aircraft was observed to enter a nose high pitch attitude and drift into a right turn. The… - [NTSB SEA87LA077](https://openairdocs.org/ntsb/SEA87LA077.md): Ercoupe 415-C · Scott Mills, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1987 · N3258H · Destroyed > With a gusting crosswind from the left the pilot allowed the student pilot to make the take off. The student pilot rotated prematurely and the aircraft weathercocked to the left. The pilot then took the controls of the aircraft but by then it was pointed 90… - [NTSB MKC87LA076](https://openairdocs.org/ntsb/MKC87LA076.md): Cessna 172 · Muscatine, IA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N79179 · Destroyed > The grass runway was 1300 feet long. The wind was 90 degrees cross at 5 knots, gusts to 20 KTS. The instructor said they had a wind shift and then they hit a soft spot near the end of the runway which slowed them. The elevator and stabilizer caught on a… - [NTSB LAX87LA194](https://openairdocs.org/ntsb/LAX87LA194.md): Stinson 108 · Healdsburg, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 1987 · N9216K · Substantial damage > During what was supposed to be a taxi test, the plt decided to takeoff when he lost control of the acft. The acft veered to the right off the rwy and collided with the terrain. The plt had flown the acft for the first time with the owner the day before the… - [NTSB LAX87LA168](https://openairdocs.org/ntsb/LAX87LA168.md): Balloon Works Firefly 8-24 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 1987 · N3750D · No damage > During a pleasure Balloon ride, the Balloon lifted off in a southerly direction then shifted to a south easterly direction. The plt felt that the balloons response time for adequate lift took too long. The Balloon began drifting toward 50 to 60 ft power… - [NTSB ANC87LA058](https://openairdocs.org/ntsb/ANC87LA058.md): Piper PA-18 · Valdez, AK · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N9073D · Substantial damage > The pilot reported that he could not keep the ski equipped aircraft from banking to the left after take off and elected to reduce power and land. The aircraft sustained substantial damage when the left wing tip struck the ground and cartwheeled during the… - [NTSB MKC87LA075](https://openairdocs.org/ntsb/MKC87LA075.md): Beech 35A · Liberal, KS · Accident · No injuries · Limited investigation · Final report · Apr 4, 1987 · N1953V · Substantial damage > The PIC rptd experiencing turbulence on takeoff from Liberal airport. Winds were prevailing from the southeat at 15 knots as he departed the airstrip using runway 19. At rotation, the PIC reported that the left wing got too high and he lost control. The PIC… - [NTSB SEA87LA128](https://openairdocs.org/ntsb/SEA87LA128.md): Mooney M20F · Grants Pass, OR · Accident · No injuries · Limited investigation · Final report · Apr 3, 1987 · N6901V · Substantial damage > Shortly after takeoff the pilot realized that he had no airspeed indication due to his forgetting to remove the pitot cover during preflight. The pilot returned to land at the airport and landed gear up. - [NTSB DEN87FA081](https://openairdocs.org/ntsb/DEN87FA081.md): Piper PA-22-150 · Morgan, UT · Accident · Serious injuries · Field investigation · Final report · Apr 3, 1987 · N3809P · Destroyed > The plt departed Morgan arpt with an acft near gross weight, in a relatively strong cross wind. After a successful takeoff at about 100 AGL, he said he encountered moderate turbulence and a downdraft. Altitude and airspeed could not be maintained. The acft… - [NTSB MIA87LA123](https://openairdocs.org/ntsb/MIA87LA123.md): Cessna A150M · Jackson, MS · Accident · No injuries · Limited investigation · Final report · Apr 1, 1987 · N7344A · Substantial damage > The plt stated that he failed to remove the control column gust lock prior to take off. Immediately after rotation, the acft began to porpoise, descended uncontrolled, & landed hard collapsing the landing gear. He further stated that this accident could have… - [NTSB LAX87DVM02](https://openairdocs.org/ntsb/LAX87DVM02.md): Bowers Flybaby 1A · San Luis Obispo, CA · Accident · Serious injuries · Final report · Mar 31, 1987 · N792JB · Substantial damage > During a pleasure flt in an experimental acft, during the takeoff roll, the eng sputtered, however, the plt continued the flt. After takeoff at aprx 30 ft the eng sputtered again. The plt made a sharp 45 deg turn which put him on downwind, however, the acft… - [NTSB FTW87FA087](https://openairdocs.org/ntsb/FTW87FA087.md): Piper PA-28-140 · Leakey, TX · Accident · Serious injuries · Field investigation · Final report · Mar 31, 1987 · N4602R · Substantial damage > Flight instructor and student pilot flying Piper PA-28-140 departed uncontrolled airport after switching fuel tanks on runway. Fuel selector valve was inadvertently moved to off position by student pilot. Aircraft engine quit on initial climb at approximately… - [NTSB DCA87MA023](https://openairdocs.org/ntsb/DCA87MA023.md): Cessna 172N · Oakland, CA · Accident · 3 fatal · Class 1 · Major · Final report · Mar 31, 1987 · N75584 · 2 aircraft · Destroyed > At 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn… - [NTSB ATL87FA101](https://openairdocs.org/ntsb/ATL87FA101.md): Beech A36 · Dalton, GA · Accident · Serious injuries · Field investigation · Final report · Mar 30, 1987 · N6170U · Destroyed > On t/o at 1st power change PIC noted loss of performance. He turned left to downwind leg for landing. PIC and ground witnesses said eng quit and acft crashed into trees and ground. Post crash fire destroyed acft. PIC rpted taking fuel sample before t/o with… - [NTSB DEN87LA075](https://openairdocs.org/ntsb/DEN87LA075.md): Aeronca 7AC · Columbus, MT · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N6050V · Substantial damage > A pre-solo student and CFI were practicing landings. The CFI reduced pwr on climbout at 300 to 400 feet. During the discussion of what to do in case of lost pwr on takeoff, the student executed a steep, 180 degree turn, toward the arpt. The acft stalled, and… - [NTSB CHI87FA133](https://openairdocs.org/ntsb/CHI87FA133.md): Beech V35-TC · Mount Vernon, IL · Accident · 1 fatal · Field investigation · Final report · Mar 28, 1987 · N2820S · Destroyed > The acft was on a test flt after a top-overhaul had just been completed. Mechanics rprtd that before the flt, the eng had been properly rigged & operated normally drg run-up. Drg initial climb after takeoff, witnesses said the eng lost power. The plt… - [NTSB LAX87LA163](https://openairdocs.org/ntsb/LAX87LA163.md): Piper PA-28-235 · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N9306W · Substantial damage > After take-off, the pilot was flying a downwind departure when the engine quit. The pilot was unable to return to the runway and collided with the terrain a half mile from the airport. Inspection of the engine at the time of the accident found that the main… - [NTSB FTW87DPJ05](https://openairdocs.org/ntsb/FTW87DPJ05.md): de Havilland DHC-1B-2S5 · Claremore, OK · Accident · Serious injuries · Final report · Mar 27, 1987 · N320HP · Destroyed > Mud daubers plugged the fuel tank vents resulting in fuel starvation and engine failure. The acft received substantial damage during the forced lndg and the plt was seriously injured. Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=171 ## 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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=170 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.