# NTSB investigations, 2001: 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 8 · 396 cases

## Latest cases

- [NTSB IAD02LA022](https://openairdocs.org/ntsb/IAD02LA022.md): Cessna 310H · Tappahannock, VA · Accident · No injuries · Limited investigation · Final report · Dec 30, 2001 · N10MS · Substantial damage
  > The pilot's inadequate compensation for the gusty wind conditions. Factors in the accident were the gusty wind conditions and the total loss of left engine power due to the alternate air valve becoming disconnected and embedded in the fuel injector servo.
- [NTSB ATL02FA025](https://openairdocs.org/ntsb/ATL02FA025.md): Cessna C-210N · Lilburn, GA · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2001 · N139JP · Destroyed
  > The pilot's failure to maintain aircraft control.
- [NTSB CHI02IA058](https://openairdocs.org/ntsb/CHI02IA058.md): Boeing 737-522 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Dec 28, 2001 · N941UA · No damage
  > The wake turbulence encounter.
- [NTSB ATL02LA024](https://openairdocs.org/ntsb/ATL02LA024.md): Cessna 172M · Trenton, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 2001 · N4452Q · Substantial damage
  > The pilot's improper in-flight decision to make a precautionary landing after sustaining a total loss of electrical power with sufficient fuel remaining to reach his destination airport. This resulted in an off field landing to an off site location in a…
- [NTSB NYC02LA043](https://openairdocs.org/ntsb/NYC02LA043.md): Cessna 182 · Falmouth, KY · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 2001 · N660DD · Substantial damage
  > The pilot's continued flight into known adverse weather. A factor was the snow.
- [NTSB FTW02TA060](https://openairdocs.org/ntsb/FTW02TA060.md): Bell OH-58A · El Paso, TX · Accident · No injuries · Final report · Dec 27, 2001 · N76PD · Substantial damage
  > The loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the moving ground vehicle.
- [NTSB ATL02LA023](https://openairdocs.org/ntsb/ATL02LA023.md): Piper PA-28-161 · Kennesaw, GA · Accident · No injuries · Limited investigation · Final report · Dec 27, 2001 · N3035L · Substantial damage
  > The pilot's improper in-flight planning/decision resulting in a total loss of engine power due to fuel exhaustion,which resulted in a forced landing, and subsequent in-flight collision with transmission wires.
- [NTSB LAX02LA055](https://openairdocs.org/ntsb/LAX02LA055.md): Cessna T210M · Santa Rosa, CA · Accident · No injuries · Limited investigation · Final report · Dec 25, 2001 · N1309M · Substantial damage
  > The pilot's inadequate preflight and in-flight planning/decision resulting in miscalculation of fuel consumption, fuel exhaustion and loss of engine power. Factors were rough terrain in a vineyard, power lines in the landing area, and night time.
- [NTSB LAX02FA056](https://openairdocs.org/ntsb/LAX02FA056.md): Cessna 172N · San Clemente, CA · Accident · 2 fatal · Field investigation · Final report · Dec 25, 2001 · N738BC · Destroyed
  > a loss of engine power due to a loss of magneto to engine timing resulting from stress corrosion crack induced fracture, and separation of the magneto impulse coupling spring.
- [NTSB IAD02LA020](https://openairdocs.org/ntsb/IAD02LA020.md): Cessna 401A · Martinsburg, WV · Accident · No injuries · Limited investigation · Final report · Dec 17, 2001 · N4062Q · Substantial damage
  > the owner/mechanic's failure to comply with an Airworthiness Directive, which resulted in a cracked fuel supply line and subsequent in-flight fire.
- [NTSB CHI02LA052](https://openairdocs.org/ntsb/CHI02LA052.md): Piper PA-34 · Clinton, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 2001 · N4354A · Substantial damage
  > the pilot's inadequate prefight, his failure to feather the propellers, and the fuel exhaustion.
- [NTSB FTW02LA053](https://openairdocs.org/ntsb/FTW02LA053.md): Ryan Navion A · Sierra Blanca, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 13, 2001 · N4530K · Substantial damage
  > the pilot's inadverent VFR flight into instrument meteorological weather conditions which resulted in an in-flight collision with terrain. Contributing factors were the night light conditions and the clouds.
- [NTSB CHI02IA050](https://openairdocs.org/ntsb/CHI02IA050.md): Boeing 737-322 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Dec 13, 2001 · N359UA · No damage
  > Reason for occurrence is undetermined.
- [NTSB CHI02FA049](https://openairdocs.org/ntsb/CHI02FA049.md): Robinson R44 · Waukesha, WI · Accident · 1 fatal · Field investigation · Final report · Dec 13, 2001 · N7007F · Destroyed
  > The pilot's continued flight into adverse weather and not maintaining altitude/clearance from the static line during cruise flight. Factors were the static wire, the darkness of night, the low ceiling, and the vehicle.
- [NTSB FTW02FA048](https://openairdocs.org/ntsb/FTW02FA048.md): Gates Learjet 24D · Sierra Blanca, TX · Accident · 2 fatal · Field investigation · Final report · Dec 11, 2001 · N997TD · Destroyed
  > loss of control during descent for undetermined reasons.
- [NTSB LAX02LA044](https://openairdocs.org/ntsb/LAX02LA044.md): Cessna 150K · Honolulu, HI · Accident · Minor injuries · Limited investigation · Final report · Dec 10, 2001 · N6136G · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate preflight inspection and improper in-flight decision and planning.
- [NTSB CHI02FAMS1](https://openairdocs.org/ntsb/CHI02FAMS1.md): Cessna R182 · Lake Michigan, IL · Accident · 4 fatal · Missing aircraft · Final report · Dec 10, 2001 · N2359C · Destroyed
  > The uncontrolled descent for undetermined reasons.
- [NTSB FTW02FA054](https://openairdocs.org/ntsb/FTW02FA054.md): Cessna T210-M · Monticello, AR · Accident · 2 fatal · Field investigation · Final report · Dec 9, 2001 · N317RG · Destroyed
  > The separation of the #2 connecting rod and subsequent catastrophic failure of the engine. A factor was the in-flight collision with a vehicle while maneuvering to a emergency landing area.
- [NTSB CHI02LA048](https://openairdocs.org/ntsb/CHI02LA048.md): Piper PA-38-112 · O'Neill, NE · Accident · No injuries · Limited investigation · Final report · Dec 9, 2001 · N2492K · Substantial damage
  > The inadequate preflight planning by the pilot resulting in the exhaustion of the fuel supply, and the pilot not maintaining directional control during the forced landing. A factor was the unsuitable landing area selected by the pilot, and the ditch.
- [NTSB FTW02LA055](https://openairdocs.org/ntsb/FTW02LA055.md): Luscombe 8A · Haltom City, TX · Accident · No injuries · Limited investigation · Final report · Dec 7, 2001 · N1212B · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB ATL02LA016](https://openairdocs.org/ntsb/ATL02LA016.md): Whitty, Philip J. Mustang II · Hampstead, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 2001 · N888PW · Substantial damage
  > A loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over during landing roll. A factor was the soft, unsuitable terrain.
- [NTSB LAX02FA038](https://openairdocs.org/ntsb/LAX02FA038.md): Piper PA-24-250 · El Dorado, CA · Accident · 4 fatal · Field investigation · Final report · Dec 3, 2001 · N6946P · Destroyed
  > the pilot's intentional flight into adverse weather conditions and his subsequent failure to maintain aircraft control.
- [NTSB CHI02LA043](https://openairdocs.org/ntsb/CHI02LA043.md): McDonnell Douglas DC-9-82 · Romulus, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 2001 · N488AA · No damage
  > The turbulence encountered in-flight and the passenger not complying with the flight and cabin crew’s warning of the turbulance.
- [NTSB CHI02FA042](https://openairdocs.org/ntsb/CHI02FA042.md): Mooney M20M · Evansville, IN · Accident · 2 fatal · Field investigation · Final report · Nov 27, 2001 · N7775L · Destroyed
  > The fatigue failure of the turbocharger exhaust band clamp and aircraft control not possible by the pilot due to the fire.
- [NTSB MIA02LA034](https://openairdocs.org/ntsb/MIA02LA034.md): Cessna 310C · Reidsville, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 2001 · N1840H · Destroyed
  > Improper fuel management by the pilot resulting in loss of power in both engines, and the pilots lowering of the landing gear prior to having the runway made resulting in a hard landing short of the runway.
- [NTSB MIA02LA027](https://openairdocs.org/ntsb/MIA02LA027.md): Mooney M-20-20 · Hilton Head, SC · Accident · 2 fatal · Limited investigation · Final report · Nov 22, 2001 · N5217B · Destroyed
  > The pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control, an uncontrolled descent, and an impact with the water.
- [NTSB FTW02LA042](https://openairdocs.org/ntsb/FTW02LA042.md): Cessna 152 · New Braunfels, TX · Accident · No injuries · Limited investigation · Final report · Nov 22, 2001 · N48941 · Substantial damage
  > the loss of engine power due to carburetor icing conditions while in cruise flight. A contributing factor was the lack of suitable terrain for the ensuing forced landing.
- [NTSB FTW02FA040](https://openairdocs.org/ntsb/FTW02FA040.md): Piper PA-28-160 · Ben Wheeler, TX · Accident · 1 fatal · Field investigation · Final report · Nov 22, 2001 · N6321W · Destroyed
  > The pilot's failure to maintain aircraft control for undetermined reasons.
- [NTSB NYC02LA033](https://openairdocs.org/ntsb/NYC02LA033.md): Cessna 182 · Brookville, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 2001 · N24KA · Substantial damage
  > Fouling of the engine intake and exhaust valves with bromine and lead deposits.
- [NTSB NYC02FA032](https://openairdocs.org/ntsb/NYC02FA032.md): Beech 95-B55 · Falmouth, MA · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2001 · N3847Q · Destroyed
  > The incapacitation of the pilot for undetermined reasons which resulted in an in-flight collision with water.
- [NTSB MIA02LA030](https://openairdocs.org/ntsb/MIA02LA030.md): Beech A36 · Milton, FL · Accident · No injuries · Limited investigation · Final report · Nov 21, 2001 · N1836L · Substantial damage
  > the pilot's failure to properly manage the available fuel in all fuel tanks, which resulted in the loss of engine power due to fuel starvation, a forced landing, and damage to the aircraft when the proper touch down point was not attained.
- [NTSB LAX02FA031](https://openairdocs.org/ntsb/LAX02FA031.md): Aero Commander 500S · Eagleville, CA · Accident · 5 fatal · Field investigation · Final report · Nov 21, 2001 · N900RA · Destroyed
  > the pilot's encounter with forecast mountain wave conditions, moderate or greater turbulence, and icing, with downdrafts that likely exceeded the climb capability of the airplane, which was encountered at an altitude that precluded recovery. Also causal in…
- [NTSB MIA02LA025](https://openairdocs.org/ntsb/MIA02LA025.md): Piper PA-24-250 · Evans, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 2001 · N6688P · Substantial damage
  > The pilot's improper fuel management and failure switch to the other fuel tank which had fuel available prior to the engine ceasing to operate, which resulted in fuel starvation and damage to the airplane during an off-airport landing.
- [NTSB MIA02LA021](https://openairdocs.org/ntsb/MIA02LA021.md): Ercoupe 415-C · Southern Pines, NC · Accident · No injuries · Limited investigation · Final report · Nov 18, 2001 · N99236 · Substantial damage
  > The dislodging of the front crankshaft oil seal for undetermined reasons resulting in loss of engine oil, loss of engine power, and collision with a tree and then the ground during a forced landing.
- [NTSB MIA02LA020](https://openairdocs.org/ntsb/MIA02LA020.md): Mooney M20C · High Springs, FL · Accident · No injuries · Limited investigation · Final report · Nov 18, 2001 · N6753U · Substantial damage
  > The pilot's improper preflight planning/preparation and failure to ensure sufficient fuel was available to complete the flight, which resulted in fuel exhaustion, a forced landing, and damage to the aircraft when it collided with a fence during the landing…
- [NTSB CHI02LA041](https://openairdocs.org/ntsb/CHI02LA041.md): Cessna 152 · Sedalia, MO · Accident · No injuries · Limited investigation · Final report · Nov 18, 2001 · N48285 · Substantial damage
  > The pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident was the soft, rough/uneven terrain.
- [NTSB MIA02LA018](https://openairdocs.org/ntsb/MIA02LA018.md): Beech P35 · Belle Glade, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2001 · N9754Y · Substantial damage
  > The loss of engine oil for undetermined reasons that resulted in the engine seizing, a forced landing on a dirt road, and an impact with a vehicle on the dirt road during the landing rollout.
- [NTSB CHI02FA034](https://openairdocs.org/ntsb/CHI02FA034.md): Piper PA-32R-301 · Spearville, KS · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2001 · N9224X · Destroyed
  > the pilot's failure to maintain aircraft control and his inadvertent flight into known adverse weather conditions. Factors relating to this accident were the pilot's limited ability to see at night, spatial disorientation, the dark night, and the fog.
- [NTSB MIA02LA017](https://openairdocs.org/ntsb/MIA02LA017.md): Piper PA-24-250 · Peachtree City, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 2001 · N8183P · Substantial damage
  > The pilot’s attempted operation of the aircraft with known deficiencies in the engine ignition system resulting in failure of the engine due to ignition system failure and damage to the airplane during the subsequent forced landing.
- [NTSB MIA02FA032](https://openairdocs.org/ntsb/MIA02FA032.md): Cessna 152 · Poplarville, MS · Accident · 1 fatal · Field investigation · Final report · Nov 16, 2001 · N89645 · Destroyed
  > The pilot's becoming lost and disoriented and his failure to maintain control of the airplane while flying over an unpopulated area on a dark night, which was the result of spatial disorientation. Factors in the accident was the pilot's consuming alcoholic…
- [NTSB CHI02FA033](https://openairdocs.org/ntsb/CHI02FA033.md): Zenair CH2000 · Wentzville, MO · Accident · 2 fatal · Field investigation · Final report · Nov 16, 2001 · N33ZA · Destroyed
  > The improper selection of the fuel selector which resulted in fuel starvation and subsequent engine failure. Factors were the unsuitable terrain for the forced landing encountered by the pilot and the night light condition.
- [NTSB SEA02LA014](https://openairdocs.org/ntsb/SEA02LA014.md): Bölkow BO 105 LS · Mud Lake, ID · Accident · Serious injuries · Limited investigation · Final report · Nov 14, 2001 · N93LF · Destroyed
  > Pilot's failure to maintain adequate separation from terrain during the initial climb. Factors include spatial disorientation and a dark moonless night.
- [NTSB FTW02LA032](https://openairdocs.org/ntsb/FTW02LA032.md): Aero Commander 200D · Houston, TX · Accident · No injuries · Limited investigation · Final report · Nov 13, 2001 · N28PC · Substantial damage
  > the failure of the left outboard elevator attachment, which resulted in the partial separation of the left elevator and induced an airframe vibration.
- [NTSB NYC02TA026](https://openairdocs.org/ntsb/NYC02TA026.md): Bell 407 · Whitley City, KY · Accident · Serious injuries · Final report · Nov 12, 2001 · N11HX · Substantial damage
  > The pilots decision to operate the helicopter at an airspeed in excess of the maximum demonstrated stable airspeed for the water bucket. A factor in the accident was the pilot did not follow the published emergency procedure.
- [NTSB NYC02FA025](https://openairdocs.org/ntsb/NYC02FA025.md): Piper PA-28-180 · Mansfield, OH · Accident · 1 fatal · Field investigation · Final report · Nov 12, 2001 · N3672R · Destroyed
  > the pilot's improper use of carburetor heat, and subsequent forced landing. Factors were the carburetor icing condition, night conditions, trees, and the pilot's impairment from ingestion of an over-the-counter antihistamine.
- [NTSB NYC02LA028](https://openairdocs.org/ntsb/NYC02LA028.md): Piper PA-28R-200 · Cattaraugus, NY · Accident · No injuries · Limited investigation · Final report · Nov 11, 2001 · N3057R · Substantial damage
  > A separation of the cylinder from the engine for undetermined reason(s). A factor was the hidden ground obstruction (hole) which the airplane struck during the landing roll.
- [NTSB FTW02LA033](https://openairdocs.org/ntsb/FTW02LA033.md): Bell 407 · Erath, LA · Accident · No injuries · Limited investigation · Final report · Nov 10, 2001 · N517R · Substantial damage
  > The pilot's inadvertant application of full right pedal which resulted in the baggage compartment door to open in-flight and a tie down rope to become entangled in the tail rotor drive system, and the failure of the tail rotor drive shaft resulting in the…
- [NTSB CHI02LA026](https://openairdocs.org/ntsb/CHI02LA026.md): Cessna 182A · Wahoo, NE · Accident · Minor injuries · Limited investigation · Final report · Nov 10, 2001 · N3916D · Substantial damage
  > The pilot's inadequate preflight planning/preparation resulting in fuel exhaustion during cruise flight, and the unsuitable terrain for landing encountered by the pilot during the subsequent forced landing. Factors relating to the accident were the pilot's…
- [NTSB SEA02LA012](https://openairdocs.org/ntsb/SEA02LA012.md): Thurston Pitts S-1S · Eatonville, WA · Accident · 1 fatal · Limited investigation · Final report · Nov 9, 2001 · N3VT · Substantial damage
  > The pilot's unsuccessful corrective action (recovery) from an inverted spin. A contributing factor was the pilot's encounter with the inverted spin maneuver.
- [NTSB DEN02TA011](https://openairdocs.org/ntsb/DEN02TA011.md): Cessna 206 · Casper, WY · Accident · No injuries · Final report · Nov 9, 2001 · N9582G · Substantial damage
  > failure to maintain aircraft control during landing. Contributing factors were the crosswind and gusting wind conditions.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2001&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") = 2001
  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=2001

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