# NTSB investigations, 1985: 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 1 of 9 · 418 cases

## Latest cases

- [NTSB DEN86LA058](https://openairdocs.org/ntsb/DEN86LA058.md): Cessna 140A · Columbus, NM · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1985 · N5330C · Substantial damage
  > According to the plt, after performing the preflight engine runup, he leaned the mixture control and switched the fuel selector to both tanks. Shortly after takeoff at approximately 50 ft AGL, the eng lost partial pwr. The plt made a forced landing following…
- [NTSB MIA86LA051](https://openairdocs.org/ntsb/MIA86LA051.md): Cessna T210L · Madison, FL · Accident · No injuries · Limited investigation · Final report · Dec 30, 1985 · N5302V · Substantial damage
  > The pilot stated that he had started the flight at about 1000 EST from miami, FL and had planned on landing at Madison county airport. As he flew overhead he noted an airstrip with county vehicles parked nearby. He landed and was informed that it was local…
- [NTSB FTW86FA028](https://openairdocs.org/ntsb/FTW86FA028.md): Beech B33 · Arlington, TX · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1985 · N8948M · Destroyed
  > Inspite of an adverse weather forecast, the non-instrument rated pilot took off into pre-dawn fog and low ceilings. The acft impacted the ground in a steep descending turn after being observed maneuvering at a low altitude. No eng, airframe, or instrument…
- [NTSB ATL86IA051](https://openairdocs.org/ntsb/ATL86IA051.md): Airbus Industrie A-300 B4-203 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Dec 30, 1985 · N231 · Minor damage
  > During takeoff initial climb the aircraft experienced an uncontained failure of the no 1 engine. The pilot returned to the airport and landed without further incident. Post incident examination disclosed four broken turbine mid frame strut studs. The fracture…
- [NTSB MIA86LA049](https://openairdocs.org/ntsb/MIA86LA049.md): Beech B-35-P · Lake Wales, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1985 · N1544Z · Substantial damage
  > The private pilot stated that during takeoff from a wet sod field he rotated prematurely and the aircraft stalled. The aircraft then mushed and crashed causing minor injuries to one passenger.
- [NTSB FTW86LA029](https://openairdocs.org/ntsb/FTW86LA029.md): Piper PA-31-325 · Junction, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 1985 · N27842 · Destroyed
  > During initial climb after takeoff the pilot noticed oil streaming out from the oil filler access door on the right engine cowling. He elected to continue climbing and make a tear drop turn back to the airport and land in the opposite direction from which he…
- [NTSB MIA86MA048](https://openairdocs.org/ntsb/MIA86MA048.md): Boeing 727-232 · Fort Lauderdale, FL · Incident · No injuries · Major investigation · Final report · Dec 28, 1985 · N519DA · Minor damage
  > After gear retraction drg takeoff, at aprx 150' AGL, the aircrew heard a loud noise & noted the #2 eng had failed. They secured the eng, dumped fuel & landed without further incident. An exam of the #2 eng revealed the combustion chamber outer case, pn…
- [NTSB MIA86LA050](https://openairdocs.org/ntsb/MIA86LA050.md): Piper PA-28-161 · Leesburg, FL · Accident · No injuries · Limited investigation · Final report · Dec 28, 1985 · N8408F · Substantial damage
  > The plt stated that while attempting to takeoff from a private airstrip his left main wheel hit a barbed wire fence causing the left wing to strike the ground & separate from the acft.
- [NTSB SEA86LA031](https://openairdocs.org/ntsb/SEA86LA031.md): Cessna 402B · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Dec 27, 1985 · N4624N · Substantial damage
  > The plt reported encountering icing conditions during his apch to Spokane. Upon arrival, the acft remained at Spokane for 30-40 minutes during which freezing drizzle and below freezing temps existed prior to and during the departure. The plt did not utilize…
- [NTSB FTW86FA026](https://openairdocs.org/ntsb/FTW86FA026.md): Cessna 150E · Shawnee, OK · Accident · 1 fatal · Field investigation · Final report · Dec 21, 1985 · N4066U · Destroyed
  > The unlicensed plt was conducting an unauthorized flt when the accident occurred. The plt took off from a sod fld adjacent to a closed rwy at Shawnee, OK. Witnesses stated that the acft assumed an excessively nose high attitude immediately after takeoff and…
- [NTSB LAX86LA072](https://openairdocs.org/ntsb/LAX86LA072.md): Cessna 150L · Tucson, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 1985 · N10882 · Substantial damage
  > After about a 45 min wait as the number one acft for departure, the controller informed the plt that he could expect an additional 3 min wait because of wake turbulence from a (large) EC-130 acft which was approaching for a touch & go landing. The plt elected…
- [NTSB MIA86LA045](https://openairdocs.org/ntsb/MIA86LA045.md): Piper PA-32-260 · Lake City, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1985 · N5547J · Substantial damage
  > The plt stated that after a forced landing in a field due to a stuck fuel selector valve, the fuel selector was repaired and a takeoff was attempted from county road 240. At an alt of aprx 3 ft the eng sputtered & the plt lost control of the acft, veered left…
- [NTSB FTW86FRG05](https://openairdocs.org/ntsb/FTW86FRG05.md): Adams William C Quickie Q1 · Beeville, TX · Accident · No injuries · Final report · Dec 15, 1985 · N220WA · Substantial damage
  > The acft crashed during a forced lndg after a power loss at 200 ft AGL during takeoff. The acft crashed on the arpt in a run-up area adjacent to the rwy. The only discrepancy noted during post acc exam was a very weak spark produced by the battery coil…
- [NTSB MIA86FA044](https://openairdocs.org/ntsb/MIA86FA044.md): Beech BE-23 · Pensacola, FL · Accident · 2 fatal · Field investigation · Final report · Dec 14, 1985 · N6636B · Destroyed
  > Shortly after takeoff on initial climb the aircraft was seen to crash back on the runway. Examination of the wreckage revealed that the right stabilator attach/hinge bolt was not installed, and the left stabilator attach/hinge bolt was found partially…
- [NTSB CHI86LA048](https://openairdocs.org/ntsb/CHI86LA048.md): Cessna 152 II · Aurora, IL · Accident · No injuries · Limited investigation · Final report · Dec 14, 1985 · N4655P · Substantial damage
  > During initial climbout the student plt saw his IAS drop 10 KTS. He aborted the takeoff and land hard on the nose gear. Gear collapsed.
- [NTSB FTW86FA025](https://openairdocs.org/ntsb/FTW86FA025.md): Gates Learjet 35A · College Station, TX · Accident · 2 fatal · Field investigation · Final report · Dec 13, 1985 · N723GL · Destroyed
  > The acft rolled to the right and crashed after a catastrophic (uncontained) failure of the rt eng during takeoff for a night flt. The rt eng fan rotor disc separated from the hub which damaged the cowling and some disc fragments buried in the fuselage but…
- [NTSB CHI86LA043](https://openairdocs.org/ntsb/CHI86LA043.md): Cessna 140 · Rochester, IN · Accident · No injuries · Limited investigation · Final report · Dec 7, 1985 · N4155N · Substantial damage
  > Upon takeoff and after reaching an altitude of approx ten feet the right side of the cowl became unlatched and whipped up into the airstream, blocking the pilots forward view and causing some control problems. He elected to abort the takeoff and ran off the…
- [NTSB SEA86FA028](https://openairdocs.org/ntsb/SEA86FA028.md): Cessna 335 · Pendleton, OR · Accident · Serious injuries · Field investigation · Final report · Dec 6, 1985 · N2711U · Destroyed
  > At 500 ft AGL on departure climb, with lndg gear unretracted, plt felt vibrations similar to rough-running engine but noted no instrument indications, throttled back and leveled off. While trouble-shooting problem, plt noted acft was descending at 1200 fpm,…
- [NTSB DEN86FA039](https://openairdocs.org/ntsb/DEN86FA039.md): Beech 35-B33 · Columbia Falls, MT · Accident · 1 fatal · Field investigation · Final report · Dec 6, 1985 · N5637K · Destroyed
  > The acft contacted snow covered terrain in an uncontrolled descent aprx 3 minutes after takeoff. The plt obtained a wx briefing from kalispell, MT, NWS and updated briefings from missoula and great Falls, MT, fss, for proposed night VFR flt to ogden, UT. VFR…
- [NTSB LAX86LA053](https://openairdocs.org/ntsb/LAX86LA053.md): Mooney M20J · Taft, CA · Accident · No injuries · Limited investigation · Final report · Nov 30, 1985 · N201UH · Substantial damage
  > The landing gear intransit light illuminated and stayed on when the plt attempted to retract the gear after takeoff. After all efforts to extend or retract the gear failed the plt elected to land at the arpt of departure. The landing gear collapsed on…
- [NTSB SEA86LA027](https://openairdocs.org/ntsb/SEA86LA027.md): Cessna 182P II · Carson City, NV · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 1985 · N9893M · Substantial damage
  > Plt attempted takeoff with at least one-half inch of frost and ice on upper surfaces of acft. Acft became airborne near end of 5900-FT runway in extreme nose-high attitude, stalled and nose dropped to ground contact. Acft skidded through perimeter fence and…
- [NTSB MIA86FA033](https://openairdocs.org/ntsb/MIA86FA033.md): North American T-28A · Lantana, FL · Accident · 1 fatal · Field investigation · Final report · Nov 23, 1985 · N9867C · Destroyed
  > The pilot/mechanic had recently re-installed a rebuilt engine in the aircraft and performed a very short run-up prior to takeoff. Witnesses stated the aircraft engine made popping noises and was belching black smoke during the takeoff roll. The aircraft…
- [NTSB CHI86FEM02](https://openairdocs.org/ntsb/CHI86FEM02.md): Piper PA-25-235 · Holland, MI · Accident · Minor injuries · Final report · Nov 23, 1985 · N7424Z · Substantial damage
  > The acft crashed during a forced lndg after a loss of power during initial climb. After the accident the plt said that he drained fuel from the main fuel strainer and found no water in the fuel prior to takeoff. The acft carburetor was disassembled after the…
- [NTSB DEN86LA030](https://openairdocs.org/ntsb/DEN86LA030.md): Piper PA-28-140D · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1985 · N473FL · Substantial damage
  > According to the plt, the eng lost pwr shortly after takeoff, requiring the plt to make a forced landing. During the investigation, it was determined that the plt had flown into, and later attempted to depart from Albuquerque, NM, with the mixture full rich.…
- [NTSB DEN86IA026](https://openairdocs.org/ntsb/DEN86IA026.md): North American NA-265-40 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Nov 22, 1985 · N1909D · Minor damage
  > After to from a snow covered rw, the lg dwn and locked lights in the cockpit remained illuminated on lg retract the crew did not recognize this as a log gear ino sys malfunction nor were they familiar with the correct proc to lower lg when this malfunction…
- [NTSB NYC86LA038](https://openairdocs.org/ntsb/NYC86LA038.md): Gensen B8M · Mars, PA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1985 · N291PR · Substantial damage
  > The plt reported that after climbing to an alt of aprx 200 ft after takeoff, the airspeed dropped from 50 to 40 mph. The acft then lost alt and mushed to ground impact. The plt did not hold a medical or student plt certificate.
- [NTSB SEA86LA023](https://openairdocs.org/ntsb/SEA86LA023.md): Brisbin Pientenpol Aircamper · Gig Harbor, WA · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 1985 · N31131 · Destroyed
  > A total loss of power occurred for unknown reasons shortly after takeoff. A 75 foot tree was struck with the aircraft striking the ground nose first and then coming to rest inverted. The engine was tested and ran normally with no abnormalities with the…
- [NTSB LAX86FA039](https://openairdocs.org/ntsb/LAX86FA039.md): Cessna 182P · Cottonwood, AZ · Accident · 1 fatal · Field investigation · Final report · Nov 14, 1985 · N7036S · Destroyed
  > Witnesses saw the plt depart with frost covering the acft & without either a runup or warmup. The witnesses reported that the plt 'scraped the frost from a small square directly in front of him on the windshield' just prior to takeoff. Temp & dew point were…
- [NTSB MKC86FA028](https://openairdocs.org/ntsb/MKC86FA028.md): Cessna 337B · Fayetteville, AR · Accident · 1 fatal · Field investigation · Final report · Nov 13, 1985 · N5445S · Destroyed
  > The plt and his wife were flying to Alaska with the first en route stop to be canton, TX. The non-plt wife stated that as the acft passed over the departure end of the rwy on takeoff, her husband released the controls and threw his head back. She kept the…
- [NTSB ATL86LA024](https://openairdocs.org/ntsb/ATL86LA024.md): Gary E. Wilson Quickie · Paris, TN · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1985 · N4974A · Destroyed
  > The plt had completed several high speed taxi runs in the homebuilt acft prior to the attempted flt. The acft climbed to about 50-100 ft and reached a speed of apprx 65 mph. It would not accelerate nor climb any further. The plt attempted a turn back to the…
- [NTSB LAX86FVD02](https://openairdocs.org/ntsb/LAX86FVD02.md): John Patrick Coleman Bensen B-8M · Eureka, CA · Accident · 1 fatal · Final report · Nov 12, 1985 · N4579C · Substantial damage
  > On November 12, 1985, at approximately 1345 PST an amateur built bensen B-8M aircraft owned and operated by John Patrick Coleman crashed while on a pleasure flight. VFR conditions prevailed and no flight plan was filed. The aircraft was destroyed and the…
- [NTSB NYC86FNE01](https://openairdocs.org/ntsb/NYC86FNE01.md): Dorfman,William A. Bede 4/275 · Westfield, MA · Accident · No injuries · Final report · Nov 10, 1985 · N58266 · Substantial damage
  > The aircraft collided with the ground off to the side of the runway during a takeoff attempt. The nose gear and the main gear collapsed during the ground contact. The wind blew the aircraft to the side with a wing raised and before recovery as effected the…
- [NTSB FTW86FRG03](https://openairdocs.org/ntsb/FTW86FRG03.md): Cessna 150G · Geronimo, TX · Accident · Serious injuries · Final report · Nov 10, 1985 · N4754X · Substantial damage
  > The acft failed to achieve proper climb to clear pwr lines during takeoff initial climb. The takeoff was performed on a 700 ft long grass strip in a downwind direction. When it became questionable that the acft could climb over a pwr line the plt cut the…
- [NTSB DEN86LA019](https://openairdocs.org/ntsb/DEN86LA019.md): Beech F33A · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Nov 9, 1985 · N4956M · Substantial damage
  > The plt reported the cylinder head temp began 'falling back out of green' shortly after takeoff. The plt reversed direction & landed at the arpt, but failed to extend the gear, substantially damaging the acft. The investigation of theeng revealed the exhaust…
- [NTSB LAX86LA036](https://openairdocs.org/ntsb/LAX86LA036.md): Piper PA-28R-200 · Mammoth Lakes, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 1985 · N3096R · Substantial damage
  > The plt reported that when he observed the arpt's wind sock in preparation for departure the wind was blowing down the rwy with occasional gusts that did not seem over 20 KTS. After taking off & climbing to abt 100 ft AGL, the acft encountered turbulence…
- [NTSB ATL86LA021](https://openairdocs.org/ntsb/ATL86LA021.md): Cessna 150J · Cumming, GA · Accident · No injuries · Limited investigation · Final report · Nov 8, 1985 · N51182 · Substantial damage
  > Shortly after takeoff the acft experienced a loss of pwr as related by the student plt. A forced landing was performed in a fld during which the nose wheel dug into the terrain and the acft nosed over. Examination of the wreckage failed to disclose any…
- [NTSB FTW86FA004](https://openairdocs.org/ntsb/FTW86FA004.md): Beech H18 · Oklahoma City, OK · Accident · 2 fatal · Field investigation · Final report · Nov 5, 1985 · N1461G · Destroyed
  > Atr plt departing arpt under VMC experienced failure of the right eng shortly after lift-off. The acft yawed right followed by a steep right roll, contacting power lines with the right wing and subsequently impacted the ground. A post-crash fire destoyed the…
- [NTSB DEN86LA018](https://openairdocs.org/ntsb/DEN86LA018.md): Piper PA-28-140 · Ranchos De Taos, NM · Accident · No injuries · Limited investigation · Final report · Nov 3, 1985 · N4351J · Substantial damage
  > The plt stated that during takeoff, after a touch and go, the eng quit due to fuel exhaustion. The acft nosed over during a forced landing in a sage brush covered fld 3/4 of a mile north of the rwy. According to the plt, he failed to switch the fuel tanks…
- [NTSB ATL86FLT03](https://openairdocs.org/ntsb/ATL86FLT03.md): Cessna 172I · Millington, TN · Accident · Minor injuries · Final report · Nov 3, 1985 · N35469 · Substantial damage
  > The acft collaped the nose lndg bear during a forced lndg after the engine failed during takeoff. During post ace eng exam the wires disconnected from the magneto switch. The wires were resting on the 'p' leads. The fastening screw found on the bottom of the…
- [NTSB DEN86LA017](https://openairdocs.org/ntsb/DEN86LA017.md): Beech A36TC · Bismarck, ND · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 1985 · N3663K · Substantial damage
  > Shortly after takeoff, the plt of the Beech A36TC acft activated what he believed was the flap retraction lever, and the eng quit. The plt made a forced landing aprx 1000 ft from the rwy departure end. During the investigation, the eng was started and…
- [NTSB ANC86FA007](https://openairdocs.org/ntsb/ANC86FA007.md): Cessna 208 · Bethel, AK · Accident · 2 fatal · Field investigation · Final report · Nov 1, 1985 · N9241F · Destroyed
  > A total loss of pwr was experienced on takeoff due to the fuel selectors being in the off position. The plt attempted to restart the eng during which time the acft entered a stall and collided with the terrain. According to passengers the plt did not use a…
- [NTSB ANC86LAG05](https://openairdocs.org/ntsb/ANC86LAG05.md): Beech BE77 · Hope, AK · Accident · Minor injuries · Final report · Oct 29, 1985 · N6753X · Substantial damage
  > The acft struck trees and crashed during a night takeoff from a gravel strip. The plt suspected an partial pwr loss, but incomplete information precluded a thorough investigation.
- [NTSB MIA86LA021](https://openairdocs.org/ntsb/MIA86LA021.md): Mooney M20C · Starke, FL · Accident · No injuries · Limited investigation · Final report · Oct 28, 1985 · N79386 · Substantial damage
  > The plt stated that after takeoff while climbing through 15 ft AGL the eng sputtered and lost pwr momentarily. Full pwr was regained but the acft had lost altitude and could not climb to clear trees at the departure end of the rwy. The acft then veered left,…
- [NTSB LAX86LA028](https://openairdocs.org/ntsb/LAX86LA028.md): S. Piccolotto/Dave Morss Cassutt SH-1 · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1985 · N4975M · Substantial damage
  > The acft experienced a loss of power shortly after departing ry 30, San Carlos airport, San Carlos, CA. The plt reptd that after experiencing the loss of power, he pumped the throttle. This action caused the engine to regain some power but not enough to…
- [NTSB ANC86LA006](https://openairdocs.org/ntsb/ANC86LA006.md): Cessna 182L · Anchorage, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 1985 · N3339R · Substantial damage
  > Aircraft stalled and crashed into trees at takeoff end of private airstrip. Several witnesses reported seeing big pieces of crusted snow and ice flying off the aircraft during the takeoff run and climb. Takeoff was made up hill contrary to published…
- [NTSB ANC86LAG04](https://openairdocs.org/ntsb/ANC86LAG04.md): Cessna 177 · Soldotna, AK · Accident · No injuries · Final report · Oct 26, 1985 · N300WC · Substantial damage
  > The plt stated that during the preflight inspection the right wing tank quick drain was frozen and the fuel strainer was not working correctly. After consulting with a mechanic, a takeoff was performed and the eng quit during initial climb. The acft contacted…
- [NTSB FTW86LQG01](https://openairdocs.org/ntsb/FTW86LQG01.md): Piper PA-36-300 · Fluvanna, TX · Accident · No injuries · Final report · Oct 25, 1985 · N3671E · Substantial damage
  > The acft contacted a cattle guard during an attempted takeoff for an aerial application flt. The plt reported the acft was overloaded for the length of rwy being used for the takeoff. He continued to report he was too late in dumping the chemical load. The…
- [NTSB DEN86LA013](https://openairdocs.org/ntsb/DEN86LA013.md): Cessna 170B · Coloradosprings, CO · Accident · No injuries · Limited investigation · Final report · Oct 23, 1985 · N170CE · Substantial damage
  > The pilot took off on runway 17. The wind was reported to be from 130 degrees at 10 knots. After liftoff the left wing rose abruptly and the aircraft veered to the right. The pilot stated that because of his low altitude he could not regain control of the…
- [NTSB ATL86LMG02](https://openairdocs.org/ntsb/ATL86LMG02.md): Aeronca 11AC · Wallace, NC · Accident · Serious injuries · Final report · Oct 21, 1985 · N86097 · Destroyed
  > The acft collided with the terrain following a loss of control during initial takeoff climb. The plt reported that after clearing trees at an alt of aprx 200 ft the acft drifted to the right. The tail of the acft then rose pushing the nose down until the acft…
- [NTSB MIA86FA015](https://openairdocs.org/ntsb/MIA86FA015.md): Beech BE 35 · Zellwood, FL · Accident · Serious injuries · Field investigation · Final report · Oct 20, 1985 · N2805V · Substantial damage
  > The private pilot landed at a turf strip utilizing full flaps and 6 units of nose up trim. The pilot stated that when preparing for departure he was in a hurry to avoid inclement weather at his destination and did not utilize a check list he never re-trimmed…

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?year=1985&page=2

## 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 year(c."eventDate") = 1985
  AND 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?year=1985

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