Skip to content

NTSB investigations: Cessna 182H, CA

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

19652026

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 ('2072718')) 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 ('2072718'))
  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 ('2072718'))
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 WPR22LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 182H · Petaluma, CAThe pilot’s failure to maintain airplane control during a go-around in gusting wind conditions.Jul 4, 2022 · N8414S · Substantial damage NTSB WPR13LA317Accident · No injuriesLimited investigationFinal reportCessna 182H · Hesperia, CAThe loss of engine power during cruise flight due to the detachment of the mixture control cable from its mounting clamp.Jul 9, 2013 · N2062X · Substantial damage NTSB LAX94LA003Accident · 1 fatalLimited investigationFinal reportCessna 182H · Clear Lake Res, CAFailure of the pilot to maintain altitude, while performing a low-altitude maneuver (turn) over water. Factors related to the accident were: sun glare, haze, glassy condition of the water, and the lack of visual cues (visual perception) for the pilot to judge…Oct 1, 1993 · N8397S · Substantial damage NTSB LAX92LA048Accident · No injuriesLimited investigationFinal reportCessna 182H · Fortuna, CAThat the pilot misjudged the flare altitude. Contributing to the accident was the failure of the flight instructor to adequately supervise the flight.Nov 6, 1991 · N3474S · Substantial damage NTSB LAX91LA246Accident · No injuriesLimited investigationFinal reportCessna 182 · Lincoln, CAThat the pilot-in-command improperly flared the airplane by misjudging the altitude and improper recovery from the bounced landing.Jun 5, 1991 · N2489X · Substantial damage NTSB LAX90LA296Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Temecula, CAThe pilot's inadequate preflight that resulted in his continuing flight with an inoperative alternator.Aug 19, 1990 · N2355X · Substantial damage NTSB LAX83LA176Accident · No injuriesLimited investigationFinal reportCessna 182H · Ruth, CAAfter landing at Ruth, CA, the acft was refueled with aprx 38 gal of 80/87 octane aviation fuel. During takeoff, about 15 min after landing, the eng lost power as the acft was climbing thru aprx 200 to 300 ft AGL. The plt landed straight ahead in the best…Apr 5, 1983 · N2353X · Substantial damage NTSB LAX82FVG07Accident · Serious injuriesClosedCessna 182H · Sacramento, CANov 25, 1981 · N2361X · Substantial damage NTSB LAX80FVD16Accident · Minor injuriesClosedCessna 182 · Petaluma, CAMar 23, 1980 · N1826X · Substantial damage NTSB OAK78DXQ22Accident · Serious injuriesClosedCessna 182H · Mammoth Lakes, CAMay 19, 1978 · N1837X · Substantial damage NTSB OAK75FVG73Accident · No injuriesClosedCessna 182 · Red Bluff, CAMay 31, 1975 · N2394X · Substantial damage NTSB LAX75AL066Accident · 4 fatalClosedCessna 182 · Arvin, CAApr 9, 1975 · N376LA · Destroyed NTSB LAX74IUA22Accident · No injuriesClosedCessna 182H · Torrance, CAApr 25, 1974 · N8478S · Substantial damage NTSB LAX72DUG79Accident · No injuriesClosedCessna 182 · Big Bear, CAJun 28, 1972 · N1903X · Substantial damage NTSB LAX72FUA31Accident · No injuriesClosedCessna 182H · Long Beach, CAJan 16, 1972 · N8545S · Substantial damage NTSB OAK71DVG66Accident · No injuriesClosedCessna 182 · Vacaville, CAApr 25, 1971 · N8424S · Substantial damage NTSB OAK71DVD42Accident · No injuriesClosedCessna 182 · Novato, CAApr 21, 1971 · N2018X · Substantial damage NTSB OAK71AP001Accident · 1 fatalClosedCessna 182H · Shaver Lake, CAJul 8, 1970 · N2042X · Destroyed NTSB LAX70FUQ23Accident · No injuriesClosedCessna 182H · Pearlblossm, CAApr 17, 1970 · N8411S · Substantial damage NTSB OAK70D0012Accident · No injuriesClosedCessna 182 · Concord, CAMay 30, 1969 · N1997X · Substantial damage NTSB OAK70D0019Accident · No injuriesClosedCessna 182 · Paso Robles, CAMay 10, 1969 · N1807X · Substantial damage NTSB OAK69D0225Accident · No injuriesClosedCessna 182 · Danville, CAJan 13, 1969 · N1879X · Substantial damage NTSB OAK69D0131Accident · No injuriesClosedCessna 182H · Modesto, CASep 6, 1968 · N2475X · Substantial damage NTSB OAK69A0007Accident · 3 fatalClosedCessna 182H · El Granada, CAJul 28, 1968 · N8348S · Destroyed NTSB LAX68D0089Accident · No injuriesClosedCessna 182 · Fallbrook, CAJul 27, 1967 · N8434S · Substantial damage NTSB OAK68D0002Accident · No injuriesClosedCessna 182 · Lodi, CAMay 14, 1967 · N1903X · Substantial damage NTSB LAX67D0376Accident · No injuriesClosedCessna 182 · Long Beach, CAApr 18, 1967 · N8488S · Substantial damage NTSB LAX66F0364Accident · No injuriesClosedCessna 182 · Torrance, CAJun 5, 1966 · N2047X · Substantial damage NTSB LAX66D0329Accident · No injuriesClosedCessna 182 · Rancho Mirage, CAMar 27, 1966 · N8424S · Substantial damage NTSB OAK66D0135Accident · No injuriesClosedCessna 182 · Gonzales, CASep 15, 1965 · N2069X · Substantial damage NTSB LAX65F0078Accident · No injuriesClosedCessna 182 · Santa Ana, CAApr 13, 1965 · N2304X · Substantial damage