# 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 147 of 281 · 14,038 cases ## Cases, newest first - [NTSB LAX85LA104](https://openairdocs.org/ntsb/LAX85LA104.md): Smith Miniplane DSA-1 · Van Nuys, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 10, 1985 · N5111V · Substantial damage > This was the initial test flt after installation of rebuilt wings. On the takeoff roll, the acft began drifting to the right & the plt corrected with left aileron. He stated that the acft 'whipped violently further to right, caught a wing tip & ground… - [NTSB ANC85LA038](https://openairdocs.org/ntsb/ANC85LA038.md): Piper PA-18 · Shaktoolik, AK · Accident · No injuries · Limited investigation · Final report · Jan 8, 1985 · N1912A · Substantial damage > The ski equipped acft contacted a snow drift during takeoff ground run. Acft veered and contacted a fishing rack. - [NTSB ATL85LA076](https://openairdocs.org/ntsb/ATL85LA076.md): Beech C90 · Winston Salem, NC · Accident · No injuries · Limited investigation · Final report · Jan 6, 1985 · N66KA · Substantial damage > During takeoff roll, at rotation, acft contacted a large dog which was on the rwy. Plt had good visibility except for light condition. Acdt occurred at night. Arpt perimeter is fenced but there are many gates, some of which remain open at night. Many dogs… - [NTSB SEA85LA039](https://openairdocs.org/ntsb/SEA85LA039.md): Cessna 152A · Pullman, WA · Accident · No injuries · Limited investigation · Final report · Jan 5, 1985 · N4702A · Substantial damage > Plt made 10 touch and go landings and had just raised the flaps and was applying full pwr to initiate another takeoff. Noting he was rt of the centerline he applied left rudder. Acft veered sharply to the left where it slid on ice into a snowbank. - [NTSB DEN85LA061](https://openairdocs.org/ntsb/DEN85LA061.md): Bellanca 8GCBC · Newburg, ND · Accident · No injuries · Limited investigation · Final report · Jan 5, 1985 · N5046C · Substantial damage > Plt attempted takeoff on a slippery, snow covered field with a 45 degree x-wind. Acft veered during the takeoff ground run and left main gear sheared off after contacting a snowbank. - [NTSB LAX85LA094](https://openairdocs.org/ntsb/LAX85LA094.md): Piper PA-28RT-201T · California City, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 30, 1984 · N2826G · Destroyed > The plt elected to land in a clear, flat, open, desert area which was used by campers to ride motorcycles and off-road vehicles. On the date that the plt landed there, numerous campsites & off-road vehicles were in the area. Nearly 2 hrs after the landing, he… - [NTSB MIA85IA076](https://openairdocs.org/ntsb/MIA85IA076.md): Douglas DC3A · Naples, FL · Incident · No injuries · Incident investigation · Final report · Dec 28, 1984 · N139PB · No damage > Shortly after takeoff, the aircrew noted that the elevator control was locked. They declared an emergency & landed without causing damage to the acft. After landing, the elevator external gust lock was found still installed. - [NTSB MKC85LA038](https://openairdocs.org/ntsb/MKC85LA038.md): Cessna 182F · Caruthersville, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 1984 · N3535U · Destroyed > According to the plt, the eng lost power after takeoff as the acft was climbing thru about 400 to 500 ft AGL. He attempted to land straight ahead on the remaining rwy. However, he was unable to stop on the rwy. The acft continued off the end of the rwy, went… - [NTSB ATL85LKG02](https://openairdocs.org/ntsb/ATL85LKG02.md): Cessna 172N · Tuscaloosa, AL · Accident · No injuries · Final report · Dec 23, 1984 · N1947F · Substantial damage > The acft veered to the left during the takeoff ground run. The acft departed the rwy into a soft, plowed field where it momentarily nosed down before coming to rest on the main landing gear. - [NTSB CHI85LA081](https://openairdocs.org/ntsb/CHI85LA081.md): Piper PA-38-112 · Wisconsin Rapid, WI · Accident · No injuries · Limited investigation · Final report · Dec 22, 1984 · N2461N · Substantial damage > The plt stated that during takeoff into winds form 290 deg at 10 KTS gusting to 15 KTS, the acft began to slide to the left on the icy rwy. When the acft hit a snow bank along the rwy, the nose gear collapsed. - [NTSB SEA85LA041](https://openairdocs.org/ntsb/SEA85LA041.md): Cessna 441 · Coeur D' Alene, ID · Accident · No injuries · Limited investigation · Final report · Dec 21, 1984 · N441CF · Substantial damage > On takeoff run, acft drifted left of center line, left seat pilot made corrective rudder input then right seat pilot made additional corrective input. Acft yawed moderately to left and contacted a snow berm. Acft spun left 180 degrees and slid backward to a… - [NTSB CHI85FA072](https://openairdocs.org/ntsb/CHI85FA072.md): Beech B-18S · Bellesville, MI · Accident · No injuries · Field investigation · Final report · Dec 19, 1984 · N51FG · Substantial damage > The plt stated that just after lift off the acft veered to the left going off the rwy striking the ground. Investigationrevealed that the plt in the left seat was receiving training & both plts were at the controls. The acft eng & airframe were inspected &… - [NTSB DEN85LA041](https://openairdocs.org/ntsb/DEN85LA041.md): Gulfstream Aerocommander 695 · Cortez, CO · Accident · No injuries · Limited investigation · Final report · Dec 13, 1984 · N980DW · Substantial damage > The accident acft was the first to use the rwy since it was scraped by the snow plow earlier in the day. A commercial plt that operates at the arpt said about 2-3 inches of snow had accumulated on the rwy since it was cleared. The plt of the accident acft… - [NTSB DEN85LA039](https://openairdocs.org/ntsb/DEN85LA039.md): Taylorcraft BC12-D · Conrad, MT · Accident · No injuries · Limited investigation · Final report · Dec 9, 1984 · N96059 · Substantial damage > Plt stated takeoff was being made on a dirt trail, heading 270 degrees, with a 20 kt headwind. Just prior to rotation wind shifted to a direction from the south-southwest. Acft drifted off right side of trail, contacted a ditch and nosed over. - [NTSB ANC85LA028](https://openairdocs.org/ntsb/ANC85LA028.md): Cessna 185 · Nome, AK · Accident · No injuries · Limited investigation · Final report · Dec 6, 1984 · N4895C · Substantial damage > The acft crashed during takeoff in gusty wind conditions. The acft reportedly hit a snow drift during takeoff and veeredoff the road being used as a rwy. The acft flew a short distance before impact. - [NTSB NYC85LA037](https://openairdocs.org/ntsb/NYC85LA037.md): Piper PA-38-112 · New Castle, PA · Accident · No injuries · Limited investigation · Final report · Dec 5, 1984 · N24880 · Substantial damage > On takeoff roll, the student pilot allowed the acft to drift left off of the runway. Acft collided with a dirt embankment and flipped inverted. - [NTSB LAX85LA065](https://openairdocs.org/ntsb/LAX85LA065.md): Cessna 150 · Ukiah, CA · Accident · No injuries · Limited investigation · Final report · Dec 5, 1984 · N22505 · Substantial damage > On initial takeoff roll, plt allowed acft to drift left while attention was focused on the airspeed indicator. When drift was noted, plt cut power and applied brakes but acft collided with VASI lights. - [NTSB FTW85LA066](https://openairdocs.org/ntsb/FTW85LA066.md): Cessna 172N · Lagrange, TX · Accident · No injuries · Limited investigation · Final report · Dec 3, 1984 · N3296E · Substantial damage > For unknown reasons the plt aborted the takeoff. Directional control was lost and the acft rolled into a parked acft. The private plt received his rating 2 days prior to the accident. - [NTSB LAX85LA056](https://openairdocs.org/ntsb/LAX85LA056.md): Gulfstream AA-5A · Llano, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1984 · N26773 · Substantial damage > The plt of the departing acft reported that he broadcast his intentions of takeoff & he made a 360 deg clearing turn to check for inbnd acft before beginning his takeoff roll on rwy 07. Prior to becoming airborne the plt observed an acft on short final apch… - [NTSB BFO85FA007](https://openairdocs.org/ntsb/BFO85FA007.md): Quickie Q2 · Clinton, MD · Accident · 1 fatal · Field investigation · Final report · Dec 2, 1984 · N5571W · Substantial damage > The acft was making its first takeoff following several previous hours of taxi tests. Witnesses reported that the airplane drifted to the left early in the takeoff roll until the left main wheel dropped off the rwy. The acft yawed to the left and continued… - [NTSB SEA85IA024](https://openairdocs.org/ntsb/SEA85IA024.md): Fairchild Swearingen SA 227 · Pullman, WA · Incident · No injuries · Incident investigation · Final report · Nov 30, 1984 · N1014T · Minor damage > The aircraft's landing gear collapsed after the plane went off the right side of runway 23 during takeoff. Reportedly, the aircraft drifted to the right of centerline on a fairly constant arc until contacting a snow berm at a taxiway intersection. An… - [NTSB CHI85LA060](https://openairdocs.org/ntsb/CHI85LA060.md): Aeronca 7AC · Allegan, MI · Accident · No injuries · Limited investigation · Final report · Nov 30, 1984 · N84360 · Substantial damage > The plt stated he lost power on takeoff, but elected to takeoff rather than abort. He cleared wires but decided he could not clear trees & made a forced landing in a corn field. Inspection of the acft revealed that the fuel control rod cotter pin was… - [NTSB MKC85LA027](https://openairdocs.org/ntsb/MKC85LA027.md): Temco GC-1B Swift · Fulton, MO · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N78247 · Substantial damage > The acft left the rwy collided with a pile of brush and nosed over during takeoff. A x-wind of 90 degrees at 8-14 KTS affected the takeoff. The plt said he delayed the abort too long after the acft started heading off the rwy thinking he could become airborne. - [NTSB ANC85LA025](https://openairdocs.org/ntsb/ANC85LA025.md): Piper PA-185-135 · Kodiak, AK · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N4083E · Substantial damage > The wheel equipped acft broke through the ice during a takeoff from a frozen lake. The increased drag slowed the acft and the plt was able to clear some trees but after bouncing along for 300-400 ft the acft hit a tree and ground looped. The acft wreckage was… - [NTSB ANC85FA023](https://openairdocs.org/ntsb/ANC85FA023.md): Piper PA-28RT-201T · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Nov 21, 1984 · N83645 · Substantial damage > The acft crashed during the takeoff roll by running off the departure end of the rwy, gliding over a hwy & impacting trees. According to the plt, 'on takeoff, we accelerated to 90-95 KTS, but the acft did not respond to back pressure for lift off. We… - [NTSB ANC85LA024](https://openairdocs.org/ntsb/ANC85LA024.md): Cessna 170B · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Nov 20, 1984 · N2468D · Substantial damage > The acft crashed during a takeoff from a sandbar on the King Salmon river. The plt stated that during his take- off roll, the windshield fogged over & he was unable to see, the acft's main gear struck a rock & the acft nosed over. - [NTSB ANC85LA021](https://openairdocs.org/ntsb/ANC85LA021.md): Cessna 207 · Koliganek, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 1984 · N1606U · Substantial damage > The acft crashed when it failed to become airborne during the takeoff run. The plt & witnesses agreed that snow was not removed from the acft prior to departure. - [NTSB LAX85LA044](https://openairdocs.org/ntsb/LAX85LA044.md): Cessna 185F · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Nov 18, 1984 · N4845E · Substantial damage > The acft went to the left of the desired track for takeoff and the plt said that in the attempt to regain directional control by means of throttle manipulation and brake application (the plt in later inspection of rwy and brakes reported rubber marks on the… - [NTSB CHI85LA094](https://openairdocs.org/ntsb/CHI85LA094.md): Cessna 172N · Holland, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1984 · N4738G · Substantial damage > The plt stated that a slight rudder pedal misalignment caused the acft to run off the rwy & into a ditch during the takeoff roll. He stated that during the first part of the takeoff roll the rudder 'did not respond normally or as expected.' A later… - [NTSB DCA85AA003](https://openairdocs.org/ntsb/DCA85AA003.md): Boeing 747-122 · Honolulu, HI · Accident · Serious injuries · Final report · Nov 16, 1984 · N4714U · Substantial damage > After accelerating to about 153 KTS drg the takeoff roll, the #7 tire failed & the flt crew aborted the takeoff. The acft was stopped with aprx 3000 ft of rwy remaining. Due to a fuel leak from the right wing, the capt ordered an evacu- ation from the left… - [NTSB CHI85LA047](https://openairdocs.org/ntsb/CHI85LA047.md): Rockwell 114 · Strongville, OH · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 1984 · N4739W · Substantial damage > Plt was aware runway had a pronounced dip just prior to rotation area of his acft. Passing the dip on takeoff roll, he felt a 'shimmy' which he attributed to nose gear reaction to the dip. Plt considered aborting takeoff, but felt insufficient runway… - [NTSB ATL85LA036](https://openairdocs.org/ntsb/ATL85LA036.md): Cessna 195B · Eads, TN · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1984 · N2133C · Substantial damage > The plt stated that he was taking off with full pwr. The acft accelerated to about 60 when it went over a small rise in the rwy, the left wheel assembly seperated from the acft at the pt where it attaches to the landing gear strut. The strut dug into the gnd… - [NTSB FTW85FA044](https://openairdocs.org/ntsb/FTW85FA044.md): Bell 206L-1 · E Cameron Blk 2 · Accident · Serious injuries · Field investigation · Final report · Nov 12, 1984 · N514EH · Substantial damage > Total loss of pwr occurred just after lift off from 130 ft high drill rig platform in gulf of Mexico. Plt entered autorotation but touchdown was hard during ditching resulting in a roll over. Post accident testing did not reveal any mechanical failure or… - [NTSB ANC85LA029](https://openairdocs.org/ntsb/ANC85LA029.md): Cessna 172I · Chandalar, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1984 · N8487L · Substantial damage > The plt reported that the acft hit a wooden sign post and ground looped during takeoff. The acft came to rest about 100 yards from the starting takeoff point. - [NTSB CHI85IA042](https://openairdocs.org/ntsb/CHI85IA042.md): Cessna T210L · Wheeling, IL · Incident · No injuries · Incident investigation · Final report · Nov 3, 1984 · N21YF · Minor damage > During a preflt, just prior to takeoff, the plt checked the flt controls & full travel of the controls was achieved. He initiated the takeoff, but when he applied back pressure on the elevator control, it would only move about 1 inch. He aborted the takeoff… - [NTSB CHI85LA030](https://openairdocs.org/ntsb/CHI85LA030.md): Moore Quicksilver MX II · Aurora, IL · Accident · No injuries · Limited investigation · Final report · Oct 28, 1984 · N3998J · Destroyed > Plt landed in open field to tighten his scarf, which had become loose and posed a possible hazard. A second ultralight landed to see of the plt had problems, then departed toward the east, successfuly negotiating a 10 kt x-wind. Plt elected to takeoff in same… - [NTSB DEN85LA021](https://openairdocs.org/ntsb/DEN85LA021.md): Cessna 320B · Glen Canyon, UT · Accident · No injuries · Limited investigation · Final report · Oct 27, 1984 · N9842L · Substantial damage > On takeoff roll, plt noted 5 inch difference in manifold pressure between the engs. Acft began to drift to the right. Plt applied corrective difference power, rudder and aileron to correct drift, but stated a gust of wind caused further right drift. Right… - [NTSB CHI85LA026](https://openairdocs.org/ntsb/CHI85LA026.md): Beech G-18S · Belleville, MI · Accident · No injuries · Limited investigation · Final report · Oct 24, 1984 · N3281T · Substantial damage > After reaching 75 KTS on takeoff roll, the acft ground looped to the left, shearing the main landing gear in side overload. Plt stated left gear seemed to be dragging. Investigation revealed no evidence of pre-existing brake/wheel malfunction or failure. - [NTSB MIA85LA017](https://openairdocs.org/ntsb/MIA85LA017.md): Piper PA-23-250 · Williston, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 23, 1984 · N24UE · Destroyed > The left seat pilot stated that he was doing touch and go landings on runway 04. He continued to state that on the last landing he touched down on the runway, then added full power and retracted the flaps, but inadvertantly retracted the landing gear. The… - [NTSB MIA85FA016](https://openairdocs.org/ntsb/MIA85FA016.md): Bell 47G-5A · Belle Glade, FL · Accident · No injuries · Field investigation · Final report · Oct 22, 1984 · N59424 · Substantial damage > Acft wad parked with 3 ft clearance between main rotor and corner of hangar. Plt stated that on lift off a gust of wind blew acft toward hangar. Main rotor blades made contact. Ground crewman injured by flying debris. - [NTSB CHI85LA023](https://openairdocs.org/ntsb/CHI85LA023.md): Cessna 172K · Berlin, WI · Accident · No injuries · Limited investigation · Final report · Oct 21, 1984 · N46407 · Substantial damage > The plt stated that he attempted to takeoff from a grass strip that is priented north and south. He described the grass as being 'too long' and the wind was from the west. The plt over rotated the acft to raise the nose wheel clear of the grass and was unable… - [NTSB DEN85FA015](https://openairdocs.org/ntsb/DEN85FA015.md): Cessna 414-8 · Cheyenne, WY · Accident · Serious injuries · Field investigation · Final report · Oct 20, 1984 · N1597T · Destroyed > The acft departed the airport in IFR conditions (snowing) & was observed staggering into the air. Shortly after takeoff the acft struck power lines & crashed into homes in a residential area. Investigation revealed that the acft had accumulated ice & in… - [NTSB FTW85LA023](https://openairdocs.org/ntsb/FTW85LA023.md): Piper J3C-65 · Kilgore, TX · Accident · No injuries · Limited investigation · Final report · Oct 19, 1984 · N6248H · Substantial damage > After taxiing north to the end of the strip a 180 deg turn was made prior to takeoff to the south. Out of the turn the acft was lined up with the left wing tip close to the fence. The plt intended to correct his line-up during the roll. According to the plt,… - [NTSB ATL85LA018](https://openairdocs.org/ntsb/ATL85LA018.md): Grumman G-164A · Tunica, MS · Accident · No injuries · Limited investigation · Final report · Oct 19, 1984 · N7867 · Substantial damage > The pilot attempted takeoff from an agricultural site which had soft spots from wet conditions. Directional control was lost when one main wheel encountered a soft spot. The aircraft veered into a plowed field and flipped inverted. - [NTSB DEN85LA011](https://openairdocs.org/ntsb/DEN85LA011.md): Helio Courier · Livingston, MT · Accident · No injuries · Limited investigation · Final report · Oct 18, 1984 · N700HC · Substantial damage > Prior to the attempted takeoff fss advised the plt of wind from 250 deg at 20 gusting to 30 KTS and informed him that rwy 26 would be the preferred rwy. The plt elected to use rwy 22. During the takeoff roll the right wing rose in a gust but control was… - [NTSB LAX85LA017](https://openairdocs.org/ntsb/LAX85LA017.md): Cessna 150M · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Oct 13, 1984 · N8989U · Substantial damage > Plt lost directional control of acft just prior to takeoff rotation. Acft continued off left side of rwy into a plowed field despite attempted remedial action. Nose gear collapsed. - [NTSB SEA85LA007](https://openairdocs.org/ntsb/SEA85LA007.md): Cessna 180 · Burley, ID · Accident · No injuries · Limited investigation · Final report · Oct 10, 1984 · N4752Q · Substantial damage > As plt initiated takeoff in a left x-wind, acft began to weathervane to the left. Increased right rudder and repeated applications of right brake failed to arrest an increasing swerve to left, with right brake pedal eventually bottoming out. As acft departed… - [NTSB SEA85LA006](https://openairdocs.org/ntsb/SEA85LA006.md): Cessna 140A · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Oct 10, 1984 · N9661A · Substantial damage > According to the plt he was unable to raise the tail of the acft during the takeoff and directional control could not be maintained. The plt made a hard landing in the acft on the day before the the accident. Investigators did not any flight control… - [NTSB DEN85FA007](https://openairdocs.org/ntsb/DEN85FA007.md): Bell 206B · Cheyenne, WY · Accident · No injuries · Field investigation · Final report · Oct 9, 1984 · N3912T · Substantial damage > The helicopter's tail rotor section contacted a pwr line during an attempted takeoff. A section of tail rotor blade tipwas found beneath the pwr lines. The pilot reported a vibration in the tail rotor control pedals. He attempted a landing into an open field.… - [NTSB SEA85LA004](https://openairdocs.org/ntsb/SEA85LA004.md): Cessna 152 · Aberdeen, ID · Accident · No injuries · Limited investigation · Final report · Oct 7, 1984 · N48757 · Substantial damage > According to the solo student plt, while accelerating through 40 KTS during takeoff the acft began to drift to the left. The acft departed the rwy, rolled through two fences and nosed over in the soft ground. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=148 ## 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=147 --- 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.