# NTSB investigations, 2000: Approach

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

## Latest cases

- [NTSB DEN01IA036](https://openairdocs.org/ntsb/DEN01IA036.md): McDonnell Douglas MD-90-30 · Salt Lake City, UT · Incident · No injuries · Incident investigation · Final report · Dec 30, 2000 · N909DA · Minor damage
  > the captain's failure to maintain the proper glide path. Contributing factors were the weather conditions that included low visibility and fog.
- [NTSB FTW01LA041](https://openairdocs.org/ntsb/FTW01LA041.md): Beech BE-60 · Addison, TX · Accident · No injuries · Limited investigation · Final report · Dec 25, 2000 · N53444 · Substantial damage
  > The pilot's misjudged flare of the airplane resulting from restricted forward visibility. Factors were the pilot's continued flight into known adverse weather conditions, the icing conditions, and the iced windshield.
- [NTSB DEN01LA034](https://openairdocs.org/ntsb/DEN01LA034.md): Barackman Vans RV-6 · Springfield, CO · Accident · No injuries · Limited investigation · Final report · Dec 24, 2000 · N3891P · Substantial damage
  > Total failure of the right hand flap control rod due to construction procedures/directives not being followed by the builder.
- [NTSB DEN01FA033](https://openairdocs.org/ntsb/DEN01FA033.md): Beech V35B · Albuquerque, NM · Accident · 2 fatal · Field investigation · Final report · Dec 24, 2000 · N2174L · Substantial damage
  > the pilot's failure to maintain aircraft control and the inadvertent stall. Factors contributing to the accident were the pilot's improper in-flight planning, his lack of recent flying experience, and the abrupt maneuver to correct to the proper runway.
- [NTSB LAX01LA064](https://openairdocs.org/ntsb/LAX01LA064.md): Cessna 140 · Bakersfield, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 23, 2000 · N72970 · Substantial damage
  > The pilot's inadequate in-flight planning, fuel management, and inadequate remedial actions, which resulted in a total loss of engine power due to fuel starvation. The pilot made an off-field landing and collided with a fence.
- [NTSB NYC01FA058](https://openairdocs.org/ntsb/NYC01FA058.md): Beech B200 · Rangeley, ME · Accident · 2 fatal · Field investigation · Final report · Dec 22, 2000 · N30EM · Destroyed
  > The pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…
- [NTSB LAX01LA063](https://openairdocs.org/ntsb/LAX01LA063.md): Bell 206-L3 · Wilcox, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 2000 · N288JB · Substantial damage
  > The pilot's incapacitation that resulted from nausea during the final approach to landing. The pilot collapsed on the cyclic, which precipitated inadvertent contact between the main rotor blades and the ground. Factors were hilly terrain on a dark night,…
- [NTSB LAX01LA062](https://openairdocs.org/ntsb/LAX01LA062.md): Cessna 177RG · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · Dec 21, 2000 · N2102Q · Substantial damage
  > A loss of engine power for undetermined reasons during an extended downwind leg in the landing pattern.
- [NTSB CHI01LA050](https://openairdocs.org/ntsb/CHI01LA050.md): Beech 58 · Huntingburg, IN · Accident · No injuries · Limited investigation · Final report · Dec 18, 2000 · N4558S · Substantial damage
  > The proper touchdown point not obtained/maintained by the pilot. Factors were the snow covered runway, the ice contaminated windshield, and the airport snow removal performed by the driver of the vehicle.
- [NTSB FTW01LA039](https://openairdocs.org/ntsb/FTW01LA039.md): Robinson R22 · Sunnyvale, TX · Accident · No injuries · Limited investigation · Final report · Dec 17, 2000 · N7187W · Substantial damage
  > The flight instructor's inadequate supervision of his student and his failure to maintain control of the helicopter. Factors were the student pilot allowing the airspeed and main rotor RPM to get too low during the simulated emergency.
- [NTSB CHI01LA048](https://openairdocs.org/ntsb/CHI01LA048.md): Socata TBM 700 · Harrisburg, IL · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 2000 · N45PM · Substantial damage
  > The pilot not attaining the proper glidepath on the instrument approach. The pilot's decision not to fly to an alternate airport and his decision to continue the approach in weather conditions below the published minimums were contributing factors.
- [NTSB LAX01FA055](https://openairdocs.org/ntsb/LAX01FA055.md): Cessna TR182 · Petaluma, CA · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2000 · N739HB · Destroyed
  > The pilot's improper IFR procedure, failure to maintain course alignment, and use of a nonapproved handheld GPS receiver for navigation during flight in actual instrument meteorological conditions. Factors contributing to the accident were the low clouds and…
- [NTSB FTW01FA033](https://openairdocs.org/ntsb/FTW01FA033.md): Cessna 421B · Norman, OK · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2000 · N52KL · Destroyed
  > the pilot's failure to follow the instrument approach procedure and his continued descent below the prescribed minimum descent altitude (MDA). Contributory factors were the pilot's physical impairment from drugs, the low ceiling, fog, and dark night light…
- [NTSB NYC01LA057](https://openairdocs.org/ntsb/NYC01LA057.md): Mooney M-20J · Trenton, NJ · Accident · No injuries · Limited investigation · Final report · Dec 9, 2000 · N201MP · Substantial damage
  > The flight instructor's improper decision to allow his student to land in close proximity to a hovering helicopter.
- [NTSB LAX01FA049](https://openairdocs.org/ntsb/LAX01FA049.md): Beech BE-55-D55 · Clifton, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2000 · N7901R · Destroyed
  > the pilot's improper in-flight decision to attempt a landing on an unlit runway at night, and his failure to maintain the proper glide path and clearance from obstacles while on final approach, which resulted in the collision with a utility pole. A…
- [NTSB CHI01FA043](https://openairdocs.org/ntsb/CHI01FA043.md): Piper PA-28R-180 · Danville, IL · Accident · 4 fatal · Field investigation · Final report · Nov 27, 2000 · N4541J · Destroyed
  > The pilot's failure to maintain altitude/clearance during the instrument approach. Factors were the low ceilings, the pilot's failure to maintain proper alignment and glidepath during the approach, his lack of recent instrument experience, and his failure to…
- [NTSB FTW01FA024](https://openairdocs.org/ntsb/FTW01FA024.md): Piper PA-28-180 · Stillwater, OK · Accident · 1 fatal · Field investigation · Final report · Nov 23, 2000 · N3988R · Destroyed
  > the pilot's failure to maintain altitude/clearance from terrain while performing an instrument approach. Contributing factors were the low ceiling, dark night light condition, the pilot's decision to fly in known adverse weather conditions, and his lack of an…
- [NTSB FTW01FA020](https://openairdocs.org/ntsb/FTW01FA020.md): Cessna 185F · Jena, LA · Accident · 1 fatal · Field investigation · Final report · Nov 15, 2000 · N6232E · Destroyed
  > The pilot's decision to land on a highway with vehicle traffic and obstacles and his failure to maintain proper clearance from the obstacles.
- [NTSB ATL01LA010](https://openairdocs.org/ntsb/ATL01LA010.md): Beech BE-23 · Everglades City, FL · Accident · No injuries · Limited investigation · Final report · Nov 15, 2000 · N2334J · Substantial damage
  > The pilot's failure to maintain control of the aircraft during landing.
- [NTSB LAX01LA039](https://openairdocs.org/ntsb/LAX01LA039.md): Messerschmitt-Boelkow-Blohm BO-105CBS-5 · Parumph, NV · Accident · No injuries · Limited investigation · Final report · Nov 14, 2000 · N911VH · Substantial damage
  > The pilot's failure to verify the presence of wires near the remote landing site during the high reconnaissance, and his misjudgement of the clearance from the ground during the attempted hovering turn to avoid the wire obstacle. Factors were the dark night…
- [NTSB NYC01LA036](https://openairdocs.org/ntsb/NYC01LA036.md): Cessna 172L · Winchester, VA · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 2000 · N2843Q · Substantial damage
  > The pilot's failure to obtain a pre-departure or en route weather briefing, which led to fuel exhaustion, after his destination and alternate airports were covered by fog. A factor was the fog.
- [NTSB CHI01LA033](https://openairdocs.org/ntsb/CHI01LA033.md): Saab 340-B · Aberdeen, SD · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2000 · N402XJ · Substantial damage
  > the impact with the flock of snow geese.
- [NTSB ANC01LA016](https://openairdocs.org/ntsb/ANC01LA016.md): Piper PA-32-260 · Lime Village, AK · Accident · No injuries · Limited investigation · Final report · Nov 9, 2000 · N4803S · Substantial damage
  > The pilot's failure to properly utilize carburetor heat. Factors in the accident were the presence of carburetor icing conditions, and unsuitable terrain for a forced landing.
- [NTSB NYC01LA032](https://openairdocs.org/ntsb/NYC01LA032.md): Navion A · Lumberton, NJ · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 2000 · N675JM · Substantial damage
  > The pilot's misjudgment of altitude and distance to the runway while performing a forced landing after an engine failure. Factors related to the accident were the pilot's inadequate rebuilding procedures and maintenance inspection, which resulted in…
- [NTSB DEN01LA011](https://openairdocs.org/ntsb/DEN01LA011.md): Cessna 152 · Roswell, NM · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 2000 · N95262 · Substantial damage
  > the flight instructor's failure to adequately preflight the airplane, which resulted in the loss of engine power due to fuel exhaustion. A contributing factor was the dark night light condition.
- [NTSB LAX01FA032](https://openairdocs.org/ntsb/LAX01FA032.md): Cessna 340A · Selma, CA · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2000 · N12273 · Destroyed
  > The pilot's improper decision to attempt a visual approach and landing in instrument meteorological conditions and his failure to follow instrument flight rules procedures.
- [NTSB LAX01LA033](https://openairdocs.org/ntsb/LAX01LA033.md): Piper PA-28-140 · Livermore, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 2000 · N9986W · Substantial damage
  > The pilot's lack of familiarity with the airplane's fuel system. This lead to the pilot inadvertently switching the fuel selector handle to the "OFF" position and subsequently to a loss of engine power due to fuel starvation.
- [NTSB MIA01LA023](https://openairdocs.org/ntsb/MIA01LA023.md): Piper PA-34-200 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Nov 3, 2000 · N1519T · Substantial damage
  > The CFI's inadequate supervision of the dual student and the dual student's loss of directional control during landing.
- [NTSB CHI01FA026](https://openairdocs.org/ntsb/CHI01FA026.md): Luscombe 8A · Des Moines, IA · Accident · 1 fatal · Field investigation · Final report · Nov 3, 2000 · N71134 · Destroyed
  > The pilot not maintaining aircraft control during the final turn, and the pilot's improper decision to fly the tight pattern to the closer runway. Factors relating to the accident were the pilot's inadequate distance/altitude in the traffic pattern and the…
- [NTSB LAX01LA030](https://openairdocs.org/ntsb/LAX01LA030.md): Piper PA-32R-301 · Dayton Valley, NV · Accident · No injuries · Limited investigation · Final report · Nov 1, 2000 · N8139A · Substantial damage
  > The pilot's failure to attain a proper glide path during the final approach resulting in an undershoot of the runway. Factors were the lack of runway lights and night lighting condition.
- [NTSB DEN01LA012](https://openairdocs.org/ntsb/DEN01LA012.md): Bell 206L-1 · Mesa Verde, CO · Accident · No injuries · Limited investigation · Final report · Oct 30, 2000 · N613 · Substantial damage
  > The manufacturer's use of improper materials, and inadequate quality control of the tail rotor blades during the manufacturing process, which resulted in fatigue failure of the blade.
- [NTSB DEN01LA010](https://openairdocs.org/ntsb/DEN01LA010.md): Otero-Pitts PT1 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 30, 2000 · N47BS · Substantial damage
  > A hard landing, which exceeded the design stress limits of the aircraft. Factors were the pilot's lack of experience in aircraft make and model and improper recovery from a bounced landing.
- [NTSB CHI01LA027](https://openairdocs.org/ntsb/CHI01LA027.md): Forney F1A · Austin, MN · Accident · Minor injuries · Limited investigation · Final report · Oct 30, 2000 · N3028G · Substantial damage
  > the proper glide path not being maintained by the pilot which resulted in the proper touchdown point not being obtained during the approach. A factor to the accident was the rising embankment.
- [NTSB DEN01LA007](https://openairdocs.org/ntsb/DEN01LA007.md): Piper PA-34-200T · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Oct 28, 2000 · N238Z · Substantial damage
  > Failure by the pilot to follow instrument approach procedures and execute a missed approach when the runway environment was not in sight at decision height. A factor was low ceiling.
- [NTSB CHI01FA025](https://openairdocs.org/ntsb/CHI01FA025.md): Piper PA-28R-200 · Gaylord, MI · Accident · 2 fatal · Field investigation · Final report · Oct 25, 2000 · N15900 · Destroyed
  > The pilot not maintaining proper glideslope and localizer alignment during the precision instrument approach, the pilot continuing flight below the decision height, the pilot not performing a missed approach, and the pilot not maintaining altitude/clearance…
- [NTSB NYC01LA019](https://openairdocs.org/ntsb/NYC01LA019.md): American AA-1A · White Plains, NY · Accident · Serious injuries · Limited investigation · Final report · Oct 23, 2000 · N9375L · Substantial damage
  > An improperly planned approach which resulted in an inadvertent stall.
- [NTSB LAX01LA021](https://openairdocs.org/ntsb/LAX01LA021.md): Cessna 172P · Half Moon Bay, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 22, 2000 · N5226K · Substantial damage
  > A local windshear condition that exceeded the airplane's climb performance capability during landing approach and resulted in the runway overrun during an attempted go-around.
- [NTSB NYC01LA020](https://openairdocs.org/ntsb/NYC01LA020.md): Schweizer SGS 2-33A · Shirley, NY · Accident · No injuries · Limited investigation · Final report · Oct 21, 2000 · N2055T · Substantial damage
  > The pilot's improper in-flight decision to abort the glide toward the airport. A factor was the pilot's failure to comply with the published best glide speed.
- [NTSB CHI01LA022](https://openairdocs.org/ntsb/CHI01LA022.md): Bollinger BD-4 · Hedrick, IA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2000 · N108BC · Substantial damage
  > the pilot not obtaining/maintaining clearance from the fence. A factors was fence.
- [NTSB LAX01FA018](https://openairdocs.org/ntsb/LAX01FA018.md): Beech C90 · Van Nuys, CA · Accident · No injuries · Field investigation · Final report · Oct 17, 2000 · N1801B · 2 aircraft · Substantial damage
  > The failure of the pilot of the other airplane to correctly set a new transponder code and an anomaly in ATC software that precluded the controller from manually overriding the resulting inhibition of displayed data. Factors in the accident were impaired…
- [NTSB CHI01IA016](https://openairdocs.org/ntsb/CHI01IA016.md): Boeing B-727-61 · Wood Dale, IL · Incident · No injuries · Incident investigation · Final report · Oct 17, 2000 · N530KF · Minor damage
  > Inadequate overhaul of the flap segment that allowed for corrosion and debonding that resulted in the flap segment departing the airplane during the approach. Factors relating to this incident were insufficient information provided to the overhaul facility by…
- [NTSB ATL01LA007](https://openairdocs.org/ntsb/ATL01LA007.md): Cessna 172-B · Palatka, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2000 · N7894X · Substantial damage
  > The CFI's inadequate preflight planning which resulted in fuel exhaustion and the subsequent loss of engine power.
- [NTSB FTW01LA002](https://openairdocs.org/ntsb/FTW01LA002.md): Cessna 401A · Andrews, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 10, 2000 · N800SS · Substantial damage
  > The hard landing due to the pilot's excessive rate of descent. A factor was the loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel selectors.
- [NTSB LAX01FA007](https://openairdocs.org/ntsb/LAX01FA007.md): Cessna P210N · Phoenix, AZ · Accident · 2 fatal · Field investigation · Final report · Oct 9, 2000 · N888MM · Destroyed
  > The failure of the pilot to operate the airplane according to the flight manual, resulting in fuel starvation and loss of engine power during a critical phase of flight. A factor was the lack of suitable terrain for a forced landing and the presence of…
- [NTSB NYC01FA005](https://openairdocs.org/ntsb/NYC01FA005.md): Mitsubishi MU-2B-26A · Edgartown, MA · Accident · 4 fatal · Field investigation · Final report · Oct 7, 2000 · N60BT · Destroyed
  > The pilot's failure to follow instrument flight procedures resulting in a collision with a tree. A factor related to the accident was the low cloud ceiling.
- [NTSB LAX01FA004](https://openairdocs.org/ntsb/LAX01FA004.md): Piper PA-34-200 · San Dimas, CA · Accident · 2 fatal · Field investigation · Final report · Oct 7, 2000 · N222ES · Destroyed
  > The pilots becoming lost and disoriented during an improperly conducted IFR approach, and subsequent missed approach, that led to a collision with rising mountainous terrain. Also causal was the local controller canceling the IFR approach when the pilot…
- [NTSB NYC01LA004](https://openairdocs.org/ntsb/NYC01LA004.md): Cessna 210 · Marshfield, MA · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 2000 · N6096B · Substantial damage
  > The pilot's improper management of the fuel supply, which resulted in fuel starvation of the engine. A factor in the accident was the pilot's diverted attention to the inclement weather.
- [NTSB ATL01LA003](https://openairdocs.org/ntsb/ATL01LA003.md): University of Alabama MINI-500 · Tuscaloosa, AL · Accident · 1 fatal · Limited investigation · Final report · Oct 3, 2000 · N6165T · Destroyed
  > The loss of engine power for undetermined reasons, and the pilot's unapproved airframe modification that resulted in the loss of flight control during the emergency descent.
- [NTSB IAD01LA001](https://openairdocs.org/ntsb/IAD01LA001.md): Piper PA-22-160 · Lewisberg, PA · Accident · No injuries · Limited investigation · Final report · Oct 1, 2000 · N9697D · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB FTW00LA271](https://openairdocs.org/ntsb/FTW00LA271.md): Temco Luscombe 11A · Hammond, LA · Accident · No injuries · Limited investigation · Final report · Sep 30, 2000 · N1689B · Substantial damage
  > the pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A contributory factor was the fuel cap leak, due to a worn seal.

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

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