# NTSB investigations: Enroute 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 338 of 718 · 35,889 cases ## Cases, newest first - [NTSB CHI85FA269](https://openairdocs.org/ntsb/CHI85FA269.md): Chamberlain Viking Dragonfly · Faribault, MN · Accident · 2 fatal · Field investigation · Final report · Jul 7, 1985 · N59BC · Destroyed > The acft collided with trees and burst into flames during a forced landing. On the plt's second radio contact with Faribault municipal airport UNICOM he declared, 'I have engine failure. I'm going down in a corn field.' Post accident inspection of the… - [NTSB LAX85LA307](https://openairdocs.org/ntsb/LAX85LA307.md): Cessna 152 · Fall River Mill, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1985 · N94295 · Substantial damage > The student plt, on her first solo cross-country flt, departed for a planned 97 NM, 67 min trip. While enroute, the winds aloft increased in velocity and the student failed to adequately compensate for the drift. The student became lost, & after flying for… - [NTSB DEN85LA185](https://openairdocs.org/ntsb/DEN85LA185.md): Eiriavion PIK-20B · Grand Lake, CO · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N563Y · Substantial damage > On returning from a 300-kilometer cross-country flight, in a glider the pilot noticed the absence of thermal activity and was forced to land in an open field. The pilot said he landed with a 2-5 knot tailwind and his approach and touchdown speed was too fast.… - [NTSB DEN85LA181](https://openairdocs.org/ntsb/DEN85LA181.md): Cessna 170B · Swan Lake, MT · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N2432D · Substantial damage > The plt said that prior to departure there was an estimated 14 gals of fuel on board. After aprx 30 minutes of flight the eng lost all pwr and a forced landing was accomplished in a mountainous creek bed. During the landing roll the acft struck a feeled tree… - [NTSB CHI85LA279](https://openairdocs.org/ntsb/CHI85LA279.md): Cessna 150F · Fond Du Lac, WI · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N8219S · Substantial damage > The acft nosed over in soft terrain 1/4 mile short of the rwy at fon du lac arpt following a total loss of pwr. The flt departed henderson, KY, at 1510 CDT with 26 gallons of fuel and the pwr loss occurred at 1925 CDT, 4 hrs and 15 minsafter departure. Post… - [NTSB CHI85LA271](https://openairdocs.org/ntsb/CHI85LA271.md): Jodel D-11 · Wooster, OH · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N4628S · Substantial damage > The pilot and pax were on a x-country pleasure flt. After 2420 hrs of fliht, 45 mi short of dest, the engine stopped the acft was ld in a corn fld. Examination disclosed main bearing failure. - [NTSB SEA85LA170](https://openairdocs.org/ntsb/SEA85LA170.md): Piper PA-24-250 · Mccall, ID · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N5829P · Substantial damage > The acft was damaged during a forced landing in a fld following fuel exhaustion. The plt reported he departed yellow pine, ID, with the fuel gages indicating 1/2. Upon reaching an alt of 10,000 ft, the eng quit due to fuel exhaustion. The right fuel tank was… - [NTSB CHI85LA278](https://openairdocs.org/ntsb/CHI85LA278.md): Grumman TR2 · Crookston, MN · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N9891L · Substantial damage > The acft nosed over in a fld during a forced landing following a total loss of pwr. The plt reported the fuel consumption during the flt seemed higher than usual. He then began looking for Crookston municipal arpt to land. Aprx 3 miles se of the arpt the pwr… - [NTSB CHI85LA272](https://openairdocs.org/ntsb/CHI85LA272.md): Stinson 108-2 · Hastings, MI · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N9306K · Destroyed > The purpose of the flight was to break in the newly overhauled engine. The pilot stated that he had been flying around the local area for about 25 minutes when he heard a clank and the engine lost complete power. The pilot determined that a tree landing was… - [NTSB MKC85FCQ04](https://openairdocs.org/ntsb/MKC85FCQ04.md): Ryan Navion · Blue Rapids, KS · Accident · Serious injuries · Final report · Jul 4, 1985 · N4482K · Substantial damage > The acft eng lost power after a 30 minute flt and a forced landing resulted in an off.-arpt acc. Witnesses at the acc site did not find any fuel in the tanks or evidence of spillage of fuel. An inspection of the eng did not reveal any discrepancies. A… - [NTSB MIA85LA207](https://openairdocs.org/ntsb/MIA85LA207.md): Quinn EL Tomcat MK-5A · Blakley, GA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N8429 · Substantial damage > While en route to reposition the helicopter to another farm, the eng lost power. The plt reported that during an autorotation, the main rotor lost some RPM as he stretched his glide to avoid a fence. As the helicopter touched down on uneven terrain, the main… - [NTSB CHI85LA266](https://openairdocs.org/ntsb/CHI85LA266.md): Cessna 152 · Elkhorn, WI · Accident · No injuries · Limited investigation · Final report · Jul 3, 1985 · N65562 · Substantial damage > The acft collided with the terrain during a low alt maneuver. The plt said that he allowed the airspeed to dissipate during a turn and before he could recover the acft hit the ground. - [NTSB NYC85FA260](https://openairdocs.org/ntsb/NYC85FA260.md): Douglas DC-9 · Boston, MA · Incident · Serious injuries · Field investigation · Final report · Jul 2, 1985 · N968BJ · No damage > The acft was climbing out of 10000 ft, shortly after tkf, when the PIC lost consciousness. The copilot took control of the flight and returned to Boston where a lndg occured without incident. Medical examination of the PIC revealed that he suffered a heart… - [NTSB LAX85FA304](https://openairdocs.org/ntsb/LAX85FA304.md): Maule M-6-180 · Corona, CA · Accident · 2 fatal · Field investigation · Final report · Jul 2, 1985 · N5658F · Destroyed > During a banner towing mission, the acft was observed flying at low alt near California state freeway 91. According to witnesses, the banner collided with power lines after the acft had crossed over the lines at a relatively slow speed. The banner & tow… - [NTSB FTW85LA276](https://openairdocs.org/ntsb/FTW85LA276.md): Grumman AA1B · Robinson, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1985 · N8995L · Substantial damage > Shortly after takeoff the plt experienced a loss of pwr. Unable to glide to a suitable landing area, a forced landing was attempted in tall corn. The acft nosed over sustaining substantial damage. Subsequent exam revealed that the carburetor float had become… - [NTSB LAX85FA301](https://openairdocs.org/ntsb/LAX85FA301.md): Beech 95-B55 · Corona, CA · Accident · 3 fatal · Field investigation · Final report · Jul 1, 1985 · N5794X · Destroyed > During en route descent the plt told the radar controller tht he had lost an eng and could not hold alt. Witnesses saw the acft descending toward hilly terrain, begin a right turn, then abruptly pitch down and roll right to impact in a residence yard on the… - [NTSB MIA85LA204](https://openairdocs.org/ntsb/MIA85LA204.md): North American Navion · Cooper City, FL · Accident · No injuries · Limited investigation · Final report · Jun 30, 1985 · N8784H · Substantial damage > The plt reported that the eng lost power during a descent about 5 mi from the arpt. Subsequently, the left wing & left main gear were damaged during a forced landing on a highway ramp area that was being built. An exam of the acft revealed that the fuel tanks… - [NTSB ANC85LA113](https://openairdocs.org/ntsb/ANC85LA113.md): Piper PA-12 · Kenai, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1985 · N4011M · Substantial damage > The plt reported that when he departed seward. The fuel gages indicated there was aprx 15 gal on board. About 5 min from the intended destination, the eng lost power from fuel exhaustion while the left fuel gage showed there was 5 gal remaining. During an… - [NTSB MKC85LA143](https://openairdocs.org/ntsb/MKC85LA143.md): Shindler Special Great Lakes · Gentry, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1985 · N8727 · Substantial damage > The plt became disoriented on a cross-country flight from manhattan, Kansas, to marysville, Missouri. Flying off course for a short time, the plt regained his directions to his fueling stop. While returning to his intended fuel stop the acft eng stopped and a… - [NTSB NYC85LA157](https://openairdocs.org/ntsb/NYC85LA157.md): Schweizer SGS 1-26 · Cambria, NY · Accident · No injuries · Limited investigation · Final report · Jun 28, 1985 · N691U · Substantial damage > The glider, while returning to land after a pleasure flt, encounter a rainshower and strong downdraft. The plt made a landing in a farmers fld. During the landing the right wing caught and the acft ground looped, incurring substantial damage. - [NTSB MIA85FA202](https://openairdocs.org/ntsb/MIA85FA202.md): Piper PA-32RT-300T · Pembroke Pines, FL · Accident · Minor injuries · Field investigation · Final report · Jun 28, 1985 · N633RE · Destroyed > The acft experienced a complete in flt loss of his prop after departure from north perry arpt hollywood FL due to a fatigue failure of the prop hub. The fatigue cracking was due to residual stress resulting from deformation of the material in the hub ass'y - [NTSB FTW85LA269](https://openairdocs.org/ntsb/FTW85LA269.md): Cessna 182 · Pearsall, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1985 · N200KH · Substantial damage > A commercially rated CFI departed on a part 135 air taxi flt, but encountered deteriorating weather conditions. Circling his destination he reported that rain clouds closed in. Anticipating that he would be unable to file IFR in the air, he elected to land in… - [NTSB CHI85LA264](https://openairdocs.org/ntsb/CHI85LA264.md): Cessna 172H · Coleman, WI · Accident · No injuries · Limited investigation · Final report · Jun 28, 1985 · N3859R · Substantial damage > The pilot departed on a short x-country flt. Stated fuel aboard was 8 gls. Pilot diverted from drct flt and ran out of fuel after one hour airborne. Ld in farm field. Struck a post with resultant sub damage to airframe. - [NTSB CHI85LA257](https://openairdocs.org/ntsb/CHI85LA257.md): Piper PA-28-181 · Oxford, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1985 · N9459K · Substantial damage > While on a round-robin flight at night the pilot experienced an alternator failure. As he was returning to his point of origin the battery power depleted leaving him with no radios or landing light and only a flashlight for cockpit lighting. He decided to… - [NTSB CHI85FA258](https://openairdocs.org/ntsb/CHI85FA258.md): Piper PA-32RT-300T · Merom, IN · Accident · 1 fatal · Field investigation · Final report · Jun 28, 1985 · N39554 · Destroyed > The aircraft was on a visual flight from fairfield Iowa to indianapolis, IN and was about 55 mautical miles south of course when the aircraft broke up in flight. The main wreckage, empennage, and outer wing sections landed within about a quarter of a mile of… - [NTSB MIA85LA201](https://openairdocs.org/ntsb/MIA85LA201.md): Piper PA-44-180 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1985 · N2198T · Substantial damage > The acft settled gear up onto the rwy during an attempted go around from a simulated single engine apch. The student flared too high & requested command of both throttles from the CFI. Pwr was applied & the flaps & gear were prematurely retracted. The acft… - [NTSB LAX85IA297](https://openairdocs.org/ntsb/LAX85IA297.md): Boeing 737-247 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Jun 27, 1985 · N473AC · Minor damage > The captain stated that the 'b' hydraulic system low oil leval lamp illuminated while the acft was in cruise flt. As he completed the failure check and placed the 'b' system into standby rudder condition that provides hydraulic pressure to only the rudder,… - [NTSB MKC85LA141](https://openairdocs.org/ntsb/MKC85LA141.md): Cessna 150M · Rushville, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1985 · N704ZS · Substantial damage > Shortly after the plt departed on a flt, the eng lost power while the acft was cruising at 1800 ft MSL over hilly terrain. The plt reported that the eng speed dropped to 800 RPM & he was unable to correct the situation. During a forced landing on soft… - [NTSB FTW85FA265](https://openairdocs.org/ntsb/FTW85FA265.md): Aerospatiale AS35OD · Dallas, TX · Accident · 1 fatal · Field investigation · Final report · Jun 26, 1985 · N148BH · Destroyed > The eng to transmission short shaft became disconnected in flt. This resulted in complete loss of pwr to the main rotor assembly. However, the tail rotor assembly was still being powered by the eng. Upon collective pitch application to stop the descent the… - [NTSB ANC85LA108](https://openairdocs.org/ntsb/ANC85LA108.md): Aeronca 7DC · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jun 25, 1985 · N4353E · Destroyed > While in flt, the plt smelled smoke. Within 30 sec, smoke was observed coming from around the firewall & under the floorboards. The acft was over an airstrip, so the plt made a 360 deg turn & landed there. The plt said that he immediately applied brakes when… - [NTSB MIA85LA198](https://openairdocs.org/ntsb/MIA85LA198.md): Piper PA-23-250 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Jun 24, 1985 · N21ML · Destroyed > The plt reported that during an overwater flt, a fire began in the front section of the acft while he was cruising at 10,500 ft. he radioed his position on the emergency freq (121.5 mhz) & squawked an emergency code (7700) on his transponder. Subsequently, he… - [NTSB MIA85IA203](https://openairdocs.org/ntsb/MIA85IA203.md): Mitsubishi MU-2K · San Juan, PR · Incident · No injuries · Incident investigation · Final report · Jun 24, 1985 · N7DD · Minor damage > After departure the nose gear unsafe light remained illuminated peter gear retraction. Attempts to get a safe light on the nose gear in the extended position was unsuccessful and when the aircraft landed it settled onto a partially retracted nose gear.… - [NTSB CHI85LA247](https://openairdocs.org/ntsb/CHI85LA247.md): Let L-13 · Gregory, MI · Accident · No injuries · Limited investigation · Final report · Jun 23, 1985 · N14420 · Substantial damage > The glider landed in trees after the spoiler 'popped' open in flt during a towed takeoff. The tow plane released the glider at 300 ft AGL after the spoilers opened. The plt landed without retracting the spoilers. Two FAA inspectors stated that they checked… - [NTSB CHI85FA249](https://openairdocs.org/ntsb/CHI85FA249.md): Boeing 727 · South Haven, MI · Accident · Serious injuries · Field investigation · Final report · Jun 23, 1985 · N1965 · 2 aircraft · No damage > While en route on an IFR flt plan (1st officer at ctls), American flt 803 (a Boeing 727, N1965) bgn a dscnt fm FL 190 TO9000'. The seat belt sign was turned on at 18,000'. While dscndg btn cld layers, at aprx 13,000 to 12,000', the capt sawa Cessna 421C,… - [NTSB ATL85FA193](https://openairdocs.org/ntsb/ATL85FA193.md): Bell 206L-1 · Ghent, WV · Accident · No injuries · Field investigation · Final report · Jun 21, 1985 · N27716 · Substantial damage > The plt took off at 1805 with 150 lbs of fuel remaining, intending to fly to beckley, WV to refuel. He stated that afterhe was in lvl flt at about 3000 ft MSL for 3 to 4 min, he noted an unusual jerk or vibration in the rear. Suspecting a psbl tail rotor… - [NTSB CHI85LA260](https://openairdocs.org/ntsb/CHI85LA260.md): Stinson 108-1 · Roseau, MN · Accident · No injuries · Limited investigation · Final report · Jun 20, 1985 · N9070K · Substantial damage > The plt intentionally ground looped the acft during a forced landing to avoid obstacles following a loss of power en route. Aprx 1 1/2 hrs into the flt the plt noticed an engine roughness followed by an increase in oil temp which returned to normal shortly… - [NTSB CHI85FEX03](https://openairdocs.org/ntsb/CHI85FEX03.md): Piper PA-28-180 · Orleans, IN · Accident · Serious injuries · Final report · Jun 20, 1985 · N7750N · Substantial damage > During flt, the plt noted that the eng RPM dropped from 2500 to 2000. He could not restore the RPM. He then heard a loud noise from the eng compartment & the eng seized. Subsequently, the acft was damaged during an emerg landing in a corn field. A teardown of… - [NTSB FTW85FA259](https://openairdocs.org/ntsb/FTW85FA259.md): Swearingen SA-26AT · Rocksprings, TX · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1985 · N199TA · Destroyed > As the acft was climbing thru 14,800' for 19,000', the plt reported a rapid decompression. Two minutes later, he reported that he has lost the tail. Acft impacted in an inverted flat spin and the tail and a section of empennage were found about 3/4 mile away… - [NTSB DEN85FA167](https://openairdocs.org/ntsb/DEN85FA167.md): Cessna 402B · Bailey, CO · Accident · 8 fatal · Field investigation · Final report · Jun 17, 1985 · N100HK · Destroyed > Ground witnesses observed the acft enter low clouds going south, then emerge from clouds going went. Acft collided with mountain in wings-level and powered attitude. Mountains were reported to be obscured by clouds and fog. - [NTSB MIA85LA194](https://openairdocs.org/ntsb/MIA85LA194.md): Boeing B-737-201 · Vero Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1985 · N814N · No damage > The acft was deviating around thunderstorm cells when it encountered heavy turbulence. The cabin attendants were conducting beverage service at the time. The passengers andybeen advised to gasten their seat belts and the 'fasten seat belts' lights were on.… - [NTSB NYC85LA151](https://openairdocs.org/ntsb/NYC85LA151.md): Burkhart Grob G-103-II Aero · Erwinna, PA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N217BG · Substantial damage > The glider contacted tall hay in a fld and ground looped during an off arpt forced landing. The plt stated the glider was released downwind from the arpt at an alt of aprx 3000 ft AGL. A sink rate of 1000 fpm developed preventing the plt from returning to… - [NTSB LAX85LA282](https://openairdocs.org/ntsb/LAX85LA282.md): Bell 206B-III · Lahaina, HI · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N3179X · Substantial damage > The pilot reported that the engine failed at an altitude of 800 feet MSL during the climb to cruise phase of a sightseeing flight with 3 passengers on board. The acft landed in the surf of the pacific ocean and damaged the tail rotor. The pilot and passengers… - [NTSB FTW85FA257](https://openairdocs.org/ntsb/FTW85FA257.md): Cessna T210N · Mineral Wells, TX · Accident · Minor injuries · Field investigation · Final report · Jun 15, 1985 · N6993N · Destroyed > The pilot experienced engine power failure due to fuel exhaustion for unknown reasons since about 30 gallons of fuel should have been on board when the crash occurred. The pilot was vectored toward the nearest airport but was unable to reach it and crashed… - [NTSB ATL85LA187](https://openairdocs.org/ntsb/ATL85LA187.md): Champion 7AC · Barnardsville, NC · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N83678 · Substantial damage > During a supervised solo x-country flt, the student acft experienced a loss of pwr at cruise. After reaching his first check point, the student reversed course because he departed on the wrong heading. Before reaching the first check point for the second… - [NTSB ATL85LA185](https://openairdocs.org/ntsb/ATL85LA185.md): Cessna 210L · Andalusia, AL · Accident · No injuries · Limited investigation · Final report · Jun 14, 1985 · N2427S · Substantial damage > The plt stated that shortly after takeoff, at about 700 ft MSL, the eng lost power with out warning after he made a power reduction to 2500 RPM & 25 inches of manifold pressure. He attempted to glide to a field, but the acft went into the tops of trees before… - [NTSB MKC85LA129](https://openairdocs.org/ntsb/MKC85LA129.md): Piper PA-28-181 · Ogallala, NE · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1985 · N83815 · Substantial damage > Plt reports that the eng quit due to fuel exhaustion. The power loss occurred 2 hrs. After t/o, 3 mi from dest. Plt had to maneuver around obstacle in field during landing and landed hard. - [NTSB MIA85FA191](https://openairdocs.org/ntsb/MIA85FA191.md): Aerospatiale SA316B · Silver Springs, FL · Accident · No injuries · Field investigation · Final report · Jun 13, 1985 · N49550 · Substantial damage > The plt of the helicopter on an on demand air taxi medevac flt encountered deteriorating wx conditions and attmepted to maintain VFR flt in IMC conditions. He descended and struck a tree causing substantial damage. He then made a forced landing and the… - [NTSB LAX85LA272](https://openairdocs.org/ntsb/LAX85LA272.md): Cessna 150M · Colusa, CA · Accident · No injuries · Limited investigation · Final report · Jun 13, 1985 · N704FU · Substantial damage > The plt preflighted the acft at night with a flashlight and noted 12-15 gals of fuel in the tanks. Upon level off at 5500 ft AGL he noted a slight lack of engine power. He also noted that one fuel tank was empty and the other tank read 1/4 full. Because of… - [NTSB MIA85LA190](https://openairdocs.org/ntsb/MIA85LA190.md): Cessna 150J · New Smyrna Bch, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 1985 · N51261 · Destroyed > While performing a banner towing flight the pilot encountered severe turbulence in the area of a thunderstorm and lost control of the acft. He stated he jettisoned the banner just before impact but still could not control the acft. The acft struck a small… - [NTSB SEA85LA178](https://openairdocs.org/ntsb/SEA85LA178.md): Bell 47G-3B-1 · Idaho City, ID · Accident · No injuries · Limited investigation · Final report · Jun 11, 1985 · N1333X · Substantial damage > While the student plt was on a x-country flt, the eng lost power after the supercharger failed. The plt stated that he was unable to maintain altitude & RPM; he subsequently made a forced landing in a heavily timbered, mountainous area. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=339 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=338 --- 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.