# 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 190 of 378 · 18,851 cases ## Cases, newest first - [NTSB ATL87LA167](https://openairdocs.org/ntsb/ATL87LA167.md): Cessna 172M · Sylva, NC · Accident · No injuries · Limited investigation · Final report · Jun 12, 1987 · N9355H · Substantial damage > The CFI instructed his low-time beginning student to make a normal appch to the rwy, and fly down the rwy at about 10 ft above the rwy surface while maintaining rwy hdg. The CFI stated that the purpose of the maneuver was '...to help the student improve his… - [NTSB MIA87LA177](https://openairdocs.org/ntsb/MIA87LA177.md): Grumman G-164 · Ruleville, MS · Accident · No injuries · Limited investigation · Final report · Jun 10, 1987 · N585Y · Substantial damage > While maneuvering the acft for a swath run after takeoff the plt stated that it was slow to climb. He then lowered the nose to increase airspeed, & realizing that the acft would not clear trees located ahead of the flt, elected to land in a field. Upon… - [NTSB ATL87DKG04](https://openairdocs.org/ntsb/ATL87DKG04.md): Bell TH-13T · Melvin, AL · Accident · No injuries · Final report · Jun 10, 1987 · N205PS · Substantial damage > The plt rprtd that after lndg to reload with herbicide, he got out of the helicopter to check the fuel in the tanks. After a visual inspn, he believed he had 'an adequate amount' of fuel to fly about 1/4 mi to the area to be sprayed, apply the chemical &… - [NTSB FTW87DRA03](https://openairdocs.org/ntsb/FTW87DRA03.md): Grumman G-164B · Egypt, TX · Accident · No injuries · Final report · Jun 8, 1987 · N6667Q · Substantial damage > Acft experienced a power loss drng an aerial app maneuver. During the ensuing emerg lndg, the left wing struck high weeds on the shoulder of a road, veered left into a ditch, and flipped over. Investigation revealed no. 7 cylinder had a pre-existing crack in… - [NTSB ATL87FA160](https://openairdocs.org/ntsb/ATL87FA160.md): Globe Globe GC-1A · Pleasant View, TN · Accident · 1 fatal · Field investigation · Final report · Jun 8, 1987 · N80532 · Destroyed > Upon returning from a short local area flight the aircraft was observed as it buzzed the owners private airstrip, where the passenger waved to his family. The plt pulled up sharply and made another low pass. This pullup was straight ahead. The climb peaked… - [NTSB MIA87LA173](https://openairdocs.org/ntsb/MIA87LA173.md): Grumman G-164A · Vaiden, MS · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1987 · N9734 · Destroyed > The plt stated that during the takeoff ground run the acft travelled over a small rise on the rwy & became airborne prematurely. The acft then collided with trees while the plt was trying to maneuver it to avoid a populated area. The acft then collided with… - [NTSB DEN87FA147](https://openairdocs.org/ntsb/DEN87FA147.md): Bell 206L-1 · Choteau, MT · Accident · 4 fatal · Field investigation · Final report · Jun 6, 1987 · N4999N · Destroyed > The EMS helicopter was returning to great falls, MT, on 6/5/87 when it crashed. Its occupants had earlier participated in a rescue seminar at many glacier, MT. The wreckage was not found until 6/9/87. A video tape recovered from the wreckage disclosed the… - [NTSB FTW87DRD05](https://openairdocs.org/ntsb/FTW87DRD05.md): Grumman G-164 · Kaplan, LA · Accident · No injuries · Final report · Jun 5, 1987 · N7804 · Substantial damage > The plt was dispensing fertilizer on a rice field when the acft collided with six strands of a power line at about 20' AGL. The airplane then crashed to the ground & was substantially damaged. The power line poles were located outside the field boundry.… - [NTSB LAX87FA225](https://openairdocs.org/ntsb/LAX87FA225.md): Douglas A-4A · California City, CA · Accident · 1 fatal · Field investigation · Final report · Jun 4, 1987 · N444AV · Destroyed > The airplane, a civilian Douglas A4A, was engaged in filming a commercial which required the plt to fly over a ferrari vehicle. The pilot had completed a low filming pass over the vehicle and was circling the area while the film crew was preparing for another… - [NTSB DEN87LA142](https://openairdocs.org/ntsb/DEN87LA142.md): Bell 206B II · Logan, UT · Accident · No injuries · Limited investigation · Final report · Jun 3, 1987 · N59624 · Substantial damage > The plt did not have authorizatoin from his employer to conduct the flight. The plt stated after the acc that he was on a LCL flt with the pax to view property. He cont to state that drng a rt turn the eng low rotor RPM warning sounded. The plt executed an… - [NTSB MKC87LA114](https://openairdocs.org/ntsb/MKC87LA114.md): Grumman G-164 · Knoble, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1987 · N730Y · Substantial damage > The PIC had taken off for a local aerial application operation. While maneuvering to make initial application the acft started to lose power and sink during a downwind turn. PIC dumped his load but acft continued to sink until one wing struck the terrain and… - [NTSB BFO87FIG04](https://openairdocs.org/ntsb/BFO87FIG04.md): Ayres S2R-T15 · Grantsville, MD · Accident · No injuries · Final report · May 31, 1987 · N40184 · Substantial damage > The acft was second in a flt of three spraying forest area with dimilin when it contacted a power line suspended between two hilltops. The prop severed the single strand of cable and shortly after the engine lost power. The plt maneuvered for an emgcy lndg,… - [NTSB ATL87DLQ02](https://openairdocs.org/ntsb/ATL87DLQ02.md): Hughes 369HS · Hawesville, KY · Accident · Minor injuries · Final report · May 28, 1987 · N9180F · Substantial damage > During a weed control spraying operation, the pilot experienced a power failure 45 feet above the ground. The autorotation attempt resulted in the helicopter impacting the ground on it's left side. The investigation disclosed that the flexible fuel line to… - [NTSB DEN87LA135](https://openairdocs.org/ntsb/DEN87LA135.md): Cessna 152 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · May 26, 1987 · N48590 · Substantial damage > The student plt & CFI were practicing slow flt & stalls. Carb heat was applied before the start of each stall series. During the recovery from the last stall the student plt applied only partial pwr. The CFI applied full pwr & the eng began to run rough. The… - [NTSB ANC87LA072](https://openairdocs.org/ntsb/ANC87LA072.md): Taylorcraft BC-12D · Soldotna, AK · Accident · Serious injuries · Limited investigation · Final report · May 25, 1987 · N96857 · Substantial damage > The 280 hour private pilot was observed doing steeply banked turns in excess of 90 degrees, inside loops and other aerobatic maneuvers, prior to entering a spin at an estimated altitude of 1500 to 2000 feet. The airplane completed approximately 8 turns prior… - [NTSB NYC87DHD05](https://openairdocs.org/ntsb/NYC87DHD05.md): Piper PA-36-400 · Mullica Hill, NJ · Accident · Minor injuries · Final report · May 23, 1987 · N2412X · Destroyed > The pilot of the PA-36 was spraying chemicals on trees for control of the gypsy moth. He reported that he was unable to clear power lines and dumped his load. The aircraft settled to the ground. The FAA reported that the weight of the aircraft exceeded the… - [NTSB ATL87LA146](https://openairdocs.org/ntsb/ATL87LA146.md): Consolidated Aeronautics Lake LA-4-200 · Sparta, NC · Accident · Minor injuries · Limited investigation · Final report · May 23, 1987 · N8543A · Substantial damage > The plt attempted a precautionary ldg at a private grass airstrip he had located, after being advised of wx at his intended destination by ATC. Just prior to touchdown, he observed a balloon at mid-field and excuted a go-around. During climbout, he lost sight… - [NTSB MKC87LA107](https://openairdocs.org/ntsb/MKC87LA107.md): Grumman G-164 · Newport, AR · Accident · Minor injuries · Limited investigation · Final report · May 22, 1987 · N492Y · Substantial damage > The pilot stated that he was spraying a rice field in formation with another airplane when his aircraft experienced an inflight upset due to the propwash, or wake turbulence, generated by the other aircraft. The landing gear struck a rice levee and was… - [NTSB FTW87DRG02](https://openairdocs.org/ntsb/FTW87DRG02.md): Air Tractor AT301 · Weslaco, TX · Accident · No injuries · Final report · May 22, 1987 · N5510S · Substantial damage > During an aerial application flt the eng lost pwr and the plt made a forced lndg. Post acc disassembly of the acft eng revealed the failure of an impeller bearing which resulted in the failure of the eng. - [NTSB MKC87DPG01](https://openairdocs.org/ntsb/MKC87DPG01.md): Cessna A188B · Lake Village, AR · Accident · 1 fatal · Final report · May 21, 1987 · N731YU · Destroyed > After completing several spary swaths, the pilot began another turn for another spray swath. A witness stated that during this right turn, the aircraft initiated a left descending turn and crashed into nearby trees and then burned. Examination found no… - [NTSB LAX87DVA09](https://openairdocs.org/ntsb/LAX87DVA09.md): Ayres S2R-T34 · Mendota, CA · Accident · No injuries · Final report · May 21, 1987 · N4012Y · Substantial damage > During an agricultural application flight, the aircraft struck a pole that was located 30 feet within the field boundary. The pilot stated that due to the dawn light and the way the pole blended in with the field along with a light amount of chemical on the… - [NTSB CHI87FA132](https://openairdocs.org/ntsb/CHI87FA132.md): Jauch Coot · Franklin Grove, IL · Accident · 1 fatal · Field investigation · Final report · May 21, 1987 · N81KX · Destroyed > The plt deptd mendota, IL on a local test flt under a 40 hour time in service restriction in an experimental home built airplane. A witness stated that the airplane was circling over his farm and then turned south. He said the eng stalled and the airplane… - [NTSB ATL87DEI03](https://openairdocs.org/ntsb/ATL87DEI03.md): Bell 47G-2A · Monroeville, OH · Accident · No injuries · Final report · May 20, 1987 · N818HJ · Substantial damage > The plt was on a normal spray run next to the edge of a field when he misjudged his clearance & the main rotor blades contacted a tree. The helicopter then crashed to the ground in a wheat field. - [NTSB MIA87FA160](https://openairdocs.org/ntsb/MIA87FA160.md): Schweizer G-164A · Dundee, MS · Accident · 1 fatal · Field investigation · Final report · May 19, 1987 · N4654 · Destroyed > While spraying a rice field, the acft was flying across svrl small dirt banks that had been furrowed for water ctl. Drg a swath run, it struck 3 furrowed banks that were close together, flipped over as it crashed, then burned. Witnessesrprtd the eng was… - [NTSB BFO87FA037](https://openairdocs.org/ntsb/BFO87FA037.md): Cessna 150M · Elkton, MD · Accident · 1 fatal · Field investigation · Final report · May 17, 1987 · N714FZ · Destroyed > The acft was flying at low altitude over an area of open fields when according to witnesses the acft abruptly pitched down and descended to the ground. Some witnesses stated they heard the engine operating throughout the descent while ohter witnesses reported… - [NTSB CHI87FA129](https://openairdocs.org/ntsb/CHI87FA129.md): Cessna A150K · Scotts, MI · Accident · 2 fatal · Field investigation · Final report · May 16, 1987 · N8331M · Destroyed > The airplane had been circling a residence at tree top level when a witness saw the nose drop and the acft descend steeply toward the terrain. The airplane struck a power line before ground impact. - [NTSB CHI87DER07](https://openairdocs.org/ntsb/CHI87DER07.md): Air Command Unknown · Dodge Center, MN · Accident · 1 fatal · Final report · May 16, 1987 · UNREG · Destroyed > Before flt the pilot had stated that his uncertified and unregisterd gyroplane had a 'lot of bugs to work out'. After t.o. and five min of airwork the acft entered a steep 90 degree banked turn and then began to tumble. Shortly after the main rotor separated.… - [NTSB ATL87LA138](https://openairdocs.org/ntsb/ATL87LA138.md): Cessna 172-N · Walhalla, SC · Accident · Minor injuries · Limited investigation · Final report · May 16, 1987 · N739QF · Destroyed > During a local sightseeing flight the plt trimmed the aircraft to a slow flight configuration, and circled a lake in the mountains of south carolina at an alt of approx 1,000 ft AGL. The aircraft was near max gross weight and the ground temp was 82 deg f. the… - [NTSB DEN87LA124](https://openairdocs.org/ntsb/DEN87LA124.md): Brantly Helicopter 305 · Golden, CO · Accident · No injuries · Limited investigation · Final report · May 14, 1987 · N5JM · Substantial damage > The commercial plt was performing hover tests in his experimental helicopter at his private helipad, located 60 feet from his residence. The plt reported winds as variable gusting to 40 knots. The plt's attention was diverted and a wind gust pushed the… - [NTSB CHI87DER06](https://openairdocs.org/ntsb/CHI87DER06.md): Bell 47G-2A · New Prague, MN · Accident · 1 fatal · Final report · May 14, 1987 · N6786D · Destroyed > After about a 5 min flight, the helicopter collided with the ground during a downwind turn on an agricultural turnaround. Impact was on a heading of 210 degrees. Wind was from 326 degrees at 14 KTS, gusts to 22 KTS. No evidence was found of powerplant, flight… - [NTSB SEA87LA092](https://openairdocs.org/ntsb/SEA87LA092.md): Aerospatiale SA315-D Lama · Siletz, OR · Accident · Minor injuries · Limited investigation · Final report · May 13, 1987 · N47256 · Destroyed > During external load operations the chockers became loose due to improper loading. The external load longline cable became entangled with the tailrotor causing a failure of the tail rotor system. The helicopter assumed a nose down attitude and spun to the… - [NTSB LAX87DUM04](https://openairdocs.org/ntsb/LAX87DUM04.md): Texas Helicopter M74L-WASP · Holtville, CA · Accident · Minor injuries · Final report · May 12, 1987 · N1001Z · Substantial damage > During an aerial application flight, the pilot reported that the electrical system failed. Shortly after, the aircraft collided with power lines. Inspection of the aircraft revealed that the generator was inoperative. There were no other reported mechanical… - [NTSB LAX87DUM03](https://openairdocs.org/ntsb/LAX87DUM03.md): Chance Vought F4U-7 · Chula Vista, CA · Accident · 2 fatal · Final report · May 10, 1987 · N33693 · Destroyed > The pilot of the F4U was giving the passenger a ride in appreciation of her volunteer work she contributed to an airshow conducted at brown field in san diego, California. Ground witnesses observed the F4U enter an inverted dive from an altitude of about 1500… - [NTSB DEN87FA121](https://openairdocs.org/ntsb/DEN87FA121.md): North American T-28D · Tatum, NM · Accident · 2 fatal · Field investigation · Final report · May 10, 1987 · N9611C · Destroyed > According to friends of the plt, the acft left roswell, new Mexico, with 2 people aboard after an airshow with a destination of lovington, NM. Witnesses observed the acft flying in the distance and then observed a big cloud of dust rising from the ground. The… - [NTSB ATL87FA136](https://openairdocs.org/ntsb/ATL87FA136.md): Piper J4A · Collierville, TN · Accident · 2 fatal · Field investigation · Final report · May 10, 1987 · N25020 · Destroyed > It was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site… - [NTSB SEA87LA091](https://openairdocs.org/ntsb/SEA87LA091.md): Bell 206-B · Sloan, NV · Accident · No injuries · Limited investigation · Final report · May 9, 1987 · N3187D · Destroyed > While climbing at a slow airspeed at a low altitude above the ground during strong gusting wind conditions, the pilot initiated a right turn and encountered an uncommanded right yaw. The aircraft completed several right spinning turns, impacted the ground,… - [NTSB MKC87FA103](https://openairdocs.org/ntsb/MKC87FA103.md): Champion 7EC · Delia, KS · Accident · 2 fatal · Field investigation · Final report · May 9, 1987 · N7556E · Destroyed > Witnesses stated that the aircraft was performing high speed, low level passes over the homes of some friends and relatives when, suddenly, it started a steep climb over a tree line. The aircraft appeared to slow down at the top of the climb; then it leveled… - [NTSB BFO87LA034](https://openairdocs.org/ntsb/BFO87LA034.md): Ayres Turbo Thrush 52R34 · Lavale, MD · Accident · Minor injuries · Limited investigation · Final report · May 8, 1987 · CGDFQ · Substantial damage > While spraying for gypsy moths during the early morning, the turbo-thrush collided with static wires located on top of high tension lines. The pilot stated that he did not see the wires because they were located on the shady side of an adjacent mountain. - [NTSB MKC87LA102](https://openairdocs.org/ntsb/MKC87LA102.md): Enstrom F-28A · Fayetteville, AR · Accident · No injuries · Limited investigation · Final report · May 7, 1987 · N13CM · Substantial damage > The PIC was demonstrating the helo to a prospective customer. The PIC was hovering in a remote area with rough and uneven terrain. The PIC rptd outside air temps of abt 90 degrees during the demo flt. The PIC stated that he was moving around over the grnd in… - [NTSB MKC87DCQ02](https://openairdocs.org/ntsb/MKC87DCQ02.md): Cessna 188 · Harper, KS · Accident · Serious injuries · Final report · May 7, 1987 · N5609J · Destroyed > The pilot was preparing to spray a wheatfield. During the second 1/3 of procedural turnaround, the aircraft struck powerlines, then the ground. The aircraft was destroyed by post-impact fire. - [NTSB LAX87DVG06](https://openairdocs.org/ntsb/LAX87DVG06.md): Ayres S-2R · Williams, CA · Accident · Minor injuries · Final report · May 6, 1987 · N4216X · Substantial damage > The plt reported he heard something break. The sound was followed by a vibration. The plt then turned to land on a road. He was unable to maintain alt and airspeed. The rockwell S2R landed in a cultivated field and nosed over after a collision with a dirt… - [NTSB DEN87LA119](https://openairdocs.org/ntsb/DEN87LA119.md): Cessna A188B · St. Ignatius, MT · Accident · No injuries · Limited investigation · Final report · May 6, 1987 · N9282R · Substantial damage > An ag plt was spraying a field near the local arpt, at 100 feet AGL. During an aerial application maneuver, the engine made a loud bang and stopped. The plt leveled the acft, selected a landing site and landed. During the roll out, the acft crossed an… - [NTSB ANC87LA066](https://openairdocs.org/ntsb/ANC87LA066.md): Cessna 170B · Kenai, AK · Accident · Serious injuries · Limited investigation · Final report · May 6, 1987 · N2754D · Substantial damage > The pilot stated during a low level flight above the trees, the aircraft started to vibrate. A few seconds later the propeller completely separated from the aircraft. The propeller was not located in the wooded area. The propeller separated from the aircraft… - [NTSB MIA87LA155](https://openairdocs.org/ntsb/MIA87LA155.md): Bell 47G-3B1 · Panama City Bch, FL · Accident · No injuries · Limited investigation · Final report · May 3, 1987 · N43CD · Substantial damage > The plt reported that shortly after takeoff the eng began to lose power, then failed. He then autorotated & set the helicopter down aprx 6 feet offshore. Examination of the eng logbooks by FAA personnel revealed that AD 62-23-02 which requires insp of the oil… - [NTSB MKC87LA095](https://openairdocs.org/ntsb/MKC87LA095.md): Grumman G-164B · Brinkley, AR · Accident · No injuries · Limited investigation · Final report · Apr 30, 1987 · N2000A · Destroyed > The acft had 100 gallons of water onboard for the ag training flt. The plt has completed one spray pass and was half way through the turnaround when the acft stalled. It collided with the ground and flipped forward to the inverted position. The plt listed 80… - [NTSB LAX87LA199](https://openairdocs.org/ntsb/LAX87LA199.md): Hughes 369D · Tamunings · Accident · 2 fatal · Limited investigation · Final report · Apr 29, 1987 · N10995 · Destroyed > A Hughes 369D, operated off of a fishing vessel, went out of control and crashed in the pacific ocean, nr guam. The accident was witnessed by the ship's captain. His statement indicated one of the main rotor blades separated in flt while the helo was orbiting… - [NTSB MIA87FA150](https://openairdocs.org/ntsb/MIA87FA150.md): Piper PA-11 · Hollandale, MS · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1987 · N5093H · Destroyed > Witnesses stated that the acft circled a pond & dived once, then on a 2nd circling attempt, it made a short steep turn & went into a twisting dive into the pond. The passenger stated that they were flying at appx 100 to 150 ft above some fish ponds when the… - [NTSB LAX87DVG04](https://openairdocs.org/ntsb/LAX87DVG04.md): Schweizer G-164B · Pleasant Grove, CA · Accident · No injuries · Final report · Apr 28, 1987 · N3633B · Substantial damage > During an aerial application flight, the pilot reported that during a turn for the next pass over the field, the engine quit. The aircraft was turned into the wind and was landed on a rough plowed field. During the landing roll the aircraft nosed over. The… - [NTSB DEN87LA112](https://openairdocs.org/ntsb/DEN87LA112.md): Piper PA-25-260 · Harvey, ND · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1987 · N9736P · Substantial damage > An ag plt was working a field on an aerial application flt. At the end of a spray pass, the acft struck a shelterbelt and went out of control. The acft climbed to 300 ft and rolled inverted. The acft impacted the ground in a nose low, wing down attitude. The… - [NTSB MKC87FA092](https://openairdocs.org/ntsb/MKC87FA092.md): Piper PA-28-181 · Valley, NE · Accident · 2 fatal · Field investigation · Final report · Apr 26, 1987 · N1145Q · Destroyed > At aprx 2020 CDT, witnesses saw the acft as the plt made svrl low passes over the platte river near Valley, NE. On the last pass, the acft struck power lines, then crashed in the river. The wreckage came to rest in the main channel of the river in aprx 25 ft… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=191 ## 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=190 --- 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.