# 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 160 of 412 · 20,559 cases

## Cases, newest first

- [NTSB CHI88LA193](https://openairdocs.org/ntsb/CHI88LA193.md): Cessna 172 · Milwaukee, WI · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N65711 · Substantial damage
- [NTSB DEN88LA178](https://openairdocs.org/ntsb/DEN88LA178.md): Taylorcraft BC12-D · Clinton, MT · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 1988 · N95855 · Substantial damage
  > The plt rprtd that drg takeoff from rwy 25, the winds were from 270 deg at 10 gusting 15 KTS. He stated that drg the initial climb, the airplane enctrd a severe windshear. Subsequently, he lost control & the acft struck the ground in a 40 deg nose down, 70…
- [NTSB DEN88LA171](https://openairdocs.org/ntsb/DEN88LA171.md): Cessna 150 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Aug 4, 1988 · N704UN · Substantial damage
  > The instructor (CFI) & student plt were on an instructional flt. The CFI rprtd that while climbing thru aprx 150' AGL, the acft enctrd a downdraft. He took the controls, but the acft descended to about 10 ft AGL. The CFI elected to land immediately to avoid a…
- [NTSB CHI88LA191](https://openairdocs.org/ntsb/CHI88LA191.md): Stinson 108-1 · St. Charles, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1988 · N97797 · Destroyed
  > The pilot failed to attain sufficient altitude to clear obstacles during the initial climb-out and the aircraft collided with trees located off the departure end of the private grass strip. The aircraft fell to the ground, where it caught fire and was…
- [NTSB NYC88FA202](https://openairdocs.org/ntsb/NYC88FA202.md): Cessna 172P · Post Mills, VT · Accident · 2 fatal · Field investigation · Final report · Aug 3, 1988 · N62541 · Destroyed
  > The plt flew the acft to an arpt with two turf rwys. Rwy 5/23 was 2300' long & rwy 4/22 was 2600' long. After attending a meeting which ended at 1600 EDT, the plt elected to wait until later in the day to takeoff after the air had cooled. Subsequently, he…
- [NTSB NYC88DHJ01](https://openairdocs.org/ntsb/NYC88DHJ01.md): Stolp Starduster SA-300 · Shirley, NY · Accident · Serious injuries · Final report · Aug 3, 1988 · N7613 · Destroyed
  > The plt rprtd that the acft's eng lost power as he was departing from rwy 24. He said he turned left to land on rwy 15, then the eng restarted again, so he decided to land on rwy 24. Also, he rprtd that as he was banking to the left in the traffic pattern,…
- [NTSB CHI88FA188](https://openairdocs.org/ntsb/CHI88FA188.md): Bellanca 7ECA · Flushing, MI · Accident · 1 fatal · Field investigation · Final report · Aug 3, 1988 · N2956Z · Destroyed
  > Pilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.
- [NTSB DEN88FA170](https://openairdocs.org/ntsb/DEN88FA170.md): Beech B23 · Cimarron, NM · Accident · 1 fatal · Field investigation · Final report · Aug 2, 1988 · N4006T · Destroyed
  > The pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.
- [NTSB CHI88LA187](https://openairdocs.org/ntsb/CHI88LA187.md): Piper PA-22-108 · Cheboygan, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 1988 · N4982Z · Substantial damage
  > Shortly after departure, when the aircraft was approximately 30' in the air, the aircraft's right wing 'dropped hard'. The pilot attempted remedial action, but was unable to regain control of the aircraft before the right wing tip struck the ground. The…
- [NTSB CHI88DEP08](https://openairdocs.org/ntsb/CHI88DEP08.md): Monnett Sonerai II · Wisc Rapids, WI · Accident · No injuries · Final report · Aug 1, 1988 · N79TG · Substantial damage
  > The plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…
- [NTSB CHI88LA180](https://openairdocs.org/ntsb/CHI88LA180.md): Piper PA-38-112 · St. Jacob, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 1988 · N9291T · Substantial damage
  > During the initial climbout the student pilot failed to attain sufficient altitude to clear the power lines located off of the departure end of the runway. When the pilot realized that he would not be able to clear the power lines, he elected to attempt to…
- [NTSB CHI88FA183](https://openairdocs.org/ntsb/CHI88FA183.md): Boeing B75N1 · Wonder Lake, IL · Accident · No injuries · Field investigation · Final report · Jul 31, 1988 · N4408N · Substantial damage
- [NTSB MKC88LA144](https://openairdocs.org/ntsb/MKC88LA144.md): Grumman G-164B · Cherry Valley, AR · Accident · No injuries · Limited investigation · Final report · Jul 30, 1988 · N6823K · Substantial damage
  > The plt said that shortly after takeoff, he had a partial power loss. He dumped his chemical load and attempted to return for landing. While turning the engine suffered a complete loss of power. He attempted to land, but on the roll out, acft nosed over in…
- [NTSB NYC88LA197](https://openairdocs.org/ntsb/NYC88LA197.md): Erco 415C · W. Bloomfield, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 1988 · N94011 · Destroyed
  > Shorlty after takeoff at about 150 feet a.g.l., the pilot lost control of the airplane and crashed in a corn field about 0.5 mile from airport. A passenger reported that they encountered a wind gust and the pilot was unable to control the airplane.
- [NTSB MKC88LA140](https://openairdocs.org/ntsb/MKC88LA140.md): Mooney M20C · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jul 28, 1988 · N6722U · Substantial damage
  > Shortly after takeoff, the pilot said the engine failed. He said he pumped the throttle and the engine restarted about the same time the acft returned to the runway. The engine restart propelled the aft back into the air. The plt felt he had sufficient power…
- [NTSB NYC88LA195](https://openairdocs.org/ntsb/NYC88LA195.md): Cessna 177RG · Canton, MA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1988 · N52865 · Substantial damage
  > During initial climb from takeoff, the engine lost total power and an emergency landing was made on a highway. The left wing and horizontal stabilizer struck a guardrail when the pilot was maneuvering to avoid a truck. A post-crash inspection of the engine…
- [NTSB ANC88LA096](https://openairdocs.org/ntsb/ANC88LA096.md): Piper PA-32 · Sand Point, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 1988 · N493CA · Substantial damage
  > The pilot reported that the aircraft had high oil temp and moderate vibrations. The aircraft was landed at Sand Point and a company mechanic arrived to inspect the aircraft. The oil quantity was checked and a run-up performed. The mechanic reported that no…
- [NTSB NYC88FA193](https://openairdocs.org/ntsb/NYC88FA193.md): Cessna 150J · Palmyra, NY · Accident · 1 fatal · Field investigation · Final report · Jul 25, 1988 · N51413 · Destroyed
  > Cessna N51413 departed Palmyra airpark with full flaps and crashed into a barn about 75 feet past the departure end of runway 35. Afterward, the flap actuator was found in the flap up position. The pilot said that the engine lost 200 to 300 RPM about 300 feet…
- [NTSB NYC88LA192](https://openairdocs.org/ntsb/NYC88LA192.md): Piper PA-28-140 · Smoketown, PA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1988 · N33743 · Substantial damage
  > The plt reported that the eng lost power at about 300 ft AGL after takeoff. A forced landing was made in a corn field. During the landing roll the aircraft nosed over. The wreckage was examined after the accident and water was discovered in the fuel system.…
- [NTSB MIA88IA231](https://openairdocs.org/ntsb/MIA88IA231.md): Boeing 737-222 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Jul 24, 1988 · N69AF · Minor damage
  > Flt experienced failure of the number two engine shortly after takeoff when the combustion outer case ruptured. Metallurgical examination revealed the ruptured case had a 1/2 inch crack in it when it went through overhaul 16 cycles before the failure. It was…
- [NTSB FTW88DRA15](https://openairdocs.org/ntsb/FTW88DRA15.md): Air Command Elite 532 · Baytown, TX · Accident · 1 fatal · Final report · Jul 23, 1988 · N91359 · Destroyed
  > Acft was observed to takeoff and turn right crosswind. Drng the crosswind, the RPM increased suddenly. The acft pitched nose downwards, impacted the ground in a vertical descent and burned. The plt/builder had a total of 5 hrs in the new acft. No evidence of…
- [NTSB ATL88FA219](https://openairdocs.org/ntsb/ATL88FA219.md): Piper PA-28-180 · Winston-Salem, NC · Accident · 4 fatal · Field investigation · Final report · Jul 23, 1988 · N7942N · Destroyed
  > N7942N crashed into a building shortly after liftoff from runway 21. The pilot was cleared for a left turnout over runway 33. A witness estimated that the airplane had reached 300 feet when the pilot lost control and crashed. The investigation failed to…
- [NTSB FTW88LA138](https://openairdocs.org/ntsb/FTW88LA138.md): Beech V35B · Sayre, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1988 · N771RB · Substantial damage
  > The pilot said that shortly after takeoff, at 200 feet AGL, the engine quit. He tried to land on the remaining runway but the airplane went off left side, then through a ditch. No problems could be found to cause the loss of engine power. The engine was later…
- [NTSB ANC88LA094](https://openairdocs.org/ntsb/ANC88LA094.md): Piper PA-32-300 · Dillingham, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1988 · N29148 · Substantial damage
  > The pilot reported that he lost control of the aircraft. The plane crashed approximately 500 feet off the departure end of the airstrip. The flight was a part 135 on-demand air taxi flight. At the time of the accident, the aircraft was above maximum certified…
- [NTSB SEA88LA135](https://openairdocs.org/ntsb/SEA88LA135.md): Schweizer G164A · Colfax, WA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1988 · N8974H · Substantial damage
  > On departure with a load of chemical, ag plt attempted to outclimb rising terrain ahead. The aircraft collided with terrain in a stall/mush.
- [NTSB NYC88LA190](https://openairdocs.org/ntsb/NYC88LA190.md): Waco UPF-7 · Greenland, NH · Accident · No injuries · Limited investigation · Final report · Jul 21, 1988 · N20973 · Substantial damage
  > The intention of the flight was to give people at an annual company picnic a ride in the aircraft. After takeoff and while starting a left turn the pilot stated that he encountered a 'sudden windshear/downdraft.' The aircraft never got above 200 feet and…
- [NTSB ATL88LA217](https://openairdocs.org/ntsb/ATL88LA217.md): Mooney M20E · Lawrenceville, GA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1988 · N6810V · Substantial damage
  > The plt reported that the engine failed shortly after takeoff. The pilot made a 180 degree turn and landed downwind on the runway. He elected to land gear up to avoid a drop-off past the runway end. The acft slid off the runway end, but came to a stop before…
- [NTSB BFO88FA067](https://openairdocs.org/ntsb/BFO88FA067.md): de Havilland DHC-6-200 · Chantilly, VA · Accident · 1 fatal · Field investigation · Final report · Jul 20, 1988 · N7267 · Destroyed
  > The pilot inadvertently misused the flaps, by failing to set the flaps to the proper setting. The flaps were set full down. This caused the aircraft to pitch up steeply after liftoff. Additionally, the flight control lock was probably installed during some…
- [NTSB MIA88LA229](https://openairdocs.org/ntsb/MIA88LA229.md): Air Tractor AT-301 · Moorhead, MS · Accident · No injuries · Limited investigation · Final report · Jul 18, 1988 · N23640 · Substantial damage
  > While on an aerial application flt during the ground roll the wind changed from a headwind to a tailwind. The plt dumped the load of chemical in an attempt to climb but the acft crashed into a fish pond.
- [NTSB CHI88DEI02](https://openairdocs.org/ntsb/CHI88DEI02.md): Geddes Commander 503 · North Lima, OH · Accident · Serious injuries · Final report · Jul 18, 1988 · N9173W · Substantial damage
  > Pilots continued operation of the aircraft with a known deficiency and attempting to stretch his partial power descent to reach a runway rather than land off airport.
- [NTSB NYC88LA184](https://openairdocs.org/ntsb/NYC88LA184.md): Mooney M20F · Princeton, NJ · Accident · No injuries · Limited investigation · Final report · Jul 17, 1988 · N6310Q · Substantial damage
  > The Mooney M20F made a takeoff and as the pilot turned crosswind, he experienced a partial power loss. He returned for a landing and the engine smoothed out. He made extensive ground runs and could not duplicate the problem. However he did not have…
- [NTSB NYC88LA183](https://openairdocs.org/ntsb/NYC88LA183.md): Aeronca S11BC · Livingston Mnr, NY · Accident · No injuries · Limited investigation · Final report · Jul 16, 1988 · N3988E · Destroyed
  > The pilot had just departed from the surface of a lake, when at an altitude of 50 ft AGL and in a left turn, the engine quit. There was not enough altitude to make it back to the lake. The aircraft impacted trees and was destroyed. The pilot had experienced…
- [NTSB LAX88LA259](https://openairdocs.org/ntsb/LAX88LA259.md): Cessna R172K · Corona, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1988 · N736HQ · Substantial damage
  > During takeoff the engine failed to develop full power & the acft collided with trees located approx 500 ft beyond the runway. Exam of the engine revealed the mixture control arm at its fuel pump housing attachment point had restricted movement & was…
- [NTSB LAX88FA258](https://openairdocs.org/ntsb/LAX88FA258.md): Piper PA-28-140 · Compton, CA · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1988 · N40808 · Destroyed
  > The student plt was taking his 2 grandchildren & 1 of their friends on a local flt. Ground witnesses observed the airplane lift off and continue in an excessively high angle of attack climb attitude. When the airplane reached abt 150 ft a.g.l. it stalled,…
- [NTSB FTW88DRG11](https://openairdocs.org/ntsb/FTW88DRG11.md): Enstrom F28A · Port Isabel, TX · Accident · No injuries · Final report · Jul 16, 1988 · N9087 · Substantial damage
  > The pilot reported that he had accomplished a max-performance takeoff, cleared an obstacle, and when he attempted forward flight, the main rotor RPM decreased. He stated he was unable to recover the RPM and maintain altitude so he selected a landing area. Due…
- [NTSB SEA88LA130](https://openairdocs.org/ntsb/SEA88LA130.md): Cessna 150G · Athol, ID · Accident · No injuries · Limited investigation · Final report · Jul 14, 1988 · N2886S · Substantial damage
  > The student pilot was practicing full stop landings. He failed to raise the flaps from full down after the previous landing. On the subsequent takeoff, the aircraft became airborne prematurely. The pilot reduced the power and the aircraft stall/mushed onto…
- [NTSB ATL88LA216](https://openairdocs.org/ntsb/ATL88LA216.md): Cessna 172L · Michie, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 1988 · N19632 · Substantial damage
  > Witness reported that the airplane engine was running rough during takeoff; the airplane subsequently disappeared from sight in a nose-down attitude. The plt later reported that he could not remember the events that led up to the power loss. Post-crash exam…
- [NTSB LAX88FA252](https://openairdocs.org/ntsb/LAX88FA252.md): Beech A35 · Lompoc, CA · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1988 · N27EB · Destroyed
  > Pilot's improper use of the fuel system and his failure to maintain control of his aircraft. Contributing factors were the pilot's intentional operation of an aircraft with known deficiencies in equipment, his improper emergency procedure and his lack of…
- [NTSB FTW88LA130](https://openairdocs.org/ntsb/FTW88LA130.md): Cessna 152 · Slidell, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1988 · N25999 · Substantial damage
  > The student pilot landed on the private strip to pick up a passenger. The pilot reported that after takeoff he smelled smoke and almost immediately, the engine started cutting out. The airplane impacted the tops of tall trees, thena fence, and then impacted…
- [NTSB FTW88DRD15](https://openairdocs.org/ntsb/FTW88DRD15.md): Cessna A188B · Patterson, LA · Accident · No injuries · Final report · Jul 12, 1988 · N4825Q · Substantial damage
  > Shortly after takeoff, the engine lost power & the plt dumped his load. Subsequently, the acft crash landed in a cane field. No preimpact mechanical problems could be found with the engine or fuel system. Water was found in the fuel tank outlet screen,…
- [NTSB DEN88LA147](https://openairdocs.org/ntsb/DEN88LA147.md): Cessna 150C · Fort Peck, MT · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1988 · N7940Z · Substantial damage
  > The pilot made a takeoff from a muddy, dirt, road. He said that after he become airborne he put his aircraft into a sharp turn in order to avoid some power lines. Although he was successful in avoiding the power lines, he inadvertently stalled the aircraft…
- [NTSB CHI88DEP06](https://openairdocs.org/ntsb/CHI88DEP06.md): Huntley Challenger II · Platteville, WI · Accident · No injuries · Final report · Jul 12, 1988 · N51012 · Substantial damage
  > After climbing about 100' after takeoff, a partial power loss occurred & the plt initiated a left turn to rtrn to the arpt. Unable to reach the arpt, an emerg lndg was made in a corn field & the acft was damaged. No airframe failure was found & the eng ran…
- [NTSB NYC88LA180](https://openairdocs.org/ntsb/NYC88LA180.md): Champion 7GCAA · Lakewood, NJ · Accident · No injuries · Limited investigation · Final report · Jul 11, 1988 · N11088 · Substantial damage
  > Loss of directional control during landing, due to a banner towing rope being wrapped around the left rudder horn.
- [NTSB NYC88LA149](https://openairdocs.org/ntsb/NYC88LA149.md): Piper PA-28-161 · Fryeburg, ME · Accident · 1 fatal · Limited investigation · Final report · Jul 11, 1988 · N84493 · Destroyed
  > According to witnesses, the pilot had been drinking and two friends drove him to the airport and watched as he departed. They noted that the aircraft was climbing steeply after liftoff and then observed the aircraft's rotating beacon as the aircraft spiraled…
- [NTSB DEN88LA153](https://openairdocs.org/ntsb/DEN88LA153.md): Piper PA-22-150 · Spearfish, SD · Accident · No injuries · Limited investigation · Final report · Jul 11, 1988 · CGCCF · Substantial damage
  > The accident involved a tri-pacer with four persons and about 150 pounds of baggage on board who were from Canada and vacationing in the U.S. The pilot said the acft became airborne and climbed to about 100 ft above the rwy, but would not maintain altitude…
- [NTSB NYC88LA179](https://openairdocs.org/ntsb/NYC88LA179.md): Waco UPF-7 · Plymouth, NH · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N32126 · Substantial damage
  > The plt reported that the eng lost power during takeoff as the acft was climbing thru about 200 to 250 ft AGL. Unable to restore power, he turned to land in a corn field, but was unable to reach it. He then selected a smaller field, but during the landing,…
- [NTSB MKC88DCG01](https://openairdocs.org/ntsb/MKC88DCG01.md): Boeing 75A · Neosho, MO · Accident · Serious injuries · Final report · Jul 9, 1988 · N450LR · Substantial damage
  > Witnesses stated that just after liftoff, they observed a map blow out of the a/c. the pilot stated he saw something go past and turned to see what it was. He inadvertently pushed the stick forward and hit the runway nose-first. The pilot stated that he was…
- [NTSB DEN88LA149](https://openairdocs.org/ntsb/DEN88LA149.md): Piper PA-28R-200 · Cheyenne, WY · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 1988 · N4329F · Substantial damage
  > The flight originated in omaha, NE. Three passengers and the commercial plt embarked on a fishing trip into Wyoming. The pilot departed Cheyenne after having several problems with the engine and correcting the problem by proper leaning. He said he took off…
- [NTSB CHI88DEX07](https://openairdocs.org/ntsb/CHI88DEX07.md): Cessna 175A · Bloomington, IN · Accident · Minor injuries · Final report · Jul 8, 1988 · N8059T · Substantial damage
  > Aircraft experienced partial loss of engine power at 150 feet AGL after takeoff. Pilot made 180 degree turn in attempt to return to airport, but experienced further power loss and elected to make emergency landing in field. Right wingtip hit tree, and…
- [NTSB ATL88FA210](https://openairdocs.org/ntsb/ATL88FA210.md): Cessna 210L · St. Marys, GA · Accident · Serious injuries · Field investigation · Final report · Jul 7, 1988 · N732JV · Substantial damage

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=161

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

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