# NTSB investigations, 2000: 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 · 451 cases

## Latest cases

- [NTSB LAX01IA066](https://openairdocs.org/ntsb/LAX01IA066.md): Lockheed L-1011-385-1 · Honolulu, HI · Incident · No injuries · Incident investigation · Final report · Dec 30, 2000 · N735D · Minor damage
  > the electrical wire arcing and burning as result of insulation degradation, which more than likely resulted from improper clamping.
- [NTSB FTW01FA043](https://openairdocs.org/ntsb/FTW01FA043.md): Bell 407 · Gilchrist, TX · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2000 · N407MM · Destroyed
  > The loss of control for reasons undetermined.
- [NTSB CHI01IA055](https://openairdocs.org/ntsb/CHI01IA055.md): Embraer EMB-135LR · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Dec 28, 2000 · N721HS · No damage
  > The jammed horizontal stabilizer trim that occurred during the airplane's initial climb after takeoff. Factors relating to the incident were the inadequate capability of the horizontal stabilizer trim actuator to move the stabilizer during all flight phases,…
- [NTSB FTW01FAMS1](https://openairdocs.org/ntsb/FTW01FAMS1.md): Bell 206B · High Island 116 · Accident · 1 fatal · Missing aircraft · Final report · Dec 27, 2000 · N83137 · Destroyed
  > undetermined, missing aircraft.
- [NTSB MIA01IA051](https://openairdocs.org/ntsb/MIA01IA051.md): Canadair CL-600-2B19 · Hebron, KY · Incident · No injuries · Incident investigation · Final report · Dec 26, 2000 · N729CA · No damage
  > The inadequate design of the flight compartment windshield by the windshield manufacturer resulting in cracking of the center ply.
- [NTSB CHI01LA053](https://openairdocs.org/ntsb/CHI01LA053.md): Cessna 150M · New Underwood, SD · Accident · No injuries · Limited investigation · Final report · Dec 26, 2000 · N63067 · Substantial damage
  > The pilot's inadequate planning and preparation, which resulted in fuel exhaustion. A factor relating to this accident was the plowed field.
- [NTSB SEA01LA031](https://openairdocs.org/ntsb/SEA01LA031.md): de Havilland DHC-2 Mk. I · Kirkland, WA · Accident · No injuries · Limited investigation · Final report · Dec 22, 2000 · N2502 · Substantial damage
  > A malfunction of the aircraft's fuel selector valve and subsequent fuel starvation. Factors included a short emergency landing area, a wet landing surface, and a fence.
- [NTSB ANC01LA027](https://openairdocs.org/ntsb/ANC01LA027.md): Piper PA-31-350 · Deadhorse, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 2000 · N63MB · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were clouds, fog, dusk light conditions, and the pilot's self-induced pressure to complete the flight prior to nightfall.
- [NTSB ANC01FA026](https://openairdocs.org/ntsb/ANC01FA026.md): Curtis-Wright C46A · Kenai, AK · Accident · 2 fatal · Field investigation · Final report · Dec 20, 2000 · N1419Z · Destroyed
  > The flight crew's decision to continue VFR flight into instrument meteorological conditions. Factors associated with the accident are high winds, turbulence, and low ceilings.
- [NTSB IAD01LA020](https://openairdocs.org/ntsb/IAD01LA020.md): Cessna 172M · Medford, NJ · Accident · No injuries · Limited investigation · Final report · Dec 19, 2000 · N789FW · Substantial damage
  > The pilot's failure to attain the proper touchdown point. Factors included the loss of electrical power, the dark night, and the pilot's lack of night experience.
- [NTSB NYC01LA059](https://openairdocs.org/ntsb/NYC01LA059.md): Aerospatiale SA365-N1 · West Mifflin, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 18, 2000 · N89SM · Destroyed
  > Insufficient lubrication within the tail rotor gearbox, which resulted in the seizure of the duplex ball bearing and a fixed pitch setting of the tail rotor. Also causal, was the pilot's loss of control, which was the result of a relative low speed/high power…
- [NTSB CHI01FA052](https://openairdocs.org/ntsb/CHI01FA052.md): Beech BE-23 · Rolla, MO · Accident · 1 fatal · Field investigation · Final report · Dec 18, 2000 · N2324J · Destroyed
  > The pilot's inadequate preflight during the pre-buy inspection, the pilot's incapacitation due to carbon monoxide, and the fractured muffler.
- [NTSB DEN01FA028](https://openairdocs.org/ntsb/DEN01FA028.md): Cessna 172 · Lusk, WY · Accident · 2 fatal · Field investigation · Final report · Dec 16, 2000 · N4223F · Substantial damage
  > the pilot's VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance, which resulted in an in-flight collision with terrain. Contributing factors were the pilot's failure to obtain a weather briefing, low…
- [NTSB LAX01FA059](https://openairdocs.org/ntsb/LAX01FA059.md): Dehavilland DHC-6 · Sacramento, CA · Accident · 1 fatal · Field investigation · Final report · Dec 15, 2000 · N252SA · No damage
  > The passenger committed suicide.
- [NTSB DEN01FA027](https://openairdocs.org/ntsb/DEN01FA027.md): Mooney M20K · Ogden, UT · Accident · 1 fatal · Field investigation · Final report · Dec 15, 2000 · N5772C · Destroyed
  > the pilot's inadvertent VFR flight into IMC, which resulted in a collision with mountainous terrain. Contributing factors were the blowing snow, turbulence, dark night light conditions, and pilot fatigue due to the long flight day.
- [NTSB NYC01FA056](https://openairdocs.org/ntsb/NYC01FA056.md): Cessna 310Q · Chesterfield, NH · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2000 · N55QS · Destroyed
  > The pilot's continued flight into icing conditions, and his failure to use alternate air. A factor was the icing conditions.
- [NTSB LAX01GA057](https://openairdocs.org/ntsb/LAX01GA057.md): Cessna 182P · Lancaster, CA · Accident · 1 fatal · Final report · Dec 12, 2000 · N182ER · Destroyed
  > the pilot's in-flight loss of control for undetermined reasons.
- [NTSB ATL01LA016](https://openairdocs.org/ntsb/ATL01LA016.md): Cessna 182A · Plant City, FL · Accident · No injuries · Limited investigation · Final report · Dec 12, 2000 · N6300B · Substantial damage
  > The loss of engine power due to fuel starvation resulting from the separation of the mixture control cable from the carburetor. Factors were cows, rough and uneven terrain.
- [NTSB ANC01IA022](https://openairdocs.org/ntsb/ANC01IA022.md): Boeing 747-422 · Port Heiden, AK · Incident · Minor injuries · Incident investigation · Final report · Dec 12, 2000 · N119UA · Minor damage
  > An encounter with severe turbulence while in cruise flight. Factors in the incident were a delay in notification of the turbulence, and the lack of controller/pilot data link communications in the Anchorage ARTCC area.
- [NTSB DEN01FA021](https://openairdocs.org/ntsb/DEN01FA021.md): Piper PA-24-250 · Antimony, UT · Accident · 2 fatal · Field investigation · Final report · Dec 8, 2000 · N8245P · Destroyed
  > the pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his VFR flight into IMC, lack of instrument certification, spatial disorientation, low ceiling, and snow.
- [NTSB CHI01LA045](https://openairdocs.org/ntsb/CHI01LA045.md): Larson Aero COMP-6 · Brainerd, MN · Accident · No injuries · Limited investigation · Final report · Dec 8, 2000 · N4334Z · Substantial damage
  > The pilot's inadequate preflight of the airplane which resulted in fuel exhaustion. Factors associated with the accident were the loose fuel cap and the snow covered terrain.
- [NTSB FTW01LA032](https://openairdocs.org/ntsb/FTW01LA032.md): Smith Team Tango 2 · Dry Creek, LA · Accident · 1 fatal · Limited investigation · Final report · Dec 6, 2000 · N6204D · Destroyed
  > the pilot's VFR flight into IMC while in cruise, which resulted in his loss of control of the airplane due to spatial disorientation. Contributing factors were the clouds, and icing weather conditions, and the inadequate weather briefing.
- [NTSB NYC01LA052](https://openairdocs.org/ntsb/NYC01LA052.md): Mooney M20J · Danbury, CT · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 2000 · N4101H · Substantial damage
  > Water/ice in the fuel system and the pilot's inadequate preflight inspection.
- [NTSB NYC01FA053](https://openairdocs.org/ntsb/NYC01FA053.md): Robinson R-44A · Sandgap, KY · Accident · 3 fatal · Field investigation · Final report · Dec 5, 2000 · N744FC · Destroyed
  > the pilot's improper weather evaluation, and his failure to maintain terrain clearance while operating over unlighted terrain at night. Factors were the isolated areas of fog, and night conditions.
- [NTSB SEA01LA025](https://openairdocs.org/ntsb/SEA01LA025.md): Cessna A185F · Lynwood, WA · Accident · No injuries · Limited investigation · Final report · Dec 3, 2000 · N7609Q · Substantial damage
  > Fuel exhaustion due to refueling was not performed by the pilot-in-command. Trees and a fence were factors.
- [NTSB NYC01LA050](https://openairdocs.org/ntsb/NYC01LA050.md): Miller Slingshot · Kingwood, WV · Accident · 1 fatal · Limited investigation · Final report · Dec 3, 2000 · N97MS · Substantial damage
  > The pilot's failure to maintain control of the airplane, and subsequent collision with trees.
- [NTSB FTW01LA036](https://openairdocs.org/ntsb/FTW01LA036.md): Bell 206B · Rockport, TX · Accident · No injuries · Limited investigation · Final report · Dec 1, 2000 · N222LM · Substantial damage
  > the loss of engine power during cruise flight due to the fatigue fracture of the compressor coupling adapter. A contributing factor was the high sea condition existing for the forced landing.
- [NTSB NYC01IA046](https://openairdocs.org/ntsb/NYC01IA046.md): Mooney M20C · Hazard, KY · Incident · Minor injuries · Incident investigation · Final report · Nov 30, 2000 · N942TB · No damage
  > The incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.
- [NTSB LAX01LA047](https://openairdocs.org/ntsb/LAX01LA047.md): Wsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Kaunakakai, HI · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 2000 · N112B · Substantial damage
  > The pilot's improper assessment of in-flight weather conditions, his inadequate compensation for winds, and his failure to maintain sufficient altitude and clearance on the lee side of mountainous terrain.
- [NTSB IAD01IA017](https://openairdocs.org/ntsb/IAD01IA017.md): McDonnell Douglas DC-9-82 · Dulles, VA · Incident · No injuries · Incident investigation · Final report · Nov 29, 2000 · N3507A · Minor damage
  > the operator's inadequate maintenance procedure to disconnect the Omega navigational system, which resulted in coaxial cables being cut and not properly protected. A factor in the incident was the lightning strike.
- [NTSB DCA01MA005](https://openairdocs.org/ntsb/DCA01MA005.md): Douglas DC-9 · Atlanta, GA · Accident · Minor injuries · Major investigation · Final report · Nov 29, 2000 · N826AT · Substantial damage
  > the leakage of lavatory fluid from the airplane's forward lavatory onto electrical connectors, which caused shorting that led to a fire. Contributing to the accident were the inadequate servicing of the lavatory and the failure of maintenance to ensure…
- [NTSB NYC01LA044](https://openairdocs.org/ntsb/NYC01LA044.md): Bellanca 17-30A · Zanesville, OH · Accident · No injuries · Limited investigation · Final report · Nov 28, 2000 · N8268R · Substantial damage
  > The pilot's failure to follow the restart procedures published in the approved flight manual(AFM). Factors were his failure to follow the fuel management procedures published in the AFM, which resulted in fuel starvation.
- [NTSB FTW01LA028](https://openairdocs.org/ntsb/FTW01LA028.md): Cessna 150L · Valley Spring, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 2000 · N18609 · Substantial damage
  > the loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.
- [NTSB FTW01LA026](https://openairdocs.org/ntsb/FTW01LA026.md): Piper PA-46-310P · Gainesville, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 2000 · N9298Y · Substantial damage
  > the loss of engine power due to improper splicing of the TIT thermocouple leads by unknown persons, which led to over temperature operation of the engine due to inaccurate TIT gauge readings. Contributing factors were the manufacturer's stamp on the top of…
- [NTSB IAD01LA110](https://openairdocs.org/ntsb/IAD01LA110.md): Boeing 767 · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 2000 · EI-CRL · No damage
  > The airplane's inadvertent encounter with severe turbulence.
- [NTSB FTW01FA025](https://openairdocs.org/ntsb/FTW01FA025.md): Cessna 172N · Katy, TX · Accident · 1 fatal · Field investigation · Final report · Nov 26, 2000 · N6521D · 2 aircraft · Substantial damage
  > the failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.
- [NTSB IAD01IA019](https://openairdocs.org/ntsb/IAD01IA019.md): McDonnell Douglas MD-11 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Nov 25, 2000 · N582FE · No damage
  > a short in the left inboard elevator parallel engage solenoid valve for undetermined reasons.
- [NTSB IAD01LA016](https://openairdocs.org/ntsb/IAD01LA016.md): Bellanca BL-17-30A · Union, CT · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 2000 · N280H · Substantial damage
  > pilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel starvation.
- [NTSB DEN01LA017](https://openairdocs.org/ntsb/DEN01LA017.md): 2000 McCoy Genesis · Fort Collins, CO · Accident · 1 fatal · Limited investigation · Final report · Nov 22, 2000 · N9931W · Destroyed
  > Failure of an airframe stringer due to improper construction by the builder/pilot which rendered the aircraft uncontrollable. A factor was failure by the builder pilot to follow procedures and secure the engine prior to deploying the aircraft recovery…
- [NTSB MIA01LA032](https://openairdocs.org/ntsb/MIA01LA032.md): Piper PA-32RT-300 · Wewahitchka, FL · Accident · No injuries · Limited investigation · Final report · Nov 21, 2000 · N9658C · Substantial damage
  > a loss of engine power due to the number 5 cylinder connecting rod separating at the rod cap, resulting in a forced landing and subsequent impact with rough uneven terrain.
- [NTSB MIA01LA031](https://openairdocs.org/ntsb/MIA01LA031.md): Lake LA-4-200 · Iuka, MS · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 2000 · N65717 · Substantial damage
  > a loss of engine power due to fuel contamination resulting in fuel starvation, a forced landing and the subsequent in-flight collision with a wire.
- [NTSB MIA01LA030](https://openairdocs.org/ntsb/MIA01LA030.md): Aerospatiale ATR-72-212 · Ashevelle, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 2000 · N630AS · No damage
  > the flight encountered forecasted turbulence, which resulted in serious injury to a flight attendant. Factors in this accident were; the captain's inadequate briefing to the cabin crew; and the insufficient information about the known turbulence that would be…
- [NTSB MIA01FA029](https://openairdocs.org/ntsb/MIA01FA029.md): Airbus Industrie A300B4-605R · Miami, FL · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2000 · N14056 · Minor damage
  > The failure of the flight crew to perform the cabin pressurization manual control abnormal checklist after experiencing a pressurization system malfunction and switching to manual pressurization control, and the failure of the flight crew to perform the…
- [NTSB FTW01LA022](https://openairdocs.org/ntsb/FTW01LA022.md): Cessna 172K · Belcher, LA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2000 · N567QL · Substantial damage
  > the total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.
- [NTSB LAX01LA045](https://openairdocs.org/ntsb/LAX01LA045.md): Collette Glassair III · Guistine, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2000 · N540AK · Substantial damage
  > Maintenance personnel misrouted the crankcase breather hose so that it was pinched when the cowling was installed. This pressurized the crankcase displacing the oil seal and forcing oil out of the engine. A factor was the unsuitable terrain encountered during…
- [NTSB DEN01LA016](https://openairdocs.org/ntsb/DEN01LA016.md): Piper PA-28-140 · Wendover, UT · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 2000 · N6355R · Substantial damage
  > a forced landing to unsuitable terrain due to a loss of engine power as a result of carburetor icing. Factors were insufficient weather information regarding carburetor icing in the pilot's operating handbook for the aircraft and delay by the pilot in…
- [NTSB SEA01LA023](https://openairdocs.org/ntsb/SEA01LA023.md): Piper PA-30 · Stevensville, MT · Accident · No injuries · Limited investigation · Final report · Nov 17, 2000 · N7062Y · Substantial damage
  > Fatigue of the right propeller blade resulting in an in-flight separation of the blade tip. A contributing factor was the improper maintenance procedure.
- [NTSB SEA01FA021](https://openairdocs.org/ntsb/SEA01FA021.md): Piper PA-22-135 · Ontario, OR · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2000 · N3762A · Destroyed
  > Overstress loading to the left wing lift strut resulting in the left wing folding upward during the initial climb.
- [NTSB FTW01FA021](https://openairdocs.org/ntsb/FTW01FA021.md): Eurocopter AS350B2 · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2000 · N126TV · Destroyed
  > the pilot's failure to maintain obstacle clearance while maneuvering, which resulted in an in-flight collision with objects. Contributing factors were the dark night and low ceilings.
- [NTSB LAX01LA043](https://openairdocs.org/ntsb/LAX01LA043.md): Cessna 210K · Oxnard, CA · Accident · No injuries · Limited investigation · Final report · Nov 16, 2000 · N8118G · Substantial damage
  > Failure of the internal cam gear in the remanufactured engine. A factor was the congested obstacles in the forced landing area.

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

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