# 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 335 of 718 · 35,889 cases ## Cases, newest first - [NTSB CHI85LA361](https://openairdocs.org/ntsb/CHI85LA361.md): Cessna 150M · Wabash, IN · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1985 · N66550 · Substantial damage > The student plt was on a planned 3 leg x-country. On the second leg, he became ill and was lost for about one hour. He did not refuel as he though enough fuel remained to return to Wabash. The eng stopped about 7 miles from Wabash. The acft nosed down in a… - [NTSB SEA85LA205](https://openairdocs.org/ntsb/SEA85LA205.md): Cessna T210-M · Camano Island, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1985 · N761VV · Substantial damage > The plt failed to visually verify the fuel on board prior to takeoff and he was aware that one fuel gage was inaccurate.a total loss of pwr occurred over water aprx 30 miles from the intended destination arpt. The plt was able to reach land during the… - [NTSB MKC85LA198](https://openairdocs.org/ntsb/MKC85LA198.md): Cessna 150G · Camdenton, MO · Accident · No injuries · Limited investigation · Final report · Aug 30, 1985 · N3240J · Substantial damage > The pilot and son were on a personal cross-country flight when the engine quit. The airplane nosed forward to the inverted position during the landing roll. The reason for the engine failure could not be determined. - [NTSB MIA85FA241](https://openairdocs.org/ntsb/MIA85FA241.md): Grumman AA-1B · Daytona Beach, FL · Accident · Serious injuries · Field investigation · Final report · Aug 29, 1985 · N6502L · Substantial damage > Pilot did not know how to turn on the instrument panel lights nor did he have a flash light available. He continued flight into darkness of night at which time he became disoriented and lost. He continued to fly until he exhausted all fuel on the aircraft and… - [NTSB ATL85IA263](https://openairdocs.org/ntsb/ATL85IA263.md): Boeing 727-225 · Charleston, SC · Incident · Minor injuries · Incident investigation · Final report · Aug 29, 1985 · N8832E · No damage > The flight was level at 330 when it encountered turbulance and the arcraft moved an estimated 200 feet down then up before the crew could regain altitude control. Two flight attendents and several passengers initially complained of injuries. No documentation… - [NTSB NYC85LA233](https://openairdocs.org/ntsb/NYC85LA233.md): Grumman AA-1C · Wheatland, NY · Accident · No injuries · Limited investigation · Final report · Aug 28, 1985 · N9787U · Substantial damage > Acft departed leroy, NY, on an instructional flt to rochester, NY. Fifteen minutes after departure the flt made a forced landing in a bean field. Examination of the acft showed no useable fuel remained. - [NTSB NYC85LA226](https://openairdocs.org/ntsb/NYC85LA226.md): Smith, Ted Aerostar Aerostar 601P · Wrightstown, NJ · Accident · No injuries · Limited investigation · Final report · Aug 28, 1985 · N90342 · Substantial damage > During an enroute climb the pilot noticed a manifold pressure loss on the left engine. Oil pressure and temp gauges went off and the left engine was secured by the piilot. During shutdown a passenger informed the pilot that the left wing was turning brown.… - [NTSB ATL85FA261](https://openairdocs.org/ntsb/ATL85FA261.md): Beech C-99 · Conover, NC · Accident · 3 fatal · Field investigation · Final report · Aug 28, 1985 · N992SB · Destroyed > Acft was on trng flt for initial copilot qual for commuter air carrier. Instructor and two trainees were on board. The acft departed charlotte at about 2314EDT for the hickoryarea for trng. At about 0015EDT,it was reported that the crew visited the hickory… - [NTSB SEA85FA203](https://openairdocs.org/ntsb/SEA85FA203.md): Piper PA-32-300 · Bridge, ID · Accident · 1 fatal · Field investigation · Final report · Aug 27, 1985 · N2282M · Destroyed > At 1445 MDT, the 60 yr old plt departed on a routine, VFR, repositioning flt which he had frequently flown before. After takeoff, he leveled the acft at 9500 ft on a direct course toward the destination. While en route at about 1515, the acft began a shallow… - [NTSB NYC85LA223](https://openairdocs.org/ntsb/NYC85LA223.md): Cessna 150G · Reading, PA · Accident · No injuries · Limited investigation · Final report · Aug 27, 1985 · N2901S · Destroyed > During a descent for landing, the eng lost power & the plt made a forced landing in a grass field. However, the grass was damp & the plt was unable to stop the acft before it hit a cyclone fence. According to the local township police, the plt stated the acft… - [NTSB LAX85FA373](https://openairdocs.org/ntsb/LAX85FA373.md): Swearingen SA226TC Metro II · Fresno, CA · Accident · Minor injuries · Field investigation · Final report · Aug 27, 1985 · N139WW · Substantial damage > While in cruise flight at 16,000 feet one of the three propeller blades separated at the shank. The unbalanced condition twisted the eng from its mounts and into the fuselage. The cabin was punctured and rapid decompression followed. The crew was able to… - [NTSB LAX85LA367](https://openairdocs.org/ntsb/LAX85LA367.md): Cessna 172P · Glendale, CA · Accident · No injuries · Limited investigation · Final report · Aug 26, 1985 · N62868 · 2 aircraft · Substantial damage > As the acft approached its home arpt, on a westerly heading and looking into the sun, the plt began the descent. The acft's left wing severed the left horizontal stabilizer and elevator from an approaching acft. The plt continued his approach and landed… - [NTSB FTW85FA331](https://openairdocs.org/ntsb/FTW85FA331.md): Valentin Taifun 17E · Abilene, TX · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1985 · N164RB · Destroyed > The glider was thermaling in a slow right climbing turn about 600 feet above ground level. Witnesses stated it started a right spiraling descent and the nose suddenly dropped until it was in a near vertical attitude. The spiral then developed into a tight… - [NTSB BFO85FA071](https://openairdocs.org/ntsb/BFO85FA071.md): Cessna R182 · Browntown, VA · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1985 · N7393Y · Destroyed > Drg a wx briefing, flt prctns for ocnl mtn obscn & IMC were relayed to the plt, but he was not provided a forecast for thunderstorms, nor advised VFR flt was not rcmdd. The route of flt was portrayed as marginal VFR, as was the destn at morgantown (mgm).… - [NTSB BFO85FA070](https://openairdocs.org/ntsb/BFO85FA070.md): Cessna 120 · Afton, VA · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1985 · N1812V · Destroyed > The plt and his wife departed waynesboro arpt in reported VFR wx conditions at aprx 1700 hrs. According to the assistantarpt mgr the ceiling was about 2500 ft however, the mountain tops were obscured in the direction the acft flew towards. At about 1710 hrs… - [NTSB ATL85FA256](https://openairdocs.org/ntsb/ATL85FA256.md): Piper PA-31T · Flat Rock, NC · Accident · 5 fatal · Field investigation · Final report · Aug 24, 1985 · N600CM · Destroyed > Acft hit northwest side of ridge in level attitude,cruise speed,heading southeast. Conditions were dark night and the cloud ceiling was about 40 feet above the ridge. Pilot received wx brief before take off and en route which reported a ceiling of 10,000 feet… - [NTSB ANC85LA160](https://openairdocs.org/ntsb/ANC85LA160.md): Piper PA-18 · Yuki River, AK · Accident · No injuries · Limited investigation · Final report · Aug 23, 1985 · N83545 · Substantial damage > During a normal cruise the aircraft engine quit. The pilot attempted a emergency landing on the Yuki River. During the examination of the aircraft engine no mechanical failure or malfunction was noted. Water was located in both the fuel tanks and fuel lines. - [NTSB LAX85LA362](https://openairdocs.org/ntsb/LAX85LA362.md): Cessna 210 · Sylmar, CA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1985 · N9726X · Substantial damage > The pilot reported that the aircrafts engine experienced mechanical trouble and a forced landing on a freeway was attempted. The aircraft's left wing struck a metal center divider during the landing rollout. The results of an engine oil analysis revealed high… - [NTSB SEA85LA197](https://openairdocs.org/ntsb/SEA85LA197.md): Piper PA-25-23-5B · American Falls, ID · Accident · No injuries · Limited investigation · Final report · Aug 21, 1985 · N76942 · Substantial damage > While departing into bright morning sun from a road to spray crops, the pilot pulled up to avoid power lines. A departure stall was then entered into. The pilot dumped his chemical prior to striking the ground hard. - [NTSB LAX85LA360](https://openairdocs.org/ntsb/LAX85LA360.md): Schweizer G-164B · Tolleson, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1985 · N6749K · Destroyed > According to the pilot,the engine lost partial power while in cruise flt. He selected a cotton field in which to make a precautionary lng. The aircraft over shot the intended landing area and impacted a utility pole. The collision ruptured the fuel system and… - [NTSB DEN85LA226](https://openairdocs.org/ntsb/DEN85LA226.md): Cessna 152 · Rocklake, ND · Accident · No injuries · Limited investigation · Final report · Aug 21, 1985 · CGZSQ · Substantial damage > The student plt got lost during her 1st solo x-country flt. She subsequently attempted a lng on a gravel road but swerved the a/c off the road to avoid an oncoming car & the a/c received substantial damage. - [NTSB DEN85FA227](https://openairdocs.org/ntsb/DEN85FA227.md): Piper PA-31B-310 · Vernal, UT · Accident · Serious injuries · Field investigation · Final report · Aug 21, 1985 · N7497L · Destroyed > The plt cancelled his IFR plan and began descent from 13000 ft in preparation for landing at Vernal, UT. The acft impacted ground in wings level attitude under power. Plt was seriously burned by post-crash ground fire. Investigation revealed no evidence of… - [NTSB CHI85FA354](https://openairdocs.org/ntsb/CHI85FA354.md): Piper PA-28RT-201 · Wilmington, OH · Accident · 1 fatal · Field investigation · Final report · Aug 20, 1985 · N3074K · Destroyed > The pilot was flying on a south casterly heading of approximately 150' at a low altitude when he struck a set of static lines at approximately 170' AGL. The aircraft flipped over and hit the terrain at approximately 60, nose down in a stand of corn. The pilot… - [NTSB ATL85LA254](https://openairdocs.org/ntsb/ATL85LA254.md): Piper PA-38-112 · Spring City, TN · Accident · No injuries · Limited investigation · Final report · Aug 19, 1985 · N23376 · Substantial damage > The student was on a solo cross-country training flight when the engine lost total power without warning. The plt made an emergency landing in a field and durning the landing the aircraft collided with trees and was substantially damaged. Post crash… - [NTSB SEA85LA216](https://openairdocs.org/ntsb/SEA85LA216.md): Cessna 152 · Independence, OR · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N49282 · Substantial damage > The plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion… - [NTSB NYC85LA217](https://openairdocs.org/ntsb/NYC85LA217.md): Piper J-3 · Goshen, NY · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N35515 · Substantial damage > Acft ran out of fuel while plt was returning to orange co arpt. Plt almost froze on controls when acft engine stopped running. Plt overshot emerg landing fcd and hit trees. - [NTSB NYC85FNA03](https://openairdocs.org/ntsb/NYC85FNA03.md): Piper PA-28-151 · Newburyport, MA · Accident · Serious injuries · Final report · Aug 18, 1985 · N8371C · Substantial damage > The pilot attempted a landing at night with an inoperative landing light and no runway lights. After circling the airport 3 or 4 times he attempted a landing. The aircraft received substantial damage and the pilot received serious injuries. The passenger… - [NTSB DEN85FA222](https://openairdocs.org/ntsb/DEN85FA222.md): Cessna 172P II · Cedar City, UT · Accident · 4 fatal · Field investigation · Final report · Aug 18, 1985 · N54168 · Destroyed > The plt took three of his friends up for a pleasure flt in the local area of Cedar City, Utah. VMC prevailed at the time. The plt continued to climb his acft as it passed over rising terrain. The flt terminated in a box canyon with high terrain on all sides.… - [NTSB CHI85LA352](https://openairdocs.org/ntsb/CHI85LA352.md): Hughes 269A · Hector, MN · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N8777F · Substantial damage > After liftoff from an open field, on a short local flight the helicopter experienced fuel exhaustion. During the auto rotation landing, in an open field the helicopter rolled on the side. - [NTSB CHI85FEV02](https://openairdocs.org/ntsb/CHI85FEV02.md): de Havilland DH-82A · Elmore, IL · Accident · Serious injuries · Final report · Aug 17, 1985 · N510AB · Substantial damage > While on a x-country flt, the eng lost power & the prop continued to windmill. Subsequently, the acft crashed during an emerg landing. During the crash landing, the plt's shoulder harness failed at the upper attachment point & he received head & back… - [NTSB ATL85LA249](https://openairdocs.org/ntsb/ATL85LA249.md): Piper PA-28-181 · Yanceyville, NC · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1985 · N47994 · Substantial damage > The non instrument rated private pilot flew into know adverse wx conditions. While receiving vectors to the nearest airport, the eng lost power dur to fuel exhaustion and an emergency landing was made in a field near a private residence. - [NTSB ATL85FA252](https://openairdocs.org/ntsb/ATL85FA252.md): Mooney M20C · Columbus, GA · Accident · 4 fatal · Field investigation · Final report · Aug 17, 1985 · N5844Q · Destroyed > Acft departed airport after enroute stop for fueling.VFR conditions with broken clouds at 2800 feet and turbulence in clouds. Acft was cleared to 4500 and PIC asked to report reaching. During climb PIC was asked his altitude. His response was unintelligible… - [NTSB SEA85FA198](https://openairdocs.org/ntsb/SEA85FA198.md): Piper PA-31-350 · Sparks, NV · Accident · No injuries · Field investigation · Final report · Aug 16, 1985 · N27476 · Destroyed > Acft exhausted fuel enroute to destination during cross coun try night flgt. Plt advised ATCT of loss of engines about 20 miles out. Plt made deadstick landing on hwy, struck bridge divider. No fire or reported injures. Inspection disclosed dry fuel tanks. - [NTSB NYC85LA214](https://openairdocs.org/ntsb/NYC85LA214.md): Grumman American AA-5 · Montgomery, NY · Accident · No injuries · Limited investigation · Final report · Aug 16, 1985 · N5405L · Substantial damage > The plt reported that the flt was uneventful until he was in a descent about 12 mi from the destination arpt. He said that a large bird suddenly appeared in front of the acft & collided with the right wing. The bird strike put a large hole in the right wing… - [NTSB LAX85LA356](https://openairdocs.org/ntsb/LAX85LA356.md): Cessna R182RG · Hilo, HI · Accident · No injuries · Limited investigation · Final report · Aug 16, 1985 · N8798Z · Destroyed > On August 16, 1985, a Cessna 182 ditched at sea following fuel starvation about 200 miles northeast of Hawaii while on a ferry flight. The pilot reported that he had 23 hours of fuel onboard for the 16 hour flight. The aircraft was equipped with auxiliary… - [NTSB LAX85LA352](https://openairdocs.org/ntsb/LAX85LA352.md): Cessna 182K · Pioneer, CA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1985 · N3169Q · Substantial damage > Documents provided by the plt established that 45.5 gallons of fuel were loaded on the aircraft prior to departure from watsonville, California, the day prior to theaccident. The flt flew direct to minden, Nevada, a straight line distance of 170 NM, where it… - [NTSB LAX85LA350](https://openairdocs.org/ntsb/LAX85LA350.md): Cessna 182A · Santa Paula, CA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1985 · N5879B · Substantial damage > During a cross country flt the acft experienced fuel exhaustion and collided with ground obstructions during the subsequent forced landing in a river bed. The plt said 4 hrs and 20 mns of engine run time had elapsed since the last fueling of the acft. At the… - [NTSB DEN85LA221](https://openairdocs.org/ntsb/DEN85LA221.md): Beech E18S · Billings, MT · Accident · No injuries · Limited investigation · Final report · Aug 16, 1985 · N44N · Substantial damage > The plt stated that he encountered a 'wind draft' and the acft was struck by lightning. The rt eng mount failed and the rt eng was deflected downward. Plt was unable to maintain alt and executed a forced landing in an open field. Post crash exam of the welded… - [NTSB CHI85FA351](https://openairdocs.org/ntsb/CHI85FA351.md): Cessna 404 · South Lyon, MI · Accident · 1 fatal · Field investigation · Final report · Aug 16, 1985 · N404EX · Destroyed > The acft took off and climbed to 5000 ft uneventfully. It then dropped off radar and subsequently impacted the ground in a flat upright attitude. A post-crash fire consumed the majority of the airframe. Eng and prop teardowns indicated no abnormalities and… - [NTSB NYC85LA211](https://openairdocs.org/ntsb/NYC85LA211.md): Ercoupe Ercoupe 415-C · Del Mar, NY · Accident · No injuries · Limited investigation · Final report · Aug 14, 1985 · N3431H · Substantial damage > The plt was reposition the acft at the request of the new owner who was not a rated plt. While climbing thru 2000 ft AGL the plt reported hearing the engine growl and felt a loss of power. During a precautionary descent the engine seized and the plt made a… - [NTSB LAX85LA351](https://openairdocs.org/ntsb/LAX85LA351.md): Cessna 172P · Saint Helena, CA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1985 · N5259K · Substantial damage > During a local personal flt, the plt said the 'engine began to run rough a shake violently.' With not enough power to maintain altitude, the plt elected to make an emergency landing in a field, however, overran the field after touchdown and collided with… - [NTSB FTW85LA320](https://openairdocs.org/ntsb/FTW85LA320.md): Cessna 172N · Sallisaw, OK · Accident · No injuries · Limited investigation · Final report · Aug 14, 1985 · N738XZ · Substantial damage > The plt stated he had an electrical failure and elected to make a precautionary landing at Sallisaw municipal arpt. Equipment was on the rwy and the plt elected to land on a grass strip next to the rwy. He touched down and during rollout thought he could not… - [NTSB NYC85LA209](https://openairdocs.org/ntsb/NYC85LA209.md): Luscombe 8E · Carthage, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1985 · N2661K · Substantial damage > According to the pilot,while climbing to cruise, the engine began to run rough; however it did not quit. The pilot decided to return to the field for a precautionary landing. While turning onto final approach, the engine quit and the pilot attempted to glide… - [NTSB MKC85LA187](https://openairdocs.org/ntsb/MKC85LA187.md): Taylorcraft BL-65 · Ottumwa, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1985 · N27492 · Substantial damage > N27492 collided with utility wires which cross the des moines river and crashed into the river. - [NTSB MKC85LA184](https://openairdocs.org/ntsb/MKC85LA184.md): Air Tractor AT301 · Oakley, KS · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1985 · N8541S · Substantial damage > N8541S collided with a fence and crashed while attempting a forced landing. The plt reports that it took longer than expected to dispense his chemical load and he was critically low on fuel when he departed the working area for the arpt. He got to within 2… - [NTSB MKC85FA182](https://openairdocs.org/ntsb/MKC85FA182.md): Ronald Houk RD-1 · St. Charles, MO · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1985 · N4741A · Destroyed > The home built gyrocopter was being flown by the owner/builder/designer who had an airplane, single-eng, land rating. Shortly after the gyrocopter took off, the eng was operating at a high RPM when a witness heard a pop/noise. Subsequently, the gyrocopter… - [NTSB FTW85LA318](https://openairdocs.org/ntsb/FTW85LA318.md): Piper PA-28-140 · May, TX · Accident · No injuries · Limited investigation · Final report · Aug 13, 1985 · N9912W · Destroyed > The plt stated the eng RPM dropped to 1500 during level cruise flt at 4200 ft MSL. He could not regain pwr. He diverted the flt and attempted to reach the brownwood, TX, arpt but did not have sufficient alt. A forced landing was made in a rugged, heavily… - [NTSB DEN85LA218](https://openairdocs.org/ntsb/DEN85LA218.md): Downer Aircraft Industries REP. Seabee RC-3 · Haugan, MT · Accident · No injuries · Limited investigation · Final report · Aug 13, 1985 · N6305K · Substantial damage > The plt had reconditioned N6305K and was flying the acft to his home in Texas. He continued to state that while climbing through 6500 ft, he heard an unusual noise followed by a substantial loss in pwr. The plt executed an emergency landing on a forest… - [NTSB MIA85LA230](https://openairdocs.org/ntsb/MIA85LA230.md): Cessna 177 · Vieques, PR · Accident · No injuries · Limited investigation · Final report · Aug 12, 1985 · N30232 · Substantial damage > The CFI and student plt utilized a homemade dipstick to check the fuel tanks & determined they had about 8 gals of fuel in the tanks. About 30 minutes after takeoff the eng failed and all restart attempts were negative. The acft was ditchedin about 25 ft of… - [NTSB CHI85LA346](https://openairdocs.org/ntsb/CHI85LA346.md): Cessna 177 · Hillsdale, MI · Accident · No injuries · Limited investigation · Final report · Aug 12, 1985 · N3495F · Substantial damage > The acft contacted trees during a forced landing following fuel exhaustion. The acft was in cruise flt when the plt noted the fuel gages indicated a low fuel state. He had turned toward an arpt which was closer than his destination and the eng quit. He… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=336 ## 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=335 --- 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.