# NTSB investigations: Takeoff

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 154 of 281 · 14,038 cases

## Cases, newest first

- [NTSB ANC83LA132](https://openairdocs.org/ntsb/ANC83LA132.md): Cessna A185E · Tyonek, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1983 · N4535F · Substantial damage
  > According to the pilot, during takeoff at rotation the floats struck a sandbar. He lost control of the aircraft and it nosed over in the water.
- [NTSB SEA83LA158](https://openairdocs.org/ntsb/SEA83LA158.md): Bensen B8M · Wenatchee, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 1983 · N2279C · Destroyed
  > Reportedly, the plt had received 7 hrs of dual instruction in the benson gyrocopter. He had been observed taxiing the acft on an unused portion of the arpt during the winter months of 1982 & 1983. However, no flts were observed & the student plt had no…
- [NTSB SEA83LA156](https://openairdocs.org/ntsb/SEA83LA156.md): Finamore KR-2 · Hillsboro, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1983 · N3382F · Substantial damage
  > The acft lost power at about 100 ft AGL during takeoff. The pilot made a forced landing straight ahead into a grain field. The high vegetation caused enough drag on the landing gear to nose the acft over. Examination of the engine revealed that the high…
- [NTSB FTW83LA345](https://openairdocs.org/ntsb/FTW83LA345.md): Cessna A185F · Houma, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1983 · N4959Q · Destroyed
  > The acft had previously been submerged in water. After it was salvaged & repaired, a ferry permit was obtained to fly it to amarillo, TX. According to a witness, the eng began running rough after the 1st 50 ft of the ground roll during takeoff. However. The…
- [NTSB FTW83LA341](https://openairdocs.org/ntsb/FTW83LA341.md): Cessna 152 · Whitewright, TX · Accident · No injuries · Limited investigation · Final report · Jul 20, 1983 · N46909 · Substantial damage
  > The acft collided with a fence and nosed over after the seat lock pin failed and the seat slid all the way to the rear. The plt was unable to reach the rudder pedals and the acft veered off the road being used as a rwy.
- [NTSB MKC83LA158](https://openairdocs.org/ntsb/MKC83LA158.md): Cessna 152 · Nebraska City, NE · Accident · No injuries · Limited investigation · Final report · Jul 18, 1983 · N714VP · Substantial damage
  > The student plt lost directional control during a takeoff on his 2nd solo flt. He reported that as he started the takeoff, the acft began moving to the left of the rwy, so he applied right rudder, but too much, then too much left rudder. Subsequently, the…
- [NTSB SEA83LA151](https://openairdocs.org/ntsb/SEA83LA151.md): Cessna 170B · Ellensburg, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1983 · N3033A · Substantial damage
  > The acft nosed over during an aborted takeoff. The pilot stated that the acft was subjected to a gusty tailwind just before takeoff and the acft started to skip and skid with the nose to the left. The pilot started abort procedures and said the tail of the…
- [NTSB ATL83FA282](https://openairdocs.org/ntsb/ATL83FA282.md): Piper PA-34-22OT · Atlanta, GA · Accident · No injuries · Field investigation · Final report · Jul 17, 1983 · N8387X · Substantial damage
  > The acft was on a takeoff roll when the left main and nose gear retracted. Investigation revealed a flt switch for the hobbs meter had been installed to automatically record only flt time when the switch was in the flt position. In this postion the hobbs…
- [NTSB CHI83LA316](https://openairdocs.org/ntsb/CHI83LA316.md): Cessna 188-B · Springfield, MN · Accident · No injuries · Limited investigation · Final report · Jul 16, 1983 · N21700 · Substantial damage
  > The acft crashed into a cornfield during a takeoff to spray crops. The pilot stated that there were no mechanical problems with the acft. Investigaiton showed that the pilot attempted a takeoff on rwy 31 with a 5 kt tailwind. The acftdid not become airborne.
- [NTSB NYC83LA178](https://openairdocs.org/ntsb/NYC83LA178.md): Champion 7GCBC · Canandaigua, NY · Accident · No injuries · Limited investigation · Final report · Jul 15, 1983 · N733MW · Substantial damage
  > The plt initiated a takeoff on a 1900 ft grass rwy with 2 notches of flaps. He stated that after lift-off, he had climbed 50 to 75, but was unsure whether or not he could clear the tops of the trees at the end of the rwy. He elected to abort, but was unable…
- [NTSB CHI83LA290](https://openairdocs.org/ntsb/CHI83LA290.md): Eipper MX-2 · Pylmouth, IN · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1983 · N38802 · Substantial damage
  > The acft was taking off for dual instruction when a gust of wind picked up the wing and the aircraft cartwheeled ending on the nose and rt. Wing. The instructor stated that as the acft accelerated a sudden gust of wind caught the acft from the left. The…
- [NTSB LAX83FVG14](https://openairdocs.org/ntsb/LAX83FVG14.md): Sikorsky S-58 · Biggs, CA · Accident · Serious injuries · Final report · Jul 14, 1983 · N9043P · Destroyed
  > The plt reported that he brought the helicopter to a hover in the loading area & eased forward to the rwy where he attempted to 'transition from a hover to flt.' He became aware that the helicopter was not going to have sufficient performance, so he elected…
- [NTSB DEN83LA164](https://openairdocs.org/ntsb/DEN83LA164.md): Cessna T188C · Carthage, SD · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N2060J · Substantial damage
  > The acft was using a county road near the field being sprayed for takeoff. The pilot reported that the herbicide sloshedout onto the windscreen during takeoff and obscured his vision. The acft veered right and entered the ditch. The pilot said the hopper lid…
- [NTSB FTW83LA330](https://openairdocs.org/ntsb/FTW83LA330.md): WSK PZL Mielec PZL-M-18 · Delaplaine, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1983 · N90135 · Substantial damage
  > The acft nosed over after running off the end of the rwy during takeoff. The plt had a heavy load of fertilizer and a passenger in the single seat acft. The temperature was 94 degrees and the rwy was only 1500 ft long rather than 2300 ft as reported by the…
- [NTSB CHI83LA306](https://openairdocs.org/ntsb/CHI83LA306.md): Cessna 150J · Hibbing, MN · Accident · No injuries · Limited investigation · Final report · Jul 11, 1983 · N51228 · Substantial damage
  > The acft collided with a ditch during takeoff roll. The takeoff was on rwy 31 with the wind from 270 degrees at 8 KTS. The plt said that at 30-40 mph he lost directional control and swerved off the rwy into a drainage ditch. The rwy was 150 ft wide and made…
- [NTSB CHI83LA314](https://openairdocs.org/ntsb/CHI83LA314.md): Flug-Und Fahrzeugwerke Diamant · Frankfort, MI · Accident · No injuries · Limited investigation · Final report · Jul 10, 1983 · N37AC · Substantial damage
  > The plt reported that during a winch tow takeoff the right wing caught in tall grass & soft sand, & the glider ground-looped.
- [NTSB ATL83FA267](https://openairdocs.org/ntsb/ATL83FA267.md): Cessna 172M · Sylvester, GA · Accident · Minor injuries · Field investigation · Final report · Jul 10, 1983 · N80329 · Substantial damage
  > The pilot had accomplished two takeoffs and two full stop landings. The pilot stated that on the third takeoff RPM was lost about the time for liftoff. He elected to abort the takeoff about halfway down the runway. When he pulled the power/throttle back to…
- [NTSB ATL83LA264](https://openairdocs.org/ntsb/ATL83LA264.md): Bensen B8M · Somerville, TN · Accident · 1 fatal · Limited investigation · Final report · Jul 9, 1983 · N47BH · Destroyed
  > The acft crashed during takeoff while on a pleasure flight. A witness stated that he saw the acft take off and climb outat a gradual climb to about 100 ft and then start a gradual descent to about 30 ft. at which time the acft nosed over and went almost…
- [NTSB FTW83LA322](https://openairdocs.org/ntsb/FTW83LA322.md): Piper PA-18-150 · Los Lunas, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1983 · N8999 · Substantial damage
  > The tow plane collided with a van on the rwy during takeoff. The van had been parked there on purpose by the arpt owner to close the rwy. He stated that he had notified the FAA of the closing but no NOTAM had been issued on 7/7/83. A NOTAM was issued for…
- [NTSB ANC83FA113](https://openairdocs.org/ntsb/ANC83FA113.md): Cessna 207A · Dillingham, AK · Accident · Minor injuries · Field investigation · Final report · Jul 6, 1983 · N6271H · Substantial damage
  > The acft collided with a beached unoccupied 18 ft skiff during a takeoff attempt from a soft beach. This acft is a 7 place model. At the time of the accident there were 12 occupants on board. The acft was not overweight because several occupants were children…
- [NTSB FTW83LA312](https://openairdocs.org/ntsb/FTW83LA312.md): Beech C-23 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1983 · N1932L · Destroyed
  > The aircraft impacted 2.2 miles off the departure end of runway 35 at coronada airport. Witnesses stated the aircraft used almost all of the 4020 ft runway before becoming airborne and the aircraft achieved an altitude of only 20 feet. Investigation revealed…
- [NTSB ATL83LA276](https://openairdocs.org/ntsb/ATL83LA276.md): Piper L-21B · Vernon, AL · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N8056W · Substantial damage
  > The acft departed the rwy & nosed over inverted during an unauthorized flight. After the accident the non-certificated plt told the owner that he had flown the acft several times based on the permission of a friend who was authorized to fly the acft.
- [NTSB MIA83LA189](https://openairdocs.org/ntsb/MIA83LA189.md): Piper PA-38-112 · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N9103A · Substantial damage
  > The acft collided with a tree during an aborted takeoff when the plt realized that the airspeed was not registering. During the abort, directional control was lost and the acft veer to the left. Inspection revealed the airspeed indicatormalfunctioned due to a…
- [NTSB LAX83LA315](https://openairdocs.org/ntsb/LAX83LA315.md): Cessna 172 · Hayward, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1983 · N4957G · Destroyed
  > The plt stated that during the takeoff roll he attempted to lift the acft off at about 65-75 KTS indicated airspeed. The plt said that he thought the acft was not responding properly so he cut the power and tried to land on the rwy. The acft kept bouncing, so…
- [NTSB ANC83IA111](https://openairdocs.org/ntsb/ANC83IA111.md): Douglas DC-7C · King Salmon, AK · Incident · No injuries · Incident investigation · Final report · Jul 2, 1983 · N284 · Minor damage
  > Acft overran the end of the rwy when takeoff was aborted after failure to rotate. No mechanical difficulties were noted. The rwy was dry and adequate. The CG was at or near the forward limit.
- [NTSB FTW83LA305](https://openairdocs.org/ntsb/FTW83LA305.md): Piper PA-32RT-300T · Port Mansfield, TX · Accident · No injuries · Limited investigation · Final report · Jun 29, 1983 · N39589 · Substantial damage
  > According to the plt, the nose gear position light flickered & the nose gear unsafe light illuminated, just prior to rotation. He reportedly aborted the takeoff at that time, but was unable to stop before going off the end of the rwy at 65 to 70 KTS. As the…
- [NTSB CHI83LA284](https://openairdocs.org/ntsb/CHI83LA284.md): Taylorcraft BC-12D · Crane Lake, MN · Accident · No injuries · Limited investigation · Final report · Jun 29, 1983 · N96333 · Substantial damage
  > The plt reported that while he was taking off on an easterly heading, the float plane was on the step & became airborne sooner than he expected. While he was correcting the stituation by lowering the nose, the left float dug into the water. Subsequently,…
- [NTSB DEN83LA157](https://openairdocs.org/ntsb/DEN83LA157.md): Taylorcraft BC12D · Vernon, CO · Accident · No injuries · Limited investigation · Final report · Jun 26, 1983 · N43344 · Substantial damage
  > The acft collided with a mailbox during takeoff from a gravel road.
- [NTSB ANC83LA106](https://openairdocs.org/ntsb/ANC83LA106.md): Cessna 170 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Jun 26, 1983 · N3074A · Substantial damage
  > The acft collided with trees alongside the runway during takeoff. The runway was a dirt strip 1200 feet long and 30 feetwide. The pilot stated after the accident that he lost control of the acft and ran off the runway into the wooded area. The wind was from…
- [NTSB MKC83LA134](https://openairdocs.org/ntsb/MKC83LA134.md): Cessna 170B · Denton, NE · Accident · No injuries · Limited investigation · Final report · Jun 24, 1983 · N2506D · Substantial damage
  > The acft went off the runway during takeoff. The pilot said the acft drifted to the left after the tailwheel was raised. He said he brought the acft back to the centerline but it drifted left again and entered tall grass beside the runway. As the pilot…
- [NTSB LAX83IA302](https://openairdocs.org/ntsb/LAX83IA302.md): Mcdonnell Douglas DC9-32 · Las Vegas, NV · Incident · Minor injuries · Incident investigation · Final report · Jun 24, 1983 · N942N · Minor damage
  > During the ground run for takeoff a fatigue precipitated failure of the third stage turbine blade occurred with secondary damage to several guide vanes and the fourth stage turbine wheel. Imbalance of the turbine wheel caused the failure of the number six…
- [NTSB CHI83LA280](https://openairdocs.org/ntsb/CHI83LA280.md): Piper PA-32R · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Jun 24, 1983 · N8310L · Substantial damage
  > The acft ran off the end of the rwy and collapsed the nose gear during an aborted takeoff. The acft exceeded the maximum gross weight for takeoff by 190 lbs. Decision to abort was made about 2/3 of the way down the rwy. Braking was good and deceleration…
- [NTSB MKC83LA132](https://openairdocs.org/ntsb/MKC83LA132.md): Cessna 182F · Dows, IA · Accident · No injuries · Limited investigation · Final report · Jun 21, 1983 · N3568U · Substantial damage
  > The acft nosed over during takeoff. The rwy used was 090 and the wind was from 170 degrees at 17 KTS. The plt said the acfts right wing raised followed by the tail and then the left wing dropped impacting the sod rwy before the acft nosed over.
- [NTSB FTW83LA284](https://openairdocs.org/ntsb/FTW83LA284.md): Piper PA-25-235 · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Jun 19, 1983 · N6303Z · Substantial damage
  > The agricultural acft collided with a pole during an aborted takeoff after directional control was lost. The plt stated that a soft spot in the rwy caused the acft to veer left. The takeoff was aborted but the acft continued off the rwy andcollided with the…
- [NTSB DEN83LA146](https://openairdocs.org/ntsb/DEN83LA146.md): Cessna 188A · Burlington, WY · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1983 · N9789V · Substantial damage
  > The acft departed the rwy in an evasive maneuver to avoid a deer. The acft contacted small trees and brush off the rwy and collapsed the landing gear. The pilot said he was about 150 yards down the rwy with the tail of the acft up when thedeer ran onto the…
- [NTSB ANC83LA100](https://openairdocs.org/ntsb/ANC83LA100.md): Cessna 140 · Bettles, AK · Accident · No injuries · Limited investigation · Final report · Jun 19, 1983 · N89410 · Substantial damage
  > The acft nosed over during an aborted takeoff. The acft was damaged but the occupants were not injured. The pilot statedthat he decided to take off to the south since there was no wind. The acceleration for takeoff was slow according to thepilot so he closed…
- [NTSB DEN83LA145](https://openairdocs.org/ntsb/DEN83LA145.md): Cessna 195A · St. George, UT · Accident · No injuries · Limited investigation · Final report · Jun 18, 1983 · N1537H · Substantial damage
  > The prop blade separated causing the acft to veer sharply to the left out of control. The acft came to rest about 30 ft from the rwy with the right main landing gear broken off. A metallurgical exam revealed that the blade failed from fatigue. The fatigue…
- [NTSB ATL83LIJ03](https://openairdocs.org/ntsb/ATL83LIJ03.md): Piper PA-28-140 · Bruceton Mills, WV · Accident · No injuries · Final report · Jun 18, 1983 · N6575W · Substantial damage
  > The acft collided with a fence during an attempted takeoff from a short sod private strip. The privately owned grass strip is approx. 800 feet long with a 5 deg upgrade from the midway point. The pilot said he realized he could not climbfast enough so he…
- [NTSB DEN83LA141](https://openairdocs.org/ntsb/DEN83LA141.md): Cessna A188 · Leola, SD · Accident · No injuries · Limited investigation · Final report · Jun 16, 1983 · N8181V · Substantial damage
  > The plt was using a gravel road, aprx 20 ft wide, for an aerial application operation. During takeoff, the acft swerved to the right, went into the ditch beside the road & was substantially damaged. The plt believed that the right wheel had become locked.…
- [NTSB NYC83LA140](https://openairdocs.org/ntsb/NYC83LA140.md): Cessna 172P · Latrobe, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1983 · N65615 · Substantial damage
  > The acft ran off the runway when the student pilot attempted to close a window during the takeoff roll. As the acft left the runway the nose wheel collapsed rearward and the prop, main gear and fuselage were damaged. The pilot received minor injuries.
- [NTSB FTW83LA277](https://openairdocs.org/ntsb/FTW83LA277.md): Ayres S2R-1820 · Ville Platte, LA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1983 · N4025P · Substantial damage
  > The acft collided with a dirt levee during takeoff after an engine malfunction. According to the plt he experienced a power failure at liftoff. He dumped his spray load and applied brakes. The engine regained partial power and failed again. At about 60 mph…
- [NTSB FTW83LA275](https://openairdocs.org/ntsb/FTW83LA275.md): Grumman G-164A · Newport, AR · Accident · No injuries · Limited investigation · Final report · Jun 13, 1983 · N6581 · Substantial damage
  > According to the plt, after he took off, he was unable to maintain alt & began dumping his load of 1500 lbs of chemicals. He turned back toward the airstrip, but was forced to land short of a bean field. After touchdown, the acft rolled into a small drainage…
- [NTSB CHI83LA253](https://openairdocs.org/ntsb/CHI83LA253.md): Piper PA-38-112 · Strongville, OH · Accident · No injuries · Limited investigation · Final report · Jun 12, 1983 · N24802 · Substantial damage
  > The acft collided with trees at the departure end of the runway during an aborted takeoff. The instructor pilot who was doing a demonstration flt stated that 'the acft rotated to a normal climb attitude but did not climb out of ground effect. After electing…
- [NTSB CHI83FA251](https://openairdocs.org/ntsb/CHI83FA251.md): Boeing 727-222A · Chicago, IL · Accident · Serious injuries · Field investigation · Final report · Jun 11, 1983 · N7273U · Substantial damage
  > During the takeoff roll, the #1 eng failed & the takeoff was aborted at aprx 70 KTS. The aircrew taxied the acft clear of the rwy & stopped on the reverse high speed turnoff. The aircrew of another company acft transmitted that the #1 eng was on fire. There…
- [NTSB FTW83LA269](https://openairdocs.org/ntsb/FTW83LA269.md): Beech 95-B55 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Jun 7, 1983 · N1757W · Substantial damage
  > While on the takeoff roll, with aprx 1400 ft of rwy remaining, the plt noticed that there was no indication of airspeed. He therefore elected to abort the takeoff, the rwy was a combination of asphalt & turf. Following his decision to abort, the remaining…
- [NTSB NYC83LA135](https://openairdocs.org/ntsb/NYC83LA135.md): Burkhart Grob 109 · Finleyville, PA · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1983 · N903BG · Substantial damage
  > The motorized glider collided with trees and the terrain during an emergency landing after the prop had struck the ground during takeoff. During the takeoff roll the propeller 1st collided with high grass and then a bump in the ground after the pilot lost…
- [NTSB ATL83FA213](https://openairdocs.org/ntsb/ATL83FA213.md): Bellanca 8KCAB · Calhoun, GA · Accident · 1 fatal · Field investigation · Final report · Jun 4, 1983 · N111UD · Destroyed
  > The plt had flown to the arpt to perform aerobatic maneuvers at a fly-in. He had a low altitude waiver to perform down to 500 ft AGL. Before the flight, he told several spectators he was going to do a maneuver right after takeoff. Witnesses reported that the…
- [NTSB MIA83LA150](https://openairdocs.org/ntsb/MIA83LA150.md): Cessna 207 · Sebring, FL · Accident · No injuries · Limited investigation · Final report · May 31, 1983 · N75773 · Substantial damage
  > According to the plt, he heard a 'thump' when he was taking off from orlando west arpt, but attributed it to the grass strip. When he landed at Sebring arpt, he heard a scraping sound as he lowered the nose & elected to go around. He decided the nosewheel was…
- [NTSB ANC83LA088](https://openairdocs.org/ntsb/ANC83LA088.md): Cessna TU206 · Venetie, AK · Accident · Minor injuries · Limited investigation · Final report · May 31, 1983 · CGPZP · Destroyed
  > The plt initiated his takeoff from a downhill, uni-directional rwy (rwy 17) with a tail wind from 020 deg at 15 gusting 25 KTS. He stated that he climb to an alt of 100 to 200 ft then encountered severe turbulence. Subsequently the acft struck the ground 2…
- [NTSB FTW83LA257](https://openairdocs.org/ntsb/FTW83LA257.md): Cessna 170B · Roswell, NM · Accident · No injuries · Limited investigation · Final report · May 29, 1983 · N113E · Substantial damage
  > The solo student plt was practicing touch and go landings. According to the plt, after landing and rolling about 200 ft he applied power to takeoff, the acft turned left and then ground looped 180 degrees. The right main landing gear collapsed.

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=155

## 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 = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=154

---
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.