Final NTSB investigations: Cessna 172S
578 cases on aircraft the registry lists as Cessna 172S. 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
| 1967 | 2 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1979 | 3 |
| 1987 | 1 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 20 |
| 2002 | 22 |
| 2003 | 29 |
| 2004 | 27 |
| 2005 | 28 |
| 2006 | 25 |
| 2007 | 26 |
| 2008 | 31 |
| 2009 | 22 |
| 2010 | 27 |
| 2011 | 20 |
| 2012 | 29 |
| 2013 | 24 |
| 2014 | 18 |
| 2015 | 18 |
| 2016 | 29 |
| 2017 | 24 |
| 2018 | 22 |
| 2019 | 23 |
| 2020 | 18 |
| 2021 | 22 |
| 2022 | 9 |
| 2023 | 13 |
| 2024 | 14 |
| 2025 | 14 |
| 2026 | 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.\"completionStatus\" = 'Completed'
AND 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'))
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."completionStatus" = 'Completed'
AND 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'))
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 ERA26LA248Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe student pilot’s failure to ensure clearance while taxiing, which resulted in contact with another airplane that was performing an engine run-up.NTSB WPR26LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Death Valley, CAThe pilot’s failure to maintain airspeed and encounter with a tailwind while landing on a rough runway, which resulted in a runway overrun and subsequent nose over.NTSB WPR26LA220Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Morgan Hill, CAAn in-flight collision with a bird.NTSB CEN26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Colorado Springs, COThe student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.NTSB CEN26LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Georgetown, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ERA26LA209Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Harrison, NYThe student pilot’s excessive pitch up attitude during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB ERA26LA174Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · The Rock, GAThe pilot’s improper landing flare, which resulted in a hard, porpoised landing.NTSB ERA26LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Carthage, NCThe pilot’s failure to maintain clearance from trees while on final approach for landing. Contributing to the accident were the flight instructor’s inadequate remedial actions.NTSB CEN26LA133Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Denver, COThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing which resulted in substantial damage to the airplane.NTSB ERA26LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Castle, DEThe pilots’ failure to properly identify the assigned runway during the landing approach, which resulted in the airplane landing on a closed, snow-covered runway. Contributing was the illumination of the closed runway’s edge lighting.NTSB ERA26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lynchburg, VAAn in-flight collision with a bird.NTSB ERA26LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · North Lauderdale, FLA total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.NTSB ERA26LA003Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · West Milford, NJThe pilot’s failure to adequate clearance from obstacles while maneuvering during the landing approach and the instructor pilot’s delayed remedial action, which resulted in the airplane contacting a tree and terrain.NTSB WPR26LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Lathrop, CAAn inflight collision with a bird.NTSB CEN26LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · North La Junta, COThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB ERA25LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Farmingdale, NYThe Cessna 150 pilot’s decision to taxi in front of an oncoming Cessna 172, which resulted in a ground collision. Contributing to the accident was the Cessna 150 pilot’s momentary distraction, which delayed his recognition of the impending collision.NTSB ERA25LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gaithersburg, MDThe flight instructor’s distraction during landing, which resulted in a long landing and subsequent runway excursion.NTSB ERA25LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Baltimore, MDThe pilot’s inadequate landing flare at night, which resulted in a hard landing.NTSB CEN25LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Rusk, TXThe pilot's failure to maintain airplane control and adequate airspeed during the go-around, resulting in an aerodynamic stall and impact with terrain.NTSB ERA25LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB WPR25LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · La Verne, CAThe failure of the right main landing gear tubular spring due to a fatigue crack that originated at the airframe connecting bolt hole and progressed to an overstress fracture.NTSB CEN25LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe student pilot’s inadequate landing flare that led to a bounced landing, and her improper pitch control during the attempted recovery that resulted in a nose down pitch attitude upon the second touchdown.NTSB ERA25LA118Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s failure to maintain an appropriate glide path and the flight instructor’s inadequate monitoring of the landing approach, which resulted in the airplane contacting the ground short of the runway.NTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.NTSB ERA25FA082Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Cintrona, PRMaintenance personnel’s inadequate inspection of the airplane, which resulted in inflight the failure of the right aileron carry through cable due to wear, reduced effectiveness of the airplane’s ailerons, and a subsequent loss of control.NTSB ERA25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Jefferson, GAThe airplane’s collision with a deer on the runway during landing.NTSB ERA25LA072Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Pahokee, FLThe pilots' failure to see and avoid the other airplane, which resulted in a midair collision during short final approach.NTSB ERA25LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Chattanooga, TNA partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…NTSB WPR24LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Seattle, WAThe Gulfstream pilot’s failure to maintain clearance from the Cessna while taxiing that resulted in a ground collision.NTSB ERA24LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Elizabeth City, NCThe pilot’s improper flare and subsequent improper recovery from a bounced landing.NTSB ERA24LA231Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Pierson, FLThe flight instructor’s failure to attain a proper touchdown point during a precautionary landing, which resulted in a runway excursion during landing.NTSB WPR24LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Prescott, AZThe student pilot’s failure to maintain directional control during landing following an aborted takeoff which resulted in a runway excursion and impact with a ditch.NTSB ERA24LA398Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · St. Augustine, FLThe pilot’s improper landing flare resulting in a hard, bounced landing.NTSB WPR24LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Chandler, AZThe pilot’s failure to maintain clearance from obstacles during taxi operations.NTSB ERA24LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zelienople, PAThe pilot’s inadequate compensation for the gusting crosswind condition during landing.NTSB ERA24LA137Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Leesburg, VAAn in-flight collision with a bird while on the downwind leg of the airport traffic pattern.NTSB ERA24LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Smyrna, TNAn in-flight collision with a bird during initial climb.NTSB ERA24LA090Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Mooresville, NCThe pilot’s failure to maintain control of the airplane during a go-around in gusting crosswind conditions.NTSB ERA24LA033Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Orlando, FLA partial loss of engine power during initial climb after takeoff for undetermined reasons.NTSB CEN23LA421Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, TXThe student pilot’s improper landing flare, which resulted in a hard, bounced landing, and the nose landing gear collapse.NTSB CEN23LA430Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · West Bend, WIThe pilot’s inadequate landing flare that resulted in a hard landing and impact with the runway.NTSB CEN23LA348Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Philadelphia, PAThe pilot receiving instruction’s failure to maintain control during a go-around. Contributing to the accident was the flight instructor’s inadequate supervision of the flight.NTSB CEN23LA354Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Clewiston, FLThe student pilot’s improper landing flare, which resulted in a hard landing on the nose landing gear. Contributing to the accident was the flight instructor’s inadequate supervision of the student pilot.NTSB WPR23LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Long Beach, CAThe flight instructor’s inattention during ground operations, which resulted in unintentional movement of the airplane and ground collision with another airplane.NTSB WPR23LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Novato, CAThe pilot's failure to maintain directional control of the airplane during the landing roll for a touch and go, which resulted in a collision with terrain.NTSB WPR23LA199Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Casa Grande, AZAn in-flight separation of the throttle linkage, which resulted in a loss of throttle control. Contributing to the accident was maintenance personnel’s failure to follow the maintenance manual inspection procedure for the throttle cable assembly.NTSB CEN23LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Brookings, SDThe student pilot’s failure to maintain pitch and directional control during the takeoff roll. Contributing to the accident, was the student pilot’s delay in relinquishing control of the airplane and the instructor's delayed reaction before the loss of…NTSB WPR23FA172Accident · 1 fatalClass 3 · FieldFinal reportCessna 172S · Los Angeles, CAThe pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.NTSB CEN23LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fredericksburg, TXThe pilot’s failure to maintain airplane control during an attempted go-around resulting in abnormal contact with the runway pavement and a runway excursion.NTSB CEN23LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Princeton, MNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident, was the runway condition combined with a right crosswind.