# NTSB investigations: Initial climb

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 89 of 412 · 20,559 cases

## Cases, newest first

- [NTSB ATL00LA095](https://openairdocs.org/ntsb/ATL00LA095.md): William J. Knowles KNOWLES-THORP KT-18 · Opa-Locka, FL · Accident · 2 fatal · Limited investigation · Final report · Sep 30, 2000 · N37BK · Destroyed
  > The pilot's failure to maintain flying airspeed during initial climb, resulting in an inadvertent stall/spin.
- [NTSB SEA00LA190](https://openairdocs.org/ntsb/SEA00LA190.md): Piper PA-28-140 · Miles City, MT · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 2000 · N4686R · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ATL00LA096](https://openairdocs.org/ntsb/ATL00LA096.md): Piper PA-28-140 · Deland, FL · Accident · No injuries · Limited investigation · Final report · Sep 21, 2000 · N5530F · Substantial damage
  > A partial loss of engine power during initial climb following takeoff, due to the restricted movement of the number two cylinder's exhaust valve.
- [NTSB IAD00LA084](https://openairdocs.org/ntsb/IAD00LA084.md): Cessna 150G · Conesus, NY · Accident · No injuries · Limited investigation · Final report · Sep 19, 2000 · N8376J · Substantial damage
  > the pilot's inadequate preflight performance planning.
- [NTSB FTW00LA264](https://openairdocs.org/ntsb/FTW00LA264.md): Beech H35 · Wagoner, OK · Accident · No injuries · Limited investigation · Final report · Sep 17, 2000 · N5448D · Substantial damage
  > The loss of engine power during the takeoff initial climb, for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA00LA263](https://openairdocs.org/ntsb/MIA00LA263.md): Grumman AA-5 · Zephyrhills, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 2000 · N7196L · Substantial damage
  > the intentional stall/mush by the pilot-in-command due to obstructions ahead resulting in a hard landing. Contributing to the accident was the partial loss of engine power due to fuel starvation caused by wear, fatigue, then overstress separation of the…
- [NTSB LAX00LA336](https://openairdocs.org/ntsb/LAX00LA336.md): Piper PA-28-161 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Sep 15, 2000 · N381AS · Substantial damage
  > Loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available for a straight ahead landing during the takeoff initial climb.
- [NTSB NYC00LA262](https://openairdocs.org/ntsb/NYC00LA262.md): Cessna 150L · Salem, OH · Accident · No injuries · Limited investigation · Final report · Sep 14, 2000 · N10825 · Substantial damage
  > A partial power loss for undetermined reasons.
- [NTSB ANC00LA135](https://openairdocs.org/ntsb/ANC00LA135.md): Champion 7GCBC · Sparrevohn, AK · Accident · No injuries · Limited investigation · Final report · Sep 14, 2000 · N9654S · Substantial damage
  > The pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable winds, and a crosswind.
- [NTSB SEA00LA176](https://openairdocs.org/ntsb/SEA00LA176.md): Cessna 150H · Ontario, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 2000 · N22237 · Substantial damage
  > The pilot-in-command/flight instructor's failure to adequately refuel the aircraft, resulting in fuel exhaustion, and his subsequent high flare in a forced landing attempt, resulting in a stall and touchdown/impact on the nose gear.
- [NTSB LAX00LA350](https://openairdocs.org/ntsb/LAX00LA350.md): Worgull Hornet · Camp Verde, AZ · Accident · No injuries · Limited investigation · Final report · Sep 11, 2000 · N707BD · Substantial damage
  > Separation of the forward spark plug due to wear damage to the cylinder head threads. A factor in the accident was traffic on the highway and the pilot having to maneuver to avoid the traffic.
- [NTSB DEN00FA169](https://openairdocs.org/ntsb/DEN00FA169.md): Piper PA-28-180 · Englewood, CO · Accident · Serious injuries · Field investigation · Final report · Sep 11, 2000 · N2190R · Destroyed
  > the pilot's failure to maintain aircraft control, which resulted in a collision with terrain. A contributing factor was the high-density altitude weather condition.
- [NTSB ANC00LA119](https://openairdocs.org/ntsb/ANC00LA119.md): Piper PA-18 · Sleetmute, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 2000 · N9692P · Substantial damage
  > The loss of aircraft control precipitated by the pilot's inadvertent stall. Factors associated with the accident are the disengagement of the stabilizer trim system, which resulted in reduced aircraft control, an inadvertent stall by the pilot, and a large…
- [NTSB FTW00LA255](https://openairdocs.org/ntsb/FTW00LA255.md): Mooney M20 · Owasso, OK · Accident · No injuries · Limited investigation · Final report · Sep 10, 2000 · N866B · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI00LA294](https://openairdocs.org/ntsb/CHI00LA294.md): Beech B24 · Necedah, WI · Accident · No injuries · Limited investigation · Final report · Sep 10, 2000 · N4342W · Substantial damage
  > The pilot did not properly flare the airplane during the aborted takeoff and he failed to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the partial power loss for undetermined reasons and the…
- [NTSB LAX00LA332](https://openairdocs.org/ntsb/LAX00LA332.md): Cessna 120 · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 2000 · N76261 · Substantial damage
  > The pilot's inadequate preflight planning and his improper use of carburetor heat that resulted in a loss of engine power due to carburetor icing following a delayed takeoff in conditions that were conducive to carburetor icing. A factor was the nonsuitable…
- [NTSB NYC00LA261](https://openairdocs.org/ntsb/NYC00LA261.md): Carlson CA-8 · East Palestine, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 2000 · N47XY · Substantial damage
  > Fuel starvation as a result of the pilot's inadequate pre-flight inspection. A factor in this accident was the inadequate marking of the fuel selector valve to clearly indicate a fully open position.
- [NTSB ANC00LA117](https://openairdocs.org/ntsb/ANC00LA117.md): Cessna 180 · Sterling, AK · Accident · No injuries · Limited investigation · Final report · Sep 8, 2000 · N2347C · Substantial damage
  > The pilot's failure to attain clearance from trees during takeoff from a touch-and-go landing. A factor associated with the accident is the pilot's failure to attain a proper touchdown point.
- [NTSB FTW00LA248](https://openairdocs.org/ntsb/FTW00LA248.md): Cessna 150F · Guthrie, OK · Accident · No injuries · Limited investigation · Final report · Sep 4, 2000 · N8783S · Substantial damage
  > The partial loss of engine power due to undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC00FA247](https://openairdocs.org/ntsb/NYC00FA247.md): Piper PA-32-300 · Apple Creek, OH · Accident · 4 fatal · Field investigation · Final report · Sep 2, 2000 · N2102X · Destroyed
  > The pilot's premature liftoff and failure to attain a proper climb rate. Factors related to the accident were the over-gross weight conditions, and the low cloud ceilings.
- [NTSB ANC00LA112](https://openairdocs.org/ntsb/ANC00LA112.md): Piper PA-18 · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 2000 · N10572 · Substantial damage
  > The pilot's inadequate removal of frost from the airplane, and the inadvertent stall during takeoff. A factor was wind gusts.
- [NTSB LAX00FA322](https://openairdocs.org/ntsb/LAX00FA322.md): Piper PA-46-310P · So. Lake Tahoe, CA · Accident · 4 fatal · Field investigation · Final report · Sep 1, 2000 · N88AM · Destroyed
  > The pilot's in-flight loss of control in the takeoff initial climb for undetermined reasons.
- [NTSB CHI00LA289](https://openairdocs.org/ntsb/CHI00LA289.md): Cessna A188B · Nickerson, KS · Accident · No injuries · Limited investigation · Final report · Sep 1, 2000 · N9326R · Substantial damage
  > altidude/clearance not obtained/maintained by the pilot. Factors to the accident were the hay bale, the inadequate preflight planning/preparation by the pilot, the high-density altitude, and the high weight of the aircraft at the time of the accident.
- [NTSB CHI00FA276](https://openairdocs.org/ntsb/CHI00FA276.md): Beech E-55 · Grafton, IL · Accident · 2 fatal · Field investigation · Final report · Aug 30, 2000 · N9047V · Destroyed
  > The pilot not maintaining aircraft control and altitude/clearance from the river. Factors to the accident included the pilot not obtaining an air traffic control clearance prior to departure into instrument meteorological conditions, the pilot becoming…
- [NTSB LAX00TA318](https://openairdocs.org/ntsb/LAX00TA318.md): Bell 206L-1 · Los Angeles, CA · Accident · Minor injuries · Final report · Aug 29, 2000 · N5758H · Substantial damage
  > The probable loss of the main rotor tip weight on the red blade for undetermined reasons resulting in main rotor vibration and oscillation. Sideward movement during the ensuing emergency landing resulted in a dynamic rollover.
- [NTSB SEA00LA170](https://openairdocs.org/ntsb/SEA00LA170.md): Hughes 369E · Coolin, ID · Accident · No injuries · Limited investigation · Final report · Aug 25, 2000 · N570CA · Substantial damage
  > The turbine outlet temperature indicating system was out of calibration. Factors included improper maintenance calibration, which resulted in the over temperature of the turbine assembly.
- [NTSB MIA00LA247](https://openairdocs.org/ntsb/MIA00LA247.md): Cessna 182Q · Fayetteville, TN · Accident · No injuries · Limited investigation · Final report · Aug 25, 2000 · N759CW · Substantial damage
  > the pilot's failure to maintain adequate airspeed during the takeoff/initial climb, which resulted in an inadvertent stall/mush and collision with the runway that resulted in substantial damage to the airplane.
- [NTSB CHI00LA270](https://openairdocs.org/ntsb/CHI00LA270.md): Raven AS-55A · Lincoln, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 2000 · N1073R · Substantial damage
  > The pilot failed to maintain clearance with the power lines. Factors associated with the accident were the pilot's attention was diverted and the power lines which the balloon contacted.
- [NTSB MIA00LA244](https://openairdocs.org/ntsb/MIA00LA244.md): Siai-Marchetti F260B · Meridianville, AL · Accident · No injuries · Limited investigation · Final report · Aug 23, 2000 · N800RH · Substantial damage
  > the pilot's inadequate preflight planning/preparation which resulted in fuel contamination going undetected, which resulted in a forced landing and substantial damage to the aircraft during the emergency landing.
- [NTSB FTW00LA239](https://openairdocs.org/ntsb/FTW00LA239.md): Grumman-Schweizer G-164B · Kaplan, LA · Accident · No injuries · Limited investigation · Final report · Aug 21, 2000 · N6506K · Substantial damage
  > the failure of the supercharger during takeoff. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC00LA233](https://openairdocs.org/ntsb/NYC00LA233.md): Grooms Titan Tornado · Libertytown, MD · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 2000 · N61246 · Substantial damage
  > An engine seizure due to improper reconditioning of piston/cylinder after a previous seizure. A factor was the unsuitable terrain, to which, the forced landing was made.
- [NTSB DEN00LA155](https://openairdocs.org/ntsb/DEN00LA155.md): Trammell Avid Flyer · Trinidad, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 2000 · N7081M · Substantial damage
  > the failure of wing lift strut attachment rod for an unknown reason, which resulted in a loss of aircraft control during initial takeoff climb.
- [NTSB NYC00LA234](https://openairdocs.org/ntsb/NYC00LA234.md): Cessna 152 · Culpeper, VA · Accident · No injuries · Limited investigation · Final report · Aug 19, 2000 · N67495 · Substantial damage
  > The partial loss of power due to an inadequate annual inspection, which resulted in the throttle linkage becoming disconnected from the throttle.
- [NTSB CHI00LA260](https://openairdocs.org/ntsb/CHI00LA260.md): Cessna 150M · Chapin, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2000 · N304JF · Substantial damage
  > the pilot's failure to refuel the aircraft prior to the flight and exhaustion of the fuel supply. A factor to the accident was the embankment.
- [NTSB ANC00LA102](https://openairdocs.org/ntsb/ANC00LA102.md): Piper J-3 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2000 · N88283 · Substantial damage
  > The loss of engine power due to water contamination of the fuel system, the airplane's lack of the required center fuel tank quick drain, and the pilot's inadequate preflight.
- [NTSB NYC00FA229](https://openairdocs.org/ntsb/NYC00FA229.md): Cessna 182RG · Princeton, KY · Accident · 2 fatal · Field investigation · Final report · Aug 16, 2000 · N3674C · Destroyed
  > The pilot's failure to clear trees, for undetermined reasons.
- [NTSB DEN00LA152](https://openairdocs.org/ntsb/DEN00LA152.md): Rosenbarger Lancair IV · Artesia, NM · Accident · No injuries · Limited investigation · Final report · Aug 15, 2000 · N494R · Substantial damage
  > Failure by the pilot in command to maintain control of the aircraft during initial climb following takeoff.
- [NTSB CHI00FA263](https://openairdocs.org/ntsb/CHI00FA263.md): Piper PA-28-161 · Watertown, WI · Accident · 3 fatal · Field investigation · Final report · Aug 15, 2000 · N8126V · Destroyed
  > Aircraft control not being maintained during initial climb resulting in a stall/mush. Factors to the accident were the pilot's inadequate preflight planning/preparation, the pilot operating over the airplane's certified maximum gross weight, and the pilot…
- [NTSB SEA00LA165](https://openairdocs.org/ntsb/SEA00LA165.md): Ladd Nieuport 11 · White Pine, MT · Accident · Serious injuries · Limited investigation · Final report · Aug 14, 2000 · UNREG · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff after becoming airborne. Contributing factors were his lack of overall recent flight experience and the stall.
- [NTSB NYC00FA226](https://openairdocs.org/ntsb/NYC00FA226.md): Cessna 172 · Davis, WV · Accident · 1 fatal · Field investigation · Final report · Aug 12, 2000 · N8874B · Substantial damage
  > The pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind.
- [NTSB ATL00FA079](https://openairdocs.org/ntsb/ATL00FA079.md): Cessna 172H · Peachtree City, GA · Accident · 3 fatal · Field investigation · Final report · Aug 12, 2000 · N1749F · Substantial damage
  > The pilot's improper use of takeoff checklist procedures, and his failure to maintain flying speed, which resulted in a stall and subsequent collision with the ground. Factors: A factor was the landing flaps were not retracted.
- [NTSB LAX00LA290](https://openairdocs.org/ntsb/LAX00LA290.md): Cessna 150H · Corona, CA · Accident · No injuries · Limited investigation · Final report · Aug 9, 2000 · N7011S · Substantial damage
  > The student pilot's inadequate preflight planning which included improper fuel consumption calculations that led to fuel exhaustion and loss of engine power during takeoff.
- [NTSB MIA00LA234](https://openairdocs.org/ntsb/MIA00LA234.md): Eachon Time Warp Spitfire 9 · Lakeland, FL · Accident · 1 fatal · Limited investigation · Final report · Aug 8, 2000 · N355DE · Destroyed
  > a loss of control which resulted in an inadvertent stall at too low an altitude to allow recovery. Factors in this accident were, the pilot/owner did not verify that the airplane was balanced before the flight, and he did not perform any weight or balance…
- [NTSB DCA00MA079](https://openairdocs.org/ntsb/DCA00MA079.md): Douglas DC-9-32 · Greensboro, NC · Accident · Minor injuries · Major investigation · Final report · Aug 8, 2000 · N838AT · Substantial damage
  > A phase-to-phase arc in the left heat exchanger cooling fan relay, which ignited the surrounding wire insulation and other combustible materials within the electrical power center panel. Contributing to the left heat exchanger fan relay malfunction was the…
- [NTSB FTW00LA225](https://openairdocs.org/ntsb/FTW00LA225.md): Brown/Morrison Rans S-12 · Bonham, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2000 · UNREG · Substantial damage
  > The pilot's failure to maintain control of the airplane while maneuvering to return to the airport. Factors were the gusty wind conditions and the pilot's lack of experience.
- [NTSB NYC00LA217](https://openairdocs.org/ntsb/NYC00LA217.md): Piper PA-28-140 · E. Stroudsburg, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 2000 · N5731U · Substantial damage
  > The pilot's decision to takeoff with only partial engine power available.
- [NTSB CHI00LA240](https://openairdocs.org/ntsb/CHI00LA240.md): Thompson Avid Mark IV · Springfield, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 2000 · N619T · Destroyed
  > the pilot's inadequate preflight planning, his failure to abort the takeoff, and the inadequate airspeed. Factors included the tall runway grass, the quartering tailwind, and the trees.
- [NTSB SEA00LA151](https://openairdocs.org/ntsb/SEA00LA151.md): Kokenge Glastar · Butte, MT · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 2000 · N4350K · Destroyed
  > A loss of aircraft control for undetermined reasons.
- [NTSB LAX00FA283](https://openairdocs.org/ntsb/LAX00FA283.md): Mooney M20E · Jackpot, NV · Accident · 2 fatal · Field investigation · Final report · Jul 30, 2000 · N5853Q · Destroyed
  > The pilot inadvertently became lost/disoriented during initial climb and collided with terrain. A related factor was the dark night.
- [NTSB FTW00LA219](https://openairdocs.org/ntsb/FTW00LA219.md): Let L-23 Super Blankit · Waller, TX · Accident · 1 fatal · Limited investigation · Final report · Jul 29, 2000 · N105LW · Destroyed
  > the pilot's failure to maintain control of the glider while maneuvering. Contributory factors were the in-flight separation of the tow rope and the pilot's physical impairment from his use of diphenhyrdramine.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=90

## 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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=89

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