Skip to content

NTSB investigations: Cessna 182B, CA

42 cases on aircraft the registry lists as Cessna 182B. 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 ('2072706')) 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 ('2072706'))
  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 ('2072706'))
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 GAA16CA520Accident · No injuriesData collectionFinal reportCessna 182 · Lakeport, CAThe pilot's delayed action to add power during the approach, which resulted in an impact with terrain prior to the approach end of the runway.Sep 29, 2016 · N2613G · Substantial damage NTSB LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.Jun 8, 2006 · N2404G · Substantial damage NTSB LAX06CA010Accident · No injuriesData collectionFinal reportCessna 182B · Mokelumne Hill, CAthe pilot's improper flare resulting in a hard landing. A related factor was gusty wind conditions.Oct 15, 2005 · N2728B · Substantial damage NTSB LAX97LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Madera, CAfuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.Sep 7, 1997 · N81MK · Substantial damage NTSB LAX96LA303Accident · No injuriesLimited investigationFinal reportCessna 182B · Santa Ana, CAImproper fuel management by the pilot resulting in exhaustion of the aircraft's fuel supply.Aug 10, 1996 · N2487G · Substantial damage NTSB LAX95FA340Accident · 1 fatalField investigationFinal reportCessna 182B · Rancho Cucamong, CAthe failure of the pilot to maintain adequate altitude above mountainous terrain.Dec 31, 1994 · N2569G · Destroyed NTSB LAX94LA351Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Twentynine Palm, CAthe cause of the loss of engine power could not be determined. The dirt berm was a factor in this accident.Sep 4, 1994 · N8431T · Substantial damage NTSB LAX92LA251Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Big Bear Lake, CAThe lose of engine power for undetermined reasons. The mountainous road on which the pilot attempted to land and the two motor vehicles that were on the road were factors in the accident.Jun 16, 1992 · N7133E · Substantial damage NTSB LAX91FA252Accident · 3 fatalField investigationFinal reportCessna 182 · Bermuda Dunes, CAThe pilot-in-command's failure to maintain airspeed while maneuvering to return to the departure airport, resulting in an in flight loss of control, stall, and in flight collision with terrain. Factors related to the accident were: partial loss of engine…Jun 8, 1991 · N7299E · Destroyed NTSB LAX91LA225Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Kernville, CA1)The failure of the pilot to accurately assess and compensate for the prevailing wind conditions; 2) his failure to maintain a correct approach speed for the aircraft; 3) his failure to attain a proper touchdown point; and 4) his failure to initiate a go…May 26, 1991 · N2687G · Substantial damage NTSB LAX91LA185Accident · No injuriesLimited investigationFinal reportCessna 182B · Arvin, CA1) The pilot inadequately compensated for wind conditions; 2) the pilot's improper inflight decision; and 3) the pilot not attaining the proper landing touchdown point.Apr 27, 1991 · N7220E · Substantial damage NTSB LAX91LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Madera, CAThat the pilot's fuel consumption calculation were inaccurate. Contributing to this accident was fuel exhaustion.Apr 12, 1991 · N7290E · Substantial damage NTSB LAX86LA338Accident · No injuriesLimited investigationFinal reportCessna 182B · La Jolla, CAThe pilot of a Cessna 182 ditched into the ocean after experiencing a loss of engine power. The weather was instrument meteorological conditions in the area. The pilot indicated the fuel gauges indicated less than 1/4 of fuel on the right tank at the time of…Aug 30, 1986 · N2710G · Destroyed NTSB LAX80FVM15Accident · No injuriesClosedCessna 182 · Salinas, CAFeb 15, 1980 · N2633G · Substantial damage NTSB LAX77FUA21Accident · No injuriesClosedCessna 182B · San Pedro, CASep 7, 1977 · N8440T · Destroyed NTSB OAK77DVM20Accident · No injuriesClosedCessna 182 · San Jose, CAJul 10, 1977 · N2363G · Substantial damage NTSB OAK76DVA87Accident · No injuriesClosedCessna 182B · Stevinson, CASep 3, 1976 · N8419T · Substantial damage NTSB OAK75FVM29Accident · No injuriesClosedCessna 182B · San Jose, CAMay 4, 1975 · N2461G · Substantial damage NTSB LAX74DUG04Accident · No injuriesClosedCessna 182B · Lucerne Vly, CAJun 23, 1974 · N2675G · Substantial damage NTSB OAK73DVG69Accident · No injuriesClosedCessna 182B · Dunsmuir, CAJun 18, 1973 · N7289E · Substantial damage NTSB OAK72DVG30Accident · No injuriesClosedCessna 182 · Tulelake, CADec 12, 1971 · N2396G · Substantial damage NTSB OAK72DVG15Accident · No injuriesClosedCessna 182 · Fair Oaks, CAAug 10, 1971 · N2787G · Substantial damage NTSB LAX70D0095Accident · No injuriesClosedCessna 182 · Rubidoux, CAAug 14, 1969 · N2569G · Substantial damage NTSB LAX69F0284Accident · No injuriesClosedCessna 182B · Compton, CAFeb 25, 1969 · N7266E · Substantial damage NTSB LAX69F0282Accident · No injuriesClosedCessna 182 · Indio, CAFeb 21, 1969 · N2599G · Substantial damage NTSB OAK69D0127Accident · No injuriesClosedCessna 182 · Belota, CAAug 25, 1968 · N2730G · Destroyed NTSB OAK68D0109Accident · No injuriesClosedCessna 182 · Healdsburg, CASep 7, 1967 · N2640G · Substantial damage NTSB LAX67A0089Accident · 1 fatalClosedCessna 182B · Caliente, CAMar 28, 1967 · N23F · Destroyed NTSB OAK66A0057Accident · Minor injuriesClosedCessna 182 · Hayfork, CAJun 11, 1966 · N2781G · Destroyed NTSB LAX66A0068Accident · 1 fatalClosedCessna 182B · Santa Cruz Is, CAMar 8, 1966 · N7254E · Destroyed NTSB LAX66F0191Accident · Minor injuriesClosedCessna 182B · Ocotillo, CADec 13, 1965 · N2780G · Substantial damage NTSB OAK66D0164Accident · No injuriesClosedCessna 182B · Mokelumne Pk, CANov 29, 1965 · N8425T · Substantial damage NTSB LAX66D0149Accident · No injuriesClosedCessna 182 · Furnace Creek, CANov 4, 1965 · N2382G · Substantial damage NTSB LAX66F0151Accident · No injuriesClosedCessna 182 · Maricopa, CAOct 28, 1965 · N7286E · Substantial damage NTSB OAK66F0128Accident · No injuriesClosedCessna 182 · Live Oak, CAOct 17, 1965 · N9138R · Substantial damage NTSB OAK66D0073Accident · No injuriesClosedCessna 182 · Arbuckle, CASep 24, 1965 · N2299C · Substantial damage NTSB UNK65X1407Accident · No injuriesClosedCessna 182 · Yucca Valley, CAFeb 8, 1965 · N2788G · Substantial damage NTSB UNK65X0883Accident · No injuriesClosedCessna 182 · March Afb, CANov 29, 1964 · N7197E · Substantial damage NTSB UNK65X0355Accident · Minor injuriesClosedCessna 182 · San Diego, CAOct 21, 1964 · N2372G · Substantial damage NTSB UNK64X3514Accident · Minor injuriesClosedCessna 182 · Auburn, CAAug 21, 1964 · N2459G · Substantial damage NTSB UNK64X0502Accident · No injuriesClosedCessna 182 · Watsonville, CAFeb 8, 1964 · N8425T · Substantial damage NTSB UNK64X0199Accident · No injuriesClosedCessna 182 · Garnet, CAJan 9, 1964 · N7197E · Substantial damage