# NTSB investigations, 1987: Standing 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 2 · 53 cases ## Latest cases - [NTSB DEN88LA045](https://openairdocs.org/ntsb/DEN88LA045.md): Raven Rally RX7 · Dona Ana, NM · Accident · No injuries · Limited investigation · Final report · Dec 30, 1987 · N40364 · Substantial damage > The commerical plt was conducting a sightseeing flight in his balloon. After a one and one half hour flight, he landed beside a paved road. The envelope collapsed over a power line. The ground crewman somehow contacted the balloon and was electrically… - [NTSB LAX88LA074](https://openairdocs.org/ntsb/LAX88LA074.md): Piper PA-32R-300 · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1987 · N75397 · 2 aircraft · Substantial damage > While taxiing after landing, N911E was instructed to taxi to a position and hold, en route to that position, the acft collided with N75397 that was also holding in the same position. The plt of N911E stated that he did not see the acft due to moisture that… - [NTSB NYC88LA058](https://openairdocs.org/ntsb/NYC88LA058.md): Cessna 182 · Hammonton, NJ · Accident · No injuries · Limited investigation · Final report · Dec 19, 1987 · N3041Y · Destroyed > The aircraft had taxied to the runup area and during this process of engine runup, the pilot stated that the engine was running rough on one magneto but smooth on the other. The carburetor mixture was leaned but the engine quit. When an attempt to restart was… - [NTSB MKC88LA029](https://openairdocs.org/ntsb/MKC88LA029.md): Piper PA-28-140 · Osceola, AR · Accident · No injuries · Limited investigation · Final report · Dec 16, 1987 · N1595J · Destroyed > The airplane was being jump-started from an automobile. The flight instructor left for some equipment when the student called him back and said there was smoke in the cabin. The airplane started to burn and was demolished. The student stated there was a… - [NTSB MKC88FA028](https://openairdocs.org/ntsb/MKC88FA028.md): Aero Commander 680FL · Kansas City, MO · Accident · No injuries · Field investigation · Final report · Dec 16, 1987 · N6509V · 2 aircraft · Substantial damage > At 2108:57 ea flt 275(EA275) a Boeing 727, was cleared to takeoff on runway 19 and at 2110:24 N6509V, an Aero Commander,was cleared to taxi into position and hold. N6509V entered runway 19 near mid-field at taxiway A-3 without advising the tower of his intent… - [NTSB ATL88LA065](https://openairdocs.org/ntsb/ATL88LA065.md): Grumman American AA-5 · Elizabethtown, KY · Accident · No injuries · Limited investigation · Final report · Dec 16, 1987 · N7151L · Substantial damage > After a short stop btn flts, the battery was too weak to crank the eng. The plt elected to hand-prop the eng while his non-rated pax held the brakes. He briefed the pax on the proper procedure. He had previously allowed the pax to operate the brakes while… - [NTSB MKC88LA024](https://openairdocs.org/ntsb/MKC88LA024.md): Cessna 182Q · Coffeyville, KS · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 1987 · N735SV · Substantial damage > While trying to start the acft with a low battery, PIC exited the acft and pulled the propeller one quarter of a turn to get it past the compression cycle. Engine started with pax aboard and proceeded to taxi. PIC was unable to stop the acft, and pax, after… - [NTSB MKC88IA025](https://openairdocs.org/ntsb/MKC88IA025.md): Bell 206L-3 · Little Rock, AR · Incident · Minor injuries · Incident investigation · Final report · Dec 10, 1987 · N86CH · Destroyed > An EMS helo was consumed in a fire while parked at a hospital heliport. The helo had recently returned fm a medevac flt and the on-board patient oxygen pressure was low. Two respiratory therapists participated in refilling the system after the flt. The system… - [NTSB DEN88LA034](https://openairdocs.org/ntsb/DEN88LA034.md): Cessna 177RG · Great Falls, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 6, 1987 · N8035G · Minor damage > The private plt was preparing for departure on an IFR flight plan. After finding that the starter would not operate properly, the plt tried to manually repositon the propeller. The ignition was still on and the engine fired. The propeller struck the plt's… - [NTSB SEA88LA027](https://openairdocs.org/ntsb/SEA88LA027.md): Cessna 172M · Tacoma, WA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1987 · N9134H · 2 aircraft · Substantial damage > The Cessna was at the runup area for runway 35 preparing to do his runup. Three pitts aircraft were taxiing abreast of each other, when one of the pitts's propeller struck the right wingtip of the Cessna causing substantial damage to the Cessna and minor… - [NTSB LAX88FA057](https://openairdocs.org/ntsb/LAX88FA057.md): Boeing 737-387 · Los Angeles, CA · Accident · Serious injuries · Field investigation · Final report · Nov 25, 1987 · N383AU · No damage > The Boeing 737-387, N383AU, operating as usair flt 20, a regularly scheduled domestic flight, returned to lax shortly after takeoff, when the capt was advised of a bomb threat. After landing on rwy 24L, the capt parked the airplane on the west end of the rwy.… - [NTSB FTW88LA031](https://openairdocs.org/ntsb/FTW88LA031.md): Cessna 150 · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1987 · N6463F · Substantial damage > The pilot was attempting to start the unsecured aircraft by hand-propping it. The aircraft started and rolled forward striking a fuel truck, damaging the left wing, fuselage, and propeller. - [NTSB MIA88LA037](https://openairdocs.org/ntsb/MIA88LA037.md): Mandley Steen Skybolt · Placida, FL · Accident · No injuries · Limited investigation · Final report · Nov 16, 1987 · N44JM · Destroyed > When attempting to start the eng the plt heard it backfire & then observed smoke coming from under the eng cowling. He then immediately exited the acft & left the scene to summon the fire department. He later returned to find the aircraft consumed by fire.… - [NTSB ATL88IA036](https://openairdocs.org/ntsb/ATL88IA036.md): Lockheed L-188C · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Nov 14, 1987 · N861U · Minor damage > After two aborted takeoffs for a RPM fluctation problem at takeoff pwr, the crew retd to the cargo ramp. They parked the acft, with engines running, adjacent to the gnd pwr cart used for starting the engines. The pwr cart had been left unattended with the… - [NTSB NYC88LA056](https://openairdocs.org/ntsb/NYC88LA056.md): Piper PA-28R-201 · Beaver Falls, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1987 · N8364N · No damage > During hand-propping of Piper PA-28R, the passenger slipped and fell into the turning prop. He received a serious head injury. - [NTSB MIA88LA033](https://openairdocs.org/ntsb/MIA88LA033.md): Piper PA-23-250 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 1987 · N5086Y · Destroyed > Plt stated that shortly after starting the left engine he heard an explosion and saw flame spreading from the accessory area of the left engine toward the left wing tip and the cabin. He shut down the engine by turning off the magnetos and he and his… - [NTSB CHI88LA021](https://openairdocs.org/ntsb/CHI88LA021.md): Piper PA-28-161 · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Nov 7, 1987 · N8253E · 2 aircraft · Substantial damage > The plt of north American P-51D, N6341T, was southbound on twy alpha as the plt of Piper PA-28 cherokee, N8253E, taxied from the run-up area to the hold line for rwy 33, which was near the intxn of twys alpha & india. The plt of the tail- wheel equipped P-51… - [NTSB LAX88DUQ01](https://openairdocs.org/ntsb/LAX88DUQ01.md): Stits Elkins 85 · Camarillo, CA · Accident · 1 fatal · Final report · Oct 25, 1987 · N72P · Substantial damage > During the starting procedures for a local flight, the pilot had chocked the wheels and was hand-propping the engine. After several tries, the engine started. The airplane jumped the chocks and the pilot moved to the right wing, attempting to stop the… - [NTSB LAX88LA035](https://openairdocs.org/ntsb/LAX88LA035.md): Piper PA-22-160 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Oct 18, 1987 · N8779D · Substantial damage > The pilot reported that the engine would not start by pressing the starter so he decided to hand prop the engine. After several attempts the engine finally started. The engine immediately increased power and the aircraft jumped the chocks. The non-pilot… - [NTSB MIA88LA010](https://openairdocs.org/ntsb/MIA88LA010.md): Beech A-90 · Ft Lauderdale, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1987 · N601TA · Substantial damage > After the plt placed the master switch on to start the engines the landing gear collapsed. He stated that the passenger, in the co-plt seat, bumped the landing gear handle into the up position. The passenger stated that he did not. Insp of the acft revealed… - [NTSB MIA87LA265](https://openairdocs.org/ntsb/MIA87LA265.md): CASA 212-200 · San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 1987 · N436CA · No damage > The co-plt was helping the passengers de-plane while the plt remained in the acft with the engines winding down after shutdown. The plt stated that he observed a commotion outside the acft and shortly thereafter exited it. He then realized that an individual,… - [NTSB NYC87LA266](https://openairdocs.org/ntsb/NYC87LA266.md): Cessna 152 · Bridgeport, CT · Accident · No injuries · Limited investigation · Final report · Sep 29, 1987 · N93193 · Substantial damage > The plt of Cessna 152, N93193, taxied for takeoff with the intentions of using rwy 24. At about the same time, a navy H-53 (Sikorsky) helicopter entered a pattern to land on rwy 24. With the heavy helicopter apchg to land, the Cessna plt accepted an offer to… - [NTSB NYC87LA271](https://openairdocs.org/ntsb/NYC87LA271.md): Piper PA-28-180 · Waynesburg, PA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N9122J · Substantial damage > The pilot said he flooded the engine of the Piper PA-28-180 and decided to pull the prop through a couple of times by hand. He said he thought he had turned the mags off, pulled the mixture to idle cut-off, and set the parking brake. When he had pulled the… - [NTSB ATL87LA254](https://openairdocs.org/ntsb/ATL87LA254.md): Aerostar 600 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Sep 11, 1987 · N8073J · 2 aircraft · Substantial damage > The scheduled domestic all cargo flt was taxiing from the ramp to the rwy behind another company acft when the plt suddenly realized that the lead acft was not moving. The plts attempts to stop the acft were not successful. The stopped acft was substantially… - [NTSB NYC87LA256](https://openairdocs.org/ntsb/NYC87LA256.md): Cessna 310N · Williamsport, PA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1987 · N4166Q · Substantial damage > After landing, the cargo was unloaded & the acft was prepared for departure. The plt stated the preflight was normal & satisfactory. He rprtd that when the left eng was started, he heard a loud 'pop' & observed 'flame traces and smoke.' He immediately shut… - [NTSB ATL87LA252](https://openairdocs.org/ntsb/ATL87LA252.md): Bell 47G-2A · Mc Intosh, AL · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 1987 · N1200W · Destroyed > The helicopter was being used to set fires to burn off underbrush in a commercial forest prior to cutting of trees. The plt landed the helicopter on a mobile transport trailer at the completion of the day's work. The helicopter engine had been shut off and… - [NTSB CHI87IA201](https://openairdocs.org/ntsb/CHI87IA201.md): Mcdonnell Douglas DC-8-71 · Chicago, IL · Incident · Minor injuries · Incident investigation · Final report · Sep 3, 1987 · N8078U · No damage > Smoke detected in the cabin resulted in an evacuation of the aircraft just after being pushed back from the jet-way. Subsequent investigation established that a malfunctioning pack valve had caused the air-conditioning system to overheat causing the smoke.… - [NTSB SEA87LA167](https://openairdocs.org/ntsb/SEA87LA167.md): Luscombe 8A · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Aug 17, 1987 · N2507K · Substantial damage > Due to a low battery charge, the plt elected to hand prop the acft to start the eng. He rprtd the eng became flooded, so he shut off the mags & opened the throttle, to clear the eng while hand turning the prop. He then turned on the master sw & mags, but… - [NTSB BFO87FA053](https://openairdocs.org/ntsb/BFO87FA053.md): Boeing 747-200B · Washington, DC · Accident · 1 fatal · Field investigation · Final report · Aug 11, 1987 · JA182 · No damage > A flight attendant fell from the acft during opening of the L5 door. The f/a was helping a company ground person, who was outside on the boarding step. The boarding step was not against the acft but about 1 ft away from it. When the door was opened, the f/a… - [NTSB CHI87FA185](https://openairdocs.org/ntsb/CHI87FA185.md): Cessna 120 · Oshkosh, WI · Accident · Serious injuries · Field investigation · Final report · Aug 5, 1987 · N76249 · No damage > The plt was taxiing out of the antique/classic camping area at Oshkosh with the assistance of wing walkers when he stopped to permit the pax (his wife) to perform an errand. The pax deplaned & went under the outer 1/3 of the wing strut, then walked back into… - [NTSB LAX87LA288](https://openairdocs.org/ntsb/LAX87LA288.md): Luscombe 8A · Selma, CA · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N1017K · Substantial damage > A Luscombe 8A collided with two parked airplanes after a hand propped start. The student pilot started the aircraft engine without the brakes set, with no chocks, and with no one in the cockpit. Once the engine started, the aircraft subsequently collided with… - [NTSB DEN87LA189](https://openairdocs.org/ntsb/DEN87LA189.md): Aerospatiale SA316B · Red Lodge, MT · Accident · No injuries · Limited investigation · Final report · Jul 19, 1987 · N48184 · Substantial damage > The plt said he was getting ready to take off from a 9400-FT MSL landing zone a top a mountain 7 mi ssw of Red Lodge, MT. The plat said the helicopter was positioned on a slight north-south slope and pointed towards the west. The wind was from the south… - [NTSB MIA87LA202](https://openairdocs.org/ntsb/MIA87LA202.md): Piper PA-28 · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1987 · N6852J · Substantial damage > A us customs blackhawk helicopter intercepted the acft after mistakenly identifing it as a suspected drug smuggling acft. After the acft landed at a gliderport on the edge of the everglades, the helicopter swooped down in the vicinity of the acft & blew it… - [NTSB LAX87FA257](https://openairdocs.org/ntsb/LAX87FA257.md): Beech A60 · Santa Rosa, CA · Accident · 2 fatal · Field investigation · Final report · Jul 7, 1987 · N7485D · Destroyed > Pilot's failure to maintain adequate airspeed on final approach which resulted inthe aircraft stalling. - [NTSB BFO87LA045](https://openairdocs.org/ntsb/BFO87LA045.md): Beech A23-19 · Cambridge, MD · Accident · No injuries · Limited investigation · Final report · Jul 6, 1987 · N5775V · Substantial damage > When the aircraft failed to start the pilot set the throttle, insured the aircraft was tied down and attempted to start the aircraft by hand propping. The aircraft started immediately, broke both tie-down ropes, traveled across the field into a ditch and… - [NTSB SEA87IA127](https://openairdocs.org/ntsb/SEA87IA127.md): British Aerospace BAE-146-100 · Las Vegas, NV · Incident · Minor injuries · Incident investigation · Final report · Jun 28, 1987 · N146AP · Minor damage > During pushback and while starting the #4 engine the auxiliary power unit which provides electrical power to the engine starter tripped off the line. The loss of electrical power to the engine starter resulted in a hung start at approximately 25% N2 RPM.… - [NTSB LAX87LA243](https://openairdocs.org/ntsb/LAX87LA243.md): Boeing 737-277 · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Jun 23, 1987 · N184AW · 2 aircraft · Substantial damage > Failure of the qualified mechanic to insure the operation of the aircraft brakes prior to taxiing and his failure to utilize the emergency brake system to prevent the collision. Contributing to this accident was the decision of airline maintence supervisors… - [NTSB LAX87DUJ05](https://openairdocs.org/ntsb/LAX87DUJ05.md): Hiller UH-12E · Tolleson, AZ · Accident · No injuries · Final report · May 19, 1987 · N4034T · Destroyed > The plt stated that he landed the acft on a platform on top of a chemical tank truck. The truck was parked on a slight slope with its left side six inches lower than the right. The plt reduced power to idle and the loader began to load the helicopter with… - [NTSB ATL87LA143](https://openairdocs.org/ntsb/ATL87LA143.md): Beech B100 · Birmingham, AL · Accident · 1 fatal · Limited investigation · Final report · May 19, 1987 · N753D · Minor damage > The lineman walked into the prop arc of the operating rt engine and was fatally injured after disconnecting a ground power unit (gpu) cable from the rt engine nacelle. The lineman initially approached the nacelle from the rear, but walked forward into the… - [NTSB NYC87LA151](https://openairdocs.org/ntsb/NYC87LA151.md): Aeronca 11AC · Jeanette, PA · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N3886E · Substantial damage > The plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees. - [NTSB SEA87LA090](https://openairdocs.org/ntsb/SEA87LA090.md): Rutan VARI-EZE · Renton, WA · Accident · Minor injuries · Limited investigation · Final report · May 8, 1987 · N29Z · Substantial damage > While being hand propped the aircraft began to move. The pilot then attempted to climb inside the aircraft but the canopy had closed. The pilot held onto the aircraft and was dragged across the end of the runway. The aircraft struck a parked, unoccupied… - [NTSB FTW87FA116](https://openairdocs.org/ntsb/FTW87FA116.md): Beech V35-B · Terrell, TX · Accident · No injuries · Field investigation · Final report · May 8, 1987 · N1861W · Destroyed > While attempting to start the aircraft the starter solenoid wiring caught fire. The heat from the fire caused an overstressed brake line to fall, allowing brake fluid to drain onto the lip of the nose gear door. The fire then burned through the floor of the… - [NTSB NYC87LA168](https://openairdocs.org/ntsb/NYC87LA168.md): Taylorcraft DCO-65 · Sanford, ME · Accident · No injuries · Limited investigation · Final report · Apr 22, 1987 · N58032 · Substantial damage > The acft was being hand propped from behind the prop on the rgt side when the eng started. The plane jumped the chock, knocked the plt to the ground, turned to the rgt & collided with a parked acft in the tie-down area. The acft was not tied down & only the… - [NTSB LAX87LA185](https://openairdocs.org/ntsb/LAX87LA185.md): Cessna P210N II · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 1987 · N6509P · 2 aircraft · Minor damage > A C-172 collided with a C-210N while txg. The C-172 was txg along a 75 ft wide parallel twy after landing. The C-210N was txg from a ramp area to his dep rwy. The C-210N route intersected the C-172 route at the parallel twy where the collision occurred. Plts… - [NTSB LAX87LA171](https://openairdocs.org/ntsb/LAX87LA171.md): Mooney M20J · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1987 · N5690N · 2 aircraft · Minor damage > While holding short of the runway behind a Cessna 182R, the pilot of a Mooney M20J, reached over to tighten his four year old sons seatbelt. The pilots foot came off the toe brake and the aircraft rolled forward and collided with the Cessna. - [NTSB CHI87IA110](https://openairdocs.org/ntsb/CHI87IA110.md): Cessna 172L · Plainfield, IL · Incident · 1 fatal · Incident investigation · Final report · Mar 29, 1987 · N4211Q · No damage > The pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a… - [NTSB ANC87LA042](https://openairdocs.org/ntsb/ANC87LA042.md): Cessna 185F · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 1, 1987 · N2449J · Substantial damage > The pilot was unable to start his airplane due to a weak battery and elected to start the unsecured acft's engine by hand-propping. The engine started and the airplane accelerated away from its tie-down area and into a building before the pilot could reenter… - [NTSB NYC87LA090](https://openairdocs.org/ntsb/NYC87LA090.md): Cessna 150C · Manville, NJ · Accident · No injuries · Limited investigation · Final report · Feb 17, 1987 · N63218 · Substantial damage > After making a rest stop, the plt attempted to restart the eng, using a normal start procedure, but the starter would not engage. He tried to turn off the ignition switch, but said that 'possibly due to the fact that I was wearing heavy gloves, I failed to… - [NTSB CHI87FA081](https://openairdocs.org/ntsb/CHI87FA081.md): Boeing 747-122 · Detroit, MI · Accident · Serious injuries · Field investigation · Final report · Feb 12, 1987 · N4718U · No damage > Drg flt, united flt 108 recd info of a bomb threat. Due to a short time limit, specified in the threat, the flt divertedto Detroit & the slides were used to evacuate the acft; 8 of 10 slides deployed nmly & were used. The slide at door 4R didn't inflate &… - [NTSB LAX87LA111](https://openairdocs.org/ntsb/LAX87LA111.md): Cessna T210L · El Cajon, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 1987 · N5275V · No damage > The plt indicated that he and his wife were planning to fly together, but at the last minute his wife changed her mind. She exited the acft and departed the area to the rear of the plane. The plt was taxiing from his parking spot when his wife suddenly… Next page: https://openairdocs.org/ntsb-phases/150/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 = 150) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/150/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.