NTSB investigations, 2005, OR

13 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2005, OR per year, 1964–2026: 1,009 cases
196423
196528
196639
196753
196837
196918
197023
197118
197215
197326
197421
197520
197624
197722
197819
197932
198023
198120
198222
198313
198410
198517
19869
19877
19887
198911
199016
199110
199211
19938
199412
199515
199618
19977
199812
199911
200022
200116
200215
200313
200410
200513
20068
200714
200819
20099
201012
201113
201214
201312
20148
20159
201612
201710
201819
20199
20207
202112
202213
20236
202414
20259
202614

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\") = 2005
    AND c.\"eventStateOrRegion\" = 'OR' 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 SEA06CA002Accident · No injuriesData collectionFinal reportBeech D35 · Creswell, ORThe pilot's failure to attain a proper touchdown point and worn brakes. Inadequate maintenance was a factor.Oct 3, 2005 · N2106D · Substantial damageNTSB SEA05CA183Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Chiloquin, ORThe failure of the left chain link which permits the pilot to control the tailwheel, and the subsequent inability of the pilot to control the airplane during the landing roll.Aug 27, 2005 · N11661 · Substantial damageNTSB SEA05CA168Accident · No injuriesData collectionFinal reportHughes 269A · Ashland, ORThe inability of the dual student to maintain directional control of the helicopter during the landing roll when the left skid sank into an area of thick, soft, sticky tar, and the instructor pilot's improper decision to perform a full-down autorotational…Aug 12, 2005 · N488MC · Substantial damageNTSB SEA05LA144Accident · No injuriesLimited investigationFinal reportCessna 180 · Prospect, ORThe pilot's inadequate in-flight decision to perform a wheel landing with a 5 to 10 knot tail wind, and his subsequent loss of aircraft directional control during the landing roll. A tailwind and soft terrain were factors.Jul 16, 2005 · N2944C · Substantial damageNTSB SEA05CA142Accident · No injuriesData collectionFinal reportBeech H-35 · Oregon City, ORThe unattended animal on the runway during the landing, which caused the pilot to pull up and land a second time, resulting in an overrun. A factor contributing to the accident was the inability to abort the landing due to obstacles at the end of the runway.Jul 14, 2005 · N5576D · Substantial damageNTSB SEA05LA137Accident · No injuriesLimited investigationFinal reportScheibe SF-28A Tandem-Falke · North Plains, ORThe pilot's failure to maintain airspeed during landing. Inadequate emergency procedures training and high vegetation were factors.Jul 3, 2005 · N12HS · Substantial damageNTSB SEA05CA113Accident · No injuriesData collectionFinal reportMicco MAC-145A · Aurora, ORThe demonstration pilot's (pilot in command) inadequate supervision of the pilot-passengers descent on final for landing. A contributing factor was the pilot-passengers improper descent on final for landing.Jun 9, 2005 · N223MJ · Substantial damageNTSB SEA05CA123Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ontario, ORThe pilot's failure to maintain aircraft control during landing roll. A contributing factor was the cross wind weather condition.Jun 7, 2005 · N5814D · Substantial damageNTSB SEA05LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Medford, ORThe pilot's failure to maintain directional control during the landing roll. Factors include variable winds that at times were crosswinds.Apr 8, 2005 · N4948Q · Substantial damageNTSB SEA05CA078Accident · No injuriesData collectionFinal reportShannon Lancair Legacy 2000 · Bend, ORThe pilot's failure to put the landing gear down for landing.Apr 8, 2005 · N115YP · Substantial damageNTSB SEA05LA054Accident · 1 fatalLimited investigationFinal reportSimpkins RV-6A · Yamhill, ORThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in a nose over. Factors contributing to the accident included the wet runway and the embankment.Mar 6, 2005 · N664DS · Substantial damageNTSB SEA05LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · The Dalles, ORThe student pilot's improper compensation for the wind condition and the improper rejected landing procedure, which resulted in the collision with terrain. A contributing factor to the accident was the crosswind condition.Feb 22, 2005 · N181WC · Substantial damageNTSB SEA05LA056Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Prineville, OROther maintenance personnel's inadequate reassembly of the tail wheel assembly and the left main landing gear breaking assembly resulting in an inadvertent loss of control during the landing roll. Contributing factors were the pilot's inadvertent swerve…Jan 30, 2005 · N53719 · Substantial damage