# NTSB investigations, 1997: 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 1 of 6 · 272 cases

## Latest cases

- [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…
- [NTSB CHI98LA047](https://openairdocs.org/ntsb/CHI98LA047.md): Hall RV-6 · Blair, NE · Accident · No injuries · Limited investigation · Final report · Nov 25, 1997 · N36AH · Substantial damage
  > a fatigue failure of the torque tube outside of the weld and the fractured pilot's side left rudder pedal.
- [NTSB FTW98LA058](https://openairdocs.org/ntsb/FTW98LA058.md): Gulfstream-Schweizer G-164B · Lecompte, LA · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 1997 · N2LU · Substantial damage
  > a loose battery cover, due to improper installation by maintenance personnel, that became jammed with an elevator control rod and restricted the movement of the elevator control system, which subsequently led to an uncontrolled impact with a tree, shortly…
- [NTSB ATL98LA012](https://openairdocs.org/ntsb/ATL98LA012.md): Roebuck Rans S-10 Sakota · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Nov 22, 1997 · N803DR · Substantial damage
  > the airplane builder's improper routing of vinyl/plastic cooling/vent line(s) for the engine oil system, and improper materials supplied by the manufacturer, which led to overheating of the line(s) in the engine compartment and an in-flight fire.
- [NTSB FTW98TA052](https://openairdocs.org/ntsb/FTW98TA052.md): Cessna 310J · Beaumont, TX · Accident · Serious injuries · Final report · Nov 19, 1997 · N156SD · Destroyed
  > The pilot's failure to maintain control for undetermined reasons. A factor may have been an encounter with wake turbulence.
- [NTSB FTW98LA050](https://openairdocs.org/ntsb/FTW98LA050.md): Cessna 172G · Van, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1997 · N202EX · Substantial damage
  > fuel starvation, resulting from restricted carburetor float travel, due to improper maintenance installation. The encounter with a power line was related factor.
- [NTSB CHI98LA038](https://openairdocs.org/ntsb/CHI98LA038.md): Cessna 150 · Plymouth, IN · Accident · No injuries · Limited investigation · Final report · Nov 17, 1997 · N50579 · Substantial damage
  > the pilot's failure to maintain control of the airplane during the crosswind, soft field takeoff. Factors in this accident were the pilot not following the airplane manufacturer's recommended takeoff procedures by lowering the flaps, and the crosswind.
- [NTSB LAX98LA038](https://openairdocs.org/ntsb/LAX98LA038.md): Adams Sonerai II · Kingman, AZ · Accident · 1 fatal · Limited investigation · Final report · Nov 16, 1997 · N27KF · Destroyed
  > The complete loss of engine power for undetermined reasons. A factor in the accident was the rough nature of the landing site terrain.
- [NTSB SEA98LA014](https://openairdocs.org/ntsb/SEA98LA014.md): Piper PA-18-150 · Battle Ground, WA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1997 · N1668P · Substantial damage
  > The owner/pilot's failure to properly install the fuel selector valve after removal, subsequently leading to a false indication on the valve selector handle. This led to the pilot unintentionally closing the valve and starving the engine of fuel during the…
- [NTSB LAX98FA039](https://openairdocs.org/ntsb/LAX98FA039.md): Mooney M20 · Big Bear, CA · Accident · 2 fatal · Field investigation · Final report · Nov 15, 1997 · N5231B · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…
- [NTSB MIA98LA030](https://openairdocs.org/ntsb/MIA98LA030.md): Cessna 150M · Ormond Beach, FL · Accident · No injuries · Limited investigation · Final report · Nov 13, 1997 · N6062K · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB MIA98LA028](https://openairdocs.org/ntsb/MIA98LA028.md): Cessna 182A · Parkton, NC · Accident · No injuries · Limited investigation · Final report · Nov 9, 1997 · N5883B · Substantial damage
  > improper installation of an auto battery cable which led to an in-flight fire due to the chaffed cable.
- [NTSB MIA98LA029](https://openairdocs.org/ntsb/MIA98LA029.md): Cessna 172P · Naples, FL · Accident · No injuries · Limited investigation · Final report · Nov 8, 1997 · N97074 · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB ANC98MA008](https://openairdocs.org/ntsb/ANC98MA008.md): Cessna 208B · Barrow, AK · Accident · 8 fatal · Major investigation · Final report · Nov 8, 1997 · N750GC · Destroyed
  > The pilot's disregard for lateral fuel loading limits, his improper removal of frost prior to takeoff, and the resulting inadvertent stall/spin. Factors involved in this accident were the improper asymmetrical fuel loading which reduced lateral aircraft…
- [NTSB FTW98LA045](https://openairdocs.org/ntsb/FTW98LA045.md): Beech J35 · Provo, UT · Accident · No injuries · Limited investigation · Final report · Nov 5, 1997 · N171Y · Substantial damage
  > the pilot's failure to properly position the fuel tank selector to a tank with adequate fuel, which resulted in fuel starvation, and a subsequent forced landing due to lack of engine power. His failure (or inability) to extent the gear for landing was a…
- [NTSB FTW98LA048](https://openairdocs.org/ntsb/FTW98LA048.md): Cessna 150F · Brigham City, UT · Accident · No injuries · Limited investigation · Final report · Nov 1, 1997 · N7934F · Substantial damage
  > failure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.
- [NTSB FTW98LA038](https://openairdocs.org/ntsb/FTW98LA038.md): Piper PA-23-250 · Galveston, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 1997 · N40201 · Substantial damage
  > inadequate maintenance and/or preflight inspection of the airplane, and subsequent blockage of the fuel filters, which led to fuel starvation, partial loss of engine power in both engines, and a forced landing. A related factor was the lack of suitable…
- [NTSB CHI98LA037](https://openairdocs.org/ntsb/CHI98LA037.md): Piper PA-32-260 · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · Oct 31, 1997 · N3359W · Substantial damage
  > fuel starvation due a deteriorated grommet in an Adel clamp, and a loose mixture control cable.
- [NTSB CHI98LA024](https://openairdocs.org/ntsb/CHI98LA024.md): Beech 23 · Salina, KS · Accident · No injuries · Limited investigation · Final report · Oct 27, 1997 · N843KS · Substantial damage
  > the student pilot's excessive pull-up and the flight instructor's inadequate supervision during a simulated engine failure after takeoff, resulting in a stall/mush onto the runway.
- [NTSB LAX98LA021](https://openairdocs.org/ntsb/LAX98LA021.md): Revolution MINI-500 · Long Beach, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 1997 · N7234Y · Destroyed
  > loss of engine power and low rotor rpm for undeterminted reasons. The factory representative's recommendation to reduce the main rotor low pitch stop (from -1.8 degree to -0.5 degree) may have been a related factor.
- [NTSB NYC98LA019](https://openairdocs.org/ntsb/NYC98LA019.md): Piper PA-34-220T · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Oct 24, 1997 · N8371H · Substantial damage
  > the pilot's failure to check the elevator trim prior to takeoff, and his failure to retard the power in a timely manner after touchdown.
- [NTSB SEA98LA003](https://openairdocs.org/ntsb/SEA98LA003.md): Champion 7EC · Galata, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 1997 · CFOJT · Substantial damage
  > The pilot's failure to adequately perform preflight planning (prior to the precautionary landing and prior to the subsequent takeoff), his selection of an unsuitable takeoff area, and his failure to maintain altitude/clearance from the fence during the…
- [NTSB ATL98FA002](https://openairdocs.org/ntsb/ATL98FA002.md): Beech 95-B55 · Kennesaw, GA · Accident · 1 fatal · Field investigation · Final report · Oct 15, 1997 · N315K · Destroyed
  > the pilot's improper emergency procedures and subsequent loss of aircraft control, while attempting to maneuver for a precautionary landing. A factor relating to the accident was: partial loss of power in one or both engines for undetermined reason(s).
- [NTSB NYC98LA011](https://openairdocs.org/ntsb/NYC98LA011.md): Schweizer SGS1-26A · Fairfield, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 13, 1997 · N1154N · Minor damage
  > The improper installation of the elevator cables and elevator control bell-crank by the pilot, and an inadequate annual inspection by the mechanic. Also causal was the pilot's inadequate preflight of the flight controls prior to takeoff.
- [NTSB MIA98TA011](https://openairdocs.org/ntsb/MIA98TA011.md): Cessna 172P · Wiggins, MS · Accident · Minor injuries · Final report · Oct 12, 1997 · N945SM · Substantial damage
  > Loss of engine power for undetermined reasons resulting in a forced landing on unsuitable terrain and the aircraft nosing over during landing roll.
- [NTSB MIA98FA010](https://openairdocs.org/ntsb/MIA98FA010.md): Piper PA-28-180 · Knoxville, TN · Accident · 3 fatal · Field investigation · Final report · Oct 12, 1997 · N15331 · Destroyed
  > failure of the pilot to maintain control of the airplane, while climbing after takeoff, which resulted in an uncontrolled descent and impact with the water.
- [NTSB NYC98FA009](https://openairdocs.org/ntsb/NYC98FA009.md): Piper PA-28R-180 · Morganville, NJ · Accident · 4 fatal · Field investigation · Final report · Oct 11, 1997 · N3981T · Destroyed
  > The inadequate maintenance by the flying club and maintenance facility, which resulted in a takeoff with a partially blocked fuel injector nozzle and the failure of the landing gear to retract after takeoff. This resulted in the pilot's diverted attention and…
- [NTSB IAD98LA004](https://openairdocs.org/ntsb/IAD98LA004.md): Ford RV-4 · Dansville, NY · Accident · No injuries · Limited investigation · Final report · Oct 8, 1997 · N17PQ · Substantial damage
  > The internal mechanical failure of the engine driven fuel pump which resulted in a loss of engine power.
- [NTSB FTW98LA013](https://openairdocs.org/ntsb/FTW98LA013.md): Piper PA-18-150 · Folsum, NM · Accident · No injuries · Limited investigation · Final report · Oct 6, 1997 · N83454 · Substantial damage
  > the pilot's failure to maintain aircraft control during takeoff, which resulted in a stall/mush. A related factor was the crosswind condition.

Next page: https://openairdocs.org/ntsb-phases/350/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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/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.