Fatal NTSB investigations, 2002

11 cases where the phase of flight was Landing.

Cases per year

19622026
Fatal NTSB investigations, 2002 per year, 1962–2026: 766 cases
19631
19648
196510
196611
196710
196821
196911
197015
197114
197219
197311
197421
19758
197623
197715
197821
197912
198021
198120
198216
198317
198416
198512
198614
198710
19888
19898
199011
19917
199216
19939
19948
199510
199614
19974
19987
199912
200011
20017
200211
200313
200410
200513
200613
200710
20088
20096
201012
20115
201210
20137
20149
20159
20166
201713
201811
201915
202012
202115
202219
20239
202413
202515
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.\"highestInjuryLevel\" = 'Fatal'
    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 LAX03LA055Accident · 1 fatalLimited investigationFinal reportLipscomb Lancair 235 · Payson, AZthe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in an inadvertent stall/spin. A contributing factor in the accident was the pilot's lack of familiarity with the airplane.Dec 28, 2002 · N777KL · Substantial damageNTSB CHI03LA013Accident · 1 fatalLimited investigationFinal reportWondrasek Rans S-10 Sakota · Missouri Valley, IAThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A factor was the low altitude.Oct 18, 2002 · N228DW · DestroyedNTSB SEA03LA005Accident · 2 fatalLimited investigationFinal reportIV Lancair IV · Coeur d'Alene, IDThe pilot's inadequate flare and his failure to maintain runway alignment. The pilot's lack of familiarity,downsloping terrain, and trees are contributing factors.Oct 15, 2002 · N599L · Substantial damageNTSB NYC02LA183Accident · 1 fatalLimited investigationFinal reportRoyse Glasair · Flemingsburg, KYThe pilot's improper recovery from a bounced landing, which resulted in a loss of control on the ground. A factor was the pilot's lack of experience in the type of aircraft.Sep 6, 2002 · N582RR · Substantial damageNTSB NYC02FA177Accident · 1 fatalField investigationFinal reportGates Learjet 25C · Lexington, KYThe captain's addition of forward thrust during the landing rollout, which resulted in a lack of braking effectiveness and a subsequent runway overrun. A factor was the captain's inability to deploy the thrust reversers for undetermined reasons.Aug 30, 2002 · N45CP · DestroyedNTSB ANC02FA106Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 MK3 · Aleknagik, AKThe pilot's failure to use a checklist to ensure the airplane was in the proper landing configuration, which precipitated an inadvertent water landing on amphibious floats with the wheels extended. A factor contributing to the accident was the pilot's failure…Aug 29, 2002 · N4478 · 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 LAX02FA247Accident · 2 fatalField investigationFinal reportBeech 58TC · Avalon, CAthe pilot's misjudged distance and speed during the landing approach, which resulted in an overrun of the runway. Also causal was the pilot's failure to conduct a go-around during the approach, or abort the landing when an overrun became obvious.Aug 2, 2002 · N2102L · DestroyedNTSB 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 SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.Jun 22, 2002 · N658B · Substantial damageNTSB LAX02LA109Accident · 1 fatalLimited investigationFinal reportTrenti RV-4 · Jacumba, CAin-flight loss of control for undetermined reasons.Mar 15, 2002 · N491T · Destroyed