Skip to content

NTSB investigations: Cessna 172F, FL

26 cases on aircraft the registry lists as Cessna 172F. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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 ('2072414')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072414'))
  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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172F · Vero Beach, FLA total loss of engine power for reasons that could not be determined.Jun 2, 2025 · N5200F · Substantial damage NTSB ERA14LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 - F · Gainesville, FLA total loss of engine power for reasons that could not be determined because a postaccident engine examination and test run revealed no anomalies.Oct 5, 2013 · N8715U · Substantial damage NTSB MIA03LA048Accident · No injuriesLimited investigationFinal reportCessna 172F · Jacksonville, FLa total loss of engine power due to the failure the oil filter because of over-pressurization, resulting in damage to the airplane during the subsequent forced landing.Jan 28, 2003 · N5602R · Substantial damage NTSB ATL03LA028Accident · No injuriesLimited investigationFinal reportCessna 172F · Stuart, FLThe pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.Dec 31, 2002 · N5338R · Substantial damage NTSB MIA01LA139Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Pierce, FLa loss of engine power due to fuel exhaustion which resulted in a forced landing, and subsequent impact with a sign and a ditch.May 6, 2001 · N8664U · Substantial damage NTSB MIA98LA233Accident · No injuriesLimited investigationFinal reportCessna 172F · Spring Hill, FLThe pilot's misjudgment of distance and his delay in initiating a go around. Contributing was the pilot's improper landing flare.Aug 30, 1998 · N7832U · Substantial damage NTSB MIA97FA010Accident · Minor injuriesField investigationFinal reportCessna 172F · Venice, FLinadequate maintenance servicing of the airplane during an oil change by the owner/pilot for his failure to secure the oil temperature probe securing nut. Also, inadequate maintenance of the airplane by the owner/pilot for his failure to operate the engine…Oct 22, 1996 · N5130F · Substantial damage NTSB MIA95LA006Accident · No injuriesLimited investigationFinal reportCessna 172-F · Clearwater, FLThe student pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident was the pilot's lack of total experience.Oct 15, 1994 · N8356U · Substantial damage NTSB MIA95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Indiantown, FLThe improper landing flare by the pilot resulting in the hard landing.Oct 11, 1994 · N5415R · Substantial damage NTSB MIA88LA272Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Wales, FLThe plt aborted the takeoff from the 'thick, wet' grass strip because the acft was not accelerating 'adequately.' He applied the brakes but it went off the departure end of the rwy, collided with a fence, tree, and dirt mound before coming to rest. There was…Sep 23, 1988 · N8707U · Substantial damage NTSB MIA86LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Clewiston, FLThe plt stated that a x-wind caused him to lose control of the acft while attempting to land on a x-country flt. The acft departed the rwy and struck a ditch. The plt indicated that no pre-flt wx briefing was obtained prior to departure.Feb 15, 1986 · N8886U · Substantial damage NTSB MIA74DLD92Accident · Minor injuriesClosedCessna 172 · Lake Wales, FLJun 2, 1974 · N8263U · Destroyed NTSB MIA74DKT50Accident · No injuriesClosedCessna 172 · Miami, FLDec 13, 1973 · N8443U · Substantial damage NTSB MIA72DLD76Accident · No injuriesClosedMid-America 172 · Kenansville, FLJun 21, 1972 · N8658U · Substantial damage NTSB MIA72FLA21Accident · Serious injuriesClosedCessna 172F · Gainesville, FLDec 4, 1971 · N8721U · Substantial damage NTSB MIA69D0428Accident · No injuriesClosedCessna 172F · Balm, FLMar 16, 1969 · N8438U · Substantial damage NTSB MIA69A0012Accident · 4 fatalClosedCessna 172F · Clewiston, FLSep 1, 1968 · N5359R · Destroyed NTSB MIA68D0534Accident · No injuriesClosedCessna 172F · Fort Myers, FLApr 11, 1968 · N8514U · Substantial damage NTSB MIA68F0482Accident · No injuriesClosedCessna 172 · Milton, FLMar 16, 1968 · N5567R · Substantial damage NTSB MIA68F0105Accident · No injuriesClosedCessna 172 · Tampa, FLAug 7, 1967 · N5366R · Substantial damage NTSB MIA67D0313Accident · No injuriesClosedCessna 172 · Opa Locka, FLNov 10, 1966 · N5359R · Substantial damage NTSB MIA66D0473Accident · No injuriesClosedCessna 172 · Ft Lauderdale, FLMar 25, 1966 · N8625U · Substantial damage NTSB MIA66F0338Accident · No injuriesClosedCessna 172 · Deland, FLNov 12, 1965 · N8625U · Substantial damage NTSB MIA66F0309Accident · No injuriesClosedCessna 172F · Homestead, FLOct 30, 1965 · N8748U · Substantial damage NTSB UNK65X1455Accident · No injuriesClosedCessna 172 · Daytona Beach, FLFeb 25, 1965 · N8335U · Substantial damage NTSB UNK65X1215Accident · No injuriesClosedCessna 172 · Naples, FLJan 2, 1965 · N8130U · Substantial damage