Skip to content

NTSB investigations: Cessna 172N, MS

19 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

19782026

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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).Nov 25, 2017 · N739KW · Substantial damage NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.Oct 8, 2016 · N3379E · Substantial damage NTSB DFW08CA003Accident · Minor injuriesData collectionFinal reportCessna 172N · Oxford, MSThe pilots inadvertent stall during takeoff. A contributing factor was his failure to calculate the aircraft gross weight prior to the flight.Oct 7, 2007 · N5260J · Substantial damage NTSB DFW06FA187Accident · 2 fatalField investigationFinal reportCessna 172N · Petal, MSThe pilot's improper use of flaps, which resulted in an impact with trees during takeoff-initial climb.Jul 19, 2006 · N738KE · Destroyed NTSB ATL04FA099Accident · 3 fatalField investigationFinal reportCessna 172N · Moselle, MSThe pilot's failure to maintain clearance and his inadequate visual look-out while maneuvering resulting in an in-flight collision with a radio tower.Apr 24, 2004 · N75812 · Substantial damage NTSB MIA04FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Olive Branch, MSThe student pilot's failure to maintain airspeed (Vso), which resulted in an inadvertent stall/spin, an uncontrolled descent, and an impact with terrain. A factor in the accident was his failure to follow the airplane's operating checklist and retract the…Oct 21, 2003 · N75510 · Substantial damage NTSB MIA03LA098Accident · No injuriesLimited investigationFinal reportCessna 172N · Foxworth, MSThe failure of the pilot to perform a go-around, his failure to attain the proper touchdown point, and his delay in applying the normal brakes resulting in his inability to stop the airplane and subsequent on-ground collision with a fence.Apr 10, 2003 · N738QM · Substantial damage NTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.Aug 27, 1999 · N4521E · Substantial damage NTSB ATL98LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe student pilot's failure to maintain directional control of the airplane during takeoff.Jul 6, 1998 · N739ZA · Substantial damage NTSB MIA97LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot's improper flare and improper recovery from a ballooned/bounced landing. The gusty wind was a related factor.Nov 24, 1996 · N739ZA · Substantial damage NTSB MIA96LA199Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Victoria, MSThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.Aug 1, 1996 · N737DK · Substantial damage NTSB MIA95LA244Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and/or improper recovery from a bounced landing.May 31, 1995 · N734YD · Substantial damage NTSB MIA92LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Gulfport, MSFailure of the pilot-in-command to perform a go-around and inadvertent stall.Dec 18, 1991 · N733XV · Substantial damage NTSB MIA90FA046Accident · 1 fatalField investigationFinal reportCessna 172N · Meridian, MSIn flight loss of control by the pilot while flying in instrument meteorological conditions. Contributing factor(s) was: the pilot's apprehension toward instrument flying and the adverse weather conditions that existed at the time.Dec 29, 1989 · N733FK · Destroyed NTSB MIA89LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and improper recovery from a bounced landing, which resulted in porpoising of the aircraft and an uncontrolled ground swerve.Aug 27, 1989 · N5215E · Substantial damage NTSB MIA89LA017Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, MSDuring normal cruise flt a portion of one propeller blade separated. The plt landed the acft in a field & during the landing roll, the acft collided with a haystack. Examination of the propeller blade revealed it separated at blade station 28.5. Metallurgical…Oct 28, 1988 · N21ER · Substantial damage NTSB MIA86FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Starkville, MSWitnesses rprtd that the plt had purchased wine cooler beverages before going to the arpt. He stated that he drank from one of the bottles before the flt. The plt took off at about 2230 CDT. After takeoff, he flew back over the arpt & made a low pass over a…May 3, 1986 · N4838G · Destroyed NTSB ATL82FKQ01Accident · No injuriesClosedCessna 172N · Ocean Springs, MSOct 5, 1981 · N5255J · Substantial damage NTSB MIA78FA123Accident · 1 fatalClosedCessna 172N · Gautier, MSSep 11, 1978 · N666ZH · Destroyed