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

## Cases, newest first

- [NTSB LAX04LA203](https://openairdocs.org/ntsb/LAX04LA203.md): Schleicher ASW-20 · Reno, NV · Accident · 1 fatal · Limited investigation · Final report · May 8, 2004 · N126PS · Destroyed
  > the pilot's failure to maintain an adequate airspeed margin while performing a return to runway maneuver, which led to a stall and spin. Factors in the accident were: 1) the deteriorated condition of the glider towrope, which resulted in towrope failure…
- [NTSB DEN04CA068](https://openairdocs.org/ntsb/DEN04CA068.md): Ercoupe 415G · Falcon, CO · Accident · Minor injuries · Data collection · Final report · May 5, 2004 · N94405 · Destroyed
  > the pilot's failure to maintain aircraft control. A contributing factor was the clear air turbulence encounter.
- [NTSB NYC04IA116](https://openairdocs.org/ntsb/NYC04IA116.md): Dornier DO-328-100 · Allentown, PA · Incident · No injuries · Incident investigation · Final report · May 3, 2004 · N441JS · No damage
  > The opening of the main cabin door after takeoff, for undetermined reasons.
- [NTSB FTW04LA105](https://openairdocs.org/ntsb/FTW04LA105.md): Cessna 150J · Lake Dallas, TX · Accident · No injuries · Limited investigation · Final report · May 2, 2004 · N60539 · Substantial damage
  > The pilot's failure to maintain proper airspeed for flight resulting in a stall/spin during the forced landing. A contributing factors was the loss of engine power for undetermined reasons.
- [NTSB ANC04LA050](https://openairdocs.org/ntsb/ANC04LA050.md): Cessna U206F · Nanwalek, AK · Accident · No injuries · Limited investigation · Final report · May 2, 2004 · N35860 · Substantial damage
  > A loss of directional control for an undetermined reason during takeoff-initial climb, which resulted in the left wing colliding with the ground.
- [NTSB IAD04LA018](https://openairdocs.org/ntsb/IAD04LA018.md): Beech A36 · Bedford, MA · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 2004 · N3243P · Substantial damage
  > The mechanic's failure to properly torque the engine-driven fuel pump's return line B-nut fitting.
- [NTSB CHI04LA112](https://openairdocs.org/ntsb/CHI04LA112.md): Grumman American AA-1B · Dodge Center, MN · Accident · 1 fatal · Limited investigation · Final report · Apr 28, 2004 · N9919L · Destroyed
  > The pilot's failure maintain climb and his failure to maintain clearance from the terrain during initial climb out after takeoff. The aircraft's low altitude, high gusty winds and low level turbulence were contributing factors.
- [NTSB CHI04CA108](https://openairdocs.org/ntsb/CHI04CA108.md): Piper PA-18-150 · Minneapolis, MN · Accident · Minor injuries · Data collection · Final report · Apr 22, 2004 · N82943 · Substantial damage
  > The pilot not verifying the position of the fuel selector prior to the takeoff, resulting in the loss of engine power during initial climb due to fuel starvation. Factors to the accident were the power pole and the trees.
- [NTSB FTW04CA112](https://openairdocs.org/ntsb/FTW04CA112.md): Air Tractor AT-502B · San Angelo, TX · Accident · No injuries · Data collection · Final report · Apr 21, 2004 · N5196J · Destroyed
  > The pilot's improper preflight performance planning, and his failure to establish a climb. Factors were the high density altitude and crosswind.
- [NTSB ATL04FA096](https://openairdocs.org/ntsb/ATL04FA096.md): Cirrus Design SR20 · Greenwood, SC · Accident · 4 fatal · Field investigation · Final report · Apr 19, 2004 · N8157J · Destroyed
  > The pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.
- [NTSB DEN04FA064](https://openairdocs.org/ntsb/DEN04FA064.md): Cessna 150H · Boulder, CO · Accident · Minor injuries · Field investigation · Final report · Apr 18, 2004 · N105DP · Substantial damage
  > the failed magneto and the lack of suitable terrain (lake) for a forced landing.
- [NTSB MIA04LA075](https://openairdocs.org/ntsb/MIA04LA075.md): Richard A. Denisar RV-4 · Spring Hill, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 16, 2004 · N199RD · Substantial damage
  > The pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power during takeoff/initial climb due to fuel contamination, that resulted in a forced landing
- [NTSB CHI04CA105](https://openairdocs.org/ntsb/CHI04CA105.md): Cessna A185E · Hastings, MN · Accident · Minor injuries · Data collection · Final report · Apr 16, 2004 · N185TY · Substantial damage
  > The pilot not verifying the fuel selector valve's position during the preflight leading to the fuel starvation and subsequent loss of engine power during the flight's initial climb.
- [NTSB ANC04LA040](https://openairdocs.org/ntsb/ANC04LA040.md): Piper PA-12 · Copper Center, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 2004 · N3029M · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, and his failure to utilize carburetor heat, which resulted in a loss of engine power during takeoff initial climb, and a subsequent encounter with snow-covered terrain. Factors contributing to the…
- [NTSB LAX04FA187](https://openairdocs.org/ntsb/LAX04FA187.md): Piper PA-28RT-201T · Concord, CA · Accident · Serious injuries · Field investigation · Final report · Apr 13, 2004 · N2920C · Destroyed
  > a loss of engine power due to improper maintenance repair procedures and use of improper parts.
- [NTSB FTW04CA106](https://openairdocs.org/ntsb/FTW04CA106.md): Cessna 172K · Bogalusa, LA · Accident · No injuries · Data collection · Final report · Apr 10, 2004 · N84623 · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX04LA182](https://openairdocs.org/ntsb/LAX04LA182.md): Piper PA-38-112 · San Martin, CA · Accident · No injuries · Limited investigation · Final report · Apr 9, 2004 · N25645 · Substantial damage
  > the loss of engine power for undetermined reasons.
- [NTSB CHI04LA103](https://openairdocs.org/ntsb/CHI04LA103.md): Cessna 150M · Marion, IN · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 2004 · N6160K · Substantial damage
  > The pilot's inadequate preflight planning/decision to ensure adequate takeoff performance by the improper use of flaps and failure to establish the aircraft was within weight and balance limitations.
- [NTSB LAX04LA191](https://openairdocs.org/ntsb/LAX04LA191.md): North American Aviation Div. Navion · Page, AZ · Accident · No injuries · Limited investigation · Final report · Apr 8, 2004 · N91729 · Substantial damage
  > the pilot's failure to attain and maintain a sufficient airspeed, which led to an inadvertent stall mush in high density altitude conditions.
- [NTSB LAX04CA179](https://openairdocs.org/ntsb/LAX04CA179.md): Beech 95-A55 · Montague, CA · Accident · No injuries · Data collection · Final report · Apr 6, 2004 · N686H · Substantial damage
  > the pilot's failure to maintain an adequate airspeed during the takeoff climb, which led to a stall/mush. Factors to the accident were the uneven intersection of the two runways, and the pilot's failure to use all of the available runway, and the premature…
- [NTSB LAX04LA178](https://openairdocs.org/ntsb/LAX04LA178.md): Beech V35 · Elko, NV · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 2004 · N7923M · Destroyed
  > the pilot's improper mixture leaning technique and failure to attain an adequate airspeed during takeoff, which resulted in a stall/mush.
- [NTSB ATL04FA090](https://openairdocs.org/ntsb/ATL04FA090.md): Smith Aerostar 601P · Johns Island, SC · Accident · 2 fatal · Field investigation · Final report · Apr 5, 2004 · N869CC · Substantial damage
  > The pilot's failure to maintain airspeed during emergency descent, which resulted in an inadvertent stall/spin and uncontrolled descent into trees and terrain. A factor was the loss of engine power in one engine due to pre-ignition/detonation.
- [NTSB MIA04LA069](https://openairdocs.org/ntsb/MIA04LA069.md): Louis Amato Buccaneer · Labelle, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 4, 2004 · UNREG · Destroyed
  > The pilots improper preflight preparation resulting in loss of engine power due to contaminated fuel and his failure to maintain airspeed while attempting to reverse direction to land resulting in an inadvert stall, uncontrolled descent, and impact with…
- [NTSB MIA04FA064](https://openairdocs.org/ntsb/MIA04FA064.md): Piper PA-30 · Fernandina Bch, FL · Accident · 2 fatal · Field investigation · Final report · Apr 4, 2004 · N14A · Substantial damage
  > The failure of the pilot to feather the left propeller and his failure to maintain control of the airplane following a loss of engine power from the left engine resulting in the in-flight collision with terrain. A factor in the accident was the loss of power…
- [NTSB LAX04FA177](https://openairdocs.org/ntsb/LAX04FA177.md): Piper PA-32R-301T · Ukiah, CA · Accident · 1 fatal · Field investigation · Final report · Apr 4, 2004 · N4130D · Destroyed
  > The non-instrument rated pilot's flight intentional flight into instrument meteorological conditions during takeoff-initial climb, which resulted in spatial disorientation, a subsequent loss of aircraft control, and an uncontrolled descent into terrain. A…
- [NTSB LAX04CA175](https://openairdocs.org/ntsb/LAX04CA175.md): Cessna 177 · California City, CA · Accident · Minor injuries · Data collection · Final report · Apr 3, 2004 · N88BM · Destroyed
  > the certified flight instructor's failure to maintain an adequate airspeed, which resulted in a stall/mush condition and a collision with terrain. Factors in the accident were strong tailwind conditions and a sudden wind shift.
- [NTSB SEA04LA062](https://openairdocs.org/ntsb/SEA04LA062.md): Davenport RV-8F · College Place, WA · Accident · 1 fatal · Limited investigation · Final report · Apr 1, 2004 · N284DM · Substantial damage
  > A loss of engine power for undetermined reason(s) and the pilot's failure to maintain adequate flying airspeed during the forced landing. A contributing factor was the pilot's decision to attempt a turn at low altitude.
- [NTSB LAX04LA171](https://openairdocs.org/ntsb/LAX04LA171.md): Maule M-7-260C · Paso Robles, CA · Accident · No injuries · Limited investigation · Final report · Mar 28, 2004 · N99KJ · Substantial damage
  > fuel system vapor lock due to the failure of the left exhaust stack clamp pin, which caused a separation of the exhaust stack from the muffler and the porting of hot exhaust gases onto the fuel lines.
- [NTSB CHI04CA090](https://openairdocs.org/ntsb/CHI04CA090.md): Schleicher ASW-20 · Yoder, KS · Accident · No injuries · Data collection · Final report · Mar 28, 2004 · N232EM · Substantial damage
  > The pilot's failure to secure the elevator Louis L'Hotellier connector with a safety pin or wire as directed in several airworthiness directives and his inadequate preflight inspection of the sailplane, both of which resulted in the in-flight loss of elevator…
- [NTSB SEA04LA057](https://openairdocs.org/ntsb/SEA04LA057.md): Cessna A188B · Palouse, WA · Accident · No injuries · Limited investigation · Final report · Mar 25, 2004 · N731YZ · Substantial damage
  > The pilot's decision to takeoff downwind resulting in his inability to achieve a positive climb rate and an in-flight collision with terrain. Factors contributing to the accident included the rising terrain and the tailwind condition.
- [NTSB ANC04LA035](https://openairdocs.org/ntsb/ANC04LA035.md): Cessna 180H · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Mar 22, 2004 · N2472F · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a snow drift during takeoff/initial climb. Factors contributing to the accident were the snow-covered and uneven terrain.
- [NTSB SEA04LA052](https://openairdocs.org/ntsb/SEA04LA052.md): Cessna 172N · Creswell, OR · Accident · No injuries · Limited investigation · Final report · Mar 21, 2004 · N739HQ · Substantial damage
  > The pilot's attempting takeoff with the fuel selector in the OFF position resulting in fuel starvation. Contributing factors were the change in habit pattern and expectancy of the fuel selector position as well as the fence and tree.
- [NTSB LAX04FA168](https://openairdocs.org/ntsb/LAX04FA168.md): Alon A2 · Cameron Park, CA · Accident · 2 fatal · Field investigation · Final report · Mar 21, 2004 · N6374V · Destroyed
  > The pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which resulted in a stall/spin. Also causal was the partial loss of engine power due to improperly secured magnetos.
- [NTSB FTW04IA104](https://openairdocs.org/ntsb/FTW04IA104.md): Cessna 414 · Midland, TX · Incident · No injuries · Incident investigation · Final report · Mar 19, 2004 · N414FB · Minor damage
  > The in-flight wing fire for undetermined reasons.
- [NTSB LAX04LA166](https://openairdocs.org/ntsb/LAX04LA166.md): Globe GC-1B · Placerville, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2004 · N369BZ · Substantial damage
  > a loss of engine power due to an improperly sized and installed set of sealing gaskets in the gascolator, which resulted in fuel starvation. A factor to the accident was the unsuitable terrain for the forced landing.
- [NTSB ATL04LA086](https://openairdocs.org/ntsb/ATL04LA086.md): Cessna 182K · Eden, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2004 · N4GB · Substantial damage
  > Loss of engine power due to improper installation by maintenance personnel which resulted in the mixture control cable becoming disconnected in-flight. Contributing to the severity of the accident was the in-flight collision with trees.
- [NTSB ANC04FA042](https://openairdocs.org/ntsb/ANC04FA042.md): Cessna 150C · DeLand, FL · Accident · 2 fatal · Field investigation · Final report · Mar 17, 2004 · N2080Z · Destroyed
  > The pilot's failure to detect water in the fuel system during the preflight inspection, which precipitated a loss of engine power during initial climb, and his failure to maintain adequate airspeed resulting in a stall.
- [NTSB DEN04LA052](https://openairdocs.org/ntsb/DEN04LA052.md): Cessna 182P · Monticello, UT · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 2004 · N400DH · Substantial damage
  > the pilot's failure to maintain aircraft control during takeoff. Contributing factors include the sudden windshift and the bushes.
- [NTSB LAX04LA156](https://openairdocs.org/ntsb/LAX04LA156.md): American AA-1 · Selma, CA · Accident · No injuries · Limited investigation · Final report · Mar 13, 2004 · N6175L · Substantial damage
  > The pilot's inadequate preflight planning, which failed to assure adequate takeoff performance, and his failure to abort the takeoff. The aircraft inadequate weight and balance was a contributing factor.
- [NTSB FTW04LA091](https://openairdocs.org/ntsb/FTW04LA091.md): Air Tractor AT-301 · Plain Dealing, LA · Accident · No injuries · Limited investigation · Final report · Mar 13, 2004 · N4359S · Destroyed
  > A loss of engine power due to undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX04CA153](https://openairdocs.org/ntsb/LAX04CA153.md): Ayres S2R-600 · Calipatria, CA · Accident · No injuries · Data collection · Final report · Mar 11, 2004 · N8520V · Substantial damage
  > the failure of ground personnel to refuel the airplane with the proper fuel grade/octane, resulting in the airplane's loss of engine power. Also causal was the pilot's failure to detect the fuel problem during a preflight inspection.
- [NTSB NYC04LA082](https://openairdocs.org/ntsb/NYC04LA082.md): Socata TB-20 · Frederick, MD · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 2004 · N163GT · Substantial damage
  > Total loss of engine power for undetermined reasons.
- [NTSB FTW04LA088](https://openairdocs.org/ntsb/FTW04LA088.md): Bell 206L-3 · W. Cameron 149 · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 2004 · N81SP · Substantial damage
  > A partial loss of engine power due to undetermined reasons. A contributing factor was the emergency floats not being deployed.
- [NTSB FTW04LA081](https://openairdocs.org/ntsb/FTW04LA081.md): Cessna 182A · Claremore, OK · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 2004 · N30408 · Substantial damage
  > The loss of engine power due to fuel contamination (water). A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW04LA082](https://openairdocs.org/ntsb/FTW04LA082.md): Ayres S2R-T34 · Ville Platte, LA · Accident · No injuries · Limited investigation · Final report · Feb 19, 2004 · N3092H · Destroyed
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI04LA070](https://openairdocs.org/ntsb/CHI04LA070.md): Piper PA-23-160 · Casey, IL · Accident · No injuries · Limited investigation · Final report · Feb 15, 2004 · N4332P · Substantial damage
  > The pilot not maintaining aircraft control during the loss of engine power and his improper remedial action during the encountered uncommanded roll (VMC roll). An additional cause was the pilot's failure to obtain a maintenance inspection by a qualified…
- [NTSB LAX04LA124](https://openairdocs.org/ntsb/LAX04LA124.md): Cessna 172N · Upland, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 13, 2004 · N5107K · Substantial damage
  > A partial loss of engine power for undetermined reasons during takeoff.
- [NTSB ANC04LA031](https://openairdocs.org/ntsb/ANC04LA031.md): Cessna 182M · Yakutat, AK · Accident · No injuries · Limited investigation · Final report · Feb 9, 2004 · N71886 · Substantial damage
  > The pilot's delayed use of carburetor heat, which resulted in an engine power loss during takeoff-initial climb, a forced landing, and subsequent collision with terrain. A factor contributing to the accident was the presence of carburetor icing conditions.
- [NTSB FTW04LA071](https://openairdocs.org/ntsb/FTW04LA071.md): Beech BE-23 · Mena, AR · Accident · No injuries · Limited investigation · Final report · Feb 8, 2004 · N234DD · Substantial damage
  > The loss of engine power for undetermined reasons and the pilot's misjudgment of altitude and distance during the forced landing which resulted in a collision with trees and transmission wires.
- [NTSB NYC04LA059](https://openairdocs.org/ntsb/NYC04LA059.md): Robinson R-22 · Nicholasville, KY · Accident · No injuries · Limited investigation · Final report · Jan 19, 2004 · N224LC · Destroyed
  > A leak in the fuel system due to a loose fitting, which resulted in a loss of engine power, and the inadequate maintenance inspection, which failed to detect/correct the security of the fitting.

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

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

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