# 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 172 of 412 · 20,559 cases ## Cases, newest first - [NTSB NYC87LA058](https://openairdocs.org/ntsb/NYC87LA058.md): Agusta A109AII · So. Dartmouth, MA · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1987 · N300CC · Substantial damage > Agusta N300CC departed a helipad in front of claremont corp president's residence in south Dartmouth, Massachusetts. As the helicopter was hovering prior to moving forward, the tail rotor blade, s/n 124, failed. The tail rotor assembly and gearbox separated… - [NTSB MIA87LA071](https://openairdocs.org/ntsb/MIA87LA071.md): Cessna 182 · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Jan 13, 1987 · CGOXD · Substantial damage > The acft collided with a powerline, trees & a truck after sustaining a complete power loss right after take-off. The acft was being ferried to be sold & had not flown for about two months. During the pre-flt inspection, the plt stated that he drained a… - [NTSB LAX87FA084](https://openairdocs.org/ntsb/LAX87FA084.md): Cessna T210M · Pacoima, CA · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1987 · N112DW · Destroyed > During initial climb after takeoff the aircraft experienced a complete loss of power. The pilot attempted to return to the airport and collided with a large warehouse. The airframe was totally consumed in the post crash fire. Examination of the engine… - [NTSB ATL87LA059](https://openairdocs.org/ntsb/ATL87LA059.md): Cessna 152 · Columbia, SC · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1987 · N757XP · Substantial damage > The student plt was unable to recall anything about the acdt. A plt/a&p observing the t.o. stated that the acft lifted off and climbed to 50-60 ft. when a flock of black birds flew up into the path of the acft. The acft pitchedup, yawed slightly, turned about… - [NTSB LAX87LA079](https://openairdocs.org/ntsb/LAX87LA079.md): Intermountain Mfg. Callair A-9 · Fremont, CA · Accident · No injuries · Limited investigation · Final report · Jan 10, 1987 · N7232V · Substantial damage > During a towing operation, just after lift-off the aircraft lost engine power at approximately 75 feet AGL. The glider released and landed without incident. The aircraft continued straight ahead, ran into a fence and came to rest in a plowed field. The fuel… - [NTSB ATL87LA058](https://openairdocs.org/ntsb/ATL87LA058.md): Cessna 172G · Tuskegee, AL · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1987 · N3971L · Substantial damage > During a touch and go attempt, the pilot experiended an engine failure shortly after liftoff. The pilot safely landed on the runway, but did not have sufficient runway to stop the aircraft before running off the departure end of 31. The aircraft nosed over… - [NTSB LAX87LA075](https://openairdocs.org/ntsb/LAX87LA075.md): Bellanca 8KCAB · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 1987 · N68557 · Substantial damage > The plt lost control and collided with the surface of runway 24 during initial takeoff climb. The pilot indicated that he encountered a crosswind gust from his left during the initial takeoff/climb. The aircraft right wing or landing gear dragged along the… - [NTSB ATL87LA053](https://openairdocs.org/ntsb/ATL87LA053.md): Cessna 182J · Kennasaw, GA · Accident · No injuries · Limited investigation · Final report · Jan 3, 1987 · N3473F · Substantial damage > During initial climb for a local pleasure flight the pilot reported that the aircraft began to lose power. The pilot made a 180 degree turn to make an emergency downwind landing. He reported that the power increased and he decided to make a normal approach to… - [NTSB LAX87FA072](https://openairdocs.org/ntsb/LAX87FA072.md): North American T-28C · Van Nuys, CA · Accident · 1 fatal · Field investigation · Final report · Jan 1, 1987 · N9022Y · Destroyed > The plts were practicing lndgs, and were on the 3rd flt after the eng had been overhauled. After takeoff from a tough-&-go, the instructor noticed that the oil temp was high. Soon thereafter, the eng began to run rough, then it seized. Unable to get back to… - [NTSB SEA87LA039](https://openairdocs.org/ntsb/SEA87LA039.md): Hughes 269 · Matlock, WA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1986 · N9365F · Substantial damage > During takeoff the aircraft nosed over inverted and then struck the ground. The pilot found after the accident that a strap had hooked under the skid of the aircraft. - [NTSB SEA87LA042](https://openairdocs.org/ntsb/SEA87LA042.md): Cessna 150L · Lebanon, OR · Accident · No injuries · Limited investigation · Final report · Dec 27, 1986 · N11537 · Substantial damage > A power loss occurred during takeoff at about 100 feet AGL due to fuel exhaustion. A turn to the left was made so that a landing could be made on a field. During landing roll the aircraft's wing struck two trees. - [NTSB LAX87FA069](https://openairdocs.org/ntsb/LAX87FA069.md): Beech E-55 · East Palo Alto, CA · Accident · 6 fatal · Field investigation · Final report · Dec 27, 1986 · N111FC · Destroyed > The pilot and 5 passengers departed for a planned vacation in Mexico in dark night conditions. The aircraft was observedto depart from runway 30, turn from the crosswind to the downwind leg and the aircraft 'lost altitude rapidly' and impacted in the san… - [NTSB ATL87DEG02](https://openairdocs.org/ntsb/ATL87DEG02.md): Cessna 150H · Harrison, OH · Accident · No injuries · Final report · Dec 27, 1986 · N7190S · Substantial damage > The engine quit after takeoff at about 200 ft AGL. A ldg was made in a plowed field where the acft flipped over inverted. The CFI PIC reported that, prior to takeoff, he had calculated there was adequate fuel on board for the flt; his calculations were based… - [NTSB NYC87FA049](https://openairdocs.org/ntsb/NYC87FA049.md): Cessna 172M · Kingston, NY · Accident · 1 fatal · Field investigation · Final report · Dec 21, 1986 · N64342 · 2 aircraft · Destroyed > Cessna 172M, N64342, was on his initial climb after taking off on runway 33 at the uncontrolled Kingston-ulster airport when the pilot failed to see Cessna 177, N2981X, or hear, on the UNICOM frequency, the transmissions by N2981X who was on his final… - [NTSB FTW87LA033](https://openairdocs.org/ntsb/FTW87LA033.md): Cessna 150M · Cresson, TX · Accident · No injuries · Limited investigation · Final report · Dec 20, 1986 · N714KY · Substantial damage > After about 45 min of flt time, the instructor (CFI) & student plt entered the traffic pattern to practice touch-&-go landings. As they were taking off from the 1st touch-&-go, the eng lost power. Subsequently, they made a forced landing in an open area near… - [NTSB ATL87FA045](https://openairdocs.org/ntsb/ATL87FA045.md): Cessna 170B · Asheville, NC · Accident · 2 fatal · Field investigation · Final report · Dec 19, 1986 · N8062A · Destroyed > During initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student… - [NTSB LAX87DUJ03](https://openairdocs.org/ntsb/LAX87DUJ03.md): Solem KR-2 · Mesa, AZ · Accident · Minor injuries · Final report · Dec 13, 1986 · N3762S · Substantial damage > The pilot said that shortly after takeoff the control stick shuddered and he felt 'back pressure' on the stick. The nose started pitching up so he pushed forward on the stick. He continued pushing the stick forward until it reached the forward stops. Despite… - [NTSB MKC87FA030](https://openairdocs.org/ntsb/MKC87FA030.md): Piper PA-28-151 · Grain Valley, MO · Accident · Serious injuries · Field investigation · Final report · Dec 11, 1986 · N44291 · Destroyed > The pilot stated, after takeoff the engine sputtered and began losing power during initial climb. According to the pilot, he tried to land on a highway but there were numerous vehicles in transit and he decided to attempt an off-airport landing. On initial… - [NTSB CHI87LA042](https://openairdocs.org/ntsb/CHI87LA042.md): Cessna 152II · Anoka, MN · Accident · No injuries · Limited investigation · Final report · Dec 8, 1986 · N753AA · Substantial damage > The acft was on the fifth touch & go of the student plt training flt when a loss of power occurred at 100-200 ft AGL during climbout. The CFI had to land the acft in unsuitable terrain which resulted in substantial damage to the acft. Examination of eng and… - [NTSB NYC87LA046](https://openairdocs.org/ntsb/NYC87LA046.md): Beech B23 · Trenton, ME · Accident · No injuries · Limited investigation · Final report · Dec 7, 1986 · N7651R · Substantial damage > The plt rprtd that after takeoff, the acft had climbed to 600 ft & was climbing at 300 ft/min, when the eng 'started to labor,' then quit running. He used carburetor heat & 'primed through power reduction,' but the eng would not restart. During an emerg lndg… - [NTSB ATL87FA038](https://openairdocs.org/ntsb/ATL87FA038.md): Cessna 185D · Hammonton, NJ · Accident · 2 fatal · Field investigation · Final report · Dec 7, 1986 · N5878T · 2 aircraft · Destroyed > The mid-air collision occurred while the Cessna 185 was attempting a steep climbout during takeoff from rwy 21 and the Mooney was making a landing to the same runway. Another aircraft attemped to warn both aircraft over the UNICOM freq. Neither aircraft… - [NTSB CHI87DEM05](https://openairdocs.org/ntsb/CHI87DEM05.md): Cessna T210L · Lawton, MI · Accident · Serious injuries · Final report · Dec 6, 1986 · N999WF · Substantial damage > The plt experienced a loss of control shortly after takeoff which resulted in an uncontrolled descent. The acft struck the ground with its left wingtip causing it to flip over onto its side. The plt reported that the auto-plt had been worked on after having… - [NTSB MKC87LA028](https://openairdocs.org/ntsb/MKC87LA028.md): Grumman-Schweizer G-164B-600 · Earle, AR · Accident · No injuries · Limited investigation · Final report · Dec 3, 1986 · N6898Q · Substantial damage > The pilot stated that the powerplant was performing normally during initial climb when, suddenly, the engine experienced a power loss after backfiring. Immediate remedial action resulted in a partial power output but not enough to sustain flight. Emergency… - [NTSB ATL87IA034](https://openairdocs.org/ntsb/ATL87IA034.md): de Havilland DHC-8-101 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Dec 3, 1986 · N802MX · Minor damage > At about 4,000 ft MSL, cpt on sch dom flt reported loud pop and sub shutdown of rt eng. Smell of smoke and visual confirmation of fire in rt nacelle. Ships fire ext activated during return to dept. Arpt. Landed without further incident. Investigation revld… - [NTSB LAX87DUM01](https://openairdocs.org/ntsb/LAX87DUM01.md): Bell UH-1B · Calipatria, CA · Accident · No injuries · Final report · Dec 1, 1986 · N2770N · Substantial damage > During the initial climb at the beginning of an aerial application flight, the pilot made a climbing 180 degree right turn in the reverse direction when the rotor RPM began to drop. The pilot continued to raise collective, lost directional control and… - [NTSB DEN87LA025](https://openairdocs.org/ntsb/DEN87LA025.md): Cessna 152 · Ellicott, CO · Accident · No injuries · Limited investigation · Final report · Nov 29, 1986 · N757TN · Substantial damage > During the initial climb phase of takeoff the plt encountered a wind shear with strong gusty tail winds. The acft entered an uncontrolled descent from 25 feet AGL, struck a wire fence off the end of the rwy and nosed over. - [NTSB FTW87LA023](https://openairdocs.org/ntsb/FTW87LA023.md): North American Navion A · Springtown, TX · Accident · 2 fatal · Limited investigation · Final report · Nov 28, 1986 · N91548 · Substantial damage > The pilot told rescue personnel that he had taken off with empty tanks selected. The engine quit, and the aircraft impacted the ground before he could restart. Initial reports of serious injury only, but both occupants expired two weeks later. - [NTSB CHI87LA038](https://openairdocs.org/ntsb/CHI87LA038.md): Cessna 150G · Rockford, IL · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 1986 · N8703S · Destroyed > Shortly after takeoff at about 100 feet AGL, pilot reports the engine lost power, aircraft stalled, entered a spin, and collided with the ground. Inspection of the aircraft and magnetos did not disclose any discrepancies other than possible coil deterioration. - [NTSB SEA87LA032](https://openairdocs.org/ntsb/SEA87LA032.md): Cessna 172D · Kennewick, WA · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 1986 · N2349U · Substantial damage > The private pilot was seated in the right front seat with the student pilot in the left front seat. The pvt pilot allowed the student pilot to takeoff. The student over rotated and the stall warning was sounding. The pvt pilot took command of the aircraft but… - [NTSB SEA87FA031](https://openairdocs.org/ntsb/SEA87FA031.md): Cessna 177RG · Republic, WA · Accident · 1 fatal · Field investigation · Final report · Nov 25, 1986 · N52069 · Destroyed > A witness observed the acft taxi out ot the rwy in light snow showers and taxi to the north end of the rwy. During the takeoff the area was covered with a heavy snow shower, with winds from the north gusting T0 20-25 mph. The acft was observed to depart to… - [NTSB MIA87LA034](https://openairdocs.org/ntsb/MIA87LA034.md): Cessna 152 · Lantana, FL · Accident · No injuries · Limited investigation · Final report · Nov 22, 1986 · N24298 · Substantial damage > The pilot stated the aircraft performed sluggishly during takeoff and would not climb to clear trees at the departure end of the runway. The takeoff was aborted and the aircraft overran the runway encountering sand and nosing over. The pilot stated that… - [NTSB ATL87LA026](https://openairdocs.org/ntsb/ATL87LA026.md): Mullinax KR-2 · Augusta, GA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1986 · N313RR · Destroyed > The plt stated that the eng always ran rough at full pwr due to a rich mixture setting on the carburetor. Normally the eng roughness could be corrected by retarding the throttle or mixture control. The plt said that he adjusted the mixture on the carburetor… - [NTSB ANC87LA014](https://openairdocs.org/ntsb/ANC87LA014.md): Cessna 305E · Barrow, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1986 · N68396 · Substantial damage > The pilot stated that during the takeoff he had full right aileron and left rudder. The pilot lost directional control of the aircraft and crashed off the left side of the runway. At the time of the accident the wind was five knots or less. - [NTSB ANC87LA013](https://openairdocs.org/ntsb/ANC87LA013.md): Piper PA-18 · Big Lake, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1986 · N1ZA · Substantial damage > The student plt stalled the acft at aprx 20 to 30 ft AGL during the initial climbout. Subsequently, the acft impacted the rwy & went off to the side. - [NTSB MIA87LA033](https://openairdocs.org/ntsb/MIA87LA033.md): Hickham Twinstar · Bay St. Louis, MS · Accident · No injuries · Limited investigation · Final report · Nov 16, 1986 · N9731N · Substantial damage > Shortly after takeoff on the initial test flt, severe vibration was felt and the plt attempted to return the float equipped acft to the water for a forced ldg. Due to low alt, the plt had to land in trees. An exam of one of the blades of the 3 bladed… - [NTSB CHI87LA029](https://openairdocs.org/ntsb/CHI87LA029.md): Piper PA-28-180 · Lansing, IL · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1986 · N2311R · Substantial damage > The plt rprtd he enctrd IFR conds at aprx 400' AGL drg takeoff. He elected to 'fly out of it' & 'was in the clear' afterclbg to 4500' MSL. He elected to return to the arpt & indcd he could see the arpt 'on and off' thru brkn clds. On an apch to lnd, the acft… - [NTSB CHI87LA032](https://openairdocs.org/ntsb/CHI87LA032.md): Burkhart Grob 109B · Gregory, MI · Accident · No injuries · Limited investigation · Final report · Nov 15, 1986 · N58287 · Substantial damage > While landing, the aircraft bounced twice, so the pilot decided to go around and make a second attempt. On climb out, the landing gear struck 65 ft tall trees at the end of the runway. The aircraft then stalled and collided with the terrain. Reportedly, the… - [NTSB LAX87FA039](https://openairdocs.org/ntsb/LAX87FA039.md): Beech D55 · Livermore, CA · Accident · 2 fatal · Field investigation · Final report · Nov 13, 1986 · N8386N · Destroyed > Witnesses stated that the aircraft started the takeoff roll, became airborne at about 1000 feet down the runway, climbed to an altitude of about 50 feet, rolled to the left and crashed inverted onto a parallel taxiway at about mid field. There was no fire.… - [NTSB CHI87LA028](https://openairdocs.org/ntsb/CHI87LA028.md): Beech 23 · Laporte, IN · Accident · No injuries · Limited investigation · Final report · Nov 11, 1986 · N2335Q · Substantial damage > The plt stated that at the initial full throttle position the acft developed 2450 RPM. According to the plt, at approximately 200 feet of altitude he noticed a loss of rpm's to 2050 and he immediately rechecked the throttle and mixture controls, the magneto… - [NTSB CHI87DEX01](https://openairdocs.org/ntsb/CHI87DEX01.md): Turnbloom Kitfox · Crawfordsville, IN · Accident · No injuries · Final report · Nov 9, 1986 · N371DT · Substantial damage > The plt rprtd that when he was preparing for the acft's 1st test flt, he made a hi speed run with the tail raised & acft control was good. On the next run, he planned to let the acft lift off the rwy, then let it settle back on the surface. He stated that he… - [NTSB MKC87FA015](https://openairdocs.org/ntsb/MKC87FA015.md): Cessna 310Q · Liberal, KS · Accident · 1 fatal · Field investigation · Final report · Nov 6, 1986 · N510SU · Destroyed > The acft impacted the terrain just off the departure end of rwy 17 at Liberal, KS, while on a return flt to Texas. Dark night conditons prevailed and no horizon visual cue were available shortly after takeoff. Reliance on flt attitude instruments would have… - [NTSB ATL87LA148](https://openairdocs.org/ntsb/ATL87LA148.md): Cessna 150J · Memphis, TN · Accident · 1 fatal · Limited investigation · Final report · Nov 4, 1986 · N50736 · Destroyed > Prior to its discovery on may 20, 1987, this acft had last been seen on x-wind leg on climb out after a touch and go at dewitt spain arpt. Parts of the acft were recovered from the Mississippi river northwest of the arpt. The plt's remains had not been… - [NTSB MKC87FA012](https://openairdocs.org/ntsb/MKC87FA012.md): Piper PA-24 · Siloam Springs, AR · Accident · 2 fatal · Field investigation · Final report · Nov 3, 1986 · N7062P · Destroyed > The plt had logged 3 hrs of simulated instrument training prior to this accident. He received a wx briefing which reported wx conditions nearby were IFR due to low ceilings and fog. Immediately after takeoff, the acft started a left turn and impacted terrain… - [NTSB DEN87LA013](https://openairdocs.org/ntsb/DEN87LA013.md): Pitts S-1D · Shelby, MT · Accident · No injuries · Limited investigation · Final report · Nov 2, 1986 · N255NK · Destroyed > The plt took off with little or no warmup, pushed the acft to max performance at 10 ft, performed a max performance climb to 300 to 400 ft and reduced throttle to idle. As the acft reached stall speed, the plt dived at a 45 degree angle and impacted the… - [NTSB ATL87FA016](https://openairdocs.org/ntsb/ATL87FA016.md): Koons-Donald Sonerai II · Macon, GA · Accident · 1 fatal · Field investigation · Final report · Nov 2, 1986 · N23DK · Destroyed > During climbout, the pilot allowed the aircraft to stall while turning to a left crosswind. The acft impacted the ground in a nose low attitude after colliding with two trees. The pilot was unable to exit the aircraft and local residents were unable to assist… - [NTSB MIA87FA019](https://openairdocs.org/ntsb/MIA87FA019.md): Cessna 210 · Jacksonville, FL · Accident · Serious injuries · Field investigation · Final report · Nov 1, 1986 · N6123U · Substantial damage > The flt, transporting banking records, had executed a VOR apch to the rwy after being given the arpt wx which was ceiling indefinate with 1 mi visibility in fog. The plt stated that after landing, he realized he had touched down too FAR down the rwy to… - [NTSB FTW87FA007](https://openairdocs.org/ntsb/FTW87FA007.md): Bell 206B · Mustang Island · Accident · Serious injuries · Field investigation · Final report · Nov 1, 1986 · N5741K · Substantial damage > Acft experienced a power loss immediately after takeoff from an offshore platform in the gulf of Mexico. The plt held collective to clear the rig and then popped the floats and autorotated to the water. The auto was successful, however, the acft was struck by… - [NTSB FTW87DPJ01](https://openairdocs.org/ntsb/FTW87DPJ01.md): Snow AT-301 · Hennessey, OK · Accident · No injuries · Final report · Nov 1, 1986 · N7309D · Substantial damage > The acft collided with a street sign during takeoff. Unablt to maintain flight, the plt landed the acft in a field collapsing the right landing gear. - [NTSB LAX87IA029](https://openairdocs.org/ntsb/LAX87IA029.md): British Aerospace BAE 146-200 · Santa Ana, CA · Incident · No injuries · Incident investigation · Final report · Oct 31, 1986 · N363PS · Minor damage > Just after takeoff the aircraft experienced a fire in the number 3 engine which was extinguished by the on board fire bottles. Investigation revealed that a secondary fuel line had pulled out of a b-nut ferrule fitting at the fuel flow divider manifold which… - [NTSB MIA87FA015](https://openairdocs.org/ntsb/MIA87FA015.md): de Havilland DHC-3 · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Oct 29, 1986 · N778L · Destroyed > Witnesses stated that the acft used most of the rwy to takeoff, reached an aprx altitude of 60 feet, then pulled up to clear an embankment. However, the acft struck a tall palm tree & crashed between 2 roads, near an intersection, where the roads merged. The… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=173 ## 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=172 --- 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.