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

## Cases, newest first

- [NTSB DEN82FTC08](https://openairdocs.org/ntsb/DEN82FTC08.md): Cessna T210N · Near Laramie, WY · Accident · Minor injuries · Final report · Aug 5, 1982 · N5433A · Substantial damage
  > The pilot reported that on a previous flight, he had an engine problem, in which, he was unable to obtain more than 27 to 28 inches of manifold pressure. He had the engine checked, no problem was found that would have caused the loss of manifold pressure, and…
- [NTSB CHI82DA295](https://openairdocs.org/ntsb/CHI82DA295.md): Boeing Stearman A75-300N1 · Whitehall, WI · Accident · No injuries · Final report · Aug 5, 1982 · N802RB · Substantial damage
  > The pilot received a weather briefing before takeoff, and reportedly, was advised that VFR flight was not recommended. During the flight, the ceiling and visibility began to decrease. The pilot decided to make a precautionary landing in a field. He stated…
- [NTSB CHI82DA294](https://openairdocs.org/ntsb/CHI82DA294.md): Breezy RLU1 · Milwaukee, WI · Accident · No injuries · Final report · Aug 5, 1982 · N59Y · Substantial damage
  > The pilot stated that he got a weather briefing before departing oshkosh, WI. While en route, he encountered fog and rain. The pilot attempted to continue to find timmerman or rainbow airport. The engine lost power due to fuel exhaustion. While landing on a…
- [NTSB ANC82IA067](https://openairdocs.org/ntsb/ANC82IA067.md): Piper J-3 · Near Big Lake, AK · Incident · No injuries · Incident investigation · Final report · Aug 5, 1982 · N70604 · Minor damage
  > During cruise flight, the aircrafts engine lost power and began vibrating severly. After the pilot tried unsuccessfully to remedy the problem, he executed an emergency landing in a marsh. Shortly after touchdown the aircraft bogged down and nosed over. A…
- [NTSB LAX82FVD20](https://openairdocs.org/ntsb/LAX82FVD20.md): Cessna 210 · Livermore, CA · Accident · No injuries · Final report · Aug 4, 1982 · N6976N · Substantial damage
  > Approximately 4 to 5 minutes after takeoff the eng failed. The acft struck a fence while attempting to return to the airport. The right fuel tank gauge indicated 30 gals & the right tank was found empty. The left fuel tank gauge indicated 10 gals & it…
- [NTSB FTW82DA314](https://openairdocs.org/ntsb/FTW82DA314.md): Piper PA-18-150 · Newellton, LA · Accident · No injuries · Final report · Aug 4, 1982 · N2375J · Substantial damage
  > During flight, the engine lost power and the pilot made a forced landing in a plowed field. While landing on the soft terrain, the aircraft flipped over. The pilot reported that the engine had failed due to fuel starvation when one fuel tank ran dry while the…
- [NTSB ANC82DAG40](https://openairdocs.org/ntsb/ANC82DAG40.md): Aeronca 7GC · Tyonek, AK · Accident · Minor injuries · Final report · Aug 4, 1982 · N8933R · Substantial damage
  > The plt stated he departed anchorage for the kustatan river. He encountered ground fog enroute & landed on a beach. About 1-1/2 hrs later the fog cleared & he took off. He again encountered fog at the mcarther river, but it looked clearon the other side.…
- [NTSB NYC82FNC10](https://openairdocs.org/ntsb/NYC82FNC10.md): Piper PA-24-180 · Woodstock, VT · Accident · No injuries · Final report · Aug 3, 1982 · N7502P · Substantial damage
  > Approximately 5 min after departure the eng lost most of its oil pressure & started to lose power. The acft landed on a rough plowed field & the gear were torn off. The aluminum oil line that connects to the oil cooler broke off at the flare. The "b" nut was…
- [NTSB ANC82DA064](https://openairdocs.org/ntsb/ANC82DA064.md): Cessna 207 · Near Kenai, AK · Accident · Serious injuries · Final report · Aug 3, 1982 · N1751U · Substantial damage
  > Several black bears were spotted in a narrow canyon and the pilot began making tight, descending turns so his sightseeing passengers could get photographs. Reportedly, the stall warning horn came on, but the pilot continued the turns. He finally rolled out of…
- [NTSB NYC82FNC13](https://openairdocs.org/ntsb/NYC82FNC13.md): Piper PA-28-140 · Beans Purchase, NH · Accident · 1 fatal · Final report · Aug 2, 1982 · N5566F · Destroyed
  > The acft impacted an obscured mountain. An observation log & a pilot-certificated witness confirmed that IFR conditions existed at the time of the accident.
- [NTSB NYC82DA180](https://openairdocs.org/ntsb/NYC82DA180.md): Piper PA-12 · Long Branch, NJ · Accident · No injuries · Final report · Aug 2, 1982 · N2705M · Destroyed
  > Even though he had performed several banner pick-ups during the afternoon the pilot did no refueling. After 4 hours of towing banners the engine quit. The pilot stated the gauges read 1/3 full of fuel. The pilot ditched the aircraft which sank and has not…
- [NTSB LAX82FA287](https://openairdocs.org/ntsb/LAX82FA287.md): Cessna 150M · Los Angeles, CA · Accident · Minor injuries · Field investigation · Final report · Aug 2, 1982 · N63572 · Substantial damage
  > The flight was doing traffic reporting when the engine failed. The pilot selected a place for a forced landing. During the landing, the aircraft bounced out of this lot, went over some buildings, then touched down into an athletic field. During a short…
- [NTSB FTW82DA310](https://openairdocs.org/ntsb/FTW82DA310.md): Cessna 182P · Abbeville, LA · Accident · No injuries · Final report · Aug 2, 1982 · N5787J · Substantial damage
  > The pilot was on a cross-country ferry flight when the engine lost power. A forced landing was made in a field of tall rice. The pilot stated that during the landing, the aircraft struck a rice levee and nosed over. The source of engine failure was not…
- [NTSB ATL82DLQ08](https://openairdocs.org/ntsb/ATL82DLQ08.md): Bell 206B · 2nm Sw Of Lynch, KY · Accident · Serious injuries · Final report · Aug 2, 1982 · N33TA · Destroyed
  > The pilot was on a flight to spray powerline right-of-ways with defoliant. During climb, near a 3500 foot ridgeline, the aircraft began to spin to the right. The pilot took corrective action but was not able to stop the spin. The pilot did not have sufficient…
- [NTSB ATL82DA227](https://openairdocs.org/ntsb/ATL82DA227.md): Hiller UH12D · Dothan, AL · Accident · No injuries · Final report · Aug 2, 1982 · N79SW · Substantial damage
  > The pilot calculated his fuel for the flight and determined it adequate for the flight. He drained the fuel sump while the crew was loading fungicide at the loading area. After the spraying was completed, the pilot started his return flight and when over a…
- [NTSB ATL82DA223](https://openairdocs.org/ntsb/ATL82DA223.md): Aero Commander 680FL · Alabaster, AL · Accident · No injuries · Final report · Aug 2, 1982 · N11GT · Destroyed
  > Prior to the post-maintenance inspection flight the pilot/owner, who is a certificated A&P mechancic, had been calibrating the fuel flow on the right eng fuel injector pump. An external line had been connected to the fuel flow transmitter fitting of the fuel…
- [NTSB NYC82FA176](https://openairdocs.org/ntsb/NYC82FA176.md): Cessna 150L · West Brattlebor, VT · Accident · 1 fatal · Field investigation · Final report · Aug 1, 1982 · N17135 · Destroyed
  > At 2036 the plt contacted bradley approach control (a/c) on freq 121.5 & stated he was lost, at an altitude of 4,000 ft & in "almost IFR weather." Since the acft was not transponder equipped a/c had the plt use VOR orientation procedures to determine his…
- [NTSB NYC82DA178](https://openairdocs.org/ntsb/NYC82DA178.md): Piper PA-28-181 · Dubois, PA · Accident · No injuries · Final report · Aug 1, 1982 · N2852E · Substantial damage
  > After power interruption during cruise the pilot returned to the airport for landing. Turning base leg the engine ouit. The pilot cut short the base leg and landed on the grass beside runway 25. No reasons for engine malfunction was found.
- [NTSB FTW82DA304](https://openairdocs.org/ntsb/FTW82DA304.md): Cessna 421B · Cotulla, TX · Accident · No injuries · Final report · Aug 1, 1982 · N832BW · Substantial damage
  > While on a cross-country business flight the left engine started running rough. The pilot shut down the engine and diverted to Cotulla, TX, where he made a single engine approach and landing. The pilot landed with a 20 kt tail wind, was unable to stop the…
- [NTSB SEA82DA135](https://openairdocs.org/ntsb/SEA82DA135.md): Mooney M20F · Sandy, OR · Accident · No injuries · Final report · Jul 31, 1982 · N9707M · Substantial damage
  > After the engine was overhauled, the pilot and a mechanic took off on a test flight. During the takeoff climb the engine lost power and when force landed on soft terrain, the nose and right main landing gear collapsed. An examination revealed that the left…
- [NTSB NYC82DNC12](https://openairdocs.org/ntsb/NYC82DNC12.md): Boeing PT-17 · Hamlin, ME · Accident · No injuries · Final report · Jul 31, 1982 · N1344M · Substantial damage
  > The pilot departed a private strip with 150 gallons of water mixed with fungicide and insecticide. After takeoff, he turned and began climbing over rising terrain. The terrain sloped upward from a river, rising about 400 ft. the pilot reported that he failed…
- [NTSB LAX82DA284](https://openairdocs.org/ntsb/LAX82DA284.md): Piper PA-28R · San Pedro, CA · Accident · No injuries · Final report · Jul 31, 1982 · N3935T · Destroyed
  > Pilot was flying near catalina island and when he switched tanks the engine quit. Procedures to restart did not work so aircraft was ditched.
- [NTSB ANC82DAA10](https://openairdocs.org/ntsb/ANC82DAA10.md): Cessna 180A · Manley Hot Spri, AK · Accident · No injuries · Final report · Jul 31, 1982 · N9749B · Substantial damage
  > The pilot reported that the weather at the departure point was 1500 ft broken, visibility 20 miles wind from the southwest at 5 to 10 KTS. After taking off in a float plane, he elected to follow a slough. After turning a corner about 1 1/2 miles from the…
- [NTSB NYC82DA174](https://openairdocs.org/ntsb/NYC82DA174.md): Cessna 150M · Watertown, NY · Accident · No injuries · Final report · Jul 30, 1982 · N9169U · Substantial damage
  > While en route on a night flight, the engine lost power. During a forced landing, the aircraft struck a power line while on final approach. The power line failed and the pilot continued the landing, but the propeller, spinner, nose cowling, lift strut, and…
- [NTSB DEN82DA139](https://openairdocs.org/ntsb/DEN82DA139.md): Sikorsky S-55B · Wahpeton, ND · Accident · No injuries · Final report · Jul 30, 1982 · N6704 · Substantial damage
  > After receiving his last load of chemical, the pilot thought he had enough fuel to complete two spray passes to finish the field before proceeding to the fuel truck. He completed the passes, then pulled to about 150 ft AGL to fly about three miles to refuel.…
- [NTSB CHI82DA315](https://openairdocs.org/ntsb/CHI82DA315.md): Piper PA-38 · New Haven, IL · Accident · No injuries · Final report · Jul 30, 1982 · N25814 · Substantial damage
  > The pilot reported that before departing on a routine pipe line patrol, he obtained a weather briefing. After about 30 minutes of flight, the visibility began to decrease due to ground fog. The pilot elected to land on a gravel road. During the landing roll,…
- [NTSB LAX82FA282](https://openairdocs.org/ntsb/LAX82FA282.md): Cessna 177 · 11mi.Sw Of Silv, NV · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1982 · N13310 · Destroyed
  > At 0237 the plt contacted ARTCC & verified that he was VFR at 9,500 ft MSL enroute to reno. At 0238 he located his position as 10 mi south of lidat intersection & was advised that oakland enroute radar was out of service. Lidat is on V105 between the beatty &…
- [NTSB DEN82FA148](https://openairdocs.org/ntsb/DEN82FA148.md): Enstrom F-280 · Medora, ND · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1982 · N4202S · Substantial damage
  > During flt the plt noticed that eng RPM was about 500 over rotor RPM. The acft crashed during an unsuccessful autorotation. The overrunning clutch linkage & clutch was found in the disengaed position. A successful autorotation requires that the collective…
- [NTSB CHI82DA280](https://openairdocs.org/ntsb/CHI82DA280.md): SIAI Marchetti S.205-22/R · Carrollton, IL · Accident · Minor injuries · Final report · Jul 29, 1982 · N956W · Substantial damage
  > The aircraft engine failed inflight and during the forced landing on a road the aircraft collided with posts. An investigation showed that a #4 connecting rodcap attaching bolt had failed.
- [NTSB ATL82DA221](https://openairdocs.org/ntsb/ATL82DA221.md): Grumman G-164 · Donalsonville, GA · Accident · No injuries · Final report · Jul 29, 1982 · N10286 · Substantial damage
  > While en route back to the airport, the engine lost power and the pilot landed in a rain soaked, soybean field. During the landing roll, the wheels bogged down in soft earth and the plane nosed over. According to the pilot, there was 10 to 12 gallons of fuel…
- [NTSB ANC82DAG54](https://openairdocs.org/ntsb/ANC82DAG54.md): Cessna 185F · Mcgrath, AK · Accident · No injuries · Final report · Jul 29, 1982 · N1453Q · Substantial damage
  > The pilot departed Mcgrath, AK at 2200 adt on a flight to bear creek, AK. He reported that the weather became rainy and hazy, and he could not land at bear creek due to the deteriorating weather. He started to divert back to Mcgrath, but low clouds prevented…
- [NTSB MIA82DA161](https://openairdocs.org/ntsb/MIA82DA161.md): Cessna R182 · Plymouth, FL · Accident · No injuries · Final report · Jul 28, 1982 · N2334C · Substantial damage
  > The pilot had a flight of over 4 hours total with one enroute stop. At this stop the pilot did not refuel. After 2 hoursand 9 minutes of return flight the eng lost power & the plt made a wheels up landing on a highway.
- [NTSB DEN82FTM16](https://openairdocs.org/ntsb/DEN82FTM16.md): Varieze · Milcreek Canyon, UT · Accident · 2 fatal · Final report · Jul 28, 1982 · N104P · Destroyed
  > The aircraft crashed into trees in a Canyon at an elevation of 9300 MSL. The weather was reported as marginal VFR. No flight plan was filed. VFR flight was not recommended. A toxicological check of the pilot's blood showed an alcohol level of 91 mg%; however,…
- [NTSB ATL82DA217](https://openairdocs.org/ntsb/ATL82DA217.md): Cessna 172 · Laurinburg, NC · Accident · Minor injuries · Final report · Jul 28, 1982 · N733JU · Substantial damage
  > The weather briefing forecast thunderstorms however the pilot took off on a cross country and circumnavigated two cells. The air became turbulent so the pilot decided to land in a plowed field. A downdraft caught the plane and it landed nosedown and nosed…
- [NTSB MKC83LA055](https://openairdocs.org/ntsb/MKC83LA055.md): Cessna 182 · Pawnee City, NE · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1982 · N31094 · Substantial damage
  > The owner of the aircraft was flying with the CFI for a biennial flight review. Shortly after takeoff, at approximately 700 feet, the engine quit. The owner selected what he thought was the best field and began the forced landing. The CFI took over the…
- [NTSB FTW82DA294](https://openairdocs.org/ntsb/FTW82DA294.md): Varga 2150A · Oklahoma City, OK · Accident · Minor injuries · Final report · Jul 26, 1982 · N8265J · Substantial damage
  > The student reported that before he began his flight, he visually checked both tanks and estimated that he had two hours of fuel remaining. He flew 1.1 hrs and was on his way home when the engine lost power. While landing in a plowed field, the plane flipped…
- [NTSB CHI82DA275](https://openairdocs.org/ntsb/CHI82DA275.md): Ercoupe 415C · Port Sheldon Tw, MI · Accident · Minor injuries · Final report · Jul 26, 1982 · N3247H · Destroyed
  > During a VFR flight along lake Michigan shoreline the pilot encountered a decrease in ceiling height. The pilot chose to make a 180 degrees maneuver and return to the airport but during the turn encountered a fog bank. The pilot decended to avoid the fog bank…
- [NTSB SEA82DA130](https://openairdocs.org/ntsb/SEA82DA130.md): Cessna 175 · Sunnyside, WA · Accident · Minor injuries · Final report · Jul 25, 1982 · N7694M · Substantial damage
  > When the pilot arrived on a flight from Sunnyside to the clark county airport, all fuel facilities were closed. He estimated that he had enough fuel to return and took off without refueling. About 12 miles from the Sunnyside airport, fuel exhaustion occurred.…
- [NTSB DEN82DA146](https://openairdocs.org/ntsb/DEN82DA146.md): Piper PA-23C-250 · Gunnison, CO · Accident · Minor injuries · Final report · Jul 25, 1982 · N6383Y · Substantial damage
  > During takeoff, the pilot was distracted by inbound traffic and delayed retracting his gear. At the same time, the engines were not synchronized and he was having difficulty getting them to sound good. He then noticed that a fire had started in the vicinity…
- [NTSB SEA82FA129](https://openairdocs.org/ntsb/SEA82FA129.md): Cessna A185F · 11nm East Of Si, AK · Accident · 4 fatal · Field investigation · Final report · Jul 24, 1982 · N9682Q · Destroyed
  > After departing sitka the acft proceeded generally east via blue lake, blue lake pass & the "cut", a ridge oriented ne/sw with an elevation of approximately 3000 ft MSL. The impact site was about 1 NM se of the cut on the north face of the valley. Both stall…
- [NTSB MKC82DA131](https://openairdocs.org/ntsb/MKC82DA131.md): Cessna 152II · Near Wright Cit, MO · Accident · No injuries · Final report · Jul 24, 1982 · N49789 · Substantial damage
  > The student pilot was on a solo cross country and landed at an intermediate stop and refueled with 6 gallons of fuel. During the return flight the aircraft's engine quit. During the forced landing the aircraft collided with trees. Post accident examination of…
- [NTSB LAX82FA275](https://openairdocs.org/ntsb/LAX82FA275.md): Piper PA-601P · South Of Wicken, AZ · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1982 · N3642T · Destroyed
  > At about 1005 MST the plt received a wx briefing for a flt to Florida with an overnight stay in Texas. Thunderstorm activity was forecast along the proposed route of flt. The briefer advised the plt to get an updated briefing before departure because of the…
- [NTSB FTW82DA305](https://openairdocs.org/ntsb/FTW82DA305.md): Alon A2 · Poyen, AR · Accident · No injuries · Final report · Jul 24, 1982 · N5637F · Substantial damage
  > As the pilot approached his destination, malverne, AR, he descended into hazy conditions under a cloud layer. As he continued, he mistook Poyen, AR for malverne. He was unable to find the airport and elected to make a precautionary landing before dark. He…
- [NTSB SEA82AA126](https://openairdocs.org/ntsb/SEA82AA126.md): Cessna 172 · Mercer Island, WA · Accident · 6 fatal · Final report · Jul 23, 1982 · N2428E · 2 aircraft · Destroyed
  > N2428E, a C-172, had departed sea-tac arpt for a VFR flt to snohomish, WA, about 27 mi on the 355 deg radial from the sea-tac VORTAC. It proceeded nnw over the west shore of Mercer Island located approximately 10 mi north of the sea-tac arpt. N761EL, a…
- [NTSB DEN82FTE20](https://openairdocs.org/ntsb/DEN82FTE20.md): Steen Skybolt · Glenwood Spring, CO · Accident · No injuries · Final report · Jul 23, 1982 · N58D · Destroyed
  > The aircraft crashed into trees in mountainous terrain about 10 miles southwest of the Glenwood springs county airport. This occurred while the pilot was flying low over the mountainous area and was unable to outclimb the rising terrain. The density altitude…
- [NTSB ATL82DA209](https://openairdocs.org/ntsb/ATL82DA209.md): Cessna T188C · Moultrie, GA · Accident · No injuries · Final report · Jul 23, 1982 · N2998J · Substantial damage
  > A catastrophic engine failure occurred at an altitude of about 500 ft AGL while the pilot was returning to the airport. The pilot elected to land on a highway. He reported that during the landing, he ran the plane off the road to avoid an oncoming car. An…
- [NTSB LAX82FA273](https://openairdocs.org/ntsb/LAX82FA273.md): Piper PA-32-301 · Tonopah, NV · Accident · 2 fatal · Field investigation · Final report · Jul 22, 1982 · N8408X · Destroyed
  > The acft impacted the east slope of a ridge at 6500 ft MSL.
- [NTSB CHI82FA266](https://openairdocs.org/ntsb/CHI82FA266.md): Piper PA-28-180 · Hartsburg, IL · Accident · 2 fatal · Field investigation · Final report · Jul 22, 1982 · N7304W · Destroyed
  > At 1223 CDT the plt contacted peoria approach control & requested radar vectors to the Mt. Hawley arpt located just northof the peoria arpt. At 1227 CDT he stated the weather was getting bad & he would like to fly to the logan county arpt. One witness stated…
- [NTSB SEA82FA122](https://openairdocs.org/ntsb/SEA82FA122.md): Piper PA-34-200T · 10 Nm E. Of Ken, ID · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1982 · N33329 · Destroyed
  > The plt declared an emergency & reported out of fuel. While approaching a field the plt observed a power/telephone line in his flt path & instinctively pulled the nose up. On-scene examination revealed no evidence of fuel.
- [NTSB NYC82FGM14](https://openairdocs.org/ntsb/NYC82FGM14.md): Piper PA-28-140 · Shanksville, PA · Accident · Serious injuries · Final report · Jul 21, 1982 · N1885T · Substantial damage
  > During preflight the plt estimated he had about 18 gals of fuel on board. Approximately 10 min after takeoff the eng quit due to fuel exhaustion. The acft collided with a power line pole during the forced landing. The arpt's FBO stated that fuel was not…

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

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

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