NTSB investigations: Cessna 182P, SC
15 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 | 1 |
|---|---|
| 1976 | 1 |
| 1978 | 4 |
| 1979 | 1 |
| 1989 | 1 |
| 1994 | 2 |
| 1998 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2023 | 1 |
| 2026 | 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\" = 'SC' 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" = 'SC' 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 ERA26LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mount Pleasant, SCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB ERA23LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · North Myrtle Beach, SCThe pilot’s failure to properly secure the left wing fuel cap, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA11LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Columbia, SCA total loss of engine power due to a loss of lubrication after the engine experienced a piston ring failure for undetermined reasons.NTSB ATL07FA031Accident · 3 fatalField investigationFinal reportCessna 182P · Columbia, SCThe pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.NTSB ATL99FA019Accident · 1 fatalField investigationFinal reportCessna 182P · Santee, SCThe pilot continued VFR flight into IMC conditions and lost control of the airplane due to spatial disorientation. Factors were foggy weather conditions and self-induced stress.NTSB ATL95LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greer, SCThe pilot's failure to follow instrument approach procedures and his premature descent below the published decision height. A factor was pilot fatigue.NTSB ATL94LA138Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greenville, SCThe pilot's improper positioning of the fuel selector valve which resulted in fuel starvation.NTSB ATL90FA022Accident · 1 fatalField investigationFinal reportCessna 182P · Darlington, SCThe pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.NTSB MIA79FA085Accident · 1 fatalClosedCessna 182P · Eastover, SCNTSB MIA79FA028Accident · 1 fatalClosedCessna 182 · Union, SCNTSB MIA79FLG01Accident · No injuriesClosedCessna 182P · Hilton Head, SCNTSB MIA78FLG29Accident · Minor injuriesClosedCessna 182P · Ehrhardt, SCNTSB MIA78DLG12Accident · No injuriesClosedCessna 182 · Pelzer, SCNTSB MIA76DLG36Accident · No injuriesClosedCessna 182 · Ridgeland, SCNTSB MIA74FLG30Accident · Serious injuriesClosedCessna 182P · Ridgeway, SC