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

## Cases, newest first

- [NTSB LAX03LA238](https://openairdocs.org/ntsb/LAX03LA238.md): Piper PA-28-161 · Lomita, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 2003 · N3091M · Destroyed
  > The partial loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat. Also causal was the pilot's failure to attain and maintain an adequate airspeed during the aborted landing, which resulted in a stall/mush.
- [NTSB LAX03LA237](https://openairdocs.org/ntsb/LAX03LA237.md): Thompson Quickie Q2 · Tehachapi, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 2003 · N218DT · Destroyed
  > The pilot's inadvertent entry into a pilot induced oscillation and failure to maintain airplane control during the takeoff initial climb. A contributing factor was the pilot's likely impairment by an over-the-counter drug substance that degraded his physical…
- [NTSB CHI03FA218](https://openairdocs.org/ntsb/CHI03FA218.md): Robinson R22-Beta · Flint, MI · Accident · Serious injuries · Field investigation · Final report · Jul 20, 2003 · N131MH · Substantial damage
  > The loss of engine power for undetermined reasons, and the pilot's inadequate decision to land on an unsuitable area.
- [NTSB ANC03LA083](https://openairdocs.org/ntsb/ANC03LA083.md): Maule M-4 · Kobuk, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 2003 · N40344 · Substantial damage
  > The pilot's inadvertent use of diesel fuel in a gasoline engine which resulted in a partial loss of engine power, and subsequent collision with trees during a forced landing after takeoff. A factor contributing to the accident was the pilot's inadequate…
- [NTSB NYC03FA161](https://openairdocs.org/ntsb/NYC03FA161.md): Cessna T210L · Quakertown, PA · Accident · 1 fatal · Field investigation · Final report · Jul 18, 2003 · N700PR · Destroyed
  > A loss of engine power for undetermined reasons.
- [NTSB DEN03LA134](https://openairdocs.org/ntsb/DEN03LA134.md): Piper PA-32R-301 · Logan, UT · Accident · No injuries · Limited investigation · Final report · Jul 18, 2003 · N8036D · Substantial damage
  > the loss of engine power due to partial mechanical failure, which resulted in a forced landing. Contributing factors include the pilot's improper preflight planning/preparation, the improper rigging of the propeller governor control, the high density altitude…
- [NTSB CHI03LA216](https://openairdocs.org/ntsb/CHI03LA216.md): Cessna 172H · Isle, MN · Accident · 1 fatal · Limited investigation · Final report · Jul 18, 2003 · N1606F · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in a stall. The trees, high density altitude, and the soft field were additional factors.
- [NTSB IAD03LA063](https://openairdocs.org/ntsb/IAD03LA063.md): Piper PA-23-180 · Akron, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 2003 · N825SA · Destroyed
  > the pilot's failure to maintain minimum control single engine airspeed (Vmc) during a loss of power on one engine, which resulted in a loss of control in flight an in-flight collision with terrain. A factor was a shifted main journal, which resulted in a…
- [NTSB CHI03LA205](https://openairdocs.org/ntsb/CHI03LA205.md): Cessna 182Q · Empire, MI · Accident · No injuries · Limited investigation · Final report · Jul 9, 2003 · N95890 · Substantial damage
  > The pilot's failure to abort the takeoff. A contributing factor to the accident included the pilot not utilizing all available engine power during the entire takeoff. Additional factors were the improper wing flap setting and the cherry-tree orchard.
- [NTSB CHI03FA202](https://openairdocs.org/ntsb/CHI03FA202.md): Cessna 150L · Schaumburg, IL · Accident · 1 fatal · Field investigation · Final report · Jul 8, 2003 · N10257 · Destroyed
  > The pilot not maintaining airplane control and the inadvertent stall he encountered during initial climb.
- [NTSB NYC03LA154](https://openairdocs.org/ntsb/NYC03LA154.md): Wohlers Falco F.8L · Ashland, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 2003 · N33LW · Substantial damage
  > A loss of engine power due to the failure of the engine air intake duct tubing, which resulted in a total blockage of the induction inlet duct. A factor related to the accident was the inadequate 100-hour inspection by maintenance personnel. (This narrative…
- [NTSB NYC03FA153](https://openairdocs.org/ntsb/NYC03FA153.md): Piper PA-34-200T · Montauk, NY · Accident · 3 fatal · Field investigation · Final report · Jul 7, 2003 · N5636V · Substantial damage
  > A loss of control during climb for undetermined reasons.
- [NTSB ANC03LA070](https://openairdocs.org/ntsb/ANC03LA070.md): Helio H-391B · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Jul 7, 2003 · N17081 · Substantial damage
  > A loss of engine power for an undetermined reason during takeoff initial climb, which resulted in an in-flight collision with trees.
- [NTSB NYC03LA151](https://openairdocs.org/ntsb/NYC03LA151.md): Bellanca 8GCBC · Manorville, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 6, 2003 · N86985 · Substantial damage
  > The pilot's failure to obtain the proper airspeed and his delayed remedial action to jettison the banner.
- [NTSB DEN03LA123](https://openairdocs.org/ntsb/DEN03LA123.md): Piper PA-46-310P · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Jul 6, 2003 · N4386G · Substantial damage
  > the pilot's improper flare which resulted in a hard landing. Contributing factors were the out-of-calibration waste gate actuator, a blown tire, and the airport sign.
- [NTSB DEN03LA122](https://openairdocs.org/ntsb/DEN03LA122.md): Mooney M20J · Leadville, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 6, 2003 · N37JK · Substantial damage
  > the pilot's inadequate compensation for wind conditions and his failure to attain adequate airspeed resulting in an inadvertent stall/mush. Contributing factors were the wind shear, runway light, fence post, and unsuitable terrain.
- [NTSB SEA03LA128](https://openairdocs.org/ntsb/SEA03LA128.md): Mooney M20-J · Renton, WA · Accident · No injuries · Limited investigation · Final report · Jul 4, 2003 · N201DV · Substantial damage
  > In-flight failure of the electric landing gear motor during the initial takeoff climb.
- [NTSB LAX03FA207](https://openairdocs.org/ntsb/LAX03FA207.md): Globe GC-1B · Truckee, CA · Accident · 1 fatal · Field investigation · Final report · Jul 4, 2003 · N78053 · Substantial damage
  > an in-flight loss of control due to the pilot's rotation to an excessive pitch up attitude after takeoff and his failure to maintain an adequate airspeed, which resulted in a stall. Factors in the accident were the high density altitude and the lack of stall…
- [NTSB CHI03LA192](https://openairdocs.org/ntsb/CHI03LA192.md): Debay Dragonfly Mark II · Eden Prairie, MN · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 2003 · N25JD · Substantial damage
  > The pilot's intentional operation of the airplane with a known deficiency with regard to an improper carburetor calibration that led to the loss of engine power. The improperly calibrated carburetor and the trees were contributing factors.
- [NTSB NYC03LA146](https://openairdocs.org/ntsb/NYC03LA146.md): Cessna 172N · Linden, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 2003 · N314TM · Substantial damage
  > The mechanic's improper installation of the carburetor, and his failure to secure the mixture control wire to the mixture control arm pivot bolt.
- [NTSB CHI03LA186](https://openairdocs.org/ntsb/CHI03LA186.md): Beech A35 · Douglass, KS · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 2003 · N564B · Substantial damage
  > The pilot's failure to attain adequate airspeed and his premature liftoff, which resulted in a stall. A factor to the accident was the tree.
- [NTSB ATL03LA113](https://openairdocs.org/ntsb/ATL03LA113.md): Aero Vodochody Aero Works L39C · Gadsden, AL · Accident · 1 fatal · Limited investigation · Final report · Jun 30, 2003 · N8125R · Destroyed
  > The loss of engine power during takeoff due to foreign object damage, which resulted in an in-flight collision with terrain during forced landing. Factors were the pilot's inadequate preflight inspection of the airplane, his failure to secure the…
- [NTSB CHI03LA189](https://openairdocs.org/ntsb/CHI03LA189.md): Bowers Fly Baby · Altus, AR · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2003 · N1878 · Substantial damage
  > A loss of engine power for undetermined reasons. Factors associated with the accident were the tree and evasive maneuver performed during the forced landing.
- [NTSB DEN03FA114](https://openairdocs.org/ntsb/DEN03FA114.md): Stugart Vans RV-6A · Fort Collins, CO · Accident · 2 fatal · Field investigation · Final report · Jun 28, 2003 · N29PT · Destroyed
  > the pilot's improper preflight planning/decision resulting in the fuel selector positioned improperly and fuel starvation, and his failure to maintain adequate airspeed. A factor contributing to the accident was the low altitude.
- [NTSB LAX03LA213](https://openairdocs.org/ntsb/LAX03LA213.md): Mcanally Glasair JM-1 · Hollister, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2003 · N104JM · Substantial damage
  > the pilot's failure to follow the checklist and apply the electric fuel pump prior to takeoff, which resulted in vapor lock.
- [NTSB NYC03LA137](https://openairdocs.org/ntsb/NYC03LA137.md): Cessna 150F · Williamson, NY · Accident · No injuries · Limited investigation · Final report · Jun 26, 2003 · N8517G · Substantial damage
  > The failure of a rocker arm shaft boss, which resulted in a partial loss of power and subsequent forced landing. A factor was the unsuitable terrain.
- [NTSB ANC03CA088](https://openairdocs.org/ntsb/ANC03CA088.md): de Havilland DHC-2 · Iliamna, AK · Accident · No injuries · Data collection · Final report · Jun 25, 2003 · N930TG · Substantial damage
  > The pilot's incorrect selection of the fuel selector valve position during takeoff which resulted in fuel starvation. A factor associated with the accident was inadequate transition training provided to the pilot by the company/operator management.
- [NTSB MIA03LA131](https://openairdocs.org/ntsb/MIA03LA131.md): Beech Be-35-33 · Raymond, MS · Accident · Serious injuries · Limited investigation · Final report · Jun 24, 2003 · N929TP · Substantial damage
  > The loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.
- [NTSB NYC03LA134](https://openairdocs.org/ntsb/NYC03LA134.md): Cessna 150L · Mount Holly, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 2003 · N18146 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB MIA03CA132](https://openairdocs.org/ntsb/MIA03CA132.md): Parsons Trainer · New Smyrna, FL · Accident · Minor injuries · Data collection · Final report · Jun 23, 2003 · UNREG · Substantial damage
  > Failure of the pilot to maintain control of the gyrocopter.
- [NTSB LAX03LA209](https://openairdocs.org/ntsb/LAX03LA209.md): Davis LG2H · Salome, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 2003 · N128RD · Substantial damage
  > The pilot's excessive use of the controls during an aborted takeoff, and his failure to maintain airspeed which resulted in a stall/mush. Factors in the accident include the pilot's lack of familiarity with the airplane and an excessively rich mixture setting…
- [NTSB NYC03LA133](https://openairdocs.org/ntsb/NYC03LA133.md): MBB BO-105C · Buffalo, NY · Accident · Serious injuries · Limited investigation · Final report · Jun 20, 2003 · N105SJ · Substantial damage
  > The pilot's improper interpretation of a descent as a power loss and subsequent decision to autorotate, which resulted in a hard landing. A factor in the accident was the collective friction.
- [NTSB DEN03LA108](https://openairdocs.org/ntsb/DEN03LA108.md): Piper PA 28-180 · Green River, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 2003 · N2537R · Substantial damage
  > pilot's improper preflight planning and failure to maintain obstacle clearance. Contributing factors include improper short field takeoff procedures and the high vegetation at the end of the runway.
- [NTSB LAX03LA202](https://openairdocs.org/ntsb/LAX03LA202.md): Bellanca 8GCBC · Williams, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 2003 · N2558Z · Substantial damage
  > the loss of engine power on takeoff for undetermined reasons.
- [NTSB MIA03LA133](https://openairdocs.org/ntsb/MIA03LA133.md): Piper PA-28-180 · Ocean Springs, MS · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2003 · N8378W · Substantial damage
  > A loss of engine power due to starvation as a result of the pilot's continued operation of an airplane with known deficiencies.
- [NTSB FTW03LA181](https://openairdocs.org/ntsb/FTW03LA181.md): Piper PA-36-300 · Gruver, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2003 · N3715E · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL03FA107](https://openairdocs.org/ntsb/ATL03FA107.md): Piper PA-31P · Augusta, GA · Accident · 2 fatal · Field investigation · Final report · Jun 16, 2003 · N577FS · Destroyed
  > The pilot's failure to maintain airspeed while maneuvering on initial take off climb resulting in an inadvertent stall, loss of control, and subsequent in-flight collision with trees and a swamp. A factor in the accident was a reported loss of engine power…
- [NTSB SEA03LA105](https://openairdocs.org/ntsb/SEA03LA105.md): Cessna T337G · Lewistown, MT · Accident · No injuries · Limited investigation · Final report · Jun 15, 2003 · N4TD · Substantial damage
  > Inadequate preflight planning/preparation prior to takeoff, and the pilot's failure to maintain aircraft control during the takeoff. An inadvertent stall and rough terrain were factors.
- [NTSB NYC03FA131](https://openairdocs.org/ntsb/NYC03FA131.md): Cessna 205 · Jeannette, PA · Accident · 4 fatal · Field investigation · Final report · Jun 15, 2003 · N124A · Substantial damage
  > The loss of power caused by fragments of the air filter being ingested in the engine. A factor was the pilot's delayed decision to perform a forced landing after experiencing a partial loss of engine power.
- [NTSB CHI03LA183](https://openairdocs.org/ntsb/CHI03LA183.md): Enstrom 280C · West Branch, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 15, 2003 · N5695D · Substantial damage
  > The loss of engine power due to the fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain the pilot encountered.
- [NTSB CHI03LA161](https://openairdocs.org/ntsb/CHI03LA161.md): Cessna 172M · Gridley, IL · Accident · Minor injuries · Limited investigation · Final report · Jun 15, 2003 · N20553 · Substantial damage
  > The checklist not followed by the pilot and the fuel starvation of the engine. The incorrect fuel tank selector position by the pilot,, and the lack of recurrent training were contributing factors.
- [NTSB MIA03CA128](https://openairdocs.org/ntsb/MIA03CA128.md): Kolb Mkiii · Bunnell, FL · Accident · Minor injuries · Data collection · Final report · Jun 14, 2003 · UNREG · Substantial damage
  > The inadequate preflight inspection of the airplane by the pilot-in-command (pilot) for his failure to assure that the forward attachment of the right horizontal stabilizer was secured and safetied before flight resulting in rotation of the leading edge of…
- [NTSB ANC03LA060](https://openairdocs.org/ntsb/ANC03LA060.md): Longren Centaur L-13 · Chickaloon, AK · Accident · No injuries · Limited investigation · Final report · Jun 14, 2003 · N4062H · Substantial damage
  > The loss of engine power during the takeoff initial climb for an undetermined reason, which resulted in an in-flight collision with water.
- [NTSB IAD03CA057](https://openairdocs.org/ntsb/IAD03CA057.md): Boeing A75N1(PT17) · Sutton, WV · Accident · Minor injuries · Data collection · Final report · Jun 13, 2003 · N55175 · Substantial damage
  > The pilot's failure to abort the takeoff in a timely manner. Factors included the high density altitude conditions, and the pilot's lack of familiarity with the airplane's high density altitude performance characteristics.
- [NTSB SEA03LA098](https://openairdocs.org/ntsb/SEA03LA098.md): Cessna R182 · Kent, WA · Accident · No injuries · Limited investigation · Final report · Jun 12, 2003 · N7568T · Substantial damage
  > The failure of the flaps to operate properly for undetermined reasons during the initial climb and subsequent aborted takeoff. A factor was the collapse of the main landing gear due to an inadequate amount of time for the gear extension process to be…
- [NTSB SEA03FA100](https://openairdocs.org/ntsb/SEA03FA100.md): Aviat A-1 · Atlanta, ID · Accident · 2 fatal · Field investigation · Final report · Jun 12, 2003 · N104CA · Substantial damage
  > Clearance from trees was not maintained during the initial climb. A proper touchdown point was not attained, the pilot's lack of familiarity with the geographic area and trees were factors.
- [NTSB NYC03FA129](https://openairdocs.org/ntsb/NYC03FA129.md): Cessna 150H · Pittsfield, ME · Accident · 2 fatal · Field investigation · Final report · Jun 12, 2003 · N6566S · Destroyed
  > The inadvertent resumption of power during a forced landing that resulted in a subsequent spin. Factors related to the accident were the CFI's delayed remedial action, the loss of engine power due to contaminated fuel, an obstructed fuel screen, and the…
- [NTSB DEN03TA102](https://openairdocs.org/ntsb/DEN03TA102.md): Cessna 182R · Hobbs, NM · Accident · Minor injuries · Final report · Jun 12, 2003 · N6319H · Destroyed
  > The pilot's failure to maintain airspeed, which resulted in a stall.
- [NTSB MIA03LA119](https://openairdocs.org/ntsb/MIA03LA119.md): Piper PA-28R-180 · Olive Branch, MS · Accident · Minor injuries · Limited investigation · Final report · Jun 10, 2003 · N4658J · Substantial damage
  > The pilot's operation of the airplane with known deficiencies (water contamination of the fuel) resulting in loss of engine power shortly after takeoff and damage to airframe during the subsequent forced landing.
- [NTSB NYC03LA124](https://openairdocs.org/ntsb/NYC03LA124.md): Piper PA-28-140 · Aurora, NY · Accident · No injuries · Limited investigation · Final report · Jun 8, 2003 · N560FL · Substantial damage
  > The pilot's failure to obtain the proper climb rate.

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

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

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