Final NTSB investigations: Cessna 172L, FL
22 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.
Cases per year
| 1971 | 1 |
|---|---|
| 1972 | 3 |
| 1973 | 3 |
| 1974 | 1 |
| 1975 | 4 |
| 1976 | 2 |
| 1977 | 2 |
| 1982 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2008 | 1 |
| 2024 | 1 |
Where
Latest cases
Query with SQL
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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed'
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" DESCRun 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 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.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.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…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…NTSB MIA93LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Okeechobee, FLThe pilot-in-command's improper flare.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…NTSB MIA78FKT18Accident · Serious injuriesClosedCessna 172 · Lantana, FLNTSB MIA77FA088Accident · 4 fatalClosedCessna 172 · Lauderhill, FLNTSB MIA76DKT80Accident · No injuriesClosedCessna 172 · Deerfld Beach, FLNTSB MIA76DLD57Accident · Serious injuriesClosedCessna 172 · Plymouth, FLNTSB MIA76AM041Accident · 1 fatalClosedCessna 172L · Key West, FLNTSB MIA76FLD09Accident · Minor injuriesClosedCessna 172 · Nw Prt Richey, FLNTSB MIA75DKT82Accident · No injuriesClosedCessna 172L · Sanibel Island, FLNTSB MIA75AM079Accident · 1 fatalClosedCessna 172L · Marathon, FLNTSB MIA75DKT35Accident · No injuriesClosedCessna 172L · Hollywood, FLNTSB MIA74DLD22Accident · No injuriesClosedCessna 172 · Arcadia, FLNTSB MIA73AM111Accident · 1 fatalClosedCessna 172L · Newberry, FLNTSB MIA73FLA37Accident · Serious injuriesClosedCessna 172L · St Augustine, FLNTSB MIA73DKT42Accident · No injuriesClosedCessna 172 · Evergldes Cty, FLNTSB MIA73DLA18Accident · No injuriesClosedCessna 172 · Jacksonville, FLNTSB MIA73AM039Accident · 1 fatalClosedCessna 172L · Deerfield Bch, FLNTSB MIA72FLD14Accident · Serious injuriesClosedCessna 172L · Orlando, FL