# 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 149 of 281 · 14,038 cases ## Cases, newest first - [NTSB DEN84LQA02](https://openairdocs.org/ntsb/DEN84LQA02.md): Lighthizer, Richard E. Lighthizer Special · Gallup, NM · Accident · No injuries · Final report · Aug 8, 1984 · N11RL · Substantial damage > The pilot/builder of this ultra-light had flown from oshkosh, WI to Gallup, NM without incident. During his attempted take-off from Gallup he allowed the acft to veer off the rwy to the left. After the acft rolled into the grasshe regained directional control… - [NTSB ATL84LA249](https://openairdocs.org/ntsb/ATL84LA249.md): Cessna 150J · Leesville, SC · Accident · No injuries · Limited investigation · Final report · Aug 8, 1984 · N60319 · Substantial damage > The pilot stated that while attempting to takeoff from a 1600 ft strip he was, 'unhappy with the thakeoff roll'. An aborted takeoff was initiated and when brakes were applied hard the nose gear collapsed and the aircraft nosed over. - [NTSB ANC84LA129](https://openairdocs.org/ntsb/ANC84LA129.md): Piper PA-12 · Hope, AK · Accident · No injuries · Limited investigation · Final report · Aug 6, 1984 · N2318M · Substantial damage > The acft collided with a ditch alongside a short strip used by hunters and fishermen. During interviews with the plt it was revealed that the acft was overloaded and out of CG. During the takeoff the plt decided to abort after passing his decision point but… - [NTSB MIA84LA216](https://openairdocs.org/ntsb/MIA84LA216.md): Piper PA-28-140 · Carrabelle, FL · Accident · No injuries · Limited investigation · Final report · Aug 5, 1984 · N5732W · Substantial damage > Acft swerved off the rwy after the plt heard a loud pop sound. Examination of the aircraft disclosed that the a main landing gear attach bolt had sheared. - [NTSB FTW84LA333](https://openairdocs.org/ntsb/FTW84LA333.md): Beech 56TC · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 1984 · N3792Q · Substantial damage > A special ferry permit had been issued for a one time flt. According the plt neither eng was developing normal power during or after takeoff. At appx 300 ft AGL the acft began to descend and the plt initiated the forced landing in the wooden terrain about 5… - [NTSB CHI84LA325](https://openairdocs.org/ntsb/CHI84LA325.md): Cessna 182-C · Akron, OH · Accident · No injuries · Limited investigation · Final report · Aug 2, 1984 · N8851T · 2 aircraft · Substantial damage > A Cessna 182 on takeoff on rwy 19 collided with a Piper PA34 landing on rwy 25. Each plts view of the other was obstructed by airport parking at one point during the mishap. The airport tower was closed. The pilot of the Cessna left the UNICOM frequency for… - [NTSB NYC84LA257](https://openairdocs.org/ntsb/NYC84LA257.md): Gates Learjet 25B · Waterville, ME · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 1984 · N1JR · Substantial damage > During preflight preparation for departure from a short field the plt failed to remove the pitot tube covers. On takeoff roll, the stall warning light began to flicker. Plt noted airspeed was not registering but did not consider this unusual in the early part… - [NTSB MKC84FA234](https://openairdocs.org/ntsb/MKC84FA234.md): Sims - Basset Varieze · Clarinda, IA · Accident · 2 fatal · Field investigation · Final report · Jul 27, 1984 · N4229G · Destroyed > Witnesses observed a ground run of aprx 2000 ft before lift-off was achieved after which the acft appeared to climb laboriously to about 100 ft AGL. Acft then executed steep, descending rt turn of about 240 degrees back toward the arpt. Acft collided with pwr… - [NTSB MIA84LA219](https://openairdocs.org/ntsb/MIA84LA219.md): Cessna 188 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Jul 24, 1984 · N4892R · Substantial damage > The acft departed the side of the rwy during takeoff. The acft was being ferried by the plt to his home base in FL. The NTSB did not receive an accident report from the plt although he said that one was mailed. Requests for a duplicate werenot responded to. A… - [NTSB LAX84LA409](https://openairdocs.org/ntsb/LAX84LA409.md): Vance-Hamm Glasair · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1984 · N499SH · Substantial damage > When the plt was cleared for takeoff, the tower was reporting a wind from 260 deg at 11 KTS. The takeoff was initiated & the acft accelerated normally. When the tailwheel was raised, the plane began drifting left. The plt said she applied rudder until she had… - [NTSB DEN84LA233](https://openairdocs.org/ntsb/DEN84LA233.md): Cessna A188B · Stratford, SD · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N9108R · Substantial damage > Plt stated that he was taking off on this flight with 120 gallons of chemical and full fuel tanks. He continued to state that the acft did not accelerate as it had earlier that day. The acft rolled aprx 3 quarters of the 1/2 mile long rwy before it became… - [NTSB ATL84LA232](https://openairdocs.org/ntsb/ATL84LA232.md): Cessna 182M · Harlan, KY · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 1984 · N91725 · Substantial damage > As the acft accelerated for takeoff the pilot's seat slid aft and he was unable to maintain directional control. The acft went off the left side of the rwy and nosed over when it rolled through high grass. According to the pilot the seat was locked in place… - [NTSB MKC84LA228](https://openairdocs.org/ntsb/MKC84LA228.md): Aero Commander Thrush S2R · Waldenberg, AR · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N9063Q · Substantial damage > While on takeoff roll one propeller blade separated and the engine came loose from the engine mounts. The acft was then stopped on the rwy. - [NTSB FTW84LA317](https://openairdocs.org/ntsb/FTW84LA317.md): Beech D-18S · Mcallen, TX · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N113B · Substantial damage > The PIC was observing from the right seat while the C0-PLT was in the left seat taking off. During the takeoff roll, the co-plt lost directional control of the acft & the PIC was unable to recover. The acft veered off the left side of the rwy, the right main… - [NTSB ATL84LA229](https://openairdocs.org/ntsb/ATL84LA229.md): Cessna A188B · Crenshaw, MS · Accident · No injuries · Limited investigation · Final report · Jul 19, 1984 · N9112R · Substantial damage > The pilot acknowledged that he attempted to take off on an aerial application flt with the acft loaded above its maximumcertificated gross weight. He stated that he had previously flown with chemical loads & had not encountered problems taking off. Prior to… - [NTSB MKC84LU006](https://openairdocs.org/ntsb/MKC84LU006.md): Rotec Rally 3 · Grand Island, NE · Accident · Serious injuries · Final report · Jul 17, 1984 · UNREG · Destroyed > Before the flt, the instructor saw a thunderstorm approximatetly 20 mi north of the field, moving slowly to the south-southeast. He & the student elected to make a short flt. After taking off, they made a practice forced landing in an open field about 1 mi… - [NTSB CHI84IA301](https://openairdocs.org/ntsb/CHI84IA301.md): Boeing 727-200 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jul 16, 1984 · N464DA · Minor damage > The #2 wheel assembly separated from the acft during takeoff roll. Flt was diverted to atlanta, GA, where an uneventful landing was made. Inspection revealed the axle failure occurred as a result of fatigue crack propagation of numerous prior cracks in the… - [NTSB ATL84LA219](https://openairdocs.org/ntsb/ATL84LA219.md): Haxton Quickie Q2 · Kennesaw, GA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1984 · N72PJ · Substantial damage > The home built acft had just been constructed & the plt was making hi speed taxi checks. On the 3rd check, he applied full power, intending to accelerate to a target speed of 60 mph. He reduced the power before reaching that speed; however, the acft… - [NTSB DEN84LA217](https://openairdocs.org/ntsb/DEN84LA217.md): Weatherly 201 · Watertown, SD · Accident · No injuries · Limited investigation · Final report · Jul 10, 1984 · N86686 · Destroyed > The spray boom of the acft caught in the green wheat along the right side of the dirt rwy during takeoff. The acft then ran off the prepared surface into the wheat. It then nosed over onto its back and caught fire. The dirt rwy is 30 ft wide. The wingspan of… - [NTSB DEN84LA261](https://openairdocs.org/ntsb/DEN84LA261.md): Piper PA-28R-201 · Los Alamos, NM · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N2292M · Substantial damage > The attempted downwind takeoff was aborted but resulted in an overrun off the end of the rwy. According to the PIC the airspeed indicator was inoperative and the brakes were well worn prior to departure. With about 1000 ft of rwy remaining the abort was… - [NTSB ATL84FKG11](https://openairdocs.org/ntsb/ATL84FKG11.md): Cessna 421C · Kennesaw, GA · Accident · No injuries · Final report · Jul 9, 1984 · N88639 · Substantial damage > The plt reported that during the takeoff roll, at about 80 KTS, the right baggage door came open. He aborted the takeoff & the acft ran off the end of the rwy. - [NTSB DEN84LA213](https://openairdocs.org/ntsb/DEN84LA213.md): Piper PA-38-112 · Bryce, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1984 · N25673 · Substantial damage > The plt said that the wind was calm. The arpt mgr said that the wind was 5-10 KTS from about 180 degrees. The acft according to him went off the left side of the rwy into dirt at full pwr. The acft went back to the rwy heading still atfull power. The plt… - [NTSB SEA84LA160](https://openairdocs.org/ntsb/SEA84LA160.md): Rearwin Rearwin 8125 · The Dalles, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1984 · N25547 · Substantial damage > The plt inadvertantly taxied the acft to the wrong rwy for takeoff. The plt did say he saw acft departing from another rwy. Takeoff was attempted with a 19 kt x-wind. The acft ran off the side of the rwy before becoming airborne. The arpt manager has since… - [NTSB NYC84FU007](https://openairdocs.org/ntsb/NYC84FU007.md): Pioneer Flightstar · Cross River, NY · Accident · Serious injuries · Final report · Jul 2, 1984 · UNREG · Substantial damage > During the takeoff roll, it appeared to the plt that the eng was not developing full power. The ultralight was not equipped with a tachometer & the suspected loss of power was based on the plt's estimated lift-off point. The plt further stated that he was… - [NTSB DEN84LA206](https://openairdocs.org/ntsb/DEN84LA206.md): Grumman G-164A · Wyndmere, ND · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N4638 · Substantial damage > Sod was worn from the middle of the strip & the strip was wet. Therefore, the plt elected to use the left side of the sod strip for takeoff. During the takeoff roll, the left spray boom dragged into wheat that was growing beside the rwy & the acft veered… - [NTSB LAX84FA375](https://openairdocs.org/ntsb/LAX84FA375.md): Cessna 182Q · Yorba Linda, CA · Accident · 2 fatal · Field investigation · Final report · Jun 30, 1984 · N735MQ · Destroyed > After filing a VFR flt plan, the non-instrument rated plt took off during darkness. The tower was not in operation when he departed. After taking off, the acft was observed maneuvering at an estimated alt of about 200 ft. witnesses reported there was no wind,… - [NTSB MKC84IA184](https://openairdocs.org/ntsb/MKC84IA184.md): Swearingen SA227-AC · Grand Island, NE · Incident · No injuries · Incident investigation · Final report · Jun 29, 1984 · N1014P · Minor damage > The capt started the rt eng at the gate & the lt eng while taxiing for takeoff. At this time the f/o was briefing the passengers on takeoff & en route procedures. The f/o then initiated the takeoff roll & the acft proceeded to the lt, striking a rwy light.… - [NTSB MKC84LA188](https://openairdocs.org/ntsb/MKC84LA188.md): Cessna 152 · Lee'S Summit, MO · Accident · No injuries · Limited investigation · Final report · Jun 28, 1984 · N25496 · Substantial damage > While taking off from a touch-&-go landing, the eng failed to develope full power. The instructor plt (CFI) pulled the throttle back to abort the takeoff, but the RPM would not reduce to idle. Subsequently, the acft continued aprx 500 ft past the end of the… - [NTSB MKC84IA185](https://openairdocs.org/ntsb/MKC84IA185.md): Swearingen SA226TC · Joplin, MO · Incident · No injuries · Incident investigation · Final report · Jun 27, 1984 · N233AM · Minor damage > While taxiing to takeoff & on the takeoff roll, the left brake overheated. Ten to fifteen mins after departure both tires on the left main landing gear exploded. The bearings and brakes also seized due to the high temperatures. Upon arrival at the dest, the… - [NTSB CHI84LA267](https://openairdocs.org/ntsb/CHI84LA267.md): Cessna 152 · Park Falls, WI · Accident · No injuries · Limited investigation · Final report · Jun 26, 1984 · N757DR · Substantial damage > The plt reported that during his preflt run-up, everything seemed normal. Using short field takeoff procedures, he rotated at 40 KTS & reached an alt of about 10 ft AGL. However, he stated that the acft did not want to accelerate to the best angle of climb… - [NTSB FTW84LA289](https://openairdocs.org/ntsb/FTW84LA289.md): Cessna A188B · Speaks, TX · Accident · No injuries · Limited investigation · Final report · Jun 25, 1984 · N731TL · Substantial damage > During takeoff to the south the northerly wind picked up. Acceleration was not sufficient enough to become airborne before end of airstrip. Acft overran airstrip and collided with a ditch. Density alt was 2,500 ft MSL and acft loaded with 1,200 lbs of… - [NTSB DEN84LA197](https://openairdocs.org/ntsb/DEN84LA197.md): Cessna T188C · Philip, SD · Accident · No injuries · Limited investigation · Final report · Jun 25, 1984 · N9952J · Substantial damage > The plt lost control of the acft during takeoff ground run when his vision was obscured by water which was sprayed on the windshield from a light rain shower. - [NTSB LAX84LA369](https://openairdocs.org/ntsb/LAX84LA369.md): Schweizer SGS-126D · Lucerne Valley, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1984 · N7712S · Substantial damage > The student plt reported that during a winch launch with a left x-wind, the wind lifted the left wing & the right wing contacted the ground. The glider then veered to the right & the right wing hit a wind sock & a vehicle. He reported that a wind-shift had… - [NTSB ANC84LA099](https://openairdocs.org/ntsb/ANC84LA099.md): Interstate S-1B2 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 24, 1984 · N62AT · Substantial damage > The plt reported that he began taking off on rwy 31 with an 8 kt x-wind, but after he started rolling, he noticed the wind had changed to 'downwind.' The plane 'seemed to pull hard to the left' & he could not maintan rwy alignment. As the acft apchd the left… - [NTSB NYC84LA220](https://openairdocs.org/ntsb/NYC84LA220.md): Waco UPF-7 · Orange, MA · Accident · No injuries · Limited investigation · Final report · Jun 23, 1984 · N32127 · Substantial damage > The plt stated that he was giving local sightseeing flights. He indicated that a 'wide' gentleman and a 'moderate' size gentleman boarded the acft. The plt moved the throttle to ensure clearance but found one of the pax restricted the movement slightly. The… - [NTSB LAX84LA365](https://openairdocs.org/ntsb/LAX84LA365.md): Stinson 108 · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Jun 23, 1984 · N97205 · Substantial damage > A prospective buyer in the left seat was initiating a takeoff in a tail wheel acft when the acft ground looped and the right main landing gear collapsed. The owner in the right seat was unable to correct the situation in time. The buyer had professed… - [NTSB SEA84LA154](https://openairdocs.org/ntsb/SEA84LA154.md): Piper PA-16 · Haines, AK · Accident · No injuries · Limited investigation · Final report · Jun 22, 1984 · N6826K · Substantial damage > The acft had landed on a short airstrip with a 10 kt headwind. When a takeoff was attempted the wind had stopped, according to the plt, and the acft would not become airborne. The acft went off the departure end of the rwy into underbrush and a gulley. The… - [NTSB MIA84LA192](https://openairdocs.org/ntsb/MIA84LA192.md): Piper J-3 CUB · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Jun 22, 1984 · N6932H · Substantial damage > The plt reported a loss of directional control occurred during the takeoff ground roll. The acft traveled off the rwy and collided with trees. - [NTSB ATL84LLT11](https://openairdocs.org/ntsb/ATL84LLT11.md): Cessna T188C · Shelby, MS · Accident · No injuries · Final report · Jun 22, 1984 · N9931J · Substantial damage > Acft was departing on the ninth aerial application flt of the operation. Weather had been clear but thunderstorms were building in the local area. On takeoff roll, a strong gust from the left rear caused loss of directional control. Acft veered left and… - [NTSB NYC84LA216](https://openairdocs.org/ntsb/NYC84LA216.md): Cessna C150 · Marlboro, NJ · Accident · No injuries · Limited investigation · Final report · Jun 21, 1984 · N66078 · Substantial damage > During takeoff the plt said that the power was slow to build and when he tried to rotate at 55 KTS he noticed the RPM AT2300 so he aborted the takeoff. The acft went past the departure end of the rwy into a ditch before stopping. - [NTSB NYC84FU004](https://openairdocs.org/ntsb/NYC84FU004.md): Teratorn TA · Landenberg, PA · Accident · Serious injuries · Final report · Jun 20, 1984 · UNREG · Substantial damage > The plt had previously flown 75 to 80 hrs in an ultralight controlled by a combination of weight-shift & rudder. On the day of the accident, he & his partner had practiced a series of crow hops in a Teratorn ta. The Teratorn ta was a 3-axis controlled… - [NTSB ATL84LA205](https://openairdocs.org/ntsb/ATL84LA205.md): Sikorsky CH-19E · Iva, SC · Accident · No injuries · Limited investigation · Final report · Jun 20, 1984 · N4721 · Substantial damage > The helicopter was being operated from sloping terrain. After returning from a spray mission, the plt remained inside the helicopter with the eng & rotor at ground idle while the ground crew refilled the spray tank. After completing the loading operation, the… - [NTSB MKC84LA175](https://openairdocs.org/ntsb/MKC84LA175.md): Cessna A188B · Westboro, MO · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N4857R · Substantial damage > Once becoming airborne, the acfts left boom was dragging in tall grass which paralleled the airstrip resulting in a 90 deg level turn to the left. The acft contacted the ground with the nose heading 90 to 110 degs left of the rwy heading. - [NTSB CHI84LA247](https://openairdocs.org/ntsb/CHI84LA247.md): Cessna 152 · Little Falls, MN · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N751AA · Substantial damage > Previously, the acft had been landed in a 1000 ft fld when the eng quit during a simulated emergency while on a dual instructional flt. The instructor plt decided to leave the student there & fly the acft back to the arpt. He walked down the field & made an… - [NTSB ANC84FA094](https://openairdocs.org/ntsb/ANC84FA094.md): Cessna A185F · Talkeetna, AK · Accident · No injuries · Field investigation · Final report · Jun 17, 1984 · N1047F · Substantial damage > The acft was being used to transport mountain climbers from a glacier. During takeoff from the glacier, the right landing gear strut failed at the axle point & the wheel/ski dangled free. When he landed on a gravel rwy, the plt held off the right side as long… - [NTSB MKC84LA170](https://openairdocs.org/ntsb/MKC84LA170.md): Stolp Starduster Starduster II · Lawrence, KS · Accident · No injuries · Limited investigation · Final report · Jun 13, 1984 · N4GB · Substantial damage > During takeoff roll from a grass covered runway the plt aborted the takeoff. The acft nosed over as the plt attempted to bring it to a stop. The plt stated that the acft did not appear to be accelerating as it should & so he aborted the takeoff. He said that… - [NTSB MKC84LA168](https://openairdocs.org/ntsb/MKC84LA168.md): Aero Commander S2R · Dexter, MO · Accident · No injuries · Limited investigation · Final report · Jun 11, 1984 · N8986Q · Substantial damage > The ag strip had recently been graded to increase its width from 20 ft to 50 ft. some clumps of dirt and sod had been left on the strip. The plt said the acft drifted to the left during takeoff roll and hit some of the dirt clods. The pltsaid he overcorrected… - [NTSB LAX84LA344](https://openairdocs.org/ntsb/LAX84LA344.md): Piper PA-28R-201T · Kernville, CA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N2650Q · Substantial damage > Plt attempted to takeoff with acft near max gross weight. The density alt was calculated to be 5000 ft. according to the performance charts, the acft would have used aprx 5000 ft for takeoff. The departure runway was 3500 feet long. The plt attempted takeoff… - [NTSB DEN84LA176](https://openairdocs.org/ntsb/DEN84LA176.md): Cessna 150M · Afton, WY · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N8564U · Substantial damage > The plt departed rwy 16 with the intention of repositioning the acft on the arpt after landing. He estimated the surfacewinds were from the southeast at 15 KTS. A witness stated that the winds had changed directions about eight times during the day. The plt… - [NTSB LAX84LA341](https://openairdocs.org/ntsb/LAX84LA341.md): Bell 47G-5 · Oceanside, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1984 · N2252W · Substantial damage > A security guard with no flight experience attempted to fly the helicopter which he was guarding during early morning hours after substantial alcoholic beverage consumption. The acft sustained substantial damage when it touched down on the rt skid aprx 15 ft… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=150 ## 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=149 --- 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.