# NTSB investigations: Maneuvering 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 207 of 378 · 18,851 cases ## Cases, newest first - [NTSB SEA85FA067](https://openairdocs.org/ntsb/SEA85FA067.md): Cessna 175 · Bancroft, ID · Accident · 1 fatal · Field investigation · Final report · Mar 2, 1985 · N9386B · Destroyed > The acft impacted level terrain aprx 500 yards east of the Bancroft arpt. N9386B was one of a flt of two acft returning to Bancroft from preston, ID. The wx had deteriorated during the flt with snow showers and blowing snow. While the other acft was landing… - [NTSB LAX85LA162](https://openairdocs.org/ntsb/LAX85LA162.md): Sevdy Pitts Special 104 · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N913S · Substantial damage > While practicing aerobatics for an airshow, the plt entered a spin. During the spin maneuver, the eng sputtered, lost power & the prop stopped turning. The acft was not equipped with an electric starter, so the plt tried to windmill the prop by diving, but… - [NTSB FTW85LA135](https://openairdocs.org/ntsb/FTW85LA135.md): Hiller UH-12D · Big Spring, TX · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N26EW · Substantial damage > CFI was demonstrating a simulated eng failure with tailwind of 10 KTS, 20 KTS grnd speed. The acft yawed left and touchdown was made with 10 kt grnd speed. The right skid broke off and the acft rolled over. The maneuver was initiated at 4 ft skid height. - [NTSB ANC85LA049](https://openairdocs.org/ntsb/ANC85LA049.md): Cessna 207 · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N1715U · Destroyed > The plt was attempting a 180 deg turn to reverse direction away from lowering clouds and snow showers when the right wing dug into the snow covered terrain. The plt stated a virtual 'white out' condition existed at the time. - [NTSB DEN85FA088](https://openairdocs.org/ntsb/DEN85FA088.md): Bellanca 7GCAA · Cornville, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 28, 1985 · N6328N · Destroyed > The acft was on a local flt with the owner/private plt & a student plt on board. While in aerobatic flt over a narrow canyon/gully area, the acft collided with & severed 3 power lines & a static line, located aprx 100 ft above the ground. The acft then… - [NTSB FTW85LA129](https://openairdocs.org/ntsb/FTW85LA129.md): Rotorway Exec · Bethany, OK · Accident · No injuries · Limited investigation · Final report · Feb 27, 1985 · N3071 · Substantial damage > The owner/builder had a single engine, multi-engine, land rating, but did not have a helicopter rating. While practicing hover flt in his experimental helicopter, he unexpectedly allowed the helicopter to reach a higher than normal alt. He attempted to… - [NTSB LAX85FA156](https://openairdocs.org/ntsb/LAX85FA156.md): Cessna 152 · Newport Beach, CA · Accident · 3 fatal · Field investigation · Final report · Feb 26, 1985 · N714WJ · Destroyed > The student plt took off on a dark night in marginal wx conditions with 2 passengers occupying the only passenger seat. About 17 min later, the acft was observed in a low pass over a pier at Newport Beach, CA, flying toward the open ocean. After crossing over… - [NTSB CHI85LA125](https://openairdocs.org/ntsb/CHI85LA125.md): Cessna 152 · Frankton, IN · Accident · No injuries · Limited investigation · Final report · Feb 26, 1985 · N5394M · Substantial damage > During a setup for a practice stall the solo student pilot retarded the throttle, raised the nose slightly and applied carb heat. He believed he was losing airspeed too quickly so he then reapplied full power. At this point the engine rpms dropped to 5 or… - [NTSB LAX85LA155](https://openairdocs.org/ntsb/LAX85LA155.md): Robinson R-22A · Santa Barbara, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 25, 1985 · N85550 · Destroyed > Student plt stated that while flying the last leg of a solo cross country flight he was flying along the coast at 50 to 75 feet, he diverted his attention to look at the a man on the beach and when he looked back at the instruments he noticed the helicopter… - [NTSB CHI85FA121](https://openairdocs.org/ntsb/CHI85FA121.md): Mooney M20K · Coldwater, OH · Accident · 4 fatal · Field investigation · Final report · Feb 23, 1985 · N231GX · Destroyed > The flight departed without a pre-flight inspection, engine run up, or radio call on UNICOM. The aircraft was observed doing low altitude aerobatic maneuvers. Witnesses observed the aircraft nose over and impact the ground in a near vertica attitude from… - [NTSB DEN85FA084](https://openairdocs.org/ntsb/DEN85FA084.md): Taylorcraft BC-65 · Chinook, MT · Accident · 2 fatal · Field investigation · Final report · Feb 22, 1985 · N26580 · Destroyed > The airplane was observed to enter a shallow right climbing turn at about 200 feet AGL after making a low pass over friends. Witnesses said the airplane then stalled and dove to the ground. There was no evidence of airframe, eng, prop, flt control, or syst… - [NTSB SEA85LA060](https://openairdocs.org/ntsb/SEA85LA060.md): Bell 214B1 · Lowell, OR · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 1985 · N314RM · Substantial damage > The acft collided with hilly terrain during an emergency autorotation landing attempt following a reported eng overspeed. The crew reported there was an indication of eng overspeed which they could not control. Post acc examinationrevealed no evidence of… - [NTSB CHI85LA110](https://openairdocs.org/ntsb/CHI85LA110.md): Brantly Helicopter B-2 · Huntingburg, IN · Accident · No injuries · Limited investigation · Final report · Feb 18, 1985 · N511R · Substantial damage > The acft experienced a partial power loss and made a hard autorotative lndg during a training flt. Investigation of the eng revealed mistiming of the left mag. The eng during tests also ran hot until the addition of a cooling shroud. The other significant… - [NTSB LAX85LA144](https://openairdocs.org/ntsb/LAX85LA144.md): Cessna 172N · Healdsburg, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1985 · N739XZ · Destroyed > While on a local flt, the acft collided with trees in a canyon. The plt reported the acft's alt was lower than anticipated & the terrain in the canyon rose rapidly. Full eng power was not sufficient to negotiate the rising terrain. The plt reported the acft's… - [NTSB LAX85FJA04](https://openairdocs.org/ntsb/LAX85FJA04.md): Cessna 152 · Laupahoehoe, HI · Accident · Minor injuries · Final report · Feb 14, 1985 · N89246 · Destroyed > The acft collided with rising terrain while on a training alt. The student plt was scheduled to proceed to the practice area near puna for this first extended solo flt. At aprx 1200 HST, he returned to general lyman flt, hilo, ha, for touch-&-go landing… - [NTSB NYC85FGT01](https://openairdocs.org/ntsb/NYC85FGT01.md): Cessna 335 · Barrville, PA · Accident · Serious injuries · Final report · Feb 12, 1985 · N6821C · Destroyed > The Cessna 335 was making a contact approach when it flew into the ground. The aircraft received substantial damage and the pilot received serious injuries. Winds in the area were reported at 25 knots with gusts to 35 knots. Visual meteorological conditions… - [NTSB DEN85LA076](https://openairdocs.org/ntsb/DEN85LA076.md): Piper PA-18 · Thompson Falls, MT · Accident · No injuries · Limited investigation · Final report · Feb 11, 1985 · N3777P · Substantial damage > The acft nosed over during a forced lndg on terrain covered by 20 inches of snow. The flt was on deer survey flt the plt told of improper use of the carb heat control during a period of'perfect' icing conditions. The plts reduction of power during maneuvering… - [NTSB CHI85FA104](https://openairdocs.org/ntsb/CHI85FA104.md): Mooney M20C · Portsmouth, OH · Accident · 2 fatal · Field investigation · Final report · Feb 10, 1985 · N2961L · Destroyed > The acft was maneuvering at about 500 ft AGL when witnesses reported what they believed to be an eng malfunction. The acft then entered a spin and impacted in an open fld out of control. A conclusive cause of an eng malfunction could not be determined during… - [NTSB ATL85FA090](https://openairdocs.org/ntsb/ATL85FA090.md): Cessna 152 · Acworth, GA · Accident · Serious injuries · Field investigation · Final report · Feb 9, 1985 · N5317Q · Substantial damage > The acft contacted power lines and descended uncontrolled to the terrain during the recovery phase of a simulated forced landing. The simulated forced landing was initiated by the CFI at an alt of aprx 800 ft AGL over the median strip of hwy 75. The student… - [NTSB FTW85LA115](https://openairdocs.org/ntsb/FTW85LA115.md): Cessna 172K · Mccoy, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 1985 · N79043 · Substantial damage > The plt stated that he had departed the gala ranch strip & was flying at aprx 100 ft AGL to show his passengers their ranch property. While in slow flight with the flaps deployed, the plt entered a downwind skidding left turn. The acft subsequently stalled &… - [NTSB SEA85LA053](https://openairdocs.org/ntsb/SEA85LA053.md): Hughes 369D · Taholah, WA · Accident · Minor injuries · Limited investigation · Final report · Feb 4, 1985 · N8306F · Destroyed > The acft had lifted off during an external load operation when the plt felt a 'vibration/shudder'. The right skid contacted the ground and the helicopter rolled over during an attempt to maneuver the helicopter away from ground personnel. Inspection revealed… - [NTSB LAX85FA132](https://openairdocs.org/ntsb/LAX85FA132.md): Hiller UH12E · Five Points, CA · Accident · Minor injuries · Field investigation · Final report · Feb 3, 1985 · N5323V · Substantial damage > While performing an ag flight the helicopter's engin suddenly lost power. At the time the aircraft was near its max allowable gross weight and it was between 3-5FT AGL. As the aircraft yawed left and descended. The pilot in command attempted to land on a… - [NTSB NYC85LA058](https://openairdocs.org/ntsb/NYC85LA058.md): Luscombe 8A · Silver Lake, ME · Accident · Serious injuries · Limited investigation · Final report · Jan 30, 1985 · N1907B · Substantial damage > The acft stalled and contacted the ground while maneuvering during the initial takeoff climb. The plt reported that the acft became airborne following a short takeoff ground run and upon reaching tree top level, the plt reported, 'we just mushed along.' The… - [NTSB LAX85FJA01](https://openairdocs.org/ntsb/LAX85FJA01.md): Emair MA-1 · Paanilo, HI · Accident · No injuries · Final report · Jan 30, 1985 · N9924M · Substantial damage > The plt initiated his 1st spray pass uphill with about a 5 to 10 kt quartering tail wind. While on the swath run, he noted the airspeed was decaying, so he aborted the pass by turning into the wind. However, this resulted in flying over more rapidly rising… - [NTSB FTW85FA104](https://openairdocs.org/ntsb/FTW85FA104.md): Piper PA-34-220T · Victoria, TX · Accident · 1 fatal · Field investigation · Final report · Jan 30, 1985 · N8204A · Destroyed > The plt had rented the acft on January 28, 1985, with route of flt unknown. No reported contact was made with the acft. The acft impacted the surface during hours of darkness in instrument meteorological conditions and was demolished. The plt was fatally… - [NTSB SEA85FA051](https://openairdocs.org/ntsb/SEA85FA051.md): Beech BE-35 · Verdi, NV · Accident · 3 fatal · Field investigation · Final report · Jan 26, 1985 · N1560S · Destroyed > Pilot impacted rising terrain while descending into & thru IFR weather conditions during VFR flight. Lost visual contact w/ground and broke out in mountains. - [NTSB MKC85FA051](https://openairdocs.org/ntsb/MKC85FA051.md): Cessna 152 · Ashdown, AR · Accident · 2 fatal · Field investigation · Final report · Jan 26, 1985 · N89782 · Destroyed > Acft made two passes over residence to alert friend to go to nearby ag strip to pick up plt & pax. Acft was then seen flying in area at low alt & slow speed by the friend as she proceeded to the strip. She looked away from the acft momentarily & when she… - [NTSB DEN85FA069](https://openairdocs.org/ntsb/DEN85FA069.md): Cessna 150F · Marvel, CO · Accident · 2 fatal · Field investigation · Final report · Jan 26, 1985 · N6787F · Substantial damage > A witness reported seeing the acft enter a dive and level off aprx 10-15 ft AGL. The acft continued flt close to the ground for aprx 1/2 mile, the witness stated, before a near vertical climb was entered until the acft stalled. Recovery from the stall was not… - [NTSB ANC85FA040](https://openairdocs.org/ntsb/ANC85FA040.md): Piper PA-12 · Wasilla, AK · Accident · 1 fatal · Field investigation · Final report · Jan 25, 1985 · N2399M · Destroyed > Witnesses observed the plt 'buzzing' a building & rolling the acft about its longitudinal axis. After the 3rd pass, it entered a steep bank, stalled & pitched down into a wooded area. There was evidence that the acft was at least 73 lbs over its max weight… - [NTSB ATL85FA081](https://openairdocs.org/ntsb/ATL85FA081.md): Cessna 182H · Letohatchee, AL · Accident · 2 fatal · Field investigation · Final report · Jan 24, 1985 · N2431X · Destroyed > Acft was observed at low alt descending on a northerly hdg. About 1.5 mi. 5 of the crash site. Engine sounds were characterized as smooth and normal. Acft struck a 44000 volt x-mission line parting a 5/16IN. Diameter hi-strength steel ground cable and a 1/0… - [NTSB SEA85LA046](https://openairdocs.org/ntsb/SEA85LA046.md): Hiller UH12DJ3 · Forks, WA · Accident · No injuries · Limited investigation · Final report · Jan 22, 1985 · N87977 · Substantial damage > The acft made a hard landing and rolled to the left inverted after the engine quit due to fuel exhaustion. The plt stated that the fuel guage was not working and that he was using a dip stick to measure fuel at the time of the engine failure. He stated that… - [NTSB MIA85LA084](https://openairdocs.org/ntsb/MIA85LA084.md): Cessna 340A · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Jan 21, 1985 · N6829L · Substantial damage > The acft collided with power lines while operating at low alt over an unpopulated area. The plt indicated that he descended to a 'low alt' & pulled up to aviod some trees. After the pull-up, he said that he noticed some damage & continued his flt to ft.… - [NTSB LAX85FA115](https://openairdocs.org/ntsb/LAX85FA115.md): Bell 205A-1 · Newhall, CA · Accident · 1 fatal · Field investigation · Final report · Jan 18, 1985 · N830V · Destroyed > This helicopter collided with hilly terrain while circling at a low altitude. It was following another helicopter in a clockwise circular pattern at the time, and being filmed for the t.v. series 'air wolf'. One witness observed the helicopter decending in… - [NTSB SEA85LA042](https://openairdocs.org/ntsb/SEA85LA042.md): Cessna T210M · Troutdale, OR · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 1985 · N6475B · Substantial damage > Shortly after takeoff plt felt a 'tick' in the engine. Plt reduced pwr and headed back to Troutdale. Engine quit over the threshold of rwy 07 as plt was making a 360 deg turn. Acft touched down short of rwy 07 contacting small bushes and trees. Inspection… - [NTSB NYC85LA054](https://openairdocs.org/ntsb/NYC85LA054.md): Cessna 152II · Franklin, PA · Accident · No injuries · Limited investigation · Final report · Jan 16, 1985 · N5497P · Substantial damage > The acft experienced a nose gear collapse during a landing in deep snow at Franklin center arpt after a partial loss or pwr. The CFI and student were practicing apch to landing stall recovery when the eng failed to produce full pwr. There was unsufficient pwr… - [NTSB ANC85FA095](https://openairdocs.org/ntsb/ANC85FA095.md): Cessna 207 · Port Alsworth, AK · Accident · 1 fatal · Field investigation · Final report · Jan 16, 1985 · N1618U · Substantial damage > The pilot continued the air taxi flight into adverse weather conditions and struck a mountain. - [NTSB DEN85LA064](https://openairdocs.org/ntsb/DEN85LA064.md): Cessna 182Q · Wapiti, WY · Accident · Serious injuries · Limited investigation · Final report · Jan 14, 1985 · N759WB · Destroyed > According to the pilot as she was flying her aircraft in a canyon she encountered downdrafts which pushed her aircraft down. She was unable to maintain her airspeed or altitude and elected to put the aircraft into the trees. - [NTSB LAX85LA103](https://openairdocs.org/ntsb/LAX85LA103.md): Piper PA-28-161 · Beaumont, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1985 · N29493 · Substantial damage > The acft was on a personal VFR flt to santa barbara, CA, on a dark ovcst night. Marginal VFR conditions with lgt rain prevailed. Gnd witnesses rptd the acft was following the hwy at about 200 ft AGL prior to the accident. The plt rptd he inadvertently began… - [NTSB ANC85LA035](https://openairdocs.org/ntsb/ANC85LA035.md): Fairchild Hiller FH-1100 · Glennallen, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1985 · N5056F · Destroyed > Shortly after liftoff plt experienced downdrafts and variable wind gusts. Plt decided to set the helicopter back down aprx 100 yds from point of takeoff. Plt stated hovering was very difficult and the helicopter settled to the upsloping terrain. The… - [NTSB FTW85FA094](https://openairdocs.org/ntsb/FTW85FA094.md): Piper J3C-65 · Ferriday, LA · Accident · 1 fatal · Field investigation · Final report · Jan 8, 1985 · N1474N · Substantial damage > Acft was observed in slow flt aprx 40 ft AGL just above stall speed with the eng operating smoothly. The acft then stalled and impacted in an aprx 90 deg nose down attitude. The plt was flying from the front seat. The acft was not equipped with shoulder… - [NTSB LAX85LA099](https://openairdocs.org/ntsb/LAX85LA099.md): Aeronca 7AC · Chandler, AZ · Accident · Serious injuries · Limited investigation · Final report · Jan 7, 1985 · N84096 · Substantial damage > The PIC reported the 2nd plt was flying the acft at the time of the accident while they were practicing off arpt landings. On the second takeoff, the 2nd plt executed a course reversal turn to land opposite the direction of takeoff. The initial turn was to… - [NTSB ANC85LA033](https://openairdocs.org/ntsb/ANC85LA033.md): Maule M6-235 · Trading Bay, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 5, 1985 · N5652D · Substantial damage > The plt-in-command, IA an attempt to avoid a mid-air collision, did not control his airplane sufficiently to avoid a stall. Once in the stall the plt-in-command did not properly recover & the airplane mushed into the ground. - [NTSB DEN85LA057](https://openairdocs.org/ntsb/DEN85LA057.md): Aerospatiale SA315B · Salt Lake City, UT · Accident · Minor injuries · Limited investigation · Final report · Jan 3, 1985 · N1356A · Destroyed > The helicopter collided uncontrolled with the terrain during external load operation. A 100 ft steel cable was attached to the cargo hook on the helicopter and a nylon sling was attached to the cable so a snowcat could be pulled out of a mud area. The plt… - [NTSB MKC85FA042](https://openairdocs.org/ntsb/MKC85FA042.md): Cessna 150F · Pawnee City, NE · Accident · 1 fatal · Field investigation · Final report · Jan 2, 1985 · N7138F · Substantial damage > Plt and passenger departed to fly over a group of friends who were on a coyote hunt. Witness stated the acft approached from the NE aprx 300 ft AGL. Acft then made a left crcling turn and was described as flying very slow. After completing aprx 360 degrees of… - [NTSB MIA85FA071](https://openairdocs.org/ntsb/MIA85FA071.md): Fuji LM-1 "NIKKO" · Odessa, FL · Accident · Serious injuries · Field investigation · Final report · Jan 1, 1985 · N2104X · Substantial damage > The acft collided with the ground in an acft parking area on the arpt after a low alt loop which was not completed prior to ground contact. The plt had made one low pass down the rwy in formation with another Fuji acft, a 2nd pass ended in an aileron roll,… - [NTSB ATL85FA072](https://openairdocs.org/ntsb/ATL85FA072.md): Cessna 182A · Dublin, VA · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1984 · N4963D · Destroyed > After dropping the parachutist, the acft was observed to fly eastward over the dz, make a left 180 turn, line up on the parked van on an easterly heading and descend to a low altiude. Witnesses estimated the altitude at from 10 T0 30 ft AGL. The van was… - [NTSB LAX85FA088](https://openairdocs.org/ntsb/LAX85FA088.md): Cessna 182Q · Upland, CA · Accident · 4 fatal · Field investigation · Final report · Dec 28, 1984 · N735MJ · Destroyed > The instrument rated plt & 3 pax departed palo alto for an intended 3-hour long day VFR flt to santa ana, CA. The final destination was to be mx. The plt had not flown at night or on instruments in over 6 yrs. He elected to delay departing pao until 1611 PST… - [NTSB FTW85FA087](https://openairdocs.org/ntsb/FTW85FA087.md): Cessna T210N · Brackettville, TX · Accident · 3 fatal · Field investigation · Final report · Dec 26, 1984 · N6578Y · Destroyed > The plt had filed an instrument flt plan from how to dht and had received a wx briefing for the route. The flt proceededto dht where radar contact was lost and the acft was cleared for an apch. The plt canceled IFR. The plt then proceeded to Brackettville,… - [NTSB FTW85FA086](https://openairdocs.org/ntsb/FTW85FA086.md): Cessna 441 · Marble Falls, TX · Accident · 1 fatal · Field investigation · Final report · Dec 26, 1984 · N441CM · Destroyed > The acft crashed aprx 1.5 miles south of the departure end of rwy 17 during an attempted rwy 17 NDB apch. The acft was cleared for the apch at 2012 CST and the plt canceled IFR reporting the arpt in sight at 2014. A witness located aprx 1 mile south of the… - [NTSB SEA85FA036](https://openairdocs.org/ntsb/SEA85FA036.md): Piper PA-18-150 · Imlay, NV · Accident · 2 fatal · Field investigation · Final report · Dec 25, 1984 · N9659P · Destroyed > Plt was reportedly engaged in aerial coyote hunting, witnesses observed acft of this description flying low and slow in vicinity but there were no eyewitnesses to the crash. Investigation revealed acft impacted ground upright with high vertical descent rate.… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=208 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=207 --- 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.