# 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 180 of 420 · 20,992 cases ## Cases, newest first - [NTSB NYC87LA075](https://openairdocs.org/ntsb/NYC87LA075.md): Cessna 172K · Butler, PA · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N79881 · Substantial damage > The personal flight with four occupants on board landed about 40 feet short of the runway after completing two successful touch and go landings. Pilot stated that the wind was at 220 degrees at 10 knots. - [NTSB ATL87DLQ01](https://openairdocs.org/ntsb/ATL87DLQ01.md): Air Command CDR Elite 532 · Paducah, KY · Accident · 1 fatal · Final report · Feb 1, 1987 · N2562 · Destroyed > While conducting local traffic pattern training, the gyroplane undershot runway 22 during an attempted landing. The plt was killed in the crash. The investigation failed to disclose any aircraft problems. The autopsy revealed severe coronary arterisclerosis… - [NTSB CHI87LA072](https://openairdocs.org/ntsb/CHI87LA072.md): Enstrom F-28A · Martinsville, IN · Accident · No injuries · Limited investigation · Final report · Jan 31, 1987 · N9257 · Destroyed > While landing to the east the plt was blinded by the sun and the acft struck telephone wires. - [NTSB ATL87IA067](https://openairdocs.org/ntsb/ATL87IA067.md): Burkhart Grob G103 Twin Astir · Williamson, GA · Incident · No injuries · Incident investigation · Final report · Jan 31, 1987 · N429BG · Minor damage > As the glider plt was apchg the entry point for landing, he checked the spoilers for operation. The spoilers extended, but would not retract. There was a significant increase in the sink rate & the plt realized he would be unable to reach the arpt.… - [NTSB SEA87LA050](https://openairdocs.org/ntsb/SEA87LA050.md): Beech B23 · Alderwood Manor, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 1987 · N6076N · Destroyed > The pilot, after exhausting all fuel in one tank, failed to select the remaining fuel tank during his approach. His unfamiliarity with the make/model of the accident aircraft is considered a factor in his failing to locate the fuel selector and switching to… - [NTSB FTW87LA050](https://openairdocs.org/ntsb/FTW87LA050.md): Piper PA-22-108 · Terrel, TX · Accident · No injuries · Limited investigation · Final report · Jan 29, 1987 · N4862Z · Substantial damage > The pilot attempted a go-around due to cross winds and experienced an engine failure due to fuel starvation when the mixture control vibrated out to the shutoff position. The pilot attempted several times to restart the engine, but was unsuccessful prior to… - [NTSB SEA87LA049](https://openairdocs.org/ntsb/SEA87LA049.md): Cessna 402B · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Jan 28, 1987 · N69310 · Substantial damage > Plt filed IFR, 2+40 ete. Due delay, plt departed VFR and opened VFR flt plan. Enroute, stong hdwinds encountered. Also, clouds required altitude and course deviations to maintain VFR. Ate was 3+33. On final, left eng lost pwr, rt eng began surging. Into 20-KT… - [NTSB ANC87FA028](https://openairdocs.org/ntsb/ANC87FA028.md): Cessna 207 · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Jan 28, 1987 · N7393U · Destroyed > The aircraft crashed one mile short of the runway. The accident occurred during an ILS approach in instrument meteorological conditions. During a post accident interview with the pilot he stated that he did not recognize and react in a timely manner to the… - [NTSB ANC87LA027](https://openairdocs.org/ntsb/ANC87LA027.md): Cessna 185D · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Jan 27, 1987 · N75LE · Substantial damage > The pilot stated that during the right downwind approach to the airstrip the aircraft ran out of fuel; the engine quit and then he attempted an emergency landing. The plt attempted to land on the rwy. Inspection revealed no fuel in the acft and the fuel… - [NTSB SEA87LA052](https://openairdocs.org/ntsb/SEA87LA052.md): Cessna 182R II · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Jan 24, 1987 · N9322X · Substantial damage > Plt attempted instrument approach in conditions conducive to structural icing; I.e., fog, light snow, temp 32F. Acft not equipped for deice. Structural ice accretion during approach and climb-out following missed approach degraded acft performance so that… - [NTSB ATL87FA064](https://openairdocs.org/ntsb/ATL87FA064.md): Cessna 310P · Memphis, TN · Accident · 2 fatal · Field investigation · Final report · Jan 24, 1987 · N5814M · Destroyed > The plt reported an engine problem inside the outer marker to runway 31. The acft impacted the ground in a nose low attitude. The wreckage examination failed to disclose any system malfunction or failure. The acft was destroyed by impact forces, and a post… - [NTSB DEN87LA044](https://openairdocs.org/ntsb/DEN87LA044.md): Beech A36 · Taos, NM · Accident · No injuries · Limited investigation · Final report · Jan 21, 1987 · N6321X · Substantial damage > The plt was making a night VFR landing approach to rwy 22 at Taos, new Mexico, when the acft struck some high voltage power transmission lines running perpendicular to the rwy. The plt was able to maintain control of the acft and landed it successfully. The… - [NTSB MIA87LA076](https://openairdocs.org/ntsb/MIA87LA076.md): Piper J3-C65 · Pembroke Pines, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 19, 1987 · N3666K · Substantial damage > The plt stated that after dropping his banner, he circled back to drop the banner hook so he could land, and as he was circling, the acft stalled, started a spin to the right and struck the ground. - [NTSB LAX87LA099](https://openairdocs.org/ntsb/LAX87LA099.md): Hughes 369D · Lemon Cove, CA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1987 · N1107N · Substantial damage > The plt rprtd that while at 100 to 150 ft AGL on an apch to land, the eng lost pwr as though it had flamed out. He entered an autorotation, but was unable to reach the helipad. Subsequently, the helicopter landed in trees & was badly dmgd. Drg the… - [NTSB LAX87LA091](https://openairdocs.org/ntsb/LAX87LA091.md): Cessna C-152 · Bakersfield, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1987 · N757QE · Destroyed > A Cessna 152 collided with a dirt bank located approximately 140 ft to the left of the rwy edge while on a night apch. The rwy safety area at the aprt extends 60 ft from the rwy centerline. The PIC indicated that he was unable to activate the low intensity… - [NTSB MKC87LA040](https://openairdocs.org/ntsb/MKC87LA040.md): Beech A-36 · Corning, IA · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 1987 · N7688N · Substantial damage > The flt had progressed normally from champagne, IL. The IFR flt plan was cancelled at lamoni VOR and the flt proceeded VFR. On final approach to rwy 17, aprx 1 mile from the rwy, the altimeter suddenly unwound and the acft struck trees. The altimeter had… - [NTSB MIA87LA075](https://openairdocs.org/ntsb/MIA87LA075.md): Piper PA-32-260 · Ft.Lauderdale, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 1987 · N3743W · Substantial damage > The plt repositioned the fuel selector from the left tip tank to the right main tank when the flt entered the traffic pattern. The eng then quit & a forced landing was made in an open field. Upon touchdown the left & right main landing gear were pushed… - [NTSB NYC87LA059](https://openairdocs.org/ntsb/NYC87LA059.md): Cessna 150 · Montgomery, NY · Accident · No injuries · Limited investigation · Final report · Jan 16, 1987 · N6717G · Substantial damage > During an instructional flight to orange county airport, a simulated engine out was performed while on approach for landing. Directional control was lost and the flight landed west of runway 3 in snow causing substantial damage. - [NTSB ATL87LA061](https://openairdocs.org/ntsb/ATL87LA061.md): Piper PA-28-181 · Albany, GA · Accident · No injuries · Limited investigation · Final report · Jan 15, 1987 · N4353P · Substantial damage > Plt deptd bowling green with a listed 5.0 hrs fuel on bd. After 3 hr 35 min he arrived over dest after exhausting fuel in the rt tank abt 30 min prior. He stated that the other tank was abt 1/2 full at the time. 15 min after rt tank exhaustion the plt req his… - [NTSB BFO87LA014](https://openairdocs.org/ntsb/BFO87LA014.md): Cessna 150L · Ellicott City, MD · Accident · No injuries · Limited investigation · Final report · Jan 13, 1987 · N18140 · Substantial damage > Approximately 30 minutes after the pilot departed hayes field, columbia, Maryland, the pilot elected to return to the field. After entering downwind the engine ceased to continue producing power and the pilot was forced to make an emergency landing. During… - [NTSB SEA87LA045](https://openairdocs.org/ntsb/SEA87LA045.md): Cessna 172 · Eatonville, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1987 · N1815Y · Destroyed > The student plt was on approach to home field after a x-c flight. During final, the pilot elected to go-around due to gusty winds and a downdraft. The acft stalled into trees along side the runway. Investigation revealed the flaps were set at 40 degrees and… - [NTSB SEA87LA046](https://openairdocs.org/ntsb/SEA87LA046.md): Bellanca 7KCAB · Bremerton, WA · Accident · No injuries · Limited investigation · Final report · Jan 11, 1987 · N36339 · Substantial damage > Plt with less than 2 hrs as PIC in Bellanca 7KCAB acft stalled on approach to runway. Plt reported winds estimated at 10 KTS with gusts to 15 KTS. Acft stalled about 30 feet above runway and impacted on the nose at about 30 degree angle. - [NTSB MIA87LA070](https://openairdocs.org/ntsb/MIA87LA070.md): Smith, Ted Aerostar Aerostar 601 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Jan 10, 1987 · N181X · Substantial damage > The plt stated that he was conducting an over water apch to rwy 17 when he observed traffic preparing to land ahead of him. He slowed the acft for traffic separation, lowered the gear, & extended partial flaps. He then stated that he felt an abnormal loss of… - [NTSB NYC87LA057](https://openairdocs.org/ntsb/NYC87LA057.md): Cessna 170A · Marston Mills, MA · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1987 · N5571C · Substantial damage > The flight was on an aerial photography mission but due to the heavy cloud cover, the aircraft returned to departure airport. The engine quit before reaching the runway and the aircraft was substantially damaged when it collided with terrain. Examination of… - [NTSB DEN87FA042](https://openairdocs.org/ntsb/DEN87FA042.md): Aero Commander 690A · Miles City, MT · Accident · Serious injuries · Field investigation · Final report · Jan 7, 1987 · N57133 · Substantial damage > The plt of the nonscheduled domestic pax air taxi flt was flying the vor/dme rwy 22 apch to wiley field, Miles City, MT. The plt said he turned on the autopilot and after turning inbound from the procedure turn towards the faf he engaged the apch mode. After… - [NTSB MKC87FA037](https://openairdocs.org/ntsb/MKC87FA037.md): Cessna T210N · Sherwood, AR · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1987 · N123LF · Substantial damage > The PIC dptd morristown with 600# of cargo as part of a rnd trip to mcalester, okla. Headwinds at alt were avg 45 KTS. The PIC had asked for 60 gal before the departure but rcvd 59.1. Aft several hrs in cruise flt, the PIC notified memphis cntr ctrlr that a… - [NTSB ATL87LA055](https://openairdocs.org/ntsb/ATL87LA055.md): Cessna 414 · Gallipolis, OH · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 1987 · N345TR · Substantial damage > The flight was established in the traffic pattern when the pilot experienced a dual engine failure. The pilot attempted to restart the engines but failed. The pilot also failed to feather the propellers which created a aerodynamic condition which allowed the… - [NTSB ATL87DEI01](https://openairdocs.org/ntsb/ATL87DEI01.md): Cessna 180 · Wadsworth, OH · Accident · Serious injuries · Final report · Jan 2, 1987 · N3296D · Substantial damage > The airplane reportedly completed an NDB appch to rwy 02. The plt reported that he circled the rwy twice after arriving at the arpt to check the rwy condition. He subsequently landed on rwy 20 where he 'impacted something on runway or hit air pocket, did not… - [NTSB ATL87FA051](https://openairdocs.org/ntsb/ATL87FA051.md): Beech 35-33 · Blountville, TN · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1986 · N210M · Substantial damage > Drg vectors for a ILS rwy 23 apch, the plt allowed the acft to get 400' below the assigned alt of 3700'. The controller (ctlr) queried the plt about his alt & the plt replied he had gotten a little low, but was returning to the assigned alt. After… - [NTSB MIA87FA062](https://openairdocs.org/ntsb/MIA87FA062.md): Piper PA-34 · Ft. Lauderdale, FL · Accident · 2 fatal · Field investigation · Final report · Dec 27, 1986 · N84136 · Destroyed > The pvt plt had been cleared for 27R ILS apch and was on the localizer at 1,600 ft when the controller noticed the acft north of the localizer course and in a right turn headed east. The controller querried the plt as to his heading and the plt replied,… - [NTSB MKC87FA035](https://openairdocs.org/ntsb/MKC87FA035.md): Cessna 414A · Olathe, KS · Accident · Serious injuries · Field investigation · Final report · Dec 25, 1986 · N414LL · Destroyed > The plt stated that this was not a charter flt and, as such, he decided to attempt the LOC 17 apch to Olathe even though the area was forecasting zero-zero conditions. According to the plt, the last thing he remembers during the flt is bracketing the LOC and… - [NTSB MIA87LA057](https://openairdocs.org/ntsb/MIA87LA057.md): Cessna 172N · Sarasota, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1986 · N737ZB · Destroyed > Two ldg attempts were made at the physician plt's private arpt but were abandoned due to strong shifting violent winds. The plt later stated the last thing he remembered was seeing 500 ft on the altimeter & telling himself 'to get up & out of there' the acft… - [NTSB ATL87FA047](https://openairdocs.org/ntsb/ATL87FA047.md): Cessna 310N · Savannah, GA · Accident · Serious injuries · Field investigation · Final report · Dec 23, 1986 · N4137Q · Substantial damage > During ILS rwy 9 appraoch acft disappeared from radar at one mile short of rwy. Acft impacted in level attitude with landing gear extended on a northerly heading one half mile short and about one quarter mile left of rwy centerline. Plt and CFI both stated… - [NTSB LAX87LA067](https://openairdocs.org/ntsb/LAX87LA067.md): Cessna 172M · Chico, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 1986 · N64533 · Substantial damage > During an ILS apch to rwy 13L, the plt thinking he was at the missed apch point collided with the terrain 200 yrds west of the arpt. The route of flt was determined to be in a north westerly direction. Exam of the navigational instruments revealed that the… - [NTSB CHI87FA054](https://openairdocs.org/ntsb/CHI87FA054.md): Bellanca 14-19-3A · West Chicago, IL · Accident · 4 fatal · Field investigation · Final report · Dec 22, 1986 · N1253R · Destroyed > At 0850 CST, the plt got a wx briefing for a flt to the dupage arpt. At that time, the current dupage wx was in part: partial obscn, 2 mi vis with fog; also, the plt was given svrl pireps for lgt to mod icing in southern Wisconsin. At 1231, he got a wx… - [NTSB NYC87LA051](https://openairdocs.org/ntsb/NYC87LA051.md): Cessna 201A · Scotias, NY · Accident · No injuries · Limited investigation · Final report · Dec 21, 1986 · N6615X · Substantial damage > The flight experienced an engine power loss when the throttle was reduced and the pilot turned the aircraft in an attempt to make the field, the aircraft was landed in a swampy area off the arpt when the field could not be reached. Investigation revealed no… - [NTSB NYC87LA050](https://openairdocs.org/ntsb/NYC87LA050.md): Piper PA-28-140 · Old Bridge, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 20, 1986 · N6192W · Destroyed > The plt took off fm the marlboro arpt & flew to 2 other arpts before lndg at the miller arpt at burgettstown, PA, where the eng was shut down. He had difficulty in starting the eng & remained on the gnd about 1 hr. The plt told an aviation safety inspector… - [NTSB DEN87IA032](https://openairdocs.org/ntsb/DEN87IA032.md): Swearingen SA226TC · Billings, MT · Incident · No injuries · Incident investigation · Final report · Dec 20, 1986 · N124AV · Minor damage > N124AV was operating as big sky airlines flt 3857, scheduled service from helena to Billings. The flt proceeded uneventfully until the apch into Billings. The flt crew stated after the incident that when the landing gear was extended, the left main gear… - [NTSB LAX87FA065](https://openairdocs.org/ntsb/LAX87FA065.md): Rockwell 112TC · Gardena, CA · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1986 · N112DM · Substantial damage > The pilot elected to return and land at his home airport when the aircraft's landing gear failed to retract after a night takeoff. After reentering the traffic pattern the pilot changed his fuel selector to the left tank for landing. As the aircraft turned… - [NTSB DCA87IA015](https://openairdocs.org/ntsb/DCA87IA015.md): ATR ATR-42 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Dec 18, 1986 · N423MQ · No damage > Drg arr, the flt was vectored for an ILS rwy 3R apch. At that time, ATIS info indcd mod mixed icing in clds. The capt rprtd the acft entered the cloud tops at 5500', was in the clds aprx 5 min & accumulated abt 1.5' of rime ice. He statedice accumulation was… - [NTSB CHI87LA052](https://openairdocs.org/ntsb/CHI87LA052.md): Cessna 172M · Middleton, WI · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1986 · N12841 · Substantial damage > At the completion of a period of instrument training and while returning to the airport of origin the CFI asked the private rated dual student to demonstrate a simulated forced landing to the runway. In an attempt to lose altitude on the final approach the… - [NTSB CHI87LA051](https://openairdocs.org/ntsb/CHI87LA051.md): Cessna 172RG · Bloominton, IN · Accident · Serious injuries · Limited investigation · Final report · Dec 18, 1986 · N9603B · Destroyed > According to the pilot he was cleared for the ILS approach and followed his glideslope and localizer indications in a normal manner. He eventually saw the ground prior to reaching his decision height of approx 200 feet AGL. This sighting of the ground was the… - [NTSB SEA87FA036](https://openairdocs.org/ntsb/SEA87FA036.md): Swearingen SA227AC · Salt Lake City, UT · Accident · No injuries · Field investigation · Final report · Dec 16, 1986 · N164SW · Substantial damage > The f/o was at the controls for the ILS apch to slc. Fog seeding was in progress, producing variable visibilities. The apch commenced with RVR well above cat I mins. At decision height(dh), the capt called 'lights in site'. The f/o continued the apch descent… - [NTSB LAX87LA064](https://openairdocs.org/ntsb/LAX87LA064.md): Cessna P210N · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Dec 15, 1986 · N3605P · Substantial damage > While the plt was receiving vectors for arrival at Chandler, AZ, the eng lost power. Subsequently, the plt made an emergency landing about 1 mi north of the arpt. He rprtd that he had filled the fuel tanks at Chandler & had flown to durango, co on 12/5/86. On… - [NTSB CHI87LA046](https://openairdocs.org/ntsb/CHI87LA046.md): Aeronca 11BC · Lake Village, IN · Accident · No injuries · Limited investigation · Final report · Dec 15, 1986 · N3969E · Substantial damage > The pilot stated that he gradually lost power while on final approach. He finally stalled the aircraft and pancaked it into the trees before the runway. The pilot also stated that he suspected carburetor ice was involved. - [NTSB CHI87LA044](https://openairdocs.org/ntsb/CHI87LA044.md): Cessna T303 · Benton Harbor, MI · Accident · No injuries · Limited investigation · Final report · Dec 11, 1986 · N9894T · Substantial damage > The plt was flying to Benton Harbor to get work done on a continuing problem with the right eng throttle. On final apch, the plt did not get a gear down indication and tried to cycle the gear. Not sure that the gear was down, the plt choose to go-around. When… - [NTSB ATL87MA041](https://openairdocs.org/ntsb/ATL87MA041.md): Beech 100 · Windsor, MA · Accident · 6 fatal · Major investigation · Final report · Dec 10, 1986 · N65TD · Destroyed > Drg arr for a LOC rwy 26 apch, the plt was adzd the abyss fan marker was notamed out-of-svc. With abyss inop, min dscnt alt (mda) was 2200'. After N65TD was clrd for the apch, radar svc was terminated & the flt was clrd to adzy freq. The crew contacted UNICOM… - [NTSB SEA87LA020](https://openairdocs.org/ntsb/SEA87LA020.md): Cessna 414A · Murtaugh, ID · Accident · Serious injuries · Limited investigation · Final report · Dec 7, 1986 · N37561 · Destroyed > During the transition from a DME arc to the ILS final apch course, the plt allowed the acft to prematurely descend into the ground. The reason for the descent could not be determined. However, no pre-impact mechanical malfunction with the acft was found nor… - [NTSB MIA87FA045](https://openairdocs.org/ntsb/MIA87FA045.md): North American Rockwell 112 · Jacksonville, FL · Accident · 1 fatal · Field investigation · Final report · Dec 7, 1986 · N1142J · Destroyed > The acft, being flown by a non-instrument rated plt, appeared over the arpt without making contact with the tower while the arpt was under instrument flt conditions and the control zone was in operation. After making several erratic passes the plt contacted… - [NTSB SEA87MA034](https://openairdocs.org/ntsb/SEA87MA034.md): Bell 206L-1 · Pendleton, OR · Accident · 3 fatal · Major investigation · Final report · Dec 4, 1986 · N7EC · Destroyed > The helicopter departed Pendleton on an emerg med svc/med-evac (EMS) flt to transport a patient to portland. After delivering the patient, the plt took off on the rtn flt with 2 med psnl aboard. Drg arrival at 1658 PST, he requested a special VFR (svfr)… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=181 ## 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=180 --- 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.