Skip to content

NTSB investigations: Cessna 182D, CA

20 cases on aircraft the registry lists as Cessna 182D. 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 ('2072710')) 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 ('2072710'))
  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 ('2072710'))
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 WPR22LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Desert Camp, CAThe airplane’s loss of engine power due to carburetor icing.Mar 2, 2022 · N8814X · Substantial damage NTSB WPR18TA157Accident · No injuriesClass 3Final reportCessna 182D · Crescent Mills, CAA total loss of engine power due to the development of carburetor icing.May 18, 2018 · N9163X · Substantial damage NTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…Oct 15, 2016 · N8718X · Destroyed NTSB LAX06CA244Accident · No injuriesData collectionFinal reportCessna 182D · Santa Clarita, CAA loss of engine power due to fuel exhaustion. The fuel exhaustion was the result of a split O-ring on the right fuel cap, which allowed fuel to siphon out of the right fuel tank during flight.Jul 25, 2006 · N8961X · Substantial damage NTSB LAX96LA288Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Weed, CAThe pilot's improper fuel management. A factor was the lack of suitable terrain for the forced landing.Jul 23, 1996 · N8787X · Substantial damage NTSB LAX87LA347Accident · No injuriesLimited investigationFinal reportCessna 182D · San Ramon, CAAfter telling the lineman at calexico, CA to fill the tanks, the plt walked away from the acft to clear customs. When he returned, he loaded his passengers into the acft and departed the arpt. After flying 3 and 1/2 hours the engine stopped and the acft was…Sep 26, 1987 · N8711X · Substantial damage NTSB LAX84LA489Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Lincoln, CAAfter a descent from 11,000 ft, the eng lost power at 3500 ft & would not restart. At that time, the plt noted that the fuel gages indicated the right tank was about 1/4 full & the left tank was empty. He landed in a rice field at night where the nose gear…Sep 21, 1984 · N9157X · Substantial damage NTSB OAK76DVG81Accident · No injuriesClosedCessna 182 · Vallejo, CAMay 27, 1976 · N8806X · Substantial damage NTSB LAX69F0127Accident · No injuriesClosedCessna 182 · Fullerton, CAAug 5, 1968 · N8878X · Substantial damage NTSB LAX69F0044Accident · No injuriesClosedCessna 182 · Burbank, CAJun 16, 1968 · N9122X · Substantial damage NTSB OAK68D0342Accident · No injuriesClosedCessna 182 · Nicolaus, CANov 5, 1967 · N8763X · Substantial damage NTSB LAX68D0130Accident · No injuriesClosedCessna 182 · Compton, CAOct 1, 1967 · N9005X · Substantial damage NTSB OAK67D0284Accident · No injuriesClosedCessna 182 · Turlock, CAMar 31, 1967 · N8938X · Substantial damage NTSB OAK67D0176Accident · No injuriesClosedCessna 182D · Bethel Isl., CANov 19, 1966 · N8948X · Substantial damage NTSB OAK66F0172Accident · Minor injuriesClosedCessna 182 · Tahoe Valley, CADec 15, 1965 · N9078X · Substantial damage NTSB UNK65X1486Accident · No injuriesClosedCessna 182 · Salton City, CAApr 14, 1965 · N9166X · Substantial damage NTSB LAX65F0042Accident · No injuriesClosedCessna 182 · Joshua Tree, CAJan 13, 1965 · N8791X · Substantial damage NTSB UNK64X4054Accident · No injuriesClosedCessna 182 · Santa Cruz, CASep 19, 1964 · N9977T · Substantial damage NTSB UNK64X2475Accident · No injuriesClosedCessna 182 · Van Nuys, CAJun 25, 1964 · N8704X · Substantial damage NTSB UNK64X0239Accident · 1 fatalClosedCessna 182 · Fresno, CAJan 13, 1964 · N8867X · Destroyed