# NTSB investigations, 2000: Maneuvering

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 · 281 cases

## Latest cases

- [NTSB SEA01FA032](https://openairdocs.org/ntsb/SEA01FA032.md): Hughes 369HS · Pierce, ID · Accident · 2 fatal · Field investigation · Final report · Dec 28, 2000 · N9186F · Substantial damage
  > While maneuvering, clearance from an object was not maintained. A tree was a factor.
- [NTSB FTW01LA042](https://openairdocs.org/ntsb/FTW01LA042.md): Robinson R-22B2 · Mesquite, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 2000 · N7158M · Substantial damage
  > The student pilot's abrupt control input, which resulted in a tail rotor blade strike. Factors were the CFI's delay in taking remedial action and the student pilot's lack of total experience.
- [NTSB DEN01LA029](https://openairdocs.org/ntsb/DEN01LA029.md): Cessna 172E · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Dec 16, 2000 · N96024 · Substantial damage
  > the lack of suitable terrain for a forced landing. A factor was a total power loss due to a connecting rod failure.
- [NTSB MIA01FA043](https://openairdocs.org/ntsb/MIA01FA043.md): Piper PA-31-325 · Belvidere, NC · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2000 · N120JB · Destroyed
  > The pilot's failure to maintain airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions resulting in the airplane entering a descending turn and crashing into terrain.
- [NTSB MIA01FA041](https://openairdocs.org/ntsb/MIA01FA041.md): Christen Industries Pitts S-2B · Weston, FL · Accident · 2 fatal · Field investigation · Final report · Dec 14, 2000 · N260DB · Substantial damage
  > An inflight loss of control by both pilots while maneuvering, which resulted in an inverted flat spin, an uncontrolled descent, and an impact with terrain/water. A factor contributing to the accident was the failure of both pilots to ensure that the…
- [NTSB LAX01LA052](https://openairdocs.org/ntsb/LAX01LA052.md): Cessna 172H · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 2000 · N4959R · Substantial damage
  > The pilot's inadequate preflight planning and weather evaluation that resulted in the inadvertant entry into instrument meteorological conditions while conducting visual flight. A factor was fog and the night visual conditions.
- [NTSB MIA01LA039](https://openairdocs.org/ntsb/MIA01LA039.md): Robinson R22 · Marathon, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 2000 · N411MJ · Destroyed
  > The certified flight instructors disregard of an FAA weather forecast stating VFR flight not recommended resulting in VFR flight into known instrument flight conditions, loss of aircraft control due to spatial disorientation, and subsequent in-flight descent…
- [NTSB SEA01LA029](https://openairdocs.org/ntsb/SEA01LA029.md): Kaman K-1200 · Prineville, OR · Accident · No injuries · Limited investigation · Final report · Dec 10, 2000 · N317KA · Substantial damage
  > The pilot's failure to adequately compensate for wind conditions.
- [NTSB MIA01LA037](https://openairdocs.org/ntsb/MIA01LA037.md): Air Tractor AT-502B · Belle Glade, FL · Accident · No injuries · Limited investigation · Final report · Dec 6, 2000 · N50470 · Substantial damage
  > The pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with known wires along the swath run, and a loss of directional control on landing roll due to flight control damage sustained during the in-flight…
- [NTSB DEN01TA019](https://openairdocs.org/ntsb/DEN01TA019.md): Hughes 369D · Montrose, CO · Accident · No injuries · Final report · Dec 6, 2000 · N411SM · Destroyed
  > the foreign object damage to a main rotor blade, while maneuvering.
- [NTSB CHI01FA044](https://openairdocs.org/ntsb/CHI01FA044.md): Beech 95-B55 · Milltown, WI · Accident · 2 fatal · Field investigation · Final report · Dec 3, 2000 · N7678N · Substantial damage
  > The flight instructor's inadequate supervision of the flight, the flightcrew not maintaining control of the airplane, and the flight instructor's delayed remedial action which resulted in the inadvertent spin. Factors to the accident were the inadvertent spin…
- [NTSB DEN01FA018](https://openairdocs.org/ntsb/DEN01FA018.md): Cessna 182P · Taos, NM · Accident · 2 fatal · Field investigation · Final report · Nov 30, 2000 · N21390 · Destroyed
  > the pilot's failure to maintain terrain clearance while maneuvering in a narrow canyon. Contributing factors were the down slope winds in excess of 50 knots and the pilot's improper decision to enter the canyon given the wind conditions.
- [NTSB FTW01LA029](https://openairdocs.org/ntsb/FTW01LA029.md): Landes/Karich/Schmidt Christen Eagle II · Tyler, TX · Accident · 2 fatal · Limited investigation · Final report · Nov 28, 2000 · N83007 · Substantial damage
  > the pilot's performance of aerobatic maneuvers at a low altitude and his failure to maintain terrain clearance.
- [NTSB NYC01FA040](https://openairdocs.org/ntsb/NYC01FA040.md): Mooney M20K · Rixford, PA · Accident · 3 fatal · Field investigation · Final report · Nov 26, 2000 · N252MW · Destroyed
  > The pilot's loss of control of the airplane while maneuvering. Factors included low ceilings and the pilot's lack of instrument flight experience.
- [NTSB SEA01LA024](https://openairdocs.org/ntsb/SEA01LA024.md): Bell 206 B3 · Lake Kachess, WA · Accident · No injuries · Limited investigation · Final report · Nov 23, 2000 · N2062D · Substantial damage
  > The pilot's failure to comply with the flight manual regarding the use of an induction system deflector kit (snow baffles) while operating in snow, and the ingestion of foreign material/snow that resulted in an engine flameout while hovering. A snow baffle…
- [NTSB FTW01FA023](https://openairdocs.org/ntsb/FTW01FA023.md): Hall Glasair III · Gilmer, TX · Accident · 1 fatal · Field investigation · Final report · Nov 22, 2000 · N462SH · Destroyed
  > the pilot's performance of aerobatic maneuvers at a low altitude and his failure to maintain aircraft control. A contributing factor was the pilot's lack of aerobatic experience.
- [NTSB SEA01FA100](https://openairdocs.org/ntsb/SEA01FA100.md): Cessna U206F · Cambridge, ID · Accident · 2 fatal · Field investigation · Final report · Nov 16, 2000 · N8529Q · Destroyed
  > Airspeed not maintained and an inadvertent stall while maneuvering. Mountainous terrain was a factor.
- [NTSB MIA01FA028](https://openairdocs.org/ntsb/MIA01FA028.md): Lockheed-Martin F-16CG · Bradenton, FL · Accident · 1 fatal · Field investigation · Final report · Nov 16, 2000 · USAF · 2 aircraft · Destroyed
  > the failure of the F-16 flight lead pilot and F-16 accident pilot to maintain an adequate visual lookout while maneuvering. Factors contributing to the accident were: the F-16 flight lead pilot’s decision to discontinue radar traffic advisory service, the…
- [NTSB LAX01LA041](https://openairdocs.org/ntsb/LAX01LA041.md): Experimental Glasair 1RG · Temecula, CA · Accident · 2 fatal · Limited investigation · Final report · Nov 15, 2000 · N41AL · Destroyed
  > the pilot's failure to maintain an adequate terrain clearance altitude while performing aerobatic maneuvers, which resulted in the in-flight collision with terrain.
- [NTSB DEN01FA013](https://openairdocs.org/ntsb/DEN01FA013.md): Cessna 175 · Hanksville, UT · Accident · 1 fatal · Field investigation · Final report · Nov 12, 2000 · N7360M · Destroyed
  > the pilot's failure to maintain control of the airplane while maneuvering at low altitude, and his physical impairment due to alcohol and drugs. A contributing factor was the downdraft.
- [NTSB ANC01LA020](https://openairdocs.org/ntsb/ANC01LA020.md): Eurocopter AS-350B2 · Girdwood, AK · Accident · No injuries · Limited investigation · Final report · Nov 11, 2000 · N216EH · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance from terrain. A factor in the accident was flat light conditions.
- [NTSB NYC01LA029](https://openairdocs.org/ntsb/NYC01LA029.md): Cessna 177B · Prosperity, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2000 · N35241 · Substantial damage
  > The failure of the dual magneto ignition system points to open.
- [NTSB FTW01FA015](https://openairdocs.org/ntsb/FTW01FA015.md): Beech BE-76 · Tulsa, OK · Accident · 2 fatal · Field investigation · Final report · Oct 31, 2000 · N23823 · Destroyed
  > the instructor pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around, which resulted in his loss of control of the airplane. Contributory factors were the engine fire, the pilot's failure to follow the…
- [NTSB SEA01LA011](https://openairdocs.org/ntsb/SEA01LA011.md): Cessna 172 · Conconully, WA · Accident · Minor injuries · Limited investigation · Final report · Oct 30, 2000 · CGDNN · Destroyed
  > The pilot's failure to maintain clearance from the trees while flying at a very low altitude in mountainous/hilly terrain. Factors include, forested mountainous/hilly terrain, flight at a very low altitude, and an encounter with a downdraft.
- [NTSB LAX01LA029](https://openairdocs.org/ntsb/LAX01LA029.md): Piper PA-28-140 · Gorman, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 30, 2000 · N16503 · Substantial damage
  > the pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. A contributing factor was the pilot's use of impairing medications.
- [NTSB FTW01FA014](https://openairdocs.org/ntsb/FTW01FA014.md): Cessna 150L · Rockport, TX · Accident · 1 fatal · Field investigation · Final report · Oct 26, 2000 · N6968G · Destroyed
  > the loss of engine power for undetermined reasons, and the pilot's subsequent failure to maintain control of the airplane during the ensuing forced landing.
- [NTSB LAX01FA024](https://openairdocs.org/ntsb/LAX01FA024.md): Cessna 152 · Alpine, CA · Accident · 2 fatal · Field investigation · Final report · Oct 24, 2000 · N24961 · Destroyed
  > The pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.
- [NTSB NYC01LA022](https://openairdocs.org/ntsb/NYC01LA022.md): Howard Weedhopper · Fordsville, KY · Accident · Serious injuries · Limited investigation · Final report · Oct 22, 2000 · UNREG · Substantial damage
  > An engine failure for undetermined reasons and the pilot's low altitude flight.
- [NTSB FTW01LA012](https://openairdocs.org/ntsb/FTW01LA012.md): Cessna 188B · Stanton, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 2000 · N53211 · Destroyed
  > The failure of the pilot to maintain clearance with the power lines, while maneuvering during an aerial application flight.
- [NTSB CHI01FA017](https://openairdocs.org/ntsb/CHI01FA017.md): Beech 95-C55 · Homer, NE · Accident · 2 fatal · Field investigation · Final report · Oct 19, 2000 · N782B · Destroyed
  > The inadequate remedial action the flightcrew had during the stall recovery maneuver and the flight instructor's inadequate supervision. A factor was the intentional stall the flightcrew was performing.
- [NTSB FTW01LA011](https://openairdocs.org/ntsb/FTW01LA011.md): Air Tractor AT-301 · Littlefield, TX · Accident · 1 fatal · Limited investigation · Final report · Oct 18, 2000 · N3165G · Destroyed
  > the pilot's failure to maintain clearance with a guy wire while maneuvering during an aerial application flight.
- [NTSB DEN01LA004](https://openairdocs.org/ntsb/DEN01LA004.md): Cessna 172N · Jensen, UT · Accident · Serious injuries · Limited investigation · Final report · Oct 15, 2000 · N738CW · Substantial damage
  > an undershoot due to misjudging distance/altitude during an emergency landing. Factors were: inadequate preflight, failure to refuel, fuel exhaustion, operating with an inoperative fuel gauge, and failure to attain a proper glide path during approach.
- [NTSB MIA01FA004](https://openairdocs.org/ntsb/MIA01FA004.md): Robinson R-22 · Pembroke Pines, FL · Accident · 2 fatal · Field investigation · Final report · Oct 14, 2000 · N4004J · Destroyed
  > The pilot's failure to maintain rotor rpm and the proper rate of descent during a forced landing/autorotation resulting in an in-flight collision with terrain. Contributing to the accident was a loss of engine power due to the failure of the No. 3 exhaust…
- [NTSB FTW01FA003](https://openairdocs.org/ntsb/FTW01FA003.md): Beech B19 · Umbarger, TX · Accident · 1 fatal · Field investigation · Final report · Oct 12, 2000 · N5108R · Destroyed
  > The pilot's loss of control due to spatial disorientation. Contributing factors were the low ceilings, the dark night illumination, the lack of visual cues, and the pilot's lack of instrument flight qualification or experience.
- [NTSB DEN01LA002](https://openairdocs.org/ntsb/DEN01LA002.md): Hughes 369FF · Baggs, WY · Accident · Serious injuries · Limited investigation · Final report · Oct 10, 2000 · N82638 · Substantial damage
  > impact with terrain following a total loss of engine power due to fatigue failure of the turbine-to-compressor coupling. A contributing factor was the unsuitable terrain for a forced landing.
- [NTSB SEA01FA001](https://openairdocs.org/ntsb/SEA01FA001.md): Cessna 208B · Lummi Island, WA · Accident · 1 fatal · Field investigation · Final report · Oct 9, 2000 · N941FE · Substantial damage
  > The pilot's attempted flight into known adverse weather conditions, and his subsequent failure to maintain altitude above, or clearance with, trees. Factors contributing to the accident included low ceilings, fog, the pilot's low-altitude flight, rising…
- [NTSB LAX01LA002](https://openairdocs.org/ntsb/LAX01LA002.md): Robinson R22 Beta · Long Beach, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 2000 · N8340N · Substantial damage
  > The dual student's improper use of the collective and the flight instructor's inadequate supervision during the practice hovering autorotation maneuver. A factor was the underlying soft dirt terrain, which promoted the rollover event.
- [NTSB CHI01FA001](https://openairdocs.org/ntsb/CHI01FA001.md): Piper PA-44-180 · Rapid City, SD · Accident · 1 fatal · Field investigation · Final report · Oct 3, 2000 · N294ND · Destroyed
  > Suicide
- [NTSB DEN00FA182](https://openairdocs.org/ntsb/DEN00FA182.md): Sukhoi SU-26MX · Telluride, CO · Accident · 1 fatal · Field investigation · Final report · Sep 30, 2000 · N26KP · Destroyed
  > the pilot's failure to maintain aircraft control while maneuvering, and the subsequent inadvertent stall/spin to the ground. A contributing factor was the high density altitude weather condition.
- [NTSB FTW00LA270](https://openairdocs.org/ntsb/FTW00LA270.md): Cessna 188B · Stanton, TX · Accident · 1 fatal · Limited investigation · Final report · Sep 29, 2000 · N4983Q · Destroyed
  > The pilot's failure to maintain clearance from guy wires and tower.
- [NTSB SEA00LA193](https://openairdocs.org/ntsb/SEA00LA193.md): Hughes 269B · Laurel, MT · Accident · No injuries · Limited investigation · Final report · Sep 27, 2000 · N9503F · Substantial damage
  > Failure to maintain aircraft control during hover operations. Inadequate remedial action by the pilot was a factor.
- [NTSB SEA00LA192](https://openairdocs.org/ntsb/SEA00LA192.md): Air Tractor AT-602 · Columbia River, WA · Accident · No injuries · Limited investigation · Final report · Sep 27, 2000 · N5111A · Substantial damage
  > Clearance from a transmission power line was not maintained. The power line was a factor.
- [NTSB FTW00FA268](https://openairdocs.org/ntsb/FTW00FA268.md): Cessna 152 · Navasota, TX · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2000 · N5357M · Destroyed
  > the pilot's failure to maintain control of the airplane due to spatial disorientation. Contributory factors were the clouds, dark night light conditions, the pilot's lack of total instrument flight time, and the pilot's self-induced pressure to complete the…
- [NTSB SEA00LA188](https://openairdocs.org/ntsb/SEA00LA188.md): Hughes 269B · Burlington, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 2000 · N9355F · Substantial damage
  > Mintenance personnel not following the mandatory service bulletin procedure of not exceeding 0.0005 inch paint thickness on the cylinder flange. Factors were the fatigue separation of multiple cylinder hold down bolts resulting in looseness of the cylinder;…
- [NTSB SEA00LA186](https://openairdocs.org/ntsb/SEA00LA186.md): de Havilland DH-100 MK.6 · Ontario, OR · Accident · 1 fatal · Limited investigation · Final report · Sep 23, 2000 · N152RD · Destroyed
  > The pilot's failure to maintain adequate airspeed during low-altitude maneuvering flight, resulting in an accelerated stall and spin. A factor was the pilot's intentional low-altitude maneuvering flight.
- [NTSB LAX00FA347](https://openairdocs.org/ntsb/LAX00FA347.md): Cessna 207A · Valle, AZ · Accident · Minor injuries · Field investigation · Final report · Sep 23, 2000 · N9439M · Substantial damage
  > Improper maintenance and adjustment of the engine magnetos resulting in a loss of optimum performance during a critical takeoff that required peak engine performance.
- [NTSB FTW00LA269](https://openairdocs.org/ntsb/FTW00LA269.md): Robinson R-22B · Tomball, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 23, 2000 · N7183X · Substantial damage
  > The student pilot's abrupt lowering of the collective. Factors were the student pilot's lack of experience in helicopters and the CFI's delayed remedial action.
- [NTSB ANC00LA132](https://openairdocs.org/ntsb/ANC00LA132.md): Eurocopter AS-350B-3 · Ketchikan, AK · Accident · No injuries · Limited investigation · Final report · Sep 23, 2000 · N405AE · Substantial damage
  > The pilot's inadvertent activation of the collective flight stop/emergency fuel augmentation switch, which resulted in engine and main rotor overspeeds, thereby precipitating failures of the tail rotor drive shaft coupling and power turbine blades. A factor…
- [NTSB LAX00LA345](https://openairdocs.org/ntsb/LAX00LA345.md): Grumman-Schweizer G-164B · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Sep 22, 2000 · N8981H · Substantial damage
  > Loss of engine power due to failure and separation of the number one connecting rod.
- [NTSB FTW00LA267](https://openairdocs.org/ntsb/FTW00LA267.md): PZL-Mielec M-18A · Jacksonville, AR · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 2000 · N81548 · Substantial damage
  > the corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight. A factor was the failure of the operator to perform the recommended wing attachment fitting inspection.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?year=2000&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") = 2000
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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