NTSB investigations: Cessna 182H, FL
11 cases on aircraft the registry lists as Cessna 182H. 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
| 1966 | 1 |
|---|---|
| 1967 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1992 | 1 |
| 2004 | 1 |
| 2005 | 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 ('2072718'))
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 ('2072718'))
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 MIA06CA034Accident · No injuriesData collectionFinal reportCessna 182 · Haines City, FLThe pilot's improper preflight planning/preparation, and operation of equipment with known deficiencies, a right wing fuel cap leak, which resulted in fuel exhaustion and the loss of engine power.NTSB MIA04CA095Accident · No injuriesData collectionFinal reportCessna 182H · La Belle, FLThe inadvertent deployment of the main parachute resulting in damage to the right horizontal stabilizer and elevator.NTSB MIA93LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Englewood, FLInadequate preflight of the airplane by the pilot in command which resulted in the total loss of engine power shortly after takeoff due to fuel contamination.NTSB MIA83FA081Accident · 2 fatalField investigationFinal reportCessna 182H · Chuluota, FLThe acft crashed from 200 ft AGL on takeoff. Witnesses said the engine quit and the acft made a steep left turn and then dove straight to the ground. The acft had almost made a 180 degree turn to line up with state road 419 when it crashed. This road…NTSB MIA82DA071Accident · No injuriesFinal reportCessna 182H · New Port Richey, FLThe pilot stated that moments after takeoff power was applied the seat retaining pins broke, the pilot's seat moved aft breaking the rear retainer leaving him unable to reach the control yoke. The aircraft swerved off the runway and collided with trees. The…NTSB MIA81FA033Accident · 3 fatalClosedCessna 182H · Gainesville, FLNTSB MIA74DLD38Accident · No injuriesClosedCessna 182 · Daytona, FLNTSB MIA72FKT40Accident · Minor injuriesClosedCessna 182H · West Palm Bch, FLNTSB MIA67F0484Accident · No injuriesClosedCessna 182 · Cross City, FLNTSB MIA67F0431Accident · No injuriesClosedCessna 182H · Daytona Beach, FLNTSB MIA67A0057Accident · 1 fatalClosedCessna 182 · Tarpon Spring, FL