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

## Cases, newest first

- [NTSB NYC91FA103](https://openairdocs.org/ntsb/NYC91FA103.md): Bellanca 17-31 ATC · Gt. Barrington, MA · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1991 · N1269R · Destroyed
  > The mechanic's improper use of anti-seize compound on the injector nozzle threads which resulted in an engine failure.
- [NTSB DEN91LA059](https://openairdocs.org/ntsb/DEN91LA059.md): Beech A36 · Salida, CO · Accident · No injuries · Limited investigation · Final report · Apr 6, 1991 · N4595S · Substantial damage
  > The dual student's poor takeoff technique, his failure to maintain directional control, and inadequate supervision by the PIC CFI. A factor was: the dual student's lack of experience in mountain flying.
- [NTSB CHI91LA121](https://openairdocs.org/ntsb/CHI91LA121.md): Piper PA-28-161 · Schaumburg, IL · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 1991 · N2366W · Substantial damage
  > The mechanic's not understanding the identifying marks on the replacement part. A factor in the accident was that the mechanic was provided with an improper part.
- [NTSB LAX91FA156](https://openairdocs.org/ntsb/LAX91FA156.md): Herbert W. Ross RV-4 · Santa Paula, CA · Accident · 2 fatal · Field investigation · Final report · Apr 3, 1991 · N45EM · Destroyed
  > That the pilot inadvertently selected the wrong fuel tank and the passenger interfered with the flight controls when the seat back failed.
- [NTSB SEA91LA072](https://openairdocs.org/ntsb/SEA91LA072.md): Piper PA-28-180 · Wamic, OR · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 1991 · N7119W · Destroyed
  > The pilot's selection of an empty fuel tank for takeoff.
- [NTSB SEA91FA069](https://openairdocs.org/ntsb/SEA91FA069.md): Cessna 150G · Kennewick, WA · Accident · 2 fatal · Field investigation · Final report · Mar 27, 1991 · N4065J · Destroyed
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to maintain adequate airspeed, while maneuvering to make a forced landing, which resulted in a stall.
- [NTSB MIA91LA112](https://openairdocs.org/ntsb/MIA91LA112.md): Piper PA-28R-200 · Sanford, FL · Accident · No injuries · Limited investigation · Final report · Mar 27, 1991 · N55516 · Substantial damage
  > Excessive flare by the dual student during the forced landing following a simulated engine failure shortly after takeoff. Also, failure of the student to maintain vs, and failure of the CFI to take remedial action.
- [NTSB MIA91LA110](https://openairdocs.org/ntsb/MIA91LA110.md): Cessna 150L · Quincy, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1991 · N10860 · Substantial damage
  > The pilot's inadequate preflight.
- [NTSB FTW91DPJ01](https://openairdocs.org/ntsb/FTW91DPJ01.md): Piper PA-25 · Spiro, OK · Accident · Serious injuries · Final report · Mar 26, 1991 · N9845P · Destroyed
  > A power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX91LA145](https://openairdocs.org/ntsb/LAX91LA145.md): Aeronca 7-AC · No. Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Mar 25, 1991 · N84025 · Destroyed
  > The pilot's failure to maintain airspeed.
- [NTSB MIA91LA108](https://openairdocs.org/ntsb/MIA91LA108.md): Glassair SH-2TD · Bay St. Louis, MS · Accident · Minor injuries · Limited investigation · Final report · Mar 24, 1991 · N59BH · Substantial damage
  > The loss of power due to vapor lock of the fuel system on takeoff. Contributing to the cause of the accident was the improper decision of the pilot-in-command to attempt to take off with known deficiencies in the airplane.
- [NTSB BFO91LA038](https://openairdocs.org/ntsb/BFO91LA038.md): Cessna 152 · California, MD · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1991 · N757PH · Destroyed
  > The loss of engine power for undetermined reasons resulting in a forced landing and on ground collision with terrain.
- [NTSB LAX91FA139](https://openairdocs.org/ntsb/LAX91FA139.md): Beech 55 · Burbank, CA · Accident · Serious injuries · Field investigation · Final report · Mar 21, 1991 · N711RY · Destroyed
  > The pilot misjudged the liftoff speed, and prematurely rotated the aircraft for takeoff.
- [NTSB FTW91LA054](https://openairdocs.org/ntsb/FTW91LA054.md): Cessna 210 · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1991 · N219CG · Substantial damage
  > The power loss due to fatigue induced crankshaft failure. Factors were the pilot's continued operation with known mechanical malfunction and the lack of suitable terrain for the forced landing.
- [NTSB NYC91LA090](https://openairdocs.org/ntsb/NYC91LA090.md): Piper PA-22-150 · Phillipsburg, PA · Accident · No injuries · Limited investigation · Final report · Mar 17, 1991 · N4510A · Substantial damage
  > Carburetor ice and the pilot's improper use of carburetor heat. Factors related to the accident were: the carburetor icing (weather) conditions and the lack of suitable terrain for a forced landing.
- [NTSB MIA91LA113](https://openairdocs.org/ntsb/MIA91LA113.md): Bell UH-1B · Vero Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1991 · N9687R · Substantial damage
  > Improper maintenance adjustment by company maintenance personnel resulting in overtorque of a tailboom attach bolt which allowed the tailboom to shift. This disengaged the tail rotor drive shaft at a coupling resulting in the loss of tail rotor drive.
- [NTSB LAX91LA129](https://openairdocs.org/ntsb/LAX91LA129.md): Cessna 421B · Tucson, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 1991 · N924MD · Substantial damage
  > The fatigue failure of the right engine turbo exhaust clamp, and, the failure of the flying pilot to complete the single engine emergency procedures in a timely manner. A factor in the accident was the failure of the pilot in command to adequately supervise…
- [NTSB SEA91LA064](https://openairdocs.org/ntsb/SEA91LA064.md): Mooney M20C · Loa, UT · Accident · Serious injuries · Limited investigation · Final report · Mar 10, 1991 · N7108U · Substantial damage
  > The pilot-in-command's failure to maintain airspeed on takeoff climb in a turn resulting in an inadvertnent stall and subsequent in flight collision with terrain. Contributing to the accident was a crosswind with gusts.
- [NTSB MIA91FA095](https://openairdocs.org/ntsb/MIA91FA095.md): Beech 35-C33A · Key West, FL · Accident · 3 fatal · Field investigation · Final report · Mar 10, 1991 · N4828J · Destroyed
  > The pilot-in-command's failure to maintain airspeed, while returning for an emergency landing following propeller failure, resulting in the aircraft stalling and entering a spin.
- [NTSB DEN91LA050](https://openairdocs.org/ntsb/DEN91LA050.md): Beech V35B · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Mar 10, 1991 · N9038Q · Destroyed
  > The pilot's premature liftoff and inadvertent stall mush. Factors were: downdrafts, high density altitude, and unsuitable terrain.
- [NTSB NYC91LA083](https://openairdocs.org/ntsb/NYC91LA083.md): Piper PA-30-160 · Rancocas, NJ · Accident · No injuries · Limited investigation · Final report · Mar 7, 1991 · N74994 · Substantial damage
  > The pilot-in-command failed to maintain airspeed on initial take off climb resulting in a stall and in flight collision with terrain. Contributing to the accident was a loss of engine power for undetermined reason and a gusty crosswind condition.
- [NTSB NYC91LA079](https://openairdocs.org/ntsb/NYC91LA079.md): Piper PA-28-161 · Philadelphia, PA · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 1991 · N2960B · Destroyed
  > Due to failure of the induction air control/air filter/screen, which blocked airflow through the carburetor throat.
- [NTSB LAX91LA118](https://openairdocs.org/ntsb/LAX91LA118.md): Beech BE-77 · Carmel Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 1991 · N3846X · Destroyed
  > The failure of the PIC to supervise a non-certificated pilot and to maintain adequate airspeed with subsequent collision with trees. Contributing to the accident was the failure of the PIC to obtain a weather briefing and assess hazardous wind conditions and…
- [NTSB LAX91LA115](https://openairdocs.org/ntsb/LAX91LA115.md): Cessna 182P · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Mar 2, 1991 · N182WS · Substantial damage
  > Failure of the PIC to ensure that the fuel system was free of water prior to flight. Contributing to the accident was the inadequate compliance with airworthiness directives by maintenance personnel to preclude water from entering the fuel system.
- [NTSB DEN91FA048](https://openairdocs.org/ntsb/DEN91FA048.md): Cessna T210M · Taos, NM · Accident · 1 fatal · Field investigation · Final report · Mar 2, 1991 · N761MU · Destroyed
  > The pilot's decision to initiate flight into freezing rain which resulted in structural icing that exceeded the ability of the aircraft to maintain flight. A factor was: improper deicing.
- [NTSB SEA91FA059](https://openairdocs.org/ntsb/SEA91FA059.md): Cessna 172 · Oregon City, OR · Accident · 1 fatal · Field investigation · Final report · Feb 28, 1991 · N7119T · Destroyed
  > The pilot's failure to attain proper airspeed before takeoff. Factors relating to the accident were the binding brake, the uphill grass airstrip, the tail wind weather conditions, and the improper annual inspection that was just completed on the aircraft.
- [NTSB MIA91LA087](https://openairdocs.org/ntsb/MIA91LA087.md): Piper PA-28-161 · Valkaria, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 25, 1991 · N609FT · Substantial damage
  > The failure of the instructor pilot to supervise the student pilot's actions, resulting in a stall at a low altitude where recovery was not possible.
- [NTSB FTW91FA043](https://openairdocs.org/ntsb/FTW91FA043.md): Mitsubishi MU-2B-60 · Tulsa, OK · Accident · 3 fatal · Field investigation · Final report · Feb 22, 1991 · N274MA · Destroyed
  > The shutdown of one engine for undetermined reasons, and the pilot's failure to maintain vmca during a critical phase of flight. A factor in the accident was the pilot's improper emergency procedure.
- [NTSB SEA91FA054](https://openairdocs.org/ntsb/SEA91FA054.md): Piper PA-15 · Cottage Grove, OR · Accident · 2 fatal · Field investigation · Final report · Feb 20, 1991 · N4518H · Substantial damage
  > The pilot did not maintain an adequate airspeed. Factors to the accident were: a dark night condition and an uncontrolled stall/spin.
- [NTSB LAX91LA109](https://openairdocs.org/ntsb/LAX91LA109.md): Rockwell S2R-600 · Corcoran, CA · Accident · No injuries · Limited investigation · Final report · Feb 18, 1991 · N4930X · Substantial damage
  > Failure of the aircraft engine's fuel pump valve assembly bypass.
- [NTSB LAX91FA103](https://openairdocs.org/ntsb/LAX91FA103.md): Cessna 172 · Bullhead City, CA · Accident · Serious injuries · Field investigation · Final report · Feb 17, 1991 · N8551B · Substantial damage
  > The pilot's poor in-flight planning and decision and physical impairment from fatigue; he also failed to maintain flying speed. The lineman's failure to secure the access door and the pilot's impairment due to consumption of alcohol were factors in the…
- [NTSB DCA91MA021](https://openairdocs.org/ntsb/DCA91MA021.md): Mcdonnell Douglas DC-9-15 · Cleveland, OH · Accident · 2 fatal · Class 1 · Major · Final report · Feb 17, 1991 · N565PC · Destroyed
  > The failure of the flightcrew to detect and remove ice contamination on the airplane's wings, which was largely a result of a lack of appropriate response by the federal aviation administration, Douglas aircraft company, and ryan international airlines to the…
- [NTSB DEN91LA044](https://openairdocs.org/ntsb/DEN91LA044.md): Cessna 152 · Timberon, NM · Accident · No injuries · Limited investigation · Final report · Feb 16, 1991 · N49123 · Substantial damage
  > The pilot's inadequate preflight planning and selection of the wrong runway. Related factors were: the rising terrain, trees, and the pilot's lack of experience.
- [NTSB ATL91LA055](https://openairdocs.org/ntsb/ATL91LA055.md): Beech C23 · Concord, NC · Accident · No injuries · Limited investigation · Final report · Feb 14, 1991 · N9146S · Substantial damage
  > The pilot's inadequate preflight planning in that he disregarded the crosswind limit in the pilot's operating handbook. Factors were the wet runway and the ravine at the end of the runway.
- [NTSB LAX91FA098](https://openairdocs.org/ntsb/LAX91FA098.md): Bell 206B · Santa Paula, CA · Accident · 2 fatal · Field investigation · Final report · Feb 13, 1991 · N2282T · 2 aircraft · Substantial damage
  > Inadequate visual lookout by the Bell 206B pilot, which resulted in his failure to see-and-avoid the pitts S-2A. A factor related to the accident was: the S-2A pilot's restricted visibility from the tailwheel equipped airplane, once it was in position on the…
- [NTSB NYC91LA075](https://openairdocs.org/ntsb/NYC91LA075.md): Cessna 150G · Mount Gilead, OH · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 1991 · N2859S · Substantial damage
  > The pilot's improper use of carburetor heat resulting in an engine failure due to carburetor ice and a subsequent off airport landing in unsuitable terrain.
- [NTSB LAX91LA107](https://openairdocs.org/ntsb/LAX91LA107.md): Questaire Venture · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Feb 12, 1991 · N71T · Substantial damage
  > The failure of the fuel system vent check valve, which resulted in fuel starvation to the aircraft's engine.
- [NTSB ATL91LA061](https://openairdocs.org/ntsb/ATL91LA061.md): Maxair ARV 582 · Eastman, GA · Accident · Serious injuries · Limited investigation · Final report · Feb 10, 1991 · UNREG · Substantial damage
  > The inadvertent stall of the aircraft which was encountered as a result of the lack of total experience of the non-rated pilot.
- [NTSB FTW91DPA01](https://openairdocs.org/ntsb/FTW91DPA01.md): Donald E. Samuels Q2 · Gilmer, TX · Accident · Serious injuries · Final report · Feb 9, 1991 · N3147L · Destroyed
  > The pilot's failure to attain proper climb performance.
- [NTSB NYC91FA073](https://openairdocs.org/ntsb/NYC91FA073.md): Beech BE-58 · Skaneateles, NY · Accident · 2 fatal · Field investigation · Final report · Feb 7, 1991 · N80JB · Destroyed
  > The pilot's loss of situational awareness/disorientation due to the influences of cocaine, which resulted in the loss of airplane control in instrument meteorological conditions. Factors related to the accident were: psychological impairment, fatigue and…
- [NTSB MIA91LA078](https://openairdocs.org/ntsb/MIA91LA078.md): Cessna 150G · La Belle, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 7, 1991 · N2481J · Substantial damage
  > Total loss of engine power due to undetermined reasons.
- [NTSB SEA91LA048](https://openairdocs.org/ntsb/SEA91LA048.md): Maule M-5-235C · Draper, UT · Accident · Minor injuries · Limited investigation · Final report · Feb 6, 1991 · N392X · Substantial damage
  > An undetermined loss of engine power.
- [NTSB NYC91LA070](https://openairdocs.org/ntsb/NYC91LA070.md): Cessna 172M · Nashua, NH · Accident · No injuries · Limited investigation · Final report · Feb 2, 1991 · N13341 · Substantial damage
  > Fuel system contamination by other personnel which resulted in an inflight engine failure and a subsequent forced landing in unsuitable terrain.
- [NTSB NYC91FA069](https://openairdocs.org/ntsb/NYC91FA069.md): Cessna 172P · Augusta, ME · Accident · 3 fatal · Field investigation · Final report · Feb 2, 1991 · N62746 · Destroyed
  > The pilot rotated the airplane at an improper speed, then allowed the climb angle to become too steep, causing an inadvertent stall at too low an altitude to allow recovery. Contributing factors in the accident were; the pilot failed to use all of the…
- [NTSB MIA91FA076](https://openairdocs.org/ntsb/MIA91FA076.md): Aerospatiale SA-341G · Miami, FL · Accident · Serious injuries · Field investigation · Final report · Jan 31, 1991 · N341WC · Destroyed
  > The pilot in command's failure to initiate an autorotation in timely manner following loss of engine power for undetermined reasons resulting in loss of rotor RPM and an uncontrolled descent and impact with the terrain.
- [NTSB CHI91LA083](https://openairdocs.org/ntsb/CHI91LA083.md): Cessna R182 · Indianapolis, IN · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 1991 · N6610S · Substantial damage
  > Visual outlook was not possible and aircraft directional control was not maintained by the pilot. Factors related to the accident were dense fog, early dawn light conditions, poor judgement and over confidence in personal ability by the pilot and trees in the…
- [NTSB ANC91LA022](https://openairdocs.org/ntsb/ANC91LA022.md): De Havilland DHC-3 · Nome, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 1991 · N212NY · Substantial damage
  > The failure of the 1, 2, 6, 7, 8 and 9 piston linkrods which were broken at the master rod attach end. Contributing to the accident was the rough, uneven terrain.
- [NTSB MIA91LA073](https://openairdocs.org/ntsb/MIA91LA073.md): Piper PA-28-140 · Titusville, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 27, 1991 · N610FL · Substantial damage
  > Partial loss of engine power after takeoff due to undetermined reasons resulting in the emergency descent and in-flight collision with the power line then the ground.
- [NTSB MIA91LA072](https://openairdocs.org/ntsb/MIA91LA072.md): Cessna 170A · Fort Myers, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1991 · N1279D · Substantial damage
  > In-flight encounter with a downdraft which caused the airspeed to decrease below vso resulting in an inadvertent stall/mush.
- [NTSB SEA91LA045](https://openairdocs.org/ntsb/SEA91LA045.md): Cessna C-150L · Alderwood Manor, WA · Accident · No injuries · Limited investigation · Final report · Jan 22, 1991 · N5437Q · Substantial damage
  > The failure of the pilot in command to attain proper clearance from terrain. A factor relating to this accident was the night light conditions.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.