# 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 144 of 281 · 14,038 cases ## Cases, newest first - [NTSB MIA85LLD03](https://openairdocs.org/ntsb/MIA85LLD03.md): Brokaw Bullet · Eustis, FL · Accident · No injuries · Final report · Sep 14, 1985 · N520BJ · Substantial damage > The acft contacted a ditch during an attempted takeoff on a taxiway. The plt reportedly decided to use the taxiway for takeoff rather than the rwy because of the soft rwy conditions which resulted from recent rains. During takeoff the leftmain gear contacted… - [NTSB MKC85LA215](https://openairdocs.org/ntsb/MKC85LA215.md): Cessna 421B · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Sep 13, 1985 · N88DM · Substantial damage > During the takeoff roll on an IFR flt, the right eng lost pwr and the plt aborted the takeoff. The acft ran off the end of the rwy, across two ditches, one road, through a fence and struck a post in a fld. During post accident tests, the right eng would run… - [NTSB CHI85IA369](https://openairdocs.org/ntsb/CHI85IA369.md): Fokker F27-500 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 9, 1985 · N242MA · Minor damage > At about the time full power was obtained the heard a loud bang followed by a fire warning for the left engine. The takeoff was aborted and the crew shut down the engine. The passengers were deplaned on the taxiway after it was determined the fire was out &… - [NTSB ANC85LA173](https://openairdocs.org/ntsb/ANC85LA173.md): Taylorcraft BL-65 · Rainey Pass, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 9, 1985 · N27696 · Substantial damage > The plt was taking off on a strip of tundra about 1000 ft long in calm wind conditions. During the takeoff roll, he lost directional control & the acft ground looped & was damaged. No mechanical problems were reported. - [NTSB MKC85LA211](https://openairdocs.org/ntsb/MKC85LA211.md): Cessna 172N · Bridgeport, NE · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 1985 · N2920E · Substantial damage > N2920E was taking off on a 2,800 ft long, turf rwy. There was a lt crosswind of 12 KTS and the density alt was 5,000 ft. the plt said the acft encountered a dip in the rwy and swerved to the lt momentarily. He said he regained directional control but then… - [NTSB MIA85IA246](https://openairdocs.org/ntsb/MIA85IA246.md): Douglas DC-8-71 · West Palm Bch, FL · Incident · No injuries · Incident investigation · Final report · Sep 8, 1985 · N1300L · Minor damage > During take off roll the #4 engine failed causing catostrophic destruction of the engine. During subsequent examination the left vgv actuator pin was found to be missing. Without this pin the vgv ARM8 are aysemetrically driven. The vgv arms were found broken… - [NTSB LAX85FA385](https://openairdocs.org/ntsb/LAX85FA385.md): Jonas Humming Bird · Tucson, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 8, 1985 · N14GJ · Substantial damage > The experimental homebuilt acft was designed by the plt and incorporated a lifting body symetrical airfoil shaped fuselage. Pitch control was to be accomplished with a narrow chord canard. Witnesses saw the acft lift off briefly to about 10 ft AGL during the… - [NTSB LAX85LA387](https://openairdocs.org/ntsb/LAX85LA387.md): Cessna 170B · Buckeye, AZ · Accident · No injuries · Limited investigation · Final report · Sep 5, 1985 · N1659D · Substantial damage > The plt attempted to depart on soft silt & sand. During the takeoff roll the acft wheels sank into the soft terrain necessatating differential braking to maintain directional control. As the acft approached a ditch the plt forced the acft airborne. The acft… - [NTSB FTW85LA342](https://openairdocs.org/ntsb/FTW85LA342.md): Cessna A185F · Port Sulphur, LA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1985 · N5513E · Destroyed > The plt stated he initiated his water takeoff run on a canal which had a left bend. When he rounded the bend he observed a 15-20 foot high piling (post) in the middle of the canal and a peninsula of land about 300 yards beyond the piling. He steered to the… - [NTSB FTW85LA337](https://openairdocs.org/ntsb/FTW85LA337.md): Piper PA-28-181 · Westbrook, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1985 · N8043C · Substantial damage > There were no known eye witnesses to the accident. Available evidence reveals that the pilot most probably made a successful landing in the remotely located field and rolled to a stop. The sheriff reported that the engine oil was drained onto the ground at… - [NTSB ATL85LA267](https://openairdocs.org/ntsb/ATL85LA267.md): Bryan HP-14 · Aiken, SC · Accident · No injuries · Limited investigation · Final report · Sep 2, 1985 · N5DB · Substantial damage > Plt reported that sailplane was positioned for a tow in tall grass beside the rwy. He said that during the takeoff the left wing was slowed by the tall grass allowing the right wing to accelerate. The sailplane yawed left and rolled left until 90 degrees to… - [NTSB ANC85LA166](https://openairdocs.org/ntsb/ANC85LA166.md): Maule M-5 · Cape Yakataga, AK · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N51566 · Substantial damage > The plt reported that he started to depart from a gravel strip, then elected to abort the takeoff. While rolling on the ground, the acft hit a 'wash-out' which bent a structural tube on the landing gear assembly. - [NTSB CHI85FEP04](https://openairdocs.org/ntsb/CHI85FEP04.md): PZL-Bielsko SZD-45A Ogar · Ft. Atkinson, WI · Accident · Serious injuries · Final report · Aug 31, 1985 · N35AS · Substantial damage > Witnesses reported seeing the acft shortly after takeoff at an alt of aprx 40 to 50 ft AGL. At this time, according to witnesses, the eng slowed down, the acft turned left and dove into the terrain. No mechanical failure/malfunction was discovered during an… - [NTSB ANC85LA164](https://openairdocs.org/ntsb/ANC85LA164.md): Bellanca 7AC · Chetaslina Rvr, AK · Accident · No injuries · Limited investigation · Final report · Aug 29, 1985 · N83725 · Substantial damage > The pilot stated that he run out of runway and he did not reach min flying speed for lift off. The tundra run way created more drag than the pilot had anticipated. The pilot then departed thr tundra runway lost directional control of the aircraft crusing a… - [NTSB NYC85LA225](https://openairdocs.org/ntsb/NYC85LA225.md): Beech G18S · Newark, NJ · Accident · No injuries · Limited investigation · Final report · Aug 28, 1985 · N9990R · Substantial damage > While taking off with a left x-wind, the acft began to veer to the left. The plt corrected by using differential power & right brake, but the acft continued to veer left & went off the rwy. Subsequently, the right main gear collapsed & the acft was… - [NTSB ANC85LA161](https://openairdocs.org/ntsb/ANC85LA161.md): Aeronca 11AC · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Aug 25, 1985 · N86090 · Substantial damage > The pilot stated that approximately 200 ft into the rollout the right wing lifted into the air, veering the plane to the right losing directional control of the aircraft causing the aircraft to exit the runway into a gravel pit. - [NTSB LAX85LA363](https://openairdocs.org/ntsb/LAX85LA363.md): Cessna 172N · Turlock, CA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1985 · N7338F · Substantial damage > On August 22, 1985, a Cessna 172N, N7338F, collided with a 3FT tall pole while taking off from Turlock, CA. VMC existed at the time. The ac was substantially damaged and the plt and his 2 pax were not injured. The plt stated that he was on the rwy when in… - [NTSB CHI85LA355](https://openairdocs.org/ntsb/CHI85LA355.md): Ercoupe 415-C · Ashkum, IL · Accident · No injuries · Limited investigation · Final report · Aug 21, 1985 · N99666 · Substantial damage > The left wing of the acft contacted crops during an attempted takeoff. The plt reported liftoff was too soon and the acft veered left contacted crops. The plt stated that he should have stayed on rwy longer. - [NTSB CHI85LA353](https://openairdocs.org/ntsb/CHI85LA353.md): Cessna 170B · West Chicago, IL · Accident · No injuries · Limited investigation · Final report · Aug 21, 1985 · N2209D · Substantial damage > During application of pwr during a touch-and go landing the acft 'started to get sideways' on the rwy. The plt allowed the acft to drift off the left side of the rwy into the grass. A ground loop subsequently occurred which substantially damaged the acft.… - [NTSB DEN85LTG07](https://openairdocs.org/ntsb/DEN85LTG07.md): Aeronca 058B · Mott, ND · Accident · No injuries · Final report · Aug 19, 1985 · N47500 · Substantial damage > While departing a stubble field, the aircraft's tire ran into a soft spot in the ground and the aircraft turned and struck the shoulder of a road. The right gear broke and the right wing tip struck the ground, the right strut broke, the tail wheel and rudder… - [NTSB LAX85FA355](https://openairdocs.org/ntsb/LAX85FA355.md): Cessna 150L · Rialto, CA · Accident · Serious injuries · Field investigation · Final report · Aug 18, 1985 · N19530 · 2 aircraft · Destroyed > The christian eagle biplane was returning from a local instructional flight and entered the pattern on a normal 45 degree entry, announcing position and intentions on the UNICOM frequency. The Cessna 150 was departing the airport on a local instructional… - [NTSB FTW85LA327](https://openairdocs.org/ntsb/FTW85LA327.md): Cessna 150M · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N714AE · Substantial damage > The plt was advised that he was cleared for an intersection takeoff on rwy 17R. After his run up, the plt attempted a night takeoff to the north on an unlighted taxiway that ran parallel to the active runway. Controllers advised the pilot to abort, which he… - [NTSB MKC85FA189](https://openairdocs.org/ntsb/MKC85FA189.md): Bell 47G-2A · Sedalia, MO · Accident · Serious injuries · Field investigation · Final report · Aug 17, 1985 · N3951U · Substantial damage > The plt was taking 2 passengers on a helicopter ride at a fair. Immediately after lift-off, he encountered a situation where he was unable to maintain directional control, so he reduced power & landed. Before coming to rest, the tail of the helicopter struck… - [NTSB MIA85LA236](https://openairdocs.org/ntsb/MIA85LA236.md): Mooney M20F · Ft. Myers, FL · Accident · No injuries · Limited investigation · Final report · Aug 16, 1985 · N7122V · Substantial damage > The acft settled to the rwy during the takeoff roll after the landing gear retracted. The plt stated that the landing gear collapsed for an unknown reason. A post accident inspection of the landing gear and related components revealed no defects or… - [NTSB CHI85LA350](https://openairdocs.org/ntsb/CHI85LA350.md): Cessna C-172P · Zanesville, OH · Accident · No injuries · Limited investigation · Final report · Aug 16, 1985 · N5279K · Substantial damage > Plt aborted takeoff from taxiway when he realized that he as not on rwy. Plt stated he was confused by taxiway marking & he believes taxiway arrows are misleading. - [NTSB LAX85LA347](https://openairdocs.org/ntsb/LAX85LA347.md): Piper PA-30 · Hollister, CA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1985 · N7982Y · Substantial damage > The plt and gnd witnesses reported that during the takeoff roll, the nose gear collapsed, followed by the main landing gears. Post-accident investigation disclosed the landing gear control handle was in the down position. All of the landing gear… - [NTSB DEN85LA217](https://openairdocs.org/ntsb/DEN85LA217.md): Piper PA-32-300 · Ruidoso, NM · Accident · No injuries · Limited investigation · Final report · Aug 13, 1985 · N2905B · Substantial damage > Acft was 20 lbs over the max gross weight. Plt said he aborted the first takeoff due to a rough running eng. The plt performed a runup and attempted a second takeoff which was aborted again due to rough running eng. The acft ran off end of rwy and struck a… - [NTSB CHI85FA344](https://openairdocs.org/ntsb/CHI85FA344.md): Learjet 23 · Madison, WI · Accident · No injuries · Field investigation · Final report · Aug 13, 1985 · N61TS · Substantial damage > The plt elected to take off with a heavy loaded acft on the short rwy. The plt stated a loud noise was heard as the acft approached 80 KTS. The takeoff was aborted at 100 KTS. Hydroplaning was experienced and a loss of control occurred. The acft traveled off… - [NTSB CHI85LA343](https://openairdocs.org/ntsb/CHI85LA343.md): Cessna 152 · Marlette, MI · Accident · No injuries · Limited investigation · Final report · Aug 11, 1985 · N49292 · Substantial damage > The student plt was cleared by his CFI for his second solo flt immediately following a period of dual traffic pattern instruction. As he began his takeoff run he failed to use sufficient right rudder quickly enough to prevent the acft from eventually… - [NTSB CHI85LA333](https://openairdocs.org/ntsb/CHI85LA333.md): Cessna 172XP · Int'L Falls, MN · Accident · No injuries · Limited investigation · Final report · Aug 10, 1985 · N1254V · Substantial damage > The acft veered hard to the rt & collided with the water during takeoff at about 45 mph. It was discovered that the left float failed and allowed the left float to turn rt and go under the rt float. - [NTSB SEA85FA190](https://openairdocs.org/ntsb/SEA85FA190.md): Beachner Quick Silver · Vancouver, WA · Accident · 2 fatal · Field investigation · Final report · Aug 7, 1985 · N824CB · Destroyed > Plt was observed working on engine distributor prior to departure for weekend demo at airshow for design sales promotion. Witnesses noted engine sound on takeoff seemed less than normal. Acft lifted off, gear were retracted and acft climbed to about 200 ft… - [NTSB ATL85LA240](https://openairdocs.org/ntsb/ATL85LA240.md): Cessna 152 · Lexington, NC · Accident · No injuries · Limited investigation · Final report · Aug 7, 1985 · N48005 · Substantial damage > Student pilot was on solo flight. He stated that another acft called on final as he was on runway for takeoff. Unsure of action to take since taxiway behind him was blocked, he rushed takeoff. A soft field takeoff was attempted. Nose was raised, tail dragged… - [NTSB FTW85FA306](https://openairdocs.org/ntsb/FTW85FA306.md): Cessna A150M · Levelland, TX · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1985 · N9807J · Substantial damage > The plt had been observed to make takeoffs using maximum up elevator for liftoff. The elevator was found in a nineteen degree up position and both the left horizontal stabilizer and elevator were bent upward at the tip. The down elevator clevis was observed… - [NTSB CHI85LA341](https://openairdocs.org/ntsb/CHI85LA341.md): Cessna 172H · Whitewater, WI · Accident · No injuries · Limited investigation · Final report · Aug 6, 1985 · N8229L · Substantial damage > According to the plt he planned to use max performance takeoff procedures out of the owner's manual for the takeoff. After brake release the acft began to roll down the sod rwy. Acceleration continued, but according to the plt, his airspeed increase seemed… - [NTSB ANC85LA148](https://openairdocs.org/ntsb/ANC85LA148.md): Stinson 108-3 · Montague Island, AK · Accident · No injuries · Limited investigation · Final report · Aug 6, 1985 · N4000C · Substantial damage > The plt stated that during the takeoff roll, the acft was kept close to the waterline to stay on the hard sand. After rolling aprx 700 ft, the tail wheel was raised. At about that time, the left gear sank in soft sand & pulled the acft to the left.… - [NTSB ANC85LA147](https://openairdocs.org/ntsb/ANC85LA147.md): Cessna 172 · Chickaloon Flat, AK · Accident · No injuries · Limited investigation · Final report · Aug 6, 1985 · N61684 · Substantial damage > The plt made an off-arpt landing on an area of clay silt with sparse grass. After slowing the acft to about 20 to 25 mph, the nosewheel went into a shallow gully of soft clay. The acft then stopped abruptly & nosed over. - [NTSB NYC85LA202](https://openairdocs.org/ntsb/NYC85LA202.md): Piper PA-28-161 · Wildwood, NJ · Accident · No injuries · Limited investigation · Final report · Aug 5, 1985 · N21521 · Substantial damage > N21521 taxied onto runway 10 at the intersection of runway 14 after observing another aircraft taxi and take off from that point. N21521 did not attain sufficient airspeed for takeoff prior to running out of available runway. The pilot did not apply hard… - [NTSB SEA85LA185](https://openairdocs.org/ntsb/SEA85LA185.md): Beech B-35 · Auburn, WA · Accident · No injuries · Limited investigation · Final report · Jul 30, 1985 · N3729N · Substantial damage > Directional control of the acft was lost for unknown reasons just prior to rotation. The acft then veered off the right side of the rwy. - [NTSB DEN85FA203](https://openairdocs.org/ntsb/DEN85FA203.md): Cessna C-182 · La Salle, CO · Accident · 2 fatal · Field investigation · Final report · Jul 30, 1985 · N5642B · Destroyed > The plt and his girlfriend t/o from a pvt airfield north of denver co in a C182 in heavy fog conditions. The pilot was not inst rated. Shortly after t/o the aircraft hit the ground and was destroyed. Both occupants rec'd fatal injuries. - [NTSB BFO85LA064](https://openairdocs.org/ntsb/BFO85LA064.md): Stampe SV4C · Fredericksburg, VA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1985 · N10WN · Substantial damage > The acft lost directional control and veered to the right. Colliding with a tied down Cessna 210, N2542X, while taking off from rwy 23 at shannon airport, Fredericksburg, Virginia. - [NTSB ANC85FA136](https://openairdocs.org/ntsb/ANC85FA136.md): Cessna 180H · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Jul 28, 1985 · N71RD · Substantial damage > The pilot attempted to takeoff uphill from a short airstrip with a steep incline during a no wind condition. The airplane drifted off the centerline after liftoff and struck three parked airplanes before hitting trees and turning over. Uphill takoffs are not… - [NTSB ANC85LA134](https://openairdocs.org/ntsb/ANC85LA134.md): Cessna 206 · Kustatan River, AK · Accident · No injuries · Limited investigation · Final report · Jul 27, 1985 · N4649U · Substantial damage > The plt reported that he was taking off from a River/lake area with glassy water on a hot/sultry day. After initial lift-off, the acft settled & touched down on the water, then lifted off again. It flew beyond the edge of the lake, then settled & nosed over… - [NTSB NYC85LA193](https://openairdocs.org/ntsb/NYC85LA193.md): Piper PA-30 · Worcester, MA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1985 · N999RH · Substantial damage > The instructor (CFI) & student were practicing touch-&-go landings. On the 4th landing, the apch & touchdown were made with full flaps extended. The CFI began to retract the flaps while the student applied full power for takeoff. The acft became airborne &… - [NTSB NYC85LA188](https://openairdocs.org/ntsb/NYC85LA188.md): Lake LA-4 · Sidney, ME · Accident · No injuries · Limited investigation · Final report · Jul 21, 1985 · N6668L · Substantial damage > According to the plt, the acft was on step and in indicating about 45 KTS airspeed. It then encountered a boat wake and began flying. The acft porpoised 2 or 3 times and then collided with the water in an estimated 10 to 15 deg nose down attitude. The pwr was… - [NTSB FTW85LA295](https://openairdocs.org/ntsb/FTW85LA295.md): Bell 206L-1 · South Marsh · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1985 · N5753D · Destroyed > The plt was initiating a takeoff from a hover off an offshore oil rig. As he lowered the nose for takeoff, he heard a loud noise emit from the tailboom area & the acft began rotating to the right. The plt continued to apply pwr and autorotated to the water.… - [NTSB CHI85LA288](https://openairdocs.org/ntsb/CHI85LA288.md): Beech BE-55 · Eden Prairie, MN · Accident · No injuries · Limited investigation · Final report · Jul 18, 1985 · N22PG · Substantial damage > The acft collided with the fence during an aborted takeoff. The tires of the acft showed signs of hydroplaning after the accident. No mechanical discrepancies were noted during the investigation. The takeoff was aborted the plt said because the acft yawed… - [NTSB ATL85LA220](https://openairdocs.org/ntsb/ATL85LA220.md): Cessna 152 · Mt Sterling, KY · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1985 · N67825 · Destroyed > The insturctor (CFI) was demonstrating a soft field takeoff from a grass area beside the rwy. At that time, the acft lifted off, then settled back onto the grass. The CFI reported that the right main gear touched down in a hole which caused the acft to veer… - [NTSB ANC85FA130](https://openairdocs.org/ntsb/ANC85FA130.md): Piper PA-22/20 · Alexander Lake, AK · Accident · No injuries · Field investigation · Final report · Jul 18, 1985 · N3445Z · Substantial damage > The plt lost directional control of the acft during takeoff and the acft rolled into rough terrain along side of the rwy where it nosed over. - [NTSB CHI85LA295](https://openairdocs.org/ntsb/CHI85LA295.md): Robert Thibodeau JR ACE · Troy, MI · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N3642 · Substantial damage > On July 17,1985 at 1015 EDT, a Robert Thibodeau jr ace N3642, registered to and flown by Robert Thibodeau, lost control and collided with the terrain on takeoff at Troy oakland airport, Troy,Michigan, while on a personal flight. Visual meteorological… - [NTSB ATL85LA214](https://openairdocs.org/ntsb/ATL85LA214.md): Wag-Aero Cubbie (J-3) · Stockbridge, GA · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1985 · N909GH · Substantial damage > During a departure, the eng had a partial loss of power. The plt reported that after climbing to about 75 ft, neither the acft's speed nor alt would increase. He lowered the nose to increase the eng RPM & speed, but the eng did not respond. Subsequently, the… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=145 ## 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=144 --- 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.