NTSB investigations: Cessna 172N, FL

18 cases on aircraft the registry lists as Cessna 172N, where the sequence of events included Collision with terr/obj (non-CFIT). 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

20082026
NTSB investigations: Cessna 172N, FL per year, 2008–2026: 18 cases
20081
20112
20132
20141
20151
20162
20182
20192
20211
20232
20241
20251

Latest 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 ('2072434')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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.

NTSB ERA26LA046Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Palm Bay, FLOn November 17, 2025, about 1900 eastern standard time, a Cessna 172N, N6124D, was substantially damaged when it was involved in an accident near Palm Bay, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…Nov 18, 2025 · N6124D · Substantial damageNTSB ERA24LA271Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hernando, FLThe improper installation of a cylinder rocker stud by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing.Jun 21, 2024 · N734XT · Substantial damageNTSB ERA24LA059Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Zephyrhills, FLAn aerodynamic stall from which the pilots did not recover while maneuvering in the airport traffic pattern.Dec 7, 2023 · N906KS · Substantial damageNTSB ERA23LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Opa-locka, FLThe flight instructor’s decision to taxi behind a large multi-engine airplane, which resulted in an encounter with propeller blast and a loss of airplane control on the ground.Jan 3, 2023 · N2354E · Substantial damageNTSB ERA21LA261Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jupiter, FLThe flight instructor’s failure to obtain the proper touchdown point during a forced landing. Contributing to the accident was the improper service and subsequent inadequate inspection of the single-drive, dual magneto, which resulted in a total loss of…Jun 18, 2021 · N2797E · Substantial damageNTSB GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.Nov 12, 2019 · N739UA · Substantial damageNTSB GAA19CA122Accident · No injuriesData collectionFinal reportCessna 172 · Miami, FLThe student pilot's failure to control the airplane's speed and direction during the approach, which resulted in landing long, a runway excursion, and impact with a windsock.Jan 19, 2019 · N734AY · Substantial damageNTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.Nov 12, 2018 · N4642J · Substantial damageNTSB ERA18FA194Accident · 4 fatalField investigationFinal reportPiper PA34 · Miami, FLThe failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.Jul 17, 2018 · N16281 · 2 aircraft · DestroyedNTSB ERA16FA309Accident · 2 fatalField investigationFinal reportCessna 172 · Hollywood, FLThe pilot's inadequate preflight and in-flight weather planning, which resulted in continued flight into a thunderstorm and a subsequent loss of airplane control.Sep 3, 2016 · N6091E · DestroyedNTSB ERA16LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hollywood, FLA partial loss of engine power during the initial climb for undetermined reasons.Jun 26, 2016 · N734UF · Substantial damageNTSB GAA16CA073Accident · No injuriesData collectionFinal reportCessna 172N · Boca Raton, FLThe pilot's failure to maintain directional control during the landing touchdown resulting in a runway excursion, a collision with an object, and an impact with terrain.Dec 3, 2015 · N5185D · Substantial damageNTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…Aug 6, 2014 · N9400E · Substantial damageNTSB ERA13FA217Accident · Minor injuriesField investigationFinal reportCessna 172N · Dade City, FLThe in-flight loosening of the No. 3 cylinder exhaust valve rocker arm stud, which resulted in a complete loss of engine power.Apr 27, 2013 · N5944J · Substantial damageNTSB ERA13CA137Accident · Minor injuriesData collectionFinal reportCessna 172N · Okeechobee, FLThe pilot’s failure to maintain directional control during takeoff.Feb 18, 2013 · N6249D · Substantial damageNTSB ERA12LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe separation of the throttle cable from its fitting, which resulted in an inability to control engine power. Contributing to the accident was the inadequate maintenance by the owner.Nov 1, 2011 · N739JN · Substantial damageNTSB ERA11CA347Accident · No injuriesData collectionFinal reportCessna 172N · Belle Glades, FLThe pilot’s failure to maintain airplane control during the landing approach.Jun 15, 2011 · N4954G · Substantial damageNTSB ERA09LA015Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kissimmee, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during initial climb due to fuel contamination. Contributing to the accident was a fuel tank cap that did not seal properly.Oct 12, 2008 · N734BL · Substantial damage