NTSB investigations: Cessna 182C, FL
9 cases on aircraft the registry lists as Cessna 182C. 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1984 | 1 |
| 1987 | 2 |
| 1991 | 1 |
| 1998 | 1 |
| 2024 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072708'))
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 ('2072708'))
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 ERA24LA315Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Zephyrhills, FLThe loss of engine power due to the formation of carburetor ice as a result of the pilot’s delayed application of carburetor heat.NTSB MIA99LA035Accident · No injuriesLimited investigationFinal reportCessna 182C · St. Petersburg, FLthe pilot misjudged the flare, resulting in a hard land and subsequent damage to the airplane.NTSB MIA91LA179Accident · No injuriesLimited investigationFinal reportCessna 182C · Keystone Hghts, FLTotal loss of engine power due to fuel exhaustion due to fuel siphoning overboard, and failure of the pilot to perform an adequate preflight inspection to insure the fuel caps were secured. Contributing to the accident was incorrect fuel tank quantity gauges…NTSB MIA87LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Opa Locka, FLThe plt stated that he was on a long final apch for Opa Locka airport & he lost all power. During a forced landing in an open field he struck a pile of logs, collapsing the nose gear. Post crash run of the eng revealed no evidence that would suggest a failure…NTSB MIA87LA112Accident · No injuriesLimited investigationFinal reportCessna 182C · Branford, FLThe plt was unable to locate his postion, & with wx conditions deteriorating & darkness approaching, elected to land in a field. Upon touchdown, the nose gear broke off, the acft nosed over & came to rest inverted.NTSB MIA84FA176Accident · Serious injuriesField investigationFinal reportCessna 182C · Cedar Key, FLThe plt rotated the acft at 45 mph & lifted off at aprx 6O mph. The acft climbed to about tree top level, then it mushed as it drifted to the left. The left wing hit a tree & the acft cartwheeled & crashed. The plt said he did not compute a weight & balance…NTSB MIA69D0240Accident · Serious injuriesClosedCessna 182 · Bonifay, FLNTSB MIA66F0559Accident · No injuriesClosedCessna 182C · Leesburg, FLNTSB UNK64X0660Accident · Minor injuriesClosedCessna 182 · Clearwater, FL