NTSB investigations: Cessna 182H, UT
9 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 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1977 | 1 |
| 1984 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 2011 | 1 |
| 2021 | 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\" = 'UT' 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" = 'UT' 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 WPR21FA321Accident · 3 fatalClass 3 · FieldFinal reportCessna 182H · Bountiful, UTThe decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…NTSB WPR11LA452Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Paragonah, UTThe pilot's failure to secure the left tank's fuel cap after refueling the airplane, which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA93LA201Accident · No injuriesLimited investigationFinal reportCessna 182H · Salt Lake City, UTThe pilot's improper flare. Inadequate recovery from a bounced landing was factor.NTSB SEA91FA120Accident · 1 fatalField investigationFinal reportCessna 182H · Thompson, UTThe pilot's misjudged descent. Contributing to the accident was the dark night conditions.NTSB DEN85FA035Accident · 2 fatalField investigationFinal reportCessna 182H · Provo, UTThe left seat non-instrument pvt plt was being checked out in the flying club acft by a comm plt. The acft was being flown over Utah lake on a dark night, on final approach to runway 31 at the pvu arpt. While on final, the flying plt manuevered the acft for…NTSB DEN77FA035Accident · 2 fatalClosedCessna 182H · Tooele, UTNTSB DEN70FXT01Accident · No injuriesClosedCessna 182 · Spanish Fork, UTNTSB DEN68D0203Accident · No injuriesClosedCessna 182 · Logan, UTNTSB DEN66F0342Accident · No injuriesClosedCessna 182 · Salt Lake City, UT