Skip to content

NTSB investigations: Cessna 182A, UT

17 cases on aircraft the registry lists as Cessna 182A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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 ('2072704')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072704'))
  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 ('2072704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR20LA099Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Moab, UTThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and the airplane’s subsequent noseover.Mar 5, 2020 · N4031D · Substantial damage NTSB WPR15LA185Accident · No injuriesLimited investigationFinal reportCessna 182A · Moab, UTThe pilot’s inadequate preflight fuel planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jun 14, 2015 · N5143D · Substantial damage NTSB DEN01LA072Accident · No injuriesLimited investigationFinal reportCessna 182A · Richfield, UTloss of engine power during cruise as a result of fuel exhaustion due to the pilots failure to refuel. Contributing factors were the pilots inadequate aircraft preflight and the unsuitable terrain for a forced landing.Mar 19, 2001 · N4918D · Substantial damage NTSB DEN99LA110Accident · No injuriesLimited investigationFinal reportCessna 182A · Salt Lake City, UTA total loss of engine power (nonmechanical) for reasons undetermined. Factors were the existence of conditions conducive to carburetor icing, and unsuitable terrain on which to make a forced landing.Jul 1, 1999 · N6165B · Substantial damage NTSB SEA94LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Hanksville, UTThe excess airspeed maintained by the pilot on final approach, and his failure to attain the proper touchdown point. Factors include loose gravel, and a berm off the end of the intended landing strip.Apr 18, 1994 · N5045D · Substantial damage NTSB SEA90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Ogden, UTThe failure of the pilot to correct the position of the fuel tank selector, causing erratic engine operation and loss of power.Sep 9, 1990 · N5146D · Substantial damage NTSB DEN83FA133Accident · 1 fatalField investigationFinal reportCessna 182A · Orderville, UTThe acft crashed in mountainous terrain on a x-country in bad weather. The plt had received a weather briefing which hadincluded the caution that VFR flt was not recommended. Also the acft had no radio so the plt told the briefer to assume him off at 1330…Nov 8, 1982 · N5149D · Destroyed NTSB DEN80DTM12Accident · No injuriesClosedCessna 182 · Cedar City, UTApr 11, 1980 · N3916D · Substantial damage NTSB DEN72FTM16Accident · Minor injuriesClosedCessna 182A · Logan, UTMay 11, 1972 · N6095B · Substantial damage NTSB DEN69F0132Accident · No injuriesClosedCessna 182A · Cedar City, UTOct 16, 1968 · N4968D · Substantial damage NTSB DEN68F0123Accident · Serious injuriesClosedCessna 182 · Roosevelt, UTOct 7, 1967 · N3978D · Substantial damage NTSB DEN68D0105Accident · No injuriesClosedCessna 182 · Emery, UTSep 3, 1967 · N5847B · Substantial damage NTSB DEN67D0077Accident · No injuriesClosedCessna 182 · Green River, UTAug 16, 1966 · N4918D · Substantial damage NTSB DEN66F0044Accident · No injuriesClosedCessna 182 · Sandy, UTJul 10, 1966 · N4968D · Substantial damage NTSB DEN67D0014Accident · Minor injuriesClosedCessna 182A · Dutch John, UTJun 10, 1966 · N5109D · Destroyed NTSB DEN67F0003Accident · Minor injuriesClosedCessna 182 · Salt Lake City, UTJun 2, 1966 · N5185D · Substantial damage NTSB DEN66F0277Accident · No injuriesClosedCessna 182A · Salt Lake City, UTApr 5, 1966 · N2120G · Substantial damage