# NTSB investigations: Approach 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 184 of 420 · 20,996 cases ## Cases, newest first - [NTSB ATL86LA204](https://openairdocs.org/ntsb/ATL86LA204.md): Cessna C-152 · Conway, SC · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · N6521B · Substantial damage > The acft was based at an uncontrolled airstrip without fuel facilities. Prior to take-off, the plt refueled the acft from a 5 gal can and draining the fuel sumps. During an approach to land at Conway, SC, the acft lost power and a forced landing was made on a… - [NTSB DEN86LA199](https://openairdocs.org/ntsb/DEN86LA199.md): Schleicher ASW-20 · Hobbs, NM · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N13JR · Substantial damage > The plt was participating in a soaring competion meet. While on the return portion of the flt, the plt encountered an area of insufficient lift & was unable to reach the arpt. During an off arpt landing, the left wing of the glider struck a mesquite bush &… - [NTSB DEN86LA195](https://openairdocs.org/ntsb/DEN86LA195.md): Cessna 320C · Cedar City, UT · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N3030T · Substantial damage > The plt said that while on downwind during his apch to land, he advanced the mixtures to full rich and retarded the throttles. On final approach when throttles were advanced, he discovered the right eng was not running and the left eng would not respond… - [NTSB SEA86FA165](https://openairdocs.org/ntsb/SEA86FA165.md): Thorp T-18 · Richland, WA · Accident · 2 fatal · Field investigation · Final report · Jul 11, 1986 · N2056 · Destroyed > At time of mishap, acft presumed to be in rt-hand approach to land in 20-KT, 40 degree rt crosswind. Witnesses first observed acft descending vertically, out of control, in an area consistent with the 90 degree approach position. Evidence indicates acft… - [NTSB MIA86LA204](https://openairdocs.org/ntsb/MIA86LA204.md): Cessna 172H · Kissimmee, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1986 · N1448F · Substantial damage > The plt rprtd that he initiated a flt around the pattern, but stalled the acft during the apch to land. The acft crashed outside the arpt boundry, just short of the rwy. Prior to the flt, a mechanic, who had been working on the acft, told the plt that the… - [NTSB DEN86LA200](https://openairdocs.org/ntsb/DEN86LA200.md): Schleicher ASW-20B · Hobbs, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1986 · N26EE · Substantial damage > The plt said that he was participating in a glider soaring contest when the accident occurred. He stated that he was flying on the second leg of the flt when he ran out of thermals to keep his glider flying, and he was forced to land prematurely. On a… - [NTSB MIA86FA202](https://openairdocs.org/ntsb/MIA86FA202.md): Grumman G-164B · Sidon, MS · Accident · 1 fatal · Field investigation · Final report · Jul 10, 1986 · N48593 · Destroyed > The right wings of the ag operator's bi-plane collided with the ground support cables of a 322 ft high microwave tower while on a base leg for landing. The right wings separated & the acft crashed & burned killing the plt. The 25000 hr plt knew of the tower… - [NTSB NYC86FHD02](https://openairdocs.org/ntsb/NYC86FHD02.md): Cessna 172K · Jobstown, NJ · Accident · Minor injuries · Final report · Jul 8, 1986 · N7456G · Destroyed > While on the third landing attempt, the student pilot was high and fast, the instructor allowed the landing to be accomplished, on the last third of the runway, the CFI attempted a go-around, the flaps were not retracted. The aircraft cleared power lines, but… - [NTSB CHI86LA164](https://openairdocs.org/ntsb/CHI86LA164.md): Cessna 150F · Selfridge Ang, MI · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N8095F · Substantial damage > The plt became lost at night over a large body of water and requested assistance. When identified by ATC, the acft did not have enough fuel remaining to reach an arpt. The acft suffered fuel exhaustion on final apch and was landed on a golf course 2000 ft… - [NTSB MIA86LA201](https://openairdocs.org/ntsb/MIA86LA201.md): Beech 36 · Marco Island, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1986 · N9031S · Destroyed > During landing apch, the plt stated that he switched from the left fuel tank to the right tank & shortly thereafter, the eng failed. He was unable to restart the eng and a forced ldg was made. An exam of the left tank revealed it to be empty while the right… - [NTSB LAX86FA279](https://openairdocs.org/ntsb/LAX86FA279.md): Cessna 172M · Havasu Lake, CA · Accident · 5 fatal · Field investigation · Final report · Jul 6, 1986 · N80503 · Destroyed > At about 2100 PDT on 7/5/86, the flt departed lake Havasu city, AZ for an unkn destn. On the next morning at aprx 0330, witnesses, who were fishing on lake Havasu, heard the acft circle twice, then crash about 2 mi west of the arpt on the California side of… - [NTSB ATL86IA187](https://openairdocs.org/ntsb/ATL86IA187.md): Cessna U206C · Bucyrus, OH · Incident · No injuries · Incident investigation · Final report · Jul 6, 1986 · N29095 · Minor damage > The plt was returning to the airport after transporting skydivers to altitude and while on final aprch he allowed the acft to stall & crash short of the rwy. - [NTSB DEN86LA187](https://openairdocs.org/ntsb/DEN86LA187.md): Cessna 172N · Richfield, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1986 · N8291E · Substantial damage > Plt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1)... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the… - [NTSB MKC86LA144](https://openairdocs.org/ntsb/MKC86LA144.md): Piper PA-24-250 · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1986 · N6FF · Substantial damage > The owner of the airplane had not flown since 1980 and was receiving instruction to become current and was to receive a bfr on this trip also. The airplane had been rebuilt after a forced landing and also had just received an annual inspection. The airplane… - [NTSB MKC86LA142](https://openairdocs.org/ntsb/MKC86LA142.md): Stevens Akro · Conway, AR · Accident · No injuries · Limited investigation · Final report · Jul 3, 1986 · N6009N · Substantial damage > The PIC stated he allowed the acft to develop a high sink rate on final approach to the rwy, and was late in applying pwr to arrest the descent. Subsequently the acft impacted the terrain and sustained substantial damage. - [NTSB LAX86LA276](https://openairdocs.org/ntsb/LAX86LA276.md): Cessna 320D · Compton, CA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1986 · N4153T · Substantial damage > The plt attempted a night landing after he was unable to extend the acft's landing lights. He stated that, over the end of the rwy at about 25 ft AGL, everything blended into a large black spot. As the plt attempted a go-around, the acft contacted the rwy,… - [NTSB BFO86FA038](https://openairdocs.org/ntsb/BFO86FA038.md): Beech 95-B 55 · Lynchburg, VA · Accident · 4 fatal · Field investigation · Final report · Jul 2, 1986 · N133P · Destroyed > The non-instrument rated pilot filed an IFR flight plan into known and forecast IFR weather. During his second ILS approach to the airport, after the control tower had closed, he failed to utilize the aircraft radio to illuminate the approach lighting system.… - [NTSB ATL86LA186](https://openairdocs.org/ntsb/ATL86LA186.md): Piper PA-28RT-201 · Robbinsville, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 1986 · N8153C · Destroyed > The acft was flown from troy, mi to knoxville, TN and landed, but it was not refueled. The plt proceeded on to the assume destination, but the acft did not arrive. According to the plt's original flt plan (from troy to andrews, NC), the estimated time en… - [NTSB NYC86LA165](https://openairdocs.org/ntsb/NYC86LA165.md): Cessna 150E · Hammondsport, NY · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N4067U · Substantial damage > While on final apch over high terrain east of the arpt, the plt inadvertently pulled the mixture control when he intended to apply carburetor heat. The eng stopped running & the plt was unable to obtain a restart before the acft collided with trees. The acft… - [NTSB CHI86LA162](https://openairdocs.org/ntsb/CHI86LA162.md): Cessna 150L · Int'L Falls, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1986 · N19528 · Substantial damage > Acft struck power lines on approach to private airstrip. The plt stated that an air pocket pulled the plane down. Weather at international Falls, six miles from the accident site, reported winds at 7 KTS with no gusts. The plts flt time was not reported. - [NTSB NYC86LA161](https://openairdocs.org/ntsb/NYC86LA161.md): Alon A2 · South Sutton, NH · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1986 · N5474E · Destroyed > The plt rprtd that during a landing, the flight encountered a severe downdraft and impacted the ground hard, collapsing the nose gear and incurring other damage to the aircraft. - [NTSB MIA86LA193](https://openairdocs.org/ntsb/MIA86LA193.md): Culver V · Deland, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1986 · N80273 · Substantial damage > The plt stated that on his landing apch he reduced the power too soon, the acft stalled and collided with trees and crashed 150 feet short of the runway. - [NTSB LAX86LA269](https://openairdocs.org/ntsb/LAX86LA269.md): Beech B-19 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Jun 25, 1986 · N5420M · Substantial damage > The acft was fast and long during a landing attempt according to the student plt. He elected to make a go-around but in doing so he raised the flaps too rapidly and the acft landed hard after which it bounced into the dirt off to the side of the rwy. - [NTSB BFO86FIA01](https://openairdocs.org/ntsb/BFO86FIA01.md): Grumman AA1B · Brandywine, MD · Accident · Minor injuries · Final report · Jun 24, 1986 · N9628L · Destroyed > Prior to reaching the lom during an ILS rwy 01L apch, a loss of pwr was experienced. The plt applied carb heat and pwr was momentarily restored. A total pwr loss was then experienced and the plt executed a forced landing in a field during which the acft nosed… - [NTSB MIA86LA189](https://openairdocs.org/ntsb/MIA86LA189.md): Piper PA-28-180 · Punta Gorda, FL · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N9625J · Substantial damage > The plt stated that after a 20 minute flight on a long final approach the engine sputtered & quit. A forced landing was made in a residential area and the acft went through a ditch severing the landing gear. Post crash examination of the carburetor revealed… - [NTSB NYC86LA154](https://openairdocs.org/ntsb/NYC86LA154.md): Cessna 152 · Wayne, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1986 · N89720 · Destroyed > The aircraft developed engine problems while on approach to the airport at caldwell, new jersey and collided with trees during the forced landing. Upon examination of the aircraft, debris was found in the vent line from the fuel vent tube to the left fuel… - [NTSB DEN86FA170](https://openairdocs.org/ntsb/DEN86FA170.md): Cessna A150K · Silver City, NM · Accident · 1 fatal · Field investigation · Final report · Jun 21, 1986 · N6DW · Destroyed > The student plt took a private plt for a sight seeing ride. The acft was over gross weight and the density alt was calculated to be 9,292 feet. On an approach to landing the student plt elected to go around. The surviving plt said that in a steep bank the… - [NTSB ATL86LA179](https://openairdocs.org/ntsb/ATL86LA179.md): Andrew D. Moore HP-18 · Chester, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1986 · N9700P · Substantial damage > The pilot related that while turning from base to final he heard a loud bang from the left side of the aircraft. The aircraft entered a steep left turn and crashed left of final approach course. Post crash examination of the aircraft revealed that the flap… - [NTSB FTW86FPJ09](https://openairdocs.org/ntsb/FTW86FPJ09.md): Quick Silver Mxii · Ardmore, OK · Accident · Serious injuries · Final report · Jun 20, 1986 · N4410W · Substantial damage > The acft landed short of the rwy after losing eng pwr during the apch. Post acc inspection showed that the bearing on the pwr shaft failed. This allowed the belt tension to become slack which reduced the prop RPM. No other discrepancies were noted. - [NTSB CHI86LA159](https://openairdocs.org/ntsb/CHI86LA159.md): Cessna 152 · Shiocton, WI · Accident · No injuries · Limited investigation · Final report · Jun 20, 1986 · N5220M · Substantial damage > CFI delayed corrective action during a practice forced landing by a student. Aircraft touched down with insufficient runway remaining to stop safely. During the subsequent go-around attempt the aircraft rolled into a plowed field and nosed over. - [NTSB LAX86MA268](https://openairdocs.org/ntsb/LAX86MA268.md): Aerospatiale AS-355F-1 · Galveston, TX · Accident · No injuries · Major investigation · Final report · Jun 18, 1986 · N5796T · Substantial damage > The plt rprtd that while apchg an oil drilling platform for a lndg, he observed the main rotor blades go out of track about 8 to 10 inches. He also rprtd the helicopter developed a 1:1 vertical vibration. Drg the lndg, the helicopter entered into ground… - [NTSB CHI86LA157](https://openairdocs.org/ntsb/CHI86LA157.md): Brantly Helicopter B-2B · Griffith, IN · Accident · No injuries · Limited investigation · Final report · Jun 17, 1986 · N2295U · Substantial damage > The student plt & instructor (CFI) were on a dual instructional flt, practicing landings. During an apch to rwy 8, the student began to undershoot on final apch. As the helicopter was apchg a fence near the apch end of the rwy, he became alarmed & applied aft… - [NTSB ATL86FA174](https://openairdocs.org/ntsb/ATL86FA174.md): Schweizer SGS 1-36 · Waynesville, OH · Accident · 1 fatal · Field investigation · Final report · Jun 17, 1986 · N36175 · Destroyed > The plt was attempting to achieve a club duration/altitude gain goal and released from the tow plane at 1,000 ft as opposed to the requested 3,000 ft tow. The plt communicated with another glider plt in the area and stated he was getting low and had to land.… - [NTSB ANC86FA080](https://openairdocs.org/ntsb/ANC86FA080.md): Champion 7ECA · Settlers Bay, AK · Accident · Serious injuries · Field investigation · Final report · Jun 16, 1986 · N11864 · Substantial damage > The instructor (CFI) gave the front seat plt a simulated forced lndg while the airplane was aligned with rwy 20 & the wind. The front seat plt elected to fly a traffic pattern to rwy 2. As the front seat plt maneuvered to line up with rwy 2, much alt was lost… - [NTSB MKC86LA128](https://openairdocs.org/ntsb/MKC86LA128.md): Cessna 152 · Liberty, MO · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N68729 · Substantial damage > The instructor stated that the student had done well during this dual session, and he felt that traffic pattern airwork would be appropriate. Traffic pattern entry and letdown were normal, but the student got too low and slow on the full flap final approach.… - [NTSB FTW86LA108](https://openairdocs.org/ntsb/FTW86LA108.md): Cessna 177B · Odessa, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 1986 · N34889 · Substantial damage > According to the pax, the plt had been drinking prior to the flt. After takeoff, the plt decided that perhaps he was not in any condition to fly, so he elected to return to the arpt & land. Rprtdly, his seat belt had gotten caught in the door, & on final… - [NTSB DEN86LA159](https://openairdocs.org/ntsb/DEN86LA159.md): Cessna 150L · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Jun 12, 1986 · N1739Q · Substantial damage > The plt said he had been airborne for about 1.25 hrs when the eng began to cut out. Emerg procedures did not remedy the situation and an off arpt forced landing was necessary. The plt said he did not look in the fuel tanks prior to takeoff but relied on the… - [NTSB FTW86FRG26](https://openairdocs.org/ntsb/FTW86FRG26.md): Benson B-8M · New Braunfels, TX · Accident · 1 fatal · Final report · Jun 10, 1986 · N632X · Destroyed > The acft crashed out of control after the eng stopped during a landing approach, the acft had almost completed the 1st pattern around the field when the eng stopped. Investigation revealed a 1/4 inch nylon rope wrapped and tied around the rotor blade about 30… - [NTSB LAX86FA248](https://openairdocs.org/ntsb/LAX86FA248.md): Beech V35B · Del Rey Oaks, CA · Accident · 1 fatal · Field investigation · Final report · Jun 9, 1986 · N4457W · Destroyed > Approaching the destination arpt the plt informed ATC that he did not feel well and desired to land 'as quickly as possible.' The plt was cleared to land. While on a right base leg the acft pitched 45 degrees nose down, and collided with terrain and a… - [NTSB SEA86LA140](https://openairdocs.org/ntsb/SEA86LA140.md): Varga 2050A · Bear Trap, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1986 · N5077V · Destroyed > During a simulated forced landing the instructor pilot allowed the student to enter into a stall while turning from base to final. Although the instructor attempted to correct the student's mistakes he allowed the student to go too FAR with the task before… - [NTSB LAX86FA247](https://openairdocs.org/ntsb/LAX86FA247.md): Beech M35 · Swall Meadows, CA · Accident · Serious injuries · Field investigation · Final report · Jun 7, 1986 · N398Z · Destroyed > The civil air patrol (cap) organized & provided instructors to teach cap mission plts techniques of 'high altitude' search flying during a 2-DAY course. The curriculum included making a landing approach to a 6080 ft elevation airstrip. The approach was to be… - [NTSB CHI86FA151](https://openairdocs.org/ntsb/CHI86FA151.md): Beech 55 · Kenosha, WI · Accident · No injuries · Field investigation · Final report · Jun 7, 1986 · N1268Z · Substantial damage > The acft was on a positioning flt returning from traverse city, MI, to Kenosha, WI. The reported milwaukee weather was ceiling 300 ft and visibility 2 miles. The pilot was cleared for a VOR 14 approach and given vectors to the final approach course. The pilot… - [NTSB ATL86LA159](https://openairdocs.org/ntsb/ATL86LA159.md): Piper J3C-65 · Fayetteville, GA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1986 · N28044 · Substantial damage > The plt reported that while on downwind the engine started to run rough. The plt applied carburetor heat and the engine quit. A turn toward a landing area was made; however, the acft collided with trees. Weather conditions at the time were favorable for… - [NTSB LAX86LA241](https://openairdocs.org/ntsb/LAX86LA241.md): Boeing A75N1 · Sonoma, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1986 · N62763 · Substantial damage > The acft collided with a pole and crashed in a flooded field while on final approach. The pilot indicated that he flew a 20 minute local VFR flight prior to the accident. He stated he had suffered head injuries and was unable to recall any details of the… - [NTSB NYC86LA142](https://openairdocs.org/ntsb/NYC86LA142.md): Cessna 172 · Oxford, CT · Accident · No injuries · Limited investigation · Final report · Jun 3, 1986 · N7475G · Substantial damage > During an attempted go around, the aircraft stalled. The aircraft then veered left and collided with the ground. The aircraft came to rest about 100 feet off to the side of the runway on the grassy area. - [NTSB NYC86LA141](https://openairdocs.org/ntsb/NYC86LA141.md): Cessna 150 · Syracuse, NY · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1986 · N61316 · Substantial damage > During descent about six miles from Syracuse hancock airport, the flight experienced engine vibration. Engine lost power and restarted. However when flight was at 3500 feet, power was lost again. Pilot set up for best glide and crashed in a grassy field. Full… - [NTSB DEN86FA147](https://openairdocs.org/ntsb/DEN86FA147.md): Piper PA-20-160 · Buena Vista, CO · Accident · 1 fatal · Field investigation · Final report · May 31, 1986 · N5394Z · Substantial damage > When the plt took off, the wind was light & variable. However, when he returned to the arpt about 20 to 30 min later, dark threatening clouds had moved into the area. He attempted to land on rwy 14. During the landing, the acft bounced & went off the right… - [NTSB CHI86FET01](https://openairdocs.org/ntsb/CHI86FET01.md): Piper PA-20 · Rolling Prairie, IN · Accident · Serious injuries · Final report · May 31, 1986 · N7734K · Substantial damage > During a go-around from an aborted landing the acft struck unmarked power lines at the departure end of the landing rwy. The acft collided with terrain during the resulting uncontrolled descent. The rwy being used was a 2400 ft long and 50 ft wide sod private… - [NTSB BFO86FID05](https://openairdocs.org/ntsb/BFO86FID05.md): Maule M-4-210C · Saluda, VA · Accident · No injuries · Final report · May 31, 1986 · N9861M · Substantial damage > While on final apch, the acft struck the top side of a van which was on a road off the apch end of the rwy. Both main landing gear were sheared off and the plt landed the acft in a grass area along the side of the rwy. The plt reported that a high sink rate… - [NTSB LAX86LA236](https://openairdocs.org/ntsb/LAX86LA236.md): Piper PA-34-200T · Long Beach, CA · Accident · Minor injuries · Limited investigation · Final report · May 30, 1986 · N8306Z · Substantial damage > The airplane crashed on final approach to runway 16L at Long Beach airport (lgb), Long Beach, California. The pilot reported that both engines sustained a total loss of power. The airplane's altitude was insufficient to land on the airport. The left fuel tank… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=185 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=184 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.