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

## Cases, newest first

- [NTSB ANC89FA133](https://openairdocs.org/ntsb/ANC89FA133.md): Piper PA-38-112 · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1989 · N2424N · Destroyed
  > Loss of engine power for an unknown reason, and the pilot's failure to maintain adequate airspeed, while turning back toward the airport, which resulted in an inadvertent stall/spin.
- [NTSB DEN89LA187](https://openairdocs.org/ntsb/DEN89LA187.md): Cessna 172M · Ruidoso, NM · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1989 · N9183H · Destroyed
  > The pilot's improper use of the mixture control and carburetor heat during a takeoff in high density altitude conditions. Contributing to the accident was the high density altitude.
- [NTSB CHI89LA163](https://openairdocs.org/ntsb/CHI89LA163.md): Cessna 150J · Putnam, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1989 · N60263 · Substantial damage
  > Improper use of carburetor heat by the pilot which resulted in reduced power for takeoff. The obstructions (hangar & trees) and weather conditions were contributing factors.
- [NTSB NYC89LA179](https://openairdocs.org/ntsb/NYC89LA179.md): Schweizer 269C · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Aug 2, 1989 · N75044 · Substantial damage
  > Loss of engine power for an unknown reason. A factor related to the accident was: water in the emergency landing area.
- [NTSB MIA89FA210](https://openairdocs.org/ntsb/MIA89FA210.md): Beech A24R · Sarasota, FL · Accident · 2 fatal · Field investigation · Final report · Aug 2, 1989 · N24586 · Destroyed
  > Failure of the propeller hub due to previous damage, which resulted in subsequent fatigue failure of the hub; and failure of the pilot to maintain flying speed, which resulted in a stall and subsequent impact with the ground. Inadequate maintenance/inspection…
- [NTSB CHI89DEX06](https://openairdocs.org/ntsb/CHI89DEX06.md): Grumman G-164A · Sullivan, IN · Accident · No injuries · Final report · Aug 2, 1989 · N952X · Substantial damage
  > A failure of the supercharger oil seal which resulted in a partial loss of engine power during takeoff and the uncontrolled touchdown during the forced landing. Factors related to the accident were: partial failure of the supercharger and spark plub fowling.
- [NTSB ATL89FA188](https://openairdocs.org/ntsb/ATL89FA188.md): Beech 70 · Albany, GA · Accident · 6 fatal · Field investigation · Final report · Aug 2, 1989 · N11TP · Destroyed
  > The fatigue failure of the supercharger intermediate drive gear shaft (gear tooth), which resulted in a partial loss of power, and the pilot's initiation of lift-off before reaching VMC airspeed. Factors related to the accident were: the worn intermediate…
- [NTSB LAX89LA255](https://openairdocs.org/ntsb/LAX89LA255.md): Beech A35 · Hemet, CA · Accident · No injuries · Limited investigation · Final report · Aug 1, 1989 · N8581A · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB ATL89LA186](https://openairdocs.org/ntsb/ATL89LA186.md): Cessna 172L · N Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Aug 1, 1989 · N336AF · Substantial damage
  > Water contamination of the airplane fuel supply, and the pilot's failure to adequately preflight the aircraft. A factor related to the accident was: swampy terrain at the emergency landing site.
- [NTSB CHI89FA154](https://openairdocs.org/ntsb/CHI89FA154.md): Ryan PT-22 · Oshkosh, WI · Accident · Minor injuries · Field investigation · Final report · Jul 31, 1989 · N54403 · 2 aircraft · Substantial damage
  > The experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…
- [NTSB ANC89LA131](https://openairdocs.org/ntsb/ANC89LA131.md): Cessna 185 · Tozitna River, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1989 · N4005Y · Substantial damage
  > Improper preflight planning/preparation by the pilot. High obstructions, unfavorable wind conditions, and trees were contributing factors.
- [NTSB NYC89LA218](https://openairdocs.org/ntsb/NYC89LA218.md): Cessna 305A · Chalfont, PA · Accident · No injuries · Limited investigation · Final report · Jul 30, 1989 · N5209G · Substantial damage
  > The pilot's improper use of carburetor heat, which resulted in a power loss due to carburetor ice. Factors related to the accident were: carburetor icing conditions and rough/uneven terain in the emergency landing area.
- [NTSB BFO89FA064](https://openairdocs.org/ntsb/BFO89FA064.md): Piper PA-32-260 · Bradshaw, MD · Accident · Serious injuries · Field investigation · Final report · Jul 29, 1989 · N3663W · Substantial damage
  > An engine power loss due to fuel starvation for unknown reasons.
- [NTSB ANC89FA130](https://openairdocs.org/ntsb/ANC89FA130.md): Cessna 180A · Wasilla, AK · Accident · Serious injuries · Field investigation · Final report · Jul 29, 1989 · N9681B · Substantial damage
  > Inadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel and his failure to maintain adequate airspeed while maneuvering back toward the lake which resulted in an inadvertent stall. The house & trees were…
- [NTSB DEN89LA180](https://openairdocs.org/ntsb/DEN89LA180.md): Cessna 150G · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · Jul 28, 1989 · N2473J · Substantial damage
  > Inadequate preflight by the pilot, which resulted in fuel exhaustion, due to his misjudgement of the fuel supply. Factors related to the accident were: a false fuel gage indication, and the ditch in the emergency landing area.
- [NTSB CHI89LA146](https://openairdocs.org/ntsb/CHI89LA146.md): Piper PA-32R-300 · Nappanee, IN · Accident · No injuries · Limited investigation · Final report · Jul 27, 1989 · N3923F · Substantial damage
  > The pilot-in-command's improper preflight calculation of weight and balance and the aircraft's inadequate climb capability due to low compression.
- [NTSB LAX89LA248](https://openairdocs.org/ntsb/LAX89LA248.md): Flug-Und Fahrzeugwerke Diament 16.5 · Marana, AZ · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1989 · N808VV · Destroyed
  > The loss of aircraft control resulting from an uncommanded upward pitch shortly after lift off.
- [NTSB LAX89LA247](https://openairdocs.org/ntsb/LAX89LA247.md): Piper PA-22 · Placerville, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1989 · N5925D · Destroyed
  > The improper maintenance performed at the last overhaul which resulted in the failure of the #3 main bearing. Contributing to the accident was the lack of a suitable landing area for the emergency landing.
- [NTSB NYC89LA174](https://openairdocs.org/ntsb/NYC89LA174.md): Piper PA-28-161 · Stonington, CT · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1989 · N29216 · Destroyed
  > The pilot's inadvertent flight into instrument meteorological conditions (IMC) and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the environmental conditions (dark night & fog) and the pilot's lack of…
- [NTSB MKC89LA169](https://openairdocs.org/ntsb/MKC89LA169.md): Grumman G-164A · Harviell, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1989 · N48426 · Substantial damage
  > The pilot's inability to avoid unsuitable terrain during the landing roll after a forced landing. The forced landing was made necessary by a loss of engine power caused by a foreign object restricting the fuel system.
- [NTSB DEN89DQA02](https://openairdocs.org/ntsb/DEN89DQA02.md): Cloud MA-5 Charger · Vaughn, NM · Accident · 1 fatal · Final report · Jul 25, 1989 · N3137G · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in the aircraft entering a stall/mush at too low an altitude to permit recovery. Contributing to the accident was the high density altitude.
- [NTSB DEN89FA178](https://openairdocs.org/ntsb/DEN89FA178.md): Beech E35 · Kalispell, MT · Accident · Serious injuries · Field investigation · Final report · Jul 24, 1989 · N3317C · Substantial damage
  > Contaminated fuel system that starved the engine of fuel.
- [NTSB DEN89FA177](https://openairdocs.org/ntsb/DEN89FA177.md): Cessna 152 · Logan, UT · Accident · 1 fatal · Field investigation · Final report · Jul 24, 1989 · N46260 · Substantial damage
  > Inadequate preflight and improper inflight planning/decision by the student, which resulted in fuel exhaustion from an inadequate supply of fuel, and the student's failure to maintain airspeed, while maneuvering, which resulted in an inadvertent stall/spin. A…
- [NTSB NYC89LA172](https://openairdocs.org/ntsb/NYC89LA172.md): Piper PA-18A · Atlantic City, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1989 · N8061C · Substantial damage
  > The pilot's failure to maintain adequate flying speed, and his delay to jettison the banner. A factor related to the accident was: the location of the trees.
- [NTSB MIA89LA206](https://openairdocs.org/ntsb/MIA89LA206.md): Schweizer SGS 1-26C · Ms State Univ, MS · Accident · No injuries · Limited investigation · Final report · Jul 23, 1989 · N9944J · Substantial damage
  > Improper in-flight planning/decison by the pilot. Contributing factors were: failure of the tow vehicle driver to use/maintain the proper speed, the pilot's lack of total flying experience, and high vegetation (uncut hay).
- [NTSB CHI89LA142](https://openairdocs.org/ntsb/CHI89LA142.md): Globe GC-1B · Metropolis, IL · Accident · No injuries · Limited investigation · Final report · Jul 23, 1989 · N332HM · Substantial damage
  > Pilot's failure to adhere to procedures and ensure the aircraft had sufficient airspeed before attempting rotation and climbout. Airspeed was inadequate to maintain flight, and just after the landing gear was retracted the aircraft settledto the ground.
- [NTSB LAX89LA243](https://openairdocs.org/ntsb/LAX89LA243.md): Piper PA-28R-200 · Van Nuys, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1989 · N5123S · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CHI89DEP07](https://openairdocs.org/ntsb/CHI89DEP07.md): Hiller UH-12E · Blackriverfalls, WI · Accident · Minor injuries · Final report · Jul 20, 1989 · N48313 · Destroyed
  > Pilot-in-command's failure to jettison the external load followed by his misjudgement of distance to avoid collision with the external load.
- [NTSB ATL89FA182](https://openairdocs.org/ntsb/ATL89FA182.md): Cessna 172G · Ridgeland, SC · Accident · 3 fatal · Field investigation · Final report · Jul 20, 1989 · N4254L · Destroyed
  > Improper planning/decision by the pilot-in-command (PIC), which resulted in an inadvertent stall during takeoff. Factors related to the accident were: the excessive gross weight and improper lift-off by the PIC, the pilot/passenger's improper crew…
- [NTSB SEA89LA135](https://openairdocs.org/ntsb/SEA89LA135.md): Grumman G-164A · Albion, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1989 · N8377 · Substantial damage
  > The pilot's improper use of the mixture control during takeoff. The fence was a related factor.
- [NTSB DEN89LA173](https://openairdocs.org/ntsb/DEN89LA173.md): Beech A36 · Cimarron, NM · Accident · No injuries · Limited investigation · Final report · Jul 19, 1989 · N26208 · Substantial damage
  > Failure of the pilot to properly plan his flight. He failed to take into account the changable winds and the high density altitude that existed at the airstrip when he attempted to takeoff. A proper climb rate was not possible and theaircraft stalled/mushed…
- [NTSB BFO89FA059](https://openairdocs.org/ntsb/BFO89FA059.md): Beech E18S · Glen Burnie, MD · Accident · 2 fatal · Field investigation · Final report · Jul 19, 1989 · N138JR · Destroyed
  > A fire that erupted in the cockpit of the aircraft (under a side panel). Related factors were: smoke and fumes in the cockpit which reduced the pilot's visual perception and ability to see.
- [NTSB FTW89DRA08](https://openairdocs.org/ntsb/FTW89DRA08.md): Grumman-Schweizer G-164B · Anahuac, TX · Accident · Minor injuries · Final report · Jul 18, 1989 · N6633Q · Destroyed
  > Failure of the supercharger bearing. The dirt bank was a contributing factor.
- [NTSB FTW89FA137](https://openairdocs.org/ntsb/FTW89FA137.md): Piper PA-32R-301T · Celina, TX · Accident · 2 fatal · Field investigation · Final report · Jul 16, 1989 · N4360K · Destroyed
  > Improper planning/decision by the pilot. Related factors were: failure of the pilot to use all of the available runway area, the runway/terrain conditions, and obstructions/power lines beyond the departure end of the runway.
- [NTSB LAX89LA245](https://openairdocs.org/ntsb/LAX89LA245.md): Burkhart Grob G-102 · Maricopa, AZ · Accident · No injuries · Limited investigation · Final report · Jul 15, 1989 · N925G · Substantial damage
  > The pilot's inability to maintain airspeed, resulting in a hard landing. Also causal to the accident was the opening of the canopy for undetermined reasons.
- [NTSB LAX89DUJ07](https://openairdocs.org/ntsb/LAX89DUJ07.md): Grumman G-164A · Eloy, AZ · Accident · No injuries · Final report · Jul 15, 1989 · N5252 · Substantial damage
  > Inaequate preflight by the pilot, which resulted in fuel starvation during the climb after takeoff, due to very little fuel remaining in the tanks. The rough/uneven desert terrain was considered to be a contributing factor.
- [NTSB CHI89DEM04](https://openairdocs.org/ntsb/CHI89DEM04.md): Cessna 175 · Lawton, MI · Accident · No injuries · Final report · Jul 15, 1989 · N7404M · Substantial damage
  > The pilot's delay in aborting takeoff and his excessive rate of descent at touchdown. A factor in the accident was the pilot's inadequate preflight planning.
- [NTSB NYC89LA165](https://openairdocs.org/ntsb/NYC89LA165.md): Cessna 182A · Lancaster, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1989 · N6171B · Substantial damage
  > Water contamination of the fuel, and an inadequate preflight by the pilot-in-command.
- [NTSB NYC89LA164](https://openairdocs.org/ntsb/NYC89LA164.md): Piper PA-28-160 · Hammond, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1989 · N5913W · Substantial damage
  > The pilot's decision to abort the takeoff with insufficient runway remaining. Contributing to the the accident was a wet grass runway and the faulty tachometer which influenced the pilot's decision.
- [NTSB CHI89FA135](https://openairdocs.org/ntsb/CHI89FA135.md): Cessna 177 · Lockport, IL · Accident · 3 fatal · Field investigation · Final report · Jul 14, 1989 · N3146T · Destroyed
  > The pilot's inadequate preflight planning/preparation, and his failure to attain adequate airspeed, which resulted in a stall or mush. A factor related to the accident was: the aircraft's excessive gross weight.
- [NTSB ANC89LA120](https://openairdocs.org/ntsb/ANC89LA120.md): Piper PA-28 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Jul 14, 1989 · N5745W · Substantial damage
  > The pilot failed to maintain airspeed and inadvertently allowed the airplane to stall.
- [NTSB FTW89LA135](https://openairdocs.org/ntsb/FTW89LA135.md): Cessna 421 · Okmulgee, OK · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1989 · N699PC · Substantial damage
  > Failure of the nose gear extension assembly and the pilot's improper precautionary landing procedures that included securing the engines prior to a point where a safe landing was assured.
- [NTSB CHI89DEX05](https://openairdocs.org/ntsb/CHI89DEX05.md): Texas Helicopter OH-13H/M74A · New Richmond, IN · Accident · No injuries · Final report · Jul 13, 1989 · N10002 · Substantial damage
  > The pilot's misjudgement of the fuel supply which resulted in fuel exhaustion.
- [NTSB SEA89LA131](https://openairdocs.org/ntsb/SEA89LA131.md): Aeronca 65-CA · Prineville, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1989 · N36532 · Destroyed
  > The pilot's failure to maintain adequate clearance from trees.
- [NTSB SEA89LA130](https://openairdocs.org/ntsb/SEA89LA130.md): Cushing C2 · John Day, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 1989 · N129C · Substantial damage
  > The pilot improperly changed the design of the airplane by elongating holes at the wing attachment. The change was not inspected by a qualified individual. As a result of the change, the wing separated at the spar.
- [NTSB MIA89LA188](https://openairdocs.org/ntsb/MIA89LA188.md): Cessna 182 · Kissimmee, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1989 · N6199B · Substantial damage
  > The failure of the carburetor throttle cable because of an inadequate annual inspection conducted 4.6 flight hours and one month before the accident.
- [NTSB LAX89LA232](https://openairdocs.org/ntsb/LAX89LA232.md): Ryan SCW-145 · Santa Paula, CA · Accident · No injuries · Limited investigation · Final report · Jul 9, 1989 · N46207 · Substantial damage
  > Total loss of engine power for undetermined reasons.
- [NTSB NYC89LA168](https://openairdocs.org/ntsb/NYC89LA168.md): Mooney M20C · Stormville, NY · Accident · No injuries · Limited investigation · Final report · Jul 8, 1989 · N6872N · Substantial damage
  > Failure of the pilot to maintain airspeed which resulted in an inadvertent stall.
- [NTSB MKC89LA155](https://openairdocs.org/ntsb/MKC89LA155.md): Weatherly 201-B · Wymore, NE · Accident · No injuries · Limited investigation · Final report · Jul 8, 1989 · N1286W · Substantial damage
  > The pilot's failure to maintain airspeed and altitude during climbout. Contributing to the accident was the high density altitude.
- [NTSB DEN89LA166](https://openairdocs.org/ntsb/DEN89LA166.md): Cessna 172 · Glenwood Spgs, CO · Accident · No injuries · Limited investigation · Final report · Jul 8, 1989 · N2720E · Substantial damage
  > Inadequate compensation for wind conditions by the dual student, resulting in a loss of control and a forced landing. The pilot-in-command, CFI, failed to adequately supervise the operation.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.