# 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 40 of 128 · 6,398 cases ## Cases, newest first - [NTSB SEA89LA024](https://openairdocs.org/ntsb/SEA89LA024.md): Cessna 180J · Ketchikan, AK · Accident · No injuries · Limited investigation · Final report · Dec 6, 1988 · N46602 · Substantial damage > The pilot had planned to taxi the floatplane from one ramp to another for the purpose of obtaining an annual inpn & to dock the plane at better facilities. She found the float rudder pulley to be inoperative. A decision was then made to fly the plane from its… - [NTSB ANC89LA021](https://openairdocs.org/ntsb/ANC89LA021.md): de Havilland DHC-6 · Homer, AK · Accident · No injuries · Limited investigation · Final report · Dec 4, 1988 · N525EH · Substantial damage > After landing, the plt was advised to taxi to the ramp via the south taxiway, since this was the only taxiway that had been snow plowed. Only about a 12 ft width of the 80 ft wide taxiway had been plowed. The cleared portion was on the outer edge of the… - [NTSB NYC89LA031](https://openairdocs.org/ntsb/NYC89LA031.md): Grumman AA-5 · Latrobe, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 1988 · N30FA · Substantial damage > Loss of directional control while taxiing at an excessive speed. - [NTSB MIA89LA025](https://openairdocs.org/ntsb/MIA89LA025.md): Piper PA-31-350 · Tupelo, MS · Accident · No injuries · Limited investigation · Final report · Nov 10, 1988 · N637JC · 2 aircraft · Substantial damage > The Cessna plt was taxiing his acft on a marked taxiway when he observed a Piper PA-31-350 (chieftain) entering the taxiway ahead of his acft. The Cessna plt applied the brakes & stated the acft was stopped for 3-4 seconds before the left wing of the Piper… - [NTSB ATL89FA020](https://openairdocs.org/ntsb/ATL89FA020.md): Mcdonnell Douglas DC-9-31 · Memphis, TN · Accident · No injuries · Field investigation · Final report · Oct 30, 1988 · N918RW · Substantial damage > The acft was being taxied to the gate when its right wingtip struck a catering truck that had been driven off of the designated driving lanes & partially onto the taxiway. The flt crew rprtd that the truck was traveling in the same direction within the… - [NTSB ANC89LA037](https://openairdocs.org/ntsb/ANC89LA037.md): Cessna 180 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Oct 30, 1988 · N9278C · Substantial damage > The pilot reported that he lost directional control of the airplane during a post-flight taxi to tie down. He said that a small flashlight had fallen behind the left rudder pedal and limited the amount of brake and rudder available for directional control. - [NTSB MIA89LA018](https://openairdocs.org/ntsb/MIA89LA018.md): Schweizer 269C · Arcadia, FL · Accident · No injuries · Limited investigation · Final report · Oct 28, 1988 · N75068 · Substantial damage > After making an apch to 'the numbers' on rwy 5, the plt decelerated the helicopter & began to air taxi to the refueling area. Subsquently, while decelerating and/or while taxiing, the tail rotor collided with terrain. - [NTSB FTW89LA009](https://openairdocs.org/ntsb/FTW89LA009.md): Cessna 152 · Muskogee, OK · Accident · No injuries · Limited investigation · Final report · Oct 26, 1988 · N4715B · Substantial damage > Acft's left wing struck a truck that was parked adjacent to the taxiway. After initial impact, the acft veered left and the nose also struck the truck. The plt stated that he was concentrating on a ramp sweeper that was moving down the taxiway in front of the… - [NTSB DEN89LA018](https://openairdocs.org/ntsb/DEN89LA018.md): Cessna U206 · Brush, CO · Accident · No injuries · Limited investigation · Final report · Oct 17, 1988 · N184V · Destroyed > Following landing at an unattended airport, while back-taxiing, the eng failed. During restart the plt heard a loud 'pop' from the eng compartment followed by white smoke and flame. The plt and pax exited the acft and the plt went to a nearby phone to call… - [NTSB BFO89LA002](https://openairdocs.org/ntsb/BFO89LA002.md): Pitts S-1S · Ridgeway, VA · Accident · No injuries · Limited investigation · Final report · Oct 16, 1988 · N66RJ · Substantial damage > The pilot landed to the south on the private airstrip. In an attempt to make a left 180 deg turn to back taxi on the runway and avoid acft parked along the left side of the runway, the pilot steered his airplane to the right. While turning to the right, the… - [NTSB NYC89LA010](https://openairdocs.org/ntsb/NYC89LA010.md): Beech 77 · Farmingdale, NY · Accident · No injuries · Limited investigation · Final report · Oct 10, 1988 · N37273 · Substantial damage > The pilot of the Beech 77 had just started the engine and was checking the gauges, when the aircraft started moving forward. The pilot tried to turn the aircraft onto a taxiway. The aircraft continued straight ahead and hit two parked aircraft. - [NTSB FTW89DPA01](https://openairdocs.org/ntsb/FTW89DPA01.md): Shannon J-BIRD · Mckinney, TX · Accident · Minor injuries · Final report · Oct 1, 1988 · N151JS · Substantial damage > The plt rprtd he was making a high speed taxi test of his gyroplane after installation of a different eng & prop. He said the gyroplane enctrd a bump on the rwy which caused it to become airborne at about 35 mph (takeoff speed was 45 mph). He added power to… - [NTSB ATL89LA001](https://openairdocs.org/ntsb/ATL89LA001.md): Grumman AA-5A · Ridgeland, SC · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 1988 · N26827 · Substantial damage > The plt reported that the left brake failed to function during taxi when he attempted to reduce speed and turn 180 deg into t/o position. The airplane began to track to the right. He released brake pressure on both pedals thinking that he might have been… - [NTSB CHI88LA242](https://openairdocs.org/ntsb/CHI88LA242.md): Piper PA-32-300 · Akron, OH · Accident · No injuries · Limited investigation · Final report · Sep 28, 1988 · N8322C · Substantial damage > On taxiing in from landing on a dark night, the pilot inadvertently taxied off the pavement onto a grassy area. When he realized that he was off the pavement he made an attempt to return to the pavement and encountered a 20' hole. The main gear sank into the… - [NTSB MIA88LA276](https://openairdocs.org/ntsb/MIA88LA276.md): Piper PA-28R-200 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Sep 24, 1988 · N15513 · Substantial damage > While taxiing to takeoff after lndg, the left main lndg gear collapsed. The acft slid to stop. Examination of the acft revealed the lndg gear microswitch failed internally. The landing gear handle was down gut no determination could be made as to its position… - [NTSB DEN88LA211](https://openairdocs.org/ntsb/DEN88LA211.md): Cessna 172Q · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Sep 19, 1988 · N66076 · Destroyed - [NTSB ANC88LA132](https://openairdocs.org/ntsb/ANC88LA132.md): Maule M-5-235 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1988 · N362X · Substantial damage > The commercial pilot had dropped two hunters off at their campsite, and was taxiing for takeoff on an unlighted gravel bar at dusk. He misjudged the end of the gravel bar in the fading light and taxied off a four foot embankment. - [NTSB MKC88LA150](https://openairdocs.org/ntsb/MKC88LA150.md): Aeronca 7CCM · Weiner, AR · Accident · No injuries · Limited investigation · Final report · Aug 30, 1988 · N85294 · Substantial damage > The pilot handproped the starterless aircraft. After engine start, the pilot was unable to gain access to the cockpit, and the aircraft taxied uncontrolled into some nearby farm implements. The purpose of the flight was to ferry the acft for an annual… - [NTSB LAX88LA329](https://openairdocs.org/ntsb/LAX88LA329.md): Cessna 172N · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Aug 28, 1988 · N789CE · Substantial damage > While taxiing for takeoff, the pilot maneuvered off the taxiway centerline to allow an oncoming Cessna 182 to pass. The Cessna 172 then collided with an airport t-hangar located near the taxiway. - [NTSB LAX88LA296](https://openairdocs.org/ntsb/LAX88LA296.md): Cessna 402C · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Aug 25, 1988 · N5715C · Substantial damage > While taxiing, in order to clear a parked airplane to the right, the pilot maneuvered the airplane left of the centerline. The left main landing gear traveled off the asphalt. The airplane pivoted 90 degrees from the direction of travel collapsing the landing… - [NTSB FTW88LA152](https://openairdocs.org/ntsb/FTW88LA152.md): Brantly Helicopter B-2B · Sallisaw, OK · Accident · No injuries · Limited investigation · Final report · Aug 25, 1988 · N2264U · Substantial damage > Acft experienced a hard landing and rolled over following a loss of control in a hover. Plt delayed cutting the throttle in order to clear a ditch. Investigation revealed that the tail rotor driveshaft coupling retaining screw had separated. The separation… - [NTSB ANC88DAG07](https://openairdocs.org/ntsb/ANC88DAG07.md): Cessna T182RG · Kenai, AK · Accident · No injuries · Final report · Aug 22, 1988 · N738NR · Substantial damage > The pilot was taxiing the Cessna to the ramp area when the airplane wing struck a light pole near the terminal building. The pilot stated that he did not see the light pole before impact and that it blended in with the natural surroundings. - [NTSB NYC88LA214](https://openairdocs.org/ntsb/NYC88LA214.md): Bell 47G5 · Biddeford, ME · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1988 · N14861 · Substantial damage > The helicopter made an approach to a low hover above a hard surfaced rwy. The helicopter was slowly air taxiing when the plt felt the helicopter become unstable directionally and he considered making a run-on landing. However, before he could make the landing… - [NTSB NYC88LA204](https://openairdocs.org/ntsb/NYC88LA204.md): Sikorsky S-76A · Teterboro, NJ · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N69WW · Substantial damage > The S-76 helicopter was taxiing on its company ramp when the copilot taxied onto a grass area. During a left turn the right main wheel stuck in a soft spot and the helicopter rolled over on its right side receiving substantial damage. The ground maneuver that… - [NTSB ATL88IA226](https://openairdocs.org/ntsb/ATL88IA226.md): Douglas DC-9-51 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Aug 5, 1988 · N421EA · 2 aircraft · Minor damage > The eastern DC-9 collided with the delta DC-9 during taxi. Ground personnel had cleared the eastern flight forward after the pilot had completed a powerback which left the airplane perpendicular to the delta flight. Due to the long fuselage and the relative… - [NTSB CHI88LA185](https://openairdocs.org/ntsb/CHI88LA185.md): Cessna 172N · Xenia, OH · Accident · No injuries · Limited investigation · Final report · Aug 1, 1988 · N2282E · Substantial damage - [NTSB CHI88FA179](https://openairdocs.org/ntsb/CHI88FA179.md): Piper PA-30 · Oshkosh, WI · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1988 · N43GS · No damage - [NTSB ANC88FA100](https://openairdocs.org/ntsb/ANC88FA100.md): Fairchild SA227-AT · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jul 28, 1988 · N482SA · Substantial damage > During the taxi to the runway, the flight crew noted a vibration in the airplane and stopped to check the tires, thinking that they were underinflated. No obvious problem was seen, and they elected to takeoff. Shortly after takeoff, a fire erupted in the left… - [NTSB DEN88IA167](https://openairdocs.org/ntsb/DEN88IA167.md): Boeing 727-100 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Jul 26, 1988 · N1973 · Minor damage > While taxiing to the cargo ramp, the left wing collided with a lightpole as the flight crew were directed by gnd pers. One taxi director attempted to handoff the flight to another but the second misunderstood and turned away. A third person, who was not a… - [NTSB ANC88LA151](https://openairdocs.org/ntsb/ANC88LA151.md): Cessna U206F · Lake Minchumina, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 25, 1988 · N401SU · Substantial damage > The plt said he was taxiing the floatplane from a windy/wavy location to a small protected cove for a final preflt. While taxiing, the top cap of the left float was open & the float began filling with water. Subsequently, the float- plane rolled over & sank. - [NTSB MIA88LA220](https://openairdocs.org/ntsb/MIA88LA220.md): Classic YMF-5 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Jul 13, 1988 · N99Y · Substantial damage > While turning the acft around at the operator's establishment after completing a sightseeing flt, the lower left wing collided with a vehicle. - [NTSB CHI88FA163](https://openairdocs.org/ntsb/CHI88FA163.md): Boeing 727 · St Paul, MN · Accident · No injuries · Field investigation · Final report · Jul 11, 1988 · N254US · Substantial damage > After push back from the gate, the captain received an unrestricted taxi clearance & elected to taxi to the north side of a construction area. Subsequently, the left wing of the acft struck a parked vehicle in a nonmovement area, which resulted in substantial… - [NTSB ANC88LA090](https://openairdocs.org/ntsb/ANC88LA090.md): Cessna A185F · Georgetown, AK · Accident · No injuries · Limited investigation · Final report · Jul 11, 1988 · N4742E · Substantial damage > The pilot stated that he encountered several up & down drafts prior to lndg. After landing and taxiing toward shore, the pilot saw the surface water on the river being whipped up; the pilot estimated the wind to be 40 knots or more. The aircraft became… - [NTSB MKC88LA123](https://openairdocs.org/ntsb/MKC88LA123.md): Aeronca 7EC · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · Jul 10, 1988 · N82994 · 2 aircraft · Substantial damage > The plt said he was taxiing out for departure, when he collided with another aircraft that was taxiing in from a local flight. He said he was intending to make an intersection takeoff and failed to see the incoming aircraft in time to avoid a collision. - [NTSB ANC88LA087](https://openairdocs.org/ntsb/ANC88LA087.md): Bellanca 7GCBC · Quartz Creek, AK · Accident · No injuries · Limited investigation · Final report · Jul 10, 1988 · N88276 · Substantial damage > According to the flight instructor, he and the student pilot attended a picnic and were returning. During the departure, and while attempting a step taxi turn, they struck the trees along the shoreline. - [NTSB MKC88LA125](https://openairdocs.org/ntsb/MKC88LA125.md): Cessna 172 · Topeka, KS · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N80208 · Substantial damage > While taxiing in from a personal solo training flight, the student pilot taxied into a chain link fence while attempting to park the acft. The right wing spar sustained substantial damage. - [NTSB ANC88LA084](https://openairdocs.org/ntsb/ANC88LA084.md): Cessna 170B · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N2487D · Substantial damage > The pilot of a Cessna 170 lost directional control and ground looped while taxiing for take off. The FAA control tower had instructed the pilot to taxi behind a taxiing B-727, and issued caution: wake turbulence. The idle power of the B-727 caused the Cessna… - [NTSB ANC88LA071](https://openairdocs.org/ntsb/ANC88LA071.md): Cessna 180H · Big River, AK · Accident · No injuries · Limited investigation · Final report · Jun 26, 1988 · N9939V · Substantial damage > While taxiing on the lake the aircraft's right float struck a log causing the aircraft's left wing to strike the water. - [NTSB SEA88LA116](https://openairdocs.org/ntsb/SEA88LA116.md): Teratron Tierra 2 · Kent, WA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1988 · N488JL · Substantial damage > Plt was intentionally taxiing on grass between paved runway and taxiway for better tailwheel control. The acft struck an unseen obstruction in dusk conditions. - [NTSB CHI88LA136](https://openairdocs.org/ntsb/CHI88LA136.md): de Havilland DHC2-MK I · Warroad, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1988 · N49771 · Substantial damage > The pilot decided to land in the lake approximately 1000 yds from the sea plane base and was attempting a step-taxi back to the base when the acft struck a sand bar. The pilot stated that he was taxiing near tall grass where he thought the water was deep… - [NTSB BFO88LA056](https://openairdocs.org/ntsb/BFO88LA056.md): Piper PA-28-181 · Reedville, VA · Accident · No injuries · Limited investigation · Final report · Jun 17, 1988 · N82836 · Substantial damage > After back-taxiing on the pvt airstrip, the plt made a 180 deg turn to line up for takeoff. During the turn the right main gear contacted a ditch in a tall grass area off the end of the rwy. The plt applied power to prevent the acft from becoming stuck in the… - [NTSB DEN88LA130](https://openairdocs.org/ntsb/DEN88LA130.md): Piper J3C-65 · West Jordon, UT · Accident · No injuries · Limited investigation · Final report · Jun 15, 1988 · N70471 · Substantial damage - [NTSB FTW88DPJ06](https://openairdocs.org/ntsb/FTW88DPJ06.md): Cessna 172G · Frederick, OK · Accident · Serious injuries · Final report · Jun 9, 1988 · N1103F · Substantial damage > During slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time. - [NTSB CHI88LA131](https://openairdocs.org/ntsb/CHI88LA131.md): Piper PA-22-150 · Marion, IN · Accident · No injuries · Limited investigation · Final report · Jun 8, 1988 · N3737P · Substantial damage > The pilot became disoriented during flight and made an unscheduled stop in a corn field to ask for directions to his destination airport. During taxi for takeoff from the field, the pilot failed to maintain adequate visual lookout, and struck a manhole cover… - [NTSB CHI88FA128](https://openairdocs.org/ntsb/CHI88FA128.md): Dornier 228-201 · Chicago, IL · Accident · No injuries · Field investigation · Final report · Jun 5, 1988 · N259MC · Substantial damage > The capt was completing the checklist drg pax loading & the f/o secured the door & came fwd. The capt started the #2 eng& bgn single eng taxi while atmtg a rgt turn to stay clr of a parked Dornier (N264MC). As N259MC bgn rolling fwd, the capt noted the… - [NTSB ATL88LA188](https://openairdocs.org/ntsb/ATL88LA188.md): Mooney M-20 · Hartwell, GA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1988 · N5705Q · Substantial damage > The nose gear collapsed while taxiing at a speed of about 5 mph after landing. The annual inspection failed to disclose a material problem with the gear truss. Examination of the fractured component disclosed that the tubular material had rusted from the… - [NTSB ANC88LA091](https://openairdocs.org/ntsb/ANC88LA091.md): Grumman AA-1B · Nikolai Creek, AK · Accident · No injuries · Limited investigation · Final report · Jun 2, 1988 · N9895L · Substantial damage > A pilot reported that he was attempting to taxi off the dirt road that he had just used as a landing site in a rural area of Alaska, when the airplane's left main landing gear wheel became mired in a soft spot. The aircraft veered off the road into a ditch. - [NTSB LAX88LA188](https://openairdocs.org/ntsb/LAX88LA188.md): Cessna 180 · S. Lake Tahoe, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1988 · N2969A · Substantial damage > The pilot lost control and dragged a wing while taxiing. The pilot indicated that he had just completed an uneventful landing and was taxiing to parking. He also indicated that he was taxiing too fast when he turned off the runway and the wing dipped and… - [NTSB SEA88LA125](https://openairdocs.org/ntsb/SEA88LA125.md): Cessna 177B · Ocean Shores, WA · Accident · No injuries · Limited investigation · Final report · May 14, 1988 · N35177 · Substantial damage > During taxi for takeoff, plt misjudged clrnc between wingtip and mowing machine. - [NTSB LAX88LA186](https://openairdocs.org/ntsb/LAX88LA186.md): Piper PA-34-200T · Merced, CA · Accident · No injuries · Limited investigation · Final report · May 14, 1988 · N66SL · Substantial damage > While taxiing on a dirt road, the right wing struck a tree resulting in substantial damage. There were no mechanical failures or malfunctions reported at the time of the accident. Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=41 ## 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=40 --- 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.