Skip to content

NTSB investigations: Cessna 172, TN

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

19642026

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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 ERA22LA413Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Chattanooga, TNA total loss of engine power due to of carburetor ice. Contributing to the accident was the pilot’s failure to apply carburetor heat.Sep 13, 2022 · N388TC · Substantial damage NTSB ERA21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Johnson City, TNThe student pilot’s excessive airspeed during the landing approach and his delayed remedial action, which resulted in the airplane striking obstacles during an aborted landing. Contributing was the pilot’s decision to land with a tailwind.May 12, 2021 · N6344E · Substantial damage NTSB MIA08CA018Accident · No injuriesData collectionFinal reportCessna 172 · McKinnon, TNThe pilot's failure to perform a go around.Nov 18, 2007 · N5803A · Substantial damage NTSB ATL02LA096Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Livingston, TNThe pilot failure to maintain flying speed, followed by a subsequent stall.May 11, 2002 · N8608B · Substantial damage NTSB ATL98LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Sewanee, TNThe inadequate visual lookout by the ground pedestrian. A factor was dark night conditions.Aug 25, 1998 · N6720A · No damage NTSB ATL91FA054Accident · 1 fatalField investigationFinal reportCessna 172 · Crossville, TNThe improper flight planning by the noninstrument rated pilot which resulted in his inadvertent flight into instrument meteorological conditions in mountainous terrain.Feb 14, 1991 · N8641B · Destroyed NTSB ATL89FA177Accident · Serious injuriesField investigationFinal reportCessna 172 · Townsend, TNImproper in-flight planning/decision by the pilot and his delay in initiating remedial action, when he encountered low ceilings over mountainous terrain, which resulted in his inability to maintain sufficient altitude. Contributing factors were: the pilot's…Jul 11, 1989 · N8855B · Destroyed NTSB ATL89FA081Accident · 2 fatalField investigationFinal reportCessna 172 · Hartsville, TNThe pilot allowing the aircraft to lift-off prematurly at a slow airspeed and his failure to maintain directional control before inadvertently entering a stall. Contributing to the accident was the pilot's experience level and lack of qualifications.Jan 21, 1989 · N5834A · Substantial damage NTSB ATL88LA097Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNWhile returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…Feb 22, 1988 · N6285E · Substantial damage NTSB IAD80FKW08Accident · Serious injuriesClosedCessna 172 · Tn Ridge, TNFeb 2, 1980 · N6248E · Substantial damage NTSB IAD79DKW11Accident · No injuriesClosedCessna 172 · Cleveland, TNMay 25, 1979 · N5052H · Substantial damage NTSB IAD77DKW26Accident · No injuriesClosedCessna 172 · Beersheba Spgs, TNAug 13, 1977 · N4295F · Substantial damage NTSB IAD77FKW20Accident · 2 fatalClosedCessna 172 · Midtown Commun, TNJun 18, 1977 · N7129A · Destroyed NTSB IAD77FKW13Accident · No injuriesClosedCessna 172 · Jamestown, TNFeb 11, 1977 · N4028F · Substantial damage NTSB IAD74AI021Accident · 1 fatalClosedCessna 172 · Lewisburg, TNOct 13, 1973 · N7108T · Destroyed NTSB MIA73DLT10Accident · No injuriesClosedCessna 172 · Stantonville, TNOct 1, 1972 · N9167B · Substantial damage NTSB MIA68A0105Accident · 1 fatalClosedCessna 172 · Benton, TNJun 8, 1968 · N3909F · Destroyed NTSB MIA68D0387Accident · No injuriesClosedCessna 172 · Nashville, TNJan 29, 1968 · N4207F · Substantial damage NTSB MIA67F0461Accident · Minor injuriesClosedCessna 172 · Collegedale, TNMar 25, 1967 · N9122B · Destroyed NTSB MIA65F0124Accident · Serious injuriesClosedCessna 172 · Rutherford, TNJun 5, 1965 · N6073A · Substantial damage NTSB UNK65X0843Accident · 1 fatalClosedCessna 172 · Troy, TNNov 26, 1964 · N8059B · Destroyed NTSB UNK64X3401Accident · Serious injuriesClosedCessna 172 · Crossville, TNAug 15, 1964 · N6687A · Destroyed