# 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 346 of 718 · 35,889 cases ## Cases, newest first - [NTSB LAX85FVW01](https://openairdocs.org/ntsb/LAX85FVW01.md): Cessna 150L · Furnace Creek, CA · Accident · No injuries · Final report · Nov 30, 1984 · N17171 · Substantial damage > Plt stated the eng began running rough during cruise flt. Plt applied carb heat and 'adjusted the mixture' but eng continued running rough and subsequently quit. The right wing contacted a road sign during the forced landing on a road. The acft veered off the… - [NTSB MKC85LA029](https://openairdocs.org/ntsb/MKC85LA029.md): Sikorsky S58J · Storm Lake, IA · Accident · 1 fatal · Limited investigation · Final report · Nov 28, 1984 · N62243 · No damage > A passenger was being transported from a boat to shore. The plt lowered a wheel strut to the boat for the boarding and says he received a radio call from the passenger saying, 'ok I'm ready let's go.' The plt assumed that he was inside the acft and a climb… - [NTSB LAX85IA052](https://openairdocs.org/ntsb/LAX85IA052.md): Beech C24R · Glendale, CA · Incident · No injuries · Incident investigation · Final report · Nov 27, 1984 · N6713D · Minor damage > After a loss of eng power, the plt made a forced landing on a street. While landing, the tip of the vertical stabilizer snagged a guy wire which crossed the street. The aircraft owner stated that the electrical fuel pump needed a rotor & body kit. He… - [NTSB FTW85FA343](https://openairdocs.org/ntsb/FTW85FA343.md): Mooney M20J · Bethel, OK · Accident · 1 fatal · Field investigation · Final report · Nov 26, 1984 · N4081H · Destroyed > Despite a wx brief discouraging VFR flt the non-instrument rated plt departed at about 1330 CST. His stated dest was ft. worth, TX which is due north. After takeoff in VMC the acft flew NE toward an unknown dest. A wx study indicated conditions along the… - [NTSB FTW85FA060](https://openairdocs.org/ntsb/FTW85FA060.md): Cessna 172A · Hammond, LA · Accident · 1 fatal · Field investigation · Final report · Nov 26, 1984 · N7415T · Destroyed > Non-stop endurance for this make/model is 4.2 hrs in normal cruise. Calculated ete for plt's reported route of flight is 4.0 hrs (non-stop, no wind, normal cruise). Time from intial departure to mishap was 6.0 hrs. Acft of this discription was observed to… - [NTSB DEN85FA034](https://openairdocs.org/ntsb/DEN85FA034.md): Cessna P206 · Wagon Mound, NM · Accident · 4 fatal · Field investigation · Final report · Nov 26, 1984 · N2797Y · Destroyed > Plt received 3 wx briefings before flt and informed of possibility of diminishing conditions. Acft collided with terrain 1 1/2 mi from I-25 that goes from raton to albuquerqe. Local residents described wx at aprx time of accident as heavy snow, high winds,… - [NTSB ATL85LA044](https://openairdocs.org/ntsb/ATL85LA044.md): Piper PA-28-140 · Nicholasville, KY · Accident · No injuries · Limited investigation · Final report · Nov 26, 1984 · N4343F · Substantial damage > The acft crashed into a sewage treatment plant during an emergency landing after fuel exhaustion while on a personal flt. The plt indicated that the flt was 4 hours 10 minutes long. The acft fuel capacity is listed as 38 gals usable. The acft is certified for… - [NTSB SEA85LA022](https://openairdocs.org/ntsb/SEA85LA022.md): Bell 47G-3B-2 · Nampa, ID · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N7927J · Substantial damage > Following a power loss-induced forced landing two days prior, the acft fuel pump and carburetor were changed and fuel lines flushed. Six hours of uneventful operations ensued before the power loss leading to this mishap occurred. Pwrloss occurred when the… - [NTSB FTW85LA058](https://openairdocs.org/ntsb/FTW85LA058.md): Piper PA-22 · Brownwood, TX · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N2259A · Substantial damage > A witness who is a pilot and an A&P mechanic, stated that he heard the engine on N2259A sputtering as if it was running out of fuel as it passed over his house. The witness continued to state that shortly after the aircraft passed, the pilot of N2259A called… - [NTSB CHI85LA058](https://openairdocs.org/ntsb/CHI85LA058.md): Piper PA-28-140 · Romeoville, IL · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 1984 · N1846J · Destroyed > While en route a ttl loss of power occurred. The acft nosed over during the forced landing in an open field. A fire then erupted. Inspection of the engine revealed no failures or malfunctions. The right wing fuel tank was found empty and the left tank… - [NTSB DEN85LA032](https://openairdocs.org/ntsb/DEN85LA032.md): Piper PA-28 · Alexandria, SD · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 1984 · N43530 · Destroyed > The acft made a forced landing in a plowed field after the engine failed. The plt reported that during cruise flt he heard a faint knock from the engine compartment. He reduced power and called fss. Almost immediately the engine began to vibrate. The plt… - [NTSB MIA85FA044](https://openairdocs.org/ntsb/MIA85FA044.md): Cessna 210 · Clermont, FL · Accident · 4 fatal · Field investigation · Final report · Nov 23, 1984 · N6658B · Destroyed > Despite 5 pre-flt wx briefings from the local fss, warnings from a plt who had just landed in a corporate jet, and questioning from the ATCT regarding the plt's knowledge of existing conditions. The plt departed at 1138 EST. The acft impacted inverted and the… - [NTSB LAX85FA051](https://openairdocs.org/ntsb/LAX85FA051.md): Cessna 172G · Kingman, AZ · Accident · 2 fatal · Field investigation · Final report · Nov 23, 1984 · N3698L · Destroyed > Aircraft collided with the face of a shear cliff about 30 feet below its crest. It impacted with the left wing 15 degs down and with the nose up at about 5 degs. Impact occurred at 3500 ft MSL. Local authorities indicated that the weather at the time of the… - [NTSB LAX85FA048](https://openairdocs.org/ntsb/LAX85FA048.md): Cessna 172M · Lake Isabella, CA · Accident · 2 fatal · Field investigation · Final report · Nov 23, 1984 · N9589V · Destroyed > Acft departed arpt in mountain valley (elev 2,614) generally direct toward a saddle pass (elev 6,500) about 1 mi nw & on the lee side of the valley. Tops of the mountains around the valley average about 7,000 ft MSL. Flt encountered updrafts during climb… - [NTSB MIA85LA043](https://openairdocs.org/ntsb/MIA85LA043.md): Cessna T210N · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Nov 22, 1984 · N4949U · Substantial damage > The acft was substantially damaged during a forced landing in a marsh area following fuel exhaustion. Plt stated he had flown this trip several times in a non-turbo 210 without any problems. He calculated endurance of 6 hrs for this flt. Fuel exhaustion… - [NTSB MIA85LA042](https://openairdocs.org/ntsb/MIA85LA042.md): Rockwell 690A · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Nov 21, 1984 · N44WV · Substantial damage > Climbing through 10,000 ft the plt noticed a red gear light and dropping hyd pressure. Prior to the precautionary landing, according to the plt, the gear were extended and indicated down and locked. When reverse thrust was applied the left main gear… - [NTSB MIA85FA041](https://openairdocs.org/ntsb/MIA85FA041.md): Piper PA-28-181 · Orlando, FL · Accident · 3 fatal · Field investigation · Final report · Nov 21, 1984 · N82108 · Destroyed > Numerous witnesses heard the engine sputter and then stop. The evidence suggests the pilot attempted an emergency landing at the parking lot. While maneuvering at very low altitudes and airspeeds, the left wing hit a light pole. The private pilot had a total… - [NTSB LAX85FA059](https://openairdocs.org/ntsb/LAX85FA059.md): Piper PA-34-200T · Independence, CA · Accident · 4 fatal · Field investigation · Final report · Nov 21, 1984 · N2245F · Destroyed > The non-instrument rated plt received two wx briefings before the flt during which he was informed that VFR flt was not recommended. Flt departed at 1308 PST and a search was inititated when acft failed to arrive at it's destination. Ntap print out indicated… - [NTSB ATL85FA043](https://openairdocs.org/ntsb/ATL85FA043.md): Beech M35 · Gainesville, GA · Accident · Serious injuries · Field investigation · Final report · Nov 21, 1984 · N9760R · Destroyed > The acft crashed during an emergency landing while operating in VFR conditions on a dark night over isolated terrain. The plt stated he thought the eng exploded & lost visual contact due to oil spraying on the windshield. The rt front passenger held a… - [NTSB NYC85LA031](https://openairdocs.org/ntsb/NYC85LA031.md): Cessna 182D · Woodside, DE · Accident · No injuries · Limited investigation · Final report · Nov 20, 1984 · N8957X · Substantial damage > The plt reported that he refueled the acft on 11/12/84 & filled the tanks. Tach time was 1766.95. On 11/20/84, when he took off, he estimated 51 gals of fuel was on board. He flew to another location & landed, then was away from his acft about 1 hr. When he… - [NTSB MKC85LA023](https://openairdocs.org/ntsb/MKC85LA023.md): Cessna 150L · Joplin, MO · Accident · No injuries · Limited investigation · Final report · Nov 20, 1984 · N6584G · Substantial damage > Plt departed with estimated 16 gals of fuel on board for brief flight. Approaching arpt for landing, engine lost power. Plt set up for forced lndg in open field. Acft overran available open space and collided with brush. Plt stated acft had been modified for… - [NTSB MKC85FA024](https://openairdocs.org/ntsb/MKC85FA024.md): Piper PA-28RT-201 · Cozad, NE · Accident · 1 fatal · Field investigation · Final report · Nov 20, 1984 · N2894S · Destroyed > The acft collided with a electrical transmission line while on a business flt. Investigation revaled IMC existed at the time of the accident, the plt did not file a flt plan, there was no evidence of a wx briefing and there were no known communications with… - [NTSB CHI85FA053](https://openairdocs.org/ntsb/CHI85FA053.md): Cessna 310N · Valparaiso, IN · Accident · 5 fatal · Field investigation · Final report · Nov 20, 1984 · N31747 · Destroyed > The aircraft stalled and impacted the terrain during a forced landing. Witnesses observed the acft flying at 'tree top level' with the wings 'wagging'. One witness reported hearing no engine sounds. The acft impacted the terrain (open field) in a near… - [NTSB MKC85FA022](https://openairdocs.org/ntsb/MKC85FA022.md): Piper J5A · Stuttgart, AR · Accident · No injuries · Field investigation · Final report · Nov 19, 1984 · N35786 · Substantial damage > The acft was being ferried x-country in legs of approximately 2 hrs flt duration. The acft was refueled for the next legand it needed 18 gallons of fuel. The plt was predicting a burn of 5-6 gallons of fuel per hour. After a flt of 2 hrs and 17 minutes with… - [NTSB DEN85LA029](https://openairdocs.org/ntsb/DEN85LA029.md): Cessna 182P · Snowville, UT · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1984 · N21037 · Destroyed > The acft nosed over during an off arpt forced landing after the engine failed in cruise flt. The engine was disassembledand examined on 12/3/84. The #3 and #4 piston rods were separated from their cranckshaft journals. Most of the rod bearings were worn. The… - [NTSB ATL85FA041](https://openairdocs.org/ntsb/ATL85FA041.md): Cessna 172K · Lineville, AL · Accident · Serious injuries · Field investigation · Final report · Nov 19, 1984 · N46537 · Substantial damage > Plt obtained 2 wx briefings stating VFR flight not recommended along intended route. Plt requested local wx only during 3rd wx briefing. Reporting stations upwind and downwind of mountains were forecasting ceilings to be below mountain tops. Route of flt was… - [NTSB MIA85FA040](https://openairdocs.org/ntsb/MIA85FA040.md): Piper PA-32R-301T · Freeport, FL · Accident · 3 fatal · Field investigation · Final report · Nov 18, 1984 · N4316P · Destroyed > Preflt wx brief included advisory for scattered showers/thunderstorms along route of flt. Departed in VFR conditions but encountered deteriorating wx enroute, received inflt wx advisory to expect low clngs and reduced visibility ahead. Plt stated he 'would… - [NTSB MIA85LA035](https://openairdocs.org/ntsb/MIA85LA035.md): Piper J3C-65 · Stuart, FL · Accident · No injuries · Limited investigation · Final report · Nov 16, 1984 · N77517 · Substantial damage > Acft was flying at low level over water to film a tv commercial. Plt pushed throttle in for additional pwr but engine did not respond. Full throttle was applied with no response from the eng. Plt stated that there was insufficient pwr to maintain level flt.… - [NTSB NYC85FGM02](https://openairdocs.org/ntsb/NYC85FGM02.md): Hiller UH-12B · Butler, PA · Accident · Serious injuries · Final report · Nov 15, 1984 · N17129 · Substantial damage > After training at mcville arpt for about 1HR & 15MIN the plt decided to purchase fuel, taxied to the fuel pumps & discovered that the operator was not there. The CFI EST that there was sufficient fuel to fly to Butler county arpt, aprx 18 miles away. During… - [NTSB FTW85FA052](https://openairdocs.org/ntsb/FTW85FA052.md): Piper PA-31-350 · San Antonio, TX · Accident · Serious injuries · Field investigation · Final report · Nov 15, 1984 · N333TB · Substantial damage > Shortly after takeoff both engines began to surge. Plt stated he did not switch fuel tanks during emerg procedure because he knew outboard tanks were empty. Company policy was to carry on 10 gallons of fuel in outboard tanks. Post accident investigation… - [NTSB ATL85LA035](https://openairdocs.org/ntsb/ATL85LA035.md): Piper PA-28R-201T · Madison, WV · Accident · No injuries · Limited investigation · Final report · Nov 15, 1984 · N47416 · Substantial damage > Following a loss of eng power during a x-country flt, the plt landed on a bridge. During the ldg roll the wing struck a pole. Post crash examination of the engine disclosed that the camshaft gear teeth suffered fatigue failure. - [NTSB SEA85LA017](https://openairdocs.org/ntsb/SEA85LA017.md): Hughes 369D · Humptulips, WA · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1984 · N1096L · Destroyed > When the hoisting cable on the helicopter failed, the hook end rebounded into the rotor system. The rotor system failed from the structural damage imposed and the acft went into an uncontroled descent impacting the ground on the left skid. - [NTSB LAX85LA047](https://openairdocs.org/ntsb/LAX85LA047.md): Cessna 152 · Yuma, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1984 · N25854 · Substantial damage > The plt rptd that while en route to Yuma, AZ, the eng began running rough and subsequently quit. During the landing rollthe acft collided with a dirt embankment and nosed over. Examination of the wreckage disclosed both fuel tanks contained only residual… - [NTSB ANC85LA017](https://openairdocs.org/ntsb/ANC85LA017.md): Cessna 310J · Tok, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1984 · N313SL · Substantial damage > The acft crashed during an emerg night landing after the loss of pwr on both engines. Investigation revealed the rt eng was secured because of decreasing oil pressure & a visible oil leak. There were seven airports within reach of the acft when this eng was… - [NTSB DEN85IA025](https://openairdocs.org/ntsb/DEN85IA025.md): Aerospatiale SA315B (Lama) · Oak City, UT · Incident · Minor injuries · Incident investigation · Final report · Nov 11, 1984 · N5785V · 2 aircraft · Minor damage > Both acft were performing external load operations. N5785V was in level flt to the north. N9362 was in a 60-70 kt slight climb to the southeast. Neither plt, both in rt seats, saw the other acft before contact. Three main rotor blades of N5785V passed through… - [NTSB CHI85LA046](https://openairdocs.org/ntsb/CHI85LA046.md): Piper PA-32RT-300T · Bloomington, IN · Accident · No injuries · Limited investigation · Final report · Nov 11, 1984 · N22267 · Substantial damage > Plt stated that while in cruise flt, the acft nose pitched down abruptly. Plt disengaged the autopilot and noted vacuum system was inoperative. Flt continued on manual control without further incident until late final approach at destination. When flaps were… - [NTSB ANC85LA018](https://openairdocs.org/ntsb/ANC85LA018.md): Piper PA-22 · Minchumina, AK · Accident · No injuries · Limited investigation · Final report · Nov 11, 1984 · N6821B · Substantial damage > The acft made a hard landing on a frozen lake during a precautionary landing. The plt said that cargo on board had shifted in flt and he also had a loss of 15 mph in airspeed. Thinking it might be an icing problem, the plt made the unscheduled landing. No ice… - [NTSB NYC85LA027](https://openairdocs.org/ntsb/NYC85LA027.md): Taylorcraft BL-65 · Conyngham, PA · Accident · No injuries · Limited investigation · Final report · Nov 10, 1984 · N29642 · Substantial damage > The plt made an emergency landing in a plowed field following a loss of power. During the landing, the left strut & right wing tip were damaged. No reason for the loss of power was found during the investigation. - [NTSB LAX85LA045](https://openairdocs.org/ntsb/LAX85LA045.md): Bell 206B · Inverness, CA · Accident · No injuries · Limited investigation · Final report · Nov 10, 1984 · N2917W · Substantial damage > An autorotation was initiated at about 300 ft as eng and rotor RPM began to decrease. Touchdown occurred in soft sand with some forward motion. Full aft cyclic was applied causing the main rotor to contact the tailboom. Exam of the acft fuel system revealed… - [NTSB FTW85LA042](https://openairdocs.org/ntsb/FTW85LA042.md): Cessna 441 · Grand Chenier, LA · Accident · Minor injuries · Limited investigation · Final report · Nov 10, 1984 · N441ST · Substantial damage > The pilot told the cameron parrish sheriff that he was attempting to land the aircraft at a small agricultural landing strip after one of the two engines quit due to fuel starvation. The pilot stated that there was nothing wrong with the aircraft except that… - [NTSB ANC85LA015](https://openairdocs.org/ntsb/ANC85LA015.md): Piper PA-12 · Talkeetna, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 1984 · N2520M · Destroyed > The acft crashed during a forced landing following a power loss. Post accident fire destroyed the acft. The acft engine was partially disassembled following the accident and no discrepancies were found. The plt said that he suspected carburetor ice. During… - [NTSB MIA85FA028](https://openairdocs.org/ntsb/MIA85FA028.md): Cessna 150 · Orlando, FL · Accident · Serious injuries · Field investigation · Final report · Nov 9, 1984 · N6867G · Destroyed > According to the plt the eng failed while flying at aprx 1500 ft AGL. During the forced landing the acft struck the crown of a sand trap on a golf course in a left wing low, nose low attitude and boumced aprx 60 ft before comming to rest inverted. Post crash… - [NTSB FTW85FA040](https://openairdocs.org/ntsb/FTW85FA040.md): Cessna T337B · West Monroe, LA · Accident · Serious injuries · Field investigation · Final report · Nov 9, 1984 · N6T · Destroyed > The acft crashed into trees during a forced lndg after both engs lost pwr. The acft had been recently purchased and was being ferried to the new owner. The acft had been flown only 40 hrs since the last annual inspection which was done on 1/19/84. It was… - [NTSB MIA85LA026](https://openairdocs.org/ntsb/MIA85LA026.md): Cessna T210M · Mayport, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 1984 · N8444M · Substantial damage > The acft crashed about 10 min after departure on the return leg of a x-country flt. Post crash investigation revealed that the eng failed due to fuel exhaustion. The plt stated that he did not visually check the fuel supply because there was no step ladder… - [NTSB ATL85LA030](https://openairdocs.org/ntsb/ATL85LA030.md): Bellanca 17-30A · Ariton, AL · Accident · No injuries · Limited investigation · Final report · Nov 8, 1984 · N8794V · Substantial damage > Acft lost pwr and plt attempted to restart engine by switching fuel tanks. Power was not regained and forced landing was made in a field. Plt stated aux tanks were full and rt main contained 1/2 gallon of fuel. Fuel tank selected at time of power loss is… - [NTSB NYC85LA022](https://openairdocs.org/ntsb/NYC85LA022.md): Mooney M20C · Landover, MD · Accident · No injuries · Limited investigation · Final report · Nov 7, 1984 · N6890N · Substantial damage > Flt departed danbury, CT, on x-country flt to college park, MD. According to plt there was sufficient fuel on board, however plt extended flt to northern VA before returning to college park. Prior to reaching arpt a loss of power occurred and plt made gear up… - [NTSB ATL85LA028](https://openairdocs.org/ntsb/ATL85LA028.md): Cessna 152 · Baxley, GA · Accident · No injuries · Limited investigation · Final report · Nov 7, 1984 · N84BN · Substantial damage > The acft was damaged during a forced landing into a plowed field after the eng quit. Investigation revealed the plt had been instructed to refuel at his first stop of an extended x-country flt. The acft ran out of fuel aprx 1 mi from the second scheduled stop. - [NTSB BFO85FA006](https://openairdocs.org/ntsb/BFO85FA006.md): Piper J3C-65 · Waterford, VA · Accident · 1 fatal · Field investigation · Final report · Nov 6, 1984 · N70645 · Destroyed > The aircraft was observed flying around the airstrip at dusk. As it passed over the aprx center of the field it was seen to nose over into a steep angle continuing until impact. Investigation revealed no evidence of any mal funtion of the aircraft or the… - [NTSB SEA85LA015](https://openairdocs.org/ntsb/SEA85LA015.md): Boeing A75N1 · Ely, NV · Accident · No injuries · Limited investigation · Final report · Nov 5, 1984 · N56234 · Substantial damage > The acft crashed in a swampy area during a forced landing after a power loss. The plt said he had a rise in oil temp andwas cruising at a lower alt to stabilize the oil temp. This necessitated navigating around some mountains which increased the flt distance.… - [NTSB MIA84LA023](https://openairdocs.org/ntsb/MIA84LA023.md): Cessna C-152 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 5, 1984 · N25575 · Destroyed > While cruising at 800 ft MSL the plt statd that the eng sputtered and lost all pwr as he opened the throttle. During the ensuing forced landing the plt veered to the left because of a bldg located at the end of the field. The acft collided with trees. An eng… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=347 ## 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=346 --- 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.