# Final NTSB investigations, 2002: 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 LAX03FAMS1](https://openairdocs.org/ntsb/LAX03FAMS1.md): Piper PA-34-200T · Pacific Ocean (Pacific Ocean) · Accident · 1 fatal · Missing aircraft · Final report · Dec 15, 2002 · N101YK · Destroyed
  > undetermined, missing aircraft.
- [NTSB ANC03LA022](https://openairdocs.org/ntsb/ANC03LA022.md): Cessna 180 · Petersburg, AK · Accident · 1 fatal · Limited investigation · Final report · Dec 13, 2002 · N9701G · Destroyed
  > An in flight collision with ocean water for an undetermined reason.
- [NTSB CHI03FAMS1](https://openairdocs.org/ntsb/CHI03FAMS1.md): Cessna 175 · MI · Accident · 2 fatal · Missing aircraft · Final report · Nov 11, 2002 · N7091M · Substantial damage
  > Undetermined. Missing aircraft.
- [NTSB MIA03LA012](https://openairdocs.org/ntsb/MIA03LA012.md): Piper PA-46-350P · Memphis, TN · Accident · 2 fatal · Limited investigation · Final report · Nov 3, 2002 · N167MA · Destroyed
  > The cause of the accident is unknown as the airplane has not been located. A finding in the investigation was the fact that the pilot conducted an unstabilized approach; the flight was right, left, then right of the final approach course during the approach…
- [NTSB MIA02FAMS3](https://openairdocs.org/ntsb/MIA02FAMS3.md): Piper PA-36-300 · Missing · Accident · 1 fatal · Missing aircraft · Final report · Sep 6, 2002 · N59684 · Destroyed
  > The falure of the pilot to arrive at the intended destination for undetermined reasons. A finding in the investigation was the fact that clouds with tops to 44,000 feet were noted 38 miles south of the airplane's last position.
- [NTSB ANC02FA070](https://openairdocs.org/ntsb/ANC02FA070.md): Zawada Super Cuby · Cantwell, AK · Accident · 2 fatal · Field investigation · Final report · Jul 4, 2002 · N43Z · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall, and subsequent collision with terrain. A contributing factor was the pilot's impairment from the effects of prescription painkilling drugs.
- [NTSB SEA02LA098](https://openairdocs.org/ntsb/SEA02LA098.md): Unknown Quicksilver MX II · Cook, WA · Accident · 1 fatal · Limited investigation · Final report · Jun 9, 2002 · UNREG · Substantial damage
  > Failure to maintain aircraft control. High winds were a factor.
- [NTSB CHI02FA140](https://openairdocs.org/ntsb/CHI02FA140.md): Schutte Ms. Ryan Special · Anderson, IN · Accident · 1 fatal · Field investigation · Final report · May 23, 2002 · N827CM · Destroyed
  > The pilot's failure to properly install the canard attach bolts prior to the flight and the resulting inflight separation of the canard.
- [NTSB FTW02LA134](https://openairdocs.org/ntsb/FTW02LA134.md): Robinson Tierra II · Hooker, OK · Accident · 1 fatal · Limited investigation · Final report · May 1, 2002 · N3960D · Destroyed
  > the loss of control for an undetermined reason, which resulted in an in-flight collision with terrain.

## 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") = 2002
  AND c."completionStatus" = 'Completed'
  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?status=final&year=2002

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
