OpenAirDocs.org

NTSB investigations, 2003, WI

11 cases where the phase of flight was Landing.

Cases per year

19642026

Where

Open the map

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\" = 'WI' 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 CHI04LA042Accident · No injuriesLimited investigationFinal reportBeech 99 · Mosinee, WIThe pilot's failure to maintain the proper descent rate and his inadequate flare.Dec 16, 2003 · N399CZ · Substantial damageNTSB CHI04LA036Accident · No injuriesLimited investigationFinal reportCessna 182R · Wausau, WIThe pilot 's improper flare which resulted in a hard landing, and the flight instructors inadequate supervision.Nov 22, 2003 · N323KW · Substantial damageNTSB CHI04LA034Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Superior, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the ditch that the airplane contacted.Nov 21, 2003 · N28693 · Substantial damageNTSB CHI03LA321Accident · No injuriesLimited investigationFinal reportCessna 305A · New Richmond, WIThe pilot's inadequate compensation for wind and his failure to maintain directional control. The pilot's in-flight selection of the wrong runway and excessive application of brake pressure are contributing factors.Sep 25, 2003 · N5237G · Substantial damageNTSB CHI03LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wausau, WIThe excessive free play resulting in a loose tail wheel assembly and a failure of the flight crew to maintain directional control during the landing rollout.Sep 8, 2003 · N5595H · Substantial damageNTSB CHI03FA238Accident · No injuriesField investigationFinal reportDegair Lancair 360 · Oshkosh, WIThe other airplane pilot's inadequate visual look out and his failure to perform a go-around, and maintain clearance from the other aircraft.Aug 1, 2003 · N3602D · 2 aircraft · Substantial damageNTSB CHI03FA234Accident · No injuriesField investigationFinal reportBeech M35 · Oshkosh, WIThe pilot's inadequate in-flight planning/decision and his failure to execute a go-around. Contributing factors were the pilot's failure to attain alignment with the runway centerline, the runway light and the airport sign.Jul 29, 2003 · N9785R · Substantial damageNTSB CHI03LA222Accident · No injuriesLimited investigationFinal reportCessna 195 · Racine, WIThe failure of the left main landing gear axle resulting in the brake being locked and subsequent loss of directional control.Jul 19, 2003 · N355ST · Substantial damageNTSB CHI03LA206Accident · No injuriesLimited investigationFinal reportCessna 140 · Sullivan, WIThe pilot's inadequate compensation for wind conditions resulting in a loss of directional control. A factor contributing to the accident was the crosswind.Jul 13, 2003 · N2180V · Substantial damageNTSB CHI03LA173Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Monroe, WIThe pilot's failure to maintain clearance from the transmission wires during landing and his decision to jump from the balloon. A factor to the accident was the power transmission lines.Jun 21, 2003 · N5253Y · No damageNTSB CHI03LA162Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · West Bend, WIThe pilot's excessive braking during landing roll. Contributing factors to this accident were the pilot's lack of experience in the accident airplane.Jun 13, 2003 · N930V · Substantial damage