NTSB investigations: Cessna 172M
113 cases on aircraft the registry lists as Cessna 172M, 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 | 4 |
| 1984 | 6 |
| 1985 | 8 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 8 |
| 1991 | 5 |
| 1992 | 7 |
| 1993 | 7 |
| 1994 | 7 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 10 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 6 |
| 2002 | 1 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 5 |
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 ('2072418')
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 ('2072418')
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 CHI08CA030Accident · No injuriesData collectionFinal reportCessna 172M · Duluth, MNThe pilot's inadequate compensation for wind conditions during the landing approach. Contributing to the accident was the crosswind weather condition.NTSB ATL07FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Mansfield, MAThe pilot's improper use of wing flaps during takeoff, which resulted in reduced climb performance and a subsequent stall. Contributing to the accident was the exceedance of the airplane's maximum gross weight.NTSB CHI07LA288Accident · 1 fatalLimited investigationFinal reportCessna 172M · Union Star, MOThe student pilot's failure to maintain adequate airspeed and the subsequent inadvertent stall while buzzing residences. Contributing to the accident was the pilot performing buzzing maneuvers.NTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.NTSB NYC07CA111Accident · Minor injuriesData collectionFinal reportCessna 172S · Montgomery, NYThe pilot's improper flare while landing, which resulted in a loss of directional control and collision with terrain.NTSB LAX06CA252Accident · No injuriesData collectionFinal reportCessna 172M · San Andreas, CAthe student pilot's improper soft-field takeoff technique and failure to obtain and maintain an adequate airspeed, which resulted in a stall mush. The certificated flight instructor's inadequate supervision of the maneuver was also causal.NTSB ANC06LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tuluksak, AKThe pilot's inadvertent stall/mush during takeoff-initial climb, which resulted in an in-flight collision with trees and terrain. Factors associated with the accident were the pilot's excessive loading of the airplane, his inadequate preflight planning, and a…NTSB SEA05FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Yamhill, ORThe flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…NTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.NTSB CHI04CA209Accident · Minor injuriesData collectionFinal reportCessna 172M · Sublette, KSThe student pilot's inadequate compensation for the crosswind condition, and her failure to maintain aircraft control during landing. Factors contributing to the accident included the student pilot's unsuccessful recovery from the bounced landings and the…NTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.NTSB FTW03LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ardmore, OKThe failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.NTSB FTW03LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXThe instructor's delay in executing a go-around and his failure to maintain aircraft control due to inadequate compensation of wind gusts. A contributing factor was the gusty winds.NTSB CHI03FA150Accident · Serious injuriesField investigationFinal reportCessna 172M · West Chicago, ILThe abrupt pull-up initiated by the pilot during takeoff before airspeed was attained resulting in a stall. Factors contributing to the accident were the pilot's failure to maintain directional control of the airplane on takeoff and the crosswind.NTSB LAX03LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Conroe, TXThe pilot's failure to attain/maintain sufficient airspeed, which resulted in a stall/mush.NTSB MIA03LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Leesburg, MSThe pilot's improper use of flaps, resulting in the degradation of climb performance and collision with the ground.NTSB ANC03LA014Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to adequately remove frost/ice from the airplane which resulted in an inadvertent stall/mush during the takeoff/initial climb.NTSB MIA02LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · New Smyrna Bch, FLthe failure of the pilot to maintain airspeed, during initial climb out, which resulted in an inadvertent stall, and subsequent impact with the terrain.NTSB MIA02LA031Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Barceloneta, PRThe pilot's failure to maintain control of the aircraft which resulted in an uncontrolled descent and an in flight collision with water. Contributing to the accident was the impairment of the pilot due to alcohol.NTSB LAX01LA259Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Placerville, CAInadequate airspeed during climb out following an aborted landing that was precipitated by the pilot's misjudged speed/distance on final approach. Also, contributing to the accident was the pilot's inexperience in the type of operation, his failure to…NTSB MIA01LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Miami, FLThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling, descending uncontrolled, impacting the runway, and sliding off the runway and nosing over.NTSB CHI01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · West Chicago, ILThe inadequate compensation for the crosswind by the student pilot. Additional factors included the student pilot's lack of total flight time, the runway sign and the crosswind.NTSB CHI01LA127Accident · No injuriesLimited investigationFinal reportCessna 172M · Eveleth, MNThe pilot's inadequate compensation for the crosswind conditions which resulted in the loss of aircraft control. Factors associated with the accident were the gusty crosswind condition, the pilot's lack of experience, and the trees which were contacted.NTSB CHI00FA129Accident · 3 fatalField investigationFinal reportCessna 172M · Cornell, WIthe pilot not maintaining aircraft control and the stall/spin he encountered. A factor was the extended flaps.NTSB CHI00LA036Accident · No injuriesLimited investigationFinal reportCessna 172M · Ava, MOthe improper in-flight decision made by the pilot. Factors to the accident were the charts/other manuals depicting the incorrect frequency, the dirt bank, and the rocks.NTSB NYC99LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fayetteville, WVThe pilot's failure to maintain directional control during the aborted landing. A factor in this accident was the crosswind condition.NTSB FTW99LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Midlothian, TXThe student pilot's failure to compensate for a crosswind resulting in a loss of control. Factors were the gusty high winds and the flight instructor's improper decision to allow the student to solo during high winds.NTSB LAX98LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Scottsdale, AZThe pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A contributing factor was the crosswind.NTSB NYC98LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Mansfield, MAThe pilot's failure to remove snow and ice from the aircraft prior to takeoff resulting in degraded climb performance and a subsequent stall/mush condition.NTSB MIA98FA045Accident · 1 fatalField investigationFinal reportCessna 172M · Raleigh-Durham, NCWas loss of control of the airplane on initial climb after entering instrument flight conditions resulting in a turn opposite in direction from that given by ATC, and eventual collision with terrain.NTSB ATL97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Lawrenceville, GAThe student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.NTSB NYC97LA156Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WVThe student pilot's improper recovery from a bounced landing.NTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…NTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.NTSB IAD97LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Put-In-Bay, OHPilot in command failed to maintain control of the airplane. Factors to the accident where high wind conditions with a strong crosswind component and the pilot's inadvertent failure to raise the flaps during the go around.NTSB IAD97LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during takeoff, which resulted in a collision with tree(s) and a ditch.NTSB ATL97LA043Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Brooksville, FLinadequate supervision by the flight instructor (CFI), and his failure to ensure that adequate airspeed was obtained/maintained, which resulted in a stall and collision with the ground. The crosswind was a related factor.NTSB FTW97LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172M · San Antonio, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A factor was the pilot's lack of recent experience.NTSB SEA96LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar City, UTthe pilot's failure to attain proper airspeed during takeoff, which resulted in a premature lift-off and an encounter with the terrain during the aborted landing. Excessive extension of the wing flaps was a related factor.NTSB IAD96LA125Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHfailure of the student pilot to maintain sufficient airspeed during an attempted go-around, which resulted in a stall/spin and an uncontrolled collision with the ground. A factor related to the accident was: an improper (premature) flare for landing.NTSB CHI96LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Backus, MNthe pilot's failure to maintain adequate altitude and his abrupt maneuver to avoid the tree tops. The dark night was a factor.NTSB FTW96LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fredericksburg, TXfailure of the pilot to maintain adequate airspeed during the approach and go-around, which resulted in a stall and subsequent collision with the ground. Factors relating to the accident were: the high, gusty, crosswind conditions, and the pilot's lack of…NTSB LAX96LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Bakersfield, CAthe pilot's improper aborted landing procedure which resulted in the aircraft stalling and impacting terrain.NTSB MIA96LA034Accident · No injuriesLimited investigationFinal reportCessna 172M · Madison, MSThe pilot's premature raising of flaps during a go-around.NTSB CHI95LA298Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Independence, MOthe pilot's failure to perform the pre-takeoff checklist and set the elevator trim tab to the takeoff position.NTSB BFO95FA045Accident · 3 fatalField investigationFinal reportCessna 172M · Eldersburg, MDThe pilot's failure to maintain proper airspeed. Factors in the accident were the pilot's failure to remove carburetor heat during the go-around and the presence of a tailwind.NTSB NYC95LA038Accident · No injuriesLimited investigationFinal reportCessna 172J · Batavia, OHFailure of the pilot to maintain control of the airplane during the landing flare/toughdown. Factors related to the accident were: the crosswind and proximity of the ditch to the runway.NTSB FTW95LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmington, NMThe pilot's inadequate compensation for wind conditions. Factors were wind shear, crosswinds, and gusts.NTSB NYC94LA179Accident · Minor injuriesLimited investigationFinal reportCessna 172M · New London, PAThe pilot failed to maintain adequate airpseed which resulted in an inadvertent stall and inflight collision with terrain.NTSB LAX94LA349Accident · 1 fatalLimited investigationFinal reportCessna 172M · Jackpot, NVthe pilot's failure to maintain aircraft control due to spatial disorientation during a moonless night departure over an area without ground reference lights. A factor in the accident was the pilot's lack of instrument training and experience.