Skip to content

NTSB investigations: Cessna 172B, FL

21 cases on aircraft the registry lists as Cessna 172B. 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 ('2072406')) 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 ('2072406'))
  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 ('2072406'))
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 MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.Nov 21, 2004 · N7493X · Substantial damage NTSB ATL01LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172-B · Palatka, FLThe CFI's inadequate preflight planning which resulted in fuel exhaustion and the subsequent loss of engine power.Oct 13, 2000 · N7894X · Substantial damage NTSB ATL98LA122Accident · No injuriesLimited investigationFinal reportCessna 172B · New Port Richey, FLThe pilots disregard of the performance capabilities of the airplane, his failure to attain and maintain flying speed, and his exceeding of the airplane's maximum weight.Sep 7, 1998 · N8096X · Substantial damage NTSB MIA86LA167Accident · No injuriesLimited investigationFinal reportCessna 172 · Windermere, FLAfter leveling off at an alt of aprx 1000 ft the eng of the float plane failed for undetermined causes. The plt selected a small lake on which to land and a glide was established. The plt stated that he lowered the flaps too soon & the left wing struck trees.…May 26, 1986 · N7850X · Substantial damage NTSB MIA85LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawtey, FLThe acft had not been flown for two years. During the preflt inspecton, the fuel sumps were drained repeatedly & each time, a quantity of water was observed in the collected fuel sample. Aprx 30 mins after takeoff, the eng failed & a forced landing was…Jul 25, 1985 · N8151X · Destroyed NTSB MIA85FLD01Accident · Serious injuriesFinal reportCessna 172B · Brooksville, FLAccording to a plt statement, he entered the traffic pattern at about 800 ft & held 70 mph with 10 deg of flaps & the carb heat on. After turning onto final apch, he advanced the throttle for a power adjustment, but the eng did not respond. Subsequently, the…Apr 24, 1985 · N7846X · Substantial damage NTSB MIA81FA073Accident · 1 fatalClosedCessna 182 · La Belle, FLMay 14, 1981 · N7407X · Destroyed NTSB MIA81FKJ06Accident · No injuriesClosedCessna 172 · Defuniak Spgs, FLApr 10, 1981 · N8127X · Substantial damage NTSB MIA80FA095Accident · 2 fatalClosedCessna 172 · Wabasso, FLAug 28, 1980 · N3885L · Destroyed NTSB MIA79FLD42Accident · 1 fatalClosedCessna 172B · Orlando, FLFeb 25, 1979 · N7850X · No damage NTSB MIA73FLA38Accident · No injuriesClosedCessna 172 · Defuniak Spng, FLMay 21, 1973 · N7609X · Substantial damage NTSB MIA72DKT81Accident · Minor injuriesClosedCessna 172B · Opa Locka, FLJun 9, 1972 · N8112X · Substantial damage NTSB MIA70FKT05Accident · No injuriesClosedCessna 172B · Loxahatchee, FLFeb 5, 1970 · N8164X · Destroyed NTSB MIA69F0369Accident · No injuriesClosedCessna 172B · Melbourne, FLFeb 4, 1969 · N8165X · Substantial damage NTSB MIA69D0079Accident · No injuriesClosedCessna 172 · Jupiter, FLJul 13, 1968 · N7443X · Substantial damage NTSB MIA68D0545Accident · No injuriesClosedCessna 172 · Naples, FLMay 15, 1968 · N7718X · Destroyed NTSB MIA67D0416Accident · Minor injuriesClosedCessna 172B · Clewiston, FLMar 3, 1967 · N7528X · Substantial damage NTSB MIA66D0558Accident · No injuriesClosedCessna 172B · Davie, FLMay 23, 1966 · N7776X · Substantial damage NTSB MIA66A0030Accident · 1 fatalClosedCessna 172B · Englewood, FLSep 12, 1965 · N7652X · Destroyed NTSB UNK65X1414Accident · No injuriesClosedCessna 172 · Williston, FLFeb 11, 1965 · N7489X · Substantial damage NTSB UNK64X1538Accident · No injuriesClosedCessna 172 · Belle Glade, FLApr 30, 1964 · N7446X · Substantial damage