# 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 174 of 412 · 20,559 cases ## Cases, newest first - [NTSB ATL86LA246](https://openairdocs.org/ntsb/ATL86LA246.md): Beech 95 · Springfield, TN · Accident · No injuries · Limited investigation · Final report · Sep 6, 1986 · N2030C · Destroyed > The instructional flt had been in the air for about 45 min when the instructor told the plt to return to the arpt and land. Upon entering the traffic pattern the plt was told to make a touch and go landing. He completed two of these maneuvers and was… - [NTSB ANC86LA148](https://openairdocs.org/ntsb/ANC86LA148.md): Piper PA-18 · Farewell, AK · Accident · No injuries · Limited investigation · Final report · Sep 5, 1986 · N5907Y · Substantial damage > Aircraft lost control and crashed while attempting takeoff from gravel bar. Pilot estimated left crosswind to be 10 gusting to 30 knots. - [NTSB MIA86LA246](https://openairdocs.org/ntsb/MIA86LA246.md): Piper PA-38 · Palmetto, FL · Accident · No injuries · Limited investigation · Final report · Sep 4, 1986 · N938SC · Substantial damage > The CFI was demonstrating a simulated short field takeoff on a grass airstrip to his student. During the takeoff roll, the plt stated the acft was performing normally, but after lift-off, he was unable to climb out of ground effect. The acft collided with a… - [NTSB DEN86LA247](https://openairdocs.org/ntsb/DEN86LA247.md): Grumman AA-1A · Chinook, MT · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 1986 · N6401L · Substantial damage > The acft took off on a 3900-foot dry asphalt rwy. An uncommanded left yaw developed which the plt was unable to counter. The acft struck a fence off the left side of the rwy and nosed over. - [NTSB ATL86FMG10](https://openairdocs.org/ntsb/ATL86FMG10.md): Quickie Q2 · Clinton, NC · Accident · Serious injuries · Final report · Sep 4, 1986 · N206JB · Destroyed > The acft was destroyed during a forced lndg after a power loss during takeoff climb. The plts son witnessed the takeoff & saw the acft descend below trees north of the arpt. He said that the eng sounded out of time. During a post acc eng inspection the… - [NTSB SEA86LA238](https://openairdocs.org/ntsb/SEA86LA238.md): Beech A24R · Kent, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1986 · N66BW · Destroyed > A forced landing was made due to a loss of power for undetermined reasons. The power loss occurred at about 600 feet AGL. A slight left turn was made to land onto a road. The aircraft's left wing struck a tree separating it from the aircraft. The aircraft's… - [NTSB NYC86LA229](https://openairdocs.org/ntsb/NYC86LA229.md): Piper PA-38-112 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N2447B · Substantial damage > During a simulated engine out on takeoff, the student plt leveled the acft instead of lowering the nose to maintain airspeed. The CFI took over control of the acft, however, the airspeed was too slow to arrest the rate of descent. The acft contacted the… - [NTSB NYC86LA226](https://openairdocs.org/ntsb/NYC86LA226.md): Grumman AA-5A · So. Berwick, ME · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N26784 · Substantial damage > The acft experienced a loss of eng power while leveling off at 2,500 ft MSL shortly after takeoff. Remedial action was attempted, however, power was not regained. The plt initiated a 180 deg turn back toward the arpt but altitude was insufficient to reach the… - [NTSB ATL86LA236](https://openairdocs.org/ntsb/ATL86LA236.md): Enstrom F-28C · Coshocton, OH · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N549H · Substantial damage > The plt initiated a maximum power takeoff from a confined parking lot with 2 passengers on board. The area was boardered by obstructions & people. The plt rprtd that during lift-off, she increased power to 2900 RPM, lifted off to a 4' hover with 33' of… - [NTSB NYC86LA224](https://openairdocs.org/ntsb/NYC86LA224.md): Cessna 150 · Butler, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1986 · N3649J · Destroyed > A loss of eng power was experienced shortly after takeoff at an alt of aprx 400 ft AGL. The acft contacted wires and descended uncontrolled to terrain impact during the forced landing descent. Post accident inspection of the acft revealed aprx 4 ounces of… - [NTSB MKC86FA181](https://openairdocs.org/ntsb/MKC86FA181.md): Piper PA-28-140 · Elkhart, KS · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1986 · N4233J · Destroyed > The student plt intended to fly from his home arpt to a nearby arpt where he was receiving flt instruction. No record of a wx briefing was found. Local authorities said there were low clouds and fog in the area at the time of the accident. No one saw the acft… - [NTSB DEN86LA243](https://openairdocs.org/ntsb/DEN86LA243.md): Cessna 150F · Dexter, NM · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1986 · N8856S · Destroyed > Plt and pax were taking off from 1900 ft x 50 ft turf rwy 30. Plt said she lifted off at 45 mph and initiated climb of 55 mph. At 250 ft AGL acft suddenly lost 100 ft. acft then went into steep right bank. Acft cleared power lines. Right wing contacted ground… - [NTSB LAX86FUM03](https://openairdocs.org/ntsb/LAX86FUM03.md): Eipper Quicksilver MX 2 · Pine Valley, CA · Accident · No injuries · Final report · Aug 30, 1986 · N57999 · Substantial damage > Just after lift-off at an altitude of aprx 10 ft AGL, the ultralight acft began to settle back to the dirt runway. The plt turned the acft to the right to avoid colliding with trees, however, the nose gear caught in the brush and the acft nosed over. There… - [NTSB FTW86LA161](https://openairdocs.org/ntsb/FTW86LA161.md): Bell 206L-1 · Grand Isle · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 1986 · N3905G · Destroyed > The acft crashed into the gulf of Mexico following a suspected eng failure shortly after lift off from an offshore platform. The plt stated that after takeoff, while at 40 KTS and 200 ft above the water, he heard a loud squeal followed by the low RPM audio… - [NTSB FTW86FA156](https://openairdocs.org/ntsb/FTW86FA156.md): Great Lakes 2T-1A-2 · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1986 · N6198L · Destroyed > The ends of the outer string and the inner reinforcing wire of the engine air intake duct were not properly positioned under the duct clamp during installation. As a result, they unwound during engine operation and moved out of their normal position on and in… - [NTSB FTW86FA154](https://openairdocs.org/ntsb/FTW86FA154.md): Piper PA-12 · Big Sandy, MT · Accident · 2 fatal · Field investigation · Final report · Aug 30, 1986 · N2532M · Destroyed > Student pilot on unauthorized cross country flight departed unimproved field on VFR flight for the purpose of spotting game. Weather conditions in the area were conducive for light to moderate turbulence. Witnesses reported the acft wings rocked violently… - [NTSB ATL86LA234](https://openairdocs.org/ntsb/ATL86LA234.md): Benham Midget Mustang M-1 · Rome, GA · Accident · No injuries · Limited investigation · Final report · Aug 30, 1986 · N545JS · Substantial damage > The plt reported he took off too close behind a preceding acft and was caught in the wing tip vorticies. The vortices combined with a 110 deg left crosswind (wind 070/20 gusting higher) resulted in a loss of control and ground impact. The plt said he was in a… - [NTSB ATL86FA231](https://openairdocs.org/ntsb/ATL86FA231.md): Piper PA-18-150 · Mansfield, OH · Accident · 2 fatal · Field investigation · Final report · Aug 30, 1986 · N9698P · Destroyed > Acft took off from pvt sod strip. Father of plt said eng sounds were normal during run up. Acft appeared to be climbing with a normal attitude when the eng quit. Subsequently, acft was stalled followed by a near vertical nose down impact and post impact fire.… - [NTSB ANC86LA140](https://openairdocs.org/ntsb/ANC86LA140.md): Cessna 182 · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Aug 30, 1986 · N5227R · Substantial damage > The pilot stated that he lost control of the aircraft; the aircraft stalled on takeoff and the aircraft struck the lake and rolled over on the gravel bar. - [NTSB MIA86LA245](https://openairdocs.org/ntsb/MIA86LA245.md): Beech G-35 · Lantana, FL · Accident · No injuries · Limited investigation · Final report · Aug 29, 1986 · N1883D · Substantial damage > Shortly after takeoff the cabin door opened. The pilot continued the short flight to his home airfield. During approach he stated that due to the increased noise in the cabin he forgot to lower the landing gear. The aircraft contacted the runway with the… - [NTSB NYC86LA221](https://openairdocs.org/ntsb/NYC86LA221.md): Cessna 150H · Leroy, NY · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N6659S · Substantial damage > The flt experienced an engine failure shortly after takeoff due to fuel starvation. The plt was flying the aircraft on the left tank which had no appreciable amount of fuel, while the right tank contained 12 to 13 gallons on fuel. - [NTSB ATL86LA230](https://openairdocs.org/ntsb/ATL86LA230.md): Rockwell S-2R · Shellman, GA · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N5042X · Substantial damage > Just after liftoff, the plt noted smoke and attributed it to an overhauled prop which had just been installed. He then heard a loud squeal from the eng and noted a loss of power. A forced landing was made in a rough corn field, where the acft was damaged. An… - [NTSB MIA86LA243](https://openairdocs.org/ntsb/MIA86LA243.md): Grumman G-44A · Hawthorne, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 1986 · N1629H · Substantial damage > The plt stated that upon touchdown on the lake the acft felt strange. He added full pwr and took off again but just after takeoff the acft rolled to the right and the nose dove. He removed pwr and with the controls full back, the acft hit the water with no… - [NTSB ANC86LA141](https://openairdocs.org/ntsb/ANC86LA141.md): Piper PA-32-260 · Stoney River, AK · Accident · No injuries · Limited investigation · Final report · Aug 26, 1986 · N400TH · Substantial damage > The pilot stated that after liftoff he failed to maintain airspeed. The aircraft stalled and crashed into the River. - [NTSB NYC86FHM03](https://openairdocs.org/ntsb/NYC86FHM03.md): Schempp-Hirth Ventus A · Middletown, NY · Accident · 1 fatal · Final report · Aug 24, 1986 · N7XT · Destroyed > The sailplane was being towed into the air. It was observed to come off the ground in a tail low attitude and then start porposing. The aircraft was released from the tow plane and impacted. The pilot was fatally injured and the aircraft destroyed. No… - [NTSB MKC86LA174](https://openairdocs.org/ntsb/MKC86LA174.md): Scheibe Flugzeugbau Bergfalke II-55 · Hutchinson, KS · Accident · No injuries · Limited investigation · Final report · Aug 24, 1986 · N5924 · Substantial damage > The pilot stated that he performed what he thought was a thorough pre-flight inspection, including the installation of the horizontal tail, before he pushed the aircraft onto the runway and hooked the tow line. Immediately after liftoff, the pilot further… - [NTSB LAX86FVA15](https://openairdocs.org/ntsb/LAX86FVA15.md): I.C.A. Brasov IS-28M2 · Porterville, CA · Accident · Minor injuries · Final report · Aug 24, 1986 · N9023B · Substantial damage > During initial climb, shortly after takeoff, the pilot heard a loud whir then a boom sound. The aircraft started vibrating so the pilot shut down the engine. Having gained 200 to 300 feet of alt the pilot initiated a left 180 deg turn to attempt a forced… - [NTSB LAX86FA328](https://openairdocs.org/ntsb/LAX86FA328.md): Cessna 172L · Grand Canyon, AZ · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1986 · N7382Q · Destroyed > The acft crashed in a wooded area shortly after departing rwy 21 at Grand Canyon national park arpt (gcn). The plt had made a precautionary landing at gcn during the x-country flt to page, AZ, so he call a fss having been unable to establish contact in-flt.… - [NTSB CHI86LA209](https://openairdocs.org/ntsb/CHI86LA209.md): Cessna 150F · Milford, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1986 · N8765S · Substantial damage > The pilot used full power and 10 degrees of flaps to perform a short field takeoff from a sod strip. He rotated for takeoff less than halfway down the 1100 ft runway, then kept the acft low to accelerate to 80 KTS. He then pulled up to clear a row of 40 ft… - [NTSB SEA86FA216](https://openairdocs.org/ntsb/SEA86FA216.md): Glasair SH2 · Roche Harbor, WA · Accident · 3 fatal · Field investigation · Final report · Aug 23, 1986 · N394SK · Destroyed > The acft was one of a group of glasairs that were departing the airport after a fly in breakfast at the resort. Witnesses reported the acft departed on runway 06 (uphill) in a 3 point attitude. As the acft continued down the runway, in a steep nose up climb,… - [NTSB LAX86LA330](https://openairdocs.org/ntsb/LAX86LA330.md): Cessna 182U · Tuba City, AZ · Accident · No injuries · Limited investigation · Final report · Aug 23, 1986 · N5299N · Substantial damage > The acft collided with a dirt bank after losing alt during the initial climb after takeoff from a dirt road. The plt indicated the acft became airborne after an aprx 800 ft ground run and climbed to an alt of 10 ft AGL. The acft then encountered a gust of… - [NTSB CHI86LA211](https://openairdocs.org/ntsb/CHI86LA211.md): Cessna 175 · Muskegon, MI · Accident · No injuries · Limited investigation · Final report · Aug 23, 1986 · N9275B · Substantial damage > Just prior to applying takeoff power the pilot switched to the left fuel tank. Fuel from this tank had never been used by this pilot since he purchased the aircraft two weeks earlier. Shortly after breaking ground the engine quit. Although the pilot switched… - [NTSB ANC86LA134](https://openairdocs.org/ntsb/ANC86LA134.md): Piper PA-18 · Nabesna, AK · Accident · No injuries · Limited investigation · Final report · Aug 23, 1986 · N2994Z · Substantial damage > During the initial climbout the pilot stalled the aircraft, lost control and crashed off the departed end of the airstrip. At the time of the accident, the pilot departed with a tailwind. - [NTSB ANC86LA132](https://openairdocs.org/ntsb/ANC86LA132.md): Piper PA-20 · Two Lakes, AK · Accident · No injuries · Limited investigation · Final report · Aug 20, 1986 · N7481K · Substantial damage > The pilot lost control of the aircraft on the initial climb. The pilot stated that after takeoff the wind shifted 180 degrees. - [NTSB CHI86FEM14](https://openairdocs.org/ntsb/CHI86FEM14.md): Piper PA-25-235 · White Pigeon, MI · Accident · No injuries · Final report · Aug 18, 1986 · N6862Z · Substantial damage > The pilot took off with a full load of seed on a 1300 ft runway during shifting wind conditions. He struck a fence before he had enough airspeed to establish a climb. - [NTSB SEA86LA208](https://openairdocs.org/ntsb/SEA86LA208.md): Curtiss JN4-D · Vancouver, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1986 · N511JN · Substantial damage > The plt reported a normal takeoff was made with 1300 RPM. At liftoff a small amount of black smoke emitted from both exhaust stacks and the RPM dropped to 1250. After clearing the rwy, more black smoke emitted and the RPM dropped to 1200. The plt cleared two… - [NTSB NYC86LA211](https://openairdocs.org/ntsb/NYC86LA211.md): Grumman AA-1B · Moultonboro, NH · Accident · No injuries · Limited investigation · Final report · Aug 16, 1986 · N9909L · Substantial damage > The plt rprtd that he departed the Moultonboro arpt at about 2200 EDT. During departure, the acft stalled & crashed into trees about 1/2 mi northwest of the arpt. - [NTSB CHI86LA205](https://openairdocs.org/ntsb/CHI86LA205.md): Piper PA-28-140 · Linden, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1986 · N40754 · Substantial damage > The newly certificated pvt plt with three passengers was attempting to practice a short field takeoff on the 2500 ft long asphalt runway. The owner's manual recommends 25 degrees of flaps to perform the takeoff. The plt did not extend any flaps. After… - [NTSB NYC86LA210](https://openairdocs.org/ntsb/NYC86LA210.md): Luscombe 8A · Nantucket, MA · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 1986 · N1515B · Substantial damage > The pilot made a precautionary landing on a beach shortly after takeoff when the engine stopped running. However during engine examination, nothing was found to determine malfunction or failure. - [NTSB MIA86LA236](https://openairdocs.org/ntsb/MIA86LA236.md): Piper PA28-151 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Aug 15, 1986 · N4539X · Substantial damage > The plt stated that just after takeoff, the eng sputtered and lost power. He landed the acft in the grass on the right side of runway 31, rolled aprx 100 yards, struck a sign, and veered left into soft dirt collapsing the nose gear. Post crash examination and… - [NTSB LAX86LA323](https://openairdocs.org/ntsb/LAX86LA323.md): Beech 35R · Sun City West, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 1986 · N3371V · Substantial damage > A Beechcraft BE-35R lost alt during initial climb and collided with the ground after takeoff from a private airstrip. The plt described the takeoff as normal until he reached an alt of 100 to 125 ft AGL and started to turn left. The plt stated, 'the aircraft… - [NTSB SEA86LA199](https://openairdocs.org/ntsb/SEA86LA199.md): Schweizer 2-22EK · Easton, WA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1986 · N2723Z · Substantial damage > The instructor pilot was flying the glider with a student in the front seat on a local instructional flight. About 2200 ft down the 2640 foot grass strip, the tow aircraft, at about 50 to 100 feet AGL, lost power and started to descend back to the runway. The… - [NTSB SEA86LA198](https://openairdocs.org/ntsb/SEA86LA198.md): Cessna 188 · Easton, WA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1986 · N5506S · Substantial damage > The tow plane with glider attached began losing pwr at aprx 50 ft AGL during takeoff. The tow plt signaled the glider plt for tow release. The two plts landed on the remaining rwy. The tow plane skidded into the trees off the end of the rwy. Investigation… - [NTSB ANC86LA125](https://openairdocs.org/ntsb/ANC86LA125.md): Piper PA-18 · Rochez Moutonee, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 1986 · N4293Z · Substantial damage > After departing the gravel bar, the aircraft banked to the left; the aircraft stalled and crashed. - [NTSB MKC86LA170](https://openairdocs.org/ntsb/MKC86LA170.md): Teratorn Tierra 2 · Dixon, IA · Accident · No injuries · Limited investigation · Final report · Aug 12, 1986 · N5575Y · Substantial damage > The experimental acft was loaded near max gross wt on takeoff from the pvt sod airatrip. The plt stated the acft performed sluggishly during the climbout from the field. The plt stated that on the climbout that he was overflying a corn field bordering the… - [NTSB NYC86LA206](https://openairdocs.org/ntsb/NYC86LA206.md): Piper PA-28-140 · Sussex, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1986 · N5803U · Substantial damage > The Piper PA-28-140 had just taken off when the main cabin door unlocked at the top. The pilot returned for a landing, had to go-around due to traffic, and was on final for his second approach, with the top of the main cabin door still unlocked. When, passing… - [NTSB SEA86LA202](https://openairdocs.org/ntsb/SEA86LA202.md): Piper PA-28-140 · Preston, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1986 · N5576F · Substantial damage > The jackson county sheriff reported that the pilot was attempting to take off from a farmer's field and failed to clear a dike. Subsequently, the acft cartwheeled into a county landfill and was damaged. - [NTSB ATL86FA217](https://openairdocs.org/ntsb/ATL86FA217.md): Piper PA-28-161 · Douglasville, GA · Accident · Minor injuries · Field investigation · Final report · Aug 10, 1986 · N8340F · Destroyed > The plt loaded three adults plus herself into the warrior ii and attempted to take off from a grass strip which had a dip and a hill of about 6 feet near the departure end. The acft traveled about 150 ft past the end of the runway before impacting on the side… - [NTSB SEA86LA200](https://openairdocs.org/ntsb/SEA86LA200.md): Piper PA-38 · Elko, NV · Accident · No injuries · Limited investigation · Final report · Aug 9, 1986 · N9148A · Substantial damage > Plt executed forced lndg following pwr loss on initial climb. Acft tanks (16 gal cap ea) had been topped two hours prior, fuel receipt shows 16.6 added, refueler recalled abt 8 gals added per tank. Plt checked visually and on gages during preflight.… - [NTSB ATL86FMG09](https://openairdocs.org/ntsb/ATL86FMG09.md): Gray Drifter XP · Orangeburg, SC · Accident · 1 fatal · Final report · Aug 9, 1986 · N4817N · Destroyed > The homebuilt acft crashed shortly after takeoff. Witnesses reported hearing a loss of power during initial climb. The acft then entered an abrupt right turn and descended to ground impact. Post accident bench test of the engine failed to disclose any… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=175 ## 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=174 --- 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.