NTSB investigations: Cessna 172P
84 cases on aircraft the registry lists as Cessna 172P, where the first occurrence was “Hard landing”. 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 | 4 |
|---|---|
| 1983 | 5 |
| 1984 | 8 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 8 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 10 |
| 1998 | 2 |
| 1999 | 4 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 3 |
| 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 ('2072436')
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\" = 200))
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 ('2072436')
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" = 200))
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 CHI07CA132Accident · No injuriesData collectionFinal reportCessna 172P · Kenosha, WIThe pilot's improper recovery from a bounced landing, which resulted in a flat nose wheel tire and a buckled firewall. A factor was the porpoising that was encountered during the flare.NTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.NTSB NYC06CA221Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe pilot's improper flare, which resulted in a hard landing.NTSB NYC06CA189Accident · No injuriesData collectionFinal reportCessna 172P · Poughkeepsie, NYThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a hard landing.NTSB ATL06CA047Accident · No injuriesData collectionFinal reportCessna 172 P · Wilmington, NCThe student pilot's improper landing flare which resulted in a hard landing.NTSB NYC05CA082Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's improper flare and recovery from a bounced landing.NTSB MIA05CA061Accident · No injuriesData collectionFinal reportCessna 172 · Brooksville, FLThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB FTW04LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesquite, TXThe student pilot's delayed landing flare and the improper supervision provided by the flight instructor.NTSB NYC04CA102Accident · No injuriesData collectionFinal reportCessna 172P · Westfield, MAThe student pilot's improper flare and his failure to maintain aircraft control while landing.NTSB ANC04LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Clewiston, FLThe student pilot's misjudged landing flare, which resulted in a hard landing, a collapse of the nose wheel landing gear, and the airplane nosing over when it encountered a ditch.NTSB CHI03LA229Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntingburg, INThe pilot's inadequate flare and the failure to perform a go-around during landing. The planned approach with a quartering tailwind were contributing factors.NTSB ATL03LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NCThe pilot's improper flare during touchdown and failure to properly recover from a bounced landing, which resulted in a loss of control and inflight collision with the runway. A factor was the pilot did not understand the porpoise condition during landing.NTSB ATL02LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Merritt Island, FLThe pilot's improper recovery after a bounced landing and improper landing flare which resulted in the airplane colliding with the runway.NTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.NTSB NYC02LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Coatesville, PAThe student pilot's loss of aircraft control which resulted in a hard landing, and the CFI's delayed remedial action. Factors related to the accident were the fatigue cracks which initiated at the attachment hole on the landing gear strut, and the crosswind…NTSB NYC01LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Dayton, OHThe pilot excessive flare, which resulted in a hard landing.NTSB LAX00LA031Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe pilot's misjudged landing flare and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing.NTSB SEA99LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Easton, WAThe flight instructor's delayed remedial action. Factors include the student allowing the aircraft to climb too steeply at too low an airspeed, and the soft/rough terrain on which the aborted takeoff took place.NTSB NYC99LA086Accident · No injuriesLimited investigationFinal reportCessna 172P · Lawrence, MAThe student pilot's improper flare, and his improper recover from a bounced landing.NTSB MIA99LA080Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, MSThe pilot's improper recovery from a bounced landing, resulting in a blown nose tire, loss of directional control, and subsequent collision with terrain.NTSB FTW98LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · La Porte, TXThe pilot's premature landing flare and improper recovery procedures from a bounced landing. A factor was the gusty winds.NTSB MIA98LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Destin, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB LAX97LA053Accident · No injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAimproper flare by the pilot during the landing, and his improper recovery from a bounced landing, which resulted in a hard landing, dragged wing tip, and a collapsed main gear.NTSB CHI97LA026Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's improper recovery from a bounced landing. A factor was the pilot's misjudging the flare.NTSB CHI96LA326Accident · No injuriesLimited investigationFinal reportCessna 172 · Chicago, ILthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the pilot's lack of experience (or lack of training) in recovery from bounced landings.NTSB LAX96LA250Accident · No injuriesLimited investigationFinal reportCessna 172 · Camarillo, CAthe student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was high airspeed.NTSB ATL96LA086Accident · No injuriesLimited investigationFinal reportCessna 172 · Winston-Salem, NCThe pilot's improper use of the elevator in response to a bounced landing.NTSB NYC96LA093Accident · No injuriesLimited investigationFinal reportCessna 172P · Rutland, VTthe pilot's improper flare and recovery from a bounced landing. A contributing factor was his lack of recent flight experience.NTSB FTW96LA191Accident · No injuriesLimited investigationFinal reportCessna 172P · Denton, TXthe student pilot's delayed landing flare and his improper bounced landing recovery technique.NTSB LAX96LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Sedona, AZthe pilot misjudged the flare.NTSB SEA96LA077Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAthe pilot's misjudgment of the aircraft's altitude above the runway and failure to flare for landing. Darkness (bright night) was a related factor.NTSB CHI96LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · West Chicago, ILthe student pilot's misjudging the flare. A factor was the gusts.NTSB NYC95LA172Accident · No injuriesLimited investigationFinal reportCessna 172P · Teterboro, NJthe student pilot's improper flare which resulted in the airplane porpoising and the subsequent buckling of the firewall.NTSB MIA95LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Clearwater, FLThe pilot-in-command's improper remedial action after the aircraft porpoised during the landing flare and touchdown.NTSB FTW95LA036Accident · No injuriesLimited investigationFinal reportCessna 172P · Colorado Spgs, COThe pilot's improper landing flare, the resultant porpoise and an inadequate recovery from the bounced landing.NTSB LAX94LA321Accident · No injuriesLimited investigationFinal reportCessna 172P · Scottsdale, AZthe pilot's misjudging the flare altitude and failing to maintain adequate airspeed resulting in an inadvertent stall and hard landing. The pilot's lack of total time in the airplane is a factor in this accident.NTSB SEA94LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Hillsboro, ORPoor in-flight planning. Factors to the accident were: inadequate remedial action and uncontrolled porpoise.NTSB SEA94LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Seattle, WAThe student's improper flare for landing and the instructor's delayed remedial action.NTSB LAX93LA368Accident · No injuriesLimited investigationFinal reportCessna 172P · Phoenix, AZThe pilot's misjudging the landing flare. A physical problem may have contributed.NTSB CHI92LA278Accident · No injuriesLimited investigationFinal reportCessna 172P · Yipslanti, MIThe pilot's premature flare during landing and not performing a recovery from a bounced landing.NTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.NTSB FTW92LA091Accident · No injuriesLimited investigationFinal reportCessna 172P · West Helena, ARPilot's improper flarea ND improper recovery from a bounced landing.NTSB LAX92LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Monica, CAThe pilot's misjudged landing flare and her improper bounced landing recovery technique. Contributing factors were the airplane's excessive approach airspeed and the student's lack of experience.NTSB FTW91LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Lakeview, AR(1) The pilot's failure to properly flare the airplane for landing and (2) his subsequent improper recovery from a bounced landing.NTSB DEN91LA094Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot misjudging his flare.NTSB ATL91LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Hatteras, NCThe pilot's improper landing flare, subsequent inadvertent porpoise, and his failure to execute a bounced landing recovery.NTSB SEA91LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAA hard landing due to the pilot's midjudgement of his touchdown.NTSB CHI90LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILThe student's improper flare, improper recovery from a bounced landing, and failure to maintain directional control. The crosswind was a related factor.NTSB DEN90LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Ogallala, NEThe misjudged landing flare. A factor was the pilot's lack of experience.NTSB LAX89LA272Accident · No injuriesLimited investigationFinal reportCessna 172P · Redlands, CAThe pilot's improper level-off, recovery from bounced landing, and failure to maintain directional control during the landing. The pilot's limited recent experience was a contributing factor.