# NTSB investigations: Initial climb 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 175 of 412 · 20,559 cases ## Cases, newest first - [NTSB ANC86LA124](https://openairdocs.org/ntsb/ANC86LA124.md): Piper PA-32-300 · Tyonek, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1986 · N1491X · Substantial damage > The pilot stated that during the initial climb, the aircraft started to settle. The pilot stalled and crashed into a wooded area at the departure end of the runway. - [NTSB LAX86DVA13](https://openairdocs.org/ntsb/LAX86DVA13.md): Bell 47G-4A · Shafter, CA · Accident · No injuries · Final report · Aug 8, 1986 · N1185W · Substantial damage > Shortly after departing the loading rig, en route to an agricultural aerial application operation, the forward coupling tail rotor drive shaft failed. The helicopter was about 10 ft above ground level and about 100 ft west of the loading rig. The pilot… - [NTSB DEN86LA227](https://openairdocs.org/ntsb/DEN86LA227.md): Hughes 369D · Clark, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1986 · N1110Z · Substantial damage > After the accident the pltstated that he was departing from a landing zone that was surrounded by tall trees. He also stated that after liftoff, as the helicopter climbed above the trees the wind either shifted direction or stopped and the helicopter began to… - [NTSB SEA86FA194](https://openairdocs.org/ntsb/SEA86FA194.md): Cessna 310C · Vancouver, WA · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1986 · N310MT · Destroyed > Plt not IFR rated. Attempted departure from own airstrip in fog during early dawn. Positive rate of climb not established. Acft contacted terrain 3/4 mile from runway end. Psgrs reported no sensation of power probs, but complete loss of ground ref at liftoff.… - [NTSB NYC86LA200](https://openairdocs.org/ntsb/NYC86LA200.md): Piper PA-38-112 · Grove City, PA · Accident · No injuries · Limited investigation · Final report · Aug 5, 1986 · N91356 · Substantial damage > The instructor plt (CFI) rprtd that shortly after takeoff, after climbing out of gnd effect, the acft seemed to lvl off & stop climbing. He took control fm the student & proceeded to check the instruments, but no specific abnormality was determined. He… - [NTSB NYC86LA198](https://openairdocs.org/ntsb/NYC86LA198.md): Piper PA-38-112 · Farmingdale, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1986 · N9359T · Substantial damage > The Piper PA-38-112 had just taken off and was on crosswind when it experienced a power loss. The pilot landed in a cemetary and both the pilot and passenger received minor injuries. The aircraft received substantial damage. Examination of the acft revealed… - [NTSB MIA86LA228](https://openairdocs.org/ntsb/MIA86LA228.md): Continental Copters Tomcat MK5A · Indiantown, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1986 · N9086T · Substantial damage > The aerial application helicopter crashed just after lift-off after sustaining a power failure, the plt stated that he thought the reason for the failure could have been fuel starvation since he had observed some foreign matter in the fuel when he drained the… - [NTSB SEA86LA192](https://openairdocs.org/ntsb/SEA86LA192.md): Cessna 185FII · Reno, NV · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1986 · N185M · Destroyed > Plt attempted takeoff with acft 540 pounds over max cert wt and 8500 ft density altitude conditions. Acft became airborne but positive climb and airspeed increase not possible. Plt turned to avoid obstructions, putting acft into semi-controlled collision with… - [NTSB NYC86FA196](https://openairdocs.org/ntsb/NYC86FA196.md): Grumman TBM-3E · Brooklyn, CT · Accident · 1 fatal · Field investigation · Final report · Aug 4, 1986 · N6581D · Destroyed > The acft was being flown to the owner's residence when the accident occurred. Shortly after takeoff black and white smoke was observed emitting from the eng cowling and the eng was heard sputtering. According to witnesses, the acft leveled off at an alt of… - [NTSB CHI86FEM13](https://openairdocs.org/ntsb/CHI86FEM13.md): Piper PA-28-140 · Menominee, MI · Accident · Minor injuries · Final report · Aug 4, 1986 · N4394J · Substantial damage > The acft lost eng pwr shortly after takeoff. The plt attempted to land back on the rwy but ran off the end into a ditch. The reason for the power loss could not be determined. - [NTSB NYC86LA193](https://openairdocs.org/ntsb/NYC86LA193.md): Piper PA-60-601P · Lancaster, PA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1986 · N9531Q · Substantial damage > The Piper PA-60 Aerostar was making a takeoff with five passengers on board. The PIC did not establish any procedures with his co-pilot prior to the takeoff. The aircraft continued off the 4100 ft runway to the overrun finally becoming airborne. The co-pilot… - [NTSB MIA86LA227](https://openairdocs.org/ntsb/MIA86LA227.md): Piper PA-28-180 · Zellwood, FL · Accident · No injuries · Limited investigation · Final report · Aug 3, 1986 · N9716J · Substantial damage > The flt sustained eng failure immediately after lift-off & collided with a tree near the end of the rwy. The plt stated that the take-off roll had been 'sluggish'. He said that it was his practice to keep his acft outdoors & to only fuel the tanks to about… - [NTSB CHI86LA195](https://openairdocs.org/ntsb/CHI86LA195.md): Piper J-3 · Peoria, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 1986 · N40761 · Destroyed > The plt reported that the acft stalled on takeoff, control was lost and the acft descended to impact with the terrain. - [NTSB CHI86FEV04](https://openairdocs.org/ntsb/CHI86FEV04.md): Pate Quickie · Danville, IL · Accident · Minor injuries · Final report · Aug 3, 1986 · N24RP · Substantial damage > After performing hi speed taxi tests, the plt of a new home built acft took off on the acft's 1st flt. After taking off,he realized something was wrong; however, by then, the acft was past the dep end of the rwy at 50 to 75 ft AGL & would not climb any… - [NTSB MKC86LA165](https://openairdocs.org/ntsb/MKC86LA165.md): Grumman G-164A · Hugoton, KS · Accident · No injuries · Limited investigation · Final report · Aug 2, 1986 · N8677H · Substantial damage > The PIC stated that the eng quit on takeoff abt 100 feet abv the gnd and 200 yds past the departure end of the rwy. The PIC stated that he had no warning prior to the engine quitting. The acft dscnd to the gnd, impacted hard and subsequently flipped over… - [NTSB SEA86LA186](https://openairdocs.org/ntsb/SEA86LA186.md): Cessna 210 · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Aug 1, 1986 · N1782X · Substantial damage > The pilot reported that he struck a post on take-off and broke off the main landing gear wheel. The pilot proceeded to Hillsboro, Oregon where an emergency landing was made on a paved runway with the landing gear still extended. The stub caught in the runway… - [NTSB SEA86FA211](https://openairdocs.org/ntsb/SEA86FA211.md): Schweizer SGS-2-33 · Toledo, WA · Accident · Serious injuries · Field investigation · Final report · Aug 1, 1986 · N5720S · Substantial damage > The weak link at the tow vehicle broke during launching. The plt lowered the nose of the acft and turned into the wind. The plt stated that the acft was stalled and that he was unable to stop the descent rate. The acft struck the runway in a slight nose down… - [NTSB CHI86FEP08](https://openairdocs.org/ntsb/CHI86FEP08.md): North American T28D-FENNEC · Madison, WI · Accident · Minor injuries · Final report · Aug 1, 1986 · N128RM · Substantial damage > After the aircraft was initally taxied for takeoff, the pilot returned to the ramp and stated that he was experiencing engine problems. He inquired at an FBO about chartering an aircraft to take himself and his son to an experimental aircraft association… - [NTSB SEA86LA181](https://openairdocs.org/ntsb/SEA86LA181.md): Cessna 152 · Snohomish, WA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1986 · N6509L · Substantial damage > The student was attempting to depart with a quartering tailwind. The aircraft was veering to the left of the centerline and the pilot rotated prematurely. The aircraft settled back to the ground to the left of the runway onto uneven terrain. At the time of… - [NTSB MKC86LA162](https://openairdocs.org/ntsb/MKC86LA162.md): Aero Commander S-2R · Dumas, AR · Accident · No injuries · Limited investigation · Final report · Jul 28, 1986 · N5694X · Destroyed > The pilot stated that after takeoff, during initial climb, he heard grinding metal and smelled hot metal before the engine slowed down and seized. After crash landing in a corn field, the pilot further stated, he noticed smoke coming from the engine… - [NTSB CHI86FA183](https://openairdocs.org/ntsb/CHI86FA183.md): American AA-1 · Plainfield, IL · Accident · 1 fatal · Field investigation · Final report · Jul 28, 1986 · N6135L · Destroyed > Witnesses who spoke with plt of N6135L prior to accident stated that he was acting out of character. He had a loss of appetite and his complexion was ashen grey. The plt stated that he did not feel well before the flt. Witnesses observed the acft takeoff,… - [NTSB MKC86LA158](https://openairdocs.org/ntsb/MKC86LA158.md): Grumman AA-5A · Audubon, IA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N9835U · Substantial damage > The pilot stated that the engine was developing full power during the brake release and takeoff roll but that the aircraft would not accelerate to lift-off speed as fast as expected. Upon reaching 70 m.p.h.(61 KTS.), and after a takeoff roll of 2,000 feet,… - [NTSB DEN86FA211](https://openairdocs.org/ntsb/DEN86FA211.md): Steven Soper Pitts S-1T · Shelby, MT · Accident · Serious injuries · Field investigation · Final report · Jul 27, 1986 · N155NK · Destroyed > During initial climb after takeoff from a private ranch airstrip, the acft engine quit. The plt had inadvertently left the fuel selector switch in the no. 2 position which allowed oil, normally used to produce smoke during aerial demonstrations, to enter the… - [NTSB BFO86FID10](https://openairdocs.org/ntsb/BFO86FID10.md): Quickie Q200 · Newport News, VA · Accident · 1 fatal · Final report · Jul 27, 1986 · N45CX · Destroyed > The acft went out of control and crashed from aprx 100 AGL after takeoff. The acft was on a test flt and after the crash the plt said that the acft was pulling to the rt during takeoff so he reduced power. The acft continued to pull rt before nosing down to… - [NTSB ANC86FA114](https://openairdocs.org/ntsb/ANC86FA114.md): Interstate S-1B2 · Wasilla, AK · Accident · 2 fatal · Field investigation · Final report · Jul 27, 1986 · N51AA · Substantial damage > Witnesses rprtd that immediately after taking off from the Wasilla lake seaplane base, the acft entered a steep climbing turn. Shortly thereafter, it entered a steep dscnt & crash into the water. There was evidence that the acft entered a stall/spin prior to… - [NTSB NYC86LA187](https://openairdocs.org/ntsb/NYC86LA187.md): Grumman AA-5A · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1986 · N333TE · Destroyed > Shortly after takeoff, the aircraft was unable to continue climb out. The pilot lowered the nose to level flight, however the airspeed continued to drop and the aircraft crashed. The continued drop in the airspeed was undetermined. - [NTSB CHI86LA181](https://openairdocs.org/ntsb/CHI86LA181.md): Piper PA-38-112 · Middleton, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1986 · N2444N · Substantial damage > The CFI and student had been practicing touch-and-go's and had just made a full stop landing. The CFI reported that during a subsequent soft field takeoff, accelleration seemed a little slow, and after lift-off, the aircraft seemed to stop accelerating… - [NTSB MKC86LA157](https://openairdocs.org/ntsb/MKC86LA157.md): Randolph R.Clark KR-2 · Russell, KS · Accident · No injuries · Limited investigation · Final report · Jul 25, 1986 · N151RC · Substantial damage > The pilot had just completed some adjustments to the carburetor and was making a high-speed taxi test when he became airborne. He applied more power to avoid stalling and immediately thereafter, the engine started running rough. He then decided to make a… - [NTSB DEN86FA207](https://openairdocs.org/ntsb/DEN86FA207.md): Cessna 140 · Taos, NM · Accident · Serious injuries · Field investigation · Final report · Jul 25, 1986 · N76541 · Substantial damage > N76541 took off on rwy 04 on a high density altitude day. The acft was seen climbing with the nose high near the departure end of the rwy. The acft just cleared some electrical lines near the end of the rwy and then was observed to descend down to a height… - [NTSB MKC86LA155](https://openairdocs.org/ntsb/MKC86LA155.md): Schweizer G-164B · Harrisburg, AR · Accident · No injuries · Limited investigation · Final report · Jul 23, 1986 · N8494K · Substantial damage > The aerial application airplane was departing from a short strip on a hot day. The pilot said the airplane would not climb and he was forced to put it down in a flooded rice field where it nosed forward to the inverted position. The pilot stated he should… - [NTSB NYC86LA189](https://openairdocs.org/ntsb/NYC86LA189.md): Schweizer SGS-2-33A · Plymouth, MA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1986 · N33985 · Substantial damage > Shortly after takeoff, the tow was released from the glider when its nose started rising uncontrollably. The glider thencollided with the ground & was substantially damaged. The plt rprted the accident could have been avoided by more info &emphasis on the… - [NTSB SEA86FA174](https://openairdocs.org/ntsb/SEA86FA174.md): Weiss-Haynes Stits SA6B · Big Creek, ID · Accident · 1 fatal · Field investigation · Final report · Jul 20, 1986 · N3HW · Destroyed > N3HW, a stits SA6B, was being flown from an airstrip with a density altitude of about 7,800 feet. The plt lost control of the acft during initial climb and the acft descended into the trees, struck the ground, and caught fire. The plt stated that during… - [NTSB NYC86LA191](https://openairdocs.org/ntsb/NYC86LA191.md): Bell 47G-5A · Portland, CT · Accident · No injuries · Limited investigation · Final report · Jul 20, 1986 · N59400 · Substantial damage > While climbing, shortly after takeoff, the eng quit for undetermined reasons. The pilot autorotated into a sand bank where the helicopter received substantial damage. - [NTSB MIA86FA216](https://openairdocs.org/ntsb/MIA86FA216.md): Beech V35 · Tampa, FL · Accident · 3 fatal · Field investigation · Final report · Jul 20, 1986 · N3872N · Destroyed > The private pilot transmitted to the contrl tower shortly after lift off that he had a door ajar, and he was turning back to the runway. Witnesses saw the aircraft execute a teardrop type of turn back to the runway with a nose high attitude, gear down and in… - [NTSB FTW86LA134](https://openairdocs.org/ntsb/FTW86LA134.md): Aeronca 7AC · Plano, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 20, 1986 · N83847 · Substantial damage > The pilot tried twice to rotate the aircraft before it lifted off at approximately 800 feet down the runway. At 100 feet above the ground, the aircraft started veering to the west side of the runway in a nose high attitude, stalled and nosed down impacting… - [NTSB DEN86LA203](https://openairdocs.org/ntsb/DEN86LA203.md): Rotec Panther II Plus · Sundance, WY · Accident · No injuries · Limited investigation · Final report · Jul 20, 1986 · N990RE · Substantial damage > The plt said that on the first flight of N990RE, the vehicle revealed some undesirable flt control characteristics. He said that after landing he installed both doors and then attempted another take off. It was shortly after take off that the plt lost control… - [NTSB CHI86FEM11](https://openairdocs.org/ntsb/CHI86FEM11.md): Cessna 150E · Muskegon, MI · Accident · Serious injuries · Final report · Jul 20, 1986 · N4072U · Substantial damage > The plt rprtd that drg takeoff, the acft lifted off at about the midpoint of the rwy & climbed to just above treetop level. He turned the acft slightly into the wind, then noted that it seem to lose the ability to climb further. The stall warning horn sounded… - [NTSB FTW86FA133](https://openairdocs.org/ntsb/FTW86FA133.md): Cessna 421 · Addison, TX · Accident · 4 fatal · Field investigation · Final report · Jul 19, 1986 · N6VR · Destroyed > Witnesses reported a normal takeoff and climb was made to an alt of aprx 400 ft AGL at which time eng pwr ceased/ decreased. The rt wing then dropped, the nose and lt wing rose and the acft entered a near vertical descent to ground impact. Post accident exam… - [NTSB MIA86LA210](https://openairdocs.org/ntsb/MIA86LA210.md): Beech 35 · Plymouth, FL · Accident · No injuries · Limited investigation · Final report · Jul 16, 1986 · N417B · Substantial damage > The plt lost control of the acft when it rotated early due to the elevator trim tab being set at four notches nose up. The acft then stalled & landed hard collapsing the landing gear. The plt failed to use a checklist. - [NTSB CHI86FEC05](https://openairdocs.org/ntsb/CHI86FEC05.md): Jerry Berry MONO-FLY · Blissfield, MI · Accident · No injuries · Final report · Jul 15, 1986 · N84JL · Substantial damage > The acft was damaged in a forced lndg after a power loss at 200 ft AGL. The plt/owner had an ignition problem with the eng quitting in flt. After ground checks & repairs the eng was ground run successfully but during test flt it quit again. An attempt was… - [NTSB ATL86FEI08](https://openairdocs.org/ntsb/ATL86FEI08.md): Fairchild 24R-46 · Canton, OH · Accident · Serious injuries · Final report · Jul 15, 1986 · N77670 · Substantial damage > The plt reported that he was taking off after making a touch and go ldg; as he 'pushed (the) throttle forward on lift-off (the) engine began to quit'. The engine subsequently quit altogether at about 200-300 feet AGL over the departure end of the rwy.… - [NTSB MKC86LA150](https://openairdocs.org/ntsb/MKC86LA150.md): Stainbrook Avid Flyer · Salina, KS · Accident · No injuries · Limited investigation · Final report · Jul 14, 1986 · N146AF · Substantial damage > The PIC had been practicing touch and go landings at a private air strip. At 50 feet AGL the PIC stated the engine quit and he descended into the ground off the rwy. Post accident inspection of the eng revealed that the propeller reduction gearing had broken… - [NTSB DEN86LA197](https://openairdocs.org/ntsb/DEN86LA197.md): Cessna A150N · Akron, CO · Accident · No injuries · Limited investigation · Final report · Jul 14, 1986 · N757GH · Substantial damage > The plt stated the acft he was piloting encountered a severe downdraft during initial climbout, which forced the acft to the ground. Upon ground contact, the acft nosed over onto its back. - [NTSB CHI86FA170](https://openairdocs.org/ntsb/CHI86FA170.md): Grumman AA5B · Benton Harbor, MI · Accident · Serious injuries · Field investigation · Final report · Jul 14, 1986 · N81259 · Destroyed > The aircraft departed on runway 09. Passenger remembers the pilot starting to turn back to the airport when the wings went perpendicular to the horizon and the ground came rushing up. Teardown of the engine revealed a bent push rod and a split push rod shroud… - [NTSB LAX86LA290](https://openairdocs.org/ntsb/LAX86LA290.md): Cessna 195B · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · N195JB · Substantial damage > The airplane departed montgomery airport, runway 28L, San Diego, CA. Shortly after departing a fire erupted in the upper cowling area. The pilot executed an emergency landing on runway 05, but landed hard. Examination of the wreckage disclosed the number 2… - [NTSB FTW86LA128](https://openairdocs.org/ntsb/FTW86LA128.md): Cessna U-206G · Decker'S Island, TX · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · N9611Z · Substantial damage > During take-off the pilot did not compensate for a strong crosswind and allowed the aircraft to drift sideways where the main gear collided with a fallen tree separating it from the aircraft and causing the aircraft to veer and collide with the ground. - [NTSB SEA86LA166](https://openairdocs.org/ntsb/SEA86LA166.md): Rockwell S2R · Royal City, WA · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N5698X · Substantial damage > Shortly after takeoff at an alt of aprx 110 ft AGL, a loss of pwr occurred due to the #2 cylinder failing. The acft nosed over during the subsequent forced landing in a wheat field. The plt then extinguished a small exhaust fire. - [NTSB FTW86LA125](https://openairdocs.org/ntsb/FTW86LA125.md): Cessna 152 · Broken Arrow, OK · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1986 · N65548 · Destroyed > The pilot made his takeoff from the intersection of a cinder packed runway, allowing only 900 feet before the end of the runway. Gross weight of the aircraft at the time of the accident was 1,700 lbs.; maximum gross weight of the aircraft is 1,670. The… - [NTSB ANC86LA105](https://openairdocs.org/ntsb/ANC86LA105.md): Piper PA-18 · Stoney River, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 12, 1986 · N1825A · Substantial damage > According to a witness, a certificated pilot, a crowd had gathered to wave, watch the takeoff and take photographs. The airplane began its takeoff roll about mid point on the airstrip and rolled 120 feet before lifting off. The airplane climbed steeply and… - [NTSB NYC86LA179](https://openairdocs.org/ntsb/NYC86LA179.md): Champion 7GCAA · Newburyport, MA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1986 · N9574S · Substantial damage > Pilot made a precautionary landing after experiencing a rudder control failure after a banner pick up. The left aft rudder cable had parted 49.5 inches aft of the rudder pedal attachment point. Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=176 ## 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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=175 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.