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

## Cases, newest first

- [NTSB MKC89LA172](https://openairdocs.org/ntsb/MKC89LA172.md): Cessna 152 · Ft Smith, AR · Accident · No injuries · Limited investigation · Final report · Jul 31, 1989 · N757HY · Substantial damage
  > Inadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A contributing factor was the road sign.
- [NTSB BFO89FA065](https://openairdocs.org/ntsb/BFO89FA065.md): Piper PA-28R-201T · College Park, MD · Accident · 4 fatal · Field investigation · Final report · Jul 31, 1989 · N64MB · Destroyed
  > Failure of the pilot to maintain aircraft control due to spatial disorientation, and his exceeding the design stress limits of the aircraft, which resulted in overload failure of the stabilators and wings. Factors related to the accident were: the pilot's…
- [NTSB SEA89FA143](https://openairdocs.org/ntsb/SEA89FA143.md): Piper PA-32-301 · Haines, AK · Accident · 2 fatal · Field investigation · Final report · Jul 30, 1989 · N8257V · Destroyed
  > Improper in-flight planning and decision by the pilot, which resulted in inadvertent flight into instrument meteorological conditions (IMC). The weather conditions and terrain were related factors.
- [NTSB MKC89LA163](https://openairdocs.org/ntsb/MKC89LA163.md): Beech 58 · Cedar Rapids, IA · Accident · No injuries · Limited investigation · Final report · Jul 30, 1989 · N1846L · Substantial damage
  > The failure of the pilot in command to maintain alignment with the runway and excessive aircraft control in close proximity to the ground. Contributing to the accident was the pilot's diverted attention which resulted from having to shut down the left engine.
- [NTSB LAX89LA252](https://openairdocs.org/ntsb/LAX89LA252.md): Piper PA-28-180 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Jul 30, 1989 · N7341W · Substantial damage
  > Continued buildup of carburetor ice due to the pilot's improper use of carburetor heat, and his improper use of emergency procedures. Factors related to the accident were: carburetor icing conditions, the pilot's lack of recent flight experience, and trees in…
- [NTSB CHI89LA152](https://openairdocs.org/ntsb/CHI89LA152.md): Piper PA-28-180 · Watertown, WI · Accident · No injuries · Limited investigation · Final report · Jul 29, 1989 · N3954R · Substantial damage
  > Improper planning/decision by the pilot and his misjudgement of distance and speed during the landing, which resulted in failure to attain a proper touchdown point. Contributing factors were: the weather conditions, the pilot's continued flight into…
- [NTSB CHI89FA150](https://openairdocs.org/ntsb/CHI89FA150.md): Prospector FK-1 · Chilton, WI · Accident · No injuries · Field investigation · Final report · Jul 29, 1989 · N4XK · Substantial damage
  > The pilot's poor in flight planning in that he diverted his attention and continued the flight beyond the original period planned. Before takeoff the pilot was aware of his fuel endurance.
- [NTSB CHI89DEP08](https://openairdocs.org/ntsb/CHI89DEP08.md): James Eggleston Varieze · Cottage Grove, WI · Accident · No injuries · Final report · Jul 29, 1989 · N13EG · Substantial damage
  > The pilot misjudged altitude and distance to the runway and failed to attain the proper touchdown point for a landing. Factors related to the accident were: adverse weather conditions and uneven terrain short of the runway.
- [NTSB LAX89LA256](https://openairdocs.org/ntsb/LAX89LA256.md): Cessna 172M · Marana, AZ · Accident · No injuries · Limited investigation · Final report · Jul 28, 1989 · N61552 · Substantial damage
  > Inadequate preflight by the student pilot, inadequate supervision by the flight instructor (CFI), and fuel exhaustion due to lack of fuel. Related factors were: inoperative left fuel quantity gage, the cfi's decision to make the flight with a known deficiency…
- [NTSB CHI89DEP09](https://openairdocs.org/ntsb/CHI89DEP09.md): Cabrinha/Free Spirit 412 · Waukesha, WI · Accident · No injuries · Final report · Jul 28, 1989 · N412RC · Substantial damage
  > The plt became lost/disoriented and allowed fuel exhaustion to occur before accomplishing remedial action. Factors related to the accident were: the adverse environmental conditions and the road sign and vehicles in the emergency landing area.
- [NTSB BFO89FA063](https://openairdocs.org/ntsb/BFO89FA063.md): Piper PA-24-250 · True, WV · Accident · 1 fatal · Field investigation · Final report · Jul 28, 1989 · N7162P · Destroyed
  > The pilots failure to properly monitor the fuel supply which resulted in fuel starvation. The aircraft stalled as the pilot performed an evasive maneuver to avoid the mountain top.
- [NTSB MIA89LA208](https://openairdocs.org/ntsb/MIA89LA208.md): Aeronca 7AC · Homestead, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 1989 · N60FU · Substantial damage
  > Improper repair of the fuel cap (seal) by the pilot, which resulted in a blocked fuel system (cap) vent and subsequent fuel starvation, and his failure to see-and-avoid the telephone line. The telephone (transmission) line was a contributing factor.
- [NTSB LAX89LA257](https://openairdocs.org/ntsb/LAX89LA257.md): Cessna 337H · Honolulu, HI · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1989 · N2AC · Substantial damage
  > An unexpected and sudden encounter with severe turbulence while the aircraft was cruising over the pacific ocean in cumulus cloud conditions.
- [NTSB CHI89DEE05](https://openairdocs.org/ntsb/CHI89DEE05.md): Cessna 152 · Romeoville, IL · Accident · No injuries · Final report · Jul 27, 1989 · N25848 · Substantial damage
  > The pilot's misjudgement of the fuel supply.
- [NTSB NYC89IA176](https://openairdocs.org/ntsb/NYC89IA176.md): Douglas DC-9-30 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Jul 26, 1989 · N556NY · Minor damage
  > Rupture of a flexible high pressure hydraulic line in the 'a' hydraulic system, due to chafing of the steel braid covering, which allowed the system pressure and quantity to be completely depleted.
- [NTSB LAX89LA246](https://openairdocs.org/ntsb/LAX89LA246.md): Hughes 269C · Kalapana, HI · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1989 · N58344 · Substantial damage
  > The loss of engine power due to the failure of the engine exhaust valve in the no. 2 cylinder and the disregard of the Lycoming service bulletin by company maintenance personnel. Contributing to the accident was the high vegetation and trees located at the…
- [NTSB NYC89LA175](https://openairdocs.org/ntsb/NYC89LA175.md): Cessna 170B · Bricktown, NJ · Accident · No injuries · Limited investigation · Final report · Jul 24, 1989 · N8388A · Substantial damage
  > Undetermined. The terrain was a related factor.
- [NTSB BFO89FA062](https://openairdocs.org/ntsb/BFO89FA062.md): Beech 77 · Cluster Springs, VA · Accident · 1 fatal · Field investigation · Final report · Jul 23, 1989 · N18257 · Destroyed
  > The pilot's failure to perform an adequate preflight which resulted in an unlatched fuel filler cap. Contributing to the accident was the pilot's failure to monitor the fuel supply during the flight.
- [NTSB CHI89LA141](https://openairdocs.org/ntsb/CHI89LA141.md): Cessna R172K · Wisconsin Dells, WI · Accident · No injuries · Limited investigation · Final report · Jul 22, 1989 · N736DA · Substantial damage
  > Failure of the pilot to insure the oil filler cap was properly secured when he serviced the aircraft before takeoff, and subsequent loss of oil and oil exhaustion. The tree was considered to be a contributing factor.
- [NTSB MIA89LA204](https://openairdocs.org/ntsb/MIA89LA204.md): Texas Helicopter OH-13E/M74 · Greenwood, MS · Accident · No injuries · Limited investigation · Final report · Jul 21, 1989 · N47345 · Substantial damage
  > Failure of a main rotor blade pitch change horn and/or attaching bolt(s).
- [NTSB ATL89FA190](https://openairdocs.org/ntsb/ATL89FA190.md): Mooney M20J · Suches, GA · Accident · 4 fatal · Field investigation · Final report · Jul 21, 1989 · N205AG · Destroyed
  > The pilot elected to continue flight to the intended destination disregarding the recommendations of the in flight weather briefer. Contributing factor(s) was: the adverse weather conditions that existed at the time.
- [NTSB SEA89LA137](https://openairdocs.org/ntsb/SEA89LA137.md): Piper PA-22 · Meridian, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1989 · N3700P · Substantial damage
  > The pilot's failure to properly position the fuel selector, which resulted in fuel starvation, his failure to follow the emergency procedure, and his inadequate visual lookout (failure to see & avoid obstructions). The power line was a related factor.
- [NTSB LAX89IA242](https://openairdocs.org/ntsb/LAX89IA242.md): Aerospatiale AS350D · Long Beach, CA · Incident · Minor injuries · Incident investigation · Final report · Jul 20, 1989 · N143EH · Minor damage
  > The failure of the engine driven fuel pump.
- [NTSB SEA89LA136](https://openairdocs.org/ntsb/SEA89LA136.md): Cessna A188B · Albion, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 1989 · N9768G · Destroyed
  > The pilot failed to see and avoid a wooden utility pole while cruising at a low level. A contributing factor was the dusk light conditions.
- [NTSB DCA89MA063](https://openairdocs.org/ntsb/DCA89MA063.md): Mcdonnell Douglas DC-10-10 · Sioux City, IA · Accident · 111 fatal · Class 1 · Major · Final report · Jul 19, 1989 · N1819U · Destroyed
  > The inadequate consideration given to human factors limitations in the inspection and quality control procedures used by united airlines' engine overhaul facility which resulted in the failure to detect a fatigue crack originating from a previously…
- [NTSB ATL89LA181](https://openairdocs.org/ntsb/ATL89LA181.md): Piper PA-28-235 · Somerset, OH · Accident · No injuries · Limited investigation · Final report · Jul 19, 1989 · N8914W · Substantial damage
  > The pilot's failure to adequately perform an airplane pre-flight inspection and drain water present in the airplane fuel supply. The airplane engine subsequently lost power due to the water contamination.
- [NTSB DEN89FA175](https://openairdocs.org/ntsb/DEN89FA175.md): Bell 206B · Duchesne, UT · Accident · 3 fatal · Field investigation · Final report · Jul 18, 1989 · N1086C · Destroyed
  > The pilot failed to maintain clearance from the power line. Contributing factors were: lack of mission training provided by the company/operator, the pilot's lack of experience in this type of operation, his lack of familiarity with the geographic area, and…
- [NTSB BFO89FA060](https://openairdocs.org/ntsb/BFO89FA060.md): Beech V35TC · Charlottesville, VA · Accident · 1 fatal · Field investigation · Final report · Jul 18, 1989 · N118FC · Destroyed
  > Improper installation of the throttle and variable absolute controller assemblies by maintenance personnel which resulted in a total loss of engine power.
- [NTSB SEA89LA133](https://openairdocs.org/ntsb/SEA89LA133.md): Aeronca 7AC · American Falls, ID · Accident · No injuries · Limited investigation · Final report · Jul 16, 1989 · N1636E · Substantial damage
  > An engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.
- [NTSB NYC89FA167](https://openairdocs.org/ntsb/NYC89FA167.md): Piper PA-24-250 · Hartleton, PA · Accident · 2 fatal · Field investigation · Final report · Jul 16, 1989 · N6206P · Destroyed
  > The pilot allowed the design stress limits of the aircraft to be exceeded after encountering adverse weather conditions. Weather was a related factor.
- [NTSB MIA89LA200](https://openairdocs.org/ntsb/MIA89LA200.md): Piper PA-32-300 · Luquillo, PR · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1989 · N999MA · Substantial damage
  > Failure of the left exhaust stack which resulted in an engine fire, loss of engine power, and subsequent ditching of the acft in ocean waters.
- [NTSB BFO89FA058](https://openairdocs.org/ntsb/BFO89FA058.md): Piper PA-32-300 · Libertytown, MD · Accident · 3 fatal · Field investigation · Final report · Jul 16, 1989 · N83HA · Destroyed
  > Continued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), which resulted in the pilot's loss of aircraft control due to disorientation, and overload failure of the wings and stabilator due to the pilot exceeding…
- [NTSB ATL89LA179](https://openairdocs.org/ntsb/ATL89LA179.md): Cessna P210N · Jackson, SC · Accident · No injuries · Limited investigation · Final report · Jul 16, 1989 · N132WW · Substantial damage
  > The pilot's mismanagement of the available fuel supply which resulted in a total loss of engine power. The fuel selector was not positioned to the tank which contained fuel. Contributing factor(s) was: the rough terrain encountered during the forced landing.
- [NTSB ANC89LA124](https://openairdocs.org/ntsb/ANC89LA124.md): Piper PA-32-300 · Quinhagak, AK · Accident · No injuries · Limited investigation · Final report · Jul 16, 1989 · N32062 · Destroyed
  > Powerplant failure for an unknown reason, which resulted in an engine vibration, oil leak and a fire.
- [NTSB FTW89LA141](https://openairdocs.org/ntsb/FTW89LA141.md): Beech 35-C33A · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1989 · N9497S · Substantial damage
  > Fuel exhaustion due to pilot mismanagement.
- [NTSB NYC89LA163](https://openairdocs.org/ntsb/NYC89LA163.md): Piper PA-11 · Walpole, ME · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1989 · N5014H · Substantial damage
  > A loss of engine power for undetermined reasons. Contributing to the accident was the powerline which the airplane contacted.
- [NTSB MIA89LA195](https://openairdocs.org/ntsb/MIA89LA195.md): Cessna 210N · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1989 · N9913Y · Destroyed
  > A gunshot wound, which resulted in a loss of the pilot's ability to effectively fly and navigate the aircraft, and a subsequent loss of engine power due to fuel exhaustion.
- [NTSB ATL89LA178](https://openairdocs.org/ntsb/ATL89LA178.md): Piper PA-32RT-300T · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Jul 12, 1989 · N2153K · Substantial damage
  > The improper installation of the propeller governor idler-gear shaft retaining set-screw, which led to an engine oil leak and resulted in a loss of engine power; and the reduction of the pilot's ability to see outside the airplane due to oil on the windshield.
- [NTSB FTW89FA133](https://openairdocs.org/ntsb/FTW89FA133.md): Aerospatiale AS-350-D · Galveston, TX · Accident · 2 fatal · Field investigation · Final report · Jul 11, 1989 · N3595B · 2 aircraft · Destroyed
  > Failure of both pilots to see-and-avoid the other aircraft (inadequate visual lookout).
- [NTSB CHI89LA131](https://openairdocs.org/ntsb/CHI89LA131.md): Cessna 172P · Logansport, IN · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 1989 · N64087 · Substantial damage
  > Poor judgement of the pilot due to physical impairment from consumption of alcohol, his inadvertent flight into known adverse weather, and his inadequate control of the aircraft during a precautionary landing. Contributing factors were: the weather conditions…
- [NTSB ATL89FA177](https://openairdocs.org/ntsb/ATL89FA177.md): Cessna 172 · Townsend, TN · Accident · Serious injuries · Field investigation · Final report · Jul 11, 1989 · N8855B · Destroyed
  > Improper in-flight planning/decision by the pilot and his delay in initiating remedial action, when he encountered low ceilings over mountainous terrain, which resulted in his inability to maintain sufficient altitude. Contributing factors were: the pilot's…
- [NTSB ANC89FA119](https://openairdocs.org/ntsb/ANC89FA119.md): Cessna 207 · 44 Nw Fairbanks, AK · Accident · No injuries · Field investigation · Final report · Jul 11, 1989 · N91052 · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel starvation. Factors related to the accident were: inaccurate fuel consumption calculations, inadequate fuel supply, turbulence, tailwind, terrain conditions, and trees (willows) in the emergency…
- [NTSB MIA89LA190](https://openairdocs.org/ntsb/MIA89LA190.md): Cessna 172M · Perry, FL · Accident · No injuries · Limited investigation · Final report · Jul 10, 1989 · N4427Q · Substantial damage
  > Failure of the number three exhaust valve which necessitated a forced landing. The trees were considered to be a contributing factor.
- [NTSB NYC89LA159](https://openairdocs.org/ntsb/NYC89LA159.md): Cessna 177A · Akron, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1989 · N3154T · Destroyed
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: soft terrain in the emergency landing area.
- [NTSB MIA89LA189](https://openairdocs.org/ntsb/MIA89LA189.md): Cessna 152 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Jul 9, 1989 · N4680P · Substantial damage
  > Inadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel. The soft terrain in the emergency landing area was considered to be a contributing factor.
- [NTSB LAX89LA233](https://openairdocs.org/ntsb/LAX89LA233.md): Cessna P210N · Los Angeles, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 1989 · N609AC · Destroyed
  > An undertorqued oil line fitting, due to its improper installation by maintenance personnel, which resulted in a loose oil line fitting, an oil line leak, oil exhaustion, and subsequent failure of the engine.
- [NTSB CHI89IA144](https://openairdocs.org/ntsb/CHI89IA144.md): Dornier DO-228 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jul 9, 1989 · N263MC · No damage
  > Poor lookout by the crew of the Dornier and the baron.
- [NTSB CHI89IA143](https://openairdocs.org/ntsb/CHI89IA143.md): Mcdonnell Douglas DC-9-32 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jul 9, 1989 · N939ML · No damage
  > Poor lookout by the crew of the DC-9 and the Cessna pilot.
- [NTSB DEN89LA161](https://openairdocs.org/ntsb/DEN89LA161.md): Raven RX-7 · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1989 · N4069H · Substantial damage
  > Inadequate visual lookout by the pilot. Contributing to the accident were the power lines.
- [NTSB DEN89LA160](https://openairdocs.org/ntsb/DEN89LA160.md): Grumman-Schweizer G-164B · Holden, UT · Accident · No injuries · Limited investigation · Final report · Jul 8, 1989 · N6754Q · Substantial damage
  > The pilot's misjudgement of the effect of high density altitude on a heavily loaded aircraft.

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

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

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