NTSB investigations, 2002, TX

27 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2002, TX per year, 1964–2026: 3,413 cases
1964154
1965175
1966168
1967202
1968118
1969133
1970101
197197
197275
197378
197481
197576
197686
197782
197872
197984
198087
198191
198274
198361
198461
198548
198640
198748
198824
198926
199024
199119
199222
199321
199416
199528
199635
199735
199827
199935
200025
200124
200227
200331
200433
200529
200629
200732
200834
200928
201042
201130
201232
201332
201428
201522
201639
201726
201833
201924
202036
202123
202238
202334
202427
202526
202625

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 = 550)
  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 FTW03LA062Accident · No injuriesLimited investigationFinal reportCessna 195 · Wink, TXThe separation of the main landing gear axle bolt from the landing gear assembly.Dec 20, 2002 · N195SR · Substantial damageNTSB FTW03LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Odessa, TXThe pilot's inadvertent failure to extended the landing gear.Dec 13, 2002 · N6068P · Substantial damageNTSB FTW03LA058Accident · No injuriesLimited investigationFinal reportRamsay Lancair IV-P · Bulverde, TXThe pilot's misjudgment of speed and distance.Nov 21, 2002 · N222MR · Substantial damageNTSB FTW03LA001Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235C · San Antonio, TXThe pilot's failure to compensate for the existing winds conditions. A contributing factor was the prevailing tailwind.Oct 1, 2002 · N4269B · DestroyedNTSB FTW02LA268Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Del Rio, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the reported gusting wind conditions.Sep 29, 2002 · N952LC · Substantial damageNTSB FTW02LA269Accident · No injuriesLimited investigationFinal reportCessna 421B · Mineral Wells, TXThe pilot's failure to maintain a proper descent rate which resulted hard landing and a subsequent failure of the main landing gear.Sep 28, 2002 · N7926R · Substantial damageNTSB FTW02CA249Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Graham, TXthe pilot's failure to attain the proper touchdown point which resulted in a runway overrun.Sep 4, 2002 · N9855S · Substantial damageNTSB FTW02LA238Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Rosenburg, TXthe failure of the pedestrian to perform a visual lookout while walking on the runway which resulted in a on-ground collision with the airplane.Aug 21, 2002 · N628LA · Minor damageNTSB FTW02LA219Accident · No injuriesLimited investigationFinal reportSchempp-Hirth K.G. Nimbus-2C · Briggs, TXthe pilot's failure to maintain clearance with the high grass during the landing roll, which resulted in a ground loop.Jul 21, 2002 · N141SF · Substantial damageNTSB FTW02CA207Accident · No injuriesData collectionFinal reportGulfstream American AA-5B · Spicewood, TXthe pilot's failure to maintain directional control during landing roll.Jul 13, 2002 · N358RW · Substantial damageNTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.Jul 8, 2002 · N7550X · Substantial damageNTSB DEN02LA058Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Giddings, TXthe failure of the pilot to maintain aircraft control during the landing rollout. A contributing factor was the subsequent inadvertent ground loop of the airplane.Jun 24, 2002 · N83DH · Substantial damageNTSB FTW02LA188Accident · No injuriesLimited investigationFinal reportCessna 182Q · Midland, TXThe pilot's hard landing as a result of her improper landing flare. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.Jun 21, 2002 · N5327N · Substantial damageNTSB FTW02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Pecos, TXThe pilot misjudged the landing flare resulting in a hard landing. A contributing factor was the dark night conditions.Jun 17, 2002 · N675MP · Substantial damageNTSB FTW02LA178Accident · No injuriesLimited investigationFinal reportCessna 172M · Kirbyville, TXthe pilot's failure to attain the proper touchdown point. A contributing factor was the loose gravel.Jun 15, 2002 · N21799 · Substantial damageNTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.Jun 9, 2002 · N2282Y · Substantial damageNTSB FTW02LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Dalhart, TXThe pilot's failure to maintain aircraft control. Contributing factors were the shifting gusty winds and the ditch.Jun 2, 2002 · N4261Q · Substantial damageNTSB FTW02LA169Accident · No injuriesLimited investigationFinal reportGolias RV6 · Leander, TXthe pilot's failure to maintain directional control while landing. Contributing factor is the pilot's improper recovery from a bounced landing.May 31, 2002 · N16PG · Substantial damageNTSB FTW02LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-S · La Porte, TXThe failure of a hydraulic line, which resulted in the loss of the brakes.May 25, 2002 · N98TT · Substantial damageNTSB FTW02LA156Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Frankston, TXthe pilot's failure to adequately compensate for wind conditions while landing on the water which resulted in a water loop/swerve. A contributing factor was a wind gust.May 19, 2002 · N1298L · Substantial damageNTSB FTW02LA165Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Palestine, TXThe failure of the nose gear actuator aft attach point from the tube cluster on the engine mount assembly. A contributing factor was the owner's non-compliance with the service bulletin for inspection/replacement of the engine mount.May 18, 2002 · N529TX · Substantial damageNTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.May 9, 2002 · N48819 · Substantial damageNTSB FTW02LA136Accident · No injuriesLimited investigationFinal reportCessna 560 · Leakey, TXThe pilots failure to land the aircraft at the proper touchdown point on the runway to allow adequate stopping distance.May 2, 2002 · N397QS · DestroyedNTSB FTW02LA123Accident · No injuriesLimited investigationFinal reportHalfacre Velocity · Cleveland, TXthe pilot's failure to maintain the proper descent rate during the landing flare/touchdown.Apr 16, 2002 · N355BH · Substantial damageNTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.Apr 8, 2002 · N99341 · Substantial damageNTSB FTW02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Iraan, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were the pilot's selection of a downwind runway for landing, the tail wind condition, and his lack of total experience in the type of aircraft.Jan 15, 2002 · N509R · Substantial damageNTSB FTW02LA068Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXthe student pilot's failure to maintain directional control during landing.Jan 12, 2002 · N497SJ · Substantial damage