# 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 183 of 412 · 20,559 cases ## Cases, newest first - [NTSB ATL85LA244](https://openairdocs.org/ntsb/ATL85LA244.md): Cessna A188B · Benton, MS · Accident · No injuries · Limited investigation · Final report · Aug 10, 1985 · N731TS · Substantial damage > The plt attempted to takeoff on the rwy a during takeoff ground run the acft lifted off prematurely and stalled into high vegetation. The plt stated that the grass on the runway should have been cut before it got too tall. - [NTSB MKC85LA178](https://openairdocs.org/ntsb/MKC85LA178.md): Boeing E75 · Fairfield, IA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1985 · N3994B · Substantial damage > A Beech baron departed just prior to N3994B. N3994B was heavily loaded and encountered turblence after lifting off. The acft drifted to the rt until it was over a corn field about 100 ft to the rt of the rwy. The plt tried to correct back to the rwy but the… - [NTSB LAX85LA343](https://openairdocs.org/ntsb/LAX85LA343.md): North American F-51D · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Aug 6, 1985 · N6175C · Substantial damage > The private plt attempted to make his first, solo, take off in the F-51D model acft. The acft became airborne & immediately attained a noise high pitch attitude. The angle of attack was then reduced & the acft bounced hard off the rwy blowing out its right… - [NTSB FTW85LA304](https://openairdocs.org/ntsb/FTW85LA304.md): Cessna 172 M · Arcadia, LA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1985 · N5045H · Substantial damage > The plt stated he heard a 'boom' and experienced a partial power loss when he was about 10 ft above the rwy during the initial takeoff climb. He was about half way down the 3000 foot rwy at this time. He aborted the takeoff and landed. However, he was not… - [NTSB NYC85FNE02](https://openairdocs.org/ntsb/NYC85FNE02.md): Earl F. Folsom Sonerai II · Waterbury, CT · Accident · No injuries · Final report · Aug 2, 1985 · N27EF · Substantial damage > The homebuilt sonerai ii made an off airport landing 3 minutes after takeoff. The aircraft received substantial damage and the sole occupant was uninjured. Post crash examination of the aircraft showed the fuel tank was empty. However, there was fuel in the… - [NTSB NYC85FGM05](https://openairdocs.org/ntsb/NYC85FGM05.md): James Postlewait RV-4 · Zelienople, PA · Accident · 2 fatal · Final report · Aug 2, 1985 · N85JP · Destroyed > A witness reported that when the acft was departing, the takeoff run & beginning of the climb appeared to be normal. However, at about 300 to 400 ft AGL, the left wing dropped & the acft pivoted to the left, then the plane crashed in a steep nose down… - [NTSB LAX85LA333](https://openairdocs.org/ntsb/LAX85LA333.md): Cessna 150E · Sonoma, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 1985 · N6284T · Destroyed > During a dual instructional flight the student plt practiced a full stop ldg followed by a take off. On initial climb all eng power was suddenly lost. When the CFI took over the controls & maneuvered the acft for an emergency ldg, the eng momentarily coughed… - [NTSB ANC85LA139](https://openairdocs.org/ntsb/ANC85LA139.md): Piper PA-18 · Kustatan River, AK · Accident · No injuries · Limited investigation · Final report · Jul 31, 1985 · N1104N · Substantial damage > The plt reported that he landed the float plane on the Kustatan River to fish. Later, when he was departing, he selected an area that required negotiating a turn on the step. He reported that there was a 10 to 12 knot headwind that became a quartering… - [NTSB DEN85LTG06](https://openairdocs.org/ntsb/DEN85LTG06.md): Bell 47G-4A · Minot, ND · Accident · No injuries · Final report · Jul 30, 1985 · N1041B · Substantial damage > The plt was engaged by a deputy sheriff to fly the helicopter about 2-1/2 mi to the Minot intl arpt for impoundment. During takeoff, it began climbing, then the plt lost control & the helicopter entered a descent & crashed. Initial impact occurred about 35 ft… - [NTSB CHI85FEV01](https://openairdocs.org/ntsb/CHI85FEV01.md): Larry Schindler Midget MUSTANG-1 · Paxton, IL · Accident · 1 fatal · Final report · Jul 30, 1985 · N28LS · Destroyed > The acft pitched up at about 100 ft AGL after takeoff. After a rt & left turn the acft pitched down and struck the ground left wing down at about a 30 degree angle. No evidence was found to indicate a failure or malfunction of the acft or components.… - [NTSB MKC85LA172](https://openairdocs.org/ntsb/MKC85LA172.md): Piper PA-28-140B · Minden, NE · Accident · No injuries · Limited investigation · Final report · Jul 29, 1985 · N98193 · Substantial damage > Plt said that he was unable to clear wires at the end of the 2,100 ft long, sod, farm, strip. He said he began truning to avoid the wires and in the turn the acft settled, the rt wing hit the ground and the acft crashed. The acft weight was near max allowable… - [NTSB FTW85FA300](https://openairdocs.org/ntsb/FTW85FA300.md): S.N.I.A.S. AS350D Astar · Houma, LA · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1985 · N3607C · Destroyed > The plt landed at a microwave antenna tower and did not shut down the eng or deplane. An employee at the tower retrievedcargo from the helicopter (a small box of parts) and went back inside the tower building. Shortly thereafter, the plt apparently initiated… - [NTSB FTW85LA299](https://openairdocs.org/ntsb/FTW85LA299.md): Beech 35-B33 · Alpine, TX · Accident · No injuries · Limited investigation · Final report · Jul 28, 1985 · N7935K · Substantial damage > The plt experienced a partial pwr loss when about 50 ft above the rwy, just after liftoff. The acft was about 300 ft down the rwy with some rwy still remaining. He landed the acft but was unable to stop until the acft had run through the perimeter fence. It… - [NTSB SEA85LA183](https://openairdocs.org/ntsb/SEA85LA183.md): Cessna T-188C · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1985 · N1964J · Substantial damage > The pilot elected to depart an 1800 foot gravel airstrip with a 90 degrdd f temperature. The density altitude was about 3100 feet. The aircraft was heavily loaded, approaching gross weight. The pilot made the decision during the last 1/3 of the runway to… - [NTSB SEA85LA179](https://openairdocs.org/ntsb/SEA85LA179.md): Luscombe 8A · Yamhill, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1985 · N1035K · Destroyed > The eng ceased operating at aprx 40 ft AGL during initial takeoff climb. Investigation disclosed the acft had been fueled with a mixture of automotive fuel and 80/87 avgas. The acft had sat on the ground for over 4 hrs with a surface tem of 95 degs f. a… - [NTSB CHI85LA328](https://openairdocs.org/ntsb/CHI85LA328.md): Piper PA-28-140 · Lakewood, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1985 · N7183R · Substantial damage > The student plt and his pax had landed on an airstrip on a golf course. On takeoff the student plt lifted off early and stalled back on the turf. He then lost directional control, veered off the airstrip and struck a golfer in the back with the outer section… - [NTSB ATL85FA224](https://openairdocs.org/ntsb/ATL85FA224.md): Aero Commander 680-FP · Chesapeake, OH · Accident · 1 fatal · Field investigation · Final report · Jul 27, 1985 · N100HA · Destroyed > As near as can be determined, this was the plt's second flt since obtaining his multi engine rating and third flt since obtaining his com'l plt certificate from a designated p.e. the acft was observed to depart lawrence co. arpt and upon reaching a point over… - [NTSB LAX85LA330](https://openairdocs.org/ntsb/LAX85LA330.md): Huff Sonerai IIL · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Jul 26, 1985 · N4422P · Substantial damage > The plt reptd that during the takeoff off roll, he applied back pressure to the control stick when the acft reached 60 knots. The aircraft began an immediate climb at a steep angle, stalled and crashed on to the rwy. This was the initial flight for this… - [NTSB DEN85LA201](https://openairdocs.org/ntsb/DEN85LA201.md): Cessna U206 · Greystone, CO · Accident · No injuries · Limited investigation · Final report · Jul 26, 1985 · N9675G · Substantial damage > The plt lost control of the acft during an attempted takeoff from a 7000 ft gravel road. The takeoff was being made to the north-northeast and the plt reported winds were from 180 degs at 10 KTS gusting to 15 KTS. The acft veered left, contacted a tree and… - [NTSB FTW85LA298](https://openairdocs.org/ntsb/FTW85LA298.md): Air Tractor AT301 · Bonita, LA · Accident · No injuries · Limited investigation · Final report · Jul 25, 1985 · N23257 · Substantial damage > The plt stated he was the second of two acft in a formation takeoff and he encountered severe wake turbulence from the other acft (same type). He stated that he dumped his load of chemicals but could not get above the pwr curve and the acft settled into a… - [NTSB DEN85LA199](https://openairdocs.org/ntsb/DEN85LA199.md): Beech 58P · Buena Vista, CO · Accident · No injuries · Limited investigation · Final report · Jul 25, 1985 · N6039S · Substantial damage > The left engine failed during takeoff at an altitude of about 40 ft AGL. During the forced landing, the plt used incorrect emergency procedures and failed to maintain lateral and directional control of the acft. Inspection of the acft revealed a disintegrated… - [NTSB MKC85LA166](https://openairdocs.org/ntsb/MKC85LA166.md): James Gress Quickie · Fenton, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 1985 · N32JG · Substantial damage > While taking off, the plt noted a partial loss of eng power during the initial climb. He was unable to maintain alt & tried to maneuver around trees near the departure end of the rwy. However, the acft descended into the tree tops, then crashed onto the roof… - [NTSB LAX85FA325](https://openairdocs.org/ntsb/LAX85FA325.md): Cessna 150L · Goleta, CA · Accident · 2 fatal · Field investigation · Final report · Jul 23, 1985 · N11490 · Destroyed > At 0242 PDT, the student plt tried to call the tower for a radio check. The tower was closed, but a fss specialist heard the transmission & provided advisories. Subsequently, the student plt took off with a passenger aboard. Shortly, after takeoff, the acft… - [NTSB LAX85FA328](https://openairdocs.org/ntsb/LAX85FA328.md): Cessna 150G · Columbia, CA · Accident · 2 fatal · Field investigation · Final report · Jul 22, 1985 · N2209J · Destroyed > On July 21, 1985 at about 2115 hours p.d.t., Cessna 150, N2209J, registered to laurence p. thompson, auburn, California,and operated by sunshine flyers, inc., auburn, California, crashed after colliding with some trees about 1 mile north northwest of Columbia… - [NTSB CHI85LA306](https://openairdocs.org/ntsb/CHI85LA306.md): Cessna 120 · Hart, MI · Accident · No injuries · Limited investigation · Final report · Jul 22, 1985 · N2785N · Substantial damage > The pilot on the return leg of a x.country flt failed to visually check his fuel supply and selected an empty tank for takeoff. On liftoff the engine stopped and the pilot attempted to ld on the remaining 300 ft of runway. After touchdown the acft veered off… - [NTSB NYC85FNC06](https://openairdocs.org/ntsb/NYC85FNC06.md): Piper PA-11 · Moultonboro, NH · Accident · Serious injuries · Final report · Jul 21, 1985 · N4810M · Destroyed > The 65 HP acft took off from a cove and during a turn at about 150 ft AGL the acft nosed dwn after rolling rt. The acft struck the water in a steep nose down attitude. According to witnesses, the bng was running normally during the climb and descent. No… - [NTSB MKC85LA163](https://openairdocs.org/ntsb/MKC85LA163.md): Cessna 182 · Forest City, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1985 · N5699B · Substantial damage > Shortly after the acft took off with 4 skydivers on board, its eng seized at an alt of about 300 to 400 ft. the plt selected the best available area to land which was a field of tall corn on rolling terrain. During the emerg landing, the acft nosed over.… - [NTSB MKC85LA162](https://openairdocs.org/ntsb/MKC85LA162.md): Cessna A188B · Indianola, NE · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N4848Q · Substantial damage > N4848Q was loaded to max gross wt and was taking off on a 2,350 ft, turf rwy. The plt said the wind was light and favored rwy 29 before takeoff. The density alt was about 2,500 ft. the plt said the acft did not seem to be developing quite the power it should… - [NTSB ATL85FLT09](https://openairdocs.org/ntsb/ATL85FLT09.md): Cessna 152 · Memphis, TN · Accident · Serious injuries · Final report · Jul 20, 1985 · N89634 · Destroyed > The acft nosed over during a forced landing following a loss of pwr. Purpose of the flt was to practice night takeoffs and landings. On the fifth takeoff, at aprx 200 ft AGL, a total loss of pwr was experienced. The acft contacted an embankment during the… - [NTSB CHI85LA299](https://openairdocs.org/ntsb/CHI85LA299.md): Piper PA-28-140 · Big Falls, MN · Accident · No injuries · Limited investigation · Final report · Jul 19, 1985 · N5279S · Substantial damage > The plt diverted into the Big Falls arpt because his original destination was below VFR minimums. After checking the sod runway for a firmness & determining a go/no go point, he subsequently took off using soft field techniques. His rotation was well in… - [NTSB ATL85FA221](https://openairdocs.org/ntsb/ATL85FA221.md): Cessna 421C · Kennesaw, GA · Accident · 1 fatal · Field investigation · Final report · Jul 19, 1985 · N5473G · Destroyed > The acft lost power on # 2 eng shortly after take-off. The acft crashed and burned in a wooded area several miles sw of the arpt. The # 2 eng was severly damaged in the fire. No pre-impact malfunction could be documented. Examination of the prop did not… - [NTSB ANC85LA132](https://openairdocs.org/ntsb/ANC85LA132.md): Piper PA-18-150 · Mccarthy, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 19, 1985 · N1109A · Destroyed > The pilot-in-command was departing from a 600 foot long airstrip at a 3400 foot field elevation. The takeoff run was downslope and the pilot had to pull the airplane off the ground by use of the control stick and the application of full flaps, the 40 degree… - [NTSB NYC85LA178](https://openairdocs.org/ntsb/NYC85LA178.md): Cessna C172 · Ellington, CT · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1985 · N98651 · Substantial damage > The acft collided with the ground during takeoff from rwy 01 at Ellington, Connecticut, and was substantially damaged but there was no fire. The pilot received minor injuries. The aircraft crashed for undetermined reasons. - [NTSB CHI85LA302](https://openairdocs.org/ntsb/CHI85LA302.md): Beech E18S · Youngstown, OH · Accident · No injuries · Limited investigation · Final report · Jul 18, 1985 · N51W · Substantial damage > During initial climb, the plt noted a vibration. He was unable to identify the source & elected to land gear up on the remaining rwy. An exam of the acft revealed that the stick shaker sys had been activated by an electrical problem in the left eng nacelle… - [NTSB FTW85LA290](https://openairdocs.org/ntsb/FTW85LA290.md): Cessna 177B · Guthrie, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1985 · N20164 · Destroyed > The plt stated he lost eng power shortly after takeoff and during initial climb. He elected to go into the trees due to lack of altitude to allow a more suitable landing area. An eng examination disclosed that the no. four exhaust valve was stuck open due to… - [NTSB ANC85LA129](https://openairdocs.org/ntsb/ANC85LA129.md): Hughes H-269B · Northway, AK · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N9434F · Substantial damage > The pilot stated he departed and after liftoff began losing power. He attempted to make adjustments when the engine changed sound distinctively to a reduced power. He attempted landing on a downslope and touched down with 5 to 10 knots of forward speed. Upon… - [NTSB ATL85FMG05](https://openairdocs.org/ntsb/ATL85FMG05.md): Fain Evans VP-1 · Statesville, NC · Accident · 1 fatal · Final report · Jul 16, 1985 · N74VP · Destroyed > The unregistered expired certificated newly purchased experimental acft was being flown by the student plt owner on his 1st flt in the acft. The acft was seen to takeoff and make a right turn after which it descended into tall trees. Witness reported hearing… - [NTSB FTW85FA287](https://openairdocs.org/ntsb/FTW85FA287.md): Bell 206L-1 · Saginaw, TX · Accident · Serious injuries · Field investigation · Final report · Jul 15, 1985 · N32GT · Destroyed > The helicopter had landed in the road to pick up an injured auto accident patient. The plt made an aerial check prior to landing to the west in a calm wind condition. The patient was loaded in a secure stretcher and all was ready for liftoff. The plt stated… - [NTSB MKC85LA154](https://openairdocs.org/ntsb/MKC85LA154.md): Cessna 170A · Camdenton, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1985 · N5593C · Substantial damage > N5593C took off on rwy 25 which has a hill off the west end. The wind was from the west at 10 to 13 knots and the temperature was 95 deg f. the plt said the acft encountered a downdraft as it approached the hill during the initial climb. The plt became… - [NTSB DEN85LA188](https://openairdocs.org/ntsb/DEN85LA188.md): Piper PA-32R-301T · Glen Canyon, UT · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N8409V · Substantial damage > The plt said that during the takeoff roll at night from an unlit runway, he was distracted when the engine overboost light illuminated. The investigation revealed, however, that the plt was actually trying to avoid colliding with an airplane at the other end… - [NTSB BFO85LA058](https://openairdocs.org/ntsb/BFO85LA058.md): Piper PA-24-260 · Middletown, DE · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1985 · N8577P · Substantial damage > Following takeoff, at about 350 feet AGL, the engine quit abruptly. The plt attempted to land in a field which was located about 15 degrees east of the acft's heading. While attempting to avoid pwr lines near the field, the right wing collided with the wires.… - [NTSB DEN85LQA01](https://openairdocs.org/ntsb/DEN85LQA01.md): Petracca Glasair SH-2 · Aztec, NM · Accident · No injuries · Final report · Jul 10, 1985 · N272CP · Substantial damage > The acft sustained substantial damage after it stalled and contacted the ground during takeoff. Plt stated lift off was made with minimal airspeed and the right wing dropped shortly after becoming airborne. Plt overcorrected for the right bank, the acft… - [NTSB ANC85FA124](https://openairdocs.org/ntsb/ANC85FA124.md): Cessna A-185F · Elmendorf Afb, AK · Accident · Minor injuries · Field investigation · Final report · Jul 10, 1985 · N61155 · Substantial damage > Immediately after takeoff from a lake the acft stalled, did a half spin & nosed into the water. Witnesses reported seeing acft nose pitching up & down & wings wobbling just prior to the stall. This was plt's first flt in this type acft without an instructor.… - [NTSB ATL85LA209](https://openairdocs.org/ntsb/ATL85LA209.md): William G. Cloaninger VARI-EZE · Albemarle, NC · Accident · No injuries · Limited investigation · Final report · Jul 9, 1985 · N450Z · Substantial damage > During the initial climb after takeoff, the eng lost power as the plt made a left turn. He tried to glide back to the rwy, but was unable. The acft was landed in a field about 300 yds short of the rwy. During the landing, all 3 gear were torn off the acft,… - [NTSB ATL85LA208](https://openairdocs.org/ntsb/ATL85LA208.md): Cessna T303 · Shelby, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1985 · N9718T · Destroyed > The plt stated that after takeoff from rwy 23, he noticed oil coming from the left eng. He initiated a turn to land on rwy 05 but was unable to line up with the rwy. He elected to go-around and when he added full power the left eng oil pressure went to zero… - [NTSB LAX85LA308](https://openairdocs.org/ntsb/LAX85LA308.md): Cessna 172 · Vacaville, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1985 · N1280F · Substantial damage > Witnesses stated that, on departure, the aircraft climbed to about 50 feet, appeared to stall, and crashed on the runway. The winds were reported as gusty, from 15 to 22 knots, and the temperature was about 95 degrees. - [NTSB BFO85LA053](https://openairdocs.org/ntsb/BFO85LA053.md): Schweizer 2-33A · Warrenton, VA · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1985 · N65818 · Substantial damage > After liftoff both the PIC and the plt getting checked out in the Schweizer sgs 2-33A stated that they encountered moderate turbulence in the area. When the sailplane reched approximately 200 ft AGL the tom rope separated from the aircraft and N65818 was… - [NTSB ATL85FKG07](https://openairdocs.org/ntsb/ATL85FKG07.md): Lett Varieze · Sylacauga, AL · Accident · Serious injuries · Final report · Jul 7, 1985 · N55VE · Substantial damage > The acft contacted a pick-up truck on a highway during a forced landing following a loss of power shortly after takeoff. Post accident inspection of the acft disclosed that the fuel vent line was severly packed (blocked) with mud dobber material. - [NTSB ANC85LA120](https://openairdocs.org/ntsb/ANC85LA120.md): Piper PA-14 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jul 7, 1985 · N4292H · Substantial damage > The plt aborted his 1st attempt to takeoff due to boat & water ski activity. He back taxied & began a 2nd attempt on rough water. The acft became airborne at about the middle of the lake. It stopped climbing when the plt began to raise the flaps, so he… - [NTSB MIA85IA208](https://openairdocs.org/ntsb/MIA85IA208.md): Cessna 402 · West Palm Bch, FL · Incident · No injuries · Incident investigation · Final report · Jul 5, 1985 · N68368 · 2 aircraft · No damage > A Learjet 35 was cleared on to runway 09L and hold, the Learjet crew confirmed with the air traffic control tower personnel that te transmission was intended for them and taxied into position and held. Personnel on duty in the control tower then cleared a… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=184 ## 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=183 --- 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.