# NTSB investigations, 1987: Landing 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 14 · 699 cases ## Latest cases - [NTSB NYC88LA061](https://openairdocs.org/ntsb/NYC88LA061.md): Cessna 172 · Concord, NH · Accident · No injuries · Limited investigation · Final report · Dec 31, 1987 · N5383R · Substantial damage > The aircraft was landing at Concord municipal airport, and during landing roll, the aircraft veered to the left leaving the runway surface and nosed over in the field between the taxiway and runway 35. - [NTSB CHI88LA038](https://openairdocs.org/ntsb/CHI88LA038.md): Cessna 210-5 · East Lansing, MI · Accident · No injuries · Limited investigation · Final report · Dec 31, 1987 · N1802Z · Substantial damage > The aircraft was landed at night on runway 9 which is 2530' in length with a 600' displaced threshold. This runway was ice covered and winds were recorded 25 minutes before the accident at a reporting facility 5 nautical miles west of the accident site as 160… - [NTSB DEN88FA044](https://openairdocs.org/ntsb/DEN88FA044.md): Swearingen SA-26AT · Telluride, CO · Accident · Serious injuries · Field investigation · Final report · Dec 30, 1987 · N4468M · Substantial damage > During a visual apch, the plt said he encountered 2000 fpm downdrafts. The plt stated he added power and executed a normal apch at 120 KTS, compensating for downdrafts/crosswinds. After touchdown, the plt said he did not get a beta light on the right eng. He… - [NTSB SEA88LA033](https://openairdocs.org/ntsb/SEA88LA033.md): Cessna 182C · Las Vegas, NV · Accident · 1 fatal · Limited investigation · Final report · Dec 29, 1987 · N8819T · Destroyed > The aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to… - [NTSB LAX88LA081](https://openairdocs.org/ntsb/LAX88LA081.md): Cessna 172M · Banning, CA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1987 · N12943 · Substantial damage > During a pleasure flight while on final approach, aprx 10 ft above the rwy, the acft suddenly dropped and bounced on the rwy. After a nearby rain storm passed over the area, the acft was flown to the home base. Several days later, the operator discovered… - [NTSB FTW88LA043](https://openairdocs.org/ntsb/FTW88LA043.md): Cessna 150 · Woodworth, LA · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1987 · N5719G · Substantial damage > The plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose… - [NTSB MIA88NA070](https://openairdocs.org/ntsb/MIA88NA070.md): McDonnell Douglas DC-9-31 · Pensacola, FL · Accident · Minor injuries · Final report · Dec 28, 1987 · N8948E · Substantial damage - [NTSB DEN88IA043](https://openairdocs.org/ntsb/DEN88IA043.md): Mcdonnell Douglas MD-80 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Dec 27, 1987 · N72830 · Minor damage > During landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of… - [NTSB MKC88LA034](https://openairdocs.org/ntsb/MKC88LA034.md): Luscombe 8-A · Chillicothe, MO · Accident · No injuries · Limited investigation · Final report · Dec 26, 1987 · N71288 · Substantial damage > During a ldg attempt, acft touched down and swerved abruptly. Loss of control was experienced by PIC, and acft made a 180 degree turn on the runway. PIC stated the brakes may have been frozen, as he had taxied thru standing water during departure. - [NTSB CHI88LA036](https://openairdocs.org/ntsb/CHI88LA036.md): Cessna 150M · Redwood Falls, MN · Accident · No injuries · Limited investigation · Final report · Dec 26, 1987 · N704XX · Substantial damage > Wind was 210 degrees at 13 knots when the student pilot attempted a landing on snow compacted runway 12. The student stated that a gust of wind pushed the aircraft sideways and it struck a snowbank when it exited the runway to the left. - [NTSB CHI88LA034](https://openairdocs.org/ntsb/CHI88LA034.md): Cessna 172K · Staunton, IL · Accident · No injuries · Limited investigation · Final report · Dec 22, 1987 · N78705 · Substantial damage > During the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot… - [NTSB MKC88LA031](https://openairdocs.org/ntsb/MKC88LA031.md): Sonerai 2L · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · Dec 21, 1987 · N502WM · Substantial damage > While practicing take offs and ldgs, PIC lost directional control during rollout. He added power and struck a snowbank just after becoming airborne during running takeoff. - [NTSB FTW88FA039](https://openairdocs.org/ntsb/FTW88FA039.md): Aerospatiale SA-330J · Eugene Island · Accident · 15 fatal · Field investigation · Final report · Dec 21, 1987 · N3596N · Destroyed > The helicopter, with 2 plts & 13 passengers, was on an IFR flt to a psn in the gulf of Mexico. From that psn, they proceeded under VFR to an off-shore oil drilling rig (EI-190). As the helicopter was arriving from the se, there was a strong wind from the NE.… - [NTSB DEN88LA039](https://openairdocs.org/ntsb/DEN88LA039.md): Piper PA-38-112 · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Dec 19, 1987 · N23497 · Substantial damage > While practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.… - [NTSB MIA88LA066](https://openairdocs.org/ntsb/MIA88LA066.md): Cessna A188B · South Bay, FL · Accident · No injuries · Limited investigation · Final report · Dec 18, 1987 · N731LS · Substantial damage > The plt attempted a landing on a narrow runway, on an embankment. The airplane swerved to the left, into a crosswind, and left the rwy. The right main ldg gear collided with a boulder; the airplane nosed over and came to rest in the water. - [NTSB MIA88LA064](https://openairdocs.org/ntsb/MIA88LA064.md): Beech 95-C55 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Dec 15, 1987 · N707CC · Substantial damage > While on a personal flt after the plt lowered the landing gear for landing, the left main landing gear did not extend. The plt continued the apch, & after touchdown, the acft veered off the rwy, collided with trees, then came to rest. According to FAA… - [NTSB ATL88LA064](https://openairdocs.org/ntsb/ATL88LA064.md): Cessna 150G · Grantham, NC · Accident · No injuries · Limited investigation · Final report · Dec 13, 1987 · N6258S · Substantial damage > The airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time. - [NTSB MIA88LA061](https://openairdocs.org/ntsb/MIA88LA061.md): Piper PA-18-150 · Fellsmere, FL · Accident · No injuries · Limited investigation · Final report · Dec 12, 1987 · N80BJ · Substantial damage > While on a business flt over the company's property the plt elected to land the acft on a 40 foot wide dirt road. After touchdown the acft drifted off the left side of the road, due in part, to a crosswind. The left wing collided with a tree. - [NTSB ATL88LA063](https://openairdocs.org/ntsb/ATL88LA063.md): Cessna 150K · Portland, TN · Accident · No injuries · Limited investigation · Final report · Dec 12, 1987 · N5995G · Substantial damage > The student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,… - [NTSB ATL88LA062](https://openairdocs.org/ntsb/ATL88LA062.md): Cessna 172P · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Dec 11, 1987 · N52701 · Substantial damage > At 1343 EST, the student plt contacted apch ctl & asked for lndg info. He was adzd to continue VFR for rwy 31. When he contacted the tower at 1347, the wind was fm 200 deg at 13 KTS. Tower psnl gave him the choice of rwy 31 or 28L; he elected to lnd on rwy… - [NTSB SEA88LA082](https://openairdocs.org/ntsb/SEA88LA082.md): Cessna TU206G · Silverdale, WA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1987 · N4953Z · Substantial damage > While on the lndg roll with a qtrg hdwnd, the acft enctrd a gust which pushed it to the left. The plt said he applied full rgt aileron, but it had no effect. As the acft was 'being blown' toward trees, the plt applied full rgt brake. He said the left wing tip… - [NTSB MIA88FA058](https://openairdocs.org/ntsb/MIA88FA058.md): Embraer EMB 120 · Columbus, MS · Accident · No injuries · Field investigation · Final report · Dec 10, 1987 · N232AS · Substantial damage > The acft landed gear up while on a training flight, the crew stated that they had completed 2 hours of training when the first officer requested a single engine no flap approach demonstration. Both pilots stated that during this demonstration they neglected… - [NTSB ATL88LA058](https://openairdocs.org/ntsb/ATL88LA058.md): Ercoupe 415-C · Marlboro, OH · Accident · No injuries · Limited investigation · Final report · Dec 10, 1987 · N87102 · Substantial damage > The student plt rptd that he flew a flat final apch to remain clear of trees. The airspeed began to drop, and the airplane subsequently landed hard after clearing the trees. - [NTSB NYC88LA055](https://openairdocs.org/ntsb/NYC88LA055.md): Mitsubishi MU-2B-20 · White Plains, NY · Accident · No injuries · Limited investigation · Final report · Dec 7, 1987 · N866Q · Substantial damage > The cross country business flight was uneventful from concord, new hampshire to White Plains, new york under clear sky. During final approach, the pilot extended the gear but did not notice that the circuit breaker had opened and the gear was not lowered. The… - [NTSB CHI88LA033](https://openairdocs.org/ntsb/CHI88LA033.md): Cessna 152 · Lincoln, IL · Accident · No injuries · Limited investigation · Final report · Dec 6, 1987 · N757KW · Substantial damage > The plt returned to the arpt after dark & noted there was an excessive x-wind for the active rwy. He elected to land on the unlighted grass rwy (rwy 14) which was aligned more favorably with the wind. He thought that on final apch, he had aligned the acft… - [NTSB ANC88DAG01](https://openairdocs.org/ntsb/ANC88DAG01.md): Cessna 207A · Atmautluak, AK · Accident · No injuries · Final report · Dec 6, 1987 · N73503 · Substantial damage > The aircraft was on final approach when a vehicle appeared to be on the runway coming at the aircraft. The pilot pulled the aircraft up over the snow machine but settled back to the ground alongside the runway. - [NTSB MIA88LA054](https://openairdocs.org/ntsb/MIA88LA054.md): Cessna 310F · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Dec 5, 1987 · N317L · Substantial damage > The plt stated that he had made three touch & go landings & on the fourth landing, while on rollout, the left main gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed that the left main gear downlock rod… - [NTSB MIA88LA053](https://openairdocs.org/ntsb/MIA88LA053.md): Beech C-45H · Miami, FL · Accident · No injuries · Limited investigation · Final report · Dec 4, 1987 · N4209V · Substantial damage > While practicing short field landings the plt flared the acft for landing after which it stalled, descended right wing low, then crashed onto the rwy. The acft then touched down on the nose landing gear causing it to collapse, & slid off the rwy. - [NTSB MIA88IA052](https://openairdocs.org/ntsb/MIA88IA052.md): Beech 58 · Vicksburg, MS · Incident · No injuries · Incident investigation · Final report · Dec 3, 1987 · N3012W · Minor damage > While on a part 135 on-demand domestic passenger flt, the acft landed gear up. The plt stated that he forgot to lower the landing gear. There was no mechanical failure or malfunction. - [NTSB ATL88LA051](https://openairdocs.org/ntsb/ATL88LA051.md): Cessna 172F · Eden, NC · Accident · No injuries · Limited investigation · Final report · Dec 2, 1987 · N8674U · Substantial damage > The student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's… - [NTSB MIA88LA048](https://openairdocs.org/ntsb/MIA88LA048.md): Cessna 172K · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Nov 29, 1987 · N84613 · Substantial damage > The pvt plt flying the acft for the first time from the rt seat landed it aprx 170 ft short of the runway on soft grass. The acft rolled 6-10 ft, after which the nose gear sank & the acft then nosed over & came to rest inverted. - [NTSB MIA88LA047](https://openairdocs.org/ntsb/MIA88LA047.md): Cessna 210 · Quincy, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1987 · N9492T · Substantial damage > The plt stated that he performed a prelanding check on final apch but failed to lower the landing gear. He continued the apch, & just prior to touchdown, was advised that the gear was not down. The apch to landing was continued & the acft slid to a stop. He… - [NTSB DEN88LA032](https://openairdocs.org/ntsb/DEN88LA032.md): Cessna 180 · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Nov 28, 1987 · N6547A · Substantial damage > During a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and… - [NTSB MIA88LA045](https://openairdocs.org/ntsb/MIA88LA045.md): Mooney M-22 · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Nov 26, 1987 · N7739M · Substantial damage > Plt stated that on landing roll at approximately 30 to 35 knots the nose landing gear began to shimmy and turn to the left. Full right brake and rudder could not correct the left turning tendency of the aircraft. The aircraft ran off the left side of the… - [NTSB LAX88LA056](https://openairdocs.org/ntsb/LAX88LA056.md): Cessna 172N · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1987 · N75825 · Substantial damage > A Cessna 172N veered off runway 30. The pilot reported that a gust of wind lifted the left wing resulting in the right wing scraping the runway surface. The airplane subsequently ground looped to the right and departed the runway. The winds were reported to… - [NTSB SEA88LA022](https://openairdocs.org/ntsb/SEA88LA022.md): Hughes 269B · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 1987 · N22730 · Destroyed > During practice autorotation the pilot flared excessively high and the tail boom struck the ground. The pilot then lost control of the aircraft. The density alt was 2616 feet. A rt quartering tailwind was present. - [NTSB NYC88LA044](https://openairdocs.org/ntsb/NYC88LA044.md): Bell 206B · Beverly, MA · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 1987 · N3888Q · Substantial damage > The helicopter was on a normal approach to Beverly airport and was cleared to cross runway 27 from the southeast. The pilot entered an autorotation but realized that the ground was under construction and was very muddy. In an attempt to shift directions at… - [NTSB ATL88LA045](https://openairdocs.org/ntsb/ATL88LA045.md): Cessna 150M · Waynesboro, GA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1987 · N4081V · Substantial damage > The student plt lost control of the airplane while landing, during his second supervised-solo flt. The airplane veered off of the rwy into a ditch where the nosegear collapsed and the airplane nosed over. The wind was reportedly calm. - [NTSB NYC88LA039](https://openairdocs.org/ntsb/NYC88LA039.md): Waco ZKC-5 · No. Canaan, CT · Accident · No injuries · Limited investigation · Final report · Nov 23, 1987 · N14164 · Substantial damage > The aircraft touched down in a 3-point landing attitude at north Canaan, Connecticut. The left landing gear wheel rotated 90 degrees and the left gear was dragged 144 yards before the aircraft became inverted. It was revealed that the braze joint at the top… - [NTSB DEN88LA027](https://openairdocs.org/ntsb/DEN88LA027.md): Piper PA-24-180 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Nov 23, 1987 · N7291P · Substantial damage > The private pilot was flying to build time. After an hour of flight, the plt returned to the home airport and attempted to land. Landing gear would not extend properly and manual gear extension did not help. All gear was partially extended and would not… - [NTSB FTW88IA029](https://openairdocs.org/ntsb/FTW88IA029.md): Mcdonnell Douglas DC-10-10 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Nov 22, 1987 · N121AA · No damage > Immediately after the hard landing the captain was observed by the copilot and flight engineer to be incapacitated. The copilot took control of the airplane and guided it onto a high speed taxiway. With the aid of a flight attendant and the flight engineer… - [NTSB LAX88LA055](https://openairdocs.org/ntsb/LAX88LA055.md): Cessna 172N · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Nov 21, 1987 · N9568G · Substantial damage > At the conclusion of a cross country instructional flight, the pilot made three approaches to land. On the first two attempts, the aircraft touched down on the nose wheel and porpoised, then the pilot initiated a go-around. On the third landing, the aircraft… - [NTSB CHI88LA030](https://openairdocs.org/ntsb/CHI88LA030.md): Cessna 337 · Kankakee, IL · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 1987 · N6255F · Substantial damage > The pilot was attempting to land on runway 22 at an uncontrolled airport when he heard another pilot transmit he was about to depart from the same runway. According to the pilot, while he was turning on to final approach, he observed an aircraft taxiing to… - [NTSB MIA88LA043](https://openairdocs.org/ntsb/MIA88LA043.md): North American 500 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Nov 20, 1987 · N4111P · Substantial damage > While on a part 135 non-scheduled domestic passenger flt in VFR conditions, the plt landed the acft gear up. Operational check of the landing gear & warning horn revealed no failure or malfunction. - [NTSB FTW88LA030](https://openairdocs.org/ntsb/FTW88LA030.md): Cessna 185 · Burnet, TX · Accident · No injuries · Limited investigation · Final report · Nov 20, 1987 · N7370H · Substantial damage > During landing roll, the aircraft drifted to the left of the runway centerline. Witnesses then observed the aircraft veer to the right and ground loop coming to rest off the end of the runway. Attempts to contact the student plt have not been successful. - [NTSB ANC88LA017](https://openairdocs.org/ntsb/ANC88LA017.md): Cessna 208 · Atmautluak, AK · Accident · No injuries · Limited investigation · Final report · Nov 18, 1987 · N9370F · Substantial damage > The pilot stated that he landed at a distance approximately one-third of the way down the 2,000 foot ice covered gravel runway. After touchdown the pilot lost directional control of the aircraft causing the aircraft to exit the departure end of the runway.… - [NTSB NYC88LA040](https://openairdocs.org/ntsb/NYC88LA040.md): Cessna 210 · Schenectady, NY · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N9568T · Substantial damage > During landing, the left main gear collapsed. A metallurgical examination revealed that the left main gear saddle assembly was fractured into three pieces through the area near the forward edge of the landing gear strut. When examined further, the faces and… - [NTSB NYC88LA038](https://openairdocs.org/ntsb/NYC88LA038.md): Grumman AA-1B · Tewksbury, MA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N8993L · Substantial damage > The student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,… - [NTSB LAX88LA048](https://openairdocs.org/ntsb/LAX88LA048.md): Beech 58 · Jackson, CA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N9106Q · Substantial damage > The plt rprtd that prior to reaching the destn, he received an adzy on the UNICOM freq that rwy 19 was in use & that there was a direct x-wind. Drg arrival, he tried to contact UNICOM again to get a wx update, but was unable. He elected to lnd on rwy 19.… - [NTSB CHI88LA023](https://openairdocs.org/ntsb/CHI88LA023.md): Cessna A150K · Elkhart, IN · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N8382M · Substantial damage > The plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any… Next page: https://openairdocs.org/ntsb-phases/550/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 = 550) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/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.