# NTSB investigations, 1985: Approach 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 · 408 cases ## Latest cases - [NTSB MKC86LA039](https://openairdocs.org/ntsb/MKC86LA039.md): Cessna 182RG · Wentzville, MO · Accident · No injuries · Limited investigation · Final report · Dec 30, 1985 · N9199C · Substantial damage > The pilot stated that he winds were calm when he made the tou long, on the runway, attempted a go around and ran off the end of the runway into a field when the airplanefailed to get airborne. - [NTSB DEN86FA056](https://openairdocs.org/ntsb/DEN86FA056.md): Cessna T210L · West Valley, UT · Accident · 6 fatal · Field investigation · Final report · Dec 29, 1985 · N2082S · Destroyed > During apch to rwy 34L, the rt horizontal stab, elevators and wings separated in-flt. Investigation revealed the plt was not instr current. Ntap data revealed N2082S at an alt of 7,400 ft and 203 KTS grnd speed at outer marker. The mca at the marker is 6,100… - [NTSB BFO86FA011](https://openairdocs.org/ntsb/BFO86FA011.md): Piper PA-28-140 · Westminster, MD · Accident · Serious injuries · Field investigation · Final report · Dec 29, 1985 · N41204 · Destroyed > The student pilot was flying in a flight of three returning from having lunch at a nearby airport. The first pilot made a go-around after bouncing during touchdown on the downhill 1830 foot long by 30 foot wide airstrip. He then came aroundand made a… - [NTSB NYC86LA055](https://openairdocs.org/ntsb/NYC86LA055.md): Piper PA-24 · Ellington, CT · Accident · No injuries · Limited investigation · Final report · Dec 28, 1985 · N7571P · Substantial damage > While on apch for landing, about 50 ft from the rwy, the landing gear contacted a bridge and the acft bounced into the air. Pwr was added at this time and again the acft bounced. The acft was then landed on the rwy and it skidded to a stop. The plt stated she… - [NTSB FTW86FA027](https://openairdocs.org/ntsb/FTW86FA027.md): Cessna 172B · Caddo Mills, TX · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1985 · N6876X · 2 aircraft · Destroyed > Mid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was… - [NTSB LAX86MA074](https://openairdocs.org/ntsb/LAX86MA074.md): Beech 95-A55 · Concord, CA · Accident · 7 fatal · Major investigation · Final report · Dec 24, 1985 · N1494G · Destroyed > Drg arr, the acft was vectored for an lda rwy 19R apch. After being clrd for the apch, the plt was advised that radar svc was terminated & told to contact the twr. At 2033 PST, he rprtd inbnd at the final apch fix & was clrd for the apch. Aprx 2 min later, he… - [NTSB LAX86LA073](https://openairdocs.org/ntsb/LAX86LA073.md): Cessna 150M · Santa Paula, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1985 · N714GG · Substantial damage > The student plt & his CFI successfully performed 8 landings. On final apch to the 9'TH ldg the acft was low & the CFI delayed in directing his student to increase eng pwr. The student responded but the acft did not gain alt soon enough to avoid colliding with… - [NTSB BFO86LA010](https://openairdocs.org/ntsb/BFO86LA010.md): Cessna 152 · Stevensville, MD · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1985 · N6147Q · Destroyed > After landing at the bay bridge airport, the CFI got out of the aircraft and told the student-pilot to take it around the pattern. The aircraft was taxied to runway 28 and while waiting for other traffic to depart the CFI called over UNICOM that the landing… - [NTSB NYC86LA052](https://openairdocs.org/ntsb/NYC86LA052.md): Piper PA-28-140 · Rochester, NY · Accident · No injuries · Limited investigation · Final report · Dec 21, 1985 · N98240 · Substantial damage > The acft contacted the terrain following a loss of control during an attempted go-around. - [NTSB DCA86AA011](https://openairdocs.org/ntsb/DCA86AA011.md): Boeing 747-136 · Boston, MA · Accident · No injuries · Final report · Dec 15, 1985 · GAWNE · Substantial damage > Aprx 16 ft of the left inboard trailing edge flap separated while the acft was on final apch to land. The apch and landing were completed without further incident. Investigation revealed 5 of the 8 bolts which hold the no. 3 flap trackforward attach fitting… - [NTSB ATL86FA041](https://openairdocs.org/ntsb/ATL86FA041.md): Mooney M20K · Langhorne, PA · Accident · 1 fatal · Field investigation · Final report · Dec 15, 1985 · N231A · Substantial damage > Acft collided with marked but unlighted transmission lines 670 ft fm rwy threshold. The lines are 81 ft above the threshold elevation and are marked but unlighted. They are also 1193 ft from the displaced threshold. The pilot did not have a current medical or… - [NTSB ANC86FA014](https://openairdocs.org/ntsb/ANC86FA014.md): Cessna C-207 · Napaskiak, AK · Accident · Serious injuries · Field investigation · Final report · Dec 15, 1985 · N6497H · Substantial damage > According to the pilot-in-command, the weather at his destination was deteriorating so he diverted to Napaskiak where he encountered freezing drizzle rain and fog. While attempting to align himself with the runway for a landing to the south, the windshield… - [NTSB CHI86MA047](https://openairdocs.org/ntsb/CHI86MA047.md): Beech B-60 · Carp Lake, MI · Accident · 5 fatal · Major investigation · Final report · Dec 14, 1985 · N24RT · Destroyed > Drg arrival, the plt reported a problem with his #1 nav, but said he would try to make an ILS apch. He said he would return to pontiac, if his ILS did not work. ARTCC cleared him for the ILS rwy 32 apch & instructed him to contact pellston radio (fss). At… - [NTSB BFO86LHD01](https://openairdocs.org/ntsb/BFO86LHD01.md): Cessna 414 · Georgetown, DE · Accident · No injuries · Final report · Dec 13, 1985 · N13FH · Destroyed > The acft impacted trees during a VOR apch and descended to ground impact. The plt flew the apch with the autopilot coupled. The alt hold and alert were set for the mda. When visual contact with the arpt enviroment was established, the plt disconnected the alt… - [NTSB LAX86LA064](https://openairdocs.org/ntsb/LAX86LA064.md): Cessna 335 · Yuba City, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 1985 · N2708X · Destroyed > Upon completing a 35 min sight-seeing flight the plt entered the traffic pattern & prepared for landing. While descending, both engines lost all power. The plt stated that he repositioned the fuel selectors to the aux tanks, power was restored to the left… - [NTSB ATL86FA039](https://openairdocs.org/ntsb/ATL86FA039.md): Piper PA-30 · Corning, NY · Accident · 1 fatal · Field investigation · Final report · Dec 11, 1985 · N7770Y · Destroyed > During ILS runway 6 approach acft hit high terrain short of the outer marker. When on downwind for approach pilot said he was not receiving the localizer and asked for a surveillance approach. Controller said he could not provide. When cleared for the ILS… - [NTSB MIA86LA041](https://openairdocs.org/ntsb/MIA86LA041.md): Cessna 337F · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Dec 8, 1985 · N1158M · Substantial damage > The plt stated that all attempts to extend the landing gear were to no avail. He then intentionally landed gear up on the left side of rwy 4. - [NTSB CHI86FA042](https://openairdocs.org/ntsb/CHI86FA042.md): Learjet 35A · Rochester, MN · Accident · 3 fatal · Field investigation · Final report · Dec 8, 1985 · N15TW · Destroyed > The aircraft had just successfully completed a series of practice approaches to a full stop. The training flight was being conducted to give refresher training to the pilot who had not flown a lear jet in over a year and had never flown a lear model 35. The… - [NTSB SEA86LA029](https://openairdocs.org/ntsb/SEA86LA029.md): Maule M-5-180C · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Dec 7, 1985 · N5635D · Substantial damage > A total loss of power occurred during an ILS approach due to induction ice. During touchdown on 12 inches of snow a nose over occurred. - [NTSB FTW86LRG04](https://openairdocs.org/ntsb/FTW86LRG04.md): Cessna 150J · Temple, TX · Accident · No injuries · Final report · Dec 7, 1985 · N51079 · Substantial damage > The acft nosed over during a forced landing on soft terrain following a total loss of eng pwr. The plt reported that the eng quit while on a 45 deg entry to the downwind leg for rwy 15. The plt then attempted to restart the eng and maneuver the acft toward… - [NTSB LAX86FA057](https://openairdocs.org/ntsb/LAX86FA057.md): Beech F33A · Sacramento, CA · Accident · 1 fatal · Field investigation · Final report · Dec 5, 1985 · N6541A · Destroyed > On December 4, 1985 at 2230 PST, a Beech F33A, operated by the owner, collided with trees during a missed approach at Sacramento metropolitan airport, Sacramento, California, while on a business flight. Instrument meteorological conditions prevailed at the… - [NTSB CHI86LA040](https://openairdocs.org/ntsb/CHI86LA040.md): Cessna 177 · Crookston, MN · Accident · No injuries · Limited investigation · Final report · Dec 5, 1985 · N3386T · Substantial damage > While doing a 270 degree turn on base leg for runway realignment the pilot permitted the acft to fly into the ground. - [NTSB DEN86FA034](https://openairdocs.org/ntsb/DEN86FA034.md): Piper PA-31-350 · Englewood, CO · Accident · Serious injuries · Field investigation · Final report · Dec 2, 1985 · N9250Y · Substantial damage > The plt had been flying aprx 7 hrs and was completing the flt at night when the accident occurred. He was using visual cues (the arpt enviroment) to position the acft at a proper alt for a visual apch and landing. The terrain south of the arpt rises several… - [NTSB ATL86FA034](https://openairdocs.org/ntsb/ATL86FA034.md): Piper PA-28-180 · Dacula, GA · Accident · 2 fatal · Field investigation · Final report · Dec 2, 1985 · N9289J · Destroyed > The acft collided with trees 3.5 miles from the arpt during an instrument approach in dense fog. The approach required an adf receiver and the acft did not have one. The mda on the approach was 1600 ft. the acft impacted the trees at 1200 ft MSL. The acft was… - [NTSB NYC86LA045](https://openairdocs.org/ntsb/NYC86LA045.md): Piper PA-34 · Hazleton, PA · Accident · No injuries · Limited investigation · Final report · Dec 1, 1985 · N4324D · Substantial damage > Piper aircraft ran off the runway during landing at Hazleton Pennsylvania. According to the pilot the first approach was missed due to bad visibility. The flight returned to the initial aprroach fix for a second attempt. The pilot broke out of the clouds at… - [NTSB LAX86MA050](https://openairdocs.org/ntsb/LAX86MA050.md): Bell 206L-1 · San Pedro, CA · Accident · 1 fatal · Major investigation · Final report · Dec 1, 1985 · N3913Z · 2 aircraft · Destroyed > Two Bell 206L'S (N3913Z oprd by helitrans, N5759Y oprd by island express) deptd avalon 2 min apart on flts to San Pedro. Arr route at destn was ovr a RVR with angling fnl acph arnd a floating restaurant (fr). Heliport (HP) was in congested area nr bridge,… - [NTSB LAX86LA051](https://openairdocs.org/ntsb/LAX86LA051.md): Pitts S1-C · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Dec 1, 1985 · N75PB · Substantial damage > The plt was practicing takeoff and landings on rwy 13 at reid-hillview airport, San Jose, CA. The plt reported that during the base leg to final turn, while negotiating a 'power-off' apch, he attempted by apply pwr but was unable to do so. The acft crashed in… - [NTSB LAX86LA049](https://openairdocs.org/ntsb/LAX86LA049.md): Piper PA-18A-150 · Likely, CA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1985 · N6878B · Substantial damage > While practicing power-off forced landings in an open, snow covered field, the pilot said he applied the throttle to abort the approach but the engine 'sputtered then quit.' The aircraft landed in the snow covered field and flipped over. The pilot said he… - [NTSB ATL86FA032](https://openairdocs.org/ntsb/ATL86FA032.md): Beech C90 · East Greenwich, RI · Accident · 2 fatal · Field investigation · Final report · Nov 27, 1985 · N220F · Destroyed > The acft crashed about nine miles short of the rwy during an ILS approach to warwick, RI in IMC wx. The acft had been cleared to descend from 13000 to 3000 ft. the acft crashed outside the outer marker. The co-plt had reported the acft as inside the outer… - [NTSB SEA86FVW01](https://openairdocs.org/ntsb/SEA86FVW01.md): Griffin, Thomas Modified KR-Z · Panaca, NV · Accident · 1 fatal · Final report · Nov 26, 1985 · N999TG · Destroyed > A witness to the accident observed the aircraft climb straight ahead and make a shallow left 90 degree turn. The aircraft was then observed to resume level flight. The aircraft then slowly wen into a bank and fell off into a dive striking the ground. This was… - [NTSB NYC86LA044](https://openairdocs.org/ntsb/NYC86LA044.md): Piper Aztec · North Adams, MA · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 1985 · N6LQ · Destroyed > The flight departed albany new york under VFR conditions and picked up IFR clearance to pittsfield, MA. The pilot flew the approach until reaching VFR under a cloud layer at about 2500 ft. continuing VFR toward no. Adams at an altitude of 2000 ft, the pilot… - [NTSB MKC86MA031](https://openairdocs.org/ntsb/MKC86MA031.md): Rockwell 500-S · Des Moines, IA · Accident · 7 fatal · Major investigation · Final report · Nov 25, 1985 · N81589 · Destroyed > N81589 was flwg a Boeing 727 on ILS apch in IFR conds. Aprx 2.5 mi fm rwy, N81589 suddenly deviated left nrly 90 deg. 39 sec later, plt rprtd he enctrd svr turbc, then said he was trying to clb. N81589 subsequently flew thru tree tops on rising trrn for aprx… - [NTSB MKC86FA030](https://openairdocs.org/ntsb/MKC86FA030.md): Cessna P210N · Tontitown, AR · Accident · 2 fatal · Field investigation · Final report · Nov 25, 1985 · N86JB · Destroyed > After completing two erratic 360 deg turns in a holding pattern west of the razorback VORTAC station, the plt was instructed to proceed via the 218 deg radial of the razorback VORTAC until reaching the elmie intersection and to hold. A couple of minutes later… - [NTSB DEN86LA029](https://openairdocs.org/ntsb/DEN86LA029.md): Cessna C-152 · Franktown, CO · Accident · No injuries · Limited investigation · Final report · Nov 24, 1985 · N6122P · Substantial damage > According to the plt, upon initiating a pwr recovery after a simulated forced landing, the acft in which he and his pax were in, encountered turbulence. The plt stated that the acft contacted the ground shortly thereafter. The plt said he allowed the acft to… - [NTSB ATL86LA031](https://openairdocs.org/ntsb/ATL86LA031.md): Cessna 152 · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Nov 24, 1985 · N45920 · Substantial damage > During a cross country flight, the pilot elected not to refuel at his proposed refueling point and continued to another airport. While on a visual approach to the runway, the aircraft lost power due to fuel exhaustion. - [NTSB LAX86LA044](https://openairdocs.org/ntsb/LAX86LA044.md): Cessna 177 · Stockton, CA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1985 · N3459T · Substantial damage > After performing a preflight inspection of his acft, the PIC along with a CFI who was acting as his safety plt, and another passenger departed. The CFI reportedly had logged over 19,000 hours & possessed an ATP certificate. The PIC did not report having any… - [NTSB LAX86LA040](https://openairdocs.org/ntsb/LAX86LA040.md): Piper PA28-151 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Nov 18, 1985 · N41309 · Substantial damage > While on final apch for San Jose muni airport at the end of a cross country flt, the acft experienced total fuel exhaustion. Plt diverted a/c to ried hillview airport & established power-off glide. On final for rwy 31R, plt said he realized the a/c would not… - [NTSB FTW86LRD03](https://openairdocs.org/ntsb/FTW86LRD03.md): Cessna 185 · Leeville, LA · Accident · No injuries · Final report · Nov 18, 1985 · N4732E · Substantial damage > The acft collided with a power line during an off arpt landing on a canal. It was an intentional landing to transport company employees of la-tex gulf drilling, inc. the wx was VMC and no flt plan was filed. - [NTSB NYC86LA036](https://openairdocs.org/ntsb/NYC86LA036.md): Cessna C182 · Gardiner, NY · Accident · No injuries · Limited investigation · Final report · Nov 17, 1985 · N5634B · Substantial damage > The acft contacted power lines on final apch and descended uncontrolled to ground impact. The plt reported that turbulence was encountered when he entered the traffic pattern. He then proceeded onto final apch at a 'normal altitude'and full flaps were added.… - [NTSB MKC86FA029](https://openairdocs.org/ntsb/MKC86FA029.md): Piper PA-22-135 · Osage Beach, MO · Accident · 2 fatal · Field investigation · Final report · Nov 17, 1985 · N8042C · Destroyed > Witnesses observed N80426 lt of the final apch course for rwy 14 heading toward the arpt for landing. One witness said the acft was at 300 to 400 ft AGL when the nose of the acft rose abruptly, the lt wing went down and the acft descended to the ground. Other… - [NTSB BFO86FA006](https://openairdocs.org/ntsb/BFO86FA006.md): Eipper Quicksilver MXL II · Parkton, MD · Accident · 1 fatal · Field investigation · Final report · Nov 17, 1985 · N401WA · Destroyed > Witnesses in the area observed the vehicle flying in the local area at other times however this was the first time they had seen two people in it. They also observed the vehicle flying erratically after liftoff and noted that the winds were gusty. Upon… - [NTSB SEA86LA024](https://openairdocs.org/ntsb/SEA86LA024.md): Cessna 421C · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Nov 16, 1985 · N124RS · Substantial damage > During initial apch inflight icing was encountered. The windscreen failed to heat due to an inoperative inverter. A small area on the right bottom portion of the windscreen de-iced due to defrost heat. The plt elected to land using the small clear area of the… - [NTSB NYC86LA035](https://openairdocs.org/ntsb/NYC86LA035.md): Lake LA4-200 · Millbrook, NY · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1985 · N6195V · Substantial damage > During a go-around the aircraft stalled and crashed on the airport. - [NTSB NYC86FA034](https://openairdocs.org/ntsb/NYC86FA034.md): Piper PA-28-161 · Wellsville, NY · Accident · 3 fatal · Field investigation · Final report · Nov 13, 1985 · N1400H · Destroyed > After departure the plt made 3 practice isl apchs at bradford regional arpt located 35 mls away. The acft returned to Wellsville and was cleared for rwy localizer apch. The plt radioed Wellsville UNICOM for advisories and was informed that a fog bank was over… - [NTSB MKC86FA026](https://openairdocs.org/ntsb/MKC86FA026.md): Cessna P210N · Wichita, KS · Accident · 4 fatal · Field investigation · Final report · Nov 13, 1985 · N3864P · Destroyed > The acdt occurred during an IFR, non-precision approach to the uncontrolled jabara airport. When the flt was one mile from the faf, ATC told the flt that in the event of a missedapproach N3864P should enter controlled airspace heading 360 deg. The controller… - [NTSB FTW86FA024](https://openairdocs.org/ntsb/FTW86FA024.md): Beech S35 · Pampa, TX · Accident · 1 fatal · Field investigation · Final report · Nov 13, 1985 · N6843Q · Destroyed > Drg arrival, N6843Q was cleared for an NDB rwy 17 apch. The plt's last radio call was at 1949 CST, when he acknowleged radar svc was terminated & freq chg was approved. When the acft did not arrive, a search was initiated. At 2335, after fog had lifted, the… - [NTSB CHI86FA026](https://openairdocs.org/ntsb/CHI86FA026.md): Cessna 402C · Detroit, MI · Accident · 1 fatal · Field investigation · Final report · Nov 12, 1985 · N6788Y · Destroyed > A 100-FT ceiling with 3000 ft RVR existed at Detroit. The plt attempted an ILS apch with a 200 ft dh when he struck trees one mile from the rwy. He flew the acft to the airfield but crashed near the threshold. The only apch plates found onboard were for… - [NTSB BFO86FA005](https://openairdocs.org/ntsb/BFO86FA005.md): Piper PA-23-250 · Coatesville, PA · Accident · 2 fatal · Field investigation · Final report · Nov 12, 1985 · N54136 · Destroyed > There was no wx rprtg stn at Coatesville, but aprx 25 mi ese at philadelphia, the forecast was for ocnl ceilings of 600'OVERCAST, vis 3 mi with lgt rain showers & fog. There were flt prctns for turbc blo 5000' due to wnd shear, ceilings & vis freq blo 1000' &… - [NTSB SEA86LA022](https://openairdocs.org/ntsb/SEA86LA022.md): Cessna T210N · Overton, NV · Accident · No injuries · Limited investigation · Final report · Nov 11, 1985 · N1604U · Substantial damage > Several diversions had been made due to encountering airframe icing. Once the pilot realized that a low fuel condition existed he asked for vectors to the nearest airport. The pilot had to make a forced landing due to fuel exhaustion 1 mile short of the… - [NTSB NYC86LA031](https://openairdocs.org/ntsb/NYC86LA031.md): Piper PA-32R-301T · West Chester, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 1985 · N4313T · Substantial damage > A practice VOR apch was made to the arpt. Afterwards a landing was attempted on rwy 27. A G0 around was made when the acft was too high on final. A second landing attempt was made. According to the CFI, while on final the student was headed for a touchdown… Next page: https://openairdocs.org/ntsb-phases/500/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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/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.