# 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 379 of 718 · 35,889 cases

## Cases, newest first

- [NTSB DEN82FTE24](https://openairdocs.org/ntsb/DEN82FTE24.md): Cessna 172M · Monarch Pass, CO · Accident · Serious injuries · Final report · Aug 27, 1982 · N3LT · Destroyed
  > The acft crashed in mountainous terrain at approximately 10,950 ft MSL 22 minutes after takeoff. The temperature at the accident site was about 50 deg f. rate of climb at 10,000 ft MSL & 50 deg f is about 251 fpm at 76 mph.
- [NTSB DEN82FA175](https://openairdocs.org/ntsb/DEN82FA175.md): Convair 340 · Del Norte, CO · Accident · Serious injuries · Field investigation · Final report · Aug 25, 1982 · N477KW · Substantial damage
  > According to the flight crew, VMC had deteriorated into IMC over the mountains. After entering IFR conditions the acft impacted a mountain ridge.
- [NTSB ANC82DAG60](https://openairdocs.org/ntsb/ANC82DAG60.md): Piper PA-28R · Dillingham, AK · Accident · 3 fatal · Final report · Aug 24, 1982 · N5936V · Destroyed
  > Pilot collided with mountainous terrain at the 1400 foot level. He proposed flight on V-452 which does not exist in that area. V-462 would have been appropriate but his position did not coincide with that route. He was on a VFR flight plan. Twilight ended…
- [NTSB MKC82FCJ05](https://openairdocs.org/ntsb/MKC82FCJ05.md): Taylorcraft BC-12-65 · Max, NE · Accident · 1 fatal · Final report · Aug 23, 1982 · N29639 · Destroyed
  > Pilot flying cross-country at low altitude collided with wires and crashed. No malfunctions of aircraft observed.
- [NTSB MKC82DA155](https://openairdocs.org/ntsb/MKC82DA155.md): Aerospatiale AS-355F · Cedar Rapids, IA · Accident · Minor injuries · Final report · Aug 23, 1982 · N57807 · Substantial damage
  > The aircrew lost control of the helicopter while making a pedal turn at 800 to 900 AGL. After 5 rotations, the helicopter impacted the ground, bounced, rolled and fell on its right side. Switches were cut and the crew made an exit. An investigation revealed…
- [NTSB LAX82DA311](https://openairdocs.org/ntsb/LAX82DA311.md): Bell 206B · Grand Canyon, AZ · Accident · No injuries · Final report · Aug 22, 1982 · N83037 · Substantial damage
  > During flight at about 300 ft AGL, there was an abrupt loss of engine power. The pilot descended at 60 to 70 KTS, then made an autorotative landing on a dirt road. During the landing, the main rotor blades struck the tail boom. An engine teardown revealed…
- [NTSB CHI82DA320](https://openairdocs.org/ntsb/CHI82DA320.md): Piper PA-22 · Houston, MN · Accident · No injuries · Final report · Aug 22, 1982 · N8601C · Substantial damage
  > The pilot obtained a weather briefing before departing on a cross-country flight from west bend, WI to waseca, MN. Reportedly, the ceiling was 2500 to 3000 ft or better (as briefed) until after crossing the Mississippi river. The weather then began to…
- [NTSB ATL82DA242](https://openairdocs.org/ntsb/ATL82DA242.md): Cessna 210M · Holly Springs, MS · Accident · Minor injuries · Final report · Aug 22, 1982 · N7320M · Substantial damage
  > The pilot, an aircraft mechanic, made a night forced landing on a highway near Holly Springs, MS. During the landing roll, the right wing contacted two signposts which caused substantial damage to the aircraft. The aircraft continued 520 feet before leaving…
- [NTSB NYC82DA206](https://openairdocs.org/ntsb/NYC82DA206.md): Bell 206L-1 · Ho Ho Kus, NJ · Accident · No injuries · Final report · Aug 21, 1982 · N57480 · Substantial damage
  > While in straight and level flight at 1000 ft, the pilot heard a "pop" in the engine area. He noted that the turbine outlet temperature (tot) began an immediate rise to the high yellow area initially, the power was reduced to 50% torque and the tot returned…
- [NTSB LAX82DA314](https://openairdocs.org/ntsb/LAX82DA314.md): Aeronca 65-TC · Mira Loma, CA · Accident · No injuries · Final report · Aug 21, 1982 · N29473 · Substantial damage
  > The pilot reported that during flight, he ran out of fuel and the plane was damaged during a forced landing. An examination verified there was no preimpact, structural engine failure. Only residual fuel was found in the fuel filter, carburetor, header tank…
- [NTSB FTW82DA342](https://openairdocs.org/ntsb/FTW82DA342.md): Bell 206B · Port Mansfield, TX · Accident · No injuries · Final report · Aug 21, 1982 · N208EH · Substantial damage
  > The helicopter was being ferried to shore from an oil rig when the tailrotor gear box failed and separated from the aircraft. The pilot autorotated to the water. Upon water contact the helicopter rolled over. The pilot had called his skipper on the radio as…
- [NTSB DEN82DA172](https://openairdocs.org/ntsb/DEN82DA172.md): Beech C24R · Palisade, CO · Accident · No injuries · Final report · Aug 21, 1982 · N18906 · Substantial damage
  > According to the pilot, the flight departed the arapahoe airport with the fuel tanks half full because of passenger load factor. As the aircraft approached within 45 miles of the destination airport, the pilot switched from the right fuel tank to the left…
- [NTSB CHI82DA324](https://openairdocs.org/ntsb/CHI82DA324.md): Piper PA-28-160 · Knox, IN · Accident · No injuries · Final report · Aug 21, 1982 · N5796W · Substantial damage
  > The pilot departed on a flight from lake village to Knox, IN. While en route, he landed to refuel at rensselaer, IN. During the flight from rensselaer to Knox, the engine began loosing power when he was about 5 mi from the destination. When the pilot realized…
- [NTSB ATL82DA244](https://openairdocs.org/ntsb/ATL82DA244.md): Piper PA-28-140 · Lexington, MS · Accident · No injuries · Final report · Aug 21, 1982 · N5044T · Substantial damage
  > About 6 minutes after takeoff, there was a partial loss of engine power when the mixture lever was retarded to lean the engine for cruise. The mixture was quickly advanced, but the engine continued to lose power. The pilot turned back toward the departure…
- [NTSB MKC82DA150](https://openairdocs.org/ntsb/MKC82DA150.md): Eagle DW-1 · Holdrege, NE · Accident · No injuries · Final report · Aug 20, 1982 · N8809J · Substantial damage
  > The aircraft nosed over during a forced landing after the engine stopped from fuel exhaustion. The pilot had finished spraying and was on his way to refuel when the loss of power occurred. He picked out a short field for landing and the tailwheel aircraft…
- [NTSB SEA82DA146](https://openairdocs.org/ntsb/SEA82DA146.md): Auster A.O.P.6 · Toledo, WA · Accident · No injuries · Final report · Aug 19, 1982 · N38220 · Substantial damage
  > Aircraft lost wooden propeller during cruise. Aircraft was forced to land on a highway. During approach aircraft wing hit a light pole and yawed. During touchdown it bounced hard on left main landing gear which collapsed.
- [NTSB MKC82DA147](https://openairdocs.org/ntsb/MKC82DA147.md): Piper PA-32-260 · Manhattan, KS · Accident · Minor injuries · Final report · Aug 19, 1982 · N3436W · Substantial damage
  > The pilot departed Manhattan, KS and flew to minneapolis, MN. At minneapolis, he refueled with 10 gal added to the left main tank. He said both main tanks were full, the right auxiliary tank was empty, and he estimated there was 5 gal in the left auxiliary…
- [NTSB LAX82FUG15](https://openairdocs.org/ntsb/LAX82FUG15.md): Piper PA-34-200T · Fontana, CA · Accident · No injuries · Final report · Aug 19, 1982 · N24MF · Substantial damage
  > Approximately 5 hrs after takeoff the plt contacted ontario tower & requested radar vectors to the arpt because he had an eng out. After switching to approach control the plt began receiving vectors to the arpt. At 0209 the plt advised a/c that he ran out of…
- [NTSB MIA82DA172](https://openairdocs.org/ntsb/MIA82DA172.md): Helio H-395 · Near St. Marks, FL · Accident · No injuries · Final report · Aug 17, 1982 · N4197D · Substantial damage
  > During flight, the engine began missing and started vibrating excessively. The pilot force landed in a swamp with sawgrass and the aircraft flipped inverted. The #3 exhaust push rod was missing and was not found, but debris from the push rod shroud tube was…
- [NTSB NYC82DA201](https://openairdocs.org/ntsb/NYC82DA201.md): Ercoupe 415C · Gardner, MA · Accident · No injuries · Final report · Aug 16, 1982 · N3366H · Substantial damage
  > The engine lost power during flight and the pilot engaged the starter with the prop windmilling. The starter gear was found shattered and the starter gear teeth were scattered through various parts of the engine. No reason was found for the original engine…
- [NTSB MIA82DA171](https://openairdocs.org/ntsb/MIA82DA171.md): Engineering & Research 415-C · Clearwater, FL · Accident · No injuries · Final report · Aug 16, 1982 · N99987 · Substantial damage
  > The pilot reported that after he took off on runway 35R, he turned out to the northeast. He reported that when he reached 900 ft, the engine stalled and restarted. He notified the tower and was cleared to land on runway 09. A witness reported observing the…
- [NTSB MIA82DA170](https://openairdocs.org/ntsb/MIA82DA170.md): Cessna 210 · Gainesville, FL · Accident · Minor injuries · Final report · Aug 16, 1982 · YS325 · Substantial damage
  > The pilot ran out of fuel on the last leg of a flight that involved 4 enroute stops. He stated that the fuel gauge showed about 2 hours of fuel when he departed Gainesville. The forced landing occurred about 1 mile east of the airport.
- [NTSB FTW82IA331](https://openairdocs.org/ntsb/FTW82IA331.md): Cessna 421B · El Paso, TX · Incident · Minor injuries · Incident investigation · Final report · Aug 16, 1982 · N1969J · Minor damage
  > N1969J is a 1974 Cessna 421B modified by a riley conversion kit. The aircraft was descending through about 1900 ft MSL when, without previous warning, it yawed left. The pilot reported that the acft then immediately yawed severely to the right and began to…
- [NTSB DEN82DA174](https://openairdocs.org/ntsb/DEN82DA174.md): Piper PA-28RT-201T · 15mi. Ne Of Chr, CO · Accident · No injuries · Final report · Aug 16, 1982 · N3072Z · Destroyed
  > While en route, the engine began to lose power, and subsequently, there was a total power loss. The pilot landed in a small clearing, but during the landing roll, the right main gear hit a large rock. The gear failed and punctured a hole in the fuel tank. The…
- [NTSB DEN82DA173](https://openairdocs.org/ntsb/DEN82DA173.md): Cessna A188B · Britton, SD · Accident · No injuries · Final report · Aug 16, 1982 · N91919 · Substantial damage
  > When the pilot departed to spray the last field for that day, he estimated that he had 19 to 20 gallons of fuel remaining. He figured it would take about 16 to 17 gallons of fuel to complete the job. About 1 hr later, as he was returning to land, the engine…
- [NTSB DEN82DA163](https://openairdocs.org/ntsb/DEN82DA163.md): Piper PA-28-140 · 5nm Colorado Sp, CO · Accident · No injuries · Final report · Aug 16, 1982 · N2292T · Substantial damage
  > The pilot on a cross-country landed after 2.4 hrs. No refueling crew was found so he measured 15 gals into each tank forabout 25 gals each. The next leg was 3.5 hours. At 3.3 hrs both tanks were out of useable fuel 6 miles from the destination. A forced…
- [NTSB LAX82DA304](https://openairdocs.org/ntsb/LAX82DA304.md): Menees LP-49MS · Sparks, NV · Accident · Serious injuries · Final report · Aug 15, 1982 · N1524 · Destroyed
  > The plt stated he released from the tow plane at 1,200 ft AGL in a 200 fpm lift. Almost immediately he encountered a 1,000 fpm sink & immediately entered the pattern for a landing. He was unable to arrest the sink rate & the acft landed hard breaking off the…
- [NTSB DEN82DA162](https://openairdocs.org/ntsb/DEN82DA162.md): Cessna 172XP · 3 Miles Sw Of D, CO · Accident · No injuries · Final report · Aug 15, 1982 · N736JX · Destroyed
  > The aircraft was cruising at 11000 ft when the engine began to run rough. Attempts to enrich and then lean the mixture, throttle adjustments and switching the fuel tanks did not alleviate the engine roughness. The engine then lost all power. Another plt…
- [NTSB FTW82FQD12](https://openairdocs.org/ntsb/FTW82FQD12.md): Luscombe 8E · Timberon, NM · Accident · Serious injuries · Final report · Aug 14, 1982 · N2996K · Destroyed
  > Plt stated he could not gain sufficient altitude to clear terrain. A witness observed the acft at approximately 150-200 ft AGL, well below the top of the canyon.
- [NTSB ATL82DA236](https://openairdocs.org/ntsb/ATL82DA236.md): Cessna 150L · Jacksonville, NC · Accident · No injuries · Final report · Aug 14, 1982 · N5301Q · Substantial damage
  > The pilot reported that the engine lost power while the fuel gauges were indicating at or near 1/4 full. Reportedly, the power loss occurred when the aircraft ran out of fuel. The aircraft was substantially damaged when it was landed in a corn field.
- [NTSB ANC82IA074](https://openairdocs.org/ntsb/ANC82IA074.md): Cessna 207 · Near Anvik, AK · Incident · No injuries · Incident investigation · Final report · Aug 14, 1982 · N1717U · Minor damage
  > During a deadheading flight back to his operations base, the pilot experienced an inflight fire and smoke in the cockpit. After he extinguished the fire and evacuated the smoke, a normal landing was made. Examination of the aircraft revealed that the…
- [NTSB SEA82FA142](https://openairdocs.org/ntsb/SEA82FA142.md): Piper PA32-300 · Shelton, WA · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1982 · N9732K · Destroyed
  > Witnesses 3 miles west of the arpt heard the sounds of the departing acft. As the acft proceeded northbound, sounds of eng power cycling were heard, followed by increasing noise levels as if the acft was returning to the field. At the sudden sound of high…
- [NTSB NYC82FHD18](https://openairdocs.org/ntsb/NYC82FHD18.md): Beech E18S · Lakewood, NJ · Accident · Serious injuries · Final report · Aug 13, 1982 · N380MA · Destroyed
  > Prior to flt the spark plugs on both engs were replaced due to minor eng vibration & the landing gear retract system wiring repaired due to the gear not retracting electrically on a prior occasion. After takeoff the gear would not retract electrically & the…
- [NTSB DEN82FTE23](https://openairdocs.org/ntsb/DEN82FTE23.md): Hughes 369D · Meredith, CO · Accident · Serious injuries · Final report · Aug 13, 1982 · N5014F · Substantial damage
  > The pilot reported that during flight, the engine lost power while he was over steep wooded terrain. He spotted a clearing, but had to use residual RPM to clear trees during the approach. Subsequently, the helicopter landed hard and was substantially damaged.…
- [NTSB MKC82DA145](https://openairdocs.org/ntsb/MKC82DA145.md): Cessna 150J · Conway Springs, KS · Accident · No injuries · Final report · Aug 12, 1982 · N61142 · Destroyed
  > The aircraft engine lost power during landing and the aircraft hit trees 100 yards short of the runway. Post-accident examination disclosed low compression on 3 cylinders and none on number four cylinder. The engine had been low on RPM since the beginning of…
- [NTSB SEA82DA140](https://openairdocs.org/ntsb/SEA82DA140.md): Condor 150L · 16nm No. Of Pie, ID · Accident · Minor injuries · Final report · Aug 10, 1982 · N10517 · Destroyed
  > The eng failed enroute & while landing on a logging road the right wing contacted vegetation causing the acft to swerve & come to rest nose low. The eng had been inspected 1 hr previous to the accident & had 8 hrs of operating time since new at the…
- [NTSB MIA82DA169](https://openairdocs.org/ntsb/MIA82DA169.md): Cessna 172 · Moore Haven, FL · Accident · No injuries · Final report · Aug 10, 1982 · N68266 · Substantial damage
  > The student pilot was on the return portion of a cross-country flight when she deviated to avoid weather. She tried to circumnavigate around lake okeechobee, but in her opinion, the weather began to close in with the visibility decreasing in heavy rain. She…
- [NTSB SEA82DA139](https://openairdocs.org/ntsb/SEA82DA139.md): Enstrom F280 · Seattle, WA · Accident · No injuries · Final report · Aug 9, 1982 · N267Q · Substantial damage
  > Helicopter made an emergency forced landing after power loss aircraft landed heavily in loose dirt and damaged skids and rotors. Post-accident exam found "throttle activating arm was improperly engaged to throttle stop."
- [NTSB SEA82DA138](https://openairdocs.org/ntsb/SEA82DA138.md): Cessna 150 · Forks, WA · Accident · Minor injuries · Final report · Aug 9, 1982 · N9368U · Destroyed
  > The student pilot, on a night cross country flight, became lost, disoriented and low on fuel. He established radio communications with seattle center and was radar vectored to Forks, WA, airport. The pilot was not able to see the runway lights or the…
- [NTSB DEN82DA159](https://openairdocs.org/ntsb/DEN82DA159.md): Aerospatiale SA-315B · Afton, WY · Accident · No injuries · Final report · Aug 9, 1982 · N10067 · Destroyed
  > En route during a seismic operation a loud screeching, grinding sound was heard. The pilot reported the aircraft seemed to buck. A long flame emitting from the aft end of the aircraft was observed by witnesses. The engine ceased and the aircraft crashed into…
- [NTSB ATL82FKW09](https://openairdocs.org/ntsb/ATL82FKW09.md): Grumman AA-1 · Lafayette, TN · Accident · 1 fatal · Final report · Aug 9, 1982 · N5628L · Substantial damage
  > The acft crashed while apparently trying to land in a field drg IFR conditions after loss of a top eng cowling. The plt had just made a may day transmission that he had lost his cowling. It could not be determined whether the cowling was lost before or after…
- [NTSB NYC82DA189](https://openairdocs.org/ntsb/NYC82DA189.md): Piper PA-12 · Wellesley, MA · Accident · No injuries · Final report · Aug 8, 1982 · N4463M · Substantial damage
  > The pilot experienced a power loss and decaying RPM and decided to land short of destination which was 10 miles away. After surveying a pond for landing, the RPM was 600 and the landing was hard enough to damage the floats. As inspection revealed a blockage…
- [NTSB FTW82FRG39](https://openairdocs.org/ntsb/FTW82FRG39.md): Piper PA-23-250 · Bandera, TX · Accident · 1 fatal · Final report · Aug 8, 1982 · N148AF · Destroyed
  > While returning from Mexico, the pilot landed at eagle pass, TX and cleared U.S. Customs. Without refueling or obtaining a weather briefing, he continued toward his home airfield at the flying l ranch near Bandera, TX. Local weather observations indicated…
- [NTSB SEA82FYA09](https://openairdocs.org/ntsb/SEA82FYA09.md): Cessna R172K · Ketchum, ID · Accident · 2 fatal · Final report · Aug 7, 1982 · N736VC · Destroyed
  > The acft was observed flying low over a road in mountainous terrain prior to impact. All pilot and aircraft records were destroyed by fire.
- [NTSB SEA82DA137](https://openairdocs.org/ntsb/SEA82DA137.md): Hughes 369D · Shelton, WA · Accident · No injuries · Final report · Aug 7, 1982 · N10966 · Substantial damage
  > During a sight seeing flight the pilot smelled a burning odor and prepared to make a precautionary off-airport landing. Shortly thereafter, engine RPM decayed and an autorotative landing was effected on a dirt road. On touchdown, the main rotor blades flexed…
- [NTSB ATL82FA233](https://openairdocs.org/ntsb/ATL82FA233.md): Piper PA-28-140 · Folkston, GA · Accident · 2 fatal · Field investigation · Final report · Aug 7, 1982 · N7379J · Destroyed
  > The acft crashed into the okefenokee swamp in se Georgia. Thunderstorms, varying in magnitude from levels 3 to 5, were moving from west of jacksonville FL to an area north of the okefenoke swamp. The storms were moving nw at 20K.
- [NTSB ANC82DA045](https://openairdocs.org/ntsb/ANC82DA045.md): Piper PA-12 · Near Anchorage, AK · Accident · Minor injuries · Final report · Aug 7, 1982 · N251T · Substantial damage
  > The pilot reported that during flight, the engine quit when the right tank went dry. He switched the fuel selector to the left tank, but the engine would not start. Subsequently, the plane was damaged during a forced landing in a creek bottom Near powerlines.…
- [NTSB MIA82DA182](https://openairdocs.org/ntsb/MIA82DA182.md): Beech 65 · Andros Is, Bahamas · Accident · No injuries · Final report · Aug 6, 1982 · N35PK · Destroyed
  > While en route at 9000 ft MSL at night, the right engine reportedly lost power and was feathered. The pilot reported that the left engine had a partial loss of power and the aircraft would not maintain altitude. Communication was maintained with miami center…
- [NTSB FTW82DA315](https://openairdocs.org/ntsb/FTW82DA315.md): Piper PA-28-140 · Springdale, AR · Accident · No injuries · Final report · Aug 6, 1982 · N7176R · Substantial damage
  > The pilot stated taht the aircraft was at 4200 ft descending when the engine suddenly lost power. He was unable to glide to an airport so he landed on a road. During the landing, the right wing hit a road sign and was substantially damaged. After landing, the…
- [NTSB MKC82IA137](https://openairdocs.org/ntsb/MKC82IA137.md): Mitsubishi MU-2B-25 · St. Joseph, MO · Incident · No injuries · Incident investigation · Final report · Aug 5, 1982 · N312MA · Minor damage
  > After takeoff, the pilot was cleared to climb to 6000 ft MSL. While climbing through about 5000 ft, he heard a loud noise (bam) as the left engine lost power. The left engine was shut down and feathered and a landing was made with no other problems. An…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=380

## 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=379

---
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.