Skip to content

NTSB investigations: Cessna 182G, CA

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

19642026

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 ('2072716')) 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 ('2072716'))
  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 ('2072716'))
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 WPR12CA169Accident · No injuriesData collectionFinal reportCessna 182G · Georgetown, CAThe pilot’s failure to maintain control of the airplane while landing with a gusting wind.Apr 17, 2012 · N3272S · Substantial damage NTSB LAX07LA212Accident · No injuriesLimited investigationFinal reportCessna 182G · Orland, CAFuel exhaustion due to the pilot's improper preflight inspection and preparation, and his failure to ensure adequate fuel was onboard for the anticipated flight.Jul 9, 2007 · N4521M · Substantial damage NTSB LAX04LA299Accident · No injuriesLimited investigationFinal reportCessna 182G · Big Bear City, CAthe pilot's mistaken selection of an airport road as the landing runway. Factors in the accident were the nonstandard markings on the temporary landing surface and the glare from the setting sun.Aug 21, 2004 · N2059R · Substantial damage NTSB LAX03FA116Accident · 1 fatalField investigationFinal reportCessna 182G · Santa Maria, CAthe pilot's failure to maintain proper runway alignment during the takeoff ground roll, which resulted in the left wing contacting the brush lining the runway edge. The combined effects of the brush and tree contact retarded the airplanes acceleration and…Mar 22, 2003 · N3236S · Destroyed NTSB LAX02LA301Accident · No injuriesLimited investigationFinal reportCessna 182G · Paradise, CAthe pilot's improper flare resulting in a hard landing.Sep 28, 2002 · N2443R · Substantial damage NTSB LAX99LA069Accident · No injuriesLimited investigationFinal reportCessna 182G · San Andreas, CAThe other pilot's failure to maintain an adequate visual lookout while taxiing in a confined area between rows of parked aircraft.Dec 27, 1998 · N3787U · 2 aircraft · Substantial damage NTSB LAX97LA249Accident · No injuriesLimited investigationFinal reportCessna 182G · Fresno, CAthe pilot's improper flare, which resulted in a hard landing and damage to the airplane.Jul 14, 1997 · N2164R · Substantial damage NTSB LAX97LA184Accident · No injuriesLimited investigationFinal reportCessna 182G · Corona, CAfuel exhaustion due to the pilot's failure to perform either preflight or en route fuel consumption calculations. The pilot's decision to fly the aircraft without the required pilot's operating handbook (POH) on board was a factor in this accident.May 19, 1997 · N3165S · Substantial damage NTSB LAX96LA181Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Riverside, CAthe loss of directional control by the pilot's inadequate compensation for the wind gusts, and improper use of the engine and flight controls. The wind was a factor.Apr 29, 1996 · N2182R · Substantial damage NTSB LAX87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Avenal, CAA Cessna 182G collided with trees during landing rollout on a dirt road. The pilot indicated during a telephone interview that the manifold pressure gradually dropped to 18 pounds. The aircraft was unable to maintain altitude and the pilot landed the aircraft…May 30, 1987 · N3274S · Substantial damage NTSB LAX87LA123Accident · No injuriesLimited investigationFinal reportCessna 182G · Vallecito, CAA Cessna 182G collided with the rwy surface after the nose gear collapsed at a private airstrip. The pilot indicated that the nose gear turned 90 degrees during the landing roll then collapsed. Pilot examined the nose gear after the accident and discovered…Feb 20, 1987 · N3683U · Substantial damage NTSB LAX80FUG33Accident · Serious injuriesClosedCessna 182 · Hesperia, CAMay 11, 1980 · N2147R · Destroyed NTSB LAX78FUD05Accident · Serious injuriesClosedCessna 182 · Compton, CAMay 13, 1978 · N2148R · Destroyed NTSB OAK76FVM27Accident · No injuriesClosedCessna 182 · San Jose, CAMar 5, 1976 · N2487R · Substantial damage NTSB LAX75DUQ24Accident · No injuriesClosedCessna 182 · Edwards Afb, CAMar 31, 1975 · N3426S · Substantial damage NTSB OAK75AP039Accident · 1 fatalClosedCessna 182G · Gustine, CAFeb 12, 1975 · N923M · Destroyed NTSB OAK74DVD04Accident · No injuriesClosedCessna 182 · Byron, CAJul 21, 1973 · N2368R · Destroyed NTSB OAK71DVA18Accident · No injuriesClosedCessna 182G · Atwater, CAAug 16, 1970 · N3715J · Substantial damage NTSB LAX70FUG25Accident · Minor injuriesClosedCessna 182 · Big Bear City, CAApr 12, 1970 · N3178S · Substantial damage NTSB LAX69A0031Accident · 5 fatalClosedCessna 150B · Santa Paula, CADec 8, 1968 · N1192Y · 2 aircraft · Destroyed NTSB OAK69D0091Accident · No injuriesClosedCessna 182 · Annapolis, CAJul 13, 1968 · N3127S · Substantial damage NTSB OAK67A0064Accident · 1 fatalClosedCessna 182G · Oroville, CAMar 2, 1967 · N2344R · Destroyed NTSB LAX67F0334Accident · No injuriesClosedCessna 182 · Long Beach, CAFeb 16, 1967 · N3798U · Substantial damage NTSB OAK67F0086Accident · No injuriesClosedCessna 182G · Sacramento, CASep 16, 1966 · N3439S · Substantial damage NTSB OAK67A0027Accident · 4 fatalClosedCessna 182G · Tahoe Pardise, CAAug 30, 1966 · N2376R · Destroyed NTSB OAK67F0046Accident · No injuriesClosedCessna 182S · Woodland, CAAug 10, 1966 · N3160S · Substantial damage NTSB OAK66D0154Accident · No injuriesClosedCessna 182 · Concord, CADec 1, 1965 · N2173R · Substantial damage NTSB OAK66A0025Accident · 1 fatalClosedCessna 182 · Stock, CADec 1, 1965 · N2430R · Destroyed NTSB OAK66D0115Accident · No injuriesClosedCessna 182 · Santa Cruz, CASep 29, 1965 · N3155S · Substantial damage NTSB LAX66D0098Accident · No injuriesClosedCessna 182 · Santee, CASep 3, 1965 · N3679U · Substantial damage NTSB OAK66D0050Accident · No injuriesClosedCessna 182 · Al Tahoe, CAMay 29, 1965 · N2173R · Substantial damage NTSB UNK65X1164Accident · 5 fatalClosedCessna 182G · Boulder Creek, CADec 27, 1964 · N3187S · Destroyed NTSB UNK65X0937Accident · Minor injuriesClosedCessna 182 · Calif Valley, CADec 6, 1964 · N3719U · Substantial damage NTSB UNK64X1061Accident · No injuriesClosedCessna 182 · Blythe, CAMar 27, 1964 · N3683U · Substantial damage