NTSB investigations, 2003, ID

15 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2003, 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\") = 2003
    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 SEA04LA028Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent group loop and the collapse of the right main landing gear.Dec 17, 2003 · N290AM · Substantial damageNTSB SEA04LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Emmett, IDBrake failure as a result of inadequate hydraulic (brake) fluid in the aircraft's closed brake system. Contributing factors were the pilot's overall lack of experience in the aircraft make/model, the cold soaked brake system due to the low temperatures, and…Nov 23, 2003 · N8982C · Substantial damageNTSB SEA03CA195Accident · No injuriesData collectionFinal reportCessna 180 H · Council, IDAircraft control not maintained during the landing roll. Factors include soft, water soaked terrain.Sep 26, 2003 · N9707G · Substantial damageNTSB SEA03LA191Accident · No injuriesLimited investigationFinal reportLevick RAF 2000 GTX-SE · Bonners Ferry, IDThe pilot's inadequate compensation for gusty wind conditions and his failure to maintain directional control, which resulted in the gyrocraft departing the runway and the main rotor impacting the ground. A contributing factor was wind gusts.Sep 19, 2003 · N24DN · Substantial damageNTSB SEA03LA181Accident · No injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDThe instructor's inadequate supervision, and the student's failure to maintain directional control.Aug 29, 2003 · N1027X · Substantial damageNTSB SEA03LA175Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Cottonwood, IDThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane. Factors contributing to the accident were the updraft, the terrain drop-off, and the fence.Aug 20, 2003 · N80978 · Substantial damageNTSB SEA03LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Nampa, IDLanding gear collapse for undetermined reasons during the landing roll. On ground collision with a runway light was a factor.Aug 20, 2003 · N4816T · Substantial damageNTSB SEA03LA171Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Emmett, IDThe pilot's failure to adequately compensate for a quartering tailwind during the initial part of the landing roll, and his failure to adequately decrease his brake applications to compensate for the tailwind conditions. Factors include, variable, gusting…Aug 17, 2003 · N185LC · Substantial damageNTSB SEA03LA167Accident · No injuriesLimited investigationFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain control of the aircraft during the landing roll. A contributing factor was the dust devil.Aug 11, 2003 · N233HY · Substantial damageNTSB SEA03CA119Accident · No injuriesData collectionFinal reportCessna P206 · Gooding, IDImproper flare while landing. Factors include inadequate preflight preparation and a tow bar that had not been removed prior to the flight.Jun 27, 2003 · N2825X · Substantial damageNTSB SEA03LA113Accident · No injuriesLimited investigationFinal reportCessna 206 · Soldier Bar, IDThe overload failure of the nose landing gear assembly during the landing roll, due to an improper maintenance installation. A factor was the rough/uneven terrain condition.Jun 17, 2003 · N7372Q · Substantial damageNTSB SEA03LA083Accident · No injuriesLimited investigationFinal reportCessna 182J · Payette, IDThe pilot-in-command's failure to maintain directional control during the landing roll resulting in the aircraft departing the runway environment, collapsing the nose gear and nosing over. Contributing factors were the pilot-in-command's failure to execute a…May 17, 2003 · N3450F · Substantial damageNTSB SEA03LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Boise, IDThe landing gear extension was not performed by the pilot for landing. Contributing factors included the pilot's failure to perform the Before Landing checklist and his unfamiliarity with the landing gear warning horn system.May 10, 2003 · N711BG · Substantial damageNTSB SEA03LA066Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Plummer, IDThe jamming of the left parking brake locking tab on a burr on the left brake master cylinder activation rod during the landing roll, resulting in the left brake becoming locked in a position where excessive braking was applied.Apr 20, 2003 · N114MK · Substantial damageNTSB SEA03LA056Accident · Minor injuriesLimited investigationFinal reportCessna TU206 G · Pistol Creek, IDInadequate visual lookout by the driver of the vehicle that turned on to the runway. Factors include rising terrain decreasing the possibility of a successful go-around and rough uneven terrain beyond the departure end of the runway.Apr 7, 2003 · N756WZ · Substantial damage