# 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 139 of 281 · 14,041 cases ## Cases, newest first - [NTSB MKC87LA071](https://openairdocs.org/ntsb/MKC87LA071.md): Cessna 140 · Creve Coeur, MO · Accident · No injuries · Limited investigation · Final report · Apr 1, 1987 · N89316 · Substantial damage > The PIC was practicing landings in gusty crosswind conditions. PIC landed long, and after rolling a short distance, perceived that the wind direction had changed. The PIC stated that this new wind direction was now more of a tailwind. The PIC did not select a… - [NTSB DEN87LA077](https://openairdocs.org/ntsb/DEN87LA077.md): Pitts Special S2C · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Mar 30, 1987 · N58DC · Substantial damage > The acft swerved during takeoff and the swerve severity increased during acceleration. The plt lifted off before reaching proper speed to sustain flt. The acft stall mushed into the ground to the left of the rwy, bounced into the air and stalled again. The… - [NTSB ATL87LA099](https://openairdocs.org/ntsb/ATL87LA099.md): Grumman G-164 · Shelbyville, TN · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N654Y · Destroyed > The acft was being operated from a dirt road that was reportedly only slightly wider than the acft. The plt reported that he had just completed a spraying operation and was about to put out some fertilizer. He stated that he installed the spreader, but left… - [NTSB FTW87FA080](https://openairdocs.org/ntsb/FTW87FA080.md): Convair CV-580 · Dallas, TX · Accident · No injuries · Field investigation · Final report · Mar 25, 1987 · N73107 · Substantial damage > Metro flight airlines Convair CV-580 attempted takeoff from runway 35L at the Dallas/fort worth airport (dfw) with crosswinds exceeding demonstrated capability of the aircraft. The takeoff attempt violated company limitations for crosswinds in the Convair… - [NTSB DEN87LA071](https://openairdocs.org/ntsb/DEN87LA071.md): Cessna 172H · Larimore, ND · Accident · No injuries · Limited investigation · Final report · Mar 23, 1987 · N1725F · Substantial damage > The plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over. - [NTSB FTW87DPJ06](https://openairdocs.org/ntsb/FTW87DPJ06.md): Air Tractor AT301 · El Dorado, OK · Accident · No injuries · Final report · Mar 22, 1987 · N3655G · Substantial damage > The pilot stated that during takeoff from a county road, black smoke started coming out of the engine exhaust. The aircraft then collided with a tree and a post causing substantial damage. It was found that the carburetor heat system had been modified and the… - [NTSB SEA87LA067](https://openairdocs.org/ntsb/SEA87LA067.md): Grumman G164B · Reubens, ID · Accident · No injuries · Limited investigation · Final report · Mar 20, 1987 · N6798Q · Substantial damage > During takeoff run the aircraft veered to the right of the runway, struck a ditch, and then nosed over inverted. The pilot found that the right dowel pin on the right main gear had broken. The reason for the failure could not be determined. - [NTSB ANC87LA054](https://openairdocs.org/ntsb/ANC87LA054.md): Cessna 170B · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Mar 19, 1987 · N3439D · Substantial damage > As the plt was taking off from a frozen lake with a ski equipped acft, it collided with a snowbank & was damaged. The plt rprtd that he had just landed a few minutes earlier & that the wind was blowing differently when he took off again. After the acdnt,… - [NTSB ANC87LA053](https://openairdocs.org/ntsb/ANC87LA053.md): Cessna 185F · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Mar 15, 1987 · N9618H · Substantial damage > While taxiing on skis at excess speed, the pilot lost control of the airplane in a crosswind. The landing gear box failed causing substantial damage to the airframe and propeller. - [NTSB ANC87LA050](https://openairdocs.org/ntsb/ANC87LA050.md): Piper PA-18 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Mar 12, 1987 · N135RB · Substantial damage > The student pilot elected to make an off airport landing in his ski-equipped Piper PA18 airplane. He landed the acft successfully, but the right ski attachment and left gear leg collapsed on take off from the uneven terrain. The acft was substantially… - [NTSB NYC87IA105](https://openairdocs.org/ntsb/NYC87IA105.md): McDonnell Douglas MD-80 · Baltimore, MD · Incident · No injuries · Incident investigation · Final report · Mar 8, 1987 · N236AA · No damage > Main landing gear upper torque link attach bolt separated during takeoff as a result of preexisting stress corrosion cracking. McDonnell-douglas issued alert MD-80 service bulletin A32-220 following the incident. - [NTSB CHI87DEE05](https://openairdocs.org/ntsb/CHI87DEE05.md): Resney Commander 447 · Lansing, IL · Accident · Serious injuries · Final report · Mar 8, 1987 · N447MR · Substantial damage > The acft made a forced landing in a field due to fuel starvation. The acc plt offered to fly the acft out. He had 30 min of dual flt in this type acft. He sat on the left side of the acft for the flt which resulted in an unbalanced condition. The acft entered… - [NTSB ANC87LA046](https://openairdocs.org/ntsb/ANC87LA046.md): Cessna 170B · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Mar 8, 1987 · N4570C · Substantial damage > The plt lost control of the acft after the tail was raised during takeoff. The acft groundlooped and collided with a snow bank which damaged the rt wing, landing gear and elevator. - [NTSB DEN87LA060](https://openairdocs.org/ntsb/DEN87LA060.md): Gates Learjet 35A · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Feb 26, 1987 · N888DJ · Substantial damage > The rwy was plowed aprx 15 minutes prior to this takeoff. One-half inch of snow still remained along the rwy centerline with up to 3 1/2 inches along the edge of the rwy. The acft veered to the left side of the rwy during the takeoff run and continued aprx 80… - [NTSB LAX87LA122](https://openairdocs.org/ntsb/LAX87LA122.md): Boeing PT-13D · Vacaville, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 1987 · N620BD · 2 aircraft · Substantial damage > The aircraft were in the holding area short of runway 19 at the uncontrolled nut tree airport. The Cessna pilot taxied into position behind landing traffic and allowed his aircraft to roll slowly forward while waiting for the landing aircraft to clear the… - [NTSB FTW87LA068](https://openairdocs.org/ntsb/FTW87LA068.md): Bell 206B · New Braunfels, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 1987 · N1082Z · Substantial damage > Acft had been parked in an open field and when the plt returned he noticed that the left skid had sunk into the mud. After eng start and run up, the plt attempted to takeoff with right cyclic applied to un-stick the left skid. The acft lifted off with a right… - [NTSB MIA87FA091](https://openairdocs.org/ntsb/MIA87FA091.md): Beech A36TC · Orlando, FL · Accident · Serious injuries · Field investigation · Final report · Feb 21, 1987 · N47EE · Substantial damage > Drg the takeoff roll, lgt colored smoke was seen trailing the the acft. The plt rprtd that at 100 to 200 ft AGL, the englost partial pwr. He said he checked all ctls & raised the lndg gear. Witnesses rprtd that at about that time, heavy smoke bgn trailing the… - [NTSB SEA87LA058](https://openairdocs.org/ntsb/SEA87LA058.md): Cessna 188 · Genesee, ID · Accident · No injuries · Limited investigation · Final report · Feb 19, 1987 · N531SF · Substantial damage > After operation in light winds, plt attempted takeoff in calm wind conditions. Gravel runway was soft from overnight rains. Acft became airborne briefly in ground effect near end of runway, settled back into muddy terrain and nosed over inverted. - [NTSB NYC87LA088](https://openairdocs.org/ntsb/NYC87LA088.md): Cessna 180H · New Paltz, NY · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1987 · N9708G · Substantial damage > The Cessna 180/H was departing the runway at night with two passengers on board. The pilot lost control of the aircraft as the tail came up and veered left into a snow bank. After striking the left snow bank, the aircraft veered right and struck the right… - [NTSB ANC87LA039](https://openairdocs.org/ntsb/ANC87LA039.md): Piper PA-34 · Tyonek, AK · Accident · No injuries · Limited investigation · Final report · Feb 14, 1987 · N6970J · Substantial damage > The on-demand air taxi flight struck a moose during the takeoff roll at a private rural airstrip. The two pilot crew and one passenger were uninjured. The leading edge of the aircraft's left wing was substantially damaged; but the pilot-in-command elected to… - [NTSB SEA87LA057](https://openairdocs.org/ntsb/SEA87LA057.md): Cessna 140 · Nyssa, OR · Accident · No injuries · Limited investigation · Final report · Feb 12, 1987 · N72166 · Substantial damage > During takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted. - [NTSB BFO87DIG01](https://openairdocs.org/ntsb/BFO87DIG01.md): Cessna 152C · Gaithersburg, MD · Accident · No injuries · Final report · Feb 10, 1987 · N25846 · Substantial damage > While taking off on rwy 32, the acft veered to the left & collided with a snowbank before the student plt could regain control. The student rprtd the winds were from 280 deg at 10 KTS. - [NTSB FTW87FA061](https://openairdocs.org/ntsb/FTW87FA061.md): Piper PA-42 · Horseshoe Bay, TX · Accident · Serious injuries · Field investigation · Final report · Feb 7, 1987 · N81SM · Destroyed > The pilot made a fairly long taxi from the ramp to the end of the runway and then started his takeoff roll with the parking brake still partially set. The brakes became very hot and the component parts expanded. After rolling almost 3,000 feet the brakes… - [NTSB CHI87LA076](https://openairdocs.org/ntsb/CHI87LA076.md): Cessna 152 · Little Falls, MN · Accident · No injuries · Limited investigation · Final report · Feb 6, 1987 · N757SX · Substantial damage > During takeoff roll at about 50-55 KTS plt lost directional control. As the acft started going to the left, the plt applied the brakes. When the acft departed rwy 30, the nose wheel collapsed. - [NTSB NYC87LA070](https://openairdocs.org/ntsb/NYC87LA070.md): Cessna 172N · Duanesburg, NY · Accident · No injuries · Limited investigation · Final report · Feb 4, 1987 · N9193G · Substantial damage > On lndg the acft ran into a snowbank causing minor dmg to the acft. Aft determining it airworthy the plt elected to depart and ran into another snowbank on the takeoff. He stated that the accd occurred because of poor judgement to attempt a takeoff from an… - [NTSB LAX87LA108](https://openairdocs.org/ntsb/LAX87LA108.md): Cessna 172N · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Feb 4, 1987 · N64484 · Substantial damage > A Cessna 172M veered left during takeoff ground run on rwy 8 and nosed down on the rwy. The plt indicated that he encountered a left 90 degree x-wind gusting up to 20 KTS. The acft began to veer uncontrolled into the wind. He elected to abort the takeoff at… - [NTSB CHI87LA077](https://openairdocs.org/ntsb/CHI87LA077.md): Lake LA-4-200 · Bridgman, MI · Accident · No injuries · Limited investigation · Final report · Feb 4, 1987 · N6686L · Substantial damage > Plt was attempting to takeoff from a soft field. The gear caught a rise in the field and acft settled back to the soft ground tearing off the nose wheel and damaging both wings. - [NTSB FTW87LA048](https://openairdocs.org/ntsb/FTW87LA048.md): Piper PA-38-112 · Alpine, TX · Accident · No injuries · Limited investigation · Final report · Jan 24, 1987 · N2592C · Substantial damage > Student pilot on solo flight attempted takeoff in strong gusty winds and dragged left wing tip on runway. Pilot leveled wings and attempted to land aircraft but departed left side of runway and collided with ditch. - [NTSB CHI87LA064](https://openairdocs.org/ntsb/CHI87LA064.md): Piper PA-38-112 · Decatur, IL · Accident · No injuries · Limited investigation · Final report · Jan 23, 1987 · N2536A · Substantial damage > Following taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was… - [NTSB CHI87DEX05](https://openairdocs.org/ntsb/CHI87DEX05.md): Cessna 340A · Bloomington, IN · Accident · No injuries · Final report · Jan 22, 1987 · N3961G · Substantial damage > The plt rprtd that drg preflt, there was snow on the acft which would move with hand brushing, so he elected not to remove it. Drg departure, as he rotated the acft to lift-off, he noted the acft did not feel right. He intentionally aborted the takeoff, but… - [NTSB ATL87LA063](https://openairdocs.org/ntsb/ATL87LA063.md): Piper PA-23-250 · Wilkesboro, NC · Accident · No injuries · Limited investigation · Final report · Jan 22, 1987 · N2489R · Substantial damage > During a takeoff attempt, the right seat pilot did not get an airspeed indication. However, the left airspeed indicated 45 mph when the pilot aborted the takeoff. The aircraft veered off the right side of the runway 1700 feet from the initial takeoff roll.… - [NTSB LAX87LA090](https://openairdocs.org/ntsb/LAX87LA090.md): Cessna 170B · Yucca Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 1987 · N2293D · Destroyed > The pilot reported that during the takeoff roll, a wind gust caused the left wing to raise and the airplane veered to the right. He immediately applied left aileron and rudder, but to no avail. The airplane went off the runway, hit a tree and fence, and… - [NTSB LAX87LA080](https://openairdocs.org/ntsb/LAX87LA080.md): Cessna 152 · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 10, 1987 · N46354 · Substantial damage > The student pilot stated that he had just finished practicing 4 touch-and-go with his flight instructor. The flight instructor then exited the aircraft and instructed the student to practice 5 solo touch-and-go. On the take-off run just prior to rotation, the… - [NTSB LAX87LA078](https://openairdocs.org/ntsb/LAX87LA078.md): Champion 7EC · Oakland, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 9, 1987 · N7515E · Substantial damage > A Champion 7EC went out of control during the takeoff initial climb. The aircraft dragged a wing during takeoff ground run. The pilot was observed looking back towards the runway during the initial climb. The aircraft stalled and descended uncontrolled to the… - [NTSB DEN87FA036](https://openairdocs.org/ntsb/DEN87FA036.md): Piper PA-28-140 · Rawlins, WY · Accident · 2 fatal · Field investigation · Final report · Dec 29, 1986 · N4388X · Destroyed > The plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway. - [NTSB NYC87DNC04](https://openairdocs.org/ntsb/NYC87DNC04.md): Taylorcraft BC12D · West Farmington, ME · Accident · Serious injuries · Final report · Dec 27, 1986 · N95575 · Substantial damage > The aircraft climbed in a steep attitude after takeoff to an alt of aprx 100 ft AGL. The acft then stalled and impacted the terrain in a left wing low attitude. - [NTSB MIA87LA052](https://openairdocs.org/ntsb/MIA87LA052.md): Piper PA-32R-300 · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Dec 18, 1986 · N2279Q · Substantial damage > The plt stated that the acft tilted shortly after liftoff and he elected to abort the takeoff. While on roll out, when the brakes were applied, the acft veered to the left and ran off the rwy colliding with a fence. The plt reported no mechanical difficulties… - [NTSB DEN87LA030](https://openairdocs.org/ntsb/DEN87LA030.md): Piper PA-12 · Opheim, MT · Accident · No injuries · Limited investigation · Final report · Dec 15, 1986 · N78588 · Substantial damage > The plt elected to take off downhill because he said the hill was too steep to try a takeoff uphill even into the wind. He said that just prior to lift off, he hit a snowbank which slowed the acft down. Deeper snow was then contacted and the acft flipped over. - [NTSB ATL87FA039](https://openairdocs.org/ntsb/ATL87FA039.md): Cessna 170B · Madison, GA · Accident · 1 fatal · Field investigation · Final report · Dec 9, 1986 · N2464D · Substantial damage > Although there were no witnesses to the crash, one witness did observe the acft taxiing at a very slow speed toward the dept end of the rwy. Abt 30 mins later the wreckage was fd in a fld east of the airstrip. Exam indicated it collided w the gd in a near… - [NTSB ATL87LA037](https://openairdocs.org/ntsb/ATL87LA037.md): Cessna 150L · Cullowhee, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 7, 1986 · N6860G · Destroyed > After not flying for about 7 yrs, the plt obtained flt instruction in preparation for a biennial flt review. His 1st flt was completed 4 days prior to the acdnt. The acdnt flt was to be devoted primarily to takeoffs & landings. The student plt was rprtd to… - [NTSB NYC87LA047](https://openairdocs.org/ntsb/NYC87LA047.md): Piper J-3 · East Moriches, NY · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N26057 · Substantial damage > During the takeoff roll on an instructional solo flight, the flight encountered a crosswind which pushed the Piper off the runway to the left colliding with trees and bush. - [NTSB MIA87FA040](https://openairdocs.org/ntsb/MIA87FA040.md): de Havilland DHC-6 · San Juan, PR · Accident · No injuries · Field investigation · Final report · Nov 29, 1986 · N930MA · Substantial damage > The plt stated that on takeoff roll as the nose wheel was lifted at aprx 60 knots, the acft veered sharply to the left, ran off the runway and collided with the glide slope building. The left eng and propeller were examined and both components were found to… - [NTSB LAX87LA054](https://openairdocs.org/ntsb/LAX87LA054.md): North American-Maslon SNJ-4 · El Cajon, CA · Accident · No injuries · Limited investigation · Final report · Nov 28, 1986 · N269WB · Substantial damage > A North American SNJ-4 ground looped after a loss of control during takeoff roll on runway 27R. The aircraft swerved to the left twice and then lifted off the ground with a high angle of attack and low airspeed. The aircraft then 'mushed along' at… - [NTSB DEN87LA022](https://openairdocs.org/ntsb/DEN87LA022.md): Cessna 150 · St. George, UT · Accident · No injuries · Limited investigation · Final report · Nov 26, 1986 · N19224 · Substantial damage > During a touch and go landing, the acft's left landing gear tangled in loose wire. The acft swerved to the the left, struck a used tire barrier then nosed over. The landing was made on a closed rwy. - [NTSB BFO87LA013](https://openairdocs.org/ntsb/BFO87LA013.md): Cessna 152 · Manassas, VA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1986 · N4599L · Substantial damage > According to the student plt, during the apch for the touch-and-go landing, he applied left rudder pressure to line up the acft with the rwy centerline. After touchdown he did not adequetely release pressure from the left rudder and as takeoff was started the… - [NTSB DEN87LA021](https://openairdocs.org/ntsb/DEN87LA021.md): Cessna A188B · Rock Springs, MT · Accident · No injuries · Limited investigation · Final report · Nov 24, 1986 · N4862Q · Substantial damage > During the initial takeoff ground run in high wind conditions the acft drifted to the right, impacted a dirt bank, ground looped and nosed down. During the ground loop the left wing struck the ground, damaging the main spar. - [NTSB MIA87FA035](https://openairdocs.org/ntsb/MIA87FA035.md): Cessna T210F · West Palm Bch, FL · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1986 · N6194R · Destroyed > The eng was reported to be sputtering during the takeoff roll. The plt continued the takeoff and after liftoff declared an emergency. As the acft turned to a downwind position at a low alt with the eng still sputtering it struck a tree and a building at which… - [NTSB BFO87LA010](https://openairdocs.org/ntsb/BFO87LA010.md): Beech BE-55 · Beckley, WV · Accident · No injuries · Limited investigation · Final report · Nov 19, 1986 · N42P · Substantial damage > The plt stated that before takeoff he did not see anything on the rwy. The landing and taxi lights on the acft were on for the takeoff. During the takeoff roll when the acft was almost at takeoff speed the plt heard a loud bang followedby the acft yawing to… - [NTSB ANC87LA015](https://openairdocs.org/ntsb/ANC87LA015.md): Cessna 207A · Manokotak, AK · Accident · No injuries · Limited investigation · Final report · Nov 19, 1986 · N1763U · Substantial damage > The pilot stated that he lost directional control of the aircraft on the takeoff roll. The aircraft exited the departure end of the runway into the open tundra. - [NTSB CHI87LA031](https://openairdocs.org/ntsb/CHI87LA031.md): Cessna 150F · Nicollet, MN · Accident · No injuries · Limited investigation · Final report · Nov 16, 1986 · N6442F · Destroyed > The plt experienced fuel exhaustion and made an emergency forced landing. With the help of a farmer he refueled the acft and got it to nearby highway 14, where he attempted to takeoff while state police provided road blocks. While on takeoff, the plt lost… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=140 ## 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=139 --- 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.