# 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 143 of 281 · 14,038 cases ## Cases, newest first - [NTSB DEN86FA069](https://openairdocs.org/ntsb/DEN86FA069.md): Bell 206L-1 · Missoula, MT · Accident · No injuries · Field investigation · Final report · Jan 27, 1986 · N5019K · Substantial damage > The helicopter, equipped with landing skid snow pads, was parked on a narrow ramp extension to a roof top helipad that was surrounded by a concrete curb. Upon takeoff to a hover, the right snow pad struck and became momentartily caught on bolts protruding… - [NTSB CHI86LA070](https://openairdocs.org/ntsb/CHI86LA070.md): Cessna 185 · St. Ignace, MI · Accident · No injuries · Limited investigation · Final report · Jan 20, 1986 · N1573F · Substantial damage > The pilot stated that after the application of full power for takeoff his seat slid back to its full aft position. He could not reach any of the controls. He then unfastened his seat belt and lunged forward to pull the power off. At this time the right wing… - [NTSB ATL86LA059](https://openairdocs.org/ntsb/ATL86LA059.md): Beech A36TC · Louisville, KY · Accident · No injuries · Limited investigation · Final report · Jan 19, 1986 · N345CC · Substantial damage > Plt attempted t.o. from slush covered rwy with about 1/2 to 3/4 inch of snow on acft. When snow did not blow off the wings, abort attempted at between 80-100 knots. Acft went off the end of the rwy and through fence before coming to a stop on the golf course… - [NTSB MKC86LA055](https://openairdocs.org/ntsb/MKC86LA055.md): Cessna 152 · Independence, MO · Accident · No injuries · Limited investigation · Final report · Jan 18, 1986 · N4977P · Substantial damage > During an aborted takeoff in strong crosswinds, the acft veered off the rwy and into a ditch near the runways edge. The nose gear collapsed rearward and the right wing dropped striking the ground. The plt stated he aborted the takeoff when the acft felt like… - [NTSB MKC86LA052](https://openairdocs.org/ntsb/MKC86LA052.md): Piper PA-28-180 · Columbia, MO · Accident · No injuries · Limited investigation · Final report · Jan 15, 1986 · N7013W · Substantial damage > The pilot stated that he was showing his passenger a procedure that he used in multi-engine airplanes when he inadvertently stalled the airplane at 300 feet AGL just after takeoff. He could not complete the recovery before impacting the runway. - [NTSB NYC86LA066](https://openairdocs.org/ntsb/NYC86LA066.md): Cessna 152 · Plainville, CT · Accident · No injuries · Limited investigation · Final report · Jan 10, 1986 · N6267Q · Substantial damage > The purpose of instructional flight was to practice soft field landings and takeoffs, stall series and VOR naviagtion. After airwork, the pilot flew to robertson field for short and soft field landings and takeoffs. During final soft field takeoff, 10 degrees… - [NTSB MKC86LA046](https://openairdocs.org/ntsb/MKC86LA046.md): Cessna 177A · Sidney, NE · Accident · No injuries · Limited investigation · Final report · Jan 7, 1986 · N30535 · Substantial damage > N30535 was making a night takeoff on a rwy covered by 3' deep snow. There were also drifts along the lt side of the rwy which were 8 to 10 inches deep. During the takeoff roll moisture blew onto the windshield and the acft drifted to the lt. the acft then… - [NTSB FTW86FA033](https://openairdocs.org/ntsb/FTW86FA033.md): Bell 206B · Port O'Connor, TX · Accident · Minor injuries · Field investigation · Final report · Jan 7, 1986 · N520EH · Destroyed > The helicopter sustained a loss of tailrotor drive on lift off. A bonding in a shaft coupling failed. Extensive research and analysis discovered no discrepancies in design, production, quality assurance, maintenance or operating environment that could have… - [NTSB CHI86LA058](https://openairdocs.org/ntsb/CHI86LA058.md): Cessna 152 · West Chicago, IL · Accident · No injuries · Limited investigation · Final report · Jan 5, 1986 · N6422Q · Substantial damage > During takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the… - [NTSB FTW86MA030](https://openairdocs.org/ntsb/FTW86MA030.md): Boeing 737-2H4 · Dallas, TX · Incident · No injuries · Major investigation · Final report · Jan 3, 1986 · N86SW · Minor damage > This incident occurred when the no. 2 engine experienced an aft engine mount cone bolt failure and the subsequent failure of the secondary support link (stainless steel cable). The failure of both aft engine support assemblies during the takeoff roll allowed… - [NTSB DEN86LA062](https://openairdocs.org/ntsb/DEN86LA062.md): Bellanca 7ECA · Hope, ND · Accident · No injuries · Limited investigation · Final report · Jan 3, 1986 · N50384 · Substantial damage > The plt stated the citabria he was piloting failed to obtain flying speed before reaching the end of the snow covered private airstrip. According to the pilot, he aborted the takeoff too late. The acft contacted a snowbank and nosed over. The plt said that… - [NTSB LAX86LA103](https://openairdocs.org/ntsb/LAX86LA103.md): Cessna T210N · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Jan 2, 1986 · N6594Y · Substantial damage > The plt planned to fly nonstop fm houston, TX, to phoenix, AZ. He reported that during the trip he encountered 'fluctuating head winds' & he miscalculated the acft's endurance. Fuel exhaustion occurred 8 miles fm Tucson, AZ., & the plt made a successful… - [NTSB FTW86FPA13](https://openairdocs.org/ntsb/FTW86FPA13.md): Beech E18S · Terrell, TX · Accident · No injuries · Final report · Jan 2, 1986 · N27Y · Substantial damage > The plt reported the acft yawed left on takeoff and despite attempted remedial action the acft would not clear odstaclesalong the flt path. Pwr was reduced and a straight in landing was made in a fld aprx 1/4 mile north of the rwy. A witness reported the acft… - [NTSB MKC86LA042](https://openairdocs.org/ntsb/MKC86LA042.md): Cessna 150 · Carlisle, AR · Accident · No injuries · Limited investigation · Final report · Dec 31, 1985 · N4649X · Substantial damage > The student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls… - [NTSB DEN86LA055](https://openairdocs.org/ntsb/DEN86LA055.md): Cessna 172RG · Las Vegas, NM · Accident · No injuries · Limited investigation · Final report · Dec 28, 1985 · N4849V · Substantial damage > According to the plt, he was attempting to depart from a pvt grass strip, which is located on a plateau at an elev of aprx 6,400 MSL. The grass strip, which is aprx 3,000 ft in length, has an upslope of about 10% for the first half and a downslope at about… - [NTSB MIA86LA047](https://openairdocs.org/ntsb/MIA86LA047.md): Piper PA-38-112 · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Dec 22, 1985 · N2569L · Substantial damage > The instructor pilot simulated an engine failure after takeoff. The student pilot failed to lower the airplane nose to maintain flying speed. The instructor took over the controls and lowered the nose, but was unable to avert the hard landing and ensuing… - [NTSB MKC86LA038](https://openairdocs.org/ntsb/MKC86LA038.md): Cessna 140 · Coy, AR · Accident · No injuries · Limited investigation · Final report · Dec 21, 1985 · N3587V · Substantial damage > The pilot reports that the engine of N3587V was run at idle for an extended time before the takeoff was attempted. After several minutes, the engine died. It was restarted and the takeoff was commenced immediately. According to the pilot, the engine was… - [NTSB ATL86LA042](https://openairdocs.org/ntsb/ATL86LA042.md): Cessna 150L · Manning, SC · Accident · No injuries · Limited investigation · Final report · Dec 15, 1985 · N19099 · Substantial damage > During takeoff ground run on the wet grass runway the aircraft hit a soft spot in the runway and nosed over to an inverted attitude. Both the private pilot and passenger escaped without injury. - [NTSB DEN86LA046](https://openairdocs.org/ntsb/DEN86LA046.md): Cessna 206 · Hardin, MT · Accident · No injuries · Limited investigation · Final report · Dec 14, 1985 · N5173U · Destroyed > After ldg to the east on a snow covered dirt rwy, the pilot elected to t/o on an intersecting rwy to the south. He could not see the entire rwy surface from the position due to dwn slope from center of rwy. The acft impacted snowdrifts 40-50 mph on t/o gnd… - [NTSB MIA86LA042](https://openairdocs.org/ntsb/MIA86LA042.md): Beech E-18S · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Dec 13, 1985 · N43T · Substantial damage > The plt stated that while on his takeoff roll, the left main wheel started to shimmy, the acft pulled left then veered off the right side of the rwy, collapsing the tail wheel & coming to rest in the grass. - [NTSB LAX86FA066](https://openairdocs.org/ntsb/LAX86FA066.md): Cessna 150 · Oxnard, CA · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1985 · N7310X · Destroyed > The acft took off, pitched up steeply, stalled, nosed over to the right and crashed, nose down into the grass south of the rwy. Post accident inspection of the acft disclosed that the 2 inch bolt the plt used as a control gust lock for the elevator and… - [NTSB NYC86LA047](https://openairdocs.org/ntsb/NYC86LA047.md): Cessna 172 · East Moriches, NY · Accident · No injuries · Limited investigation · Final report · Dec 4, 1985 · N3530S · Substantial damage > The acft was substantially damaged when it collided with trees during a forced landing following a loss of pwr during a takeoff climb. The plt reported that the pwr loss resulted from carb ice. - [NTSB ATL86LA027](https://openairdocs.org/ntsb/ATL86LA027.md): Cessna 150M · Jacksonville, NC · Accident · No injuries · Limited investigation · Final report · Nov 18, 1985 · N45363 · Substantial damage > During the takeoff phase of a touch & go landing the student plt lost directional control of the acft and ran off the side of the rwy. The student plt was on his third solo training flight. - [NTSB DEN86LA027](https://openairdocs.org/ntsb/DEN86LA027.md): Piper PA-38-112 · Ft. Collins, CO · Accident · No injuries · Limited investigation · Final report · Nov 16, 1985 · N2601G · Substantial damage > The acft collided with large chunks of snow on the rwy during takeoff roll. The plt stated that during the roll about mid-way down the rwy he spotted the snow and decided to abort but was unable to avoid the snow. The left gear contacted the snow and the acft… - [NTSB ATL86LA019](https://openairdocs.org/ntsb/ATL86LA019.md): Piper Aerostar 601P · Sylacauga, AL · Accident · No injuries · Limited investigation · Final report · Nov 6, 1985 · N601PC · Substantial damage > During takeoff ground run the plt lost directional control of the acft which ran off the side of the rwy and into a grove of trees. The plt stated that the right eng lost pwr, however, the eng was test run after the accident and no discrepancies were noted. - [NTSB LAX86LA031](https://openairdocs.org/ntsb/LAX86LA031.md): Piper PA-28-181 · Angwin, CA · Accident · No injuries · Limited investigation · Final report · Nov 3, 1985 · N21491 · 2 aircraft · Minor damage > Near the completion of a dual instructional flt with a pre-solo student, the CFI followed the procedures recommended in the aim 7 & announced his Cessna acft's position over the CTAF stating his intentions & identifying his location on the 45 deg. Entry &… - [NTSB MIA86LA019](https://openairdocs.org/ntsb/MIA86LA019.md): Beech G35 · Destin, FL · Accident · No injuries · Limited investigation · Final report · Oct 26, 1985 · N4275D · Substantial damage > The acft veered off rwy 14 and struck a rwy light and small trees during an attempted x-wind takeoff. The plt stated that he thought the x-wind was from the right, however, the surface winds were reported as 050 at 9 KTS with gusts 12 to 15 KTS, a left x-wind. - [NTSB LAX86LUG01](https://openairdocs.org/ntsb/LAX86LUG01.md): Texas Helicopter M74A · Daggett, CA · Accident · No injuries · Final report · Oct 19, 1985 · N51862 · Substantial damage > The plt stated he had just lifted off for a fertilizer spreading operation with an external load bucket, when the eng had a partial pwr loss at 100 ft AGL. A descent was started and the bucket was disengaged. However, while the plt was attempting to land the… - [NTSB LAX86LA017](https://openairdocs.org/ntsb/LAX86LA017.md): Piper PA-28-140 · Chino Valley, AZ · Accident · No injuries · Limited investigation · Final report · Oct 15, 1985 · N9660W · Substantial damage > When the flt departed prescott for the local flt, the plt said the rwys switched several times between 11 & 03 due to the winds. The official prescott surfact observation reported the winds from 110 degrees at 8 KTS with gusts to 17 KTS. After departing… - [NTSB ATL86LA005](https://openairdocs.org/ntsb/ATL86LA005.md): Hughes 269C · Chapman, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1985 · N7451F · Destroyed > During an attempted takeoff from a field adjacent to a grove of trees the aircraft was unable to climb over the trees and crashed into them. The engine was test run and although it ran rough during initial start up it later operated normally and the reason… - [NTSB ANC86LA013](https://openairdocs.org/ntsb/ANC86LA013.md): Piper PA-18 · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · Oct 8, 1985 · N9960Q · Substantial damage > The acft cartwheeled after dragging the right wing during an attempted takeoff from a gravel strip. The plt reported the takeoff was attempted to the west with a 10 to 15 mph left x-wind. Another person in the area when the accident occurred stated the wind… - [NTSB SEA86LA003](https://openairdocs.org/ntsb/SEA86LA003.md): Cessna 150 · Burton Lake, OR · Accident · No injuries · Limited investigation · Final report · Oct 7, 1985 · N50120 · Substantial damage > The acft failed to become airborne on the soft, short, rough cinder covered airstrip probably due to a combination of density altitude and poor plt technique. The acft struck a berm at the end of the runway where it nosed over. The plt was also departing… - [NTSB LAX86LA005](https://openairdocs.org/ntsb/LAX86LA005.md): Willie II · Blythe, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1985 · N7919 · Substantial damage > On oct 5, 1985 a Willie ii homebuilt crashed on takeoff after its left main landing gear collapsed. VMC existed at the time and no flt plan was filed. The ac sustained substantial damage and the two occupants received minor injuries. The winds were from 050.… - [NTSB ANC86LAG01](https://openairdocs.org/ntsb/ANC86LAG01.md): Cessna 140 · Beluga, AK · Accident · No injuries · Final report · Oct 4, 1985 · N2181N · Substantial damage > The student plt attempted takeoff from am unimproved, overgrown river bed. He stated he paced off the distance availablefor takeoff and it was too short, however, he decided to takeoff anyway. The acft impacted alders and a stream bank just as it was lifting… - [NTSB ANC86LAG03](https://openairdocs.org/ntsb/ANC86LAG03.md): Piper PA-18A-150 · Homer, AK · Accident · No injuries · Final report · Oct 3, 1985 · N3992P · Substantial damage > The landing gear axle failure was due to the oversize tires that were installed on the aircraft. - [NTSB SEA86LA001](https://openairdocs.org/ntsb/SEA86LA001.md): Cessna 172P · Winnemucca, NV · Accident · No injuries · Limited investigation · Final report · Oct 1, 1985 · N53432 · Substantial damage > Directional control was lost during takeoff roll due to a flat nose wheel tire. The aircraft continued to veer to the left of the runway despite the student pilots attempts to correct to the right. The aircraft departed the runway where it nosed over. - [NTSB CHI86LA001](https://openairdocs.org/ntsb/CHI86LA001.md): Cessna 152 · Ravenna, OH · Accident · No injuries · Limited investigation · Final report · Oct 1, 1985 · N5331P · Substantial damage > According to the initial solo stufent pilot, he landed uneventfully, applied takeoff power and reached down to retract the flaps. As the aircraft began to accelerate it began to drift to the left. The student pilot applied right rudder but the aircraft… - [NTSB NYC85LA251](https://openairdocs.org/ntsb/NYC85LA251.md): Piper PA-28-180 · Pittstown, NJ · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1985 · N2335R · Substantial damage > During an attempted takeoff on a 2439 ft rwy, the plt was unable to apply back elevator pressure thus the acft was prevented from becoming airborne. The acft traveled off the end of the rwy where it contacted a fence and trees. Inspection of the acft… - [NTSB ATL85LA287](https://openairdocs.org/ntsb/ATL85LA287.md): Hughes 269A · Winchester, KY · Accident · No injuries · Limited investigation · Final report · Sep 28, 1985 · N9308F · Substantial damage > The accident occurred as the student pilot was attempting to takeoff for hover training. As the pilot was applying collective torque, the student said, he lost control and crashed. There were no system malfunctions or failures reported. - [NTSB LAX85LA406](https://openairdocs.org/ntsb/LAX85LA406.md): Cessna 152 · Concord, CA · Accident · No injuries · Limited investigation · Final report · Sep 25, 1985 · N64981 · Substantial damage > The acft was observed to turn to the left during the takoeff ground roll on rwy 32R at buchanan airport, Concord, California and exit the rwy environment. The certificated private plt reported that shortly after applying full power the acft 'swerved' to the… - [NTSB FTW85LA356](https://openairdocs.org/ntsb/FTW85LA356.md): Cessna 182A · Sanderson, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1985 · N9937B · Substantial damage > On landing, the plt noticed a quantity of brush on the rwy, however, he did not think it would be an obstacle to his intended takeoff and therefore did not remove it. During takeoff, the left main gear struck the brush causing the plt to lose control of the… - [NTSB DEN85LA248](https://openairdocs.org/ntsb/DEN85LA248.md): Piper PA-18 · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 1985 · N7467D · Substantial damage > While practicing touch and go landings the plt added pwr for takeoff and the eng quit. The plt veered the acft to the left to avoid hitting farm machinery and collided with a tree stump. Post accident exam of the eng revealed the eng mostlikely failed as a… - [NTSB SEA85LA223](https://openairdocs.org/ntsb/SEA85LA223.md): Cessna A185F · Eastsound, WA · Accident · No injuries · Limited investigation · Final report · Sep 23, 1985 · N61298 · Substantial damage > During takeoff roll the acft veered right and the plt overcorrected to the left. The acft then departed the rwy to the left striking VASI lights. - [NTSB MIA85FA261](https://openairdocs.org/ntsb/MIA85FA261.md): Aerofab Lake LA-4-250 · Medley, FL · Accident · Serious injuries · Field investigation · Final report · Sep 23, 1985 · N1401K · Substantial damage > The non seaplane rated plt whose airman certificate was under suspension. Attempted a downwind take-off from an intermediate point on the lake's surface. The plt stated he thought the non seaplane rated plt/pax attempted to abort the take-off by closing the… - [NTSB SEA85LA221](https://openairdocs.org/ntsb/SEA85LA221.md): Cessna 170B · Winnemucca, NV · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N1930C · Substantial damage > The plt was attmepting to depart rwy 02 and the wind was from 300 degs at 15 KTS gusting to 20 KTS. Directional control of the acft was not maintained and it veered off the side of the rwy during the takeoff ground run. - [NTSB NYC85LA246](https://openairdocs.org/ntsb/NYC85LA246.md): Piper PA-24-180 · Bayport, NY · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N7505P · Substantial damage > According to the CFI, the student raised the nose of the acft too early during takeoff. This resulted in the acft becoming airborne prematurely. The student was unable to climb out of ground effect and the decision to abort the takeoff was made. The acft… - [NTSB MIA85LA259](https://openairdocs.org/ntsb/MIA85LA259.md): Cessna C-152 · Lantana, FL · Accident · No injuries · Limited investigation · Final report · Sep 19, 1985 · N49873 · 2 aircraft · Substantial damage > The plt stated that he was hovering at an altitude of about three feet. Approximately 100 feet north of the rwy. When an out-of-control Cessna 152 tore off their right landind skid. The helicopter landed safely using a wooden dolly for support of the right… - [NTSB MKC85LA218](https://openairdocs.org/ntsb/MKC85LA218.md): Cessna 210N · Mullen, NE · Accident · No injuries · Limited investigation · Final report · Sep 18, 1985 · N5278A · Substantial damage > The takeoff was being made from a hay meadow that was soft due to recent rains. The property owner said the field was 1/4 mi long. The density alt was calculate to be 5600 ft. the plt said the acft did not attain takeoff speed & that it collided with a fence… - [NTSB LAX85FVA05](https://openairdocs.org/ntsb/LAX85FVA05.md): Beech E-33 · Coalinga, CA · Accident · No injuries · Final report · Sep 16, 1985 · N3493A · Substantial damage > The acft dragged the tail and crashed in a plowed field about 1/4 mile east of the takeoff rwy. The plt said the acft became 'squirrely' on the rwy and went left off the rwydespite her application of rt rudder tracks showed that the acft left rwy after 250 ft… - [NTSB ANC85LA178](https://openairdocs.org/ntsb/ANC85LA178.md): Cessna 180 · Tutna Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N2490C · Substantial damage > The plt elected to takeoff from a lake that was aprx 1/2 mi long & oriented on an east/west heading. During a x-wind takeoff, the plt had difficulty getting the acft to lift off, but elected to continue the takeoff. The acft finally lifted off, but failed to… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=144 ## 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=143 --- 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.