# 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 318 of 718 · 35,889 cases ## Cases, newest first - [NTSB MKC87FA022](https://openairdocs.org/ntsb/MKC87FA022.md): Piper PA-28-181 · Summersville, MO · Accident · 1 fatal · Field investigation · Final report · Nov 23, 1986 · N4326P · Destroyed > The PIC had flown his acft fm springfield, MO to olathe, Kansas to have some repair work accomplished and was to return that same day. The PIC never returned to springfield. The PIC had flown to salem, ill where witnesses stated they observed that he was… - [NTSB LAX87LA352](https://openairdocs.org/ntsb/LAX87LA352.md): Cessna 180K · Lakeport, CA · Accident · 2 fatal · Limited investigation · Final report · Nov 23, 1986 · N66039 · Destroyed > The plt & his daughter were believed to have depd his pvt airstrip on 11/22/86 or 11/23/86. They were rprtd missing on 11/24/86 & a search was begun, but the acft was not fnd until 8/19/88, when the wreckage was discovered by hunters. The crash site was… - [NTSB LAX87LA051](https://openairdocs.org/ntsb/LAX87LA051.md): Cessna 152 · Waipahu, HI · Accident · No injuries · Limited investigation · Final report · Nov 22, 1986 · N5327M · Substantial damage > The plt dragged both wings through a sugar cane crop during landing roll on a gravel road after a partial loss of power. The engine had 4040 total hours and had been previously overhauled 1655 hours prior. The plt indicated that the eng had a top overhaul… - [NTSB FTW87FA021](https://openairdocs.org/ntsb/FTW87FA021.md): Mooney M20E · Arcola, TX · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1986 · N9347M · Destroyed > The plt departed Arcola, TX, VFR, on rwy 10, made a 180 degree left climbing turn and entered clouds at about the boundary line on the west side of the arpt. The radar operator stated the acft continued westbound one to two miles beyond the arpt then entered… - [NTSB CHI87LA035](https://openairdocs.org/ntsb/CHI87LA035.md): Cessna 172G · Evansville, IN · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1986 · N3871L · Substantial damage > According to the plt, just after starting a descent from 300O feet, while inbound to Evansville dress regional airport(evv), the engine 'suddenly and without warning quit.' The plt stated that after deciding he could not make evv, he turned left and set up a… - [NTSB FTW87LA035](https://openairdocs.org/ntsb/FTW87LA035.md): Cessna 150L · Leander, TX · Accident · No injuries · Limited investigation · Final report · Nov 21, 1986 · N3230V · Substantial damage > The pilot made an emergency landing on a highway 20 miles nw of austin due to fule exhaustion. The aircraft received substantial damage to the right wing. The pilot then refueled the aircraft with auto gas from a passing truck and continued on to his… - [NTSB ATL87LA024](https://openairdocs.org/ntsb/ATL87LA024.md): Beech BE-19A · Waverly, TN · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 1986 · N6093N · Destroyed > The pilot reported an electrical failure, however the exact reason for the broken alternator belt was not determined. The wreckage examination disclosed that there was no fuel found in the aircraft system. There was also no fuel spillage. The pilot was not… - [NTSB SEA87FA027](https://openairdocs.org/ntsb/SEA87FA027.md): Cessna U206F · Moose Creek, ID · Accident · 1 fatal · Field investigation · Final report · Nov 20, 1986 · N7311Q · Destroyed > After departure and during the initial cruise climb the plt and pax heard a metallic clicking described as sounding like a 'valve tap' in an automobile and coming from the eng area. The plt executed an immediate course reversal back to the airstrip while… - [NTSB LAX87LA043](https://openairdocs.org/ntsb/LAX87LA043.md): Cessna A150M · Corona, CA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1986 · N2731J · Substantial damage > During a local flight, the pilot was practicing a simulated engine out procedure toward an open field on rolling terrain. He stated that he misjudged the rising terrain and got too low and slow to initiate a go-around. Subsequently, he was forced to land.… - [NTSB CHI87DEM04](https://openairdocs.org/ntsb/CHI87DEM04.md): Devries Sonerai II · Wayland, MI · Accident · Serious injuries · Final report · Nov 19, 1986 · N28KD · Destroyed > The volkswagen engine of this homebuilt aircraft lost power sometime during flight. Subsequently, the aircraft crashed during a forced landing in a field. The pilot received serious head injuries during impact and could not remember details of the accident.… - [NTSB MKC87FA020](https://openairdocs.org/ntsb/MKC87FA020.md): Cessna 182A · Bluff City, KS · Accident · 1 fatal · Field investigation · Final report · Nov 17, 1986 · N2038G · Destroyed > The plt stated that he was cruising at 2,500 ft MSL en route southbound to enid, Oklahoma, when he encountered fog but flew for 15 to 20 minutes before executing a 180DEG northerly turn back to hutchinson, KS. According to the plt, he was in the clouds trying… - [NTSB LAX87FA045](https://openairdocs.org/ntsb/LAX87FA045.md): Cessna 150L · Lake Isabella, CA · Accident · 2 fatal · Field investigation · Final report · Nov 17, 1986 · N18235 · Destroyed > The aircraft departed the kern valley airport, kernville, California, on a direct cross-country route to its home base at general william j. fox airfield, lancaster, California. The flight route was over mountainous terrain that was obscured by clouds. A… - [NTSB NYC87LA033](https://openairdocs.org/ntsb/NYC87LA033.md): Cessna 33TC · Phillipsburg, PA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1986 · N2581S · Substantial damage > The Cessna 337 experienced engine surging and plt made a precautionary landing at an airport while enroute to destination. The aircraft landed 200 ft short of the runway and received substantial damage while the two occupants were not injured. On scene… - [NTSB MIA87FA031](https://openairdocs.org/ntsb/MIA87FA031.md): Piper PA-32RT-300 · Columbus, MS · Accident · 1 fatal · Field investigation · Final report · Nov 12, 1986 · N21188 · Destroyed > The acft departed Columbus, MS, en route to meridian, MS, to pick up cargo for a return flt to Columbus. The acft did not arrive at its destination and was later found in an open field about 2 miles southwest of the golden triangle regional airport in… - [NTSB ATL87IA020](https://openairdocs.org/ntsb/ATL87IA020.md): Boeing 727-227 · Livingston, TN · Incident · No injuries · Incident investigation · Final report · Nov 12, 1986 · N471BN · 2 aircraft · No damage > The braniff and united Boeing 727 jetliners were approaching 'swapp' intersection on converging jetways at their proper assigned alt of 35,000'. The controller was in the process of issuing radar vectors to assure proper lateral separation when the control… - [NTSB MKC87LA019](https://openairdocs.org/ntsb/MKC87LA019.md): Cessna 152 · Gretna, NE · Accident · No injuries · Limited investigation · Final report · Nov 11, 1986 · N5175M · Substantial damage > The instructor stated that this training flight would emphasize power reduction manuevers, to include: slow flight, power-off stalls, and flight at minimum controllable airspeed. Thirty minutes into the flight, and during the application of power for… - [NTSB CHI87LA022](https://openairdocs.org/ntsb/CHI87LA022.md): Piper PA-28R-200 · South Bend, IN · Accident · Minor injuries · Limited investigation · Final report · Nov 10, 1986 · N578PA · Substantial damage > During cruise at 7000' MSL, the plt assumed that he was having an electrical failure because he had not heard any ARTCC transmissions, fuel gauges were indicating low fuel, ammeter reading was zero, and landing gear would not cycle. He shut off all electrical… - [NTSB ANC87IA012](https://openairdocs.org/ntsb/ANC87IA012.md): Mcdonnell Douglas DC-10 · Adak, AK · Incident · No injuries · Incident investigation · Final report · Nov 10, 1986 · CGCPJ · 2 aircraft · No damage > A canadian pacific Mcdonnell Douglas DC-10 (flt 3), cg-cpj, & a reeve aleutian Boeing 727 (flt 724), N832, were clrd to fly at FL 290 on 2 different airways. The airways crossed at picum intxn, ovr the bearing sea. While traveling in nrly opposite drctns at… - [NTSB LAX87LA036](https://openairdocs.org/ntsb/LAX87LA036.md): Cessna 150L · Elk Grove, CA · Accident · No injuries · Limited investigation · Final report · Nov 9, 1986 · N5360Q · Substantial damage > As the plt was returning from a local flight, the engine lost power for about 15 seconds, then restarted. The plt checked the fuel gauges which indicated one tank was empty and the other was 1/4 full. At about 1-1/2 miles from the airport, the engine lost… - [NTSB ATL87LA019](https://openairdocs.org/ntsb/ATL87LA019.md): Cessna 152 · Conway, SC · Accident · No injuries · Limited investigation · Final report · Nov 9, 1986 · N6537P · Substantial damage > One blade of the fixed pitch propeller separated 3' from the hub during a routine instructional flight. The imbalance resulted in a broken engine mount and a total loss of power was experienced. A forced landing was made in a soft field during which, the… - [NTSB ATL87LA018](https://openairdocs.org/ntsb/ATL87LA018.md): Cessna 152 · Lexington, NC · Accident · No injuries · Limited investigation · Final report · Nov 9, 1986 · N6617L · Destroyed > During a local instructional flight, the CFI was demonstrating a simulated emergency landing to a field to a 5 hour pre-solo student pilot. During recovery the aircraft was reportedly affected by a downdraft and collided with a wire. The acft began losing… - [NTSB SEA87LA021](https://openairdocs.org/ntsb/SEA87LA021.md): Bellanca BL17-30 · Beatty, NV · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 1986 · N4797V · Substantial damage > While in cruise at 11,500 ft MSL, fuel pressure and engine pwr were lost. Plt tried variations of fuel tank selections and boost pump with no success. During forced landing attempt at remote airstrip, plt misjudged approach, stalled acft about 100 yds short… - [NTSB MIA87LA027](https://openairdocs.org/ntsb/MIA87LA027.md): Beech A100 · Brooksville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 1986 · N78L · Destroyed > The pilot stated that shortly after departure the cockpit filled with smoke. While returning for landing his visibility was reduced due to the smoke and ground fog. On landing roll the the aircraft ran off the left side of the runway, went through a cow fence… - [NTSB BFO87MA007](https://openairdocs.org/ntsb/BFO87MA007.md): Beech 65-A80 · Baltimore, MD · Accident · 1 fatal · Major investigation · Final report · Nov 8, 1986 · N304D · Destroyed > Drg clb after tkof, l eng seized. Plt said he atmtd 1 eng restart; prop would not rotate or feather. No emerg declared. Plt stated eng shut-dwn proc was used, scientific bus sws were shut off, r gen was recycled & appeared to oper normally. Plts got imt… - [NTSB SEA87FA019](https://openairdocs.org/ntsb/SEA87FA019.md): Beech BE35K · Marysville, WA · Accident · 2 fatal · Field investigation · Final report · Nov 7, 1986 · N9536R · Destroyed > A witness observed the acft impact in an open field during a heavy rain. Rain, fog, and turbulence in the clouds were reported in the area at the time. The acft impacted in a right turn. The new instrument rated plt was getting complex acft time in… - [NTSB MIA87LA026](https://openairdocs.org/ntsb/MIA87LA026.md): Piper PA-23-250 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Nov 7, 1986 · N2107C · Destroyed > While being followed at a low altitude by a united states customs service aircraft, the aircraft was observed entering a left turn. The left wing tip of the aircraft struck the water and it cartwheeled. After the crash, bales of an unknown substance floated… - [NTSB LAX87MA044](https://openairdocs.org/ntsb/LAX87MA044.md): Mcdonnell Douglas DC-10-10 · Los Angeles, CA · Accident · Serious injuries · Major investigation · Final report · Nov 7, 1986 · N68043 · No damage > The captain stated that about 90 min after departure, the acft experienced an abrupt pitch-up, followed by an abrupt pitch-down. Drg the occurrence, one flt attendant was seriously injured; two flt attendants & one passenger received minor injuries. The… - [NTSB DEN87FA018](https://openairdocs.org/ntsb/DEN87FA018.md): Bell 206L-3 · Billings, MT · Accident · Serious injuries · Field investigation · Final report · Nov 7, 1986 · N3889S · Destroyed > While on takeoff from a hospital roof top helipad on an emergency medical service flt, a synchronized elevator cover blew off and struck the tail rotor. This resulted in an inflight separation of one tail rotor blade and a loss of anti-torque control. The plt… - [NTSB CHI87FA021](https://openairdocs.org/ntsb/CHI87FA021.md): Cessna 182P · Goreville, IL · Accident · 1 fatal · Field investigation · Final report · Nov 7, 1986 · N9124M · Destroyed > The acft crashed and burned following a collision with a guy-wire supporting a micro-wave tower. The plt had initiated the flt in MVFR weather and continued the VFR flt into IMC conditions. The crash site was located adjacent to interstate hwy 57 and… - [NTSB SEA87MA018](https://openairdocs.org/ntsb/SEA87MA018.md): Cessna 401 · Henderson, NV · Accident · 2 fatal · Major investigation · Final report · Nov 6, 1986 · N3219Q · Destroyed > Approximately 5 1/2 minutes after departure and while the aircraft was climbing enroute, an unknown ignition source triggered an explosion of fuel/air vapor which existed within the interior of the left wing. Wing skin from the upper/lower wing surface was… - [NTSB NYC87LA030](https://openairdocs.org/ntsb/NYC87LA030.md): Bell 206B · Staten Island, NY · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 1986 · N83086 · Substantial damage > The on-demand cargo flight encountered a bird strike enroute from new jersey to jamaica, new york. The pilot received serious injury to the eye and checkbone but was able to accomplish an emergency landing in a parking lot without further damage or injury. - [NTSB MIA87FA025](https://openairdocs.org/ntsb/MIA87FA025.md): Cessna 152 · Woodville, FL · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1986 · N49083 · Destroyed > The non-instrument rated private plt had received his certificate two days prior to the accident. The flight was receiving stage three radar service when it advised that it was in the clouds and was turning around. Radar contact was lost moments later and the… - [NTSB CHI87IA026](https://openairdocs.org/ntsb/CHI87IA026.md): Boeing 757-251 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Nov 6, 1986 · N516US · No damage > Drg an en route climb, aileron control (ctl) bcm progressively more stiff. At cruise alt, the autoplt disengaged & the ailerons would not move. Aileron ctl was restored after a dscnt below the freezing level. The acft was flown below the freezing lvl for the… - [NTSB MKC87LA016](https://openairdocs.org/ntsb/MKC87LA016.md): Cessna 150F · Louisburg, KS · Accident · No injuries · Limited investigation · Final report · Nov 5, 1986 · N3507L · Substantial damage > The instructor stated that he had observed the student visually check the fuel supply bu that he did not personally inspect the tanks, assuming they were full. According to the pilot, his only confirmation of full tanks was the students repeated statements… - [NTSB MIA87LA021](https://openairdocs.org/ntsb/MIA87LA021.md): Smith, Ted Aerostar 601P · Jacksonville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 5, 1986 · N8002J · Destroyed > While in cruise flight, the pilot noted that the left engine began losing power and oil pressure. He stated that he then shut down the engine and feathered the propeller. He declared an emergency and descended to land. While on final approach, he lowered the… - [NTSB CHI87LA017](https://openairdocs.org/ntsb/CHI87LA017.md): Cessna 150M · Ramsey, MN · Accident · No injuries · Limited investigation · Final report · Nov 5, 1986 · N7680U · Substantial damage > The newly certficated pilot thought his fuel gages were not indicating properly and did not dip the tanks during preflight. On the last leg of the round robin flt fuel exhaustion occurred and the acft nosed over during the forced landing. The plt reported he… - [NTSB CHI87FA018](https://openairdocs.org/ntsb/CHI87FA018.md): Gates Learjet 23 · Charleston, WV · Accident · Serious injuries · Field investigation · Final report · Nov 5, 1986 · N344WC · No damage > The PIC lost consciousness during cruise near Charleston WV while on a revenue flt. The co-plt assumed command and landed at Charleston WV without further incident. The PIC was hospitalized and the flt continued on to detroit mi after a replacement PIC was… - [NTSB SEA87LA017](https://openairdocs.org/ntsb/SEA87LA017.md): Champion 7ECA · Paisley, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1986 · N8338V · Substantial damage > The acft contacted power lines during a night forced landing on a highway following a loss of pwr. The power lines paralleled the road. Investigation revealed no discrepancies with the engine or fuel system. Planned fuel reserve was found in the tanks. The… - [NTSB SEA87LA016](https://openairdocs.org/ntsb/SEA87LA016.md): Piper PA-24-400 · Oregon City, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 1986 · N8419P · Substantial damage > Shortly after takeoff, an eng failure occurred. The plt elected to make a forced lndg on a freeway. During the landing, the acft collided with two vehicles. An inspection revealed an eng oil line had ruptured which led to oil exhaustion. Evidence indicated… - [NTSB LAX87LA031](https://openairdocs.org/ntsb/LAX87LA031.md): Luscombe 8A · Half Moon Bay, CA · Accident · No injuries · Limited investigation · Final report · Nov 1, 1986 · N71745 · Substantial damage > The acft collided with the terrain during a forced landing following a loss of engine power. The plt indicated that he retarded the throttle and applied the carburetor heat to descend from 3,000 to 2,000 ft when the engine quit. He was unable to restart the… - [NTSB FTW87LA011](https://openairdocs.org/ntsb/FTW87LA011.md): Cessna 182Q · Plainview, TX · Accident · No injuries · Limited investigation · Final report · Nov 1, 1986 · N97814 · Substantial damage > The plt rprtd that aprx 25 min after he took off, the eng lost power. He made an emergency landing in a plowed field where the acft nosed over. During an investigation, only traces of fuel were found in the acft. There was no evidence that fuel had drained… - [NTSB NYC87LA028](https://openairdocs.org/ntsb/NYC87LA028.md): Cessna 152 · Linden, NJ · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 1986 · N758YR · Substantial damage > The flight experienced an engine power loss during cruise. Pwr was restored and the acft proceeded the pilot was able to return to the airport and made a soft field landing, collapsing the nose wheel during landing roll. The reason for the pwr loss was not… - [NTSB LAX87LA030](https://openairdocs.org/ntsb/LAX87LA030.md): Piper PA-31-350 · Eleele Kauai, HI · Accident · No injuries · Limited investigation · Final report · Oct 31, 1986 · N33WH · Substantial damage > A Piper pa 31-350 lost power and collided with sign posts after landing on a road. It was reported to the FAA that the aircraft's right engine was producing partial power and the aircraft was unable to maintain altitude on the left engine. The pilot never… - [NTSB NYC87FA027](https://openairdocs.org/ntsb/NYC87FA027.md): Piper PA-31-325 · Mansfield, MA · Accident · Serious injuries · Field investigation · Final report · Oct 30, 1986 · N200GG · 2 aircraft · Substantial damage > Piper PA-31, N200GG, was on a VFR flt to boston, MA. The PA-31 plt contacted boston TRACON & adzd he had ATIS info & would be lndg at boston. TRACON suggested a hdg & alt of 070 deg & 2500' for rwy 33R & told the plt to maint VFR. At aprx the same time, a… - [NTSB MKC87LA011](https://openairdocs.org/ntsb/MKC87LA011.md): Grumman G164B · Memphis, MO · Accident · No injuries · Limited investigation · Final report · Oct 30, 1986 · N6608Q · Destroyed > The aerial application acft was en route to seed a wheat field when smoke came into the cockpit. The plt made a precautionary landing on a blacktop road. The road was the best available, but was not adequate and acft flipped forward to the inverted position.… - [NTSB NYC87LA026](https://openairdocs.org/ntsb/NYC87LA026.md): Cessna U206F · Marshfiled, MA · Accident · No injuries · Limited investigation · Final report · Oct 29, 1986 · N9585G · Substantial damage > Electrical failure occurred in flight due to an alternator belt failure. The acft landed in the grass beside the rwy and was damaged. The landing was difficult due to darkness, fog and no lights. The plt tried to use flaps but failed due to no elec power. The… - [NTSB NYC87FA025](https://openairdocs.org/ntsb/NYC87FA025.md): Bell 206B · Brattleboro, VT · Accident · 1 fatal · Field investigation · Final report · Oct 29, 1986 · N52EG · Destroyed > The helicopter crashed into a wooded ridge aprx 2 NM from it's liftoff location. Persons who reside under the flt path were awakened by the acft as it was descending into IMC at what sounded like full power. The plt's heliport was at an elevation of 950 ft… - [NTSB DEN87FA046](https://openairdocs.org/ntsb/DEN87FA046.md): Piper PA-24-250 · Leyba, NM · Accident · 1 fatal · Field investigation · Final report · Oct 29, 1986 · N8323P · Substantial damage > The plt departed albuquerque on October 29, 1986, in his acft for an unknown destination. When he failed to return to his home, relatives notified local authorities. A search was begun and on January 23, 1987, the wreckage was found. The pilot was deceased… - [NTSB MIA87FA013](https://openairdocs.org/ntsb/MIA87FA013.md): Grumman G-73 · St. Croix · Accident · 1 fatal · Field investigation · Final report · Oct 28, 1986 · N604SS · Substantial damage > The plts lost aileron control shortly after takeoff while in a left turn. The left turning tendencies of the acft could not be corrected and the acft crash landed in the carribean sea. Post crash inspection of the acft revealed the left aileron control cable… - [NTSB ATL87FA012](https://openairdocs.org/ntsb/ATL87FA012.md): Piper PA-32-260 · Lawrenceville, GA · Accident · Serious injuries · Field investigation · Final report · Oct 28, 1986 · N3285W · Destroyed > About 20 min after takeoff, while cruising at 6500', the eng lost power. Rprtdly, the eng went to either idle or a wind-milling cond & the fuel pressure dropped to zero. The plt tried to restart the eng by using emerg procedures, but was unable. He initially… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=319 ## 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=318 --- 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.