NTSB investigations: Cessna 182G, CO

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

NTSB investigations: Cessna 182G, CO per year, 1966–2026: 14 cases
1966	3
1971	1
1972	2
1974	1
1979	1
1986	1
1988	1
2012	1
2015	1
2018	1
2023	1

Where

Open the map

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 ('2072716')) 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 ('2072716'))
  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 ('2072716'))
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 CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.Jun 23, 2023 · N3289S · Destroyed NTSB CEN19LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Norwood, COThe partial loss of engine power for undetermined reasons.Dec 23, 2018 · N3120S · Substantial damage NTSB CEN15LA430Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Glenwood Springs, COA loss of engine power during cruise flight due to carburetor icing and the pilot's failure to apply carburetor heat, which resulted in a forced landing on rough/uneven terrain.Sep 27, 2015 · N3147S · Substantial damage NTSB CEN12LA493Accident · No injuriesLimited investigationFinal reportCessna 182G · Montrose, COThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jul 30, 2012 · N3198S · Substantial damage NTSB DEN88LA047Accident · No injuriesLimited investigationFinal reportCessna 182G · Aurora, CON3406S was landing on rwy 32, an asphalt rwy 5,000 ft long and 40 ft wide. The rwy was clear and dry, but the terrain surrounding the rwy was covered by 12 to 15 inches of snow. The wind at an arpt 5 mi sw was from 160 deg at 5 KTS. In his rpt of the acdt the…Jan 10, 1988 · N3406S · Substantial damage NTSB DEN86FA249Accident · 1 fatalField investigationFinal reportCessna 182G · Brighton, COAt approximately 0415 hours when it was still night time, the non instrument rated private plt took off on an extended cross country flt to Kentucky. About 15 minutes later he was observed flying in a left turn, at an attitude of 50 to 75 feet in heavy fog…Sep 15, 1986 · N2030R · Destroyed NTSB DEN80FA011Accident · 2 fatalClosedCessna 182 · Longmont, CODec 3, 1979 · N3194S · Destroyed NTSB DEN75AD028Accident · 2 fatalClosedCessna 182G · Delta, CONov 10, 1974 · N3271S · Destroyed NTSB DEN73AD016Accident · 1 fatalClosedCessna 182 · Denver, COOct 20, 1972 · N2458R · Destroyed NTSB DEN73FTE19Accident · No injuriesClosedCessna 182G · Aurura, COAug 26, 1972 · N3779U · Substantial damage NTSB DEN71AD037Accident · Serious injuriesClosedCessna 182 · Clark, COMar 13, 1971 · N2121L · Substantial damage NTSB DEN67A0032Accident · 1 fatalClosedCessna 182 · Lamar, CONov 9, 1966 · N3247S · Destroyed NTSB DEN67D0040Accident · No injuriesClosedCessna 182 · Colorado Sprg, COJul 24, 1966 · N2450R · Substantial damage NTSB DEN66D0248Accident · No injuriesClosedCessna 182 · Pubeblo, COMar 8, 1966 · N3247S · Substantial damage