NTSB investigations: Cessna 182Q
20 cases on aircraft the registry lists as Cessna 182Q, where the first occurrence was “In flight encounter with weather”. 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
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 3 |
| 1987 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072732')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072732')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DEN07CA162Accident · Minor injuriesData collectionFinal reportCessna 182Q · Glenwood Spring, COThe pilot's failure to go around when it became apparent that he could not land and stop the airplane on the remaining runway. Factors contributing to the accident were the tailwind and the gusts.NTSB DEN05LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Grand Junction, COthe pilot's failure to maintain aircraft control during aborted landing and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the encounter with wind shear during final approach and landing.NTSB LAX05FA023Accident · 4 fatalField investigationFinal reportCessna 182Q · Lebec, CAthe pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.NTSB CHI04FA284Accident · 1 fatalField investigationFinal reportCessna 182Q · Morris, MNThe pilot's inadequate weather evaluation that resulted flight into night instrument meteorological conditions and a subsequent loss of aircraft control. Factors to the accident were the pilot's lack of recent night experience and the low cloud ceiling at…NTSB CHI04FA071Accident · 1 fatalField investigationFinal reportCessna 182Q · Rozel, KSThe inadvertent flight into instrument meteorological conditions, the spatial disorientation, and aircraft control not maintained by the pilot during cruise flight. Contributing to the accident were the night instrument meteorological conditions due to low…NTSB CHI03FA141Accident · 1 fatalField investigationFinal reportCessna 182Q · Gettysburg, SDThe pilot not maintaining aircraft control in cruise flight leading to his inadvertent spiral. A factor was the pilot's in-flight encounter with moderate to heavy rain.NTSB FTW97FA039Accident · 1 fatalField investigationFinal reportCessna 182Q · Colorado City, TXthe pilot's encounter with instrument meteorological conditions (IMC), and his subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the clouds, low ceilings, and the pilot's lack of recent instrument…NTSB FTW95FA261Accident · 2 fatalField investigationFinal reportCessna 182Q · San Angelo, TXThe pilot's decision to attempt flight into known adverse weather conditions, and his loss of aircraft control due to spatial disorientation. Factors relating to the accident were: conditions of darkness, thunderstorm and lightning, and the pilot's lack…NTSB SEA91FA258Accident · 2 fatalField investigationFinal reportCessna 182Q · Lincoln, MTThe improper inflight planning/decision by the pilot to continue VFR flight into IMC conditions. Factors relating to the accident were the mountainous terrain in the area, and the low ceilings and clouds obscuring the mountains.NTSB ATL89LA217Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mt Pleasant, SCFailure of the pilot to slow the aircraft to the proper landing speed at the proper touchdown point or go around. The weather conditions, tailwind, lack of airport facilities (UNICOM not operating and windsock damaged), wet runway/hydroplaning conditions, and…NTSB FTW89LA061Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Robstown, TXThe pilot delayed flight to an alternate destination, continued flight into instrument meteorological conditions (IMC), experienced spatial disorientation, and lost control of the aircraft. Contributing factors were: the pilot's inadequate preflight…NTSB LAX87LA152Accident · No injuriesLimited investigationFinal reportCessna 182Q · Palm Springs, CADuring a pleasure cross country flt, the aircraft encountered approximately 50 knot headwinds. The plt had diverted once to refuel and had expected to fly direct to the final destination. However, while enroute on the final leg of the flight, the aircraft was…NTSB ATL86FA025Accident · 2 fatalField investigationFinal reportCessna 182Q · Edenton, NCThe aircraft crashed into the abermarle sound and sank in 18 ft of water. The pilot was reportedly on an NDB approach and descended below mda. Witnesses stated that the aircraft circled over head about 15 minutes prior to the accident. Witnesses also stated…NTSB FTW85LA098Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Abilene, TXDeteriorating wx was encountered & the plt elected to land short of the original destn. He was provided vectors for an ILS apch to rwy 35R at abiline, TX. During the night apch, he encountered strong gusty winds, severe turbulence & restricted visibility. The…NTSB DEN85LA064Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Wapiti, WYAccording to the pilot as she was flying her aircraft in a canyon she encountered downdrafts which pushed her aircraft down. She was unable to maintain her airspeed or altitude and elected to put the aircraft into the trees.NTSB ATL84FA141Accident · 2 fatalField investigationFinal reportCessna 182Q · Nw.Of Abingdon, VAThe acft crashed into a mountain at the 4000 ft level about 100 ft below the crest en route to chattanooga, TN. The plt had received a pre-flt telephonic briefing that was considered current and appropriate for the flt without any special remarks. At…NTSB LAX84FA152Accident · 1 fatalField investigationFinal reportCessna 182Q · Soledad, CAThe acft crashed into the side of a hill at about 1500 ft MSL in a 50 degree nose down attitude. The plt had encounteredweather on a night VFR flt. He was attempted to return the acft for a scheduled club flt the next morning. He had previously planned an…NTSB FTW84FA032Accident · 1 fatalField investigationFinal reportCessna 182Q · Columbus, NMThe non-instrument rated plt departed imperial, CA, at 2010 PDT, & shortly thereafter, was identified & followed by a U.S. Customs special mission acft. The acft was followed to demming, NM. During that portion of the flt, its altitude varied from about 500…NTSB SEA83FA113Accident · 2 fatalField investigationFinal reportCessna 182Q · Mccall, IDThe acft impacted a rocky slope of a box canyon at the 6300 foot level. The weather was reported to be IMC with thunderstorms, overcast skies and the mountain tops obscured. The wreckage location was on a direct line between departure point and destination.…NTSB LAX82FA236Accident · 3 fatalField investigationFinal reportCessna 182 · Trinity Center, CAThe plt contacted the redding, CA tower & stated he was on top & 41 mi from the redding VOR. He then reported he was going into the clouds & requested radar service. He then contacted oakland ARTCC who provided assistance until the plt stated he had found a…