Skip to content

NTSB investigations: Cessna 182N, CA

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

19712026

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 ('2072730')) 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 ('2072730'))
  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 ('2072730'))
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 WPR27LA026Accident · No injuriesClass 3 · LimitedInvestigation openCessna 182N · Santa Maria, CAOct 28, 2026 · N442RA NTSB WPR25LA292Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182N · Fallbrook, CAOn September 23, 2025, about 1400 Pacific daylight time, N766EE, a Cessna 182N, was substantially damaged when it was involved in an accident near Fallbrook, California. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…Sep 23, 2025 · N766EE · Substantial damage NTSB WPR25LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Auburn, CAThe pilot’s improper use of throttle and brakes during engine start that resulted in a loss of control and impact with a hangar.Feb 9, 2025 · N92467 · Substantial damage NTSB LAX97LA252Accident · No injuriesLimited investigationFinal reportCessna 182N · Sacramento, CAFailure of maintenance personnel to adequately repair the pitch trim system and ensure that it was properly rigged, and the pilot's failure to maintain pitch control due to the distraction at liftoff of the mistrim condition.Jul 18, 1997 · N9099G · Substantial damage NTSB LAX95LA329Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Mariposa, CAthe pilot's inadequate compensation for the existing crosswind condition, and his failure to maintain an adequate airspeed during the attempted go-around, which led to an inadvertent stall/mush.Sep 8, 1995 · N9088G · Destroyed NTSB LAX94LA184Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Kerman, CAAn exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, incapacition of the pilot, and loss of aircraft control.Apr 8, 1994 · N9124G · Substantial damage NTSB LAX92LA125Accident · No injuriesLimited investigationFinal reportCessna 182N · San Ardo, CAThe pilot's inadequate preflight inspection. Contributing to this accident was water contamination in the fuel and the soft soil landing area.Feb 23, 1992 · N8948G · Substantial damage NTSB DEN89FA219Accident · 2 fatalField investigationFinal reportCessna 182 · Concord, CALoss of engine power due to an unknown reason, and failure of the pilot to maintain adequate airspeed, which resulted in a stall.Sep 18, 1989 · N92651 · Destroyed NTSB LAX86FA326Accident · Serious injuriesField investigationFinal reportCessna 182N · Wilmington, CADuring a local night instructional flt the plts reported that the eng began to run very rough and eventually quit when power was reduced slightly to begin the descent for the destination arpt. The acft struck power lines, two small buildings and a brick wall…Aug 20, 1986 · N92252 · Destroyed NTSB LAX82FA045Accident · 3 fatalField investigationFinal reportCessna 182N · Escondido, CABefore takeoff, the pilot received a complete weather briefing. The briefer warned him that the weather system in southern California was extremely hazardous and advised him several times not to go. The briefing included numerous pilot reports that confirmed…Jan 21, 1982 · N92387 · Destroyed NTSB OAK79FXQ05Accident · Serious injuriesClosedCessna 182N · Truckee, CADec 2, 1978 · N8981G · Destroyed NTSB OAK78DVG55Accident · No injuriesClosedCessna 182 · Fair Oaks, CAJul 2, 1978 · N92187 · Substantial damage NTSB OAK7LFVD02Accident · Minor injuriesClosedCessna 182N · Fortuna, CAJul 28, 1975 · N9099G · Substantial damage NTSB OAK75FVM08Accident · No injuriesClosedCessna 182 · Sn L Obispo, CAJul 11, 1974 · N9229G · Substantial damage NTSB LAX74AL066Accident · 1 fatalClosedCessna 182N · Arlington, CAMar 30, 1974 · N92409 · Destroyed NTSB OAK73FXQ10Accident · Minor injuriesClosedCessna 182N · Mammoth Lks, CAAug 26, 1973 · N92252 · Substantial damage NTSB OAK73DVA61Accident · No injuriesClosedCessna 182N · Modesto, CAJun 2, 1973 · N92816 · Substantial damage NTSB LAX73FUG22Accident · Serious injuriesClosedCessna 182 · Rialto, CANov 11, 1972 · N9127G · Substantial damage NTSB OAK73FVM01Accident · No injuriesClosedCessna 182 · S.Francisco, CAJul 6, 1972 · N9168G · Substantial damage NTSB LAX72DUG82Accident · No injuriesClosedCessna 182 · Daggett, CAJun 30, 1972 · N92337 · Substantial damage NTSB OAK72DVA56Accident · No injuriesClosedCessna 182 · Pinedale, CAMar 12, 1972 · N9196G · Substantial damage NTSB LAX72DVM01Accident · No injuriesClosedCessna 182 · San L Obspo, CAAug 1, 1971 · N92816 · Substantial damage NTSB LAX71FUQ93Accident · Serious injuriesClosedCessna 182 · Sta Barbara, CAJun 18, 1971 · N92847 · Destroyed