# 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 202 of 378 · 18,851 cases ## Cases, newest first - [NTSB ANC85FA163](https://openairdocs.org/ntsb/ANC85FA163.md): Cessna 180H · Mt. Palmer, AK · Accident · 6 fatal · Field investigation · Final report · Aug 25, 1985 · N417GP · 2 aircraft · Destroyed > Aircraft collided with Cessna 180 and crashed on mountain side about one-quarter mile apart. Piper was sightseeing and Cessna was spotting sheep. Scattered clouds were reported about 300 feet above the points of ground impact. - [NTSB FTW85LA332](https://openairdocs.org/ntsb/FTW85LA332.md): Piper Aerostar 601P · San Angelo, TX · Accident · No injuries · Limited investigation · Final report · Aug 24, 1985 · N8045J · Destroyed > The plt had recently purchased the acft and received 25 hrs dual instruction to comply with his insurance requirements. Shortly thereafter he went out solo to practice steep turns. He climbed to 12,500 ft and leveled off. He then rolled into a 60 deg left… - [NTSB DEN85LTK02](https://openairdocs.org/ntsb/DEN85LTK02.md): Piper PA-25-235 · Yankton, SD · Accident · Minor injuries · Final report · Aug 24, 1985 · N9748P · Destroyed > The acft descended uncontrolled into the terrain after it contacted a power line during an aerial application flt. Witnesses reported the acft appeared to pull up at the west end of the 40 acre fld, however, it did not clear the lines and it nosed over into… - [NTSB BFO85FID04](https://openairdocs.org/ntsb/BFO85FID04.md): Cessna A188B · Farmville, VA · Accident · Minor injuries · Final report · Aug 24, 1985 · N4830Q · Destroyed > The pilot stated that while making his third swath run over a field, the engine started to run rough. He stopped spraying and attempted to gain altitude, but the roughness increased. Shortly thereafter, the manifold pressure dropped and he was unable to keep… - [NTSB ATL85LA258](https://openairdocs.org/ntsb/ATL85LA258.md): Beech C23 · Clarksburg, WV · Accident · No injuries · Limited investigation · Final report · Aug 24, 1985 · N6975R · Destroyed > The pilot ran into less than VFR weather and turned around and attempted to make an airport. He became boxed in by weather all around and attempted to land on the highway. He did not make a pss over his intended landing area. When he was on short final, a car… - [NTSB LAX85LA365](https://openairdocs.org/ntsb/LAX85LA365.md): Cessna 150 · Newport Beach, CA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1985 · N5422Q · Destroyed > The acft was circling to photograph a sailboat race. The plt rptd that when he attempted to rollout of the turn the acft flt controls did not respond. In order to prevent a stall the plt applied full power and pushed the nose downwards. The acft collided with… - [NTSB FTW85LA330](https://openairdocs.org/ntsb/FTW85LA330.md): Air Tractor AT-400 · Oak Ridge, LA · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1985 · N3656N · Substantial damage > The plt stated the acft 'sagged' (settled) during an aerial application maneuver and he leveled the wings to let it recover. However, he did not add power, flaps, or dump the load of almost 300 gallons of spray material he was carrying since he thought it… - [NTSB CHI85LA358](https://openairdocs.org/ntsb/CHI85LA358.md): Piper PA-36-285 · Fergus Falls, MN · Accident · No injuries · Limited investigation · Final report · Aug 23, 1985 · N40920 · Substantial damage > When the plt entered a steep right turn at the end of a swath run the acft began to loose alt so the plt added full pwr and leveled the wings. When the acft was close to the ground and slow the plt noticed a row of trees along the flt path. During a pull up… - [NTSB MKC85LA193](https://openairdocs.org/ntsb/MKC85LA193.md): Cessna A188B · Meade, KS · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 1985 · N731SM · Substantial damage > The plt reported that when he attempted to climb at the end of a swath run the acft began to mush. The acft was over tall corn and despite the use of full power it would not climb. The acft flew about one mile in the semi-stalled condition and then began to… - [NTSB LAX85LA361](https://openairdocs.org/ntsb/LAX85LA361.md): Grumman G-164A · Buckeye, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 1985 · N5297 · Substantial damage > The plt had just completed a spray run and was executing a procedure turn when the engine's no. 8 cylinder connecting rod failed. Engine oil covered the windshield. The plt attempted to land on the departure airstrip but he could not align the acft with the… - [NTSB ANC85LA159](https://openairdocs.org/ntsb/ANC85LA159.md): Piper PA-18 · Gulkana, AK · Accident · 1 fatal · Limited investigation · Final report · Aug 22, 1985 · N625SW · Destroyed > The acft crashed shortly after the plt had departed an airstrip to proceed on a hunting trip. Impact occurred in a wooded area about 1 mi from the strip. According to witnesses, the plt had made 2 low approaches over the trees before the acdnt. The acft was… - [NTSB MIA85FA235](https://openairdocs.org/ntsb/MIA85FA235.md): Cessna 172M · St. Thomas · Accident · 4 fatal · Field investigation · Final report · Aug 19, 1985 · N22198 · Destroyed > Witnesses stated the acft was flying slow at aprx 200 ft alt photographing a group of sail boats. As the plt entered a left turn to reverse course, it stalled and nosed down striking the water in a near vertical attitude. At the time of the accident the acft… - [NTSB DEN85FA225](https://openairdocs.org/ntsb/DEN85FA225.md): Cessna 182J · Torrington, WY · Accident · Serious injuries · Field investigation · Final report · Aug 19, 1985 · N3336F · Substantial damage > The plt had a limitation on her certificate that prohibited flight at night. The flt was conducted at night and while enroute the plt diverted to the Torrington arpt. The rwy is equipped with plt activated lgts. A witness stated that the acft circled several… - [NTSB CHI85FA356](https://openairdocs.org/ntsb/CHI85FA356.md): Cessna 172 · Rose Township, MI · Accident · 1 fatal · Field investigation · Final report · Aug 19, 1985 · N5146A · Destroyed > Just prior to the accident, several witnesses observed the acft flying at a very low alt in the vicinity of the crash site. The crash site was located across the road from the home of the plt's brother. According to witnesses, the acfts eng was operating… - [NTSB MKC85FA191](https://openairdocs.org/ntsb/MKC85FA191.md): Piper PA-18-135 · New Madrid, MO · Accident · 2 fatal · Field investigation · Final report · Aug 18, 1985 · N267CD · Destroyed > A witness said N267CD made a low pass down the farm airstrip and as the acft neared the end of the strip, it began a climb, banked to the left and descended to the ground. The acft impacted in a nose low, left wing low attitude. - [NTSB ANC85FA154](https://openairdocs.org/ntsb/ANC85FA154.md): de Havilland DHC-2 MK.1 · Tutna Lake, AK · Accident · 4 fatal · Field investigation · Final report · Aug 18, 1985 · N68085 · Destroyed > The acft crashed on the side of a mountain at an elev of 2200 ft aprx 3 miles from its intended destination, a remote lake. Purpose of the flt was to discharge caribou hunters into an area where caribou were spotted early that day. The acft was destroyed by… - [NTSB NYC85FA213](https://openairdocs.org/ntsb/NYC85FA213.md): Cessna C-305A · Brooklyn, NY · Accident · 1 fatal · Field investigation · Final report · Aug 17, 1985 · N5250G · Destroyed > During an aerial banner tow operation at low level along the beach, witnesses observed the airplane bank sharply to the right and dive into the water. Witnesses recall the engine noise to have been loud yet sputtering before the impact. Inspection of the… - [NTSB MKC85LA188](https://openairdocs.org/ntsb/MKC85LA188.md): Cessna 172RG · Lee'S Summit, MO · Accident · No injuries · Limited investigation · Final report · Aug 17, 1985 · N4772R · Substantial damage > The plt reported that the eng start & run-up were normal before he took off on a night currency & proficiency flt. After 2 normal takeoffs & full stops, he made a 3rd takeoff. He climbed to 1000 ft AGL on a x-wind leg, reduced power to 20' manifold pressure &… - [NTSB MIA85LKG04](https://openairdocs.org/ntsb/MIA85LKG04.md): Cessna A188B · Bainbridge, GA · Accident · No injuries · Final report · Aug 17, 1985 · N731RD · Substantial damage > The acft stalled during aerial application operations and collided with the ground. The plt said the wind was gusting to 30 KTS and during a steep downwind turn the loaded acft stalled at 100 ft AGL. The plt recommended less steep turns and not operating in… - [NTSB CHI85FEK02](https://openairdocs.org/ntsb/CHI85FEK02.md): Unknown Quickie · Wren, OH · Accident · Serious injuries · Final report · Aug 17, 1985 · N4253F · Destroyed > On August 17,1985 at about 1442 EDT, a Q2 quickie (homebuilt) N4253F, registered to gary a. moser and flown by keith w. moser crashed while performing maneuvers 1/2 mile southeast of Wren, Ohio, while on a personal flight. VFR meteorological conditions… - [NTSB ATL85LA250](https://openairdocs.org/ntsb/ATL85LA250.md): Cessna A-188B · Winterville, MS · Accident · No injuries · Limited investigation · Final report · Aug 17, 1985 · N4762Q · Substantial damage > During pull-up from a swath, the acft stalled & descenced into trees. The plt related that he pulled up into a tight turn causing the acft to stall. - [NTSB MIA85LKG05](https://openairdocs.org/ntsb/MIA85LKG05.md): Cessna L-188 · Camilla, GA · Accident · No injuries · Final report · Aug 16, 1985 · N53172 · Substantial damage > The plt stated that during a swath run at an alt of aprx 5 ft AGL, a sudden loss of pwr occurred. The acft was damaged when it settled and contacted the terrain. Post accident inspection and a test run of the eng failed to reveal any mechanical… - [NTSB LAX85LA349](https://openairdocs.org/ntsb/LAX85LA349.md): Cessna 172K · Santa Paula, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 1985 · N79504 · Substantial damage > On a local flt to view camping and hiking facilities in mountainous terrain, the acft entered a box canyon with a moderately rising floor and steep sides reported by the sheriff's department at about one-quarter of a mile wide. Duringan attempted course… - [NTSB LAX85LA348](https://openairdocs.org/ntsb/LAX85LA348.md): Cessna A188B · Willcox, AZ · Accident · No injuries · Limited investigation · Final report · Aug 15, 1985 · N4974Q · Substantial damage > On August 15, 1985, a Cessna 180 lost eng pwr due to fuel exhaustion and collided with the ground during an aerial applicaion maneuver. The acft sustained substantial damage but the pilot was not injured. The plt stated that he should have checked the fuel… - [NTSB FTW85LA323](https://openairdocs.org/ntsb/FTW85LA323.md): Cessna T188C · Floydada, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 1985 · N9964J · Destroyed > The plt stated he failed to see a metal stand pipe in the cotton field. The acft collided with the stand pipe and flipped inverted. Residue of the spraying chemical was observed on the windscreen after the accident. This residue restricted forward visibility… - [NTSB ATL85LA248](https://openairdocs.org/ntsb/ATL85LA248.md): Grumman G-164B · Irwinville, GA · Accident · No injuries · Limited investigation · Final report · Aug 15, 1985 · N48515 · Substantial damage > The acft reportedly suffered a loss of power during aerial application. A forced landing was attempted in a field and collided with a tree. The cause of the loss of power was undetermined - [NTSB MKC85LA183](https://openairdocs.org/ntsb/MKC85LA183.md): Cessna A188B · Menlo, KS · Accident · No injuries · Limited investigation · Final report · Aug 13, 1985 · N4936Q · Substantial damage > Plt reports that the eng gradually lost power during a swath turn around. A landing on a nearby road appeared possible but the eng quit and the acft crashed in a corn field. Post accident examination by an FAA inspector failed to reveal any evidence to… - [NTSB LAX85LA345](https://openairdocs.org/ntsb/LAX85LA345.md): Aerospatiale SF3130 · Buckeye, AZ · Accident · No injuries · Limited investigation · Final report · Aug 12, 1985 · N537 · Substantial damage > During a hover in a confined area the plt misinterpeted his passg signal to move to a diferent location as a signal that the tail rotor was in danger. The plt used abrupt control movements that resulted in the toe of a skid hooking into a wire fence. The… - [NTSB FTW85MA317](https://openairdocs.org/ntsb/FTW85MA317.md): Beech 200 · Quinlan, TX · Accident · 3 fatal · Major investigation · Final report · Aug 12, 1985 · N100HC · 2 aircraft · Destroyed > N100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed… - [NTSB ATL85LA246](https://openairdocs.org/ntsb/ATL85LA246.md): Piper PA-25-235 · Goodway, AL · Accident · No injuries · Limited investigation · Final report · Aug 12, 1985 · N9647P · Destroyed > During aerial application the acft lost total pwr and the plt made an emergency landing in a fld. The plt stated that shortly after the eng lost pwr, he noticed smoke coming from the eng nacelle. After landing in the fld, the acft began to burn and was… - [NTSB ATL85LA245](https://openairdocs.org/ntsb/ATL85LA245.md): Cessna T188C · Athens, AL · Accident · No injuries · Limited investigation · Final report · Aug 12, 1985 · N2825J · Destroyed > The acft experienced a gradual loss of pwr followed by an in-flt fire which lead to an off arpt forced landing. During the forced landing ihe acft collided with trees and was destroyed by fire. - [NTSB ANC85LA151](https://openairdocs.org/ntsb/ANC85LA151.md): Cessna C-207 · Mountain Villag, AK · Accident · No injuries · Limited investigation · Final report · Aug 12, 1985 · N9480M · Substantial damage > The pilot-in-command was aware of the weather he was operating in and intended to fly through a locally well known pass. He misidentified the pass and found himself in a narrow valley. There was insufficient width to effect a 180 degree turn and the rising… - [NTSB FTW85LA312](https://openairdocs.org/ntsb/FTW85LA312.md): Piper PA-25-235 · Morton, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 11, 1985 · N6529Z · Destroyed > After completing several passes, the acft was crossing a road under power lines when the propeller struck a road sign. The acft subsequently became uncontrollable and impacted in an adjacent field, flipped over and slid to a stop. The pilot stated that he was… - [NTSB MKC85FA181](https://openairdocs.org/ntsb/MKC85FA181.md): Piper PA-18-150 · Moscow, AR · Accident · 2 fatal · Field investigation · Final report · Aug 10, 1985 · N9060P · Destroyed > Witnesses saw three acft in a loose trail formation at low alt near the plt's pvt farm strip. The last acft in the trail position (N9060P) broke off to the left and made a steep pull up. After a short climb, the nose of the acft dropped and the acft dove to… - [NTSB MKC85FA179](https://openairdocs.org/ntsb/MKC85FA179.md): Piper PA-25-235 · Palisade, NE · Accident · Serious injuries · Field investigation · Final report · Aug 10, 1985 · N8941L · Destroyed > While on a swath run over a cornfield, the plt attempted to maneuver under power lines that were spanning a large ditch. The right wing struck one of the three lower cables which cut into the wing structure. The cable finally separated releasing the acft. The… - [NTSB MIA85LA228](https://openairdocs.org/ntsb/MIA85LA228.md): Hughes 269C · St.Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Aug 10, 1985 · N300JS · Substantial damage > The pilot of the helicopter was executing a quick stop in a downwind condition. As he increased collective pitch control, the rotor RPM bled down. The pilot stated that he increased collective pitch to increase RPM and the aircraft crashed. - [NTSB MIA85FA227](https://openairdocs.org/ntsb/MIA85FA227.md): Cessna 172RG · Cedar Key, FL · Accident · 2 fatal · Field investigation · Final report · Aug 10, 1985 · N6419R · Destroyed > The manager of the destination arpt said the plt had called earlier in the evening & had asked to be picked up at the arpt. The plt said that he would fly over the manager's house after he arrived. The manager heard the acft fly over from east to west.… - [NTSB FTW85FA310](https://openairdocs.org/ntsb/FTW85FA310.md): Bell UH-1B · Saint James, LA · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1985 · N1385W · Destroyed > Acft was at a 150' hover preparing to pick up a log when it experienced a power loss. Witnesses stated that they heard a loud 'bang' and the pilot radioed 'get out of the way'. Acft autorotated thru 60' to 80' trees with very low rotor RPM and impacted with… - [NTSB DEN85LTE06](https://openairdocs.org/ntsb/DEN85LTE06.md): Cessna 180 · Mule Creek Jct, WY · Accident · No injuries · Final report · Aug 8, 1985 · N5163E · Destroyed > The plt was spotting cattle during a cattle herding operation. He saw 2 cows with calves in a cove of a canyon that personnel on the ground were leaving behind. The plt stated that he made a sharp turn & flew over the cows to show their location to riders on… - [NTSB FTW85LA309](https://openairdocs.org/ntsb/FTW85LA309.md): Grumman G-164A · Tallulah, LA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1985 · N962X · Substantial damage > During an aerial application operation, the eng lost power & the plt made an emergency landing in a soy bean field. While on the landing roll, the acft nosed over. The operator reported that he did not see or smell any fuel around the acft; he believed that… - [NTSB CHI85LA338](https://openairdocs.org/ntsb/CHI85LA338.md): Bell 47G-5 · Pickett, WI · Accident · No injuries · Limited investigation · Final report · Aug 7, 1985 · N1476W · Substantial damage > The fld where this accident occurred had been sprayed one week prior to the accident by a fixed-wing acft at an alt of 20 ft. no wires were noted to be a hazard at that time. On the day of the accident the plt of the helicopter was talking to a spotter on the… - [NTSB ANC85LA150](https://openairdocs.org/ntsb/ANC85LA150.md): Taylorcraft BC12D · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Aug 7, 1985 · N29705 · Substantial damage > The instructor initiated a simulated engine failure at 250 foot above the ground with no forced landing area in sight except of the lake behind them from which they had just departed. The student attempted a 180 degree turn back to the lake and the instructor… - [NTSB NYC85FGT02](https://openairdocs.org/ntsb/NYC85FGT02.md): Jones Marquart MA-5 · New Oxford, PA · Accident · 2 fatal · Final report · Aug 6, 1985 · N168FJ · Destroyed > Before flying a short distance to thomasville to refuel, the plt added 3 to 4 gal of auto fuel to the acft. At thomasville, the acft was serviced with 20.1 gal of aviation fuel. While taxiing to takeoff, the eng stopped & was restarted twice. After departing… - [NTSB MKC85FA177](https://openairdocs.org/ntsb/MKC85FA177.md): Cessna A188B · Dodge City, KS · Accident · Serious injuries · Field investigation · Final report · Aug 5, 1985 · N9257G · Destroyed > The plt was was making east & west runs over a milo field as he was dispensing parathion. He reported that he had been working under high voltage power lines each time he flew past the west edge of the field. He stated that on the last pass, the acft… - [NTSB ATL85LA236](https://openairdocs.org/ntsb/ATL85LA236.md): Cessna A188B · Trenton, AL · Accident · No injuries · Limited investigation · Final report · Aug 5, 1985 · N21708 · Destroyed > The pilot stated that the eng lost power while he was maneuvering for another spray run over the field. The aircraft settled into the trees and a post-crash fire developed. - [NTSB ATL85FA237](https://openairdocs.org/ntsb/ATL85FA237.md): Cessna 172A · Glencoe, KY · Accident · 1 fatal · Field investigation · Final report · Aug 5, 1985 · N7279T · Substantial damage > The acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two… - [NTSB SEA85LYA01](https://openairdocs.org/ntsb/SEA85LYA01.md): Rockwell S2R · Caldwell, ID · Accident · No injuries · Final report · Aug 4, 1985 · N5511X · Substantial damage > An aero commander S2R had been modified by the installation of an air research TPE-331-43A power plant. During an aerial application flight the pilot heard a loud bang and experienced a loss of power. Investigation revealed the first stage turbine whee, part… - [NTSB LAX85LA338](https://openairdocs.org/ntsb/LAX85LA338.md): Aeronca 7AC · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1985 · N85168 · Substantial damage > On aug 4, 1985 an Aeronca 7AC collided with the ground while buzzing over a sand bar near Santa Paula, CA. VMC existed at the time. The ac sustained substantial damage and the pvt plt received minor injuries. He reported no mechanical problems with the ac… - [NTSB ATL85LA233](https://openairdocs.org/ntsb/ATL85LA233.md): Schweizer G-164B · Leesburg, GA · Accident · No injuries · Limited investigation · Final report · Aug 4, 1985 · N48562 · Substantial damage > The aircraft suffered a loss of power due to water in fuel and made an emergency landing in a field. During landing roll the aircraft collided with trees at the end of the field. - [NTSB ANC85LA158](https://openairdocs.org/ntsb/ANC85LA158.md): Cessna C-172M · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Aug 4, 1985 · N20338 · Substantial damage > The pilot-in-command was on a personal flight with the purpose of observing a hunting camp from the air. While maneuvering in the canyon, the pilot stated he encountered a downdraft. He applied full power and lowered the flaps 20 degrees. The airplane… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=203 ## 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=202 --- 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.