NTSB investigations, UT

673 cases where the phase of flight was Landing.

Cases, newest first

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 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 SEA96LA147Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-19 · Salem, UTThe pilot's failure to attain a proper touchdown point during an off-airport landing. Factors relating to the accident were: loss of thermal lift, high obstructions (transmission wires) near the edge of the field that the pilot chose to land, and a bale of…Jul 5, 1996 · N19KH · Substantial damageNTSB SEA96LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Erda, UTfailure of the pilot to maintain directional control of the airplane during the landing. Darkness was a related factor.Apr 27, 1996 · N24316 · Substantial damageNTSB SEA96LA051Accident · No injuriesLimited investigationFinal reportMadorin Kitfox III · Grantsville, UTthe pilot's selection of an unsuitable area for a precautionary landing. A factor was the snow covered terrain.Feb 9, 1996 · N32308 · Substantial damageNTSB SEA96LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe pilot's improper flare and inadequate recovery from a bounced landing. His improper approach was a related factor.Jan 16, 1996 · N757TJ · Substantial damageNTSB SEA95LA216Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moab, UTThe pilot-in-command's landing long, precluding a go-around and not maintaining a proper descent rate. Factors were trees and the crosswind.Sep 11, 1995 · N9041E · Substantial damageNTSB SEA95LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ogden, UTthe pilot's failure to use brakes to maintain directional control following a tailwheel steering malfunction. Partial failure of the tailwheel steering system contributed to the accident.Aug 27, 1995 · N9281E · Substantial damageNTSB SEA95LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · Bullfrog, UTThe right brake locking for undetermined reasons.Aug 10, 1995 · N2377F · Substantial damageNTSB SEA95LA153Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ogden, UTThe pilot-in-command's failure to maintain directional control. Hte loose tailwheel assembly bolt was a factor.Jul 18, 1995 · N6953K · Substantial damageNTSB SEA95LA067Accident · No injuriesLimited investigationFinal reportCessna 140 · Ogden, UTDirectional control was not maintained. Factors to the accident were a lack of total experience in type of aircraft and crosswind.Mar 15, 1995 · N3605V · Substantial damageNTSB SEA95LA054Accident · No injuriesLimited investigationFinal reportCessna TR182 · Bountiful, UTThe pilot's failure to attain proper runway alignment. Factors in the accident were: the dark night conditions and inadequate maintenance of the runway lighting system.Feb 19, 1995 · N738NQ · Substantial damageNTSB SEA95LA030Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Heber City, UTAn open connection clip. A factor to the accident was a locked tail wheel assembly.Dec 17, 1994 · N101ZA · Substantial damageNTSB SEA94LA238Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullfrog, UTThe pilot-in-command exceeded the airplane's maximum crosswind component capability. A factor related to the accident was the gusty crosswind.Sep 9, 1994 · N9918Q · Substantial damageNTSB SEA94LA172Accident · No injuriesLimited investigationFinal reportPitts S1 · Heber City, UTFailure of main landing gear axle hardware. Factors include collapse of main landing gear strut.Jul 5, 1994 · CGPUR · Substantial damageNTSB SEA94LA166Accident · No injuriesLimited investigationFinal reportHughes 369HS · West Jordan, UTThe pilot not maintaining a proper descent rate and his delayed remedial action.Jul 3, 1994 · N9029F · Substantial damageNTSB SEA94LA144Accident · No injuriesLimited investigationFinal reportCessna 182P · Salt Lake City, UTAn improper flare by the pilot, who was landing the aircraft, at the time it was damaged.May 29, 1994 · N8488M · Substantial damageNTSB SEA94LA126Accident · No injuriesLimited investigationFinal reportChristen Industries Husky · Ogden, UTThe pilot's inadequate compensation for wind condiitons. The wind gusts were a factor.May 21, 1994 · N103TB · Substantial damageNTSB SEA94LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Hanksville, UTThe excess airspeed maintained by the pilot on final approach, and his failure to attain the proper touchdown point. Factors include loose gravel, and a berm off the end of the intended landing strip.Apr 18, 1994 · N5045D · Substantial damageNTSB SEA94LA092Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Levan, UTThe left main landing gear wheel bearing broke resulting in the wheel jamming and the airplane nosing over.Mar 30, 1994 · N6754Q · Substantial damageNTSB SEA94LA017Accident · No injuriesLimited investigationFinal reportCessna 182R · Tooele, UTAirspeed was not maintained.Oct 15, 1993 · N6503E · Substantial damageNTSB SEA93LA201Accident · No injuriesLimited investigationFinal reportCessna 182H · Salt Lake City, UTThe pilot's improper flare. Inadequate recovery from a bounced landing was factor.Sep 5, 1993 · N2076X · Substantial damageNTSB SEA93LA165Accident · No injuriesLimited investigationFinal reportRiches Avid Flyer · Tooele, UTThe failure of the PIC to maintain directional control and to correct a ground loop/swerve.Jul 27, 1993 · N160VR · Substantial damageNTSB SEA93LA162Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Kanab, UTAn inadvertent wheel up landing. A factor to the accident was turbulence.Jul 6, 1993 · N7601E · Substantial damageNTSB SEA93LA144Accident · No injuriesLimited investigationFinal reportCessna 182RG · Price, UTThe pilot's poor inflight decision. Factors include high density altitude, and control interference.Jun 29, 1993 · N5209S · Substantial damageNTSB SEA93LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Provo, UTThe wild animals on the runway. A factor relating to the accident was the dark night light conditions.Jun 20, 1993 · N8262S · Substantial damageNTSB SEA93LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTThe student pilot's selection of a closed runway for landing. Factors contributing to the accident were the student pilot's anxiety and the rough landing surface.Jun 19, 1993 · N7045R · Substantial damageNTSB SEA93LA138Accident · No injuriesLimited investigationFinal reportBeech 60 · Bullfrog, UTInadvertent landing gear retraction.May 22, 1993 · N620E · Substantial damageNTSB SEA93LA099Accident · No injuriesLimited investigationFinal reportCessna 172K · Ogden, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were soft terrain, excessive airspeed, and crosswinds.Mar 8, 1993 · N1628C · Substantial damageNTSB SEA93LA065Accident · No injuriesLimited investigationFinal reportCessna 182C · Huntington, UTThe improper in flt decision by the pilot in command to land on an airstrip unsuitable for landing. A factor relating to the accident was the soft snow covering the airstrip.Jan 29, 1993 · N8540T · Substantial damageNTSB SEA92LA186Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Morgan, UTPoor inflight planning/decision by the pilot in command. Factors contributing to the accident were: the gravel/dirt bank, night environmental conditions, and runway lighting unavailable.Aug 24, 1992 · N2169A · Substantial damageNTSB SEA92LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Pleasant, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: weather (gusts) and terrain (berm).May 30, 1992 · N108ES · Substantial damageNTSB SEA92LA043Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Jordan, UTThe pilot in command's failure to maintain control of the aircraft. A factor contributing to the accident was gusty wind conditions.Feb 8, 1992 · N50659 · Substantial damageNTSB SEA91LA241Accident · No injuriesLimited investigationFinal reportCessna 172N · St George, UTImproper planning/decision by the student pilot. The crosswind and the student's lack of experience were related factors.Sep 14, 1991 · N2185E · Substantial damageNTSB SEA91LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Heber City, UTThe pilot's failure to maintain directional control during landing ground roll. A factor relating to the accident was the crosswind weather conditions.Aug 26, 1991 · N4653C · Substantial damageNTSB SEA91LA188Accident · No injuriesLimited investigationFinal reportWaco KNF · Wendover, UTPilot installed an improper 'o' ring which restricted normal landing gear extension and subsequent loss of control by the pilot.Jul 24, 1991 · NC698N · Substantial damageNTSB SEA91IA159Incident · No injuriesIncident investigationFinal reportGalaxy GLX-7 · Provo, UTThe pilot's diverted attention. Facotrs include on ground contact with a fence.Jul 5, 1991 · N5353A · Minor damageNTSB SEA91LA149Accident · No injuriesLimited investigationFinal reportCessna 210 · Salt Lake City, UTThe pilot's poor inflight planning and decisions in that he failed to anticipate wake turbulence from the departing helicopter.Jun 21, 1991 · N7350E · Substantial damageNTSB SEA91LA113Accident · No injuriesLimited investigationFinal reportBeech B23 · Spanish Fork, UTThe pilot did not adequately recover from a bounced landing. Factors to the accident were: a poorly planned approach, and the pilot's lack of total flight experience.May 19, 1991 · N4019T · Substantial damageNTSB SEA91LA114Accident · No injuriesLimited investigationFinal reportCessna TR182 · Green River, UTWorn brakes. Contributing to the accident was: poor maintenance.May 17, 1991 · N4664S · Substantial damageNTSB SEA91LA094Accident · No injuriesLimited investigationFinal reportCessna 180 · Vernal, UTThe pilot's impairment due to alcohol consumption and his failue to control the airplane during landing.Apr 26, 1991 · N40LT · Substantial damageNTSB SEA91LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Ogden, UTThe pilot's poorly planned approached for landing. Factors to the accident were: an excessive airspeed, and the inadequacy of the pilot's recovery from a bounced landing.Mar 31, 1991 · N6852H · Substantial damageNTSB SEA91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot did not maintain directional control of the airplane during the landing roll.Feb 13, 1991 · N757PW · Substantial damageNTSB 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