NTSB investigations: Cessna 172R, FL
34 cases on aircraft the registry lists as Cessna 172R. 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
| 1999 | 1 |
|---|---|
| 2001 | 4 |
| 2002 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 3 |
| 2026 | 1 |
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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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 ERA26LA025Accident · No injuriesClass 4 · LimitedFinal reportAkrotech Giles G-202 · Boca Raton, FLThe low-wing pilot’s inadequate visual lookout, which resulted in a collision with another airplane while taxiing.NTSB ERA25LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Spring Hill, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB ERA25LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Fort Myers, FLThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB ERA23LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Miami, FLThe pilot's improper landing flare, which resulted in substantial damage the airplane’s fuselage.NTSB ERA22LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kissimmee, FLThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nose landing gear impacting the runway.NTSB GAA19CA326Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe student pilot's excessive rudder application during takeoff and the flight instructor's delayed remedial action, which resulted in a loss of directional control, a runway excursion, and subsequent substantial damage.NTSB GAA18CA151Accident · No injuriesData collectionFinal reportCessna 172 · Lakeland, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.NTSB ANC18LA014Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLThe pilot's decision to continue the landing after a loss of visual cues during a night landing.NTSB ERA17LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Clearwater, FLThe pilot's improper landing flare, which resulted in damage to the engine firewall.NTSB GAA16CA114Accident · No injuriesData collectionFinal reportCessna 172 · Merritt Island, FLThe student pilot's improper flare which resulted in a porpoise, runway excursion, and nose over.NTSB ERA14CA184Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe inadvertent encounter with a microburst during taxi from landing that resulted in the aircraft being turned over inverted and receiving substantial damage.NTSB ERA14CA121Accident · No injuriesData collectionFinal reportCessna 172R · Fort Pierce, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA13CA189Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA044Accident · No injuriesData collectionFinal reportCessna 172R · Miami, FLThe flight instructor's improper power management during a steep, obstacle-clearance approach, which resulted in a hard landing.NTSB ERA12CA330Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot’s failure to maintain directional control during a touch-and-go landing.NTSB ERA11CA490Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe student pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.NTSB ERA11CA338Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe pilot’s improper flare and recovery from a bounced landing.NTSB ERA11CA241Accident · No injuriesData collectionFinal reportCessna 172 · Ft Pierce, FLThe student pilot's inadequate flare which resulted in a hard landing.NTSB ERA10LA421Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Key West, FLThe non-instrument-rated pilot's spatial disorientation during night, over-water, low-ambient-light conditions, which resulted in the airplane impacting the ocean.NTSB ERA09FA080Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Ft. Lauderdale, FLThe failure of both pilots to see and avoid the other aircraft.NTSB NYC07CA117Accident · No injuriesData collectionFinal reportCessna 172R · Hollywood, FLThe student pilot's inadequate recovery from a bounced landing which resulted in a loss of control and subsequent impact with a sign.NTSB MIA07CA090Accident · No injuriesData collectionFinal reportCessna 172R · Lantana, FLThe student pilot's failure to maintain directional control of the airplane during landing roll.NTSB MIA07CA065Accident · No injuriesData collectionFinal reportCessna 172R · Orlando, FLThe student pilot's inadequate compensation for the wind conditions while landing. Factors associated with the accident are a crosswind and wind gusts.NTSB MIA06CA113Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare.NTSB MIA06LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Fort Myers, FLThe flight instructor's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was a malfunction of the elevator control for an undetermined reason, which required excessive forward pressure on the…NTSB MIA06CA021Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare and remedial action during landing resulting in an in-flight loss of control and subsequent collision with terrain. A related factor was the crosswind.NTSB MIA05CA120Accident · No injuriesData collectionFinal reportCessna 172R · Fort Myers, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL02FA032Accident · 1 fatalField investigationFinal reportCessna 172R · Tampa, FLThe pilot's unauthorized use of an aircraft for the purpose of commiting suicide.NTSB ATL02LA007Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Kissimmee, FLSee narrative for ATL02LA007A.NTSB ATL01LA110Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLThe improper installation of the engine vacuum pump by maintenance personnel which resulted in oil exhaustion and the subsequent loss of engine power. A factor was the none-suitable terrain.NTSB MIA01LA228Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with another parked aircraft.NTSB ATL01LA089Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLThe student pilots improper flare, and improper recovery from a bounced landing. A factor was the student pilot's lack of total experience.NTSB MIA00LA027Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLWas the pilot's improper flare and improper recovery from a bounced landing resulting in a hard landing and damage to the aircraft.