# 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 189 of 378 · 18,851 cases ## Cases, newest first - [NTSB ATL87FA209](https://openairdocs.org/ntsb/ATL87FA209.md): Cessna 152 · Yanceyville, NC · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1987 · N4869B · Destroyed > The plt was engaged in low alt commercial photography. Witnesses had observed the acft operating at a very low altitude in the area for the past two or three days. The witness closest to the crash site related that the acft would make a straight pass near a… - [NTSB SEA87FA135](https://openairdocs.org/ntsb/SEA87FA135.md): Maule M-4-210C · Sitka, AK · Accident · 2 fatal · Field investigation · Final report · Jul 12, 1987 · N9812M · Destroyed > Plt was on local VFR flight plan. Witnesses observed acft flying at low level along beaches. Later, witness saw smoke rising from wooded terrain about two miles inland from nearest beach. Investigation revealed no evidence of inflight failure of malfunction… - [NTSB CHI87LA167](https://openairdocs.org/ntsb/CHI87LA167.md): Balloon Works Firefly 7 · Springfield, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1987 · N1505F · 2 aircraft · Substantial damage > Two hot air balloons were involved in a midair collision during a sanctioned Balloon competition. N40363 was able to retain control and landed uneventfully. N1505F partially deflated and descended out of control to the ground. Witnesses stated that N40363 was… - [NTSB ANC87LA096](https://openairdocs.org/ntsb/ANC87LA096.md): Aeronca 7AC · Mcneil Cove, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1987 · N4322E · Substantial damage > The pilot and his passenger were flying at approximately 150 feet above the water near the shoreline when the pilot made a steep left climbing turn. The airplane stalled and crashed into the water. The pilot was not rated to fly seaplanes. No mechanical… - [NTSB ANC87FA095](https://openairdocs.org/ntsb/ANC87FA095.md): Piper PA-18 · Sheep Mountain, AK · Accident · Serious injuries · Field investigation · Final report · Jul 12, 1987 · N159T · Substantial damage > The pilot and his two passengers took off in a two place Piper PA-18 from a glacier after doing repair work on an aircraft that had crashed there earlier. Weather conditions were deteriorating as they approached their destination airstrip located in a nearby… - [NTSB NYC87LA200](https://openairdocs.org/ntsb/NYC87LA200.md): Champion 7GCAA · Bargaintown, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 1987 · N9085L · Substantial damage > The pilot reported that during climb out and level off after a banner pickup, the engine would not produce sufficient power to sustain flight. After checking the carburetor heat and mixture, he released the tow ropes and established a glide. Subsequently, the… - [NTSB MKC87DPG02](https://openairdocs.org/ntsb/MKC87DPG02.md): Piper PA-25-235 · Hazen, AR · Accident · Serious injuries · Final report · Jul 11, 1987 · N7705Z · Destroyed > The pilot stated to a witness that after coming out of his 2nd pass, in the last 1/3 of his procedural turn, the plane stalled and the right wing struck a telephone wire which caused it to swing onto a gravel road. It hit left wing/nose down, bounced, and… - [NTSB ATL87DLT03](https://openairdocs.org/ntsb/ATL87DLT03.md): Burkhart Grob G102-111B · Memphis, TN · Accident · 1 fatal · Final report · Jul 11, 1987 · N3950L · Destroyed > Glider tow rope released at about 200FT following t/o. glider made rt turn followed by stall/spiral which continued until ground impact. Tow pilot saw glider pilot's hat falling to ground just after tow rope was released by glider pilot. Glider canopy was… - [NTSB FTW87LA165](https://openairdocs.org/ntsb/FTW87LA165.md): Bell 206L-1 · Venice, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1987 · N5734S · Substantial damage > The pilot was repositioning the aircraft after a phase iv inspection. The aircraft lifted off the pad and made several clockwise revolutions, descended out of control, impacted the ground and rolled over on its right side. Investigation revealed the number 1… - [NTSB ATL87DEI08](https://openairdocs.org/ntsb/ATL87DEI08.md): Grumman G-164A · Bucyrus, OH · Accident · Minor injuries · Final report · Jul 9, 1987 · N7845 · Substantial damage > As the plt was apchg a field to spread fertilizer, the acft collided with a tree & crashed to the ground. The plt received a head injury & said he could not recall the acdnt. According to hospital records, he was suffering from pneumonia & had a 101 deg temp… - [NTSB MKC87FA131](https://openairdocs.org/ntsb/MKC87FA131.md): Bellanca 8GCBC · Holdrege, NE · Accident · 2 fatal · Field investigation · Final report · Jul 8, 1987 · N87099 · Destroyed > Witnesses stated that the aircraft was performing a loop when the left wing failed upward and rearward causing the aircraft to plummet to the ground, out of control. The aircraft appeared to have been in trouble during the loop entry and throughout the… - [NTSB CHI87DER08](https://openairdocs.org/ntsb/CHI87DER08.md): Cessna T188C · Olivia, MN · Accident · No injuries · Final report · Jul 8, 1987 · N9674J · Substantial damage > During a 180 degree turn from completion of a spray swath the aircraft began to sink. The pilot dumped his load and added power, however was unable to arrest sink. When it was obvious that impact with the ground was imminent, the pilot reduced power and… - [NTSB ATL87LA204](https://openairdocs.org/ntsb/ATL87LA204.md): Bell 47D1 · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Jul 8, 1987 · N908B · Substantial damage > The aerial application flight was dispensing insecticides on a cotton field. While maneuvering to avoid powerlines during the procedure turnaround following an upwind swath run, the pilot failed to maintain sufficient airspeed to ensure effective… - [NTSB SEA87LA137](https://openairdocs.org/ntsb/SEA87LA137.md): Bell 47G-3B-1 · Cashmere, WA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1987 · N73932 · Substantial damage > During aerial applications maneuver a loud whine accompanied by a loss of power occurred. During forced landing a hard landing was made collapsing the skids with the main rotor blades striking the ground. No reason for the power loss was found. - [NTSB ATL87LA203](https://openairdocs.org/ntsb/ATL87LA203.md): Cessna 152 · Goldsboro, NC · Accident · No injuries · Limited investigation · Final report · Jul 6, 1987 · N69087 · Substantial damage > Student PIC rpted he followed wrong railroad track to return from the practice area to the airport. Viz was about 6 miles in hazy conditions. Prior to exhausting fuel or daylight he elected to land in a field. Field was soft terrain and acft nosed over. - [NTSB NYC87LA197](https://openairdocs.org/ntsb/NYC87LA197.md): Aeronca 7EC · Scoodic Lake, ME · Accident · No injuries · Limited investigation · Final report · Jul 5, 1987 · N8955R · Substantial damage > The plt of the float equipped acft was taking off from Scoodic Lake. Drg the initial climb phase after takeoff, he noted the acft began to lose altitude & would not clear trees on a ridge ahead. He initiated a turn back toward the lake; however, the acft… - [NTSB NYC87DNC07](https://openairdocs.org/ntsb/NYC87DNC07.md): Mcculloch Monerai "S" · Springfield, VT · Accident · 1 fatal · Final report · Jul 5, 1987 · N54MS · Destroyed > The monerai 's' (N54MS, a pwrd glider) experienced an inflt failure of the left wing spar & crashed. An investigation revealed the acft was being operated in excess of its max gross wt limit of 450 lbs. The plt of an unpowered monerai said he & 3 others… - [NTSB DEN87MA168](https://openairdocs.org/ntsb/DEN87MA168.md): Beech D18S · Lakeside, MT · Accident · 10 fatal · Major investigation · Final report · Jul 5, 1987 · N132E · Destroyed > The plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the… - [NTSB DEN87LA170](https://openairdocs.org/ntsb/DEN87LA170.md): Christian Eagle II · Snowmass, CO · Accident · 2 fatal · Limited investigation · Final report · Jul 5, 1987 · N81DG · Destroyed > The ATP plt and his passenger departed aspen, CO on a local acrobatic flight. Witnesses stated the plt had been performing acrobatic manuevers and was attempting a 'loop' when the acft was observed to 'stall' at the top of the manuever, approximately 2000… - [NTSB LAX87DUJ06](https://openairdocs.org/ntsb/LAX87DUJ06.md): Davis Midget Mustang · Kirkland, AZ · Accident · 1 fatal · Final report · Jul 3, 1987 · N7SD · Destroyed > During a low level aerobatic flight, the aircraft collided with the terrain after completing a roll. There were no mechanical failures or malfunctions reported. The plt performed the last roll in view of two friends driving in a car near the acc scene.… - [NTSB LAX87LA255](https://openairdocs.org/ntsb/LAX87LA255.md): Bell 206L-3 · Benson, AZ · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 1987 · N2123X · Substantial damage > A Bell helicopter 206L-3 collided with wires while maneuvering over an underground telephone cable. The plt indicated that he had just completed a 360 deg right turn at the request of the pax and was aprx 185 deg through the second turn when he struck a… - [NTSB CHI87LA160](https://openairdocs.org/ntsb/CHI87LA160.md): Taylorcraft BC-12D · Dyckesville, WI · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1987 · N33967 · Destroyed > Aircraft stalled as the pilot attempted to climb and turn back to fly along green bay shoreline. The pilot was flying approx. 100 to 150 feet above the water in order for the passenger to photograph the shoreline. - [NTSB ATL87FA194](https://openairdocs.org/ntsb/ATL87FA194.md): Piper PA-18A-150 · No.Myrtle Beach, SC · Accident · Serious injuries · Field investigation · Final report · Jun 30, 1987 · N74815 · Destroyed > The airplane was maneuvering at 350 ft AGL in preparation for a banner pick-up when it entered a spin and subsequently impacted trees and the terrain. The plt stated that he 'failed to fly the airplane' while attempting to deploy a banner tow line, and that… - [NTSB DEN87LA161](https://openairdocs.org/ntsb/DEN87LA161.md): Cessna A188B · Cayuga, ND · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 1987 · N4703R · Destroyed > The plt was completing a swath run and struck a power line with the right wing, severing the wing. The aircraft did a snap roll to the right and impacted in a field. - [NTSB NYC87LA191](https://openairdocs.org/ntsb/NYC87LA191.md): Piper J3C-65 · Cape May, NJ · Accident · No injuries · Limited investigation · Final report · Jun 28, 1987 · N42138 · Substantial damage > The Piper J3C-65 made an unsuccessful attempt at a banner pickup and was maneuvering at 400 ft in a climbing left turn for another pickup when a power loss occurred. The pilot made a forced landing in a marsh. The pilot reported the fuel quanity gauge was… - [NTSB LAX87DUJ08](https://openairdocs.org/ntsb/LAX87DUJ08.md): Teague Phantom · Casa Grande, AZ · Accident · Serious injuries · Final report · Jun 28, 1987 · N922ET · Destroyed > The plt was flying the ultralight type acft at low level. As he flew thru a pass between two foothills, the acft struck telephone lines, then collided with terrain. There were no reported mechanical failures or malfunctions. - [NTSB DEN87FA162](https://openairdocs.org/ntsb/DEN87FA162.md): Cessna 421C · Cody, WY · Accident · 4 fatal · Field investigation · Final report · Jun 28, 1987 · N26553 · Destroyed > The plt & 3 paxs were returning to dallas, TX from a retreat in Montana. The plt filed an IFR flt plan from white sulphur springs, MT, to casper, WY, but did not activate it after departure. The acft was rprtd overdue by family & a search was initiated. The… - [NTSB FTW87FA152](https://openairdocs.org/ntsb/FTW87FA152.md): Champion 7ECA · Monahans, TX · Accident · 1 fatal · Field investigation · Final report · Jun 27, 1987 · N2500F · Destroyed > Witnesses stated that upon departure the pilot pulled the aircraft up abruptly and rolled into a very steep right climbing turn. After about 20 minutes the pilot returned to the airport due to weather conditions along his porposed route of flight. Over the… - [NTSB FTW87DRD07](https://openairdocs.org/ntsb/FTW87DRD07.md): Grumman G-164B · Chenneyville, LA · Accident · No injuries · Final report · Jun 26, 1987 · N7500K · Substantial damage > The engine experienced a total loss of power due to a failed #1 connecting rod. During the forced landing the left wing contacted cotton plants which caused the aircraft to veer left and flip inverted. - [NTSB CHI87DEM09](https://openairdocs.org/ntsb/CHI87DEM09.md): North American P-51D · Ludington, MI · Accident · 2 fatal · Final report · Jun 26, 1987 · N3278D · Destroyed > N3278D was #1 (leader) in a flt of 2 North American P-51 acft. The plt of the 2nd P-51 rprtd that they were on a southerly heading over water about 1/2 mi from the shore when the leader raised his nose & began rolling to the right. Witnesses on the beach… - [NTSB ATL87FA189](https://openairdocs.org/ntsb/ATL87FA189.md): Piper PA-28-180 · Jesup, GA · Accident · 4 fatal · Field investigation · Final report · Jun 26, 1987 · N15978 · Destroyed > Witnesses rprtd the acft 'buzzed' (flew low) over a factory, where the plt used to work, then it went over the altamaha river, flew under a bridge & continued up the river at low alt. About 2 to 3 mi upstream, the acft was maneuvering when it struck trees &… - [NTSB ATL87DEI06](https://openairdocs.org/ntsb/ATL87DEI06.md): Steen Skybolt · Wadsworth, OH · Accident · 2 fatal · Final report · Jun 25, 1987 · N86173 · Destroyed > The accident occurred when the pilot was practicing aerobatics. The investigation disclosed that linkage control rods between the pilot's stick and the pitch elevator was broken. The evidence indicated that the failure was caused by a combination of… - [NTSB SEA87LA121](https://openairdocs.org/ntsb/SEA87LA121.md): Grumman G-164A · Viola, ID · Accident · No injuries · Limited investigation · Final report · Jun 24, 1987 · N5285 · Substantial damage > During an aerial applications maneuver a total loss of power occurred due to the internal failure of the supercharger impeller. During the forced landing the left main gear collapsed causing the aircraft to nose over inverted. - [NTSB CHI87DEP07](https://openairdocs.org/ntsb/CHI87DEP07.md): Piper PA-36 · Plover, WI · Accident · Serious injuries · Final report · Jun 22, 1987 · N57791 · Destroyed > After spraying most of a bean crop, the plt was making clean-up swaths over an area at the north side of the field. This area had bldgs to the west & trees to the east. To avoid flying toward the bldgs, the plt elected to make the passes to the east (toward… - [NTSB CHI87LA155](https://openairdocs.org/ntsb/CHI87LA155.md): Stinson 108-1 · Big Sandy Lake, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1987 · N40161 · Substantial damage > The engine stalled for undetermined reasons after the pilot made a wide circle turn. During a forced landing in a lake, the aircraft nosed over. The last annual aircraft inspection was 15 months prior to the date of the accident. - [NTSB ATL87LA184](https://openairdocs.org/ntsb/ATL87LA184.md): Grumman G-164A · Cottonwood, AL · Accident · No injuries · Limited investigation · Final report · Jun 21, 1987 · N7687 · Substantial damage > The plt stated that everything was normal for the acft during the preflt and runup. He had just about completed his first swath run when he reptd that the engine shook a little and started backfiring. He pulled up and started across a swamp toward a paved… - [NTSB MIA87LA190](https://openairdocs.org/ntsb/MIA87LA190.md): Bell 47G-2 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N6772D · Substantial damage > The instructor plt stated that the helicopter began to vibrate while the student plt was maneuvering it during an instructional flt. The instructor plt then executed a forced landing and upon touchdown the main rotor blades contacted the ground. Inspection of… - [NTSB ATL87LA175](https://openairdocs.org/ntsb/ATL87LA175.md): Piper PA-25 · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jun 19, 1987 · N6078Z · Substantial damage > The acft encountered a strong downdraft in a thunderstorm and impacted the water during a beachside banner towing operation. The plt reported that he had observed thunderstorms developing inland about 1/2 hr prior to the accident and that his acft was… - [NTSB NYC87LA180](https://openairdocs.org/ntsb/NYC87LA180.md): Cessna 172 · Mt.Union Boro, PA · Accident · No injuries · Limited investigation · Final report · Jun 18, 1987 · N3913F · Substantial damage > The aircraft collided with transmission wires while flying low during a pleasure flight. An uneventful precautionary landing was made on a highway with reduced power and full flaps. - [NTSB MKC87LA124](https://openairdocs.org/ntsb/MKC87LA124.md): Grumman G-164A · Neelyville, MO · Accident · No injuries · Limited investigation · Final report · Jun 18, 1987 · N5214 · Substantial damage > The ag pilot was making a low pass to wave his flagman out of the field. The engine response was slow and he was forced to land. To keep from hitting trees, pilot overbraked and flipped airplane forward to inverted position. - [NTSB LAX87LA238](https://openairdocs.org/ntsb/LAX87LA238.md): Cessna 172N · Malibu, CA · Accident · No injuries · Limited investigation · Final report · Jun 18, 1987 · N738JV · Substantial damage > During a local instructional flight, the pilot stated that they were flying along the coast aprx 1 mile offshore and 500 ft AGL. The student started a climbing right turn towards land. The student continued to apply back pressure to the point that the acft… - [NTSB DEN87FA153](https://openairdocs.org/ntsb/DEN87FA153.md): Concept 70 · Durango, CO · Accident · No injuries · Field investigation · Final report · Jun 17, 1987 · N23405 · Substantial damage > The plt reported that he had been flying for one hour and had been doing acrobatics. He had started an inside loop and during pull up, he reported indicating 5.5 g's on his new g meter. The plt reported that both wings left the acft and he jettisoned the… - [NTSB ATL87LA170](https://openairdocs.org/ntsb/ATL87LA170.md): Piper PA-28-180 · Hazard, KY · Accident · No injuries · Limited investigation · Final report · Jun 16, 1987 · N8021W · Substantial damage > The plt observed the rear of the upper engine cowling lift up shortly after takeoff and he became concerned that the cowling might come off the airplane during flight. The pilot attempted to maneuver the airplane back to the airport to land, the airplane… - [NTSB LAX87LA235](https://openairdocs.org/ntsb/LAX87LA235.md): Cessna 152 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1987 · N115RJ · Destroyed > The aircraft ditched in the pacific ocean while on a VFR instructional flight. Both pilots indicated that the engine stopped abruptly and they were unable to restart it. The propeller would not turn when the starter was engaged, nor would it windmill. The CFI… - [NTSB LAX87FA234](https://openairdocs.org/ntsb/LAX87FA234.md): Cessna T210N · Huntington Bch, CA · Accident · 1 fatal · Field investigation · Final report · Jun 15, 1987 · N6461N · Destroyed > During a pleasure flight, the pilot informed an air traffic controller that he was running out of fuel and turning to an airport. During the descent the airplane collided with a tree and terrain. There were no reported mechanical failures or malfunctions with… - [NTSB FTW87LA144](https://openairdocs.org/ntsb/FTW87LA144.md): Great Lakes 2T-1A · Lago Vista, TX · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N874K · Substantial damage > While maneuvering at approximately 50 feet AGL, the aircraft's landing gear contacted a 7200 volt powerline. Control of the aircraft was lost, and it descended out of control into about 2 feet of water, causing substantial damage. - [NTSB SEA87LA114](https://openairdocs.org/ntsb/SEA87LA114.md): Cessna T-188C · Yerington, NV · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1987 · N9795J · Destroyed > While on an aerial application swath run the pilot allowed the aircraft landing gear to contact the grain crop, resulting in loss of airspeed, uncontrolled descent, impact with the ground and nose over. - [NTSB NYC87LA178](https://openairdocs.org/ntsb/NYC87LA178.md): Robinson R-22 · Sterling, MA · Accident · No injuries · Limited investigation · Final report · Jun 13, 1987 · N351 · Substantial damage > While practicing hovering in the designated hover area at the arpt, the stu plt accidently pulled aft cyclic while the helicopter was drifting backwards. This caused the tail structure and rotor blades to contact the ground. The main rotor blades then… - [NTSB DEN87LA150](https://openairdocs.org/ntsb/DEN87LA150.md): Cessna A185E · Norwood, CO · Accident · No injuries · Limited investigation · Final report · Jun 13, 1987 · N5836J · Substantial damage > The plt was circling gnd psnl at 300 to 500 ft AGL, banking up to 60 deg, when the eng quit. An eng restart was successful; however, the acft was too low to recover & it collided with a fence. After hitting the fence, the acft crashed to the gnd & was… - [NTSB SEA87LA118](https://openairdocs.org/ntsb/SEA87LA118.md): Bell 47G-3B-2 · Milton-Freewatr, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1987 · N2219W · Destroyed > The pilot was hovering up rising terrain at a slow airspeed, at 15 feet above the ground while on an agricultural spraying flight and encountered settling with power. The aircraft entered an uncontrolled descent and impacted the ground. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=190 ## 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=189 --- 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.