# NTSB investigations, 2002: 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 9 · 407 cases ## Latest cases - [NTSB ATL03FA030](https://openairdocs.org/ntsb/ATL03FA030.md): Piper PA-28-180 · Austell, GA · Accident · Serious injuries · Field investigation · Final report · Dec 31, 2002 · N5118G · Substantial damage > The pilot's inadequate preflight and in-flight planning/decision that resulted in fuel exhaustion, and subsequent loss of engine power. - [NTSB LAX03LA056](https://openairdocs.org/ntsb/LAX03LA056.md): Nicholson Lancair 320 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Dec 30, 2002 · N364M · Substantial damage > The pilot/builder's improper maintenance procedure for reattaching a high-pressure oil line, which resulted in the oil line disconnecting during flight, followed by a loss of oil and engine seizure. - [NTSB FTW03LA070](https://openairdocs.org/ntsb/FTW03LA070.md): Cessna T207 · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Dec 30, 2002 · N1599U · Substantial damage > The loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing. - [NTSB DEN03FA028](https://openairdocs.org/ntsb/DEN03FA028.md): Piper PA-32-300 · Steamboat Spgs, CO · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2002 · N7989C · Destroyed > the pilot's inadequate in-flight planning/decision making resulting in insufficient altitude to fly over the mountain, and the subsequent inadvertent stall/mush into tree covered mountainous terrain. Contributing factors were the tail wind and high density… - [NTSB ANC03LA021](https://openairdocs.org/ntsb/ANC03LA021.md): de Havilland DHC-3 · Nikolai, AK · Accident · No injuries · Limited investigation · Final report · Dec 28, 2002 · N3904 · Substantial damage > An improper and undocumented major repair of the elevator torque tube support assembly by an unknown person, which resulted in an in-flight disconnection of the airplane's right elevator, and a jammed rudder. A factor associated with the accident is the… - [NTSB DEN03FA025](https://openairdocs.org/ntsb/DEN03FA025.md): Cessna 421 · Akron, CO · Accident · 2 fatal · Field investigation · Final report · Dec 25, 2002 · N421D · Destroyed > The fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the… - [NTSB ATL03LA031](https://openairdocs.org/ntsb/ATL03LA031.md): Beech F-35 · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Dec 25, 2002 · N4268B · Substantial damage > The pilot exceeded the design limits of the airplane which resulted in an in flight structural failure. - [NTSB SEA03LA021](https://openairdocs.org/ntsb/SEA03LA021.md): Hughes 369D · Boise, ID · Accident · No injuries · Limited investigation · Final report · Dec 24, 2002 · N8366F · Substantial damage > The failure of the operator's maintenance personnel to properly rig the left/right seat twistgrip throttles to the engine fuel control, the pilot in command's failure to adhere to the rotorcraft flight manual, and the check pilot's premature flare during the… - [NTSB LAX03FA054](https://openairdocs.org/ntsb/LAX03FA054.md): Robinson R22 Beta · Dolan Springs, AZ · Accident · 2 fatal · Field investigation · Final report · Dec 23, 2002 · N888KB · Destroyed > the pilot's inadequate visual lookout and failure to maintain clearance from power lines. A factor was the pilot's decision to conduct cruise flight at a low altitude. - [NTSB FTW03LA066](https://openairdocs.org/ntsb/FTW03LA066.md): Hughes 369E · Fritch, TX · Accident · No injuries · Limited investigation · Final report · Dec 22, 2002 · N5234Y · Substantial damage > The loss of engine power due to the failure of the generator input drive-end bearing, which resulted in excessive vibrations that induced a fatigue fracture of the Pc line leading to the engine fuel control unit. A contributing factor was the lack of suitable… - [NTSB CHI03LA043](https://openairdocs.org/ntsb/CHI03LA043.md): Piper PA-28-235 · Carleton, MI · Accident · No injuries · Limited investigation · Final report · Dec 22, 2002 · N8555W · Substantial damage > The #2 cylinder exhaust valve failed due to undetermined reasons. A factor associated with the accident was the soft terrain encountered during the forced landing. - [NTSB IAD03FA024](https://openairdocs.org/ntsb/IAD03FA024.md): Piper PA-32R-301T · Woodbury, CT · Accident · 2 fatal · Field investigation · Final report · Dec 21, 2002 · N8168G · Destroyed > An engine fire for undetermined reasons, which resulted in the pilot's loss of control, and the airplane's subsequent impact with terrain. - [NTSB ATL03FA025](https://openairdocs.org/ntsb/ATL03FA025.md): Piper PA-32-300 · Macon, GA · Accident · 4 fatal · Field investigation · Final report · Dec 21, 2002 · N47420 · Destroyed > The loss of engine power due to oil starvation. - [NTSB FTW03LA061](https://openairdocs.org/ntsb/FTW03LA061.md): Creekmore Team Rocket F-1 · Rosenberg, TX · Accident · 1 fatal · Limited investigation · Final report · Dec 20, 2002 · N140TC · Destroyed > The in-flight separation of the vertical stabilizer as a result of the builder's failure to install the upper attachment fitting for the vertical fin aft spar. - [NTSB CHI03LA044](https://openairdocs.org/ntsb/CHI03LA044.md): Piper PA-28-180 · Osage Beach, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 20, 2002 · N3236Y · Substantial damage > Fuel Starvation due to the failure of the mechanical fuel pump and the inoperable electric fuel pump caused by the electrical system failure. Factors were the unsuitable terrain and the trees. - [NTSB SEA03LA019](https://openairdocs.org/ntsb/SEA03LA019.md): Eurocopter Deutschland EC-135 P1 · Loon Lake, WA · Accident · No injuries · Limited investigation · Final report · Dec 18, 2002 · N311MS · Substantial damage > The pilot's inadvertent flight into instrument meteorological conditions (IMC) while in cruise flight, and an excessive descent rate. Factors include falling snow, whiteout conditions and dark night conditions. - [NTSB MIA03LA028](https://openairdocs.org/ntsb/MIA03LA028.md): Beech A36 · Laurens, SC · Accident · No injuries · Limited investigation · Final report · Dec 15, 2002 · N12MB · Substantial damage > Improper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation… - [NTSB MIA03LA033](https://openairdocs.org/ntsb/MIA03LA033.md): Beech 200 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Dec 14, 2002 · N623VP · Substantial damage > Failure of the main landing gear locking mechanism for undetermined reasons, which resulted in the main landing gear collapsing, and damage to the airplane during landing. - [NTSB MIA03LA029](https://openairdocs.org/ntsb/MIA03LA029.md): Piper PA-28-150 · Cashiers, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 2002 · N5899W · Substantial damage > The pilot's inadequate in-flight decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain terrain clearance. Contributing factors were a low ceiling and mountainous terrain. - [NTSB FTW03LA060](https://openairdocs.org/ntsb/FTW03LA060.md): Piper PA-28-235 · Bryson, TX · Accident · No injuries · Limited investigation · Final report · Dec 14, 2002 · N8925W · Substantial damage > the pilot's inadequate inflight planning and decision which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane and dark night conditions were contributing factors. - [NTSB MIA03FA024](https://openairdocs.org/ntsb/MIA03FA024.md): Aaa Aircraft Leasing 192 · Miami, FL · Accident · 2 fatal · Field investigation · Final report · Dec 6, 2002 · N192FW · Destroyed > The inflight fire of undetermined origin, which resulted in pilot incapacitation, loss of aircraft control and an inflight collision with a building. - [NTSB DEN03FA023](https://openairdocs.org/ntsb/DEN03FA023.md): Rockwell Commander 114 · Hot Springs, AR · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2002 · N314M · Destroyed > the loss of engine power due to the failure of the engine ignition system's single-drive dual-magneto, and the magneto's improper installation by unknown maintenance personnel. Contributing factors were the improper installation of the magneto by unknown… - [NTSB CHI03IA033](https://openairdocs.org/ntsb/CHI03IA033.md): Hughes OH-6 · Moberly, MO · Incident · No injuries · Incident investigation · Final report · Dec 5, 2002 · N353RK · Minor damage > The loss of tail rotor effectiveness during cruise flight due to the bellcrank pivot pin becoming separated from the non-rotational swashplate. The plain brass liner of the non-rotating swashplate and the bellcrank pivot pin were worn. - [NTSB SEA03LA016](https://openairdocs.org/ntsb/SEA03LA016.md): Luscombe 8A · Tekoa, WA · Accident · Serious injuries · Limited investigation · Final report · Dec 4, 2002 · C-FIIF · Substantial damage > The pilot's failure to maintain clearance from the terrain while attempting to fly a non-IFR equipped aircraft solely by reference to its instruments after the aircraft's windshield became coated with freezing rain in cruise flight. A factor was the pilot's… - [NTSB NYC03LA028](https://openairdocs.org/ntsb/NYC03LA028.md): Ercoupe 415-CD · Dalton, MA · Accident · No injuries · Limited investigation · Final report · Dec 4, 2002 · C-FXJK · Substantial damage > The pilot's inadequate preflight inspection of the aircraft, which resulted in a total loss of engine power due to fuel contamination. A factor was the cold air temperature. - [NTSB FTW03FA055](https://openairdocs.org/ntsb/FTW03FA055.md): Cessna 421C · Tajique, NM · Accident · 1 fatal · Field investigation · Final report · Dec 4, 2002 · N3855C · Destroyed > The pilot's failure to maintain terrain clearance. Factors contributing to the accident were the high mountains, mountain obscuration, the dark night condition, and the pilot's improper in-flight planning/decision making. - [NTSB MIA03LA023](https://openairdocs.org/ntsb/MIA03LA023.md): Beech 35-B33 · Gainesville, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 2002 · N8578M · Substantial damage > a loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing. - [NTSB FTW03LA056](https://openairdocs.org/ntsb/FTW03LA056.md): Cessna 172M · Vici, OK · Accident · No injuries · Limited investigation · Final report · Dec 3, 2002 · N4470R · Substantial damage > The pilot's departure and continued flight into adverse weather conditions. Contributing factors were the icing conditions, and the lack of suitable terrain for the precautionary landing. - [NTSB SEA03FA015](https://openairdocs.org/ntsb/SEA03FA015.md): Caron Seawind · Bryant, WA · Accident · 2 fatal · Field investigation · Final report · Nov 30, 2002 · N313FC · Destroyed > A loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain. - [NTSB SEA03TA014](https://openairdocs.org/ntsb/SEA03TA014.md): Hughes OH-6A · Snohomish, WA · Accident · No injuries · Final report · Nov 29, 2002 · N13SD · Substantial damage > Loss of engine power for undetermined reasons while in cruise flight. A tree was a factor. - [NTSB MIA03LA020](https://openairdocs.org/ntsb/MIA03LA020.md): Cessna 150L · Powells Point, NC · Accident · No injuries · Limited investigation · Final report · Nov 28, 2002 · N10905 · Substantial damage > a loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing. - [NTSB NYC03LA026](https://openairdocs.org/ntsb/NYC03LA026.md): Cessna TR182 · Willoughby, OH · Accident · No injuries · Limited investigation · Final report · Nov 27, 2002 · N4929S · Substantial damage > The pilot's failure to select the alternator to the "ON" position before initiating the flight. A factor in the accident was the tailwind which resulted in the overrun. - [NTSB LAX03LA041](https://openairdocs.org/ntsb/LAX03LA041.md): Clyde K Carrier Team 1400Z · Woodland, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 2002 · N9190U · Substantial damage > the builder/pilot's improper modification of wing fuel caps resulting in the failure of the vent system to adequately compensate for the pressure differential between the fuel tank and the external low pressure area of the wing. This led to the partial loss… - [NTSB FTW03FA051](https://openairdocs.org/ntsb/FTW03FA051.md): Piper PA-34-220T · McAlester, OK · Accident · 5 fatal · Field investigation · Final report · Nov 27, 2002 · N699WG · Destroyed > The pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around which resulted in his loss of control. Contributing factors to the accident included the loss of power from the left engine as a result of… - [NTSB DEN03LA021](https://openairdocs.org/ntsb/DEN03LA021.md): Piper PA-28-180 · Vernal, UT · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 2002 · N9020J · Substantial damage > the pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog. - [NTSB SEA03FA013](https://openairdocs.org/ntsb/SEA03FA013.md): Cessna 172P · Malaga, WA · Accident · 2 fatal · Field investigation · Final report · Nov 26, 2002 · N65564 · Destroyed > The pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of… - [NTSB FTW03FA048](https://openairdocs.org/ntsb/FTW03FA048.md): Beech A36 · Salem, UT · Accident · 2 fatal · Field investigation · Final report · Nov 25, 2002 · N367T · Destroyed > The pilot's inadequate inflight planning/decision to continue flight from visual to instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain while in cruise flight. A low ceiling, obscuration, mountainous terrain… - [NTSB SEA03LA011](https://openairdocs.org/ntsb/SEA03LA011.md): Peterson Dragonfly · Mulino, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 23, 2002 · N2448 · Substantial damage > Fuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing. - [NTSB NYC03LA023](https://openairdocs.org/ntsb/NYC03LA023.md): Cessna 172K · Prestonsburg, KY · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N7192G · Substantial damage > The loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition. - [NTSB CHI03LA029](https://openairdocs.org/ntsb/CHI03LA029.md): Piper PA-23-250 · Stalwart, MI · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N5985Y · Substantial damage > The pilot's improper fuel management during the flight and the pilot's improper decision not to select the outboard fuel tank when a loss of engine power was experienced, resulting in fuel starvation, a sustained loss of engine power, and subsequent forced… - [NTSB CHI03LA028](https://openairdocs.org/ntsb/CHI03LA028.md): Woods Velocity · Claflin, KS · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N241KW · Substantial damage > The total loss of engine power while in cruise flight due to vapor lock of the fuel line as a result of the fractured exhaust manifold. A factor was the unsuitable terrain encountered during the forced landing. - [NTSB LAX03LA036](https://openairdocs.org/ntsb/LAX03LA036.md): Asmus Exec 162F · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Nov 21, 2002 · N162LC · Substantial damage > The loss of engine power for undetermined reasons. A factor in the accident was the pilot's failure to maintain aircraft control during the forced landing. - [NTSB NYC03FA024](https://openairdocs.org/ntsb/NYC03FA024.md): Socata TB-20 · Massena, NY · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2002 · N57TB · Substantial damage > The pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot. - [NTSB LAX03LA034](https://openairdocs.org/ntsb/LAX03LA034.md): Cessna T210 L · Williams, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 2002 · N59132 · Destroyed > An in-flight fire for undetermined reasons. - [NTSB FTW03FA044](https://openairdocs.org/ntsb/FTW03FA044.md): Cessna 210L · Kentwood, LA · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2002 · N93770 · Destroyed > The failure of the #1 and #2 connecting rods during climb to cruise due to overheating, resulting from oil starvation. A contributing factor was the low cloud conditions limiting the pilot's visibility during the ensuing emergency landing. - [NTSB CHI03FA025](https://openairdocs.org/ntsb/CHI03FA025.md): Robinson R22 · St. Jacob, IL · Accident · No injuries · Field investigation · Final report · Nov 20, 2002 · N559DD · Substantial damage > Fatigue fracture of the clutch assembly fan shaft and the resulting complete loss of power to the rotor drive system. A contributing factor was the loss of tail rotor authority due to the secondary failure of the control tube assembly. - [NTSB MIA03LA019](https://openairdocs.org/ntsb/MIA03LA019.md): John H. Heiring Express · Moncks Corner, SC · Accident · 3 fatal · Limited investigation · Final report · Nov 19, 2002 · N297JH · Destroyed > The pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons, resulting in an inadvertent stall and subsequent uncontrolled descent and in-flight collision with water. - [NTSB NYC03IA027](https://openairdocs.org/ntsb/NYC03IA027.md): Canadair CL-600-2B19 · Rockville, VA · Incident · No injuries · Incident investigation · Final report · Nov 17, 2002 · N868CA · No damage > The PIC's inadvertent encounter with turbulence while operating in an area of forecast occasional severe turbulence. - [NTSB NYC03FA022](https://openairdocs.org/ntsb/NYC03FA022.md): Cessna 182D · NewPhiladelphia, OH · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2002 · N9964T · Destroyed > The pilot's improper decision to disregard the weather briefing, and to conduct an intentional flight into known icing conditions, with an airplane not equipped for that flight, and his failure to maintain airspeed. Factors were the clouds and icing… - [NTSB FTW03LA041](https://openairdocs.org/ntsb/FTW03LA041.md): Cessna 152 · Houston, TX · Accident · 1 fatal · Limited investigation · Final report · Nov 17, 2002 · N4794P · No damage > The dual student's intentional suicide by exiting from the airplane during descent. A contributing factor was the psychological condition of the dual student. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2002&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") = 2002 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=2002 --- 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.