Skip to content

NTSB investigations: Cessna 172N, UT

27 cases on aircraft the registry lists as Cessna 172N. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19792026

Where

Latest cases

Query with SQL

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434'))
  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.

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB GAA17CA276Accident · No injuriesData collectionFinal reportCessna 172 · Monument Valley, UTThe pilot’s improper landing flare, which resulted in a bounced landing.May 12, 2017 · N9390E · Substantial damage NTSB GAA15CA156Accident · No injuriesData collectionFinal reportCessna 172N · Vernal, UTThe pilot's failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.Jun 26, 2015 · N3159E · Substantial damage NTSB WPR11LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Spanish Fork, UTThe student pilot's inadequate compensation for the gusting wind, which resulted in a loss of airplane control during landing. Contributing to the accident was the pilot's decision to depart with a high gusting wind.Mar 21, 2011 · N739DG · Substantial damage NTSB DEN05LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Cedar City, UTthe loss of engine power for reasons undetermined. Contributing factors include the lack of suitable terrain for a forced landing, and the soft dirt.Aug 17, 2005 · N9892J · Substantial damage NTSB DEN04LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Hurricane, UTthe student pilot's failure to maintain aircraft control during the landing. Contributing factors include the crosswind, the wind gusts, and the exceeded maximum demonstrated crosswind component.Jul 31, 2004 · N5426J · Substantial damage NTSB DEN04LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Parowan, UTthe pilot's in-flight decision/planning which resulted in fuel exhaustion. The fence and night conditions were contributing factors.Feb 13, 2004 · N9892J · Substantial damage NTSB DEN02LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of total experience in aircraft, and the pilot's lack of recent experience in kind of aircraft.Oct 21, 2001 · N5552E · Substantial damage NTSB DEN01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Jensen, UTan undershoot due to misjudging distance/altitude during an emergency landing. Factors were: inadequate preflight, failure to refuel, fuel exhaustion, operating with an inoperative fuel gauge, and failure to attain a proper glide path during approach.Oct 15, 2000 · N738CW · Substantial damage NTSB DEN00FA149Accident · 1 fatalField investigationFinal reportCessna 172N · Kamas, UTThe pilot's improper inflight decision to enter a valley at low altitude and attempt a climb towards rising terrain. A factor was exceeding the airplane's climb performance.Aug 13, 2000 · N734UD · Destroyed NTSB DEN99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · West Jordan, UTThe pilot's failure to maintain directional control of the aircraft. Factors were his lack of recent flight experience, and his lack of experience in the make and model of aircraft.Feb 16, 1999 · N734BE · Substantial damage NTSB FTW98FA399Accident · 1 fatalField investigationFinal reportCessna 172N · Montezuma Crk, UTThe pilot's attempted aerobatic maneuver and the subsequent inadvertent stall/spin. A factor was his intentional low altitude flight.Sep 14, 1998 · N737NH · Destroyed NTSB SEA97LA060Accident · No injuriesLimited investigationFinal reportCessna 172N · Delta, UTThe pilot's failure to adequately compensate for the prevailing wind conditions, and his subsequent failure to maintain directional control during the landing roll. Factors contributing to the accident are a sudden shift in the prevailing wind at the time of…Feb 21, 1997 · N5552E · Substantial damage NTSB SEA96LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Jordan, UTimproper installation of the airplane's carburetor fuel lines by maintenance personnel.Feb 24, 1996 · N76027 · Destroyed NTSB SEA93LA193Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Price, UTThe failure of the pilot to maintain airspeed above stall.Sep 6, 1993 · N8067E · Substantial damage NTSB 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 damage NTSB DEN88LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Duchesne, UTThe student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…Jan 22, 1988 · N4897G · Substantial damage NTSB DEN87FA038Accident · Serious injuriesField investigationFinal reportCessna 172N · Central, UTThe plt and 3 passengers were on a local sightseeing flt over the pine valley mountain range. The plt stated that he made three 360 deg turns to gain alt from 7500 ft to 9500 ft. he also stated that upon leveling at 9500 ft the eng began to lose pwr. Attempts…Dec 29, 1986 · N5153K · Substantial damage NTSB DEN86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Richfield, UTPlt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1) ... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…Jul 4, 1986 · N8291E · Substantial damage NTSB DEN86LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Tooele, UTAfter successive aircraft bounces during a touchdown phase of landing, the pilot lost control. The aircraft departed the side of the runway into an area of soft terrain. The landing gear nose wheel sank into the ground and the aircraft nosed over into an…Jul 3, 1986 · N5552E · Substantial damage NTSB DEN86LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Logan, UTThe plt stated that shortly after a night departure, the acft entered a fog bank. The plt said he was turning to reverse direction and descending in order to avoid IMC. Prior to completing the turn, the plt encountered IMC and lost all outside visual…Dec 16, 1985 · N739KU · Substantial damage NTSB DEN82DA026Accident · No injuriesFinal reportCessna 172 · Bryce Canyon, UTAfter arriving from a cross-country flight, the pilot landed on an icy runway with calm wind conditions. During ground roll, the aircraft began sliding to the left. The left wheel hit snow and pulled the aircraft further left. The pilot applied right rudder…Jan 30, 1982 · N5447E · Substantial damage NTSB DEN81FTM35Accident · No injuriesClosedCessna 172N · Moab, UTJul 13, 1981 · N5097E · Substantial damage NTSB DEN80FTM01Accident · No injuriesClosedCessna 172N · West Jordan, UTOct 2, 1980 · N734UD · Substantial damage NTSB DEN80FTM41Accident · Serious injuriesClosedCessna 172 · Heber, UTSep 25, 1980 · N8076E · Substantial damage NTSB DEN80DTM20Accident · No injuriesClosedCessna 172N · Tooele, UTMay 14, 1980 · N739ZB · Substantial damage NTSB DEN80DTM09Accident · No injuriesClosedCessna 172N · Heber, UTFeb 4, 1980 · N6190D · Substantial damage NTSB DEN80DTM03Accident · Serious injuriesClosedCessna 172 · Ogden, UTOct 8, 1979 · N2285E · Destroyed