NTSB investigations: Cessna R182
15 cases on aircraft the registry lists as Cessna R182, 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 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 2000 | 1 |
| 2002 | 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 ('2072734')
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 ('2072734')
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 ATL03FA010Accident · 3 fatalField investigationFinal reportCessna R182 · Greensboro, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. Factors were low ceilings and fog.NTSB FTW00LA141Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Monument Valley, UTThe pilot's inadequate compensation for wind conditions and his delayed go-around, which resulted in the loss of aircraft control. A factor was the turbulent weather conditions.NTSB LAX91LA245Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Williams, AZThat the flight encountered windshear and that aircraft control was not possible.NTSB ATL90FA118Accident · 1 fatalField investigationFinal reportCessna 182RG · Highland, NCThe pilot's attempted VFR flight in IMC. Factors in the accident are the pilot's inaccurate weather evaluation and poor in flight decision.NTSB LAX90FA027Accident · 2 fatalField investigationFinal reportCessna R182 · San Diego, CAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors in the acident were: darkness, adverse weather conditions, and the pilot's lack of…NTSB DEN89LA150Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Telluride, COInadequate compensation for wind conditions by the pilot and his failure to maintain runway alignment. Contributing factors were wind conditions, high density altitude, and trees.NTSB NYC88FA235Accident · 3 fatalField investigationFinal reportCessna 182RG · Greenville, METhe non-instrument rated pilot apparently could not locate the destination airport because of low ceilings and ground fog. Before the pilot started his trip he was advised by the fss that VFR flight to his destination was not recommended. It appears that the…NTSB BFO85FA071Accident · 2 fatalField investigationFinal reportCessna R182 · Browntown, VADrg a wx briefing, flt prctns for ocnl mtn obscn & IMC were relayed to the plt, but he was not provided a forecast for thunderstorms, nor advised VFR flt was not rcmdd. The route of flt was portrayed as marginal VFR, as was the destn at morgantown (mgm).…NTSB NYC85FA110Accident · 2 fatalField investigationFinal reportCessna R182 · Hamilton Twnshp, NJThe plt's original destn was bader field at atlantic city. However, during arrival, he diverted to the atlantic city arpt, since bader field was below mins. Vectors were provided for an ILS rwy 13 apch & the plt was cleared for the apch. He was then cleared…NTSB ATL85FA077Accident · 4 fatalField investigationFinal reportCessna R182 · Crossville, TNThe acft collided with wooded, rising terrain at an elevation of about 2800 ft MSL on the west slope of hinch mountain. A passenger, who survived the crash, but died later due to burns, reported that light conditions were dark & she could not see anything…NTSB SEA85FA001Accident · 3 fatalField investigationFinal reportCessna R182 · Austin, NVDeteriorating wx was encountered as the plt followed a highway to his dest on an easterly heading. On scene evidence indicated that the acft impacted left wing tip first on a northerly heading near the east end of a box canyon. The impact flight path angle…NTSB MKC84FA271Accident · Serious injuriesField investigationFinal reportCessna R182 · Ottumwa, IAThe acft entered IMC weather, the plt became disoriented & cruised without ATC navigational assistance after failing to make radio contact or file a flt plan. The non-instrument rated private plt flew until acft power was lost due to fuel exhaustion. The…NTSB ATL84LA074Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Pennington Gap, VAEnroute at 7,000 ft MSL the acft started picking up heavy ice. The plt make a 180 deg turn & descended to 6,000 ft. he was able to see the ground through breaks in the clouds. Upon sighting lee county arpt the plt elected to make a precautionary landing.…NTSB MKC83FA044Accident · 1 fatalField investigationFinal reportCessna R182 · 1 1/2 Mi.N. May, KSThe pilot received wx briefings at 1114 & 1220. He was advised against VFR flt due to low ceilings & visibilities in western Missouri, eastern & northeastern Kansas. At 1300 the plt received a special VFR clearance to depart. At 1330 witnesses observed the…NTSB CHI83FA022Accident · 1 fatalField investigationFinal reportCessna R182 · Lemont, ILThe pilot took off at 0642 CDT, and at 0645, he reported level at 4000 ft MSL. At 0659:08, he preported that he was encountering icing conditions and requested a climb to 6000 ft. at 0700:16, after changing from TRACON to center frequency, he was cleared as…