# 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 198 of 378 · 18,851 cases ## Cases, newest first - [NTSB MKC86FA098](https://openairdocs.org/ntsb/MKC86FA098.md): Cessna 150 · Harrisburg, NE · Accident · 1 fatal · Field investigation · Final report · Apr 30, 1986 · N10768 · Substantial damage > The acft impacted in a 40 degree nose down attitude following a stall-spin. No mechanical descrepancies were noted with the acft and no pre-existing physical incapacitating history of the PIC was discovered. On two separate occasions prior to this flt, the… - [NTSB CHI86FEX07](https://openairdocs.org/ntsb/CHI86FEX07.md): Air Tractor AT301 · Bruceville, IN · Accident · Minor injuries · Final report · Apr 29, 1986 · N3660Y · Destroyed > The acft collided with trees during a pull-up at the end of a swath run. During the collision the rt wing tip separated from the acft and the acft rolled hitting the ground with the rt wing first which started a cartwheel. Investigation revealed that the acft… - [NTSB NYC86FA114](https://openairdocs.org/ntsb/NYC86FA114.md): Glaser-Dirks DIRK-DG-400 · Julian, PA · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1986 · N40MS · 2 aircraft · Destroyed > The plt of N686U reported he was established in weak thermal at an alt of aprx 2500 AGL when two other gliders were seen. One at aprx the same alt and one below his alt. He continued to state that the glider which was at his alt passed very close to but… - [NTSB ANC86LA051](https://openairdocs.org/ntsb/ANC86LA051.md): Piper PA-22 · Chugiak, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1986 · N3438A · Substantial damage > While flying in the mountains at about 5000 feet MSL (200 feet AGL), the airplane encountered a downdraft, causing it to crash on a glacier. Pilot estimated the winds to be about 10 knots. - [NTSB LAX86LA195](https://openairdocs.org/ntsb/LAX86LA195.md): Cessna 172 · Kearny, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1986 · N12962 · Destroyed > The plt stated that he was on a sightseeing flt and was flying westbound at about 100 ft AGL along the gila river, when the acft struck powerlines. The acft then descended into the river bed. He futher stated that he observed the powerlines at the last minute… - [NTSB ATL86LA119](https://openairdocs.org/ntsb/ATL86LA119.md): Piper PA-25-150 · Braselton, GA · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N6242Z · Substantial damage > The pilot reported that the engine RPM decreased while conducting a banner tow flight and that the engine subsequently quit. The airplane was landed in a field of an auto race track where a telephone pole was struck during the landing roll. Temperature was 92… - [NTSB DEN86LA119](https://openairdocs.org/ntsb/DEN86LA119.md): Bell 47G-3B-2 · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Apr 25, 1986 · N4073G · Substantial damage > According to the student plt, he was attempting to hover the helicopter when he encountered turbulence. The student plt stated that the hard landing which followed resulted in spreading the skids & severing the tailboom. - [NTSB CHI86FA129](https://openairdocs.org/ntsb/CHI86FA129.md): Bell 222B · Chicago, IL · Accident · Minor injuries · Field investigation · Final report · Apr 25, 1986 · N660DD · Substantial damage > The aircraft had just discharged two passengers on the rooftop helipad and was preparing for departure. The aircraft was picked up to a hover and the tailrotor struck a heliport surface perimeter light. The tailrotor separated from the aircraft and the… - [NTSB ANC86LA047](https://openairdocs.org/ntsb/ANC86LA047.md): Piper J3C-65 · Yentna River, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 24, 1986 · N170CH · Substantial damage > The pilot stated that the aircraft began to settle; airspeed was 60 mph. The aircraft would not recover altitude with full power. The aircraft stalled and struck tree tops. - [NTSB LAX86LA188](https://openairdocs.org/ntsb/LAX86LA188.md): Hughes 269 · Kahului, HI · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 1986 · N9288F · Substantial damage > A Hughes 269 went out of control after turning left into a 20 kt tailwind condition. The plt indicated that the engine failed. The eng was run on a eng test stand and no deficientcies were found. A fuel sample was found to be within specified parameters. Ac… - [NTSB NYC86FA112](https://openairdocs.org/ntsb/NYC86FA112.md): Cessna 310 · Lincoln, RI · Accident · 1 fatal · Field investigation · Final report · Apr 21, 1986 · N128K · Destroyed > The air taxi cargo aircraft was observed maneuvering over the airport in IMC conditions for a VFR approach to land. Witnesses described an abrupt turn to reverse direction of flight followed by a nose dive into the ground. The pilot, age 22, had accummulated… - [NTSB LAX86MA186](https://openairdocs.org/ntsb/LAX86MA186.md): LTV Aerospace Industries A7E · Warner Springs, CA · Accident · No injuries · Major investigation · Final report · Apr 20, 1986 · USN · 2 aircraft · Substantial damage > A rolladen-schneider LS-4 glider and an Ltv A7E jet collided over hot Springs mtn, near Warner Springs, CA. The A7E was attempting a rapid pull up and the glider was attempting a nose down, 30 deg right turn when they collided. Both aircraft were operating… - [NTSB FTW86FRG18](https://openairdocs.org/ntsb/FTW86FRG18.md): Baby Bird Q2-200 · Gerogetown, TX · Accident · Serious injuries · Final report · Apr 20, 1986 · N39943 · Destroyed > The acft landed short of the rwy after losing partial pwr while maneuvering around the arpt. The plt had radioed that the eng was developing about 2000 RPM. The plt had reported throttle problems on previous flt. Due to impact damage it was not possible to… - [NTSB NYC86FGM01](https://openairdocs.org/ntsb/NYC86FGM01.md): Vere Eze Long EZE · Dorrseyville, PA · Accident · No injuries · Final report · Apr 19, 1986 · N40FP · Substantial damage > The homebuilt acft collided with a ditch during a forced lndg short of the rwy after a power loss during a test flt. The plt had noted smoke in the cockpit and a loss of oil pressure. As he returned to the arpt the eng began to run rough and surge before… - [NTSB SEA86LA106](https://openairdocs.org/ntsb/SEA86LA106.md): Bell 47G-3B1 · Lapwai, ID · Accident · No injuries · Limited investigation · Final report · Apr 18, 1986 · N1371X · Substantial damage > The helicopter rotor mast struck powerlines at an alt of 12 ft AGL during an aerial application flt. The plt reported she inadvertently missed seeing the powerlines when she made her survey of the terrain prior to this flt. The helicopterdescended and… - [NTSB ATL86LA115](https://openairdocs.org/ntsb/ATL86LA115.md): Cessna 150 · Lake City, TN · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1986 · N63636 · Destroyed > While filming for king kong productions, a Cessna 150, flown by the production pilot collided with bowel mountain near Lake City, TN the pilot was flying low over the terrain when the aircraft failed to climb as fast as the pilot anticipated. The aircraft… - [NTSB MKC86LA091](https://openairdocs.org/ntsb/MKC86LA091.md): Rockwell S-2R · Salem, IA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1986 · N4949X · Substantial damage > The pilot states that the engine quit without warning as he was spraying a wheatfield. Pilot further states that he had very little time to pick a suitable landing area. He landed in hilly terrain and slid sideways into a crest, tearing out the right main… - [NTSB ATL86LA113](https://openairdocs.org/ntsb/ATL86LA113.md): Cessna 150 · Appalachia, VA · Accident · Serious injuries · Limited investigation · Final report · Apr 14, 1986 · N7792E · Destroyed > N7792E experienced a gradual power loss while en route to greenwood. S.c. via Appalachia, VA. The pilot reported that the engine quit and restarted for a few seconds after he had been flying about twenty minutes. This cycle continued for about two more… - [NTSB LAX86LA176](https://openairdocs.org/ntsb/LAX86LA176.md): Cessna 152 · Snellings, CA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1986 · N5150B · Substantial damage > The CFI stated that he pulled the acft up to avoid birds and then lowered the nose to gain airspeed from 70 KTS back to cruise speed. During the dive the acft collided with a power line that crossed a river at about 50 ft AGL. After the collision the acft was… - [NTSB DEN86LA116](https://openairdocs.org/ntsb/DEN86LA116.md): Beech A-36 · Wall, SD · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 1986 · N4479W · Substantial damage > According to the plt he was making a precautionary landing due to wx, when the acft he was piloting encountered an unexpected crosswind just prior to touchdown. The plt said the left wing dipped & made contact with the ground. The impact resulted in… - [NTSB MKC86LA086](https://openairdocs.org/ntsb/MKC86LA086.md): Grumman G164B · Advance, MO · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N6609Q · Substantial damage > The airplane was being operated as an agricultural aircraft when the engine started backfiring and then quit. During the forced landing in a plowed field, the airplane flipped forward to the inverted position. Investigation revealed the teeth on the left… - [NTSB LAX86LA175](https://openairdocs.org/ntsb/LAX86LA175.md): Robinson R22 · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N211DM · Substantial damage > The pilot stated that he was attempting to land on a dirt road and that the helicopter was at a two to five foot hover when a gust of wind pivoted the tail into the wind. The helicopter touched down and rolled over onto its right side. The pilot further… - [NTSB FTW86FA063](https://openairdocs.org/ntsb/FTW86FA063.md): Cessna 177RG · Dallas, TX · Accident · 1 fatal · Field investigation · Final report · Apr 12, 1986 · N8047G · Destroyed > The pilot was advised by the FAA weather briefer, prior to flight, against making this flight due to present and forecast weather conditions. After arriving in the general area of his destination the plt observed the weather conditions and commented on thier… - [NTSB MKC86FA083](https://openairdocs.org/ntsb/MKC86FA083.md): Glasair 2 · Cheney, KS · Accident · 1 fatal · Field investigation · Final report · Apr 8, 1986 · N161JD · Destroyed > The acft approached Cheney lake, west of wichita, Kansas at low altitude from the southeast. Several witnesses fishing from the bank saw the acft pass near the Cheney lake marina heading toward the lake. The acft then entered a spin and crashed into the lake… - [NTSB MIA86LA117](https://openairdocs.org/ntsb/MIA86LA117.md): Fairchild Hiller FH-1100 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Apr 8, 1986 · N428FH · Substantial damage > The student plt was on a supervised solo flt & was hovering. The helicopter was seen to wobble, roll to the right & crash to the ground. The owner of the helicopter stated that he had flown the acft just prior to the accident & the acft performed normally.… - [NTSB MIA86FA115](https://openairdocs.org/ntsb/MIA86FA115.md): Pitts Special · Homestead, FL · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1986 · N501L · Destroyed > The plt was on a flt to practice aerobatic mnvrs in a designated practice area. A witness, who was driving nearby, stated that he saw the acft 'falling straight down' & crash in a tomato field. An investigation revealed evidence that the acft had impacted in… - [NTSB NYC86LA099](https://openairdocs.org/ntsb/NYC86LA099.md): Sikorsky S-76 · Safe Harbor, PA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1986 · N221SC · Substantial damage > The helicopter was maneuvering at low altitude, low airspeed, while on a search and rescue mission at night, looking for a capsized boat, when it impacted the water. - [NTSB FTW86FA059](https://openairdocs.org/ntsb/FTW86FA059.md): Beech 65 · Montague, TX · Accident · 1 fatal · Field investigation · Final report · Apr 5, 1986 · N810Q · Destroyed > The pilot was observed in the area for several minutes while he was performing steep climbs and descents, low passes, and buzzing. Witnesses reported power was removed from both engines simultaneously, as if the throttles were retarded, followed by a loud… - [NTSB ATL86LA105](https://openairdocs.org/ntsb/ATL86LA105.md): Cessna 152 · Moultrie, GA · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 1986 · N48885 · Destroyed > A deputy sheriff rented an acft to assist the sheriff's dept with a ground search for an escaped prisoner. Witnesses observed the acft flying low and slow over the area when it made a partial turn and pitch down into the trees. There were no indications of… - [NTSB ANC86LA042](https://openairdocs.org/ntsb/ANC86LA042.md): Robinson R-22A · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Apr 3, 1986 · N8455P · Substantial damage > The student helicopter pilot stated that the helicopter nosed over and rolled to the right during the hover. The pilot encountered a roll to the right due to low rotor RPM. - [NTSB LAX86FJA01](https://openairdocs.org/ntsb/LAX86FJA01.md): Schweizer 2-32 · Dillingham Fld, HI · Accident · No injuries · Final report · Apr 2, 1986 · N1189S · Substantial damage > The glider collided with a power line as the plt maneuvered down a valley to recover some airspeed that had been lost along a ridgeline. The vertical fin and rudder were damaged along the top 18 inches but the acft was landed without further incident. - [NTSB CHI86FEC01](https://openairdocs.org/ntsb/CHI86FEC01.md): Taylorcraft BC12-D · Leslie, MI · Accident · Minor injuries · Final report · Apr 1, 1986 · N94903 · Substantial damage > The acft was damaged during a forced lndg following a loss of power after a low pass over an off arpt intended landing area. The plt was overflying a field belonging to a friend in preparation for a possible landing when a loud clunk was heard from the eng… - [NTSB MKC86FA077](https://openairdocs.org/ntsb/MKC86FA077.md): Donald R. Casper Skyote · St. Louis, MO · Accident · 1 fatal · Field investigation · Final report · Mar 31, 1986 · N106DC · Destroyed > The pilot built the homebuilt airplane from data obtained from skyote aeromarine ltd. at the time of the accident, the airplane had 51 hours on it and the pilot/builder had flown all of the 51 hours. On this flight he was observed to depart on runway 16, fly… - [NTSB FTW86FRD11](https://openairdocs.org/ntsb/FTW86FRD11.md): Grumman G-164A · Crowley, LA · Accident · No injuries · Final report · Mar 31, 1986 · N4561 · Substantial damage > The acft crashed into wires and a house during an attempted forced landing. The plt was preparing to do rice seeding when the eng began to backfire & lose power. The plt was trying to return to the ag strip when the eng quit and he was forced to land. Eng… - [NTSB DEN86LA108](https://openairdocs.org/ntsb/DEN86LA108.md): Luscombe T-8F · Watkins, CO · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 1986 · N1593B · Destroyed > While practicing ground reference maneuvers at 500 ft AGL a total loss of engine power was experienced. The pilot rated passenger in the rear seat performed the emergency landing while the PIC attempted to restart the engine. The landing was made on open… - [NTSB CHI86FEP02](https://openairdocs.org/ntsb/CHI86FEP02.md): Piper PA-38-112 · Dexterville, WI · Accident · Serious injuries · Final report · Mar 31, 1986 · N23854 · Substantial damage > On the fourth flight of the day carrying relatives in the vicinity of another relatives house the pilot admitted that he allowed the airspeed to decay during a 55 degree bank and did not recognize an impending stall. When the aircraft stalled there was… - [NTSB FTW86FA051](https://openairdocs.org/ntsb/FTW86FA051.md): Cessna 172N · Del Rio, TX · Accident · 4 fatal · Field investigation · Final report · Mar 30, 1986 · N8423E · Destroyed > The pilot was doing aerobatic maneuvers in the Cessna 172 airplane with three passengers and a heavy load of fuel aboard. The maneuvers consisted of buzzing boats on the lake at very low altitude, at least one complete aileron roll, several very abrupt… - [NTSB ATL86FA102](https://openairdocs.org/ntsb/ATL86FA102.md): North American NA219 (T28B) · Luthersville, GA · Accident · 2 fatal · Field investigation · Final report · Mar 30, 1986 · N544E · Destroyed > After takeoff the acft was observed to climb straight out toan alt of about 500-700 ft. it then turned to a northerly heading. After a short time on the northerly hdg, the acft was observed to initiated a left aileron or barrel roll, dishout and end up on an… - [NTSB LAX86LA158](https://openairdocs.org/ntsb/LAX86LA158.md): Cessna 150L · Kailua Kona, HI · Accident · 1 fatal · Limited investigation · Final report · Mar 29, 1986 · N7384G · Destroyed > Ground witnesses observed the acft spiral into the pacific ocean. Neither the plt nor the acft have been recovered. - [NTSB CHI86FER03](https://openairdocs.org/ntsb/CHI86FER03.md): Hughes 269A (TH-55A) · Lakeville, MN · Accident · Minor injuries · Final report · Mar 29, 1986 · N10415 · Destroyed > The CFI reported the accident occurred during a demonstration of wind effect during turns around a point. The CFI reported that as the helicopter was turned downwind it began descending from an alt of aprx 200 ft AGL. It continued it's descent until the right… - [NTSB CHI86FEX05](https://openairdocs.org/ntsb/CHI86FEX05.md): Christen Industries Eagle II · Aurora, IN · Accident · 1 fatal · Final report · Mar 26, 1986 · N39RH · Destroyed > The aircraft impacted the ground when an unsuccessful aerobatic loop maneuver was attempted on takeoff. The pilot of the aircraft was issued a statement of acrobatic compentency which allowed all maneuvers within the limitations of the aircraft and with a… - [NTSB FTW86FA046](https://openairdocs.org/ntsb/FTW86FA046.md): Cessna 120 · Whitefield, OK · Accident · 1 fatal · Field investigation · Final report · Mar 22, 1986 · N77483 · Destroyed > The pilot was flying at very low altitude while circling the area and most probably did not see the powerline, due to sunglare, until at very close range. He then pulled up steeply in the strong and gusty headwind and stalled the aircraft without sufficient… - [NTSB ATL86FA097](https://openairdocs.org/ntsb/ATL86FA097.md): Robinson R-22 · Memphis, TN · Accident · 2 fatal · Field investigation · Final report · Mar 22, 1986 · N9069S · Destroyed > A loss of control in flight for undetermined reasons. - [NTSB LAX86FVG02](https://openairdocs.org/ntsb/LAX86FVG02.md): Sikorsky S-55 · Afton, CA · Accident · No injuries · Final report · Mar 21, 1986 · N8327 · Substantial damage > The acft was landed off the arpt in a forced landing after a pwr loss. The acft was damaged in the hard landing. Eng teardown showed the r/h magneto model S7LV-2 had stripped distributor drive gears. No other abnormalities noted. The TSO of the mag was… - [NTSB MIA86FA100](https://openairdocs.org/ntsb/MIA86FA100.md): Beech D-35 · Crystal Springs, FL · Accident · 3 fatal · Field investigation · Final report · Mar 18, 1986 · N5968C · Destroyed > Witnesses stated they observed the acft performing aerobatics while at an estimated alt of 1000 to 1300 ft. after the completion of a loop, the acft was observed to nearly come to a stop while vertical, then fall off to the left & enter a spin which continued… - [NTSB DEN86FA099](https://openairdocs.org/ntsb/DEN86FA099.md): Cessna 401 · Silver City, NM · Accident · Serious injuries · Field investigation · Final report · Mar 14, 1986 · N9867F · Substantial damage > The 2 com rated plts were returning from a part 135 flt at night. The fuel tanks were inadvertently not switched from mains to aux. Fuel starvation occurred when acft was at low altitude. Insufficient altitude remained to restart the engines. Acft impacted… - [NTSB CHI86FER01](https://openairdocs.org/ntsb/CHI86FER01.md): Cessna 172H · Williams, MN · Accident · Serious injuries · Final report · Mar 13, 1986 · N3706R · Substantial damage > The plt made a low pass over a frozen, snow covered lake, then intended to make a climbing left turn. He rprtd the wx & light conds as 'slight haze, poor horizon visibility, very white out.' As the plt contd with what he thought was a climbing turn, the acft… - [NTSB LAX86LA138](https://openairdocs.org/ntsb/LAX86LA138.md): Cessna 172M · Guinda, CA · Accident · No injuries · Limited investigation · Final report · Mar 9, 1986 · N6740H · Substantial damage > The plt & his roommate went flying in a rented acft. The plt maneuvered the acft through a valley, reversed course, descended over an assembly of persons & while buzzing them collided with trees. The plt was able to fly the substantially damaged acft back to… - [NTSB DEN86LA096](https://openairdocs.org/ntsb/DEN86LA096.md): Cessna R172K · Ft. Bridger, WY · Accident · No injuries · Limited investigation · Final report · Mar 9, 1986 · N736GS · Substantial damage > According to the plt, he and his passenger were ferrying an acft back to the point of origin after a sar mission for the civil air patrol, when they encountered IMC weather. The plt stated he was making a precautionary landing on a dirt road when the acft… - [NTSB MKC86FCA02](https://openairdocs.org/ntsb/MKC86FCA02.md): Cessna A152 · Old Monroe, MO · Accident · Serious injuries · Final report · Mar 8, 1986 · N8143L · Destroyed > The stu PIC and his instructor were practicing forced lndgs to a corn stubblefield. As they initiated a climb fm a simulated forced lndg, the acft crashed nose low, right wing low. No mech pblm was found with the flt controls or the pwrplant. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=199 ## 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=198 --- 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.