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

## Cases, newest first

- [NTSB LAX06CA060](https://openairdocs.org/ntsb/LAX06CA060.md): Robinson R22 Beta · Irwindale, CA · Accident · No injuries · Data collection · Final report · Dec 19, 2005 · N177LH · Destroyed
  > The pilot failed to maintain adequate main rotor rpm.
- [NTSB NYC06LA035](https://openairdocs.org/ntsb/NYC06LA035.md): Robinson R44 · Linden, NJ · Accident · No injuries · Limited investigation · Final report · Dec 18, 2005 · N44EK · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB MIA06LA028](https://openairdocs.org/ntsb/MIA06LA028.md): Mestas Felix R Velocity LWFG-E · Punta Gorda, FL · Accident · No injuries · Limited investigation · Final report · Dec 10, 2005 · N535BM · Destroyed
  > A loss of engine power for undetermined reasons.
- [NTSB SEA06CA025](https://openairdocs.org/ntsb/SEA06CA025.md): Piper PA-18-150 · Prineville, OR · Accident · No injuries · Data collection · Final report · Dec 9, 2005 · N2584S · Substantial damage
  > Aircraft control not maintained by the private pilot during the initial takeoff climb, and the improper remedial action by the flight instructor. A factor was the wind gust.
- [NTSB DFW06FA037](https://openairdocs.org/ntsb/DFW06FA037.md): Piper PA-30 · Raymond, MS · Accident · 3 fatal · Field investigation · Final report · Dec 1, 2005 · N7315Y · Destroyed
  > The pilot's failure to maintain Vmc (velocity minimum control) on initial climb resulting in a loss of control. Contributing factors were the loss of engine power to the right engine and the prevailing gusty wind conditions.
- [NTSB CHI06CA039](https://openairdocs.org/ntsb/CHI06CA039.md): Larson Aero Comp-6 · Brainerd, MN · Accident · Serious injuries · Data collection · Final report · Nov 30, 2005 · N4334Z · Substantial damage
  > The pilot/builder inadvertently reversed the aileron control systems during installation and failed to maintain control of the airplane during takeoff. A factor associated with the accident was the pilot/builder’s failure to perform an adequate aircraft…
- [NTSB DFW06CA034](https://openairdocs.org/ntsb/DFW06CA034.md): Cessna 210M · Kirbyville, TX · Accident · No injuries · Data collection · Final report · Nov 28, 2005 · N761FL · Substantial damage
  > The total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DFW06CA035](https://openairdocs.org/ntsb/DFW06CA035.md): Cessna P206 · New Braunfels, TX · Accident · No injuries · Data collection · Final report · Nov 23, 2005 · N2564X · Substantial damage
  > The pilot's improper compensation for the existing wind conditions resulting in a loss of control. A contributing factor was the gusty crosswind.
- [NTSB SEA06IA019](https://openairdocs.org/ntsb/SEA06IA019.md): Gulfstream Aerospace G-5 · Hillsboro, OR · Incident · No injuries · Incident investigation · Final report · Nov 21, 2005 · N225GV · Minor damage
  > The failure of the right main landing gear (MLG) door uplock linkage actuator due to corrosion, which resulted in jamming of the right MLG during the initial takeoff climb.
- [NTSB LAX06LA041](https://openairdocs.org/ntsb/LAX06LA041.md): Tingle Special · Tucson, AZ · Accident · 2 fatal · Limited investigation · Final report · Nov 19, 2005 · N660T · Destroyed
  > The pilot's excessive use of power during takeoff, which resulted in an inadvertent torque roll shortly after lift off. Also causal was the pilot's failure to abort the takeoff when directional control could not be maintained during the takeoff roll.
- [NTSB NYC06FA029](https://openairdocs.org/ntsb/NYC06FA029.md): Piper PA-28-161 · Leesburg, VA · Accident · 2 fatal · Field investigation · Final report · Nov 9, 2005 · N4171T · Substantial damage
  > The flight instructor's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with trees and terrain.
- [NTSB NYC06LA028](https://openairdocs.org/ntsb/NYC06LA028.md): Cessna 172L · Lehighton, PA · Accident · No injuries · Limited investigation · Final report · Nov 8, 2005 · N7684G · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power during takeoff due to fuel contamination, and a subsequent forced landing to a field.
- [NTSB LAX06LA029](https://openairdocs.org/ntsb/LAX06LA029.md): Cessna 150F · Mesa, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 2005 · N8903S · Substantial damage
  > the failure of the flap motor fuse that rendered the flaps inoperable during a critical phase of flight. Factors in the accident were the lack of suitable terrain to perform an emergency landing and the owner's use of nonapproved fuses for the flap motor…
- [NTSB ATL06CA118](https://openairdocs.org/ntsb/ATL06CA118.md): Cessna 172N · Perry, GA · Accident · No injuries · Data collection · Final report · Nov 7, 2005 · N3015E · Substantial damage
  > The student pilot's failure to maintain airspeed during a touch-and-go landing on initial takeoff climb, resulting in a hard landing on the departure runway.
- [NTSB DFW06FA019](https://openairdocs.org/ntsb/DFW06FA019.md): Cessna 500 · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2005 · N505K · Destroyed
  > The pilot's failure to maintain directional control of the airplane resulting in an inadvertent stall/mush. Contributing factors were the unsecured passenger door and the pilot's diverted attention.
- [NTSB CHI06CA024](https://openairdocs.org/ntsb/CHI06CA024.md): Colson/Goodbread Rans S-12 · Flushing, MI · Accident · Minor injuries · Data collection · Final report · Oct 29, 2005 · N62078 · Substantial damage
  > The loss of engine power on initial climb for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.
- [NTSB SEA06CA014](https://openairdocs.org/ntsb/SEA06CA014.md): Aeronca 7AC · Yelm, WA · Accident · Serious injuries · Data collection · Final report · Oct 27, 2005 · N85534 · Substantial damage
  > The complete loss of engine power during the initial climb for undetermined reasons, and the excessive descent rate during the ensuing forced landing.
- [NTSB ANC06CA006](https://openairdocs.org/ntsb/ANC06CA006.md): Cessna 172 · Naknek, AK · Accident · No injuries · Data collection · Final report · Oct 23, 2005 · N6832A · Substantial damage
  > The pilot's inadequate removal of frost from the wings, and his failure to attain adequate airspeed during takeoff initial climb, which resulted in a stall and collision with terrain. Factors contributing to the accident were the pilot's delayed aborted…
- [NTSB DFW06CA015](https://openairdocs.org/ntsb/DFW06CA015.md): Chamberlain Vans RV6 · Eunice, LA · Accident · Minor injuries · Data collection · Final report · Oct 22, 2005 · N296PC · Substantial damage
  > The loss of engine power for undetermined reason. A contributing factor was lack of suitable terrain for the forced landing.
- [NTSB MIA06FA007](https://openairdocs.org/ntsb/MIA06FA007.md): Cessna 172P · La Belle, FL · Accident · 1 fatal · Field investigation · Final report · Oct 16, 2005 · N99173 · Substantial damage
  > The student pilot's failure to maintain airspeed during the initial takeoff climb, resulting in an inadvertent stall/spin and uncontrolled descent to ground impact. A contributing factor was the failure of the wing flap control, which resulted in the flaps…
- [NTSB DEN06LA007](https://openairdocs.org/ntsb/DEN06LA007.md): Piper PA-22-150 · New Century, KS · Accident · No injuries · Limited investigation · Final report · Oct 12, 2005 · N8875D · Substantial damage
  > loss of engine power due to the pilot's improper use of carbuetor heat and his improper inflight planning/decision. Contributing factors were the inadequate supervision of the student by the flight instructor, conditions conducive to carburetor ice, dark…
- [NTSB LAX06CA007](https://openairdocs.org/ntsb/LAX06CA007.md): Appel RDA 04 · Clovis, NM · Accident · No injuries · Data collection · Final report · Oct 11, 2005 · N835RA · Substantial damage
  > a loss of engine power due to water contamination of the fuel system. The inadequate placement of the fuel system drain by the builder was a factor.
- [NTSB LAX06FA005](https://openairdocs.org/ntsb/LAX06FA005.md): American Champion 8KCAB · Oroville, CA · Accident · 2 fatal · Field investigation · Final report · Oct 10, 2005 · N943D · Destroyed
  > The certified flight instructor and the private pilot's failure to maintain adequate airspeed while attempting a return to runway maneuver, which resulted in an inadvertent stall.
- [NTSB MIA06LA004](https://openairdocs.org/ntsb/MIA06LA004.md): Beech 95-B55 · Lakeland, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 2005 · N6413S · Destroyed
  > The failure of the pilot-in-command to abort the takeoff.
- [NTSB MIA06LA001](https://openairdocs.org/ntsb/MIA06LA001.md): Pilatus PC-6/B2-H2 · Deland, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 2005 · N7895J · Substantial damage
  > The pilot's incorrect setting of the stabilizer trim and his failure to maintain adequate airspeed during takeoff initial climb, which resulted in a stall. A factor contributing to the accident was an inadvertent stall. A factor contributing to the severity…
- [NTSB SEA06CA001](https://openairdocs.org/ntsb/SEA06CA001.md): Cessna 150D · Greenwater, WA · Accident · Minor injuries · Data collection · Final report · Oct 2, 2005 · N4175U · Destroyed
  > The pilot's inadvertently flying into IMC weather conditions, his failure to maintain sufficient airspeed for flight, and his subsequent inadvertent stall/mush into trees. Contributing factors were the fog and the trees.
- [NTSB IAD05LA144](https://openairdocs.org/ntsb/IAD05LA144.md): Howard Whyte Nieuport 28 · Dayton, OH · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2005 · N62610 · Substantial damage
  > A loss of engine power due to the installation of incorrect spring type terminal contacts which were accidentally supplied by the engine distributor.
- [NTSB DFW05CA253](https://openairdocs.org/ntsb/DFW05CA253.md): Cessna 172S · Batesville, TX · Accident · No injuries · Data collection · Final report · Sep 29, 2005 · N5343U · Substantial damage
  > The pilot's failure to maintain clearance from the tree. A contributing factor was the gusty winds.
- [NTSB SEA05FA201](https://openairdocs.org/ntsb/SEA05FA201.md): Cessna P210N · Salmon, ID · Accident · 2 fatal · Field investigation · Final report · Sep 28, 2005 · N45SE · Destroyed
  > The pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.
- [NTSB LAX05LA319](https://openairdocs.org/ntsb/LAX05LA319.md): Rose Kitfox · Hesperia, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 2005 · N656T · Substantial damage
  > a loss of engine power due to a loose master ignition relay wire.
- [NTSB LAX05LA317](https://openairdocs.org/ntsb/LAX05LA317.md): Cessna A185F · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Sep 26, 2005 · N8548Q · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB SEA05CA197](https://openairdocs.org/ntsb/SEA05CA197.md): Cessna 180H · Yelm, WA · Accident · No injuries · Data collection · Final report · Sep 22, 2005 · N1037V · Substantial damage
  > The mixture control linkage separation as a result of a missing retaining nut and washer on the mixture cable attach bolt. Inadequate maintenance inspection and fences were factors.
- [NTSB LAX05IA312](https://openairdocs.org/ntsb/LAX05IA312.md): Airbus Industrie A320 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Sep 22, 2005 · N536JB · Minor damage
  > The fatigue failure of two anti-rotation lugs due to repeated cyclic pre-landing tests, which allowed the nosewheels to deviate from the 0-degree position on landing gear retraction. A contributing factor was the design of the Brake Steering Control Unit…
- [NTSB DFW05CA247](https://openairdocs.org/ntsb/DFW05CA247.md): Smith, Ted Aerostar 601P · Mexia, TX · Accident · Minor injuries · Data collection · Final report · Sep 22, 2005 · N909KF · Destroyed
  > The pilot's failure to maintain clearance from the barn. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.
- [NTSB LAX05LA309](https://openairdocs.org/ntsb/LAX05LA309.md): Thomas RV4 · Kernville, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 21, 2005 · N3882N · Substantial damage
  > a loss of engine power due to fuel starvation caused by the pilot's failure to select a tank containing fuel for takeoff. A factor in the accident was the lack of a runway overrun area beyond the departure end of the runway.
- [NTSB NYC05LA144](https://openairdocs.org/ntsb/NYC05LA144.md): Piper PA-28-180 · Millville, NJ · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2005 · N6494J · Substantial damage
  > The flight instructor's improper in-flight decision to perform a emergency landing to a runway, with a tailwind, and his failure to maintain airspeed after aborting that landing, which resulted in an inadvertent stall and subsequent impact with terrain.…
- [NTSB LAX05LA305](https://openairdocs.org/ntsb/LAX05LA305.md): Beech 35-C33 · Bisbee, AZ · Accident · No injuries · Limited investigation · Final report · Sep 19, 2005 · N5757D · Substantial damage
  > the pilot's failure to lean the mixture in accordance with the pilot operating handbook specified procedures, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush…
- [NTSB SEA05CA195](https://openairdocs.org/ntsb/SEA05CA195.md): Eiland RAF-200 Gyro · Bend, OR · Accident · Minor injuries · Data collection · Final report · Sep 18, 2005 · N4416N · Substantial damage
  > The malfunction of the flight controls for an undetermined reason, which resulted in a loss of control and in-flight collision with terrain.
- [NTSB DFW05FA241](https://openairdocs.org/ntsb/DFW05FA241.md): Piper PA-46-310P · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Sep 18, 2005 · N69146 · Destroyed
  > The pilot's improper in-flight decision to maneuver back to the departure airport following a loss of engine power on initial climb. Contributing factors were the loss of engine power for undetermined reasons, and the dark night conditions.
- [NTSB MIA05LA158](https://openairdocs.org/ntsb/MIA05LA158.md): Cessna 172C · Saint Cloud, FL · Accident · 2 fatal · Limited investigation · Final report · Sep 16, 2005 · N1814Y · Destroyed
  > The pilot's failure to maintain the airspeed while maneuvering following loss of engine power resulting in a stall/mush, an uncontrolled descent, and collision with trees and the ground.
- [NTSB SEA05LA194](https://openairdocs.org/ntsb/SEA05LA194.md): Cessna 182P · Yellow Pine, ID · Accident · No injuries · Limited investigation · Final report · Sep 15, 2005 · N58717 · Substantial damage
  > The pilot's improper preflight planning/preparation during takeoff. A factor was the windshear.
- [NTSB CHI05CA271](https://openairdocs.org/ntsb/CHI05CA271.md): Bell 206B · Elk Point, SD · Accident · No injuries · Data collection · Final report · Sep 15, 2005 · N2995W · Substantial damage
  > The loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.
- [NTSB DFW05CA237](https://openairdocs.org/ntsb/DFW05CA237.md): Cessna 172M · Amarillo, TX · Accident · Minor injuries · Data collection · Final report · Sep 14, 2005 · N19998 · Destroyed
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Contributing factors were the reported loss of engine power for undetermined reasons and the high density altitude.
- [NTSB SEA05CA191](https://openairdocs.org/ntsb/SEA05CA191.md): Gleason Sky Star Kitfox · Klamath Falls, OR · Accident · No injuries · Data collection · Final report · Sep 12, 2005 · N852PG · Substantial damage
  > The binding of the flaperon push pull tube due to deformation of the front seat, which resulted in a loss of control on takeoff initial climb and collision with the runway.
- [NTSB LAX05FA296](https://openairdocs.org/ntsb/LAX05FA296.md): Cessna 152 · Lakewood, CA · Accident · 2 fatal · Field investigation · Final report · Sep 11, 2005 · N6565L · Destroyed
  > the certified flight instructor's failure to maintain an adequate airspeed resulting in a stall and loss of control. Also causal was the engine's loss of partial power due to inadequate maintenance, worn spark plugs, worn pistons, and broken piston rings.
- [NTSB LAX05CA295](https://openairdocs.org/ntsb/LAX05CA295.md): Ricardo Lopez RAF 2000 Gtxse · Wickenburg, AZ · Accident · Minor injuries · Data collection · Final report · Sep 11, 2005 · N282SL · Substantial damage
  > the pilot's failure to obtain and maintain an adequate airspeed and rotor speed during takeoff.
- [NTSB NYC05LA141](https://openairdocs.org/ntsb/NYC05LA141.md): Piper PA-28-140 · Marstons Mills, MA · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 2005 · N6777W · Substantial damage
  > The pilot's failure to attain a climb during takeoff which resulted in a diminished climb rate and subsequent collision with trees. Factors were the turf runway and a tailwind.
- [NTSB LAX05CA294](https://openairdocs.org/ntsb/LAX05CA294.md): Schweizer SGS2-33A · Peoria, AZ · Accident · No injuries · Data collection · Final report · Sep 10, 2005 · N2054T · Substantial damage
  > the pilot's encounter with obstacles and unsuitable terrain in the landing area during the pilot's attempted precautionary landing. A factor in the accident was the loose wing root gap seal fairing.
- [NTSB SEA05LA192](https://openairdocs.org/ntsb/SEA05LA192.md): North American AT-6D · Chehalis, WA · Accident · No injuries · Limited investigation · Final report · Sep 9, 2005 · N3617F · Substantial damage
  > The pilot's failure to follow the checklist to switch to the fullest fuel tank prior to departure which resulted in fuel starvation and a loss of engine power during the initial takeoff climb. Subsequently, the aircraft landed hard damaging the landing gear…
- [NTSB CHI05LA261](https://openairdocs.org/ntsb/CHI05LA261.md): Piper PA-28-235 · Faulkton, SD · Accident · 1 fatal · Limited investigation · Final report · Sep 9, 2005 · N8523W · Destroyed
  > The pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.

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

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

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