# 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 164 of 412 · 20,559 cases ## Cases, newest first - [NTSB FTW88DRG06](https://openairdocs.org/ntsb/FTW88DRG06.md): Hodges Condor III +2 · Canyon Lake, TX · Accident · Minor injuries · Final report · Feb 21, 1988 · N5539Z · Substantial damage > The homebuilt airplane was being flown by the new owner and his son. After two takeoffs and landings, the airplane was 5O feet in the air when the engine quit. The pilot stated in his report, 'we suspect a kill switch was inadvertently touched and this was… - [NTSB BFO88LA023](https://openairdocs.org/ntsb/BFO88LA023.md): Piper PA-28-180 · Annapolis, MD · Accident · No injuries · Limited investigation · Final report · Feb 21, 1988 · N32019 · Substantial damage > The plt said he did a preflight inspection of the acft which included a check for water in the fuel. Tanks were partially full- 17 gals in each one. A pre-takeoff eng runup was normal. During the initial takeoff climb the eng had a partial power loss. After… - [NTSB DCA88MA032](https://openairdocs.org/ntsb/DCA88MA032.md): Fairchild SA227-AC · Cary, NC · Accident · 12 fatal · Major investigation · Final report · Feb 20, 1988 · N622AV · Destroyed > The aircraft departed during low ceiling, low visibility, and night conditions. Shortly after takeoff the aircraft impacted a reservoir. Analysis of radar data indicated the acft was in a 45 degree descending turn. Exam of the acft trim system showed that the… - [NTSB CHI88IA073](https://openairdocs.org/ntsb/CHI88IA073.md): Boeing 747-227B · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Feb 19, 1988 · N635US · 2 aircraft · No damage > Failure of the tower cab supervisor to assure that coordination between the south local controller and north local controller had been completed. A factor is the failure of FAA tower management to insure there were personnel manning the cab coordinator… - [NTSB LAX88DUJ03](https://openairdocs.org/ntsb/LAX88DUJ03.md): Beech F33A · Goodyear, AZ · Accident · No injuries · Final report · Feb 18, 1988 · N6785Y · Substantial damage > During an instructional flight, after takeoff, at 300 feet, the pilot and student said they heard a loud bang. The engine experienced a loss of power and the pilot noted that the top of the engine cowling was gone. A forced landing was made off the runway.… - [NTSB BFO88FA022](https://openairdocs.org/ntsb/BFO88FA022.md): Cessna 150M · So. Charleston, WV · Accident · 1 fatal · Field investigation · Final report · Feb 17, 1988 · N9399U · Destroyed > The stu plt said the engine began to alternate between partial and full power during the initial tkf climb. The acft was about 100 ft AGL and about 300 ft past the rwy end. According to the stu the inst took control of the acft, turned left, reversed course… - [NTSB MKC88LA053](https://openairdocs.org/ntsb/MKC88LA053.md): Beech 23 · Grain Valley, MO · Accident · No injuries · Limited investigation · Final report · Feb 16, 1988 · N18868 · Substantial damage > While practicing soft field takeoffs, the student pilot stated that he overrotated, establishing too high a nose up attitude. The aircraft entered a departure stall, followed by uncontrolled descent to the terrain. - [NTSB SEA88LA046](https://openairdocs.org/ntsb/SEA88LA046.md): Cessna 305A (L-19) · Jean, NV · Accident · 2 fatal · Limited investigation · Final report · Feb 14, 1988 · N5173G · Destroyed > Witnesses observed acft enter 45 deg climb attitude on liftoff, climb to about 200 ft AGL, then enter left turn. Acft appeared to stall, wing dropped and nose fell through to impact 100 yds left of runway. Flaps found set at 60 deg vs. max 30 deg setting… - [NTSB FTW88LA065](https://openairdocs.org/ntsb/FTW88LA065.md): Piper PA-38-112 · Maud, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 1988 · N9319T · Destroyed > The acft took off from a 1800 ft private, turf, strip. The takeoff was to the sw and the wind was strong and gusty from the nw. There are trees along the right or upwind side of the rwy. Shortly after takeoff, the acft encountered turbulence and collided with… - [NTSB ATL88FA088](https://openairdocs.org/ntsb/ATL88FA088.md): Cessna 150H · Youngstown, OH · Accident · 1 fatal · Field investigation · Final report · Feb 9, 1988 · N618DP · Substantial damage - [NTSB NYC88LA077](https://openairdocs.org/ntsb/NYC88LA077.md): Cessna 150 · Westerly, RI · Accident · Minor injuries · Limited investigation · Final report · Feb 6, 1988 · N3210J · Substantial damage > The plt reported that he experienced a power loss at 350 ft AGL after takeoff. He turned back toward the airport but had insufficient altitude. He elected to land off-airport at an industrial site with the stall warning horn sounding. During landing roll, the… - [NTSB NYC88LA076](https://openairdocs.org/ntsb/NYC88LA076.md): Piper PA-38-112 · Williamstown, NJ · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 1988 · N2352N · Destroyed > The flight departed runway 27 at cross keys airport and upon reaching 250 feet altitude, the engine lost power and began vibrating. The pilot maneuvered to return to the airport but was unable to reach it. The aircraft crashed in a yard about 1/2 mile from… - [NTSB NYC88LA073](https://openairdocs.org/ntsb/NYC88LA073.md): Piper PA-28-161 · Hammonton, NJ · Accident · No injuries · Limited investigation · Final report · Feb 5, 1988 · N2126J · Destroyed > The plt reported that he experienced a power loss after takeoff at about 100 feet AGL near the end of rwy 30. He said the acft stalled at treetop level, collided with trees, and came to rest in a nosedown attitude. The plt reported that he initiated the flt… - [NTSB LAX88DVD02](https://openairdocs.org/ntsb/LAX88DVD02.md): Cessna A188B · Lodi, CA · Accident · No injuries · Final report · Feb 5, 1988 · N2832J · Substantial damage - [NTSB NYC88LA071](https://openairdocs.org/ntsb/NYC88LA071.md): Cessna 402B · Bangor, ME · Accident · No injuries · Limited investigation · Final report · Feb 1, 1988 · N4175G · Substantial damage > The crew rprtd that drg takeoff, a power surge occurred after the acft had climbed about 400 to 500 ft. the coplt saw what he later said was a right fuel flow fluctuation & told the plt (PIC) that the right eng was losing power. The PIC told the coplt to… - [NTSB MKC88LA045](https://openairdocs.org/ntsb/MKC88LA045.md): Cessna 195 · Rolla, MO · Accident · No injuries · Limited investigation · Final report · Jan 28, 1988 · N1071D · Substantial damage > Shortly after takeoff, during a personal flight, the engine progressively lost power. The PIC attempted an emergency ldg in a pasture. During the ldg roll, the acft collided with a tree, causing substantial damage to the right wing. Post accident aircraft… - [NTSB MIA88FA094](https://openairdocs.org/ntsb/MIA88FA094.md): Cessna 411 · Venice, FL · Accident · 1 fatal · Field investigation · Final report · Jan 27, 1988 · N235UV · Destroyed > Witnesses stated that the acft was climbing & just after takeoff, the left wing dropped, the acft then leveled off, climbed aprx 75 more feet. The acft then abruptly turned hard left & went straight in, striking a wall surrounding a swimming pool, burst into… - [NTSB SEA88LA040](https://openairdocs.org/ntsb/SEA88LA040.md): Piper PA-22-150 · Kennewick, WA · Accident · No injuries · Limited investigation · Final report · Jan 24, 1988 · N3316Z · Substantial damage > At about 75 feet AGL a total loss of power occurred. The plt landed on the remaining runway but overran the rwy, coming to rest 200 ft beyond the end. During the overrun, the nose gear struck a rock and the acft nosed over. The aircraft's fuel tanks contained… - [NTSB NYC88FA069](https://openairdocs.org/ntsb/NYC88FA069.md): Cessna 182L · Waynesburg, PA · Accident · 2 fatal · Field investigation · Final report · Jan 24, 1988 · N3467R · Destroyed > Shortly after departure from runway 26, the aircraft engine failed. The aircraft banked to about 90 degrees, descended and impacted the ground. A flight instructor described the wind as very gusty and varying out of the south at approximately 10-20 knots. The… - [NTSB NYC88LA066](https://openairdocs.org/ntsb/NYC88LA066.md): Cessna 210 · Stowe, VT · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 1988 · N94064 · Substantial damage > The Cessna 210 took off and shortly thereafter experienced a loss of power. The pilot was unable to get the engine restarted and made an off-airport landing in a grove of trees. On-scene examination by the FAA showed that the fuel selector was on the left… - [NTSB MIA88FA088](https://openairdocs.org/ntsb/MIA88FA088.md): Christen Industries A-1 · Pompano Beach, FL · Accident · Serious injuries · Field investigation · Final report · Jan 17, 1988 · N29076 · Destroyed > The plt stated that as he pushed the control stick forward in an attempt to raise the tail, the acft violently pitched up, stalled and broke right, the right wing struck the ground, & the acft rolled over & came to rest inverted. Post crash examination of the… - [NTSB LAX88FA087](https://openairdocs.org/ntsb/LAX88FA087.md): Cessna T210N · Lost Hills, CA · Accident · 1 fatal · Field investigation · Final report · Jan 16, 1988 · N7573N · Destroyed > On a dark night with light drizzle falling the pvt plt, who was not instrument rated, departed from an uncontrolled arpt for a x-c flt. The plt made a downwind departure, & his altitude on the x-wind leg was estimated by a passing truck driver at 200 ft AGL.… - [NTSB ANC88LA025](https://openairdocs.org/ntsb/ANC88LA025.md): Piper PA-28 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 1988 · N9103W · Substantial damage > The pilot had selected the left auxiliary fuel tank for takeoff. During the climbout the engine quit; the aircraft crashed short of a private airstrip. The pilot stated that he ran the left auxiliary fuel tank dry and did not select another fuel tank with the… - [NTSB NYC88LA054](https://openairdocs.org/ntsb/NYC88LA054.md): Grumman AA-5A · Honesdale, PA · Accident · No injuries · Limited investigation · Final report · Jan 10, 1988 · N26869 · Substantial damage > Shortly after takeoff from runway 35 at cherry ridge airport, Honesdale, Pennsylvania, the aircraft experienced an engine power loss and crashed about 200 feet off the end of the runway. Examination of the aircraft after the accident revealed no fuel in the… - [NTSB CHI88FA041](https://openairdocs.org/ntsb/CHI88FA041.md): Fairchild SA226T · Pontiac, MI · Accident · 3 fatal · Field investigation · Final report · Jan 10, 1988 · N800AW · Destroyed > Acft was scheduled for an instructional flt. During the wx briefing, the CFI told the fss specialist that the flt would include eng-out practice. Witness statements indicate that the acft rolled sharply to the rt and nosed down after attaining about 100 ft of… - [NTSB MIA88LA082](https://openairdocs.org/ntsb/MIA88LA082.md): Cessna 172 · Tampa, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 3, 1988 · N40AZ · Substantial damage > After preflighting the acft, 30.8 gal of fuel were added. No further insp was performed. The flt took off after an eng runup was accomplished. No problems were noted. During the initial climb of the first touch-and-go landing, at an alt of aprx 75 ft, the eng… - [NTSB MIA88LA080](https://openairdocs.org/ntsb/MIA88LA080.md): Bellanca 14-13 · Merritt Island, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 2, 1988 · N8429H · Substantial damage > The private pilot experienced a power loss after takeoff. He then collided with water after hitting a mast of a boat and a dock. The plt stated that he experienced carburetor ice prior to the eng quitting. The plt stated that on an earlier flt he had problems… - [NTSB FTW88LA045](https://openairdocs.org/ntsb/FTW88LA045.md): Aero Commander 100-180 · Mineola Quitman, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 2, 1988 · N3709X · Substantial damage > During a practice touch and go landing, the engine back fired and then surged. At about 150' AGL the engine RPM dropped about 80% and the pilot attempted to make an emergency landing in an open field. The aircraft flew over a trash dump and between two trees.… - [NTSB ATL88LA071](https://openairdocs.org/ntsb/ATL88LA071.md): Cessna 177 · Springfield, KY · Accident · Serious injuries · Limited investigation · Final report · Jan 2, 1988 · N2906X · Substantial damage > One witness stated that the eng misfired during the takeoff roll, others stated that the acft was about 75 ft high when it lost power. There were several interruptions of power before it quit totally. The pilot attempted to return to the departure airfield.… - [NTSB LAX88LA078](https://openairdocs.org/ntsb/LAX88LA078.md): Cessna 150K · San Andreas, CA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1987 · N6422G · Substantial damage - [NTSB FTW88LA042](https://openairdocs.org/ntsb/FTW88LA042.md): Cessna 182 · Fargo, OK · Accident · No injuries · Limited investigation · Final report · Dec 29, 1987 · N94546 · Substantial damage > During takeoff roll, the engine RPM dropped to 2600 and started running rough. Shortly after takeoff, the pilot elected to make a precautionary landing. During landing roll the aircraft's left wing hit a tree causing substantial damage to the aircraft. Prior… - [NTSB BFO88FA011](https://openairdocs.org/ntsb/BFO88FA011.md): Champion 7ECA · Keymar, MD · Accident · 1 fatal · Field investigation · Final report · Dec 25, 1987 · N11089 · Destroyed > Witnesses heard and observed the aircraft takeoff, bank to the left, and nose down into the adjoining dirt field with no change in engine sound. Exam of the wreckage revealed that an elevator cable had separated at a point where grounding strap was found to… - [NTSB DCA88MA011](https://openairdocs.org/ntsb/DCA88MA011.md): Piper PA-31-350 · Kenai, AK · Accident · 6 fatal · Major investigation · Final report · Dec 23, 1987 · N496SC · Destroyed > The pilot had just departed the runway when he reported to the flight service station that he had engine problems. The aircraft was observed by witnesses to be about 300 ft on a descending downwind. The pilot stated that he was circling for runway one.… - [NTSB FTW88DRG04](https://openairdocs.org/ntsb/FTW88DRG04.md): MBB 109 · Harlingen, TX · Accident · 1 fatal · Final report · Dec 19, 1987 · N8575 · Destroyed > The set of floats which allows a high fuel flow in this carburetor for high power settings used for takeoff, climb, etc., had cracked and swollen to such an extent that they were rubbing against the float chamber walls and float chamber shroud tubes. This… - [NTSB MIA88LA067](https://openairdocs.org/ntsb/MIA88LA067.md): Gulfstream American AA5A · Marathon, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1987 · CGRRP · Substantial damage > While on a personal flt shortly after takeoff at an alt of aprx 400 ft, the plt reported that the eng quit shortly after she turned off the electric fuel pump. Attempts to restart were unsuccessful. A forced landing followed during which the acft collided… - [NTSB MIA88LA062](https://openairdocs.org/ntsb/MIA88LA062.md): Champion 7EC · Ocoee, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 12, 1987 · N4387C · Substantial damage > The plt rprtd that before takeoff, he made a thorough preflt, which included a check of the fuel sys for contaminates & water, but no discrepancies were noted. Shortly after takeoff, at an alt of aprx 100 ft, the eng sputtered & lost pwr. The plt stated he… - [NTSB LAX88LA050](https://openairdocs.org/ntsb/LAX88LA050.md): Cessna 150H · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Dec 11, 1987 · N50320 · Substantial damage > As the aircraft began its initial climb after takeoff, the engine began to run rough and the pilot elected to land on a street. The aircraft impacted street signs during the ground roll and collided with the street curbing. Post acc investigation revealed the… - [NTSB ATL88LA061](https://openairdocs.org/ntsb/ATL88LA061.md): Piper PA-28-180 · Richmond Hts, OH · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 1987 · N9494J · Substantial damage > The plt began taking off on rwy 23 with a wind from 160 deg at 13 KTS. The tower ctlr saw the acft turn sharply to the left after lift-off & subsequently impact about 250' left of the rwy. The ctlr said the plt appeared to have 'jerked' the acft off of the… - [NTSB ATL88FA059](https://openairdocs.org/ntsb/ATL88FA059.md): Cessna 421A · Hilton Head Isl, SC · Accident · 2 fatal · Field investigation · Final report · Dec 11, 1987 · N777RC · Destroyed > Acft depted coastal arpt at night with 400 ft partial obscuration in patchy fog. Ground witnesses who heard acft depicted a circling flt path to the right after takeoff. Eng, prop & turbo teardowns demonstrated both engs were operating at high power & no… - [NTSB MIA88LA059](https://openairdocs.org/ntsb/MIA88LA059.md): Piper PA-18-135 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Dec 10, 1987 · N8767C · Substantial damage > Although the plt stated that he performed a preflt & eng runup prior to departure with no problem noted, shortly after takeoff, while climbing through 350 ft, the engine RPM dropped to & stayed between 1500 & 1600. The plt was unable to maintain altitude… - [NTSB NYC88LA052](https://openairdocs.org/ntsb/NYC88LA052.md): Piper PA-28-140 · Pottstown, PA · Accident · No injuries · Limited investigation · Final report · Dec 3, 1987 · N16491 · Substantial damage > During soft field takeoff, the instructor pilot who was watching from the ramp, said the the student plt seemed to have excessive angle of attack and stalled the aircraft. The aircraft crashed on airport property about 1,000 feet from the start of the takeoff… - [NTSB MIA88FA049](https://openairdocs.org/ntsb/MIA88FA049.md): Beech K-35 · Crescent City, FL · Accident · 1 fatal · Field investigation · Final report · Dec 1, 1987 · N125LE · Destroyed > The pilot experienced a partial engine failure at lift off with 1/2 of the runway remaining in front of him. The pilot then attempted to do a 180 degree teardrop back to the runway, stalled and crashed. Investigation revealed water contamination of the fuel… - [NTSB SEA88LA026](https://openairdocs.org/ntsb/SEA88LA026.md): Cessna 206 · Funter Bay, AK · Accident · No injuries · Limited investigation · Final report · Nov 30, 1987 · N9303R · Substantial damage > Shortly after takeoff, with a right quartering tailwind of 20 knots gusting to 25 knots, a downdraft was encountered. The pilot flew the aircraft away from rising terrain but the aircraft settled into small trees at full power in the takeoff configuration. - [NTSB CHI88DEP02](https://openairdocs.org/ntsb/CHI88DEP02.md): Beech V35B · Waukesha, WI · Accident · Serious injuries · Final report · Nov 30, 1987 · N6679J · Destroyed > Shortly after liftoff in IMC, the acft descended to the ground. The plt had been cleared for a rt turn but the controller noticed the acft turning left at about 50 ft AGL. The plt later could not stop the drifting to the left. The lndg gear was raised and the… - [NTSB MIA88LA046](https://openairdocs.org/ntsb/MIA88LA046.md): Cessna 172P · New Port Richey, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 29, 1987 · N62083 · Substantial damage > The pilot experienced an engine failure due to a heavily coked #4 cylinder exhaust valve while on climb out at 500 ft AGL. He attempted a turn back to the airport and stalled in the turn and crashed. - [NTSB DEN88LA031](https://openairdocs.org/ntsb/DEN88LA031.md): Cessna 170B · Conner, MT · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 1987 · N2926D · Substantial damage > On takeoff from a private, grass strip the pilot stated the engine began to lose power at approximately 20 to 30 feet AGL. A ravine was ahead and he attempted to stretch his glide to the FAR side of the ravine; however, the aircraft stalled and crashed into… - [NTSB SEA88FA023](https://openairdocs.org/ntsb/SEA88FA023.md): Cessna 172M · Hillsboro, OR · Accident · Serious injuries · Field investigation · Final report · Nov 25, 1987 · N21460 · Destroyed > The daily radio traffic reporting flight was cleared for an IFR departure from Hillsboro airport in IMC. The owner/ operator of the aircraft stated the company had a 'no ifr' policy. On takeoff witnesses observed the aircraft to be lower and slower than… - [NTSB ATL88FA043](https://openairdocs.org/ntsb/ATL88FA043.md): Cessna 172N · Blanchester, OH · Accident · 1 fatal · Field investigation · Final report · Nov 24, 1987 · N5548J · Destroyed > The aircraft departed before dawn from a private sod airstrip owned by the pilot, and collided with trees shortly thereafter. The pilot's wife said that the airstrip was not foggy when her husband took off, but the witness reported that the fog at the… - [NTSB NYC88FA041](https://openairdocs.org/ntsb/NYC88FA041.md): Mooney M20C · St. Marys, PA · Accident · 4 fatal · Field investigation · Final report · Nov 15, 1987 · N3644H · Destroyed > While getting fuel, the pilot of the Mooney M20C and his 3 pals were attempting to remove frost with paper towels and plastic credit cards after being told by the fuel truck driver that the arpt had no ice removal solution. A witness stated that as the… - [NTSB DCA88MA004](https://openairdocs.org/ntsb/DCA88MA004.md): Mcdonnell Douglas DC-9-14 · Denver, CO · Accident · 28 fatal · Major investigation · Final report · Nov 15, 1987 · N626TX · Destroyed > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/09. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=165 ## 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=164 --- 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.