# 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 161 of 412 · 20,559 cases ## Cases, newest first - [NTSB MIA88FA214](https://openairdocs.org/ntsb/MIA88FA214.md): Bellanca 17-30A · Clearwater, FL · Accident · 1 fatal · Field investigation · Final report · Jul 5, 1988 · N399AC · Destroyed > The private pilot experienced a rough running engine on takeoff roll and continued the takeoff. After liftoff the engine failed and he crashed into a residence. The engine fuel control and fuel divider block were found to have water, rust and sand in them.… - [NTSB DEN88LA145](https://openairdocs.org/ntsb/DEN88LA145.md): Sikorsky S-58J · Sioux Falls, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1988 · N62243 · Substantial damage > N62243 was being used to lift air conditioning units to the top of a shopping mall. The plt stated that he was on the 16th lift of the day and had just taken off when he heard two loud pops and the engine lost power. After jettisoning the load he executed an… - [NTSB SEA88FA122](https://openairdocs.org/ntsb/SEA88FA122.md): Cessna TU-206-G · Root Ranch, ID · Accident · 5 fatal · Field investigation · Final report · Jul 3, 1988 · N732HH · Destroyed > Shortly after takeoff, prior to reaching 500 feet AGL, the pilot lost control of the aircraft and struck trees. After striking trees the aircraft then impacted the ground and exploded into flames. Witnesses stated that from the time of rotation to the time… - [NTSB NYC88LA194](https://openairdocs.org/ntsb/NYC88LA194.md): Champion 7ECA · Bally, PA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1988 · N11061 · Substantial damage > The plt was taking off with a left tailwind/crosswind. At liftoff, the left wing dropped and the pilot attempted to correct with rudder. The acft collided with the terrain. - [NTSB BFO88FA063](https://openairdocs.org/ntsb/BFO88FA063.md): Piper PA-23 · Friendly, MD · Accident · No injuries · Field investigation · Final report · Jul 2, 1988 · N1021P · Substantial damage > Shortly after takeoff at an altitude of 200 ft AGL, a power loss was experienced on the left engine. According to the plt, when the throttle was retarded to verify the engine failure, the engine seemed to 'come back to life'. The throttle was advanced and… - [NTSB DEN88DTE06](https://openairdocs.org/ntsb/DEN88DTE06.md): Helfrich-Leonard BD-5B · Englewood, CO · Accident · No injuries · Final report · Jul 1, 1988 · N250TH · Substantial damage > This experimental acft is powered by a modified honda 1250 cc, watercooled eng. The plt reported that after takeoff the eng temp reached the redline and the eng lost power. During the forced landing the main landing gear collapsed. Examination of the eng… - [NTSB NYC88DHD02](https://openairdocs.org/ntsb/NYC88DHD02.md): Darlington Monnett Moni · Vincentown, NJ · Accident · Minor injuries · Final report · Jun 29, 1988 · N2276R · Substantial damage > The plt was on his 1st flt in the home built acft. During the initial climb after takeoff, he diverted his attention from the airspeed indicator to other instruments. He believed that he may have inadvertently pulled up the nose at that time. Subsequently,… - [NTSB LAX88LA239](https://openairdocs.org/ntsb/LAX88LA239.md): Cessna 206F · Healdsburg, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1988 · N33284 · Substantial damage > Just after takeoff the engine lost power. A forced landing was made in a field where the airplane collided with rough terrain. Inspection of the engine revealed evidence of corrosion in the main fuel sump bowl and on the fuel injection throttle body fuel… - [NTSB FTW88DPJ07](https://openairdocs.org/ntsb/FTW88DPJ07.md): Northrop C-125A · Tulsa, OK · Accident · Minor injuries · Final report · Jun 29, 1988 · N3756Q · Substantial damage > The pilot did not hold a type rating or written authorization to act as pilot in command. The co-pilot did not hold a type rating or written authorization to act as second in command and his medical had expired. The aircraft did not have an airworthiness… - [NTSB BFO88DIA01](https://openairdocs.org/ntsb/BFO88DIA01.md): Terry Osprey II · Manassas, VA · Accident · Serious injuries · Final report · Jun 29, 1988 · N70J · Destroyed > The pilot reported that on initial climb at an alt of 300 ft AGL, engine power began to decay. A right turn was initiated to return to the runway but a further loss of power was experienced and a forced landing was attempted in a field. The acft contacted… - [NTSB CHI88FA144](https://openairdocs.org/ntsb/CHI88FA144.md): Cessna 150G · Ft Wayne, IN · Accident · 1 fatal · Field investigation · Final report · Jun 28, 1988 · N4744X · Destroyed > Inadvertent stall/spin due to the failure to maintain adequate airspeed, and failure to avoid the adverse wind conditions associated with a thunderstorm. - [NTSB ATL88LA202](https://openairdocs.org/ntsb/ATL88LA202.md): Piper J3C-65 · Whitsett, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1988 · N2875Y · Substantial damage > The plt reported that the engine lost power during initial climb at 150 ft AGL. He attempted to make a 180 deg turn back to the arpt; the airplane crashed at about the 180 deg point. Post-crash exam of the engine revealed no evidence of mechanical failure or… - [NTSB MIA88LA208](https://openairdocs.org/ntsb/MIA88LA208.md): Cessna 150M · Davisville, FL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1988 · N704MN · Substantial damage > Acft's engine had over 200 RPM drop on one magneto during runup. Plt attempted to takeoff with the engine running rough. After liftoff the engine began to backfire and lose power. The plt stated he then applied carburetor heat and pumped the engine primer.… - [NTSB LAX88LA236](https://openairdocs.org/ntsb/LAX88LA236.md): Cessna 152 · Lake Tahoe, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 1988 · N23TW · Substantial damage > During the initial climb the pilot was unable to sustain a positive climb rate. The acft collided with a tree at the end of the runway and, subsequently, the ground. There were no reported mechanical failures or malfunctions. The density altitude was about… - [NTSB LAX88LA232](https://openairdocs.org/ntsb/LAX88LA232.md): Beech B35 · Weaverville, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1988 · N5354E · Substantial damage - [NTSB FTW88LA124](https://openairdocs.org/ntsb/FTW88LA124.md): Mooney M20J · Portland, TX · Accident · No injuries · Limited investigation · Final report · Jun 24, 1988 · N201ZP · Substantial damage > The pilot dragged the lower empennage on the runway during the takeoff rotation. A premature liftoff resulted and the aircraft recontacted the runway twice before the aircraft passed the runway end. Thereafter, the aircraft collided with a powerline before… - [NTSB BFO88LA058](https://openairdocs.org/ntsb/BFO88LA058.md): Sikorsky S-76A · Moundsville, WV · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1988 · N54C · Destroyed > The helicopter contacted power lines shortly after takeoff from a mine site. The nose gear of the helicopter contacted an uninsulated static wire. This wire was strung with one other static wire and two black insulated power lines. Both crew members stated… - [NTSB CHI88LA139](https://openairdocs.org/ntsb/CHI88LA139.md): Piper PA-28R-201 · Noblesville, IN · Accident · No injuries · Limited investigation · Final report · Jun 22, 1988 · N36472 · Substantial damage > During initial climbout the pilot stated that he experienced a partial loss of power and was unable to maintain sufficient rate of climb to continue flight. The pilot executed a forced landing in a field, striking trees. Post-accident investigation failed to… - [NTSB ATL88LA197](https://openairdocs.org/ntsb/ATL88LA197.md): Aeronca 0-58B · Newberry, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1988 · N47190 · Destroyed > The pilot related that he had been flying around the local area making landings at various airports for about 1 1/2 hours. He returned to the departure airport and made a full stop landing. His 12 year old son requested that he make another takeoff and… - [NTSB NYC88DFA02](https://openairdocs.org/ntsb/NYC88DFA02.md): Terry Tierra II · Plattsburgh, NY · Accident · 1 fatal · Final report · Jun 20, 1988 · N4462T · Substantial damage > According to witnesses, the plt was on his 2nd flt of the day in a recently purchased ultralight type of acft. They rprtd that after the acft took off from rwy 32, it climbed to about 300' AGL & rolled into a steep right bank. Its nose then dropped & the acft… - [NTSB MIA88FA201](https://openairdocs.org/ntsb/MIA88FA201.md): Smith, Ted Aerostar Aerostar 600 · Catano, PR · Accident · 1 fatal · Field investigation · Final report · Jun 20, 1988 · N90360 · Destroyed > As the acft was taxiing for takeoff, witnesses noted the l rear baggage door was unlocked & hanging down. A warning was relayed to the plt via the twr, but by then the acft was airborne & the plt had rprtd a control prblm. Drg lift-off, theacft pitched up… - [NTSB LAX88DVG05](https://openairdocs.org/ntsb/LAX88DVG05.md): Schweizer G-164B · Gridley, CA · Accident · No injuries · Final report · Jun 20, 1988 · N8487K · Destroyed - [NTSB CHI88DER10](https://openairdocs.org/ntsb/CHI88DER10.md): Anderson-Tucker Evans VP-1 · Duquette, MN · Accident · No injuries · Final report · Jun 20, 1988 · N17BL · Substantial damage > On the initial flight of this amateur built aircraft the pilot lowered the nose after liftoff to allow the aircraft to accelerate. However, the aircraft settled and the pilot was unable to keep the aircraft from colliding with trees. - [NTSB LAX88DVA08](https://openairdocs.org/ntsb/LAX88DVA08.md): Smith Model B Avid Flyer · Atwater, CA · Accident · Serious injuries · Final report · Jun 18, 1988 · N249SJ · Destroyed > During a local test flight, just after takeoff, the engine suddenly lost power and went to idle. The pilot made an off airport landing without incident. The pilot inspected the engine finding nothing unusual. The pilot attempted another takeoff to return to… - [NTSB MKC88LA111](https://openairdocs.org/ntsb/MKC88LA111.md): Aero Commander 685 · Scranton, AR · Accident · No injuries · Limited investigation · Final report · Jun 16, 1988 · N165SE · Substantial damage > Shortly after takeoff from a 2400 foot sod strip, the PIC said the acft began to settle, although both engines were delivering takeoff power and RPM, and liftoff speeds were proper. The acft settled back to the runway and careened off on to the overrun… - [NTSB MIA88LA193](https://openairdocs.org/ntsb/MIA88LA193.md): Piper PA-32R-301T · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · Jun 16, 1988 · N4379A · Substantial damage > During takeoff from the grass strip, the left main landing gear and wingtip collided with runway lights & a fencepost. The acft was slow to climb. After clearing trees at the departure end of the rwy, the acft descended below treetop level, then continued to… - [NTSB MIA88FA192](https://openairdocs.org/ntsb/MIA88FA192.md): Bell 47G3B-1 · Benoit, MS · Accident · Serious injuries · Field investigation · Final report · Jun 15, 1988 · N73947 · Substantial damage > The plt said the engine misfired three times during takeoff and lost partial power. The helicopter settled into a rice field and the damaged spray booms became entangled. The helicopter nosed over in the high vegetation. The plt stated the engine accelerated… - [NTSB LAX88LA224](https://openairdocs.org/ntsb/LAX88LA224.md): Cessna 180K · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1988 · N2509K · Substantial damage > The plt attempted to takeoff in his conventional gear acft using rwy 21. The local wind was estimated at 180 degrees, 15 knots with gusts to 35 knots. The plt stated that immediately after rotating for takeoff 'a gust of wind caught us & threw us… - [NTSB MKC88LA110](https://openairdocs.org/ntsb/MKC88LA110.md): Cessna 188B · Dighton, KS · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1988 · N731CD · Substantial damage > During an aerial application operation, the plt said that as he initiated liftoff, the acft turned to the left and he felt he had no rudder control. He hit a fence on the apt boundary, continued, dumped his chemical load, hit a tree, and landed in a field… - [NTSB MIA88LA190](https://openairdocs.org/ntsb/MIA88LA190.md): Cessna 150J · Carthage, MS · Accident · No injuries · Limited investigation · Final report · Jun 13, 1988 · N50945 · Substantial damage > While on a personal flt, during the upwind leg after completion of the second touch-and-go landing, the plt reported that the eng sputtered. He then turned crosswind & attempted to land on a section of road under construction. Shortly before touchdown a… - [NTSB FTW88LA120](https://openairdocs.org/ntsb/FTW88LA120.md): Cessna 152 · Mounds, OK · Accident · No injuries · Limited investigation · Final report · Jun 13, 1988 · N94370 · Substantial damage > The instructor was demonstrating an engine out emergency to the student. The engine balked on the attempted go-around and he completed the landing. Thereafter, his first two takeoff attempts were aborted because of insufficient distance to complete the… - [NTSB LAX88DVD05](https://openairdocs.org/ntsb/LAX88DVD05.md): Kerlin Avid Flyer · Tracy, CA · Accident · No injuries · Final report · Jun 12, 1988 · N4642S · Substantial damage > During a local high speed taxi test, the airplane became airborne. Shortly after takeoff the engine quit. The airplane was landed straight ahead in an open field. During the landing roll, the airplane nosed over. The pilot did not report any mechanical… - [NTSB ANC88FA067](https://openairdocs.org/ntsb/ANC88FA067.md): De Havilland DHC-2 · Chugiak, AK · Accident · 1 fatal · Field investigation · Final report · Jun 10, 1988 · N48108 · Substantial damage > The pilot-in-command, a certified mechanic, performed his own maintenance on the acft. This maintenance required the removal, reinstallation & rigging of the ailerons. As the plt was taking off on the 1st flt after maintenance, the acft entered a roll after… - [NTSB FTW88FA115](https://openairdocs.org/ntsb/FTW88FA115.md): Cessna 340 · Georgetown, TX · Accident · 2 fatal · Field investigation · Final report · Jun 7, 1988 · N7828Q · Destroyed > The pilot in the right seat had hired the pilot in the left seat to ferry the airplane to germany, then to turkey. A four tank ferry fuel system was installed but a weight and balance check was not made. During the tkof, the acft would not climb. Afterward… - [NTSB FTW88DRD07](https://openairdocs.org/ntsb/FTW88DRD07.md): Pezetel M-18 · Mer Rouge, LA · Accident · Minor injuries · Final report · Jun 7, 1988 · N4685R · Substantial damage > The ag airplane departed the strip with 3000 lbs of fertilizer. 200 yds later it settled in a rice field and flipped forward to the inverted. No mechanical problems were found. Elevation at takeoff was 150 ft MSL. Density altitude was 2272 ft. max allowable… - [NTSB MKC88LA108](https://openairdocs.org/ntsb/MKC88LA108.md): Grumman G-164-A · Wynne, AR · Accident · No injuries · Limited investigation · Final report · Jun 6, 1988 · N9695 · Substantial damage > Following the takeoff from a private strip near Wynne, Arkansas, the pilot reported that he failed to establish and maintain an adequate angle of climb with the heavily loaded condition of the aircraft. The aircraft impacted trees in the flight path, then… - [NTSB FTW88DPJ05](https://openairdocs.org/ntsb/FTW88DPJ05.md): Stinson 108-3 · Collinsville, OK · Accident · 1 fatal · Final report · Jun 6, 1988 · N4108C · Destroyed > The pilot experienced a loss of engine power during the takeoff leg. Post accident investigation revealed that the fuel selector was in the near closed position. This position only allowed a small percentage of the fuel to flow but would allow operation in… - [NTSB NYC88LA161](https://openairdocs.org/ntsb/NYC88LA161.md): Burkhart Grob G-103A · Franconia, NH · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N49443 · Substantial damage > During takeoff, turbulence was encountered and the student pilot had a hard time controlling the glider. As the instructor took control, the student released the tow rope. The instructor pushed the nose down and turned in an attempt to level the wings, but… - [NTSB MKC88DCD01](https://openairdocs.org/ntsb/MKC88DCD01.md): Bohnker Tierra II · Audubon, IA · Accident · No injuries · Final report · Jun 5, 1988 · N116LB · Substantial damage > The pilot stated that the takeoff run and liftoff appeared normal, but after liftoff the aircraft veered to the right (into the crosswind). The pilot attempted to correct with left rudder and aileron. When he was unsuccessful, he retarded throttle. The plane… - [NTSB DEN88LA123](https://openairdocs.org/ntsb/DEN88LA123.md): Helio H-295 · Encampment, WY · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1988 · N6454V · Destroyed > The plt stated he calculated the density altitude to have been 11,300 ft at takeoff. He said the acft was near max gross wt and that the grass strip he departed from was approx 1,500 ft long. The plt stated 'I was on the on the back side of the pwr curve as… - [NTSB DEN88LA122](https://openairdocs.org/ntsb/DEN88LA122.md): Beech C23 · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N9311S · Substantial damage > The private plt was taking off with three passengers for a personal transportation flight. The airplane left the runway and only gained about 50 feet AGL according to a witness. The plt reported that the aircraft reached 200 feet AGL. The airplane stalled and… - [NTSB CHI88LA127](https://openairdocs.org/ntsb/CHI88LA127.md): Taylorcraft L-2 · Three Rivers, MI · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1988 · N57502 · Substantial damage > The owner of the acft stated that he released the acft to the PIC so that he could 'checkout' another plt and help her with her tailwheel landings. During their fourth tkof, the plt being checked out attempted to climb out of ground effect with insufficient… - [NTSB CHI88LA126](https://openairdocs.org/ntsb/CHI88LA126.md): Taylorcraft BC12-D · Aledo, IL · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1988 · N95061 · Destroyed > During takeoff roll the pilot reported he experienced a loss of directional control and elected to lift the aircraft off the ground prematurely in an effort to avoid running into a cornfield. Unable to establish the proper rate of climb, and unable to clear… - [NTSB MIA88FA187](https://openairdocs.org/ntsb/MIA88FA187.md): Cessna 172N · Jacksonville, FL · Accident · Serious injuries · Field investigation · Final report · Jun 3, 1988 · N5245E · Substantial damage > The private pilot had been hired to ferry a recently purchased aircraft. He stated that the aircraft had not been flown for about 2 weeks. He had it refueled and checked the fuel tanks for water. After takeoff the engine failed at about 200 ft. he crashed… - [NTSB DEN88FA120](https://openairdocs.org/ntsb/DEN88FA120.md): Luscombe 8E · Grantsville, UT · Accident · 1 fatal · Field investigation · Final report · Jun 3, 1988 · N71646 · Destroyed > The acft was 1 of 3 that were lndd on a gravel road near a truck stop where the occupants had breakfast. Drg departure, the 1st 2 acft took off without incident. Witnesses rprtd that when the 3rd acft (N71646) took off, the plt began a left turn at about 75'… - [NTSB CHI88LA133](https://openairdocs.org/ntsb/CHI88LA133.md): Alon A2 · Flushing, MI · Accident · No injuries · Limited investigation · Final report · Jun 2, 1988 · N6589Q · Substantial damage > During initial takeoff climb the acft experienced a loss of engine power at approximately 30' to 40' above the ground. The pilot elected to execute a forced landing on the grassy infield of the airport because insufficient runway remained. The acft struck the… - [NTSB MIA88FA184](https://openairdocs.org/ntsb/MIA88FA184.md): Piper J3C · N Fort Myers, FL · Accident · 2 fatal · Field investigation · Final report · Jun 1, 1988 · N98178 · Destroyed > The plt tkof on rwy 27 with the wind fm 060 deg at 12 gusting 23 KTS. Density alt was 2100'. Witnesses said the acft was in a slow speed, nose hi climb, when eng pwr was interrupted momentarily. Pwr was restored, but soon thereafter, the acft rolled rgt,… - [NTSB FTW88LA113](https://openairdocs.org/ntsb/FTW88LA113.md): Cessna 152 · Hinton, OK · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 1988 · N25352 · Substantial damage > The pilot departed bethany, Oklahoma on a local pleasure flight with the fuel tanks slightly less than 1/2 full. After about a 1.5 hour flight, he landed at the red rock airport in Hinton, Oklahoma. No service was performed on the aircraft while in Hinton and… - [NTSB NYC88LA148](https://openairdocs.org/ntsb/NYC88LA148.md): Grumman AA-1B · Dover, PA · Accident · No injuries · Limited investigation · Final report · May 30, 1988 · N9981L · Substantial damage > Loss of engine power for an unknown reason. Contributing factors were: failure of the pilot to maintain runway alignment obstructions near the end of the runway (sign, stone fence & tree). - [NTSB MKC88LA102](https://openairdocs.org/ntsb/MKC88LA102.md): Pitts S-2 · Siloam Springs, AR · Accident · No injuries · Limited investigation · Final report · May 30, 1988 · N246PC · Substantial damage > The pilot said that after takeoff and reaching a safe altitude, he made an immediate hard left turn resulting in a loss of control. Pilot did not recover from the resultant stall. Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=162 ## 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=161 --- 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.