Skip to content

NTSB investigations: Cessna 182M, CA

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

19692026

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" = 'CA' 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 ('2072728')) 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\" = 'CA' 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 ('2072728'))
  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" = 'CA' 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 ('2072728'))
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 WPR19LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182M · Upland, CAThe total loss of engine power due to detonation within the No. 2 cylinder as a result of a lean fuel flow setting.Jun 15, 2019 · N777RK · Substantial damage NTSB GAA16CA356Accident · Minor injuriesData collectionFinal reportCessna 182 · Llano, CAThe pilot's failure to attain an adequate airspeed and his intentional aerodynamic stall, which resulted in an impact with terrain and a post-impact fire.Jul 3, 2016 · N1642T · Destroyed NTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.Mar 8, 2015 · N2030M · Substantial damage NTSB WPR10CA227Accident · No injuriesData collectionFinal reportCessna 182M · Angwin, CAThe pilot's inadequate compensation for the crosswind resulting in the loss of directional control during the landing roll.May 3, 2010 · N91603 · Substantial damage NTSB WPR09LA242Accident · No injuriesLimited investigationFinal reportCessna 182M · Madera, CAThe pilot’s failure to maintain directional control of the airplane throughout the landing.May 9, 2009 · N71165 · Substantial damage NTSB LAX05FA175Accident · 2 fatalField investigationFinal reportCessna 182M · Palm Springs, CAThe pilot's inadequate in-flight planning/decision, and his failure to maintain clearance while maneuvering in rising terrain, resulting in an in-flight collision with terrain.May 15, 2005 · N333LP · Destroyed NTSB LAX97LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Fallbrook, CAthe pilot's selection of a runway with a tailwind component and his maintaining an excessive airspeed on final approach, which resulted in a late touchdown and a high ground speed.Nov 28, 1996 · N70967 · Substantial damage NTSB LAX91LA007Accident · No injuriesLimited investigationFinal reportCessna 182M · Bakersfield, CAThe pilot failed to properly recover from the bounced landing. Contributing to the accident was the pilot's lack of familiarity with the airplane.Oct 7, 1990 · N70892 · Substantial damage NTSB LAX88LA316Accident · No injuriesLimited investigationFinal reportCessna 182M · Crescent City, CAFailure of the number 2 piston due to preexisting fatigue cracks in the piston.Sep 10, 1988 · N4834P · Substantial damage 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…Apr 18, 1987 · N71736 · Substantial damage NTSB LAX86LA116Accident · No injuriesLimited investigationFinal reportCessna 182M · Healdsburg, CAOn February 8, 1986, at 1430 PST a Cessna 182, N91614, overran the landing surface and nosed over at a dirt strip. VMC prevailed at the time. The winds were generally calm with sporadic gusts from the north at approximately 10 knots. There was no indication…Feb 8, 1986 · N91614 · Substantial damage NTSB LAX81FA048Accident · 2 fatalClosedCessna 182M · Truckee, CAFeb 19, 1981 · N71803 · Destroyed NTSB LAX80FUQ05Accident · Minor injuriesClosedCessna 182 · Valencia, CADec 5, 1979 · N92063 · Substantial damage NTSB LAX79DUQ20Accident · No injuriesClosedCessna 182 · Tehachapi, CAMar 10, 1979 · N71514 · Substantial damage NTSB LAX78FA079Accident · 2 fatalClosedCessna 182M · Santa Barbara, CASep 24, 1978 · N71182 · Destroyed NTSB LAX78DUG56Accident · No injuriesClosedCessna 182M · El Monte, CASep 23, 1978 · N70833 · Substantial damage NTSB LAX76DVA30Accident · No injuriesClosedCessna 182 · Bakersfield, CANov 24, 1975 · N70946 · Substantial damage NTSB LAX74FUA26Accident · No injuriesClosedCessna 182 · Hntgton Bch, CAJun 30, 1974 · N71665 · Substantial damage NTSB OAK74DVA73Accident · No injuriesClosedCessna 182 · Columbia, CAJun 8, 1974 · N92069 · Substantial damage NTSB OAK74DVA15Accident · No injuriesClosedCessna 182M · Visalia, CAAug 17, 1973 · N70986 · Substantial damage NTSB OAK73DVD44Accident · No injuriesClosedCessna 182 · Livermore, CAMay 28, 1973 · N70946 · Substantial damage NTSB OAK72DVM23Accident · No injuriesClosedCessna 182M · San Jose, CAFeb 2, 1972 · N70655 · Substantial damage NTSB LAX72FUG33Accident · Serious injuriesClosedCessna 182M · Mentone, CANov 13, 1971 · N71169 · Destroyed NTSB LAX71DVM47Accident · No injuriesClosedCessna 182 · S.L.Obispo, CAMar 28, 1971 · N71610 · Substantial damage NTSB LAX70FUG43Accident · No injuriesClosedCessna 182 · Big Bear, CAJun 6, 1970 · N91538 · Substantial damage NTSB OAK69D0306Accident · Serious injuriesClosedCessna 182M · Livermore, CAApr 22, 1969 · N667PL · Substantial damage