Skip to content

NTSB investigations: Cessna 172M, AR

24 cases on aircraft the registry lists as Cessna 172M. 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

19732026

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" = 'AR' 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 ('2072418')) 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\" = 'AR' 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 ('2072418'))
  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" = 'AR' 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 ('2072418'))
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 CEN20CA351Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Conway, ARThe pilot’s improper recovery from a bounced landing.Aug 2, 2020 · N13184 · Substantial damage NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.Jan 22, 2009 · N20275 · Substantial damage NTSB DFW05CA203Accident · No injuriesData collectionFinal reportCessna 172M · El Dorado, ARThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.Aug 2, 2005 · N80735 · Substantial damage NTSB FTW01LA138Accident · No injuriesLimited investigationFinal reportCessna 172M · Hot Springs, ARthe student pilot's delayed go-around, which resulted in the airplane impacting trees during the aborted landing.Jun 8, 2001 · N5394H · Substantial damage NTSB FTW00LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Manilla, ARThe pilot's performance of low altitude flight and his failure to maintain clearance with the power lines.Mar 7, 2000 · N20179 · Substantial damage NTSB FTW95FA393Accident · 3 fatalField investigationFinal reportCessna 172M · Witter, ARfailure of the pilot to maintain sufficient altitude/clearance from high/wooded terrain. Factors relating to the accident were: darkness, high terrain, and foggy weather conditions. Also, the pilot's use of Methamphetamine (not approved by the FAA) was a…Sep 13, 1995 · N61899 · Destroyed NTSB FTW94LA298Accident · No injuriesLimited investigationFinal reportCessna 172M · Oil Trough, ARThe pilot's loss of aircraft directional control during the landing roll. A factor was the wet grass landing surface.Sep 14, 1994 · N1367U · Substantial damage NTSB FTW94LA111Accident · No injuriesLimited investigationFinal reportCessna 172M · Flippin, ARThe student pilot's premature flare and the resultant inadvertent stall.Mar 18, 1994 · N6654H · Substantial damage NTSB FTW92LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Stuttgart, ARThe pilot's failure to compensate for wind conditions. Factors were the crosswind and the downdraft.Apr 12, 1992 · N6934H · Substantial damage NTSB FTW91FA060Accident · 2 fatalField investigationFinal reportCessna 172M · Flippin, ARThe pilot's attempted VFR flight in instrument meteorological conditions and his failure to maintain altitude.Apr 4, 1991 · N4416R · Destroyed NTSB MKC89FA117Accident · Serious injuriesField investigationFinal reportCessna 172M · Oakland, ARPilot electing to buzz persons on the lake at low altitude and colliding with power lines.May 28, 1989 · N9646H · Substantial damage NTSB FTW88FA084Accident · 1 fatalField investigationFinal reportCessna 172M · Hope, ARThe non-instrument rated pilot initiated the flight into known adverse weather after being advised during a preflight weather briefing that VFR flight was not recommended. About 40 minutes before the crash, he called el dorado (Arkansas) radio and requested…Mar 31, 1988 · N6534H · Destroyed NTSB MKC84LA268Accident · No injuriesLimited investigationFinal reportCessna 172 M · Heber Springs, ARThe acft ran off the side of the rwy into some brush and a ditch. The plt said the landing seemed normal until she applied the brakes and the acft veered to the right. The lift wheel brake was found to be worn after the accident.Sep 2, 1984 · N80332 · Substantial damage NTSB MKC84LA204Accident · No injuriesLimited investigationFinal reportCessna 172M · Colt, ARThe pilot stated that he made his final approach to the rwy at 70 mph and the aircraft floated when he flared for touchdown. He continued to state that after acft touched down, insufficient runway remained to stop before overrunning the runway and impacted a…Jul 7, 1984 · N61625 · Substantial damage NTSB FTW84FA023Accident · 3 fatalField investigationFinal reportCessna 172M · Redfield, ARAt aprx 1331 CDT, the plt entered the pine bluff fss station & requested a briefing for a VFR flt to springfield, MO. He was advised that VFR flt was not recommended. The plt returned again between 1335 & 1350 & was seen examining the wx charts. At aprx 1420,…Oct 16, 1983 · N321HR · Destroyed NTSB FTW79FA094Accident · 2 fatalClosedCessna 172M · Little Rock, ARJul 11, 1979 · N5471H · Destroyed NTSB FTW79FPG60Accident · Minor injuriesClosedCessna 172M · Newport, ARJul 4, 1979 · N12588 · Substantial damage NTSB FTW79FPG53Accident · No injuriesClosedCessna 172 · Redfield, ARJun 13, 1979 · N20076 · Substantial damage NTSB FTW79DPG23Accident · No injuriesClosedCessna 172 · Arkadelphia, ARMar 24, 1979 · N12163 · Substantial damage NTSB FTW78FPG24Accident · No injuriesClosedCessna 172 · Forrest City, ARApr 13, 1978 · N20275 · Substantial damage NTSB FTW76DPG58Accident · No injuriesClosedCessna 172 · Manila, ARMay 29, 1976 · N5248R · Substantial damage NTSB FTW76DPG56Accident · No injuriesClosedCessna 172 · Bald Knob, ARMay 25, 1976 · N19870 · Substantial damage NTSB FTW76FPG18Accident · Serious injuriesClosedCessna 172M · Lakeview, ARSep 2, 1975 · N92720 · Destroyed NTSB FTW73AF067Accident · 3 fatalClosedCessna 172 · Mena, ARApr 30, 1973 · N20318 · Destroyed