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

## Cases, newest first

- [NTSB SEA89FA157](https://openairdocs.org/ntsb/SEA89FA157.md): Beech C35 · Sandy, OR · Accident · 1 fatal · Field investigation · Final report · Aug 27, 1989 · N5916C · Substantial damage
  > The loss of engine power due to the separation of the bolt connecting the throttle rod to the carburetor throttle arm and an inadequate annual inspection performed 5 flight hours prior to the occurrence. Contributing factors were obstructions in and around…
- [NTSB ANC89LA151](https://openairdocs.org/ntsb/ANC89LA151.md): Maule M-4-210 · Bainbridge, AK · Accident · No injuries · Limited investigation · Final report · Aug 27, 1989 · N4605T · Substantial damage
  > Continued flight by the pilot into known adverse weather conditions, and his subsequent selection of unsuitable terrain for landing. Factors related to the accident were: adverse weather conditions and terrain conditions in the precautionary landing area.
- [NTSB ATL89LA203](https://openairdocs.org/ntsb/ATL89LA203.md): Cessna 150G · Edgefield, SC · Accident · No injuries · Limited investigation · Final report · Aug 26, 1989 · N465SR · Substantial damage
  > Poor inflight planning by the pilot in command in that he allowed the fuel supply to be exhausted.
- [NTSB BFO89LA073](https://openairdocs.org/ntsb/BFO89LA073.md): Cessna 152 · Selbyville, DE · Accident · No injuries · Limited investigation · Final report · Aug 25, 1989 · N67803 · Substantial damage
  > Excessive wear of the number four exhaust lobe on the camshaft and poor condition (wear) of the number four exhaust tappet. The soybean crop in the emergency landing area was considered to be a factor.
- [NTSB LAX89FA287](https://openairdocs.org/ntsb/LAX89FA287.md): Cessna 180J · Tracy, CA · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1989 · N42695 · 2 aircraft · Destroyed
  > Inadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: the lack of a conflict alert system for the stockton arts ii radar.
- [NTSB DEN89LA198](https://openairdocs.org/ntsb/DEN89LA198.md): Cessna 150-L · Logan, UT · Accident · No injuries · Limited investigation · Final report · Aug 23, 1989 · N6697G · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion, due to lack of fuel. Factors related to the accident were: darkness and a fence in the emergency landing area.
- [NTSB BFO89FA069](https://openairdocs.org/ntsb/BFO89FA069.md): Beech B50 · Church Creek, MD · Accident · 3 fatal · Field investigation · Final report · Aug 23, 1989 · N3688B · Destroyed
  > VFR flight into IMC and pilot disorientation, which resulted in the loss of aircraft control. Contributing to the accident was the pilot's lack of instrument experience, darkness, and the adverse weather condition.
- [NTSB MKC89LA184](https://openairdocs.org/ntsb/MKC89LA184.md): Dormoy TKD Bathtub · Carlisle, MN · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1989 · N812SS · Substantial damage
  > Failure of the mixture control cable and inadequate maintenance (repair) by the pilot. The terrain conditions were considered to be contributing factors.
- [NTSB DEN89FA197](https://openairdocs.org/ntsb/DEN89FA197.md): Aerospatiale AS350D · Carson City, NV · Accident · Serious injuries · Field investigation · Final report · Aug 21, 1989 · N3596G · Substantial damage
  > A failure of the gas generator turbine. Factors related to the accident were: the tailwind and the residential area in which the pilot was forced to land.
- [NTSB BFO89LA070](https://openairdocs.org/ntsb/BFO89LA070.md): Piper PA-28-180 · Clendenin, WV · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1989 · N7597W · Destroyed
  > Inadequate preflight planning/preparation by the pilot which resulted in fuel exhaustion. The weather conditions, the pilot's delay in diverting to an alternate airport, and the light pole were contributing factors.
- [NTSB ANC89LA147](https://openairdocs.org/ntsb/ANC89LA147.md): Cessna 175 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Aug 21, 1989 · N6929E · Substantial damage
  > Failure of the accessory drive (crankshaft) dowel pin and/or gear bolt, which resulted in the accessory drivegear becoming disconnected from the crankshaft.
- [NTSB MIA89LA228](https://openairdocs.org/ntsb/MIA89LA228.md): Fokker F-28 MK4000 · Vero Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 1989 · N489US · No damage
  > In-flight encounter with unforecast turbulence, which resulted in injury of a flight attendant, who was not wearing a safety belt.
- [NTSB LAX89LA281](https://openairdocs.org/ntsb/LAX89LA281.md): Aerospatiale AS350D · Volcano, HI · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 1989 · N35970 · Destroyed
  > A catastrophic failure of the power turbine shaft and bearings. The failure was a result of oil starvation due to an excessively worn chip detector o-ring seal,inadequate maintenance and preflight. Contributing factor(s) was: the mountainous terrain.
- [NTSB CHI89LA172](https://openairdocs.org/ntsb/CHI89LA172.md): Cessna T-337D · Howell, MI · Accident · No injuries · Limited investigation · Final report · Aug 19, 1989 · N33N · Substantial damage
  > The pilot's poor preflight planning and inaccurate fuel consumption calculations. Contributing factor was maintenance personnel's not performing correct calibration of fuel gages.
- [NTSB ATL89FA200](https://openairdocs.org/ntsb/ATL89FA200.md): Bell 206B · Fruithurst, AL · Accident · No injuries · Field investigation · Final report · Aug 19, 1989 · N117V · Substantial damage
  > Pilot's failure to maintain main rotor RPM while executing an autorotation which resulted in a hard landing. Contributing to the accident was the pilot's failure to follow autorotation procedures after the reported engine failure.
- [NTSB MKC89LA187](https://openairdocs.org/ntsb/MKC89LA187.md): Beech V35B · Concord, AR · Accident · No injuries · Limited investigation · Final report · Aug 18, 1989 · N699T · Substantial damage
  > Improper installation of the alternator wiring harness by the pilot/owner which resulted in chafed wiring and a subsequent electrical fire. The uneven terrain was a contributing factor.
- [NTSB LAX89DUJ09](https://openairdocs.org/ntsb/LAX89DUJ09.md): Hiller UH-12E · Tolleson, AZ · Accident · Minor injuries · Final report · Aug 16, 1989 · N7086 · Substantial damage
  > An engine failure due to water contamination in the fuel supply which preceded an autorotation and collision with the ground during night time conditions.
- [NTSB MKC89LA182](https://openairdocs.org/ntsb/MKC89LA182.md): Cessna 182 · Russell, AR · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1989 · N3763D · Substantial damage
  > An engine failure, because of a valve which stuck in the open position, over terrain that was unsuitable for a forced landing.
- [NTSB MKC89LA181](https://openairdocs.org/ntsb/MKC89LA181.md): Bell 47G-B3 · Waseca, MN · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1989 · N8471E · Substantial damage
  > Inadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. The tailwind, high obstruction (power line), and crop (beans) were contributing factors.
- [NTSB LAX89FA280](https://openairdocs.org/ntsb/LAX89FA280.md): Cessna 152 · Castaic, CA · Accident · 1 fatal · Field investigation · Final report · Aug 15, 1989 · N152DM · Destroyed
  > Failure of the instructor pilot to adequately supervise the conduct of the flight, failure of the instructor pilot to ensure adequate terrain clearance prior to initiating the maneuver, and failure of the instructor pilot to take timely and proper and proper…
- [NTSB MIA89FA219](https://openairdocs.org/ntsb/MIA89FA219.md): Cessna 177RG · Janice, MS · Accident · 2 fatal · Field investigation · Final report · Aug 14, 1989 · N1976Q · Destroyed
  > The in flight loss of control by the non instrument rated pilot after encountering instrument meteorological conditions resulting in the airplane spiraling into a wooded area.
- [NTSB LAX89LA278](https://openairdocs.org/ntsb/LAX89LA278.md): Piper PA-28-140 · Butte Meadows, CA · Accident · 1 fatal · Limited investigation · Final report · Aug 14, 1989 · N3795K · Substantial damage
  > The pilot improper in-flight planning to attain proper altitude to clear the mountainous terrain. Contributing factor(s) was: the high terrain and high density attitude.
- [NTSB MKC89FA179](https://openairdocs.org/ntsb/MKC89FA179.md): Mooney M20F · Mound City, KS · Accident · 3 fatal · Field investigation · Final report · Aug 13, 1989 · N6960V · Destroyed
  > The pilot's continued VFR flight into an area of thunderstorms & heavy rain which resulted in a loss of control of the airplane. Factors related to the accident were thunderstorms and heavy rain.
- [NTSB LAX89LA274](https://openairdocs.org/ntsb/LAX89LA274.md): Piper PA-38-112 · Benson, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 1989 · N2471D · Destroyed
  > The pilot's failure to maintain adequate airspeed during an emergency descent and to properly flare the aircraft during landing. Contributing to the accident was the pilot's anxiousness in over-reacting to a situation and prematurely entering a power-off…
- [NTSB LAX89LA273](https://openairdocs.org/ntsb/LAX89LA273.md): Cessna 172N · Seligman, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1989 · N5961J · Substantial damage
  > A loss of engine power due to a failure of the number 3 cylinder exhaust valve rocker arm pivot stud, which was in turn caused by a stuck exhaust valve.
- [NTSB BFO89LA068](https://openairdocs.org/ntsb/BFO89LA068.md): Piper PA-28-161 · Leesburg, VA · Accident · No injuries · Limited investigation · Final report · Aug 13, 1989 · N4325V · Substantial damage
  > Improper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC), and his failure to maintain proper alignment, while landing at night on a road. The weather conditions, dark night, and…
- [NTSB FTW89LA148](https://openairdocs.org/ntsb/FTW89LA148.md): Cessna 150 · Terrell, TX · Accident · No injuries · Limited investigation · Final report · Aug 11, 1989 · N5794E · Substantial damage
  > The pilot became lost during the flight and fuel exhaustion occurred which required an off airport forced landing.
- [NTSB LAX89IA315](https://openairdocs.org/ntsb/LAX89IA315.md): Boeing 727-224 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Aug 10, 1989 · N88709 · Minor damage
  > A fatigue crack in the right gear wheel well.
- [NTSB FTW89LA145](https://openairdocs.org/ntsb/FTW89LA145.md): Cessna 182 · Comfort, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1989 · N5703B · Substantial damage
  > The fuel exhaustion induced power loss which resulted from the fuel pilot's failure to accurately determine the amount of fuel available for the flight.
- [NTSB DCA89IA066](https://openairdocs.org/ntsb/DCA89IA066.md): Mcdonnell Douglas DC-10-40 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Aug 10, 1989 · N133JC · Minor damage
  > Fatigue failure and separation of a first-stage compressor fan blade.
- [NTSB ATL89FA194](https://openairdocs.org/ntsb/ATL89FA194.md): Beech E55 · Raleigh, NC · Accident · 1 fatal · Field investigation · Final report · Aug 10, 1989 · N55TP · Destroyed
  > The pilot's loss of control due to spatial disorientation while operating in instrument weather conditions.
- [NTSB MKC89LA175](https://openairdocs.org/ntsb/MKC89LA175.md): Balloon Works FIREFLY-7 · Indianola, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1989 · N2210H · Substantial damage
  > Failure of the pilot to maintain clearance from the tv tower due to improper in-flight planning/decision. Unfavorable wind/windshear and the tall tower were contributing factors.
- [NTSB LAX89LA267](https://openairdocs.org/ntsb/LAX89LA267.md): Grumman American AA-5B · Terminal Island, CA · Accident · No injuries · Limited investigation · Final report · Aug 8, 1989 · N28565 · Substantial damage
  > The fatigue failure of an exhaust valve due to excessive wear of the respective valve guide. Factors related to the accident were: the fence & cars in the emergency landing area.
- [NTSB NYC89LA184](https://openairdocs.org/ntsb/NYC89LA184.md): Piper PA-28-161 · Hammonton, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1989 · N22179 · Destroyed
  > The pilot overshooting a landing during a precautionary landing due to deteriorating weather conditions. Contributing factor(s) was: the pilot's decision to attempt the flight after being advised that VFR flight was not recommended and inadequate preflight by…
- [NTSB NYC89FA183](https://openairdocs.org/ntsb/NYC89FA183.md): Beech B24R · Wiscasset, ME · Accident · 2 fatal · Field investigation · Final report · Aug 6, 1989 · N2175W · Destroyed
  > The pilot's loss of control of the airplane and uncontrolled descent during attempted flight in instrument meteorological conditions.
- [NTSB LAX89FA276](https://openairdocs.org/ntsb/LAX89FA276.md): Piper PA-28-140 · Toms Place, CA · Accident · 2 fatal · Field investigation · Final report · Aug 6, 1989 · N6274W · Destroyed
  > Failure of the pilot to attain sufficient altitude to clear terrain obstructions before entering a high elevation basin. Contributing to the accident was a high density altitude which reduced the aircraft's climb performance to less than the rate of climb of…
- [NTSB CHI89DEK02](https://openairdocs.org/ntsb/CHI89DEK02.md): Keener Rotorway/Exec · Circleville, OH · Accident · No injuries · Final report · Aug 6, 1989 · N4JK · Destroyed
  > Material failure of an oil line allowing oil to escape and ignite as it touched hot exhaust manifold surfaces.
- [NTSB FTW89LA144](https://openairdocs.org/ntsb/FTW89LA144.md): Cessna 172G · Mckinney, TX · Accident · No injuries · Limited investigation · Final report · Aug 5, 1989 · N4377L · Substantial damage
  > Total failure of the engine assembly/rocker arm/tappet shaft.
- [NTSB FTW89FA143](https://openairdocs.org/ntsb/FTW89FA143.md): Balloon Works Firefly 6B · Baton Rouge, LA · Accident · 1 fatal · Field investigation · Final report · Aug 5, 1989 · N27113 · Substantial damage
  > The pilot exceeded the temperature limitations of the Balloon during the climb, which resulted in failure of the frabric. Factors related to the accident were: the previous heat damage to the frabric, and the lack of maintenance by the pilot/owner.
- [NTSB NYC89LA189](https://openairdocs.org/ntsb/NYC89LA189.md): Convair CV-600-240D · Augusta, ME · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1989 · N94253 · Substantial damage
  > The failure of the propeller control system for undetermined reasons during a precautionary landing after encountering deteriorating weather conditions during a VFR ferry flight. Contributing factor(s) was: the adverse weather conditions, inadequate…
- [NTSB LAX89LA263](https://openairdocs.org/ntsb/LAX89LA263.md): Piper PA-23-180 · Lancaster, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1989 · N4376P · Substantial damage
  > The pilot's failure to follow established procedures in restarting the engine that drives the hydrualic pump and his failure to follow published emergency landing gear extension procedures. The pilot's decision to shut down an engine and feather the propeller…
- [NTSB ANC89LA132](https://openairdocs.org/ntsb/ANC89LA132.md): Piper PA-18 · Canyon Creek, AK · Accident · No injuries · Limited investigation · Final report · Aug 4, 1989 · N679RK · Substantial damage
  > The pilot's improper planning/decision concerning fuel management, which resulted in fuel starvation. Contributing factors were: probable water in the fuel, inadequate altitude for an engine restart, and the terrain conditions.
- [NTSB MIA89LA211](https://openairdocs.org/ntsb/MIA89LA211.md): Cessna 172 · Apalachicola, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 3, 1989 · N64RF · Destroyed
  > Failure of the pilot to maintain proper altitude. A factor related to the accident was: the pilot's lack of visual perception concerning altitude above the water.
- [NTSB CHI89LA156](https://openairdocs.org/ntsb/CHI89LA156.md): Cessna 152 · Kankakee, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 3, 1989 · N67342 · Substantial damage
  > Failure of the student pilot to use carburetor heat, which resulted in loss of engine power, due to carburetor ice. A factor related to the accident was: carburetor icing conditions.
- [NTSB LAX89LA259](https://openairdocs.org/ntsb/LAX89LA259.md): Robinson R22 · Palm Springs, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 1989 · N971JG · Substantial damage
  > The pilot's failure to properly manipulate the throttle control to maintain engine/rotor RPM and his decision to enter an autorotation (forced landing). His eagerness to land and lack of total experience were factors in the accident.
- [NTSB FTW89LA142](https://openairdocs.org/ntsb/FTW89LA142.md): Schempp-Hirth Cirrus · Littlefield, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 1989 · N158WT · Substantial damage
  > Improper planning/decision by the pilot & the severe turbulence.
- [NTSB CHI89DEM05](https://openairdocs.org/ntsb/CHI89DEM05.md): Gatzemeyer 88 ACRO-SPORT II · Escanaba, MI · Accident · Minor injuries · Final report · Aug 2, 1989 · N55NG · Substantial damage
  > A loose fuel line between the carburetor and engine which resulted in fuel starvation. A factor related to the accident was: no suitable terrain.
- [NTSB MKC89LA173](https://openairdocs.org/ntsb/MKC89LA173.md): Mooney M20C · Fouke, AR · Accident · No injuries · Limited investigation · Final report · Aug 1, 1989 · N6249U · Substantial damage
  > The pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion, at night. The ensuing forced landing resulted in a collision with a fencepost, ground swerve, and collapse of the right main landing gear.
- [NTSB SEA89LA144](https://openairdocs.org/ntsb/SEA89LA144.md): Robinson R22 · Brinnon, WA · Accident · No injuries · Limited investigation · Final report · Jul 31, 1989 · N933CB · Destroyed
  > The pilot's inadequate in-flight planning. The helicopter skid contacted the water as a result of the pilot's misjudgement of clearance above the water.
- [NTSB NYC89LA181](https://openairdocs.org/ntsb/NYC89LA181.md): Cessna 185D · Wolfeboro, NH · Accident · No injuries · Limited investigation · Final report · Jul 31, 1989 · N1526F · Substantial damage
  > Loss of engine power for an unknown reason. Factors related to the accident were: the obstructions (trees & boats) in the emergency landing area.

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

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

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