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

## Cases, newest first

- [NTSB FTW88FA066](https://openairdocs.org/ntsb/FTW88FA066.md): Aero Commander 680 · El Paso, TX · Accident · 3 fatal · Field investigation · Final report · Feb 19, 1988 · N634SA · Destroyed
  > The non-instrument rated, non multiengine rated pilot, whose medical had expired, lost control of the aircraft during an IFR flight in instrument meteorological conditions. The aircraft crashed and burned. The pilot was attempting to return and land after he…
- [NTSB NYC88LA090](https://openairdocs.org/ntsb/NYC88LA090.md): Stinson 108 · Oswego, NY · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1988 · N6939M · Substantial damage
  > During a local pleasure flight, a decrease in engine power was experienced and a puff of smoke observed in the cockpit. The pilot applied full power in an attempt to return to the airport, but realized it was not possible. The pilot put the aircraft down in…
- [NTSB MIA88LA108](https://openairdocs.org/ntsb/MIA88LA108.md): Cessna 152 · La Belle, FL · Accident · No injuries · Limited investigation · Final report · Feb 17, 1988 · N93137 · Substantial damage
  > While on a personal flt, the passenger requested the instructor plt to demonstrate a forced landing. The plt descended, set up for a normal landing, & when the acft was at an alt of aprx 50- 100 ft, discontinued the descent & added power for climbout. At that…
- [NTSB FTW88DRG05](https://openairdocs.org/ntsb/FTW88DRG05.md): Air Tractor 301 · Circleville, TX · Accident · No injuries · Final report · Feb 17, 1988 · N3164Y · Substantial damage
  > The airplane was being ferried to a new location, and an en route refueling stop was planned. A low ceiling and low visibility set in and the pilot tried to extend the flight to a different town. The fuel was exhausted 6 miles short of a town. The airplane…
- [NTSB NYC88LA083](https://openairdocs.org/ntsb/NYC88LA083.md): Hughes 369D · Waterfall, PA · Accident · Serious injuries · Limited investigation · Final report · Feb 16, 1988 · N5093Y · Destroyed
  > Shortly after takeoff, the pilot heard a loud 'boom' and experienced a loss of tail rotor control accompanied by an increase in N2 and RPM. A radio transmission was made to the aircraft that was trailing and then an approach for landing set up. On landing,…
- [NTSB CHI88LA064](https://openairdocs.org/ntsb/CHI88LA064.md): Bell 206B · Martinsville, IN · Accident · Serious injuries · Limited investigation · Final report · Feb 16, 1988 · N21197 · Substantial damage
  > While engaged in intentional low level flight for the purpose of doing advertising photography, the helicopter experienced a wire strike. The wire wound around the main rotor and pulled the helicopter to the ground. The helicopter received substantial damage.…
- [NTSB SEA88LA047](https://openairdocs.org/ntsb/SEA88LA047.md): Cessna 175 · Stevens Pass, WA · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 1988 · N6642E · Substantial damage
  > Planned flt was VFR transit of cascade mountains in daylight. Plt filed VFR flt plan; wx brief indicated VFR. Unforeseen delays resulted in arrival at planned mountain Pass over one hour late and wx no longer VMC. Plt could see alternate Pass to north…
- [NTSB FTW88LA062](https://openairdocs.org/ntsb/FTW88LA062.md): Cessna 170B · Crowley, TX · Accident · No injuries · Limited investigation · Final report · Feb 14, 1988 · N3180B · Substantial damage
  > The engine stopped as a result of fuel starvation, due to a large amount of contamination throughout the fuel system. The source of the contamination and the length of time it had been in the system was not determined. The pilot was not in gliding distance of…
- [NTSB DEN88GA068](https://openairdocs.org/ntsb/DEN88GA068.md): Cessna T-337H · Galisteo, NM · Accident · 1 fatal · Final report · Feb 13, 1988 · N602SP · Destroyed
- [NTSB FTW88LA061](https://openairdocs.org/ntsb/FTW88LA061.md): Cessna 152 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Feb 12, 1988 · N669ST · Substantial damage
  > The pilots experienced a sudden total and complete loss of engine power during climbout after takeoff. Suitable terrain for a safe landing was not available and the aircraft was damaged during landing on a golf course. Examinations of the aircraft and engine…
- [NTSB FTW88FA064](https://openairdocs.org/ntsb/FTW88FA064.md): Piper PA-32-260 · Laplace, LA · Accident · No injuries · Field investigation · Final report · Feb 12, 1988 · N4882S · Substantial damage
  > Plt was in level crz flt at night when he observed sparks and flame coming from the eng cowling. Shortly thereafter, the eng began running rough and then seized. After declaring an emergency and being cleared straight in to a runway about 28 miles away, the…
- [NTSB NYC88LA079](https://openairdocs.org/ntsb/NYC88LA079.md): Cessna 172P · East Hampton, NY · Accident · 1 fatal · Limited investigation · Final report · Feb 11, 1988 · N52535 · Destroyed
  > The flight departed East Hampton airport for a pleasure flt. Shortly thereafter, the pilot called on frequency 122.7 stating that he had struck some birds and could not maintain control of the aircraft. There as no further transmission as to his location, and…
- [NTSB FTW88FA057](https://openairdocs.org/ntsb/FTW88FA057.md): Cessna 120 · Ada, OK · Accident · Serious injuries · Field investigation · Final report · Feb 10, 1988 · N2431N · Destroyed
  > The pilot was flying low up the river and hit the upper strand of a two strand high voltage power line. Both the pilot and passenger received serious injuries when the airplane crashed on a sand-bar in the river.
- [NTSB DEN88FA071](https://openairdocs.org/ntsb/DEN88FA071.md): Cessna 172M · Red Lodge, MT · Accident · 3 fatal · Field investigation · Final report · Feb 7, 1988 · N20484 · Destroyed
  > The plt and two pax were returning to twin falls, id from billings, MT. The plt rec two wx briefings prior to dep. The wx forecast indicated low clouds, snow, turb and icing cond along the intended route of flight. The route of flight required the plt to…
- [NTSB CHI88DET02](https://openairdocs.org/ntsb/CHI88DET02.md): Beech A35 · Wheeler, IN · Accident · No injuries · Final report · Feb 7, 1988 · N8568A · Substantial damage
  > The acft was being operated iaw a ferry permit to obtain an annual inspn. The prev annual inspn was on 3/13/85. Drg flt abt 1.3 hrs after takeoff, the eng lost pwr. The plt noted the fuel pres was zero. He said he turned on the aux fuel pump & insured the…
- [NTSB ATL88LA087](https://openairdocs.org/ntsb/ATL88LA087.md): Mooney M20E · Liberty, NC · Accident · Minor injuries · Limited investigation · Final report · Feb 7, 1988 · N2633W · Substantial damage
  > The plt rptd that he overestimated the amount of fuel on board the acft prior to departure. The engine subsequently lost pwr at cruise due to fuel exhaustion. A forced ldg was made in a field. During the rollout, the airplane vaulted the crest of a small hill…
- [NTSB DEN88FA064](https://openairdocs.org/ntsb/DEN88FA064.md): Piper PA-28-181 · Roswell, NM · Accident · 3 fatal · Field investigation · Final report · Feb 5, 1988 · N8417F · Destroyed
- [NTSB LAX88FA101](https://openairdocs.org/ntsb/LAX88FA101.md): Cessna U206F · Lk Havasu City, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 2, 1988 · N60566 · Destroyed
  > Pilot's decision to continue flight in forecast marginal VFR conditions in mountainous terrain. Contributing to this accident was the failure of the pilot to obtain an aviation weather briefing and his lack of recurrent training.
- [NTSB DEN88LA060](https://openairdocs.org/ntsb/DEN88LA060.md): Cessna 150L · Reynolds, ND · Accident · No injuries · Limited investigation · Final report · Feb 1, 1988 · N11312 · Substantial damage
- [NTSB ATL88LA086](https://openairdocs.org/ntsb/ATL88LA086.md): Cessna 150K · Barnwell, SC · Accident · Serious injuries · Limited investigation · Final report · Jan 31, 1988 · N6254G · Substantial damage
  > The CFI and her student became lost on the last leg of a dual x-c flt after encountering rainshowers and low ceilings. After unsuccessfully attempting to locate their destination arpt, the CFI located another arpt and elected to land there. The engine…
- [NTSB FTW88LA056](https://openairdocs.org/ntsb/FTW88LA056.md): Cessna 152 · Tomball, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 1988 · N6614H · Destroyed
  > The airplane was descending toward the airport when the engine lost power. Application of carburetor heat restored power until next descent. Second descent was started with full carburetor heat applied and power was lost again and could not be restored. Pilot…
- [NTSB ANC88LA027](https://openairdocs.org/ntsb/ANC88LA027.md): Piper PA-32-300 · Cold Bay, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 30, 1988 · N123TA · Substantial damage
  > The ATP certificated pilot in command departed on a solo, cargo-only air-taxi flight at 1104 a.k.s.t. for a destination 83SM to the n.e. the pilot was normally assigned to copilot duties on a multi-engined airplane, and was not familiar with the terrain he…
- [NTSB SEA88LA042](https://openairdocs.org/ntsb/SEA88LA042.md): Piper PA-32-300 · Twin Falls, ID · Accident · No injuries · Limited investigation · Final report · Jan 29, 1988 · N4290R · Substantial damage
  > When the pilot attempted to reduce power to descend to land he was unable to obtain a power reduction due to the throttle rod end separating in flight. The pilot made a spiralling descent and then shut down the engine. The pilot misjudged his altitude and…
- [NTSB NYC88LA074](https://openairdocs.org/ntsb/NYC88LA074.md): Mcdonnell Douglas DC-9-82 · Decatur, MI · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 1988 · N262AA · No damage
  > The flight attendant was pulling a beverage cart up the aisle when the pad the coffee pot was resting on caught against a curtain. The pad was pulled off the cart and the full pot of coffee spilled in a passengers lap. The passenger service cart has a…
- [NTSB ATL88FA085](https://openairdocs.org/ntsb/ATL88FA085.md): Bell 204B · Stockton, AL · Accident · Serious injuries · Field investigation · Final report · Jan 28, 1988 · N8514F · Destroyed
- [NTSB MIA88LA093](https://openairdocs.org/ntsb/MIA88LA093.md): Cessna 305A · Chuluota, FL · Accident · No injuries · Limited investigation · Final report · Jan 27, 1988 · N5290G · Substantial damage
  > Plt stated electric boost pump was operated longer than normal during power off glide for banner pickup. After banner pickup when full throttle was applied for climb the engine sputtered and lost power. The nose was lowered in preparation for a landing…
- [NTSB CHI88LA054](https://openairdocs.org/ntsb/CHI88LA054.md): Mooney M20A · La Porte, IN · Accident · Minor injuries · Limited investigation · Final report · Jan 27, 1988 · N6072X · Substantial damage
  > The aircraft experienced a complete power failure and while the pilot was attempting to make an emergency landing ran through a fence and between two trees substantially damaging the aircraft. The pilot sustained minor injuries. Post acc invest revealed a…
- [NTSB NYC88IA078](https://openairdocs.org/ntsb/NYC88IA078.md): Beech 1900C · Philadelphia, PA · Incident · No injuries · Incident investigation · Final report · Jan 26, 1988 · N818BE · No damage
  > The Beech 1900C took off on a scheduled commuter flt. When attempting to level the aircraft at 5000 ft, the co-pilot was unable to push the control wheel forward FAR enough to level off. By reducing power, the crew was able to compensate. The crew…
- [NTSB LAX88LA098](https://openairdocs.org/ntsb/LAX88LA098.md): Cessna 150L · Diamond Springs, CA · Accident · No injuries · Limited investigation · Final report · Jan 26, 1988 · N1706Q · Substantial damage
  > During a dual instructional flt, approaching the airport the engine experienced a total loss of power. The plt made a forced landing in a field where during the landing roll the acft nosed over. There were no mechanical failures or malfunctions reported. The…
- [NTSB LAX88LA097](https://openairdocs.org/ntsb/LAX88LA097.md): Cessna 150 · Redbluff, CA · Accident · No injuries · Limited investigation · Final report · Jan 26, 1988 · N7929E · Substantial damage
  > During a cross country flt, the engine experienced a complete pwr loss. The plt made a forced landing where the acft collided with the terrain 1 mile short of the rwy. Inspection of the acft revealed that the fuel tanks were near empty. There were no reported…
- [NTSB CHI88LA053](https://openairdocs.org/ntsb/CHI88LA053.md): Cessna T310R · Urbana, IL · Accident · No injuries · Limited investigation · Final report · Jan 26, 1988 · N5120J · Substantial damage
  > After the aircraft experienced a complete electrical failure the gear was extended manually and a precautionary landing was made. On roll out the landing gear collapsed. Subsequent investigation revealed that 10 turns remained on the manual gear extension…
- [NTSB ATL88LA084](https://openairdocs.org/ntsb/ATL88LA084.md): Boeing 767-332 · Block Island, RI · Accident · Serious injuries · Limited investigation · Final report · Jan 26, 1988 · N117DL · No damage
  > The capt rptdly advised the flight attendants to secure the cabin and be seated due to turbulence expected during descent. About 5 minutes later, the airplane briefly encountered severe turbulence while passing through about FL230. A flight attendant…
- [NTSB FTW88LA054](https://openairdocs.org/ntsb/FTW88LA054.md): Bellanca 17-30A · Borger, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1988 · N8250R · Substantial damage
  > Shortly after takeoff there was smoke in the cabin. The plt started a turn back toward the runway. When he turned off the electrical master switch the engine stopped producing power. Attempts to restart the engine were not successful. He impacted a heavy…
- [NTSB LAX88LA095](https://openairdocs.org/ntsb/LAX88LA095.md): Hughes 369D · Rialto, CA · Accident · No injuries · Limited investigation · Final report · Jan 24, 1988 · N8366F · Substantial damage
- [NTSB NYC88LA068](https://openairdocs.org/ntsb/NYC88LA068.md): Piper PA-28 · Mendon, MA · Accident · Serious injuries · Limited investigation · Final report · Jan 23, 1988 · N663FL · Destroyed
  > Off airport landing due to engine power loss for undetermined reasons.
- [NTSB LAX88LA093](https://openairdocs.org/ntsb/LAX88LA093.md): Cessna TU206G · Kirkland, AZ · Accident · 2 fatal · Limited investigation · Final report · Jan 23, 1988 · N4884U · Destroyed
  > During a cross country flt, the acft struck power lines that were stretched across a canyon. The unmarked wires were aprx 500 ft AGL. There were no reported mechanical failures or malfunctions. No explanation was given for the low flying.
- [NTSB LAX88FA094](https://openairdocs.org/ntsb/LAX88FA094.md): Cessna 172 · Temple City, CA · Accident · 2 fatal · Field investigation · Final report · Jan 23, 1988 · N5113A · 2 aircraft · Destroyed
  > Pilot of N63CA improper visual look-out. Contributing to this accident was the controller's failure to observe the faster moving airplane approaching the single engine Cessna from the rear.
- [NTSB SEA88FA039](https://openairdocs.org/ntsb/SEA88FA039.md): Beech B23 · Hamer, ID · Accident · 3 fatal · Field investigation · Final report · Jan 22, 1988 · CFWET · Destroyed
  > The two non instrument rated pilots (owner/pilot in command and second pilot) as well as a passenger departed medicine hat, alberta, Canada, on a pleasure flight to las vegas, Nevada. Upon arrival at great falls, Montana, both pilots were briefed on the…
- [NTSB FTW88IA052](https://openairdocs.org/ntsb/FTW88IA052.md): Dassault-Breguet DA-10 · Dallas, TX · Incident · No injuries · Incident investigation · Final report · Jan 21, 1988 · N79PB · Minor damage
  > The flight experienced in-flight fire resulting from an electrical short in an auxiliary circuit breaker panel installed after aircraft manufacture. The short resulted from the use of a mounting bracket that chafed against the input wires. The flightcrew…
- [NTSB NYC88IA067](https://openairdocs.org/ntsb/NYC88IA067.md): Mitsubishi MU-2B-35 · Teterboro, NJ · Incident · No injuries · Incident investigation · Final report · Jan 20, 1988 · N349MA · No damage
  > The MU-2 made a departure and while climbing through approximately 800 ft AGL, there was an inadvertent auto-pilot engagement. The nose pitched down and right. Both pilots got on the controls and control was maintained. A normal landing was made at the point…
- [NTSB MKC88FA042](https://openairdocs.org/ntsb/MKC88FA042.md): Gulfstream 500B · Pierceville, KS · Accident · 1 fatal · Field investigation · Final report · Jan 20, 1988 · N611CA · Destroyed
  > The acft dptd garden city under extremely poor wx cond's. more than half way to dodge city, the PIC rptd eng pblms to Kansas city (ARTCC). Vectors were provided to the dodge city arpt, but the PIC did not maintain assigned hdgs. The acft headed back towards…
- [NTSB CHI88FA048](https://openairdocs.org/ntsb/CHI88FA048.md): Boeing 767-200 · Chicago, IL · Accident · Serious injuries · Field investigation · Final report · Jan 20, 1988 · N306AA · No damage
  > A flight attendant and a passenger received serious and minor injuries respectively during an inflight encounter with severe turbulence during an enroute descent. Greater than moderate turbulence was forecast to be in the area and severe turbulence had been…
- [NTSB SEA88LA038](https://openairdocs.org/ntsb/SEA88LA038.md): Cessna 150M · Port Angeles, WA · Accident · No injuries · Limited investigation · Final report · Jan 19, 1988 · N9894J · Substantial damage
  > During cruise the pilot noticed a gradual loss of RPM. Carburetor heat was applied but the pilot stated that he noted no improvement in the engine power. The power loss continued to deteriorate so a landing was made onto a rough field where the nose gear…
- [NTSB MKC88DPG01](https://openairdocs.org/ntsb/MKC88DPG01.md): Meyer VARI-EZE · Little Rock Afb, AR · Accident · 1 fatal · Final report · Jan 19, 1988 · N748BC · Destroyed
  > Pilot received a wx briefing and was told VFR was not recommended. The pilot did not file a flight plan and flew an aircraft not equipped for IFR into weather with 100-feet obscured ceiling and.3 mile visibility. The aircraft crashed into the ground at a…
- [NTSB MIA88LA090](https://openairdocs.org/ntsb/MIA88LA090.md): Douglas DC-9-82 · Hickman, KY · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1988 · N915TW · No damage
  > The capt left the seat belt sign on after takeoff. The flight attendants made a followup announcement for the passengers to remain seated and keep their seatbelts fastened due to the turbulence they were encountering. A passenger elected to get up from her…
- [NTSB CHI88IA045](https://openairdocs.org/ntsb/CHI88IA045.md): Aerospatiale ATR-42 · Waterloo, IA · Incident · No injuries · Incident investigation · Final report · Jan 19, 1988 · N421MQ · Minor damage
- [NTSB LAX88LA091](https://openairdocs.org/ntsb/LAX88LA091.md): Aerospatiale SA-341G · Bowie, AZ · Accident · No injuries · Limited investigation · Final report · Jan 18, 1988 · N61DR · Substantial damage
- [NTSB ATL88FA081](https://openairdocs.org/ntsb/ATL88FA081.md): Piper PA-28R-200 · Barnardsville, NC · Accident · 1 fatal · Field investigation · Final report · Jan 18, 1988 · N55WP · Destroyed
- [NTSB LAX88LA089](https://openairdocs.org/ntsb/LAX88LA089.md): Robinson R22 · Sun City, AZ · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 1988 · N90165 · Substantial damage
- [NTSB LAX88FA088](https://openairdocs.org/ntsb/LAX88FA088.md): Cessna 182L · Newhall, CA · Accident · 4 fatal · Field investigation · Final report · Jan 17, 1988 · N42450 · Destroyed
  > Pilots decision to continue VFR flight after encountering instrument meteorological conditions.

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

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

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