# NTSB investigations: Landing 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 435 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB MKC85LA010](https://openairdocs.org/ntsb/MKC85LA010.md): Aspen Quickie 2 · Grand Island, NE · Accident · No injuries · Limited investigation · Final report · Oct 29, 1984 · N39202 · Substantial damage > The plt stated that he was practicing landings & had less than three hours total time in the Q2. He said he flared high & bounced three times. During the third bounce the front wing, to which the main landing gear is attached, broke & the acft ran off the… - [NTSB MIA85LA019](https://openairdocs.org/ntsb/MIA85LA019.md): Beech 76 · Ft.Walton Beach, FL · Accident · No injuries · Limited investigation · Final report · Oct 29, 1984 · N38085 · Substantial damage > During takeoff on a multiengine instructioanl flt, the instructor (CFI) simulated an eng failure by retarding power on the left eng. The student elected to land on the remaining rwy. He retarded the right eng power & dove for the rwy, but the acft touched… - [NTSB CHI85LA033](https://openairdocs.org/ntsb/CHI85LA033.md): Cessna 172 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Oct 28, 1984 · N66964 · Substantial damage > The pvt plt stated that he was aware of a nose wheel shimmy on the acft before flt but was advised by the operator that it was safe to fly. He stated that upon landing, when the nose wheel touched down, it began to shimmy violently and the nose tire blew.… - [NTSB ANC85LA014](https://openairdocs.org/ntsb/ANC85LA014.md): de Havilland Otter DHC-3 · Dan Creek, AK · Accident · No injuries · Limited investigation · Final report · Oct 28, 1984 · N2899J · Substantial damage > According to the plt the acft hit a downdraft, landed hard and struck the wing on the rwy surface. The wind was reported from 360 deg 15 KTS gusting to 20 KTS. - [NTSB NYC85LA020](https://openairdocs.org/ntsb/NYC85LA020.md): Piper PA-28-161 · Farmington, PA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1984 · N82587 · Substantial damage > According to the plt, during the landing flare the wind shifted causing the acft to drift off the left side of the rwy striking rwy lights and a pole. Winds were from 230 deg at 10 KTS gusting to 15. - [NTSB LAX85LA032](https://openairdocs.org/ntsb/LAX85LA032.md): Cessna 152 · Fillmore, CA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1984 · N48809 · Substantial damage > According to the pilot, unforecast wx was encountered in cruise at 6,500 ft. the student became lost and elected to make a precautionary landing in an unimproved field. The nose gear collapsed on touchdown and the acft nosed over coming to rest inverted. No… - [NTSB BFO85FA003](https://openairdocs.org/ntsb/BFO85FA003.md): Piper PA-23-250 · Washington, DC · Accident · No injuries · Field investigation · Final report · Oct 27, 1984 · N6235Y · Substantial damage > After a high & fast apch, acft touched down beyond midfield on rwy 36 at dca. Plt delayed initiating a go around until he was sure the acft would not stop in the rwy remaining. On initial climb the acft struck two apch lights at the departure end of the rwy,… - [NTSB ANC85LA013](https://openairdocs.org/ntsb/ANC85LA013.md): Maule M-6 · Homer, AK · Accident · No injuries · Limited investigation · Final report · Oct 27, 1984 · N5645D · Substantial damage > Shortly after touchdown the acft veered left. Right rudder was applied causing the acft to over correct back to the right. In an effort to regain directional control left rudder was applied. The acft ground looped to the right collapsing the left main landing… - [NTSB FTW85LA024](https://openairdocs.org/ntsb/FTW85LA024.md): Beech 58P · Beeville, TX · Accident · 1 fatal · Limited investigation · Final report · Oct 26, 1984 · N187DA · Destroyed > When the plt called the fss at 1426 EDT & filed an IFR flt plan, the fss person began providing a wx briefing. The plt interrupted the wx briefing & said he would check back later. He called back at 2016 EDT, but talked to another briefer & only asked for… - [NTSB ATL85LA022](https://openairdocs.org/ntsb/ATL85LA022.md): Beech 95 · Birmingham, AL · Accident · No injuries · Limited investigation · Final report · Oct 26, 1984 · N2773Y · Substantial damage > Plt reported apch was high and fast but when the nose gear touched down during the normal landing, the nose gear tire blew. A witness stated the acft porpoised several times and then impacted on the nose gear resulting in the blown out tire. - [NTSB ANC85FA012](https://openairdocs.org/ntsb/ANC85FA012.md): Maule M-6-235 · Kenai, AK · Accident · No injuries · Field investigation · Final report · Oct 26, 1984 · N56512 · Substantial damage > The acft bounced twice at a point about 1000-1500 ft down the rwy and then started to ground loop according to a witness. During the ground loop the acft pitched up and climbed steeply to about 40 ft AGL and stalled. The right wing dropped and the acft… - [NTSB LAX85LA031](https://openairdocs.org/ntsb/LAX85LA031.md): Piper PA-22-20 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Oct 24, 1984 · N72480 · Substantial damage > The student plt started to retract the flaps during a touch-&-go landing with a CFI on board the acft. The acft veered and the CFI took control. During this time the student applied the brakes. The right main landing gear went into the dirt and the acft nosed… - [NTSB ATL85LA019](https://openairdocs.org/ntsb/ATL85LA019.md): Cessna 172M · Griffin, GA · Accident · No injuries · Limited investigation · Final report · Oct 24, 1984 · N92388 · Substantial damage > The acft ran off the side of the rwy during landing. The plt planned to do touch and go landings. On the 1st landing theacft veered to the right and rolled off the rwy. The plt added power but the acft went into a ditch. The student plts logbook was not… - [NTSB NYC85LA012](https://openairdocs.org/ntsb/NYC85LA012.md): Cessna 152II · Wappinger Falls, NY · Accident · No injuries · Limited investigation · Final report · Oct 22, 1984 · N4904B · Substantial damage > The solo student plt stated that during the flare the acft drifted left toward the rwy lights. A go-around was initiated with power and the acft flew over the lights but collided with the unimproved grassy terrain, coming to rest aprx 30 ft left of the rwy. - [NTSB ANC85LA011](https://openairdocs.org/ntsb/ANC85LA011.md): Piper PA-18 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Oct 22, 1984 · N4361A · Substantial damage > According to the plt, when he arrived at the gravel bar the passengers to be picked up were not there & could not be located from the air. After making low passes over the gravel bar he determined that the snow did not look deep and touched down to check the… - [NTSB FTW85LA021](https://openairdocs.org/ntsb/FTW85LA021.md): Cessna 152 · Bogalusa, LA · Accident · No injuries · Limited investigation · Final report · Oct 21, 1984 · N5097H · Substantial damage > The solo student plt landed 8 to 10 ft short of the rwy and rolled into the asphalt lip of the prepared surface. Touchdown occurred in an area of construction lengthening the rwy. - [NTSB NYC85LA011](https://openairdocs.org/ntsb/NYC85LA011.md): Cessna 206 · Menemsha, MA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1984 · N8063E · Substantial damage > During climb out when the plt normally retracted the landing gear he was copying an IFR clearance. The gear were not retracted and upon touchdown in the pond the float acft nosed over in the 8 ft deep water. - [NTSB LAX85LA026](https://openairdocs.org/ntsb/LAX85LA026.md): Harvard MK IV/AT-6 · Apple Valley, CA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1984 · N44110 · Substantial damage > Plt had executed successful crosswind landing and was decelerating on roll-out when a gust of wind caused the acft to swerve into the wind. Directional control could not be regained with rudder so plt elected to attempt go-around. Acft became airborne in… - [NTSB CHI85LA024](https://openairdocs.org/ntsb/CHI85LA024.md): Piper PA28-151 · Lake Village, IN · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1984 · N41483 · Substantial damage > The plt reported that he was on final apch to land on a wet, sod rwy when he noticed a flock of geese over the apch end. He added power to fly over the geese then proceeded to touchdown further down the rwy than what he had planned. Due to his speed & the wet… - [NTSB CHI85LA022](https://openairdocs.org/ntsb/CHI85LA022.md): Cessna 172N · Dodgeville, WI · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 1984 · N734YR · Destroyed > The plt attempted a landing on rwy 30 which is 85 ft higher in elev at the approach end of the rwy than the departure end. This was the plt's first flt to this arpt. The acft touched down further down the rwy than intended so the plt applied pwr to abort the… - [NTSB ATL85LA015](https://openairdocs.org/ntsb/ATL85LA015.md): Piper PA-38-112 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Oct 20, 1984 · N2388V · Substantial damage > During attempted go-around from a bounced landing, the plt allowed the acft to drift off center line and into trees paralling the runway. Directional control was compromised by low flying speed. - [NTSB ANC85LA009](https://openairdocs.org/ntsb/ANC85LA009.md): Cessna U-206C · Iliamna, AK · Accident · 1 fatal · Limited investigation · Final report · Oct 20, 1984 · N9577G · Substantial damage > The acft dragged a wing tip & nosed over while landing on a small lake near Iliamna, Alaska. The passenger seated next to the PIC stated that the plt had cancelled his flt plan prior to landing, circled the lake & made a long final apch to a touchdown on the… - [NTSB ANC85LA007](https://openairdocs.org/ntsb/ANC85LA007.md): Cessna A185E · Shulin Lake, AK · Accident · No injuries · Limited investigation · Final report · Oct 20, 1984 · N70018 · Substantial damage > The acft nosed over during a water landing. This acft had wheels in the floats and one of the wheels was not retracted for the water landing. These gear are hand retracted by the plt. The plt said he checked visually to insure the left gear was up but did not… - [NTSB CHI85LA019](https://openairdocs.org/ntsb/CHI85LA019.md): Piper PA-34-200T · Compton, IL · Accident · No injuries · Limited investigation · Final report · Oct 18, 1984 · N500JT · Substantial damage > The plt stated that he landed aprx 1/4 way down the wet sod rwy which is 2590 ft long. The braking action was nil. The acft ran off the end of the rwy & collided with a 3 ft embankment. - [NTSB LAX85LA021](https://openairdocs.org/ntsb/LAX85LA021.md): Cessna 172RG · El Monte, CA · Accident · No injuries · Limited investigation · Final report · Oct 16, 1984 · N6456V · Substantial damage > The plt landed the acft fast & lost control. Subsequently, the acft went off the right side of the rwy & struck a perimeter fence. - [NTSB DEN85LA012](https://openairdocs.org/ntsb/DEN85LA012.md): Piper PA-34-220T · Creede, CO · Accident · No injuries · Limited investigation · Final report · Oct 16, 1984 · N8011J · Substantial damage > According to the plt, just prior to landing, at about 5 ft AGL, the gear warning horn sounded and the right main gear down and locked light flickered. The landing was continued and the right gear collapsed during the rollout. A mechanic who examined the acft… - [NTSB ANC85LA006](https://openairdocs.org/ntsb/ANC85LA006.md): Beech 3NM · Selawik, AK · Accident · No injuries · Limited investigation · Final report · Oct 16, 1984 · N9540 · Substantial damage > Maintaining visual separation with other acft, flying a straight-in apch instead of a conventional pattern, and concern over the landing on a short strip interfered with the plt's habit pattern. The gear was not extended and the gear-up landing resulted. - [NTSB MIA85LA010](https://openairdocs.org/ntsb/MIA85LA010.md): Cessna 152 · Ormond Beach, FL · Accident · No injuries · Limited investigation · Final report · Oct 15, 1984 · N757TV · Substantial damage > Student pilot was on first solo flight. Upon touchdown on main gear, the aircraft bounced and came down the second time on its nose gear. Main engine mount was bent. - [NTSB MIA85LA008](https://openairdocs.org/ntsb/MIA85LA008.md): Cessna 150J · Coolidge, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1984 · N60960 · Substantial damage > The acft collided with a bush during landing. The plt flew under a wire that he saw just in time to avoid hitting and over the 5 foot embankment on the opposite side of an intervening roadway. After the collision, the acft flipped over and slid through a… - [NTSB LAX85LA018](https://openairdocs.org/ntsb/LAX85LA018.md): Cessna R172 · Corning, CA · Accident · No injuries · Limited investigation · Final report · Oct 15, 1984 · N758FN · Substantial damage > The plt reported that during a landing on rwy 34, the acft encountered a x-wind gust & was pushed off the rwy. It subsequently collided with a ditch & was damaged. The plt reported that the wind was from 300 deg at 16 gusting 22 KTS. - [NTSB FTW85LA018](https://openairdocs.org/ntsb/FTW85LA018.md): Cessna 152 · Uvalde, TX · Accident · No injuries · Limited investigation · Final report · Oct 15, 1984 · N67172 · Substantial damage > Witnesses stated that the student plt made an initial solo takeoff & landing. During the second landing attempt he made a go-around. On the final landing the acft touched on the wheels, bounced/floated, started to porpoise and collapsed the nose gear. - [NTSB FTW85LA013](https://openairdocs.org/ntsb/FTW85LA013.md): Stinson 108-2 · Booker, TX · Accident · No injuries · Limited investigation · Final report · Oct 15, 1984 · N9737K · Substantial damage > Plt arrived at destination at dusk. Lighted wind tetrahedron was out of service. Plt executed low pass in unsuccesful attempt to see windsock. Plt was aware of strong surface winds (about 35 KTS), presumed to be from sw, from recent frontal passage and… - [NTSB MIA85LA007](https://openairdocs.org/ntsb/MIA85LA007.md): Cessna T210N · Live Oak, FL · Accident · No injuries · Limited investigation · Final report · Oct 14, 1984 · N7393C · Substantial damage > The acft was landed long on the rwy according to the plts statement. He also said that he could not go-around because OF50 ft trees at the end of the rwy, so he elected to aim (place) the acft 'between a tree & house for safety reasons.' The accident happened… - [NTSB DCA85IA001](https://openairdocs.org/ntsb/DCA85IA001.md): McDonnell Douglas DC-9-30 · Erie, PA · Incident · No injuries · Incident investigation · Final report · Oct 14, 1984 · N965VJ · Minor damage > The orig destn was youngstown, OH, but its wx was blo mins, so the flt to transport a football team was planned to Erie which was slightly above mins. The coach & business manager were not happy about this, but plans were made to bus the team on to… - [NTSB ANC85LA004](https://openairdocs.org/ntsb/ANC85LA004.md): Cessna U206 · Hinchinbrook, AK · Accident · No injuries · Limited investigation · Final report · Oct 14, 1984 · N4863C · Substantial damage > Investigation revealed that the nose gear torque link bolt sheared during the landing roll on an abandoned sand airstrip causing the gear collapse and noseover. Metallurgical testing disclosed evidence of long term progression of severe corrosion between the… - [NTSB SEA85LA008](https://openairdocs.org/ntsb/SEA85LA008.md): Cessna T210N · Gabbs, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1984 · N6488N · Substantial damage > On landing touchdown, the acft bounced and ballooned back into the air. Plt applied full throttle for go-around, but engine responded with partial power, insufficient for successful go-around. Plt then cut throttle in attempt to remain within airport confines… - [NTSB LAX85LA016](https://openairdocs.org/ntsb/LAX85LA016.md): Piper PA-24-260 · Sonoma, CA · Accident · No injuries · Limited investigation · Final report · Oct 13, 1984 · N9493P · Substantial damage > Plt made inadvertant gear up landing. Plt stated he forgot to lower the gear when his attention was diverted to the cabin door which came open in-flight. - [NTSB LAX85LA014](https://openairdocs.org/ntsb/LAX85LA014.md): Beech B35 · Marble Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Oct 13, 1984 · N8885A · Substantial damage > Plt stated wind was from 220 deg at 5 KTS but after touchdown a gust of wind caught the right wing forcing the acft off rwy. Plt added full pwr to abort landing and acft became airborne. Left landting gear contacted a sand dune. As acft veered left it… - [NTSB LAX85FA015](https://openairdocs.org/ntsb/LAX85FA015.md): Bellanca 73CA · Porterville, CA · Accident · 1 fatal · Field investigation · Final report · Oct 13, 1984 · N53860 · Destroyed > The acft crashed after an inflt loss of control during both the landing flare & subsequent go around attempt. The plt stated that he was approaching touchdown in a three point attitude when 'a gust of wind suddenly pushed (the acft) to the right of the… - [NTSB ATL85LA006](https://openairdocs.org/ntsb/ATL85LA006.md): Smith, Ted Aerostar Aerostar 600 · Abbeville, SC · Accident · No injuries · Limited investigation · Final report · Oct 11, 1984 · N66CM · Substantial damage > Right main tire blew during a hard landing. Plt applied left brake and rudder but acft continued off right side of rwy. Acft skidded across a pile of debris which initiated a flash fire in the underbrush. The right main gear assembly was broken from the acft… - [NTSB LAX85LA010](https://openairdocs.org/ntsb/LAX85LA010.md): Cessna 177RG · Concord, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1984 · N52936 · Substantial damage > The plt stated that he did a go-around while on final approach to runway 19L because of excessive speed. The plt re-entered the traffic pattern and was cleared by the tower to lnd on rwy 19R. The plt stated that he was advised by the tower to initiate the… - [NTSB LAX85LA009](https://openairdocs.org/ntsb/LAX85LA009.md): Cessna 172H · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1984 · N8048L · Substantial damage > The plt said that after he returned to the arpt for a night landing, he applied back pressure during the flare, then heard the stall warning horn. Subsequently, the acft was damaged when it landed hard & bounced. However, the plt was able to taxi to the… - [NTSB FTW85LA020](https://openairdocs.org/ntsb/FTW85LA020.md): Cessna 310C · Los Fresnos, TX · Accident · No injuries · Limited investigation · Final report · Oct 9, 1984 · N1794H · Substantial damage > The plt stated that he landed on rwy 32 after noting vertical rising smoke about 1/2 mi north of the airstrip. He stated that during landing he encountered a 20 to 25 kt tailwind from a small local squall line & was unable to stop the acft. The acft continued… - [NTSB ATL85LA003](https://openairdocs.org/ntsb/ATL85LA003.md): Cessna 172N · Gold Hill, NC · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1984 · N737MW · Substantial damage > The plt was uable to raise UNICOM for wind advisories and was unable to find the wind sock to aid in rwy selection. He did see some smoke on the ground which indicated calm winds. During his flare the acft floated about halfway down the rwy, touched down and… - [NTSB LAX85LA022](https://openairdocs.org/ntsb/LAX85LA022.md): Cessna 180 · Santa Monica, CA · Accident · No injuries · Limited investigation · Final report · Oct 8, 1984 · N4932A · Substantial damage > Plt reproted, descent made to mda of 740 ft MSL and visual contact made with rwy 1/2 mile east of arpt. Slipped acft to within 200 ft of rwy and made a wheel landing midfield. Both wheels locked up and acft nosed over. Plt stated, 'I may have had my feet on… - [NTSB CHI85LA006](https://openairdocs.org/ntsb/CHI85LA006.md): Piper PA-34-200T · Lincoln, IL · Accident · No injuries · Limited investigation · Final report · Oct 8, 1984 · N44730 · Substantial damage > According to the pilot touchdown occurred on the first third of the rwy and braking seemed ineffective. He further stated that as brake pressure was increased the seat back failed. A representative of the FAA examined the seat and found no evidence of… - [NTSB SEA85LA005](https://openairdocs.org/ntsb/SEA85LA005.md): Cessna 172N · Ashford, WA · Accident · No injuries · Limited investigation · Final report · Oct 7, 1984 · N739UW · Substantial damage > The acft ground looped during a landing in a gusty x-wind. After directional control was lost the acft veered off the rwy striking trees. No accident report form was filed by the plt. - [NTSB NYC85LA006](https://openairdocs.org/ntsb/NYC85LA006.md): Champion 7KCAB · Coram, NY · Accident · No injuries · Limited investigation · Final report · Oct 7, 1984 · N76BP · Substantial damage > Plt stated rough condition of runway surface made directional control difficult. The left wheel overran the runway edge which was bounded by a dirt ridge. Plt was unable to bring the left wheel back onto the prepared surface as ridge dimensions increase… - [NTSB FTW85LA008](https://openairdocs.org/ntsb/FTW85LA008.md): Lake LA-4-200 · Waurika, OK · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 1984 · N6685L · Destroyed > According to witnesses, the acft nose was too low at water contact on lndg touchdown and the nose and right pontoon dug into the water. The acft swerved abruptly to the right, flipped inverted and sank. No logs or other floating debris were located during a… - [NTSB FTW85LA007](https://openairdocs.org/ntsb/FTW85LA007.md): Piper PA-30 · Amarillo, TX · Accident · No injuries · Limited investigation · Final report · Oct 7, 1984 · N8692Y · Substantial damage > During the lndg roll, all 3 lndg gear collapsed. The plt stated that on short final he inadvertantly retracted the gear instead of the flaps. He immediately cycled it back down butthe gear collapsed shortly after touchdown. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=436 ## 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 = 550) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?page=435 --- 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.