# NTSB investigations, 1997: Unknown

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.

## Latest cases

- [NTSB LAX98FA064](https://openairdocs.org/ntsb/LAX98FA064.md): Piper PA-11 · Willow Beach, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1997 · N5532H · Destroyed
  > The pilot's failure to maintain control of the aircraft for undetermined reasons.
- [NTSB CHI98LA126](https://openairdocs.org/ntsb/CHI98LA126.md): Cessna 177 · Ft. Leonardwood, MO · Accident · 1 fatal · Limited investigation · Final report · Dec 29, 1997 · N30255 · Destroyed
  > The pilot's failure to maintain adequate obstacle clearance and his inadequate inflight decision which resulted in VFR flight in to instrument meteorological conditions. The pilot's overconfidence in his ability is a contributing factor.
- [NTSB MIA98FAMS1](https://openairdocs.org/ntsb/MIA98FAMS1.md): Beech G35 · Missing · Accident · 2 fatal · Missing aircraft · Final report · Dec 3, 1997 · N4404D · Destroyed
  > undetermined.
- [NTSB ANC98LA001](https://openairdocs.org/ntsb/ANC98LA001.md): Piper PA-22-160 · Sterling, AK · Accident · 1 fatal · Limited investigation · Final report · Oct 3, 1997 · N8955D · Destroyed
  > Undetermined.
- [NTSB MIA97FA248](https://openairdocs.org/ntsb/MIA97FA248.md): Bell 47G · Saluda, SC · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1997 · N70747 · Destroyed
  > in-flight collision with a tree, for undetermined reason(s).
- [NTSB CHI97FA308](https://openairdocs.org/ntsb/CHI97FA308.md): Piper PA-28-235 · St. Ignaces, MI · Accident · 2 fatal · Field investigation · Final report · Sep 14, 1997 · N9399W · Destroyed
  > The noninstrument-rated pilot's improper decision to depart in instrument meteorological conditions, which resulted in impact with terrain.
- [NTSB CHI97FA248](https://openairdocs.org/ntsb/CHI97FA248.md): Valley Adventurers Adventurer 333 · Fond Du Lac, WI · Accident · 1 fatal · Field investigation · Final report · Aug 5, 1997 · N323VA · Destroyed
  > The kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…
- [NTSB MIA97IA206](https://openairdocs.org/ntsb/MIA97IA206.md): McDonnell Douglas DC-8-61 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Jul 5, 1997 · N27UA · Minor damage
  > failure of the right main landing gear cylinder due to stress corrosion.
- [NTSB SEA97LA157](https://openairdocs.org/ntsb/SEA97LA157.md): Cessna 172M · UT · Accident · No injuries · Limited investigation · Final report · Jul 1, 1997 · N4395R · Substantial damage
  > Undetermined.
- [NTSB MIA97LA202](https://openairdocs.org/ntsb/MIA97LA202.md): DFL Holdings Tango · Keystone, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 1997 · N772T · Destroyed
  > an in-flight loss of control for undetermined reasons.
- [NTSB ANC97FAMS1](https://openairdocs.org/ntsb/ANC97FAMS1.md): Cessna 182F · Talkeetna, AK · Accident · 4 fatal · Missing aircraft · Final report · Jun 29, 1997 · N3186U · Destroyed
  > Undetermined.
- [NTSB SEA97FA148](https://openairdocs.org/ntsb/SEA97FA148.md): Beech 77 · Cottage Grove, OR · Accident · 2 fatal · Field investigation · Final report · Jun 21, 1997 · N6630C · Substantial damage
  > Fuel exhaustion resulting from the pilot's inadequate preflight planning/preparation and his failure to maintain adequate airspeed during a forced landing approach, resulting in a stall. A related factor was the pilot's failure to refuel.
- [NTSB CHI97LA163](https://openairdocs.org/ntsb/CHI97LA163.md): Siefert 5151RG · Shelbyville, IN · Accident · 1 fatal · Limited investigation · Final report · Jun 10, 1997 · N81728 · Destroyed
  > the cause of the accident is undetermined.
- [NTSB CHI97FAMS2](https://openairdocs.org/ntsb/CHI97FAMS2.md): Beech 95-C55 · Grand Haven, MI · Accident · 2 fatal · Missing aircraft · Final report · Apr 21, 1997 · N242BS · Destroyed
  > undetermined.
- [NTSB MIA97LA125](https://openairdocs.org/ntsb/MIA97LA125.md): McDonnell Douglas DC10-30F · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Apr 9, 1997 · N310FE · Substantial damage
  > A stall buffet or a high speed buffet event which occurred at an undetermined time.
- [NTSB LAX97FAMS2](https://openairdocs.org/ntsb/LAX97FAMS2.md): Piper PA-28-161 · Avalon, CA · Accident · 1 fatal · Missing aircraft · Final report · Feb 11, 1997 · N8436X · Destroyed
  > undetermined.

## 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 = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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