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

## Cases, newest first

- [NTSB NYC96LA089](https://openairdocs.org/ntsb/NYC96LA089.md): Cessna 152 · Greenville, NY · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 1996 · N89414 · Substantial damage
  > The pilot's failure to gain adequate airspeed due to inadequate planning in which he conducted a downwind takeoff, resulting in a stall mush, and collision with trees.
- [NTSB NYC96LA087](https://openairdocs.org/ntsb/NYC96LA087.md): Mooney M20K · West Milford, NJ · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 1996 · N231KS · Substantial damage
  > loss of engine power for undetermined reason(s), which resulted in a forced landing on unsuitable terrain and subsequent collision with trees.
- [NTSB IAD96LA065](https://openairdocs.org/ntsb/IAD96LA065.md): Cessna 150H · Clinton, MD · Accident · No injuries · Limited investigation · Final report · Apr 19, 1996 · N6508S · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB IAD96LA064](https://openairdocs.org/ntsb/IAD96LA064.md): Piper PA-22-135 · Dover, DE · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 1996 · N3506A · Substantial damage
  > the overhaul maintenance personnel's improper major overhaul procedure (improper torque on the engine block center through bolts), which resulted in an in flight loss of engine power. A related factor was the lack of suitable terrain available for a forced…
- [NTSB SEA96LA081](https://openairdocs.org/ntsb/SEA96LA081.md): Forth Acro 2 · Rock Springs, WY · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1996 · N565HF · Substantial damage
  > the pilot's improper decision to attempt a takeoff from a road with gusting crosswinds, and his failure to adequately compensate for wind conditions during the takeoff. Factors contributing to the accident were gusts, crosswinds, and windshear.
- [NTSB FTW96LA177](https://openairdocs.org/ntsb/FTW96LA177.md): Air Tractor AT-502B · Pond Creek, OK · Accident · No injuries · Limited investigation · Final report · Apr 18, 1996 · N6050D · Substantial damage
  > The pilot's improper planning/decision and failure to obtain/maintain sufficient airspeed to climb after takeoff, which resulted in a stall/mush and subsequent collision with terrain. Factors relating to the accident were: failure of the pilot to follow short…
- [NTSB CHI96FA135](https://openairdocs.org/ntsb/CHI96FA135.md): Piper J-3 · Raymond, NE · Accident · 2 fatal · Field investigation · Final report · Apr 18, 1996 · N6510H · Destroyed
  > failure of the pilot to ensure that the fuel selector was properly positioned to the full 'on' position before takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff; and the pilot's failure to maintain…
- [NTSB ANC96LA049](https://openairdocs.org/ntsb/ANC96LA049.md): Cessna 207 · Kotzebue, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 17, 1996 · N6282H · Destroyed
  > failure of the pilot to maintain sufficient altitude/clearance above terrain, after becoming spatially disoriented, while maneuvering after takeoff. Factors relating to the accident were: fog, snow, partial obscuration, 'flat' conditions of light, and the…
- [NTSB FTW96LA171](https://openairdocs.org/ntsb/FTW96LA171.md): Cessna U206G · Venice, LA · Accident · 1 fatal · Limited investigation · Final report · Apr 14, 1996 · N734QW · Destroyed
  > the pilot's inadvertent flight into instrument meteorological conditions. A factor was the fog.
- [NTSB IAD96LA060](https://openairdocs.org/ntsb/IAD96LA060.md): Cessna 150L · Akron, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1996 · N16188 · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB SEA96MA079](https://openairdocs.org/ntsb/SEA96MA079.md): Cessna 177B · Cheyenne, WY · Accident · 3 fatal · Class 1 · Major · Final report · Apr 11, 1996 · N35207 · Destroyed
  > the pilot-in-command's improper decision to take off into deteriorating weather conditions (including turbulence, gusty winds, and an advancing thunderstorm and associated precipitation) when the airplane was overweight and when the density altitude was…
- [NTSB ANC96LA046](https://openairdocs.org/ntsb/ANC96LA046.md): Stinson ST-75 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Apr 11, 1996 · N235C · Substantial damage
  > The pilot's failure to select the proper fuel tank prior to takeoff resulting in fuel starvation. A factor in the accident was the pilot's failure to follow the checklist.
- [NTSB FTW96LA166](https://openairdocs.org/ntsb/FTW96LA166.md): Cessna 182RG · Welsh, LA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1996 · N2385C · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.
- [NTSB FTW96LA164](https://openairdocs.org/ntsb/FTW96LA164.md): Cessna 182Q · Boerne, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 8, 1996 · XBCHP · Substantial damage
  > The pilot's improper planning/decision, and his failure to use all of available runway. Factors relating to the accident were: the pilot's overconfidence in the ability of the airplane, the high density altitude, the tailwind, and trees at the departure end…
- [NTSB LAX96LA159](https://openairdocs.org/ntsb/LAX96LA159.md): Gage VARI-EZE · Chino, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 1996 · N88VE · Substantial damage
  > the pilot's excessive initial climb attitude and his failure to maintain adequate airspeed. The pilot's diverted attention to the unlatched canopy warning light, and his lack of familiarity with the aircraft were factors.
- [NTSB SEA96LA078](https://openairdocs.org/ntsb/SEA96LA078.md): Sport Flight Talon · Salem, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1996 · UNREG · Substantial damage
  > loss of engine power for undetermined reason(s), and failure of the pilot to properly flare the aircraft during the emergency landing.
- [NTSB LAX96LA161](https://openairdocs.org/ntsb/LAX96LA161.md): Van Dyke GVD1 · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1996 · N94GV · Substantial damage
  > the pilot's failure to maintain adequate airspeed during a low altitude turn after takeoff.
- [NTSB ANC96IA039](https://openairdocs.org/ntsb/ANC96IA039.md): Helio H295 · Angoon, AK · Incident · No injuries · Incident investigation · Final report · Mar 29, 1996 · N5462E · Minor damage
  > the pilot's inadequate compensation for the gusty wind conditions. A factor associated with the accident was the gusty wind conditions.
- [NTSB SEA96LA075](https://openairdocs.org/ntsb/SEA96LA075.md): Ryan Navion · Kent, WA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1996 · N4826K · Substantial damage
  > the pilot's attempted operation with known deficiencies in the equipment, and a loose fuel system fitting. The pilot's failure to maintain maintenance service on the airplane was a factor.
- [NTSB MIA96IA109](https://openairdocs.org/ntsb/MIA96IA109.md): Beech 1900D · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Mar 28, 1996 · N29YV · Minor damage
  > Failure of a blade counterweight clamp retaining screw due to cadmium embrittlement which occurred during the manufacture process. This resulted in the counterweight clamp separating and striking the adjacent blade causing it to separate.
- [NTSB SEA96LA072](https://openairdocs.org/ntsb/SEA96LA072.md): Piper PA-16 · Lynnwood, WA · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 1996 · N5638H · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB LAX96LA143](https://openairdocs.org/ntsb/LAX96LA143.md): Cessna 172 · Upland, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 1996 · N7044T · Substantial damage
  > fuel system contamination and the pilot's intentional operation of a known unairworthy aircraft.
- [NTSB MIA96LA108](https://openairdocs.org/ntsb/MIA96LA108.md): Boeing 737-200 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Mar 21, 1996 · EICLK · Substantial damage
  > failure of the nose gear taxi light support bracket due to in service damage, which resulted in debris being ingested by the engines. Contributing to the accident was the failure of company maintenance personnel to comply with a Grimes Service Bulletin and a…
- [NTSB MIA96FA100](https://openairdocs.org/ntsb/MIA96FA100.md): Cessna U206G · Key West, FL · Accident · 5 fatal · Field investigation · Final report · Mar 17, 1996 · N9983Z · Destroyed
  > The pilot's improper decision to continue the flight rather than making an immediate water landing due to the low altitude of the airplane and obstructions ahead, which led to his intentional maneuver to avoid the obstructions and subsequent inadvertent stall…
- [NTSB IAD96LA049](https://openairdocs.org/ntsb/IAD96LA049.md): Kitfox IV-1200 · Saluda, VA · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 1996 · N32495 · Substantial damage
  > a partial loss of engine power due to spark plug failure, and the pilot's evasive maneuver to avoid lights at the end of the runway.
- [NTSB NYC96LA072](https://openairdocs.org/ntsb/NYC96LA072.md): Cessna 182L · Weedsport, NY · Accident · No injuries · Limited investigation · Final report · Mar 10, 1996 · N3407R · Substantial damage
  > the pilot's decision to takeoff on a closed snow-covered runway, and his inadequate compensation for a crosswind. A factor in the accident was the pilot's lack of recent flying experience.
- [NTSB LAX96FA131](https://openairdocs.org/ntsb/LAX96FA131.md): Varga 2180A · Peoria, AZ · Accident · 2 fatal · Field investigation · Final report · Mar 10, 1996 · N5065V · Destroyed
  > failure of the pilot to obtain or maintain adequate airspeed for turning (maneuvering) after takeoff, which resulted in an inadvertent stall/spin. The lack of altitude for stall/spin recovery was a related factor.
- [NTSB FTW96LA146](https://openairdocs.org/ntsb/FTW96LA146.md): Piper PA-28-140 · Gladewater, TX · Accident · No injuries · Limited investigation · Final report · Mar 9, 1996 · N8726N · Substantial damage
  > fuel starvation due to the pilot inadvertently turning the fuel selector to the OFF position. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ANC96LA031](https://openairdocs.org/ntsb/ANC96LA031.md): Cessna 150H · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 3, 1996 · N22053 · Substantial damage
  > loss of engine power for an undetermined reason.
- [NTSB LAX96LA126](https://openairdocs.org/ntsb/LAX96LA126.md): Worthington BD-5B · San Martin, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 1996 · N69SW · Substantial damage
  > the pilot/builder's improper installation (overtorque) of the ignition switch on the instrument panel, which caused an internal switch failure and subsequent malfunction of the ignition system.
- [NTSB NYC96LA066](https://openairdocs.org/ntsb/NYC96LA066.md): Cessna 150H · Linden, NJ · Accident · Serious injuries · Limited investigation · Final report · Feb 26, 1996 · N6964S · Substantial damage
  > the pilot's inadequate preflight and failure to follow the checklist to ensure that the fuel selector valve was in the ON position, which resulted in fuel starvation and subsequent loss of engine power. In addition, the pilot failed to maintain airspeed…
- [NTSB MIA96LA087](https://openairdocs.org/ntsb/MIA96LA087.md): Marks Kitfox II · Panama City, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 24, 1996 · N915PK · Substantial damage
  > the pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve and subsequent collision with a ditch. Factors relating to the accident were: failure of the…
- [NTSB IAD96LA047](https://openairdocs.org/ntsb/IAD96LA047.md): Beech F35 · Mt. Sterling, KY · Accident · No injuries · Limited investigation · Final report · Feb 23, 1996 · N3850B · Substantial damage
  > a loss of engine power due to the failure of the number one piston. Related factors were the unsuitable terrain available for the forced landing, and the strong tailwind encountered during the forced landing.
- [NTSB LAX96LA124](https://openairdocs.org/ntsb/LAX96LA124.md): Schweizer G-164B · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1996 · N6674Q · Substantial damage
  > overheating and failure of the engine's master rod and master rod bearing due to oil starvation. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.
- [NTSB ATL96LA050](https://openairdocs.org/ntsb/ATL96LA050.md): Cessna 172 · Jackson, MS · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1996 · N166F · Substantial damage
  > loss of engine power during takeoff for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB LAX96LA110](https://openairdocs.org/ntsb/LAX96LA110.md): Stolp Starduster II · Kahului, HI · Accident · Serious injuries · Limited investigation · Final report · Feb 10, 1996 · N1457 · Destroyed
  > a faulty engine magneto, and decision by the pilot-in-command to operate the airplane with known deficiencies. A factor relating to the accident was: the airplane was overdue for an annual inspection.
- [NTSB NYC96LA059](https://openairdocs.org/ntsb/NYC96LA059.md): Cessna 180D · Islesboro, ME · Accident · No injuries · Limited investigation · Final report · Feb 5, 1996 · N6423X · Substantial damage
  > a loss of engine power for an undetermined reason.
- [NTSB LAX96FA106](https://openairdocs.org/ntsb/LAX96FA106.md): Convair C-131E · Saint Johns, AZ · Accident · 4 fatal · Field investigation · Final report · Feb 5, 1996 · N131T · Destroyed
  > inadequate preflight planning and preparation by the first pilot (PIC), his failure to ensure the aircraft was properly loaded within limitations, his failure to use proper flaps for takeoff, his failure to use ADI assisted takeoff, and his resultant failure…
- [NTSB LAX96FA103](https://openairdocs.org/ntsb/LAX96FA103.md): Cessna 402B · Kamuela, HI · Accident · 1 fatal · Field investigation · Final report · Jan 29, 1996 · N999CR · Destroyed
  > failure of the copilot (pilot-rated cargo loader, who was flying the aircraft) to establish and maintain a positive rate of climb after taking off at night; and inadequate supervision by the pilot-in-command (PIC), by failing to ensure that proper altitude…
- [NTSB ATL96FA037](https://openairdocs.org/ntsb/ATL96FA037.md): Piper PA-28-161 · Fort Pierce, FL · Accident · 1 fatal · Field investigation · Final report · Jan 19, 1996 · N114AV · Substantial damage
  > improper re-assembly of the engine induction air filter by maintenance personnel, during an annual inspection, which resulted in a loss of engine power during takeoff; failure of the pilot to abort the takeoff before lift-off; and failure of the pilot to…
- [NTSB MIA96LA063](https://openairdocs.org/ntsb/MIA96LA063.md): Piper PA-24-250 · Lake City, FL · Accident · No injuries · Limited investigation · Final report · Jan 13, 1996 · N7498P · Substantial damage
  > Failure of the pilot to select a fuel tank with adequate fuel for takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb, and improper flare by the pilot during the subsequent forced land.
- [NTSB FTW96FA088](https://openairdocs.org/ntsb/FTW96FA088.md): Piper PA-34-200T · Wichita Falls, TX · Accident · 2 fatal · Field investigation · Final report · Jan 13, 1996 · N8894E · Destroyed
  > The inadvertent stall by the pilot in command. Factors were the impeded airplane takeoff performance, the rudder trim not corrected by the pilot, and the pilot's failure to comply with the checklist.
- [NTSB MIA96FA059](https://openairdocs.org/ntsb/MIA96FA059.md): Douglas DC-9-32 · Nashville, TN · Accident · Minor injuries · Class 1 · Field · Final report · Jan 7, 1996 · N922VV · Substantial damage
  > the flight crew's improper procedures and actions (failing to contact system operations/dispatch, failing to use all available aircraft and company manuals, and prematurely resetting the ground control relay circuit breakers) in response to an in-flight…
- [NTSB SEA96LA037](https://openairdocs.org/ntsb/SEA96LA037.md): Cessna 170B · Baker City, OR · Accident · No injuries · Limited investigation · Final report · Jan 2, 1996 · N2761D · Substantial damage
  > the pilot's premature lift-off and inadequate airspeed following liftoff. His use of a public highway as a takeoff area, and a motor vehicle on the highway, were factors.
- [NTSB ANC96LA024](https://openairdocs.org/ntsb/ANC96LA024.md): Cessna 180 · Tanana, AK · Accident · No injuries · Limited investigation · Final report · Dec 30, 1995 · N4762B · Substantial damage
  > The icing of the induction/intake screen and the pilot's improper planning/decision by electing to takeoff into suspended snow and ice crystals.
- [NTSB CHI96LA069](https://openairdocs.org/ntsb/CHI96LA069.md): Taylorcraft BC-12 · Winner, SD · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 1995 · N39244 · Substantial damage
  > the pilot's failure to maintain airspeed during takeoff. A factor was the pilot's diversion of his attention to a perceived engine problem.
- [NTSB LAX96LA084](https://openairdocs.org/ntsb/LAX96LA084.md): Nicholson Sonerai II · Ramona, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1995 · N68676 · Substantial damage
  > an interruption of fuel flow to the engine due to a misrouted fuel vent line.
- [NTSB FTW96LA079](https://openairdocs.org/ntsb/FTW96LA079.md): Meyers MY-200A · Madill, OK · Accident · No injuries · Limited investigation · Final report · Dec 27, 1995 · N484C · Substantial damage
  > the deterioration of the fuel supply line resulting in line blockage, fuel starvation, and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW96LA077](https://openairdocs.org/ntsb/FTW96LA077.md): Stinson ST-108-2 · Lake Dallas, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 1995 · N135C · Destroyed
  > the failure of the #6 connecting rod assembly. A factor was the lack of suitable terrain for a forced landing which resulted in a water landing.
- [NTSB LAX96FA080](https://openairdocs.org/ntsb/LAX96FA080.md): Cessna 152 · Compton, CA · Accident · Minor injuries · Field investigation · Final report · Dec 26, 1995 · N6110Q · Destroyed
  > a push rod failed from fatigue as a result of longitudinal stress corrosion cracking.

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

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

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