NTSB investigations: Cessna 172K, FL
35 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
| 1970 | 2 |
|---|---|
| 1971 | 4 |
| 1972 | 1 |
| 1973 | 2 |
| 1975 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1991 | 4 |
| 1992 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2019 | 2 |
| 2021 | 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\" = 'FL' 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" = 'FL' 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 ERA22LA006Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Williston, FLThe pilot’s failure to maintain clearance from terrain on approach which resulted in controlled flight into trees. Contributing to the accident was the flight instructor’s inadequate supervision of the approach path, the dark night conditions and the landing…NTSB ERA19LA246Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jay, FLThe pilot's improper decision to fly over a river at a very low altitude, which resulted in a collision with power lines.NTSB GAA19CA362Accident · No injuriesData collectionFinal reportCessna 172 · Tampa, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose-over.NTSB ERA15LA318Accident · No injuriesLimited investigationFinal reportCessna 172K · Chiefland, FLThe partial loss of engine power during cruise flight for reasons that could not be determined because a postaccident airframe and engine examination and engine test run revealed no evidence of mechanical malfunctions or failures.NTSB ERA13CA181Accident · No injuriesData collectionFinal reportCessna 172 · Tistusville, FLThe pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.NTSB ERA12LA234Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLA total loss of engine power due to the improper installation of the crankshaft gear bolt or lockplate by maintenance personnel. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB ATL05CA107Accident · No injuriesData collectionFinal reportCessna 172 K · Panama City, FLThe pilot's inadequate planning of the fuel supply, which resulted in fuel exhaustion.NTSB MIA03LA038Accident · No injuriesLimited investigationFinal reportNorth American AT-6A · Melbourne, FLThe failure of the pilot of the North American AT6A, N57318 to maintain a proper visual lookout while taxiing, which resulted in him impacting the rear of the Cessna 172K, N522F.NTSB ATL01LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Indiantown, FLThe pilot had excessive airspeed, misjudged the landing distance, and did not perform a go-around, which resulted in a nose over. The ditch was a contributing factor.NTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…NTSB MIA99LA084Accident · No injuriesLimited investigationFinal reportCessna 172K · Marathon, FLThe pilot's improper use of elevator control while landing in gusty winds resulting in the aircraft nosing down and the propeller and wing contacting the runway.NTSB MIA96LA145Accident · No injuriesLimited investigationFinal reportCessna 172K · Englewood, FLFailure of the pilot-in-command to maintain visual lookout while taxiing to takeoff resulting in an on-ground collision with a tree.NTSB MIA92FA158Accident · 4 fatalField investigationFinal reportCessna 172K · Rockledge, FLFailure of the pilot to maintain adequate airspeed during the final approach resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of recent experience in the type operation, lack of experience at the airport in the type…NTSB MIA91LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Groveland, FLFailure of the pilot to maintain adequate airspeed resulting in inadvertent stall/mush.NTSB MIA91LA161Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, FLTotal loss of engine power due to fatigue failure of the oil cooler resulting in oil exhaustion. Contributing to the accident was lack of suitable terrain.NTSB MIA91LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bunnell, FLLoss of control in flight due to a foreign object which restricted the movement of the elevator flight control.NTSB MIA91LA092Accident · No injuriesLimited investigationFinal reportCessna 172K · Everglades City, FLInformation given during a weather briefing was disregarded, in-flight encounter with wind gust, and failure of the pilot to execute a go-around. Contributing to the accident was inadequate placement of a windsock which was blocked by trees resulting in an…NTSB MIA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLThe pvt plt flying the acft for the first time from the rt seat landed it aprx 170 ft short of the runway on soft grass. The acft rolled 6-10 ft, after which the nose gear sank & the acft then nosed over & came to rest inverted.NTSB MIA85LA158Accident · No injuriesLimited investigationFinal reportCessna 172K · Sharpes, FLCarburetor had rusted parts and needed an overhaul. Pilot was demonstrating power off stall to passengers, when he tried to apply power, engine did not respond. Landed in soft terrain. Swerved to avoid ditch. Nose wheel collapsed.NTSB MIA83LA040Accident · No injuriesLimited investigationFinal reportCessna 172J · Lowell, FLWhile attempting a go-around maneuver, the aircraft tail struck treetops that were located at the departure end of runway 18. The pilot landed the aircraft safely and discovered damage to the right horizontal stabilizer and the fuselage.NTSB MIA80DLD88Accident · No injuriesClosedCessna 172K · Chiefland, FLNTSB MIA78FKT64Accident · No injuriesClosedCessna 172 · Key Largo, FLNTSB MIA77DLA34Accident · No injuriesClosedCessna T-41A · Panama City, FLNTSB MIA77FKT20Accident · No injuriesClosedCessna 172 · Pembroke Pines, FLNTSB MIA76FLD03Accident · Serious injuriesClosedCessna 172K · Venus, FLNTSB MIA75AM063Accident · 4 fatalClosedCessna 172K · Miami, FLNTSB MIA74AM039Accident · 4 fatalClosedCessna 172K · Kissimmee, FLNTSB MIA73AM084Accident · 2 fatalClosedCessna 172K · Perry, FLNTSB MIA73DLD25Accident · No injuriesClosedCessna 172 · Daytona Beach, FLNTSB MIA72DKT20Accident · No injuriesClosedCessna 172K · Key Largo, FLNTSB MIA72FLA07Accident · No injuriesClosedCessna 172K · Jacksonville, FLNTSB MIA71AM058Accident · 2 fatalClosedCessna 172K · Lake City, FLNTSB MIA71AM057Accident · 2 fatalClosedCessna 172K · High Springs, FLNTSB MIA71DLA01Accident · No injuriesClosedCessna 172K · Panacea, FLNTSB MIA70FKT02Accident · Minor injuriesClosedCessna 172K · Pompano Beach, FL