NTSB investigations: Cessna 172S
56 cases on aircraft the registry lists as Cessna 172S, 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
| 2001 | 5 |
|---|---|
| 2002 | 8 |
| 2003 | 8 |
| 2004 | 11 |
| 2005 | 8 |
| 2006 | 6 |
| 2007 | 10 |
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 ('2072439', '2072442')
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 ('2072439', '2072442')
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 SEA07CA207Accident · No injuriesData collectionFinal reportCessna 172S · Pahokee, FLThe student pilot's improper flare during the landing which resulted in a hard landing. The student pilot's failure to relinquish control of the aircraft, the flight instructors inadequate supervision and not being able to recover control of the aircraft from…NTSB ATL07CA105Accident · No injuriesData collectionFinal reportCessna 172S · Beverly, MAThe pilot's improper flare, which resulted in a hard landing and nose gear collapse. A contributing factor was the wind gust.NTSB LAX07CA202Accident · No injuriesData collectionFinal reportCessna 172S · Spanish Fork, UTThe pilot's misjudged landing flare resulting in a porpoise and hard touchdown.NTSB SEA07CA182Accident · No injuriesData collectionFinal reportCessna 172S · Long Beach, CAThe pilot's improper recovery from a bounced landing which resulted in an inadvertent stall and a hard landing. The crosswind was a factor.NTSB ATL07CA093Accident · No injuriesData collectionFinal reportCessna 172S · Batavia, NYThe student pilot's failure to flare the airplane during landing resulting in a hard landing.NTSB NYC07CA131Accident · No injuriesData collectionFinal reportCessna 172S · Raleigh-Durham, NCThe pilot's improper recovery from a bounced landing.NTSB NYC07CA116Accident · No injuriesData collectionFinal reportCessna 172S · Asheville, NCThe pilot's improper landing flare which resulted in a hard landing. A factor in the accident was the visual illusion experienced by the pilot from landing on a long, wide runway.NTSB LAX07CA171Accident · No injuriesData collectionFinal reportCessna 172S · Payson, AZThe pilot's inadequate in-flight planning/decision, excessive airspeed on final approach, and failure to execute a go-around resulting in a misjudged flare and hard landing.NTSB SEA07CA077Accident · No injuriesData collectionFinal reportCessna 172S · Kingman, AZThe pilot's misjudged flare, which resulted in a hard landing and a porpoise.NTSB CHI07CA054Accident · No injuriesData collectionFinal reportCessna 172S · Alton, ILThe student pilot's inadequate recovery from a bounced landing, which resulted in the airplane impacting a runway sign. A factor in the accident was the student pilot's misjudged landing flare.NTSB MIA07CA019Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA07CA008Accident · No injuriesData collectionFinal reportCessna 172S · Ormond Beach, FLThe failure of the student pilot to initiate a recovery from the bounced landing resulting in a hard landing.NTSB LAX06CA150Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.NTSB ATL06CA068Accident · No injuriesData collectionFinal reportCessna 172S · Gainsville, GAThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL06CA062Accident · No injuriesData collectionFinal reportCessna C-172S · Sanford, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB ANC06CA036Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's improper recovery from a bounced landing, which resulted in structural damage to the firewall and fuselage.NTSB ATL06CA025Accident · No injuriesData collectionFinal reportCessna 172S · Mobile, ALThe pilot's improper landing flare, which resulted in a hard landing.NTSB LAX05CA299Accident · No injuriesData collectionFinal reportCessna 172S · San Manuel, AZThe pilot's misjudged flare during a touch-and-go landing.NTSB IAD05CA120Accident · No injuriesData collectionFinal reportCessna 172S · White Plains, NYThe pilot's improper recovery from a bounced landing.NTSB LAX05CA275Accident · No injuriesData collectionFinal reportCessna 172S · Edwards AFB, CAthe pilot's misjudged flare and inadequate recovery technique from the subsequent bounces.NTSB IAD05CA104Accident · No injuriesData collectionFinal reportCessna 172S · Charlottesville, VAThe student pilot's improper flare which resulted in a hard landing.NTSB CHI05CA124Accident · No injuriesData collectionFinal reportCessna 172S · Port Huron, MIThe pilot not performing a go-around and misjudging the flare leading to a hard landing.NTSB MIA05CA121Accident · No injuriesData collectionFinal reportCessna 172SP · Clearwater, FLThe pilot's improper flare and recovery from a bounced landing.NTSB LAX05CA082Accident · No injuriesData collectionFinal reportCessna 172S · Coalinga, CAthe pilot's inadequate recovery from a bounced landing, and his failure to abort the landing.NTSB CHI05CA035Accident · No injuriesData collectionFinal reportCessna 172S · Anderson, INThe student pilot's improper flare and his inadequate recovery from a bounced landing.NTSB LAX05CA028Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe pilot's improper flare, which resulted in a hard landing. Contributing factors were his improper recovery from the subsequent bounced landing and pilot-induced oscillations.NTSB ATL05CA015Accident · No injuriesData collectionFinal reportCessna 172SP · West Columbia, SCThe student pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control during rollout. A factor was the runway sign.NTSB DEN04LA150Accident · No injuriesLimited investigationFinal reportCessna 172S · Broomfield, COthe pilot's improper flare, and the flight instructor's inadequate supervision of the pilot.NTSB DEN04CA137Accident · No injuriesData collectionFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control resulting in a hard landing. Factors contributing to the accident were the pilot induced oscillation and the high approach airspeed.NTSB DEN04LA127Accident · No injuriesLimited investigationFinal reportCessna 172S · Carlsbad, NMthe student pilot's inadequate flare resulting in a hard landing. A contributing factor was the tailwind conditions.NTSB LAX04CA290Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe student pilot's misjudged flare, which resulted in a hard landing. Also causal was the student pilot's improper recovery from a bounced landing and pilot induced porpoise and failure to maintain directional control on the landing roll, which resulted in…NTSB NYC04CA164Accident · No injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe pilot's improper flare during touch down, which resulted in a hard landing.NTSB CHI04CA165Accident · No injuriesData collectionFinal reportCessna 172S · Fishers, INThe pilot's inadequate remedial actions after an inadequate landing flare and subsequent hard landing. Additional causes were the pilot-induced porpoise and the collapse of the nose landing gear.NTSB FTW04CA163Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's improper recovery from a bounced landing.NTSB LAX04CA186Accident · No injuriesData collectionFinal reportCessna 172S · Long Beach, CAthe student pilot's inadequate flare, which resulted in a hard landing and porpoise.NTSB MIA04CA028Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilots improper landing flare and his improper recovery from a bounced landing resulting in a hard landing and damage to the airplane.NTSB IAD03CA071Accident · No injuriesData collectionFinal reportCessna 172 · Cleveland, OHThe pilot's improper flare, which resulted in a hard landing.NTSB MIA03CA148Accident · No injuriesData collectionFinal reportCessna 172S · Olive Branch, MSThe student pilot's improper landing flare/touchdown and inadequate recovery from a bounced landing which resulted in a hard landing and damage to the airplane.NTSB LAX03LA231Accident · No injuriesLimited investigationFinal reportCessna 172S · Chandler, AZThe pilot's misjudged landing flare, improper recovery from a bounced landing and failure to maintain directional control, resulting in a runway sign collision.NTSB LAX03CA248Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student's misjudged landing flare and inadvertent entry into a porpoise pilot-induced oscillation.NTSB MIA03CA125Accident · No injuriesData collectionFinal reportCessna 172S · Melbourne, FLThe pilot's improper flare and inadequate recovery from a bounced landing. Contributing factors were the pilot's failure to maintain directional control and his failure to execute a go-around.NTSB LAX03LA170Accident · No injuriesLimited investigationFinal reportCessna 172S · Kapolei, HIThe pilot's misjudged landing flare, and improper recovery from a bounced landing, which resulted in the collapse of the nose landing gear and structural damage to the airplane.NTSB IAD03CA044Accident · No injuriesData collectionFinal reportCessna 172S · Cleveland, OHThe student pilot's improper flare, which resulted in a hard landing.NTSB NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.NTSB CHI03LA075Accident · No injuriesLimited investigationFinal reportCessna 172S · Tea, SDThe student pilot's improper flare. The pilot's lack of experience and diverted attention were factors.NTSB CHI02LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Boyne Falls, MIThe pilot's improper flare during landing.NTSB ATL02LA166Accident · No injuriesLimited investigationFinal reportCessna 172S · Immokalee, FLThe student pilot's improper flare at touchdown resulted in a hard landing while performing an off-airport precautionary landing after the inadvertent activation of the autopilot.NTSB DEN02LA088Accident · No injuriesLimited investigationFinal reportCessna 172S · Englewood, COthe instructor's inadequate supervision of the flight and his premature raising of the flaps, resulting in a hard landing.NTSB LAX02LA167Accident · No injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's improper recovery from a bounced landing and failure to maintain directional control on the landing roll, which resulted in a collision with a runway sign.NTSB MIA02LA091Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLthe pilot misjudged the landing flare, resulting in a hard landing, and damage to the airplane.