# 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 336 of 718 · 35,889 cases ## Cases, newest first - [NTSB SEA85LA194](https://openairdocs.org/ntsb/SEA85LA194.md): Cessna 150F · Pocatello, ID · Accident · No injuries · Limited investigation · Final report · Aug 11, 1985 · N8339G · Substantial damage > Upon arrival in the vicinity of his destination the plt commenced a reduced pwr descent while in conditions which were conducive to carburetor iceing. During the descent the plt applied carburetor heat with a resultant drop in RPM and, apprehensive of this… - [NTSB NYC85LA173](https://openairdocs.org/ntsb/NYC85LA173.md): Piper PA-28-180 · Lakewood, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1985 · N6317J · Substantial damage > While returning to Lakewood airport,, power was lost suddenly. The pilot elected to land in a stand of pine and oak trees instead of landing on a busy highway. The pilot decided that the distance was too great for a glide to the airport. A post crash… - [NTSB FTW85LA314](https://openairdocs.org/ntsb/FTW85LA314.md): Piper PA-28-140 · Falfurrias, TX · Accident · No injuries · Limited investigation · Final report · Aug 11, 1985 · N1020D · Substantial damage > The plt experienced in-flt directional gyro problems (exessive precessing) which resulted in large deviations on either side of his planning flt path. After realizing it was inaccurate he continued using it for some of his heading info. The acft continued to… - [NTSB CHI85LA348](https://openairdocs.org/ntsb/CHI85LA348.md): Cessna 152 · Little Falls, MN · Accident · No injuries · Limited investigation · Final report · Aug 11, 1985 · N53264 · Substantial damage > Pilot had dept with minimum fuel for the 60 mi x-country flt. He overflew dest by 25 mi and after correcting course ran out of fuel 2 mi short of the aprt. While landing on a country road acft veered into a ditch. - [NTSB BFO85IA065](https://openairdocs.org/ntsb/BFO85IA065.md): Boeing 727-225 · Richmond, VA · Incident · No injuries · Incident investigation · Final report · Aug 11, 1985 · N8856E · Minor damage > The flt was in cruise at FL 350 when the cabin crew reported a cabin fire in the vicinity of seat 28A. Shortly after, a lower aft body overheat warning was recvd. The flt diverted to Richmond, VA. During descent, the flt crew performed the appropriate… - [NTSB NYC85LA181](https://openairdocs.org/ntsb/NYC85LA181.md): Hughes 269C · Altoona, PA · Accident · 1 fatal · Limited investigation · Final report · Aug 10, 1985 · N8615E · Substantial damage > The helicopter with cfi/owner and student who was flying from the left side over high terrain at about 70 mph reported a gradual loss of power. The CFI took control and attempted to effect an airstart. This was without success. The plt then attempted to… - [NTSB MKC85FA180](https://openairdocs.org/ntsb/MKC85FA180.md): Ryan ST-A · Versailles, MO · Accident · 1 fatal · Field investigation · Final report · Aug 10, 1985 · N17351 · Destroyed > The plt of another (accompanying) acft, had briefed the plt of N17351, on wx that could be expected en route. Instead of following the other acft as he had been briefed, the plt of N17351 got in the lead. While en route, he was observed to fly under the edge… - [NTSB DEN85LA215](https://openairdocs.org/ntsb/DEN85LA215.md): Cessna U-206 · Bullfrog Basin, UT · Accident · No injuries · Limited investigation · Final report · Aug 10, 1985 · N2187F · Destroyed > The plt was flying on a VFR x-county flt when he allowed the rt fuel tank to run dry which resulted in eng stoppage. After switching fuel an attempted eng restarted was unsuccesfull. The subsequent forced lng resulted in substantial damage to the acft. - [NTSB NYC85FA205](https://openairdocs.org/ntsb/NYC85FA205.md): Piper PA-28-161 · Cape May, NJ · Accident · 1 fatal · Field investigation · Final report · Aug 9, 1985 · N3462M · Destroyed > Crew members of a coast guard helicopter, observed an acft flying at about 1500 ft above the water. According to them, the acft pitched down into a 60 to 70 deg nose low attitude & collided with the water. The helicopter was immediately flown to the acdnt… - [NTSB FTW85LA315](https://openairdocs.org/ntsb/FTW85LA315.md): Bell 206B · Damon, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1985 · N22952 · Destroyed > The plt experienced an eng deceleration to flt idle while cruising 1000 MSL. He autorotated into trees in a heavily wooded area. A subsequent eng disassembly and examination revealed the pwr control line, p/n 6848471-B, was broken at its attaching 'b' nut… - [NTSB DEN85FTE07](https://openairdocs.org/ntsb/DEN85FTE07.md): Richard A. White Glasair SH-2 · Rawlins, WY · Accident · 2 fatal · Final report · Aug 9, 1985 · N39RW · Destroyed > The acft crashed in a slightly nose low high velocity impact with the eng operating at low pwr by the signatures on the prop. The radar plot shows that the flight descended from aprx 15000 ft to about 10000 ft in aprx 1 minute. The acft continued to descend… - [NTSB CHI85IA339](https://openairdocs.org/ntsb/CHI85IA339.md): Mcdonnell Douglas DC-10-10 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Aug 8, 1985 · N111AA · Minor damage > On August 7,1985 at 2000 EDT, a Mcdonnell Douglas DC-10-10 N111AA registered to American airlines, inc., had a piece of the engine exit the engine case and cowling. On climb to cruise at Detroit airport, Detroit, Michigan, while on a passenger flight. Visual… - [NTSB MIA85LA225](https://openairdocs.org/ntsb/MIA85LA225.md): Cessna 210L · Longwood, FL · Accident · No injuries · Limited investigation · Final report · Aug 6, 1985 · N1752X · Destroyed > The acft was 12 miles out & cleared for a visual apch when the plt reported total loss of eng power. Examination of the wreckage disclosed about four fluid ounces of fuel remaining in fuel tanks. Entry on maintenance discrepancy sheet read 'fuel gauges are… - [NTSB DEN85LA210](https://openairdocs.org/ntsb/DEN85LA210.md): Hughes 369D · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Aug 6, 1985 · N8662F · Substantial damage > The flt was a pipeline patrol operation. While in flt, smoke was observed in the cabin. The plt made an unsuccessful autorotation resulting in substantial damage to the helicopter. Investigation revealed the smoke was from an inflight eng compartment fire.… - [NTSB DEN85FQA04](https://openairdocs.org/ntsb/DEN85FQA04.md): Star Duster Too SA-300 · Grants, NM · Accident · Serious injuries · Final report · Aug 6, 1985 · N65010 · Substantial damage > The pilot-in-command of N65010, a starduster ii on 8/6/85 took off from Grants, NM at about 1100 MDT, south bound to intercept winslow, AZ VOR, radial 255. When trying to gain altitude the pilot stated the aircraft felt the effects of density altitude making… - [NTSB CHI85LA336](https://openairdocs.org/ntsb/CHI85LA336.md): Piper PA-36-300 · Red Lake Falls, MN · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 1985 · N2350Y · Substantial damage > The acft contacted wires during an aerial application flt. The plt stated he was maintaining extra alt to avoid tall weeds and the clearance below the wires was misjudged. The wires severed the vertical fin and rudder. - [NTSB DEN85LA209](https://openairdocs.org/ntsb/DEN85LA209.md): Stinson 108-1 · Superior, MT · Accident · No injuries · Limited investigation · Final report · Aug 5, 1985 · N8976K · Substantial damage > The plt was flying with his wife on a pleasure flight to Idaho when smoke started coming into the cabin. Engine oil pressure went to zero. The plt secured the engine and made a forced landing to a farmer's field. The acft was substantially damaged; however,… - [NTSB CHI85FA334](https://openairdocs.org/ntsb/CHI85FA334.md): Cessna 182Q · Walworth, WI · Accident · 1 fatal · Field investigation · Final report · Aug 5, 1985 · N11VS · Destroyed > The pilot took off with weather conditions of 100 ft ceiling & visibility of 1/4 mile. Theflight tookd off to the south & crashed in a corn field south of the airstrip tracking 058. The engine was heard at a high power setting just prior to impact. - [NTSB CHI85LA335](https://openairdocs.org/ntsb/CHI85LA335.md): Beech A23A · Griffith, IN · Accident · No injuries · Limited investigation · Final report · Aug 4, 1985 · N6937Q · Substantial damage > The preflight and takeoff were uneventful. Shortly after takeoff the plt experienced a partial pwr loss and discovered that he could not maintain level flt. He then performed a forced landing in a fld. Following the accident an FAA airworthiness inspector… - [NTSB ATL85FA234](https://openairdocs.org/ntsb/ATL85FA234.md): Aerospatiale AS-355F · Chamblee, GA · Accident · Serious injuries · Field investigation · Final report · Aug 4, 1985 · N299FE · Destroyed > Reportedly, the plt & passengers had gone to a local establishment, where the entire party had consumed an unspecified amount of alcoholic beverages. One passenger reported that after arriving at the arpt, the plt made a walk-around inspection of the… - [NTSB FTW85LA321](https://openairdocs.org/ntsb/FTW85LA321.md): Cessna 152 · Katy, TX · Accident · No injuries · Limited investigation · Final report · Aug 3, 1985 · N93980 · Substantial damage > The plt stated he had his destination arpt in sight and then lost sight of it. While attempting to locate the arpt the eng lost pwr. He attempted a emergency landing on an interstate hwy 10 west of houston, TX. After touchdown and during rollout the right… - [NTSB ATL85LA238](https://openairdocs.org/ntsb/ATL85LA238.md): Eipper MX-2 · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Aug 3, 1985 · N3986K · Substantial damage > While climbing altitude the parachute, which was secured to the right seat, was inadvertently deployed and became tangled in the propeller. The acft descended to the ground while inverted at a slow rate. - [NTSB ATL85LA231](https://openairdocs.org/ntsb/ATL85LA231.md): Cessna 152 · Hilton Head Is., SC · Accident · No injuries · Limited investigation · Final report · Aug 3, 1985 · N67998 · Destroyed > The commercial/cfi plt and a passenger were flying just off shore at about 700 ft when the engine quit. He could not clear trees along the shore and the beach was unusable due to fallen trees. The plt landed in the ocean and both occupants swam to shore. The… - [NTSB ATL85LA229](https://openairdocs.org/ntsb/ATL85LA229.md): Cessna 150K · Orchard Hill, GA · Accident · No injuries · Limited investigation · Final report · Aug 2, 1985 · N5773G · Substantial damage > The acft suffered a loss of pwr due to fuel exhaustion and the plt made an emergency landing in a fld. During landing roll the acft collided with trees at the end of the fld. Post accident exam of the acft revealed one gallon of fuel in the right fuel tank… - [NTSB FTW85LA303](https://openairdocs.org/ntsb/FTW85LA303.md): Cessna 150M · Horntown, OK · Accident · No injuries · Limited investigation · Final report · Aug 1, 1985 · N187AR · Destroyed > The acft experienced an intermittent power loss in cruise flt. The plt's attempts to remedy the problem were not successful and he elected to execute a precautionary landing on a road. During the landing, the acft struck a wire and veered into trees along the… - [NTSB DEN85LTM05](https://openairdocs.org/ntsb/DEN85LTM05.md): Interstate S-1A · Rock Springs, WY · Accident · Serious injuries · Final report · Aug 1, 1985 · N37438 · Substantial damage > While on a x-country flt, the acft encountered turbulence & downdrafts. The plt stated that at 1st, he was not concerned, but then it became apparent that the acft may impact the ground. The acft had limited power (75 HP) & the terrain elevation in that area… - [NTSB DEN85LA208](https://openairdocs.org/ntsb/DEN85LA208.md): Piper PA-28RT-201T · Clovis, NM · Accident · No injuries · Limited investigation · Final report · Aug 1, 1985 · N2232R · Destroyed > While in level cruise flight at 17,000 ft, pilot noticed sound change in cabin. All instrument readings were normal with the exception of manifold pressure drop from 32 to 25 inches. Engine began to sputter and run rough. Oil pressure warning light blinked… - [NTSB NYC85LA200](https://openairdocs.org/ntsb/NYC85LA200.md): Cessna 206 · Duanesburg, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1985 · N5197U · Destroyed > Accordidng to the pilot, he was making a low pass over Duanesburg airport to observe the area before landing. While over the airport, the engine quit and he had to make an emergency landing on route 20. The pass was made at about 300 to 400 feet above the… - [NTSB NYC85FA201](https://openairdocs.org/ntsb/NYC85FA201.md): Cessna C-177B · Macungie, PA · Accident · 1 fatal · Field investigation · Final report · Jul 31, 1985 · N34672 · Destroyed > Witnesses saw the acft descend in a near nose dive attitude during a severe thunderstorm. The plt was not in radio communication with gnd facilities. Examination of the acft did not disclose evidence of malfunction. There was no evidence of plt impairment or… - [NTSB CHI85FA325](https://openairdocs.org/ntsb/CHI85FA325.md): Piper PA-28-181 · Eureka, WI · Accident · No injuries · Field investigation · Final report · Jul 31, 1985 · N8503E · Substantial damage > Prior to takeoff the pilot calculated that with 48 gallons of fuel he could make the four hour flight to oshkosh with one hour of fuel to spare. Upon arriving at a point 25 mi sw of oshkosh he received a request to descend 1200 ft, a request to climb 1200 ft… - [NTSB ATL85LA228](https://openairdocs.org/ntsb/ATL85LA228.md): Cessna A188B · Clanton, AL · Accident · No injuries · Limited investigation · Final report · Jul 31, 1985 · N9381G · Substantial damage > The acft collided with a fence & a ditch during a precautionary off-arpt landing in a pasture. The plt reported that following the completion of aerial application operations, thunderstorms were blocking his return to the arpt. He had elected to land to await… - [NTSB MIA85LA222](https://openairdocs.org/ntsb/MIA85LA222.md): Rockwell S-2R · Colquitt, GA · Accident · No injuries · Limited investigation · Final report · Jul 30, 1985 · N3647X · Substantial damage > The aircraft was substantially damaged and the pilot uninjured when the aircraft flipped upside down in a field during a forced landing in an open field following engine failure. A post accident examination of the engine revealed the number seven cylinder… - [NTSB CHI85LA324](https://openairdocs.org/ntsb/CHI85LA324.md): Boeing E75 · Delavan, WI · Accident · No injuries · Limited investigation · Final report · Jul 30, 1985 · N5191N · Substantial damage > The acft nosed over during a forced lndg after the eng quit. The plt said he ran out of fuel. - [NTSB ATL85LA227](https://openairdocs.org/ntsb/ATL85LA227.md): Bellanca 17-30A · Camden, SC · Accident · No injuries · Limited investigation · Final report · Jul 30, 1985 · N6707V · Substantial damage > While the acft was flying over wooded terrain, the eng lost power. The plt saw a plowed field aprx 3 mi away & began an emerg apch to the field. The acft struck the tops of trees on final apch, but continued flying until the plt made a gear up landing. An… - [NTSB SEA85FYM03](https://openairdocs.org/ntsb/SEA85FYM03.md): Cessna 170B · Manzanita, OR · Accident · 2 fatal · Final report · Jul 29, 1985 · N8011A · Substantial damage > Aircraft was observed to enter a low overcast shortly after take off. The aircraft then hit a mountain about 4 miles north of the departure airport. - [NTSB SEA85FA181](https://openairdocs.org/ntsb/SEA85FA181.md): Piper PA-22 · Ketchum, ID · Accident · 2 fatal · Field investigation · Final report · Jul 29, 1985 · N4445A · Destroyed > Student pilot on cross country flt, route thru mountain pass and mountains. Attempted emergency landing on highway. During approach and while turning toward selected landing site, plt inadvertantly set full nose down trim with half flaps. As acft completed… - [NTSB DEN85FA202](https://openairdocs.org/ntsb/DEN85FA202.md): Cessna 172RG · Wilsall, MT · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1985 · N6156R · Destroyed > The plt obtained a wx briefing that forecast IMC. He filed a VFR flt plan and departed polson, Montana at 0830 en route to powell, Wyoming. The plt said he encountered low ceilings, low visibilities, and drizzle just past helena, Montana but he continued. The… - [NTSB SEA85LA180](https://openairdocs.org/ntsb/SEA85LA180.md): Piper PA-30 · Jarbridge, NV · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 1985 · N7AT · Destroyed > Shortly after departure the left wing was raised by a gust of wind. During correction the aircraft then yawed right. Almost full aileron was used to maintain level flight. The aircraft then descended to the ground. Inspection of the aircraft revealed no… - [NTSB MKC85LA171](https://openairdocs.org/ntsb/MKC85LA171.md): Bellanca 17-31A · Cozad, NE · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1985 · N6598V · Substantial damage > The plt reported that during a descent to land at kearney, NE, the eng lost power & oil oozed out of the cowling & covered most of the windshield. During a forced landing apch, he released his seat belt so he could see thru a small section of the windshield.… - [NTSB CHI85LA319](https://openairdocs.org/ntsb/CHI85LA319.md): Piper PA-20 · Madelia, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1985 · N7619K · Substantial damage > During cruise engine power was lost. The pilot was unable to restart the engine. During landing in an oats field the acft nosed over. - [NTSB CHI85LA318](https://openairdocs.org/ntsb/CHI85LA318.md): Beech C33-A · Hobart, IN · Accident · No injuries · Limited investigation · Final report · Jul 28, 1985 · N1CK · Substantial damage > The eng lost complete pwr during cruise. The plt landed on a road and the acft collided with a pile of gravel. Fuel was found in both tanks, however, the bladder fuel tanks were found partially collapsed. The fuel cap 'o' rings were to be replaced but were… - [NTSB MKC85FA168](https://openairdocs.org/ntsb/MKC85FA168.md): Schubert Cassutt Sport · Admire, KS · Accident · 1 fatal · Field investigation · Final report · Jul 27, 1985 · N1115G · Destroyed > At 0847 CDT, July 27, 1985 N1115G radioed a nearby fss. The station that was called was closed but another fss heard thecall. During the transmission the plt reported that he had an eng problem, was pumping oil overboard and could not see outside because the… - [NTSB CHI85LA329](https://openairdocs.org/ntsb/CHI85LA329.md): Cessna 152 · Rockford, IL · Accident · No injuries · Limited investigation · Final report · Jul 27, 1985 · N67455 · Substantial damage > The student plt originally planned a x-country flt from janesville, WI, to champaign, IL, to galesburg, IL & back to janesville. The total route of flt was aprx 390 mi. The plt had calculated that he needed 3-3/4 hrs of fuel. At champaign, he purchased an… - [NTSB CHI85LA321](https://openairdocs.org/ntsb/CHI85LA321.md): Piper PA-32-300 · Delaware, OH · Accident · No injuries · Limited investigation · Final report · Jul 27, 1985 · N110CF · Substantial damage > Total loss of engine power occurred in the descent. The flight was vectored toweard the nearest airport but was unable to reach the runway. The aircraft was landed in a rough field. The left magneto was found seized during engine examination. - [NTSB MIA85LA220](https://openairdocs.org/ntsb/MIA85LA220.md): Cessna 150F · Apalachicola, FL · Accident · No injuries · Limited investigation · Final report · Jul 26, 1985 · N8665G · Substantial damage > The plt stated that he elected to land at Apalachicola due to wx in the area, but on final apch, the eng started to run rough, then quit. He landed short of the rwy in a swampy area & upon touchdown, the acft flipped over on its back. Exam of the acft after… - [NTSB MIA85LA219](https://openairdocs.org/ntsb/MIA85LA219.md): Piper PA-28-180 · South Bay, FL · Accident · No injuries · Limited investigation · Final report · Jul 26, 1985 · N32576 · Substantial damage > The eng lost pwr during a sightseeing flt at 1200 ft MSL and the plt selected a divided hwy for an emergency landing to the west. Because he was overtaking a truck on the westbound lanes, the plt tried to land on the median strip. The acft was caught in the… - [NTSB DEN85FA200](https://openairdocs.org/ntsb/DEN85FA200.md): Beech A36 · Santa Rosa, NM · Accident · 2 fatal · Field investigation · Final report · Jul 26, 1985 · N130T · Destroyed > The plt departed dalhart, TX on a night x-country to quemedo, NM. En route he stopped and picked up a friend at hereford, TX. He did not file a flt plan. He was lost off of radar just west of Santa Rosa, NM, where the wreckage was later found. The acft was… - [NTSB CHI85FA314](https://openairdocs.org/ntsb/CHI85FA314.md): Beech J35 · Eden Prairie, MN · Accident · 4 fatal · Field investigation · Final report · Jul 26, 1985 · N687B · Destroyed > The plt's windscreen became covered with oil shortly after takeoff. The plt returned to the arpt attempting to set up a pattern for landing. The acft was observed in a descent and turn to final apch. The acft collided with the ground in a descending left… - [NTSB ATL85IA225](https://openairdocs.org/ntsb/ATL85IA225.md): Beech 95-B55 · Gilbertsville, KY · Incident · No injuries · Incident investigation · Final report · Jul 26, 1985 · UNK · Minor damage > The acft made a precautionary lndg after the plt feathered the left eng because of vibration. Post accident exam showed a failed cylinder in the eng - [NTSB MIA85LA218](https://openairdocs.org/ntsb/MIA85LA218.md): Cessna 172 · Lawtey, FL · Accident · No injuries · Limited investigation · Final report · Jul 25, 1985 · N8151X · Destroyed > The acft had not been flown for two years. During the preflt inspecton, the fuel sumps were drained repeatedly & each time, a quantity of water was observed in the collected fuel sample. Aprx 30 mins after takeoff, the eng failed & a forced landing was… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=337 ## 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=336 --- 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.