Skip to content

NTSB investigations: Cessna 182E, CA

29 cases on aircraft the registry lists as Cessna 182E. 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 ('2072712')) 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 ('2072712'))
  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 ('2072712'))
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 LAX04CA147Accident · No injuriesData collectionFinal reportCessna 182E · Sonora, CAthe pilot's inadequate preflight inspection and failure to ensure adequate fuel was aboard, which resulted in fuel exhaustion and loss of engine power.Mar 6, 2004 · N2819Y · Substantial damage NTSB LAX93LA122Accident · No injuriesLimited investigationFinal reportCessna 182E · Corning, CAThe pilot's poor preflight inspection. Factors relating to this accident were the not properly secured oil cap and the oil covered windshield.Feb 15, 1993 · N9300X · Substantial damage NTSB LAX92LA221Accident · No injuriesLimited investigationFinal reportCessna 182E · Lone Pine, CAThe pilot's encounter with a sudden and strong quartering tailwind after landing on a short dirt runway, and the failure of the pilot to select the other airport runway, which was longer and more aligned with the wind, for the approach and landing.May 27, 1992 · N9340X · Substantial damage NTSB LAX91LA243Accident · 2 fatalLimited investigationFinal reportCessna 182E · Eureka, CAThe non-instrument rated pilot's inadvertent flight into IMC conditions. The pilot's lack of total experience, his disregard to the preflight meteorological briefing he received, low ceilings, fog, and the mountainous terrain over which the flight was…Jun 10, 1991 · N3046Y · Destroyed NTSB LAX91LA062Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Imperial, CAFuel exhaustion.Dec 22, 1990 · N3320Y · Destroyed NTSB LAX90LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Avalon, CAFailure of the pilot to attain the proper touchdown point for landing, and his failure to go around when he had too much speed and insufficient distance to stop on the runway. A factor related to the accident was: the uneven terrain beyond the departure end…Dec 7, 1989 · N2957Y · Substantial damage NTSB LAX89LA291Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAInadequate crew coordination between the tow pilot and glider pilot, failure of the glider pilot to obtain proper assistance, and the tow pilot's misunderstanding of the glider pilot's intentions.Aug 30, 1989 · N65843 · 2 aircraft · Destroyed NTSB LAX82DA043Accident · No injuriesFinal reportCessna 182E · Santa Monica, CAUpon landing touchdown the aircraft bounced at high speed and departed the runway. The pilot applied brakes and the aircraft skidded to a stop just short of a ditch.Jan 19, 1982 · N9255X · Substantial damage NTSB LAX81DXQ19Accident · Minor injuriesClosedCessna 182 · Truckee, CAJun 5, 1981 · N3343Y · Substantial damage NTSB LAX79FA041Accident · 4 fatalClosedCessna 182E · Glamis, CAApr 15, 1979 · N3265Y · Destroyed NTSB LAX78FUG41Accident · No injuriesClosedCessna 182E · Temecula, CAJul 22, 1978 · N3188Y · Substantial damage NTSB LAX76FUM29Accident · No injuriesClosedCessna 182 · Miramar Nas, CASep 1, 1976 · N3188Y · Substantial damage NTSB LAX74FUQ40Accident · Serious injuriesClosedCessna 182 · San Frnando, CAMay 19, 1974 · N3133Y · Substantial damage NTSB OAK72DVD12Accident · No injuriesClosedCessna 182 · Novato, CAAug 22, 1971 · N3003Y · Substantial damage NTSB OAK72FXQ05Accident · Serious injuriesClosedCessna 182E · Bieber, CAAug 8, 1971 · N3126Y · Substantial damage NTSB LAX71FUG81Accident · No injuriesClosedCessna 182E · Hemet, CAMay 8, 1971 · N3133Y · Substantial damage NTSB OAK71DVA35Accident · Minor injuriesClosedCessna 182 · Selma, CAOct 3, 1970 · N2840Y · Substantial damage NTSB LAX71DUQ22Accident · No injuriesClosedCessna 182 · Oxnard, CASep 26, 1970 · N3266Y · Substantial damage NTSB LAX70DVA21Accident · No injuriesClosedCessna 182 · Bakersfield, CAJun 30, 1970 · N9297X · Substantial damage NTSB LAX70DUG17Accident · No injuriesClosedCessna 182 · Joshua Tree, CAMar 28, 1970 · N3035Y · Substantial damage NTSB OAK68D0144Accident · No injuriesClosedCessna 182 · Susanville, CAOct 8, 1967 · N2855Y · Substantial damage NTSB OAK68D0031Accident · No injuriesClosedCessna 182 · Stockton, CAJul 1, 1967 · N3073Y · Substantial damage NTSB OAK67D0160Accident · No injuriesClosedCessna 182 · Mammoth Lakes, CAAug 26, 1966 · N2850Y · Substantial damage NTSB LAX67D0048Accident · No injuriesClosedCessna 182 · Vidal Junct, CAJul 1, 1966 · N9339X · Substantial damage NTSB OAK66A0028Accident · 3 fatalClosedCessna 182E · El Portal, CADec 11, 1965 · N3167Y · Destroyed NTSB OAK66F0008Accident · No injuriesClosedCessna 182E · Sonora, CAMay 22, 1965 · N3242Y · Substantial damage NTSB UNK65X1192Accident · 3 fatalClosedCessna 182E · Ventura, CADec 30, 1964 · N9256X · Destroyed NTSB UNK64X3742Accident · No injuriesClosedCessna 182E · Santa Susana, CASep 2, 1964 · N3150Y · Substantial damage NTSB UNK64X0355Accident · Minor injuriesClosedCessna 182 · Hollister, CAJan 25, 1964 · N9329X · Destroyed