# 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 188 of 378 · 18,851 cases ## Cases, newest first - [NTSB DEN87FA216](https://openairdocs.org/ntsb/DEN87FA216.md): Great Lakes 2T-1A · Bozeman, MT · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1987 · N313Y · Destroyed > 74-Year-OLD plt was performing aerobatics at small arpt for local tv news station to promote weekend airshow. Plt made right & left pass, each pass consisting of shallow descent, pullup from aprx 150 to 200 ft AGL, & slow roll. Plt began third pass from… - [NTSB LAX87DUJ09](https://openairdocs.org/ntsb/LAX87DUJ09.md): Piper PA-25-235 · San Simon, AZ · Accident · No injuries · Final report · Aug 12, 1987 · N7328Z · Substantial damage > During a pull up from an aerial application swath run, the aircraft struck a power line. The accident occurred during daylight in visual meteorological conditions. - [NTSB FTW87DRD14](https://openairdocs.org/ntsb/FTW87DRD14.md): Grumman G-164B · Oak Grove, LA · Accident · No injuries · Final report · Aug 12, 1987 · N48614 · Substantial damage > After completing the last pass of an agricultural operation the pilot pulled up and started a turn. At this time the engine started shaking and losing power. The pilot attempted a forced landing in a soft field. The wheels bogged four or five inches into the… - [NTSB ATL87LA229](https://openairdocs.org/ntsb/ATL87LA229.md): Bell 47G (TOM CAT) · Dothan, AL · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1987 · N10175 · Substantial damage > The plt rprtd that while he was making a turn-around over trees after the 1st swath run, the helicopter enctrd a sudden wind change. He stated that the wind cond was from a cumulus buildup which put him in a tailwind situation. As he completed his turn with… - [NTSB LAX87FA300](https://openairdocs.org/ntsb/LAX87FA300.md): Globe GC-1B · Springville, CA · Accident · 1 fatal · Field investigation · Final report · Aug 9, 1987 · N80806 · Destroyed > The pilot was flying over sharply rising terrain in a canyon in a mountainous area. There was insufficient room in the canyon to manuever the aircraft. The pilot reported that he had maintained an airspeed just above a stall while attempting to fly through… - [NTSB MKC87FA159](https://openairdocs.org/ntsb/MKC87FA159.md): Piper PA-28-151 · Maquoketa, IA · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1987 · N32619 · Destroyed > After departing the Maquoketa muni arpt, the acft was observed to fly at low altitude over some buildings that included a house & trailer home. As the acft flew over the property in a left banking turn, the left wing struck the top of a tree & then the acft… - [NTSB ATL87DEK02](https://openairdocs.org/ntsb/ATL87DEK02.md): Allen Pitts Special S-1 · Lancaster, OH · Accident · 1 fatal · Final report · Aug 8, 1987 · N52LA · Destroyed > N52LA was being flown in a 2-acft acrobatic demonstration (demo). After takeoff, the plts bgn the demo by passing each other in a low alt knife edge maneuver over the rwy. After passing, they rolled inverted, until near the ends of the rwy, then rolled… - [NTSB ANC87FA117](https://openairdocs.org/ntsb/ANC87FA117.md): Cessna 207 · Crooked Creek, AK · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1987 · N7371U · Destroyed > The acft overflew the destination due to fog. The station manager stated that after transmitting to the plt that the wx was 'zero zero', the plt stated that he would continue on to red devil and she heard it fly overhead. The first pieces of acft debris were… - [NTSB LAX87LA295](https://openairdocs.org/ntsb/LAX87LA295.md): North American T-6G · Butte City, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 1987 · N8335H · Destroyed > During a local flight, a witness observed the acft making shallow right turns at aprx 100 ft AGL. The acft suddenly nosed down and collided with the terrain. Neither the plt nor the passenger remember what happened. Inspection of the engine revealed… - [NTSB ANC87FA115](https://openairdocs.org/ntsb/ANC87FA115.md): Piper PA-18A · Coldfoot, AK · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1987 · N7479D · Destroyed > The pilot had unsuccessfully attempted to fly through atigun pass earlier in the day. Even though the pass was closed due to fog and cloud cover, the pilot attempted to fly through the pass a second time. The aircraft wreckage was locatedin atigun pass. The… - [NTSB LAX87DVD04](https://openairdocs.org/ntsb/LAX87DVD04.md): Hiller UH-23-D · Brentwood, CA · Accident · No injuries · Final report · Aug 5, 1987 · N61PC · Substantial damage > During an aerial application flight, the tail boom weight separated and contacted the tail rotor. The pilot lost control of the aircraft and collided with a tree and subsequently the terrain. Post acc invest revealed that the 'pip pins' which secure the tail… - [NTSB ANC87LA114](https://openairdocs.org/ntsb/ANC87LA114.md): Champion 7ECA · Central, AK · Accident · 1 fatal · Limited investigation · Final report · Aug 5, 1987 · N2644G · Substantial damage > During an interview in the hospital with the passenger who was the pilot's son, he stated to the FAA inspector that his dad was low level flying when the aircraft struck a tree. The pilot lost control of the aircraft and crashed. At the time of the accident… - [NTSB DEN87DTG01](https://openairdocs.org/ntsb/DEN87DTG01.md): Cessna 188 · Valley City, ND · Accident · No injuries · Final report · Aug 4, 1987 · N3530Q · Substantial damage > The plt rprtd the eng lost pwr drg a swath run & the acft was dmgd drg a forced lndg in a field of mature sunflowers. An exam of the acft revealed that both fuel tanks & the gascolater contained fuel. Subsequently, the eng was started at the acdnt site & it… - [NTSB DEN87DTE03](https://openairdocs.org/ntsb/DEN87DTE03.md): Grumman-Schweizer G-164A · Springfield, CO · Accident · No injuries · Final report · Aug 4, 1987 · N8953H · Substantial damage > The plt rprtd the eng lost pwr drg an aerial application flt & the acft nosed over drg a forced lndg in a soft, wet, terraced fld. There had been hvy rain on the previous day. An investigation revealed the acft had been refueled from a fuel tank mounted on a… - [NTSB MKC87LA155](https://openairdocs.org/ntsb/MKC87LA155.md): Piper PA-36-300 · Swea City, IA · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 1987 · N2338Y · Substantial damage > The acft was engaged in ag spray operations near Swea City, Iowa. The PIC stated that he was making a procedure turn after a swath run. The PIC further stated that the acft stalled in the turn and the acft descended into the fld he had been spraying. The PIC… - [NTSB SEA87FA152](https://openairdocs.org/ntsb/SEA87FA152.md): Cessna 172 · Pahrump, NV · Accident · 4 fatal · Field investigation · Final report · Aug 2, 1987 · N8696B · Destroyed > The pilot entered a box canyon and attempted to either outclimb the terrain or reverse course. The aircraft's airspeed was allowed to decrease below vs and the aircraft stalled. A density altitude of approximately 9500 feet existed at the time. Insufficient… - [NTSB NYC87LA216](https://openairdocs.org/ntsb/NYC87LA216.md): Piper PA-18S · Brewster, MA · Accident · No injuries · Limited investigation · Final report · Aug 1, 1987 · N9075H · Substantial damage > The instructor (CFI) said that shortly after takeoff, the student was given a simulated power failure. At aprx 75' AGL, the student initiated a steep turn to head into the wind, which terminated in nearly a 90 deg heading change. The CFI stated the wind was… - [NTSB MIA87FA220](https://openairdocs.org/ntsb/MIA87FA220.md): Buccaneer XA-430 · Lk Buena Vista, FL · Accident · 1 fatal · Field investigation · Final report · Aug 1, 1987 · N910DW · Destroyed > The accident occurred while the acft was flying at an EST 800 to 1000 ft. persons on the grnd heard a bang, then looked up and saw the acft in a spin to the rt with the rt wing folded back over the fuselage. The acft hit the grnd in a near vertical attitude.… - [NTSB LAX87FA286](https://openairdocs.org/ntsb/LAX87FA286.md): Luscombe 8A · Oakdale, CA · Accident · 2 fatal · Field investigation · Final report · Aug 1, 1987 · N2098B · Destroyed > The plt & his plt-rated wife (flying in their Luscombe) & another couple (in a rented Mooney) had dinner & drank wine. By about 0015 the couples had taken off in their respective acft for a return flt home and they had each other in sight. The couple in the… - [NTSB FTW87FA184](https://openairdocs.org/ntsb/FTW87FA184.md): Piper PA-23-250 · Imperial, TX · Accident · 1 fatal · Field investigation · Final report · Aug 1, 1987 · N5998Y · Destroyed > After takeoff, the plt elected to fly low over a reservoir. He stated that as he began a pass, not FAR from the water's edge, the acft enctrd a sink. He said he '... Checked power, all ok, plane just seemed to lose all lift...' Subsequently, the acft… - [NTSB SEA87LA151](https://openairdocs.org/ntsb/SEA87LA151.md): Rockwell S-2R · Plymouth, WA · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N4229X · Substantial damage > Drg a swath run, a total loss of power occurred when the eng's #9 cylinder failed. The plt made a forced lndg in a soft potato field, but the acft nosed over after it slowed to about 20 KTS. - [NTSB MKC87LA153](https://openairdocs.org/ntsb/MKC87LA153.md): Grumman G-164A · Widener, AR · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N6568 · Substantial damage > The ag airplane was making the final swath run over a cottonfield when the engine lost power. After touchdown in a ricefield, the airplane flipped forward to the inverted position. The reason for the power loss could not be determined. - [NTSB MKC87LA151](https://openairdocs.org/ntsb/MKC87LA151.md): Cessna 150F · Bono, AR · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N8591G · Substantial damage > The pilot said he had glided down to 500 feet AGL with the throttle reduced to idle trying to locate a landing strip. He said he applied power and the engine responded too late to avoid hitting a levee in the rice field and he flipped to the inverted position. - [NTSB DEN87FA203](https://openairdocs.org/ntsb/DEN87FA203.md): Cessna A188B · Kalispell, MT · Accident · 1 fatal · Field investigation · Final report · Jul 31, 1987 · N231SH · Destroyed > A Cessna ag wagon, N731SH, hit an electrical pwr line during a climbing turn while crop spraying. The acft was observed plummeting to the ground. The acft was substantially damaged and the plt received fatal injuries. The plt was climbing into the sun which… - [NTSB MIA87LA218](https://openairdocs.org/ntsb/MIA87LA218.md): Grumman G-164 · Pope, MS · Accident · No injuries · Limited investigation · Final report · Jul 30, 1987 · N8102K · Substantial damage > The plt stated that after he made a swath run he was turning back for another run when the eng coughed & quit. He then landed in a field & on rollout he was closing in on some trees so he applied the brakes & the acft nosed over & came to rest inverted. Post… - [NTSB DEN87LA199](https://openairdocs.org/ntsb/DEN87LA199.md): Bell 204B · Dubois, WY · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 1987 · N4580Y · Substantial damage > The commercial plt was performing external sling loads in support of seismic operations. The plt reported that the engine failed during a load release and the plt executed an autorotation. This resulted in a hard landing in heavy timber on sloping terrain.… - [NTSB ATL87FA223](https://openairdocs.org/ntsb/ATL87FA223.md): Cessna 150G · Circleville, OH · Accident · 2 fatal · Field investigation · Final report · Jul 26, 1987 · N2476J · Destroyed > Aprx 35 min after the acft tkof, witnesses observed it in what they described as erratic flt. One witness rprtd the acftflew over a vacant field where it entered a steep climb, then stalled & impacted the gnd in a steep nose down attitude. No preimpact part… - [NTSB ANC87LA113](https://openairdocs.org/ntsb/ANC87LA113.md): Bellanca 7GCBC · Happy Valley, AK · Accident · 2 fatal · Limited investigation · Final report · Jul 26, 1987 · N5052C · Destroyed > The aircraft struck the mountain at the 4000 foot level. At the time of the accident several witnesses stated that the weather was IFR, low ceiling, ground fog, and the prevailing visibility was less than one mile. - [NTSB DEN87LA193](https://openairdocs.org/ntsb/DEN87LA193.md): Cessna T188C · Pisek, ND · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1987 · N2037J · Destroyed > The plt was preparing to spray a potato field with a mixture of water and 2 lbs of 'blight-out.' He made one observation pass over the field to check for obstructions and noticed two sets of power lines, one on the east side of a road and the other on the… - [NTSB ATL87LA224](https://openairdocs.org/ntsb/ATL87LA224.md): Cessna R182 · Calera, AL · Accident · No injuries · Limited investigation · Final report · Jul 25, 1987 · N737ZZ · Substantial damage > The airplane collided with trees during a forced ldg attempt. The plt reported that he observed the fuel gauges indicating near empty shortly after departure. As he executed a 'steep' 180 deg turn back toward the arpt, the engine sputtered and 'quit'. During… - [NTSB ANC87LA105](https://openairdocs.org/ntsb/ANC87LA105.md): Piper PA-18 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jul 24, 1987 · N2571H · Substantial damage > The pilot was reconnoitering for game animals when he overlooked the rising terrain until he could no longer outclimb or turn away from it. The acft collided with a large rock and came to rest in a grass area. - [NTSB ATL87LA222](https://openairdocs.org/ntsb/ATL87LA222.md): Bell 47G-2 · Huntsville, AL · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1987 · N972B · Substantial damage > The helicopter impacted the water during a low-altitude turn over a river. The plt made a low pass to the south over an island at about 30 ft AGL, to show the island to the policewoman/traffic observer onboard. As he was making a climbing right turn at about… - [NTSB SEA87FA149](https://openairdocs.org/ntsb/SEA87FA149.md): Aero Commander 560-A · Ashland, OR · Accident · 4 fatal · Field investigation · Final report · Jul 22, 1987 · N2794B · Destroyed > The non-instrument rated pilot took off in overcast weather conditions and flew toward a mountain pass that was obscured in clouds. When the flight failed to arrive at the destination, a search was initiated and the wreckage located in a box canyon on the… - [NTSB FTW87DRG05](https://openairdocs.org/ntsb/FTW87DRG05.md): Aero Commander S2R · La Joya, TX · Accident · No injuries · Final report · Jul 22, 1987 · N5510X · Substantial damage > During an aerial application flight at a low altitude the aircraft's engine failed. A forced landing was made to a grassfield resulting in substantial damage to the aircraft. Disassembly of the engine revealed partial failure of the left magneto. The aircraft… - [NTSB DEN87LA192](https://openairdocs.org/ntsb/DEN87LA192.md): Grumman G-164A · Romeo, CO · Accident · No injuries · Limited investigation · Final report · Jul 22, 1987 · N5398 · Substantial damage > The plt reports that the acft encountered a downdraft during the turn around following a swath run. The aircraft began to settle and collided with the ground, bounced, hit a second time and nosed over. The aircraft was loaded with 280 gals of amine and 70… - [NTSB MKC87DCQ03](https://openairdocs.org/ntsb/MKC87DCQ03.md): Piper PA-36 · Nickerson, KS · Accident · 1 fatal · Final report · Jul 21, 1987 · N9935P · Destroyed > After a swath run to the east, the acft was observed to pull up & begin turning back to the west. The witness then saw a big cloud of smoke. She did not see spray coming from the acft drg the last swath run, although her vision was limitedby foliage & bldgs.… - [NTSB FTW87DRG04](https://openairdocs.org/ntsb/FTW87DRG04.md): Air Tractor AT301 · Santa Rosa, TX · Accident · Minor injuries · Final report · Jul 21, 1987 · N4407S · Destroyed > The pilot was dusting a sugar cane field which bordered a dirt road with parallel electrical transmission lines. The pilot had been terminating his swath runs by flying underneath the electrical wires at the edge of the field. To prevent becoming a hazard to… - [NTSB DEN87LA190](https://openairdocs.org/ntsb/DEN87LA190.md): Piper PA-25-235 · Fargo, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1987 · N9750P · Substantial damage > The plt was spraying a field with orthine, used to exterminate grasshoppers. The plt said he was making his last pass at the field and was flying into a setting sun. He said he did not see the powerline. The acft struck the powerline and the plt made a crash… - [NTSB DEN87LA191](https://openairdocs.org/ntsb/DEN87LA191.md): Piper PA-25 · Portales, NM · Accident · No injuries · Limited investigation · Final report · Jul 20, 1987 · N6419Z · Substantial damage > The plt was practicing aerial application maneuvers without chemicals onboard. During a turn, the plt reported that the engine lost power. The plt leveled the wings and lowered the nose to gain airspeed. The plt selected a landing site and after touchdown,… - [NTSB CHI87DEM10](https://openairdocs.org/ntsb/CHI87DEM10.md): Piper PA-25-235 · Marne, MI · Accident · Minor injuries · Final report · Jul 20, 1987 · N8972Y · Substantial damage > At the end of a swath run while about one-third of the way through the procedure turn around, the engine suddenly lost power. The pilot extended his glide to clear powerlines and when he flared to land he did not have enough airspeed to stop the descent. The… - [NTSB ANC87LA100](https://openairdocs.org/ntsb/ANC87LA100.md): Cessna 152 · Lorraine Lake, AK · Accident · No injuries · Limited investigation · Final report · Jul 19, 1987 · N5199P · Substantial damage > The pilot stated that he was flying a few feet above the trees when he flew into the water. - [NTSB ANC87FA101](https://openairdocs.org/ntsb/ANC87FA101.md): Cessna 185 · Hinchinbrook Is, AK · Accident · 1 fatal · Field investigation · Final report · Jul 19, 1987 · N1744R · Destroyed > According to witnesses the aircraft was low flying just above the tree level when the aircraft stalled and spun down into the trees. - [NTSB MIA87LA209](https://openairdocs.org/ntsb/MIA87LA209.md): Air Tractor AT-301 · Swiftown, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1987 · N7310N · Substantial damage > While spraying cotton, severe vibration was felt throughout the acft & the plt elected a forced ldg. During the flare, the throttle was advanced to raise the nose, & the plt discovered the eng had totally failed. The acft flipped inverted on touch down. An… - [NTSB LAX87LA272](https://openairdocs.org/ntsb/LAX87LA272.md): I.C.A. Brasov IS-28B2 · Perris, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 18, 1987 · N125FD · Substantial damage > The tow plt rprtd that drg takeoff, he felt the glider release at about 200' AGL. The purpose of the release was to practice a rope break. After being released, the glider maneuvered back toward the arpt, but it hit a tree & a power line before reaching the… - [NTSB CHI87DER10](https://openairdocs.org/ntsb/CHI87DER10.md): Air Tractor AT-301 · Hollandale, MN · Accident · 1 fatal · Final report · Jul 18, 1987 · N3652N · Substantial damage > After making a swath run the aircraft pulled up to clear power lines. Witnesses state that the engine cut out and aircraft pitched nose down and began to rotate. They state that the engine regained power just prior to impact. Subsequent investigation failed… - [NTSB MIA87LA208](https://openairdocs.org/ntsb/MIA87LA208.md): Air Tractor AT301 · Rolling Fork, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1987 · N2321V · Destroyed > During the swath run, the plt stated that the eng 'barked' once or twice just prior to impact with the trees. The acft hit the trees, rolled inverted & burst into flames. He stated that the seat belt & shoulder harness saved his life. The plt stated that he… - [NTSB DEN87FA186](https://openairdocs.org/ntsb/DEN87FA186.md): Mooney M20E · Vail, CO · Accident · 2 fatal · Field investigation · Final report · Jul 17, 1987 · N71SB · Destroyed > The pilot proceeded up a box canyon while on a cross-country flight. When unable to out climb terrain, the pilot attempted to reverse direction. During the turn, the aircraft stalled and crashed into trees. The pilot had not received instruction in mountain… - [NTSB FTW87DRA07](https://openairdocs.org/ntsb/FTW87DRA07.md): Air Tractor AT-301 · Anahuac, TX · Accident · Minor injuries · Final report · Jul 14, 1987 · N36503 · Substantial damage > The acft was substantially damaged when it encountered soft terrain and flipped over during a forced landing. The forced landing was executed following a complete loss of eng power during a swath run on an aerial application flight. The cause of the eng… - [NTSB ANC87FA097](https://openairdocs.org/ntsb/ANC87FA097.md): Piper PA-18 · Kasilof, AK · Accident · 1 fatal · Field investigation · Final report · Jul 14, 1987 · N54106 · Substantial damage > The student pilot and his non-pilot passenger/father were flying along a salt water beach looking for signs of a recent oil spill, when the pilot saw a fishing net in the water that he wanted a closer look at. He made two 180 degree turns at an altitude of… - [NTSB LAX87LA287](https://openairdocs.org/ntsb/LAX87LA287.md): Burkhart Grob G-103A · Maricopa, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1987 · N103BG · Destroyed > The plt rprtd that after gliding in a sink for svrl minutes, he began flying about 500' above a north-south mtn ridge in search of lift. While on a northerly heading, the left wing rose & the plt interpreted this as lift. He turned to the left (west) which… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=189 ## 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=188 --- 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.