# 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 320 of 718 · 35,885 cases ## Cases, newest first - [NTSB MKC86LA193](https://openairdocs.org/ntsb/MKC86LA193.md): Cessna T210M · Old Monroe, MO · Accident · No injuries · Limited investigation · Final report · Sep 23, 1986 · N6163N · Substantial damage > The PIC had initiated his descent ot his destination arpt when he rptd experiencing eng pblms. The rough running eng finally quit and the PIC made a forced lndg to an open fld. The subsequent lndg encountered a ditch and the nose gear collapsed. Exam of the… - [NTSB CHI86FA230](https://openairdocs.org/ntsb/CHI86FA230.md): Cessna 172K · East Tawas, MI · Accident · 2 fatal · Field investigation · Final report · Sep 23, 1986 · N78715 · Destroyed > Aircraft collided with trees while in low level flight following a predawn departure. An airport 10 miles to the north was reporting very low ceilings with visibilities lower than 1/2 mile in fog and drizzle. The proximity to the departure airport and the… - [NTSB ATL86FA264](https://openairdocs.org/ntsb/ATL86FA264.md): Bell 222UT · Galax, VA · Accident · 3 fatal · Field investigation · Final report · Sep 23, 1986 · N251CC · Destroyed > The helicopter was dispatched on an emerg med svc (ems/med-evac) flt to transport a patient with subcranial bleeding back to a hospital in winston-salem. Bfr takeoff, the plt received a wx briefing. At that time, widespread IMC prevailedthru-out the area &… - [NTSB NYC86LA241](https://openairdocs.org/ntsb/NYC86LA241.md): Piper PA-28-140C · Indiana, PA · Accident · No injuries · Limited investigation · Final report · Sep 21, 1986 · N6004U · Substantial damage > The acft was substantially damaged during a forced landing following a loss of eng power. Examination of the acft showed the fuel selector was on the the left tank which contained no useable fuel. There was useable fuel remaining in the right tank. The plt… - [NTSB MIA86IA250](https://openairdocs.org/ntsb/MIA86IA250.md): Bell 206L-3 · Atlantic Ocean (Atlantic Ocean) · Incident · No injuries · Incident investigation · Final report · Sep 20, 1986 · N111GF · No damage > The helicopter ditched in the Ocean after sustaining a flameout. After the helicopter was towed ashore on its floats the fuel system was found to contain at least 4 gals of fuel. Info contained in helicopter manual revealed all fuel was usable except about 1… - [NTSB SEA86LA249](https://openairdocs.org/ntsb/SEA86LA249.md): Cessna P-210 · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1986 · N6185W · Substantial damage > While in cruise at 14,000 feet MSL, a catastrophic engine failure with a flash fire at the turbocharger occurred. A turn to reverse direction for a forced landing was initiated while making a rapid descent. An undershoot to the runway occurred with the… - [NTSB NYC86FA237](https://openairdocs.org/ntsb/NYC86FA237.md): Cessna 337D · Lapeer, NY · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1986 · N2680S · Destroyed > The acft collided with the terrain during the plts attempt to complete a night x-country in IMC wx conditions. The flt had progressed aprx 4 hrs & 34 min from SC to NY prior to the crash. The plt was not currently rated to fly IFR. The plt reported by radio… - [NTSB SEA86LA247](https://openairdocs.org/ntsb/SEA86LA247.md): Great Lakes 2T-1A-2 · Tillamook, OR · Accident · No injuries · Limited investigation · Final report · Sep 18, 1986 · N3565L · Substantial damage > A precautionary landing was made on a field due to low fuel, lowering ceiling and visibility, ensuing darkness, and the pilot not knowing his exact position. Landing was made on an uphill field with a slight tail wind. The aircraft struck a swale and then… - [NTSB LAX86FVA14](https://openairdocs.org/ntsb/LAX86FVA14.md): Hiller UH-12E · Lemoore, CA · Accident · Minor injuries · Final report · Sep 18, 1986 · N688SB · Substantial damage > The plt reptd that while returning to the loading area after spraying a field, he heard a loud pop emanating from the engine compartment. Shortly thereafter he observed a fire in the engine compartment and lost forward and aft control of the helicopter. The… - [NTSB NYC86LA238](https://openairdocs.org/ntsb/NYC86LA238.md): Cessna 150 · Ashburnham, MA · Accident · No injuries · Limited investigation · Final report · Sep 16, 1986 · N6344S · Substantial damage > While crusing at an altitude of about 3500 feet, the flight suffered fuel exhaustion and lost engine power causing the pilot to execute a forced landing in a field. - [NTSB MKC86FA189](https://openairdocs.org/ntsb/MKC86FA189.md): Piper PA28-151 · Foristell, MO · Accident · 2 fatal · Field investigation · Final report · Sep 16, 1986 · N44501 · Destroyed > Radar signal data recorded the subj acft moving northwest in a shallow climb. The track data terminated abt 0538 c.d.t. or abt 12 minutes into the flt. A witness near the VOR station stated he heard an acft flying overhead, abt the time the FAA reported… - [NTSB DEN86FA252](https://openairdocs.org/ntsb/DEN86FA252.md): Cessna 172M · Bennett, CO · Accident · 1 fatal · Field investigation · Final report · Sep 16, 1986 · N1691V · Destroyed > The plt, a bail bondsman, flew to goodland, KS, reportedly in search of an accused felon. On the afternoon of the accident, the plt obtained a wx briefing from the fss and filed a VFR flt plan back to the brighton-van aire airport in Colorado. Wx was cavu.… - [NTSB ANC86LA157](https://openairdocs.org/ntsb/ANC86LA157.md): Maule M-5-235C · Redoubt Bay, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 1986 · N77LM · Substantial damage > The non-instrument rated pvt plt became caught on top of a cloud layer during flt and was given ATC assitance. After getting below the clouds the plt encountered fog covered land and water. The plt landed the floatplane in shallow water in an inlet. The… - [NTSB DEN86FA249](https://openairdocs.org/ntsb/DEN86FA249.md): Cessna 182G · Brighton, CO · Accident · 1 fatal · Field investigation · Final report · Sep 15, 1986 · N2030R · Destroyed > At approximately 0415 hours when it was still night time, the non instrument rated private plt took off on an extended cross country flt to Kentucky. About 15 minutes later he was observed flying in a left turn, at an attitude of 50 to 75 feet in heavy fog… - [NTSB BFO86LA048](https://openairdocs.org/ntsb/BFO86LA048.md): Cessna 177B · Westminster, MD · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1986 · N34251 · Substantial damage > Five inches of one propeller blade tip separated during cruise flight at an altitude of 3,500 ft MSL. The imbalance resulted in a severe vibration and a partial power loss. Unable to maintain altitude, the plt set up for a forced landing at clearview airport.… - [NTSB NYC86LA245](https://openairdocs.org/ntsb/NYC86LA245.md): Ryan-Navion A · Lakeport, NY · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N5146K · Substantial damage > The rocker box cover on the #6 cylinder had the top and bottom screws loose and the center screw missing, causing oil to leak from the bottom of the rocker box cover. - [NTSB LAX86LA347](https://openairdocs.org/ntsb/LAX86LA347.md): Aero Commander 100 · Rio Linda, CA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N3879X · Substantial damage > At the end of a local pleasure flight, the pilot noticed a loss of oil pressure approximately 10 miles north of Rio Linda airport. Three minutes later the engine began running rough and the pilot initiated an emergency landing in a rice field. Upon touchdown,… - [NTSB CHI86LA221](https://openairdocs.org/ntsb/CHI86LA221.md): Cessna 152II · Carbondale, IL · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N6490L · Substantial damage > The pilot stated that as he was returning to the airport, the engine sputtered once and the RPM dropped very low. He applied carb heat, but there was no change, so he made an emergency landing in a corn field where the aircraft nosed over. During an… - [NTSB BFO86FA047](https://openairdocs.org/ntsb/BFO86FA047.md): Bellanca 8GCBC · Woodbine, MD · Accident · 2 fatal · Field investigation · Final report · Sep 14, 1986 · N53899 · Destroyed > Witnesses observed the aircraft nose over into a dive after the glider it had been towing released. They then saw it roll and during the roll the left wing departed the aircraft. The CFI in the glider had observed the pilot of N53899 perform what appeared to… - [NTSB NYC86FGM07](https://openairdocs.org/ntsb/NYC86FGM07.md): Tapaszy Benson B-8-M · Cooperstown, PA · Accident · 1 fatal · Final report · Sep 13, 1986 · N6154 · Destroyed > The benson B-8-M gyrocopter was observed to take off and transition to level flight. The nose of the aircraft was then observed to dip and then the aircraft banked left and crashed. The aircraft was destroyed and the pilot received fatal injuries. No… - [NTSB FTW86LA166](https://openairdocs.org/ntsb/FTW86LA166.md): Mooney M20E · Oklahoma City, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 1986 · N1250X · Substantial damage > The pilot apparently had neglected to check his engine oil supply before takeoff since there was no oil in the crankcase at the time of the accident. If five quarts of oil (the amount the pilot reportedly stated was in the engine at takeoff) had leaked out… - [NTSB DEN86LA250](https://openairdocs.org/ntsb/DEN86LA250.md): Piper PA-18A-150 · Casper, WY · Accident · No injuries · Limited investigation · Final report · Sep 12, 1986 · N8595D · Substantial damage > While in normal cruise flt, after crossing a ridgeline, the plt encountered downdraft wind currents. The acft entered a descent from which the plt could not recover. He attempted to make an emergency forced landing in rough desert terrain. The acft impacted… - [NTSB ATL86LA255](https://openairdocs.org/ntsb/ATL86LA255.md): Cessna T310R · Louisville, KY · Accident · No injuries · Limited investigation · Final report · Sep 12, 1986 · N6171X · Substantial damage > The plt was on a VFR cross country flt when the left eng began to run rough. He diverted to bowman field and made a precautionary landing where he left the aircraft with a FBO to be repaired. Examination showed that the overboard dump part of the exhaust… - [NTSB NYC86FA234](https://openairdocs.org/ntsb/NYC86FA234.md): Cessna U206F · Holoyoke, MA · Accident · Serious injuries · Field investigation · Final report · Sep 11, 1986 · N8316Q · Substantial damage > While en route at 6000 ft, the acft lost power. The plt descended through a scattered layer of clouds and made a forced landing in a grass covered field 1 1/2 miles north of barnes municipal airport, shearing off the nose gear and coming to rest inverted.… - [NTSB BFO86LA051](https://openairdocs.org/ntsb/BFO86LA051.md): Cessna 152 · Mappsville, VA · Accident · No injuries · Limited investigation · Final report · Sep 10, 1986 · N64934 · Substantial damage > The plt experienced a drop in engine power during cruise flight. He applied carburetor heat and power was regained. A precautionary landing was made at nearby accomack co arpt. Several engine runups were done and there was no problem detected. He departed the… - [NTSB BFO86LA045](https://openairdocs.org/ntsb/BFO86LA045.md): Piper PA-28-181 · Fredericksburg, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 1986 · N4350K · Substantial damage > The acft nosed over drg a forced lndg following a total loss of pwr due to fuel exhaustion. The plt rprtd that both he &the passengers visually checked the fuel tanks prior to departure to verify that they were full of fuel. The pwr loss occurred aprx 25 mi… - [NTSB NYC86IA231](https://openairdocs.org/ntsb/NYC86IA231.md): Piper PA-60-600 · Binghamton, NY · Incident · No injuries · Incident investigation · Final report · Sep 9, 1986 · N90349 · Minor damage > The plt stated that after leveling off at 9000 ft MSL. He heard a pop followed by an explosion in the left eng. The entire left side of the upper cowling was protruding into the airstream which caused the aircraft to roll to the right. The pilot had to use… - [NTSB NYC86FA232](https://openairdocs.org/ntsb/NYC86FA232.md): Sikorsky SK-76 · White Plains, NY · Accident · No injuries · Field investigation · Final report · Sep 9, 1986 · N93AE · Substantial damage > Aprx 12 seconds after takeoff while climbing through 400 ft the acft experienced a tail rotor paddle separation. The yellow paddle blade failed first followed by the red. The plt reported hearing a loud bang followed by a severe vibration. A precautionary… - [NTSB ANC86LA149](https://openairdocs.org/ntsb/ANC86LA149.md): Piper PA-18 · Umiat, AK · Accident · 2 fatal · Limited investigation · Final report · Sep 8, 1986 · N9049Z · Destroyed > The airplane departed on September 7, 1986 for a local hunting trip with a client. The airplane did not return and the wreckage was found on September 9, 1986. The airplane was destroyed by post-impact fire. According to the guide, for whom the pilot was… - [NTSB ANC86LA146](https://openairdocs.org/ntsb/ANC86LA146.md): Piper PA-14 · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · Sep 8, 1986 · N4290H · Substantial damage > The engine quit during flight due to carburetor ice. The plt became committed to a forced landing after he was unable to restart the engine. A downwind landing was made in strong wind conditions. Control of the acft was lost and it overturned in a mud flat. - [NTSB SEA86LA241](https://openairdocs.org/ntsb/SEA86LA241.md): Cessna 185 · St. John, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1986 · N2262T · Substantial damage > After running a fuel tank dry in flight, the plt switched fuel tanks but failed to assure that the fuel selector was in the detent. The engine quit running and a forced landing was made in rough terrain. - [NTSB SEA86LA242](https://openairdocs.org/ntsb/SEA86LA242.md): Piper PA-28-140 · Pomeroy, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1986 · N15390 · Destroyed > The pilot was flying over unfamiliar terrain at a low altitude in order to spot elk. The pilot encountered steep rising terrain which his aircraft was unable to out climb. Density altitude at the time of the accident computes to be approximately 7,500 feet.… - [NTSB ATL86LA248](https://openairdocs.org/ntsb/ATL86LA248.md): Ellis VARI-EZE · Wilkesboro, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1986 · N547EZ · Destroyed > Plt said he attempted to make a go around due to other acft on the rwy. When throttle was advanced engine remained at idle power. Plt elected to land in corn field at end of rwy. On landing roll acft nosed over inverted. Later exam of engine showed throttle… - [NTSB SEA86FA239](https://openairdocs.org/ntsb/SEA86FA239.md): Ercoupe 415-C · Auburn, WA · Accident · No injuries · Field investigation · Final report · Sep 5, 1986 · N99313 · Destroyed > The plt reported he was climbing after a touch and go, during the climb the 'blown fuse' light came on for the generator. After replacing the fuse sparks started coming from behind the instrument panel. Smoke filled the cockpit as the plt tried to smother the… - [NTSB LAX86LA360](https://openairdocs.org/ntsb/LAX86LA360.md): Burkhart Grob G102 III B · California City, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 5, 1986 · N630BG · Destroyed > The plt stated he was towed to an alt of aprx 2,000 ft AGL. After release the canopy came open and the plt returned to the arpt. On final apch he noticed the airspeed indicator was indicating 'low forties'. The plt stated the next thing he remembered was… - [NTSB ATL86LA243](https://openairdocs.org/ntsb/ATL86LA243.md): Cessna 172M · Monroe, GA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1986 · N12619 · Substantial damage > The plt departed cox sky ranch for a flt to stone mt, GA. When he could not receive norcross VOR, he stated that he thought he was having nav radio problems and elected to land at Monroe, GA. Prior to landing he noted the right fuel gauge reading almost empty… - [NTSB ATL86FA242](https://openairdocs.org/ntsb/ATL86FA242.md): Luscombe 8C · Lavonia, GA · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1986 · N39068 · Destroyed > The pilot had been diagnosed as having a brain tumor and was taking 300 mg of dilantin daily for the giloma. He suffered a grand mal seizure about two months before the accident. His mother stated that the pilot told her during a telephone conversation that… - [NTSB SEA86LA237](https://openairdocs.org/ntsb/SEA86LA237.md): Cessna 150L · Kent, WA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1986 · N18079 · Substantial damage > During an instructional flight a partial loss of power occurred due to the mixture control cable at the carburetor end becoming loose. During forced landing on a field, two railroad ties, on a dirt pile, were struck. It was dusk at the time of the accident. - [NTSB FTW86LA160](https://openairdocs.org/ntsb/FTW86LA160.md): Boeing E75 · Sweetwater, TX · Accident · No injuries · Limited investigation · Final report · Sep 2, 1986 · N4563N · Substantial damage > While the acft was in cruise flt, the engine suddenly went to idle power. The plt attempted to land in a clearing, but was unable to reach the intended area. During the landing, the acft collided with low mesquite trees, damaging the landing gear & wings. An… - [NTSB DEN86FA246](https://openairdocs.org/ntsb/DEN86FA246.md): Cessna 182D · Las Vegas, NM · Accident · 4 fatal · Field investigation · Final report · Sep 2, 1986 · N83F · Destroyed > The acft departed the albuquerque, new Mexico, coronado arpt, at 2248 MDT, September 1, 1986, en route to Las Vegas, new Mexico. When the acft failed to arrive as scheduled, a search was initiated. The flight was lost on radar at 2353 MDT, 15 nautical miles… - [NTSB MKC86LA184](https://openairdocs.org/ntsb/MKC86LA184.md): Cessna 172N · Vichy, MO · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N738CH · Substantial damage > The pilot stated that the aircraft's ammeter indicated the electrical system was discharging while at cruise five miles west of rolla national airport, Missouri, and that he decided to continue to his destination airport. Fifteen miles east of rolla national… - [NTSB ATL86LA237](https://openairdocs.org/ntsb/ATL86LA237.md): Cessna 152 · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N66989 · Substantial damage > The plt flew the aircraft twice, another plt flew it once then the plt attempted another flight. He reported to app control that he thought he was out of fuel. An off airport landing was attempted. Examination of the aircraft showed less than one gallon of… - [NTSB SEA86FA233](https://openairdocs.org/ntsb/SEA86FA233.md): Cessna 180 · Wallace, ID · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1986 · N4703B · Destroyed > Plt received wx brief, advised VFR for proposed flt. Plt filed VFR flt plan and departed. Wreckage located 2 days later at crest of mountain pass. - [NTSB LAX86LA340](https://openairdocs.org/ntsb/LAX86LA340.md): Great Lakes 2T-1A-2 · Santa Paula, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1986 · N10SV · Destroyed > The biplane crashed in mountainous terrain after a loss of power. The acft had been doing aerobatic maneuvers prior to the engine failure. The plt indicated that the engine quit at 7,500 ft MSL while in a descent. She relinquished the flt controls to the… - [NTSB DCA86AA041](https://openairdocs.org/ntsb/DCA86AA041.md): McDonnell Douglas DC-9-32 · Cerritos, CA · Accident · 82 fatal · Class 1 · Final report · Aug 31, 1986 · XAJED · 2 aircraft · Destroyed > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/07. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm At… - [NTSB SEA86LA229](https://openairdocs.org/ntsb/SEA86LA229.md): Bellanca 7ECA · Tygh Valley, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1986 · N5159T · Substantial damage > An uncertificated plt was flying the acft at a low altitude when the acft struck wires. Due to the damage to the acft a forced landing was made onto a bark dump where additional damage occurred to the acft. - [NTSB SEA86FA232](https://openairdocs.org/ntsb/SEA86FA232.md): Piper PA-28-180 · John Day, OR · Accident · 2 fatal · Field investigation · Final report · Aug 30, 1986 · N3618R · Destroyed > The non-instrument rated pilots departed hermiston en route to burns, Oregon. Visual meteorological conditions prevailed; however, mountain tops along the route of flight were occasionally obstructed by local cloud layers. During the course of the flight the… - [NTSB MKC86LA182](https://openairdocs.org/ntsb/MKC86LA182.md): Cessna 172 · Hayes Center, NE · Accident · No injuries · Limited investigation · Final report · Aug 30, 1986 · N75571 · Substantial damage > While en route, the plt encountered deteriorating wx conditions. He stated that he found himself above an overcast with visibilities decreasing. He saw a hole in the cloud layer and descended thru it. He stated that wx conditions were bad below the cloud… - [NTSB LAX86LA338](https://openairdocs.org/ntsb/LAX86LA338.md): Cessna 182B · La Jolla, CA · Accident · No injuries · Limited investigation · Final report · Aug 30, 1986 · N2710G · Destroyed > The pilot of a Cessna 182 ditched into the ocean after experiencing a loss of engine power. The weather was instrument meteorological conditions in the area. The pilot indicated the fuel gauges indicated less than 1/4 of fuel on the right tank at the time of… - [NTSB CHI86MA216](https://openairdocs.org/ntsb/CHI86MA216.md): Boeing 737-222 · Lansing, MI · Incident · No injuries · Major investigation · Final report · Aug 30, 1986 · N749N · 2 aircraft · No damage > Piedmont flt PI255 (a Boeing 737, N749N) was dscndg in visual conds on an IFR clnc when it & a twin commanche (Piper PA-30, N7399Y) converged & passed within a rprtd 50 to 100 ft of each other. The near collision occurred as the PA-30 was cruising westbound… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=321 ## 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=320 --- 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.