# 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 382 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC82DA138](https://openairdocs.org/ntsb/NYC82DA138.md): Grumman AA-1C · West Haven, CT · Accident · No injuries · Final report · Jul 2, 1982 · N39050 · Substantial damage > The student pilot departed bridgeport, CT at 1200 hours and arrived at nantucket, ma at 1345 hours. While en route, he made a touch-and-go at fishers island and practiced stall maneuvers. He departed nantucket at about 1430 hours without refueling.… - [NTSB LAX82FA247](https://openairdocs.org/ntsb/LAX82FA247.md): Hughes 369B · Jenner, CA · Accident · No injuries · Field investigation · Final report · Jul 2, 1982 · N1108T · Substantial damage > Helicopter was on routine police patrol when engine failed and it autorotated to a rough landing on a rocky beach. The 1st stage of the gas producer section of the turbine was found frozen. The turbine wheel blades were rubbing & seized to the 1st stage… - [NTSB LAX82FA240](https://openairdocs.org/ntsb/LAX82FA240.md): Beech V35B · 37 Nm Nw. Of Re, CA · Accident · 2 fatal · Field investigation · Final report · Jul 2, 1982 · N23725 · Destroyed > During a weather briefing before takeoff, the pilot was advised of flight precautions for turbulence, IFR conditions, and icing. While en route at 12,000 ft, the pilot reported that he was picking up rime ice. He was cleared to 11,000 and then 10,000 ft. when… - [NTSB DEN82DA125](https://openairdocs.org/ntsb/DEN82DA125.md): Ercoupe 415-C · Wamsutter, WY · Accident · Minor injuries · Final report · Jul 2, 1982 · N99481 · Substantial damage > The pilot became sick during the flight and elected to land on a highway. He took spacing behind a truck, but the truck slowed down, so he continued the landing beside the highway. After lowering the nosewheel, it hit a ditch and collapsed, and the aircraft… - [NTSB ATL82DA183](https://openairdocs.org/ntsb/ATL82DA183.md): Bell 47D1 · Louisville, KY · Accident · No injuries · Final report · Jul 2, 1982 · N929B · Substantial damage > The pilot was en route to have a radio installed when the engine lost power. He made an autorotative landing in an open field. When the helicopter contacted the ground, the main rotor, tail rotor, tail boom, and skids were damaged. The pilot stated that he… - [NTSB NYC82DA136](https://openairdocs.org/ntsb/NYC82DA136.md): Cessna 182Q · Sidman, PA · Accident · No injuries · Final report · Jul 1, 1982 · N735TR · Substantial damage > At approximately 10 miles out of johnstown, PA while descending through 5000 ft, the pilot realized he was running out of fuel. At about 4000 ft the pilot spotted a field and an approach to landing was initiated. During the landing roll the front wheel… - [NTSB CHI82DA230](https://openairdocs.org/ntsb/CHI82DA230.md): Piper PA-28-161 · Ladysmith, WI · Accident · No injuries · Final report · Jul 1, 1982 · N40037 · Substantial damage > The student pilot collided with a fence and rough terrain during a forced landing on a cross-country flight. The student heard a loud knocking from the engine after about 35 minutes of flight. He reduced power which helped but the engine was still noisy. The… - [NTSB ATL82FLQ07](https://openairdocs.org/ntsb/ATL82FLQ07.md): KR-2 · Mcwhorter, KY · Accident · Serious injuries · Final report · Jul 1, 1982 · N27JK · Destroyed > This was a home built aircraft that was equipped with an uncertificated, variable pitch, propeller. During flight, a propeller blade separated and the plane was substantially damaged when a forced landing was made on upward sloping terrain. The aircraft and… - [NTSB FTW82DA256](https://openairdocs.org/ntsb/FTW82DA256.md): Cessna 150A · Fabens, TX · Accident · No injuries · Final report · Jun 30, 1982 · N7027X · Substantial damage > The pilot reported that on a flight from midland to el paso, TX, he encountered marginal weather. Flight watch had reported rain and thunderstorm activity about 30 miles east of el paso. As the weather on his route worsened and became more turbulent, he… - [NTSB ATL82DA181](https://openairdocs.org/ntsb/ATL82DA181.md): Cessna 172 · Martinsburg, WV · Accident · No injuries · Final report · Jun 30, 1982 · N61791 · Substantial damage > Shortly after level-off to cruise, the engine began to lose power. The pilot attempted to restore the power, but the engine RPM continued to decrease. A turn was made back toward the airport. While scanning the instruments, zero oil pressure and a high oil… - [NTSB SEA82DA098](https://openairdocs.org/ntsb/SEA82DA098.md): Piper PA-32-300 · Glacier Bay, AK · Accident · No injuries · Final report · Jun 29, 1982 · N2947N · Substantial damage > The aircraft engine stopped during normal cruise and an emergency landing was made in a dry river bed. The landing gear collapsed from overload during the landing. Examination of the engine revealed a connecting dowel for a drive gear driven by the crankshaft… - [NTSB DEN82DA121](https://openairdocs.org/ntsb/DEN82DA121.md): Ayres S-2C · Greeley, CO · Accident · No injuries · Final report · Jun 29, 1982 · N1648S · Substantial damage > After takeoff the plt noticed the oil temp was increasing & the eng began losing power at about 100 ft AGL. He was unable to gain any additional altitude. He continued flying for another 15 minutes when the eng failed completely. The eng teardown & inspection… - [NTSB ATL82DA180](https://openairdocs.org/ntsb/ATL82DA180.md): Cessna 185 · Scooba, MS · Accident · No injuries · Final report · Jun 29, 1982 · N93DM · Substantial damage > The aircraft was climbing to cruise altitude of 8500 feet. The engine began to lose power, then quit entirely. The pilot called the accompaning aircraft and made an emergency landing in a plowed field. The aircraft nosed over during landing. Examination… - [NTSB FTW82FPA14](https://openairdocs.org/ntsb/FTW82FPA14.md): Mooney M20E · Paris, TX · Accident · Minor injuries · Final report · Jun 28, 1982 · N79831 · Substantial damage > About 20 min after takeoff, the pilot noticed oil on the left side glass and windshield while cruising at 7000 ft. he then checked oil pressure and it was near zero. He shut down the engine, and during a forced landing, the aircraft was substantially damaged.… - [NTSB FTW82DA252](https://openairdocs.org/ntsb/FTW82DA252.md): Beech 35 · Graham, TX · Accident · No injuries · Final report · Jun 28, 1982 · N2880V · Substantial damage > While descending through about 2800 ft AGL to land, the engine lost power. The pilot was unable to restart the engine and elected to land in an OAT field with oats about 2 to 3 ft high. The pilot reported that during the landing roll, the nose gear collapsed… - [NTSB NYC82DA173](https://openairdocs.org/ntsb/NYC82DA173.md): Cessna 150L · Shapleigh, ME · Accident · Minor injuries · Final report · Jun 27, 1982 · N11457 · Substantial damage > The pilot departed on a cross-country flight from jackman, ME to rochester, NH and return. Prior to takeoff, the fuel tanks were topped off. During the preflight, the left fuel gauge was found to be "pinned" at the full position and was inoperative. After… - [NTSB LAX82FVM15](https://openairdocs.org/ntsb/LAX82FVM15.md): Cessna 150 · Point Lobos, CA · Accident · Minor injuries · Final report · Jun 27, 1982 · N45477 · Substantial damage > The pilot reported that his standard procedure was to keep the fuel tanks topped off. However, the refueling facility was closed after he returned from the previous flight. While calculating fuel for this flight, he forgot to account for the fuel that had… - [NTSB LAX82FA236](https://openairdocs.org/ntsb/LAX82FA236.md): Cessna 182 · Trinity Center, CA · Accident · 3 fatal · Field investigation · Final report · Jun 27, 1982 · N759NE · Destroyed > The plt contacted the redding, CA tower & stated he was on top & 41 mi from the redding VOR. He then reported he was going into the clouds & requested radar service. He then contacted oakland ARTCC who provided assistance until the plt stated he had found a… - [NTSB DCA82AA027](https://openairdocs.org/ntsb/DCA82AA027.md): Pterodactyl Ascender · Near Largo, MD · Accident · 1 fatal · Final report · Jun 27, 1982 · NONE · Destroyed > While preparing for a flight to film a segment for a tv program about ultralights,the pilot completed a series of taxi tests & climbs to about 50FT AGL followed by an immediate landing. He had been previously instructed to use no more THAN3/4 power & never… - [NTSB FTW82DA250](https://openairdocs.org/ntsb/FTW82DA250.md): Beech D18S · Belen, NM · Accident · No injuries · Final report · Jun 26, 1982 · N3962 · Substantial damage > The pilot stated that during flight, the left engine began leaking oil and the cockpit filled with smoke. He shut down the left engine, but stated that the propeller would not completely feather due to the loss of oil. While approaching to land at a nearby… - [NTSB SEA82DA095](https://openairdocs.org/ntsb/SEA82DA095.md): Cessna U206 · Juneau, AK · Accident · No injuries · Final report · Jun 24, 1982 · N8320Q · Substantial damage > The float equipped aircraft crashed into trees after taking off from samonn creek reservoir while departing with overnight campers. The reservoir was located in a steep walled canyon. The pilot reported that he took off heading north into the canyon, raised… - [NTSB LAX82DA233](https://openairdocs.org/ntsb/LAX82DA233.md): Aeronca 7AC · Porterville, CA · Accident · No injuries · Final report · Jun 24, 1982 · N1938E · Substantial damage > The student pilot was on a local flight with two passengers. He reported that he was flying at about 600 ft AGL with 2100 RPM when he throttled back to 1500 RPM for about 10 seconds. He stated that when he advanced the throttle back to cruise power, the… - [NTSB FTW82DA289](https://openairdocs.org/ntsb/FTW82DA289.md): Piper PA-28-160 · Quinlan, TX · Accident · No injuries · Final report · Jun 24, 1982 · N5514W · Substantial damage > While the pilot was inspecting a power line, the aircraft struck a feeder line that was located perpendicular to the line being checked. The line snapped, but the plane contacted the ground and sheared off the right gear. The aircraft became airborne again.… - [NTSB NYC82FNA17](https://openairdocs.org/ntsb/NYC82FNA17.md): S.N.I.A.S. SA-330J · Hyannis, MA · Accident · No injuries · Final report · Jun 23, 1982 · N3601U · Substantial damage > The pilot reported that he took off, and during a climb through about 800 ft, he heard a loud snap and immediately felt severe lateral vibrations. He declared an emergency and landed without further incident. An investigation revealed that the inboard… - [NTSB MKC82FA110](https://openairdocs.org/ntsb/MKC82FA110.md): Bellanca 17-30 · Columbia, MO · Accident · Serious injuries · Field investigation · Final report · Jun 23, 1982 · N6656V · Substantial damage > The plt stated he did not refuel or visually verify fuel quantity prior to departing Kansas city. The flt to st. louis was on the left tank. As the acft approached the Columbia, MO VOR at an altitude of 3000 ft MSL the eng failed. The pilot stated he… - [NTSB MIA82DA140](https://openairdocs.org/ntsb/MIA82DA140.md): Piper PA-38-112 · Deerfield Field, FL · Accident · Minor injuries · Final report · Jun 23, 1982 · N2434K · Destroyed > The engine lost power during cruise flight. The pilot made a forced landing on a beach and collided with rocks and nosed over. The fuel bowl was found loose which lowered the fuel pressure. - [NTSB ANC82FAA05](https://openairdocs.org/ntsb/ANC82FAA05.md): Cessna 185 · Fairbanks, AK · Accident · No injuries · Final report · Jun 23, 1982 · N2635S · Substantial damage > The acft departed emmonak at 0157 adt. While approaching Fairbanks the engine quit & the acft nosed over during an emergency landing on a mudflat. No useable fuel was found in the fuel tanks & the fuel lines were empty. - [NTSB NYC82FNA16](https://openairdocs.org/ntsb/NYC82FNA16.md): Davis DA-2A · Lincoln, RI · Accident · 1 fatal · Final report · Jun 22, 1982 · N2281Z · Destroyed > The pilot was on a local pleasure flight to see that the aircraft was functioning properly after a routine inspection. Just prior to the accident, witnesses heard the engine sputter, then become quiet. The plane was observed to continue straight ahead for… - [NTSB LAX82FUG13](https://openairdocs.org/ntsb/LAX82FUG13.md): Beech 95-C55 · Ontario, CA · Accident · Serious injuries · Final report · Jun 22, 1982 · N707JF · Destroyed > While descending near banning, CA, the pilot lowered the gear after becoming aware of a popped circuit breaker. At the destination, there was an overcast with the tops at 4500 ft, so he diverted toward burbank, CA with the gear down. The overcast extended… - [NTSB FTW82DA239](https://openairdocs.org/ntsb/FTW82DA239.md): Grumman G-164A · Jennings, LA · Accident · No injuries · Final report · Jun 22, 1982 · N9684 · Substantial damage > The pilot had just finished spraying and was on his way back to the airport when the engine failed. A field with grass was selected for an emergency landing. During the landing roll, the aircraft encountered ruts and nosed over. The operator reported that the… - [NTSB ATL82DA175](https://openairdocs.org/ntsb/ATL82DA175.md): Cessna 150M · Christiansburg, VA · Accident · No injuries · Final report · Jun 22, 1982 · N704LX · Substantial damage > After flying from blacksburg, VA to monroe, NC. The pilot took off on a return flight to blacksburg without refueling. The pilot stated that before takeoff, he took the fuel tank caps off to visually check the fuel. However, he did not use the dip stick that… - [NTSB ATL82DA174](https://openairdocs.org/ntsb/ATL82DA174.md): Cessna R182 · Abbeville, SC · Accident · No injuries · Final report · Jun 22, 1982 · N5104S · Substantial damage > During flight, the pilot encountered adverse weather conditions and elected to make a precautionary landing at a nearby airport. He reported that he landed about 700 ft from the approach end of the runway at 70 knots, hydroplaned, and continued off the… - [NTSB MIA82DA139](https://openairdocs.org/ntsb/MIA82DA139.md): Cessna 310 · Near Horseshoe, FL · Accident · No injuries · Final report · Jun 21, 1982 · N5193C · Destroyed > The pilot reported that during an over water flight, he noticed the right engine fuel flow was fluctuating while the engine was cutting in and out. This was followed by intense white smoke which was observed coming out of the louvers on top of the engine… - [NTSB MIA82DA138](https://openairdocs.org/ntsb/MIA82DA138.md): Brantly B-2B · Ruskin, FL · Accident · No injuries · Final report · Jun 21, 1982 · N2282U · Destroyed > The plt experienced heavy vibration followed by loss of control of the acft. Witnesses described the acft in abrupt changes in attitude. Exam of the pitch link assemblies revealed failure under static overload conditions. A third pitch link assembly was not… - [NTSB LAX82FA226](https://openairdocs.org/ntsb/LAX82FA226.md): Cessna 172 · Granada Hills, CA · Accident · Serious injuries · Field investigation · Final report · Jun 21, 1982 · N738GF · Destroyed > The student pilot departed van nuys, CA at about 1530 PDT on a round-robin, cross-country flight to turlock, CA. It was a combination personal and training flight. His instructor pilot (CFI) had verbally approved the flight, but did not endorse the student's… - [NTSB NYC82FHM07](https://openairdocs.org/ntsb/NYC82FHM07.md): Piper PA-18-150 · Sandy Hook Beac, NJ · Accident · Serious injuries · Final report · Jun 20, 1982 · N6879B · Substantial damage > The pilot reported that while he was towing a banner, the engine RPM began to decrease. He initiated emergency procedures, but could not restore the power. The plane was maneuvered for a forced landing on a beach. The plane crashed on the beach while the… - [NTSB CHI82DA221](https://openairdocs.org/ntsb/CHI82DA221.md): Peter Clark Super Acro CUB · Delaware, OH · Accident · Serious injuries · Final report · Jun 20, 1982 · N222PC · Substantial damage > After completing several aerobatic flights, the pilot proceeded to another airport to obtain fuel. While en route, the engine lost all power and would not restart. Subsequently, the aircraft was damaged during a forced landing in a soybean field. An… - [NTSB ATL82DA169](https://openairdocs.org/ntsb/ATL82DA169.md): Cessna 182B · Tuscaloosa, AL · Accident · Minor injuries · Final report · Jun 20, 1982 · N2519G · Substantial damage > The pilot had flown from eutaw to seale, AL to participate in a parachute activity. Although the plane was equipped for parachuting, it was not used for that purpose on that trip. Before returning to eutaw, the pilot used a dipstick to check the fuel and… - [NTSB FTW82DA228](https://openairdocs.org/ntsb/FTW82DA228.md): Cessna 152 · Tulsa, OK · Accident · Minor injuries · Final report · Jun 17, 1982 · N49482 · Destroyed > The aircraft lost power during climb at 1300 feet. The engine would not restart. The pilot made a forced landing in the Arkansas river. No preimpact malfunction or failure of the aircraft's engine could be found. - [NTSB ANC82DA049](https://openairdocs.org/ntsb/ANC82DA049.md): Piper PA-32-300 · Near Ekwok, AK · Accident · No injuries · Final report · Jun 17, 1982 · N9561K · Substantial damage > The pilot made a forced landing when power would not develop more than 1500 rmp. Takeoff and climb had been normal up to 1000 feet when the engine began to lose power. Since not enough power was available to continue flight a landing was made in the tundra.… - [NTSB MKC82DA104](https://openairdocs.org/ntsb/MKC82DA104.md): Cessna 152 · 10 Sw Falls Cit, NE · Accident · No injuries · Final report · Jun 16, 1982 · N49974 · Substantial damage > The pilot stated that he took off to take photographs in nemaha county, KS. While enroute, he shot 6 rolls of film and then continued toward falls city, NE. He reported that about 7 miles from the airport, he ran out of fuel and landed in a wheat field. After… - [NTSB FTW82DA227](https://openairdocs.org/ntsb/FTW82DA227.md): Boeing 75A · Picher, OK · Accident · No injuries · Final report · Jun 16, 1982 · N450LR · Substantial damage > The pilot had just completed spraying a field and was climbing to return to his home airstrip when the engine failed. He landed in a nearby pasture but was unable to stop on the wet terrain before hitting a low fence. The main gear caught on the fence and the… - [NTSB ANC82IA048](https://openairdocs.org/ntsb/ANC82IA048.md): De Havilland DHC-6-100 · Near Port Heide, AK · Incident · No injuries · Incident investigation · Final report · Jun 16, 1982 · N525N · Minor damage > While in cruise flight, the left engine surged twice and the pilot observed fire emitting from the exhaust and cowling. After securing the engine and discharging the fire bottle without effect, the pilot made a precautionary landing at Port heiden airport.… - [NTSB FTW82FA223](https://openairdocs.org/ntsb/FTW82FA223.md): Piper PA-32R-301 · Hartshorne, OK · Accident · 3 fatal · Field investigation · Final report · Jun 15, 1982 · N8442T · Destroyed > While on a cross-country flight, the pilot was advised by radio of a severe thunderstorm and tornado watch along his route. At 1613 CDT, he was advised of a line of radar returns about 10 miles ahead. He replied that it "looks like a soft spot through there,… - [NTSB ATL82FA164](https://openairdocs.org/ntsb/ATL82FA164.md): Cessna 172P · Asheville, NC · Accident · Serious injuries · Field investigation · Final report · Jun 15, 1982 · N6545K · Destroyed > The flt reportedly involved mountain flying techniques. The student observed that the acft was not climbing normally & the CFI suggested they slow to 70K. The student started a turn toward a wide valley but the CFI urged him to continue toward the mtns which… - [NTSB ATL82DA165](https://openairdocs.org/ntsb/ATL82DA165.md): Beech A36 · Myrtle Beach, SC · Accident · Minor injuries · Final report · Jun 15, 1982 · N1691W · Destroyed > As the pilot approached his destination, he descended from 9000 ft MSL and leveled at 1600 ft MSL. At about the time he leveled, the engine quit abruptly. He stated that he switched the fuel selector to the right tank and tried to start the engine, but was… - [NTSB SEA83FA196](https://openairdocs.org/ntsb/SEA83FA196.md): Mooney M-20 · Sandy, OR · Accident · 1 fatal · Field investigation · Final report · Jun 14, 1982 · N231AW · Destroyed > The acft crashed into rising terrain in marginal weather conditions. No flt plan had been filed. The acft crashed 25 miles from the takeoff point on 6/12/82 and was missing until 9/9/83. The pilot had received a weather briefing from portland fss indicating… - [NTSB SEA82DA088](https://openairdocs.org/ntsb/SEA82DA088.md): Piper PA-38-112 · Oakley, ID · Accident · No injuries · Final report · Jun 14, 1982 · N91319 · Substantial damage > At about 1045 MDT, the pilot departed ogden, ut on a solo, cross-country flight to jackpot, NV, pocatello, ID and return. While en route to jackpot, he encountered turbulence and decreasing visibility over a mountainous area and descended from 8500 ft MSL to… - [NTSB LAX82FA231](https://openairdocs.org/ntsb/LAX82FA231.md): Cessna 182 · Truckee, CA · Accident · 2 fatal · Field investigation · Final report · Jun 14, 1982 · N42488 · Destroyed > At aprx 2015 PDT on 6/13/82, the acft departed petaluma, CA on a ngt, VFR, x-country flt to riverton, WY. An en route stop was planned for elco, NV. No records were fnd of a wx briefing or flt plan. The acft was declared overdue on 6/16/82 & the wreckage was… - [NTSB SEA82DA087](https://openairdocs.org/ntsb/SEA82DA087.md): Cessna 206 · Renton, WA · Accident · No injuries · Final report · Jun 13, 1982 · N60092 > According to the pilot, the aircraft was on its first flight after a major engine overhaul and was being flown for maintenance evaluation. About 45 minutes after takeoff, the pilot requested a descent from 7500 feet MSL. After entering an overcast, the engine… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=383 ## 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=382 --- 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.