# 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 166 of 412 · 20,559 cases ## Cases, newest first - [NTSB SEA87LA189](https://openairdocs.org/ntsb/SEA87LA189.md): Cessna 182Q · Cathlamet, WA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1987 · N96847 · Substantial damage > The pilot was making soft field takeoffs with no flaps. He lost control of the aircraft at about 10 feet AGL, the aircraft's right wing struck the ground and the aircraft came to a stop. - [NTSB ATL87LA263](https://openairdocs.org/ntsb/ATL87LA263.md): Cessna 140 · Jesup, GA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1987 · N77126 · Substantial damage > During initial takeoff the aircraft's engine lost power and the aircraft collided with the ground. Investigation revealed the carburetor inlet filter was 50 percent plugged with rusty material and two tablespoons of rusty water remained in the carburetor… - [NTSB DEN87DTM01](https://openairdocs.org/ntsb/DEN87DTM01.md): Evans VP-2 · Cedar Valley, UT · Accident · Serious injuries · Final report · Sep 18, 1987 · N84772 · Destroyed > The acft was flown by two different plts who complained of stiff ailerons. The aileron system was examined but no deficiencies were noted. A third plt then took off and began a lt turn at about 75 to 100 ft AGL. When he attempted to return to wings level he… - [NTSB FTW87DPJ07](https://openairdocs.org/ntsb/FTW87DPJ07.md): Mooney M20F · Jenks, OK · Accident · No injuries · Final report · Sep 17, 1987 · N9520M · Substantial damage > Engine failed during initial climb. Aircraft collided with airport perimeter fence and slid across road during landing attempt. Water was found in the fuel distributor system following the accident. - [NTSB ANC87LA161](https://openairdocs.org/ntsb/ANC87LA161.md): Piper PA-18 · Sparrevohn, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1987 · N7051 · Substantial damage > The pilot of the airplane was an Alaska state trooper performing his official duties and was flying an airplane owned and operated by the state of Alaska. He had landed on a remote ridge top to recover essential items of evidence for a pending case. Upon… - [NTSB ANC87LA158](https://openairdocs.org/ntsb/ANC87LA158.md): Cessna 207 · Two Lakes, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1987 · N1786U · Substantial damage > The pilot stated the gravel airstrip was muddy and he lifted off at the end of the strip. The aircraft clipped a tree with the horizontal stabilizer and the airplane settled into the trees. - [NTSB ANC87LA157](https://openairdocs.org/ntsb/ANC87LA157.md): Cessna 185 · Little Delta Rv, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1987 · N9914X · Substantial damage > The pilot stated that approximately 1000 feet after commencing the take off the airplane climbed to just above tree top level and then began to settle into the trees. The pilot also stated he believes the airplane stalled. - [NTSB FTW87LA220](https://openairdocs.org/ntsb/FTW87LA220.md): Bell 206B · Gulf Of Mexico · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 1987 · N2206F · Destroyed > While departing from an off-shore oil platform in the Gulf Of Mexico, the helicopter eng lost power. The plt initiated an autorotation & made a mayday call, but did not get the emerg floats inflated before touching down in the water. Subsequently, the… - [NTSB ATL87LA260](https://openairdocs.org/ntsb/ATL87LA260.md): Bellanca 17-30A · Louisville, KY · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 1987 · N7378V · Substantial damage > The plt made two attempts to land and during his 2nd go around the eng cut out. The plt stated that he switched from left tank to rt tank but was unable to start the eng prior to making a forced landing which resulted in a collision with a house and tree. The… - [NTSB ANC87LA154](https://openairdocs.org/ntsb/ANC87LA154.md): Piper PA-18A · Windy Ridge, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 1987 · N9350D · Substantial damage > The pilot stated that he had just lifted off from the gravel bar hen he stalled the aircraft and crashed. - [NTSB LAX87LA336](https://openairdocs.org/ntsb/LAX87LA336.md): Piper PA-18-150 · Byron, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1987 · N999BA · Destroyed > With the wind out of the southwest at 8 to 10 knots, the plt was taxiing the acft in a northerly direction at a high enough speed to keep 'on the step'. When he attempted to turn the acft to a southwesterly heading for tkof, the acft failed to respond. Rather… - [NTSB ANC87LA160](https://openairdocs.org/ntsb/ANC87LA160.md): Cessna 185 · Mt. Watana, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1987 · N5416R · Substantial damage > After liftoff from a lake the airplane's engine stopped producing power and the airplane began settling toward the remaining lake. The engine surged and the airplane crashed on the tundra, 200 yards from the lake's edge. The pilot stated that he drained the… - [NTSB SEA87LA187](https://openairdocs.org/ntsb/SEA87LA187.md): Piper PA-18 · John Day, OR · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1987 · N1394V · Destroyed > Plt departed hay field in hi density alt conds. The pilot was unable to clear trees and stalled/mushed into terrain, collapsing gear and colliding with trees. - [NTSB ANC87LA152](https://openairdocs.org/ntsb/ANC87LA152.md): Piper PA-18-150 · Stoney River, AK · Accident · No injuries · Limited investigation · Final report · Sep 14, 1987 · N5656Y · Substantial damage > The pilot stated that during the initial climbout he lost directional control of the aircraft; stalled and crashed on the gravel bar. Plt did not submit an acc report. - [NTSB ANC87LA150](https://openairdocs.org/ntsb/ANC87LA150.md): Aeronca 7AC · Island Lake, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 14, 1987 · N82171 · Substantial damage > The pilot stated that during the initial climbout the aircraft lost power, stalled, and crashed into a row of trees near the lake. The pilot also stated it was fuel contamination which caused a partial power loss. - [NTSB ATL87LA258](https://openairdocs.org/ntsb/ATL87LA258.md): Beech A23-24 · Fremont, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 1987 · N3651Q · Substantial damage > The eng lost pwr shortly after tkof. A forced lndg was made in a field where the acft impacted a ditch. Post-crash exam of the acft engine revealed water and solid contamination in the fuel injector servo. The plt had recently purchased the acft. The acft… - [NTSB LAX87DJA09](https://openairdocs.org/ntsb/LAX87DJA09.md): Emair MA-1-B · Paauilo, HI · Accident · No injuries · Final report · Sep 11, 1987 · N9924M · Substantial damage > During an aerial application flt, just after take off, the plt noted that the engine oil temp was high and that blue smoke was coming from the engine. Unable to land at the airport, the acft collided with the terrain short of the runway and nosed over.… - [NTSB BFO87LA064](https://openairdocs.org/ntsb/BFO87LA064.md): Piper PA-28-140 · Clinton, MD · Accident · No injuries · Limited investigation · Final report · Sep 11, 1987 · N5515U · Substantial damage > During takeoff with the aircraft over the end of the runway, power loss occurred. The pilot landed straight ahead in a field and nosed over. Examination of the aircraft did not disclose any mechanical malfunctions/failures. The engine was started and operated… - [NTSB NYC87DGM03](https://openairdocs.org/ntsb/NYC87DGM03.md): Woody Pitts S1 · Irwin, PA · Accident · No injuries · Final report · Sep 10, 1987 · N290RW · Substantial damage > The pilot's inability to maintain control of the aircraft during initial climbout. Inadvertent use of the rudder controls was a factor. - [NTSB DEN87LA235](https://openairdocs.org/ntsb/DEN87LA235.md): Bell 47-G3B2 · Oakley, UT · Accident · No injuries · Limited investigation · Final report · Sep 10, 1987 · N1038X · Substantial damage > The plt had just taken off from a confined area surrounded on two sides with electrical power lines. As he attempted to climb, he said his RPM began to bleed off. He stated that he made a right pedal turn to avoid the wires but was unable to prevent a hard… - [NTSB ATL87LA253](https://openairdocs.org/ntsb/ATL87LA253.md): Luscombe 8E · Cartersville, GA · Accident · No injuries · Limited investigation · Final report · Sep 10, 1987 · N2600K · Substantial damage > The plt reported a loss of power on climb out. An off arpt landing attempt resulted in impact with trees and substantial damage to the acft. Temperature and dewpoint were within the range for carburetor ice buildup. Examination of the acft revealed a cruise… - [NTSB ATL87DEI13](https://openairdocs.org/ntsb/ATL87DEI13.md): Bushby Mustang II · Salem, OH · Accident · Minor injuries · Final report · Sep 10, 1987 · N80ET · Substantial damage > A coml plt (PIC in the left seat) was providing a familiarization flt for a pvt plt (coplt in the rgt seat). The PIC allowed the rgt seat plt to make the takeoff. The PIC rprtd that after the acft lifted off & climbed about 5 to 10 ft, the rgt wing dipped &… - [NTSB NYC87DHA02](https://openairdocs.org/ntsb/NYC87DHA02.md): Kolb Twinstar · Hilltown, PA · Accident · 2 fatal · Final report · Sep 9, 1987 · N23EH · Substantial damage > After the acft took off, witnesses heard a power change & saw what appeared to be a left turn to return to the grass strip. Subsequently, it entered a descent & crashed in a left wing down, nose low attitude. The passenger was taken to a hospital, but died… - [NTSB CHI87LA209](https://openairdocs.org/ntsb/CHI87LA209.md): Cessna 182RG · Marine City, MI · Accident · No injuries · Limited investigation · Final report · Sep 9, 1987 · N251NW · Destroyed > PIC lost directional control during lift-off. The aircraft then drifted left, away from the runway, cartwheeled and came to rest upside down. The PIC and passenger exited the aircraft as it started to burn. The PIC stated that he noted immediately a crosswind… - [NTSB MIA87LA241](https://openairdocs.org/ntsb/MIA87LA241.md): Piper PA-28 · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Sep 7, 1987 · N5581U · Substantial damage > Shortly after takeoff, the eng began to lose pwr & the plt was unable to maint alt or return to the arpt. He elected to land on a road, but there was oncoming traffic, so he maneuvered to the left side. Subsequently, the left wing collided with a utility… - [NTSB ANC87LA143](https://openairdocs.org/ntsb/ANC87LA143.md): Piper PA-22-135 · Iowa Ridge, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1987 · N8510C · Substantial damage > The pilot was awakened in the night at his hunting camp by strong winds estimated at 70 - 80 mph. His airplane came loose at its tie-down and he elected to try and fly it to a safer location. Shortly after take off he lost control of the airplane and crashed.… - [NTSB CHI87LA204](https://openairdocs.org/ntsb/CHI87LA204.md): Piper PA-28-235 · Indianapolis, IN · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1987 · N9287W · Substantial damage > The acft was on the third tkof of the day when the eng stopped on initial climb at the pilots estimated alt of 500 ft. he did a 180 turn back to the arpt but touched down short and ran through the perimeter fence. Examination of the acft revealed that the… - [NTSB ANC87LA144](https://openairdocs.org/ntsb/ANC87LA144.md): Piper PA-18 · Tanana, AK · Accident · No injuries · Limited investigation · Final report · Sep 6, 1987 · N4136E · Substantial damage > The pilot stated that he just lifted off the lake when the engine quit. The aircraft stalled and crashed into the lake. The pilot stated that he just ran out of fuel. - [NTSB ANC87FA138](https://openairdocs.org/ntsb/ANC87FA138.md): Cessna 175A · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Sep 6, 1987 · N6921E · Substantial damage > The acft contacted a row of trees and crashed in a residential area shortly after takeoff. The pilot reported, that a downdraft was encountered after establishing a positive rate of climb on takeoff. Airspeed decreased when the downdraft was encountered and… - [NTSB FTW87FA210](https://openairdocs.org/ntsb/FTW87FA210.md): Bellanca 7ACA · Graford, TX · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1987 · N68529 · Substantial damage > The pilot departed possum kingdom airport and entered a crosswind turn. The pilot heard a loud 'pop' and could not move the aileron control to recover from the turn. The aircraft entered an uncontrolled descent and crashed into a lake. The aileron pulley for… - [NTSB MKC87LA170](https://openairdocs.org/ntsb/MKC87LA170.md): Ryan ST3KR · Springdale, AR · Accident · No injuries · Limited investigation · Final report · Sep 3, 1987 · N3761Q · Substantial damage > The plt rprtd that shortly after takeoff, the eng lost power, recovered for a few seconds, then went to idle. Drg the few seconds that power was restored, he initiated a turn back toward the rwy. The plt said the acft started to snap roll to the left & went… - [NTSB LAX87DUG08](https://openairdocs.org/ntsb/LAX87DUG08.md): Boyles Starduster II · Hemet, CA · Accident · Serious injuries · Final report · Aug 31, 1987 · N1189B · Substantial damage > The plt rprtd that shortly after takeoff, the eng began to 'cut out.' He moved the fuel selector to the reserve tank & activated the standby fuel pump, but was unable to restart the eng. Subsequently, the acft was damaged as the plt was making an emergency… - [NTSB CHI87DEX08](https://openairdocs.org/ntsb/CHI87DEX08.md): Champion 7KCAB · Sheridan, IN · Accident · Minor injuries · Final report · Aug 31, 1987 · N6343N · Substantial damage > On initial climbout at approximately 400' AGL the aircraft experienced a total power failure. The pilot attempted to maneuver the aircraft to return to the airport, however, the aircraft was forced to land in a farm field 1/4 mile short of the airport. The… - [NTSB SEA87LA179](https://openairdocs.org/ntsb/SEA87LA179.md): Cessna 180H · Shelton, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1987 · N4789U · Destroyed > During initial climbout the pilot stated that a loss of power occurred. However, no reason for loss of power could be found. An eye witness to the accident stated that he heard power throughout the takeoff to the moment of impact. The propeller showed heavy… - [NTSB LAX87LA328](https://openairdocs.org/ntsb/LAX87LA328.md): Cessna 310D · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · Aug 30, 1987 · N39DD · Substantial damage > The pilot-in-command (PIC) rprtd that he heard a loud bang during gear retraction after takeoff. By using the convex mirrors mounted on the tip tanks, he determined that the nose gear was hanging. He cycled the landing gear switch several times, but the nose… - [NTSB CHI87FA198](https://openairdocs.org/ntsb/CHI87FA198.md): Beech B35 · Martinsville, IN · Accident · 2 fatal · Field investigation · Final report · Aug 30, 1987 · N700T · Substantial damage > Shortly after takeoff an engine failure occurred. The aircraft stalled and spun to the ground when the pilot tried to return to the airport. The fuel selector was positioned on the almost empty auxiliary tank (meant for use in level flight only). - [NTSB LAX87DUJ10](https://openairdocs.org/ntsb/LAX87DUJ10.md): Cessna 188B · Poston, AZ · Accident · No injuries · Final report · Aug 29, 1987 · N8275G · Substantial damage > Just after liftoff one propeller blade separated from the hub near the outboard end of the associated ferrule fitting which induced a failure of the cranckshaft. The pilot made a forced landing, overran the runway end and nosed over. Metallurgical analysis… - [NTSB NYC87FA241](https://openairdocs.org/ntsb/NYC87FA241.md): Piper PA-23-160 · Selinsgrove, PA · Accident · 3 fatal · Field investigation · Final report · Aug 28, 1987 · N4003P · Destroyed > The pilot was conducting a demonstration flight in an overweight aircraft in conditions of low ceilings and fog. After a touch and go landing the aircraft stalled during the takeoff then collided with the ground. Exam of the wreckage did not disclose any… - [NTSB LAX87FA318](https://openairdocs.org/ntsb/LAX87FA318.md): Bell 206L-1 · Covelo, CA · Accident · No injuries · Field investigation · Final report · Aug 27, 1987 · N22HU · Substantial damage > The pilot performed a vertical takeoff. At aprx 30 ft AGL, while transitioning to forward flight, the engine lost power and the pilot partially lowered the collective to maintain rotor RPM. The helicopter landed hard on sloping terrain and bounced laterally… - [NTSB FTW87DRD12](https://openairdocs.org/ntsb/FTW87DRD12.md): Piper PA-22-150 · Mansfield, LA · Accident · Serious injuries · Final report · Aug 24, 1987 · N5700D · Destroyed > The airport was 324 feet above sea level. The OAT was 96 degrees f. the airplane, with the pilot and two passengers, lifted off the rwy but would not climb. A witness stated the engine sounded normal but the nose was very high. The airplane impacted trees and… - [NTSB NYC87LA239](https://openairdocs.org/ntsb/NYC87LA239.md): Taylorcraft BC-12D · Bingham, ME · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1987 · N96241 · Substantial damage > The plt rprtd he was taking off from a lake & was climbing thru about 200-300 ft AGL when the acft enctrd a severe downdraft. Subsequently, the float plane collided with rising terrain. No preimpact part failure or malfunction was rprtd. The plt rprtd the… - [NTSB MIA87IA229](https://openairdocs.org/ntsb/MIA87IA229.md): Cessna 402B · W.Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Aug 23, 1987 · N3767C · Minor damage > The lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the… - [NTSB MIA87FA231](https://openairdocs.org/ntsb/MIA87FA231.md): Cessna 182A · Pensacola, FL · Accident · Serious injuries · Field investigation · Final report · Aug 23, 1987 · N4741D · Destroyed > The plt stated that just after liftoff he flew into a layer of haze and became disoriented, the aircraft stalled, crashed into a dirt mound, spun around and came to rest off the left side of the runway. The aircraft then exploded and was consumed by post… - [NTSB LAX87LA316](https://openairdocs.org/ntsb/LAX87LA316.md): Piper PA-30-160 · Condord, CA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N8441 · Substantial damage > After an annual inspection the acft was prepared for a test flight. The pilot loaded 3 passengers and began the run-up checks. During run-up the left engine ran rough. After the roughness cleared the pilot initiated the takeoff. As the acft accelerated down… - [NTSB LAX87LA312](https://openairdocs.org/ntsb/LAX87LA312.md): Gulfstream American AA-5A · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1987 · N26250 · Substantial damage > The plt reported that just after takeoff, the engine lost partial power & he was unable to land back at the airport. During an emergency landing, the aircraft collided with a utility line & pole. An exam of the engine revealed that a rocker arm on the #4… - [NTSB ANC87LA128](https://openairdocs.org/ntsb/ANC87LA128.md): Piper PA-12-150 · Little Delta, AK · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N3341M · Substantial damage > The pilot stated that he was taking off downhill with a 10 knot tailwind. At that time the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft settled into brush and nosed over. - [NTSB MKC87FA165](https://openairdocs.org/ntsb/MKC87FA165.md): Piper PA-22-150 · Batesville, AR · Accident · 3 fatal · Field investigation · Final report · Aug 22, 1987 · N6079D · Destroyed > The airplane was at maximum gross weight at takeoff. The field elevation was 613 feet and the density altitude was 3300 feet. There were two runways available. Runway 25 was 6002 feet long and had a slight headwind from the southwest. Runway 35 was 3320 feet… - [NTSB BFO87DHD08](https://openairdocs.org/ntsb/BFO87DHD08.md): Bede BD5B · Wilmington, DE · Accident · Minor injuries · Final report · Aug 21, 1987 · N533BD · Destroyed > The pilot's failure to attain sufficient altitude to clear obstacles located off the departure end of the runway. His overconfidence in the homebuilt aircraft's performance was a contributing factor. - [NTSB FTW87FA203](https://openairdocs.org/ntsb/FTW87FA203.md): Aerospatiale AS-355F-1 · Ship Shoal 214c · Accident · Serious injuries · Field investigation · Final report · Aug 19, 1987 · N359E · Substantial damage > Acft experienced a tail rotor drive shaft failure during t/o from an offshore platform. Acft spun left and completed 6 to 7 revolutions prior to water contact as the single plt could not reach the throttles to reduce pwr to idle. Acft landed hard and the rt… - [NTSB CHI87LA193](https://openairdocs.org/ntsb/CHI87LA193.md): Piper PA-28-140 · Troy, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 1987 · N32387 · Substantial damage > While the plt was using short field techniques for takeoff, the acft lifted off into ground effect. At about that time, the plt thought there was a partial power loss. He stated, 'after perceiving a partial power loss which was accompanied with a loss in… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=167 ## 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=166 --- 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.