NTSB investigations: Cessna 172K
33 cases on aircraft the registry lists as Cessna 172K, where the first occurrence was “Loss of control - in flight”. 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 | 3 |
|---|---|
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 2 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 2 |
| 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\" = 250))
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" = 250))
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 LAX07CA201Accident · No injuriesData collectionFinal reportCessna 172K · Newcastle, UTThe pilot's inadequate compensation for the gusty and crosswind condition, and his failure to maintain control of the airplane during takeoff.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 CHI04CA113Accident · Minor injuriesData collectionFinal reportCessna 172K · Harrisonville, MOThe dual student's failure to maintain directional control of the aircraft during the landing flare. Contributing factors were the dual student's failure to relinquish the controls to the flight instructor, the resulting inability of the flight instructor to…NTSB FTW04FA045Accident · 2 fatalField investigationFinal reportCessna 172K · Grand Saline, TXThe pilot's failure to maintain control of the airplane while on final approach. Factors were the high winds and prevailing crosswind.NTSB LAX03CA208Accident · No injuriesData collectionFinal reportCessna 172K · Overton, NVthe student pilot's failure to maintain an adequate airspeed and his premature raising of the flaps during a go-around, which led to an inadvertent stall/mush. The flight instructor's inadequate supervision of the flight is also causal.NTSB DEN02FA084Accident · 1 fatalField investigationFinal reportCessna 172K · Greeley, COthe student pilot's improper handling of the airplane's controls (for reason undetermined), and the inadequate supervision of the flight instructor. A contributing factor was the high density altitude weather condition.NTSB DEN02LA045Accident · No injuriesLimited investigationFinal reportCessna 172K · Cedar City, UTthe pilot's inadvertent stall/mush during the landing flare/touchdown. A contributing factor was the gusty crosswind weather conditions.NTSB NYC01LA038Accident · No injuriesLimited investigationFinal reportCessna 172K · Hagerstown, MDThe pilot's failure to remove the gust lock from the control column before takeoff, and his failure to abort the takeoff.NTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.NTSB NYC99FA107Accident · 1 fatalField investigationFinal reportCessna 172K · Shirley, NYThe pilot's loss of control of the airplane due to intoxication. A factor was the pilot's self-induced pressure to conduct the flight.NTSB NYC98LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Chateaugay, NYBinding in the control yoke for undetermined reasons.NTSB FTW98LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Marietta, OKThe pilot's improper compensation for the wind conditions. A factor was the crosswind.NTSB NYC98FA063Accident · 1 fatalField investigationFinal reportCessna 172K · Boxborough, MAThe failure of the pilot to remove the frost on the wings before departure, which resulted in a stallNTSB IAD96LA118Accident · No injuriesLimited investigationFinal reportCessna 172 · Frederick, MDthe private pilot's inadvertently stalling the airplane immediately after takeoff. A related factor was the pilot's improper procedures during lift-off.NTSB CHI95LA088Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIdelayed remedial action by the flight instructor. Factors in the accident were the student pilot not maintaining directional control once airborne.NTSB MIA95LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Wrightsville, GAThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in a turn. The low altitude at the time of the stall was a factor.NTSB LAX95FA037Accident · 3 fatalField investigationFinal reportCessna 172K · Springerville, AZthe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall/spin. The pilot's diverted attention and overconfidence in the aircraft's ability to fly slow were factors in this accident.NTSB SEA94FA018Accident · 1 fatalField investigationFinal reportCessna 172K · North Bend, ORLoss of control while in flight due to pilot incapacitation from atherosclerotic heart disease.NTSB LAX93LA277Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Torrance, CAAn encounter with a windshear condition. The delayed banner jettison was a factor.NTSB SEA93LA093Accident · No injuriesLimited investigationFinal reportCessna 172K · Pony, MTThe improper preflt planning by the PIC and his failure to attain takeoff airspeed during ground roll on a soft snow covered airstrip. A factor relating to the accident was the soft snow on the airstrip.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 BFO92LA104Accident · No injuriesLimited investigationFinal reportCessna 172K · Piqua, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB LAX92LA281Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Agua Caliente, CAThe failure of the pilot to maintain an adequate approach airspeed and an inadvertent stall/mush condition which resulted in a collision with the ground short of the runway. A factor in the accident was the pilots lack of total experience in type of aircraft.NTSB MIA91LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Groveland, FLFailure of the pilot to maintain adequate airspeed resulting in inadvertent stall/mush.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 LAX88LA313Accident · No injuriesLimited investigationFinal reportCessna 172K · Fresno, CAThe pilot stated that he had mistakenly lined up for final approach on taxiway rather than runway 29L as instructed. When he was on short final the control tower informed him of his mistake. While maneuvering to line up on runway 29L, the pilot lost control…NTSB SEA88LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Monroe, WAThe pilot reported that he encountered a downdraft on final. He added power for a go-around; however, a wingtip struck the ground. The aircraft cartwheeled and came to rest to the left of the runway.NTSB DEN87LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Tierra Amrilla, NMNo witnesses were found who had seen the accident. The man believed to be the plt gave the investigating police officer an assumed name. The wreckage dissappeared soon after the crash and has not been found to date. The acft attempted a takeoff with four…NTSB MKC85LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Kalona, IAThe plt reported that on the initial indication of rain, he elected to takeoff from the harvested soybean field before it became muddy. The field was soft & was about 2100 ft long. Before the acdnt, the wind was from the south, so the plt began his takeoff in…NTSB LAX85LA349Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Santa Paula, CAOn a local flt to view camping and hiking facilities in mountainous terrain, the acft entered a box canyon with a moderately rising floor and steep sides reported by the sheriff's department at about one-quarter of a mile wide. Duringan attempted course…NTSB MKC83FA025Accident · 3 fatalField investigationFinal reportCessna 172K · Oxford, NEThe pilot made 3 low passes near his son's home. Reportedly, the 3rd pass was made at an altitude of about 40 to 50 ft AGL. A witness then observed the pilot pull up abruptly to about a 45 deg climb. After climbing an additional 40 to 50 ft, the aircraft…NTSB ANC82DAG38Accident · Minor injuriesFinal reportCessna 172K · 44mi Nw Mccarth, AKShortly after liftoff from a short gravel strip the aircraft settled back onto the rough terrain and crashed.NTSB LAX82FA170Accident · Minor injuriesField investigationFinal reportCessna 172K · Huntington Beac, CAThe pilot reported that while he was on final approach to runway 19, he applied full flaps near the airport boundary and the aircraft veered to the right. He said that the aircraft did not respond to aileron control inputs. The aircraft continued to the…