# NTSB investigations, 1997: Enroute

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 10 · 466 cases

## Latest cases

- [NTSB MIA98FA047](https://openairdocs.org/ntsb/MIA98FA047.md): Cessna 414A · Guyton, GA · Accident · 2 fatal · Field investigation · Final report · Dec 29, 1997 · N414MT · Destroyed
  > Inadequate maintenance of the cabin pressurization system, which resulted in inadequate pressurization and incapacitation of the pilot due to the hypoxia. Also causal was the pilot's failure to adequately monitor the cabin pressurization system.
- [NTSB NYC98LA056](https://openairdocs.org/ntsb/NYC98LA056.md): Mooney M20F · Ferncliff, VA · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1997 · N9717M · Destroyed
  > the improper installation of the engine oil temperature probe which resulted in oil starvation and a total loss of engine power. A factor in the accident was the pilot's overflight of available airports in an effort to reach the 'Nearest Airport' displayed on…
- [NTSB FTW98LA078](https://openairdocs.org/ntsb/FTW98LA078.md): Beech 35 · Springdale, AR · Accident · No injuries · Limited investigation · Final report · Dec 28, 1997 · N2815V · Substantial damage
  > The fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a…
- [NTSB DCA98MA015](https://openairdocs.org/ntsb/DCA98MA015.md): Boeing 747-122 · Pacific Ocean (Pacific Ocean) · Accident · 1 fatal · Major investigation · Final report · Dec 28, 1997 · N4723U · Minor damage
  > The pilot-in-command's inadvertent flight into adverse weather conditions, and the difficulty of obtaining adequate weather forecasts of over-ocean turbulence. Factors contributing to the accident include the presence of clear air turbulence, and the failure…
- [NTSB NYC98LA053](https://openairdocs.org/ntsb/NYC98LA053.md): Robinson R-22 Beta · Riverside, PA · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1997 · N8015V · Substantial damage
  > the pilot's improper response to the low rotor RPM warning. Factors in the accident were the pilot's failure to turn for the forced landing area and the carburetor icing conditions.
- [NTSB MIA98LA046](https://openairdocs.org/ntsb/MIA98LA046.md): Piper PA-28-151 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Dec 26, 1997 · N9514K · Substantial damage
  > The pilot's inadequate preflight planning, and his poor in-flight decision making.
- [NTSB MIA98LA044](https://openairdocs.org/ntsb/MIA98LA044.md): Piper PA-28-180 · Everglades City, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 1997 · N9640J · Substantial damage
  > the pilot's improper fuel management and improper in-flight planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Related factors were: the light conditions at dusk, and the lack of suitable terrain for a forced…
- [NTSB FTW98LA071](https://openairdocs.org/ntsb/FTW98LA071.md): Unknown Quicksilver GT-500 · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 1997 · UNREG · Substantial damage
  > the kitplane builder's improper installation of the bolts attaching the left leading edge wing strut fitting to the leading edge spar, which resulted in the eventual failure of the fitting and the ensuing loss of control. Related factors were: the…
- [NTSB FTW98FA073](https://openairdocs.org/ntsb/FTW98FA073.md): Swearingen SA226-T · Byers, CO · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1997 · N950TT · Destroyed
  > The pilot inadvertently stalling the airplane and his subsequent spatial disorientation which prevented him from maintaining airplane control. Factors were excessive workload on the pilot and the dark night light conditions.
- [NTSB NYC98LA049](https://openairdocs.org/ntsb/NYC98LA049.md): Bihn Mini 500 · Gettysburg, OH · Accident · 1 fatal · Limited investigation · Final report · Dec 19, 1997 · N727EB · Destroyed
  > A loss of engine power for undetermined reasons, followed by the main rotor striking the tailboom, which resulted in the separation of a main rotor blade.
- [NTSB NYC98LA045](https://openairdocs.org/ntsb/NYC98LA045.md): Piper PA-28R-200 · Fairplain, WV · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 1997 · N9418N · Destroyed
  > an improper overhaul of the fuel servo by the manufacturer, which resulted in the loss of engine power. Factors in the accident were the dark night conditions and rough forced landing terrain.
- [NTSB ATL98FA025](https://openairdocs.org/ntsb/ATL98FA025.md): Cessna A150K · Jacksonville, FL · Accident · 2 fatal · Field investigation · Final report · Dec 17, 1997 · N1218M · Substantial damage
  > the pilot's failure to maintain adequate flying speed following a banner pick up, which resulted in a stall and an uncontrolled collision with the ground. A related factor was: the pilot allowed the maximum certificated gross weight of the airplane to be…
- [NTSB SEA98LA024](https://openairdocs.org/ntsb/SEA98LA024.md): Bell 206L · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Dec 16, 1997 · N206LT · Substantial damage
  > loss of engine power for undetermined reason(s). A factor relating to the accident included a dirt berm/ridge in the field where the pilot executed the forced landing.
- [NTSB FTW98LA069](https://openairdocs.org/ntsb/FTW98LA069.md): Cessna 172N · Mckinney, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 1997 · N1371E · Substantial damage
  > The pilot's inadequate in-flight/planning decision which resulted in continued flight until fuel exhaustion. Related factors were incorrect fuel gauge readings and trees.
- [NTSB LAX98LA057](https://openairdocs.org/ntsb/LAX98LA057.md): Saab-Scania 340B · Ventura, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 1997 · N329AE · No damage
  > Seat belt not used. A related factor was the unforecasted severe air turbulence.
- [NTSB IAD98FA015](https://openairdocs.org/ntsb/IAD98FA015.md): Socata TB-20 Trinidad · Roanoke, VA · Accident · 1 fatal · Field investigation · Final report · Dec 10, 1997 · N3041J · Destroyed
  > Loss of engine power for undetermined reasons. A related factor was the low ceiling.
- [NTSB FTW98LA066](https://openairdocs.org/ntsb/FTW98LA066.md): Cessna 207 · Fruita, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 10, 1997 · N91002 · Substantial damage
  > The total loss of engine power for undetermined reasons.
- [NTSB NYC98LA038](https://openairdocs.org/ntsb/NYC98LA038.md): Cessna TR182 · Owenton, KY · Accident · No injuries · Limited investigation · Final report · Dec 9, 1997 · N4701S · Substantial damage
  > The pilot's inadequate preflight/inflight decision and VFR flight in instrument meteorological conditions. Contributing was a low ceiling.
- [NTSB CHI98LA059](https://openairdocs.org/ntsb/CHI98LA059.md): Bellanca 17-30 · Independence, KS · Accident · 2 fatal · Limited investigation · Final report · Dec 8, 1997 · N4854V · Destroyed
  > the pilot's intentional flight into adverse weather. Contributing factors were low ceilings, fog, and the guy wire.
- [NTSB LAX98FA052](https://openairdocs.org/ntsb/LAX98FA052.md): Cessna 172N · Lytle Creek, CA · Accident · 2 fatal · Field investigation · Final report · Dec 7, 1997 · N3548E · Destroyed
  > the non-instrument rated pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the adverse weather conditions (low ceiling…
- [NTSB CHI98LA055](https://openairdocs.org/ntsb/CHI98LA055.md): Piper PA-24 · Cairo, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 1997 · N8452P · Substantial damage
  > a fractured muffler, failure of the owner/pilot to ensured that the annual maintenance inspection had been completed before flight, and subsequent pilot incapacitation due to carbon monoxide poisoning.
- [NTSB ATL98LA020](https://openairdocs.org/ntsb/ATL98LA020.md): Cessna 172B · Henderson, NC · Accident · No injuries · Limited investigation · Final report · Dec 6, 1997 · N172MT · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB ATL98LA018](https://openairdocs.org/ntsb/ATL98LA018.md): John T. Simpson Challenger II · Rainbow City, AL · Accident · 1 fatal · Limited investigation · Final report · Dec 6, 1997 · N11644 · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with the ground. A related factor was the pilot's lack of flying experience.
- [NTSB LAX98FA050](https://openairdocs.org/ntsb/LAX98FA050.md): Mooney M20J · Sedona, AZ · Accident · 2 fatal · Field investigation · Final report · Dec 3, 1997 · N301JL · Destroyed
  > the failure of the pilot to maintain adequate terrain clearance during the climb. Contributing factors were dark night conditions, mountainous/hilly terrain, and mountain wave weather conditions.
- [NTSB NYC98LA037](https://openairdocs.org/ntsb/NYC98LA037.md): Cessna A152 · Moriches, NY · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1997 · N758YR · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB MIA98LA037](https://openairdocs.org/ntsb/MIA98LA037.md): Cessna FR-172J · Marietta, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1997 · N14493 · Destroyed
  > A catastrophic failure of the oil cooler core which led to overboard porting of lubricating oil and subsequent engine failure.
- [NTSB MIA98FA038](https://openairdocs.org/ntsb/MIA98FA038.md): Cessna C-182E · Townsend, TN · Accident · 1 fatal · Field investigation · Final report · Dec 1, 1997 · N9033Y · Destroyed
  > the pilot's failure to maintain VFR flight conditions in a mountainous area resulting in inflight collision with rising terrain.
- [NTSB MIA98FA040](https://openairdocs.org/ntsb/MIA98FA040.md): Commander 114B · Cross City, FL · Accident · 3 fatal · Field investigation · Final report · Nov 30, 1997 · N302RS · Destroyed
  > VFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the terrain (tree,…
- [NTSB FTW98LA059](https://openairdocs.org/ntsb/FTW98LA059.md): Mooney M20F · Stuttgart, AR · Accident · No injuries · Limited investigation · Final report · Nov 27, 1997 · N2954L · Substantial damage
  > the pilot's failure to activate the runway lights, which led to his selection of a closed/abandoned runway for the landing. Factors relating to the accident were: the unlatched cabin door, and the lack of lighting conditions at dusk.
- [NTSB LAX98LA047](https://openairdocs.org/ntsb/LAX98LA047.md): Cessna 182F · Palmdale, CA · Accident · No injuries · Limited investigation · Final report · Nov 26, 1997 · N3543Y · Substantial damage
  > Loss of engine power due to icing conditions which plugged the fuel system vent.
- [NTSB ATL98FA017](https://openairdocs.org/ntsb/ATL98FA017.md): Mark Ewart Velocity Standard RG · Florence, SC · Accident · 4 fatal · Field investigation · Final report · Nov 26, 1997 · N907ME · Substantial damage
  > improper maintenance procedures used by the pilot/repairman, which resulted in the loosening and eventual failure of the propeller. Factors relating to the accident were: the pilot's self-imposed pressure to hurry to the destination, and trees in the forced…
- [NTSB SEA98LA017](https://openairdocs.org/ntsb/SEA98LA017.md): Bell TH-1L · Canby, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 1997 · N8160G · Substantial damage
  > The pilot's allowance of excessive airspeed resulting in the long-line hook impacting the tail rotor, and his allowance of an airspeed bleed-off preventing a successful run-on landing due to a loss of yaw control.
- [NTSB CHI98FA048](https://openairdocs.org/ntsb/CHI98FA048.md): Cessna 172E · Topeka, KS · Accident · 1 fatal · Field investigation · Final report · Nov 25, 1997 · N5332T · Substantial damage
  > the pilot's improper use of carburetor heat. Contributing factors were carburetor icing conditions, dark night conditions, and the transmission wire.
- [NTSB LAX98FA043](https://openairdocs.org/ntsb/LAX98FA043.md): Cessna 172N · La Jolla, CA · Accident · 1 fatal · Field investigation · Final report · Nov 24, 1997 · N6463D · Destroyed
  > the pilot's act of suicide by intentionally diving his aircraft into the ocean.
- [NTSB IAD98FA012](https://openairdocs.org/ntsb/IAD98FA012.md): Cessna 182A · New Dover, OH · Accident · 2 fatal · Field investigation · Final report · Nov 24, 1997 · N6068B · Destroyed
  > The pilot's attempted VFR flight into instrument conditions and the loss of aircraft ctontrol subsequent to the pilot's spatial disorientation. Contributing factors were low ceilings, snow and the pilot's failure to obtain a preflight weather briefing, as…
- [NTSB FTW98FA056](https://openairdocs.org/ntsb/FTW98FA056.md): Beech 95-B55 · Royse City, TX · Accident · 2 fatal · Field investigation · Final report · Nov 24, 1997 · N6835Q · Destroyed
  > The pilot's impairment due to drugs, and his ensuing failure to maintain minimum required airspeed for flight, which resulted in a stall/spin. A factors was the loss of power to both engines due to fuel starvation as a result of the pilot's improper use of…
- [NTSB CHI98LA046](https://openairdocs.org/ntsb/CHI98LA046.md): Luscombe 8A · Lincoln, NE · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 1997 · N71329 · Substantial damage
  > the throttle linkage coming apart in flight, and the inadvertent stall.
- [NTSB FTW98LA055](https://openairdocs.org/ntsb/FTW98LA055.md): Piper PA-32RT-300T · Midlothian, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 1997 · N21433 · Substantial damage
  > fatigue failure of the #2 cylinder fuel injection line in an area where the line was previously damaged, which resulted in an in-flight engine compartment fire and a forced landing. Related factors were: the previous damage of the fuel injector line, and the…
- [NTSB FTW98LA054](https://openairdocs.org/ntsb/FTW98LA054.md): Cessna 150M · Tajique, NM · Accident · No injuries · Limited investigation · Final report · Nov 20, 1997 · N714MN · Substantial damage
  > The loss of engine power due to carburetor ice. Factors included unsuitable terrain, and dark night conditions.
- [NTSB CHI98LA041](https://openairdocs.org/ntsb/CHI98LA041.md): Beech 95-B55 · Burlington, KS · Accident · No injuries · Limited investigation · Final report · Nov 20, 1997 · N3681K · Substantial damage
  > an undetermined event resulting in the door seal inflation pump catching fire, the pilot's failure to close the cockpit air vents allowing heat and flames from the airplane's nose section to melt electrical wiring behind the instrument panel, and the pilot…
- [NTSB CHI98LA040](https://openairdocs.org/ntsb/CHI98LA040.md): Cessna 172 · Salem, IN · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 1997 · N92042 · Substantial damage
  > the pilot's misjudgment of distance and altitude, while on final approach to land at night. Factors relating to the accident included: an undetermined electrical malfunction, inoperative flaps, darkness, the pilot not using the landing light, and the…
- [NTSB MIA98LA034](https://openairdocs.org/ntsb/MIA98LA034.md): Cessna 152 · Palatka, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 18, 1997 · N68327 · Substantial damage
  > the student pilot's failure to properly secure the oilcap/dipstick within it's integral oil filler tube during his preflight inspection.
- [NTSB MIA98LA033](https://openairdocs.org/ntsb/MIA98LA033.md): Mooney M20C · Sparta, TN · Accident · 1 fatal · Limited investigation · Final report · Nov 15, 1997 · N78952 · Substantial damage
  > The pilot's inadequate preflight and inflight decision and his inadvertent VFR flight into instrument meteorological conditions. Contributing factors are self induced pressure, mountainous terrain, and low clouds.
- [NTSB FTW98FA067](https://openairdocs.org/ntsb/FTW98FA067.md): Cessna 180 · Johnson City, TX · Accident · 1 fatal · Field investigation · Final report · Nov 14, 1997 · N20MF · Destroyed
  > The pilot's failure to maintain obstacle clearance. Factors were the low ceilings, dark night light conditions, and the pilot's lack of visible horizon in the unpopulated area.
- [NTSB CHI98LA036](https://openairdocs.org/ntsb/CHI98LA036.md): Piper PA-28-180 · Willmar, MN · Accident · No injuries · Limited investigation · Final report · Nov 13, 1997 · N8886J · Substantial damage
  > the pilot's improper planning/decision, his continued flight into known adverse weather, and subsequent fuel exhaustion, which resulted in loss of engine power, and a forced landing. Factors related to the accident were: the adverse weather conditions, the…
- [NTSB CHI98LA034](https://openairdocs.org/ntsb/CHI98LA034.md): Piper PA-28-235 · Ulysses, KS · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1997 · N9404W · Destroyed
  > the pilot's continued flight into adverse weather conditions, his failure to activate the pitot heat system, and his failure to maintain clearance from the terrain. Factors associated with this accident were: the pilot did not obtain a preflight weather…
- [NTSB LAX98LA033](https://openairdocs.org/ntsb/LAX98LA033.md): Waco YMF-5 · Sedona, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 1997 · N369DP · Destroyed
  > The failure and separation of the propeller for undetermined reasons.
- [NTSB FTW98FA044](https://openairdocs.org/ntsb/FTW98FA044.md): Piper PA-34-200T · Myton, UT · Accident · 1 fatal · Field investigation · Final report · Nov 7, 1997 · N2119D · Destroyed
  > The pilot exceeded the design stress limits of the airplane which resulted in an in-flight airframe overload failure. A related factor was the dark night.
- [NTSB CHI98LA032](https://openairdocs.org/ntsb/CHI98LA032.md): Cessna 421A · Tomahawk, WI · Accident · No injuries · Limited investigation · Final report · Nov 7, 1997 · N2957Q · Substantial damage
  > the elevator trim tab bolt backed out, allowing the trim tab to flutter, and destroy the elevator. The factors involved were improper annual inspection by the maintenance personnel, and the inadequate aircraft preflight done by the pilot.
- [NTSB ATL98FA007](https://openairdocs.org/ntsb/ATL98FA007.md): Champion 7ECA · Hamilton, GA · Accident · 1 fatal · Field investigation · Final report · Nov 6, 1997 · N9556S · Substantial damage
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Related factors were: darkness, adverse weather conditions, and the pilot's self induced pressure…

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

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