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

## Cases, newest first

- [NTSB DFW06CA113](https://openairdocs.org/ntsb/DFW06CA113.md): Grumman-Schweizer G-164B · De Witt, AR · Accident · Minor injuries · Data collection · Final report · Apr 28, 2006 · N48717 · Destroyed
  > The pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the gusty winds.
- [NTSB ANC06LA049](https://openairdocs.org/ntsb/ANC06LA049.md): Cessna 172 · Tuluksak, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 2006 · N1453V · Substantial damage
  > The pilot's inadvertent stall/mush during takeoff-initial climb, which resulted in an in-flight collision with trees and terrain. Factors associated with the accident were the pilot's excessive loading of the airplane, his inadequate preflight planning, and a…
- [NTSB NYC06LA101](https://openairdocs.org/ntsb/NYC06LA101.md): Mooney M20J · Norwood, MA · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 2006 · N201BD · Substantial damage
  > Improper maintenance, which resulted in a fatigue fracture of the dual magneto mounting flange, and a subsequent loss of engine power.
- [NTSB LAX06CA146](https://openairdocs.org/ntsb/LAX06CA146.md): Grumman American AA-1C · San Diego, CA · Accident · Minor injuries · Data collection · Final report · Apr 23, 2006 · N9756U · Destroyed
  > The pilot's failure to maintain adequate airspeed, which resulted in a stall during initial climb. A contributing factor was his diverted attention.
- [NTSB MIA06CA096](https://openairdocs.org/ntsb/MIA06CA096.md): Eurocopter Deutschland EC135T2 · Bonifay, FL · Accident · Minor injuries · Data collection · Final report · Apr 21, 2006 · N914EF · Substantial damage
  > The pilot's failure to maintain main rotor rpm and proper descent rate resulting in a hard landing. A related factor in this accident was inadvertent encounter with clouds.
- [NTSB DFW06CA107](https://openairdocs.org/ntsb/DFW06CA107.md): Piper PA-22 · Tecumseh, OK · Accident · No injuries · Data collection · Final report · Apr 17, 2006 · N945A · Substantial damage
  > The pilot's failure to maintain clearance from the trees. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.
- [NTSB ANC06CA046](https://openairdocs.org/ntsb/ANC06CA046.md): Piper PA-18 · Talkeetna, AK · Accident · No injuries · Data collection · Final report · Apr 17, 2006 · N6195D · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during takeoff initial climb, which resulted in an in-flight collision with trees.
- [NTSB NYC06LA097](https://openairdocs.org/ntsb/NYC06LA097.md): Piper PA-28-140 · Avondale, PA · Accident · 1 fatal · Limited investigation · Final report · Apr 16, 2006 · N15507 · Destroyed
  > Separation of the propeller blade due to fatigue.
- [NTSB MIA06LA091](https://openairdocs.org/ntsb/MIA06LA091.md): Cessna 172R · Fort Myers, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 16, 2006 · N417FR · Substantial damage
  > The flight instructor's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was a malfunction of the elevator control for an undetermined reason, which required excessive forward pressure on the…
- [NTSB MIA06FA090](https://openairdocs.org/ntsb/MIA06FA090.md): Beech B-60 · Gainesville, FL · Accident · 3 fatal · Field investigation · Final report · Apr 16, 2006 · N999DE · Destroyed
  > The loss of control for an undetermined reason.
- [NTSB MIA06FA092](https://openairdocs.org/ntsb/MIA06FA092.md): Piper PA-32-260 · Dunnellon, FL · Accident · Serious injuries · Field investigation · Final report · Apr 14, 2006 · N592PR · Destroyed
  > The loss of engine power as a result of fuel starvation due to a contaminated carburetor fuel inlet screen.
- [NTSB DEN06LA063](https://openairdocs.org/ntsb/DEN06LA063.md): Rumble/Williams/Boomhower Starduster II · Junction City, KS · Accident · No injuries · Limited investigation · Final report · Apr 14, 2006 · N7JC · Substantial damage
  > Vapor lock which resulted in total engine failure and the pilot's abrupt brake application on touchdown. Factors contributing to the accident were the improper design of the fuel system resulting in the misrouting of the fuel lines close to the exhaust pipes,…
- [NTSB DFW06FA102](https://openairdocs.org/ntsb/DFW06FA102.md): Robinson R44 II · Fredericksburg, TX · Accident · 2 fatal · Field investigation · Final report · Apr 13, 2006 · N123CK · Destroyed
  > The pilot's failure to maintain clearance with the power lines. Contributing factors were the dusk light condition and the pilot's non-compliance with standard taxi and takeoff procedures.
- [NTSB NYC06LA092](https://openairdocs.org/ntsb/NYC06LA092.md): Michaud KR2S · North Andover, MA · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 2006 · N24065 · Substantial damage
  > A partial loss of engine power for undetermined reasons, during the initial climb, which resulted in a forced landing into trees.
- [NTSB NYC06LA089](https://openairdocs.org/ntsb/NYC06LA089.md): Piper PA-28RT-201 · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Apr 9, 2006 · N901AV · Substantial damage
  > A fatigue failure of the number 3 cylinder attachment studs, which resulted in a loss of engine power and subsequent forced landing.
- [NTSB SEA06CA072](https://openairdocs.org/ntsb/SEA06CA072.md): Robinson R22 Beta · Tooele, UT · Accident · Minor injuries · Data collection · Final report · Apr 8, 2006 · N921U · Substantial damage
  > The pilot's failure to maintain control of the helicopter during the takeoff initial climb, which resulted in an in-flight collision with the ground. A contributing factor was the gusty wind condition.
- [NTSB DFW06CA096](https://openairdocs.org/ntsb/DFW06CA096.md): Piper PA-28-140 · Lakeview, AR · Accident · Minor injuries · Data collection · Final report · Apr 7, 2006 · N4316T · Substantial damage
  > The pilot's inadequate weather evaluation and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.
- [NTSB DEN06IA056](https://openairdocs.org/ntsb/DEN06IA056.md): Swearingen SA226TC · Denver, CO · Incident · No injuries · Incident investigation · Final report · Apr 5, 2006 · N770S · No damage
  > the failure of the elevator down cable due to an improperly routed cable by unknown maintenance personnel. A contributing factor was the improper inspection of the elevator cable by the operator's maintenance personnel.
- [NTSB ATL06LA060](https://openairdocs.org/ntsb/ATL06LA060.md): Just Highlander · Walhalla, SC · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2006 · N9085N · Substantial damage
  > The pilot and owner/builders failure to determine the reason for partial loss of engine power resulting in loss of engine power due to fuel system contamination on a subsequent flight.
- [NTSB ANC06CA039](https://openairdocs.org/ntsb/ANC06CA039.md): Grumman-Schweizer G-164A · Dixon, CA · Accident · No injuries · Data collection · Final report · Mar 30, 2006 · N5397 · Substantial damage
  > The pilot's failure to attain altitude/clearance during takeoff/initial climb, which resulted in an in-flight collision with terrain. Factors associated with the accident were the pilot's inadequate evaluation of the weather, and unfavorable winds.
- [NTSB CHI06CA102](https://openairdocs.org/ntsb/CHI06CA102.md): Martin Rans S-7 Courier · Ray, MI · Accident · No injuries · Data collection · Final report · Mar 29, 2006 · N22220 · Destroyed
  > The loss of engine power and fire for undetermined reasons.
- [NTSB MIA06LA066](https://openairdocs.org/ntsb/MIA06LA066.md): Loehle P5151 · Lakeland, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 2006 · N151RG · Substantial damage
  > The pilot's delay in initiating landing flare during a forced landing following a total loss of engine power. A factor was the lack of correct venting of the carburetor float bowl.
- [NTSB MIA06LA064](https://openairdocs.org/ntsb/MIA06LA064.md): Cessna 152 · Sanford, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 2006 · N25566 · Substantial damage
  > A loss of engine power during takeoff-initial climb due to contamination (debris) lodged in the carburetor jet, which resulted in a forced landing and collision with trees.
- [NTSB LAX06FA129](https://openairdocs.org/ntsb/LAX06FA129.md): Beech A36 · Santa Monica, CA · Accident · 2 fatal · Field investigation · Final report · Mar 13, 2006 · N16JR · Substantial damage
  > The failure of an aviation maintenance technician to properly torque and cotter pin the number 2 connecting rod bolts at their attach point to the crankshaft, which resulted in the separation of the connecting rod in flight, and complete power loss.
- [NTSB SEA06LA064](https://openairdocs.org/ntsb/SEA06LA064.md): Sessi Midget Mustang SK-1 · Everett, WA · Accident · No injuries · Limited investigation · Final report · Mar 12, 2006 · N202 · Substantial damage
  > The pilot did not abort the takeoff and subsequently did not maintain aircraft control during the initial takeoff climb. The installation of the wrong propeller assembly and inadequate maintenance were factors.
- [NTSB SEA06CA062](https://openairdocs.org/ntsb/SEA06CA062.md): Piper PA-18A · Shady Cove, OR · Accident · No injuries · Data collection · Final report · Mar 4, 2006 · N1984A · Substantial damage
  > The pilot's improper installation of the control stick during maintenance, which resulted in the control stick becoming disconnected during the initial takeoff climb, resulting in a loss of control and in-flight collision with the ground.
- [NTSB DFW06FA076](https://openairdocs.org/ntsb/DFW06FA076.md): Cessna 182N · Georgetown, TX · Accident · 2 fatal · Field investigation · Final report · Mar 4, 2006 · XB-BID · Destroyed
  > The pilot's failure to maintain airspeed during takeoff which resulted in a loss of control.
- [NTSB ANC06LA021](https://openairdocs.org/ntsb/ANC06LA021.md): Piper PA-32R-300 · Winslow, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 2006 · N8322C · Substantial damage
  > The presence of a foreign material/substance in the fuel system, which partially blocked the fuel flow divider, and resulted in a loss of engine power during takeoff-initial climb, and an emergency landing. A factor associated with the accident was unsuitable…
- [NTSB DEN06LA045](https://openairdocs.org/ntsb/DEN06LA045.md): Piper PA-32RT-300T · Manhattan, KS · Accident · No injuries · Limited investigation · Final report · Mar 1, 2006 · N7824T · Substantial damage
  > A loss of engine power due to the intermittent grounding of the left magneto "P" lead, causing the fuel controller to search and the engine to surge then lose power, and the pilot's failure to attain proper runway alignment. Contributing factors were the…
- [NTSB CHI06LA081](https://openairdocs.org/ntsb/CHI06LA081.md): Piper PA-28-161 · Schaumburg, IL · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 2006 · N4328D · Substantial damage
  > The loss of engine power for an undetermined reason during takeoff-initial climb.
- [NTSB NYC06LA070](https://openairdocs.org/ntsb/NYC06LA070.md): Champion 7FC · Dover-Foxcroft, ME · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 2006 · N7694E · Substantial damage
  > The pilot's inadequate preflight inspection, which failed to detect ice in the fuel system, resulting in a loss of engine power during takeoff-initial climb, and an in-flight collision with trees.
- [NTSB DEN06LA039](https://openairdocs.org/ntsb/DEN06LA039.md): Spane RV-4 · Wichita, KS · Accident · 1 fatal · Limited investigation · Final report · Feb 17, 2006 · N437T · Substantial damage
  > The pilot's inadequate preparation prior to takeoff, and his failure to maintain control of the airplane resulting in a stall and subsequent crash. Factors contributing to the accident were the unsecured canopy latch, the pilot's diverted attention, and the…
- [NTSB SEA06LA053](https://openairdocs.org/ntsb/SEA06LA053.md): Cessna 150 · White Salmon, WA · Accident · Serious injuries · Limited investigation · Final report · Feb 16, 2006 · N5611E · Destroyed
  > The pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. Contributing factors were the inadequate preflight by the pilot, and the airplane's fuel contamination by water.
- [NTSB LAX06CA115](https://openairdocs.org/ntsb/LAX06CA115.md): Cessna 172M · Murrieta, CA · Accident · No injuries · Data collection · Final report · Feb 14, 2006 · N80859 · Substantial damage
  > a partial loss of engine power resulting from the student pilot's mismanagement of the mixture control.
- [NTSB SEA06CA051](https://openairdocs.org/ntsb/SEA06CA051.md): Ercoupe 415-C · Arlington, WA · Accident · No injuries · Data collection · Final report · Feb 12, 2006 · N93788 · Substantial damage
  > The pilot's excessive descent rate and his delay in taking action to reduce the descent rate which resulted in an in-flight collision with the runway during an emergency landing. Contributing factors were the total loss of engine oil pressure and the pilot's…
- [NTSB LAX06LA109](https://openairdocs.org/ntsb/LAX06LA109.md): SIAI-Marchetti S.205/22R · Phoenix, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 2006 · N981WA · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB SEA06LA049](https://openairdocs.org/ntsb/SEA06LA049.md): Cessna 172N · Snohomish, WA · Accident · No injuries · Limited investigation · Final report · Jan 31, 2006 · N492SF · Substantial damage
  > Carburetor heat was not used during the initial climb in probable serious carburetor icing conditions during cruise power. Carburetor icing conditions and wet terrain were factors.
- [NTSB NYC06LA055](https://openairdocs.org/ntsb/NYC06LA055.md): Renquist Starduster SA300 · Churchville, MD · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 2006 · N1923S · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall.
- [NTSB MIA06LA044](https://openairdocs.org/ntsb/MIA06LA044.md): MBB BO-105S · Ponce, PR · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 2006 · N495LF · Substantial damage
  > A loose B-nut on the PC line connecting the power turbine governor (PTGOV) to the fuel control unit (FCU) that created a leak and caused the engine to roll back to an idle condition, causing a low hydraulic system pressure and subsequent control lock. A…
- [NTSB LAX06CA088](https://openairdocs.org/ntsb/LAX06CA088.md): Huntington KIS · Camarillo, CA · Accident · Serious injuries · Data collection · Final report · Jan 10, 2006 · N506RJ · Substantial damage
  > a partial loss of engine power due to the engine's electronic control system reverting to a designed reduced power mode of operation.
- [NTSB LAX06FA082](https://openairdocs.org/ntsb/LAX06FA082.md): Piper PA-28-235 · Mammoth Lakes, CA · Accident · 2 fatal · Field investigation · Final report · Jan 8, 2006 · N9124W · Destroyed
  > the pilot's failure to maintain an adequate airspeed resulting in a stall/spin.
- [NTSB DEN06CA031](https://openairdocs.org/ntsb/DEN06CA031.md): Culver Cadet LCA · Alamogordo, NM · Accident · Minor injuries · Data collection · Final report · Jan 2, 2006 · N37814 · Substantial damage
  > the pilot's failure to maintain aircraft control during the departure climb. Contributing factors included the gusty winds and the downdraft.
- [NTSB LAX06FA075](https://openairdocs.org/ntsb/LAX06FA075.md): Beech V35A · Valley Center, CA · Accident · 3 fatal · Field investigation · Final report · Dec 31, 2005 · N7944R · Destroyed
  > the pilot's failure to maintain an adequate airspeed margin following a loss of engine power in the takeoff initial climb, resulting in a stall/spin. While the laboratory tests indicated the presence of an unknown biological contaminant in the fuel manifold…
- [NTSB MIA06LA037](https://openairdocs.org/ntsb/MIA06LA037.md): Cessna P206C · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · Dec 29, 2005 · N8640Z · Substantial damage
  > The loss of engine power during takeoff-initial climb due to fuel starvation, which resulted in a hard, off-airport forced landing.
- [NTSB NYC06CA047](https://openairdocs.org/ntsb/NYC06CA047.md): Cessna 180H · Greenville, NH · Accident · Minor injuries · Data collection · Final report · Dec 28, 2005 · N2869U · Substantial damage
  > The pilot's inadequate pre-flight inspection, which resulted in water-contaminated fuel in the engine and subsequent engine failure.
- [NTSB DFW06CA043](https://openairdocs.org/ntsb/DFW06CA043.md): Mooney M20J · San Antonio, TX · Accident · No injuries · Data collection · Final report · Dec 25, 2005 · N40FJ · Substantial damage
  > The pilot's failure to maintain sufficient airspeed on takeoff, which resulted in an inadvertent stall and subsequent hard landing.
- [NTSB DFW06CA042](https://openairdocs.org/ntsb/DFW06CA042.md): CASA 1.131E · McKinney, TX · Accident · No injuries · Data collection · Final report · Dec 25, 2005 · N131AK · Destroyed
  > The pilot's failure to maintain directional control and airspeed, which resulted in an inadvertent stall. A contributing factor was the pilot's helmet and goggles shifting while maneuvering.
- [NTSB SEA06LA031](https://openairdocs.org/ntsb/SEA06LA031.md): Cessna 208B · Portland, OR · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 2005 · N753FE · Substantial damage
  > A partial loss of engine power for an undetermined reason during the initial takeoff climb resulting in an in-flight collision with objects.
- [NTSB ANC06LA014](https://openairdocs.org/ntsb/ANC06LA014.md): Taylorcraft F-19 · Chenga Bay, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 2005 · N3615T · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance during takeoff initial climb, which resulted in an in-flight collision with trees, and subsequent collision with the ground.
- [NTSB NYC06IA044](https://openairdocs.org/ntsb/NYC06IA044.md): Boeing 717-200 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Dec 21, 2005 · N924ME · Minor damage
  > Water dilution of the grease, which resulted in the failure of the number 4 wheel bearing.

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

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

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