# NTSB investigations, 1986: 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 · 661 cases ## Latest cases - [NTSB SEA87LA040](https://openairdocs.org/ntsb/SEA87LA040.md): Piper PA-32-300 · Gates, OR · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1986 · N4116R · Destroyed > The plt was attempting to land the aircraft at night on an unlit grass airstrip. Prior to reaching the airstrip the plt collided with an apple tree. Both wings were severed from the aircraft and it went inverted before striking the ground in a slightly nose… - [NTSB CHI87LA059](https://openairdocs.org/ntsb/CHI87LA059.md): Cessna 172H · Mosinee, WI · Accident · No injuries · Limited investigation · Final report · Dec 30, 1986 · N3220L · Substantial damage > The CFI stated that while in the landing configuration, over the apch end of the rwy, the student excessively flared the acft and it stalled with the right wing contacting the rwy. According to the CFI, power was added but it was too late to 'save the… - [NTSB DEN87FA038](https://openairdocs.org/ntsb/DEN87FA038.md): Cessna 172N · Central, UT · Accident · Serious injuries · Field investigation · Final report · Dec 29, 1986 · N5153K · Substantial damage > The plt and 3 passengers were on a local sightseeing flt over the pine valley mountain range. The plt stated that he made three 360 deg turns to gain alt from 7500 ft to 9500 ft. he also stated that upon leveling at 9500 ft the eng began to lose pwr. Attempts… - [NTSB FTW87DRD02](https://openairdocs.org/ntsb/FTW87DRD02.md): Cessna A-188-B · Ft.Polk, LA · Accident · No injuries · Final report · Dec 28, 1986 · N49220 · Substantial damage > Examination revealed the tail wheel assembly was badly worn and its spacers were missing, causing the swivel mechanism to lock in the off center position. The aircraft landed on a narrow road. It veered slightly upon tail wheel contact and went off the… - [NTSB ATL87LA050](https://openairdocs.org/ntsb/ATL87LA050.md): Piper PA-28-181 · High Point, NC · Accident · No injuries · Limited investigation · Final report · Dec 27, 1986 · N8389C · Substantial damage > The plt landed on the wet turf/gravel rwy with a slight quartering tail wind. Rprtdly, the acft touched down about 1/3 of the way down the rwy with an airspeed of 4 to 9 KTS above the recommended speed. The plt was unable to stop on the remaining rwy &… - [NTSB MIA87LA059](https://openairdocs.org/ntsb/MIA87LA059.md): Piper PA-44 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Dec 26, 1986 · N2197X · Substantial damage > Shortly after takeoff on an IFR flt, the flt lost all electrical power while in VFR conditions. The flt returned to the arpt and the plt completed the pre-landing checklist placing the gear handle in the down position. The gear, being electrically operated,… - [NTSB CHI87LA056](https://openairdocs.org/ntsb/CHI87LA056.md): Piper PA-38-112 · Madison, WI · Accident · No injuries · Limited investigation · Final report · Dec 26, 1986 · N4325E · Substantial damage > While practicing touch & go landings, the student plt reports, the acft 'suddenly dropped' resulting in a hard landing. The acft then porpoised separating the nose gear and skidding to a stop off the rwy. - [NTSB FTW87LA039](https://openairdocs.org/ntsb/FTW87LA039.md): Cessna 172M · Lindale, TX · Accident · No injuries · Limited investigation · Final report · Dec 25, 1986 · N12525 · Substantial damage > A private pilot substantially damaged his aircraft while attempting a landing on a grass strip in Lindale, TX. The pilot overshot the airstrip, and crashed in a field off the end of the runway. - [NTSB MIA87LA058](https://openairdocs.org/ntsb/MIA87LA058.md): Cessna 152 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Dec 24, 1986 · N65484 · Substantial damage > The acft skidded off the end of the wet grassy runway after touching down about midway down the rwy. The plt stated that in the future, all available rwy should be used. The plt received his private certificate just prior to the accident. - [NTSB DEN87LA033](https://openairdocs.org/ntsb/DEN87LA033.md): Cessna 172N · Nathrop, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1986 · CGYDG · Substantial damage > The canadian registered acft, with a pvt plt and instructor rated pax and two paxs aboard, took off from canon city, CO, enroute to gunnison, CO, to refuel. This was a cross-country flt to allow the plt to build necessary flt time towards a commercial… - [NTSB MIA87LA055](https://openairdocs.org/ntsb/MIA87LA055.md): Maule M-7-235 · Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 1986 · N151CD · Destroyed > The acft dragged a wing during lndg according to the plts statement. The acft came to rest beside the rwy. The plt said he lost control of the acft due to a fuel imbalance. After the accident the left wing tip tank was found full of fuel. According to the… - [NTSB MIA87LA053](https://openairdocs.org/ntsb/MIA87LA053.md): Cessna 150F · Tunica, MS · Accident · No injuries · Limited investigation · Final report · Dec 22, 1986 · N6907F · Substantial damage > The plt stated that during landing roll he lost control of the acft and it swerved off the right side of the rwy. The acft traveled into a plowed field and the nose gear collapsed. - [NTSB ANC87LA022](https://openairdocs.org/ntsb/ANC87LA022.md): Cessna 206 · Ruby, AK · Accident · No injuries · Limited investigation · Final report · Dec 22, 1986 · N734WE · Substantial damage > The pilot stated that during the landing roll on the frozen river, he lost control of the aircraft causing the aircraft to ground loop. - [NTSB NYC87DHA01](https://openairdocs.org/ntsb/NYC87DHA01.md): Piper PA-28-180 · Lehighton, PA · Accident · No injuries · Final report · Dec 21, 1986 · N54482 · Substantial damage > Student pilot with a certified flight instructor while on the landing roll encountered a crosswind. Directional control was lost the aircraft departed the runway causing substantial damage due coming to final rest in a ditch. - [NTSB CHI87DET01](https://openairdocs.org/ntsb/CHI87DET01.md): Pitts S1S · Warsaw, IN · Accident · No injuries · Final report · Dec 21, 1986 · N39XP · Substantial damage > According to the pilot after touchdown the right brake seemed to lock up with a 'skidding' noise as the aircraft left the runway. The pilot stated he was having difficulty keeping his toes off the brakes as he was attempting to maintain directional control.… - [NTSB SEA87LA038](https://openairdocs.org/ntsb/SEA87LA038.md): Cessna 172 · Yamhill, OR · Accident · No injuries · Limited investigation · Final report · Dec 20, 1986 · N739LH · Substantial damage > The plt was landing on a one way short narrow airstrip. He stated a gust of wind occurred just prior to touchdown. The aircraft then bounced and the plt added power. The aircraft then bounced several times and the nose gear collapsed. The aircraft then nosed… - [NTSB FTW87LA036](https://openairdocs.org/ntsb/FTW87LA036.md): Piper PA-34-220T · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Dec 20, 1986 · N8456X · Substantial damage > The plt stated that after a normal apch, he made a hard landing on the main gear and the acft bounced. He further stated that the second contact was hard on the main gear and that the nose gear collapsed when it touched down the 2nd time. Damage sustained by… - [NTSB FTW87LA034](https://openairdocs.org/ntsb/FTW87LA034.md): Cessna 150 · Arlington, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 20, 1986 · N714LL · Substantial damage > A student pilot on solo flight in the local area of Arlington airport (F54) TX. Substantially damaged a Cessna 150 during a hard landing, breaking the nose gear and nosing over inverted. The pilot received minor injuries. - [NTSB DEN87IA031](https://openairdocs.org/ntsb/DEN87IA031.md): Beech C-99 · Albuquerque, NM · Incident · No injuries · Incident investigation · Final report · Dec 18, 1986 · N7212P · Minor damage > Mesa airline flt 114 was on a scheduled flt from Albuquerque to clovis, NM. Upon touchdown at clovis, the left landing gear began to collapse and a go-around was successful. The crew elected to return to Albuquerque where emerg equipment could stand by. After… - [NTSB MIA87LA049](https://openairdocs.org/ntsb/MIA87LA049.md): Christen Industries Pitts S-2B · Gulfport, MS · Accident · No injuries · Limited investigation · Final report · Dec 14, 1986 · N117CL · Substantial damage > The acft touched down at a high rate of speed with a left quartering tailwind at the halfway point on the 2700 ft rwy. The acft ran off of the right side of the rwy and the plt regained control getting the acft back onto the rwy. The acft then overran the end… - [NTSB DEN87LA028](https://openairdocs.org/ntsb/DEN87LA028.md): Cessna 152 · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Dec 14, 1986 · N4597L · Substantial damage > During landing, directional control was not maintained. The acft veered left, the landing gear entered a snowbank, and the acft nosed over. - [NTSB ATL87LA043](https://openairdocs.org/ntsb/ATL87LA043.md): Luscombe 8A · Morganton, NC · Accident · No injuries · Limited investigation · Final report · Dec 12, 1986 · N71966 · Substantial damage > Plt reptd doing LCL flying for about one hr after dept from pvt grass strip. Made apch and ldg at Morganton-lenoir apt. On touchdown plt reptd bouncing, and being unable to recover before lt main gear collapsed and lt wing dragged. Plt stated that he felt… - [NTSB MKC87LA031](https://openairdocs.org/ntsb/MKC87LA031.md): Cessna 180 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Dec 11, 1986 · N26DL · Substantial damage > During landing airplane ballooned due to wind gust. After touchdown. Airplane veered left and duirng pilot's correction, the left main landing gear leg broke off. Metallurgical evaluation revealed a previous fatigue failure in the fracture surface. - [NTSB LAX87LA060](https://openairdocs.org/ntsb/LAX87LA060.md): Mooney M20C · Michigan Bar, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 1986 · N5808Q · Substantial damage > During the flare, just prior to touchdown, a deer ran across the runway from the right and subsequently collided with the left wing of the aircraft. The pilot reported there was no time to avoid an impact. - [NTSB NYC87LA048](https://openairdocs.org/ntsb/NYC87LA048.md): Cessna 150 · Poestenkill, NY · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N50714 · Substantial damage > The pilot touched down hard, added power for a go around. Sluggish engine did not have enough power to clear trees at the end of the runway. Aircraft collided with trees. The plt after the acc said that after cutting off the carb head the eng seemed sluggish.… - [NTSB LAX87LA061](https://openairdocs.org/ntsb/LAX87LA061.md): Cessna 182Q · San Rafael, CA · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N759DH · Substantial damage > During an instructional flight, the student pilot was not aligned properly with the runway. The flight instructor (CFI) took control of the aircraft on final, but he stated that it did not respond when he applied rudder control. After touchdown, the aircraft… - [NTSB CHI87LA043](https://openairdocs.org/ntsb/CHI87LA043.md): Piper PA28-151 · Marquette, MI · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N41765 · Substantial damage > While on landing rollout the student pilot skidded off the left side of the runway and collided with a snowbank. The student stated he was holding excessive left rudder and brake pressure. - [NTSB NYC87DNC03](https://openairdocs.org/ntsb/NYC87DNC03.md): Aero Commander 680 · Barre, VT · Accident · No injuries · Final report · Dec 3, 1986 · N6375U · Substantial damage > Witness observed the acft touchdown about 2000 feet down 5001 foot rwy. The rwy was reported wet and icy in spots at the north end only. The acft overran the rwys end and went down into a ravine about 25 ft below rwy level. There was no indication of… - [NTSB ANC87LA017](https://openairdocs.org/ntsb/ANC87LA017.md): Cessna 185 · Skwentna, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 1986 · N6992N · Substantial damage > The pilot lost directional control of the aircraft on touchdown. Examination of the brake system revealed the left brake was frozen. - [NTSB DEN87LA027](https://openairdocs.org/ntsb/DEN87LA027.md): Cessna 152A · Great Falls, MT · Accident · No injuries · Limited investigation · Final report · Dec 2, 1986 · N4784A · Substantial damage > The student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.… - [NTSB CHI87IA039](https://openairdocs.org/ntsb/CHI87IA039.md): Douglas DC-9-51 · Madison, WI · Incident · No injuries · Incident investigation · Final report · Dec 2, 1986 · N786NC · Minor damage > Aircraft slid off the right side the runway during the rollout from a cross wind landing and struck 6 runway edge lights causing minor damage to the inboard trailing edge of the right flap. At the time of the incident there was 1/2 inch of snow on the runway… - [NTSB NYC87DFA02](https://openairdocs.org/ntsb/NYC87DFA02.md): Schweizer SGS 2-33A · Wurtsboro, NY · Accident · No injuries · Final report · Nov 30, 1986 · N1222S · Substantial damage > The pilot was landing a Schweizer SGS-233 when he started to get into a pilot induced oscillation. The oscillations increased and the aircraft impacted in a nose low attitude. The pilot said the accident could have been prevented with less control input,… - [NTSB LAX87LA056](https://openairdocs.org/ntsb/LAX87LA056.md): Pitts Special S1-D · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Nov 29, 1986 · N365A · Substantial damage > At the end of a local pleasure flight, the aircraft ground looped while the pilot was turning off of runway 7R onto a high speed taxiway. The pilot reported that near the end of the landing roll, he tapped the brakes lightly in preparation to turn when the… - [NTSB DEN87LA026](https://openairdocs.org/ntsb/DEN87LA026.md): Beech A23-24 · Vernal, UT · Accident · No injuries · Limited investigation · Final report · Nov 29, 1986 · N5996S · Substantial damage > The plt attempted to land on a dirt road near two oil rigs. He said he made several low passes to view the road surface. During the landing roll, the wheels of the acft dug into the soft surface. A loss of control occurred which resulted in the acft traveling… - [NTSB CHI87DER01](https://openairdocs.org/ntsb/CHI87DER01.md): Cessna 185D · St. Paul, MN · Accident · No injuries · Final report · Nov 29, 1986 · N1502F · Substantial damage > During landing after the skis had touched down the acft began to swerve. As the acft left the rwy the plt attemtped a go-around, however, one ski dug into the ground and the acft flipped over onto it's back. Post accident exam revealed the right ski had… - [NTSB NYC87DFA03](https://openairdocs.org/ntsb/NYC87DFA03.md): Cessna 150M · Guilderland Cnt, NY · Accident · No injuries · Final report · Nov 28, 1986 · N704EK · Substantial damage > The student pilot, on a solo 30 NM x-country training flt, became lost while using VOR navigation. A precautionary landing was made in an industrial park. The acft collided with a stack of slate during the landing roll. - [NTSB FTW87FA022](https://openairdocs.org/ntsb/FTW87FA022.md): Cessna 172C · Amarillo, TX · Accident · Minor injuries · Field investigation · Final report · Nov 27, 1986 · N7709U · 2 aircraft · Destroyed > The certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of… - [NTSB LAX87LA050](https://openairdocs.org/ntsb/LAX87LA050.md): Piper PA-18-150 · Half Moon Bay, CA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1986 · N76EV · Substantial damage > The airplane departed modesto airport (mod), modesto, California, on a v.f.r. pleasure flight to Half Moon Bay airport (haf), Half Moon Bay, CA. The flt to haf was uneventful. The plt negotiated a traffic pattern to runway 30. During the landing roll-out the… - [NTSB CHI87DEX02](https://openairdocs.org/ntsb/CHI87DEX02.md): Rohdecap/Thorp T-18 · Elwood, IN · Accident · Minor injuries · Final report · Nov 22, 1986 · N2433 · Substantial damage > The plt departed anderson, Indiana to check farm fields for standing water, then elected to land at the Elwood arpt at Elwood, Indiana. The sod rwy at the arpt had an uneven gradient & was soft from recent rains. While landing on the soft,uneven rwy, the acft… - [NTSB BFO87LA012](https://openairdocs.org/ntsb/BFO87LA012.md): Piper PA-28-140 · Easton, MD · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1986 · N7538R · Substantial damage > The student plt stated that the landing approach was normal until the acft was over the rwy threshold; at a height of 35 ft, he encountered moderate to strong turbulence and afterwards the acft pitched up ten degrees and entered into a moderately steep left… - [NTSB ATL87LA025](https://openairdocs.org/ntsb/ATL87LA025.md): Piper PA-28-140 · Brownsboro, AL · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1986 · N3869K · Substantial damage > The student pilot was making her first supervised solo flight in the PA28-140 model aircraft. The student reported that wind and low airspeed prevented her from reaching the runway prior to landing touchdown. - [NTSB SEA87LA028](https://openairdocs.org/ntsb/SEA87LA028.md): Cessna T-206 · Warren, ID · Accident · No injuries · Limited investigation · Final report · Nov 20, 1986 · N756WZ · Substantial damage > The pilot was attempting to land on a snow covered us forrest service airstrip at dawn. The aircrafts right main gear caught on uneven terrain to the side of the airstrip, veered to the right, and then nosed over inverted. - [NTSB FTW87LA020](https://openairdocs.org/ntsb/FTW87LA020.md): Barnes Firefly 7 · Holden, LA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1986 · N1245F · Substantial damage > A commercially rated pilot on an instructional flight was attempting a touch and go landing in the median of hiway I-12 1 mile east of Holden, LA. The pilot failed to see and avoid some power lines substantially damaging the balloon. The pilot and student… - [NTSB FTW87FA017](https://openairdocs.org/ntsb/FTW87FA017.md): Cessna 152II · Grandview, TX · Accident · Serious injuries · Field investigation · Final report · Nov 18, 1986 · N68328 · Destroyed > A student plt, while on a solo VFR navigational training flt, became lost. After 3.5 hours of flt, the plt thinking she was almost out of fuel elected to make a downwind landing on a country road near Grandview, TX. The acft contacted trees and subsequently… - [NTSB CHI87LA027](https://openairdocs.org/ntsb/CHI87LA027.md): Cessna T210N · Kankakee, IL · Accident · No injuries · Limited investigation · Final report · Nov 18, 1986 · N9843Y · Substantial damage > The plt overran rwy 22 after landing downwind during intrument weather conditions. Fss had advised the plt of a NOTAM that rwy 4 ILS was out of service due to construction. However, another acft which landed on rwy 4 about 15 minutes prior to the accident… - [NTSB ATL87LA022](https://openairdocs.org/ntsb/ATL87LA022.md): Cessna 402C · Fremont, OH · Accident · No injuries · Limited investigation · Final report · Nov 18, 1986 · N6786P · Substantial damage > The plt reported that he was about five feet above the rwy when he encountered a gust of wind. The acft rocked from side to side during the apch and touched down hard. - [NTSB LAX87LA041](https://openairdocs.org/ntsb/LAX87LA041.md): Piper PA-18-150 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Nov 17, 1986 · N4101E · Substantial damage > At the end of a local pleasure flight, the pilot attempted a downwind landing by following other traffic in the pattern. During touchdown, the left wing lifted. The pilot corrected by moving the control stick to the left. At that time, the aircraft became… - [NTSB CHI87LA036](https://openairdocs.org/ntsb/CHI87LA036.md): Piper PA-38-112 · Gaylord, MI · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1986 · N2357E · Substantial damage > The plt landed on a closed rwy and the acft collided with a snowbank. A NOTAM had been issued three days prior, closing the rwy, however, the plt stated that he had not checked notoms prior to departing traverse city. A plt of another acft, who reported being… - [NTSB CHI87LA030](https://openairdocs.org/ntsb/CHI87LA030.md): Piper PA-22 · Rockford, IL · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1986 · N1457A · Destroyed > During landing roll, plt applied brakes too hard at high speed and nosed over. - [NTSB BFO87IA008](https://openairdocs.org/ntsb/BFO87IA008.md): Boeing 727-231 · Norfolk, VA · Incident · Minor injuries · Incident investigation · Final report · Nov 16, 1986 · N64323 · Minor damage > During the landing roll the r main gear collapsed. A flight attendant received minor injuries during evacuation of the acft. Examination of the acft disclosed that the shock strut cylinder fractured circumferentially; about 10 inches below the top of the… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?year=1986&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") = 1986 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=1986 --- 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.