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

## Cases, newest first

- [NTSB CHI89MA046](https://openairdocs.org/ntsb/CHI89MA046.md): Boeing 737-201 · Chicago, IL · Accident · No injuries · Major investigation · Final report · Jan 20, 1989 · N242US · Substantial damage
  > Previous damage to the aft cone (engine mounting) bolt, which resulted in mismatched surfaces between the bolt and isolation mount, loss of torque during cyclic loading of the mounting bolt, and subsequent fatigue failure of the bolt.
- [NTSB FTW89LA041](https://openairdocs.org/ntsb/FTW89LA041.md): Douglas DC-3 · Laredo, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1989 · XBDYP · Destroyed
  > The pic's disregard for the security of the cargo that permitted its shift during the takoeff roll. This resulted in an aft CG situation and a subsequent stall and loss of aircraft control. A contributing factor in the accident was the mismanagement of the…
- [NTSB ATL89LA079](https://openairdocs.org/ntsb/ATL89LA079.md): Cessna 172 · Williamsburg, OH · Accident · Minor injuries · Limited investigation · Final report · Jan 19, 1989 · N8774B · Substantial damage
  > A defective gasket in the fuel strainer which caused a restriction in fuel flow during climbout.
- [NTSB NYC89LA068](https://openairdocs.org/ntsb/NYC89LA068.md): Robinson R-22HP · Ronkonkoma, NY · Accident · Serious injuries · Limited investigation · Final report · Jan 18, 1989 · N9021M · Substantial damage
  > The pilot's improper operation of the rotorcraft flight controls and a resulting low rotor RPM condition.
- [NTSB NYC89LA069](https://openairdocs.org/ntsb/NYC89LA069.md): Beech S-35 · Bridgeport, CT · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 1989 · N6829Q · Substantial damage
  > The improper fuel selector position and loss of power to the engine due to fuel exhaustion.
- [NTSB CHI89LA044](https://openairdocs.org/ntsb/CHI89LA044.md): Cessna 150J · Osceola, WI · Accident · No injuries · Limited investigation · Final report · Jan 15, 1989 · N61306 · Substantial damage
  > Inadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.
- [NTSB DEN89FA061](https://openairdocs.org/ntsb/DEN89FA061.md): Piper PA-24-180 · Albuquerque, NM · Accident · 1 fatal · Field investigation · Final report · Jan 14, 1989 · N5983P · Destroyed
  > Engine stoppage from fuel starvation which resulted from the pilot's failure to select the fullest tank for takeoff. In addition the pilot attempted to return to the airport during the forced landing and inadvertently stalled the aircraft during the…
- [NTSB ATL89LA073](https://openairdocs.org/ntsb/ATL89LA073.md): Cessna 182P · Hamilton, OH · Accident · No injuries · Limited investigation · Final report · Jan 14, 1989 · N21531 · Substantial damage
  > The pilot's improper use of the carburetor heat control which resulted in a loss of engine power. Contributing to the accident were conditions conducive to carburetor ice.
- [NTSB MKC89LA049](https://openairdocs.org/ntsb/MKC89LA049.md): Cessna 172 · Chadron, NE · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1989 · N3799R · Substantial damage
  > The plt failed to devote full time & attention to flying the acft, with a resulting loss of control and collision with the ground. Contributing to the accident was the dark night conditions.
- [NTSB NYC89LA064](https://openairdocs.org/ntsb/NYC89LA064.md): Cessna 152 · Stratford, CT · Accident · No injuries · Limited investigation · Final report · Jan 7, 1989 · N757KR · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CHI89DEX03](https://openairdocs.org/ntsb/CHI89DEX03.md): Grumman American AA-1C · Richmond, IN · Accident · No injuries · Final report · Jan 5, 1989 · N39000 · Substantial damage
  > The pilot's attempt to continue the takeoff with a partial loss of power. Contributing to the accident were the carburetor icing conditions.
- [NTSB DEN89LA054](https://openairdocs.org/ntsb/DEN89LA054.md): Cessna 172M · Erie, CO · Accident · No injuries · Limited investigation · Final report · Dec 31, 1988 · N80650 · Substantial damage
  > The pilot said that he made a normal preflight and engine runup prior to takeoff on runway 33 at the tri-county airport, Erie, Colorado. A normal takeoff was made but he said that as the aircraft reached 200 feet, the engine lost about 400 RPM. When he…
- [NTSB DEN89LA051](https://openairdocs.org/ntsb/DEN89LA051.md): Beech B24R · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Dec 31, 1988 · N65PW · Substantial damage
  > The non-instrument rated plt rcvd a wx briefing & filed an IFR flt pln. He tkof on rwy 34 at 1517 MST with low ceiling &restricted vis due to fog & lgt snow. The twr ctlr saw the acft lift-off at the rwy's end, then lost sight of it. Soon thereafter, the plt…
- [NTSB NYC89LA061](https://openairdocs.org/ntsb/NYC89LA061.md): Navion NA-1 · Allentown, PA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1988 · N2518T · Substantial damage
  > The pilot stated that he experienced a loss of power shortly after takeoff and landed back on the runway. The landing was hard and the right wing was damaged. The FAA investigator checked the engine and fuel system for possible contaminants and water. No…
- [NTSB MKC89LA047](https://openairdocs.org/ntsb/MKC89LA047.md): Piper PA-28 · Derby, KS · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1988 · N2213T · Substantial damage
  > Drg an eng run-up before a simulated instrument flt, the crew noticed the carb heat control would only move about 1/2 of its normal travel. The plts discussed the malfunction & ran the eng for another 1 to 2 min until the oil temp gauge indcd a temp rise. Drg…
- [NTSB LAX89LA071](https://openairdocs.org/ntsb/LAX89LA071.md): Univair Globe GC-1B · Chino, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1988 · N3388K · Substantial damage
  > **This report was modified on 2/24/2016. Please refer to the public docket for this accident for additional information.** The pilot's failure to maintain airspeed during an emergency landing following an inflight loss of engine power, resulting in an…
- [NTSB CHI89FA036](https://openairdocs.org/ntsb/CHI89FA036.md): Beech B23 · Jeffersonville, IN · Accident · 4 fatal · Field investigation · Final report · Dec 26, 1988 · N6100N · Destroyed
  > Pilot-in-command's poor inflight decision in attempting to return to the airport after a partial engine failure, and his encountering a stall/spin at low altitude from which he was unable to recover.
- [NTSB NYC89FA056](https://openairdocs.org/ntsb/NYC89FA056.md): Beech A36 · Harrison, NY · Accident · 3 fatal · Field investigation · Final report · Dec 24, 1988 · N555ST · Destroyed
  > The plt was clrd for an IFR departure from rwy 16 in instrument meteorological conditions (IMC). His departure clnc was to climb on rwy heading to 800 ft, then turn right to a heading of 320 deg. When the acft took off, tower psnl did not have visual contact…
- [NTSB MKC89LA046](https://openairdocs.org/ntsb/MKC89LA046.md): Beech A23A · California, MO · Accident · No injuries · Limited investigation · Final report · Dec 24, 1988 · N2364W · Substantial damage
  > The pvt pilot said while attempting a downwind takeoff on a dark night from an unlighted sod strip, he received an intermittent stall warning horn shortly after lift-off. He lowered the nose and the acft struck the runway and rebounded into the air. He said…
- [NTSB DEN89LA049](https://openairdocs.org/ntsb/DEN89LA049.md): Piper PA-11 · Winnett, MT · Accident · No injuries · Limited investigation · Final report · Dec 23, 1988 · N5570H · Substantial damage
  > The pilot was taking off from a farm strip with a 10 kt head wind. The plt said the sun was shining at the time of the acdt but there had been snow showers in the area. He said the liftoff was normal but at about 15 to 18 ft AGL the acft stalled and crashed.…
- [NTSB MIA89LA053](https://openairdocs.org/ntsb/MIA89LA053.md): Pilatus P-2/05 · St. Augustine, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 19, 1988 · N109PL · Destroyed
  > After an en route stop, the pilot took off in the newly acquired acft. Shortly after gear and flap retraction, the eng sustained a partial loss of power. The plt stated that all eng gages appeared normal and a turn was begun in an attempt to return to the…
- [NTSB DEN89LA044](https://openairdocs.org/ntsb/DEN89LA044.md): Cessna 150E · Basin, WY · Accident · No injuries · Limited investigation · Final report · Dec 17, 1988 · N6122T · Substantial damage
  > The private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…
- [NTSB NYC89LA048](https://openairdocs.org/ntsb/NYC89LA048.md): Enstrom F28F · Bradford, NH · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 1988 · N5699M · Substantial damage
  > An inflight contact with trees during takeoff after the student pilot experienced a loss of control due to his failure to adequately compensate for the winds.
- [NTSB MIA89LA049](https://openairdocs.org/ntsb/MIA89LA049.md): Cessna 182E · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Dec 10, 1988 · N9261X · Substantial damage
  > Shortly after rotation at an alt of aprx 20 ft AGL, the plt stated the control column would not move. He closed the throttle & the acft landed hard, bounced, then came to rest off the rwy. Examination of the acft revealed 3 of the 4 lower instrument panel…
- [NTSB MKC89LA035](https://openairdocs.org/ntsb/MKC89LA035.md): Piper PA-28-160 · Crete, NE · Accident · Serious injuries · Limited investigation · Final report · Dec 8, 1988 · N5875W · Substantial damage
  > The pvt pilot said shortly after takeoff, the engine coughed, sputtered, then quit. An emergency ldg was attempted on a farm field which resulted in substantial damage to the acft, serious injury to the pax and minor injuries to the pilot. Post accident…
- [NTSB LAX89LA060](https://openairdocs.org/ntsb/LAX89LA060.md): Piper PA-28 · Carlsbad, CA · Accident · No injuries · Limited investigation · Final report · Dec 5, 1988 · N706FL · Substantial damage
  > During the initial climb after takeoff, the engine lost power. Subsequently, the airplane collided with terrain as the plt was completing an emergency landing. An examination of the fuel tanks disclosed no evidence of fuel in the left tank. However, aprx 9…
- [NTSB FTW89LA027](https://openairdocs.org/ntsb/FTW89LA027.md): Cessna 172B · Plano, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 3, 1988 · N7917X · Substantial damage
  > Fuel exhaustion which resulted from the pilot's inadequate fuel consumption calculations and his failure to utilize numerous suitable sources of fuel along his route of flight.
- [NTSB ATL89DMG01](https://openairdocs.org/ntsb/ATL89DMG01.md): Flagg Teenie TWO · Albemarle, NC · Accident · 1 fatal · Final report · Dec 3, 1988 · N4831Y · Substantial damage
  > Reportedly, the 150-hour pilot owner was performing a high speed taxi run to get acquainted with the airplane and its controls. The airplane taxiied down runway 22, using 3000 feet of the 4700 foot runway and suddenly became airborne. The flight continued to…
- [NTSB LAX89DVD01](https://openairdocs.org/ntsb/LAX89DVD01.md): Hitchcock JH-1 · Petaluma, CA · Accident · 1 fatal · Final report · Dec 2, 1988 · N58EE · Destroyed
  > Plt was on initial flt in newly-built gyrocopter. After takeoff, witnesses observed the acft to climb to about 100 feet then to nose over until ground impact. No evidence of mechanical failure was found.
- [NTSB MKC89DCJ01](https://openairdocs.org/ntsb/MKC89DCJ01.md): Piper PA-17 · Omaha, NE · Accident · 1 fatal · Final report · Nov 28, 1988 · N4691H · Substantial damage
  > Witnesses observed the airplane takeoff and climb steeply to about 100 feet above ground. The airplane then turned sharply to the right and crashed into the ground in a nose low attitude. Investigation revealed no problems with either engine or airframe.
- [NTSB MIA89IA043](https://openairdocs.org/ntsb/MIA89IA043.md): Airbus Industrie A-300-600 · San Juan, PR · Incident · Minor injuries · Incident investigation · Final report · Nov 28, 1988 · N80057 · Minor damage
  > Company maintenance crews replaced the high pressure bleed valve prior to the flight and installed the mounting clamp improperly. After takeoff the valve disconnected and the bleed air discharge activated the fire warning system. The crew discharged both fire…
- [NTSB NYC89LA039](https://openairdocs.org/ntsb/NYC89LA039.md): Piper PA-28-181 · Danielson, CT · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 1988 · N8172P · Destroyed
  > Failure of the pilot to recognize a stall and take corrective action prior to experiencing a loss of control.
- [NTSB MKC89LA026](https://openairdocs.org/ntsb/MKC89LA026.md): Piper PA-22-135 · Salisbury, MO · Accident · No injuries · Limited investigation · Final report · Nov 22, 1988 · N8927C · Substantial damage
  > The pilot said shortly after takeoff the engine lost power. He attempted to land on a plowed field, and after rolling about fifty yards on the rough, soft terrain, the aircraft nosed over. Post accident investigation revealed the engine lost power due to fuel…
- [NTSB MKC89LA028](https://openairdocs.org/ntsb/MKC89LA028.md): Piper PA-12 · Lino Lakes, MN · Accident · No injuries · Limited investigation · Final report · Nov 20, 1988 · N12MZ · Substantial damage
  > Shortly after takeoff and climbing to about 150 AGL, the pilot said the engine began sputtering and losing power. Attempts to correct the situation by pumping the throttle and working the engine primer failed to correct the situation, and shortly thereafter…
- [NTSB NYC89FA033](https://openairdocs.org/ntsb/NYC89FA033.md): Beech A35 · Shirley, NY · Accident · 3 fatal · Field investigation · Final report · Nov 18, 1988 · N8697A · Destroyed
  > Loss of control during takeoff, due to the failure (separation) of the right rudder control cable. Contributing to the accident was improper inspection and maintenance of the cable.
- [NTSB CHI89FA026](https://openairdocs.org/ntsb/CHI89FA026.md): Mitsubishi MU-2B-60 · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Nov 17, 1988 · N271MA · Destroyed
  > The first takeoff was aborted due to a perceived engine problem. Six minutes later on second takeoff, the aircraft climbed to 50 feet, drifted to the right, rolled right and impacted in the infield. This was a single pilot operation in a complex aircraft.…
- [NTSB LAX89LA044](https://openairdocs.org/ntsb/LAX89LA044.md): Enstrom F-28C · Inyokern, CA · Accident · No injuries · Limited investigation · Final report · Nov 16, 1988 · N552CS · Destroyed
  > The pilot stated that, 'I landed in an open unpopulated area for the mechanic... To make adjustments on the main blade (we were tracking and balancing the blades). I never shut the engine down. I disengaged the clutch. After the adjustment was made, I…
- [NTSB ATL89LA037](https://openairdocs.org/ntsb/ATL89LA037.md): Cessna R172E · Lawrenceville, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 1988 · N96164 · Substantial damage
  > Improper repair and/or modification of the carburetor airbox by unknown person(s), and the subsequent failure of maintenance personnel to detect the improper repair/modification during annual inspection(s), which led to a loss of power due to carburetor…
- [NTSB CHI89LA024](https://openairdocs.org/ntsb/CHI89LA024.md): Piper PA-31-350 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Nov 14, 1988 · N6292 · Substantial damage
  > The plt rprtd that immediately after rotation & drg the initial climb, the rgt eng began to backfire & run rough. When the eng contd to run rough in spite of attempts to smooth it out, the plt elected to abort the takeoff. At that time, the acft was at about…
- [NTSB CHI89DEV03](https://openairdocs.org/ntsb/CHI89DEV03.md): Ryan Navion · Lane, IL · Accident · No injuries · Final report · Nov 14, 1988 · N91411 · Substantial damage
  > Airplane landed in a plowed field after losing power during initial climb. The flight purpose was to accomplish a biennial flight review. The landing gear failed after digging into the soft dirt of the plowed field. During the investigation the acft owner…
- [NTSB LAX89LA047](https://openairdocs.org/ntsb/LAX89LA047.md): Beech H35 · Corning, CA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1988 · N5594D · Destroyed
  > The flt originated at hayward, CA, with a stop at san carlos, CA and Corning, CA. The plt's destination was the red bluff arpt (rbl). The plt reported that when he departed hayward both main fuel tanks were full. He flew to san carlos where he picked up three…
- [NTSB BFO89LA008](https://openairdocs.org/ntsb/BFO89LA008.md): Cessna 207 · Topping, VA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1988 · N73114 · 2 aircraft · Minor damage
  > The pilot of N76470 departed on rwy 18 and followed the noise abatement procedure before turning downwind for rwy 18. The pilot of N73114 departed the grass rwy 18 and flew the noise abatement procedure prior to turning to a heading of 070 deg to depart the…
- [NTSB MKC89LA022](https://openairdocs.org/ntsb/MKC89LA022.md): Piper PA-28-180 · Mena, AR · Accident · No injuries · Limited investigation · Final report · Nov 11, 1988 · N9109J · Substantial damage
  > On left crosswind leg, during initial climb, the aircraft experienced a total loss of power. The acft had reached about 800 feet AGL and was about 1 1/2 miles from the departure end of the runway. An emergency ldg was attempted which resulted in substantial…
- [NTSB ANC89LA016](https://openairdocs.org/ntsb/ANC89LA016.md): Cessna 180 · Meshik Lake, AK · Accident · No injuries · Limited investigation · Final report · Nov 11, 1988 · N420SB · Substantial damage
  > The pilot was attempting to takeoff from an unimproved landing area with two hunter-friends. He stated that the aircraft bounced three times, reached an altitude of about four feet, then hit the ten-foot high trees at the departure end of the area and nosed…
- [NTSB MIA89LA022](https://openairdocs.org/ntsb/MIA89LA022.md): Cessna 152 · Gainesville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 1988 · N6578B · Substantial damage
  > The plt taxied to rwy 6 & made an eng run-up. As he called the twr for tkof, a navy P-3 was making a low apch to rwy 10.the plt was told to taxi to rwy 10. Abt 30 sec later, as he arrived at rwy 10, he was clrd for tkof & was cautioned abt wake turbc fm the…
- [NTSB LAX89LA039](https://openairdocs.org/ntsb/LAX89LA039.md): Aerospatiale TB-20 · Yucca Valley, CA · Accident · No injuries · Limited investigation · Final report · Nov 5, 1988 · N94TB · Substantial damage
  > The student plt and the CFI agreed that the acft developed a high sink rate as it passed over the departure end of the dirt rwy. The acft collided with the ground about 3/4 mile from the rwys end. The winds were variable but basically from the south at 15-20…
- [NTSB LAX89LA040](https://openairdocs.org/ntsb/LAX89LA040.md): Mooney M20J · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Nov 4, 1988 · N3875H · Substantial damage
  > During the initial climb after takeoff, the engine lost partial power. A turn was made to land on rwy 10R, but the pilot was unable to reach the landing area. Subsequently, he made a wheels-up landing short of the runway. An inspectionof the engine revealed…
- [NTSB FTW89FA013](https://openairdocs.org/ntsb/FTW89FA013.md): Aerospatiale AS-355F-1 · W. Cameron 617 · Accident · 4 fatal · Field investigation · Final report · Nov 4, 1988 · N355EH · Destroyed
  > The loss of control of the aircraft which occurred when the tail rotor drive shaft experienced a fatigue induced material failure and tail rotor thrust was lost. Evidence indicated that the shaft was under designed for the loads that were encountered during…
- [NTSB LAX89LA033](https://openairdocs.org/ntsb/LAX89LA033.md): Champion 7FC · Hesperia, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 3, 1988 · N9874Y · Destroyed
  > Witnesses rprtd that the winds at the arpt were out of the west at about 20 KTS with peak gusts of about 37 KTS. They stated the wind sock was indicating a direct x-wind with rwy 3/21 & that the plt initiated his takeoff on rwy 21. Witnesses rprtd that during…
- [NTSB LAX89FA034](https://openairdocs.org/ntsb/LAX89FA034.md): Bell 47G2 · Phoenix, AZ · Accident · 1 fatal · Field investigation · Final report · Nov 3, 1988 · N5163B · Destroyed
  > Loss of aircraft control by a unqualified person.

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

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

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