# NTSB investigations, 1987: Takeoff 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 1 of 4 · 187 cases ## Latest cases - [NTSB MKC88LA035](https://openairdocs.org/ntsb/MKC88LA035.md): Cessna 182Q · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1987 · N96934 · Substantial damage > The PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty… - [NTSB DEN88LA040](https://openairdocs.org/ntsb/DEN88LA040.md): Beech A36 · Angel Fire, NM · Accident · No injuries · Limited investigation · Final report · Dec 23, 1987 · N27LH · Substantial damage > The private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the… - [NTSB DEN88LA038](https://openairdocs.org/ntsb/DEN88LA038.md): Cessna T210R · Bismarck, ND · Accident · No injuries · Limited investigation · Final report · Dec 19, 1987 · N7381U · Substantial damage > The plt was attempting to takeoff at dusk on a gravel road. The acft veered off of road and hit a ditch. - [NTSB ANC88FA022](https://openairdocs.org/ntsb/ANC88FA022.md): Cessna 208 · Bethel, AK · Accident · Minor injuries · Field investigation · Final report · Dec 19, 1987 · N9438F · Substantial damage > The plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial… - [NTSB NYC88LA023](https://openairdocs.org/ntsb/NYC88LA023.md): Gulfstream American AA-5B · Morristown, NJ · Accident · No injuries · Limited investigation · Final report · Nov 30, 1987 · N4533Q · Substantial damage > The Gulfstream-american AA5B was making a takeoff with a flight instructor and student pilot on board. At 65 knots during the takeoff, a deer was struck on the runway and killed. The takeoff was aborted on the runway. The student pilot and flight instructor… - [NTSB CHI88LA029](https://openairdocs.org/ntsb/CHI88LA029.md): Piper PA-28 · Lake City, MI · Accident · No injuries · Limited investigation · Final report · Nov 22, 1987 · N9817W · Substantial damage > The student pilot initiated a takeoff from a snow covered runway. During the initial ground run, he lost directional control. Subsequently, the aircraft ran off the side of the runway & collided with trees. The plt rprtd the wind was from the south at 8 to 10… - [NTSB LAX88DUQ02](https://openairdocs.org/ntsb/LAX88DUQ02.md): Isgrigg Elite · Tehachapi, CA · Accident · Minor injuries · Final report · Nov 21, 1987 · N333JE · Substantial damage > The homebuilt gyroplane became uncontrollable during take-off roll on runway 27R. The aircraft pitched up and then rolled on its left side. The national weather service reported the winds in the area at the time of the accident to be from 290 degrees at 12-15… - [NTSB LAX88FA033](https://openairdocs.org/ntsb/LAX88FA033.md): Bell 206L-3 · Rialto, CA · Accident · Serious injuries · Field investigation · Final report · Nov 19, 1987 · N66WL · Substantial damage > The pilot lost control of the recently painted helicopter during the takeoff. The paint shop personnel had moved the helo to a airplane parking spot. The helo skids straddled the tie-down chains. Two wing tie-down chains were incorrectly attached to the right… - [NTSB LAX88LA044](https://openairdocs.org/ntsb/LAX88LA044.md): Beech D18S · Mokuleia, HI · Accident · No injuries · Limited investigation · Final report · Nov 15, 1987 · N802H · Substantial damage > The plt rprtd that he had made a normal preflight, but after the acft had rolled about 200 to 250 ft on the takeoff roll, the nose gear collapsed. The acft came to rest with damage to the nose section, props & engs. Drg an inspn of the acft, the landing gear… - [NTSB CHI88LA025](https://openairdocs.org/ntsb/CHI88LA025.md): Piper PA-28-181 · Manitowoc, WI · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N47622 · Substantial damage > The pilot and his two pax were on takeoff roll at the local, uncontrolled arpt. The pilot stated that just prior to rotation a deer ran onto the runway and the right wing struck the deer. The pilot aborted the takeoff without incident. - [NTSB DEN88LA022](https://openairdocs.org/ntsb/DEN88LA022.md): Cessna 182N · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Nov 9, 1987 · N9209G · Substantial damage > The plt reported that she was making a touch and go. She said as she applied full power to takeoff the acft veered to the right. She was unable to realign the acft with the rwy and elected to continue the takeoff and 'pulled the acft off at a speed below… - [NTSB LAX88LA026](https://openairdocs.org/ntsb/LAX88LA026.md): Cessna 182H · Willcox, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1987 · N8411S · Substantial damage > The plt reported that the takeoff ground roll was unusually long. After liftoff the acft stayed in ground effect until just before the end of the rwy then climbed to aprx 100 ft. the plt landed in a soft field. During the landing roll the acft nosed over.… - [NTSB CHI88LA013](https://openairdocs.org/ntsb/CHI88LA013.md): Grumman AA-5B · Leavenworth, IN · Accident · No injuries · Limited investigation · Final report · Nov 2, 1987 · N28483 · Substantial damage > According to the pilot, the aircraft was taking off from a 'bumpy' grass private strip. The pilot stated he discussed aborted takeoff procedures with the pilot rated passenger who was sitting in the right seat and stated if the aircraft did not reach takeoff… - [NTSB CHI88IA015](https://openairdocs.org/ntsb/CHI88IA015.md): Boeing 737-322 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Oct 29, 1987 · N305UA · 2 aircraft · No damage > The south rwys (32L, 9R, & 4R) were being ctld by the south LCL ctlr (slc) & the north rwys (9L & 4L) were ctld by the north LCL ctlr (nlc). At 1543:26, slc told united flt 973 (Boeing 737) to hold on 32L & expect a 3 min delay bfr tkof. Air Wisconsin flt 954… - [NTSB DEN88LA012](https://openairdocs.org/ntsb/DEN88LA012.md): Beech C35 · Ekalaka, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 1987 · N2028D · Destroyed > During the takeoff roll the pilot encountered an unexpected tailwind. The pilot reported that he tried to abort the takeoff but tall grass and the tailwind did not allow the aircraft to decelerate properly. The aircraft ran through two drainage ditches and… - [NTSB ANC88LA010](https://openairdocs.org/ntsb/ANC88LA010.md): Cessna A185 · Karluk, AK · Accident · No injuries · Limited investigation · Final report · Oct 21, 1987 · N61376 · Substantial damage > The pilot arrived late and the tide had come in at the beach in kanatak bay. By the time he commenced his takeoff attempt, the usable area had diminished considerably. The right main gear caught in the surf and the airplane inverted in the water. - [NTSB SEA88LA006](https://openairdocs.org/ntsb/SEA88LA006.md): Cessna 206 · Winnemucca, NV · Accident · No injuries · Limited investigation · Final report · Oct 14, 1987 · N9040M · Substantial damage > The acft nose gear collapsed during takeoff and the acft nosed over. The plt stated to inspectors that recent maintenance had been performed on the nose gear. Shortly after the accident the acft was locked in a hangar. The plt has failed to file an accident… - [NTSB ANC88LA006](https://openairdocs.org/ntsb/ANC88LA006.md): Cessna 207A · Tin City, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1987 · N91021 · Substantial damage > The pilot stated the wind was a direct crosswind and the velocity was 30 knots gusting to 38 knots. During the take off roll, the airplane lifted off the ground and then settled and ran off the end of the runway. - [NTSB MKC88FA003](https://openairdocs.org/ntsb/MKC88FA003.md): Stinson 108-2 · Wakeeney, KS · Accident · Serious injuries · Field investigation · Final report · Oct 12, 1987 · N448C · Substantial damage > The owner & his son, who were both plts, initiated a midfield takeoff from their pvt dirt airstrip which was on soft uneven terrain. The son rprtd that near the end of the strip, power was 'cut.' The acft contd about 200' beyond the dep end of the strip &… - [NTSB ANC88LA007](https://openairdocs.org/ntsb/ANC88LA007.md): Cessna 170 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Oct 12, 1987 · N1311D · Substantial damage > The plt rprtd there was frost on the acft & that a rope had been used to smooth it off. He then initiated a takeoff from a dry lake bed. After lift-off, the acft settled back to the ground & struck a berm at the end of the takeoff area. - [NTSB NYC88LA003](https://openairdocs.org/ntsb/NYC88LA003.md): Cessna 172H · Oneonta, NY · Accident · No injuries · Limited investigation · Final report · Oct 6, 1987 · N1677F · Destroyed > The plt rprtd he started to depart from rwy 13 with the wind from the south at 15 gusting 25 KTS. He stated the acft was not climbing as expected so he elected to land on the remaining rwy. He stated the wind gusts were strong from the right rear. He said he… - [NTSB ATL88IA074](https://openairdocs.org/ntsb/ATL88IA074.md): Mooney M-20E · Columbia, SC · Incident · No injuries · Incident investigation · Final report · Oct 6, 1987 · N1936Y · Minor damage > During takeoff the propeller studs failed and the propeller departed the acft. FAA incident rpt stated that propeller had been overhauled and replaced 32 hours prior to the separation. Metallurgical exam of the propeller studs revealed fatigue failure of the… - [NTSB LAX88LA005](https://openairdocs.org/ntsb/LAX88LA005.md): Beech A35 · Wickenburg, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1987 · N8583A · Substantial damage > During the takeoff run, the plt realized he had a flt control problem when he was unable to rotate the acft for lift- off. He stated that he contd the takeoff, attempting to overcome the problem with elevator trim. He was unable to establish a climb.… - [NTSB CHI88DEP01](https://openairdocs.org/ntsb/CHI88DEP01.md): Grumman G-44 · Delevan, WI · Accident · Minor injuries · Final report · Oct 1, 1987 · N1173V · Substantial damage > On initial takeoff roll the aircraft experienced a loss of control in a strong crosswind, departed the runway to the left, struck a tree line and over turned. - [NTSB ANC88LA001](https://openairdocs.org/ntsb/ANC88LA001.md): Piper PA-16 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Oct 1, 1987 · N5373H · Substantial damage > The plt stated that during tkof roll he lost directional ctl of the acft which caused it to exit the rwy. It then struck a rwy light and nosed over. - [NTSB NYC87LA237](https://openairdocs.org/ntsb/NYC87LA237.md): Piper PA-28-161 · Stow, MA · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1987 · N4332N · Substantial damage > The pilot was on takeoff roll when he decided to abort. He stated that he felt the engine was not developing adequate power and the airspeed was not up to required takeoff speed. The aircraft continued off the end of the runway and inverted in swampy soil. - [NTSB CHI87LA222](https://openairdocs.org/ntsb/CHI87LA222.md): Cessna 150H · Sparta, WI · Accident · No injuries · Limited investigation · Final report · Sep 27, 1987 · N6469S · Substantial damage > The plt was taking off on his pvt strip in a prevailing 12 kt x-wind that was vrbl & blowing fm a 'lull' to 18 KTS. He said the strip was located near an l-shaped ridge which attenuated the general wind flow. Also, he said the 1900' sod strip sloped downhill… - [NTSB NYC87LA254](https://openairdocs.org/ntsb/NYC87LA254.md): Beech E55 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1987 · N4158A · Substantial damage > Just before lift-off, after the aircraft had accellerated to about 115 mph, the door on the passenger's side came open. The pilot immediately aborted the takeoff, but was unable to stop on the remaining portion of the 2500' runway. After departing the runway,… - [NTSB DEN87LA239](https://openairdocs.org/ntsb/DEN87LA239.md): Cessna 195 · Colorado Sprgs, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1987 · N3006B · Substantial damage > The plt stated that after he lndd to pick up a pax, he engaged the control lock fm habit, but did not shut dwn the eng. He got clnc to taxi back to the rwy & takeoff, but 'forgot to release control lock.' The Cessna 195 has a combination control lock and… - [NTSB CHI87DEC05](https://openairdocs.org/ntsb/CHI87DEC05.md): Willi/Bensen B-8M · Fraser, MI · Accident · No injuries · Final report · Sep 25, 1987 · N2469 · Substantial damage > Deterioration of the internal surface of the fuel tank which led to blockage of the fuel flow and subsequent fuel starvation of the engine. - [NTSB FTW87LA227](https://openairdocs.org/ntsb/FTW87LA227.md): Cessna 152 · Mckinney, TX · Accident · No injuries · Limited investigation · Final report · Sep 24, 1987 · N67439 · Substantial damage > Drg a practice touch-&-go landing, the plt raised the flaps after making a normal lndg & applied full power for a go-around. However, the acft veered off the left side of the rwy & contacted soft ground. Subsequently, the nose gear collapsed & the left wing… - [NTSB CHI87DEX09](https://openairdocs.org/ntsb/CHI87DEX09.md): de Havilland Dragonfly DH-90 · Sellersburg, IN · Accident · Serious injuries · Final report · Sep 22, 1987 · N190DH · Substantial damage > Aircraft began left drift during takeoff roll. Pilot corrected with right rudder, and aircraft veered sharply right. Aircraft did not respond to application of left rudder or increased thrust from right engine; departed runway and crashed into drainage ditch.… - [NTSB ANC87LA163](https://openairdocs.org/ntsb/ANC87LA163.md): Piper PA-18-150 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Sep 22, 1987 · N90947 · Substantial damage > The airplane was substantially damaged after it nosed over during the takeoff roll, but the pilot and his passenger were uninjured. The pilot stated that he had landed at an off-airport site to set up his moose hunting camp and that during a subsequent… - [NTSB MIA87IA256](https://openairdocs.org/ntsb/MIA87IA256.md): Gates Learjet 36A · Tyndall Afb, FL · Incident · No injuries · Incident investigation · Final report · Sep 21, 1987 · N900MD · Minor damage > The captain aborted the takeoff at 124 KTS after hearing an explosive sound, feeling the aircraft swerve, and seeing debris from a main wheel rim and brake being thrown forward of the aircraft. The aircraft continued down the runway, barely controllable and… - [NTSB ANC87LA166](https://openairdocs.org/ntsb/ANC87LA166.md): Cessna 170A · Melozitna River, AK · Accident · No injuries · Limited investigation · Final report · Sep 21, 1987 · N9240A · Substantial damage > The pilot attempted to takeoff from a River sandbar close to the water's edge. During the take off roll, one main landing gear tire entered the water and pulled the airplane into the water. The airplane subsequently nosed over and incurred substantial damage. - [NTSB ANC87LA164](https://openairdocs.org/ntsb/ANC87LA164.md): Interstate S-1B2 · Beluga River, AK · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N50AA · Substantial damage > The pilot landed on a small lake, decided it was too small and attempted to take off. He was unable to attain lift off speed prior to striking the opposite bank with his floats and subsequently damageing the airplane. - [NTSB ANC87LA169](https://openairdocs.org/ntsb/ANC87LA169.md): Cessna 185 · Wind River, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 1987 · N1050F · Substantial damage > The pilot and his passenger had camped over night on a gravel bar on the Wind River. On departure the following day, the airplane failed to become airborne prior to reaching the end of the gravel bar. The airplane entered the shallow water surrounding the… - [NTSB ANC87LA147](https://openairdocs.org/ntsb/ANC87LA147.md): Cessna 170B · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1987 · N3410D · Substantial damage > The pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to nose over. He also indicated that the private strip was new and that the dirt rwy was wet and soft. - [NTSB SEA87LA183](https://openairdocs.org/ntsb/SEA87LA183.md): Cessna 182A · Star, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 7, 1987 · N4944D · Minor damage > The aircraft was to the left of the centerline during takeoff run on the 60 foot wide airstrip. A cross wind was present from the right. The aircraft's left wing struck a person standing close to the runway edge. The pilot stated that he had his eyes on his… - [NTSB ANC87LA148](https://openairdocs.org/ntsb/ANC87LA148.md): Piper PA-18 · Gold King, AK · Accident · No injuries · Limited investigation · Final report · Sep 7, 1987 · N1265A · Substantial damage > The pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to exit the strip into a row of trees. - [NTSB ANC87LA141](https://openairdocs.org/ntsb/ANC87LA141.md): Champion 7GCBC · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Sep 6, 1987 · N8CK · Substantial damage > The pilot attempted to take off from an unimproved site while the inside of the airplane's windows were partially obscured with condensation. The airplane struck a rock with its main gear during the take off roll and became prematurely airborne. The pilot… - [NTSB ANC87FA140](https://openairdocs.org/ntsb/ANC87FA140.md): Lake LA-4-200 · Coal Lake, AK · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1987 · N39450 · Destroyed > The pilot of the airplane stated that he had step-taxied to the east end of the Lake in preparation for a takeoff to the west. During the take off run, the airplane struck the wake he had just created and became prematurely airborne. He reduced power in an… - [NTSB CHI87LA207](https://openairdocs.org/ntsb/CHI87LA207.md): Cessna 150L · Ludington, MI · Accident · No injuries · Limited investigation · Final report · Sep 3, 1987 · N7502G · Substantial damage > Drg the takeoff roll, the acft went off the left side of the rwy. The student rprtd the takeoff roll seemed normal untilrotation, but when the nose wheel lifted off the rwy, the acft began to veer to the left. He stated he was unable to correct the situation… - [NTSB ANC87LA134](https://openairdocs.org/ntsb/ANC87LA134.md): Piper PA-18 · Kwethluk, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1987 · N7233K · Substantial damage > The pilot stated that he was flying a search and rescue mission for a missing aircraft when he noticed that his airspeed indicator was not working. He landed on a lake in gusty wind conditions to correct the problem. During the ensuing takeoff attempt, a gust… - [NTSB CHI87LA206](https://openairdocs.org/ntsb/CHI87LA206.md): Cessna 152 · Phillips, WI · Accident · No injuries · Limited investigation · Final report · Aug 30, 1987 · N67795 · Substantial damage > During the takeoff phase of a touch and go landing the student pilot lost directional control of the aircraft. The aircraft exited the runway to the left, struck a ditch and overturned. The student's instructor, who was a witness to the accident states that… - [NTSB SEA87LA177](https://openairdocs.org/ntsb/SEA87LA177.md): Canton Rutan Long · Port Townsend, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 1987 · N252BC · Substantial damage > During takeoff roll the pilot noted sluggish rotation performance and retarded the throttle to abort the takeoff. When he reduced power the aircraft rotated. He reapplied full power and abrupt aft stick, to execute rapid rotation and lift off. The hand grip… - [NTSB MKC87LA168](https://openairdocs.org/ntsb/MKC87LA168.md): Grumman G-164B · Holly Grove, AR · Accident · No injuries · Limited investigation · Final report · Aug 26, 1987 · N8365K · Substantial damage > The pilot lost control on takeoff roll, ran off the side of the runway and impacted a dirt bank. The aircraft came to rest in an inverted position. Investigation revealed no preimpact mechanical malfunctions/failures. - [NTSB LAX87LA314](https://openairdocs.org/ntsb/LAX87LA314.md): Cessna 172N · Temple Bar, AZ · Accident · No injuries · Limited investigation · Final report · Aug 25, 1987 · N733TA · Destroyed > The stall warning horn sounded during climbout following a touch-and-go landing. Rising terrain was reported beyond the end of the runway and the pilot was unable to continue to climb while maintaining a safe airspeed. The density altitude was approximately… - [NTSB BFO87LA058](https://openairdocs.org/ntsb/BFO87LA058.md): Beech D50C · Somerville, VA · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1987 · N81CA · Substantial damage > The nose gear prematurely retracted and the props contacted the gravel runway during the takeoff initial climb. The plt attempted to continue the takeoff and the acft settled into trees off the departure end of the rwy. Post-accident inspection failed to… - [NTSB DEN87DTI01](https://openairdocs.org/ntsb/DEN87DTI01.md): Cessna A188B · Basin, WY · Accident · No injuries · Final report · Aug 22, 1987 · N72414 · Substantial damage > The plt was taking off on a private, 2300 ft, dirt, ag strip with a load of chemicals. The arpt elev was 4185 ft & the rprtd temp was 74 deg. The plt said the wind was calm when he began his takeoff roll, but about 3/4 of the way down the rwy, the acft… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?year=1987&page=2 ## 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 year(c."eventDate") = 1987 AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?year=1987 --- 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.