# 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 187 of 377 · 18,850 cases ## Cases, newest first - [NTSB MKC87LA175](https://openairdocs.org/ntsb/MKC87LA175.md): Cessna 180B · Atkinson, NE · Accident · No injuries · Limited investigation · Final report · Sep 19, 1987 · N5133E · Substantial damage > Witnesses stated that the pilot was chasing a wild horse out of an alfalfa field and back into a corral when a wingtip struck a grove of trees and the aircraft cartwheeled onto the ground. The pilot stated to FAA that he did not see the treeline due to… - [NTSB MKC87FA172](https://openairdocs.org/ntsb/MKC87FA172.md): Schweizer G-164B · Weiner, AR · Accident · 1 fatal · Field investigation · Final report · Sep 18, 1987 · N36328 · Substantial damage > The plt rprtd he was on a flt to chase birds from a rice field. Drg a low pass over the field, the main wheels dscndd into the rice crop, & after about 1000', the acft contacted the terrain & nosed over. The single place acft was equippedwith only one seat… - [NTSB FTW87LA221](https://openairdocs.org/ntsb/FTW87LA221.md): Cessna 340A · Lubbock, TX · Accident · 1 fatal · Limited investigation · Final report · Sep 17, 1987 · N5449G · Destroyed > The pilot did not declare an emergency or mention to the tower controller that his fuel was low. He was first told to enter right traffic for runway 17R but was subsequently told to enter right traffic for runway 26. (This was to allow a dea aircraft, at its… - [NTSB FTW87FA219](https://openairdocs.org/ntsb/FTW87FA219.md): Grumman American AA-5A · Corpus Christi, TX · Accident · 4 fatal · Field investigation · Final report · Sep 16, 1987 · N6035L · Destroyed > The aircraft exceeded maximum allowable takeoff weight and aft center of gravity limits. The aircraft had two passengers in the rear seats. The operator's manual states that no passengers are permitted in the rear seats during aerobatic maneuvers. The pilot… - [NTSB CHI87DEE10](https://openairdocs.org/ntsb/CHI87DEE10.md): Hughes 269A · Plainfield, IL · Accident · Minor injuries · Final report · Sep 15, 1987 · N8927F · Substantial damage > While maneuvering at about 4 feet above ground level the pilot experienced a loss of engine power and entered an uncontrolled right turn and descent, colliding with the ground. The engine power loss was due to the failure of a stud and bolt holding the… - [NTSB ATL87DKG07](https://openairdocs.org/ntsb/ATL87DKG07.md): Grumman G-164A · Alamo, GA · Accident · Serious injuries · Final report · Sep 15, 1987 · N6590 · Destroyed > The acft was rprtd to be on an agricultural spraying assignment. The plt took off in the single seat acft with a passenger aboard. About 5 min after depg the arpt, the acft collided with trees & crashed after making an unscheduled low pass over an open field.… - [NTSB ANC87LA149](https://openairdocs.org/ntsb/ANC87LA149.md): Taylorcraft F-19 · Kuskatan River, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1987 · N3686T · Substantial damage > The pilot stated that he was maneuvering the aircraft at approximately 400 feet MSL when he stalled the aircraft and spun down until striking the trees. At the time of the accident the pilot did not hold a valid FAA pilot or medical certificate. He also did… - [NTSB FTW87LA215](https://openairdocs.org/ntsb/FTW87LA215.md): Aeronca 7AC · Batesvile, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 13, 1987 · N84191 · Substantial damage > A witness to the accident reported the pilot was 'buzzing' personnel in a cotton field and on the third pass did not pull up in time. The belly struck the ground while the aircraft was in a 'fairly steep angle of descent.' The witness stated the engine… - [NTSB FTW87DPJ08](https://openairdocs.org/ntsb/FTW87DPJ08.md): Air Tractor 301A · Hollis, OK · Accident · 1 fatal · Final report · Sep 13, 1987 · N3651D · Destroyed > During an aerial application cleanup run, the aircraft's wing collided with a pole and sheared off the outboard five feet. The aircraft then collided with the ground out of control. Exam of the engine and airframe did not disclose any pre-existing failures or… - [NTSB DEN87FA237](https://openairdocs.org/ntsb/DEN87FA237.md): Fairchild Hiller FH-1100 · Pinedale, WY · Accident · Serious injuries · Field investigation · Final report · Sep 13, 1987 · N5059F · Destroyed > The plt and two passengers had flown to Pinedale to fish. The plt stated that he was cruising at an alt of 400 ft AGL and was executing a rt turn at the request of a pax. He stated that he slowed the acft, decreased the collective, and added rt pedal as he… - [NTSB SEA87LA186](https://openairdocs.org/ntsb/SEA87LA186.md): Hiller UH-12E · Quincy, WA · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 1987 · N8QA · Destroyed > During an aerial application maneuver the pilot flew into two 23,000 volt powerlines. The helicopter's rotor blades struck the powerlines, the aircraft turned to the right and descended to the ground. - [NTSB NYC87FA252](https://openairdocs.org/ntsb/NYC87FA252.md): Piper PA-28-140 · East Granby, CT · Accident · 2 fatal · Field investigation · Final report · Sep 12, 1987 · N670FL · Destroyed > The pilot departed simsbury airport on a x-country flight and crashed 4.5 miles to the north in bradley intl airport traffic area. Witnesses in the crash site area saw an aircraft flying in and out of clouds prior to hearing the crash. - [NTSB LAX87FA332](https://openairdocs.org/ntsb/LAX87FA332.md): Bell 206B · Vallejo, CA · Accident · 3 fatal · Field investigation · Final report · Sep 9, 1987 · N1082S · Destroyed > While performing a routine aerial observation flight to inspect the integrity of the pacific gas & electric company's transmission lines, the helicopter crashed after colliding with an unmarked static wire. The line installation was on sloping terrain &… - [NTSB DEN87DTG02](https://openairdocs.org/ntsb/DEN87DTG02.md): Bell 47G-4A · Minot, ND · Accident · No injuries · Final report · Sep 8, 1987 · N2238W · Substantial damage > The plt rprtd that when he took off fm a nrby nurse truck, the wind was fm the NE at 5 to 7 mph. He made an observation pass across the area to be treated, then bgn a dscndg rgt turn to make a swath run in the opposite drctn. He stated he was unaware of a… - [NTSB LAX87LA325](https://openairdocs.org/ntsb/LAX87LA325.md): Beech A45 · Mammoth Lakes, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 6, 1987 · N34GL · Substantial damage > During an airshow performance, the acft collided with the terrain in a near vertical attitude. The maneuver the plt was to perform was a cuban eight. The first half of the maneuver was flown correctly, however, during the second half of it the acft remained… - [NTSB SEA87LA181](https://openairdocs.org/ntsb/SEA87LA181.md): Luscombe 8A · Burbank, WA · Accident · Serious injuries · Limited investigation · Final report · Sep 5, 1987 · N71513 · Destroyed > While on a local pleasure flight the pilot made a 30 degree, banked turn at reduced power. The aircraft entered a stall and descended to the ground. The aircraft has no stall warning system. - [NTSB FTW87FA209](https://openairdocs.org/ntsb/FTW87FA209.md): Mooney M-20C · Waller, TX · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1987 · N5590Q · Destroyed > It was reported that a private pilot was receiving instrument flight instructions from a CFI when the accident occurred. However, the CFI stated that he was invited by the pvt plt to go with him on a short flight and that he was only a passenger. During the… - [NTSB ANC87LA142](https://openairdocs.org/ntsb/ANC87LA142.md): Piper PA-18 · Mcgrath, AK · Accident · 1 fatal · Limited investigation · Final report · Sep 5, 1987 · N4191Z · Destroyed > A local hunting guide crashed his airplane in a remote mountain pass in central Alaska. Another guide who overflew the crash site shortly after the accident saw the airplane burning, but was unable to land due to strong winds, severe turbulence and strong… - [NTSB ANC87FA137](https://openairdocs.org/ntsb/ANC87FA137.md): Enstrom F-28F · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1987 · N8622A · Substantial damage > The pilot of the helicopter was seen flying at approximately 50 feet AGL down the length of a private gravel airstrip near Anchorage, Alaska. A nearby jogger said that the pilot appeared to wave at him as he flew past and then he heard the helicopter crash… - [NTSB ATL87FA248](https://openairdocs.org/ntsb/ATL87FA248.md): Cessna 182 · Lima, OH · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1987 · N71536 · Destroyed > During a night flt from toledo to cincinnati, OH, the acft crashed along the route at Lima, OH, after svrl local residents heard an acft circling. Initial impact was with the top of a dike after the acft crossed over a reservoir. Wreckage was scattered over a… - [NTSB ATL87DKG06](https://openairdocs.org/ntsb/ATL87DKG06.md): Pitts S-1 · Brooks, GA · Accident · 1 fatal · Final report · Sep 3, 1987 · N11HJ · Destroyed > The acft was observed in aerobatic maneuvers near the departure airfield. The last of the series was a lomcevak maneuver, which was started at an estimated alt of 2500 to 2700 ft. a witness rprtd the acft went into an inverted flat spin, which was corrected… - [NTSB SEA87FA180](https://openairdocs.org/ntsb/SEA87FA180.md): Cessna U206G II · Yakutat, AK · Accident · 1 fatal · Field investigation · Final report · Sep 2, 1987 · N756PS · Destroyed > Acft was observed to depart from controlled flight while in a steep left turn at slow speed and low altitude, impacting on a river sand bar. Fire ensued, demolishing acft. Following heavy rains, river rose and acft not recovered. - [NTSB LAX87DUJ11](https://openairdocs.org/ntsb/LAX87DUJ11.md): Hiller UH-12E · Scottsdale, AZ · Accident · Minor injuries · Final report · Sep 1, 1987 · N236HA · Destroyed > During an aerial application flight, the plt made a turn-around & was starting to make another swath run when he heard a loud 'bang' & then the helicopter collided with terrain. An inspn of the main rotor head & pin revealed the hub had failed from hi cycle… - [NTSB ATL87LA246](https://openairdocs.org/ntsb/ATL87LA246.md): Piper J3C-65 · Greenville, KY · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1987 · N92191 · Substantial damage > The flt was being conducted as part of a 'clown act' at an air show. The eng lost pwr shortly after takeoff as the plt was performing pitching maneuvers. He unsuccessfully attempted to regain pwr by 'pumping' the throttle. The airplane subsequently impacted… - [NTSB ATL87FA244](https://openairdocs.org/ntsb/ATL87FA244.md): Cessna 150L · Murray, KY · Accident · 1 fatal · Field investigation · Final report · Aug 29, 1987 · N6795G · Substantial damage > PIC stated to friends he intended to execute a hammerhead stall after take off from a private grass strip. Airstrip owner observed acft make a low pass, pitch up vertically, and execute a hammerhead stall at about 450-500 feet AGL. There was insufficient… - [NTSB SEA87FA178](https://openairdocs.org/ntsb/SEA87FA178.md): Piper PA-20 · Chelan, WA · Accident · 1 fatal · Field investigation · Final report · Aug 28, 1987 · N6901K · Destroyed > The pilot was observed making a engine out landing at his private grass/dirt strip. The dirt strip is located on a plateau with the runway starting at the edge of the plateau. The aircraft impacted in a steep nose down attitude below the runway level on a… - [NTSB ATL87FA243](https://openairdocs.org/ntsb/ATL87FA243.md): Aero Commander 112 · Middlefield, OH · Accident · 1 fatal · Field investigation · Final report · Aug 28, 1987 · N1050J · Destroyed > On the previous flt, the plt made two unsuccessful IFR approaches before landing on the third attempt. The pax- configured acft was loaded with cargo. The plt filed an IFR flight plan and departed the arpt. Radio contact was established with ATC and the plt… - [NTSB ATL87DMG02](https://openairdocs.org/ntsb/ATL87DMG02.md): Piper PA-25-235 · Macclesfield, NC · Accident · No injuries · Final report · Aug 27, 1987 · N89201 · Destroyed > Plt ind that he was in procedure turn-around for spraying soybeans. Acft stalled and recovery initiated. Acft entered secondary stall and collided with trees. Examination of eng and acft did not disclose any pre-impact malfunction. - [NTSB MKC87FA169](https://openairdocs.org/ntsb/MKC87FA169.md): Piper PA-24-260 · Kanorado, KS · Accident · 1 fatal · Field investigation · Final report · Aug 26, 1987 · N8975P · Destroyed > The fss stated they had personally briefed the student pilot on the wx en route for this night flight and told him VFR was not recommended. At the first stop, he called the co-owner of the airplane and told her he had been flying around storms. At the next… - [NTSB DEN87FA224](https://openairdocs.org/ntsb/DEN87FA224.md): Champion 7ECA · Devils Lake, ND · Accident · Serious injuries · Field investigation · Final report · Aug 26, 1987 · N11024 · Destroyed > The acft was observed flying at low altitude and circling a farm that belonged to the plt's sister. After making two passes by the farm, the acft crashed in a corn field. The plt said he was looking for a field in which to land, and on the 2nd pass, the acft… - [NTSB LAX87LA310](https://openairdocs.org/ntsb/LAX87LA310.md): Bell 206B · Kailua-Kona, HI · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1987 · N2777R · Substantial damage > As the helicopter was climbing over rising terrain at 300' to 400' AGL, the plt noted altimeter & airspeed indcns of 8700' & 60 mph. After climbing an adnl 2 min to aprx 10,000' (12,000' density alt), he noticed the rotor RPM was bleeding off. He made a 180… - [NTSB LAX87FA309](https://openairdocs.org/ntsb/LAX87FA309.md): Beech C-55 · Salton City, CA · Accident · 2 fatal · Field investigation · Final report · Aug 23, 1987 · N3784Q · Destroyed > Instructor pilot's inability to recover control of the aircraft after it entered a spin. - [NTSB LAX87DUM05](https://openairdocs.org/ntsb/LAX87DUM05.md): Sawyer DF-9 · Ramona, CA · Accident · 1 fatal · Final report · Aug 23, 1987 · N6524J · Destroyed > During the third test flt, the plt was to fly the acft to 6000 ft for slow flt and flutter testing at increasing speeds to 200 mph. The plt was then to complete a shallow descent to touch-down with an on final, over-the-fence speed not to exceed 75 mph.… - [NTSB CHI87FA195](https://openairdocs.org/ntsb/CHI87FA195.md): Cessna 172 · Baileyville, IL · Accident · 3 fatal · Field investigation · Final report · Aug 23, 1987 · N8207B · Destroyed > While performing a low level (300-400' above the ground) flight search for a remote controlled aircraft that had been lost during flight, the pilot lost control of the acft. A witness reported that the aircraft entered a 'tight left turn', and then the nose… - [NTSB NYC87DHJ02](https://openairdocs.org/ntsb/NYC87DHJ02.md): Reder KR-2 · Mattituck, NY · Accident · 2 fatal · Final report · Aug 22, 1987 · N2262N · Destroyed > Witnesses observed the experimental homebuilt acft in a steep nose down attitude descent with its prop rotating. No witnesses were located who saw the acft prior to the descent, however, pilots in the area reported that winds were turbulent and gusty. The… - [NTSB SEA87LA172](https://openairdocs.org/ntsb/SEA87LA172.md): Bell 47G2 · Grandview, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1987 · N74161 · Substantial damage > After the completion of spray operations the pilot was attempting to place the helicopter onto a trailer. The pilot misjudged his position, over-corrected, and then lost control of the helicopter, striking the ground. - [NTSB DEN87DTK01](https://openairdocs.org/ntsb/DEN87DTK01.md): Bushby Mustang II · Aberdeen, SD · Accident · 1 fatal · Final report · Aug 21, 1987 · N44TA · Destroyed > Witnesses reported that they observed the acft perform two snap rolls. During the second snap roll something came off the aircraft and fell to the ground. The acft then became inverted and descended until impact with the ground. The acft impacted in a near… - [NTSB BFO87FA057](https://openairdocs.org/ntsb/BFO87FA057.md): Bell 206B · Washington, DC · Accident · 3 fatal · Field investigation · Final report · Aug 21, 1987 · N83080 · Destroyed > The helicopter was on a LCL photography (sight-seeing) flt. While hovering at aprx 200' abv the potomac river, the eng lost pwr. The plt initiated an autorotation & deployed the emerg floats. Subsequently, the helicopter impacted in the river & rolled ovr,… - [NTSB FTW87DRD13](https://openairdocs.org/ntsb/FTW87DRD13.md): Air Tractor AT-400A · Monroe, LA · Accident · No injuries · Final report · Aug 19, 1987 · N3159C · Substantial damage > The ag pilot pulled up from a swath run while spraying chemicals on cotton and the pt 6A-20A engine in his aircraft exploded. A post accident teardown of the engine revealed the blades of a compressor disk had failed causing a total loss of power. Reason for… - [NTSB ATL87FA235](https://openairdocs.org/ntsb/ATL87FA235.md): Cessna 172A · Camilia, GA · Accident · 1 fatal · Field investigation · Final report · Aug 19, 1987 · N7559T · Destroyed > This flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash… - [NTSB NYC87FA272](https://openairdocs.org/ntsb/NYC87FA272.md): Bellanca 8GCBC · Martha Vineyard, MA · Accident · 1 fatal · Field investigation · Final report · Aug 18, 1987 · N5060K · Destroyed > The plt was involved in commerical fishing operations as a spotter and to direct the closing of nets around schools of tuna. While directing the closing of a net, the fish being netted reversed course and started to escape from the open net. The plt dove at a… - [NTSB FTW87DRD11](https://openairdocs.org/ntsb/FTW87DRD11.md): Grumman G-164A · Bastrop, LA · Accident · 1 fatal · Final report · Aug 18, 1987 · N9685 · Minor damage > Three flagmen were working with one spray plane and three fields. On this pass, two of the flagmen moved to the proper positions but the other one had moved too FAR laterally. The pilot stated to the sheriff that he had observed the flagman stepping off the… - [NTSB SEA87FA166](https://openairdocs.org/ntsb/SEA87FA166.md): Cessna 172RG · Kettle Falls, WA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 1987 · N9747B · Destroyed > While on a local personal flight, plt entered a canyon into rising terrain, colliding first with a tree and then ground near crest. Investigation revealed that acft probably had performance to clear crest had tree not been struck. Circumstances indicate plt… - [NTSB FTW87LA199](https://openairdocs.org/ntsb/FTW87LA199.md): Let L-13 · Littlefield, TX · Accident · No injuries · Limited investigation · Final report · Aug 16, 1987 · N9997Q · Substantial damage > The pilot activated the flaps while on final approach instead of the spoilers. When the glider did not descend as he expected, a left 360 degree turn was initiated to lose altitude. The pilot stated that he then unintentionally stalled the aircraft while in… - [NTSB DEN87FA218](https://openairdocs.org/ntsb/DEN87FA218.md): Cessna 172C · Switz City, IN · Accident · 2 fatal · Field investigation · Final report · Aug 16, 1987 · N1418Y · Destroyed > After departing the bloomfield arpt, the plt flew with his family over a coal mine area where he had done reclamation work. Witnesses at the mine stated that they observed the acft fly low over the mine pits & that the plt waved at them. The acft departed,… - [NTSB MKC87LA164](https://openairdocs.org/ntsb/MKC87LA164.md): Rockwell S-2R · Mediapolis, IA · Accident · No injuries · Limited investigation · Final report · Aug 15, 1987 · N4949X · Substantial damage > The pilot stated that the field to be sprayed appeared safe enough when he flew a recon flight over the area the day prior to the accident. He stated that he didn't expect the power transmission lines to be so low, and that he did not see a rise in the… - [NTSB NYC87DNC12](https://openairdocs.org/ntsb/NYC87DNC12.md): Cessna 150L · Heartwellville, VT · Accident · Serious injuries · Final report · Aug 14, 1987 · N19363 · Destroyed > The pilot of the Cessna 150 was on a solo flight to practice several maneuvers including stalls. At about 4000 ft MSL, then aircraft was climbing with power on when it stalled and went into a spin. The pilot managed to get the nose up just prior to impact… - [NTSB ATL87FA230](https://openairdocs.org/ntsb/ATL87FA230.md): Piper PA-28R-200 · Offerman, GA · Accident · 3 fatal · Field investigation · Final report · Aug 14, 1987 · N55649 · Destroyed > During a local flt the acft was observed flying at a level attitude approx 10 ft above a corn field at high speed. The right wing of the acft struck tree branches approx 60 ft AGL during a pull up. A 6 ft section of the right wing separated. The acft climbed,… - [NTSB LAX87DVA11](https://openairdocs.org/ntsb/LAX87DVA11.md): Rockwell S-2R · Mendota, CA · Accident · 1 fatal · Final report · Aug 13, 1987 · N4219X · Substantial damage > The ground flagman reported the pilot had just completed spraying the bean field. The pilot was in the process of doing a touch-up application when he flew under the power lines. The airplane right wing contacted the lowest of the 4 powerlines, rolled… - [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… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=188 ## 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=187 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.