# 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 333 of 718 · 35,889 cases ## Cases, newest first - [NTSB MKC86LA006](https://openairdocs.org/ntsb/MKC86LA006.md): Beech A36 · Chesterfield, MO · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N72060 · Substantial damage > The pilot was on an IFR flight plan flight when the engine alternator failed and the aircraft battery became so depleted that the nav and com equipment failed. Pilot was able to descend to VFR conditions. He stated he used the checklist to manually extend the… - [NTSB MIA86LA011](https://openairdocs.org/ntsb/MIA86LA011.md): Beech 65A-80 · Ochopee, FL · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N8000R · Substantial damage > While on a night pleasure flt, both engs surged and lost pwr and an emergency landing was made. The plt stated that he had a total of 3 hrs flt time in this type of acft. He later recanted his statement & stated that he had never flown this type acft before.… - [NTSB MKC86FA008](https://openairdocs.org/ntsb/MKC86FA008.md): Piper PA-24 · Salina, KS · Accident · 2 fatal · Field investigation · Final report · Oct 11, 1985 · N9758K · Destroyed > After departing the airport under very poor IFR weather conditions, the plt rpt autopilot problems of an unspecified nature. This was followed by reports of instrument troubles. Radar controllers gave the plt a no-gyro turn to the left. After the instructions… - [NTSB DEN86FA009](https://openairdocs.org/ntsb/DEN86FA009.md): Cessna 180 · Eagle, CO · Accident · 4 fatal · Field investigation · Final report · Oct 11, 1985 · N1611C · Destroyed > The plt departed Eagle arpt with 3 pax to fly them to the white owl lake area for the reported purpose of looking for a possible camping site for hunting activities. The plt encountered IMC and lost control of the acft. He was not instrument rated. All… - [NTSB NYC86FA030](https://openairdocs.org/ntsb/NYC86FA030.md): Cessna C-182N · Winterport, ME · Accident · 2 fatal · Field investigation · Final report · Oct 10, 1985 · N9005G · Destroyed > The acft departed bangor under special VFR dur to low ceilings. A witness saw the acft fly under powerlines that crossed a river and disappear behind trees. There was no indication of an accident. 22 day later, the acft was located 150 ft south from the… - [NTSB FTW86LA014](https://openairdocs.org/ntsb/FTW86LA014.md): Piper J3C-65 · Rosharon, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1985 · N87769 · Substantial damage > The plt stated he was on a local flt and at about 200 ft above the surface the acft stalled and collided with the surface before recovery could be accomplished. He said he failed to maintain flying speed. - [NTSB DEN86LA005](https://openairdocs.org/ntsb/DEN86LA005.md): Beech 35 · Fillmore, UT · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 1985 · N3339V · Destroyed > The plt departed delta, UT on a VFR x-c flt after being advised by fss that VFR was not recommended due to IMC conditions on the proposed route of flt. He flew into an area of rising terrain, encountered IMC wx conditions, attempted to reverse course and… - [NTSB ATL86LLT01](https://openairdocs.org/ntsb/ATL86LLT01.md): Cessna 150 · Livingston, TN · Accident · No injuries · Final report · Oct 9, 1985 · N714BZ · Substantial damage > The plt made a forced landing in rugged tree covered terrain following a loss of pwr due to fuel exhaustion while on a x-country flt. The plt decame lost near Livingston, TN, and contacted the crossville and london fss for assistance. The acft was located 5… - [NTSB LAX86FA007](https://openairdocs.org/ntsb/LAX86FA007.md): Piper PA-28-151 · Payson, AZ · Accident · 2 fatal · Field investigation · Final report · Oct 8, 1985 · N44207 · Destroyed > The passenger had a 10:00 medical appointment at the destination arot on the day of the accident. The non-instrument rated, recently certificated pvt plt, requested and received a weather briefing for a proposed VFR flt at 7500 ft MSL from mesa to holbrook,… - [NTSB FTW86FA007](https://openairdocs.org/ntsb/FTW86FA007.md): Bell 206L-1 · Tomball, TX · Accident · No injuries · Field investigation · Final report · Oct 7, 1985 · N515EH · Substantial damage > Acft was substantially damaged as a result of a hard landing during an emergency autorotation following a complete power loss. The power loss occurred as a result of an uncontained failure of the no. 1 turbine wheel. The wheel burst as a result of a fatigue… - [NTSB CHI86FA006](https://openairdocs.org/ntsb/CHI86FA006.md): Cessna P210N · Grayslake, IL · Accident · No injuries · Field investigation · Final report · Oct 7, 1985 · N3890P · Substantial damage > During descent the engine stopped running. The aircraft was landed in a soft field & nosed over. Only 4 gallons of fuel was found in the left fuel system with no evidence of leakage. The pilot only used the left system during the 2 hour flight. Fuel tanks… - [NTSB SEA86LA005](https://openairdocs.org/ntsb/SEA86LA005.md): Cessna 172 · Medford, OR · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1985 · N7798X · Destroyed > The acft collided with rocky terrain during an attempted forced landing following a loss of pwr. A witness reported seeing the acft in a steep descending left turn at an alt of aprx 100 ft AGL. The descent continued until the left wing contacted the terrain.… - [NTSB MIA86LA007](https://openairdocs.org/ntsb/MIA86LA007.md): Cessna C-182P · Lake City, FL · Accident · No injuries · Limited investigation · Final report · Oct 6, 1985 · N21328 · Substantial damage > The plt stated that while on a VFR flt from west palm beach FL to atlnata ga the acft lost power. While making forced landing on interstate 75 the left main wheel struck a car, & on landing rollout the right wing struck a utility pole. Investigation revealed… - [NTSB LAX86FA003](https://openairdocs.org/ntsb/LAX86FA003.md): Gulfstream AA-5B · Orinda, CA · Accident · 3 fatal · Field investigation · Final report · Oct 6, 1985 · N45293 · Destroyed > The acft collided with rising terrain on a southerly heading. A VFR flt plan was filed. A witness near the accident site reported low ceilings and a forward ground visibility of 50 ft. aprx 15 minutes prior to the accident the acft was seen flying southeast… - [NTSB DEN86LA006](https://openairdocs.org/ntsb/DEN86LA006.md): Skypower GBN-41-100 · Pecos, NM · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1985 · N59SP · Substantial damage > Flt was participation in the 1985 balloon fiesta, a night helium-filled balloon race from albuquerque, new Mexico, to elkhart, Kansas. One hr after launch plt encountered small wind shear, causing loss of altitude, ballast, and helium. Plt then encountered… - [NTSB DEN86LA004](https://openairdocs.org/ntsb/DEN86LA004.md): Cessna 177RG · Aspen, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1985 · N2578V · Substantial damage > After departure from glenwood springs county arpt the plt initiated a cruise climb to fly over a 12,093 ft high mountain pass. He entered the narrow pass at an alt lower than the summit, encountered downdraft wind currents and was unable to climb fast enough… - [NTSB MKC86LA004](https://openairdocs.org/ntsb/MKC86LA004.md): Quickie Q2 · Willard, MO · Accident · No injuries · Limited investigation · Final report · Oct 5, 1985 · N14VV · Substantial damage > Climbing to cruise the plt rptd a loss of eng pwr an turned to head back to the airport of departure, the ensuing forced landing substantially damaged the acft. Inspection into the eng failure revealed a contaminated inline fuel filter restricting fuel flow… - [NTSB ATL86FKG01](https://openairdocs.org/ntsb/ATL86FKG01.md): Piper PA-32-300 · Perry, GA · Accident · Serious injuries · Final report · Oct 5, 1985 · N8831F · Destroyed > The acft landed short of the rwy during a forced landing following loss of pwr during a x-country flt of 2 hrs. 3 witnesses saw the acft bring refueled but the only one who mentioned the amount of fuel added was the refueler who said he'topped off' all 4… - [NTSB MIA86IA001](https://openairdocs.org/ntsb/MIA86IA001.md): Piper PA-32-300 · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Oct 4, 1985 · N8614N · Minor damage > After departure flight experienced loss of engine power and visible smoke coming from the windshield exhaust ducts. The engine subsequently failed but the pilot was able to regain power and return to the airport for a normal landing. Post landing inspection… - [NTSB CHI86FEM01](https://openairdocs.org/ntsb/CHI86FEM01.md): Leone Sonerai II · Traverse City, MI · Accident · Minor injuries · Final report · Oct 4, 1985 · N47GL · Substantial damage > The acft contacted a tree and impacted the terrain in a nose down attitude during a forced landing following a loss of pwr which resulted from fuel exhaustion. - [NTSB FTW86MA010](https://openairdocs.org/ntsb/FTW86MA010.md): Beech V35 · Bridger, MT · Accident · 4 fatal · Major investigation · Final report · Oct 3, 1985 · N8475H · Destroyed > Drg a preflt wx briefing, the plt was advised that VFR flt was not recommended due to forecast frontal activity moving southbound along his route. Severe turbulence & icing had been reported just to the north of his course. He filed a VFR flt plan & took off… - [NTSB FTW86LA002](https://openairdocs.org/ntsb/FTW86LA002.md): Cessna 152 · Lake Charles, LA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1985 · N67803 · Substantial damage > The acft experienced eng failure as a result of fuel exhaustion and the plt made a forced landing in a lake near the departure arpt while towing a banner. FAA stated the plt did not obtain a waiver to tow the banner. - [NTSB ATL86LLQ01](https://openairdocs.org/ntsb/ATL86LLQ01.md): Cessna 172 · London, KY · Accident · Minor injuries · Final report · Oct 3, 1985 · N20273 · Substantial damage > The acft crashed during a forced landing after fuel exhaustion during a x-country flt. The plt had encountered wx and in attempting to reach an alternate arpt the acft ran out of fuel. The plt was not instrument rated and the wx at London was 600 ft overcast… - [NTSB ATL86FA002](https://openairdocs.org/ntsb/ATL86FA002.md): Grumman American AA-5 · Hurricane, WV · Accident · 4 fatal · Field investigation · Final report · Oct 3, 1985 · N9629U · Destroyed > N9629U crashed in a wooded area near Hurricane, west Virginia while conducting a visual flight from millwood, WV to grundy, Virginia. The pilot and aircraft were certificated in accordance with current FARS. The pilot received a weather briefing for the… - [NTSB LAX86LA001](https://openairdocs.org/ntsb/LAX86LA001.md): Piper PA-32-300 · Van Nuys, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 1985 · N9AZ · Substantial damage > The plt stated that after takeoff he climbed to 1800 ft MSL (aprx 1000 ft above ground level) and entered a left turn. The eng failed in the turn an he selected a dry flood control basin on which to land. The acft's airspeed was slow on landing and the… - [NTSB FTW86MA001](https://openairdocs.org/ntsb/FTW86MA001.md): Cessna 441 · Dallas, TX · Accident · 5 fatal · Major investigation · Final report · Oct 1, 1985 · N400BG · 2 aircraft · Destroyed > A student plt in a Cessna 152, N5522L, had deptd redbird arpt at Dallas. He was practicing solo maneuvers in a privatelydesignated practice area that overlapped the extended inbnd course to rwys 31L & r at love field. At the same time, a Cessna 441, N400BG,… - [NTSB DEN86LA001](https://openairdocs.org/ntsb/DEN86LA001.md): Champion 7GCAA · Cortez, CO · Accident · No injuries · Limited investigation · Final report · Oct 1, 1985 · N9614S · Substantial damage > After 3.9 hrs flt time on a x-country flt from cheyenne, WY, to Cortez, CO, the plt experienced an eng failure due to fuel exahustion. He executed a forced landing in a mountain meadow that was not adequate in length for the landing. The acft impacted trees… - [NTSB NYC85FHJ04](https://openairdocs.org/ntsb/NYC85FHJ04.md): Cessna 172 · Montauk, NY · Accident · No injuries · Final report · Sep 30, 1985 · N6525J · Substantial damage > The Cessna 172 was cruising 3000 ft off shore at 600 ft AGL over the ocean. The engine was at 1900 RPM with the carburator heat on when the aircraft experienced a power failure. The flight instructor made an emergency landing on a beach. Upon touch down the… - [NTSB NYC85LA249](https://openairdocs.org/ntsb/NYC85LA249.md): Grumman AA-5B · Manchester, MA · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 1985 · N88SJ · Substantial damage > Plt stated that during cruise flight at an altitude of 1200 ft the engine RPM decreaseed from cruise setting to between 900-1100 RPM. The acft was overwater and 2 miles from the coastline. He was unable to maintain altitude and he started a descent toward… - [NTSB ATL85FLQ01](https://openairdocs.org/ntsb/ATL85FLQ01.md): Piper PA-28-181 · Bowling Green, KY · Accident · Minor injuries · Final report · Sep 27, 1985 · N8450K · Substantial damage > The acft was substantially damaged during a forced landing in a corn field following a loss of pwr 5 miles from the destination arpt. The plt reported to Bowling Green fss that he was 'out of gas' at an alt of 3000 ft. post accident examination disclosed a… - [NTSB SEA85LA227](https://openairdocs.org/ntsb/SEA85LA227.md): Beech J35 · Ontario, OR · Accident · No injuries · Limited investigation · Final report · Sep 26, 1985 · N8245D · Substantial damage > The plt was flying the acft at a low alt for the purpose of spotting game. The eng ceased operating shortly after switching fuel tanks. The plt stated during a telephone interview that he inadvertently switched the fuel selector to the off position. The acft… - [NTSB ANC85FA184](https://openairdocs.org/ntsb/ANC85FA184.md): de Havilland DHC-2 · Merrill Pass, AK · Accident · 3 fatal · Field investigation · Final report · Sep 26, 1985 · N5317G · Destroyed > The acft collided with terrain in a mountain Pass at an elevation of 3600 ft MSL. The plt obtained a wx briefing at 1329 gmt on 9/26/86 at which time Merrill Pass was forecast to be closed by 1100 adt due to deteriorating wx. The last radio communication with… - [NTSB SEA85LA226](https://openairdocs.org/ntsb/SEA85LA226.md): Cessna 172 · Fernly, NV · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1985 · N52202 · Substantial damage > The acft's windscreen was struck by a bird and was blown out injuring the plt. The plt had difficulty keeping the acft airborne and a forced landing was made. The acft nosed over during the landing rollout on soft terrain. - [NTSB LAX85LA403](https://openairdocs.org/ntsb/LAX85LA403.md): Hughes 369D · Porterville, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 25, 1985 · N29707 · Destroyed > After climbing to a cruise alt of 13500 ft MSL to cross the sierra Nevada mountains, south of mt whitney, the plt entered cruise flt at an indicated airspeed of aprx 120 to 130 KTS. The plt's flt manual lists 110 KTS as the velocity velocity to never exceed… - [NTSB MIA85LA262](https://openairdocs.org/ntsb/MIA85LA262.md): Cessna 172N · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Sep 24, 1985 · N4688D · Substantial damage > The plt stated that shortly after takeoff from ft. lauderdale, he felt a severe vibration and shut down the eng and made a emerg landing in an open field. Post crash investigation revealed that one propeller blade separated aprx one foot from the hub.… - [NTSB CHI85FEV04](https://openairdocs.org/ntsb/CHI85FEV04.md): Hiller UH-12D · Breese, IL · Accident · No injuries · Final report · Sep 24, 1985 · N67182 · Substantial damage > The plt reported that the eng began losing power while he was en route at an alt of aprx 200 ft AGL. He turned & initiated an autorotation to a road construction site. The helicopter landed tail low. Subsequently, the tail boom was chopped off & the… - [NTSB MIA85FA260](https://openairdocs.org/ntsb/MIA85FA260.md): Cessna 402C · Fort Lauderdale, FL · Accident · No injuries · Field investigation · Final report · Sep 23, 1985 · N402V · Destroyed > Pilot ditched aircraft in atlantic ocean after losing power in both engines. The three occupants escaped ininjuried and were picked up by a nearby boat. The aircraft sank in approximately 800 feet of water about 5 minutes after ditching. Post accident… - [NTSB ATL85FAMS2](https://openairdocs.org/ntsb/ATL85FAMS2.md): Piper PA-28-140 · Gulfport, MS · Accident · 3 fatal · Missing aircraft · Final report · Sep 23, 1985 · N1785J · Destroyed > Plt contacted apch control for advisories. Asked about wx onroute of ELT. Was told that lines of showers existed across path. Plt advised he thought he had found a gap and that he thought he could get over wx. Later radioed that ride was bouncy and he was in… - [NTSB SEA85LA220](https://openairdocs.org/ntsb/SEA85LA220.md): Cessna 182A · Vancouver, WA · Accident · No injuries · Limited investigation · Final report · Sep 22, 1985 · N4774D · Substantial damage > The plt was unable to land at his intended destination due to the rwy edge and end lights being inoperative. The plt diverted to a nearby arpt but fuel exhaustion occurred and a forced landing was made. The acft was landed on an overpass and during the… - [NTSB SEA85FA225](https://openairdocs.org/ntsb/SEA85FA225.md): Cessna 177BII · Lolo Pass, ID · Accident · 3 fatal · Field investigation · Final report · Sep 22, 1985 · N35105 · Destroyed > The plt failed to visually check the fuel tanks during preflt and departed with 3.4 hours flown on the pre-existing fuel supply. Fuel exhaustion occurred 1.2 hours into the flt. The plt overflew a suitable forced landing site and attempted a last minute turn… - [NTSB DEN85LA247](https://openairdocs.org/ntsb/DEN85LA247.md): Cessna 182A · Troy, MT · Accident · No injuries · Limited investigation · Final report · Sep 22, 1985 · N5145D · Substantial damage > The plt said that as he approached his destination he reduced engine pwr to begin descent. The engine quit forcing the pilot to land on unsuitable terrain. Contaminated fuel was found in the fuel system. - [NTSB CHI85FEC01](https://openairdocs.org/ntsb/CHI85FEC01.md): Cessna 182K · Monroe, MI · Accident · Minor injuries · Final report · Sep 22, 1985 · N3013Q · Substantial damage > The acft collided with trees and terrain during a forced landing following a loss of pwr. The plt reported the pwr loss occurred during a descent from 5500 ft to 2500 ft MSL. During the forced landing descent, the plt reported, he pushed the nose of the acft… - [NTSB SEA85LA224](https://openairdocs.org/ntsb/SEA85LA224.md): Cessna 172PII · Brinnon, WA · Accident · 3 fatal · Limited investigation · Final report · Sep 21, 1985 · N51698 · Destroyed > Acft collided with vertical rock face in mountainous terrain 32 mins after takeoff on night VFR instrument instruction flt, 31 mi west of point of departure. Radar trk shows acft proceeded nw for 14 mins, reversed course for 4 mins, then headed due west into… - [NTSB NYC85FA244](https://openairdocs.org/ntsb/NYC85FA244.md): Beech V35B · Warwick, RI · Accident · 2 fatal · Field investigation · Final report · Sep 21, 1985 · N5NG · Destroyed > While en route at 5000' MSL, the plt transmitted that he had an eng problem & requested clearance to land at the providence/theodore francis green state arpt, which was aprx 12 mi away. The plt then asked the controller if that was the closest arpt; however,… - [NTSB MKC85LA221](https://openairdocs.org/ntsb/MKC85LA221.md): Lon J. Mcknight Flybaby 1A · Lebanon, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1985 · N3826 · Substantial damage > After washing his aircraft the plt dptd the airport for a LCL flight. The flight lasted for approx. 30 min. When the plt stated the end began running rough. A precautionary landing was made to the airport. The acft stalled impacting the ground short of the… - [NTSB LAX85LA400](https://openairdocs.org/ntsb/LAX85LA400.md): Bell 47G-2 · Watsonville, CA · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N2874B · Substantial damage > During an ag flt, at abt 5 ft AGL, the plt heard a loud bang, the eng oversped, & all pwr to the rotor blades was lost. The plt attempted to immediately land in the underlying field, but had insufficient altitude/airspeed to autorotate. The acft touched down,… - [NTSB LAX85LA399](https://openairdocs.org/ntsb/LAX85LA399.md): Cessna 150M · Selma, CA · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N45382 · Substantial damage > The pilot reptd the acft experienced a total loss of power during the descent to Selma arpt. The pilot did not apply carb heat before begining the descent. During the subsequent forced landing the acft left wing struck a telephone pole. The engine operated… - [NTSB FTW85LA352](https://openairdocs.org/ntsb/FTW85LA352.md): Cessna 152 · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N93729 · Substantial damage > The pilot experienced total engine failure when a connecting rod bolt failed and caused the engine to lock up. He was climbing in IMC weather conditions when this occurred. He was radar vectored toward his destination airport. He broke out of the clouds at… - [NTSB DEN85LA245](https://openairdocs.org/ntsb/DEN85LA245.md): Piper PA-28-235 · Sugar City, CO · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N9186W · Destroyed > Plts were participating in mile-high air derby between denver, Colorado and taos, new Mexico. Acft was flying 50 ft AGL and at full throttle. When plt depressed microphone button to give position report, a muffled explosion was heard. Cabin immediately filled… - [NTSB ATL85FA280](https://openairdocs.org/ntsb/ATL85FA280.md): Cessna 172N · Halls, TN · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1985 · N2858E · Substantial damage > The private pilot had just leveled off at 2500 feet and pointed out the old naval base to his right front seat passenger when he slumped over the yoke. The passenger in the rear seat held the pilot off the controls while her non-pilot husband attempted to… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=334 ## 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=333 --- 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.