NTSB investigations, 2008, OR

19 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2008, 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\") = 2008
    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 SEA08CA204Accident · No injuriesData collectionFinal reportGoetz RAF 2000 · Mulino, ORThe pilot's failure to maintain directional control during landing.Sep 18, 2008 · N554BG · Substantial damageNTSB LAX08CA285Accident · No injuriesData collectionFinal reportMason Falconar F-11 · Creswell, ORThe pilot's failure to maintain a stabilized approach, inadequate recovery from a bounced landing, and failure to maintain directional control.Aug 28, 2008 · N65017 · Substantial damageNTSB LAX08CA280Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Wasco, ORThe pilot's failure to maintain directional control while landing.Aug 23, 2008 · N2870D · Substantial damageNTSB LAX08CA262Accident · Minor injuriesData collectionFinal reportLet Blanik L-13 · Bend, ORThe pilot's misjudged distance/altitude which resulted in an undershoot while on final approach to land. Factors contributing to the accident were the lack of thermal lift (sinking air), and the lack of suitable terrain for the off-airport landing.Aug 9, 2008 · N62345 · Substantial damageNTSB LAX08CA278Accident · No injuriesData collectionFinal reportPiper PA-22 · St. Paul, ORThe pilot's misjudged altitude, speed, and subsequent failure to attain the proper touchdown point while landing.Jul 31, 2008 · N2441P · Substantial damageNTSB SEA08FA161Accident · 1 fatalField investigationFinal reportCessna 441 · Sunriver, ORThe pilot's misjudged landing flare and improper recovery from a bounced landing, and the pilot's failure to maintain directional control during the go-around after one of the airplane's propellers struck the runway.Jul 16, 2008 · N441HK · DestroyedNTSB LAX08LA304Accident · No injuriesLimited investigationFinal reportBeech N35 · The Dalles, ORA collapse of the right main landing gear for undetermined reasons.Jul 10, 2008 · N931B · Substantial damageNTSB LAX08CA227Accident · Minor injuriesData collectionFinal reportBeech E17B · Hubbard, ORThe pilot's improper use of brakes during the landing rollout.Jul 8, 2008 · N233EB · Substantial damageNTSB LAX08CA243Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Canyon City, ORThe pilot's failure to maintain directional control. Contributing to the accident was the gusting tailwind.Jul 7, 2008 · N2851Z · Substantial damageNTSB LAX08CA208Accident · No injuriesData collectionFinal reportPipistrel Virus 912 · Bend, ORThe pilot's improper flare, inadequate bounced landing recovery, and his failure to maintain directional control.Jul 1, 2008 · N126BF · Substantial damageNTSB LAX08LA201Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Rainier, ORThe inadvertent extension of the left float's landing gear to near the down position due to a failure of the gear's rear hydraulic seal.Jun 28, 2008 · N5403E · Substantial damageNTSB SEA08LA157Accident · No injuriesLimited investigationFinal reportRockwell 690B · Baker City, ORThe landing gear collapse during the landing roll due to the fracture of the inboard hydraulic cylinder clevis pin housing boss for undetermined reasons.Jun 25, 2008 · N9KG · Substantial damageNTSB LAX08CA174Accident · Minor injuriesData collectionFinal reportCessna 182 · Cottage Grove, ORThe pilot's misjudged landing flare.Jun 10, 2008 · N182RA · Substantial damageNTSB LAX08CA156Accident · No injuriesData collectionFinal reportCessna 172P · Troutdale, ORThe student pilot's failure to maintain directional control, which resulted in collision with a runway light.May 24, 2008 · N62348 · Substantial damageNTSB SEA08CA131Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-40 · Lakeview, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Contributing to the accident was the crosswind was a factor.May 11, 2008 · N196DC · Substantial damageNTSB SEA08CA130Accident · No injuriesData collectionFinal reportBeech B19 · Burns, ORThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. The shifting wind was a factor.May 10, 2008 · N9342S · Substantial damageNTSB SEA08CA112Accident · No injuriesData collectionFinal reportCessna 185E · Bend, ORThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was an unexpected crosswind gust.Apr 26, 2008 · N185NH · Substantial damageNTSB LAX08LA080Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORThe failure of company maintenance personnel to install the upper pivot bolt through the pivot hole in the upper end of the landing gear actuating rod, and the company maintenance inspector's inadequate inspection of the work performed.Mar 20, 2008 · N4098A · Substantial damageNTSB LAX08CA053Accident · Minor injuriesData collectionFinal reportCessna 172N · Beaver Marsh, ORThe pilot's inadequate in-flight planning/decision to land on a snow covered runway without first determining the depth of the snow.Jan 25, 2008 · N734KU · Substantial damage