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

## Cases, newest first

- [NTSB NYC89FA099](https://openairdocs.org/ntsb/NYC89FA099.md): Piper PA-32R-300 · Southbridge, MA · Accident · 2 fatal · Field investigation · Final report · Mar 12, 1989 · N301WA · Destroyed
  > Poor judgement of the pilot by flying while physically impaired by alcohol, and his continued VFR flight into instrument meteorological conditions (IMC). Related factors were: the pilot's inadequate preflight planning/preparation, dark night, adverse weather…
- [NTSB FTW89FA065](https://openairdocs.org/ntsb/FTW89FA065.md): Piper PA-28-161 · New Orleans, LA · Accident · 4 fatal · Field investigation · Final report · Mar 12, 1989 · N8369K · Destroyed
  > The pilot diverting his attention from flying the aircraft while complying with the departure control instructions, and allowing the aircraft to descend into the water.
- [NTSB BFO89LA021](https://openairdocs.org/ntsb/BFO89LA021.md): Piper PA-38-112 · Gingerville, MD · Accident · No injuries · Limited investigation · Final report · Mar 12, 1989 · N9378T · Substantial damage
  > The pilot's improper planning and decision making en route that resulted in his failure to stop and refuel the airplane and fuel exhaustion.
- [NTSB MKC89LA078](https://openairdocs.org/ntsb/MKC89LA078.md): Cessna 175 · Murray, NE · Accident · No injuries · Limited investigation · Final report · Mar 11, 1989 · N175RP · Substantial damage
  > Water contamination of the fuel and the pilot's inadequate preflight of the aircraft. A factor related to the accident was: the ditch in the emergency landing area.
- [NTSB MIA89LA103](https://openairdocs.org/ntsb/MIA89LA103.md): Cessna 182 · Jacksonville, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1989 · N182BH · Substantial damage
  > Failure of the pilot to use the carburetor heat, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstructions (power lines & vehicles) in the emergency landing area.
- [NTSB ATL89LA102](https://openairdocs.org/ntsb/ATL89LA102.md): Cessna 172G · Coolidge, GA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1989 · N1365F · Substantial damage
  > Fuel contamination of an unknown origin, failure of company maintenance personnel to locate and remove all contamination, continued operation of the aircraft by the pilot after the cause of a known engine problem was not determined, and subsequent fuel…
- [NTSB NYC89LA098](https://openairdocs.org/ntsb/NYC89LA098.md): Cessna 337 · Bethel, NY · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1989 · N2265X · Destroyed
  > Improper planning/decision by the pilot concerning his fuel management, which resulted in fuel exhaustion due to an inadequate supply of fuel. The false indication from the fuel quantity gage(s), dark night, and trees were considered to be factors.
- [NTSB NYC89FAMS3](https://openairdocs.org/ntsb/NYC89FAMS3.md): Cessna P210N · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Missing aircraft · Final report · Mar 9, 1989 · N734QR · Destroyed
  > A power loss for undetermined reasons resulting in a ditching in the north Atlantic Ocean. High seas may have prevented the pilot from getting into his survival suit.
- [NTSB ATL89IA099](https://openairdocs.org/ntsb/ATL89IA099.md): Boeing 737-201 · Dayton, OH · Incident · No injuries · Incident investigation · Final report · Mar 9, 1989 · N217US · No damage
  > An excessively worn outflow valve in the cabin evironmental/pressurization system that resulted in a rapid cabin depressurization.
- [NTSB ANC89LA052](https://openairdocs.org/ntsb/ANC89LA052.md): Cessna 185E · Alexander Lake, AK · Accident · No injuries · Limited investigation · Final report · Mar 9, 1989 · N70122 · Substantial damage
  > The pilot's improper in-flight planning, decisions which resulted in exceeding the amount of fuel available which resulted in fuel exhaustion.
- [NTSB NYC89FAMS2](https://openairdocs.org/ntsb/NYC89FAMS2.md): Piper PA-32-300 · Missing (Atlantic Ocean) · Accident · 1 fatal · Missing aircraft · Final report · Mar 8, 1989 · N5899F · Destroyed
  > Loss of engine power for an unknown reason.
- [NTSB LAX89DVD03](https://openairdocs.org/ntsb/LAX89DVD03.md): Stearns BD-4 · Leggett, CA · Accident · 2 fatal · Final report · Mar 8, 1989 · N277MB · Destroyed
  > The pilot's continuation of VFR flight into instrument meteorological conditions (IMC), and his failure maintain proper altitude. Factors related to the accident were the adverse weather conditions, high terrain, and trees.
- [NTSB DEN89FA083](https://openairdocs.org/ntsb/DEN89FA083.md): Craven'S Quickie Q2 · Watkins, CO · Accident · 4 fatal · Field investigation · Final report · Mar 8, 1989 · N3278C · 2 aircraft · Destroyed
  > Failure of both pilot's to maintain visual lookout.
- [NTSB SEA89LA054](https://openairdocs.org/ntsb/SEA89LA054.md): Cessna 185 · Bellingham, WA · Accident · No injuries · Limited investigation · Final report · Mar 5, 1989 · N79PK · Substantial damage
  > The pilot's failure to compensate for the loss of lift due to ice accumulation on the wings, his failure to control the rate of descent, and poor inflight decision making. Contributing to the accident was the pilot's fatigue.
- [NTSB LAX89FA120](https://openairdocs.org/ntsb/LAX89FA120.md): Cessna 170B · Casa Grande, AZ · Accident · 4 fatal · Field investigation · Final report · Mar 5, 1989 · N2766C · 2 aircraft · Destroyed
  > The pilot in command's performance of aerobatic maneuvers, while flying in formation, and his failure to maintain proper clearance.
- [NTSB ATL89LA096](https://openairdocs.org/ntsb/ATL89LA096.md): Cessna 152 · Blountville, TN · Accident · Minor injuries · Limited investigation · Final report · Mar 5, 1989 · N25524 · Substantial damage
  > Carburetor ice. The pilot failed to apply carburetor heat in a timely and adequate manner. This failure resulted in the accumulation of ice to a point of failure of the engine which eliminated the heat necessary to remove the ice.
- [NTSB SEA89FA053](https://openairdocs.org/ntsb/SEA89FA053.md): Piper PA-60-601P · Lakeview, OR · Accident · 3 fatal · Field investigation · Final report · Mar 4, 1989 · CFHGH · Destroyed
  > Failure of the pilot to maintain control of the aircraft, which resulted in a spin and an uncontrolled descent. Factors related to the accident were: improper maintenence by the pilot, an autopilot malfunction, the adverse weather conditions, continued flight…
- [NTSB MKC89LA072](https://openairdocs.org/ntsb/MKC89LA072.md): Cessna 310 · Cedar Rapids, IA · Accident · No injuries · Limited investigation · Final report · Mar 4, 1989 · N98934 · Substantial damage
  > The proper touchdown point was not attained by the pilot and the crankshaft failure on one engine. Contributing to the accident were the weather conditions and the approach lights which were contacted.
- [NTSB ATL89FA095](https://openairdocs.org/ntsb/ATL89FA095.md): Beech 95-B55 · St Marys Island, GA · Accident · 1 fatal · Field investigation · Final report · Mar 4, 1989 · N9299Q · Destroyed
  > The pilot continued into IMC conditions where he collided with trees.
- [NTSB BFO89FA019](https://openairdocs.org/ntsb/BFO89FA019.md): Beech V35TC · Roanoke, VA · Accident · 1 fatal · Field investigation · Final report · Mar 3, 1989 · N27FH · Destroyed
  > The pilot failed to maintain control of the aircraft due to spatial disorientation.
- [NTSB NYC89FA093](https://openairdocs.org/ntsb/NYC89FA093.md): Piper PA-31-350 · Toms River, NJ · Accident · No injuries · Field investigation · Final report · Mar 2, 1989 · N40978 · Substantial damage
  > Failure of the pilot to maintain airspeed and control of the aircraft, and his exceeding the design stress limits of the aircraft. Factors related to the accident were: autoplt malfunction due to improper installation by maintenance personnel and the pilot's…
- [NTSB BFO89LA023](https://openairdocs.org/ntsb/BFO89LA023.md): Mitsubishi MU-2B-20F · San Diego, CA · Accident · 1 fatal · Limited investigation · Final report · Feb 28, 1989 · N701DM · Destroyed
  > Pilot incapacitation for an unknown reason.
- [NTSB NYC89LA091](https://openairdocs.org/ntsb/NYC89LA091.md): Piper PA-24-400 · Delmont, NJ · Accident · No injuries · Limited investigation · Final report · Feb 27, 1989 · N8471P · Substantial damage
  > Failure of the #6 connecting rod.
- [NTSB FTW89LA059](https://openairdocs.org/ntsb/FTW89LA059.md): Cessna 182A · Temple, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 26, 1989 · N5010D · Substantial damage
  > Improper planning/decision, by the pilot which resulted in fuel exhaustion, due to an inadequate supply o fuel.
- [NTSB MKC89LA065](https://openairdocs.org/ntsb/MKC89LA065.md): Composite Aircraft Mfg Cozy · Hudson, IA · Accident · No injuries · Limited investigation · Final report · Feb 25, 1989 · N611CZ · Substantial damage
  > Improper preflight by the pilot which resulted in an inadequate fuel supply and fuel exhaustion.
- [NTSB MKC89LA064](https://openairdocs.org/ntsb/MKC89LA064.md): Cessna 172B · Unionville, IA · Accident · No injuries · Limited investigation · Final report · Feb 25, 1989 · N7662X · Substantial damage
  > The failure of the engine due to carburetor ice. Contributing factors included carburetor icing conditions, improper use of the carburetor heat control by the pilot, and the improperly rigged carburetor air box which resulted in reduced carburetor heating…
- [NTSB MKC89FA063](https://openairdocs.org/ntsb/MKC89FA063.md): Piper PA-18 · Jacksonville, AR · Accident · 2 fatal · Field investigation · Final report · Feb 25, 1989 · N7580D · Destroyed
  > Severe corrosion of the left forward wing lift strut which resulted in the in-flight separation of the left wing. A contributing factor was inadequacy of the applicable service bulletin.
- [NTSB MIA89IA095](https://openairdocs.org/ntsb/MIA89IA095.md): Cessna 172N · Homestead, FL · Incident · No injuries · Incident investigation · Final report · Feb 25, 1989 · N734MC · No damage
  > Fuel starvation caused by a sticking needle valve which was softened by contact with automotive fuel previously used to operate the engine.
- [NTSB MIA89FA093](https://openairdocs.org/ntsb/MIA89FA093.md): Piper PA-28R-200 · Inverness, FL · Accident · Serious injuries · Field investigation · Final report · Feb 25, 1989 · N43330 · Destroyed
  > The failure of the propeller governor oil line due to fatigue which was caused by bending damage to the line and the failure of mechanics to install support clamps on the line which caused the fatigue to propagate at a faster rate.
- [NTSB DCA89MA027](https://openairdocs.org/ntsb/DCA89MA027.md): Boeing 747-122 · Honolulu, HI · Accident · 9 fatal · Class 1 · Major · Final report · Feb 24, 1989 · N4713U · Substantial damage
  > The sudden opening of the improperly latched forward lobe cargo door in flight and the subsequent explosive decompression. Contributing to the accident was a deficiency in the design of the cargo door locking mechanisms, which made them susceptible to…
- [NTSB SEA89FA050](https://openairdocs.org/ntsb/SEA89FA050.md): Mooney M20K · Incline Village, NV · Accident · Minor injuries · Field investigation · Final report · Feb 23, 1989 · N94276 · Destroyed
  > The pilot's improper use of the fuel system when troubleshooting surging fuel pressure. A contributing factor was snow conditions which impaired the pilot's ability to make a proper forced landing.
- [NTSB NYC89LA096](https://openairdocs.org/ntsb/NYC89LA096.md): Bell 206B · Harding Twnp, NJ · Accident · No injuries · Limited investigation · Final report · Feb 23, 1989 · N5754J · Substantial damage
  > The pilots attempt to conduct the flight with less than required fuel resulting in loss of engine power and subsequent damage to the helicopter while performing an autorotative landing.
- [NTSB MKC89LA062](https://openairdocs.org/ntsb/MKC89LA062.md): Cessna 152 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Feb 23, 1989 · N25909 · Substantial damage
  > Improper use of the carburetor heat control by pilot in command.
- [NTSB FTW89LA056](https://openairdocs.org/ntsb/FTW89LA056.md): Mcculloch J-2 · Orange, TX · Accident · No injuries · Limited investigation · Final report · Feb 23, 1989 · N4381G · Substantial damage
  > The pilot failed to maintain rotor RPM due to a lack of familiarity with aircraft performance data and procedures.
- [NTSB FTW89FA055](https://openairdocs.org/ntsb/FTW89FA055.md): Piper J3C-65 · Mount Vernon, TX · Accident · 2 fatal · Field investigation · Final report · Feb 23, 1989 · N494CB · Destroyed
  > Inadequate maintenance and inspection of the airplane by the mechanics who rebuilt the airplane, in that they failed to detect and/or correct the corroded lift strut which resulted in wing failure.
- [NTSB NYC89FA088](https://openairdocs.org/ntsb/NYC89FA088.md): Sikorsky S-76A · Washington, PA · Accident · Serious injuries · Field investigation · Final report · Feb 22, 1989 · N767SA · Substantial damage
  > The pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) which resulted in his loss of aircraft control. Factors related to the accident was: the pilot's flight into known weather, the adverse weather, and trees at the accident sight.
- [NTSB DEN89LA079](https://openairdocs.org/ntsb/DEN89LA079.md): Aeronca 7AC · Wolf Point, MT · Accident · No injuries · Limited investigation · Final report · Feb 22, 1989 · N4627E · Substantial damage
  > The failure of the student pilot to use carburetor heat in a timely manner which resulted in a partial loss of engine power. Contributing to the accident was the inadequate weather evaluation the pilot made after taking off and flying through fog due to his…
- [NTSB FTW89IA053](https://openairdocs.org/ntsb/FTW89IA053.md): Mcdonnell Douglas DC-9-32 · Houston, TX · Incident · Minor injuries · Incident investigation · Final report · Feb 21, 1989 · N1289L · Minor damage
  > The turbine guide vane failure.
- [NTSB ATL89FA090](https://openairdocs.org/ntsb/ATL89FA090.md): Piper PA-28R-200 · Tipp City, OH · Accident · Serious injuries · Field investigation · Final report · Feb 21, 1989 · N1139X · Destroyed
  > Improper planning by the pilot resulting in fuel exhaustion. The pilots lack of equipment and ability to handle the weather situation was ignored by the pilot in his planning for the flight.
- [NTSB MIA89FA090](https://openairdocs.org/ntsb/MIA89FA090.md): Cessna 172 · Blue Mountain, MS · Accident · 2 fatal · Field investigation · Final report · Feb 20, 1989 · N3937F · Destroyed
  > The continuation of a VFR flight into night, instrument meteorological conditions and the spatial disorientation of the non-instrument rated pilot. Contributing to the accident were the adverse weather conditions and the overconfidence of the pilot.
- [NTSB NYC89FA086](https://openairdocs.org/ntsb/NYC89FA086.md): Beech A36 · Glen Falls, NY · Accident · 6 fatal · Field investigation · Final report · Feb 19, 1989 · N1DQ · 2 aircraft · Destroyed
  > Failure of both pilots to see-and-avoid each other. Related factors were: failure of the Beech aircrew to make a normal left turn out of traffic and the Stinson pilot's visual perception due to sunglare.
- [NTSB LAX89LA131](https://openairdocs.org/ntsb/LAX89LA131.md): Aerostar Raven 560 · Tucson, AZ · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 1989 · N767AA · No damage
  > Balloon entered into a severe down draft which resulted in a hard landing due to inadequate preparation and compensation for the conditions by the balloon pilot.
- [NTSB DCA89MA026](https://openairdocs.org/ntsb/DCA89MA026.md): Cessna 402B · Corona, CA · Accident · 10 fatal · Major investigation · Final report · Feb 19, 1989 · N69383 · Destroyed
  > The pilot's failure to properly preflight and plan for flight and his intentional flight into IMC conditions. Factors contributing to the accident were the low ceiling conditions in conjunction with the mountainous terrain.
- [NTSB ATL89LA091](https://openairdocs.org/ntsb/ATL89LA091.md): Cessna 170B · Cleveland, TN · Accident · No injuries · Limited investigation · Final report · Feb 18, 1989 · N8032A · Substantial damage
  > Flight into known adverse weather by the pilot and his delay in diverting to an alternate airport which led to a partial power loss and an emergency landing. The weather conditions and soft terrain were contributing factors.
- [NTSB FTW89LA051](https://openairdocs.org/ntsb/FTW89LA051.md): Piper PA-32-260 · Conroe, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1989 · N3976W · Substantial damage
  > Failure of the engine crankshaft due to fatigue. The low ceiling, dark night, and trees in the emergency landing area were factors.
- [NTSB SEA89LA049](https://openairdocs.org/ntsb/SEA89LA049.md): Piper PA28-140 · Beaver Marsh, OR · Accident · No injuries · Limited investigation · Final report · Feb 15, 1989 · N95286 · Substantial damage
  > An loss of engine power due to a failed exhaust valve. Contributing to the accident was the snow covered terrain on which a precautionary landing was made.
- [NTSB NYC89IA084](https://openairdocs.org/ntsb/NYC89IA084.md): Beech 200 · Burlington, VT · Incident · No injuries · Incident investigation · Final report · Feb 15, 1989 · N123D · No damage
  > Improper preflight which resulted in a frozen elevator surface.
- [NTSB LAX89FA111](https://openairdocs.org/ntsb/LAX89FA111.md): Cessna 340A · Safford, AZ · Accident · 1 fatal · Field investigation · Final report · Feb 15, 1989 · N8814K · Destroyed
  > The pilot's poor judgement and the resultant hypoxia sustained in the unpressurized airplane. Factors were: the malfunctioning pressurization system and the pilot's decision to continue operation with that known discrepancy.
- [NTSB LAX89LA119](https://openairdocs.org/ntsb/LAX89LA119.md): Piper PA-31-350 · Pacific Ocean (Pacific Ocean) · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 1989 · N41169 · Destroyed
  > Loss of oil pressure due to unknown circumstances. Contributing to the cause of the accident was the overweight condition of the airplane necessitated by overwater fuel requirements.
- [NTSB LAX89IA112](https://openairdocs.org/ntsb/LAX89IA112.md): British Aerospace BAE 146-200A · Los Alamitos, CA · Incident · No injuries · Incident investigation · Final report · Feb 14, 1989 · N141AC · No damage
  > Inadequate coordination among the ATC controllers which resulted in their failure to maintain adequate radar separation of the two aircraft.

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

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

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