# 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 193 of 420 · 20,996 cases ## Cases, newest first - [NTSB NYC85LA147](https://openairdocs.org/ntsb/NYC85LA147.md): Cessna 210M · Linden, NJ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N732VU · Substantial damage > During the preflt inspection, the plt visually checked the fuel tanks and determined them to be full. The flt was made with the fuel selector on the left wing tank. During the apch to Linden arpt, the eng stopped operating. The plt attempted to restart the… - [NTSB LAX85FUG04](https://openairdocs.org/ntsb/LAX85FUG04.md): Briegleb Amature Built BG-12-BD · Hemet, CA · Accident · Serious injuries · Final report · Jun 15, 1985 · N2310B · Destroyed > In was reported that Mr. Campbell departed perris airport, perris, CA at approximately 1215 PDT. It is unknown in what area he was flying. Mr. Campbell was sighted a few minutes prior to attempting to land in a field near 36875 menlo street, Hemet, CA. A… - [NTSB LAX85FA275](https://openairdocs.org/ntsb/LAX85FA275.md): Cessna 31OQ · Chino, CA · Accident · Serious injuries · Field investigation · Final report · Jun 14, 1985 · N7649Q · Substantial damage > The acft collided with the terrain following a total loss of power while circling for landing. The left fuel selector was in the auxiliary tank position and the right fuel selectorwas in the left main tank position. A limited quanity of fuel was drained from… - [NTSB DEN85LA165](https://openairdocs.org/ntsb/DEN85LA165.md): Piper PA-24-250 · Clearfield, UT · Accident · No injuries · Limited investigation · Final report · Jun 14, 1985 · N7259P · Substantial damage > The plt/owner was receiving a cap check ride with an instructor plt & a passenger aboard the acft. The plt reported that during a simulated eng out excercise, the acft got within 200 ft of the ground when the insturctor 'gave me engine power back.' The acft… - [NTSB MKC85LA130](https://openairdocs.org/ntsb/MKC85LA130.md): Cessna 172M · Bingham, NE · Accident · No injuries · Limited investigation · Final report · Jun 13, 1985 · N80747 · Substantial damage > The plt reports that the acft began to settle while on final apch for landing. Full power was applied but the acft continued to settle. The acft hit nose gear collapsed and the acft nosed over. The plt had flown 11 hrs since receiving private plt certificate… - [NTSB FTW85LA253](https://openairdocs.org/ntsb/FTW85LA253.md): Beech 95 · New Braunfels, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 1985 · N2091C · Substantial damage > The instructer pilot and student single engine rated pilot were practicing single eng full stop landings. The acft was on final apch with the right eng shut down and the prop feathered. A vehicle was observed near the rwy. The instructor directed a go-around.… - [NTSB CHI85FA229](https://openairdocs.org/ntsb/CHI85FA229.md): Luscombe 8A · Jeffersonville, OH · Accident · 1 fatal · Field investigation · Final report · Jun 13, 1985 · N23004 · Destroyed > The airplane had circled the north-south grass runway twice before attempting a south landing with an estimated 20 to 30 mph crosswind from the west. The airplane staled and made a 360 degree roll. The pilot was unable to recover and the aircraft struck the… - [NTSB ATL85LA184](https://openairdocs.org/ntsb/ATL85LA184.md): Cessna T337G · Knoxville, TN · Accident · No injuries · Limited investigation · Final report · Jun 12, 1985 · N30S · Substantial damage > The acft made an emergency gear up landing when both the normal and emergency extension systems failed to function properly. A mechanic was later able to extend the gear with the acft on jacks by repeatedly cycling the selector switch. It was determined that… - [NTSB MKC85IA131](https://openairdocs.org/ntsb/MKC85IA131.md): Lockheed L-1011 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Jun 11, 1985 · N31013 · Minor damage > While on an IFR approach to land at stl and the plt initiated flaps. The no.3 outboard flap vane separated from its mounting and fell to the ground. Upon separation the flap vane struck the leading edge of the trailing edge flap knocking a hole in the skin.… - [NTSB NYC85FA141](https://openairdocs.org/ntsb/NYC85FA141.md): Beech BE-200 · Hamptonburgh, NY · Accident · 2 fatal · Field investigation · Final report · Jun 9, 1985 · N148CP · Destroyed > Plt filed IFR for 2 flight legs; baltimore, MD to teterboro, NJ & teterboro to montgomert, NY (orange co arpt). The plt received a preflight wx briefing & was advised that the forecast for stewart, NY, about 10 mis form montgomery was sky partially obscured… - [NTSB FTW85LA250](https://openairdocs.org/ntsb/FTW85LA250.md): Piper PA-31-350 · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N7697L · Substantial damage > The plt filed and flt planned for an overwater route between clearwater, FL, and Dallas, TX, which was denied due to ATC restrictions. On arrival over new orleans, a planned re-fueling stop, the plt determined that he would make it to Dallas. On arrival in… - [NTSB DEN85LA152](https://openairdocs.org/ntsb/DEN85LA152.md): Piper PA-28R-200 · Los Almos, NM · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N8651C · Substantial damage > The plt was making an apch to rwy 27 at the los alamos muni arpt in gusty x-wind conditions. The arpt was located atop a mesa & rwy 27 had a 1.5% uphill rwy gradient. The plt said he selected 2 notches (25 deg) of flaps. The winds were reported to be from 210… - [NTSB CHI85LA231](https://openairdocs.org/ntsb/CHI85LA231.md): Jenkins HP-18 · Wellington, OH · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 1985 · N8036X · Substantial damage > Following an aprx one-half hour flt, witnesses stated that the glider did not appear to flare for landing, but instead, impacted the ground without arresting the rate of descent. The plt eported he had very poor ventilation in the cockpit and feels that he… - [NTSB CHI85LA228](https://openairdocs.org/ntsb/CHI85LA228.md): Piper PA-22-150 · Osceola, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1985 · N1644P · Substantial damage > The solo student plt attempted to land the acft with an aprx 90 deg x-wind of 24 KTS gusting to 32 KTS. Feeling unsure of the conditions on his first apch, he decided to make a go around. This he successfully accomplished. On his second attempt, he was able… - [NTSB LAX85LA267](https://openairdocs.org/ntsb/LAX85LA267.md): Cessna 152 · Compton, CA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1985 · N4874H · Substantial damage > During a dual instructional flt, in preparation for the student's private plt flt exam, the instructor plt failed to confirm that adequte fuel was on board. Despite the fact that the fuel gauges were indicating nearly empty, the instructor plt permitted her… - [NTSB CHI85LA233](https://openairdocs.org/ntsb/CHI85LA233.md): Cessna 150 · Frankenmuth, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 7, 1985 · N5347Q · Destroyed > During the approach power was added & the aircraft was observed to bounce after touchdown. The acft entered a left turn & from about 50 ft AGL was observed to collide with the ground in a nose down attitude. The flaps were found in the down position. - [NTSB ATL85IA180](https://openairdocs.org/ntsb/ATL85IA180.md): Fairchild Swearingen SA226TC · Cherry Point, NC · Incident · No injuries · Incident investigation · Final report · Jun 5, 1985 · N1007W · Minor damage > During an appch for ldg at new bern NC, the crew was unable to get the right main ldg gear to extend. Ground observers reported that the right gear door was partially open. The crew elected to divert the commuter air carrier flt. To mcas Cherry Point where… - [NTSB SEA85LA115](https://openairdocs.org/ntsb/SEA85LA115.md): Bellanca 7GCB · Yakutat, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 1985 · N3JK · Substantial damage > During arrival, the plt extended his traffic pattern to allow another acft to depart. He reported that after he turned on final apch, his acft encountered a downdraft & hit the ground short of the rwy. - [NTSB ATL85LA178](https://openairdocs.org/ntsb/ATL85LA178.md): Cessna 152 · Olive Branch, MS · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 1985 · N49995 · Substantial damage > Plt was returning to arpt with known low fuel state. The planned landing was to be on rwy 18 but while approaching the arpt, the eng missed. The plt elected to land on rwy 36 with a tailwind and conflicting traffic. The conflicting traffic cleared the rwy and… - [NTSB NYC85FNA01](https://openairdocs.org/ntsb/NYC85FNA01.md): Gulfstream AA-5B · Boxborough, MA · Accident · Serious injuries · Final report · Jun 1, 1985 · N4523B · Destroyed > The pilot made six attempts at landing with a left crosswind of 24 knots. On the last attempt he was observed to lose control and crash into the trees off he departure end of the runway. The aircraft burnded and the pilot received serious injuries. - [NTSB MKC85LA118](https://openairdocs.org/ntsb/MKC85LA118.md): Eagle DW1-0062 · Mcpherson, KS · Accident · No injuries · Limited investigation · Final report · May 31, 1985 · N8810B · Substantial damage > During a go-around attempt the plt who was landing at the harrison airport encountered turbulent wind condition. The plt stated the acft stalled and dropped into a field off the side of the rwy. Strong wind conditions were forecast fro the area of landing. - [NTSB MKC85LA117](https://openairdocs.org/ntsb/MKC85LA117.md): Luscombe 8A · Harrison, NE · Accident · No injuries · Limited investigation · Final report · May 30, 1985 · N71407 · Substantial damage > The acft stalled during an attempted go-around. The plt initiated the go-around while attempting to land on rwy 30 with winds from 270 degs at 40 KTS gusting to 60 KTS. The acft stalled, contacted the rwy and veered left off the rwy surface. The plt received… - [NTSB MIA85LA181](https://openairdocs.org/ntsb/MIA85LA181.md): Cessna 182 · St. Marys, GA · Accident · No injuries · Limited investigation · Final report · May 30, 1985 · N21211 · Destroyed > The plt stated that he established a normal apch over the trees to the 2000 ft dry sod rwy. After clearing the trees, a high sink rate developed which was not arrested until the acft impacted the rwy on all three wheels, slid 66 ft, then nosed over. The plt… - [NTSB CHI85IA212](https://openairdocs.org/ntsb/CHI85IA212.md): Boeing 727-023 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · May 28, 1985 · N1984 · Minor damage > American airlines flt 57 had departed baltimore for Chicago. On final approach at ohare the crew discovered the nose gear would not extend. The fe made three attempts to crank down the gear all of which were unsucessful. After landing with nose gear up all… - [NTSB CHI85LA214](https://openairdocs.org/ntsb/CHI85LA214.md): Cessna 150 · Marshall, MI · Accident · Minor injuries · Limited investigation · Final report · May 26, 1985 · N18066 · Substantial damage > The student became disoriented at one of his check points on a x-county flt. With assistance from fss and approach control he arrived at his destination. The student, however, selected the rwy with a tailwind component & was unable to land after two… - [NTSB CHI85FA213](https://openairdocs.org/ntsb/CHI85FA213.md): Hughes 369E · Indianapolis, IN · Accident · Serious injuries · Field investigation · Final report · May 25, 1985 · N5219A · Destroyed > As the helicopter was on downwind for the heliport, the plt experienced an pwr interruption and eventually a eng failure. He was attempting an autorotation to railroad tracks when he saw wires. He managed to miss the wires but by doing so he expended the… - [NTSB ATL85LKG06](https://openairdocs.org/ntsb/ATL85LKG06.md): Piper PA-28-140 · Brooklet, GA · Accident · Serious injuries · Final report · May 25, 1985 · N32826 · Destroyed > The plt stated that 2 approaches were made to rwy 09 and he could not locate a wind indicator. He was also unable to contact anyone over the UNICOM to obtain wind information. The plt attempted a landing on rwy 09 during which the acft bounced and a go-around… - [NTSB DEN85FA141](https://openairdocs.org/ntsb/DEN85FA141.md): Cessna 414 · Billings, MT · Accident · 1 fatal · Field investigation · Final report · May 24, 1985 · N333AA · Destroyed > The plt was making a short (35 minutes) local flt to 'check N333AA over' before turning it over to its new owner. The acft collided with the ground in a steep descent, wings level, attitude during an entry into the traffic pattern at Billings, Montana. VMC… - [NTSB FTW85FPA02](https://openairdocs.org/ntsb/FTW85FPA02.md): Beech H35 · Wichita Falls, TX · Accident · Serious injuries · Final report · May 23, 1985 · N4697D · Substantial damage > The acft made a shallow rt turn and descended to ground contact during a go-around after the plt was informed by radio that his landing gear was not fully extended. Investigation revelaed also that the main fuel tanks were empty and the tank selector was on… - [NTSB MKC85FA111](https://openairdocs.org/ntsb/MKC85FA111.md): Bedeell BD-5 · Belton, MO · Accident · 1 fatal · Field investigation · Final report · May 22, 1985 · N500BR · Substantial damage > While turning from downwind to base a loss of pwr was experienced after which the acft stalled and impacted a corn fld. The wreckage revealed no evidence of fuel in the left tank and only about an ounce of fuel in the carburetor. Fuel burn on the terrain… - [NTSB MKC85FA110](https://openairdocs.org/ntsb/MKC85FA110.md): Cessna 501 · Harrison, AR · Accident · 2 fatal · Field investigation · Final report · May 22, 1985 · N10GE · Destroyed > At 2003 CDT, the flt was cleared for an ILS localizer apch to rwy 36 at the Harrison/boon county arpt. About 7 min later, the aircrew reported making a missed apch & the flt was cleared to the outer compass locator for another apch. The crew asked the… - [NTSB MKC85LA108](https://openairdocs.org/ntsb/MKC85LA108.md): Cessna 152 · Adams, NE · Accident · No injuries · Limited investigation · Final report · May 21, 1985 · N25868 · Substantial damage > Plt was making first landing at an ag strip and collided with 30 foot high utility wires which cross the apch end of thestrip. The wires are not marked. - [NTSB FTW85LA229](https://openairdocs.org/ntsb/FTW85LA229.md): Mitsubishi MU-2B-20 · San Angelo, TX · Accident · No injuries · Limited investigation · Final report · May 21, 1985 · N711LL · Substantial damage > A piece of unidentified equipment reportedly was not properly secured during previous maintenance. The equipment reportedly was mounted immediately above the nose wheel extension/retraction mechanism and moved due to acft vibration preventing the nose gear… - [NTSB ATL85FA168](https://openairdocs.org/ntsb/ATL85FA168.md): Embraer EMB-110-P1 · Atlanta, GA · Accident · No injuries · Field investigation · Final report · May 20, 1985 · N903FB · Substantial damage > The acft was on final apch when the circuit breaker caution light illuminated. The PIC failed to verify which cb tripped and assumed it was the gear control cb. PIC then activated emerg hydraulic sys and manually lowered the gear. After landing the hydraulic… - [NTSB NYC85LA128](https://openairdocs.org/ntsb/NYC85LA128.md): Piper PA-32R-301 · Ellington, CT · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N300UM · Substantial damage > The acft colldied with a stump during a landing attempt at Ellington arpt. The acft had touched dwn about 25 ft short of the rwy. The left aileron was damaged but the acft made a go-around & returned to westover air base & landed. According to the plt,… - [NTSB BFO85LA046](https://openairdocs.org/ntsb/BFO85LA046.md): Schweizer SGS 2-33A · Warrenton, VA · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N2885H · Substantial damage > The plt was obtaining transition tng fm pwrd acft to gliders and had flown 3 dual flts n N2885H on the morning of the accident with an instruction on board. The CFI then authorized him to fly his list solo flt and acft tkof obsvd the glider make what he… - [NTSB NYC85FA125](https://openairdocs.org/ntsb/NYC85FA125.md): Piper PA-31-350 · Latrobe, PA · Accident · Serious injuries · Field investigation · Final report · May 18, 1985 · N66892 · Destroyed > Drg an IFR arrival, the acft was vectored for an NDB rwy 23 apch to the westmoreland county arpt. At the NDB final apch fix (8.1 mi from the rwy), the crew turned inbound & contd to the arpt. They contacted the tower & reported over the ILS outer marker (an… - [NTSB SEA85LA117](https://openairdocs.org/ntsb/SEA85LA117.md): Cessna 172M · Couer D'Alene, ID · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N13403 · Substantial damage > The eng lost power after carb heat was applied & the throttle was retarded on base leg. Subsequently, the acft nosed over during a forced landing on freshly plowed ground short of the rwy. No preimpact part failure or malfunction was found during the… - [NTSB MIA85LA172](https://openairdocs.org/ntsb/MIA85LA172.md): Grumman American AA-5A · Orlando, FL · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N210JA · Substantial damage > The plt reported that after he arrived & was on an apch to land, he noted 'tape' across the rwy. He remained airborne until the acft passed over 'the taped off area.' He then landed the acft on the rwy which was rough & bumpy. The plt stated that the acft was… - [NTSB SEA85LA112](https://openairdocs.org/ntsb/SEA85LA112.md): Piper PA-28-181 · Tacoma, WA · Accident · No injuries · Limited investigation · Final report · May 16, 1985 · N8300Z · Substantial damage > The engine ceased operative while on right base for rwy 35 due to fuel exhaustion. The plt ran the left tank dry. The right tank contained full fuel. The plt had been used to flying Cessna's. - [NTSB LAX85LA257](https://openairdocs.org/ntsb/LAX85LA257.md): Cessna T303 · Mesa, AZ · Accident · Serious injuries · Limited investigation · Final report · May 14, 1985 · N4661V · Destroyed > Plt took off from scottsdale at 1934 MST for a 13 NM flt to reposition the acft to home base. Within minutes the plt advised ATC that he was 6 mi out with minimum fuel and requested no delay. He then asked for clearance to rwy 22R and was cleared to land on… - [NTSB FTW85LA223](https://openairdocs.org/ntsb/FTW85LA223.md): Cessna 210D · Austin, TX · Accident · No injuries · Limited investigation · Final report · May 13, 1985 · N3835Y · Substantial damage > The plt touched down long on rwy 17 with 30 degs of flaps, apparently goind downwind. He attempted a go-around, drifted to the right and the left main gear hit a large boulder separating the gear from the acft. The plt then flew to another nearby arpt and… - [NTSB MIA85FLD02](https://openairdocs.org/ntsb/MIA85FLD02.md): Piper PA-22-150 · Fort Pierce, FL · Accident · No injuries · Final report · May 12, 1985 · N7315D · Substantial damage > Prior to a flt from the Bahamas to west palm beach, FL, the plt noted a problem with the quick-drain for the left fuel tank. After landing in west palm beach, fuel was only added to the right tank since the plt anticipated replacing the left quick-drain. On… - [NTSB ATL85LA162](https://openairdocs.org/ntsb/ATL85LA162.md): Cessna 172N · Broxton, GA · Accident · No injuries · Limited investigation · Final report · May 12, 1985 · N739UD · Substantial damage > The acft collided with power lines on final apch to a private airstrip. The acft was landed in a field next to the rwy. The wires were not marked. The plt reported he was aware of the large power lines near the apch end of rwy 36 but was unaware of the small… - [NTSB FTW85LA216](https://openairdocs.org/ntsb/FTW85LA216.md): Grumman AA1A · Sweetwater, TX · Accident · No injuries · Limited investigation · Final report · May 8, 1985 · N6399L · Destroyed > The acft was destroyed when it flipped over during a forced landing following fuel starvation. The fuel selector was positioned on an empty tank. The right fuel tank was full of fuel. The plt stated he must have forgotten to switch tanks. - [NTSB CHI85LA192](https://openairdocs.org/ntsb/CHI85LA192.md): Cessna A152 · West Bend, WI · Accident · No injuries · Limited investigation · Final report · May 8, 1985 · N4799A · Substantial damage > Plt departed fondulac, WI, with full fuel (24.5 gallons usable) and flew aprx 25 miles south where 2 1/2 hrs were spent taking aerial photographs. Flt then proceeded aprx 60 miles to manitowoc, WI where a landing was made. Departure was then made with aprx 9… - [NTSB ATL85LA155](https://openairdocs.org/ntsb/ATL85LA155.md): Cessna 152 · Ozark, AL · Accident · No injuries · Limited investigation · Final report · May 8, 1985 · N6097M · Substantial damage > The plt was on a x-country flt from Ozark, AL to columbia, SC & return. He used 22 gal of fuel en route to columbia. Before returning, he refueled the acft to its full capacity of 24.5 usable gals. However, on the return flt, he encountered headwinds, did not… - [NTSB LAX85LA244](https://openairdocs.org/ntsb/LAX85LA244.md): Cessna 152 · Wickenburg, AZ · Accident · No injuries · Limited investigation · Final report · May 6, 1985 · N24970 · Destroyed > The plt departed bullhead city with an estimated 12 gal of fuel on board. While en route, he realized that the acft was low on fuel, so he decided to land at Wickenburg. Before reaching the arpt, the eng lost power from fuel exhaustion. The acft was damaged… - [NTSB CHI85LA187](https://openairdocs.org/ntsb/CHI85LA187.md): Cessna 120 · Strongsville, OH · Accident · Minor injuries · Limited investigation · Final report · May 5, 1985 · N89599 · Substantial damage > While on final apch the headwind changed to a quartering left crosswind. A sudden loss of alt occurred and the acft contacted the displaced threshold and weathervaned into the wind. The acft traveled off the side of the rwy and nosed over in an area of grass. - [NTSB NYC85FHA03](https://openairdocs.org/ntsb/NYC85FHA03.md): Cessna 172M · Auburn Center, PA · Accident · 1 fatal · Final report · May 4, 1985 · N6851H · Substantial damage > During attempted landing on a non-certificated strip, plt attempted a go around. The acft struck a grounding cable which was stretched between two telephone poles near the end of the airstrip. The acft then traveled aprx 120 ft before contacting trees. When… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=194 ## 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=193 --- 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.