# 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 142 of 281 · 14,038 cases ## Cases, newest first - [NTSB DEN86LA144](https://openairdocs.org/ntsb/DEN86LA144.md): Hispano Aviacion ME109 · Casper, WY · Accident · No injuries · Limited investigation · Final report · May 28, 1986 · N3109 · Substantial damage > During takeoff ground roll on a test flt, the acft left brake failed causing the left main wheel to lock up. The plt lost directional control and the acft departed the left side of the runway where it ground looped. The aircraft was destroyed. The pilot was… - [NTSB MKC86LA118](https://openairdocs.org/ntsb/MKC86LA118.md): Piper PA-28-140 · Bolivar, MO · Accident · No injuries · Limited investigation · Final report · May 26, 1986 · N32143 · Destroyed > The pilot stated he thought he could get airborne from the turf field although it was wet, soft, and muddy. After rolling some distance, he decided he would have to fly through powerlines or trees so he aborted. The airplane ran past the end of the runway,… - [NTSB MKC86LA115](https://openairdocs.org/ntsb/MKC86LA115.md): Cessna A185F · Bernie, MO · Accident · No injuries · Limited investigation · Final report · May 20, 1986 · N1096F · Destroyed > The pilot stated that they were on the takeoff roll when his seat failed and he fell backward away from the flight controls and the throttle. The airplane veered left, off the runway, crossed a small ditch, a road and then impacted in a very large drainage… - [NTSB DEN86FTK02](https://openairdocs.org/ntsb/DEN86FTK02.md): Aero Commander Callair A-9B · Dell Rapids, SD · Accident · No injuries · Final report · May 20, 1986 · N7757V · Substantial damage > The plt stated that during the takeoff roll, he lost rudder effectiveness after accelerating to about 60 KTS. He applied brakes to stop, but the acft veered off the left side of the rwy & struck a fence. No preimpact part failure or malfunction was reported.… - [NTSB NYC86LA130](https://openairdocs.org/ntsb/NYC86LA130.md): Cessna 206 · Greenville, ME · Accident · No injuries · Limited investigation · Final report · May 18, 1986 · N60638 · Destroyed > The pilot experienced problems on takeoff from moosehead lake, but eventually was able to get airborne and fly to the Greenville airport. The aircraft remained on the ground for a few hours, then was preflighted for deparapure. Runway 21 was the favorable… - [NTSB NYC86FA131](https://openairdocs.org/ntsb/NYC86FA131.md): Cessna 414A · Atlantic City, NJ · Accident · 2 fatal · Field investigation · Final report · May 18, 1986 · N414NY · Destroyed > During tkf gnd run, at a speed of 95 KTS, the plt pulled the control wheel back to lift off. The control wheel, according to the plt, would not go back more than about 2 inches; which is less than half the normal full aft travel. The acft reached a speed of… - [NTSB FTW86LA082](https://openairdocs.org/ntsb/FTW86LA082.md): Cessna 150F · San Antonio, TX · Accident · Minor injuries · Limited investigation · Final report · May 18, 1986 · N7902F · Substantial damage > Pilot failed to obtain sufficient airspeed to clear the trees at the end of the runway. The runway was soft and there was a left crosswind. - [NTSB MIA86LA163](https://openairdocs.org/ntsb/MIA86LA163.md): Cessna 152 · Naples, FL · Accident · No injuries · Limited investigation · Final report · May 17, 1986 · N69133 · Substantial damage > The plt stated that during the takeoff portion of a touch and go landing he lost directional control of the acft. The acft veered left off the rwy, struck a ditch and the landing gear collapsed. - [NTSB LAX86LA224](https://openairdocs.org/ntsb/LAX86LA224.md): Cessna 152 · Tonopah, AZ · Accident · Minor injuries · Limited investigation · Final report · May 17, 1986 · N714UL · Destroyed > The acft collided with a truck during takeoff ground run from an interstate. The plt indicated the acft had run out of fuel on the x-country flt and he had not refueled at the departure point. He landed on the interstate without incident and sent his pax for… - [NTSB CHI86MA142](https://openairdocs.org/ntsb/CHI86MA142.md): Mcdonnell Douglas DC-9-31 · Chicago, IL · Incident · No injuries · Major investigation · Final report · May 17, 1986 · N973VJ · 2 aircraft · Minor damage > U.S. Air flight 373 passed over American airlines flight 695 at the intersection of runways 32R and 4L while both aircraft were taking off. Both aircraft had been cleared for takeoff by the local controller at o'hare tower. The aircraft came within twenty… - [NTSB MKC86LA106](https://openairdocs.org/ntsb/MKC86LA106.md): Cessna 188 · Lawrence, KS · Accident · No injuries · Limited investigation · Final report · May 11, 1986 · N5531S · Substantial damage > The pilot stated that the right main tire rolled over sharp rocks and was subsequently destroyed during the takeoff roll. The pilot further stated that he apparently over corrected and drifted left, digging into a soft spot on the runway, and nosed over. - [NTSB NYC86LA124](https://openairdocs.org/ntsb/NYC86LA124.md): Cessna 305A · Salem, NH · Accident · No injuries · Limited investigation · Final report · May 10, 1986 · N16576 · Substantial damage > The Cessna 305, being used a tow plane for glider operations, ran through a fence at the departure end of the rwy during takeoff. The plt stated he experienced a wind shift during takeoff. He did not have a pre-decided point at which to either release the… - [NTSB CHI86LA139](https://openairdocs.org/ntsb/CHI86LA139.md): Taylorcraft DC-65 · Plainwell, MI · Accident · No injuries · Limited investigation · Final report · May 10, 1986 · N48102 · Substantial damage > While departing to the north in light wind conditions, the pilot made a decision to abort the takeoff, then realized he would not be able to stop on the remaining runway. He attempted to continue the takeoff. He zoomed the aircraft to clear wires in his path,… - [NTSB FTW86LA088](https://openairdocs.org/ntsb/FTW86LA088.md): Cessna 337D · Edinberg, TX · Accident · No injuries · Limited investigation · Final report · May 9, 1986 · N337D · Substantial damage > The pilot stated he lost both engines while in cruise flight. However, no evidence of engine malfunction was found during the investigation. The pilot is under investigation for illegal drug trafficking. A dea agent suspects the pilot had unloaded his cargo… - [NTSB DEN86LA130](https://openairdocs.org/ntsb/DEN86LA130.md): Cessna A188B · Berino, NM · Accident · No injuries · Limited investigation · Final report · May 9, 1986 · N4491Q · Substantial damage > The pilot reports that he was taking off on his third aerial app flt of the day. He said the wind was from the nw and very light and he was departing to the n. the density alt was calculated to be 5,200 ft. acceleration seemed to be normal until about two… - [NTSB LAX86LA211](https://openairdocs.org/ntsb/LAX86LA211.md): Bell 47G-5A · Agana · Accident · 1 fatal · Limited investigation · Final report · May 6, 1986 · N2996W · Destroyed > The helicopter crashed into the ocean when the plt attempted to lift off from a tuna boat. Reportedly, only three of the four tiedown ropes, which had secured the helicopter to the boat, had been released. The plt's medical certificate was dated 1/18/84. - [NTSB ANC86LA052](https://openairdocs.org/ntsb/ANC86LA052.md): Consolidated-Vultee L-13 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · May 2, 1986 · N2536B · Substantial damage > During the takeoff roll the pilot lost control of the aircraft, the acft exited the runway and rolled over on its right side. The inspection of both tailwheel and tailwheel assembly revealed very loose cables between the locking handle and the tailwheel. At… - [NTSB NYC86LA115](https://openairdocs.org/ntsb/NYC86LA115.md): Cessna 150 · Woodstock, CT · Accident · No injuries · Limited investigation · Final report · Apr 28, 1986 · N3235V · Substantial damage > The student pilot in a Cessna 150 was making a touch and go. He raised the flaps and then added power. He looked over to see if the flaps were retracting and when he looked straight ahead the left wheel was off the runway in soft terrain. He reduced power and… - [NTSB SEA86LA114](https://openairdocs.org/ntsb/SEA86LA114.md): Eiriavion PIK 20-D · Minden, NV · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N6VS · Substantial damage > The cockpit canopy opened during takeoff roll. The glider became airborne and climbed to an alt of aprx 10 ft AGL before descending to ground impact in a nose low attitude. - [NTSB ANC86LA050](https://openairdocs.org/ntsb/ANC86LA050.md): Interstate 15B2 · Port Heiden, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 1986 · N64AT · Substantial damage > The pilot stated that during the takeoff roll he lost control of the aircraft causing the plane to nose over on its back. - [NTSB LAX86LA184](https://openairdocs.org/ntsb/LAX86LA184.md): Cessna 310N · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Apr 21, 1986 · N4162Q · Substantial damage > The acft overran the rwy during an aborted takeoff. The plt had flown the acft the day prior on his bfr and conducted a 'thorough preflight' insp. On the day of the accident, he preflighted the acft again and flew it without incident. He then refueled the… - [NTSB CHI86FER05](https://openairdocs.org/ntsb/CHI86FER05.md): Cessna A188B · Greenbush, MN · Accident · Serious injuries · Final report · Apr 21, 1986 · N9220R · Substantial damage > The plt reported that the acft contacted a soft spot, caused by recent rains, in the sod runway during takeoff. The acft decelerated, however, the plt attempted to continue the takeoff as not enough runway remained to abort. The acft did not obtain sufficient… - [NTSB MKC86LA090](https://openairdocs.org/ntsb/MKC86LA090.md): Cessna 172D · Garden Grove, IA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1986 · N2502Y · Substantial damage > The plt stated that he was attempting a no-flap takeoff from his pvt strip when the wheels hit a wet spot. He said that the acft slowed down but he extended flaps and continued the takeoff. When he saw that he was running out of rwy, he aborted the takeoff… - [NTSB ATL86LA108](https://openairdocs.org/ntsb/ATL86LA108.md): Cessna 172L · Charlotte, NC · Accident · Serious injuries · Limited investigation · Final report · Apr 8, 1986 · N2851Q · Destroyed > During the attempted takeoff the acft skipped, climbed a few feet, settled to the ground then climbed again before the plt attempted to abort the takeoff. The acft overran the end of the rwy, crossed a road and hit a ditch and nosed over. An estimated weight… - [NTSB NYC86LA100](https://openairdocs.org/ntsb/NYC86LA100.md): Aerospatiale SA316B · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1986 · N2354 · Substantial damage > The pilot-in-command lifted off the helipad vertically to an altitude of 30 feet at which time he experienced a power loss. He backed up the helicopter 20 feet and allowed it to yaw to the right as it descended to the helipad. He landed on the helipad hard… - [NTSB LAX86LA165](https://openairdocs.org/ntsb/LAX86LA165.md): Piper PA-38-112 · Novato, CA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1986 · N91301 · Substantial damage > A PA-38 lost directional control during a takeoff with both the student and instructor pilot at the controls. The aircraft sustained substantial damage but both pilots were uninjured. The wind was 90 degrees crosswind at 10 knots gusting to 15 knots. The… - [NTSB FTW86LA057](https://openairdocs.org/ntsb/FTW86LA057.md): Cessna 185F · Point Aufer, LA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1986 · N1867Q · Substantial damage > The pilot reported losing control of his aircraft, during takeoff from a canal at Point Aufer island, LA, when gusty wind conditions lifted a wing, causing the aircraft to collide with a bank. After the collision, the aircraft continued up onto the canal… - [NTSB LAX86LA163](https://openairdocs.org/ntsb/LAX86LA163.md): Cessna 150M · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Apr 3, 1986 · N7563U · Substantial damage > The student's CFI said that a dual session was flown earlier in the morning and that the accident session was the student's first supervised solo. The CFI said that on the first landing of the accident flight, the aircraft touched down on the left main gear… - [NTSB SEA86LA086](https://openairdocs.org/ntsb/SEA86LA086.md): Maule M5-180C · Sand Point, ID · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 1986 · N119JC · Substantial damage > While attempting to take off in strong gusty crosswinds, the plt lost control of the acft. The acft veered off the rwy, struck a fence post, and nosed over inverted. The reported winds at coeur d'alene, ID, 33 nmi ssw of Sand Point, were reported as being… - [NTSB NYC86LA095](https://openairdocs.org/ntsb/NYC86LA095.md): Cessna 152 · Pittsfield, MA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1986 · N49107 · Substantial damage > The Cessna 152 was making a touch and go. The student pilot reported the landing was good and when he applied power, the aircraft veered left off the runway, struck a ditch and flipped over. The pilot was uninjured and the aircraft received substantial… - [NTSB FTW86LA052](https://openairdocs.org/ntsb/FTW86LA052.md): Luscombe 8A · Houston, TX · Accident · No injuries · Limited investigation · Final report · Mar 29, 1986 · N71611 · Substantial damage > A flight instructor was showing his student how to takeoff from a crass strip when he noticed another aircraft taking off on an intersecting runway. He elected to abort the takeoff, and the aircraft collided with a ditch, damaging the main gear, left wing and… - [NTSB LAX86LA154](https://openairdocs.org/ntsb/LAX86LA154.md): Cessna 150H · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 1986 · N22613 · Substantial damage > A Cessna 150 collided with terrain during a takeoff from a road. The student plt indicated he was practicing aerial maneuvers in the training area when the engine quit. He successfully accomplished a power off landing to an asphalt road. A certified mechanic… - [NTSB LAX86DVA04](https://openairdocs.org/ntsb/LAX86DVA04.md): Glen Davis Glasair · Chinese Camp, CA · Accident · 1 fatal · Final report · Mar 23, 1986 · N84GD · Destroyed > A glasair homebuilt aircraft collided with a barn shortly after takeoff on a night time business trip. The aircraft departed from the extreme left side of the runway which had a high growth of vegetation. The aircraft was observed to be about 40 to 50 ft… - [NTSB CHI86FEE01](https://openairdocs.org/ntsb/CHI86FEE01.md): Cessna 172 · Marseilles, IL · Accident · Minor injuries · Final report · Mar 23, 1986 · N97266 · Substantial damage > The takeoff was being made from an arpt which is on the grounds of a golf course. During takeoff the nose wheel struck the raised terrain of a golf tee located aprx 75 ft left of the rwy 18 centerline and 1000 ft from the departure end of the rwy. The plt… - [NTSB NYC86LA087](https://openairdocs.org/ntsb/NYC86LA087.md): Piper PA-28-161 · Hartford, CT · Accident · No injuries · Limited investigation · Final report · Mar 22, 1986 · N4347G · Substantial damage > The cross country solo flight was taking off on runway 02 at Hartford, Connecticut. The pilot performed a runup and was cleared for takeoff. The pilot attempted rotation at about 60 KIAS, but aircraft did not lift off. Trim tab was set at neutral on runup. As… - [NTSB ANC86LA038](https://openairdocs.org/ntsb/ANC86LA038.md): Cessna 180J · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 21, 1986 · N46362 · Substantial damage > The pilot stated that during the takeoff roll he added power too fast for the takeoff. The pilot failed to compensate with rudder. - [NTSB FTW86LA042](https://openairdocs.org/ntsb/FTW86LA042.md): Cessna 172N · Marietta, OK · Accident · No injuries · Limited investigation · Final report · Mar 15, 1986 · N7576G · Substantial damage > During takeoff roll, at about 45 knots ground speed, the left main landing gear contacted a water eroded spot on the runway. The aircraft bounced and/or was pulled off the ground without sufficient speed to maintain flight. The aircraft settled and struck a… - [NTSB ATL86LA096](https://openairdocs.org/ntsb/ATL86LA096.md): Cessna 172K · Stone Mountain, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 15, 1986 · N7374G · Substantial damage > Shortly after taking off at ngt, the plt encountered low visibility (vis) in fog. He attempted to return to the arpt for lndg, but the acft crashed in a wooded area aprx 3/4 mi from the arpt. A check of the plt's blood showed an alcohol lvl of 0.17 grams… - [NTSB SEA86LA076](https://openairdocs.org/ntsb/SEA86LA076.md): Beech 18 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1986 · N926T · Substantial damage > The pilot lost control of the aircraft on takeoff and a subsequent groundloop occurred. Although the pilot has a DC-3 type rating, he had only 20 hours in this aircraft. - [NTSB MKC86LA067](https://openairdocs.org/ntsb/MKC86LA067.md): Aeronca 7AC · Jacksonville, AR · Accident · No injuries · Limited investigation · Final report · Mar 10, 1986 · N82202 · Substantial damage > The pilot was attempting a takeoff from a sod strip in an Aeronca tail dragger aircraft in gusty wind conditions. The air strip runway is situated along a north-south heading with the rptd winds fm 290 degrees magnetic at 13 knots with gusts to 18 knots. As… - [NTSB SEA86LA070](https://openairdocs.org/ntsb/SEA86LA070.md): Cessna 172 · American Falls, ID · Accident · No injuries · Limited investigation · Final report · Mar 3, 1986 · N6486J · Substantial damage > The student pilot was attempting to make a touch and go, when the aircraft veered to the left of the runway and struck an embankment. The student failed to use enough right rudder to maintain directional control. The runway's width is 50 feet. - [NTSB NYC86LA078](https://openairdocs.org/ntsb/NYC86LA078.md): Cessna 152 · Nashua, NH · Accident · No injuries · Limited investigation · Final report · Feb 24, 1986 · N303DW · Substantial damage > The student pilot was performing touch and go landings at boire field when he applied power to takeoff, he was distracted by the flap control setting. During this distraction the aircraft drifted to the left. Full right rudder was used in an attempt to… - [NTSB FTW86LQA01](https://openairdocs.org/ntsb/FTW86LQA01.md): Cessna 152 · El Paso, TX · Accident · Minor injuries · Final report · Feb 24, 1986 · N67888 · Substantial damage > The acft went off the rwy and nosed over in the rough sand. The plt said that she looked into the cockpit to locate the flap switch to raise the flaps for a running takeoff. Power had already been added and the acft started to the left by the time the plt… - [NTSB DEN86FA080](https://openairdocs.org/ntsb/DEN86FA080.md): Boeing 737-300 · Denver, CO · Accident · No injuries · Field investigation · Final report · Feb 20, 1986 · N17309 · Substantial damage > F/o was on the 3rd initial operating experience flt with a check airman. Capt and f/o had discussed rapid rate of rotation on previous flts and again on accident flt. The f/o performed the takeoff from Denver and exceeded rotation rate of 3 degrees per sec.… - [NTSB FTW86LQG08](https://openairdocs.org/ntsb/FTW86LQG08.md): Wayne Mathews Glas AIR SH2R · Ranger, TX · Accident · No injuries · Final report · Feb 17, 1986 · N9660N · Substantial damage > The acft drifted left off the rwy during takeoff and collided with trees. This was a home built acft that had just been certified. The owner/builder had made high speed taxi runs but did not feel comfortable to fly it. Another plt was asked and after a short… - [NTSB CHI86LA087](https://openairdocs.org/ntsb/CHI86LA087.md): Cessna 340A · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Feb 16, 1986 · N2743Y · Substantial damage > According to the plt the left eng lost pwr at rotation. He could then not correct the left ground track deviation with right rudder. To avoid obstacles at the edge of the rwy he pulled the acft off the ground but the acft soon settled back down, sustaining… - [NTSB SEA86LA057](https://openairdocs.org/ntsb/SEA86LA057.md): Cessna 172 · Renton, WA · Accident · No injuries · Limited investigation · Final report · Feb 12, 1986 · N739UW · Substantial damage > The pilot failed to maintain directional control during takeoff. Although a crosswind from the left was present the pilot lost control for unknown reasons to the left, crossing the taxiway and then striking a parked vehicle and building. No mechanical reason… - [NTSB LAX86FA114](https://openairdocs.org/ntsb/LAX86FA114.md): Naval Aircraft Factory N3N-3 · Middletown, CA · Accident · 2 fatal · Field investigation · Final report · Feb 8, 1986 · N45105 · Destroyed > The acft departed the privately owned dirt strip on a sales demonstration flt. The PIC occupied the rear seat and the prospective buyer occupied the front seat. Shortly after departing the eng began to run rough. The acft entered into a course reversal turn.… - [NTSB DEN86FA076](https://openairdocs.org/ntsb/DEN86FA076.md): Cessna T-210M · Albuquerque, NM · Accident · Serious injuries · Field investigation · Final report · Feb 8, 1986 · N210TA · Destroyed > The plt took off on the 13,373 foot rwy in IMC conditions on an IFR flt plan. The arpt control twr controller observed the acft at midfield after takeoff, emitting black smoke and informed the plt. The plt requested and was cleared for landing. The acft was… - [NTSB MKC86LA056](https://openairdocs.org/ntsb/MKC86LA056.md): Piper PA-38-112 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Jan 31, 1986 · N25735 · Substantial damage > The student pilot stated he was on the takeoff roll for a practice flight when he lost directional control and ran off the left edge of the runway and stayed there until it impacted a taxi/intersection sign. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=143 ## 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=142 --- 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.