Skip to content

NTSB investigations: Cessna 172L, FL

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

19712026

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 ('2072432')) 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 ('2072432'))
  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 ('2072432'))
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 ANC26LA088Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172L · Micanopy, FLOn August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code…Aug 18, 2026 · N3866Q · Substantial damage NTSB ERA25LA302Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172 · Titusville, FLOn August 15, 2025, about 1415 eastern daylight time, a Cessna 172, N7205Q, was substantially damaged when it was involved in an accident near Titusville, Florida. The pilot was seriously injured and the flight instructor received minor injuries. The airplane…Aug 15, 2025 · N7205Q · Substantial damage NTSB ERA24LA384Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · DeLand, FLThe parachutist’s failure to control his canopy which resulted in a downwind landing, an overshoot of the drop zone, and collision with a departing airplane.Sep 17, 2024 · N19703 · Substantial damage NTSB MIA08FA038Accident · 3 fatalField investigationFinal reportCessna 172L · Clearwater, FLThe pilot's failure to maintain airspeed while maneuvering for approach to land. Contributing to the accident was the pilot's operation of the airplane above the design gross weight.Jan 12, 2008 · N7100Q · Substantial damage NTSB MIA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172L · Fort Lauderdale, FLThe total failure of the yoke weld assembly due to corrosion resulting in the inability of the flight crew to maintain elevator control of the airplane. Additionally, inadequate annual inspection of the airplane by other maintenance personnel for failure to…Mar 3, 2001 · N3802Q · Substantial damage NTSB MIA99FA050Accident · 2 fatalField investigationFinal reportCessna 172L · Macclenny, FLThe student pilot's attempted VFR flight into instrument meteorological conditions, resulting in a subsequent in-flight collision with trees and terrain. Contributing factors were, haze/smoke, the student pilot's failure to obtain a preflight weather…Jun 23, 1998 · N3853Q · Destroyed NTSB MIA93LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Okeechobee, FLThe pilot-in-command's improper flare.Nov 14, 1992 · N9854G · Substantial damage NTSB MIA82DA061Accident · No injuriesFinal reportCessna 172L · Lake City, FLWhile enroute, the pilot encountered an area with restricted visibility and with an estimated ceiling of 300 ft. after reversing course, he saw a forest road and elected to land. He reported that during the landing roll, a gust of wind was encountered causing…Feb 28, 1982 · N1026M · Substantial damage NTSB MIA78FKT18Accident · Serious injuriesClosedCessna 172 · Lantana, FLDec 4, 1977 · N3966Q · Destroyed NTSB MIA77FA088Accident · 4 fatalClosedCessna 172 · Lauderhill, FLSep 16, 1977 · N7645G · Destroyed NTSB MIA76DKT80Accident · No injuriesClosedCessna 172 · Deerfld Beach, FLMay 31, 1976 · N7941G · Substantial damage NTSB MIA76DLD57Accident · Serious injuriesClosedCessna 172 · Plymouth, FLMay 22, 1976 · N7682G · Substantial damage NTSB MIA76AM041Accident · 1 fatalClosedCessna 172L · Key West, FLNov 8, 1975 · N3913Q · Destroyed NTSB MIA76FLD09Accident · Minor injuriesClosedCessna 172 · Nw Prt Richey, FLAug 9, 1975 · N4303Q · Substantial damage NTSB MIA75DKT82Accident · No injuriesClosedCessna 172L · Sanibel Island, FLMay 24, 1975 · N7002Q · Substantial damage NTSB MIA75AM079Accident · 1 fatalClosedCessna 172L · Marathon, FLMay 10, 1975 · N7059Q · Destroyed NTSB MIA75DKT35Accident · No injuriesClosedCessna 172L · Hollywood, FLDec 22, 1974 · N4393Q · Substantial damage NTSB MIA74DLD22Accident · No injuriesClosedCessna 172 · Arcadia, FLAug 24, 1973 · N3911Q · Substantial damage NTSB MIA73AM111Accident · 1 fatalClosedCessna 172L · Newberry, FLJun 17, 1973 · N9842G · Destroyed NTSB MIA73FLA37Accident · Serious injuriesClosedCessna 172L · St Augustine, FLMay 13, 1973 · N9879G · Destroyed NTSB MIA73DKT42Accident · No injuriesClosedCessna 172 · Evergldes Cty, FLDec 26, 1972 · N7900G · Substantial damage NTSB MIA73DLA18Accident · No injuriesClosedCessna 172 · Jacksonville, FLOct 10, 1972 · N4348Q · Substantial damage NTSB MIA73AM039Accident · 1 fatalClosedCessna 172L · Deerfield Bch, FLOct 5, 1972 · N9890G · Destroyed NTSB MIA72FLD14Accident · Serious injuriesClosedCessna 172L · Orlando, FLOct 3, 1971 · N7766G · Substantial damage