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

## Cases, newest first

- [NTSB MIA96LA201](https://openairdocs.org/ntsb/MIA96LA201.md): Hernandez Challenger Special II · Toa Baja, PR · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 1996 · N113JM · Substantial damage
  > water contamination in the fuel system, which resulted in a partial loss of engine power shortly after takeoff. Factors relating to the accident were: the lack of a quick draining feature in the fuel system, the pilot's failure (or inability) to detect water…
- [NTSB FTW96LA334](https://openairdocs.org/ntsb/FTW96LA334.md): Cessna 210 · Pueblo, CO · Accident · No injuries · Limited investigation · Final report · Aug 3, 1996 · N414N · Substantial damage
  > improper routing of the nose landing gear hydraulic line by unknown maintenance personnel, allowing it to chafe on the nose wheel and develop a leak, which resulted in an inability to obtain a down-and-locked condition of the landing gear.
- [NTSB ATL96LA115](https://openairdocs.org/ntsb/ATL96LA115.md): Cessna 182 · Smithville, TN · Accident · No injuries · Limited investigation · Final report · Aug 3, 1996 · N8584T · Substantial damage
  > Restricted selector valve flow that resulted in fuel starvation. A factor was the automotive fuel that adversely affected an O-ring seal in the fuel selector valve.
- [NTSB ANC96LA113](https://openairdocs.org/ntsb/ANC96LA113.md): Sportsman 2+2 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Aug 3, 1996 · N5045X · Substantial damage
  > The pilot's failure to maintain control of the airplane which resulted in an inadvertent stall/mush. A factor associated with the accident was the pilot's low altitude skidding maneuver.
- [NTSB CHI96LA262](https://openairdocs.org/ntsb/CHI96LA262.md): Piper PA-J3C · Camp Lake, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1996 · N3445K · Substantial damage
  > seizure of the number 2 piston. Inadequate maintenance was a related factor.
- [NTSB CHI96FA264](https://openairdocs.org/ntsb/CHI96FA264.md): Hoffman, Wolf, Flugzeugbau H-36 · Waukegan, IL · Accident · 1 fatal · Field investigation · Final report · Jul 31, 1996 · N86PS · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in an inadvertent stalled and collision with the terrain. A factor relating to the accident was: the loose engine cowling.
- [NTSB LAX96LA293](https://openairdocs.org/ntsb/LAX96LA293.md): Thompson Long EZ TR · Yucca Valley, CA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1996 · N42DJ · Substantial damage
  > Fuel starvation due to the internal failure of the electric fuel pump and the subsequent fuel flow blockage to the gascolator.
- [NTSB SEA96LA172](https://openairdocs.org/ntsb/SEA96LA172.md): Grumman-Schweizer G-164A · Dubois, ID · Accident · No injuries · Limited investigation · Final report · Jul 27, 1996 · N5390 · Substantial damage
  > failure of the pilot to remain clear of an irrigation spray device, which resulted in inadvertent water ingestion and flameout of the aircraft's turboprop engine. Factors relating to the accident were: the proximity of the irrigation spray device (close to…
- [NTSB FTW96LA323](https://openairdocs.org/ntsb/FTW96LA323.md): Piper PA-25-235 · Moriarity, NM · Accident · No injuries · Limited investigation · Final report · Jul 27, 1996 · N7469Z · Substantial damage
  > loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.
- [NTSB SEA96LA166](https://openairdocs.org/ntsb/SEA96LA166.md): Cessna 172G · Kettle Falls, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1996 · N4478L · Destroyed
  > the pilot's inadequate preflight planning. Factors relating to the accident were: high ambient temperatures; departing from a short, grass runway; and tall trees off the departure end of the airstrip.
- [NTSB FTW96LA318](https://openairdocs.org/ntsb/FTW96LA318.md): Steward Breezy · Owasso, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1996 · N2343 · Substantial damage
  > the pilot's failure to secure his cargo prior to departure. A factor was the lack of suitable terrain available for the forced landing.
- [NTSB SEA96LA163](https://openairdocs.org/ntsb/SEA96LA163.md): Cessna 152 · Stehekin, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 1996 · N49794 · Substantial damage
  > the pilot's improper planning/decision, and his failure to ensure that the airplane would remain clear of trees during the takeoff. Factors relating to the accident were: high density altitude, and the proximity of trees to the runway.
- [NTSB MIA96LA194](https://openairdocs.org/ntsb/MIA96LA194.md): Cessna 150 · Brewton, AL · Accident · No injuries · Limited investigation · Final report · Jul 23, 1996 · N4223U · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB LAX96LA287](https://openairdocs.org/ntsb/LAX96LA287.md): Bell 47-G5 · Lost Hills, CA · Accident · No injuries · Limited investigation · Final report · Jul 23, 1996 · N7885S · Substantial damage
  > improper installation of the carburetor air box.
- [NTSB LAX96LA286](https://openairdocs.org/ntsb/LAX96LA286.md): Beech J-35 · Lovelock, NV · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 1996 · N8399J · Substantial damage
  > fuel starvation.
- [NTSB IAD96LA121](https://openairdocs.org/ntsb/IAD96LA121.md): Corben Baby Ace C-1 · Portsmouth, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1996 · N75H · Substantial damage
  > the pilot's inadequate preflight inspection, which resulted in a loss of engine power during the initial climb out. A related factor was the rising terrain encountered during the forced landing.
- [NTSB LAX96LA281](https://openairdocs.org/ntsb/LAX96LA281.md): Graham Falcon XP · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Jul 20, 1996 · N647AA · Substantial damage
  > blockage of the fuel system vent in the fuel cap, when the pilot overtorqued the fuel cap during his preflight check, which restricted fuel flow to the engine. The pilot's lack of experience in the make and model of airplane was a related factor.
- [NTSB LAX96LA280](https://openairdocs.org/ntsb/LAX96LA280.md): Mitsubishi MU-2B · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Jul 20, 1996 · N999FA · Destroyed
  > an uncontained failure of the second stage turbine wheel due to fatigue. Factors were: obstructions in the forced landing area and the inability of the airplane to climb after the turbine wheel failure.
- [NTSB CHI96LA250](https://openairdocs.org/ntsb/CHI96LA250.md): Poppenhagen PUD Knocker Special · Grafton, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1996 · N380BP · Substantial damage
  > the inadequate fuel system design by the builder which led to fuel starvation.
- [NTSB MIA96LA188](https://openairdocs.org/ntsb/MIA96LA188.md): Cessna 152 · Troy, AL · Accident · No injuries · Limited investigation · Final report · Jul 17, 1996 · N6481L · Substantial damage
  > fuel contamination, which resulted in loss of engine power, a forced landing, and impact with trees. A factor relating to the accident was: inadequate maintenance and/or inspection after the previous loss of engine power and forced landing.
- [NTSB CHI96LA245](https://openairdocs.org/ntsb/CHI96LA245.md): Piper PA-25-235 · Beltrami, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1996 · N4997Y · Substantial damage
  > the pilot's inadequate preflight planning. Factors in the accident were the pilot's failure to jettison the load and the soft runway overrun area.
- [NTSB FTW96LA307](https://openairdocs.org/ntsb/FTW96LA307.md): Wsk Pzl Mielec M-18A · Beedeville, AR · Accident · No injuries · Limited investigation · Final report · Jul 16, 1996 · N163RA · Substantial damage
  > The pilot's failure to maintain terrain clearance.
- [NTSB IAD96LA118](https://openairdocs.org/ntsb/IAD96LA118.md): Cessna 172 · Frederick, MD · Accident · No injuries · Limited investigation · Final report · Jul 14, 1996 · N78149 · Substantial damage
  > the private pilot's inadvertently stalling the airplane immediately after takeoff. A related factor was the pilot's improper procedures during lift-off.
- [NTSB MIA96LA183](https://openairdocs.org/ntsb/MIA96LA183.md): Rockwell S2R · Belzoni, MS · Accident · No injuries · Limited investigation · Final report · Jul 13, 1996 · N3695X · Substantial damage
  > fatigue failure of the #5 cylinder skirt, which resulted in debris that caused the oil scavenge pump to fail, oil starvation, cam drive seizure, loss of engine power, and a subsequent forced landing in a field of cotton.
- [NTSB MIA96LA182](https://openairdocs.org/ntsb/MIA96LA182.md): Tocholke 1300-Z MAX · Lascassas, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1996 · N398MT · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering (turning) after takeoff, which resulted in an inadvertent stall at too low of an altitude to allow recovery.
- [NTSB IAD96LA115](https://openairdocs.org/ntsb/IAD96LA115.md): Piper PA-46-310P · Hartford, CT · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1996 · N234DM · Destroyed
  > the pilot's inadequate preflight planning/preparation, and his failure to attain the proper lift-off airspeed, which resulted in a stall and collision with the terrain (river).
- [NTSB CHI96LA232](https://openairdocs.org/ntsb/CHI96LA232.md): Cessna 188 · Independence, IA · Accident · No injuries · Limited investigation · Final report · Jul 10, 1996 · N9542J · Substantial damage
  > the delayed jettison of the dry chemicals by the pilot. The inability of the airplane to climb was a related factor.
- [NTSB MIA96IA179](https://openairdocs.org/ntsb/MIA96IA179.md): Short Brothers SD3-60-200 · San Juan, PR · Incident · No injuries · Incident investigation · Final report · Jul 9, 1996 · N384MQ · No damage
  > Fatigue failure of a segment of the elevator trim control cable. Contributing to the accident was the failure of the airplane manufacturer to require a replacement interval of the cables.
- [NTSB NYC96LA146](https://openairdocs.org/ntsb/NYC96LA146.md): Cessna 172H · Cherry Tree, PA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1996 · N1412F · Substantial damage
  > the pilot's failure to assure that adequate takeoff distance was available to clear an obstacle.
- [NTSB IAD96LA105](https://openairdocs.org/ntsb/IAD96LA105.md): Piper PA-23-250 · Harrisburg, PA · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1996 · N6994Y · Destroyed
  > Failure of the right engine due to a fatigue fracture of the crankshaft resultant from heat cracks from an undetermined source.
- [NTSB NYC96LA140](https://openairdocs.org/ntsb/NYC96LA140.md): Schweizer SGS 1-26E · Marston Mills, MA · Accident · 1 fatal · Limited investigation · Final report · Jul 5, 1996 · N603MX · Destroyed
  > failure of the pilot to maintain control of the glider while being towed during takeoff, which resulted in a pitch oscillation, failure of the tow cable, loss of airspeed, an inadvertent stall/spin, and an uncontrolled collision with the ground.
- [NTSB MIA96LA173](https://openairdocs.org/ntsb/MIA96LA173.md): Piper PA-23-150 · Knoxville, TN · Accident · No injuries · Limited investigation · Final report · Jul 2, 1996 · N3061P · Substantial damage
  > Fatigue failure of the blade No. 1 hub arm of the left propeller.
- [NTSB LAX96LA258](https://openairdocs.org/ntsb/LAX96LA258.md): Davis Challenger I CW · Paso Robles, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 2, 1996 · N75489 · Destroyed
  > the owner/builder/pilot's impairment of judgment and performance due to drugs which led to his improper handling of the airplane and failure to maintain an adequate airspeed margin above stall speed, resulting in an inadvertent stall/spin. A factor which…
- [NTSB FTW96FA282](https://openairdocs.org/ntsb/FTW96FA282.md): Saab-Scania SF340B · Dfw Airport, TX · Accident · No injuries · Field investigation · Final report · Jul 1, 1996 · N335AE · Substantial damage
  > The manufacturer's inadequate procedure for manufacturing the number two turbine disk.
- [NTSB LAX96LA261](https://openairdocs.org/ntsb/LAX96LA261.md): Rominger Eyas · Santa Rosa, CA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1996 · N8012U · Substantial damage
  > an inadequate design change by the pilot/builder of the airplane's canopy; a malfunction of the canopy, which resulted in its separation; and failure of the pilot to flare the airplane during an emergency landing after takeoff, due to the wind blast that…
- [NTSB ANC96LA093](https://openairdocs.org/ntsb/ANC96LA093.md): Cessna 206 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1996 · N5244Z · 2 aircraft · Substantial damage
  > The pilot of the Cessna 180, N5020E, disregard of an air traffic control clearance/instruction to hold short. A factor in the accident was the failure of both pilots to maintain an adequate visual lookout for other aircraft.
- [NTSB NYC96LA134](https://openairdocs.org/ntsb/NYC96LA134.md): Wsk Pzl-Krosno KR-03A · Hilltown, PA · Accident · No injuries · Limited investigation · Final report · Jun 28, 1996 · N32113 · Substantial damage
  > failure of a bolt on the tow hook which resulted in an uncommanded release of the tow rope, and forced landing of the glider.
- [NTSB LAX96LA248](https://openairdocs.org/ntsb/LAX96LA248.md): Cessna 150H · San Carlos, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1996 · N7260S · Substantial damage
  > The failure of the flaps to retract due to the installation of an incorrect fuse and the inadequate maintenance/inspections performed on the system; and the pilot-in-command's failure to maintain an adequate airspeed while maneuvering for a forced landing,…
- [NTSB NYC96IA131](https://openairdocs.org/ntsb/NYC96IA131.md): Boeing 767-332ER · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Jun 25, 1996 · N185DN · Minor damage
  > the improper installation of the generator feed cable by the manufacturer, which resulted in a severed aileron cable due to arcing between the generator feed cable and aileron cable.
- [NTSB CHI96LA215](https://openairdocs.org/ntsb/CHI96LA215.md): Loehle-Avia 5151RG · Fond Du Lac, WI · Accident · No injuries · Limited investigation · Final report · Jun 25, 1996 · N5151N · Substantial damage
  > the pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the design/location of the fuel tank selector.
- [NTSB CHI96LA210](https://openairdocs.org/ntsb/CHI96LA210.md): Farland Genesis · Le Sueur, MN · Accident · 1 fatal · Limited investigation · Final report · Jun 24, 1996 · N9274S · Destroyed
  > the pilot's impairment of judgment and performance due to drugs, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent and collision with terrain. Factors related to the accident were: the pilot's limited aeronautical…
- [NTSB CHI96FA209](https://openairdocs.org/ntsb/CHI96FA209.md): Beech 23 · Fulton, MO · Accident · 2 fatal · Field investigation · Final report · Jun 22, 1996 · N2397J · Destroyed
  > the inadequate intake valve springs on the #1 cylinder.
- [NTSB LAX96LA240](https://openairdocs.org/ntsb/LAX96LA240.md): Experimental Mini Mustang · Page, AZ · Accident · 1 fatal · Limited investigation · Final report · Jun 21, 1996 · N61D · Destroyed
  > the pilot's inadequate compensation for crosswind conditions, and his failure to maintain control of the aircraft. A factor relating to the accident was: the gusty/crosswind condition.
- [NTSB FTW96FA262](https://openairdocs.org/ntsb/FTW96FA262.md): Douglas DC3A · Cut And Shoot, TX · Accident · Minor injuries · Field investigation · Final report · Jun 20, 1996 · N23WT · Destroyed
  > The flight instructor's failure to use the single engine best angle of climb airspeed resulting in a loss of control of the aircraft. Factors were the loss of power to the left engine for undetermined reasons, the flight instructor not being qualified to be…
- [NTSB IAD96LA099](https://openairdocs.org/ntsb/IAD96LA099.md): Aeronca L-3B · Morgantown, WV · Accident · No injuries · Limited investigation · Final report · Jun 16, 1996 · N46634 · Substantial damage
  > An inadequate maintenance/annual inspection and failure of the muffler which resulted in melted insulation on the magneto 'P' leads and subsequent loss of engine power. A related factor was the lack of suitable terrain for the forced landing.
- [NTSB IAD96LA096](https://openairdocs.org/ntsb/IAD96LA096.md): Little Scamp · Worthington, KY · Accident · Minor injuries · Limited investigation · Final report · Jun 15, 1996 · N9995A · Destroyed
  > was the loss of engine power for undetermined reasons shortly after liftoff. A related factor was the unsuitable terrain encountered during the forced landing.
- [NTSB FTW96LA254](https://openairdocs.org/ntsb/FTW96LA254.md): Cessna 172H · Crockett, TX · Accident · No injuries · Limited investigation · Final report · Jun 15, 1996 · N8824Z · Substantial damage
  > Loss of engine power for undetermined reason(s).
- [NTSB CHI96LA203](https://openairdocs.org/ntsb/CHI96LA203.md): Schweizer G164B · Oslo, MN · Accident · No injuries · Limited investigation · Final report · Jun 15, 1996 · N36311 · Substantial damage
  > the pilot not using carburetor heat when the engine began to lose power. Factors in this accident were carburetor ice formation and the soft landing surface the pilot had to use for landing.
- [NTSB NYC96LA130](https://openairdocs.org/ntsb/NYC96LA130.md): Stinson 108-1 · Elbridge, NY · Accident · No injuries · Limited investigation · Final report · Jun 14, 1996 · N8073K · Substantial damage
  > The pilot's improper decision to use auto fuel and to fly the airplane when it was in need of major repairs and overdue its annual inspection.
- [NTSB NYC96FA126](https://openairdocs.org/ntsb/NYC96FA126.md): Piper PA-23-150 · Cortland, NY · Accident · 3 fatal · Field investigation · Final report · Jun 14, 1996 · N2189P · Destroyed
  > the pilot failure to maintain directional control of the airplane which resulted in the airplane striking trees. Contributing factors were the pilot's spatial disorientation, dark night conditions, fog, and the pilot's self induced pressure to reach the…

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

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

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