NTSB investigations: Cessna 172N
104 cases on aircraft the registry lists as Cessna 172N, 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 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 6 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 5 |
| 1995 | 8 |
| 1996 | 8 |
| 1997 | 4 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 3 |
| 2004 | 8 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 4 |
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 ('2072434')
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 ('2072434')
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 DEN08CA020Accident · No injuriesData collectionFinal reportCessna 172N · Grand Junction, COthe pilot's improper flare resulting in a hard landing.NTSB MIA07CA143Accident · Minor injuriesData collectionFinal reportCessna 172N · Carrabelle, FLThe improper flare by the pilot-in-command resulting in a hard landing.NTSB ATL07CA132Accident · No injuriesData collectionFinal reportCessna C172N · Manassas, VAThe student pilot's failure to correct for a pilot-induced oscillation/porpoise, during flare/touchdown, which resulted in a hard landing.NTSB CHI07CA245Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe student pilot's improper flare, which resulted in a hard landing. An additional cause was the pilot's inadequate recovery from a bounced landing. Factors in the accident include the pilot's failure to maintain directional control during the landing roll…NTSB CHI07CA006Accident · No injuriesData collectionFinal reportCessna 172N · Grand Rapids, MNThe student pilot's misjudged landing flare and improper recovery from the bounced landing which led to the failure of the nose landing gear. The overload failure of the nose landing gear was a factor.NTSB CHI07CA004Accident · No injuriesData collectionFinal reportCessna 172N · St Charles, MOThe pilot's failure to properly judge the landing flare and his inadequate recovery from the resulting bounced landing. A contributing factor was the inadvertent pilot induced oscillation (porpoise) after initial runway contact.NTSB MIA06CA101Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe improper flare by the pilot resulting in a hard landing and substantial damage to the airplane.NTSB MIA06CA088Accident · No injuriesData collectionFinal reportCessna 172N · Daytona Beach, FLThe pilot's improper landing flare/touchdown, which resulted in the airplane porpoising and incurring damage.NTSB LAX05CA128Accident · No injuriesData collectionFinal reportCessna 172N · San Jose, CAthe student pilot's misjudged landing flare, which resulted in a hard landing.NTSB DEN05LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Loveland, COThe dual student's improper flare and the flight instructor's inadequate supervision.. A contributing factor was the inadequate communication between the flight instructor and the dual student,NTSB DEN05LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Casper, WYthe student pilot's improper flare resulting in a hard landing. A factor contributing to the accident was the student pilot's improper recovery from the bounced landing.NTSB CHI04LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · Gary, INThe failure of the nose wheel for undetermined reasons. A factor associated with the accident was the student pilot's failure to properly flare the airplane.NTSB NYC04CA189Accident · No injuriesData collectionFinal reportCessna 172P · Wilkes-Barre, PAThe student pilot's improper flare and improper recover from a bounced landing. Factors in this accident were the crosswind condition and the partial failure of the airplane's transceiver, as reported by the pilot.NTSB ATL04CA162Accident · No injuriesData collectionFinal reportCessna 172 · Chamblee, GAThe pilot's improper landing flare that resulted in a hard landing. A factor was a tailwind condition.NTSB LAX04CA255Accident · Minor injuriesData collectionFinal reportCessna 172N · Chemehuevi, CAthe pilot's improper recovery from a bounced landing, inadequate compensation for the wind conditions, and his failure to maintain directional control of the airplane.NTSB ATL04CA113Accident · No injuriesData collectionFinal reportCessna 172N · Odessa, FLThe pilot's improper landing flare that resulted in a hard landing.NTSB NYC04CA104Accident · No injuriesData collectionFinal reportCessna 172N · Bridgeport, CTThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control which resulted in a hard landing. A factor was the gusty winds.NTSB NYC04CA073Accident · No injuriesData collectionFinal reportCessna 172N · Easton, MDThe student pilot's improper flare, which resulted in a hard landing.NTSB LAX04CA059Accident · No injuriesData collectionFinal reportCessna 172N · Winslow, AZthe pilot's misjudged landing flare, which resulted in a pilot induced porpoise oscillation and hard landing.NTSB LAX03CA247Accident · No injuriesData collectionFinal reportCessna 172N · Livermore, CAThe pilot's misjudged landing flare, which resulted in a porpoise pilot induced oscillation and hard landing.NTSB CHI03LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Carbondale, ILThe pilot failed to properly recover from a bounced landing which resulted in the airplane porpoising.NTSB LAX03LA053Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAthe student pilot's excessive use of the elevator control that resulted in an inadvertent lift-off and his failure to maintain/attain adequate airspeed, which resulted in a stall and hard landing.NTSB MIA02LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Pinehurst, NCThe student pilot's improper recovery from bounced landing which resulted in substantial damage to the airplane.NTSB NYC02LA145Accident · No injuriesLimited investigationFinal reportCessna 172N · Middletown, RIThe pilot's improper flare. A factor was the shifting wind.NTSB NYC02LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructor's improper recovery from a bounced landing.NTSB IAD02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYThe pilot's improper flare, which resulted in a misaligned, hard landing.NTSB DEN02LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of total experience in aircraft, and the pilot's lack of recent experience in kind of aircraft.NTSB IAD02LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PAThe pilot's improper flare, which resulted in a hard landing. A factor was the sun glare.NTSB DEN02LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Colo Springs, COthe pilot's inadequate landing flare, which resulted in a hard landing. A contributing factor was the pilot's excessive airspeed on final approach.NTSB LAX01LA048Accident · No injuriesLimited investigationFinal reportCessna 172N · Marana, AZThe student pilot's improper flare and improper recovery from a bounced landing. A factor in the accident was the morning sun, which momentarily restricted the pilot's vision.NTSB NYC01LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYThe student pilot's improper recovery from a bounced landing.NTSB DEN00LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COThe pilot prematurely flaring the airplane for landing, resulting in a hard landing, followed by an inadvertent pilot-induced porpoise and loss of directional control. A factor was the fence.NTSB DEN00LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Abuquerque, NMThe pilot's improper flare and his inadequate recovery from a bounced landing.NTSB ATL00LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Melbourne, FLThe certified flight instructor's improper touchdown flare that resulted in a hard landing.NTSB FTW99LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Longview, TXThe pilot's improper touchdown technique, which resulted in the airplane porpoising.NTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.NTSB ATL99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Kissimmee, FLThe pilot's improper flare and recovery from a bounced landing.NTSB DEN99LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Platteville, COThe pilot misjudging the flare altitude, resulting in a hard landing, and his subsequent loss of aircraft control. A factor was overload forces collapsing the nose landing gear assembly.NTSB CHI99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Evansville, INThe pilot's improper flare and improper recovery from a bounced landing.NTSB MIA99LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Venice, FLThe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW98LA417Accident · No injuriesLimited investigationFinal reportCessna 172N · Gallup, NMThe pilot's inadequate landing flare. Factors were his misjudgement of altitude and his excessive airspeed.NTSB CHI98LA340Accident · No injuriesLimited investigationFinal reportCessna 172N · Traverse City, MIthe inadvertent stall/mush. Factors contributing to this accident were the pilot's improper compensation for the wind conditions, and his excessively high flare.NTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.NTSB IAD98LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Stevensville, MDthe pilot's improper flare, improper recover from a bounced landing, and failure to maintain directional control.NTSB LAX98LA201Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Barbara, CAThe pilot's misjudging the landing flare and subsequent hard landing.NTSB LAX98LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAthe student pilot's failure to maintain an appropriate airspeed and proper rate of descent, and his misjudged landing flare, which led to an uncontrolled porpoise and eventual collapse of the landing gear.NTSB LAX97LA295Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe pilot's inadequate recovery from a bounced landing.NTSB NYC97LA077Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln Park, NJthe student pilot's improper recovery from a bounced landing which resulted in a hard landing, collapsed nose gear, loss of directional control, and subsequent nose over.NTSB ATL97LA032Accident · No injuriesLimited investigationFinal reportCessna 172N · Anderson, SCThe pilot's improper recovery from a bounced landing. A factor was the pilot's improper level off.NTSB MIA97LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot's improper flare and improper recovery from a ballooned/bounced landing. The gusty wind was a related factor.