# NTSB investigations: Enroute 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 311 of 718 · 35,885 cases ## Cases, newest first - [NTSB DEN87LA163](https://openairdocs.org/ntsb/DEN87LA163.md): Cessna 182M · Livingston, MT · Accident · No injuries · Limited investigation · Final report · Jun 30, 1987 · N70952 · Substantial damage > The plt and an observer were conducting a search and rescue flt near the face of crazy mountain. The plt reported encountering a downdraft and the acft inadvertently stalled. The acft hit trees near the ridge line. - [NTSB NYC87LA194](https://openairdocs.org/ntsb/NYC87LA194.md): Champion 7GCB · Sullivan, NH · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 1987 · N5185X · Substantial damage > The pilot of the float equipped citabria 7GCBC experienced a power loss when he added power and raised his nose for a cruise climb from 3500 ft. he set up for a forced landing in a pond. As he neared touchdown, the engine regained power and responded to the… - [NTSB MKC87LA128](https://openairdocs.org/ntsb/MKC87LA128.md): Lowder Quickie II · Iowa City, IA · Accident · No injuries · Limited investigation · Final report · Jun 28, 1987 · N86KL · Substantial damage > The PIC rptd normal takeoff and climb during a LCL flt. Abt 15 min into the flt, the PIC experienced a nose down pitching. Throttle was reduced and level attitude was established. The PIC rptd difficulty maintaining level flt and made a precautionary lndg on… - [NTSB LAX87DVM03](https://openairdocs.org/ntsb/LAX87DVM03.md): Bell 47G-5 · Salinas, CA · Accident · No injuries · Final report · Jun 28, 1987 · N6288N · Substantial damage > At the end of an aerial application operation, enroute to the airport, the engine quit. The pilot autorotated the helicopter onto a soft field, where on touchdown, the helicopter was substantially damaged. Inspection of the helicopter revealed that the fuel… - [NTSB LAX87LA261](https://openairdocs.org/ntsb/LAX87LA261.md): Bell H-13 · Mojave, CA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1987 · N11HU · Substantial damage > During a pleasure cross country flight, the engine lost power at an alt of aprx 200 ft AGL. The plt entered an autorotative descent onto soft terrain. Upon touchdown, the main rotor blades severred the tail rotor from the boom. Shortly after the accident, the… - [NTSB LAX87LA252](https://openairdocs.org/ntsb/LAX87LA252.md): Beech A35 · Santa Rosa, CA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1987 · N255B · Substantial damage > The plt was participating in a cafe-400 (comparative acft flt efficiency) contest over a 400 mi, round robin course. While dscndg fm 7000' at the end of the flt, the plt slowed the acft to 140 mph to observe traffic. When clear, he increased the speed to 160… - [NTSB LAX87LA246](https://openairdocs.org/ntsb/LAX87LA246.md): Beech V35 · Clearlake, CA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1987 · N111MS · Substantial damage > During a cross country flight the engine experienced a loss of power. The plt made a forced landing on a road where during the landing roll the acft collided with a fence and eventually came to rest in a ditch. Inspection of the engine revealed extensive… - [NTSB LAX87DVM04](https://openairdocs.org/ntsb/LAX87DVM04.md): Rand KR-2 · Watsonville, CA · Accident · Minor injuries · Final report · Jun 27, 1987 · N75JL · Destroyed > Shortly after take-off on runway 19, the engine began 'sputtering' and losing power. The pilot tried adjusting mixture and throttle controls. The engine continued 'sputtering' and losing power and the pilot initiated an emergency descent. Having gained no… - [NTSB DCA87IA037](https://openairdocs.org/ntsb/DCA87IA037.md): Mcdonnell Douglas DC-10-30 · Miami, FL · Incident · Minor injuries · Incident investigation · Final report · Jun 27, 1987 · N391EA · No damage > Eal flight 23 experienced a rapid decompression during descent into Miami. Flight 23 departed lax with 3 flight crew, 8 f/a and 210 pax. On climbout the s/o observed that the manual outflow valve control wheel did not move toward the 1/2 closed position as it… - [NTSB NYC87FA192](https://openairdocs.org/ntsb/NYC87FA192.md): Cessna 182P · Ellenville, NY · Accident · 4 fatal · Field investigation · Final report · Jun 26, 1987 · N722DD · Destroyed > The acft collided with rising terrain in a mountainous area of minnewaska state park while climbing to cruise on a VFR flight. The crash site was about 1,430 feet higher in elevation than the departure airport. The weather at the departure airport was 1000… - [NTSB NYC87FA188](https://openairdocs.org/ntsb/NYC87FA188.md): Piper PA-32R-300 · Tannersville, NY · Accident · 2 fatal · Field investigation · Final report · Jun 26, 1987 · N7146C · Destroyed > While on a VFR air taxi cargo flight, the aircraft collided with trees on the east side of high peak mountain, elevation 3,655 feet. The accident site elevation was 3080 feet. A witness said it was heavy overcast, not raining and the clouds were not below the… - [NTSB MIA87FA191](https://openairdocs.org/ntsb/MIA87FA191.md): Rockwell 690A · Hilliard, FL · Accident · 2 fatal · Field investigation · Final report · Jun 24, 1987 · N57169 · Destroyed > Radar data indicated the acft climbed normally to 9,200 feet at which time some manuever was performed with the acft. The acft then entered a near vertical dive and the last radar hit was at 6,900 feet. Examination of the acft revealed it experienced an… - [NTSB CHI87LA158](https://openairdocs.org/ntsb/CHI87LA158.md): Cessna 175C · Oshkosh, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1987 · N7006M · Substantial damage > During cruise flight near Oshkosh the engine quit for undetermined reasons. The pilot contacted wittman field and was cleared by air traffic personnel to land on runway 27. Attempts to restart the engine were not successful and the pilot ditched the aircraft… - [NTSB CHI87LA157](https://openairdocs.org/ntsb/CHI87LA157.md): Cessna 172P · Ft. Wayne, IN · Accident · No injuries · Limited investigation · Final report · Jun 24, 1987 · N52362 · Destroyed > The pilot reported that the airspeed indicator failed in flight. The aircraft landed hard and porpoised. The nose wheel broke off and the aircraft skidded down the runway grinding off the bottom of the carburetor. A fire broke out destroying the aircraft.… - [NTSB LAX87LA242](https://openairdocs.org/ntsb/LAX87LA242.md): Cessna 310R · Kailua, HI · Accident · No injuries · Limited investigation · Final report · Jun 22, 1987 · N98836 · Destroyed > A Cessna 310R ditched in the pacific ocean aprx 500 NM sw Hawaii after an eng failure. The plt indicated that the #2 eng failed while in cruise flt at 8,000 ft MSL. Oil was observed leaking from the eng cowling. The acft was unable to maintain alt on #1 eng.… - [NTSB FTW87FA149](https://openairdocs.org/ntsb/FTW87FA149.md): Piper PA-60-601 · Hillsboro, TX · Accident · No injuries · Field investigation · Final report · Jun 22, 1987 · N7481S · Substantial damage > Aprx 3 min after leveling at 6500', the acft began losing pwr despite attempts to remedy the problem by using boost pump & x-feed. Subsequently, both engs lost power & the acft was damaged drg a wheels-up lndg in a milo field. An exam revealed the upper &… - [NTSB CHI87DEV02](https://openairdocs.org/ntsb/CHI87DEV02.md): Bell 47G2 · Peoria Heights, IL · Accident · No injuries · Final report · Jun 22, 1987 · N15395 · Substantial damage > Returning from a powerline patrol flight, the engine surged twice and quit. The pilot executed an autorotation to the only available landing site, a high school football field. On touchdown the blades flexed and severed the tailboom. Investigation revealed… - [NTSB CHI87DET07](https://openairdocs.org/ntsb/CHI87DET07.md): Mcentee Stitsplaymate SA-11A · Rolling Prairie, IN · Accident · 1 fatal · Final report · Jun 21, 1987 · N2813 · Destroyed > Aircraft crashed in open rising field killing pilot and destroying aircraft. Homebuilt aircraft was not ifr-equipped or certified. Pilot had less than ten hours on aircraft. No flight plan filed. No record of weather briefing, or in-flight weather advisory.… - [NTSB NYC87LA181](https://openairdocs.org/ntsb/NYC87LA181.md): Cessna 177RG · Batavia, NY · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N8021G · Substantial damage > The flt made an emgy lndg in a corn field after experiencing a loss of eng pwr. During lndg roll the acft collided with a fence. Examination of the propeller revealed that the low pitch stop was broken and had separated from the piston causing the blades to… - [NTSB SEA87IA119](https://openairdocs.org/ntsb/SEA87IA119.md): de Havilland DHC-8-101 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Jun 19, 1987 · N813PH · Minor damage > The crew of the scheduled airline passenger flight experienced an explosion and fire in the right engine at approx 800 ft AGL during initial climb after takeoff. The pilot shut the engine down, activated two fire bottles, which extinguished the fire and… - [NTSB MKC87LA125](https://openairdocs.org/ntsb/MKC87LA125.md): Schweizer G-164B · Hazen, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1987 · N8027K · Substantial damage > The PIC was returning to base of operations after completing an aerial application operation. Enroute, PIC experienced an engine failure and made a forced ldg in a farm field. After touchdown, acft nosed over and was substantially damaged. Subsequent… - [NTSB CHI87DEM08](https://openairdocs.org/ntsb/CHI87DEM08.md): Cessna 152 · Plainwell, MI · Accident · No injuries · Final report · Jun 19, 1987 · N47412 · Substantial damage > The aircraft experienced a total power failure and the pilot chose a wheat field on rising terrain for a forced landing. The field turned out to be rough and uneven. When the aircraft touched down, the nose gear failed and the aircraft nosed over. Subsequent… - [NTSB ATL87LA172](https://openairdocs.org/ntsb/ATL87LA172.md): Mooney M20A · Middlefield, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1987 · N8391E · Substantial damage > The acft struck a fence during a forced ldg, following a loss of engine pwr in flight. The plt reported that he had topped off both main fuel tanks prior to departure. About 10 minutes after departure at about 4000 ft MSL, he smelled fuel fumes in the… - [NTSB ATL87FA174](https://openairdocs.org/ntsb/ATL87FA174.md): Piper PA-28R-200 · Asheville, NC · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1987 · N900AJ · Destroyed > During a personal night x-country VFR flight over mountainous terrain the plt was informed by ATC that vip level 3 and 4 thunderstorms were positioned across the intended flt path. The 128 hour non-instrument rated private plt acknowledged and continued the… - [NTSB MIA87IA185](https://openairdocs.org/ntsb/MIA87IA185.md): Bell 47G-2 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Jun 17, 1987 · N17271 · Minor damage > While in cruise flt at aprx 300 ft the plt reported that he heard a loud noise followed by a loss of power. He then autorotated & set the helicopter down with no further incident. Insp of the eng revealed that the number 6 cylinder connecting rod failed near… - [NTSB NYC87LA175](https://openairdocs.org/ntsb/NYC87LA175.md): Grumman American AA-5B · Croton Fall, NY · Accident · No injuries · Limited investigation · Final report · Jun 16, 1987 · N1524R · Substantial damage > Abt 15 minutes aft tkof, the eng started to lose pwr. All efforts to restart it were unsuccessful and the acft was forced to land in a landfill. During lndg roll the acft collided with a hole and the gear sheared off. Exam of the eng revealed a burned piece… - [NTSB ATL87FA168](https://openairdocs.org/ntsb/ATL87FA168.md): Cessna 205C · Bowling Green, KY · Accident · 4 fatal · Field investigation · Final report · Jun 16, 1987 · N1823Z · Destroyed > Shortly after takeoff from Bowling Green, the pilot reported a problem. He did not report the details of the problem, but witnesses heard the aircraft backfiring as it descended. The aircraft had taken on fuel at Bowling Green. The investigation failed to… - [NTSB LAX87LA236](https://openairdocs.org/ntsb/LAX87LA236.md): Cessna T210L · Merced, CA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1987 · N59104 · Substantial damage > During a cross country flight, the engine lost power and quit aprx 4 miles from the airport. The pilot was unable to reach the runway and made a forced landing aprx 3 miles short of the runway. During the landing roll the aircraft collided with a fence and… - [NTSB CHI87DET06](https://openairdocs.org/ntsb/CHI87DET06.md): Kennedy Avid Flyer · Goshen, IN · Accident · No injuries · Final report · Jun 14, 1987 · N138RK · Substantial damage > While cruising at 1600 feet MSL, one propeller blade failed in the root area and departed the engine. The pilot made a successful emergency landing in a farmer's field. Vibrations, resulting from the unbalanced propeller condition, were of sufficient… - [NTSB CHI87DET05](https://openairdocs.org/ntsb/CHI87DET05.md): Bannwart Maxair XP-503 · Michigan City, IN · Accident · Serious injuries · Final report · Jun 14, 1987 · N171RB · Substantial damage > While in cruise flight the carburetor of this amateur built aircraft became detached and the engine failed. An emergency land was attempted, however obstacles prevented a landing at primary landing site and an alternate was selected. The aircraft was unable… - [NTSB MIA87LA182](https://openairdocs.org/ntsb/MIA87LA182.md): Cessna 172G · Caribbean Sea · Accident · No injuries · Limited investigation · Final report · Jun 13, 1987 · N4346W · Substantial damage > The plt became disoriented while flying from saint lucia to saint vincent after he incorrectly selected the wrong station when navigating using the adf. He contacted ATC who advised him to climb & was advised that the flt was aprx 20 miles west of saint… - [NTSB FTW87FA142](https://openairdocs.org/ntsb/FTW87FA142.md): Beech 35 · Cookson, OK · Accident · Serious injuries · Field investigation · Final report · Jun 13, 1987 · N3063V · Destroyed > Just after takeoff smoke was smelled and then observed in the cockpit. The pilot beleived that the smoke source was electrical and turned off the master switch. Just before touchdown flames began burning the pilots left leg. The aircraft was stopped on the… - [NTSB CHI87IA148](https://openairdocs.org/ntsb/CHI87IA148.md): Dornier DO-228-201 · Springfield, IL · Incident · No injuries · Incident investigation · Final report · Jun 13, 1987 · N88FB · Minor damage > The flightcrew experienced inflight opening of the aft baggage door and inflight separation of the cabin stairway door. The copilot checked the doors on three occasions before takeoff because the door warning light was illuminated. The captain initiated the… - [NTSB DEN87LA141](https://openairdocs.org/ntsb/DEN87LA141.md): Cessna T210H · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Jun 12, 1987 · N692RF · Substantial damage > The plt rprtd dscndg from 10,500 feet MSL for an apch to rwy 34 right at the Salt Lake City arpt. He stated he had selected landing flaps & had moved the mixture to rich & the prop to high RPM. At 8,500 MSL, 'the engine quit.' Subsequently, the plt made a… - [NTSB CHI87LA143](https://openairdocs.org/ntsb/CHI87LA143.md): Cessna 172N · Prairie Duchien, WI · Accident · No injuries · Limited investigation · Final report · Jun 12, 1987 · N4691G · Substantial damage > While in cruise flight, tape which was holding a piece of plexiglass over the cracked windshield came loose. The windshield lifted up and the pilot was not able to maintain altitude. During the forced landing in a soft field. The nose gear sheared off. - [NTSB LAX87LA233](https://openairdocs.org/ntsb/LAX87LA233.md): Cessna 150H · Porterville, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1987 · N23280 · Substantial damage > A Cessna 150H collided with terrain after a loss of power. The pilot stated his tanks were indicating 1/4 when the engine quit. He further stated that he 'misjudged landing speed and elevation' and when he turned to avoid power lines, the aircraft stalled.… - [NTSB ATL87IA166](https://openairdocs.org/ntsb/ATL87IA166.md): Boeing 737-200 · Columbus, OH · Incident · No injuries · Incident investigation · Final report · Jun 11, 1987 · N782N · No damage > Flt attendant rpted smoke in cabin and pungent odor which dissipated. After descent for landing was begun smoke and odor returned. Pax informed flt crew of smoke intensity and precautionalry landing was made at divert field. Subsequent exam revealed that the… - [NTSB DEN87LA146](https://openairdocs.org/ntsb/DEN87LA146.md): Hiller UH-12E · Grafton, ND · Accident · No injuries · Limited investigation · Final report · Jun 9, 1987 · N8286 · Substantial damage > The plt was positioning the helicopter for an aerial application project. Before taking off, he checked the fuel quantity indicator & estimated there was 30 min of fuel on board. The proposed flt was estimated to take 10 min. During flt, the eng lost power &… - [NTSB LAX87LA353](https://openairdocs.org/ntsb/LAX87LA353.md): Cessna 172P · Independence, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 8, 1987 · N55186 · Destroyed > The acft was rprtd missing after it departed san jose, CA, at about 1852 PDT on 6/9/87. A search was initiated, but the plane was not found until the wreckage was discovered by a hiker on 6/30/90. The acdnt occurred near kearsarge pass at an elev of 12,000… - [NTSB FTW87LA136](https://openairdocs.org/ntsb/FTW87LA136.md): Cessna 152 · Brownwood, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1987 · N49384 · Substantial damage > The engine failed during cruise flight due to fuel exhaustion. During the forced landing to a pasture the right horizontal stabilizer hit a tree and a limb became jammed between the stabilizer and the elevator jamming it in the full nose down position. The… - [NTSB ATL87LA169](https://openairdocs.org/ntsb/ATL87LA169.md): Piper PA-28-180 · Franklin, NC · Accident · No injuries · Limited investigation · Final report · Jun 8, 1987 · N3923R · Substantial damage > A 17 inch portion of one of the prop blades fractured and separated from the 76 inch dia prop while the acft was at cruise. During the forced landing the acft struck a fence post. Examination of the prop revealed the presence of filiform corrosion across the… - [NTSB ATL87LA162](https://openairdocs.org/ntsb/ATL87LA162.md): Beech V35B · Lexington, NC · Accident · No injuries · Limited investigation · Final report · Jun 8, 1987 · N55KP · Substantial damage > The airplane encountered rough terrain and impacted trees during a forced landing attempt in a field. The plt reported that the engine had lost pwr at 8,500 ft MSL. Post-accident exam of the engine revealed that the #1 cyl barrel had cracked and separated… - [NTSB SEA87LA110](https://openairdocs.org/ntsb/SEA87LA110.md): Piper PA28-151 · Aurora, OR · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N9232K · Substantial damage > During climbout at about 500 feet AGL for a touch and go, a loss of power occurred. Forced landing was accomplished onto a rough field where the left wing struck a small tree. The aircraft spun around and the nose gear and main gear collapsed. Examination of… - [NTSB NYC87LA162](https://openairdocs.org/ntsb/NYC87LA162.md): Cessna 182 · Vera Cruz, PA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N7426Q · Substantial damage > The plt rprtd that while en route at 3500 ft, the eng began to vibrate. About 1 min later, oil started covering the windshield & the cockpit began filling with smoke. He shut down the eng & looked for a place to land. Before landing, he restarted the eng, but… - [NTSB LAX87LA227](https://openairdocs.org/ntsb/LAX87LA227.md): Cessna 150L · Huelo, HI · Accident · No injuries · Limited investigation · Final report · Jun 6, 1987 · N10566 · Substantial damage > During a local pleasure sightseeing flight, the engine lost power and eventually quit. The plt initiated an emergency landing in a pineapple field where the acft collided with the terrain and nosed over. The acft was found to have aprx half a gallon of fuel… - [NTSB CHI87DEM07](https://openairdocs.org/ntsb/CHI87DEM07.md): Lake LA 4-200 · Fife Lake, MI · Accident · Minor injuries · Final report · Jun 6, 1987 · N80111 · Substantial damage > The plt stated that the engine started to run rough while in cruise flt. After all efforts to smooth it out failed, the plt elected to make a precautionary landing on Fife Lake. The acft landed normally followed by a loud noise and water started to enter the… - [NTSB ATL87LA159](https://openairdocs.org/ntsb/ATL87LA159.md): Piper PA-28-181 · Greer, SC · Accident · No injuries · Limited investigation · Final report · Jun 6, 1987 · N2846N · Substantial damage > Engine quit during descent for landing. PIC lnded in field, left wing struck tree and was separated from acft. PIC rpted no mechanical malfunctions. On post crash exam eng ran properly and right wing fuel quantity sys was operable. No fuel stains were seen on… - [NTSB ATL87LA158](https://openairdocs.org/ntsb/ATL87LA158.md): Balloon Works Firefly 7 · Kannapolis, NC · Accident · 1 fatal · Limited investigation · Final report · Jun 6, 1987 · N1511A · Substantial damage > The Balloon pilot was executing a landing approach to a clear area. He failed to see and avoid electrical power lines on the near side of the field as he made his approach. The Balloon collided with the power lines and the basket landed hard. The Balloon… - [NTSB NYC87LA164](https://openairdocs.org/ntsb/NYC87LA164.md): Bell 206L · Port Washington, NY · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1987 · N120RM · Substantial damage > The plt of a Bell 206L made a downwind tkof with the acft loaded more than 100 lbs over the maximum allowable gross tkof weight. At an altitude of approx 100 ft, while complying with noise abatement tkof procedures, the plt experienced decreasing main rotor… - [NTSB MKC87LA119](https://openairdocs.org/ntsb/MKC87LA119.md): Beech B35 · Keokuk, IA · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1987 · N7973D · Substantial damage > The PIC rptd a loss of manifold press during cruise flt and an inability to maintain alt. A forced lndg was made to the Keokuk arpt, but the PIC stated he was too high and fast for a lndg. The PIC made a go-around, but again approached too fast. Another… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=312 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=311 --- 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.