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

## Latest cases

- [NTSB NYC02FA044](https://openairdocs.org/ntsb/NYC02FA044.md): Raytheon BE-23-B24R · Armonk, NY · Accident · 1 fatal · Field investigation · Final report · Dec 31, 2001 · N2173W · Destroyed
  > The pilot's failure to maintain aircraft control.
- [NTSB IAD02FA024](https://openairdocs.org/ntsb/IAD02FA024.md): Piper PA-28R-180 · Milford, CT · Accident · 1 fatal · Field investigation · Final report · Dec 30, 2001 · N7427J · Substantial damage
  > The pilot's failure to follow the published IFR approach procedure, which resulted in a premature descent and subsequent impact with water. A factor was the night, overwater visual conditions.
- [NTSB ATL02FA026](https://openairdocs.org/ntsb/ATL02FA026.md): Mooney M20C · Gainesville, GA · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2001 · N6953V · Destroyed
  > The loss of engine power due to fuel starvation, resulting from fuel system blockage and improper maintenance by maintenance personnel. A factor was the unsuitable terrain.
- [NTSB CHI02FA059](https://openairdocs.org/ntsb/CHI02FA059.md): Borgman Smyth Sidewinder · Independence, KS · Accident · 2 fatal · Field investigation · Final report · Dec 28, 2001 · N133G · Substantial damage
  > The pilot's failure to maintain control of the airplane and the subsequent inadvertant stall during the base to final turn. A factor associated with the accident was that an unqualified person was piloting the airplane.
- [NTSB CHI02LA055](https://openairdocs.org/ntsb/CHI02LA055.md): Cessna 182P · Elkhart, IN · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 2001 · N58797 · Substantial damage
  > The pilot allowed the airplane's altitude to get too low while on final approach. A factor associated with the accident was the pickup truck which the airplane struck.
- [NTSB ATL02LA019](https://openairdocs.org/ntsb/ATL02LA019.md): Cessna 210D · Vero Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 2001 · N3776Y · Substantial damage
  > The pilot's inadequate preflight fuel requirements for the flight, resulting in fuel exhaustion and the subsequent loss of engine power.
- [NTSB LAX02LA053](https://openairdocs.org/ntsb/LAX02LA053.md): Cessna T210N · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Dec 20, 2001 · N7AL · Substantial damage
  > The pilot's failure to land on the runway with sufficient runway remaining as a result of his improper IFR procedure by his failure to maintain visual contact with the runway environment, and to execute a missed approach.
- [NTSB LAX02LA050](https://openairdocs.org/ntsb/LAX02LA050.md): Cessna R182 · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Dec 17, 2001 · N7317X · Substantial damage
  > Inadequate maintenance and inspection of the engine dual magneto that resulted in a loss of engine power during a critical phase of flight, and the subsequent undershoot forced landing in soft terrain.
- [NTSB LAX02FA049](https://openairdocs.org/ntsb/LAX02FA049.md): Cessna T210L · San Jacinto, CA · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2001 · N210RE · Destroyed
  > The pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.
- [NTSB MIA02FA045](https://openairdocs.org/ntsb/MIA02FA045.md): Piper PA-32-260 · Jacksonville, FL · Accident · 4 fatal · Field investigation · Final report · Dec 13, 2001 · N7701J · Destroyed
  > The pilot becoming spatially disoriented and losing control of the airplane during a missed approach resulting in the airplane descending uncontrolled and colliding with trees and the ground.
- [NTSB MIA02FA044](https://openairdocs.org/ntsb/MIA02FA044.md): Piper PA-46-350P · Raleigh, NC · Accident · 3 fatal · Field investigation · Final report · Dec 13, 2001 · N41003 · Destroyed
  > the pilot's failure to maintain control of the airplane, due to spatial disorientation, while performing a missed approach, resulting in an uncontrolled descent, and subsequent impact with a tree and a house. Factors in this accident were dark night, fog,…
- [NTSB FTW02LA052](https://openairdocs.org/ntsb/FTW02LA052.md): Piper PA-23-250 · Duncan, OK · Accident · Serious injuries · Limited investigation · Final report · Dec 13, 2001 · N127CA · Substantial damage
  > The pilot's descent below the minimum descent altitude, and his failure to maintain obstacle clearance. Contributing factors were the below approach/landing minimum weather, the dark night conditions, and the inoperative REIL's.
- [NTSB FTW02TA051](https://openairdocs.org/ntsb/FTW02TA051.md): Cessna T210K · San Antonio, TX · Accident · No injuries · Final report · Dec 11, 2001 · N8299M · Substantial damage
  > the failure of the right main landing gear downlock mechanism to engage for reasons undetermined.
- [NTSB LAX02LA043](https://openairdocs.org/ntsb/LAX02LA043.md): Rominger Zic Zac Bird · Marina, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 9, 2001 · N204ED · Destroyed
  > the failure the right wing spar and the subsequent separation of the right wing. Contributing factors were the pilot's inadequate maintenance, and the weakened wing structure due to a preexisting fuel tank leak.
- [NTSB LAX02LA042](https://openairdocs.org/ntsb/LAX02LA042.md): Burkhart Grob G102 Club Astir Iiib · Banning, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 7, 2001 · N102FC · Substantial damage
  > On final approach, the pilot's failure to maintain adequate aircraft airspeed and control during an encounter with the gusting high wind.
- [NTSB NYC02LA034](https://openairdocs.org/ntsb/NYC02LA034.md): Gillette Baby Ace · Spencerport, NY · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 2001 · N916MG · Substantial damage
  > The pilot's failure to maintain aircraft control during approach to the airport, which resulted in an inadvertent stall.
- [NTSB LAX02LA036](https://openairdocs.org/ntsb/LAX02LA036.md): Piper PA-24-250 · Prescott, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 2001 · N7213P · Substantial damage
  > Fuel starvation on final approach due to the pilot's fuel mismanagement, and his inattentiveness in following established prelanding procedures.
- [NTSB MIA02LA038](https://openairdocs.org/ntsb/MIA02LA038.md): Byrd KR-2S · Linden, NC · Accident · No injuries · Limited investigation · Final report · Dec 1, 2001 · N366KR · Destroyed
  > The pilot's failure to correct a condition where visual contact with the terrain was lost due to sunshine glare, resulting in collision with a tree during final approach for landing.
- [NTSB MIA02FA037](https://openairdocs.org/ntsb/MIA02FA037.md): Cessna 208B · Bessemer, AL · Accident · 2 fatal · Field investigation · Final report · Dec 1, 2001 · N499BA · Destroyed
  > The poor in-flight planning by the pilot-in-command for his initiation of the ILS approach to runway 05 with weather conditions below minimums for the approach contrary to the federal aviation regulations, and the failure of the pilot to maintain control of…
- [NTSB LAX02LA035](https://openairdocs.org/ntsb/LAX02LA035.md): Classic Waco YMF · Banning, CA · Accident · No injuries · Limited investigation · Final report · Dec 1, 2001 · N31BN · Substantial damage
  > a loss of engine power due to a crack in the carburetor float and leaking portions of the carburetor that resulted in an overly rich mixture.
- [NTSB CHI02LA044](https://openairdocs.org/ntsb/CHI02LA044.md): Mitsubishi MU-2B-40 · St Paul, MN · Accident · No injuries · Limited investigation · Final report · Nov 30, 2001 · N9052Y · Substantial damage
  > The autopilot's computer connections arcing and reported disconnection during the localizer approach and the pilot not performing a go around prior to the hard landing. A factor was the pilots lack of total experience in the accident airplane's make and model.
- [NTSB LAX02LA033](https://openairdocs.org/ntsb/LAX02LA033.md): Beech B95 · Henderson, NV · Accident · No injuries · Limited investigation · Final report · Nov 29, 2001 · N2012C · Substantial damage
  > the loss of engine power in the left engine for undetermined reasons. A contributing factor was the check pilot's failure to completely configure the airplane for a single engine go-around in a timely way.
- [NTSB LAX02LA030](https://openairdocs.org/ntsb/LAX02LA030.md): Beech C-99 · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Nov 29, 2001 · N228BH · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his failure to maintain directional control. Contributing factors were the icing conditions, icing, and the improper use of the anti-ice/deicing equipment.
- [NTSB MIA02LA033](https://openairdocs.org/ntsb/MIA02LA033.md): Vernon D. Pitts RV-4 · Burgaw, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 2001 · N15VP · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB MIA02FA026](https://openairdocs.org/ntsb/MIA02FA026.md): Enstrom 280FX · Tallassee, AL · Accident · 2 fatal · Field investigation · Final report · Nov 22, 2001 · N280XF · Destroyed
  > The failure of the pilot to maintain a safe altitude above terrain and maintain a visual lookout resulting in the helicopter colliding with power transmission lines and crashing into a river. A factor in the accident was the power transmission lines not being…
- [NTSB MIA02LA028](https://openairdocs.org/ntsb/MIA02LA028.md): Cessna 150M · Stuart, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 2001 · N590AM · Substantial damage
  > The pilot's improper fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion and collision with trees during a forced landing.
- [NTSB MIA02LA023](https://openairdocs.org/ntsb/MIA02LA023.md): Boeing 727-233 · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Nov 20, 2001 · N277FE · Substantial damage
  > The inadvertent collision with birds while on final approach to land resulting in substantial damage to the airplane.
- [NTSB FTW02LA034](https://openairdocs.org/ntsb/FTW02LA034.md): Air Tractor AT-802A · Benton, LA · Accident · 1 fatal · Limited investigation · Final report · Nov 14, 2001 · N202AT · Destroyed
  > in-flight collision with trees while on final approach to land for an undetermined reason.
- [NTSB FTW02FA036](https://openairdocs.org/ntsb/FTW02FA036.md): Piper PA-31T1 · Graham, TX · Accident · 4 fatal · Field investigation · Final report · Nov 13, 2001 · N6134A · Destroyed
  > The pilot's failure to discontinue the approach after encountering instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing factors were the dark night light condition, low ceiling, and reduced visibility due to fog.
- [NTSB SEA02LA016](https://openairdocs.org/ntsb/SEA02LA016.md): Piper PA-28R-200 · Puyallup, WA · Accident · No injuries · Limited investigation · Final report · Nov 10, 2001 · N9466K · Substantial damage
  > The pilots' failure to maintain aircraft control on short final, resulting in a touchdown off of the prepared landing surface. A factor was grassy terrain encountered on the landing rollout.
- [NTSB LAX02LA025](https://openairdocs.org/ntsb/LAX02LA025.md): Cessna 150L · Nogales, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 2001 · N10680 · Substantial damage
  > The pilot failed to maintain directional control while landing in a cross wind. He attempted a go-around, but inadvertently stalled the airplane, which resulted in an uncontrolled descent and collision with the runway.
- [NTSB CHI02LA027](https://openairdocs.org/ntsb/CHI02LA027.md): Beech V35 · Mounds View, MN · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 2001 · N4890J · Destroyed
  > Fuel starvation caused by the pilot's improper positioning of the fuel tank fuel selector while in the traffic pattern, and the unsuitable terrain encountered during the forced landing. Factors relating to the accident were the pilot not complying with the…
- [NTSB ATL02LA012](https://openairdocs.org/ntsb/ATL02LA012.md): Extra Flugzeugbau EA300/L · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 2001 · N2XA · 2 aircraft · Minor damage
  > The pilot of the other airplanes failure to maintain a visual lookout and yield the right-of-way to a lower airplane while landing. This resulted in an inadvertent midair collision. Contributing to the accident was reported excessive radio communication on…
- [NTSB LAX02LA024](https://openairdocs.org/ntsb/LAX02LA024.md): Taylorcraft BC12-D · Copperopolis, CA · Accident · No injuries · Limited investigation · Final report · Nov 9, 2001 · N43382 · Substantial damage
  > The pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.
- [NTSB DEN02LA010](https://openairdocs.org/ntsb/DEN02LA010.md): Agusta A119 · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2001 · N119RX · Destroyed
  > improper rigging of the rotary variable differential transformer by the manufacturer, resulting in incorrect fuel scheduling to the fuel control unit.
- [NTSB MIA02LA015](https://openairdocs.org/ntsb/MIA02LA015.md): Cessna 177 · Gainesville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 2001 · N177X · Substantial damage
  > The failure of both pilots to insure the airplane contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion and collision with trees during a forced landing.
- [NTSB LAX02LA023](https://openairdocs.org/ntsb/LAX02LA023.md): Piper PA-18-150 · Herald, CA · Accident · No injuries · Limited investigation · Final report · Nov 8, 2001 · N9461P · Substantial damage
  > The pilot's delay initiating a go-around during a downwind approach to a short runway.
- [NTSB LAX02FA019](https://openairdocs.org/ntsb/LAX02FA019.md): Cessna 182S · Little River, CA · Accident · 1 fatal · Field investigation · Final report · Nov 1, 2001 · N7270E · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.
- [NTSB FTW02LA023](https://openairdocs.org/ntsb/FTW02LA023.md): Piper PA28-140 · Wilton, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 2001 · N8305R · Substantial damage
  > the pilot's failure to obtain a proper touchdown point and his excessive approach speed during a forced landing. A contributing factor was the total loss of engine power for undetermined reasons.
- [NTSB CHI02LA015](https://openairdocs.org/ntsb/CHI02LA015.md): Piper PA-28R-201 · Lapeer, MI · Accident · No injuries · Limited investigation · Final report · Oct 28, 2001 · N6899C · Substantial damage
  > the touchdown aim point not attained by the pilot rated student and the remedial action not performed by the flight instructor.
- [NTSB CHI02LA014](https://openairdocs.org/ntsb/CHI02LA014.md): Piper PA-28-180 · Fort Wayne, IN · Accident · Serious injuries · Limited investigation · Final report · Oct 28, 2001 · N4879L · Destroyed
  > The pilot not maintaining control of the airplane during an attempted go-around. A factor was the trees.
- [NTSB NYC02LA017](https://openairdocs.org/ntsb/NYC02LA017.md): Beech B95A · Pittstown, NJ · Accident · Minor injuries · Limited investigation · Final report · Oct 26, 2001 · N919Q · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in an inadvertent stall. A factor was the gusty wind conditions.
- [NTSB CHI02FA009](https://openairdocs.org/ntsb/CHI02FA009.md): Beech 58 · Dubuque, IA · Accident · 1 fatal · Field investigation · Final report · Oct 23, 2001 · N7235R · Destroyed
  > The pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.
- [NTSB FTW02LA018](https://openairdocs.org/ntsb/FTW02LA018.md): Piper PA-30 · Ozona, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 2001 · N8642Y · Substantial damage
  > The loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel the airplane. Contributing factors were the lack of suitable terrain for the forced landing and the dark night conditions.
- [NTSB ANC02LA002](https://openairdocs.org/ntsb/ANC02LA002.md): Embraer 120ER · Bethel, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 2001 · N120AX · Substantial damage
  > The captain's continued descent below the minimum descent altitude which resulted in impact with terrain during an instrument landing approach. Factors contributing to the accident were the flightcrew's failure to reset the altimeters to the correct altimeter…
- [NTSB SEA02FA005](https://openairdocs.org/ntsb/SEA02FA005.md): Piper PA-18 · Sandy, OR · Accident · 2 fatal · Field investigation · Final report · Oct 16, 2001 · N7502K · Substantial damage
  > The pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…
- [NTSB FTW02LA008](https://openairdocs.org/ntsb/FTW02LA008.md): Beech C90 · Dallas, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 2001 · N690JP · Substantial damage
  > the pilot's failure to refuel the airplane, which resulted in fuel exhaustion and subsequent loss of dual engine power while on approach.
- [NTSB FTW02LA009](https://openairdocs.org/ntsb/FTW02LA009.md): Cessna 182A · Chickasha, OK · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 2001 · N3862D · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB MIA02LA003](https://openairdocs.org/ntsb/MIA02LA003.md): Piper PA-30B-160 · Clarksville, TN · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 2001 · N8402Y · Substantial damage
  > The failure of the CFI/check pilot to insure Vmc was maintained during a go-around following a simulated failed engine approach, resulting in an in-flight loss of control, uncontrolled descent, and collision with the terrain. A factor in the accident was the…
- [NTSB FTW02FA003](https://openairdocs.org/ntsb/FTW02FA003.md): Fokker F28 Mk 0100 · DFW Airport, TX · Accident · No injuries · Field investigation · Final report · Oct 3, 2001 · N1448A · Substantial damage
  > The collapse of the nose landing gear as a result of the failure of company maintenance personnel to follow the proper procedures for a towing the airplane with an unsafe nose landing gear indication. Contributing factors were the inadequate communication…

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

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