NTSB investigations: Cessna 172P
99 cases on aircraft the registry lists as Cessna 172P, 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 | 4 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 8 |
| 1986 | 1 |
| 1987 | 5 |
| 1988 | 9 |
| 1989 | 6 |
| 1990 | 4 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 1 |
| 1994 | 8 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 4 |
| 2007 | 2 |
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\" = 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 ('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" = 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 DFW08CA041Accident · No injuriesData collectionFinal reportCessna 172P · Bridgeport, TXThe pilot's failure to maintain direction control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.NTSB DFW08CA011Accident · No injuriesData collectionFinal reportCessna 172 · McAllen, TXThe pilot's failure to maintain airspeed during the landing approach resulting in an inadvertent stall.NTSB MIA06FA007Accident · 1 fatalField investigationFinal reportCessna 172P · La Belle, FLThe student pilot's failure to maintain airspeed during the initial takeoff climb, resulting in an inadvertent stall/spin and uncontrolled descent to ground impact. A contributing factor was the failure of the wing flap control, which resulted in the flaps…NTSB NYC05CA146Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot's failure to maintain directional control during landing.NTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.NTSB ATL05CA062Accident · Minor injuriesData collectionFinal reportCessna 172P · Redstone Arsnl, ALThe pilot's failure to maintain adequate airspeed during approach, which resulted in an inadvertent stall and subsequent collision with the runway. Factors were the turbulence and crosswind conditions.NTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.NTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.NTSB NYC04CA089Accident · No injuriesData collectionFinal reportCessna 172P · Zelienople, PAThe pilot's improper recovery from a bounced landing.NTSB ATL04LA013Accident · No injuriesLimited investigationFinal reportCessna 172P · Pell City, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing. A factor was the crosswind.NTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.NTSB FTW03LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gainesville, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the prevailing crosswind and the pilot's failure to abort landing.NTSB LAX03FA124Accident · 2 fatalField investigationFinal reportCessna 172P · North Las Vegas, NVthe applicant pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall/spin.NTSB MIA03FA043Accident · 4 fatalField investigationFinal reportCessna 172P · Edgewater, FLThe pilot's inflight loss of control and the pilot's failure to recover from the resultant dive for unknown reasons which resulted in flight beyond the design stress limits of the airplane and subsequent in flight airframe breakup.NTSB ATL02LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mocksville, NCThe pilot's failure to maintain airspeed during the takeoff and initial climb which resulted in an inadvertent stall and the subsequent collision with trees.NTSB CHI02LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Council Bluffs, IAThe student pilot's failure to maintain control of the airplane and the subsequent inadvertent stall. A factor associated with the accident was the student's lack of total experience.NTSB IAD02FA037Accident · 4 fatalField investigationFinal reportCessna 172P · Ocean City, MDThe pilot's spatial disorientation, which resulted in his subsequent loss of control of the airplane. A factor was the dark night, over water visual conditions.NTSB NYC01LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Stevensville, MDThe pilot's improper flare and his improper recovery from a bounced landing.NTSB SEA01LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grants Pass, ORThe pilot's failure or inability to maintain proper runway alignment during landing. Factors included gusty crosswind conditions and the pilot's lack of experience in crosswind landings.NTSB FTW01LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Pleasanton, TXthe student pilot's failure to maintain directional control during the landing flare/touchdown. Contributory factors were the gusty wind and the student pilot's lack of total flight experience.NTSB IAD01LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williamsport, PAThe pilot's premature raising of flaps resulting in his failure to establish a climb and his failure to maintain directional control.NTSB MIA01LA013Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Knoxville, TNThe pilot's failure to maintain Vs during takeoff/initial climb, which resulted in an inadvertent stall/mush, an uncontrolled descent, and an impact with the ground. Factors in the accident were the pilot's improper preflightplanning/preparation and failure…NTSB LAX00FA178Accident · 4 fatalField investigationFinal reportCessna 172P · Chester, CAThe pilot's encounter with a wind shear at low altitude, which resulted in a loss of control and a stall/spin. Factors in the accident were the high density altitude and the pilot's lack of experience and training in high density altitude operations. The…NTSB NYC00FA106Accident · 2 fatalField investigationFinal reportCessna 172P · Ballston Spa, NYa loss of control for undetermined reason(s).NTSB DEN99LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe pilot's failure to maintain adequate airspeed during the flare for landing/touchdown phase of flight. A factor was a ditch off the side of the runway.NTSB IAD99FA051Accident · No injuriesField investigationFinal reportCessna 172P · Gaithersburg, MDwas the pilot's failure to obtain the proper rotation speed and his subsequent loss of directional control. A factor in the accident was the improper setting of the elevator trim.NTSB FTW98LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Georgetown, TXinadequate supervision by the flight instructor (CFI), by failing to ensure that the student obtained and/or maintained sufficient airspeed, which led to an inadvertent stall and collision with the terrain.NTSB NYC98FA066Accident · 1 fatalField investigationFinal reportCessna 172P · York, PAThe pilot's failure to maintain airspeed during final approach which resulted in an inadvertent stall/spin.NTSB IAD97FA122Accident · 1 fatalField investigationFinal reportCessna 172P · Airville, PAThe student pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent collision with terrain.NTSB NYC97LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Morristown, NJThe flight instructor's inadequate supervision which allowed the student to solo at night with less than one hour of night instruction with a known inoperative landing and taxi light. A Factor was the student pilot's spatial disorientation which resulted in…NTSB FTW97LA175Accident · No injuriesLimited investigationFinal reportCessna 172P · Austin, TXThe pilot's failure to maintain aircraft control. A factor was the pilot's inadequate compensation for the wind conditions.NTSB LAX97LA167Accident · Serious injuriesLimited investigationFinal reportCessna 172P · San Jose, CAThe student pilot's failure to maintain adequate airspeed to preclude stalling following an improper recovery from a bounced landing. Contributing factors were the pilot's premature and excessive flap retraction and misjudged landing flare.NTSB MIA97FA013Accident · 3 fatalField investigationFinal reportCessna 172P · St. Croixthe pilot's failure to maintain airspeed.NTSB IAD96FA132Accident · 3 fatalField investigationFinal reportCessna 172P · Summersville, WVThe pilot's improper flare, his delay in aborting a landing, and his failure to maintain adequate airspeed, which resulted in a bounced landing and a stall during climb out in an attempt to avoid collision with trees.NTSB FTW96LA179Accident · No injuriesLimited investigationFinal reportCessna 172P · Colorado Spgs, COthe student pilot'S failure to maintain control of the aircraft during a go-around.NTSB FTW95LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Mountain Home, ARThe pilot's failure to compensate for the gusty crosswind. A factor was gusting crosswinds.NTSB NYC94LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Pottsville, PAThe pilot's failure to attain adequate airpseed, which resulted in a stall/mush and collision with a tree.NTSB NYC94LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Leesburg, VAThe student pilot's failure to attain adequate airpseed during an aborted landing which resulted in an inadvertent stall and collision with the ground. A factor is the the student pilot's inexperience.NTSB NYC94LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Newport News, VAThe pilot's (1) improper recovery from a bounced landing and (2) failure to maintain aircraft control.NTSB NYC94LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenville, METhe premature retraction of the wing flaps by the pilot after takeoff, resulting in a loss of lift and collision with trees.NTSB ATL94LA125Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kitty Hawk, NCThe pilot's improper compensation for the wind conditions, his improper recovery from a bounced landing, and the inadvertent stall. Factors were the wind conditions and the trees that bounded the runway.NTSB MIA94LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fernandina, FLThe pilot in command's improper use of flight controls and his failure to maintain airspeed resulting in an inadvertent stall and uncontrolled descent to ground impact.NTSB FTW94FA155Accident · 2 fatalField investigationFinal reportCessna 172P · Arlington, TXThe pilot's loss of aircraft control for an undetermined reason, while maneuvering in the vicinity of the airport.NTSB LAX94LA186Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Elko, NVthe student pilot's improper use of the throttle and flap controls during a bounced landing recovery, and, his failure to maintain an adequate airspeed, which led to an inadvertent stall/spin.NTSB LAX93LA298Accident · No injuriesLimited investigationFinal reportCessna 172 · Vacaville, CAThe pilot's improper in-flight planning/decision by failing to allow enough time for the rotor wash to dissipate before attempting the approach. The wake turbulence (rotor wash) was a factor in this accident.NTSB FTW92FA201Accident · 1 fatalField investigationFinal reportCessna 172P · Breckenridge, TXAn inadvertent stall.NTSB DEN92LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Englewood, COAirplane climb capability exceeded and an inadvertent pilot induced stall. Factors were: weight and balance exceeded, high density altitude, and improper use of the mixture control.NTSB SEA92FA075Accident · 5 fatalField investigationFinal reportCessna 172P · Englewood, COA loss of airplane control initiated by inadvertent control interference by the passenger pilot while apparently attempting to quell a disturbance of an unknown nature. As a result, the pilot did not, or was unable to, maintain sufficient control of the…NTSB BFO92FA044Accident · 2 fatalField investigationFinal reportCessna 172P · Accokeek, MDThe pilot experienced spatial disorientation which resulted in loss of control of the airplane.NTSB ATL92FA053Accident · 2 fatalField investigationFinal reportCessna 172P · N Topsail Beach, NCThe failure of the pilot to obtain and/or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall and collision with the ground. Factors were: the failure of the pilot to follow procedures/directives, his operation of the aircraft…