NTSB investigations: Cessna 182M
9 cases on aircraft the registry lists as Cessna 182M, 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 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1993 | 1 |
| 2005 | 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 ('2072728')
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 ('2072728')
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 DEN05CA067Accident · No injuriesData collectionFinal reportCessna 182M · Cortez, COthe pilot's failure to maintain aircraft control during the landing flare. Contributing factors include the pilot's improper in-flight planning/decision making, the crosswind and the gusty surface winds.NTSB FTW93FA168Accident · 1 fatalField investigationFinal reportCessna 182M · Hebbronville, TXThe pilot's continued flight into IMC conditions. Factors were the low cieling and dark night conditions.NTSB DEN87LA163Accident · No injuriesLimited investigationFinal reportCessna 182M · Livingston, MTThe plt and an observer were conducting a search and rescue flt near the face of crazy mountain. The plt reported encountering a downdraft and the acft inadvertently stalled. The acft hit trees near the ridge line.NTSB LAX87LA180Accident · No injuriesLimited investigationFinal reportCessna 182M · Mammoth Lakes, CAAt the end of a pleasure cross country flt, while on long final to the rwy, the plt had to add pwr to compensate for a crosswind. Prior to reaching short final the plt had reduced pwr again. Upon reaching the threshold, the acft was aprx 300 ft AGL. The plt…NTSB CHI86LA224Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Quincy, ILAccording to the ATC report, N71650 indicated he would use the ILS rwy 04 and circle to rwy 18. The plt stated that he was in and out of fog while on downwind for rwy 18 and that he then encountered a 'bank of ground fog' as he turned short final. According…NTSB FTW85LA269Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Pearsall, TXA commercially rated CFI departed on a part 135 air taxi flt, but encountered deteriorating weather conditions. Circling his destination he reported that rain clouds closed in. Anticipating that he would be unable to file IFR in the air, he elected to land in…NTSB ATL84LA081Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Dalton, GAPlt received a wx briefing aprx 1 hr prior to flt during which '...a chance of light icing' was forecast. Aprx 30 mins after takeoff at 6000 ft MSL light rain was encountered. The plt stated that a small amount of ice began to form on the strut and he…NTSB ATL83LA089Accident · No injuriesLimited investigationFinal reportCessna 182M · Columbia, SCDuring arrival, the pilot entered the traffic to land at owens field, an uncontrolled airport. He stated that the wind sock was limp despite a weather briefing to expect northwesterly winds at 8 to 20 KTS. He stated that he had allowed for strong winds by…NTSB ANC82DAG16Accident · 2 fatalFinal reportCessna 182M · Bethel, AKThe pilot filed a VFR, round robin, flight plan. When the time on the flight plan had elapsed, a search was initiated. Later, the plane was found where it had crashed on a frozen lake surrounded by low terrain. An examination of the wreckage revealed that the…