NTSB investigations, 2002, TX

30 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2002, TX per year, 1962–2026: 2,385 cases
19621
19631
196458
196547
196650
196756
196849
196958
197055
197156
197252
197368
197467
197552
197667
197763
197870
197980
198073
198176
198264
198346
198461
198554
198642
198745
198843
198947
199032
199130
199230
199343
199425
199536
199635
199723
199828
199925
200034
200129
200230
200327
200431
200527
200624
200717
200822
200922
201016
201118
201215
201318
201422
201515
201618
201716
201829
201929
202022
202114
202214
202318
202415
202522
202613

Latest cases

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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    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 FTW03LA070Accident · No injuriesLimited investigationFinal reportCessna T207 · Brownsville, TXThe loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing.Dec 30, 2002 · N1599U · Substantial damageNTSB FTW03LA066Accident · No injuriesLimited investigationFinal reportHughes 369E · Fritch, TXThe 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…Dec 22, 2002 · N5234Y · Substantial damageNTSB FTW03LA061Accident · 1 fatalLimited investigationFinal reportCreekmore Team Rocket F-1 · Rosenberg, TXThe 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.Dec 20, 2002 · N140TC · DestroyedNTSB FTW03LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bryson, TXthe 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.Dec 14, 2002 · N8925W · Substantial damageNTSB FTW03LA041Accident · 1 fatalLimited investigationFinal reportCessna 152 · Houston, TXThe dual student's intentional suicide by exiting from the airplane during descent. A contributing factor was the psychological condition of the dual student.Nov 17, 2002 · N4794P · No damageNTSB 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 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 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 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 FTW02LA247Accident · No injuriesLimited investigationFinal reportEurocopter AS350B3 · Eagle Pass, TXThe insufficient length of the stepper motor rack inside the HMU, which caused the red "GOV" light to illuminate and the fuel metering valve to freeze causing the engine to automatically engage the manual mode.Sep 2, 2002 · N747R · Substantial damageNTSB FTW02LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Price, TXThe loss of engine power for an undetermined reason, which resulted in a forced landing.Aug 31, 2002 · N3961K · Substantial damageNTSB FTW02LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Masterson, TXThe loss of engine power due to fuel starvation as a result of a blockage of the carburetor. A contributing factor was the lack of suitable terrain for the emergency landing.Aug 8, 2002 · N43473 · Substantial damageNTSB FTW02LA227Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Cornudas, TXThe pilot's failure to maintain rotor RPM and his improper landing flare. A contributing factor was the activation of a warning light.Aug 3, 2002 · N681MP · Substantial damageNTSB FTW02LA225Accident · Minor injuriesLimited investigationFinal reportSouthworth EAA Bi-Plane May Bee · West, TXThe pilot's inadequate preflight/planning inspection which resulted in fuel exhaustion and subsequent loss of engine power.Aug 3, 2002 · N11S · Substantial damageNTSB FTW02LA220Accident · Serious injuriesLimited investigationFinal reportFleet 7 Deluxe · Canyon, TXThe loss of engine power as a result of the malfunction of the magneto switch.Jul 27, 2002 · N790V · Substantial damageNTSB FTW02FA192Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Gorman, TXThe pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.Jun 30, 2002 · N8681P · DestroyedNTSB FTW02LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 · Houston, TXThe pilot's loss of control after encountering dynamic rollover during takeoff. A contributing factor was the pilot's inadequate preflight inspection.Jun 28, 2002 · N144WT · Substantial damageNTSB FTW02LA187Accident · 1 fatalLimited investigationFinal reportLidster Wittman Tailwind W-8 · Mesquite, TXThe in-flight separation of the outboard portion of the left wing due to the failure of the wing spar resulting from the builder's improper installation of a wing that did not meet the drawing specifications.Jun 23, 2002 · N14VK · DestroyedNTSB FTW02LA185Accident · Minor injuriesLimited investigationFinal reportQuinn RV-6A · El Paso, TXA loss of engine power for undetermined reasons.Jun 19, 2002 · N799RQ · Substantial damageNTSB FTW02LA159Accident · No injuriesLimited investigationFinal reportCessna 172N · Glen Rose, TXThe pilot's failure to set the ignition key to the both magnetos position, which resulted in a loss of engine power. Contributing factors were the failure of the left magneto, the lack of suitable terrain for the forced landing, and the dark night.May 22, 2002 · N734KG · Substantial damageNTSB FTW02LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Godley, TXthe loss of engine power for undetermined reasons. A contributing factor was the pilot's failure to maintain clearance with the transmission wire during the precautionary landing.May 17, 2002 · N50XP · Substantial damageNTSB FTW02LA119Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cypress, TXthe total loss of engine power as a result of oil starvation due to a missing oil filler cap, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.Apr 11, 2002 · N9321R · Substantial damageNTSB FTW02LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Walnut Hill, TXThe loss of engine power as a result of the backing off of the PC air line "B" nut due to the improper installation by the company maintenance personnel. Contributing factors were the inadequate preflight by the pilot and the lack of suitable terrain for the…Apr 11, 2002 · N513FD · Substantial damageNTSB FTW02LA108Accident · No injuriesLimited investigationFinal reportMooney M20F · Grapeland, TXThe loss of engine power due to the #2 connecting rod cap separating from the connecting rod. A contributing factor was the limited forward visibility due to oil on the windscreen.Mar 30, 2002 · N9530M · Substantial damageNTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.Mar 29, 2002 · N2966B · Substantial damageNTSB FTW02LA129Accident · No injuriesLimited investigationFinal reportBeech F35 · Amarillo, TXFlutter due to the improper balance of the ruddervator, which resulted in structural damage to the aft fuselage.Mar 25, 2002 · N4257B · Substantial damageNTSB FTW02LA083Accident · No injuriesLimited investigationFinal reportNorth American T28C · Fredericksburg, TXthe failure of the pilot to refuel the airplane resulting in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Feb 21, 2002 · N71546 · Substantial damageNTSB NYC02LA065Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Beaumont, TXAn inadvertent encounter with convective induced turbulence, which injured a flight attendant. Factors were the failure of the airline to supply direction to the flight crew to indicate when the flight attendants could begin cabin service, and the convective…Feb 20, 2002 · N24736 · No damageNTSB FTW02FA070Accident · 3 fatalField investigationFinal reportCessna 340A · Temple, TXThe pilot's mismanagement of fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing factors were the pilot's failure to follow the checklist to feather the propellers in order to reduce drag.Jan 17, 2002 · N339S · Destroyed