# 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 301 of 718 · 35,885 cases

## Cases, newest first

- [NTSB MIA88LA151](https://openairdocs.org/ntsb/MIA88LA151.md): Cessna 152 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Apr 16, 1988 · N714SW · Substantial damage
  > The plt stated that he was enroute to sanford, FL when the engine lost power. He then landed on I-4, striking a van with the left wing and propeller. The operator stated that prior to removing the wings in order to transport the acft back to sanford, all the…
- [NTSB LAX88FA162](https://openairdocs.org/ntsb/LAX88FA162.md): Cessna 210L · Maricopa, CA · Accident · 2 fatal · Field investigation · Final report · Apr 16, 1988 · N29111 · Destroyed
  > Aircraft inadvertent flight into instrument meteorological conditions.
- [NTSB DEN88FA098](https://openairdocs.org/ntsb/DEN88FA098.md): Piper PA-28R-200 · Pintura, UT · Accident · 3 fatal · Field investigation · Final report · Apr 16, 1988 · N2738R · Substantial damage
  > The plt and two pax departed overton, NV destined for sundance, WY. Witnesses stated that the acft took off under an overcast and followed interstate 15 northbound. A witness driving on the interstate said that he saw N2738R at aprx 600 ft AGL over the…
- [NTSB DCA88MA052](https://openairdocs.org/ntsb/DCA88MA052.md): de Havilland DHC-8 · Seattle, WA · Accident · Serious injuries · Major investigation · Final report · Apr 16, 1988 · N819PH · Destroyed
  > Shortly after tkof from Seattle-tacoma intl airport, the crew noted a rt eng power loss and decided to return for a precautionary lndg. After lowering the lndg gear, a massive fire was discovered in the rt eng nacelle. After lndg, directional control and all…
- [NTSB MIA88LA149](https://openairdocs.org/ntsb/MIA88LA149.md): Piper PA-32-300 · Monticello, FL · Accident · No injuries · Limited investigation · Final report · Apr 15, 1988 · N5231S · Substantial damage
  > The plt stated that while enroute to st. petersburg, and in the vicinity of montecello FL, he began to experience severe engine vibrations and a loss of power. He then selected a field to land in & on his apch, the acft struck some trees, sheared off the…
- [NTSB DEN88LA095](https://openairdocs.org/ntsb/DEN88LA095.md): Cessna 150M · Garfield, CO · Accident · No injuries · Limited investigation · Final report · Apr 14, 1988 · N714BK · Substantial damage
  > The plt was ferrying his acft from burlington, NC to kelso, WA. After refueling his acft to capacity (26 gal.), he stayed overnight in lamar, CO. He departed lamar the next morning at 0800. He passed pueblo, CO at 7500 ft., and obtained a wx briefing from the…
- [NTSB DEN88FA096](https://openairdocs.org/ntsb/DEN88FA096.md): Piper PA-28-161 · Milford, UT · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1988 · N3850M · Destroyed
  > The plt (with a recent instrument rating) rcvd a wx briefing fm cedar city (cdc) fss & filed an IFR flt plan fm provo (pvu) to st george (sgu). Current sgu wx wasn't available, but wx for cdc (abt 45 mi nne) was provided. The plt was adzdof moist unstable…
- [NTSB BFO88FA036](https://openairdocs.org/ntsb/BFO88FA036.md): Fokker F28 MK 4000 · Charleston, WV · Accident · Minor injuries · Field investigation · Final report · Apr 14, 1988 · N110UR · Substantial damage
  > Engine and airframe failure were caused by the the separation of the first stage low pressure turbine disk. The disc interstage seal was installed inadequately, resulting in rubbing between the seal and disk, causing failure of the disk. Inadequate procedure…
- [NTSB ANC88IA047](https://openairdocs.org/ntsb/ANC88IA047.md): Cessna 207A · Takslesuk Lake, AK · Incident · No injuries · Incident investigation · Final report · Apr 14, 1988 · N73188 · Minor damage
  > The scheduled commuter flight, friendship flight 305, was en route from chevak, Alaska to bethel, Alaska. During cruise flight, the airplane experienced an engine failure resulting a a forced landing on rough, snow covered terrain. The pilot-in-command stated…
- [NTSB LAX88LA159](https://openairdocs.org/ntsb/LAX88LA159.md): Cessna TU206G · Coarsegold, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 1988 · N735SU · Substantial damage
  > While at cruise flight, the engine surged twice then quit. During the emergency landing, the airplane collided with the terrain. Inspection of the engine revealed that the number three connecting rod broke.
- [NTSB SEA88LA073](https://openairdocs.org/ntsb/SEA88LA073.md): Hughes 269C · Sitka, AK · Accident · No injuries · Limited investigation · Final report · Apr 12, 1988 · N92PC · Substantial damage
  > During sling operations, the long line became separated and entangled in the tail rotor at about 300 feet AGL. The pilot landed the helicopter onto a beach area where it rolled over onto its left side striking the main rotor. No accident report has been filed…
- [NTSB CHI88IA097](https://openairdocs.org/ntsb/CHI88IA097.md): Fairchild SA-226-TC · Bloomington, IL · Incident · Minor injuries · Incident investigation · Final report · Apr 11, 1988 · N332BA · No damage
  > Physical incapacitation due to an organic pathogen. Contributing factors are anxiety and self-induced pressure.
- [NTSB ATL88FA138](https://openairdocs.org/ntsb/ATL88FA138.md): Piper PA-28-180 · Bowling Green, KY · Accident · 1 fatal · Field investigation · Final report · Apr 11, 1988 · N32911 · Destroyed
  > Pilot called fss on wrong freq. Another pilot answered & pilot req fss freq. He then called fss, rpted eng quit. Witness heard 'eng starting' momentarily overhead, watched acft pitch over, dive to gnd & impact with no attempt to flare for lnding. Pitch trim…
- [NTSB SEA88LA071](https://openairdocs.org/ntsb/SEA88LA071.md): Cessna 172XP · Walla Walla, WA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1988 · N736KG · Substantial damage
  > During descent for landing the pilot noted a surge coming from the engine area, accompanied by an increase in rpm's. both the oil temperature and the oil pressure gauges were reading zero. The cylinder head temperature had reached 500 degrees and smoke was…
- [NTSB ATL88DKG06](https://openairdocs.org/ntsb/ATL88DKG06.md): Christen Industries Eagle II · Chamblee, GA · Accident · No injuries · Final report · Apr 10, 1988 · N722HS · Destroyed
- [NTSB SEA88FA069](https://openairdocs.org/ntsb/SEA88FA069.md): Aero Commander 680FL · Soda Springs, ID · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1988 · N291NC · Destroyed
  > While en route on a night IFR cargo flt, the plt reqd & was clrd for a dscnt from an IFR cruise alt of 16,000 ft to proceed vfr-on-top. The last transmission from the acft was at 2106 when the plt acknowledged that he was familiar with the terrain along the…
- [NTSB NYC88LA125](https://openairdocs.org/ntsb/NYC88LA125.md): Schleicher ASW-20 · Fairfield, PA · Accident · 1 fatal · Limited investigation · Final report · Apr 9, 1988 · N34JH · 2 aircraft · Destroyed
  > Failure of the pilot-in-command of N34JH to see and avoid N311DP.
- [NTSB FTW88DRA06](https://openairdocs.org/ntsb/FTW88DRA06.md): Neff BD-4 · Beaumont, TX · Accident · 1 fatal · Final report · Apr 9, 1988 · N1HN · Destroyed
  > During the flight, an oil-like odor was detected and oil spots appeared on the windshield. The oil pressure dropped to zero and the engine failed. During the forced landing on a highway, the left wing struck a road sign. The spar/ fuel tank ruptured and the…
- [NTSB ATL88FA137](https://openairdocs.org/ntsb/ATL88FA137.md): Beech C50 · Fayetteville, NC · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1988 · N66L · Destroyed
  > The pilot reported a fuel pump problem to Fayetteville tower and requested landing. The pilot was cleared to land on runway 04. The controller noticed that the pilot had not lowered the landing gear. The pilot was questioned concerning the gear. Instead of…
- [NTSB ATL88DMG05](https://openairdocs.org/ntsb/ATL88DMG05.md): Bellanca 14-19-3A · Boone, NC · Accident · 2 fatal · Final report · Apr 8, 1988 · N8880R · Destroyed
- [NTSB ATL88LA135](https://openairdocs.org/ntsb/ATL88LA135.md): Cessna 177RG · Briceville, TN · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 1988 · N46316 · Destroyed
  > The plt stated that he had departed coffeyville, KS on apr 5 for an airplane delivery ferry flt to lincolnton, NC he landed at cape girardeau and remained overnight due to enroute weather. He deptd cgi the following morning following a wx brief that indicated…
- [NTSB CHI88LA095](https://openairdocs.org/ntsb/CHI88LA095.md): Cessna 172P · Sauk Center, MN · Accident · No injuries · Limited investigation · Final report · Apr 6, 1988 · N62218 · Destroyed
  > While enroute on the last leg of a solo cross country instructional flight, the student pilot experienced a rough running engine, followed by an engine failure. The pilot elected to land on a frozen lake, executed emergency procedures, and made a hard landing…
- [NTSB LAX88LA154](https://openairdocs.org/ntsb/LAX88LA154.md): Cessna 150 · Pine Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 1988 · N18136 · Substantial damage
  > Failure of the number one connecting rod bearing. Contributing to this accident was the student pilot's relative inexperience and his inability to judge the glide ratio of the airplane and completing a forced landing in unsuitable terrain.
- [NTSB CHI88FA091](https://openairdocs.org/ntsb/CHI88FA091.md): Beech B90 · St. Paul, MN · Accident · No injuries · Field investigation · Final report · Apr 5, 1988 · N181LL · Substantial damage
  > Mechanical failure and sticking of the pilots thumb operated trim switch causing nose down pitch command. The failure of the cabin heater and the low cabin temperature are contributing factors.
- [NTSB LAX88LA153](https://openairdocs.org/ntsb/LAX88LA153.md): Hiller UH-12D · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1988 · N646JS · Substantial damage
  > The helicopter encountered weather while enroute to its dest and diverted to an alternate arpt. It overflew the alternate and, after the engine failed from fuel exhaustion, crashed during an autorotative forced landing.
- [NTSB LAX88FA148](https://openairdocs.org/ntsb/LAX88FA148.md): Piper PA-31-325 · Orinda, CA · Accident · 5 fatal · Field investigation · Final report · Apr 4, 1988 · N6ET · Destroyed
  > Before the acdnt, witnesses observed the acft circling in a valley beneath a low cloud layer & below the surrounding hilltops. They estimated the ceiling was 400' obscured. Two witnesses said the acft entered clouds before it crashed. A 3rd witness, who was a…
- [NTSB ATL88FA136](https://openairdocs.org/ntsb/ATL88FA136.md): Piper PA-32R-301T · Middlesboro, KY · Accident · 7 fatal · Field investigation · Final report · Apr 3, 1988 · N8171P · Destroyed
  > The plt received preflt wx briefing that stated VFR flt was not recommended due to low pressure system affecting proposed flt path. Wx forecast included tornadoes, hail, thunderstorms to 42,000', moderate rime icing, moderate turbulence, wind gusts to 70 KTS,…
- [NTSB MKC88LA073](https://openairdocs.org/ntsb/MKC88LA073.md): Cessna 177 · Cedar Rapids, IA · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1988 · N29325 · Substantial damage
  > During a night cross country trip, PIC experienced a total power loss. An emergency ldg was attempted and the accident aircraft collided with the terrain. Post accident inspection revealed no mechanical or fuel starvation problems. The pilot reported that the…
- [NTSB DEN88FA091](https://openairdocs.org/ntsb/DEN88FA091.md): Aerospatiale SA316B · Silver Plume, CO · Accident · No injuries · Field investigation · Final report · Apr 2, 1988 · N72590 · Substantial damage
- [NTSB MKC88FA070](https://openairdocs.org/ntsb/MKC88FA070.md): Bell 206L-1 · Springfield, MO · Accident · Serious injuries · Field investigation · Final report · Apr 1, 1988 · N119AE · Substantial damage
  > While enroute to a vehicle accident the pilot encountered instrument flight conditions. As a result of flying into fog and turning on his night scanner light, the pilot experienced spatial disorientation and failed to maintain aircraft control. The pilot…
- [NTSB LAX88LA147](https://openairdocs.org/ntsb/LAX88LA147.md): Piper PA-38-112 · Apple Valley, CA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1988 · N2498D · Substantial damage
  > Drg a flt from hawthorne to delano, CA, the plt became lost, saw an arpt & landed. After landing, she learned she was at the depue arpt, lenwood, CA. No fuel was available, so she elected to fly to Apple Valley, a distance of about 17 mi. However, before…
- [NTSB LAX88FA146](https://openairdocs.org/ntsb/LAX88FA146.md): Cessna 172N · Saticoy, CA · Accident · 1 fatal · Field investigation · Final report · Apr 1, 1988 · N733KS · 2 aircraft · Substantial damage
  > A certificated private pilot and his instructor, conducting training in a 172P, were turning left to a southeasterly heading at 3,400 feet MSL, near an uncontrolled airport. A Cessna 172N on a pleasure flight in the vicinity was climbing on a southwesterly…
- [NTSB ATL88FA131](https://openairdocs.org/ntsb/ATL88FA131.md): Mooney M20G · Jasper, GA · Accident · 1 fatal · Field investigation · Final report · Apr 1, 1988 · N3638N · Destroyed
  > Before depg blairsville, the plt reqd the current atlanta wx for the dekalb-peachtree arpt & for an afternoon outlook. He told the briefer that he had received a previous wx briefing. He was informed that the forecast was for instrument conds until noon with…
- [NTSB FTW88FA084](https://openairdocs.org/ntsb/FTW88FA084.md): Cessna 172M · Hope, AR · Accident · 1 fatal · Field investigation · Final report · Mar 31, 1988 · N6534H · Destroyed
  > The non-instrument rated pilot initiated the flight into known adverse weather after being advised during a preflight weather briefing that VFR flight was not recommended. About 40 minutes before the crash, he called el dorado (Arkansas) radio and requested…
- [NTSB CHI88FA087](https://openairdocs.org/ntsb/CHI88FA087.md): Beech 35-C33A · Onamia, MN · Accident · 2 fatal · Field investigation · Final report · Mar 31, 1988 · N2766T · Destroyed
  > Pilot's poor judgement in continuing VFR flight into IMC conditions, and his subsequent disorientation and failure to maintain aircraft control.
- [NTSB MIA88LA133](https://openairdocs.org/ntsb/MIA88LA133.md): Piper PA-60-601P · St Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Mar 30, 1988 · N3645E · Substantial damage
  > The acft was climbing thru 1600 ft when the upper half of the main entry door opened & separated from the acft. The physician plt stated that he was reasonably sure that he had secured the door prior to departure. He stated that although the cabin had not yet…
- [NTSB MIA88FA134](https://openairdocs.org/ntsb/MIA88FA134.md): Bellanca 17-30 · Daytona Beach, FL · Accident · Minor injuries · Field investigation · Final report · Mar 30, 1988 · N4927V · Destroyed
  > The plt stated that he had filled the main tanks and nearly filled the two aux tanks earlier and had flown for about 1 hr using one of the aux tanks for cruise. He had just taken off using the mains & when he leveled at 2600 ft, he switched to one of the aux…
- [NTSB SEA88LA068](https://openairdocs.org/ntsb/SEA88LA068.md): Bellanca 7KCAB · Palmer, WA · Accident · Serious injuries · Limited investigation · Final report · Mar 28, 1988 · N86820 · Destroyed
  > While on a VFR cross country flight the pilot encountered instrument meteorological conditions along his route. The aircraft was not instrument equipped, even though the pilot is instrument rated. The pilot had to make two precautionary landings prior to the…
- [NTSB SEA88LA070](https://openairdocs.org/ntsb/SEA88LA070.md): Cessna 305-A · Arlington, WA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N10442 · Substantial damage
  > Shortly after takeoff, at about 200 feet AGL, a total loss of power occurred. A forced landing was made onto a turf field next to the runway. During landing the aircraft nosed over inverted. The pilot stated to FAA inspectors that the aircraft had set outside…
- [NTSB SEA88LA067](https://openairdocs.org/ntsb/SEA88LA067.md): Cessna 170 · Ashland, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 1988 · N2958D · Destroyed
  > During a dark night VFR flight, the acft encountered a severe downdraft and instrument meteorological conditions. With full power the acft descended, striking trees before it struck the ground. During the pilot's preflight briefing and in-flight briefing he…
- [NTSB NYC88LA117](https://openairdocs.org/ntsb/NYC88LA117.md): Mooney M20 · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N2746W · Substantial damage
  > Maintenance personnel improperly installed the number two connecting rod (p/n L-10646) causing it to separate, create a hole in the engine case, loss of engine oil and engine power. Due to the pilot's improper inflight decision, he performed a wheels up…
- [NTSB LAX88FA135](https://openairdocs.org/ntsb/LAX88FA135.md): Piper PA-28-181 · Torrance, CA · Accident · Minor injuries · Field investigation · Final report · Mar 27, 1988 · N26022 · Substantial damage
  > Pilot-in-command to apply carburetor heat when entering carburetor icing conditions.
- [NTSB LAX88LA137](https://openairdocs.org/ntsb/LAX88LA137.md): Avian Magnum IX · Phoenix, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1988 · N1601D · Substantial damage
  > During a local flight in a hot air balloon, while descending, the deflation line malfunctioned. It was found that the release pulley had no roller and the rope was knotted and jammed in the pulley. The vent could not be activated in this condition.
- [NTSB MKC88LA069](https://openairdocs.org/ntsb/MKC88LA069.md): Cessna 152 · Preston, MO · Accident · No injuries · Limited investigation · Final report · Mar 25, 1988 · N4712D · Substantial damage
  > The student pilot was on the second leg of a x-country trng flt when the eng quit. Exam of the acft fuel system revealed that no fuel was present. The pilot departed the original departure arpt without a full load of fuel, and had planned to acquire fuel at…
- [NTSB FTW88MA083](https://openairdocs.org/ntsb/FTW88MA083.md): British Aerospace BAE-3101 · Decatur, TX · Accident · No injuries · Major investigation · Final report · Mar 25, 1988 · N411AE · Substantial damage
  > Airplane's encounter with rought terrain during an attempted forced landing. The forced landing was necessitated after the captain used improper procedures to shutdown the left engine in flight following an unexplained torque fluctuation.
- [NTSB BFO88FA031](https://openairdocs.org/ntsb/BFO88FA031.md): Ryan Navion NA-4 · Fancy Gap, VA · Accident · 2 fatal · Field investigation · Final report · Mar 25, 1988 · N1598V · Destroyed
  > The pilot failed to maintain visual contact and clearance with rising terrain after VFR flight encountered IMC.
- [NTSB DEN88LA086](https://openairdocs.org/ntsb/DEN88LA086.md): Cessna 180 · Logan, UT · Accident · No injuries · Limited investigation · Final report · Mar 24, 1988 · N9393C · Substantial damage
  > The plt reported that he was on a flight from Colorado springs to portland, Oregon. He said he planned to refuel in the Logan/malad city, Idaho area. After crossing a ridgeline in the mountainous terrain east of Logan, the flt encountered low ceilings and…
- [NTSB CHI88IA081](https://openairdocs.org/ntsb/CHI88IA081.md): Boeing 767-200 · Cimarron, NM · Incident · Minor injuries · Incident investigation · Final report · Mar 24, 1988 · N308AA · No damage
  > While in normal cruise flight at FL 370, the flt crew was advised by ARTCC personnel that other aircraft were experiencing occasional severe turbulence at FL 370 along their route of flight. A descent was made to FL 330 to avoid turbulence. Later, as the…
- [NTSB ATL88LA124](https://openairdocs.org/ntsb/ATL88LA124.md): Cessna 150G · Muscle Shoals, AL · Accident · Minor injuries · Limited investigation · Final report · Mar 24, 1988 · N2738S · Substantial damage
  > The airplane experienced a loss of electrical power during the local, solo flt. The student elected to make a precautionary ldg at Muscle Shoals arpt (MSL) which was the nearest arpt. He made two attempts to land on rwy 36, with a 12-20 kt tailwind: on the…
- [NTSB LAX88LA133](https://openairdocs.org/ntsb/LAX88LA133.md): Gulfstream American AA5A · Union City, CA · Accident · 1 fatal · Limited investigation · Final report · Mar 23, 1988 · N26851 · Destroyed
  > During a pleasure flight, the airplane collided with a power line tower. The airplane was consumed by fire. The weather at the time of the accident was reported to be instrument meteorological conditions with low fog. The pilot did not file an instrument…

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

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

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