NTSB investigations: Cessna 182E, FL
12 cases on aircraft the registry lists as Cessna 182E. 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 | 2 |
|---|---|
| 1965 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 2019 | 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 ('2072712'))
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 ('2072712'))
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 ERA19FA193Accident · 2 fatalField investigationFinal reportCessna 182 · Maitland, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB MIA89LA049Accident · No injuriesLimited investigationFinal reportCessna 182E · Ocala, FLShortly after rotation at an alt of aprx 20 ft AGL, the plt stated the control column would not move. He closed the throttle & the acft landed hard, bounced, then came to rest off the rwy. Examination of the acft revealed 3 of the 4 lower instrument panel…NTSB MIA87LA037Accident · No injuriesLimited investigationFinal reportCessna 182E · Chiefland, FLThe plt stated that he was on final apch & attempted to go around due to gusting winds. He applied power, the eng quit & he collided with the trees at the end of the rwy. No determination could be made as to the malfunction of the eng as described by the plt.NTSB MIA86LA162Accident · No injuriesLimited investigationFinal reportCessna 182E · Crystal River, FLThe plt stated that just before descent he pushed the propeller control full forward, experienced a runaway prop and lost oil pressure. Moments later a connecting rod failure was experienced and an emergency landing was executed in amarshy area northwest of…NTSB MIA85LA080Accident · No injuriesLimited investigationFinal reportCessna 182E · Ft Myers, FLThe plt reported that after he had started the eng, the acft began moving out of the tie-down position. When he applied brakes, the right brake failed. He attempted to stop by using the parking brake, but the parking brake handle broke off. Subsequently, the…NTSB MIA79FA101Accident · 2 fatalClosedCessna 182E · Clearwater, FLNTSB MIA76DKT39Accident · Minor injuriesClosedCessna 182E · Miami, FLNTSB MIA74DKT60Accident · No injuriesClosedCessna 182E · Pompano Beach, FLNTSB MIA74AM078Accident · Minor injuriesClosedCessna 188A · Clewiston, FLNTSB MIA66D0114Accident · No injuriesClosedCessna 182 · Belle Glade, FLNTSB UNK64X4017Accident · No injuriesClosedCessna 182E · Opa Locka, FLNTSB UNK64X2705Accident · 3 fatalClosedCessna 182 · Clewiston, FL