# 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 324 of 718 · 35,885 cases ## Cases, newest first - [NTSB MIA86LA187](https://openairdocs.org/ntsb/MIA86LA187.md): Cessna 150M · Plant City, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1986 · N63133 · Destroyed > While on a dual student plt flt, about 10 minutes after takeoff, the eng began severely vibrating. The instructor plt took control of the acft, reduced power and established a glide to a local arpt. The engine then suddenly failed completely. The instructor… - [NTSB ANC86IA088](https://openairdocs.org/ntsb/ANC86IA088.md): Cessna 404 · St Marys, AK · Incident · No injuries · Incident investigation · Final report · Jun 21, 1986 · N4450M · Minor damage > During the descent into st. mary's, Alaska, the door ajar warning light illuminated. The pilot-in-command checked the rear door and then the front crew door. When the handle of the crew door was retouched it flew open and departed the airplane taking about… - [NTSB NYC86LA171](https://openairdocs.org/ntsb/NYC86LA171.md): Luscombe 8A · Barkhanstead, CT · Accident · No injuries · Limited investigation · Final report · Jun 20, 1986 · N1166B · Substantial damage > The flight took off with about seven gallons of fuel with a slight tailwind. But after about 30 minutes of flight the flight encountered a headwind. The aircraft suffered fuel exhaustion and the pilot executed a precautionary landing in a field. During ground… - [NTSB ATL86LA177](https://openairdocs.org/ntsb/ATL86LA177.md): Piper PA-24-250 · West Chester, OH · Accident · No injuries · Limited investigation · Final report · Jun 20, 1986 · N6639P · Substantial damage > Drg flt, the eng lost power & the plt was unable to maintain alt. He made a forced landing on a road, but drg the lndg roll, the acft collided with a road sign. A post crash exam of the eng revealed the #6 cylinder had separated aprx 4' above the cylinder… - [NTSB ANC86LA090](https://openairdocs.org/ntsb/ANC86LA090.md): Cessna 150 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jun 20, 1986 · N1773Q · Substantial damage > The student pilot, who was carrying a passenger, mixed automotive fuel with aviation gasoline. The auto gas contained water causing the engine to run intermittently. The airplane turned over during a forced landing in a swamp. Post accident inspection rvealed… - [NTSB FTW86LA118](https://openairdocs.org/ntsb/FTW86LA118.md): Cessna A185F · New Orleans, LA · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1986 · N9937N · Substantial damage > The pilot decided to land due to rainy conditions shortly after departure. He had forgotten to retract the landing gear after takeoff and made a water landing with the gear down, causing the aircraft to invert and sink. - [NTSB MKC86LA129](https://openairdocs.org/ntsb/MKC86LA129.md): Cessna 152II · Jonesboro, AR · Accident · No injuries · Limited investigation · Final report · Jun 18, 1986 · N67490 · Destroyed > The pilot stated that he was level at 3,000 feet, and had the airport in sight when he experienced a fluctuation in engine RPM. The pilot further stated that he continued the flight but that the engine quit when the aircraft was over the airport. The p.I.c.… - [NTSB FTW86LA112](https://openairdocs.org/ntsb/FTW86LA112.md): Beech T-34A · Pearland, TX · Accident · No injuries · Limited investigation · Final report · Jun 18, 1986 · N5154V · Substantial damage > The plt experienced an eng failure during cruise flt due to a blockage of the air induction system by a sheet of paper. The acft had been painted just prior to the accident. The acft received substantial damage when the right wing collided with the ground due… - [NTSB NYC86LA153](https://openairdocs.org/ntsb/NYC86LA153.md): Piper PA-28-235 · Westport, NY · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 1986 · N9094W · Substantial damage > The Piper PA-28-235 made an off airport landing at night in conditions of reduced visibility, with rain, gusty winds and thunderstorms in the area. The aircraft received substantial damage and the pilot received serious injuries. Post crash examination of the… - [NTSB FTW86LRD16](https://openairdocs.org/ntsb/FTW86LRD16.md): Grumman G-164B · Abbeville, LA · Accident · No injuries · Final report · Jun 17, 1986 · N48592 · Substantial damage > The pilot stated he made a successful forced landing, due to loss of power, and then had to flip the aircraft to prevent colliding with a lateral (above ground irrigation system) with a water depth of about four feet. Subsequent engine examination revealed… - [NTSB CHI86LA156](https://openairdocs.org/ntsb/CHI86LA156.md): Cessna 172P · Grand Rapids, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 1986 · N52565 · Substantial damage > The CFI and sp were returning from a transition. Enroute the #3 exhaust valve push rod failed. When the CFI smelled 'something burning' she shut down the engine. During the descent struck power lines. Acft ld in swampy terrain and nosed over inverted. - [NTSB LAX86LA254](https://openairdocs.org/ntsb/LAX86LA254.md): North American Navion A · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Jun 16, 1986 · N91608 · Substantial damage > The acft's engine failed aprx 10 minutes after takeoff. The acft collided with a utility pole during the forced landing that followed. Post accident inpsection of the acft revealed the fuel selector was positioned on the aux tank. The main fuel tanks were… - [NTSB FTW86LA119](https://openairdocs.org/ntsb/FTW86LA119.md): Aerospatiale AS35OD · Theriot, LA · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1986 · N229EH · Substantial damage > The pilot experienced a sudden yaw in the helicopter at cruise flight. The ng started winding down confirming an engine failure. The pilot had to extend an autorotation over a tree line, which caused the RPM to decrease, and made a hard landing in an adjacent… - [NTSB FTW86FA115](https://openairdocs.org/ntsb/FTW86FA115.md): Cessna P206C · Grand Chenier, LA · Accident · 1 fatal · Field investigation · Final report · Jun 16, 1986 · N8621Z · Destroyed > The aircraft impacted the marshy terrain while in a very shallow descent and wings level attitude and at a relatively high speed (I.e.,cruise). It then cartwheeled and slid to a stop. There was evidence of substantial engine power being developed at impact.… - [NTSB DEN86FA163](https://openairdocs.org/ntsb/DEN86FA163.md): Beech C90A · Jackson, WY · Accident · 1 fatal · Field investigation · Final report · Jun 16, 1986 · N114CM · Destroyed > The plt departed olathe, KS, en route to Jackson, WY. The plt radioed the denver efas and reported his position as 56 miles northwest of casper, WY. There was no further radio communication with N114CM. The plt's wife stated after the accident that the plt… - [NTSB ATL86LA173](https://openairdocs.org/ntsb/ATL86LA173.md): Pitts S-15 · Raleigh, NC · Accident · No injuries · Limited investigation · Final report · Jun 16, 1986 · N73BJ · Substantial damage > During normal cruise VFR flight at 1,500 ft AGL, the pilot reported hearing an erratic hissing sound and the acft began losing fuel pressure. The aircraft lost power and a forced landing was made into a field. The right main landing gear dropped into a hole… - [NTSB ATL86LA171](https://openairdocs.org/ntsb/ATL86LA171.md): Piper PA-28-160 · Apex, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1986 · N5447W · Destroyed > This was the first flight for the passenger. After about one and one-half hours en route the weather ahead deteriorated and the pilot turned to return to the departure point. Weather prevented a landing there so he turned to another airport. It too was in an… - [NTSB ANC86LA079](https://openairdocs.org/ntsb/ANC86LA079.md): Cessna 185F · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Jun 16, 1986 · N70438 · Substantial damage > Airplane ran out of fuel on one tank. Altitude was too low to restart on other tank prior to ground impact. - [NTSB SEA86LA148](https://openairdocs.org/ntsb/SEA86LA148.md): Mooney M20-C · Paradise Valley, NV · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N6263U · Substantial damage > A forced landing was made due to a very rough running engine accompanied by backfiring. It was discovered on engine examination that the spark plugs were worn beyond service limits. During landing roll a cattle guard was struck with the wing tips. - [NTSB LAX86LA251](https://openairdocs.org/ntsb/LAX86LA251.md): Piper PA-28-140 · Cucamonga, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1986 · N4593R · Destroyed > During a pleasure x-country flight in the student plt's own acft, he elected to fly over a ridge of hills rather than via a longer route which circumnavigated the hills. While climbing enroute the plt entered a box canyon, experienced a downdraft and collided… - [NTSB FTW86FPA22](https://openairdocs.org/ntsb/FTW86FPA22.md): Rutan LONG-EZ · Cedar Hill, TX · Accident · Serious injuries · Final report · Jun 14, 1986 · N23RY · Substantial damage > Shortly after takeoff and leveling off at 3000 ft MSL, the plt switched fuel tanks. Aprx 20 minutes into the flt a total loss of engine power was experienced. The plt attempted to land in a field; however, the acft contacted power lines during the descent.… - [NTSB FTW86FPA24](https://openairdocs.org/ntsb/FTW86FPA24.md): Repliea 78 Ral Fokker DV III · Slidell, TX · Accident · 1 fatal · Final report · Jun 13, 1986 · N2782A · Destroyed > The shutoff mechanism and handle separated from the fuel shutoff valve body and fell to the floor. This stopped the fuel flow to the engine, resulting in a total loss of engine power in the uncetificated home built aircraft. It was not determined why the… - [NTSB FTW86FA116](https://openairdocs.org/ntsb/FTW86FA116.md): MBB 105 · Houma, LA · Accident · 1 fatal · Field investigation · Final report · Jun 13, 1986 · N2784E · Destroyed > A fatigue failure in a main rotor blade pitch change link resulted in the loss of control of one blade, leading to an in flight separation of the tail boom. The helicopter was uncontrollable and pitched forward, impacting the ground inverted. - [NTSB FTW86FA107](https://openairdocs.org/ntsb/FTW86FA107.md): Piper PA-31-350 · Huffman, TX · Accident · 2 fatal · Field investigation · Final report · Jun 13, 1986 · N3539K · Destroyed > The pilot was being vectored around thunderstorms in the area just prior to the accident. During the last radio contact the pilot was issued a vector to the destination airport. During this turn, for unknown reasons, the pilot lost control of the aircraft and… - [NTSB SEA86LA143](https://openairdocs.org/ntsb/SEA86LA143.md): Bell 47G-2 · Zillah, WA · Accident · No injuries · Limited investigation · Final report · Jun 12, 1986 · N11VH · Destroyed > En route to the local spray area a total loss of power occurred along with a loss of oil pressure. The acft was aprx 200 ft AGL over a pear orchard. The plt was attempting to autorotate onto a nearby road but the left skid caught the roof top of a metal shed.… - [NTSB MIA86LA180](https://openairdocs.org/ntsb/MIA86LA180.md): Cessna 210N · Jacksonville, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1986 · N6603C · Substantial damage > The eng failed & a forced ldg was performed in a field. During the ldg roll-out, the acft struck a fence. An on-scene exam of the acft revealed a substantial quantity of fuel remaining in the tanks and there was no evidence of any foreign matter within the… - [NTSB FTW86LA109](https://openairdocs.org/ntsb/FTW86LA109.md): Cessna 206 · Tahoka, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1986 · N5195U · Substantial damage > The acft nosed over during a forced landing in a fld following a loss of pwr due to fuel exhaustion. The plt reported that after aprx 9 minutes of flt a total loss of pwr was experienced. The plt selected an open fld in which to land. The nose gear sunk in… - [NTSB SEA86LA142](https://openairdocs.org/ntsb/SEA86LA142.md): Smith Miniplane 1 · Petersburg, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1986 · N8W · Substantial damage > After derarting the arpt and flying about 75 ft AGL, the plt added power and attempted to climb. There was a power hesitation and the acft did not clear trees in it's path. The acft struck trees and descended to ground impact. The plt stated that he thought… - [NTSB MIA86LA179](https://openairdocs.org/ntsb/MIA86LA179.md): Piper PA-24-400 · St.Augustine, FL · Accident · No injuries · Limited investigation · Final report · Jun 11, 1986 · N8495P · Substantial damage > A forced ldg was made after the eng failed while cruising at 8000 ft. an exam of the eng revealed that the top of the crankcase was cracked & a hole was in the top of the case at the no. 2 cylinder. The bottom of the cap of the no. 2 connecting rod had broken… - [NTSB FTW86IA103](https://openairdocs.org/ntsb/FTW86IA103.md): Piper PA-31 · Kingston, OK · Incident · No injuries · Incident investigation · Final report · Jun 10, 1986 · N68ST · Minor damage > Acft received minor damage as a result of an electrical fire in-flight while in cruise at 9,000' MSL. The plt stated that he observed smoke emanating from the c.b. panel mounted on the left side wall of the cockpit and that several c.b.'s popped and he lost… - [NTSB ATL86LA165](https://openairdocs.org/ntsb/ATL86LA165.md): Cessna 172M · Cobb, GA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1986 · N20052 · Substantial damage > The plt reported a rough running eng. He attempted a precautionary ldg during which the acft's nose wheel dug in the soft ground and the acft nosed over. Post accident inspection of the eng failed to disclose any failures/malfunction. - [NTSB ANC86LA070](https://openairdocs.org/ntsb/ANC86LA070.md): Cessna 175 · Port Alsworth, AK · Accident · No injuries · Limited investigation · Final report · Jun 10, 1986 · N7460M · Substantial damage > The airplane experienced an engine failure while in cruise flight and subsequently overran the forced landing area. - [NTSB NYC86LA149](https://openairdocs.org/ntsb/NYC86LA149.md): Cessna U206 · Presque Isle, ME · Accident · No injuries · Limited investigation · Final report · Jun 9, 1986 · N8384Q · Substantial damage > According to the plt, the eng lost power about 10 min after he took off while flying at low altitude. He landed in a field that was surrounded by trees. Drg the landing, the rgt float, rgt wing & rgt side of the empennage were damaged. No reason was found for… - [NTSB LAX86FA249](https://openairdocs.org/ntsb/LAX86FA249.md): Carnes Osprey 2 · Julian, CA · Accident · 1 fatal · Field investigation · Final report · Jun 9, 1986 · N627JC · Destroyed > Witness statements & examination of the wreckage revealed that the aircraft struck the ground as a result of a stall-spin type accident near the end of the closed portion of a box canyon about 200 feet below the top of the ridge. The investigation revealed… - [NTSB ATL86LA163](https://openairdocs.org/ntsb/ATL86LA163.md): Cessna 150M · Parkton, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1986 · N66468 · Substantial damage > While practicing a simulated forced landing the aircraft stalled and crashed into the trees. The pilot related that the aircraft lost power. Post crash examination of the wreckage failed to disclose any pre-existing mechanical failure or malfunction which… - [NTSB SEA86FA139](https://openairdocs.org/ntsb/SEA86FA139.md): Hiller UH12B · Rathdrum, ID · Accident · Serious injuries · Field investigation · Final report · Jun 8, 1986 · N41319 · Destroyed > The plt reported noticing the fuel gage was nearing empty shortly before the eng quit. The acft crashed during an attempted forced landing on a road. The plt stated he was flying the acft to his residence where it was based. Investigation revealed little fuel… - [NTSB LAX86LA244](https://openairdocs.org/ntsb/LAX86LA244.md): Piper PA-28-150 · Santa Margarita, CA · Accident · No injuries · Limited investigation · Final report · Jun 8, 1986 · N1787P · Substantial damage > The pilot stated that he had problems with his navigation radio and overflew his destination airport. He subsequently became disoriented, ran one fuel tank dry, and then made a precautionary landing, since he was low on fuel. On landing, the nose gear… - [NTSB BFO86LA034](https://openairdocs.org/ntsb/BFO86LA034.md): Ercoupe 415-C · Concord, VA · Accident · No injuries · Limited investigation · Final report · Jun 8, 1986 · N2349H · Substantial damage > The acft experienced a total loss of pwr during cruise. A forced ldg was made on a hwy and the acft struck a road sign. Post-crash examination of the acft engine revealed an inoperative engine fuel pump. - [NTSB ATL86IA162](https://openairdocs.org/ntsb/ATL86IA162.md): Boeing 727-225 · Charleston, SC · Incident · No injuries · Incident investigation · Final report · Jun 8, 1986 · N8865E · No damage > During a scheduled air carrier flight at normal cruising altitude, the captain passed out upon re-entering the cockpit after excusing himself to go to the lavatory. The flight crew diverted to an alternate destination due to the medical emergency. A review of… - [NTSB SEA86LA147](https://openairdocs.org/ntsb/SEA86LA147.md): Avian Skyhawk · Yakima, WA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1986 · N7001N · Substantial damage > A forced landing was made due to fuel starvation. During the forced landing the balloon struck power lines, severing the basket from the envelope. Sparks from the wire strike caused a small brush fire. Post accident exam revealed the plt inadvertently… - [NTSB SEA86LA141](https://openairdocs.org/ntsb/SEA86LA141.md): Taylorcraft BCM-12D-85 · Ketchikan, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1986 · N96336 · Destroyed > The plt felt a sudden hard jolt while in cruise flt. The acft assumed a nose low, left wing down attitude which the plt was unable to correct by use of power and control inputs. The acft was at a low altitude due to weather. The acft impacted the water in a… - [NTSB LAX86LA245](https://openairdocs.org/ntsb/LAX86LA245.md): Fairchild 24R-40 · Marysville, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1986 · N28509 · Substantial damage > The acft's left wing spar failed while the acft was in level flt. The plt was able to regain partial control of the acft and landed it in a plowed field. The acft owner reported he had previously replaced the right wing due to deterioration of the wood… - [NTSB NYC86MA148](https://openairdocs.org/ntsb/NYC86MA148.md): Sikorsky S-76B · Sutton, MA · Accident · 4 fatal · Major investigation · Final report · Jun 6, 1986 · N5AZ · Destroyed > About 16 min after takeoff, while cruising at 6000' MSL in IMC, the plt transmitted 'Sikorsky 507' (call sign of acft hefrequently flew). The ATC ctlr was talking to another flt & did not respond. About 1 min later, rdo & radar contact werelost & the… - [NTSB MIA86LA173](https://openairdocs.org/ntsb/MIA86LA173.md): Champion 7KCAB · Ormond Beach, FL · Accident · No injuries · Limited investigation · Final report · Jun 6, 1986 · N1854G · Substantial damage > The plt stated that the acft engine lost oil pressure. He then dropped the banner, & ditched the acft in the ocean. Post crash examination revealed that the loss of oil pressure was due to oil starvation. No evidence of oil seepage was noted on or near the… - [NTSB DEN86LA155](https://openairdocs.org/ntsb/DEN86LA155.md): Cessna 182P · Vernal, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1986 · N8078M · Destroyed > While flying a pipeling patrol flt 1,000 feet AGL in mountainous terrain, the plt encountered a downdraft windshear which resulted in an uncontrollable 2,000 fpm acft descent from which the plt was not able to recover. The acft impacted in rough terrain and… - [NTSB ANC86IA066](https://openairdocs.org/ntsb/ANC86IA066.md): Cessna 207 · Manokotak, AK · Incident · No injuries · Incident investigation · Final report · Jun 6, 1986 · N1737U · Minor damage > During cruise flight the engine began to run rough. The pilot attempted switching fuel tanks but the engine continued to run rough. The engine ceased operation and did not windmill during the emergency descent. An examination of the engine later revealed that… - [NTSB ATL86LA157](https://openairdocs.org/ntsb/ATL86LA157.md): Mooney M20E · Pell City, AL · Accident · No injuries · Limited investigation · Final report · Jun 5, 1986 · N1308W · Substantial damage > The eng lost pwr and a forced landing was made aprx 5 miles south of the destination arpt. The plt reported that, prior to departure he visually examined the fuel tanks and estimated having aprx 9 gals total fuel onboard. He estimated that only 5 gals would… - [NTSB NYC86LA147](https://openairdocs.org/ntsb/NYC86LA147.md): Cessna 152 · Lenox Township, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1986 · N94545 · Substantial damage > The Cessna 152 experienced a power loss while being flown by a student pilot. During the forced landing the aircraft struck a utility pole and received substantial damage. The pilot was uninjured. Examination of the aircraft by the FAA showed the fuel tanks… - [NTSB DEN86FA150](https://openairdocs.org/ntsb/DEN86FA150.md): Beech A36TC · Marietta, OK · Accident · 2 fatal · Field investigation · Final report · Jun 4, 1986 · N1835W · Destroyed > The plt obtained a wx briefing and was advised of scattered thunderstorm activity along his route of flt. The plt then filed an IFR flt plan from wiley post airport, Oklahoma city, OK, to houston intercontinental airport, TX. The plt and his wife took off at… - [NTSB BFO86FA032](https://openairdocs.org/ntsb/BFO86FA032.md): Beech J-35 · Myersville, MD · Accident · Serious injuries · Field investigation · Final report · Jun 4, 1986 · N7266B · Destroyed > While in cruise flight at 3500 feet the pilot stated he experienced a rapid loss of power. Unable to restart the engine, he was forced to land in a pasture which was divided by barbed wire fences. The aircraft collided with a fence and came to rest inverted.… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=325 ## 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=324 --- 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.