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

## Cases, newest first

- [NTSB DEN03FA099](https://openairdocs.org/ntsb/DEN03FA099.md): Agusta A109K2 · Salt Lake City, UT · Accident · 1 fatal · Field investigation · Final report · Jun 8, 2003 · N123RX · Destroyed
  > Fatigue of the tail rotor trunnion resulting in complete trunnion failure and subsequent tail rotor separation from the helicopter. Factors contributing to the accident were the low altitude, low airspeed, excessive tail rotor loading, and the worn tail-rotor…
- [NTSB LAX03LA185](https://openairdocs.org/ntsb/LAX03LA185.md): Cessna 175A · Ash Fork, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 2003 · N6902E · Substantial damage
  > The pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall mush condition. Factors were the loose and uneven dirt runway surface, the known tailwind with gusts, and high density altitude.
- [NTSB CHI03IA153](https://openairdocs.org/ntsb/CHI03IA153.md): Beech 1900D · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Jun 7, 2003 · N901SK · Minor damage
  > Failure of the aileron sprocket assembly at the sprocket-to-shaft braze joint. Contributing factors were the improper braze procedure used by the part manufacturer at the time of fabrication which resulted in an inferior quality joint and the inadequate…
- [NTSB CHI03FA150](https://openairdocs.org/ntsb/CHI03FA150.md): Cessna 172M · West Chicago, IL · Accident · Serious injuries · Field investigation · Final report · Jun 7, 2003 · N13474 · Destroyed
  > The abrupt pull-up initiated by the pilot during takeoff before airspeed was attained resulting in a stall. Factors contributing to the accident were the pilot's failure to maintain directional control of the airplane on takeoff and the crosswind.
- [NTSB NYC03LA120](https://openairdocs.org/ntsb/NYC03LA120.md): Grumman G-164 · Shiloh, NJ · Accident · No injuries · Limited investigation · Final report · Jun 6, 2003 · N10291 · Substantial damage
  > The pilot's improper in-flight decision to not jettison his load when he realized that he would not clear the trees. A factor was the pilot's inattention to his airspeed at liftoff and on climb.
- [NTSB CHI03FA149](https://openairdocs.org/ntsb/CHI03FA149.md): Cessna 172S · Sidnaw, MI · Accident · 1 fatal · Field investigation · Final report · Jun 6, 2003 · N975SP · Destroyed
  > The improper short/soft field landing procedure by the pilot and his lack of recent experience in type of operation. Contributing factors were the short/soft field runway, the trees and his delay in aborting the takeoff.
- [NTSB NYC03LA119](https://openairdocs.org/ntsb/NYC03LA119.md): Palen Avro-504K · Rhinebeck, NY · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 2003 · N4929 · Substantial damage
  > A total loss of engine power during the initial climb for undetermined reasons.
- [NTSB LAX03LA180](https://openairdocs.org/ntsb/LAX03LA180.md): Air Tractor AT-502A · Raywood, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 2003 · N948BB · Destroyed
  > the pilot's encounter with a stall/mush condition in the takeoff initial climb due to his inadequate preflight/pretakeoff procedures and failure to set the wing flaps to the proper takeoff configuration before beginning the takeoff ground roll.
- [NTSB LAX03LA178](https://openairdocs.org/ntsb/LAX03LA178.md): Cessna 172M · Conroe, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 2003 · N9900V · Substantial damage
  > The pilot's failure to attain/maintain sufficient airspeed, which resulted in a stall/mush.
- [NTSB LAX03TA174](https://openairdocs.org/ntsb/LAX03TA174.md): Cessna 182Q · So Lake Tahoe, CA · Accident · Minor injuries · Final report · May 31, 2003 · N4892N · Substantial damage
  > a loss of pitch flight control authority due to the disconnection and separation of the elevator DOWN control cable turnbuckle. The separation of the turnbuckle was due to the severance of the safety wire by unknown persons at an unknown time.
- [NTSB LAX03LA176](https://openairdocs.org/ntsb/LAX03LA176.md): Winters Glasair SH-2 · Riverside, CA · Accident · 1 fatal · Limited investigation · Final report · May 31, 2003 · N73VL · Destroyed
  > The pilot's failure to maintain control of the airplane during an abrupt, low altitude maneuver during the takeoff-initial climb, which resulted in a collision with terrain during the subsequent uncontrolled descent.
- [NTSB LAX03LA171](https://openairdocs.org/ntsb/LAX03LA171.md): Denis Cozy · Kailua-Kona, HI · Accident · No injuries · Limited investigation · Final report · May 30, 2003 · N794WD · Destroyed
  > A clogged fuel filter, which resulted in fuel starvation and a total loss of engine power during takeoff-initial climb.
- [NTSB LAX03LA168](https://openairdocs.org/ntsb/LAX03LA168.md): Aero Commander 500B · Grand Canyon, AZ · Accident · Serious injuries · Limited investigation · Final report · May 29, 2003 · N64TS · Substantial damage
  > the pilot's encounter with a wind shear just after liftoff.
- [NTSB DEN03LA089](https://openairdocs.org/ntsb/DEN03LA089.md): Beech A36 · Afton, WY · Accident · No injuries · Limited investigation · Final report · May 26, 2003 · N2106L · Substantial damage
  > the pilot's failure to achieve an adequate climb rate, resulting in an inflight collision with the sign. Contributing factors were the pilot's improper mixture leaning procedure, the high density altitude, his failure to abort the takeoff in a timely manner,…
- [NTSB CHI03FA138](https://openairdocs.org/ntsb/CHI03FA138.md): Piper PA-31P · Woodruff, WI · Accident · 4 fatal · Field investigation · Final report · May 25, 2003 · N36DR · Destroyed
  > The pilot's failure to follow the before take-off checklist which led to an improper selection of the auxilliary fuel tanks for the takeoff leading to the subsequent fuel starvation of the left engine. Additional causes were the pilot not maintaining minimum…
- [NTSB MIA03LA111](https://openairdocs.org/ntsb/MIA03LA111.md): Piper PA-32-260 · Fort Meade, FL · Accident · No injuries · Limited investigation · Final report · May 23, 2003 · N3921W · Substantial damage
  > Thew failure of the pilot to abort the takeoff after travelling past the estimated point of liftoff, and failure of the pilot to maintain airspeed during the initial climb resulting in inadvertent stall and uncontrolled descent with subsequent impact onto the…
- [NTSB LAX03LA179](https://openairdocs.org/ntsb/LAX03LA179.md): Cessna 182E · Bryan, TX · Accident · No injuries · Limited investigation · Final report · May 23, 2003 · N9389X · Substantial damage
  > The presence of foreign material in the carburetor intake venturi, which resulted in a partial loss of engine power during takeoff, and a subsequent off-airport forced landing.
- [NTSB LAX03LA159](https://openairdocs.org/ntsb/LAX03LA159.md): Bellanca 7GCBC · Reno, NV · Accident · No injuries · Limited investigation · Final report · May 22, 2003 · N68567 · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB NYC03LA109](https://openairdocs.org/ntsb/NYC03LA109.md): Cessna 175A · Ocean City, NJ · Accident · No injuries · Limited investigation · Final report · May 19, 2003 · N6989E · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB LAX03LA154](https://openairdocs.org/ntsb/LAX03LA154.md): Piper PA-32R-301T · Paulden, AZ · Accident · Minor injuries · Limited investigation · Final report · May 18, 2003 · N99TX · Destroyed
  > the pilot's failure to attain and maintain the proper climb airspeed. The high density altitude condition was a factor.
- [NTSB NYC03LA110](https://openairdocs.org/ntsb/NYC03LA110.md): Agusta A109E · Harbor Creek, PA · Accident · No injuries · Limited investigation · Final report · May 15, 2003 · N7YL · Substantial damage
  > The pilot's improper preflight inspection, during which he failed to remove a flashlight from the tailboom strake. A factor was the pilot's attention be diverted by a mechanic during the preflight inspection.
- [NTSB NYC03LA107](https://openairdocs.org/ntsb/NYC03LA107.md): Cessna 208B · New Russia, OH · Accident · Minor injuries · Limited investigation · Final report · May 15, 2003 · N208AD · Substantial damage
  > The pilot's failure to verify the position of the fuel selectors prior to takeoff, which resulted in a power loss due to fuel starvation. A factor was the failure of the fuel selector warning horn.
- [NTSB MIA03LA109](https://openairdocs.org/ntsb/MIA03LA109.md): Bill Darling Rans S9 · Green Cove Sprg, FL · Accident · Serious injuries · Limited investigation · Final report · May 15, 2003 · N93WD · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB FTW03LA150](https://openairdocs.org/ntsb/FTW03LA150.md): Cessna 320-D · EL Paso, TX · Accident · Serious injuries · Limited investigation · Final report · May 15, 2003 · N4111T · Destroyed
  > the loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control. Contributing factors were the gusty and high wind conditions, and the pilot's failure to compensate for the wind conditions.
- [NTSB MIA03CA108](https://openairdocs.org/ntsb/MIA03CA108.md): WSK PZL Mielec M-18A · Baxterville, MS · Accident · No injuries · Data collection · Final report · May 13, 2003 · N82204 · Substantial damage
  > The pilot's decision to continue the takeoff at a low airspeed which resulted in a stall, an uncontrolled descent, and an impact with terrain.
- [NTSB NYC03LA103](https://openairdocs.org/ntsb/NYC03LA103.md): Francis Giroux Moni-Motorglider 032 · Glens Falls, NY · Accident · Serious injuries · Limited investigation · Final report · May 11, 2003 · N20909 · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the excessive taxi speed, and the inadvertent lift off.
- [NTSB FTW03LA149](https://openairdocs.org/ntsb/FTW03LA149.md): Bellanca 7GCBC · Houston, TX · Accident · Serious injuries · Limited investigation · Final report · May 10, 2003 · N711JJ · Substantial damage
  > The flight instructor's poor decision to initiate a simulated emergency without having a suitable area for a forced landing.
- [NTSB NYC03LA096](https://openairdocs.org/ntsb/NYC03LA096.md): Piper PA-28-180 · Montgomery, NY · Accident · No injuries · Limited investigation · Final report · May 5, 2003 · N55854 · Substantial damage
  > The inadequate 100-hour inspection by maintenance personnel, which resulted in a loose fuel line and loss of power. A factor related to the accident was the dark night conditions.
- [NTSB NYC03LA098](https://openairdocs.org/ntsb/NYC03LA098.md): Piper PA-18-150 · Ava, NY · Accident · No injuries · Limited investigation · Final report · May 4, 2003 · N9834P · Substantial damage
  > The pilot's inadequate preflight which did not detect the contamination in the fuel, and subsequent power loss due to contaminated fuel while operating over unsuitable terrain.
- [NTSB CHI03LA121](https://openairdocs.org/ntsb/CHI03LA121.md): Piper PA-18-150 · Gordon, NE · Accident · No injuries · Limited investigation · Final report · May 4, 2003 · N9682P · Substantial damage
  > The pilots failure to maintain adequate airspeed which resulted in a stall. Contributing factors to this accident were the rain, hail, and wind gusts.
- [NTSB ATL03LA091](https://openairdocs.org/ntsb/ATL03LA091.md): Homebuilt Unkown · Summerville, GA · Accident · Serious injuries · Limited investigation · Final report · May 4, 2003 · UNREG · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall, and subsequent collision with the ground.
- [NTSB FTW03LA143](https://openairdocs.org/ntsb/FTW03LA143.md): Piper PA-18A-150 · Roanoke, TX · Accident · Minor injuries · Limited investigation · Final report · May 3, 2003 · N9789D · Substantial damage
  > The flight instructor's inadequate in-flight planning/decision resulting in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL03LA088](https://openairdocs.org/ntsb/ATL03LA088.md): Mooney M20E · Milledgeville, GA · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 2003 · N201EZ · Substantial damage
  > The pilot's failure to maintain airspeed during climbout which resulted in a low altitude stall and subsequent in-flight collision with the terrain.
- [NTSB IAD03LA052](https://openairdocs.org/ntsb/IAD03LA052.md): Aeronca AR-58-058B · Brattleboro, VT · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 2003 · N46183 · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and a subsequent descent into trees. A factor in the accident was the downdrafts.
- [NTSB IAD03FA050](https://openairdocs.org/ntsb/IAD03FA050.md): Beech A36 · Jackson, OH · Accident · 2 fatal · Field investigation · Final report · Apr 26, 2003 · N523BL · Substantial damage
  > The flight instructor's improper decision to turn back to the airport at an insufficient altitude after takeoff and his failure to maintain adequate airspeed, during a simulated engine failure.
- [NTSB DEN03LA073](https://openairdocs.org/ntsb/DEN03LA073.md): Cessna 175A · Colo. Springs, CO · Accident · No injuries · Limited investigation · Final report · Apr 26, 2003 · N6884E · Substantial damage
  > the stuck open exhaust valve on the engine's number 2 cylinder, the pilot's improper preflight planning, and his failure to maintain aircraft control. Factors contributing to the accident were the low altitude flight maneuver performed, the low airspeed, the…
- [NTSB ATL03LA085](https://openairdocs.org/ntsb/ATL03LA085.md): Piper PA-28-151 · Rogersville, TN · Accident · No injuries · Limited investigation · Final report · Apr 25, 2003 · N43266 · Substantial damage
  > The rupture of the carburetor float, which resulted in the loss of engine power and subsequent on ground collision with trees.
- [NTSB CHI03LA109](https://openairdocs.org/ntsb/CHI03LA109.md): Cessna 152 · Red Owl, SD · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 2003 · N93564 · Substantial damage
  > The pilot not maintaining aircraft control during initial climb-out, resulting in the encountered stall.
- [NTSB FTW03LA133](https://openairdocs.org/ntsb/FTW03LA133.md): Air Tractor AT-402B · Taft, TX · Accident · No injuries · Limited investigation · Final report · Apr 17, 2003 · N6078W · Substantial damage
  > The partial loss of engine power resulting from a leaking fuel transfer tube following inadequate maintenance by unknown personnel. A contributing factor was the furrowed terrain encountered during the forced landing.
- [NTSB NYC03LA085](https://openairdocs.org/ntsb/NYC03LA085.md): McCaa Minimax 1500R · Robbinsville, NJ · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 2003 · N20569 · Substantial damage
  > A partial loss of power for undertermined reason(s).
- [NTSB ATL03TA078](https://openairdocs.org/ntsb/ATL03TA078.md): Aero Commander 500S · Mount Pleasant, SC · Accident · Serious injuries · Final report · Apr 14, 2003 · N19WL · Destroyed
  > The improper refueling of the airplane by airport personnel with the incorrect fuel grade that resulted in a total loss in engine power on both engines during initial climb. A factor was the inadequate preflight inspection by the pilot in command.
- [NTSB SEA03LA061](https://openairdocs.org/ntsb/SEA03LA061.md): Avia Stroitel AC-5M · Richland, WA · Accident · No injuries · Limited investigation · Final report · Apr 12, 2003 · N125MZ · Substantial damage
  > The pilot's failure to maintain airspeed and the failure of the propeller drive assembly. A factor contributing to the accident was the inadvertent stall.
- [NTSB CHI03LA105](https://openairdocs.org/ntsb/CHI03LA105.md): Cessna 172H · Holt, MO · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 2003 · N3831R · Substantial damage
  > The pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident were the trees.
- [NTSB LAX03LA126](https://openairdocs.org/ntsb/LAX03LA126.md): Bell OH-58A · Calipatria, CA · Accident · No injuries · Limited investigation · Final report · Apr 4, 2003 · N38FA · Substantial damage
  > The pilot's inadequate preflight inspection of the helicopter, and an inadvertent dynamic rollover during takeoff-initial climb, which resulted in an uncontrolled descent and collision with terrain.
- [NTSB FTW03LA123](https://openairdocs.org/ntsb/FTW03LA123.md): Ercoupe 415-C · Ranger, TX · Accident · No injuries · Limited investigation · Final report · Apr 4, 2003 · N93815 · Substantial damage
  > The loss of engine power for an undetermined reason.
- [NTSB LAX03LA121](https://openairdocs.org/ntsb/LAX03LA121.md): Beech V35A · North Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 2003 · N95DC · Destroyed
  > Fuel starvation due to the pilot's mismanagement of his fuel supply and failure to verify the fuel quantity onboard prior to departure.
- [NTSB LAX03LA120](https://openairdocs.org/ntsb/LAX03LA120.md): Beech 19A · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Mar 31, 2003 · N7610R · Substantial damage
  > The pilot's failure to obtain/maintain an adequate airspeed, which resulted in a stall/mush.
- [NTSB NYC03LA072](https://openairdocs.org/ntsb/NYC03LA072.md): Piper PA-28RT-201 · Berlin, NJ · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 2003 · N8098Q · Substantial damage
  > The pilot's inadequate preflight inspection which led to an unsecured cowling and loss of aircraft control. Factors were the pilot's diverted attention and the unsecured cowling.
- [NTSB SEA03LA049](https://openairdocs.org/ntsb/SEA03LA049.md): Cessna 172G · Packwood, WA · Accident · No injuries · Limited investigation · Final report · Mar 24, 2003 · N4150L · Substantial damage
  > Loss of partial engine power for undetermined reasons during the initial climb after takeoff. Loose gravel/sandy was a factor during the landing roll.
- [NTSB DEN03LA056](https://openairdocs.org/ntsb/DEN03LA056.md): Beech A36 · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Mar 24, 2003 · N435P · Substantial damage
  > the pilot's premature liftoff resulting in his failure to attain airspeed and achieve takeoff climb. Contributing factors were the runway light and taxiway sign.

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

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

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