NTSB investigations: Cessna 182P, OH
12 cases on aircraft the registry lists as Cessna 182P. 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
| 1974 | 2 |
|---|---|
| 1978 | 1 |
| 1980 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1999 | 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\" = 'OH' 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 ('2075816'))
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" = 'OH' 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 ('2075816'))
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 NYC00LA056Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Port Clinton, OHLoss of engine power caused by ice crystal blockage of the fuel system.NTSB NYC92FA049Accident · 1 fatalField investigationFinal reportCessna 182P · Hanging Rock, OHThe pilot's improper use of carburetor heat, which resulted in the formation of carburetor ice and a loss of engine power and subsequent forced landing in trees.NTSB NYC91LA023Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Elyria, OHThe loss of engine power for an undetermined reason(s).NTSB ATL89LA073Accident · No injuriesLimited investigationFinal reportCessna 182P · Hamilton, OHThe pilot's improper use of the carburetor heat control which resulted in a loss of engine power. Contributing to the accident were conditions conducive to carburetor ice.NTSB ATL88LA100Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Norwalk, OHThe plt rptd that he was cruising at 9,000 ft when he observed the EGT gauge indication dropping. The engine began to run rough and he noticed a fuel odor in the cabin. The carb air temp gauge was indicating 'well out of' the icing range. He selected carb…NTSB ATL86FA077Accident · 1 fatalField investigationFinal reportCessna 182P · Elyria, OHThe plt was cleared for and executed a rwy 17 ILS apch at night. Prior to beginning the apch he was informed that vis was 1/8 mile. Minimum for the apch was 1/2 mile. At the middle marker the plt rated pax in the right seat told the PIC that the rwy was not…NTSB CHI85LA108Accident · No injuriesLimited investigationFinal reportCessna 182P · Hamilton, OHThe acft nosed over in snow during lndg, the FAA inspector at the scene the following day found the acft off the left side of the rwy in the snow. The acft tracks indicated that the lndg was made too FAR to the left which allowed the left lndg gear to enter…NTSB CHI84LA168Accident · No injuriesLimited investigationFinal reportCessna 182P · Cinncinati, OHThe acft made a forced landing after a total power loss. On the landing flare the right main gear caught the edge of a sand trap & sheared off. Approximately 8 ounces of water were drained from the sumps & carburetor. The engine was subsequently started & ran…NTSB CHI81FEI08Accident · No injuriesClosedCessna 182 · Ravenna, OHNTSB CHI78FEK22Accident · No injuriesClosedCessna 182 · Columbus, OHNTSB CHI74DEI37Accident · No injuriesClosedCessna 182P · Fremont, OHNTSB CHI74FE134Accident · Minor injuriesClosedCessna 182 · Vickery, OH