Skip to content

NTSB investigations: Cessna TR182, CO

14 cases on aircraft the registry lists as Cessna TR182. 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

19812026

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" = 'CO' 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 ('2072735')) 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\" = 'CO' 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 ('2072735'))
  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" = 'CO' 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 ('2072735'))
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 CEN25LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Englewood, COThe collapse of the right main landing gear during landing rollout.Oct 1, 2024 · N756JY · Substantial damage NTSB CEN12LA473Accident · No injuriesLimited investigationFinal reportCessna TR182 · Steamboat Springs, COThe pilot's failure to extend the landing gear before landing.Jul 24, 2012 · N73VX · Substantial damage NTSB DEN06LA070Accident · No injuriesLimited investigationFinal reportCessna T-R182RG · Englewood, COthe pilot inadvertently retracting the landing gear.Apr 22, 2006 · N6170S · Substantial damage NTSB DEN06LA059Accident · No injuriesLimited investigationFinal reportCessna TR182 · Fort Collins, COthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's improper preflight planning, the pilot's failure to refuel the airplane, and the lack of suitable terrain for the forced landing.Apr 11, 2006 · N729SC · Substantial damage NTSB DEN02LA054Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glenwood Sprngs, COthe pilot's failure to maintain clearance from a tree while conducting an aborted landing. Contributing factors were the pilot’s low approach airspeed, and his failure to maintain directional control during landing roll.Jun 14, 2002 · N333AJ · Substantial damage NTSB DEN02LA040Accident · No injuriesLimited investigationFinal reportCessna TR182 · Kersey, COThe pilot's inadequate planning decision which led to fuel exhaustion and subsequent loss of engine power.Apr 28, 2002 · N787PC · Substantial damage NTSB FTW97LA111Accident · No injuriesLimited investigationFinal reportCessna TR182 · Pueblo, COImproper repair to the nose landing gear assembly. A factor was binding of the nose gear extension assembly due to the improper repair.Mar 1, 1997 · N2396S · Substantial damage NTSB FTW96LA402Accident · No injuriesLimited investigationFinal reportCessna TR182 · Telluride, COfailure of the generator control unit (GCU), which resulted in a total electrical failure and failure of the main landing gear to lock in place.Aug 24, 1996 · N757QT · Substantial damage NTSB FTW96TA289Accident · Minor injuriesFinal reportCessna 182RG · Broomfield, COfailure of the pilot to maintain directional control and runway alignment during a go-around, and the lack of power response from the engine for undetermined reason(s). The sudden wind shift was a related factor.Jul 2, 1996 · N4314R · Substantial damage NTSB FTW96LA031Accident · Serious injuriesLimited investigationFinal reportCessna 182TR · Boulder, COThe pilot's failure to determine the amount of fuel aboard the aircraft during preflight, and his failure to refuel the aircraft.Oct 30, 1995 · N7590R · Substantial damage NTSB FTW95LA314Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Center, COImproper recovery from a bounced landing by the pilot-in-command. A factor was a premature landing flare.Jul 21, 1995 · N5153R · Substantial damage NTSB DEN89LA048Accident · No injuriesLimited investigationFinal reportCessna TR182 · Lamar, COThe pilot was making a VFR approach for landing. The landing gear was lowered and full flaps were deployed. The pilot said he allowed the airspeed to get too low and the aircraft stalled. The nose and left wing dropped and the pilot added full power. The nose…Dec 24, 1988 · N757MU · Destroyed NTSB DEN86FA208Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Boulder, COThe purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a…Jul 26, 1986 · N4346L · 2 aircraft · Destroyed NTSB DEN81FA063Accident · 3 fatalClosedCessna TR182 · 17nne Durango, COAug 31, 1981 · N736KV · Destroyed