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

## Cases, newest first

- [NTSB SEA99FA144](https://openairdocs.org/ntsb/SEA99FA144.md): Beech F33A · White Swan, WA · Accident · 1 fatal · Field investigation · Final report · Aug 19, 1999 · N2291L · Substantial damage
  > Inadequate preflight planning/preparation and low airspeed. A dirt embankment, soft runway, and an excessive takeoff weight were factors.
- [NTSB LAX99LA264](https://openairdocs.org/ntsb/LAX99LA264.md): Diamond Aircraft Industries Katana DA 20-A1 · San Carlos, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1999 · N854DF · Substantial damage
  > The release of the aircraft's left canopy latch following takeoff resulting in the subsequent opening of the canopy in flight. The opened canopy resulted in a degradation of aircraft control and the subsequent hard landing.
- [NTSB NYC99GA197](https://openairdocs.org/ntsb/NYC99GA197.md): Bell 407 · Georgetown, DE · Accident · Minor injuries · Final report · Aug 17, 1999 · N97SP · Destroyed
  > The pilot's improper preflight evaluation of the weather, which resulted in inadvertent flight into IMC. Factors were the fog, and night conditions.
- [NTSB CHI99LA305](https://openairdocs.org/ntsb/CHI99LA305.md): Piper PA-28-180 · Harsens Island, MI · Accident · No injuries · Limited investigation · Final report · Aug 17, 1999 · N44547 · Substantial damage
  > the loss of engine power for undetermined reasons. Factors were the berm and the pond.
- [NTSB FTW99FA222](https://openairdocs.org/ntsb/FTW99FA222.md): Piper PA30 · Holdenville, OK · Accident · 1 fatal · Field investigation · Final report · Aug 16, 1999 · N7178Y · Destroyed
  > the pilot's failure to maintain aircraft control during takeoff initial climb. Factors were the loss of right engine power for undetermined reasons, and the pilot's lack of total experience in the make and model of aircraft.
- [NTSB DEN99LA145](https://openairdocs.org/ntsb/DEN99LA145.md): Cessna 337 · Edgewood, NM · Accident · No injuries · Limited investigation · Final report · Aug 15, 1999 · N99MH · Substantial damage
  > Breakage of the safety wire that secured the propeller control cable to the support bracket. Factors were the inability of the pilot to feather the propeller or change propeller rpm, and rough, uneven, and unsuitable terrain on which to make a forced landing.
- [NTSB ANC99LA114](https://openairdocs.org/ntsb/ANC99LA114.md): Cessna 206A · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Aug 15, 1999 · N4605F · Substantial damage
  > A loss of engine power due to corrosion/blockage of the fuel flow divider vent hole. A factor was unsuitable terrain for a forced landing.
- [NTSB SEA99LA143](https://openairdocs.org/ntsb/SEA99LA143.md): Cessna 210B · Port Angeles, WA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1999 · N9588X · Substantial damage
  > The failure of maintenance personnel to detect cracked main landing gear saddles during required inspection, and subsequent fatigue fracture of the left main landing gear saddle resulting in separation of the saddle and disabling of the left main gear.
- [NTSB FTW99LA227](https://openairdocs.org/ntsb/FTW99LA227.md): Aeronca 11AC · Rockwall, TX · Accident · No injuries · Limited investigation · Final report · Aug 14, 1999 · N3184E · Substantial damage
  > The mechanic's improper machining of the crankshaft during a major overhaul, which resulted in a fatigue crack and subsequent failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI99FA296](https://openairdocs.org/ntsb/CHI99FA296.md): Johannes-Robert Acrosport RJ-2 · Campbellsport, WI · Accident · 1 fatal · Field investigation · Final report · Aug 14, 1999 · N42J · Destroyed
  > The loss of control during initial climb for undetermined reasons.
- [NTSB CHI99LA288](https://openairdocs.org/ntsb/CHI99LA288.md): Cessna 172G · Glenarm, IL · Accident · No injuries · Limited investigation · Final report · Aug 13, 1999 · N4425L · Substantial damage
  > the pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.
- [NTSB MIA99LA223](https://openairdocs.org/ntsb/MIA99LA223.md): Arnet Pereyra Aero Aventura II · Rockledge, FL · Accident · 1 fatal · Limited investigation · Final report · Aug 11, 1999 · N303SQ · Substantial damage
  > The pilot's failure to attain directional control during his attempted takeoff due to his exceeding the airplane's gross weight limit for takeoff and the resultant inflight collision with a building.
- [NTSB CHI99LA298](https://openairdocs.org/ntsb/CHI99LA298.md): Bell 206L · Cape Girardeau, MO · Accident · No injuries · Limited investigation · Final report · Aug 10, 1999 · N810F · Substantial damage
  > The inadequate preflight planning/preparation by the pilot, in that the auxiliary power unit cord was not removed. The brick wall was a contributing factor.
- [NTSB NYC99FA193](https://openairdocs.org/ntsb/NYC99FA193.md): Piper PA28R-180 · Seven Springs, PA · Accident · 2 fatal · Field investigation · Final report · Aug 8, 1999 · N3892T · Substantial damage
  > The pilot's failure to obtain a rate of climb after takeoff due to spatial disorientation. Factors in this accident were low ceilings, fog, and the pilot's lack experience in instrument meteorological conditions.
- [NTSB FTW99LA214](https://openairdocs.org/ntsb/FTW99LA214.md): Cessna 150J · Cypress, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1999 · N60784 · Substantial damage
  > The flight instructor's failure to maintain/obtain airspeed during takeoff climb, which resulted in an inadvertent stall/mush.
- [NTSB FTW99LA216](https://openairdocs.org/ntsb/FTW99LA216.md): Cessna 172RG · Celina, TX · Accident · No injuries · Limited investigation · Final report · Aug 7, 1999 · N9620B · Substantial damage
  > The failure of the pilot in command to use all of the available runway for takeoff.
- [NTSB MIA99FA215](https://openairdocs.org/ntsb/MIA99FA215.md): Cessna 150F · Maple, NC · Accident · 2 fatal · Field investigation · Final report · Aug 6, 1999 · N7059F · Destroyed
  > the pilot's failure to follow the aircraft's operating checklist and retract the wing flaps for takeoff as specified, as well as the pilot's failure to maintain airspeed (Vso) on initial takeoff climb, which resulted in an inadvertent stall, a spin, and…
- [NTSB LAX99FA262](https://openairdocs.org/ntsb/LAX99FA262.md): Cessna 177B · Tusayan, AZ · Accident · 2 fatal · Field investigation · Final report · Aug 3, 1999 · N19113 · Destroyed
  > was the pilot's failure to have available and consult the FAA approved flight manual for performance data and, the high density altitude. Contributing to the accident were the dual magneto and spark plug system issues affecting optimum engine performance.
- [NTSB SEA99LA133](https://openairdocs.org/ntsb/SEA99LA133.md): Beech B36TC · Renton, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 1999 · N3151G · Substantial damage
  > A loss of engine power for undetermined reasons. A factor was insufficient altitude available to return to the departure runway following the loss of power.
- [NTSB MIA99FA208](https://openairdocs.org/ntsb/MIA99FA208.md): Gulfstream American AA-1B · Hilliard, FL · Accident · 1 fatal · Field investigation · Final report · Aug 1, 1999 · N9888L · Destroyed
  > the pilot's failure to obtain notams and his improper planning and decision to use a closed runway for takeoff with tall trees on the departure end, resulting in a subsequent collision with the trees.
- [NTSB DEN99LA132](https://openairdocs.org/ntsb/DEN99LA132.md): Piper PA-28-180 · Edgewood, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1999 · N7521W · Substantial damage
  > The pilot's excessive rotation during takeoff, resulting in an inadvertent stall/mush. Factors were the pilot's lack of recent flight experience, and the high density altitude..
- [NTSB CHI99MA269](https://openairdocs.org/ntsb/CHI99MA269.md): Beech 65-A90 · Marine City, MI · Accident · 10 fatal · Major investigation · Final report · Jul 31, 1999 · N518DM · Destroyed
  > The pilot's failure to maintain adequate airspeed, which resulted in a stall, inflight loss of contol, and collision with the ground.
- [NTSB CHI99LA268](https://openairdocs.org/ntsb/CHI99LA268.md): Air Tractor AT-401B · Edelstein, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 1999 · N61775 · Substantial damage
  > an inadequate fuel supply which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the corn crop the airplane contacted.
- [NTSB CHI99FA264](https://openairdocs.org/ntsb/CHI99FA264.md): Beech C23 · Detroit Lakes, MN · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1999 · N6996R · Destroyed
  > Aircraft control not obtained/maintained by the pilot. A factor to the accident was the pilot's impairment due to drugs.
- [NTSB FTW99LA202](https://openairdocs.org/ntsb/FTW99LA202.md): Cessna A150M · Alvin, TX · Accident · No injuries · Limited investigation · Final report · Jul 27, 1999 · N2721J · Substantial damage
  > The flight instructor's excessive rotation while performing a soft field takeoff, which resulted in a delayed lift-off and the ensuing failure to attain obstacle clearance.
- [NTSB CHI99LA256](https://openairdocs.org/ntsb/CHI99LA256.md): Piper PA-31-350 · Salina, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1999 · N97MA · Substantial damage
  > the inadequate preflight inspection by the pilot. Factors to the accident were fuel exhaustion and the operation of the aircraft with known deficiencies in equipment by the pilot.
- [NTSB ATL99LA114](https://openairdocs.org/ntsb/ATL99LA114.md): Maule M-5-200 · St.Simons, GA · Accident · No injuries · Limited investigation · Final report · Jul 26, 1999 · N5643T · Substantial damage
  > The inadequate installation of the magneto assembly by other maintenance personnel that in resulted the separation from the engine and the subsequent loss of engine power. A factor was the swampy terrain condition.
- [NTSB LAX99LA257](https://openairdocs.org/ntsb/LAX99LA257.md): Ewertz Starduster II · Winslow, AZ · Accident · No injuries · Limited investigation · Final report · Jul 24, 1999 · N102E · Substantial damage
  > the pilot's failure to attain and maintain a sufficient flying airspeed for the existing density altitude conditions, which resulted in an inadvertent stall/mush.
- [NTSB NYC99LA182](https://openairdocs.org/ntsb/NYC99LA182.md): Cessna 210 · Newton, NJ · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 1999 · N9712X · Substantial damage
  > The pilot's failure to secure the oil cap after adding oil; the flight instructor's failure to insure the preflight was completed properly; and oil on the windshield obstructing forward vision.
- [NTSB FTW99LA198](https://openairdocs.org/ntsb/FTW99LA198.md): Boeing A75L3 · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1999 · N59646 · Substantial damage
  > The loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW99FA199](https://openairdocs.org/ntsb/FTW99FA199.md): Smith, Ted Aerostar Aerostar 601P · Bethany, OK · Accident · 2 fatal · Field investigation · Final report · Jul 23, 1999 · N345LS · Destroyed
  > The pilot's failure to maintain the minimum controllable airspeed. A factor was the disconnected rubber interconnect boot, which resulted in the partial loss of left engine power.
- [NTSB DEN99LA126](https://openairdocs.org/ntsb/DEN99LA126.md): Piper PA28-160B · Pueblo, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1999 · N5595W · Substantial damage
  > Total loss of power during initial climb for undetermined reasons.
- [NTSB CHI99LA254](https://openairdocs.org/ntsb/CHI99LA254.md): Beech G18S · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Jul 23, 1999 · N621KE · Substantial damage
  > the premature gear retraction and proper runway alignment not maintained during takeoff by the pilot. An additional cause was the proper descent rate not maintained by the pilot. Contributing factors were the carburetor icing conditions
- [NTSB FTW99LA197](https://openairdocs.org/ntsb/FTW99LA197.md): Piper PA-25-235 · Fabens, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 1999 · N6736Z · Substantial damage
  > The pilot's inadvertent flight into adverse weather conditions. A factor was the windshear weather conditions.
- [NTSB FTW99LA196](https://openairdocs.org/ntsb/FTW99LA196.md): Air Tractor AT-502B · Marvel, AR · Accident · No injuries · Limited investigation · Final report · Jul 21, 1999 · N6073U · Substantial damage
  > The pilot's failure to attain the proper takeoff airspeed.
- [NTSB ATL99LA111](https://openairdocs.org/ntsb/ATL99LA111.md): Cessna 150M · Asheboro, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1999 · N704ET · Substantial damage
  > The pilot's failure to maintain flying speed that resulted in a stall and the subsequent collision with trees.
- [NTSB LAX99LA254](https://openairdocs.org/ntsb/LAX99LA254.md): Piper PA32R-300 · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · Jul 17, 1999 · N1692H · Substantial damage
  > The pilot's failure to attain and maintain an adequate airspeed for the prevailing density altitude. The pilot's failure to abort the takeoff is also causal.
- [NTSB FTW99TA194](https://openairdocs.org/ntsb/FTW99TA194.md): Bell 47G-3B-1 · Sour Lake, TX · Accident · No injuries · Final report · Jul 17, 1999 · N4002G · Substantial damage
  > The pilot's failure to adequately preflight the helicopter's fuel system resulting in the total loss of engine power as a result of water contamination. Factors were the incorrect filter installed on the fueling truck and the pilot's improper touchdown…
- [NTSB CHI99LA240](https://openairdocs.org/ntsb/CHI99LA240.md): Piper PA-28-180 · Butler, MO · Accident · No injuries · Limited investigation · Final report · Jul 17, 1999 · N9653J · Substantial damage
  > loss of engine power for undetermined reason, and the pilot's inability to maintain clearance from the fence during the forced landing. Factors relating to this accident were the rising terrain, the rough/uneven terrain, and the fence posts.
- [NTSB CHI99LA235](https://openairdocs.org/ntsb/CHI99LA235.md): Piper J-3C · Maple Lake, MN · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 1999 · N88593 · Substantial damage
  > The pilot's inadequate preflight planning that resulted in exceeding the maximum gross weight of the airplane and the subsequent inadvertent aerodynamic stall.
- [NTSB ATL99LA109](https://openairdocs.org/ntsb/ATL99LA109.md): Blackburn John D. Jr. Bushby M II · Daytona Beach, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 17, 1999 · N102JB · Substantial damage
  > The pilot's failure to securely reconnect the distributor coil wire during routine maintenance. Factors were the unsuitable terrain and trees.
- [NTSB FTW99LA189](https://openairdocs.org/ntsb/FTW99LA189.md): Piper PA-28-151 · Springtown, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1999 · N44677 · Substantial damage
  > The pilot's failure to maintain clearance with the trees during the initial takeoff climb. A factor was the high density altitude.
- [NTSB FTW99LA188](https://openairdocs.org/ntsb/FTW99LA188.md): Beech C35 · Jonesboro, AR · Accident · No injuries · Limited investigation · Final report · Jul 13, 1999 · N5BH · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.
- [NTSB CHI99LA234](https://openairdocs.org/ntsb/CHI99LA234.md): Grimm SEA Hawker · Princeton, MN · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1999 · N188AK · Destroyed
  > The erratic aileron control response for undetermined reasons. A factor was the tree.
- [NTSB SEA99LA115](https://openairdocs.org/ntsb/SEA99LA115.md): Grumman G-164B · Paul, ID · Accident · No injuries · Limited investigation · Final report · Jul 12, 1999 · N8005C · Substantial damage
  > The pilot's failure to attain adequate airspeed during takeoff and initial climb, resulting in stall/mush and inability of the aircraft to sustain level flight. Factors included high density altitude, a tailwind, an uphill takeoff surface, and crops in the…
- [NTSB CHI99LA228](https://openairdocs.org/ntsb/CHI99LA228.md): Mcmillan Zodiac CH 601 HD · Nauvoo, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1999 · N6781Z · Substantial damage
  > The pilot's failure to follow the airplane checklist to pin the canopy before departure, resulting in the opening of the canopy on take off and the subsequent aerodynamic stall and ground collision.
- [NTSB DEN99FA120](https://openairdocs.org/ntsb/DEN99FA120.md): Piper PA-22-150 · Roy, UT · Accident · 4 fatal · Field investigation · Final report · Jul 11, 1999 · N7729D · Destroyed
  > The pilot inadvertently allowing the aircraft to enter a stall during initial climb following takeoff. Factors were high density altitude and gross weight which exceeded the maximum.
- [NTSB ANC99LA091](https://openairdocs.org/ntsb/ANC99LA091.md): Cessna 337B · Seldovia, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1999 · N5499S · Substantial damage
  > The pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion.
- [NTSB LAX99LA248](https://openairdocs.org/ntsb/LAX99LA248.md): Piper PA-24-180 · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Jul 10, 1999 · N6597P · Substantial damage
  > The failure/separation of the crankshaft idler gear and the fatigue failure and subsequent separation of the crankshaft dowel pin due to the improper static and dynamic balance of the propeller by maintenance personnel.
- [NTSB CHI99LA255](https://openairdocs.org/ntsb/CHI99LA255.md): Buss Avid Flyer Mark IV · New London, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1999 · N392SB · Substantial damage
  > the inadequate preflight planning/preparation by the pilot. Factors to the accident were the powerplant seizing and the misjudged flare by the pilot.

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

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

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