NTSB investigations, 1990, UT

9 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1990, UT per year, 1964–2026: 673 cases
196430
196516
196627
196722
196815
196916
197011
19714
197210
197311
19744
19758
197618
197712
19787
197911
198017
198114
198212
19836
198411
19857
198610
19879
19886
19899
19909
199110
19923
199310
19948
19956
19968
199711
199810
19998
200011
200113
200212
200310
200413
20058
20069
200713
200817
200914
20108
201110
20126
20137
20146
20157
20165
20179
20189
201912
20205
20216
202213
202313
202411
20258
202612

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\") = 1990
    AND c.\"eventStateOrRegion\" = 'UT' 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 SEA91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe certified flight instructor's inability to regain directional control after it was lost by his dual student on an icy, snowy runway.Dec 27, 1990 · N5133B · Substantial damageNTSB DEN90LA162Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Logan, UTThe pilot's failure to maintain directional control and his improper use of the wheel brakes. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.Jul 12, 1990 · N45537 · Substantial damageNTSB DEN90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Clarkston, UTJammed ailerons resultant from the collision with crops.Jul 12, 1990 · N9980P · Substantial damageNTSB DEN90LA133Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Brigham City, UTThe pilot's failure to attain the proper touchdown point.Jun 13, 1990 · N3637F · Substantial damageNTSB DEN90LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Ogden, UTThe failure of the main gear locking mechanism.May 28, 1990 · N8148M · Substantial damageNTSB DEN90LA117Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Morgan, UTPilot's improper use of the brakes during landing roll.May 26, 1990 · N1113B · Substantial damageNTSB DEN90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Delta, UTThe pilot's loss of directional control during landing. Factors were gusting tailwinds and the pilot selected the wrong runway.May 19, 1990 · N6392Q · Substantial damageNTSB DEN90LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Price, UTThe pilot's inadequate conpensation for the gusty wind conditions, which were a factor.Mar 26, 1990 · N4540X · Substantial damageNTSB DEN90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nephi, UTFailure of the pilot to maintain direction control and correct the resultant ground swerve. The snow bank was a related factor.Feb 22, 1990 · N81658 · Substantial damage