# 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 305 of 718 · 35,885 cases ## Cases, newest first - [NTSB LAX88LA066](https://openairdocs.org/ntsb/LAX88LA066.md): Piper PA-38-112 · Dunsmuir, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 1987 · N123JY · Destroyed > A Piper PA-38-112 collided with terrain while on a night VFR cross country flight. Night instrument meteorological conditions prevailed at the time and no flight plan was filed. The pilot received a weather briefing prior to departure. His destination weather… - [NTSB CHI88DEV01](https://openairdocs.org/ntsb/CHI88DEV01.md): Cessna 150L · Marion, IL · Accident · 1 fatal · Final report · Dec 5, 1987 · N7533G · Substantial damage > Pilot in command suffered a fatal heart attack. His wife, a private pilot, attempted to land the aircraft, lost control on landing roll and struck a runway light. - [NTSB ATL88MA053](https://openairdocs.org/ntsb/ATL88MA053.md): Hawker Siddeley HS-125-400A · Lexington, KY · Accident · 2 fatal · Major investigation · Final report · Dec 5, 1987 · N400PH · Destroyed > While en route at FL 370, the plts declared an emerg, rprtd a fire in the rgt eng & reqd vectors to the nearest suitablearpt. They were vectored twd the Lexington bluegrass arpt & clrd to dscnd. Shortly after declaring an emerg, the plts rprtd they secured… - [NTSB NYC88LA053](https://openairdocs.org/ntsb/NYC88LA053.md): Piper PA-28RT · Houlton, ME · Accident · No injuries · Limited investigation · Final report · Dec 4, 1987 · CGRQU · Destroyed > During a personal transportation flight to quebec city in Canada and while cruising at about 6500 feet, the aircraft experienced an oil pressure light illumination, 43 nautical miles nnw of Houlton VOR on a 306 degree heading. The engine then started to run… - [NTSB FTW88DPA01](https://openairdocs.org/ntsb/FTW88DPA01.md): Bell 206B · Dallas, TX · Accident · No injuries · Final report · Dec 4, 1987 · N206DW · Substantial damage > The fuel pump warning light came on and the pilot headed for a local airport. Enroute, the engine surged and flamed out. During the landing, the rotor blades hit trees, and the helicopter made a hard landing. The fuel gage indicated 11 gallons. Later the gage… - [NTSB ATL88FA052](https://openairdocs.org/ntsb/ATL88FA052.md): Piper PA-60-600 · Mansfield, OH · Accident · Serious injuries · Field investigation · Final report · Dec 4, 1987 · N500TS · Destroyed > The pilot departed louisville, KY reportedly with a known oil leak in the right engine and was on the second leg of an on-demand air taxi cargo flight. About 14 minutes after entering Mansfield approach control airspace, the pilot requested and received an… - [NTSB MIA88LA051](https://openairdocs.org/ntsb/MIA88LA051.md): Piper PA-38-112 · San Antonio, FL · Accident · No injuries · Limited investigation · Final report · Dec 2, 1987 · N2405F · Substantial damage > The student plt became lost while on a solo x-c training flt. He attempted to contact his non control tower destination airport via UNICOM. He stated that he flew around for 20 or 25 mins attempting to make UNICOM contact & was unsuccessful in doing so. He… - [NTSB LAX88DVG02](https://openairdocs.org/ntsb/LAX88DVG02.md): Grumman G-164A · Williams, CA · Accident · No injuries · Final report · Dec 2, 1987 · N673U · Substantial damage > Shortly after takeoff, the engine experienced a loss of engine power. The pilot made a forced landing and collided with a fence on hilly terrain during the landing roll. The engine was inspected with no reported mechanical failures or malfunctions. Wx… - [NTSB FTW88LA034](https://openairdocs.org/ntsb/FTW88LA034.md): Cessna 150 · Mangum, OK · Accident · No injuries · Limited investigation · Final report · Dec 2, 1987 · N3888V · Substantial damage > According to the pilot, the engine started running rough during cruise flight. He elected to make a forced landing and intentionally stalled the aircraft into some trees to cushion the impact, substantially damaging the aircraft. The pilot further stated that… - [NTSB LAX88FA060](https://openairdocs.org/ntsb/LAX88FA060.md): Piper PA-46 · Long Beach, CA · Accident · 1 fatal · Field investigation · Final report · Nov 30, 1987 · N4369V · Destroyed > Pilot's failure to land the aircraft after experiencing the pilot's faulty decision was his previous experience with a gear up landing a couple of years before. - [NTSB ATL88MA048](https://openairdocs.org/ntsb/ATL88MA048.md): Beech C90 · Beaufort, SC · Accident · 2 fatal · Major investigation · Final report · Nov 30, 1987 · N4463W · Destroyed > At 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the… - [NTSB NYC88LA047](https://openairdocs.org/ntsb/NYC88LA047.md): Piper PA-28-180 · E.Harwich Port, MA · Accident · No injuries · Limited investigation · Final report · Nov 28, 1987 · N9714J · Destroyed > The pilot departed chatham airport for a local pleasure flight. Shortly after takeoff and while turning left in the pattern, the engine suffered a power loss. The pilot prepared for an emergency landing and transmitted a 'may day'. The aircraft crashed in a… - [NTSB MKC88LA022](https://openairdocs.org/ntsb/MKC88LA022.md): Mooney M20J · Springdale, AR · Accident · No injuries · Limited investigation · Final report · Nov 28, 1987 · N201CQ · Substantial damage > Drg a wx briefing bfr tkof, the plt was adzd that VFR flt was not rcmdd due to low ceiling & icing conds. He was adzd the freezing lvl was forecast to be at 4000' over little rock & to slope down to the surface in se Missouri. Also, he was briefed on pireps… - [NTSB CHI88LA031](https://openairdocs.org/ntsb/CHI88LA031.md): Piper PA-24-180 · Danville, IL · Accident · No injuries · Limited investigation · Final report · Nov 28, 1987 · N5611P · Substantial damage > Earlier in the day, the acft was flown from Danville to rochelle, IL. While on a return flt without refueling, the eng began losing power, so the plt moved the fuel selector to the rgt tank (which indcd 1/4 full) & power was restored. However, about 2 min… - [NTSB LAX88LA062](https://openairdocs.org/ntsb/LAX88LA062.md): Beech P35 · Maricopa, CA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1987 · N413EE · Substantial damage > During a pleasure cross country flt, a precautionary landing was made due to smoke in the cockpit and a low oil pressure indication. After landing, it was found that the oil line to the oil pressure gauge was broken. After repairs, the plt took off and 10… - [NTSB BFO88FA008](https://openairdocs.org/ntsb/BFO88FA008.md): Piper PA-32-260B · Willis, VA · Accident · 3 fatal · Field investigation · Final report · Nov 27, 1987 · N4832S · Destroyed > The acft was on a night IFR flight at 7000 ft MSL in IMC when the plt reported the directional gyro was inoperative. The acft was outbound from the pulaski VOR on V45 headed southeast. The plt further reported the turn&bank and the mag compass were operative.… - [NTSB ANC88FA021](https://openairdocs.org/ntsb/ANC88FA021.md): Cessna 185 · Fairbanks, AK · Accident · 3 fatal · Field investigation · Final report · Nov 27, 1987 · N4056Y · Destroyed > The pilot and his two passengers were returning from a hunting trip when the airplane crashed 7 miles from the Fairbanks international airport. The airplane struck the ground in a vertical attitude at a high rate of speed. Evidence at the scene suggests that… - [NTSB NYC88LA049](https://openairdocs.org/ntsb/NYC88LA049.md): Piper PA-18-150 · Gloucester, NJ · Accident · No injuries · Limited investigation · Final report · Nov 26, 1987 · N1590R · Substantial damage > The flight departed leddon's farm for an engine check in an extended traffic pattern. Shortly after takeoff, the engine suffered a power reduction from 2200 RPM to about 1000 RPM. A short plowed farm field was selected for a forced landing. The aircraft… - [NTSB LAX88LA059](https://openairdocs.org/ntsb/LAX88LA059.md): Hughes 369HS · Lihue, Kauai, HI · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 1987 · N77DJ · Substantial damage > Pilot failure to maintain adequate main rotor RPM. - [NTSB DEN88FA030](https://openairdocs.org/ntsb/DEN88FA030.md): Beech J35 · Knolls, UT · Accident · 2 fatal · Field investigation · Final report · Nov 26, 1987 · N2EE · Destroyed > The last comm with the flt was when the plt contacted elko radio and requested the salt lake city wx. He reported that he was at 11500 ft and VFR on top. The specialist on duty was unable to provide the wx info due to a computer sys outage but recommended… - [NTSB FTW88FA032](https://openairdocs.org/ntsb/FTW88FA032.md): Beech H35 · Port Mansfield, TX · Accident · 3 fatal · Field investigation · Final report · Nov 25, 1987 · N5568D · Destroyed > The plt rcvd svrl wx briefings bfr tkof & was adzd of convective activity along the initial route of flt north of the arpt. The planned dep route was twd the wx. While discussing altn routing possibilities, the plt indcd he would ask ATC for deviation arnd… - [NTSB DEN88LA029](https://openairdocs.org/ntsb/DEN88LA029.md): Cessna 182RG · Boulder, MT · Accident · No injuries · Limited investigation · Final report · Nov 25, 1987 · N2283T · Destroyed > While on a cross country flt at 6000 ft MSL, the eng lost power. Exam of the acft revealed that the left fuel tank contained 23 gallons while the right was empty. The fuel selector was found on the empty tank. The acft was destroyed during the emergency… - [NTSB NYC88LA046](https://openairdocs.org/ntsb/NYC88LA046.md): Cessna 152 · Mendham, NJ · Accident · No injuries · Limited investigation · Final report · Nov 24, 1987 · N5520H · Substantial damage > The flight instructor had simulated an engine failure. The instructor pulled the throttle to idle and the student went through the checklist procedure for emergency landing. When the student plt applied power for the go-around the engine restarted for about… - [NTSB LAX88LA054](https://openairdocs.org/ntsb/LAX88LA054.md): Cessna 152 · San Clemente, CA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1987 · N5418P · Substantial damage > A partial loss of eng power occurred while the student plt was on a solo x-country flt. He applied carb heat, but to no avail. The eng continued to run rough & the plt made an emergency landing on upward sloping terrain. During the landing roll, the nose gear… - [NTSB ATL88FA044](https://openairdocs.org/ntsb/ATL88FA044.md): Piper PA-32R-301 · Commercial Pt, OH · Accident · 2 fatal · Field investigation · Final report · Nov 24, 1987 · N8046X · Destroyed > The acft crashed on a wheat field during a night instrument training flt. The plt had declared a vacuum system failure about 40 minutes after take-off but he declined ATC assistance for a no-gyro approach to columbus. Two minutes after the radio call radar… - [NTSB SEA88FA021](https://openairdocs.org/ntsb/SEA88FA021.md): Cessna 210E · Port Townsend, WA · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1987 · N4956U · Destroyed > The aircraft flew into the side of maynard mountain, the point of a coastal land mass, while on a night VFR flight in IMC wx conditions. Radar data showed the aircraft on a straight course at cruise airspeed. - [NTSB LAX88LA053](https://openairdocs.org/ntsb/LAX88LA053.md): Bellanca 8GCBC · San Diego, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1987 · N53917 · Destroyed > As the plt was completing a banner towing opn, he applied pwr to climb from 500' to 1500' to return to the arpt. As he advanced the throttle, the eng began running rough, then lost pwr. He said the cockpit filled with smoke & he released the banner. He… - [NTSB ATL88FA040](https://openairdocs.org/ntsb/ATL88FA040.md): Piper PA-24-250 · Lewisburg, KY · Accident · Serious injuries · Field investigation · Final report · Nov 21, 1987 · N6450P · Substantial damage > The pilot experienced a loss of engine power at 5500 feet. He was not able to start the engine after completing an emergency procedure. The pilot established an approach to a landing area, and stalled the aircraft on short final. The aircraft moved about 30… - [NTSB LAX88LA051](https://openairdocs.org/ntsb/LAX88LA051.md): Piper PA-31-350 · Honolulu, HI · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 1987 · N27512 · Substantial damage > The pilot estimated that the aircraft's reduced fuel quantity was adequate for the flight during his preflight inspection. As the aircraft descended for the traffic pattern near the destination airport both engines failed. After the loss of power the pilot… - [NTSB SEA88LA020](https://openairdocs.org/ntsb/SEA88LA020.md): Cessna 172M · Sequim, WA · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1987 · N70334 · Destroyed > During dark night visual meteorological conditions, the aircraft struck trees while in cruise flt at about 2,000 feet MSL. Although the pilot had requested VFR traffic advisories, he did not solicit the use of the low altitude alert system. This system was… - [NTSB MIA88LA041](https://openairdocs.org/ntsb/MIA88LA041.md): Piper PA-28R-201 · Roseland, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 1987 · N36066 · Substantial damage > The acft was preflighted approx 20 min after refueling with no discrepancies noted. The plt had difficulty starting the acft. Mechanics flushed the acft fuel lines and declared the acft ok. No water was found in the fuel sumps or strainer during the plts… - [NTSB CHI88FA024](https://openairdocs.org/ntsb/CHI88FA024.md): Beech TC-45J · St Clair Shores, MI · Accident · Serious injuries · Field investigation · Final report · Nov 19, 1987 · N10AS · Destroyed > While enroute to home base after delivery of revenue cargo, the pilot experienced a total loss of engine power in both engines due to fuel exhaustion. The pilot performed emergency procedures and set the aircraft up for a forced landing in a grassy field on… - [NTSB BFO88FA007](https://openairdocs.org/ntsb/BFO88FA007.md): Cessna 152 · Warrenton, VA · Accident · 2 fatal · Field investigation · Final report · Nov 19, 1987 · N757ER · Destroyed > The acft was observed to be flying straight and level when the sounds of the eng were heard to increase. The only witness saw the acft nose over and dive into the ground. Radar tracking of the acft flt path confirms this. Investigation revealed that the this… - [NTSB SEA88IA019](https://openairdocs.org/ntsb/SEA88IA019.md): Beech 99-A · Port Angeles, WA · Incident · No injuries · Incident investigation · Final report · Nov 17, 1987 · N806BA · Minor damage > Both generator lights came on along with the left and right fuel pressure lights. The aircraft was being flown back to the airport for a precautionary landing, when the annunciator panel lights began to flicker. When landing flaps were selected they did not… - [NTSB CHI88LA027](https://openairdocs.org/ntsb/CHI88LA027.md): Cessna 150J · Patoka, IN · Accident · No injuries · Limited investigation · Final report · Nov 17, 1987 · N86WA · Substantial damage > While enroute to Patoka airport for fuel the aircraft experienced fuel exhaustion and the pilot was forced to make an emergency landing in a field. The aircraft landed approximately two miles northeast of the airport. The nose gear of the aircraft became… - [NTSB MKC88FA021](https://openairdocs.org/ntsb/MKC88FA021.md): Piper PA-28-180 · Mena, AR · Accident · 1 fatal · Field investigation · Final report · Nov 16, 1987 · N9131J · Destroyed > On the day of this accident, there was a well-publicized weather system affecting the weather along the pilot's route: warm moist gulf air was moving northward toward a cold front that extended from Mexico to Canada. Residents in the area said the region had… - [NTSB CHI88MA026](https://openairdocs.org/ntsb/CHI88MA026.md): Beech 200 · Jefferson, WI · Accident · 8 fatal · Major investigation · Final report · Nov 16, 1987 · N334DP · Destroyed > While cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,… - [NTSB LAX88FA042](https://openairdocs.org/ntsb/LAX88FA042.md): Mooney M20C · Grand Canyon, AZ · Accident · 4 fatal · Field investigation · Final report · Nov 15, 1987 · N6670R · Destroyed > While cruising en route all engine power was suddenly lost and the plt attempted an emergency ldg at the Grand Canyon arpt. During the glide, the acft crashed into an outcrop of rocks on a steep cliff, 0.5 mi from the end of the rwy. Exam of the engine… - [NTSB DEN88LA024](https://openairdocs.org/ntsb/DEN88LA024.md): Piper PA-24-260B · Akron, CO · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 1987 · N9039P · Substantial damage > Bfr tkof, snow was melted off the acft in a heated hangar. The flt was bgn in blowing snow with a forecast of ocnl mod icing to 20,000'. The plt said the snow lasted only 5 to 10 min & only a trace of ice (less 1/16 inch) accumulated drg the 1st 15 min of… - [NTSB ATL88IA037](https://openairdocs.org/ntsb/ATL88IA037.md): Douglas DC-9-31 · Cleveland, OH · Incident · No injuries · Incident investigation · Final report · Nov 15, 1987 · N8988E · Minor damage > While descending into Cleveland from 25,000 feet the pilot, experienced a violent lurch in the airframe. The flight continued and landed without incident. An aircraft examination disclosed that the right upper thrust reverser drive link was broken. Further… - [NTSB SEA88FA024](https://openairdocs.org/ntsb/SEA88FA024.md): Cessna 180G · Cambridge, ID · Accident · 2 fatal · Field investigation · Final report · Nov 14, 1987 · N4613U · Destroyed > During a fuel stop at elko, NV the pilot requested a weather briefing for VFR flight to lander, WY or to couer d'alene, ID. The FAA fss briefed him on adverse weather to both destinations, with flight advisories for mountain obscurations, occasional severe… - [NTSB NYC88FA042](https://openairdocs.org/ntsb/NYC88FA042.md): Mooney M20K · Danby, VT · Accident · 2 fatal · Field investigation · Final report · Nov 14, 1987 · N252ZF · Destroyed > The pilot was on a VFR cross country flight when the aircraft descended rapidly and collided with trees. Several witnesses reported hearing extensive engine surges. Witnesses reported seeing the acft maneuvering in a highly erratic manner, then begin a nose… - [NTSB LAX88LA046](https://openairdocs.org/ntsb/LAX88LA046.md): Cessna T210M · Colusa, CA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N761MX · Substantial damage > The pilot executed a missed approach at the destination because of fog and reduced visibility. The pilot elected to divert to Colusa due to the weather and on approach to calusa the engine quit. Attempts to restart the engine were unsuccessful and the pilot… - [NTSB LAX88DVG01](https://openairdocs.org/ntsb/LAX88DVG01.md): Stoopin Scorpion · Browns Valley, CA · Accident · 2 fatal · Final report · Nov 14, 1987 · N19NS · Destroyed > During the local flight, the acft was observed at 300 ft when a power loss apparently occurred. The aircraft descended steeply into a wooded area. The witness stated that the pilot/manufacturer had performed maintenance on the aircraft,s engine immediately… - [NTSB ATL88DKG02](https://openairdocs.org/ntsb/ATL88DKG02.md): Crump 512 · Parrish, AL · Accident · No injuries · Final report · Nov 14, 1987 · N512FC · Substantial damage > While cruising at 5500 ft, the propeller separated from the aircraft and struck the left wing. During the resulting forced landing, the pilot had difficulty controlling the aircraft and was unable to maneuver to a selected field. He said the aircraft would… - [NTSB MKC88LA017](https://openairdocs.org/ntsb/MKC88LA017.md): Piper PA-24-250 · Des Moines, IA · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1987 · N6644P · Substantial damage > Approx eight miles from the dest arpt, the PIC experienced partial, then a complete power loss. An emergency lndg was made on a golf course, about one mile short of the dest arpt. Post accident inspection revealed no fuel in any of the four tanks. Damage was… - [NTSB CHI88DER01](https://openairdocs.org/ntsb/CHI88DER01.md): Piper PA-22 · Mcgrath, MN · Accident · No injuries · Final report · Nov 13, 1987 · N77PL · Substantial damage > During a solo cross-country flight, the aircraft sustained a power loss due to failure of the #3 connecting rod. Subsequently, the student pilot made an emergency landing in a swamp and the aircraft was damaged. - [NTSB SEA88LA016](https://openairdocs.org/ntsb/SEA88LA016.md): Hiller FH-1100 · Turner, OR · Accident · No injuries · Limited investigation · Final report · Nov 12, 1987 · N35HA · Substantial damage > While on a short cross country flight the pilot encountered a rain storm and low clouds. The pilot made a 180 degree turn and then elected to make a precautionary landing in a field. Although the pilot visually inspected the area prior to landing, he did not… - [NTSB SEA88IA017](https://openairdocs.org/ntsb/SEA88IA017.md): Beech E18S · Reno, NV · Incident · No injuries · Incident investigation · Final report · Nov 12, 1987 · N25SM · Minor damage > Shortly after takeoff, and after the landing gear was raised, the pilot noticed an over-temperature of the right engine. A power reduction was made and afterwards symptoms of a compressor stall occurred. The pilot then shut down the right engine. A 180 degree… - [NTSB MIA88FA032](https://openairdocs.org/ntsb/MIA88FA032.md): Airbus Industrie A310 · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Field investigation · Final report · Nov 12, 1987 · N813PA · Minor damage > The capt said he expected some wx drg the 1st 2 hrs of flt. After lvlg at FL 330, the acft was in clear wx, but lgt turbc contd for a time. After the turbc had stopped & there were no wx rtrns on the radar, the seat belt sign was turned off, although the capt… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=306 ## 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=305 --- 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.