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

## Cases, newest first

- [NTSB MKC85LA225](https://openairdocs.org/ntsb/MKC85LA225.md): Grumman G-164A · Griffithville, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 1985 · N8561H · Substantial damage
  > The plt reports that the acft fishtailed during the takeoff roll and ran off the side of the rwy. The acft was heading toward a canal and the plt elected to try to fly over the canal. The acft became airborne and flew about 1/4 mi. The plt saw trees ahead and…
- [NTSB MKC85LA165](https://openairdocs.org/ntsb/MKC85LA165.md): de Havilland DH 82A · Ames, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1985 · N657DH · Substantial damage
  > The owner had given the plt permission to fly the acft & the plt elected to take a passenger in the front seat. After the accident, the plt stated that he was making a hi speed taxi run on the grass on the right side of the rwy. He reported that the lower…
- [NTSB MKC85LA155](https://openairdocs.org/ntsb/MKC85LA155.md): Beech 95-A55 · Salina, KS · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N1522Z · Substantial damage
  > The plt stated that he was receiving a multi-engine flight check from a designated flt examiner. They were still rolling after a landing when the examiner requested a go-around. The plt said that after advancing the throttles, he reached for the flap switch &…
- [NTSB LAX85FA314](https://openairdocs.org/ntsb/LAX85FA314.md): Mooney M20J · Antioch, CA · Accident · 1 fatal · Field investigation · Final report · Jul 11, 1985 · N201HU · Minor damage
  > The acft crashed into a reservoir shortly after departing the Antioch arpt. There were no eye witnesses to the crash. However, an ear witness stated that he heard the acft skipping along the water like the sound of a hydro-plane. He did not hear the eng, but…
- [NTSB ANC85FA118](https://openairdocs.org/ntsb/ANC85FA118.md): Douglas DC-6A · Egegik, AK · Accident · Minor injuries · Field investigation · Final report · Jul 7, 1985 · N2878F · Destroyed
  > Airplane accelerated to v 1 and struck through on sandy beach. The nose pitched up and the pilot lost directional control. The airplane struck adjacent bank caught fire. It was totally destroyed.
- [NTSB ANC85LA119](https://openairdocs.org/ntsb/ANC85LA119.md): Helio 250 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N5460E · Substantial damage
  > The plt reported that he took off downwind with a heavily loaded acft. He estimated the wind was from the north at 4 gusting to 6 KTS. He stated that after climbing about 100 ft, the acft began to mush as he began retracting the flaps. Subsequently, it…
- [NTSB DEN85LA184](https://openairdocs.org/ntsb/DEN85LA184.md): Cessna A188B · Del Norte, CO · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N731GN · Substantial damage
  > The plt was attempting to take off from a 3800-FT grass rwy. Field elevation was 7700 ft, temp was 88 deg. The plt said that at about 2500 ft down the rwy he decided to abort the takeoff. Directional control was lost and the airplane groundlooped. The plt…
- [NTSB MKC85LA148](https://openairdocs.org/ntsb/MKC85LA148.md): Cessna 172B · Valley Center, KS · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N51611 · Substantial damage
  > The pilot had been flying with his young son as passenger during daylight hours. He went solo to get current at night. After two full stop landings, he thought the yoke felt heavy for the trim setting he usually used but he started a takeoff anyway. Halfway…
- [NTSB MKC85LA146](https://openairdocs.org/ntsb/MKC85LA146.md): Piper PA-28-140 · El Dorado, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1985 · N2858T · Substantial damage
  > The acft had just undergone annual inspection. Pilot failed to remove control lock before test flight. On takeoff roll, pilot was not able to move controls, went off end of 1800 ft runway, through a fence and impacted a dirt pile.
- [NTSB ANC85LA114](https://openairdocs.org/ntsb/ANC85LA114.md): Cessna 172M · Theodore River, AK · Accident · No injuries · Limited investigation · Final report · Jul 1, 1985 · N20541 · Substantial damage
  > After loading the acft to its max gross wt, the plt initiated a takeoff from a road on level terrain that had numerous dips & bumps. The road was only 11 ft wide & was bordered by heavy brush. The plt reported that prior to reaching the lift-off speed during…
- [NTSB DEN85LA176](https://openairdocs.org/ntsb/DEN85LA176.md): American AA-1 · Gallup, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 1985 · N5984L · Destroyed
  > During a x-country flt from los angeles, CA to tulsa, OK, the plt made an en route stop at Gallup, NM. The fuel tanks were fully serviced & the plt took off with a passenger & aprx 50 lbs of tools & baggage on board. The plt stated that after takeoff, the…
- [NTSB ATL85LA199](https://openairdocs.org/ntsb/ATL85LA199.md): Beech 55 · Savannah, GA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1985 · N2781F · Substantial damage
  > Before taking off, the plt checked the trim & the auto-plt. During the takeoff run, he noted that the 'aircraft felt heavy on rotation/takeoff aborted.' The acft continued off the end of the rwy, hit a mound of dirt & was damaged. A post-accident exam…
- [NTSB CHI85LA263](https://openairdocs.org/ntsb/CHI85LA263.md): Lake LA-4-200 · Hart, MI · Accident · No injuries · Limited investigation · Final report · Jun 29, 1985 · N516L · Substantial damage
  > During a Lake takeoff at near lift off speed the plt stated the acft struck a submerged log and became airborne at a low airspeed. The acft then dropped back to the Lake surface, the right wing float dug in the water and separated the float from the wing. The…
- [NTSB DEN85LA175](https://openairdocs.org/ntsb/DEN85LA175.md): Piper PA-32R-301T · Lordsburg, NM · Accident · No injuries · Limited investigation · Final report · Jun 27, 1985 · N8180F · Substantial damage
  > The plt attempted to take off from a dirt road at or near max gross wieght and at high density alt conditions. The plt said there was a small rise in the road and he eased back on the control yoke. Directional control was lost and the airplane skidded off the…
- [NTSB DCA85AA027](https://openairdocs.org/ntsb/DCA85AA027.md): Mcdonnell Douglas DC-10-10 · San Juan, PR · Accident · Serious injuries · Final report · Jun 27, 1985 · N129AA · Substantial damage
  > After landing at San Juan, the acft was parked at the customs area, then was towed to gate 15 & loaded for the next flt. The push-back was such that the crew had to taxi to the gen avn parking area & turn around bfr proceeding to rwy 8 for departure. When…
- [NTSB LAX85LA290](https://openairdocs.org/ntsb/LAX85LA290.md): Luscombe 8A · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1985 · N39087 · Substantial damage
  > The pilot lost directional control,during the takeoff phase of a touch and go landing. The acft swerved off the runway as it entered a ground loop that collapsed the right landing gear strut.
- [NTSB ANC85LA105](https://openairdocs.org/ntsb/ANC85LA105.md): Bellanca 8GCBC · Lewis River, AK · Accident · No injuries · Limited investigation · Final report · Jun 22, 1985 · N2667Z · Substantial damage
  > The pilot stated there was a gust of wind about 10 knots, the pilot was not able to reach flying speed, and the aircraft ran off the departure end of the runway.
- [NTSB ANC85LA101](https://openairdocs.org/ntsb/ANC85LA101.md): de Havilland DHC-2 · Bering River, AK · Accident · No injuries · Limited investigation · Final report · Jun 20, 1985 · N99838 · Substantial damage
  > The plt stated that during a 15 to 20 min period after he had landed, the wind velocity increased greatly. He managed to taxi the float plane to an area where he could takeoff into the wind. As the acft was on the step for takeoff, the left wing lifted as if…
- [NTSB ANC85FA100](https://openairdocs.org/ntsb/ANC85FA100.md): Cessna 180H · Theordore River, AK · Accident · Minor injuries · Field investigation · Final report · Jun 20, 1985 · N91390 · Substantial damage
  > The plt landed the float plane on the Theordore River which had a maximum width of about 90 ft & had few straight runs of more than 400 ft. the River had many sharp turns, some in excess of 150 degs, & its depth was as low as 18 inches at low tide. The plt…
- [NTSB CHI85FEE02](https://openairdocs.org/ntsb/CHI85FEE02.md): Balloon Works Firefly AX-7 · Somonauk, IL · Accident · Serious injuries · Final report · Jun 18, 1985 · N40532 · Substantial damage
  > The Balloon collided with powerlines during takeoff. The wind was reported as 10-15 mph with gusts. The operation was canceled due to the wind after 6 successful launches. The last plt was reportedly pressured to go by his pass'g and a gust of wind blew them…
- [NTSB ANC85LA096](https://openairdocs.org/ntsb/ANC85LA096.md): Piper PA-18 · Mulchatna River, AK · Accident · No injuries · Limited investigation · Final report · Jun 17, 1985 · N4876A · Substantial damage
  > Plt reported that left wheel axle broke during aborted takeoff from gravel bar, causing acft to ground loop. Plt failed to provide complete info & broken axle for analysis.
- [NTSB ANC85LAG01](https://openairdocs.org/ntsb/ANC85LAG01.md): Brians Puffin · Eagle River, AK · Accident · Minor injuries · Final report · Jun 16, 1985 · N4933N · Substantial damage
  > The plt was conducting taxi tests on his homebuilt acft when it started to sustain a hull structure failure and control interference from separating parts. The acft pitched off the water, climbed to aprx 100 ft AGL, stalled and spun to ground impact.
- [NTSB NYC85LA081](https://openairdocs.org/ntsb/NYC85LA081.md): Bell 47G-3 · Plainsboro, NJ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N49882 · Substantial damage
  > The helicpopter crashed shortly after takeoff with 55 gallons of fertilizer on board. The plt stated that each time he made a swath run over the field the blades of the helicopter were picking up some of the liquid fertilizer. On takeoff helicopter felt…
- [NTSB LAX85LA281](https://openairdocs.org/ntsb/LAX85LA281.md): Otis G. Lyons Marquart Charger MA5 · Upper Lake, CA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N80GL · Substantial damage
  > The plt elected to take off in his taildragger on rwy 19 which is 4050 ft long & 200 ft wide during a period when the wind was estimated at 270 deg, 20 KTS, with gusts to 25 KTS. The plt stated that at rotation full rt rudder was applied, but his homebuilt,…
- [NTSB ANC85FA093](https://openairdocs.org/ntsb/ANC85FA093.md): Cessna 207 · Eek, AK · Accident · Serious injuries · Field investigation · Final report · Jun 15, 1985 · N9828M · Substantial damage
  > The pilot-in-command stated that during the takeoff roll he was moving the flap control lever up and down to effect a lift off. The airplane never left the runway and ran off the end of the ten foot embankment, traveled 140 feet before striking a bank and…
- [NTSB SEA85LA138](https://openairdocs.org/ntsb/SEA85LA138.md): Piper PA-22-135 · Long Valley, NV · Accident · No injuries · Limited investigation · Final report · Jun 14, 1985 · N843 · Substantial damage
  > The plt chose to land on a country road due to low fuel. After refueling the plt attempted to depart the rough road. During the takeoff roll the acft veered left and struck a wire fence.
- [NTSB LAX85LA268](https://openairdocs.org/ntsb/LAX85LA268.md): Cessna 150 · Oracle, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1985 · N8489U · Substantial damage
  > During a LCL pleasure flt the plt stated that the acft's eng began running rough so he made a precationary ldg on a dirt road which was at an elevation of 4,000 ft MSL. After inspecting the acft & finding it to be in proper working order the plt decided to…
- [NTSB MIA85LA186](https://openairdocs.org/ntsb/MIA85LA186.md): Bellanca 8GCBC · Panama City, FL · Accident · No injuries · Limited investigation · Final report · Jun 8, 1985 · N53925 · Substantial damage
  > The plt stated that while taking off in a x-wind he lost control of the acft. The acft contacted the lip of a large drainage ditch, cartwheeled 180 degs to the right and crashed into a ditch.
- [NTSB CHI85LA227](https://openairdocs.org/ntsb/CHI85LA227.md): Hughes 269C · Cleveland, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1985 · N9296F · Substantial damage
  > On takeoff, a tackel box slid forward and jammed the cyclic. The plt attempted to return to the landing pad, however, one of the skids missed the pad and the acft began to roll until the main rotor contacted the roof of a garage.
- [NTSB SEA85LA127](https://openairdocs.org/ntsb/SEA85LA127.md): Cessna 150 · North Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Jun 6, 1985 · N69236 · Substantial damage
  > Loss of directional control occurred during the student pilot's second attempted touch and go. The aircraft veered let, struck a berm with the nosewheel and then nosed over. FAA inspectors attempted to physically check flight controls but movement was limited…
- [NTSB NYC85LA140](https://openairdocs.org/ntsb/NYC85LA140.md): Cessna 340A · Butler, PA · Accident · No injuries · Limited investigation · Final report · Jun 6, 1985 · N2669Z · Substantial damage
  > The plt reported that prior to the flt, he made the usual preflight check & locked the left forward, nose baggage door. During the takeoff roll, the left forward baggage door opened & locked in an upright position. The plt aborted the takeoff, but there was…
- [NTSB FTW85LA246](https://openairdocs.org/ntsb/FTW85LA246.md): Cessna A188B · Friona, TX · Accident · No injuries · Limited investigation · Final report · Jun 4, 1985 · N731AS · Substantial damage
  > The plt lost directional control and ground looped off the side of the rwy. The purpose of the flt was to check the adjustment of the acft's spray dispensing equipment. Twenty gallons of water were on board to be used as a substitute for chemical spray. The…
- [NTSB FTW85LA243](https://openairdocs.org/ntsb/FTW85LA243.md): Aeronca 7AC · Edna, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1985 · N3708E · Substantial damage
  > The pilot lost directional control during a crosswind takeoff from a ranch road. The acft veered off the right (north) side of the road where it contacted a ditch in a rice field.
- [NTSB CHI85LA219](https://openairdocs.org/ntsb/CHI85LA219.md): Cessna T210 · Marion, IN · Accident · No injuries · Limited investigation · Final report · Jun 1, 1985 · N6787R · Substantial damage
  > Shortly after takeoff, the plt discovered that the elevator controls were jammed & pitch changes could only be made with elevator trim & power. An emerg landing was made using the trim, but the plt was unable to flare the acft at landing speed. The acft…
- [NTSB FTW85LA241](https://openairdocs.org/ntsb/FTW85LA241.md): Bell 206-B · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · May 31, 1985 · N1072Y · Substantial damage
  > The acft was taking off on a test flt to determine the aft c.g. limits in conjunction with an STC modification. As the acft was lifted off in a front skids high attitude, it entered an uncommanded right roll. Full left cyclic would not stop the roll and the…
- [NTSB LAX85LA261](https://openairdocs.org/ntsb/LAX85LA261.md): Cessna 182P · Glendale, AZ · Accident · Minor injuries · Limited investigation · Final report · May 27, 1985 · N7229N · Substantial damage
  > The plt attempted to takeoff fm a 2400-FT-long rwy, he reported that because the acft's airspeed indicator did not appear to properly represent the airspeed, he aborted the takeoff. This occurred after accelerating down the rwy for an estimated 1800 ft. the…
- [NTSB CHI85LA215](https://openairdocs.org/ntsb/CHI85LA215.md): Cessna 152 · Marshfield, WI · Accident · No injuries · Limited investigation · Final report · May 27, 1985 · N67955 · Substantial damage
  > The pilot made a precautionary landing in a field. After checking the acft fuel tanks he attempted to takeoff on a gravel road. During the ground run the acft collided with trees & skidded into a field.
- [NTSB FTW85LA232](https://openairdocs.org/ntsb/FTW85LA232.md): Pitts Special S-1C · Lubbock, TX · Accident · Minor injuries · Limited investigation · Final report · May 26, 1985 · N22BD · Destroyed
  > The pilot, although well experienced, had recorded only one hour of flight time in this make and model aircraft and no flight time in any aircraft within the 90 day period preceding the accident. This is the information recorded on the pilot/operator aircraft…
- [NTSB NYC85LA134](https://openairdocs.org/ntsb/NYC85LA134.md): Globe GC1B · Whitpain, PA · Accident · No injuries · Limited investigation · Final report · May 24, 1985 · N80902 · Substantial damage
  > The acft overran the end of the rwy and contacted rough terrain during takeoff. The plt stated the acft lifted off aprx 1/2 the way down the rwy but it did not have enough airspeed to accelerate and climb. The plt attempted to abort the takeoff however, the…
- [NTSB CHI85LA206](https://openairdocs.org/ntsb/CHI85LA206.md): Gulfstream American AA-5A · New Hudson, MI · Accident · Minor injuries · Limited investigation · Final report · May 23, 1985 · N9581U · Destroyed
  > The pilot inadvertently attempted to take off with at least 21 deg. Of flaps. The acft climbed to approximately 30-50 8T. AGL and passed over a hangar on the left side of the runway. Once past the hangar the acft began a rapid descent. Post impact fire…
- [NTSB CHI85FEP01](https://openairdocs.org/ntsb/CHI85FEP01.md): Beech 35-C33 · Middleton, WI · Accident · Minor injuries · Final report · May 23, 1985 · N6144V · Substantial damage
  > At lift-off during the departure, the plt noticed oil spray on the windshield. He initiated an aborted takeoff by retarding the throttle, then realized there was insufficient rwy remaining, so he applied full throttle again. However, the eng did not respond…
- [NTSB ATL85LA172](https://openairdocs.org/ntsb/ATL85LA172.md): Galloway B-8M · Milledgeville, GA · Accident · No injuries · Limited investigation · Final report · May 21, 1985 · N991PG · Substantial damage
  > The plt stated that the gyroplane was blow off the side of the rwy by a gust of wind during the takeoff portion of a touch and go landing. The acft traveled into a grass area and nosed over. The student plt did not have a solo endorsement and had only two…
- [NTSB ATL85FA169](https://openairdocs.org/ntsb/ATL85FA169.md): Luscombe 8-A · Columbiana, AL · Accident · No injuries · Field investigation · Final report · May 18, 1985 · N28428 · 2 aircraft · Substantial damage
  > The airstrip is used primarily as a gliderport and at the time of the accident, traffic was being controlled by a person on the ground using handsignals. N28428 proceeded on to the rwy to takeoff as the ultralight was on final apch. Both plts observed the…
- [NTSB LAX85LA254](https://openairdocs.org/ntsb/LAX85LA254.md): Cessna 152 · Atwater, CA · Accident · No injuries · Limited investigation · Final report · May 13, 1985 · N25523 · Substantial damage
  > On the student plt's third supervised solo flt he landed the acft. After touchdown he applied pwr to make a touch & go, & then raised the flaps. The acft veered left, rolled off the rwy, collided with a small dirt mound & nosed over. The student had 18.2…
- [NTSB ANC85LA081](https://openairdocs.org/ntsb/ANC85LA081.md): Cessna 185F · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · May 11, 1985 · N1062F · Substantial damage
  > Plt did not use all available takeoff area and failed to recognized need to abort until too late. Possible overweight airplane loaded beyond centre of gravity range
- [NTSB MIA85LA167](https://openairdocs.org/ntsb/MIA85LA167.md): Schempp-Hirth VENTUS-B · Winter Haven, FL · Accident · No injuries · Limited investigation · Final report · May 7, 1985 · N40EE · 2 aircraft · Substantial damage
  > A Schempp-Hirth ventus b, N40EE, was positioned on rwy 29 to be towed on a competition glider flt. The plt reported that before starting his takeoff, the tow plane was positioned to the left of the glider. The wind was from 030 deg at 8 KTS. As the takeoff…
- [NTSB BFO85LA044](https://openairdocs.org/ntsb/BFO85LA044.md): Cessna 182H · Waynesboro, VA · Accident · No injuries · Limited investigation · Final report · May 7, 1985 · N8579S · Substantial damage
  > During the takeoff roll, the pilot noticed that the left door was open. While attempting to close the door, he failed to maintain directional control and the aircraft subsequently struck trees along the south side of runway 23.
- [NTSB SEA85FA104](https://openairdocs.org/ntsb/SEA85FA104.md): Hughes 369D · Spokane, WA · Accident · 2 fatal · Field investigation · Final report · May 5, 1985 · N8365F · Destroyed
  > The helicopter was on a flt to a tv station to transport a tv camera man & his gear. The regular plt for this trip was unable to fly, so another was retained for the flt. This was his 1st flt to the station. Helicopter operations at the tv station were…
- [NTSB LAX85FA240](https://openairdocs.org/ntsb/LAX85FA240.md): Douglas DC3 · Perris, CA · Accident · No injuries · Field investigation · Final report · May 5, 1985 · N157U · Destroyed
  > The aircraft's left engine caught fire during the takeoff roll. The pilot managed to stop the aircraft on the runway and all 31 skydivers and the two member crew evacuated without injury. The left engine propeller had lost one blade which was found several…
- [NTSB NYC85LA115](https://openairdocs.org/ntsb/NYC85LA115.md): Cessna C172 · Poestenkill, NY · Accident · Serious injuries · Limited investigation · Final report · May 4, 1985 · N172TD · Substantial damage
  > Cessna 172TD encountered strong gusty crosswind while taking from rensselaer airpark and directional control was lost. The aircraft verred off the left side off the run-way and collid with the terrain. Full right rudder was applied to correct the deviation.…

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

## 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=145

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