# NTSB investigations: Takeoff 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 133 of 281 · 14,038 cases ## Cases, newest first - [NTSB LAX89DVA02](https://openairdocs.org/ntsb/LAX89DVA02.md): WSK PZL Mielec PZL-M-18 · Mendota, CA · Accident · No injuries · Final report · Oct 21, 1988 · N4206A · Substantial damage > On takeoff for an aerial application flight, the aircraft failed to clear an agricultural berm 300 ft beyond the end of the runway and nosed over. The pilot stated that the aircraft was loaded with 500 gallons of sodium chlorate and that he should have… - [NTSB CHI89LA014](https://openairdocs.org/ntsb/CHI89LA014.md): Piper PA-24-250 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Oct 21, 1988 · N7733P · Substantial damage > Shortly after liftoff and landing gear retraction, the pilot inadvertently allowed the aircraft to touch down on the runway. The pilot stated that his attention was distracted by conversation with one of the passengers and he failed to maintain a positive… - [NTSB DEN89LA016](https://openairdocs.org/ntsb/DEN89LA016.md): Cessna 172P · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Oct 17, 1988 · N53949 · Substantial damage > The pilot was practicing touch-and-go landings in a 15 kt crosswind condition in an acft in which he had 8 hrs experience. During takeoff roll after the sixth landing the plt lost control and the acft departed the side of the rnwy. - [NTSB CHI89LA007](https://openairdocs.org/ntsb/CHI89LA007.md): Cessna 172 · Carbondale, IL · Accident · No injuries · Limited investigation · Final report · Oct 9, 1988 · N98395 · Substantial damage > The student pilot, while on the takeoff roll on his first solo flight, experienced a loss of directional control which he failed to correct. The aircraft swerved to the left and departed the runway, striking a VASI installation before coming to a stop. The… - [NTSB NYC89IA005](https://openairdocs.org/ntsb/NYC89IA005.md): Boeing 727-100 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Oct 7, 1988 · N118FE · Minor damage > The #3 eng suffered an uncontained turbine blade failure during a takeoff roll. The takeoff was aborted at 120 KTS without further incident. Investigation revealed that all 12 tierods for the 2nd stage low compressor suffered a progessive failure. This… - [NTSB SEA88LA191](https://openairdocs.org/ntsb/SEA88LA191.md): Piper PA-28 · Troutdale, OR · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 1988 · N9550W · Substantial damage > The plt rprtd that soon after takeoff, he realized there was insufficient power. Subsequently, the acft mushed into trees & a raspberry field & was damaged. An exam of the eng revealed a piece of the carburetor heat muff had broken off & was ingested into the… - [NTSB BFO88FA085](https://openairdocs.org/ntsb/BFO88FA085.md): Maule M-5-210C · Clarksville, VA · Accident · 1 fatal · Field investigation · Final report · Sep 29, 1988 · N325X · Destroyed > Inflight loss of control as a result of pilot disorientation when the pilot tried to conduct VFR flight into IMC. Low clouds, poor visibility, fog and poor decision are contributing factors. - [NTSB BFO88LA086](https://openairdocs.org/ntsb/BFO88LA086.md): Cessna 172M · Keysville, VA · Accident · No injuries · Limited investigation · Final report · Sep 28, 1988 · N85012 · Substantial damage > Aircraft overran the runway after the pilot aborted the takeoff because the aircraft did not accelerate to takeoff speed. A contributing cause is inadequate prelight planning. A contributing factor is upsloping high grass covered terrain and failure to use… - [NTSB NYC88LA242](https://openairdocs.org/ntsb/NYC88LA242.md): Gulfstream American AA-5B · Roscoe, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1988 · N4518N · Destroyed > The plt said the eng lost power during takeoff past mid-field and he initiated an abort. The acft was unable to stop in the remaining rwy and collided with a dirt embankment past the end of the rwy. The owner of the acft is a student plt and was the passenger… - [NTSB ANC88LA147](https://openairdocs.org/ntsb/ANC88LA147.md): De Havilland DHC-2 · Zacher Bay, AK · Accident · No injuries · Limited investigation · Final report · Sep 24, 1988 · N53546 · Substantial damage > The pilot stated that during the takeoff run on the water, he lost directional control of the airplane, due to the high wind condition. The airplane's wing tip struck the water causing the airplane to nose over on its back. - [NTSB MIA88LA272](https://openairdocs.org/ntsb/MIA88LA272.md): Cessna 172F · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · Sep 23, 1988 · N8707U · Substantial damage > The plt aborted the takeoff from the 'thick, wet' grass strip because the acft was not accelerating 'adequately.' He applied the brakes but it went off the departure end of the rwy, collided with a fence, tree, and dirt mound before coming to rest. There was… - [NTSB DEN88LA208](https://openairdocs.org/ntsb/DEN88LA208.md): Cessna 421B · Winner, SD · Accident · No injuries · Limited investigation · Final report · Sep 20, 1988 · N44HV · Substantial damage > The private plt and 4 pax were attempting takeoff on rwy 13, a 3,900 x 30 ft asphalt rwy. The plt said the acft accelerated to 100 knots but he could not raise the nose for lift off. The plt said he aborted the takeoff and intentionally ground looped to the… - [NTSB LAX88DUG07](https://openairdocs.org/ntsb/LAX88DUG07.md): Bell 47G-5A · Perris, CA · Accident · No injuries · Final report · Sep 18, 1988 · N4099G · Substantial damage > On liftoff, tail rotor control was lost and helicopter spun with main rotor striking terrain. Investigation revealed fatigue failure of engine mounting cage. The eng basket had failed and allowed the t/r drive shaft to pull out of the coupling. The basket had… - [NTSB CHI88LA239](https://openairdocs.org/ntsb/CHI88LA239.md): Enstrom F28A · Celina, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 1988 · N249Q · Destroyed > After 2 unsuccessful attempts to takeoff, the plt/owner tried a 3rd takeoff in his newly purchased helicopter. He rprtd that during the first 2 attempts to takeoff, he couldn't seem to get 100% of his left pedal authority. Shortly after the helicopter became… - [NTSB LAX88LA320](https://openairdocs.org/ntsb/LAX88LA320.md): Cessna 172N · Truckee, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1988 · N6406D · Substantial damage > During takeoff roll the pilot heard a banging noise on the left wing. The pilot continued the takeoff. At 100 ft a.g.l. he executed a 180 degree turn to the right to return to land. The pilot added 30 degrees of flaps to the 10 that had been set for takeoff.… - [NTSB MKC88FA173](https://openairdocs.org/ntsb/MKC88FA173.md): Aero Commander 500B · Hays, KS · Accident · Minor injuries · Field investigation · Final report · Sep 16, 1988 · N1189Z · Substantial damage > Operation attempted with known deficiencies in equipment, and failure of the pilot to maintain directional control. A contributing factor was: the pilot's use of an improper starting procedure & the fence. - [NTSB ANC88LA141](https://openairdocs.org/ntsb/ANC88LA141.md): Cessna 185 · Mcclaren River, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 1988 · N73DA · Substantial damage > According to the pilot, the landing gear struck either a depression or an object on the riverbed/runway during takeoff roll and veered left. He corrected the deviation and continued taking off. However, when the airplane reached the end of the airstrip, he… - [NTSB ANC88LA140](https://openairdocs.org/ntsb/ANC88LA140.md): Cessna 170B · Hope, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 1988 · N170LA · Substantial damage > The arpt was located in an area between 2 mtns. It had two windsocks; one was at rwy level; the other was above the treetop level. The plt rprtd that the lower windsock showed the wind was favoring rwy 16, but was shifting about 45 deg to either side of the… - [NTSB ANC88LA139](https://openairdocs.org/ntsb/ANC88LA139.md): Cessna 180B · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 11, 1988 · N3539E · Substantial damage > The plt rprtd that drg an aborted takeoff, the acft overran the departure end of the rwy & the left main gear failed. He said he misjudged the performance of the acft, & when he aborted, there was insufficient rwy remaining to stop. Also, he believed the hi… - [NTSB MKC88LA170](https://openairdocs.org/ntsb/MKC88LA170.md): Cessna 172 · Warrensburg, MO · Accident · No injuries · Limited investigation · Final report · Sep 10, 1988 · N1462F · Substantial damage > While practicing stop and go ldgs, the student lost directional control. The takeoff was attempted with a left crosswind. The acft veered to the left, off the runway, and hit an embankment. The nose and left main gears, the propeller, and fuselage were… - [NTSB ANC88LA136](https://openairdocs.org/ntsb/ANC88LA136.md): Cessna 207 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Sep 10, 1988 · N6470H · Substantial damage > The pilot was an aircraft mechanic for the operator of the airplane, and was enroute to another airport to repair a company airplane. The pilot stated that he did not do a complete job of preflighting the airplane, and attempted to takeoff with the control… - [NTSB ANC88LA131](https://openairdocs.org/ntsb/ANC88LA131.md): Piper PA-18 · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1988 · N1759P · Substantial damage > The commercial pilot attempted to takeoff from a rough and soft off-airport site in rural Alaska. During the takeoff roll, the airplane's main landing gear encountered an exceptionally soft spot, causing the airplane to nose over. The pilot stated that the… - [NTSB ANC88LA130](https://openairdocs.org/ntsb/ANC88LA130.md): Cessna 182TD · September Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 6, 1988 · N5369B · Substantial damage > The 202 hour private pilot was attempting to takeoff in a Cessna 182 converted to a conventional configuration (taildragger) from an off-airport site in rural Alaska. The pilot reported that a strong, gusty crosswind pushed the airplane off the intended track… - [NTSB ANC88LA129](https://openairdocs.org/ntsb/ANC88LA129.md): Piper PA-18 · Oshetna River, AK · Accident · No injuries · Limited investigation · Final report · Sep 6, 1988 · N234E · Substantial damage > The pilot reported that he was attempting to takeoff from an extremely narrow and short stretch of land situated near a River. He had used this off-airport, unimproved site for several years without difficulty until the accident flight. On this occasion, the… - [NTSB ANC88LA127](https://openairdocs.org/ntsb/ANC88LA127.md): Maule M-4 · Eureka Creek, AK · Accident · No injuries · Limited investigation · Final report · Sep 6, 1988 · N12020 · Substantial damage > During the takeoff roll on an upsloping gravel airstrip, the pilot lost control of the airplane. The airplane nosed over on its back. The pilot and both passengers exited the airplane without injuries. - [NTSB SEA88LA170](https://openairdocs.org/ntsb/SEA88LA170.md): Grumman AA-5 · Toledo, WA · Accident · No injuries · Limited investigation · Final report · Sep 5, 1988 · N9559L · Substantial damage > The pilot aborted the first takeoff due to the engine not developing full power. After another run up, the pilot elected to make another takeoff. The pilot aborted midfield, by retarding the power and applying heavy braking, due to the aircraft not developing… - [NTSB LAX88FA307](https://openairdocs.org/ntsb/LAX88FA307.md): Cessna 172 · Grand Canyon, AZ · Accident · 4 fatal · Field investigation · Final report · Sep 4, 1988 · N54814 · Destroyed > The pilot failed to maintain control of the aircraft during nigh visual meteorological conditions. Contributing to this accident was the pilot's lack of recent experience at nigh and the lack of outside visual references due to darkness. - [NTSB ANC88LA122](https://openairdocs.org/ntsb/ANC88LA122.md): Helio H-295 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1988 · N456JH · Substantial damage > During the takeoff roll on the runway at approximately 20 to 25 mph the pilot lost directional control of the airplane. The airplane looped to the right. - [NTSB MIA88LA264](https://openairdocs.org/ntsb/MIA88LA264.md): Piper PA-28 · Orlando, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 3, 1988 · N36190 · Substantial damage > The plt had rented the fully fueled aircraft from an FBO at orl which has hard surfaced 4600 & 6000 ft rwys. He flew to a 130 ft MSL arpt with a 2430 ft grass rwy & picked up his wife for a xc flt. He stated that the acft performed normally during the 10 min… - [NTSB NYC88LA232](https://openairdocs.org/ntsb/NYC88LA232.md): Cessna 152 · Windham, CT · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1988 · N94502 · Substantial damage > The student pilot said she heard a popping sound during the takeoff roll and almost instantaneously the door came open. She tried to close the door and when that failed she attempted to abort. She retarded the throttle and attempted braking but it was not… - [NTSB FTW88LA158](https://openairdocs.org/ntsb/FTW88LA158.md): Bell 206B · West Cameron 28 · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1988 · N5747Z · Destroyed > The pilot landed the heicopter on a drilling platform and instructed the mechanic to install only the forward tie-downs. The mechanic secured the forward and aft tie-downs and secured the forward rotor blades. When the pilot returned to the helicopter, he… - [NTSB DEN88LA196](https://openairdocs.org/ntsb/DEN88LA196.md): Cessna 182RG · Antelope Wells, NM · Accident · No injuries · Limited investigation · Final report · Sep 1, 1988 · N3184C · Substantial damage > The commercial plt was flying three passengers to buy cattle. During takeoff from a 5,000 x 75 ft, wet gravel airstrip, the plt elected to use only the left side of the rwy to avoid mud. He used a soft field takeoff, with a nose high attitude, which limited… - [NTSB ANC88LA121](https://openairdocs.org/ntsb/ANC88LA121.md): Maule M-5-210C · Kukaklek, AK · Accident · No injuries · Limited investigation · Final report · Aug 31, 1988 · N307X · Substantial damage > During the takeoff roll on the gravel bar the airplane crossed the gravel area on to the soft tundra. The pilot then lost directional control of the airplane. The airplane nosed over on its back. - [NTSB CHI88LA227](https://openairdocs.org/ntsb/CHI88LA227.md): Cessna 172G · Sparta, MI · Accident · No injuries · Limited investigation · Final report · Aug 30, 1988 · N6049R · Substantial damage > During a takeoff attempt from his private strip the pilot elected to abort the takeoff. There was a slight quartering tailwind for the takeoff attempt. Due to the 'dense', damp grass, which was about 4 inches tall according to the pilot, braking effectiveness… - [NTSB MKC88LA165](https://openairdocs.org/ntsb/MKC88LA165.md): Cessna 182Q · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · Aug 29, 1988 · N97076 · Substantial damage > The plt said that during a night takeoff roll, he noticed an inoperative airspeed indicator, and elected to abort the takeoff. Unable to stop in the remaining distance, the acft ran off the end of the runway onto the grass overrun collapsing the nose wheel.… - [NTSB ANC88LA116](https://openairdocs.org/ntsb/ANC88LA116.md): Artic S-1B2 · Hartman River, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1988 · N55AD · Substantial damage > The pilot had just taken off from a sand bar. During climb-out on the downwind leg, he felt the engine was not producing the proper power because the airspeed was dropping and the climb had stopped. He made a left turn and crash landed on the sand bar to… - [NTSB MIA88LA258](https://openairdocs.org/ntsb/MIA88LA258.md): Air Tractor AT-301A · Shelby, MS · Accident · No injuries · Limited investigation · Final report · Aug 19, 1988 · N73089 · Substantial damage > While on an aerial application flt during the ground roll to takeoff, the forwardmost of two main gear clamp block bolts of the rt main landing gear failed. The gear trailed aft. The inboard main gear large bolt failed. The acft travelled off the rwy into a… - [NTSB ANC88LA114](https://openairdocs.org/ntsb/ANC88LA114.md): Piper PA-18-150 · Yenta Glacier, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1988 · N2460A · Substantial damage > During the takeoff roll on the gravel bar, the pilot lost directional control of the airplane causing the plane to nose over on its back. Examination of the left brake revealed that the brake was frozen with mud. - [NTSB CHI88FA205](https://openairdocs.org/ntsb/CHI88FA205.md): Fairchild SA-226-TC · Cleveland, OH · Accident · Minor injuries · Field investigation · Final report · Aug 16, 1988 · N322BA · Substantial damage > The captain's late decision to abort after a propeller linkage failure on the right engine and the co-pilot's failure to relinquish engine and braking authority to the captain resulting in confusion and inadequate braking to stop on the runway after the abort. - [NTSB ANC88LA110](https://openairdocs.org/ntsb/ANC88LA110.md): Piper PA-18-150 · Tok, AK · Accident · No injuries · Limited investigation · Final report · Aug 15, 1988 · N6893B · Substantial damage > During the takeoff roll on a gravel bar, the pilot lost directional control of the airplane & it bounced into the river. The airplane then nosed over on its back. The pilot and passenger both exited the airplane. - [NTSB NYC88LA217](https://openairdocs.org/ntsb/NYC88LA217.md): Piper PA-32RT-300 · Wellsboro, PA · Accident · 1 fatal · Limited investigation · Final report · Aug 14, 1988 · N979LA · Substantial damage > The pilot attempting a takeoff in an over grossed aiarcraft in high density altitude and flew off the end of the runway into high grass. - [NTSB LAX88LA286](https://openairdocs.org/ntsb/LAX88LA286.md): Piper PA-18-135 · Parker, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 1988 · N9965Q · Substantial damage > The pilot reported that just after tkof from a river the eng was not developing sufficient power to maintain altitude. The pilot made a landing and during the landing roll collided with rough terrain. After the accident, the engine was test run and found to… - [NTSB MKC88LA157](https://openairdocs.org/ntsb/MKC88LA157.md): Ercoupe 415-C · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Aug 13, 1988 · N93437 · Substantial damage > While attempting to depart a 1600 ft sod runway, the PIC said he was unable to get airborne and elected to abort the takeoff. Unable to stop, he went through a fence, substantially damaging both wings. The plt recommended not trying to takeoff from a short… - [NTSB ATL88DKG16](https://openairdocs.org/ntsb/ATL88DKG16.md): Cessna 188 · Hazel Green, AL · Accident · No injuries · Final report · Aug 13, 1988 · N42404 · Substantial damage > The plt rprtd he had flown off the strip all day & the temp had risen to 101 deg. As he was on his last takeoff, he realized the chemical load was too great for the conditions. He said he dumped part of the load, but the acft settled back to the ground.… - [NTSB MKC88LA155](https://openairdocs.org/ntsb/MKC88LA155.md): Cessna 188B · Sumner, IA · Accident · No injuries · Limited investigation · Final report · Aug 11, 1988 · N4999R · Substantial damage > During takeoff for an aerial application operation, the pilot said he was not able to climb high enough to clear a 4 foot high road at the end of the runway. He collided with the road, shearing off the main ldg gear and substantially damaging the acft. He… - [NTSB NYC88LA213](https://openairdocs.org/ntsb/NYC88LA213.md): Luscombe 8A · Plymouth, MA · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1988 · N2232K · Substantial damage > The acft was taking off on a hard packed, grassy area beside a paved rwy with a 12 kt headwind. After the tail was raised, and at a point 900 ft from the beginning of the roll, the acft suddenly nosed over. Examination of the broken right main landing gear… - [NTSB MKC88FA154](https://openairdocs.org/ntsb/MKC88FA154.md): Boeing 737-222 · Little Rock, AR · Accident · Serious injuries · Field investigation · Final report · Aug 10, 1988 · N9060U · No damage > The sked air carrier flt was aborted after the capt heard a noise and felt a vibration emanating from the left side of the acft, which at the time, was perceived as a 'blown' tire. The acft was subsequently stopped on the active rwy, and an order fm the… - [NTSB CHI88LA195](https://openairdocs.org/ntsb/CHI88LA195.md): Cessna 150 · Napoleon, OH · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N9211U · Substantial damage > The airplane left the runway and struck a ditch during an attempted soft field takeoff. The student pilot lost directional control of the acft and, after striking a runway light on the left side of the runway, continued until he collided with the ditch and… - [NTSB NYC88LA207](https://openairdocs.org/ntsb/NYC88LA207.md): Bellanca 8KCAB · Quaker Street, NY · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 1988 · N2502Z · Substantial damage > The Bellanca 8KCAB was making a takeoff when it veered to the right. The right main landing gear contacted a rock wall covered by weeds and the aircraft veered further right coming to rest on the right side of the runway. The pilot was unable to explain the… - [NTSB ANC88LA105](https://openairdocs.org/ntsb/ANC88LA105.md): Cessna 172 · Chignik, AK · Accident · No injuries · Limited investigation · Final report · Aug 6, 1988 · N2723V · Substantial damage > During the takeoff roll on the beach the pilot lost directional control of the aircraft. The aircraft nosed over on its back. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=134 ## 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 = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=133 --- 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.