NTSB investigations, 2002, ID

19 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2002, ID per year, 1964–2026: 745 cases
196429
196518
196620
196718
196819
196914
197021
197114
197212
19739
197417
197517
19769
19779
19789
197913
19809
19819
19826
19838
198411
198510
198613
19875
19888
19891
19908
19916
19928
199311
199411
19955
199612
19974
199812
199914
20009
20019
200219
200315
200413
20059
200611
200719
200810
200913
201019
20118
201218
201311
20147
201510
20169
201715
201811
201917
20207
202117
202211
202311
202415
20256
20267

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\" = 'ID' 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 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 SEA03LA003Accident · No injuriesLimited investigationFinal reportMooney M20K · Rexburg, IDThe pilot's failure to perform a go-around once it became evident that his remedial action was not adequate to overcome the porpoise/pilot-induced oscillation that occurred during the landing flare. Factors include the pilot's inadvertent repeated…Oct 12, 2002 · N231EH · Substantial damageNTSB SEA02LA183Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18 · Gannett, IDThe pilot's excessive braking during the landing rollout.Sep 28, 2002 · N380CC · Substantial damageNTSB SEA02LA179Accident · No injuriesLimited investigationFinal reportCessna R172K · Salmon, IDFailure to maintain airspeed while on approach which resulted in an aerodynamic stall and hard landing.Sep 21, 2002 · N1071V · Substantial damageNTSB SEA02LA177Accident · No injuriesLimited investigationFinal reportCessna 182L · McCall, IDThe pilot's failure to maintain adequate airspeed and an acceptable rate of descent while on short final for landing, and his failure to maintain directional control after the resultant hard landing. Factors include a ditch near the temporary runway (taxiway)…Sep 21, 2002 · N42862 · DestroyedNTSB SEA02LA188Accident · No injuriesLimited investigationFinal reportAviat A-1B · Arco, IDThe pilot's inadequate compensation for wind conditions, resulting in an inadvertent ground loop. Factors include wind gusts during the period of time at which the landing took place.Sep 8, 2002 · N290AM · Substantial damageNTSB SEA02LA159Accident · Serious injuriesLimited investigationFinal reportBeech C-35 · Nampa, IDThe pilot's failure to maintain aircraft control following an inadvertent opening of the airplane's storm window.Aug 17, 2002 · N1888D · Substantial damageNTSB SEA02LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Shearer, IDThe pilot's failure to maintain the proper approach speed while on final approach to the 2000 foot airstrip, and his excessive application of brakes while attempting to stop the aircraft during the resultant longer than normal landing roll. Factors include a…Aug 11, 2002 · N1573P · Substantial damageNTSB SEA02LA122Accident · No injuriesLimited investigationFinal reportHead Balloons AX8-88 · Victor, IDThe pilot's failure to maintain altitude/clearance from the power lines during the landing resulting in the balloon's impacting the wires. Contributing factors were the power lines and strong winds existent at the time.Jul 5, 2002 · N4522E · Substantial damageNTSB SEA02LA114Accident · Minor injuriesLimited investigationFinal reportHunter Comp Air 6 · McCall, IDThe pilot's inadequate compensation for wind conditions. Contributing factors were a 30 degree crosswind and the pilot's lack of experience in the newly acquired make/model aircraft.Jun 28, 2002 · N6008N · Substantial damageNTSB SEA02LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Donnelly, IDThe pilot's failure to arrest an excessive descent rate during an attempted landing, and his inadequate recovery from a bounced landing. Factors include a high density altitude , and trees near the runway.Jun 26, 2002 · N42505 · DestroyedNTSB SEA02LA105Accident · No injuriesLimited investigationFinal reportCessna 180K · Idaho Falls, IDThe pilot's inadequate compensation for wind conditions during the landing roll. A crosswind was a factor.Jun 23, 2002 · N2801K · 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 SEA02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Payette, IDThe pilot's failure to adequately compensate for the wind conditions during landing resulting in a ground loop/swerve. Wind gusts were a contributing factor.Jun 2, 2002 · N9967Q · Substantial damageNTSB SEA02LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Lewiston, IDThe pilot's failure to maintain directional control during the landing resulting in the aircraft departing the runway environment and the wing impacting the ground. Contributing factors were the dustdevil/whirlwind which the aircraft encountered and the ditch.May 27, 2002 · N9845Q · Substantial damageNTSB SEA02LA081Accident · Minor injuriesLimited investigationFinal reportCook Coot A · Harrison, IDThe pilot's failure to detect an unsafe boat wake during the landing process, and his inadvertent initiation of a porpoise after coming in contact with the boat wake just after touchdown on a body of water. Factors include a large wake wave/swell created by…May 12, 2002 · N12QQ · Substantial damageNTSB SEA02LA077Accident · No injuriesLimited investigationFinal reportCessna 177B · New Plymouth, IDThe pilot's use of unsuitable terrain (landing surface) at his privately owned landing site. A contribtuing factor was the soft area which the aircraft's right main wheel encountered.Apr 28, 2002 · N34858 · Substantial damageNTSB SEA02LA068Accident · No injuriesLimited investigationFinal reportSteele Steen Skybolt · Coeur d' Alene, IDThe pilot's failure to maintain directional control during the landing rollout.Apr 11, 2002 · N858RS · Substantial damageNTSB SEA02LA057Accident · No injuriesLimited investigationFinal reportCessna 340 · Idaho Falls, IDThe overload of the right main landing gear bellcrank, adjustable end fitting and clevis ears resulting in fractures and the subsequent gear collapse.Mar 23, 2002 · C-FFZJ · Substantial damage