# NTSB investigations, 1997: Takeoff

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 1 of 4 · 154 cases

## Latest cases

- [NTSB NYC98LA057](https://openairdocs.org/ntsb/NYC98LA057.md): Cessna 421C · Elkins, WV · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1997 · N1348T · Destroyed
  > The flight instructor's failure to identify an unsafe runway condition and his delay in aborting the takeoff. Contributing was the aircraft's maximum takeoff weight exceeded, and a snow-covered runway.
- [NTSB CHI98LA065](https://openairdocs.org/ntsb/CHI98LA065.md): Cessna 150M · Sidney, NE · Accident · No injuries · Limited investigation · Final report · Dec 16, 1997 · N3820V · Substantial damage
  > the student pilot's inadequate compensation for the crosswind which resulted in a loss of directional control. Factors associated with the accident were the crosswind, the misunderstood radio communication, and the rough terrain which the airplane encountered.
- [NTSB CHI98LA066](https://openairdocs.org/ntsb/CHI98LA066.md): Cessna 150H · Hillsdale, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 1997 · N23239 · Substantial damage
  > The student pilot's failure to maintain. Contributing were icy conditions on the runway and a snowbank.
- [NTSB FTW98LA082](https://openairdocs.org/ntsb/FTW98LA082.md): Mooney M20 · Pocahontas, AR · Accident · No injuries · Limited investigation · Final report · Dec 13, 1997 · N6159E · Substantial damage
  > failure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in an inadvertent ground swerve. A related factor was: the pilot's lack of recent experience in the make and model of airplane.
- [NTSB NYC98FA041](https://openairdocs.org/ntsb/NYC98FA041.md): Piper PA-32-260 · Pittsville, MD · Accident · 3 fatal · Field investigation · Final report · Dec 12, 1997 · N3448W · Destroyed
  > the pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision and flight in instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude while flying over wooded terrain. Factors…
- [NTSB CHI98LA063](https://openairdocs.org/ntsb/CHI98LA063.md): Beech 1900C · Rockford, IL · Accident · No injuries · Limited investigation · Final report · Dec 10, 1997 · N79GL · Substantial damage
  > improper installation of aileron cables by the maintenance personnel, inadequate inspection by the company's maintenance personnel of maintenance performed, and inadequate preflight by the pilot.
- [NTSB CHI98LA052](https://openairdocs.org/ntsb/CHI98LA052.md): Piper PA-46-350P · Vicksburg, MI · Accident · No injuries · Limited investigation · Final report · Dec 2, 1997 · N6295Z · Substantial damage
  > the pilot's inadequate preflight preparation and his failure to maintain directional control during takeoff. A factor was the uneven runway at the grass airstrip.
- [NTSB IAD98LA014](https://openairdocs.org/ntsb/IAD98LA014.md): Jones Mini 500 · Bluefield, WV · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 1997 · N8015E · Substantial damage
  > Pilot's unfamiliarity with reciprocating engine powered helicopter lead to a reduction in main rotor rpm and subsequent uncontrolled rate of descent with insufficient altitude to recover.
- [NTSB NYC98LA033](https://openairdocs.org/ntsb/NYC98LA033.md): Piper PA-32-300 · Johnstown, PA · Accident · No injuries · Limited investigation · Final report · Nov 26, 1997 · N2202U · Substantial damage
  > the pilot's failure to maintain direction control of the airplane during the takeoff roll. Factors relating to this accident were: the crosswind condition, and snowbank.
- [NTSB NYC98LA032](https://openairdocs.org/ntsb/NYC98LA032.md): Piper PA-28-140 · Middlefield, OH · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 1997 · N1816J · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB LAX98LA044](https://openairdocs.org/ntsb/LAX98LA044.md): Maule M-7-235B · San Martin, CA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1997 · N611BY · Substantial damage
  > The pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.
- [NTSB SEA98LA015](https://openairdocs.org/ntsb/SEA98LA015.md): Piper PA-22-150 · Newberg, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 1997 · N7528D · Substantial damage
  > The pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.
- [NTSB CHI98LA053](https://openairdocs.org/ntsb/CHI98LA053.md): McDonnell Douglas DC-9-15 · Syracuse, NY · Accident · No injuries · Limited investigation · Final report · Nov 21, 1997 · N564PC · Substantial damage
  > The pilot's inadequate preflight to ensure that the cargo pallets were properly secured. Also causal was the the improper securing of the pallets.
- [NTSB ATL98LA010](https://openairdocs.org/ntsb/ATL98LA010.md): Cessna 152 · Punta Gorda, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 1997 · N93286 · Substantial damage
  > The flight instructor's improper short field takeoff procedure and his decision to abort the takeoff after rotation.
- [NTSB ANC98LA010](https://openairdocs.org/ntsb/ANC98LA010.md): Piper PA-31-T3 · Tyonek, AK · Accident · No injuries · Limited investigation · Final report · Nov 11, 1997 · N314SC · Substantial damage
  > An on-ground collision with an animal (moose). Factors in the accident were night VFR conditions that restricted the pilot's visual lookout, and the lack of an airport perimeter fence.
- [NTSB SEA98LA012](https://openairdocs.org/ntsb/SEA98LA012.md): Aerostar PA-60-700P · Portland, OR · Accident · No injuries · Limited investigation · Final report · Nov 7, 1997 · N700HS · Substantial damage
  > The pilot's selection of an improper remedial action for an unanticipated yaw excursion during takeoff roll, resulting in the aircraft becoming airborne with inadequate airspeed and consequent loss of aircraft control.
- [NTSB FTW98LA046](https://openairdocs.org/ntsb/FTW98LA046.md): Piper PA-22-150 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Nov 7, 1997 · N9607D · Substantial damage
  > the pilot's failure to maintain directional control of the airplane during the takeoff roll, due to inadvertently stepping on the brake. A related factor was the pilot's excessive use of rudder for steering.
- [NTSB SEA98LA011](https://openairdocs.org/ntsb/SEA98LA011.md): Cessna 150H · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Nov 6, 1997 · N695NS · Substantial damage
  > The student pilot's failure to maintain directional control.
- [NTSB ANC98LA009](https://openairdocs.org/ntsb/ANC98LA009.md): Cessna 185F · Barrow, AK · Accident · No injuries · Limited investigation · Final report · Oct 31, 1997 · N61500 · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, and his delay in aborting the takeoff. A factor in the accident was the presence of gravel/sand in the takeoff area.
- [NTSB CHI98LA026](https://openairdocs.org/ntsb/CHI98LA026.md): Learjet 35A · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · Oct 29, 1997 · N62MB · Substantial damage
  > a deer that ran in front of the airplane during the takeoff phase. A factor in this accident was the lack of an airport perimeter fence to prevent deer from getting onto the runway.
- [NTSB FTW98LA029](https://openairdocs.org/ntsb/FTW98LA029.md): Cessna 185C · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Oct 23, 1997 · N725 · Substantial damage
  > the pilot's improper preflight of the airplane, by failing to properly set the elevator trim for takeoff, and his improper use use of the elevator flight controls. A related factor was: the pilot's lack of recent experience in the make and model of airplane.
- [NTSB SEA98LA005](https://openairdocs.org/ntsb/SEA98LA005.md): Piper PA-28-151 · Vashon, WA · Accident · No injuries · Limited investigation · Final report · Oct 19, 1997 · N5987F · Substantial damage
  > A misjudged soft field takeoff. Factors include wet grass.
- [NTSB FTW98LA015](https://openairdocs.org/ntsb/FTW98LA015.md): Sego Tool Hawk H2X · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Oct 15, 1997 · N4412X · Substantial damage
  > The pilot's failure to maintain aircraft control. Contributing was the inadequate design of the flight control systems, resulting in slow response to pilot input.
- [NTSB NYC98LA007](https://openairdocs.org/ntsb/NYC98LA007.md): Cessna 120 · Prince George, VA · Accident · No injuries · Limited investigation · Final report · Oct 6, 1997 · N1856N · Substantial damage
  > The pilot's failure to attain takeoff climb, and his delay in aborting the takeoff. A contributing factor was soft terrain.
- [NTSB FTW98LA143](https://openairdocs.org/ntsb/FTW98LA143.md): Aerostar S-60A · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 6, 1997 · N63459 · Substantial damage
  > the pilot's failure to maintain control of the balloon.
- [NTSB NYC98LA008](https://openairdocs.org/ntsb/NYC98LA008.md): Boeing Stearman PT-17 · Elkton, MD · Accident · No injuries · Limited investigation · Final report · Oct 5, 1997 · N49760 · 2 aircraft · Substantial damage
  > The inadequate lookout by the pilot of the Cessna and his failure to maintain adequate clearance between his airplane and the active runway. A factor in the accident was the lack of taxiway hold signs or lines.
- [NTSB LAX98LA003](https://openairdocs.org/ntsb/LAX98LA003.md): Cessna 185F · Oakland, CA · Accident · No injuries · Limited investigation · Final report · Oct 5, 1997 · N17SR · Substantial damage
  > The pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control.
- [NTSB MIA98LA004](https://openairdocs.org/ntsb/MIA98LA004.md): Piper J3C-65 · Trenton, GA · Accident · No injuries · Limited investigation · Final report · Oct 4, 1997 · N30236 · Substantial damage
  > failure of the pilot to abort the takeoff, when he observed an indication of less than full engine power on the tachometer from the beginning of the takeoff roll. Factors relating to the accident were: the inadequate preflight planning and preparation by the…
- [NTSB CHI98LA008](https://openairdocs.org/ntsb/CHI98LA008.md): Boeing B75N1 · Cloverdale, IN · Accident · No injuries · Limited investigation · Final report · Oct 4, 1997 · N75511 · 2 aircraft · Substantial damage
  > the Boeing pilot failed to identify the Waco airplane on the runway before initiating a takeoff. Factors related to the accident were: the restricted forward visibility of both pilots due to the tailwheel configurations of both airplanes.
- [NTSB MIA97LA252](https://openairdocs.org/ntsb/MIA97LA252.md): Cessna A188B · Greenwood, MS · Accident · No injuries · Limited investigation · Final report · Sep 30, 1997 · N731RP · Destroyed
  > The intentional operation of the airplane from an unsuitable takeoff area by the pilot-in-command and inadvertent rotation of the airplane after encountering rising terrain on the runway.
- [NTSB ANC97LA158](https://openairdocs.org/ntsb/ANC97LA158.md): Pilatus PC-6-350 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Sep 30, 1997 · N4911 · Substantial damage
  > An underspeed of the propeller system.
- [NTSB ANC97LA157](https://openairdocs.org/ntsb/ANC97LA157.md): Cessna 180 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Sep 30, 1997 · N4900A · Substantial damage
  > The distorted/misaligned main landing gear, and an improper maintenance repair of the main landing gear. A factor associated with the accident was rough and uneven terrain.
- [NTSB MIA97LA251](https://openairdocs.org/ntsb/MIA97LA251.md): Cessna 170 · Troy, NC · Accident · No injuries · Limited investigation · Final report · Sep 29, 1997 · N2554V · Substantial damage
  > delay of the pilot to abort the takeoff after noting sluggish acceleration during the takeoff roll. Factors relating to the accident were: improper timing of the magneto(s), and a malfunction of the carburetor.
- [NTSB SEA97IA219](https://openairdocs.org/ntsb/SEA97IA219.md): Boeing 737-3T0 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Sep 27, 1997 · N13331 · No damage
  > Separation of the ABSB-4 aileron bus cable, resulting in reduced lateral controllability of the aircraft. Related factors were wear in the cable and inadequate inspection of the cable by company maintenance personnel.
- [NTSB ATL97LA140](https://openairdocs.org/ntsb/ATL97LA140.md): Cessna 172N · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Sep 25, 1997 · N738SZ · Substantial damage
  > the pilot's improper use of the elevator control and delayed liftoff during takeoff, which resulted in an inadvertent porpoise, collision with the runway, and collapse of the nose gear as he aborted the takeoff.
- [NTSB FTW97LA356](https://openairdocs.org/ntsb/FTW97LA356.md): Sikorsky S-76A · Patterson, LA · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 1997 · N517AL · Substantial damage
  > failure of the copilot to maintain a positive rate of climb after takeoff, which led to an inadvertent descent and collision with a crop of sugar cane and the ground. Factors relating to the accident were: darkness, fog, and the pilot-in-command's inadequate…
- [NTSB MIA97LA244](https://openairdocs.org/ntsb/MIA97LA244.md): Maule M-7-235 · Louisville, MS · Accident · No injuries · Limited investigation · Final report · Sep 14, 1997 · N5662S · Substantial damage
  > The failure of the pilot to assure that the rudder trim was properly set for takeoff and his delay in aborting the takeoff when the airplane yawed to the left during the early portion of the takeoff roll.
- [NTSB FTW97LA349](https://openairdocs.org/ntsb/FTW97LA349.md): AS+ AC-4B · Sundance, WY · Accident · No injuries · Limited investigation · Final report · Sep 14, 1997 · N3021 · Substantial damage
  > improper planning/decision by the pilot, which led to a snag and sudden slack in the tow rope, and necessitated an aborted launch (emergency landing) after initial liftoff. This in turn led to an inadvertent stall, a wing drop, and the left wing tip dragging…
- [NTSB CHI97LA288](https://openairdocs.org/ntsb/CHI97LA288.md): Beech 35-C33A · Amana, IA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1997 · N5729V · Substantial damage
  > the pilot's improper planning/decision. The fence (location) was a related factor.
- [NTSB ANC97LA140](https://openairdocs.org/ntsb/ANC97LA140.md): Cessna U206F · King Salmon, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1997 · N7032Q · Destroyed
  > the pilot's selection of an unsuitable takeoff area. Factors were the sand bar and the pilot's failure to use all available waterway for the takeoff.
- [NTSB ATL97LA126](https://openairdocs.org/ntsb/ATL97LA126.md): Gulfstream-Schweizer G-164C · Beaufort, NC · Accident · No injuries · Limited investigation · Final report · Aug 28, 1997 · N585CK · Substantial damage
  > failure of the pilot to ensure the tailwheel was properly locked, while taking off on an asphalt runway, which led to loss of directional control and a ground swerve.
- [NTSB LAX97IA300](https://openairdocs.org/ntsb/LAX97IA300.md): Airbus Industrie A300 B4-203 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Aug 24, 1997 · N862PA · Minor damage
  > Separation of the landing gear tire tread and subsequent ingestion of the tread into the intake of the engine.
- [NTSB ANC97LA130](https://openairdocs.org/ntsb/ANC97LA130.md): Cessna 170A · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1997 · N9540A · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and overload failure of the right main landing gear. Factors related to the accident were: the…
- [NTSB IAD97LA113](https://openairdocs.org/ntsb/IAD97LA113.md): Haines Revolution Mini 500 · N Philadelphia, OH · Accident · No injuries · Limited investigation · Final report · Aug 23, 1997 · N7240E · Substantial damage
  > A leak on the exhaust manifold which resulted in a loss of engine power.
- [NTSB ANC97LA128](https://openairdocs.org/ntsb/ANC97LA128.md): Helio H-295 · Fort Yukon, AK · Accident · No injuries · Limited investigation · Final report · Aug 23, 1997 · N6465V · Substantial damage
  > failure of the pilot to maintain directional control of the airplane, which resulted in a swerve and collision with a tree as the pilot continued the takeoff, subsequently jamming the stabilator and causing the plane to crash in water.
- [NTSB FTW97LA315](https://openairdocs.org/ntsb/FTW97LA315.md): Piper PA-28-180 · Gila, NM · Accident · No injuries · Limited investigation · Final report · Aug 19, 1997 · N9455J · Substantial damage
  > the pilot's impairment of judgment and performance due to alcohol, and his failure to maintain directional control of the airplane, which resulted in a ground swerve, and collision with vegetation (cactus) and a fence. Related factors were: the soft runway…
- [NTSB CHI97LA263](https://openairdocs.org/ntsb/CHI97LA263.md): Grumman G-164B · Burlington, WI · Accident · No injuries · Limited investigation · Final report · Aug 16, 1997 · N7016Y · Substantial damage
  > the deer which contacted the airplane.
- [NTSB ANC97LA123](https://openairdocs.org/ntsb/ANC97LA123.md): Champion 7ECA · Kaktovik, AK · Accident · No injuries · Limited investigation · Final report · Aug 14, 1997 · N5507H · Substantial damage
  > The pilot's selection of an unsuitable takeoff area. A factor related to the accident was the rocky terrain.
- [NTSB LAX97LA281](https://openairdocs.org/ntsb/LAX97LA281.md): Aerospatiale TB-20 · Borrego, CA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1997 · N577JL · Substantial damage
  > The pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain runway alignment during the takeoff roll.
- [NTSB SEA97LA183](https://openairdocs.org/ntsb/SEA97LA183.md): Cessna 150M · Stanley, ID · Accident · No injuries · Limited investigation · Final report · Aug 8, 1997 · N704AA · Substantial damage
  > The pilot's failure to attain rotation speed. The pilot's failure to maintain aircraft control and rough runway conditions were factors.

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?year=1997&page=2

## 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 year(c."eventDate") = 1997
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?year=1997

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