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

## Cases, newest first

- [NTSB IAD96LA095](https://openairdocs.org/ntsb/IAD96LA095.md): Cessna 177 · Versailles, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1996 · N3197T · Substantial damage
  > Fuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.
- [NTSB CHI96IA207](https://openairdocs.org/ntsb/CHI96IA207.md): Airbus Industrie A-320 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Jun 14, 1996 · N347NW · No damage
  > an undetermined intermittent fault in the trimmable horizontal stabilizer actuator system.
- [NTSB LAX96FA229](https://openairdocs.org/ntsb/LAX96FA229.md): Piper PA-24-250 · Big Bear City, CA · Accident · 2 fatal · Field investigation · Final report · Jun 13, 1996 · N7280P · Destroyed
  > improper preflight by the pilot, by failing to ensure that the fuel selector was positioned to an approved fuel tank with adequate fuel before takeoff; his failure to reposition the fuel selector (per emergency procedures) after the loss of engine power; and…
- [NTSB CHI96LA199](https://openairdocs.org/ntsb/CHI96LA199.md): Cessna 150 · Charlotte, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 1996 · N16047 · Substantial damage
  > the pilot's inadequate preflight planning and failure to use all the available runway for takeoff. Factors associated with the accident were the wet grass airstrip and the powerlines.
- [NTSB SEA96LA119](https://openairdocs.org/ntsb/SEA96LA119.md): Piper PA-28-150 · Bountiful, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1996 · N5172W · Substantial damage
  > inadequate fuel management by the student pilot, which resulted in fuel starvation, due to an improperly positioned fuel selector. Factors relating to the accident were: the pilot's inadequate remedial action, and a ditch in the emergency landing area.
- [NTSB SEA96LA128](https://openairdocs.org/ntsb/SEA96LA128.md): Bailey Antares MA30 · Woodland, WA · Accident · 1 fatal · Limited investigation · Final report · Jun 10, 1996 · UNREG · Substantial damage
  > failure of the uncertificated pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain. The pilot's abrupt pull-up was a related factor.
- [NTSB CHI96LA192](https://openairdocs.org/ntsb/CHI96LA192.md): Carrison-Seiman Schukert D-1 · Gardner, KS · Accident · No injuries · Limited investigation · Final report · Jun 10, 1996 · N51CQ · Substantial damage
  > an aileron control malfunction of undetermined origin. A factor was the pilot's inability to control the airplane.
- [NTSB CHI96LA197](https://openairdocs.org/ntsb/CHI96LA197.md): Grumman American AA-1C · Custer, SD · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1996 · N39048 · Substantial damage
  > the pilot did not maintain aircraft control or abort the takeoff. The factors involved were the pilot encountered a stall/mush condition, exhaust valves were leaking, low compression on all cylinders, and all pistons were scored.
- [NTSB LAX96LA221](https://openairdocs.org/ntsb/LAX96LA221.md): Beech 23-A24R · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1996 · N102KB · Destroyed
  > fuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft.
- [NTSB FTW96LA238](https://openairdocs.org/ntsb/FTW96LA238.md): Cessna 172RG · Leadville, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 1996 · N9431D · Substantial damage
  > Inadequate preflight planning and preparation and failure to follow aircraft operating procedures and directives. Factors were high density altitude, inadequate training of the flight instructor and insufficient standards and requirements for flight…
- [NTSB ANC96LA083](https://openairdocs.org/ntsb/ANC96LA083.md): Champion 7AC · Clear, AK · Accident · No injuries · Limited investigation · Final report · Jun 5, 1996 · N83995 · Substantial damage
  > the pilot's inadequate preflight inspection in that he failed to ensure that the cabin door was properly secured for takeoff. Factors associated with the accident were: the open cabin door and rough/uneven terrain.
- [NTSB FTW96LA236](https://openairdocs.org/ntsb/FTW96LA236.md): Rockwell S-2R · Dumas, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1996 · N3646X · Substantial damage
  > Failure of all personnel concerned to identify the unsafe/hazardous condition, which resulted from a visual restriction, due to trees near the intersection of the road and runway.
- [NTSB CHI96LA189](https://openairdocs.org/ntsb/CHI96LA189.md): Luscombe 8A · Greenville, MI · Accident · No injuries · Limited investigation · Final report · Jun 3, 1996 · N2887K · Substantial damage
  > foreign material, probably due to improper maintenance, which blocked the main fuel metering jet of the carburetor, and resulted in fuel starvation and loss of engine power.
- [NTSB MIA96IA146](https://openairdocs.org/ntsb/MIA96IA146.md): Short Brothers SD3-60 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Jun 2, 1996 · N826BE · No damage
  > fatigue failure of a segment of the elevator trim cable.
- [NTSB SEA96LA110](https://openairdocs.org/ntsb/SEA96LA110.md): Stelly Kolb Firestar II · Independence, OR · Accident · No injuries · Limited investigation · Final report · Jun 1, 1996 · N2213U · Substantial damage
  > failure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. The aircraft's excessive gross weight was a related factor.
- [NTSB LAX96LA216](https://openairdocs.org/ntsb/LAX96LA216.md): Rockwell 112TCA · Eureka, NV · Accident · No injuries · Limited investigation · Final report · May 31, 1996 · N4674W · Substantial damage
  > a loss of engine power for undetermined nonmechanical reasons. A contributing factor was the lack of suitable terrain for use during an aborted takeoff.
- [NTSB FTW96FA230](https://openairdocs.org/ntsb/FTW96FA230.md): Piper PA-31T · Malvern, AR · Accident · 5 fatal · Field investigation · Final report · May 29, 1996 · N333LM · Destroyed
  > The pilot's failure to maintain control of the airplane after takeoff.
- [NTSB ATL96LA088](https://openairdocs.org/ntsb/ATL96LA088.md): Aero Commander 100 · Jesup, GA · Accident · No injuries · Limited investigation · Final report · May 29, 1996 · N3797X · Substantial damage
  > the pilot's inadequate preflight planning/preparation, and his failure to remain clear of the fence during takeoff.
- [NTSB IAD96LA086](https://openairdocs.org/ntsb/IAD96LA086.md): Champion 7FC · Stevensville, MD · Accident · Minor injuries · Limited investigation · Final report · May 25, 1996 · N456JE · Substantial damage
  > The pilot's misjudgment of the amount of fuel he had onboard the airplane which resulted in an engine failure due to fuel exhaustion. Contributing to the severity of the accident was the high vegetation encountered during the forced landing which resulted in…
- [NTSB CHI96LA174](https://openairdocs.org/ntsb/CHI96LA174.md): Piper PA-32 · Osage Beach, MO · Accident · No injuries · Limited investigation · Final report · May 25, 1996 · N40933 · Substantial damage
  > a partial loss of power for undetermined reasons.
- [NTSB NYC96LA115](https://openairdocs.org/ntsb/NYC96LA115.md): Luscombe 8E · Macedon, NY · Accident · No injuries · Limited investigation · Final report · May 24, 1996 · N2189B · Substantial damage
  > a blocked gascolator, inadequate maintenance, and the pilot's decision to fly with a known fuel flow deficiency, which resulted in a loss of engine power, forced landing, and subsequent nose over.
- [NTSB NYC96FA113](https://openairdocs.org/ntsb/NYC96FA113.md): Beech A36 · Meriden, CT · Accident · No injuries · Field investigation · Final report · May 24, 1996 · N59WW · Destroyed
  > the pilot's improper planning/decision, his failure to use takeoff power, and his premature lift-off of the airplane, which resulted in an inadvertent stall/mush and subsequent collision with terrain. Factors relating to the accident were: the pilot allowing…
- [NTSB MIA96LA149](https://openairdocs.org/ntsb/MIA96LA149.md): Smith, Ted Aerostar Aerostar 601P · Orlando, FL · Accident · No injuries · Limited investigation · Final report · May 24, 1996 · N441CB · Substantial damage
  > loss of power in both engines for undetermined reason(s).
- [NTSB IAD96FA085](https://openairdocs.org/ntsb/IAD96FA085.md): Piper PA-31-310 · Stevensville, MD · Accident · Minor injuries · Field investigation · Final report · May 24, 1996 · N103RW · Destroyed
  > The pilot's improper short field takeoff/procedure and selection of the wrong runway for takeoff.
- [NTSB ANC96FA078](https://openairdocs.org/ntsb/ANC96FA078.md): Piper PA-31-350 · Point Hope, AK · Accident · Serious injuries · Field investigation · Final report · May 24, 1996 · N4109E · Substantial damage
  > The pilot's inadequate preflight to ensure the nose baggage door was properly latched, and the subsequent opening of the baggage compartment door, which allowed items to collide with the left propeller, resulting in propeller damage and loss of thrust from…
- [NTSB FTW96LA225](https://openairdocs.org/ntsb/FTW96LA225.md): Cessna 152 · Bridgeport, TX · Accident · Minor injuries · Limited investigation · Final report · May 23, 1996 · N52MA · Destroyed
  > the pilot's improper preflight by failing to ensure the mixture control was properly set before takeoff, and his failure to abort the takeoff (while there was sufficient runway remaining).
- [NTSB IAD96LA082](https://openairdocs.org/ntsb/IAD96LA082.md): Piper PA-38-112 · Clinton, MD · Accident · Serious injuries · Limited investigation · Final report · May 22, 1996 · N2594B · Substantial damage
  > the pilot's failure to assure that an adequate supply of fuel was available for the flight. Related factors were the pilot's inadequate airplane preflight inspection and the unsuitable terrain (horses, fence, house, barn, trees) encountered during the landing…
- [NTSB LAX96LA198](https://openairdocs.org/ntsb/LAX96LA198.md): Beech 58 · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1996 · N58KD · Substantial damage
  > an interruption of fuel flow to the right engine for undetermined nonmechanical reasons. A contributing factor was the pilot's failure to keep the right engine's propeller feathered which reduced the airplane single engine performance capabilities.
- [NTSB CHI96LA164](https://openairdocs.org/ntsb/CHI96LA164.md): Schlitter Rans S6ES Coyote II · Hays, KS · Accident · No injuries · Limited investigation · Final report · May 18, 1996 · N4307N · Substantial damage
  > failure of the pilot to maintain control of the airplane, when it settled back to the runway after lift-off. A factor relating to the accident was: premature raising of the flaps after lift-off.
- [NTSB FTW96LA215](https://openairdocs.org/ntsb/FTW96LA215.md): Mitsubishi MU-2B-40 · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · May 16, 1996 · N40AM · Substantial damage
  > failure of the pilot to obtain/maintain proper airspeed and flap setting for single engine flight. A factor relating to the accident was: Loss of power in the left engine for an undetermined reason.
- [NTSB NYC96LA105](https://openairdocs.org/ntsb/NYC96LA105.md): Grumman-Schweizer G-164A · Vineland, NJ · Accident · No injuries · Limited investigation · Final report · May 14, 1996 · N6620Q · Substantial damage
  > failure of the number 8 cylinder, which resulted in loss of engine power, a forced landing in soft terrain, and subsequent nose over of the airplane.
- [NTSB MIA96LA139](https://openairdocs.org/ntsb/MIA96LA139.md): Ezekiel Velocity 173 · Pembroke Pines, FL · Accident · Serious injuries · Limited investigation · Final report · May 14, 1996 · N28KJ · Destroyed
  > loss of engine power for undetermined reason(s), resulting in a forced landing, and impact with a private residence and the ground.
- [NTSB ANC96LA071](https://openairdocs.org/ntsb/ANC96LA071.md): Piper PA-18-150 · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · May 14, 1996 · N5760D · Substantial damage
  > the pilot's improper planning/decision, which resulted in his failure (or inability) to maintain clearance from trees after encountering gusty crosswind conditions. The wind condition and close proximity of trees were related factors.
- [NTSB LAX96LA195](https://openairdocs.org/ntsb/LAX96LA195.md): Piper PA-25-235 · Adelanto, CA · Accident · No injuries · Limited investigation · Final report · May 12, 1996 · N6844Z · Substantial damage
  > fuel exhaustion as a result of an improper preflight inspection and operating with a known malfunctioning fuel gauge.
- [NTSB MIA96GA138](https://openairdocs.org/ntsb/MIA96GA138.md): Wsk Pzl Mielec M18A · Kinston, NC · Accident · 1 fatal · Final report · May 11, 1996 · N2065K · Destroyed
  > a cracked/fractured #5 cylinder and subsequent failure/jamming of the #5 exhaust valve, which resulted in a partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall and collision with the terrain. Factors…
- [NTSB FTW96LA207](https://openairdocs.org/ntsb/FTW96LA207.md): Bowers Midget Mustang M-1 · Mesquite, TX · Accident · Minor injuries · Limited investigation · Final report · May 10, 1996 · N9516 · Destroyed
  > The pilot's failure to maintain aircraft control following the separation of the propeller spinner installed by the pilot. A factor was the pilot's failure to obtain the required FAA inspection for the installation.
- [NTSB LAX96LA191](https://openairdocs.org/ntsb/LAX96LA191.md): Beech A36 · Page, AZ · Accident · Serious injuries · Limited investigation · Final report · May 7, 1996 · N100YJ · Destroyed
  > the pilot's inadequate compensation for a gusty crosswind condition, and his failure to obtain and maintain an adequate airspeed during the takeoff initial climb in a high density altitude situation, which resulted in an inadvertent stall/mush. Related…
- [NTSB ATL96LA085](https://openairdocs.org/ntsb/ATL96LA085.md): Merle Musson Cozy · Covington, TN · Accident · Minor injuries · Limited investigation · Final report · May 7, 1996 · N86LM · Substantial damage
  > The clogged fuel strainer that resulted in an engine stoppage. A factor was the lack of a suitable landing site.
- [NTSB IAD96LA071](https://openairdocs.org/ntsb/IAD96LA071.md): Beech A36 · Hot Springs, VA · Accident · No injuries · Limited investigation · Final report · May 6, 1996 · N12JE · Substantial damage
  > the pilot's failure to attain adequate aircraft speed during takeoff. Related factors were the density altitude and gusty wind conditions.
- [NTSB ANC96LA070](https://openairdocs.org/ntsb/ANC96LA070.md): Cessna 170B · Palmer, AK · Accident · No injuries · Limited investigation · Final report · May 6, 1996 · N3193B · Destroyed
  > The pilot's failure to maintain control of the airplane during takeoff.
- [NTSB SEA96LA090](https://openairdocs.org/ntsb/SEA96LA090.md): Miller MA-5 Charger · Kennewick, WA · Accident · Serious injuries · Limited investigation · Final report · May 5, 1996 · N36CM · Substantial damage
  > failure of the pilot to maintain adequate airspeed, during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's lack of total and recent flight experience.
- [NTSB SEA96LA089](https://openairdocs.org/ntsb/SEA96LA089.md): Cessna A185E · Cascade, ID · Accident · No injuries · Limited investigation · Final report · May 5, 1996 · N185MP · Substantial damage
  > the pilot's improper planning/decision, his failure to ensure that the airplane would maintain proper clearance from obstructions (trees), and his delay in aborting the takeoff. The soft/wet runway and tailwind were related factors.
- [NTSB NYC96LA096](https://openairdocs.org/ntsb/NYC96LA096.md): Cessna 152 · Harwinton, CT · Accident · Minor injuries · Limited investigation · Final report · May 5, 1996 · N25414 · Substantial damage
  > the operator's failure to eliminate water-contaminated fuel from the airplane, which resulted in the loss of engine power and collision with an obstacle during the forced landing. Also causal was an improperly maintained fuel storage facility.
- [NTSB FTW96LA199](https://openairdocs.org/ntsb/FTW96LA199.md): Piper PA-28 · Mountain Home, AR · Accident · Minor injuries · Limited investigation · Final report · May 1, 1996 · N9869K · Substantial damage
  > the pilot's failure to visually check the fuel quantity during the preflight inspection. A factor was the unsuitable terrain for the forced landing.
- [NTSB NYC96FA094](https://openairdocs.org/ntsb/NYC96FA094.md): Cessna 172RG · Duanesburg, NY · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1996 · N9678B · Destroyed
  > failure of the pilot to attain adequate airspeed (or abort the takeoff while there was sufficient runway remaining), which resulted in a stall after liftoff and collision with the terrain. A factor relating to the accident was: the pilot's distraction due to…
- [NTSB LAX96LA180](https://openairdocs.org/ntsb/LAX96LA180.md): Cessna 320 · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1996 · N5752X · Substantial damage
  > the partial failure of the right engine turbocharger wastegate butterfly valve to fully close due to mechanical binding and the low setting of its associated absolute pressure controller. A related factor was the high density altitude which reduced the…
- [NTSB ANC96LA060](https://openairdocs.org/ntsb/ANC96LA060.md): Piper PA-18 · Kasilof, AK · Accident · No injuries · Limited investigation · Final report · Apr 28, 1996 · N1930A · Substantial damage
  > fuel starvation due to a kinked fuel supply line from the left main tank, and the pilot's improper rebuild/remanufacture of the airplane. A smaller than standard fuel line from the fuel strainer to the carburetor, a smaller than standard fuel cap vent, and a…
- [NTSB NYC96LA091](https://openairdocs.org/ntsb/NYC96LA091.md): Cessna 140 · Houlton, ME · Accident · No injuries · Limited investigation · Final report · Apr 25, 1996 · N2001N · Substantial damage
  > the pilot's failure to select the fullest fuel tank prior to takeoff which resulted in fuel starvation during the initial takeoff climb.
- [NTSB NYC96LA090](https://openairdocs.org/ntsb/NYC96LA090.md): Grumman G-164 · Toms River, NJ · Accident · No injuries · Limited investigation · Final report · Apr 24, 1996 · N602U · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB CHI96LA142](https://openairdocs.org/ntsb/CHI96LA142.md): Beech 35 · Naperville, IL · Accident · Serious injuries · Limited investigation · Final report · Apr 24, 1996 · N680V · Substantial damage
  > the pilot allowed the airplane to become airborne prematurely, which resulted in a stall after liftoff.

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

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

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