# NTSB investigations, 2004, OR: Landing

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB SEA05LA024](https://openairdocs.org/ntsb/SEA05LA024.md): Maule MX-7-235 · Hermiston, OR · Accident · No injuries · Limited investigation · Final report · Dec 4, 2004 · N420CD · Substantial damage
  > An improper flare and descent rate during landing resulting in a hard landing.
- [NTSB SEA05LA015](https://openairdocs.org/ntsb/SEA05LA015.md): Luscombe 11A · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Nov 13, 2004 · N1627B · Substantial damage
  > The student pilot's failure to maintain directional control during the landing roll. Also causal were the instructor's inadequate supervision and remedial action. Factors include soft terrain just off the side of the runway.
- [NTSB SEA05CA003](https://openairdocs.org/ntsb/SEA05CA003.md): Piper PA-22/20 · Medford, OR · Accident · No injuries · Data collection · Final report · Oct 2, 2004 · N2849Z · Substantial damage
  > The pilot's inadequate compensation for crosswind conditions during landing, resulting in his failure to maintain directional control. Factors include the presence of crosswinds.
- [NTSB SEA04CA171](https://openairdocs.org/ntsb/SEA04CA171.md): Cessna 182P · Hillsboro, OR · Accident · Minor injuries · Data collection · Final report · Aug 23, 2004 · N1316S · Substantial damage
  > The pilot's failure to maintain aircraft directional control during landing roll. A contributing factor was the right-quartering tail wind.
- [NTSB SEA04CA170](https://openairdocs.org/ntsb/SEA04CA170.md): Cessna 180J · Pittsburg, OR · Accident · No injuries · Data collection · Final report · Aug 18, 2004 · N52096 · Substantial damage
  > The pilot's failure to maintain clearance from an object (pole) during an aborted landing. The pilot's delayed decision to abort the landing and a pole were factors.
- [NTSB SEA04LA153](https://openairdocs.org/ntsb/SEA04LA153.md): Piper PA-24-260 · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Aug 1, 2004 · N9394P · Substantial damage
  > Unknown malfunction of the landing gear system for undetermined reasons that resulted in a gear collapse during landing.
- [NTSB SEA04CA116](https://openairdocs.org/ntsb/SEA04CA116.md): Champion 7GCB · Florence, OR · Accident · No injuries · Data collection · Final report · Jun 21, 2004 · N9827Y · Substantial damage
  > Pilot's improper touchdown point during landing. A sand mound was a factor in the accident.
- [NTSB SEA04CA109](https://openairdocs.org/ntsb/SEA04CA109.md): Balloon Works Fire Fly 9 · Aurora, OR · Accident · Serious injuries · Data collection · Final report · Jun 17, 2004 · N3097R · Minor damage
  > Pilot's failure to compensate for wind conditions. Wind was a contributing factor.
- [NTSB SEA04LA096](https://openairdocs.org/ntsb/SEA04LA096.md): Cessna 172M · Vernonia, OR · Accident · No injuries · Limited investigation · Final report · May 29, 2004 · N5440H · Substantial damage
  > The instructor pilot's misjudgment of speed and distance and his failure to execute a go-around resulting in an overrun of the runway.
- [NTSB SEA04LA040](https://openairdocs.org/ntsb/SEA04LA040.md): Lancair LC42-550FG · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Feb 10, 2004 · N6503C · Substantial damage
  > The pilot rated passenger's failure to maintain directional control during the landing roll. Inadequate supervision by the pilot-in-command (CFI) and a taxiway sign were factors.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2004
  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
```

This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?state=OR&year=2004

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
