NTSB investigations: Cessna 172K, TN
13 cases on aircraft the registry lists as Cessna 172K. 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.
Cases per year
| 1971 | 2 |
|---|---|
| 1972 | 2 |
| 1973 | 1 |
| 1977 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2007 | 1 |
| 2014 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2072430'))
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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA14LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Elizabethton, TNThe pilot’s delayed decision to maneuver around rising terrain, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot’s failure to calculate the performance requirements needed to climb over mountainous terrain…NTSB ATL07CA050Accident · Minor injuriesData collectionFinal reportCessna 172K · Paris, TNThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.NTSB ATL05LA031Accident · No injuriesLimited investigationFinal reportCessna 172K · Smyrna, TNThe pilot's inadequate preflight planning of fuel required for the flight, and his inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB ATL05CA002Accident · Serious injuriesData collectionFinal reportCessna 172K · Knoxville, TNThe pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.NTSB ATL03LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bristol, TNThe pilot's improper use of the rudder controls during the takeoff roll resulting in a loss of directional control, and the on-ground collision with an embankment.NTSB ATL96LA079Accident · No injuriesLimited investigationFinal reportCessna 172K · Lebanon, TNthe student pilot's failure to maintain directional control during landing.NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.NTSB IAD78FLT01Accident · Minor injuriesClosedCessna 172 · Covington, TNNTSB IAD73FKW29Accident · Serious injuriesClosedCessna 172 · Crossville, TNNTSB MIA73AM040Accident · 3 fatalClosedCessna 172K · Oliver Spgs, TNNTSB MIA73FKW05Accident · No injuriesClosedCessna 182N · Gatlinburg, TNNTSB MIA72FKW03Accident · No injuriesClosedCessna 172 · Gallatin, TNNTSB MIA71FKW39Accident · No injuriesClosedCessna 172K · Oneida, TN