# NTSB investigations: Taxi 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 46 of 128 · 6,398 cases ## Cases, newest first - [NTSB MKC85LA067](https://openairdocs.org/ntsb/MKC85LA067.md): Cessna 150 · Keokuk, IA · Accident · No injuries · Limited investigation · Final report · Mar 4, 1985 · N51004 · Substantial damage > While taxiing for t/o on a sod rwy, gusting winds flipped the C-150 over after it became bogged down in the soft terrain. The plt was aware of the gusting wind conditions but was not expecting to get the a/c stuck, even though the pilot was aware it had… - [NTSB NYC85LA082](https://openairdocs.org/ntsb/NYC85LA082.md): Piper PA-22-108 · Reading, PA · Accident · No injuries · Limited investigation · Final report · Feb 27, 1985 · N66RA · Substantial damage > The acft overturned while awaiting takeoff from Reading,PA. Wind was reported from 310 degs at 16 KTS, gusting to 22 KTS. After engine up the tower advised N66RA tp hold for landing traffic which was a lear jet. Wind at this time was given as 310 KTS at 27… - [NTSB DEN85LA085](https://openairdocs.org/ntsb/DEN85LA085.md): Piper PA-18 · Polson, MT · Accident · No injuries · Limited investigation · Final report · Feb 25, 1985 · N8676C · Substantial damage > The plt stated a 35 kt gust of wind from the north lifted the tail of the acft to the left. The acft veered right, contacted a snow bank and nosed over. The plt was taxiing on rwy 18 after landing when the accident occurred. - [NTSB LAX85LA149](https://openairdocs.org/ntsb/LAX85LA149.md): Cessna 172G · Mojave, CA · Accident · No injuries · Limited investigation · Final report · Feb 20, 1985 · N1112F · Substantial damage > Prior to landing the plt was advised of wind gusts as high as 68 KTS. Plt landed & while taxiing to the ramp a gust of wind was experienced which blew the acft over to an inverted position. - [NTSB LAX85LA140](https://openairdocs.org/ntsb/LAX85LA140.md): Cessna 177RG · Ukiah, CA · Accident · No injuries · Limited investigation · Final report · Feb 14, 1985 · N2180Q · Substantial damage > On a dark night, the plt failed to observe that the taxiway (on which he was taxiing) made a 90 deg turn to connect with the beginning of the rwy. Where the taxiway turned, the acft continued straight ahead & went into a 3 ft deep ditch. There were no taxiway… - [NTSB SEA85LA057](https://openairdocs.org/ntsb/SEA85LA057.md): Cessna 172 · Boise, ID · Accident · No injuries · Limited investigation · Final report · Feb 10, 1985 · N3056V · Substantial damage > While taxiing on the ramp after landing, the right wing of the acft struck a jet blast fence. The plt stated two linemen were guiding the acft at the time. - [NTSB FTW85LA107](https://openairdocs.org/ntsb/FTW85LA107.md): Cessna A185F · Belle Chase, LA · Accident · No injuries · Limited investigation · Final report · Jan 31, 1985 · N53064 · Substantial damage > The plt had diverted back to the departure aprt due to wx. After landing, he was 'step taxiing' on the water with no reported difficulties when a landing gear shock strut, p/n 51961, separated. This allowed a float to dig into the water & caused the acft to… - [NTSB CHI85LA098](https://openairdocs.org/ntsb/CHI85LA098.md): Cessna 140A · Three Rivers, MI · Accident · No injuries · Limited investigation · Final report · Jan 27, 1985 · N5603C · Substantial damage > The ski equipped aircraft was taxiing on the frozen surface of the lake when the two bottom bolts that attached the right ski to the gear leg failed the overload failed the two top bolts and the ski failed out and up at a forty five degree angle this… - [NTSB CHI85LA089](https://openairdocs.org/ntsb/CHI85LA089.md): Beech 58P · Grand Rapids, MI · Accident · No injuries · Limited investigation · Final report · Jan 18, 1985 · N58PC · Substantial damage > At 1215 EST, a ground vehicle operator (S-1) rprtd that the braking action was poor on the rwys & taxiways (twys). In the next 9 min, 5 snow plows were cleared onto twys a & e. a short time later, the plt of N58PC was cleared to taxi fm the general aviation… - [NTSB MIA85LA080](https://openairdocs.org/ntsb/MIA85LA080.md): Cessna 182E · Ft Myers, FL · Accident · No injuries · Limited investigation · Final report · Jan 14, 1985 · N9383X · Substantial damage > The plt reported that after he had started the eng, the acft began moving out of the tie-down position. When he applied brakes, the right brake failed. He attempted to stop by using the parking brake, but the parking brake handle broke off. Subsequently, the… - [NTSB MIA85LA078](https://openairdocs.org/ntsb/MIA85LA078.md): Piper J3C-65 · St.Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Jan 12, 1985 · N70673 · Substantial damage > The acft collided with a parked acft while taxiing in from landing. The plt complained after the accident that the parked acft were too close to the taxiway. The tailwheel equipped acft had been engaged in banner towing operations prior to the taxi accident. - [NTSB ANC85LA037](https://openairdocs.org/ntsb/ANC85LA037.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jan 10, 1985 · N1827A · Substantial damage > Plt stated, while taxiing the wind lifted the acft twice. On the second ground contact the landing gear collapsed. Plt reported winds were from 090 degrees at 10 to 18 knots. - [NTSB CHI85LA074](https://openairdocs.org/ntsb/CHI85LA074.md): Cessna 150F · Staunton, IL · Accident · No injuries · Limited investigation · Final report · Dec 22, 1984 · N8232F · Substantial damage > While taxiing for takeoff at a private airstrip, the acft contacted a parked truck. The plt attributed the collision to his lack of alertness. - [NTSB SEA85LA045](https://openairdocs.org/ntsb/SEA85LA045.md): Cessna A152 · Deer Park, WA · Accident · No injuries · Limited investigation · Final report · Dec 19, 1984 · N7336B · Substantial damage > During landing practice on an instructional flight at an uncontrolled arpt, acft was being taxiied back for takeoff after a full stop landing. Surface was icy and snow-covered. Student was practicing directional control exercise with rudder. Acft skidded and… - [NTSB LAX85LA087](https://openairdocs.org/ntsb/LAX85LA087.md): Cessna 172N · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Dec 14, 1984 · N737PZ · Substantial damage > The plt landed normally & taxied off the rwy. The acft encountered a gust of wind & nosed over. Winds were reported as 300 deg at 20 KTS gusting to 25 KTS. - [NTSB MIA85FA059](https://openairdocs.org/ntsb/MIA85FA059.md): Britten-Norman BN-2 · San Juan, PR · Accident · No injuries · Field investigation · Final report · Dec 13, 1984 · N119DW · Substantial damage > After landing the flt was directed by ground control to taxi to the cargo ramp making room for a taxiing Boeing 747. Ground control then asked the acft to make a 180 deg turn and taxi further east on the ramp. As the left turn was completed the right brake… - [NTSB NYC85IA043](https://openairdocs.org/ntsb/NYC85IA043.md): Mcdonnell Douglas DC-10-10 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Dec 12, 1984 · N117AA · Minor damage > During taxi for departure, acft experienced several jolts to the right. Capt stopped acft and requested grnd personnel to inspect landing gear. Inspection revealed rt main gear truck beam failed. Metallurgical inspection of truck beam ass'y concluded the… - [NTSB MIA85LA054](https://openairdocs.org/ntsb/MIA85LA054.md): Piper PA28-151 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Dec 9, 1984 · N43080 · Substantial damage > Plt stated that he was unfamiliar with the arpt and requested assistance to taxi to the ramp. The pilot was told to take the first left turn to ramp, he turned onto an access road to the fire station and collided with a sign that stated 'no taxiway.' - [NTSB LAX85LA062](https://openairdocs.org/ntsb/LAX85LA062.md): Beech A36 · Salinas, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 7, 1984 · N6052M · Substantial damage > During walk-around preflight, plt was checking the prop for nicks and decided to 'turn the prop through' by hand to 'loosen the oil and coat cylinder walls,' assuming the power plant controls to be off and secure. The engine started at full power and the… - [NTSB CHI85LA068](https://openairdocs.org/ntsb/CHI85LA068.md): Cessna 182RG · Lafayette, IN · Accident · Minor injuries · Limited investigation · Final report · Dec 7, 1984 · N738CE · Destroyed > While turning the prop by hand to lubricate the engine it unintentionally started and ran at aprx 1700 RPM. The acft was not chocked or tied down and the parking brake was not set. The acft traveled across the ramp and collided with an empty t-hangar. After… - [NTSB NYC85LA035](https://openairdocs.org/ntsb/NYC85LA035.md): Globe GC-1B · Millbrook, NY · Accident · No injuries · Limited investigation · Final report · Nov 27, 1984 · N3709K · Substantial damage > Plt stated that while taxiing off the runway onto the taxiway, a gust of wind caused the acft to drift left. Plt stated he over corrected with rudder and power; acft swerved right, off the narrow prepared surface and down a steep embankment. - [NTSB CHI85LA064](https://openairdocs.org/ntsb/CHI85LA064.md): Piper PA-22-135 · Plainfield, IL · Accident · No injuries · Limited investigation · Final report · Nov 22, 1984 · N2381A · Substantial damage > Right wing of acft was lifted by wind while taxiing after landing. Plt was taxiing south then made turn into tie down area when accident occurred. Flaps were down and control wheel was held forward with left aileron input. Acft flipped over. Plt recommended,… - [NTSB MIA85LA034](https://openairdocs.org/ntsb/MIA85LA034.md): Piper PA-28R-201T · Gainesville, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 1984 · N38444 · Substantial damage > The acft collided with a tractor during taxi. The plt stated that he saw the tractor and thought there was room to pass. - [NTSB MKC85LA016](https://openairdocs.org/ntsb/MKC85LA016.md): Cessna 401A · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Nov 6, 1984 · N6294Q · Substantial damage > After a gear collapse following a manual extension of landing gear due to an electrical failure the acft was afforded a temporary repair by clamping a wrench to the landing gear strut to 'stiff-leg' it. The gear collapsed again during taxi to the active… - [NTSB DEN85LA023](https://openairdocs.org/ntsb/DEN85LA023.md): Piper PA-34-200T · Denver, CO · Accident · No injuries · Limited investigation · Final report · Nov 6, 1984 · N47347 · Substantial damage > According to the pilot, the acft was taxiing to park when a small truck was seen approaching from the right about 50 ft away. After realizing that the vehicle driver did not see the acft the pilot reduced power to idle and applied the brakes. The truck driver… - [NTSB LAX85IA037](https://openairdocs.org/ntsb/LAX85IA037.md): Boeing 747-131 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Nov 2, 1984 · N93106 · Minor damage > During darkness, a Boeing 747, N93106, was being taxied for departure when its left wing collided with the right wing of a Boeing 767 being towed in the same direction on a parallel taxiway. Both crews had obtained ground control clearances to perform their… - [NTSB LAX85LA033](https://openairdocs.org/ntsb/LAX85LA033.md): Cessna 150M · Lower Lake, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 1984 · N66592 · Substantial damage > The plt reported that he originally planned to start the acft eng in order to charge the battery. The eng started using the acft starter so the plt decided to fly. He set the parking brake & with the eng running at a 'fast idle', exited the acft, intending to… - [NTSB FTW85LA016](https://openairdocs.org/ntsb/FTW85LA016.md): Cessna 172P · Stillwater, OK · Accident · No injuries · Limited investigation · Final report · Oct 16, 1984 · N55350 · Substantial damage > Pilot had returned to his home airport after aborting a business flight due to weather. After landing, the pilot was taxiing from the active runway when the aircraft flipped inverted due to strong gusting winds. The wind was reported by the pilot to be… - [NTSB SEA85LA010](https://openairdocs.org/ntsb/SEA85LA010.md): Cessna C-207 · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Oct 15, 1984 · N70076 · Substantial damage > The right wing of N70076 contacted the spinning propeller of a PA-32-300 while taxiing from the ramp area to the active rwy. Plt stated he was checking the clearance on the left side of the acft and once viewing the PA-32-300 it was too late for the remedial… - [NTSB CHI85LA001](https://openairdocs.org/ntsb/CHI85LA001.md): Piper PA-23-250 · Greenbush, MN · Accident · No injuries · Limited investigation · Final report · Oct 3, 1984 · N37JL · Substantial damage > Following an uneventful approach and landing, the plt was taxiing back up the runway when the right engine quit. The right seat passenger immediately noted flames coming from the engine and notified the plt, who swung the acft into positon for wind to keep… - [NTSB LAX84LA501](https://openairdocs.org/ntsb/LAX84LA501.md): Bell 47G-2 · Borrego Springs, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1984 · N28895 · Substantial damage > After landing, the plt hover taxied to the fuel pumps to refuel. While maneuvering to touch down at the pumps, the main rotor blade struck a 10 to 12 ft high vent pipe. The plt reported that the vent pipes were painted black & were not readily apparent with… - [NTSB LAX84LA500](https://openairdocs.org/ntsb/LAX84LA500.md): Piper PA-60 · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Sep 29, 1984 · N90667 · Substantial damage > The takeoff rwy had arresting gear installed 1,900 ft from the threshold. In an effort to avoid rolling over the arresting gear cable during the takeoff roll the plt elected to utilize the overrun area for the initiation of the roll. As the acft taxied from… - [NTSB LAX84LA490](https://openairdocs.org/ntsb/LAX84LA490.md): Cessna 411 · Dolan Springs, AZ · Accident · No injuries · Limited investigation · Final report · Sep 22, 1984 · N323BE · Substantial damage > After lndg, the plt was taxiing back up the rwy to a parking area when the nose wheel 'fell into' a sand filled depression in the surface, collapsing the nose gear. County maintenance personnel had graded the rwy surface after heavy rains but no compaction… - [NTSB FTW84LA409](https://openairdocs.org/ntsb/FTW84LA409.md): Cessna 172P · Lancaster, TX · Accident · No injuries · Limited investigation · Final report · Sep 21, 1984 · N54984 · Substantial damage > Witnesses reported that the acft was taxiing fast and failed to clear the row of parked acft. The left wing contacted the tail of a parked Cessna 177, which was destroyed by impact and propeller damage as the taxiing acft swung into it. - [NTSB ATL84LA299](https://openairdocs.org/ntsb/ATL84LA299.md): Cessna 182H · Murray, KY · Accident · No injuries · Limited investigation · Final report · Sep 20, 1984 · N1936X · Substantial damage > The pilot stated that during taxi from landing, the left wing tip of the aircraft struck the corner of the main hangar building. Daylight hours, clear weather and dry ramp area conditions existed at the time. - [NTSB LAX84FA487](https://openairdocs.org/ntsb/LAX84FA487.md): Cessna 550 · Santa Ana, CA · Accident · No injuries · Field investigation · Final report · Sep 19, 1984 · N88MJ · Substantial damage > After completing a dual instructional flt in 91 to 103 deg wx, the acft landed uneventfully. The PIC failed to follow the required procedure in the flight manual of turning off the anti-skid switch after clearing the rwy. Rather, he used the outdated… - [NTSB ANC84LA183](https://openairdocs.org/ntsb/ANC84LA183.md): de Havilland DHC-2 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1984 · N5349G · Substantial damage > While taxiing for takeoff the aircraft's left wing struck a duck shack. - [NTSB FTW84LA387](https://openairdocs.org/ntsb/FTW84LA387.md): Piper PA-28-181 · Wharton, TX · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N4293Y · Substantial damage > After landing on rwy 14 the plt did a 180 deg turn and taxied back down the rwy. While attempting to turn right onto the taxiway the left main gear departing the improved surface and collapsed when it struck a concrete culvert. Brake skid marks were found on… - [NTSB LAX84LA503](https://openairdocs.org/ntsb/LAX84LA503.md): Cessna 172N · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1984 · N7338F · Substantial damage > While taxiing to rwy 28 on the taxiway the acft was overtaken by a vw bus which hit the acfts left wing. - [NTSB NYC84LA299](https://openairdocs.org/ntsb/NYC84LA299.md): Beech A23A · Mansfield, MA · Accident · No injuries · Limited investigation · Final report · Sep 2, 1984 · N613AW · Substantial damage > After a night landing, the plt went to the end of the rwy, then started a 180 deg turn to the right onto a parallel taxiway. He intended to head the opposite direction on the taxiway, which was not lighted. As he turned, the landing light (installed on the… - [NTSB MIA84LA243](https://openairdocs.org/ntsb/MIA84LA243.md): Piper PA-38 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Aug 31, 1984 · N23665 · Substantial damage > While taxiing for takeoff the acft veered to the left and collided with a parked acft. The plt stated a gust of wind caused the acft to veer. The acft operator reported the plt was helping the pax with a seatbelt when the accident occurred. - [NTSB FTW84LA373](https://openairdocs.org/ntsb/FTW84LA373.md): Cessna 172M · Bethany, OK · Accident · No injuries · Limited investigation · Final report · Aug 30, 1984 · N9646H · 2 aircraft · Substantial damage > According to the plt of N9646H, while he was taxiing under the direction of ground control the acft was struck from behind by N1PN. The plt of N1PN stated that he was cleared to taxi and did not see any other acft as he entered the taxiway. Seated in the rear… - [NTSB ANC84LA148](https://openairdocs.org/ntsb/ANC84LA148.md): Cessna 180 · Iliamna Bay, AK · Accident · 2 fatal · Limited investigation · Final report · Aug 28, 1984 · N2641Y · Destroyed > The acft struck a gravel bar while taxiing. The acft was not freed from the gravel bar until the next morning due to a receding tide on the previous night. Approx 3 hours later as the pilot taxied around awaiting daylight for takeoff, the acft rolled over in… - [NTSB LAX84LA455](https://openairdocs.org/ntsb/LAX84LA455.md): Hughes 269B · Goleta, CA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1984 · N9380F · Substantial damage > The student plt was practicing during solo flt and collided with the ground during an aerial taxi. The student explainedthat after a normal landing he pulled enough collective to make the acft light on the skids and proceeded to taxi along the ground by… - [NTSB MKC84LA261](https://openairdocs.org/ntsb/MKC84LA261.md): Cessna U206F · Satanta, KS · Accident · No injuries · Limited investigation · Final report · Aug 24, 1984 · N1386V · Substantial damage > The pilot selected 10 degrees of flap for takeoff with the aircraft loaded to near limits for existing conditions. The aircraft became airborne in ground effect and would not accelerate to flying speed, necessitating a forced landing in a soybean field.… - [NTSB NYC84LA297](https://openairdocs.org/ntsb/NYC84LA297.md): Piper PA-601P · Teterboro, NJ · Accident · No injuries · Limited investigation · Final report · Aug 23, 1984 · N18ZZ · Substantial damage > Acft was cleared to taxi to the rwy. Taxiway was blocked by construction. Plt elected to taxi to runup area to make a 180 deg turn. Plt turned right and right main gear went off pavement onto the soft shoulder and collapsed. - [NTSB LAX84LA449](https://openairdocs.org/ntsb/LAX84LA449.md): Cessna 206 · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1984 · N5122U · Substantial damage > While taxiing for takeoff the pilot's seat slid aft causing the loss of directional control and subsequent collision with other acft. The plt stated that when she entered the acft she moved the seat full forward and that the seat lockingmechanism was not… - [NTSB DEN84LA257](https://openairdocs.org/ntsb/DEN84LA257.md): Piper PA-38 · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Aug 19, 1984 · N43DR · Substantial damage > Following an uneventful solo flight the student plt began to follow a parking vehicle to a parking spot. The spot that the parking vehicle driver selected necessitated that the acft execute a 180 deg turn just priop to stopping. During this turn the right… - [NTSB MIA84LA228](https://openairdocs.org/ntsb/MIA84LA228.md): Douglas C-54 · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Aug 14, 1984 · N74183 · Substantial damage > The acft had returned for precautionary landing after #4 engine vibration was noted 10 mins into the flt. Acft landed 4000 lbs over max allowable landing wt. After #4 engine examination the acft was released for flight. An exchangeof pilot in command was made… - [NTSB ATL84LA257](https://openairdocs.org/ntsb/ATL84LA257.md): Cessna 177RG · Shelbyville, TN · Accident · No injuries · Limited investigation · Final report · Aug 8, 1984 · N35849 · Substantial damage > The acft collided with a parked truck on a taxiway en route to takeoff. The plt said he observed the parked truck on thetaxiway. There was another taxiway available but the plt continued on the congested one with the acft wing overlapping the truck by about 7… Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=47 ## 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 = 250) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/250/cases?page=46 --- 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.