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

## Cases, newest first

- [NTSB ATL98TA054](https://openairdocs.org/ntsb/ATL98TA054.md): Cessna 172 · Arcadia, FL · Accident · No injuries · Final report · Mar 13, 1998 · N54634 · Substantial damage
  > The pilot's inadequate pre-flight and in-flight planning, which resulted in fuel exhaustion and the loss of power. Trees and rough/uneven terrain are contributing factors.
- [NTSB NYC98LA076](https://openairdocs.org/ntsb/NYC98LA076.md): Enstrom F-28A · Blue Ash, OH · Accident · No injuries · Limited investigation · Final report · Mar 12, 1998 · N4884 · Substantial damage
  > The failure of a cooling fan blade and the pilot's improper flare.
- [NTSB LAX98LA109](https://openairdocs.org/ntsb/LAX98LA109.md): Cessna 182 · Santa Rosa, CA · Accident · No injuries · Limited investigation · Final report · Mar 9, 1998 · N5704B · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB IAD98LA031](https://openairdocs.org/ntsb/IAD98LA031.md): Cessna 182A · Fogelsville, PA · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 1998 · N9977B · Substantial damage
  > The pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).
- [NTSB MIA98LA094](https://openairdocs.org/ntsb/MIA98LA094.md): Nickelson Martin Coot · New Port Richey, FL · Accident · 1 fatal · Limited investigation · Final report · Mar 6, 1998 · N84MN · Destroyed
  > failure of the pilot to obtain/maintain adequate airspeed, while maneuvering after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain.
- [NTSB NYC98LA074](https://openairdocs.org/ntsb/NYC98LA074.md): Beech A36 · Lynchburgh, VA · Accident · No injuries · Limited investigation · Final report · Mar 5, 1998 · N1559X · Substantial damage
  > Failure of the number six connecting rod bolt due to improper maintenance.
- [NTSB LAX98LA102](https://openairdocs.org/ntsb/LAX98LA102.md): Lawrence Kitfox · Cottonwood, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1998 · N99TL · Substantial damage
  > The pilot's failure to maintain directional control and attain the proper airspeed for takeoff. A factor in the accident was his lack of recent experience in the make and model of airplane.
- [NTSB LAX98LA101](https://openairdocs.org/ntsb/LAX98LA101.md): Cessna 310C · Lancaster, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 1998 · N608G · Substantial damage
  > The pilot's improper use of the mixture controls.
- [NTSB IAD98FA032](https://openairdocs.org/ntsb/IAD98FA032.md): Cessna 172P · Langley Afb, VA · Accident · 2 fatal · Field investigation · Final report · Mar 1, 1998 · N62082 · Destroyed
  > The pilot's inadvertent VFR flight into IMC conditions, and the subsequent loss of aircraft control due to spatial disorientation. A factor in the accident was the low ceiling.
- [NTSB ATL98LA049](https://openairdocs.org/ntsb/ATL98LA049.md): Tankersley Europa MONO-WHEEL · Fernandina Bch, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 21, 1998 · N6173K · Substantial damage
  > a partial loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed.
- [NTSB MIA98LA082](https://openairdocs.org/ntsb/MIA98LA082.md): Piper PA-28-140 · Graniteville, SC · Accident · No injuries · Limited investigation · Final report · Feb 20, 1998 · N3965K · Substantial damage
  > failure of the number three exhaust valve, which resulted in loss of engine power and a forced landing. Related factors were: the obstructions (earthen embankment and fence) in the emergency (forced) landing area.
- [NTSB ATL98FA047](https://openairdocs.org/ntsb/ATL98FA047.md): Schweizer SA 2-37A · Green Cove Sprg, FL · Accident · 2 fatal · Field investigation · Final report · Feb 19, 1998 · N61474 · Destroyed
  > loss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while maneuvering the airplane for a forced landing, which resulted in an inadvertent stall, uncontrolled descent, and collision with a house boat…
- [NTSB LAX98LA090](https://openairdocs.org/ntsb/LAX98LA090.md): Air Tractor AT-301 · Wasco, CA · Accident · No injuries · Limited investigation · Final report · Feb 18, 1998 · N3656C · Substantial damage
  > The pilot overboosting the engine on takeoff which resulted in a cracked cylinder and subsequent loss of engine power.
- [NTSB NYC98LA122](https://openairdocs.org/ntsb/NYC98LA122.md): Goins Sonerai II LTS · Suffolk, VA · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 1998 · N426AG · Substantial damage
  > The pilot's failure to maintain directional control during the initial takeoff climb. Factors related to the accident were habit interference, the pilot's lack of experience in the make and model, and the trees.
- [NTSB FTW98MA126](https://openairdocs.org/ntsb/FTW98MA126.md): Embraer 145-ER · Beaumont, TX · Accident · Serious injuries · Major investigation · Final report · Feb 11, 1998 · N14931 · Substantial damage
  > The first officer's improper use of the rudder when given a simulated engine failure on takeoff and the pilot-in-command's delayed remedial action which resulted in a loss of control. A factor was the first officer's lack of experience in the regional jet…
- [NTSB IAD98LA026](https://openairdocs.org/ntsb/IAD98LA026.md): Mooney M20J · Davis, WV · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 1998 · N4120H · Substantial damage
  > A loss of power due to blockage of the fuel screen and one of the four fuel injector nozzles. A contributing factor was snow covered terrain.
- [NTSB ANC98FA019](https://openairdocs.org/ntsb/ANC98FA019.md): Cessna 207 · Homer, AK · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1998 · N91029 · Destroyed
  > A fatigue failure, and partial separation of the number 6 engine cylinder head assembly, the operator's inadequate progressive inspection performed by company maintenance personnel, and the pilot's inadvertent stall during a maneuvering turn toward an…
- [NTSB CHI98LA091](https://openairdocs.org/ntsb/CHI98LA091.md): Cessna 210G · Springfield, IL · Accident · No injuries · Limited investigation · Final report · Feb 4, 1998 · N5842F · Substantial damage
  > The failure of left main landing gear saddle resulting in the pilot's inability to extend the left gear. A factor was maintenance personnel's failure to comply with the related airworthiness directive.
- [NTSB NYC98FA063](https://openairdocs.org/ntsb/NYC98FA063.md): Cessna 172K · Boxborough, MA · Accident · 1 fatal · Field investigation · Final report · Feb 2, 1998 · N79588 · Destroyed
  > The failure of the pilot to remove the frost on the wings before departure, which resulted in a stall
- [NTSB CHI98LA089](https://openairdocs.org/ntsb/CHI98LA089.md): Chinese A/F Aero Ind Dev CTR PL-1B · Sugar Grove, IL · Accident · No injuries · Limited investigation · Final report · Feb 1, 1998 · N830JT · Substantial damage
  > inadequate design of the carburetor heat system by the manufacturer, and subsequent carburetor ice, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: carburetor icing (weather) conditions, and obstructions and…
- [NTSB MIA98LA061](https://openairdocs.org/ntsb/MIA98LA061.md): Air Tractor AT-602 · Wrightsville, GA · Accident · Serious injuries · Limited investigation · Final report · Jan 29, 1998 · N50929 · Substantial damage
  > The failure of the pilot to maintain airspeed (Vs) resulting in the inadvertent stall during the initial climb.
- [NTSB ATL98LA041](https://openairdocs.org/ntsb/ATL98LA041.md): Cessna 177 · New Port Richey, FL · Accident · No injuries · Limited investigation · Final report · Jan 27, 1998 · N30192 · Substantial damage
  > partial loss of engine power for undetermined reasons, which led to a forced landing and collision with trees.
- [NTSB MIA98LA078](https://openairdocs.org/ntsb/MIA98LA078.md): Lake LA-4-200 · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Jan 24, 1998 · N2994P · Substantial damage
  > inadequate clearance and fretting wear of the fitting/beam attachment to the angle/top beam, due to inadequate design, which resulted in fatigue and subsequent failure of the fitting/beam attachment ear.
- [NTSB FTW98LA105](https://openairdocs.org/ntsb/FTW98LA105.md): Cessna 140A · Justin, TX · Accident · No injuries · Limited investigation · Final report · Jan 24, 1998 · N377V · Substantial damage
  > the pilot's improper planning/decision and failure to ensure that the airplane would be able to remain clear of the fence during takeoff. Factors relating to the accident were: the wet/soft/short runway (and terrain) conditions.
- [NTSB ATL98LA035](https://openairdocs.org/ntsb/ATL98LA035.md): Piper J5-A · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 20, 1998 · N38645 · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB NYC98LA061](https://openairdocs.org/ntsb/NYC98LA061.md): Cessna 150 · Lake Placid, NY · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 1998 · N150JH · Destroyed
  > was the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.
- [NTSB IAD98LA022](https://openairdocs.org/ntsb/IAD98LA022.md): Cessna 182M · Mount Pleasant, PA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1998 · N71763 · Destroyed
  > The pilot's failure to initiate a go-around, and his failure to maintain adequate airspeed.
- [NTSB FTW98FA093](https://openairdocs.org/ntsb/FTW98FA093.md): Bell 222UT · Sandy, UT · Accident · 4 fatal · Field investigation · Final report · Jan 12, 1998 · N222UH · Destroyed
  > flight by the pilot into known adverse weather conditions, and his failure (or inability) to maintain sufficient clearance or altitude from mountainous terrain. Related factors were: darkness, heavy snow, high winds, the pilot's perception of pressure that…
- [NTSB CHI98LA073](https://openairdocs.org/ntsb/CHI98LA073.md): Cessna 402B · Watertown, SD · Accident · 1 fatal · Limited investigation · Final report · Dec 31, 1997 · N5087Q · Destroyed
  > the pilot's failure to perform an aircraft preflight and to remove the ice which had accumulated on the airframe. A factor involved in the accident was the icing weather conditions which existed and the ice which accumulated on the airplane.
- [NTSB CHI98FA074](https://openairdocs.org/ntsb/CHI98FA074.md): Mitsubishi MU-2B-30 · Wayne, IL · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1997 · N999WB · Destroyed
  > the pilot in command failed to maintain control of the aircraft. A factor was the lack of experience of the pilot and copilot in the type and model of aircraft. An additional factor was the pilot did not follow the proper procedure when the flaps were raised…
- [NTSB NYC98LA055](https://openairdocs.org/ntsb/NYC98LA055.md): Cessna 172 · Mansfield, MA · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 1997 · N9604H · Destroyed
  > The pilot's failure to remove snow and ice from the aircraft prior to takeoff resulting in degraded climb performance and a subsequent stall/mush condition.
- [NTSB CHI98LA067](https://openairdocs.org/ntsb/CHI98LA067.md): Beech 35-B33 · Troy, MI · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1997 · N512WM · Substantial damage
  > loss of engine power for undetermined reason(s). Factors associated with the accident were: the lack of a suitable forced landing site, and the embankment (dirt bank), which the airplane contacted.
- [NTSB MIA98FA045](https://openairdocs.org/ntsb/MIA98FA045.md): Cessna 172M · Raleigh-Durham, NC · Accident · 1 fatal · Field investigation · Final report · Dec 25, 1997 · N12172 · Destroyed
  > Was loss of control of the airplane on initial climb after entering instrument flight conditions resulting in a turn opposite in direction from that given by ATC, and eventual collision with terrain.
- [NTSB ATL98LA029](https://openairdocs.org/ntsb/ATL98LA029.md): Lutz EAA Biplane P-2 · Wellington, FL · Accident · 1 fatal · Limited investigation · Final report · Dec 22, 1997 · N913AM · Substantial damage
  > failure of the pilot to ensure the fuel selector was properly positioned to a tank with adequate fuel before takeoff, which resulted in fuel starvation and loss of engine power; failure of the pilot to accomplish the emergency procedure (restart the engine…
- [NTSB LAX98LA058](https://openairdocs.org/ntsb/LAX98LA058.md): Bellanca 8KCAB · Truckee, CA · Accident · No injuries · Limited investigation · Final report · Dec 20, 1997 · N5058L · Substantial damage
  > internal mechanical failure of the engine due to a progressive failure of the No. 3 connecting rod assembly. A contributing factor was the snow pack which covered the only accessible emergency landing area.
- [NTSB IAD98FA018](https://openairdocs.org/ntsb/IAD98FA018.md): Beech A 36 · Findlay, OH · Accident · 3 fatal · Field investigation · Final report · Dec 20, 1997 · N5050G · Destroyed
  > The pilot-in-command's failure to obtain/maintain clearance with objects during the initial climb. Contributing factors were trees, fog, and the flying pilot's failure to maintain runway heading during the initial climb.
- [NTSB ATL98LA026](https://openairdocs.org/ntsb/ATL98LA026.md): Piper PA-22-108 · Jacksonville, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 20, 1997 · N5258Z · Substantial damage
  > the pilot's improper preflight inspection by failing to ensure the fuel selector was properly positioned, which led to fuel starvation, loss of engine power, and a forced landing on rough/uneven terrain. The lack of suitable terrain for a forced landing was a…
- [NTSB ATL98LA027](https://openairdocs.org/ntsb/ATL98LA027.md): American AA-1 · Monticello, FL · Accident · No injuries · Limited investigation · Final report · Dec 19, 1997 · N5789L · Destroyed
  > the pilot's inadequate preflight planning/preparation, and failure to ensure that the airplane would be able to clear trees during takeoff. Related factors were: the high/wet vegetation on the grass runway, and the proximity of trees to the runway.
- [NTSB NYC98LA059](https://openairdocs.org/ntsb/NYC98LA059.md): Piper PA-23-250 · Perkasie, PA · Accident · No injuries · Limited investigation · Final report · Dec 18, 1997 · N6962Y · Substantial damage
  > The flight instructor failure to maintain directional control, which resulted in an off runway landing, after the left engine was reported to have lost power.
- [NTSB NYC98LA044](https://openairdocs.org/ntsb/NYC98LA044.md): Consolidated-Vultee BT-13A · Oxford, CT · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1997 · N67868 · Substantial damage
  > The loss of power for undetermined reasons.
- [NTSB IAD98LA017](https://openairdocs.org/ntsb/IAD98LA017.md): Bellanca 17-30A · Steubenville, OH · Accident · Serious injuries · Limited investigation · Final report · Dec 18, 1997 · N28122 · Destroyed
  > Collision with deer on runway during initial takeoff and climb.
- [NTSB CHI98LA071](https://openairdocs.org/ntsb/CHI98LA071.md): Piper J-3 · Valley Center, KS · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 1997 · N32737 · Substantial damage
  > the pilot's excessive pull up after lift-off and failure to maintain adequate airspeed during the initial climb, which resulted in a stall and collision with wooded terrain.
- [NTSB CHI98FA068](https://openairdocs.org/ntsb/CHI98FA068.md): Beech C35 · Evansville, IN · Accident · 1 fatal · Field investigation · Final report · Dec 17, 1997 · N782D · Substantial damage
  > Improper maintenance by the use of a loose fitting unapproved fuel line, which resulted in fuel starvation and the loss of engine power.
- [NTSB FTW98FA068](https://openairdocs.org/ntsb/FTW98FA068.md): Bell 407 · Littleton, CO · Accident · 4 fatal · Field investigation · Final report · Dec 15, 1997 · N771AL · Destroyed
  > The pilot's inability to maintain adequate visual lookout due to the lighting conditions and his failure to follow company procedures for departure from a landing zone. Factors were dark night conditions, bright lights in the landing zone which prevented…
- [NTSB NYC98LA042](https://openairdocs.org/ntsb/NYC98LA042.md): Cessna 182P · Chatham, MA · Accident · No injuries · Limited investigation · Final report · Dec 11, 1997 · N20710 · Substantial damage
  > loss of engine power for undetermined reason(s). The tail wind component and an encounter with a ditch were related factors.
- [NTSB CHI98LA062](https://openairdocs.org/ntsb/CHI98LA062.md): Piper PA-28-140 · Dawson, ND · Accident · No injuries · Limited investigation · Final report · Dec 9, 1997 · N55259 · Substantial damage
  > The pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.
- [NTSB ATL98LA019](https://openairdocs.org/ntsb/ATL98LA019.md): Siggi's Airplane Works D-4 Fascination · Leesburg, FL · Accident · 2 fatal · Limited investigation · Final report · Dec 6, 1997 · DMSMV · Destroyed
  > structural failure of the right wing, during the initial climb after takeoff, which resulted in an uncontrolled descent to the ground.
- [NTSB CHI98LA054](https://openairdocs.org/ntsb/CHI98LA054.md): Piper PA-34-200T · Lee'S Summit, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 1997 · N8189P · Destroyed
  > the pilot's inadequate remedial action concerning the loss of engine power, after inadvertently switching off the magnetos. Factors relating to the accident were: the broken springs for magneto cover guard; excessive drag from the extended landing gear and…
- [NTSB NYC98FA034](https://openairdocs.org/ntsb/NYC98FA034.md): Beech BE-S35 · Chatham, MA · Accident · 2 fatal · Field investigation · Final report · Nov 27, 1997 · N5667K · Destroyed
  > The pilot's failure to maintain adequate airspeed during initial climb which resulted in an inadvertent stall and subsequent impact into trees. Related factors were high wind and turbulence.
- [NTSB LAX98FA048](https://openairdocs.org/ntsb/LAX98FA048.md): Piper PA-23-250 · Carson City, NV · Accident · 4 fatal · Field investigation · Final report · Nov 27, 1997 · N6933Y · Destroyed
  > The failure of the pilot to maintain airspeed after being distracted by the nose baggage door opening in-flight resulting in a stall/spin. Factors contributing to the accident were the pilot's inadequate preflight inspection and lack of experience in the type…

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

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

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