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

## Cases, newest first

- [NTSB ANC05CA139](https://openairdocs.org/ntsb/ANC05CA139.md): Piper PA-18 · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Sep 6, 2005 · N1907A · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall/mush, and subsequent in-flight collision with trees. A factor contributing to the accident was a tailwind.
- [NTSB ANC05LA133](https://openairdocs.org/ntsb/ANC05LA133.md): Cessna 206 · Yakutat, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 2005 · N4991F · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, and his failure to maintain adequate airspeed during takeoff initial climb from a remote airstrip, which resulted in the airplane descending to the ground and colliding with soft terrain beyond the end…
- [NTSB CHI05LA250](https://openairdocs.org/ntsb/CHI05LA250.md): Porterfield FP-65 · Sedalia, MO · Accident · 1 fatal · Limited investigation · Final report · Sep 1, 2005 · N37855 · Substantial damage
  > The pilot's failure to maintain sufficient airspeed and the inadvertent stall/spin resulting in an in-flight loss of control and collision with terrain.
- [NTSB DEN05LA133](https://openairdocs.org/ntsb/DEN05LA133.md): Piper PA-28R-180 · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 2005 · N9069E · Destroyed
  > the flight instructor's failure to maintain adequate airspeed resulting in an inadvertent stall. Contributing factor's include the flight instructor's improper pre-flight planning and decision in accepting the intersection departure, and the flight…
- [NTSB CHI05TA251](https://openairdocs.org/ntsb/CHI05TA251.md): Cessna 182R · New Ulm, MN · Accident · No injuries · Final report · Aug 31, 2005 · N505NR · Substantial damage
  > The loss of engine power for undetermined reasons resulting in a forced landing. A contributing factor was the soft terrain condition.
- [NTSB ATL05LA156](https://openairdocs.org/ntsb/ATL05LA156.md): Cessna 172S · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Aug 31, 2005 · N5213M · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CHI05CA246](https://openairdocs.org/ntsb/CHI05CA246.md): Ayres S2R-G10 · Davenport, ND · Accident · No injuries · Data collection · Final report · Aug 29, 2005 · N3024U · Substantial damage
  > The pilot failed to gain suffient altitude during takeoff in order to clear the corn crop at the end of the runway. A factor associated with the accident was the corn crop.
- [NTSB CHI05CA245](https://openairdocs.org/ntsb/CHI05CA245.md): Air Tractor AT-502 · Hector, MN · Accident · No injuries · Data collection · Final report · Aug 29, 2005 · N4550N · Substantial damage
  > The pilot's failure to achieve adequate airspeed on takeoff which resulted in the airplane entering a stall/mush when it flew out of ground effect while crossing a large drainage ditch on takeoff.
- [NTSB ANC05CA132](https://openairdocs.org/ntsb/ANC05CA132.md): Cessna 172 · Tyonek, AK · Accident · No injuries · Data collection · Final report · Aug 29, 2005 · N4714F · Substantial damage
  > The pilot's inadequate compensation for wind conditions during takeoff-initial climb, which resulted in a loss of control, and subsequent in-flight collision with a creek. A factor associated with the accident is a sudden windshift.
- [NTSB SEA05LA177](https://openairdocs.org/ntsb/SEA05LA177.md): Tichacek N-3 Pup · Mead, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 2005 · N7702X · Destroyed
  > The total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB SEA05LA176](https://openairdocs.org/ntsb/SEA05LA176.md): Alon A-2A · Helena, MT · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 2005 · N5467F · Substantial damage
  > The loss of engine power for undetermined reasons, which resulted in a forced landing and nose over. A factor contributing to the accident was the ground bordering the runway pavement.
- [NTSB MIA05FA152](https://openairdocs.org/ntsb/MIA05FA152.md): Bellanca 7ECA · Freeport, FL · Accident · 2 fatal · Field investigation · Final report · Aug 20, 2005 · N90914 · Substantial damage
  > The failure of the pilot to maintain airspeed resulting in inadvertent stall, uncontrolled descent, and in-flight collision with terrain.
- [NTSB DFW05IA222](https://openairdocs.org/ntsb/DFW05IA222.md): Air Tractor AT-401 · Winnie, TX · Incident · No injuries · Incident investigation · Final report · Aug 19, 2005 · N4545W · Minor damage
  > The loss of engine power due to the failure of the second-stage turbine wheel as a result of low cycle fatigue.
- [NTSB DFW05CA212](https://openairdocs.org/ntsb/DFW05CA212.md): Grumman G164B · Alexandria, LA · Accident · No injuries · Data collection · Final report · Aug 16, 2005 · N6903K · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the high density altitude.
- [NTSB ATL05FA144](https://openairdocs.org/ntsb/ATL05FA144.md): MBB BK 117 B-1 · Jacksonville, FL · Accident · No injuries · Field investigation · Final report · Aug 14, 2005 · N117US · Substantial damage
  > The pilot in-flight decision to land in a unsuitable landing area during a precautionary landing. A factor was the loss of power on the number two engine.
- [NTSB NYC05LA133](https://openairdocs.org/ntsb/NYC05LA133.md): Palen Nieuport 11 · Rhinebeck, NY · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 2005 · N9163A · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB MIA05LA150](https://openairdocs.org/ntsb/MIA05LA150.md): Globe GC-1B · Vero Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 2005 · N2219S · Substantial damage
  > The partial loss of engine power for undetermined reasons resulting in the in-flight collision with trees during an emergency descent.
- [NTSB CHI05LA229](https://openairdocs.org/ntsb/CHI05LA229.md): Grumman G-164A · Marshalltown, IA · Accident · No injuries · Limited investigation · Final report · Aug 12, 2005 · N9632 · Substantial damage
  > The loss of engine power for undetermined reasons during initial climb and the unsuitable landing area encountered by the pilot during a forced landing.
- [NTSB ANC05LA120](https://openairdocs.org/ntsb/ANC05LA120.md): Piper PA-18-150 · Chickaloon, AK · Accident · No injuries · Limited investigation · Final report · Aug 9, 2005 · N717DR · Substantial damage
  > A loss of engine power for an undetermined reason during initial climb after takeoff, which resulted in a emergency landing/collision with terrain.
- [NTSB SEA05LA165](https://openairdocs.org/ntsb/SEA05LA165.md): Cessna 120 · Chiloquin, OR · Accident · 1 fatal · Limited investigation · Final report · Aug 7, 2005 · N627DM · Destroyed
  > The pilot's failure to maintain airspeed and a loss of control during a pull-up maneuver. A factor contributing to the accident was the inadvertent stall/spin, which resulted in the subsequent collision with terrain.
- [NTSB IAD05LA116](https://openairdocs.org/ntsb/IAD05LA116.md): O'Connor Air Command Elite · Cincinnati, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2005 · N2416P · Substantial damage
  > The pilot's improper flare following a partial loss of engine power, which resulted in a hard landing. A factor was the partial loss of engine power for unknown reasons.
- [NTSB DEN05LA121](https://openairdocs.org/ntsb/DEN05LA121.md): Sheel Vans RV-8 · Fort Collins, CO · Accident · 1 fatal · Limited investigation · Final report · Aug 7, 2005 · N5754S · Substantial damage
  > the pilot inadvertently stalling the airplane and descending into the ground. Contributing factors were the pilot's inadequate preflight planning/preparation and his failure to refuel the airplane, resulting in a loss of engine power due to fuel exhaustion.
- [NTSB MIA05LA146](https://openairdocs.org/ntsb/MIA05LA146.md): Gustafson Easy Eagle · Milton, FL · Accident · 1 fatal · Limited investigation · Final report · Aug 6, 2005 · N707DG · Destroyed
  > A loss of engine power during initial climb after takeoff for an undetermined reason, which resulted in a forced landing and subsequent in-flight collision with tree-covered terrain.
- [NTSB IAD05LA115](https://openairdocs.org/ntsb/IAD05LA115.md): Cessna 182B · East Moriches, NY · Accident · No injuries · Limited investigation · Final report · Aug 6, 2005 · N2422G · Substantial damage
  > The improper installation of the right magneto harness to the magneto housing by unidentified maintenance personnel, which resulted in arcing, significant wear, and a subsequent loss of engine power. Factors in the accident were the pilot's failure to attain…
- [NTSB ATL05FA139](https://openairdocs.org/ntsb/ATL05FA139.md): Beech BE-D35 · Decatur, AL · Accident · 1 fatal · Field investigation · Final report · Aug 6, 2005 · N3468B · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation, and subsequent inadvertent stall/spin during the forced landing.
- [NTSB ATL05CA138](https://openairdocs.org/ntsb/ATL05CA138.md): Beech C24R · Lumberton, NC · Accident · Minor injuries · Data collection · Final report · Aug 6, 2005 · N67076 · Substantial damage
  > The pilot's improper/inadequate evaluation of the weather, which resulted into flight into a thunderstorm.
- [NTSB CHI05FA212](https://openairdocs.org/ntsb/CHI05FA212.md): Cessna 421C · Wheeling, IL · Accident · Minor injuries · Field investigation · Final report · Aug 5, 2005 · N421KC · Destroyed
  > The pilot's improper in-flight decision to execute a go-around without raising the landing gear and raising the flaps to the full UP position, resulting in low airspeed and the airplane stalling. Contributing factors to the accident included the pilot's…
- [NTSB DFW05CA201](https://openairdocs.org/ntsb/DFW05CA201.md): Smith Aerostar 601P · Sinton, TX · Accident · Minor injuries · Data collection · Final report · Aug 4, 2005 · N15BA · Destroyed
  > The pilot's failure to abort the takeoff and the subsequent loss of engine power for undetermined reasons. Contributing factors were the attempted operation of the airplane with known deficiencies in the equipment and the lack of suitable terrain for the…
- [NTSB MIA05FA140](https://openairdocs.org/ntsb/MIA05FA140.md): Cessna 172S · Key West, FL · Accident · 4 fatal · Field investigation · Final report · Jul 31, 2005 · N65982 · Destroyed
  > The failure of the pilot-in-command to maintain directional control of the airplane during the dark, night flight over water, resulting in the uncontrolled descent and in-flight collision with the water. A contributing factor in the accident was the pilot's…
- [NTSB MIA05FA139](https://openairdocs.org/ntsb/MIA05FA139.md): Mooney M20C · Natchez, MS · Accident · 3 fatal · Field investigation · Final report · Jul 30, 2005 · N6555U · Destroyed
  > The pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and subsequent uncontrolled descent to ground impact. A contributing factor was the pilot's lack of experience in complex…
- [NTSB CHI05CA204](https://openairdocs.org/ntsb/CHI05CA204.md): Wilson Acrolite 1T · Oshkosh, WI · Accident · Minor injuries · Data collection · Final report · Jul 29, 2005 · C-IAVT · Substantial damage
  > The partial loss of engine power due to an obstructed carburetor fuel metering jet. Factors to the accident included the low altitude at which the loss of engine power occurred, the contamination of the fuel system from degraded automobile-style fuel lines,…
- [NTSB DFW05FA192](https://openairdocs.org/ntsb/DFW05FA192.md): Aero Commander 112 · Junction, TX · Accident · 2 fatal · Field investigation · Final report · Jul 27, 2005 · N1029J · Destroyed
  > The pilot's failure to attain the proper climb rate resulting in the airplane's wing colliding with a tree and subsequent impact with the ground. Contributing factors were the pilot's improper use of the airplane's flaps, and the rising terrain.
- [NTSB ANC05LA107](https://openairdocs.org/ntsb/ANC05LA107.md): Aerospatiale AS-350BA · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Jul 25, 2005 · N57958 · Substantial damage
  > A loss of engine power during takeoff initial climb due to the separation of the engine power turbine shaft, the failure of which was due to a disconnected adjacent leaf spring, which resulted in an emergency landing after takeoff and subsequent hard landing.
- [NTSB IAD05LA113](https://openairdocs.org/ntsb/IAD05LA113.md): Piper PA-22-150 · Chatham, VA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2005 · N3818P · Substantial damage
  > The pilot's failure to ensure that the fuel selector valve was properly engaged, which resulted in fuel starvation and subsequent loss of engine power.
- [NTSB DEN05FA114](https://openairdocs.org/ntsb/DEN05FA114.md): Beech N35 · West Jordan, UT · Accident · 3 fatal · Field investigation · Final report · Jul 24, 2005 · N31TE · Destroyed
  > the pilot's improper preflight planning, his attempted flight into adverse weather conditions, and the stall resulting in the loss of control and subsequent crash. Factors contributing to the accident were the pilot's inadequate evaluation of the weather…
- [NTSB ANC05CA105](https://openairdocs.org/ntsb/ANC05CA105.md): Jeska Murphy Rebel · Kivalina, AK · Accident · No injuries · Data collection · Final report · Jul 23, 2005 · N7478T · Substantial damage
  > The pilot's failure to attain adequate airspeed during takeoff-initial climb, which resulted in a stall and collision with a ditch. A factor contributing to the accident was the ditch.
- [NTSB LAX05LA244](https://openairdocs.org/ntsb/LAX05LA244.md): Cessna 208B · Globe, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2005 · N717BT · Substantial damage
  > The fatigue failure of the compressor turbine stator vane, the liberation of vane material into the compressor turbine, and the total loss of engine power. Also causal was the operator's failure to inspect the compressor turbine vane during fuel nozzle checks.
- [NTSB LAX05GA243](https://openairdocs.org/ntsb/LAX05GA243.md): Aero Commander 680 FL · Las Vegas, NV · Accident · Serious injuries · Final report · Jul 22, 2005 · N7UP · Destroyed
  > The pilot's excessive selection of flaps prior to takeoff, which resulted in a failure to obtain/maintain an appropriate climb airspeed, and an inadvertent stall/mush during takeoff-initial climb. A factor contributing to the accident was a high density…
- [NTSB NYC05LA121](https://openairdocs.org/ntsb/NYC05LA121.md): Ratliff Hummel Bird · Pittsville, MD · Accident · 1 fatal · Limited investigation · Final report · Jul 19, 2005 · N707TR · Substantial damage
  > A loss of control for undetermined reasons, which resulted in an uncontrolled descent into terrain.
- [NTSB CHI05FA189](https://openairdocs.org/ntsb/CHI05FA189.md): Piper PA-30 · Aurora, MO · Accident · 3 fatal · Field investigation · Final report · Jul 18, 2005 · N7868Y · Substantial damage
  > The pilot not maintaining adequate airspeed and aircraft control during initial climb, which resulted in an inadvertent stall/spin at a low altitude. A factor to the accident was the pilot operating the airplane over its certified maximum gross weight.
- [NTSB SEA05CA143](https://openairdocs.org/ntsb/SEA05CA143.md): Beech A36 · Sequim, WA · Accident · No injuries · Data collection · Final report · Jul 14, 2005 · N3119T · Substantial damage
  > The temporary loss of engine power for an undetermined reason during the takeoff initial climb.
- [NTSB NYC05LA119](https://openairdocs.org/ntsb/NYC05LA119.md): Pratt Ultravia Pelican-PL · Middlebury, VT · Accident · No injuries · Limited investigation · Final report · Jul 12, 2005 · N412JP · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB NYC05LA118](https://openairdocs.org/ntsb/NYC05LA118.md): Piper PA-28-180 · Elyria, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 2005 · N9233J · Substantial damage
  > A loss of engine power during initial climb, as reported by the pilot, for an undetermined reason which resulted in a collision with trees.
- [NTSB CHI05LA177](https://openairdocs.org/ntsb/CHI05LA177.md): North American P-51D · Tarkio, MO · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 2005 · N10607 · Substantial damage
  > A loss of engine power due to undetermined reasons and the unsuitable terrain encountered during the forced landing.
- [NTSB ANC05LA100](https://openairdocs.org/ntsb/ANC05LA100.md): PZL Warzawa-Okecie 104 Wilga 80 · Platinum, AK · Accident · No injuries · Limited investigation · Final report · Jul 4, 2005 · N2245T · Substantial damage
  > A loss of engine power for an undetermined reason during takeoff initial climb from a remote beach, which resulted in a ditching and subsequent nose over.
- [NTSB ANC05CA092](https://openairdocs.org/ntsb/ANC05CA092.md): Sweeney Preceptor Ultra Pup · Chitina, AK · Accident · No injuries · Data collection · Final report · Jul 4, 2005 · N106TB · Substantial damage
  > The pilot's failure to abort the takeoff, and his premature lift-off resulting in a stall due to inadequate airspeed. The pilot's selection of unsuitable terrain for takeoff was a contributing factor.
- [NTSB SEA05CA140](https://openairdocs.org/ntsb/SEA05CA140.md): Piper PA-22 · Kamaih, ID · Accident · No injuries · Data collection · Final report · Jul 3, 2005 · N1735P · Substantial damage
  > Fuel starvation due to the pilot's improper placement of the fuel selector, resulting in a loss of engine power, and collision with terrain.
- [NTSB IAD05LA090](https://openairdocs.org/ntsb/IAD05LA090.md): Aeronca 11CC · Charlotte, VT · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 2005 · N4337E · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and impact with terrain. A factor in the accident was the partial loss of engine power for undetermined reasons.
- [NTSB LAX05LA222](https://openairdocs.org/ntsb/LAX05LA222.md): Quiksilver MX LII Sport · Palmdale, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 2, 2005 · UNREG · Destroyed
  > an in-flight loss of control for undetermined reasons.
- [NTSB ANC05LA093](https://openairdocs.org/ntsb/ANC05LA093.md): Bellanca 7GCBC · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jul 2, 2005 · N88110 · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in a loss of control and subsequent uncontrolled descent into a lake. A factor contributing to the accident was an inadvertent stall.

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

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

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