NTSB investigations, 2002

407 cases where the phase of flight was Enroute.

Cases, newest first

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB LAX03LA032Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Napa, CAthe pilot's inadequate management of the fuel system, which led to fuel starvation and a water ditching.Nov 16, 2002 · N501A · Substantial damageNTSB ANC03LA015Accident · 1 fatalLimited investigationFinal reportBell 206B · Kingman, AZThe pilot's failure to maintain altitude/clearance from obstacles during cruise flight, which resulted in the helicopter striking a transmission line, and subsequently the ground.Nov 15, 2002 · N16962 · Substantial damageNTSB ATL03LA016Accident · 1 fatalLimited investigationFinal reportChance Vought F4U-4 · Columbia, SCAn in-flight engine fire for undetermined reasonsNov 10, 2002 · N713JT · DestroyedNTSB IAD03LA012Accident · 1 fatalLimited investigationFinal reportWestland Helicopters Gazelle AH-MK1 · East Hampton, NYThe pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with water. Factors included the pilot's decision to fly over water on a moonless night, his lack of experience in that environment, and the dark night lighting…Nov 9, 2002 · N911XW · DestroyedNTSB LAX03FA025Accident · 1 fatalField investigationFinal reportCessna 150E · Anaheim Hills, CAthe pilot's continued VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance from power lines. A contributing factor was the pilot's impairment by medication.Nov 8, 2002 · N6236T · DestroyedNTSB DEN03FA012Accident · 4 fatalField investigationFinal reportCessna 208B · Parks, AZthe pilot's improper in flight planning/decision making, his flight into known icing conditions, and his failure to maintain adequate airspeed which resulted in the inadvertent stall/spin and impact with terrain. Factors contributing to the accident were the…Nov 8, 2002 · N514DB · DestroyedNTSB FTW03LA046Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kerrville, TXThe propeller shaft seal leak resulting in an in-flight fire.Nov 6, 2002 · N698VW · Substantial damageNTSB DEN03LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28RT · Grand Junction, COthe collapse of the left main landing gear during landing roll resulting in loss of control/ground loop/swerve and subsequent impact with a sign. Contributing factors include, the airplane's total loss of electrical power due to an alternator failure and the…Nov 6, 2002 · N2904C · Substantial damageNTSB ATL03LA014Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Orlando, FLThe airplane's inflight encounter with turbulence that resulted in injuries to the number two flight attendant.Nov 6, 2002 · N479AA · No damageNTSB FTW03LA034Accident · No injuriesLimited investigationFinal reportRockwell 690B · New Braunfels, TXThe in-flight separation of the top of the rudder assembly for undetermined reasons.Nov 1, 2002 · N77UA · Substantial damageNTSB FTW03LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fort Stockton, TXThe pilot's decision to conduct VFR flight into IMC and his failure to maintain terrain clearance. Contributing factors were the dark night, clouds, fog, and the lack of suitable terrain.Nov 1, 2002 · N6072R · Substantial damageNTSB FTW03FA028Accident · 1 fatalField investigationFinal reportHughes 269A · Fort Gibson, OKThe in-flight separation of the tail boom resulting from the failure of the fuselage to tail boom attachment fitting lugs, due to fatigue.Nov 1, 2002 · N8885F · DestroyedNTSB NYC03FA015Accident · 1 fatalField investigationFinal reportCessna 182S · Accident, MDThe pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.Oct 31, 2002 · N7099L · Substantial damageNTSB FTW03LA026Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Marshall, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Oct 31, 2002 · N35866 · Substantial damageNTSB ATL03LA012Accident · 1 fatalLimited investigationFinal reportBeech F33A · Fernandina Bch, FLWater contamination in the fuel system which resulted in the loss of engine power and the subsequent collision with trees.Oct 31, 2002 · N3122K · DestroyedNTSB ATL03LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Laurel Bloomery, TNThe pilot's failure to maintain clearance with terrain, which resulted in an inflight collision with mountainous terrain. Factors were the pilot's inadequate preflight planning and failure to obtain weather information, which resulted in an inflight encounter…Oct 31, 2002 · N15704 · DestroyedNTSB ANC03LA007Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Marshall, AKThe pilot's failure to maintain clearance from terrain, which resulted in an in-flight collision with a ridgeline. Factors contributing to the accident were the high terrain, the pilot's inadequate preflight planning, and the dark night light conditions.Oct 29, 2002 · N91090 · Substantial damageNTSB MIA03FA007Accident · 2 fatalField investigationFinal reportCessna 172M · Coral Springs, FLThe failure of the dual students and flight instructors on both N9840V and N6101F to see and avoid each other, which resulted in a midair collision.Oct 27, 2002 · N9840V · 2 aircraft · DestroyedNTSB IAD03LA010Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Springfield, OHInadequate installation of the number 3 cylinder.Oct 27, 2002 · N49422 · Substantial damageNTSB NYC03LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's improper use of carburetor heat which resulted in a failure to remove carburetor ice, and loss of engine power. A factor was the carburetor icing conditions.Oct 24, 2002 · N40059 · Substantial damageNTSB ATL03FA009Accident · 2 fatalField investigationFinal reportBeechcraft A60 · Jesup, GAThe loss of power in one engine and the loss of control for undetermined reasons.Oct 24, 2002 · N73CR · DestroyedNTSB ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.Oct 24, 2002 · N76U · DestroyedNTSB FTW03LA018Accident · No injuriesLimited investigationFinal reportCarriere RW-152 Scorpion II · Opelousas, LAThe pilot's inadequate compensation for wind resulting in a loss of control. A contributing factor was the gusting wind conditions.Oct 19, 2002 · N838MC · Substantial damageNTSB ATL03LA007Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Highfalls, GAThe pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…Oct 19, 2002 · N4002G · Substantial damageNTSB NYC03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Hartwood, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.Oct 18, 2002 · N2718G · Substantial damageNTSB NYC03IA011Incident · No injuriesIncident investigationFinal reportPiper PA-28-236 · Altoona, PAA failure of the fuel selector for an undetermined reason.Oct 18, 2002 · N4295R · Minor damageNTSB DEN03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Salt Lake City, UTfuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the pilot's decision to continue the flight without stopping for fuel.Oct 18, 2002 · N33170 · Substantial damageNTSB FTW03LA013Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · San Antonio, TXthe flight instructor's failure to refuel at an available airport when a low fuel status was identified. Factors were the flight instructor's inadequate preflight flight planning, which included improper fuel consumption calculations, the night light…Oct 16, 2002 · N61463 · Substantial damageNTSB NYC03LA004Accident · No injuriesLimited investigationFinal reportde Havilland DHC-8-102 · Albany, NYAn in-flight collision with birds. A factor was the night conditions.Oct 15, 2002 · N847EX · Substantial damageNTSB NYC03LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Block Island, RIThe pilot's misjudgment of speed and distance as a result of physical impairment due to smoke.Oct 14, 2002 · N5675V · Substantial damageNTSB LAX03FA008Accident · 1 fatalField investigationFinal reportCessna 150F · Julian, CAan in-flight loss of control for undetermined reasons.Oct 14, 2002 · N8735G · DestroyedNTSB DEN03LA006Accident · No injuriesLimited investigationFinal reportMooney M20B · Loa, UTthe pilot's inadvertent placement of the fuel selector position in the off position. A contributing factor was the pilot's lack of familiarity with the aircraft.Oct 14, 2002 · N74530 · Substantial damageNTSB IAD03LA006Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · South Vienna, OHThe improper installation of the single drive, dual magneto, which resulted in its separation from the engine and a subsequent total loss of engine power. Factors included the crops in the forced landing field, and the night lighting conditions.Oct 13, 2002 · N7510V · Substantial damageNTSB SEA03LA002Accident · Serious injuriesLimited investigationFinal reportGentry Vari-Eze · Shine, WALoss of engine power for undetermined reasons during cruise. Trees and objects near the roadway were factors.Oct 12, 2002 · N24BG · Substantial damageNTSB LAX03FA005Accident · 1 fatalField investigationFinal reportGrumman AA-5A · Phoenix, AZfailure of the lubricating system resulting in a total loss of engine power and an off airport forced landing.Oct 12, 2002 · N9566U · DestroyedNTSB IAD03FA004Accident · 1 fatalField investigationFinal reportCessna 182S · Brownville Jct, METhe pilot's failure to maintain sufficient altitude while flying in mountainous terrain at night. A factor was the night lighting conditions.Oct 12, 2002 · N100TY · DestroyedNTSB FTW03LA011Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Vinson, OKThe pilot's inadvertent flight into adverse weather conditions during cruise resulting in his failure to maintain control of the helicopter, and his failure to maintain rotor rpm. Contributing factors relating to the accident included the frontal activity…Oct 12, 2002 · N9008H · Substantial damageNTSB ANC03IA001Incident · No injuriesIncident investigationFinal reportBoeing 747-400 · Anchorage, AKThe fatigue fracture of the lower rudder power control module manifold, which resulted in a lower rudder hardover.Oct 10, 2002 · N661US · No damageNTSB ATL03FA002Accident · 1 fatalField investigationFinal reportBeech K35 · Jellico, TNThe pilot's incapacitation in flight due to a heart attack resulting in an in-flight loss of control, and collision with terrain. A factor was the pilot acting as a pilot-in-command with a known medical grounding condition.Oct 9, 2002 · N5350E · DestroyedNTSB CHI03LA006Accident · No injuriesLimited investigationFinal reportWolf Rotorway Exec-162F · Gregory, MIFailure of the secondary drive shaft, which resulted in a complete loss of power to the main rotor, and a high forward airspeed on touchdown, causing the helicopter to flip forward.Oct 7, 2002 · N1955Z · Substantial damageNTSB FTW03LA005Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Lewisville, TXThe improper reinstallation of the left aileron by maintenance personnel. A contributing factor was the non-suitable terrain for the forced landing.Oct 3, 2002 · N1223S · Substantial damageNTSB CHI03FA003Accident · 1 fatalField investigationFinal reportPiper PA-18A · Garden City, KSThe inadequate preflight planning/preparation and visual flight rules flight into instrument meteorological conditions by the pilot. The clouds, mist, and night conditions were contributing factors.Oct 2, 2002 · N3279Z · DestroyedNTSB SEA02LA187Accident · No injuriesLimited investigationFinal reportMooney M20J · Oakley, IDFailure (fracture) of the two number four piston compression rings, leading to the erosion of a section of the piston sidewall, resulting in the exhaustion of the engine's oil supply during cruise flight, followed by a forced landing on a country road.…Sep 30, 2002 · N4232H · Substantial damageNTSB SEA02FA185Accident · 2 fatalField investigationFinal reportCessna 172S · Medford, ORTerrain clearance was not maintained during cruise flight. Dark night and mountainous terrain were factors.Sep 30, 2002 · N514SP · Substantial damageNTSB ANC02LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ekwok, AKA partial separation of one propeller blade during cruise flight.Sep 30, 2002 · N723C · Substantial damageNTSB SEA02LA184Accident · No injuriesLimited investigationFinal reportCessna 182 · Estacada, ORThe entanglement of an inadvertently opened skydiver's parachute in the aircraft’s elevator and rudder just after a group of four skydivers positioned themselves on the aircraft's external jump platform prior to a jump.Sep 29, 2002 · N5337B · DestroyedNTSB LAX02LA298Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lucerne Valley, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.Sep 28, 2002 · N6412A · Substantial damageNTSB CHI02LA297Accident · No injuriesLimited investigationFinal reportJonas Nieuport · Creve Coeur, MOThe installation of improper carburetor jets resulting in an improper fuel mixture and loss of engine power.Sep 28, 2002 · N678DJ · Substantial damageNTSB LAX02LA296Accident · Minor injuriesLimited investigationFinal reportWhetzel Thorpe T-18 · Valley Center, CAthe pilot's inadequate preflight planning/preparation by not verifying the fuel supply, and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the pilot's decision to initiate…Sep 25, 2002 · N60LW · Substantial damageNTSB LAX02LA295Accident · No injuriesLimited investigationFinal reportBell 206L-1 · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.Sep 25, 2002 · N601GM · Substantial damage