NTSB investigations, 2003, MN

9 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2003, MN per year, 1964–2026: 1,030 cases
196445
196552
196654
196749
196832
196937
197031
197118
197233
197324
197423
197531
197623
197727
197832
197920
198024
198122
198221
198316
198410
198513
19866
19879
198811
198914
199010
199117
199210
199311
19948
19958
199610
199715
19988
199911
200012
200110
200210
20039
20046
200513
200615
20079
200811
200911
20107
20119
201211
201313
20145
20155
20167
20176
20184
20197
202011
20215
20228
202316
20249
20259
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\" = 'MN' 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 CHI04CA020Accident · Minor injuriesData collectionFinal reportShapowal Rotorway Exec 90 · Cushing, MNSelection of an unsuitable landing area by the pilot due to the static wire across the approach path. Contributing factors were the pilot's disorientation, the static wire and the low light (dusk) conditions.Oct 24, 2003 · N442DS · Substantial damageNTSB CHI03LA326Accident · No injuriesLimited investigationFinal reportCessna 210 · St. Paul, MNThe pilot in command performing an improper flare.Sep 1, 2003 · N7445E · Substantial damageNTSB CHI03LA313Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Slayton, MNThe excessive descent rate during the balloon's landing by the student pilot.Aug 11, 2003 · N2789N · No damageNTSB CHI03LA190Accident · No injuriesLimited investigationFinal reportCessna A185F · Eveleth, MNThe pilot's misjudgment of speed and distance resulting in an overrun. Factors were the ditch embankment, and the tailwind component.Jul 1, 2003 · N30CM · Substantial damageNTSB CHI03LA163Accident · No injuriesLimited investigationFinal reportCessna 172N · Anoka, MNThe pilot's failure to attain the proper touchdown point, and his failure to maintain directional control. Contributing factors were the pilot's lack of experience, and the runway sign.Jun 14, 2003 · N2238E · Substantial damageNTSB CHI03LA147Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Cottage Grove, MNThe inadequate touchdown by the pilot.Jun 3, 2003 · N52461 · No damageNTSB CHI03LA137Accident · Minor injuriesLimited investigationFinal reportLongjev RV-6A · Backus, MNThe pilot's inadequate flare and recovery from a bounced landing.May 27, 2003 · N72159 · Substantial damageNTSB CHI03LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Owatonna, MNThe pilots loss of directional control on landing and subsequent collision with terrain. Contributing factors were the crosswind, the airport lights, and the ditch.Mar 23, 2003 · N92505 · Substantial damageNTSB CHI03LA079Accident · No injuriesLimited investigationFinal reportCessna 172R · St. Paul, MNThe loss of directional control by the solo student pilot. A factor to the accident was the excessive speed during landing.Mar 5, 2003 · N35307 · Substantial damage