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

## Cases, newest first

- [NTSB ATL02LA134](https://openairdocs.org/ntsb/ATL02LA134.md): Fay Velocity Elite · Theodore, AL · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2002 · N2214W · Substantial damage
  > The pilot's inadequate inflight planning for required fuel resulted in fuel exhaustion and the subsequent loss of engine power. A factor was unsuitable terrain.
- [NTSB DEN02LA061](https://openairdocs.org/ntsb/DEN02LA061.md): Cessna 180 · Tucumcari, NM · Accident · No injuries · Limited investigation · Final report · Jun 26, 2002 · N2443C · Substantial damage
  > the pilot's failure to position the fuel selector to the proper tank resulting in fuel starvation and the subsequent loss of engine power. Factors contributing to the accident were the pilot's failure to use the checklist and the lack of suitable terrain for…
- [NTSB CHI02FA177](https://openairdocs.org/ntsb/CHI02FA177.md): Piper PA-28R-200 · Steward, IL · Accident · No injuries · Field investigation · Final report · Jun 26, 2002 · N76SA · Substantial damage
  > A loss of engine power due to the fatigue failure of several number three cylinder through bolts and case studs, which resulted in the separation of the number three engine cylinder. A factor contributing to the accident was the rough terrain.
- [NTSB ANC02LA069](https://openairdocs.org/ntsb/ANC02LA069.md): Piper PA-32-300 · Kake, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 2002 · N2947N · Substantial damage
  > The in-flight separation of the upper engine cowling from the airplane. A factor contributing to the accident was the soft, sandy terrain of the landing area.
- [NTSB NYC02LA122](https://openairdocs.org/ntsb/NYC02LA122.md): Cessna 182B · Ellington, CT · Accident · No injuries · Limited investigation · Final report · Jun 24, 2002 · N2516G · Substantial damage
  > The pilot's misjudged distance/altitude during an emergency landing, which resulted in an undershoot and subsequent forced landing to a cornfield. A factor was the pilot's inadequate preflight planning, which resulted in fuel starvation.
- [NTSB ANC02LA058](https://openairdocs.org/ntsb/ANC02LA058.md): Cessna 150 · South Naknek, AK · Accident · Serious injuries · Limited investigation · Final report · Jun 24, 2002 · N3025X · Substantial damage
  > The pilot's failure to refuel the airplane resulting in fuel exhaustion in cruise flight, and his inadvertently stalling the airplane during the ensuing emergency landing.
- [NTSB IAD02LA063](https://openairdocs.org/ntsb/IAD02LA063.md): Murawski Pulsar · Bentleyville, PA · Accident · No injuries · Limited investigation · Final report · Jun 23, 2002 · N5123B · Substantial damage
  > Failure of the MAG cylinder rod bearing, which resulted in a loss of engine power. A factor in the damage to the airplane was the terrain condition of the forced landing field.
- [NTSB FTW02LA187](https://openairdocs.org/ntsb/FTW02LA187.md): Lidster Wittman Tailwind W-8 · Mesquite, TX · Accident · 1 fatal · Limited investigation · Final report · Jun 23, 2002 · N14VK · Destroyed
  > The in-flight separation of the outboard portion of the left wing due to the failure of the wing spar resulting from the builder's improper installation of a wing that did not meet the drawing specifications.
- [NTSB FTW02LA190](https://openairdocs.org/ntsb/FTW02LA190.md): Beech BE-300 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Jun 22, 2002 · N224CR · Substantial damage
  > The pilot's inadequate preflight of the airplane resulting in the in-flight separation of the left engine inboard access door.
- [NTSB ATL02LA129](https://openairdocs.org/ntsb/ATL02LA129.md): Eames Acro Sport · Burlington, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 2002 · N16SE · Substantial damage
  > A total loss of engine power due to fuel starvation. This resulted in a forced landing and subsequent hard landing while maneuvering around trees.
- [NTSB SEA02LA116](https://openairdocs.org/ntsb/SEA02LA116.md): Beech G35 · Yakima, WA · Accident · No injuries · Limited investigation · Final report · Jun 21, 2002 · N4647D · Substantial damage
  > Empennage flutter which resulted in structural damage during descent for landing. Turbulence was a factor.
- [NTSB SEA02FA108](https://openairdocs.org/ntsb/SEA02FA108.md): Garlick UH-1H · Clark Fork, ID · Accident · 1 fatal · Field investigation · Final report · Jun 21, 2002 · N114DR · Substantial damage
  > A failure of unknown origin in the tail rotor drive assembly. Factors include mountainous terrain unsuitable for an emergency landing.
- [NTSB CHI02FA174](https://openairdocs.org/ntsb/CHI02FA174.md): Eurocopter France AS-350-B2 · Norfolk, NE · Accident · 3 fatal · Field investigation · Final report · Jun 21, 2002 · N852HW · Substantial damage
  > A loss of tail rotor effectiveness and the pilot's failure to maintain control of the helicopter. Factors associated with the accident were the binding of the tail rotor pitch changed rod, the gusty wind conditions, and the pilot’s lack of total experience in…
- [NTSB SEA02LA095](https://openairdocs.org/ntsb/SEA02LA095.md): Cessna 441 · Medford, OR · Accident · No injuries · Limited investigation · Final report · Jun 19, 2002 · N564AC · Substantial damage
  > The overstress failure, for undetermined reasons, of the right main landing gear pivot pin roll pin, leading to the misalignment of the gear trunnion and the collapse of the right main gear during the landing roll.
- [NTSB FTW02LA185](https://openairdocs.org/ntsb/FTW02LA185.md): Quinn RV-6A · El Paso, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 2002 · N799RQ · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ANC02IA093](https://openairdocs.org/ntsb/ANC02IA093.md): Piper PA-31-350 · Talkeetna, AK · Incident · Serious injuries · Incident investigation · Final report · Jun 18, 2002 · N828KT · No damage
  > The passenger's incapacitation during a high altitude flight due to a loss of consciousness as the result of a pre-existing cardiovascular condition. A contributing factor in the incident was the operator's improper use of disposable oxygen masks without a…
- [NTSB FTW02LA183](https://openairdocs.org/ntsb/FTW02LA183.md): Beech V35A · Leslie, AR · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 2002 · N800MD · Substantial damage
  > The loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI02LA167](https://openairdocs.org/ntsb/CHI02LA167.md): Cessna 172G · Butler, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 2002 · N5953R · Substantial damage
  > The fuel exhaustion, the inadequate fuel consumption calculations by the pilot, and the inadequate in-flight planning/decision by the pilot. The unsuitable terrain encountered during the forced landing is a contributing factor.
- [NTSB DEN02LA055](https://openairdocs.org/ntsb/DEN02LA055.md): Cessna 175 · Salt Lake City, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2002 · N7338M · Destroyed
  > total mechanical loss of engine power for reasons undetermined. Contributing factors were the lack of an annual inspection and the (forced landing in) salt water.
- [NTSB MIA02FA111](https://openairdocs.org/ntsb/MIA02FA111.md): Piper PA-46-310P · Osteen, FL · Accident · 3 fatal · Field investigation · Final report · Jun 15, 2002 · N9143B · Destroyed
  > the pilot's inadequate weather evaluation and his failure to maintain control of the airplane after entering an area of thunderstorms resulting in an in-flight separation of the right wing and right horizontal stabilizer and impact with the ground during an…
- [NTSB CHI02LA165](https://openairdocs.org/ntsb/CHI02LA165.md): Firm Kit Fox 4-1200 · Virginia, MN · Accident · No injuries · Limited investigation · Final report · Jun 15, 2002 · N598HL · Destroyed
  > An in-flight collision with a bird that resulted in severed fuel lines and the subsequent in-flight fire and loss of engine power. A factor in the accident was the soft terrain condition.
- [NTSB MIA02LA110](https://openairdocs.org/ntsb/MIA02LA110.md): Harrison Pietenpol Air Camper · Bainbridge, GA · Accident · 1 fatal · Limited investigation · Final report · Jun 13, 2002 · N7224X · Destroyed
  > a loss of power due to the passenger's inadvertent deactivation and restricting the movement of the throttle, which resulted in a forced landing and subsequent impact with trees.
- [NTSB MIA02TA109](https://openairdocs.org/ntsb/MIA02TA109.md): Agusta A119 · Okeechobee, FL · Accident · No injuries · Final report · Jun 12, 2002 · N911SL · Substantial damage
  > the fracture of one of the tail rotor blades as a result of fatigue cracking in the blade spar, and subsquent impact of the main rotor with the tailboom.
- [NTSB DEN02LA053](https://openairdocs.org/ntsb/DEN02LA053.md): Cessna 172F · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Jun 12, 2002 · N7873U · Substantial damage
  > the pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A factor contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB NYC02LA112](https://openairdocs.org/ntsb/NYC02LA112.md): Cessna 182RG · Worcester, MA · Accident · No injuries · Limited investigation · Final report · Jun 11, 2002 · N4652T · Substantial damage
  > The failure of the nose wheel actuator o-ring.
- [NTSB DEN02TA052](https://openairdocs.org/ntsb/DEN02TA052.md): Beech 58P · Grand Junction, CO · Accident · No injuries · Final report · Jun 10, 2002 · N123Z · Substantial damage
  > the pilot's inadvertent flight into adverse weather conditions. A factor contributing to the accident was the terrain-induced turbulence.
- [NTSB CHI02FA233](https://openairdocs.org/ntsb/CHI02FA233.md): Piper PA-28-180 · Macomb, MI · Accident · No injuries · Field investigation · Final report · Jun 9, 2002 · N56136 · Substantial damage
  > The cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.
- [NTSB LAX02FA191](https://openairdocs.org/ntsb/LAX02FA191.md): Piper PA-23-160 · Rio Rico, AZ · Accident · 3 fatal · Field investigation · Final report · Jun 8, 2002 · N4302P · Destroyed
  > a loss of engine power in the left engine for undetermined reasons, and the failure of the flying pilot to maintain an adequate single engine minimum control airspeed and aircraft control. Also causal was the decision of all three of the pilots to continue…
- [NTSB LAX02FA188](https://openairdocs.org/ntsb/LAX02FA188.md): Fisher Celebrity · Chandler, AZ · Accident · 2 fatal · Field investigation · Final report · Jun 8, 2002 · N8205H · Destroyed
  > failure of the wing spars and the in-flight separation of the aircraft wing due to the builder's inadequate manufacture of this experimental aircraft. Also causal was the current owner/pilot's continued flight with known mechanical discrepancies.
- [NTSB FTW02LA177](https://openairdocs.org/ntsb/FTW02LA177.md): Bell 47G-3B-1 · Nederland, CO · Accident · No injuries · Limited investigation · Final report · Jun 8, 2002 · N999DW · Substantial damage
  > the pilot's inadvertent in-flight encounter with severe turbulence, which resulted in main rotor-tailboom contact and the separation of the tailrotor drive shaft.
- [NTSB LAX02FA200](https://openairdocs.org/ntsb/LAX02FA200.md): Grumman American AA-5B · Santa Paula, CA · Accident · 2 fatal · Field investigation · Final report · Jun 7, 2002 · N13GT · Destroyed
  > the pilot's attempted VFR flight into instrument conditions and failure to maintain clearance with the terrain.
- [NTSB DEN02FA050](https://openairdocs.org/ntsb/DEN02FA050.md): Beech M35 · Briggsdale, CO · Accident · 1 fatal · Field investigation · Final report · Jun 7, 2002 · N9775R · Destroyed
  > controlled descent into terrain for reasons undetermined.
- [NTSB CHI02LA161](https://openairdocs.org/ntsb/CHI02LA161.md): Cessna R182 · Harvard, IL · Accident · No injuries · Limited investigation · Final report · Jun 7, 2002 · N756TK · Substantial damage
  > The pilot's failure to verify the extension of the landing gear. Factors were the alternator failure, and the main landing gear down locks not engaged.
- [NTSB MIA02LA107](https://openairdocs.org/ntsb/MIA02LA107.md): Cessna P206 · Manteo, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 2002 · N2594X · Substantial damage
  > a total loss of engine power due to the failure of a connecting rod bolt because of fatigue, resulting in damage to the airplane during the subsequent ditching.
- [NTSB IAD02IA057](https://openairdocs.org/ntsb/IAD02IA057.md): Fairchild Dornier DO-328-300 · Cinncinnati, OH · Incident · No injuries · Incident investigation · Final report · Jun 6, 2002 · N413FJ · No damage
  > The partial loss of flight displays for undetermined reasons.
- [NTSB MIA02FA106](https://openairdocs.org/ntsb/MIA02FA106.md): Helicopters & Exec 162F · Tampa, FL · Accident · Minor injuries · Field investigation · Final report · Jun 4, 2002 · N268MA · Substantial damage
  > The pilot's intentional operation of the helicopter while impaired by alcohol and a drug (zolpidem) resulting in the in-flight collision with a house.
- [NTSB MIA02FA104](https://openairdocs.org/ntsb/MIA02FA104.md): Cessna 172S · Lutz, FL · Accident · 1 fatal · Field investigation · Final report · Jun 4, 2002 · N942SP · Destroyed
  > The suicidal act by the pilot resulting in the in-flight collision with trees then the ground. A contributing factor in the accident was the pilot's depression. Findings in the investigation were the pilot's overdose of zolpidem and citalopram before the…
- [NTSB LAX02LA182](https://openairdocs.org/ntsb/LAX02LA182.md): Cessna 172M · Mountain Ranch, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 4, 2002 · N61569 · Substantial damage
  > the pilot's inadequate preflight planning/preparation and his in-flight planning/decision resulting in fuel exhaustion and loss of engine power.
- [NTSB CHI02IA151](https://openairdocs.org/ntsb/CHI02IA151.md): McDonnell Douglas MD-82 · Wichita, KS · Incident · No injuries · Incident investigation · Final report · Jun 4, 2002 · N823NK · No damage
  > The flightcrew's failure to verify the engine instrument indications and powerplant controls while on autopilot with the autothrottles engaged, and their failure to recognize the drop in airspeed which led to an aerodynamic stall associated with the reduction…
- [NTSB LAX02LA180](https://openairdocs.org/ntsb/LAX02LA180.md): Cessna 172N · Alhambra, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 2002 · N6629E · Substantial damage
  > the pilot's miscalculated fuel consumption, failure to verify the fuel supply on board, and his failure to refuel the airplane prior to takeoff, which resulted in fuel exhaustion.
- [NTSB DCA02MA039](https://openairdocs.org/ntsb/DCA02MA039.md): McDonnell Douglas MD-11 · Subic Bay, Philippines · Accident · No injuries · Major investigation · Final report · Jun 3, 2002 · N588FE · Substantial damage
  > The momentary operation of the airplane outside of the airplane's aerodynamic design stall buffet boundary that resulted from the captain's initiation of a Ground Proximity Warning System (GPWS) escape maneuver. Factor's contributing to the accident were the…
- [NTSB NYC02LA110](https://openairdocs.org/ntsb/NYC02LA110.md): Boeing 757-232 · Fairfield, IL · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 2002 · N694DL · No damage
  > The first officer's abrupt level off.
- [NTSB DEN02LA049](https://openairdocs.org/ntsb/DEN02LA049.md): Piper PA-28R-201 · Beaver, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 2002 · N171M · Substantial damage
  > the pilot's selection of unsuitable terrain on which to make a forced landing. Contributing factors were mountain waves (wind shear) and crosswind.
- [NTSB ANC02FA042](https://openairdocs.org/ntsb/ANC02FA042.md): Piper PA-18-150 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jun 1, 2002 · N6969H · Substantial damage
  > The pilot's selection of a fuel tank that did not contain a usable quantity of fuel. Factors associated with the accident are the dirt berm, meteorological conditions conducive to carburetor icing, and carburetor ice.
- [NTSB CHI02LA150](https://openairdocs.org/ntsb/CHI02LA150.md): Piper PA-24-250 · Sparta, IL · Accident · No injuries · Limited investigation · Final report · May 31, 2002 · N5360P · Substantial damage
  > The total loss of engine power due to a separated cylinder and the failure of the pilot to perform a precautionary landing at the nearest suitable airport when the engine had a partial loss of engine power. The failure of the aircraft owners to perform an…
- [NTSB SEA02FA091](https://openairdocs.org/ntsb/SEA02FA091.md): Sikorsky CH-19E · Plains, MT · Accident · Minor injuries · Field investigation · Final report · May 30, 2002 · N94475 · Substantial damage
  > Power loss for undetermined reasons.
- [NTSB NYC02FA106](https://openairdocs.org/ntsb/NYC02FA106.md): Cessna A185F · Pleasant Mount, PA · Accident · 2 fatal · Field investigation · Final report · May 30, 2002 · N1577B · Destroyed
  > The pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control, resulting in overstress of the aircraft. A factor was the thunderstorm activity.
- [NTSB LAX02LA181](https://openairdocs.org/ntsb/LAX02LA181.md): Cessna 182P · Roosevelt, AZ · Accident · No injuries · Limited investigation · Final report · May 30, 2002 · N79107 · Substantial damage
  > Failure of the pilot to maintain aircraft control during the landing rollout after making a precautionary landing precipitated by an electrical system failure.
- [NTSB MIA02FA102](https://openairdocs.org/ntsb/MIA02FA102.md): Beech F33A · Conway, SC · Accident · 1 fatal · Field investigation · Final report · May 29, 2002 · N858KS · Destroyed
  > The failure of the pilot to request in-flight weather avoidance assistance and his poor in-flight planning/decision for flying into a Level 5 thunderstorm resulting in an in-flight loss of control, uncontrolled descent, and subsequent in-flight collision with…
- [NTSB IAD02LA053](https://openairdocs.org/ntsb/IAD02LA053.md): Beech V35A · Martinsburg, WV · Accident · Minor injuries · Limited investigation · Final report · May 29, 2002 · N45RG · Substantial damage
  > Inadequate torque of the crankcase through bolts.

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

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

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