Skip to content

NTSB investigations: Cessna 172N, TN

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

19772026

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" = 'TN' 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\" = 'TN' 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" = 'TN' 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 ERA25LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Murfreesboro, TNThe pilot’s failure to maintain directional control of the airplane while attempting to take off in a gusty crosswind, which resulted in a runway excursion.May 22, 2025 · N6317D · Substantial damage NTSB ERA13CA404Accident · No injuriesData collectionFinal reportCessna 172N · Knoxville, TNThe student pilot's improper flare and improper recovery from a bounced landing.Aug 3, 2013 · N737PD · Substantial damage NTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.Jan 15, 2011 · N1946F · Substantial damage NTSB ATL04CA129Accident · No injuriesData collectionFinal reportCessna 172N · Dover, TNThe certified flight instructor initiated flight into thunderstorm activity that resulted in a loss of control and the subsequent collision with trees.Jun 12, 2004 · N5153E · Substantial damage NTSB ATL04LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe CFI's inadequate in-flight planning/decision and his inadequate supervision which resulted in fuel exhaustion. A factor was the inadequate preflight planning/preparation to ensure an adequate fuel supply, and the berm.Mar 10, 2004 · N6257F · Substantial damage NTSB MIA99LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Eagleville, TNThe dual's student failure to maintain adequate altitude/clearance from the wire during takeoff/initial climb. Also causal was the certified flight instructor's inadequate supervision.May 4, 1999 · N739EW · Substantial damage NTSB ATL96LA118Accident · No injuriesLimited investigationFinal reportCessna 172N · Nashville, TNinadequate annual inspection by other maintenance personnel and inadequate pre-flight inspection by the pilot.Aug 9, 1996 · N5291E · Substantial damage NTSB ATL96FA094Accident · 1 fatalField investigationFinal reportCessna 172N · Arlington, TNThe pilot's failure to maintain clearance above the trees. A factor was the dark night.Jun 14, 1996 · N73941 · Substantial damage NTSB ATL95LA072Accident · No injuriesLimited investigationFinal reportCessna 172N · Paris, TNThe failure of the pilots of both aircraft to maintain proper visual lookout during landing at the uncontrolled airport.Mar 29, 1995 · N258ER · 2 aircraft · Substantial damage NTSB ATL91LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe pilot's failure to accurately evaluate the weather conditions before attempting a takeoff and his delay in aborting the takeoff procedure. A factor was the dark night.Sep 29, 1991 · N5918E · Substantial damage NTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…Apr 20, 1991 · N5738J · Destroyed NTSB ATL89LA029Accident · No injuriesLimited investigationFinal reportCessna 172N · Rogersville, TNThe plt reported that he was ferrying the airplane to obtain scheduled maintenance. Upon arrival over the arpt, he found that the only rwy was closed for maintenance. He then elected to land on a taxiway. He made a short-field ldg and applied the brakes…Nov 3, 1988 · N734ZM · Substantial damage NTSB ATL85FA280Accident · 1 fatalField investigationFinal reportCessna 172N · Halls, TNThe private pilot had just leveled off at 2500 feet and pointed out the old naval base to his right front seat passenger when he slumped over the yoke. The passenger in the rear seat held the pilot off the controls while her non-pilot husband attempted to…Sep 21, 1985 · N2858E · Substantial damage NTSB ATL84LA170Accident · 1 fatalLimited investigationFinal reportCessna 172N · Nashville, TNThe plt reported that after he & his passengers were aboard the acft, the eng was running & ground control had cleared him to taxi when he discovered that the left main wheel was still chocked, preventing forward movement of the acft. He was setting his…May 14, 1984 · N733GY · No damage NTSB ATL84LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe acft recontacted the ground during takeoff and bounced several times before coming to rest. The propeller, nose strut and firewall were damaged. The wind was reportedly from 250 degrees at 14 KTS gusting to 26 KTS. The ATC controllers on duty said the…Jan 28, 1983 · N6257F · Substantial damage NTSB ATL82FLT03Accident · 1 fatalFinal reportCessna 172N · Greenfield, TNWitnesses reported that the aircraft crashed after the pilot had been making low passes for about 15 to 30 minutes. In the vicinity of a 30 ft pole, the pilot made a right turn and the aircraft struck the top of a 45 ft tree. The aircraft continued over a…Mar 20, 1982 · N737QS · Destroyed NTSB ATL81FLT12Accident · Minor injuriesClosedCessna 172 · Brownsville, TNJul 11, 1981 · N4361R · Substantial damage NTSB ATL80FKW01Accident · No injuriesClosedCessna 172 · Nashville, TNOct 3, 1980 · N3008E · Substantial damage NTSB IAD78FA018Accident · 2 fatalClosedCessna 172H · Dickson, TNDec 4, 1977 · N75923 · Destroyed