# Final NTSB investigations, 2000: 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 ANC01FAMS1](https://openairdocs.org/ntsb/ANC01FAMS1.md): Champion 8GCBC · Juneau, AK · Accident · 2 fatal · Missing aircraft · Final report · Dec 27, 2000 · N7100C · Destroyed
  > Undetermined. Missing airplane.
- [NTSB MIA01LA026](https://openairdocs.org/ntsb/MIA01LA026.md): J and J Tukan · Hayesville, NC · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 2000 · UNREG · Destroyed
  > The ultralight pilot's in-flight loss of control for unknown reasons resulting in an in-flight collision with the terrain.
- [NTSB SEA01FA017](https://openairdocs.org/ntsb/SEA01FA017.md): Cessna 425 · Idaho Falls, ID · Accident · 2 fatal · Field investigation · Final report · Nov 10, 2000 · N41054 · Substantial damage
  > The pilot-in-command's failure to maintain adequate airspeed with an asymmetric thrust condition, resulting in a loss of aircraft control. A factor was an asymmetric engine thrust condition, which was present for undetermined reasons.
- [NTSB MIA01FAMS1](https://openairdocs.org/ntsb/MIA01FAMS1.md): Cessna 150 · Missing, FL · Accident · 1 fatal · Missing aircraft · Final report · Oct 27, 2000 · N11214 · Destroyed
  > undetermined.
- [NTSB SEA01LA008](https://openairdocs.org/ntsb/SEA01LA008.md): Wildman Adventurer · Yelm, WA · Accident · 1 fatal · Limited investigation · Final report · Oct 23, 2000 · N567AW · Destroyed
  > A main rotor blade strike (impact) with both a pusher propeller blade and the rudder during an unknown phase of operation resulting in a loss of control and uncontrolled descent to terrain.
- [NTSB SEA00LA177](https://openairdocs.org/ntsb/SEA00LA177.md): Cessna 172P · Auburn, WA · Accident · No injuries · Limited investigation · Final report · Sep 3, 2000 · N531PC · Substantial damage
  > Damage to aircraft under unknown circumstances.
- [NTSB LAX00FA306](https://openairdocs.org/ntsb/LAX00FA306.md): Robinson R22 Beta · Watsonville, CA · Accident · 2 fatal · Field investigation · Final report · Aug 19, 2000 · N8313Z · Destroyed
  > The divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in mast bumping and rotor contact with the fuselage.
- [NTSB CHI00FAMS2](https://openairdocs.org/ntsb/CHI00FAMS2.md): Peters RAF 2000 · Manistique, MI · Accident · 1 fatal · Missing aircraft · Final report · Jul 29, 2000 · N11ZK · Destroyed
  > undetermined.
- [NTSB DEN00FA141](https://openairdocs.org/ntsb/DEN00FA141.md): Mooney M20K · Cheyenne, WY · Accident · 1 fatal · Field investigation · Final report · Jul 27, 2000 · N252KD · Destroyed
  > the airplane's in-flight collision with hilly terrain for undetermined reasons.
- [NTSB FTW00LA210](https://openairdocs.org/ntsb/FTW00LA210.md): Grumman-Schweizer G-164B · Ville Platte, LA · Accident · 1 fatal · Limited investigation · Final report · Jul 15, 2000 · N428KG · Destroyed
  > The loss of control for an undetermined reason.
- [NTSB SEA00LA116](https://openairdocs.org/ntsb/SEA00LA116.md): Davis/Crouch Avid MK IV · Concrete, WA · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2000 · N518DC · Substantial damage
  > Fracture of the engine's #1 connecting rod, resulting in a total loss of engine power. Factors were an engine overheat condition experienced at an undetermined time, and no suitable terrain for a forced landing.
- [NTSB FTW00LA169](https://openairdocs.org/ntsb/FTW00LA169.md): Cecil Thorp T-18 · West, TX · Accident · 1 fatal · Limited investigation · Final report · May 24, 2000 · N856CW · Destroyed
  > The loss of control for an undetermined reason.
- [NTSB ATL00LA042](https://openairdocs.org/ntsb/ATL00LA042.md): Piper PA-31-350 · Rock Hill, SC · Accident · No injuries · Limited investigation · Final report · Apr 19, 2000 · N41081 · Substantial damage
  > The maintenance personnel's failure to re-torque the engine driven fuel pump in accordance with an Airworthiness Directive that resulted in a fuel leak and a subsequent engine fire.

## 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") = 2000
  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=2000

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