Skip to content

NTSB investigations: Cessna 172, FL

38 cases on aircraft the registry lists as Cessna 172. 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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 ERA22FA218Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Altha, FLThe pilot’s failure to perform a preflight weight and balance calculation and his operation of the flight at an excessive takeoff weight, resulting in an exceedance of the airplane’s critical angle of attack after liftoff and an aerodynamic stall from which…May 3, 2022 · N6413B · Destroyed NTSB ERA18LA257Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Winter Haven, FLThe student pilot’s improper pitch attitude control during the initial climb, which resulted in a loss of airspeed, and his subsequent decision to conduct a 180° turn following the perceived anomaly, which resulted in a runway overrun.Sep 24, 2018 · N6950A · Substantial damage NTSB ERA15CA327Accident · No injuriesData collectionFinal reportCessna 172 · Riviera Beach, FLThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to icing, which resulted in a total loss of power.Aug 22, 2015 · N8952B · Substantial damage NTSB ERA11LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Hobe Sound, FLA partial loss of engine power due to fuel contamination in the carburetor.Nov 16, 2010 · N8306B · Substantial damage NTSB MIA98LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Valkaria, FLthe pilot's inadequate preflight, and subsequent loss of engine power, due to fuel exhaustion, which resulted in a forced landing and impact with trees.Jan 31, 1998 · N6261E · Substantial damage NTSB MIA98LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Crystal River, FLThe certified flight instructors improper supervision of the rated pilot during a crosswind landing resulting in an in-flight collision with the left wing of the airplane and the runway, subsequent loss of directional control on landing rollout, and collision…Nov 3, 1997 · N4105F · Substantial damage NTSB MIA96LA192Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Okeechobee, FLfailure of the pilot to maintain control of the airplane during a high speed taxi check, which resulted in a lift-off and subsequent collision with the terrain.Jul 19, 1996 · N62224 · Substantial damage NTSB MIA89LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Okeechobee, FLThe student pilot reported that during preflight inspection, he did not replace the oil cap after he checked the oil. Subsequently, oil was vented overboard during flight & the engine lost power. The nose gear collapsed during a forced landing.Nov 20, 1988 · N8262B · Substantial damage NTSB MIA88LA270Accident · No injuriesLimited investigationFinal reportCessna 172 · Panacea, FLThe pilot stated that while attempting a go-around he inadvertently selected all flaps up and the aircraft crashed into the trees at the end of the runway.Sep 21, 1988 · N7048A · Destroyed NTSB MIA88LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tampa, FLAfter preflighting the acft, 30.8 gal of fuel were added. No further insp was performed. The flt took off after an eng runup was accomplished. No problems were noted. During the initial climb of the first touch-and-go landing, at an alt of aprx 75 ft, the eng…Jan 3, 1988 · N40AZ · Substantial damage NTSB MIA88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Titusville, FLAfter a go-around, at aprx 300 ft, the eng lost power. The plt attempted to return to the arpt, but was unable. The acft descended, collided with trees, bounced off the roof of a house & came to rest against a vehicle in the driveway. Inspection of the…Oct 24, 1987 · N4207F · Substantial damage NTSB MIA85LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Miles City, FLThe acft collided with heavy brush and the ground during a takeoff from a wet sod rwy. The plt reported that the rwy hadbeen furrowed by wild hogs and he and his 13 year old son had tried to repair the damage prior to takeoff. A takeoff wasattempted using…Oct 13, 1984 · N8336B · Substantial damage NTSB MIA80DLE02Accident · No injuriesClosedCessna 172 · Anclote Key, FLSep 14, 1980 · N5991A · Substantial damage NTSB MIA78DKJ60Accident · No injuriesClosedCessna 172 · Milton, FLJul 13, 1978 · N7370A · Substantial damage NTSB MIA78FA062Accident · 2 fatalClosedCessna 172 · Miles City, FLApr 7, 1978 · N6886A · Destroyed NTSB MIA78FLD13Accident · Minor injuriesClosedCessna 172 · Rockledge, FLNov 19, 1977 · N8647B · Substantial damage NTSB MIA76DLD10Accident · No injuriesClosedCessna 172 · Bushnell, FLAug 12, 1975 · N9119B · Substantial damage NTSB MIA73FKU10Accident · Minor injuriesClosedCessna 172 · Boca Raton, FLJun 29, 1973 · N5141A · Substantial damage NTSB MIA73AM003Accident · Serious injuriesClosedCessna 150 · Jacksonville, FLJul 1, 1972 · N1541Q · 2 aircraft · Destroyed NTSB MIA72AM125Accident · 2 fatalClosedCessna 172 · Mayo, FLMay 15, 1972 · N6708A · Destroyed NTSB MIA72FLD26Accident · No injuriesClosedCessna 172 · Tampa, FLNov 25, 1971 · N6485B · Substantial damage NTSB MIA71FLD55Accident · Minor injuriesClosedCessna 172 · Lakeland, FLMar 27, 1971 · N8313B · Substantial damage NTSB MIA69F0216Accident · Serious injuriesClosedCessna 172 · Sebring, FLAug 20, 1968 · N4002F · Substantial damage NTSB MIA68F0354Accident · No injuriesClosedCessna 172 · High Springs, FLJan 2, 1968 · N5064A · Substantial damage NTSB MIA68D0358Accident · Minor injuriesClosedCessna 172 · Dunedin, FLDec 19, 1967 · N8074L · Destroyed NTSB MIA68F0332Accident · No injuriesClosedCessna 172 · Jacksonville, FLOct 14, 1967 · N6909A · Substantial damage NTSB MIA67D0175Accident · No injuriesClosedCessna 172 · Sun City, FLSep 1, 1966 · N7965B · Substantial damage NTSB MIA67A0024Accident · 3 fatalClosedCessna 172 · Flamingo, FLAug 12, 1966 · N6484E · Destroyed NTSB MIA67D0225Accident · No injuriesClosedCessna 172 · High Springs, FLAug 2, 1966 · N6102E · Substantial damage NTSB MIA67F0158Accident · Serious injuriesClosedCessna 172 · Palatka, FLJun 4, 1966 · N4139F · Substantial damage NTSB MIA66F0245Accident · No injuriesClosedCessna 172 · Clearwater, FLSep 4, 1965 · N4105F · Substantial damage NTSB MIA66F0097Accident · Minor injuriesClosedCessna 172 · Vero Beach, FLJun 28, 1965 · N6232E · Substantial damage NTSB MIA65F0122Accident · Minor injuriesClosedCessna 172 · Tampa, FLMay 26, 1965 · N7392A · Substantial damage NTSB MIA65A0111Accident · 1 fatalClosedCessna 172 · St Cloud, FLMay 3, 1965 · N8880U · Destroyed NTSB UNK65X1456Accident · No injuriesClosedCessna 172 · Daytona Beach, FLFeb 25, 1965 · N8397B · Substantial damage NTSB UNK64X3227Accident · No injuriesClosedCessna 172 · Ft Pierce, FLAug 5, 1964 · N6146E · Substantial damage NTSB UNK64X1879Accident · No injuriesClosedCessna 172 · Alachua, FLMay 22, 1964 · N4245F · Substantial damage NTSB UNK64X0909Accident · No injuriesClosedCessna 172 · St Petersburg, FLMar 14, 1964 · N6102E · Substantial damage