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

## Cases, newest first

- [NTSB FTW89LA050](https://openairdocs.org/ntsb/FTW89LA050.md): Piper PA-28-180 · Seminole, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 1989 · N5258L · Substantial damage
  > The pilot's delay in updating his weather and diverting to an alternate destination, which resulted in fuel exhaustion from lack of fuel. Contributing factors were: the pilot's inadequate preflight planning/preparation at the en route stop, the weather…
- [NTSB FTW89FA049](https://openairdocs.org/ntsb/FTW89FA049.md): MBB BK-117 A-1 · Tyler, TX · Accident · 3 fatal · Field investigation · Final report · Feb 14, 1989 · N7025L · Destroyed
  > The pilot's failure to execute the published inadvertent IMC procedures when he encountered adverse weather conditions.
- [NTSB LAX89FA106](https://openairdocs.org/ntsb/LAX89FA106.md): Piper PA-24-260 · Julian, CA · Accident · 3 fatal · Field investigation · Final report · Feb 12, 1989 · N9240P · Destroyed
  > The pilot's poor judgement of intentionally flying into an area of known forecast icing conditions which resulted in a loss of control and an inflight breakup of the aircraft. Contributing factors were the pilot's overconfidence in his personal ability by…
- [NTSB MKC89LA057](https://openairdocs.org/ntsb/MKC89LA057.md): Cessna 150 · Wayland, MO · Accident · No injuries · Limited investigation · Final report · Feb 11, 1989 · N61064 · Substantial damage
  > The pilot becoming lost during the flight which resulted in fuel exhaustion.
- [NTSB FTW89LA048](https://openairdocs.org/ntsb/FTW89LA048.md): Pitts S2B · Walker, LA · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1989 · N11SE · Destroyed
  > Loss of total engine power due to fuel exhaustion. Fuel exhaustion occurred due to the pilot's failure to perform fuel consumption calculations. Contributing was the inadequate fuel quanity sight gauge in the rear cockpit, which was occupied by the PIC.
- [NTSB ATL89LA085](https://openairdocs.org/ntsb/ATL89LA085.md): Cessna 177B · Oneonta, AL · Accident · No injuries · Limited investigation · Final report · Feb 11, 1989 · N34306 · Destroyed
  > Inadequate preflight by the pilot and fuel exhaustion. Trees contributed to the aircraft damage.
- [NTSB NYC89LA082](https://openairdocs.org/ntsb/NYC89LA082.md): Cessna R172K · Ballston Spa, NY · Accident · No injuries · Limited investigation · Final report · Feb 10, 1989 · N758PW · Substantial damage
  > Worn connecting rod bearing(s), and failure of the #1 connecting rod. A factor related to the accident was: the lack of suitable terrain for an emergency landing.
- [NTSB FTW89MA047](https://openairdocs.org/ntsb/FTW89MA047.md): Mcdonnell Douglas DC-9-32F · Salt Lake City, UT · Accident · 1 fatal · Major investigation · Final report · Feb 9, 1989 · N935F · No damage
  > Improper in-flight planning/decision by the captain (pilot-in-command) and his improper use of the portable oxygen system, which resulted in his incapacitation due to hypoxia. Factors related to the accident were: inadequate maintenance/inspection of the…
- [NTSB DEN89LA075](https://openairdocs.org/ntsb/DEN89LA075.md): Cessna 152 · Gill, CO · Accident · No injuries · Limited investigation · Final report · Feb 9, 1989 · N69117 · Substantial damage
  > Improper use of the powerplant controls by the CFI during descent through low temperature air.
- [NTSB ATL89FAMS3](https://openairdocs.org/ntsb/ATL89FAMS3.md): Cessna 310Q · Cleveland, OH · Accident · 1 fatal · Missing aircraft · Final report · Feb 9, 1989 · N6269Q · Destroyed
  > An uncontrolled descent into the water for undetermined reasons.
- [NTSB ANC89FA042](https://openairdocs.org/ntsb/ANC89FA042.md): Cessna 207 · Nome, AK · Accident · Serious injuries · Field investigation · Final report · Feb 9, 1989 · N73771 · Substantial damage
  > The partial loss of power resulting from fuel interruption due to a blockage in the engine fuel pump low pressure check valve.
- [NTSB ANC89FA041](https://openairdocs.org/ntsb/ANC89FA041.md): Cessna U206G · Fairbanks, AK · Accident · 1 fatal · Field investigation · Final report · Feb 9, 1989 · N756EA · Destroyed
  > Separation of the torsional vibration dampers from the crankshaft boss.
- [NTSB CHI89FA049](https://openairdocs.org/ntsb/CHI89FA049.md): Cessna 172RG · Mosinee, WI · Accident · 3 fatal · Field investigation · Final report · Feb 8, 1989 · N6525V · Destroyed
  > Spatial disorientation of the pilot as a result of initiating the flight into known adverse weather. Factors related to the accident were: dark night, snow, and low ceilings.
- [NTSB MIA89IA080](https://openairdocs.org/ntsb/MIA89IA080.md): Waco UPF-7 · Marathon, FL · Incident · Minor injuries · Incident investigation · Final report · Feb 6, 1989 · N39721 · Minor damage
  > Fuel starvation due to a corroded carburetor.
- [NTSB LAX89LA104](https://openairdocs.org/ntsb/LAX89LA104.md): Cameron A-140 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 1989 · N2912R · Minor damage
  > The pilot displayed poor preflight planning and preparation by not properly evaluating the weather conditions.
- [NTSB LAX89LA102](https://openairdocs.org/ntsb/LAX89LA102.md): Cessna 172P · Santa Ynez, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 4, 1989 · N98564 · Substantial damage
  > The failure of the pilot to obtain an adequate preflight weather briefing or to obtain inflight weather advisory information, and the failure of the pilot to maintain flying speed while descending in a downdraft.
- [NTSB LAX89DVG04](https://openairdocs.org/ntsb/LAX89DVG04.md): Schweizer G-164C · Bayless, CA · Accident · No injuries · Final report · Feb 3, 1989 · N6569K · Substantial damage
  > The deparation of a turbine blade followed by a forced landing during which the landing gear collapsed due to overload forces.
- [NTSB FTW89LA057](https://openairdocs.org/ntsb/FTW89LA057.md): Cessna U206 · San Angelo, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1989 · N8096Z · Substantial damage
  > Failure of the pilot to maintain adequate altitude during continued flight into known adverse weather. The weather conditions and dark night were contributing factors.
- [NTSB SEA89LA045](https://openairdocs.org/ntsb/SEA89LA045.md): Piper PA-31 · Sparks, NV · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 1989 · N88RG · Destroyed
  > The pilot's misjudgement of the forced landing profile. Contributing to the accident was the failure of the right turbocharger and the pilot's improper handling of the landing gear system.
- [NTSB NYC89LA078](https://openairdocs.org/ntsb/NYC89LA078.md): Beech A-36 · Kennebunk, ME · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 1989 · N67561 · Substantial damage
  > The pilot's failure to assure the fuel selector was properly positioned which resulted in fuel starvation and the subsequent forced landing.
- [NTSB SEA89LA044](https://openairdocs.org/ntsb/SEA89LA044.md): Cessna 182 · N. Bonneville, WA · Accident · No injuries · Limited investigation · Final report · Jan 31, 1989 · N3254Y · Substantial damage
  > Some form of carburetor malfunction or failure which resulted in a loss of engine power. Contributing to the accident was the planned forced landing approach by the plt which resulted in the airplane landing short of the desired landing site.
- [NTSB FTW89LA044](https://openairdocs.org/ntsb/FTW89LA044.md): Cessna 152 · Ore City, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 31, 1989 · N4745B · Substantial damage
  > Slippage of the center crankshaft bearing, which resulted in oil starvation and subsequent failure of the #3 connecting rod. Contributing factors were: the aircraft owner's continued operation of the engine beyond the manufacturer's recommended overhaul…
- [NTSB BFO89LA017](https://openairdocs.org/ntsb/BFO89LA017.md): Cessna 172F · Bruceton Mills, WV · Accident · Serious injuries · Limited investigation · Final report · Jan 31, 1989 · N8264U · Destroyed
  > The power loss occurred because of carburetor ice which obstructed airflow to the induction system. Contributing to the accident was the carburetor icing conditions, the highway and the ditch which was contacted.
- [NTSB SEA89FA041](https://openairdocs.org/ntsb/SEA89FA041.md): Aeronca O-58B · Minden, NV · Accident · 2 fatal · Field investigation · Final report · Jan 29, 1989 · N48688 · Destroyed
  > The failure of the pilot to maintain adequate airspeed and airplane control. Contributing to the accident was the mountainous terrain and mountain wave conditions.
- [NTSB NYC89LA075](https://openairdocs.org/ntsb/NYC89LA075.md): Cessna 152 · Fire Island, NY · Accident · No injuries · Limited investigation · Final report · Jan 28, 1989 · N25420 · Destroyed
  > The improper installation of an unauthorized sealant used on the oil ressure screen housing gasket contaminated the oil and restricted the flow of oil through the main bearings causing oil starvation and connecting rod, bearing, and bolt failure.
- [NTSB MKC89LA058](https://openairdocs.org/ntsb/MKC89LA058.md): Piper PA-28-181 · Goodland, KS · Accident · No injuries · Limited investigation · Final report · Jan 27, 1989 · N47431 · Substantial damage
  > The loss of engine power resulting from an exhaust valve failure. Contributing to the accident was the lack of suitable terrain for a forced landing.
- [NTSB ATL89LA083](https://openairdocs.org/ntsb/ATL89LA083.md): Cessna 172D · Cumming, GA · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 1989 · N2556U · Destroyed
  > The pilot's decision to attempt VFR flight in adverse meteorological conditions at night with an inoperative attitude indicator and insufficient fuel reserve for the intended flight.
- [NTSB NYC89FA073](https://openairdocs.org/ntsb/NYC89FA073.md): Grumman GA-7 · Spartansburg, PA · Accident · 4 fatal · Field investigation · Final report · Jan 26, 1989 · N115DS · Destroyed
  > The pilots decision to disregard the weather forecast and attempt flight into known icing conditions. After the wings started to ice up, the pilot initiated a climb but could not maintain airspeed and inadvertantly stalled the aircraft which entered an…
- [NTSB CHI89DEP01](https://openairdocs.org/ntsb/CHI89DEP01.md): Cessna T337G · Green Bay, WI · Accident · 1 fatal · Final report · Jan 26, 1989 · N6CF · Destroyed
  > The pilot's loss of aircraft control, due to the loss of cockpit/instrument panel lighting for an undetermined reason, the inoperative penlight, and subsequent spatial disorientation of the pilot. Factors related to the accident were: darkness and the adverse…
- [NTSB LAX89DUG02](https://openairdocs.org/ntsb/LAX89DUG02.md): Mason AJM-1 · Cajalco, CA · Accident · 1 fatal · Final report · Jan 22, 1989 · N87AJ · Destroyed
  > The pilot's intentional descent into the terrain. Contributing factors to the accident were the pilot's phychological problems and his lack of experience in this aircraft.
- [NTSB FTW89LA043](https://openairdocs.org/ntsb/FTW89LA043.md): Hiller OH-23B · Wichita Falls, TX · Accident · No injuries · Limited investigation · Final report · Jan 21, 1989 · N88785 · Substantial damage
  > The pilot's improper use of the carburetor heat during flight and his improper flare during an autorotative landing. Contributing factors were: carburetor icing conditions, improper in-flight planning/decision by the pilot, a tailwind during the landing, and…
- [NTSB CHI89DEC02](https://openairdocs.org/ntsb/CHI89DEC02.md): Piper PA-28R-201 · Brighton, MI · Accident · Serious injuries · Final report · Jan 21, 1989 · N3536M · Destroyed
  > Installation of an improper oil drain valve by other maintenance personnel and their failure to follow the applicable airworthiness directive (AD 81-11-02/R1), resulting in subsequent interference between the landing gear and oil drain valve. This caused the…
- [NTSB DEN89FA064](https://openairdocs.org/ntsb/DEN89FA064.md): Convair 580 · Buena Vista, CO · Accident · Minor injuries · Field investigation · Final report · Jan 20, 1989 · N73160 · Substantial damage
  > Inadvertent deactivation of fuel to the left engine as the pilot was making a precautionary shutdown of the right engine, and his failure to follow the emergency checklist procedure. Related factors were: low gearbox oil pressure (at flight altitude), and…
- [NTSB ATL89IA080](https://openairdocs.org/ntsb/ATL89IA080.md): Boeing 757-225 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Jan 20, 1989 · N509EA · Minor damage
  > Failure of operator maintenance personnel to accomplish an applicable service bulletin.
- [NTSB BFO89LA016](https://openairdocs.org/ntsb/BFO89LA016.md): Piper PA-38-112 · Elkview, WV · Accident · Minor injuries · Limited investigation · Final report · Jan 19, 1989 · N2409F · Substantial damage
  > Inadequate preflight by the pilot and inadequate crew/group coordination by the flight leader (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the presence of trees in the emergency landing…
- [NTSB FTW89FA042](https://openairdocs.org/ntsb/FTW89FA042.md): Cessna 150L · Zachary, LA · Accident · 1 fatal · Field investigation · Final report · Jan 18, 1989 · N6757G · Destroyed
  > The pilot's loss of aircraft control due to spatial disorientation after encountering instrument meteorological weather conditions (IMC) shortly after takeoff, his intentional takeoff into adverse weather conditions, and the operator's inadequate supervision…
- [NTSB ATL89FA078](https://openairdocs.org/ntsb/ATL89FA078.md): Piper PA-28-140 · Bagley, AL · Accident · 2 fatal · Field investigation · Final report · Jan 18, 1989 · N8456R · Substantial damage
  > Inadequate maintenance by other maintenance personnel which allowed a foreign object to remain in the engine and damage/short the spark plugs in the #2 and #3 cylinders. Trees in the emergency landing area contributed to the accident. If shoulder harnesses…
- [NTSB MIA89LA066](https://openairdocs.org/ntsb/MIA89LA066.md): Piper PA-32-300 · Fort Myers, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 1989 · N4763T · Substantial damage
  > Failure of the #5 connecting rod bolt. Factors related to the accident were: dark night and the soft and wet (marshy) terrain conditions in the emergency landing area.
- [NTSB MIA89FA065](https://openairdocs.org/ntsb/MIA89FA065.md): Britten-Norman BN-2A · Carolina, PR · Accident · No injuries · Field investigation · Final report · Jan 16, 1989 · N457SA · Substantial damage
  > Fuel exhaustion and the failure of the pilot to insure that the proper fuel load was placed on the aircraft for the flight. Contributing factors included the improper refueling of the aircraft, improper initial training of the refueler and the crop, which…
- [NTSB FTW89DRD02](https://openairdocs.org/ntsb/FTW89DRD02.md): Piper PA-25-235 · Bogalusa, LA · Accident · Minor injuries · Final report · Jan 16, 1989 · N8782L · Substantial damage
  > The pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.
- [NTSB SEA89FA036](https://openairdocs.org/ntsb/SEA89FA036.md): de Havilland DHC-3 · Ketchikan, AK · Accident · 2 fatal · Field investigation · Final report · Jan 15, 1989 · N11250 · Destroyed
  > The pilot's inadvertant flight into IFR conditions and the stall which occurred during the turn to reverse course. Contributing to the accident were the snow conditions encountered.
- [NTSB MKC89LA053](https://openairdocs.org/ntsb/MKC89LA053.md): Mooney M20 · Malmo, MN · Accident · Serious injuries · Limited investigation · Final report · Jan 15, 1989 · N4096H · Destroyed
  > The pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), which resulted in his loss of aircraft control, due spatial disorientation. A related factor to the accident was: the adverse weather condition.
- [NTSB NYC89LA065](https://openairdocs.org/ntsb/NYC89LA065.md): Piper PA-38-112 · Albany, NY · Accident · No injuries · Limited investigation · Final report · Jan 14, 1989 · N2361K · Substantial damage
  > Fuel exhaustion resulting from the pilot's inadequate in-flight planning and misjudged fuel consumption.
- [NTSB MKC89LA051](https://openairdocs.org/ntsb/MKC89LA051.md): Cessna 150 · Clarion, IA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1989 · N22997 · Substantial damage
  > Failure of the pilot to properly use the carburetor heat during icing conditions resulting in carburetor ice formation and subsequent loss of engine power.
- [NTSB ATL89LA075](https://openairdocs.org/ntsb/ATL89LA075.md): Cessna 180 · Russells Point, OH · Accident · Minor injuries · Limited investigation · Final report · Jan 14, 1989 · N4585B · Substantial damage
  > The pilot's inaccurate evaluation of weather condition, and his failure to use available weather briefing resources. As a result, the pilot encountered structural icing which covered the windscreen, blocking forward visibility.
- [NTSB ATL89LA074](https://openairdocs.org/ntsb/ATL89LA074.md): Cessna T210N · Florence, SC · Accident · No injuries · Limited investigation · Final report · Jan 14, 1989 · N5289Y · Substantial damage
  > The failure of maintenance personnel to properly torque the thru bolts during number 2 cylinder installation. Contributing factors to the accident were terrain features which led to the collapse of the nose gear during landing.
- [NTSB MIA89LA069](https://openairdocs.org/ntsb/MIA89LA069.md): Bellanca 14-13-2 · Sebring, FL · Accident · No injuries · Limited investigation · Final report · Jan 13, 1989 · N74473 · Substantial damage
  > Failure of the cam gear snap ring, which allowed the camshaft gear to become disconnected. Factors related to the accident were trees in the emergency landing area.
- [NTSB ANC89FA034](https://openairdocs.org/ntsb/ANC89FA034.md): Beech BE-99 · Fort Yukon, AK · Accident · No injuries · Field investigation · Final report · Jan 13, 1989 · CFBCH · Substantial damage
  > The separation of a single propeller blade which caused the downward and rearward displacement of the number two engine.
- [NTSB LAX89FA082](https://openairdocs.org/ntsb/LAX89FA082.md): Beech 35-B33 · Ripon, CA · Accident · 3 fatal · Field investigation · Final report · Jan 10, 1989 · N8974M · Destroyed
  > Continued flight by the pilot into known icing conditions and structural (wing) icing, which subsequently resulted in an uncontrolled stall. A contributing factor was the icing condition.
- [NTSB FTW89LA040](https://openairdocs.org/ntsb/FTW89LA040.md): Beech V35B · Pawhuska, OK · Accident · No injuries · Limited investigation · Final report · Jan 9, 1989 · N4521S · Substantial damage
  > Fuel tank selector valve being inadvertently switched off and the pilot's emergency procedures inadequate in discoveringand correcting the problem. This resulted in the fuel starvation related power loss. Contributing to the accident was the rough terrain on…

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

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

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