Skip to content

NTSB investigations: Cessna 182F, CA

24 cases on aircraft the registry lists as Cessna 182F. 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 ('2072714')) 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 ('2072714'))
  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 ('2072714'))
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 WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.Aug 7, 2015 · N5738F · Substantial damage NTSB LAX07CA286Accident · No injuriesData collectionFinal reportCessna 182F · Bakersfield, CAThe pilot's inadequate preflight inspection and pretakeoff checks during which he failed to remove the gust lock.Oct 1, 2007 · N3580Y · Substantial damage NTSB LAX98LA047Accident · No injuriesLimited investigationFinal reportCessna 182F · Palmdale, CALoss of engine power due to icing conditions which plugged the fuel system vent.Nov 26, 1997 · N3543Y · Substantial damage NTSB LAX83FUA04Accident · Serious injuriesFinal reportCessna 182 · Avalon Catalina, CAThe acft propeller struck the arm of a lineman who was assisting the plt to start the acft the plt stated that the propeller was turning slowly and he asked for help. The lineman requested that all switches be turned off and proceed toturn the propeller which…Jul 11, 1983 · N3602U · No damage NTSB LAX82DA099Accident · No injuriesFinal reportCessna 182 · Woodland, CAA climb was made to 10,000 ft on a skydiving flight. The pilot reported that after descending to 2000 ft, the engine began to lose power and run rough. He elected to make an off-airport landing in a field. Near the end of the landing roll, the nose gear sank…Mar 7, 1982 · N3427U · Substantial damage NTSB LAX80FA015Accident · No injuriesClosedCessna 152 · Bakersfield, CANov 18, 1979 · N24906 · 2 aircraft · Substantial damage NTSB OAK78FA025Accident · 1 fatalClosedCessna 182F · Half Moon Bay, CAMar 26, 1978 · N3108U · Destroyed NTSB OAK77FVW27Accident · No injuriesClosedCessna 182 · Beatty, CAJul 22, 1977 · N3408U · Substantial damage NTSB OAK75DVD53Accident · No injuriesClosedCessna 182 · Fort Bragg, CAJun 9, 1975 · N3198U · Substantial damage NTSB OAK75DXQ31Accident · Minor injuriesClosedCessna 182 · Mammoth Lks, CADec 21, 1974 · N3408U · Substantial damage NTSB LAX75DUG08Accident · No injuriesClosedCessna 182 · Murrieta, CAJul 14, 1974 · N5738F · Substantial damage NTSB LAX74FUA12Accident · No injuriesClosedCessna 182F · Torrance, CAApr 9, 1974 · N3154U · Substantial damage NTSB OAK69F0252Accident · No injuriesClosedCessna 182 · Oakdale, CAMar 8, 1969 · N3350U · Substantial damage NTSB LAX68A0077Accident · 4 fatalClosedCessna 182F · Carlsbad, CAFeb 24, 1968 · N3554U · Destroyed NTSB LAX68F0329Accident · No injuriesClosedCessna 182F · Fullerton, CAFeb 17, 1968 · N5715R · Substantial damage NTSB OAK68D0237Accident · No injuriesClosedCessna 182 · Oroville, CADec 8, 1967 · N3433U · Substantial damage NTSB LAX66D0350Accident · No injuriesClosedCessna 182 · Rancho Mirage, CAApr 24, 1966 · N3560Y · Substantial damage NTSB OAK66D0248Accident · No injuriesClosedCessna 182F · Coalinga, CAMar 26, 1966 · N3653U · Substantial damage NTSB LAX66D0310Accident · No injuriesClosedCessna 182 · Baker, CAMar 18, 1966 · N3455U · Substantial damage NTSB LAX66F0162Accident · No injuriesClosedCessna 182F · Long Beach, CANov 4, 1965 · N3333U · Substantial damage NTSB OAK65D0025Accident · No injuriesClosedCessna 182 · Cocoran, CAMar 27, 1965 · N3403U · Substantial damage NTSB UNK64X3753Accident · No injuriesClosedCessna 182 · San Bernardin, CASep 3, 1964 · N3403U · Substantial damage NTSB UNK64X1151Accident · Serious injuriesClosedCessna 182F · Yosemite N Pa, CAApr 3, 1964 · N3625U · Substantial damage NTSB UNK64X0524Accident · No injuriesClosedCessna 182F · Ontario, CAFeb 9, 1964 · N3637U · Substantial damage