NTSB investigations: Cessna 172K
33 cases on aircraft the registry lists as Cessna 172K, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 3 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072430')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072430')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.NTSB LAX06CA136Accident · No injuriesData collectionFinal reportCessna 172 · Wickenburg, AZthe pilot's failure to maintain directional control.NTSB NYC06CA013Accident · No injuriesData collectionFinal reportCessna 172K · West Milford, NJA loss of aircraft control as a result of the installation of an improper pilot seat which moved during the takeoff roll/run..NTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…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 NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.NTSB CHI01LA107Accident · No injuriesLimited investigationFinal reportCessna 172K · Holland, MIThe pilot failed to maintain directional control of the airplane. Factors included the soft ground and the runway lights.NTSB SEA01LA036Accident · No injuriesLimited investigationFinal reportCessna 172K · Troutdale, ORThe pilot's failure to adequately compensate for wind conditions while taxiing the airplane.NTSB LAX00LA335Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Novato, CAFailure of the student pilot to maintain directional control of the airplane during the landing rollout resulting in a collision with a berm.NTSB FTW00LA088Accident · No injuriesLimited investigationFinal reportCessna 172K · Alpine, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.NTSB LAX99LA252Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Taft, CAThe pilot's selection of the wrong runway in consideration of the wind conditions and his subsequent failure to maintain directional control. The pilot's decision to abort the landing attempt with inadequate runway remaining for the takeoff phase was also…NTSB IAD98LA025Accident · No injuriesLimited investigationFinal reportCessna 172K · Oxford, MAThe pilot's failure to maintain directional control.NTSB CHI97LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Olathe, KSthe pilot's improper inflight planning/decision and exceeding the airplane recommended crosswind component. Factors associated with this accident were the weather conditions of a high wind, gusts, and a crosswind.NTSB FTW97LA145Accident · No injuriesLimited investigationFinal reportCessna 172K · Glenwood Spgs, COThe pilot's failure to maintain airplane directional control, and his use of excessive rudder control.NTSB FTW96LA203Accident · No injuriesLimited investigationFinal reportCessna 172K · Leadville, COthe pilot's failure to adequately compensate for the wind conditions and to maintain directional control. Factors were: the gusting cross wind and the pilot's lack of total experience in make and model of aircraft.NTSB ATL96LA079Accident · No injuriesLimited investigationFinal reportCessna 172K · Lebanon, TNthe student pilot's failure to maintain directional control during landing.NTSB FTW96LA160Accident · No injuriesLimited investigationFinal reportCessna 172K · Danville, ARthe student pilot's inadequate compensation for the crosswind. Factors were the crosswind and the soft terrain.NTSB ANC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Gustavus, AKThe pilot's failure to maintain directional control. A factor relating to the accident was: the diminished nosewheel steering capability due to an overinflated nosewheel strut.NTSB FTW94LA301Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Russellville, ARThe pilot's inadequate compensation for the crosswind during the takeoff ground roll. A factor was the crosswind.NTSB LAX94LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172K · New Cuyama, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control of the aircraft.NTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.NTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.NTSB ANC90FA053Accident · No injuriesField investigationFinal reportCessna 172-K · Anchorage, AKPilot-in-command used poor judgement when he elected to take off on rough & uneven frozen lake which resulted in a failed nose ski.NTSB SEA89LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · East Sound, WAThe student pilot's failure to maintain directional control.NTSB FTW88LA089Accident · No injuriesLimited investigationFinal reportCessna 172K · Houston, TXThe high-wing, tricycle gear airplane was taxiing out in winds gusting to 29 knots from about 320 degrees. While the airplane was heading 250 degrees, it was overturned to the inverted position. Owner's manual does not list any restrictions for maximum…NTSB FTW87LA172Accident · No injuriesLimited investigationFinal reportCessna 172K · Brenham, TXThe student pilot lost directional control during the landing roll. The aircraft veered off the runway and nosed over to the inverted position when the nose gear dropped into a hole hidden by tall grass.NTSB NYC87LA096Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYDuring landing roll out, the pilot lost directional control as the aircraft veered to the right side of the runway and collided with a snowbank.NTSB ANC87LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Beluga, AKThe pilot stated that during the landing roll on a snow covered road the pilot lost control of the aircraft causing the aircraft to nose over on its back.NTSB LAX86LA350Accident · No injuriesLimited investigationFinal reportCessna 172 · Novato, CAThe pilot attempted a crosswind landing at the end of a pleasure cross country flight. A loss of directional control occurred on short final and the aircraft drifted right of the runway. A go-around was attempted without success and the aircraft rolled off…NTSB FTW86LA117Accident · No injuriesLimited investigationFinal reportCessna 172K · Weatherford, TXThe pilot reported losing control of the acft during touchdown due to the crosswind. The landing was being made on runway 16 and there was a 7 kt wind from 200 degrees.NTSB CHI85LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Berlin, WIThe plt stated that he attempted to takeoff from a grass strip that is priented north and south. He described the grass as being 'too long' and the wind was from the west. The plt over rotated the acft to raise the nose wheel clear of the grass and was unable…NTSB CHI83LA240Accident · No injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNThe acft veered off the rwy during landing. The landing was on rwy 07. The wind was from 360 degrees at 15 KTS. A thunderstorm was in the area and some turbulence remained. The pilot stated he felt one good bump at 50 AGL and from that point to touchdown very…NTSB FTW82DA070Accident · No injuriesFinal reportCessna 172 · Hennessey, OKThe pilot reported that he encountered a gust of wind as he was flaring with full flaps about two feet above the strip. He stated that the right wing was blown down (the tail moved to the left) and the right wing collided with a fence beside the airstrip. The…