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

## Cases, newest first

- [NTSB NYC98LA118](https://openairdocs.org/ntsb/NYC98LA118.md): Morrison Rans S-12 · Gum Spring, VA · Accident · No injuries · Limited investigation · Final report · May 16, 1998 · N91337 · Substantial damage
  > A loose/partially disconnected engine intake fuel line which resulted in a loss of engine power, and the pilot's delayed (late) flare prior to touchdown.
- [NTSB IAD98LA060](https://openairdocs.org/ntsb/IAD98LA060.md): Piper PA-28-151 · Princeton, NJ · Accident · Minor injuries · Limited investigation · Final report · May 16, 1998 · N56969 · Substantial damage
  > A stuck carburetor float which restricted fuel flow to the engine that resulted in a loss of engine power.
- [NTSB FTW98FA216](https://openairdocs.org/ntsb/FTW98FA216.md): Beagle B-206 · Vernon, TX · Accident · 3 fatal · Field investigation · Final report · May 16, 1998 · N1885S · Destroyed
  > The pilot's failure to maintain the airplane's minimum controllable airspeed following a loss of left engine power after takeoff, which resulted in a loss of control. Contributing factors were the fractured exhaust valve guide on the left engine's # 2…
- [NTSB NYC98LA109](https://openairdocs.org/ntsb/NYC98LA109.md): Deberry Marquart MA-5 · Westminster, MD · Accident · Minor injuries · Limited investigation · Final report · May 15, 1998 · N83MC · Destroyed
  > Failure of a fuel line fitting which led to an engine failure and fire. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX98LA159](https://openairdocs.org/ntsb/LAX98LA159.md): Bell 206B · Temecula, CA · Accident · No injuries · Limited investigation · Final report · May 15, 1998 · N90215 · Destroyed
  > A loss of engine power due to a deteriorated compressor air seal which resulted in the fracture and separation of several stator vanes. Deterioration was not detected as a result of an inadequate maintenance inspection frequency.
- [NTSB ATL98FA076](https://openairdocs.org/ntsb/ATL98FA076.md): Beech BE-45-T-34B · Montgomery, AL · Accident · Serious injuries · Field investigation · Final report · May 14, 1998 · N9280Z · Destroyed
  > The installation of an incorrect engine nose seal that subsequently dislodged from the normally installed position, and resulted in the loss of engine power. A factor was the loss of engine oil.
- [NTSB MIA98LA160](https://openairdocs.org/ntsb/MIA98LA160.md): M2 Sport 1000 · Semmes, AL · Accident · 2 fatal · Limited investigation · Final report · May 13, 1998 · UNREG · Destroyed
  > The pilot's failure to maintain control of the aircraft after an encounter with turbulence during initial climb out. A related factor was the turbulence.
- [NTSB CHI98LA146](https://openairdocs.org/ntsb/CHI98LA146.md): Dangremond Challenger II · Wayland, MI · Accident · No injuries · Limited investigation · Final report · May 12, 1998 · N199DD · Destroyed
  > the pilot's improper installation of the right wing forward strut attachment bolt.
- [NTSB CHI98LA147](https://openairdocs.org/ntsb/CHI98LA147.md): Cessna 172N · Hannibal, MO · Accident · Minor injuries · Limited investigation · Final report · May 11, 1998 · N733HY · Substantial damage
  > a loss of engine power due to undetermined reasons. A factor was the rough field in which the forced landing was made.
- [NTSB FTW98LA213](https://openairdocs.org/ntsb/FTW98LA213.md): Beech A-36 · Ruidoso, NM · Accident · No injuries · Limited investigation · Final report · May 10, 1998 · N6150X · Substantial damage
  > Inadvertent post departure stall. A factor was high gusty winds.
- [NTSB FTW98LA212](https://openairdocs.org/ntsb/FTW98LA212.md): Cessna 172P · Georgetown, TX · Accident · No injuries · Limited investigation · Final report · May 10, 1998 · N99570 · Substantial damage
  > inadequate supervision by the flight instructor (CFI), by failing to ensure that the student obtained and/or maintained sufficient airspeed, which led to an inadvertent stall and collision with the terrain.
- [NTSB FTW98LA210](https://openairdocs.org/ntsb/FTW98LA210.md): Cessna 152 · Stillwater, OK · Accident · Minor injuries · Limited investigation · Final report · May 10, 1998 · N67326 · Substantial damage
  > The loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain available for the forced landing.
- [NTSB SEA98LA073](https://openairdocs.org/ntsb/SEA98LA073.md): Aero Commander 500-A · Billings, MT · Accident · No injuries · Limited investigation · Final report · May 9, 1998 · N9382R · Substantial damage
  > Failure of the main landing gear strut outer-body to inner-body needle bearing from the lack of lubrication and the development of corrosion. An inadequate manufacturer's inspection program was a factor.
- [NTSB CHI98LA140](https://openairdocs.org/ntsb/CHI98LA140.md): Piper PA-38-112 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · May 5, 1998 · N24435 · Substantial damage
  > The fatigue failure of the crankshaft which resulted from a spun bearing and the low altitude at which the loss of engine power occurred. A factor in the accident was the embankment on which the airplane was landed.
- [NTSB NYC98IA106](https://openairdocs.org/ntsb/NYC98IA106.md): Beech 1900D · Syracuse, NY · Incident · No injuries · Incident investigation · Final report · May 4, 1998 · N832CA · Minor damage
  > Improper maintenance which resulted in a cross threaded\ mistapped counterweight bolt hole, and the subsequent failure of the propeller counterweight clamp assembly. Also causal was the inadequate inspection of the counterweight clamp threads by maintenance…
- [NTSB ATL98LA071](https://openairdocs.org/ntsb/ATL98LA071.md): Bellanca 7-GCBC · Sebring, FL · Accident · Serious injuries · Limited investigation · Final report · May 3, 1998 · N4ME · Destroyed
  > The pilot's improper handling of the airplane which led to an inadvertent stall. A factor was the loss of engine power for undetermined reasons.
- [NTSB FTW98LA202](https://openairdocs.org/ntsb/FTW98LA202.md): Cessna 150M · Levelland, TX · Accident · Minor injuries · Limited investigation · Final report · May 1, 1998 · N459U · Destroyed
  > the pilot's inaccurate weather evaluation, subsequent encounter with a severe downdraft, and failure (or inability) to compensate for the wind (downdraft) condition. The high density altitude was a related factor.
- [NTSB CHI98IA169](https://openairdocs.org/ntsb/CHI98IA169.md): Douglas DC-9-34 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Apr 30, 1998 · N928L · No damage
  > the yaw rate gyro of the Stab Aug Computer had been installed in a reverse position that was 180 degrees opposite from the correct position.
- [NTSB LAX98LA147](https://openairdocs.org/ntsb/LAX98LA147.md): Schweizer SGS-1-35 · Maricopa, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1998 · N34187 · Substantial damage
  > The pilot's loss of control in flight for undetermined reasons.
- [NTSB ATL98LA068](https://openairdocs.org/ntsb/ATL98LA068.md): Piper PA-28RT-201T · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Apr 28, 1998 · N2125N · Substantial damage
  > In-flight collision with a bird, which separated a fuel line causing a loss of engine power, and resulting in an emergency landing on unsuitable terrain.
- [NTSB NYC98LA102](https://openairdocs.org/ntsb/NYC98LA102.md): Piper PA-32-300 · New Bedford, MA · Accident · 1 fatal · Limited investigation · Final report · Apr 26, 1998 · N15326 · Substantial damage
  > The pilot's impairment due to alcohol, which resulted in an inadequate preflight examination and subsequent takeoff with a control lock installed.
- [NTSB MIA98LA144](https://openairdocs.org/ntsb/MIA98LA144.md): Piper PA-18 · St. Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Apr 26, 1998 · N225NY · Substantial damage
  > The intentional operation of the airplane by the pilot and the company/operator with the known deficiencies in equipment (worn carburetor). Also, the poor preflight planning by the pilot for his failure to recognize that the carburetor heat control was…
- [NTSB ANC98LA042](https://openairdocs.org/ntsb/ANC98LA042.md): Cessna 172M · Anchor Point, AK · Accident · No injuries · Limited investigation · Final report · Apr 26, 1998 · N8969V · Substantial damage
  > The pilot's failure to compensate for a crosswind. A related factor was the crosswind.
- [NTSB FTW98FA190](https://openairdocs.org/ntsb/FTW98FA190.md): Cessna 150H · Parowan, UT · Accident · 2 fatal · Field investigation · Final report · Apr 23, 1998 · N50385 · Destroyed
  > The pilot's failure to maintain sufficient airspeed and the subsequent inadvertent stall/spin. Factors were the high density altitude, the high, gusty wind condition, and the diverted attention of the pilot.
- [NTSB SEA98LA066](https://openairdocs.org/ntsb/SEA98LA066.md): Ercoupe 415-D · Colstrip, MT · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1998 · N2777H · Substantial damage
  > The pilot's operation of the aircraft above maximum gross weight, resulting in her inability to attain a sustained climb rate after becoming airborne. A factor was high density altitude conditions.
- [NTSB FTW98FA189](https://openairdocs.org/ntsb/FTW98FA189.md): Cessna 150F · Muskogee, OK · Accident · 2 fatal · Field investigation · Final report · Apr 21, 1998 · N8720G · Destroyed
  > The inadvertent stall as result of the pilot's failure to retract the flaps from the fully extended position prior to takeoff. Factors were the gusting winds and the pilot's failure to follow the before takeoff checklist.
- [NTSB SEA98LA064](https://openairdocs.org/ntsb/SEA98LA064.md): Bell 47G-3B-1 · Sedro Wooley, WA · Accident · No injuries · Limited investigation · Final report · Apr 20, 1998 · N80SD · Destroyed
  > Fuel contamination and subsequent carburetor fuel flow restriction initiated by the use of an improper material (incorrect fuel hose). A factor was the trees.
- [NTSB CHI98FA130](https://openairdocs.org/ntsb/CHI98FA130.md): Piper PA-28-140 · Kalamazoo, MI · Accident · 4 fatal · Field investigation · Final report · Apr 20, 1998 · N1762J · Destroyed
  > The pilot's failure to maintain adequate flying airspeed resulting in a stall condition. Contributing factors were the tailwind condition and the pilot's exceeding the gross weight of the airplane on takeoff.
- [NTSB CHI98LA131](https://openairdocs.org/ntsb/CHI98LA131.md): Cessna 150J · Canton, MI · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 1998 · N50566 · Substantial damage
  > The undetermined loss of power reported by the pilot. Contributing factors were the residential nature of the landing area and unsuitable landing terrain.
- [NTSB CHI98LA122](https://openairdocs.org/ntsb/CHI98LA122.md): Cessna 172 · Barrington Hill, IL · Accident · Serious injuries · Limited investigation · Final report · Apr 14, 1998 · N6300E · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent in-flight collision with trees.
- [NTSB IAD98FA044](https://openairdocs.org/ntsb/IAD98FA044.md): Piper PA-20 · Beaver Falls, PA · Accident · 2 fatal · Field investigation · Final report · Apr 12, 1998 · N2336A · Destroyed
  > The pilot's failure to maintain aircraft control, and his failure to attain adequate airspeed, which resulted in a stall. Contributing was the pilot's lack of familiarity with the airplane, and his misjudgment of wind information which resulted in a tailwind…
- [NTSB CHI98IA167](https://openairdocs.org/ntsb/CHI98IA167.md): McDonnell Douglas MD82 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Apr 11, 1998 · N951U · No damage
  > The failure of the Dual Axis Accelerometer.
- [NTSB NYC98FA092](https://openairdocs.org/ntsb/NYC98FA092.md): Aerostar 600A · Mapleton, ME · Accident · 1 fatal · Field investigation · Final report · Apr 10, 1998 · N7527S · Destroyed
  > the failure of the pilot to maintain control of the airplane during takeoff for undetermined reasons.
- [NTSB LAX98LA134](https://openairdocs.org/ntsb/LAX98LA134.md): Bell OH-58A · Huron, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 1998 · N176SJ · Substantial damage
  > A loss of engine power due to deteriorated O-ring seals in the fuel boost pump, which allowed air to enter the fuel lines. Factors in the accident were the inadequate manufacturer's inspection criteria for the fuel boost pump O-ring seals and the resulting…
- [NTSB FTW98LA178](https://openairdocs.org/ntsb/FTW98LA178.md): Beech E18S · Del Rio, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 1998 · N2083C · Substantial damage
  > a loss of engine power on the right engine for undetermined reasons, and the pilot's failure to maintain control of the airplane.
- [NTSB IAD98FA042](https://openairdocs.org/ntsb/IAD98FA042.md): Piper PA-30 · Mcmechen, WV · Accident · 1 fatal · Field investigation · Final report · Apr 5, 1998 · N7845Y · Destroyed
  > The pilot's inadequate pre-flight planning and preparation which resulted in fuel exhaustion during takeoff.
- [NTSB FTW98LA171](https://openairdocs.org/ntsb/FTW98LA171.md): Aero Commander S2R · Cushing, OK · Accident · No injuries · Limited investigation · Final report · Apr 4, 1998 · N8984Q · Substantial damage
  > The total loss of engine power resulting from a sheared accessory drive due to an undetermined reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA98LA059](https://openairdocs.org/ntsb/SEA98LA059.md): Beech 35-C33 · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Apr 1, 1998 · N1310A · Substantial damage
  > The flight instructor's inadequate supervision and the dual student's premature lift off which resulted in inadequate airspeed, a stall, and collision with the ground.
- [NTSB LAX98LA125](https://openairdocs.org/ntsb/LAX98LA125.md): Cessna 150G · Sonoma, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 1998 · N2952J · Substantial damage
  > The instructor pilot's inadequate in-flight planning/decision and subsequent inadequate supervision of the situation to simulate an engine failure on takeoff, as well as both pilot's not maintaining a visual lookout. A related factor was the diverted…
- [NTSB FTW98LA160](https://openairdocs.org/ntsb/FTW98LA160.md): Aero Commander 100 · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1998 · N5530M · Substantial damage
  > The separation of the aileron control rod due to bending overstress. A factor was the unsuitable terrain available for the precautionary landing.
- [NTSB FTW98FA165](https://openairdocs.org/ntsb/FTW98FA165.md): Velocity 173 RG Elite · N. Little Rock, AR · Accident · 2 fatal · Field investigation · Final report · Mar 26, 1998 · N173VE · Destroyed
  > Inadequate fusion between the valve stem and head due to inadequate quality control during construction of the exhaust valve for the number three cylinder. A contributing factor was the lack of suitable terrain for the forced landing
- [NTSB FTW98LA159](https://openairdocs.org/ntsb/FTW98LA159.md): Cessna 140 · Norman, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 1998 · N2044N · Substantial damage
  > The pilot's improper compensation for wind conditions, which resulted in a loss of directional control and collision with a ditch. A contributing factor was the high crosswind.
- [NTSB MIA98LA103](https://openairdocs.org/ntsb/MIA98LA103.md): Piper PA-38-112 · Tampa, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 22, 1998 · N2321D · Substantial damage
  > failure of the student pilot to maintain directional control of the airplane and proper runway alignment, which result in an in-flight collision with a hangar.
- [NTSB ATL98FA059](https://openairdocs.org/ntsb/ATL98FA059.md): Piper PA-31-310 · Southport, NC · Accident · Serious injuries · Field investigation · Final report · Mar 22, 1998 · N715PM · Destroyed
  > The pilot's failure to follow the preflight checklist, which resulted in a loss of engine power due to fuel starvation. Contributing to the significance of the accident was the pilot's failure to maintain control of the aircraft following the loss of engine…
- [NTSB LAX98LA124](https://openairdocs.org/ntsb/LAX98LA124.md): Cessna 210K · Fallon, NV · Accident · No injuries · Limited investigation · Final report · Mar 19, 1998 · N8274M · Substantial damage
  > The aircraft owner/pilot's improper assembly of the engine oil pump, which resulted in failure of the unit and oil starvation failure of the engine. A factor was the lack of supervision of the owner/pilot's work by the A & P mechanic.
- [NTSB LAX98LA122](https://openairdocs.org/ntsb/LAX98LA122.md): Cessna TU206F · Avalon, CA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1998 · N9674G · Substantial damage
  > Contamination of the fuel system which led to a loss of engine power. Factors were the lack of suitable terrain for the forced landing and the barbwire fence.
- [NTSB FTW98TA152](https://openairdocs.org/ntsb/FTW98TA152.md): Bell OH-58C · Dulce, NM · Accident · Serious injuries · Final report · Mar 19, 1998 · N505JA · Substantial damage
  > The partial loss of engine power due to a disconnected bleed air line to the fuel controller and the unsuitable terrain for a forced landing. Factors were the loose B-nut, the inadequate maintenance by unknown personnel, insufficient standards/requirements…
- [NTSB LAX98FA119](https://openairdocs.org/ntsb/LAX98FA119.md): Beech A35 · Auburn, CA · Accident · Minor injuries · Field investigation · Final report · Mar 17, 1998 · N8597A · Substantial damage
  > failure of the engine driven fuel pump drive coupling and the pilot's failure to perform the emergency procedure specified in the Pilot Operating Handbook.
- [NTSB LAX98FA113](https://openairdocs.org/ntsb/LAX98FA113.md): Beech B95A · Little River, CA · Accident · 4 fatal · Field investigation · Final report · Mar 15, 1998 · N569T · Destroyed
  > the pilot's inadvertent visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's improper weather evaluation.
- [NTSB CHI98LA105](https://openairdocs.org/ntsb/CHI98LA105.md): Aero Commander 680FLP · Fond Du Lac, WI · Accident · Minor injuries · Limited investigation · Final report · Mar 13, 1998 · N777MX · Substantial damage
  > the pilot's misjudged weather evaluation. Factors were turbulence, the pilot's inability to attain a proper climb rate, unsuitable terrain encountered in the landing area, and crops.

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

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

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