Skip to content

NTSB investigations: Cessna 172E, FL

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

19642026

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 ('2072412')) 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 ('2072412'))
  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 ('2072412'))
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 ERA25LA200Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Florida City, FLThe commercial pilot’s improper fuel management, which resulted in a loss of total engine power due to fuel starvation.May 8, 2025 · N5405T · Substantial damage NTSB MIA03LA114Accident · No injuriesLimited investigationFinal reportCessna 172E · Hastings, FLThe failure of the pilot to maintain control of the airplane resulting in in-flight collision with terrain.May 26, 2003 · N817T · Substantial damage NTSB MIA85LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Leesburg, FLThe plt experienced an electrical failure while on a night flt & was unable to activate the rwy lights by keying his radio. He elected to land on the unlighted rwy without any landing lights rather than divert to another arpt. The plt stated that during the…Jul 18, 1985 · N3781S · Destroyed NTSB MIA84LA187Accident · No injuriesLimited investigationFinal reportCessna 172E · Vero Beach, FLThe plt reported that the acft ran out of fuel & landed just short of the rwy. He said that the acft impacted palmettos on the rwy extension & the nose gear was torn off.Jun 18, 1984 · N5463T · Substantial damage NTSB MIA82DKJ03Accident · No injuriesFinal reportCessna 172 · Malone, FLThe pilot elected to land on a runway with 800 feet of hard sod and 2700 feet of soft dirt. The aircraft nosed over when the nose wheel dug into the dirt.Jan 15, 1982 · N5559T · Substantial damage NTSB MIA75DLA45Accident · No injuriesClosedCessna 172 · Old Town, FLMay 15, 1975 · N3580S · Substantial damage NTSB MIA72FLA17Accident · No injuriesClosedCessna 172E · Compass Lake, FLOct 24, 1971 · N919DD · Substantial damage NTSB MIA72AM008Accident · 2 fatalClosedCessna 172E · Ft.Lauderdale, FLJul 31, 1971 · N5465T · Destroyed NTSB MIA70DLA24Accident · No injuriesClosedCessna 172E · Pensacola, FLJun 19, 1970 · N3781S · Substantial damage NTSB MIA70DLM01Accident · Serious injuriesClosedCessna 172 · Naples, FLMar 4, 1970 · N3754S · Substantial damage NTSB MIA70F0032Accident · Minor injuriesClosedCessna 172E · Bartow, FLMay 30, 1969 · N3685S · 2 aircraft · Substantial damage NTSB MIA67D0311Accident · No injuriesClosedCessna 172 · Ft-Bassinger, FLNov 4, 1966 · N3582S · Substantial damage NTSB MIA67F0212Accident · No injuriesClosedCessna 172E · Tampa, FLSep 20, 1966 · N3685S · Substantial damage NTSB MIA66A0128Accident · 2 fatalClosedCessna 172E · Clearwater, FLMay 5, 1966 · N3907S · Destroyed NTSB MIA66F0340Accident · No injuriesClosedCessna 172E · Lake Wales, FLNov 20, 1965 · N3683S · Substantial damage NTSB MIA66D0292Accident · No injuriesClosedCessna 172 · Miami, FLOct 2, 1965 · N3920S · Substantial damage NTSB MIA65F0057Accident · No injuriesClosedCessna 172E · St Cloud, FLApr 11, 1965 · N7753U · Substantial damage NTSB UNK65X1135Accident · No injuriesClosedCessna 172 · Belle Glade, FLDec 26, 1964 · N3723S · Substantial damage NTSB UNK65X1069Accident · No injuriesClosedCessna 172E · Miami, FLDec 20, 1964 · N3920S · Substantial damage NTSB UNK64X3603Accident · No injuriesClosedCessna 172 · Miami, FLAug 26, 1964 · N5600T · Substantial damage NTSB UNK64X3112Accident · Serious injuriesClosedCessna 172E · Ft Lauderdale, FLJul 29, 1964 · N5456T · No damage