NTSB investigations: Cessna 182C, CA
28 cases on aircraft the registry lists as Cessna 182C. 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1967 | 4 |
| 1968 | 1 |
| 1969 | 3 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2004 | 1 |
| 2011 | 1 |
| 2019 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2072708'))
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 ('2072708'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 GAA19CA146Accident · No injuriesData collectionFinal reportCessna 182 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll with a gusting tailwind, which resulted in a runway excursion and collision with runway lights and taxiway signage.NTSB WPR11CA174Accident · Minor injuriesData collectionFinal reportCessna 182C · Stockton, CAThe pilot's failure to secure the airplane before pulling the propeller to start the engine.NTSB LAX04CA183Accident · No injuriesData collectionFinal reportCessna 182C · Garberville, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane. Factors in the accident were the terrain induced turbulent conditions, wind shear, a sudden wind shift, and a tailwind.NTSB LAX95LA111Accident · No injuriesLimited investigationFinal reportCessna 182C · Novato, CAThe pilot's failure to maintain a proper base leg alignment while flying in the traffic pattern and his misjudged distance and altitude during the approach. A factor which contributed to the accident was the dark nighttime lighting condition which reduced the…NTSB LAX92LA230Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Redding, CAThe internal failure of the airplane's throttle control cable.NTSB LAX89LA117Accident · No injuriesLimited investigationFinal reportCessna 182C · Adalanto, CAThe pilot was inattentive, did not maintain proper alignment with the runway and did not maintain an adequate visual lookout during takeoff.NTSB LAX86FVD05Accident · Serious injuriesFinal reportCessna 182C · Oakland, CAThe acft contacted several vehicles during a forced landing following a loss of pwr shortly after takeoff. Post accident inspection of the acft revealed the carburetor bowl was 1/3 full of water. No other discrepancies were noted which would have resulted in…NTSB LAX85FA128Accident · Serious injuriesField investigationFinal reportCessna 182C · Apple Valley, CAThe acft was observed to enter the left downwind leg at a low alt of about 200 ft AGL. The engine stopped completely, & the plt attempted to land on the runway, but impacted the ground short & to the left of the apch end of the rwy. Wing flaps were found…NTSB LAX78DVM23Accident · Minor injuriesClosedCessna 182C · Simmler, CANTSB LAX76FUQ13Accident · Minor injuriesClosedCessna 182 · Nippomo, CANTSB LAX74FUG60Accident · No injuriesClosedCessna 182 · Amboy, CANTSB OAK73DVD08Accident · No injuriesClosedCessna 182C · Tracy, CANTSB LAX71DUM36Accident · No injuriesClosedCessna 182C · Carlsbad, CANTSB LAX71FUM27Accident · No injuriesClosedCessna 182C · El Centro, CANTSB OAK71DVG29Accident · No injuriesClosedCessna 182C · Sutter Crk, CANTSB OAK71DVA17Accident · No injuriesClosedCessna 182 · Fresno, CANTSB LAX70A0030Accident · 2 fatalClosedCessna 182C · Bg Bear Cty, CANTSB OAK70D0063Accident · No injuriesClosedCessna 182 · Bass Lake, CANTSB OAK69D0296Accident · No injuriesClosedCessna 172 · San Carlos, CANTSB LAX69D0063Accident · No injuriesClosedCessna 182C · Bakersfield, CANTSB LAX68D0267Accident · No injuriesClosedCessna 182C · Big Bear City, CANTSB LAX68F0287Accident · No injuriesClosedCessna 182C · Bakersfield, CANTSB LAX67A0107Accident · 2 fatalClosedCessna 182C · Hawthorne, CANTSB OAK68D0151Accident · No injuriesClosedCessna 182 · Carmel, CANTSB LAX67D0171Accident · No injuriesClosedCessna 182 · Lone Pine, CANTSB LAX67F0073Accident · No injuriesClosedCessna 182 · Lompoc, CANTSB LAX65A0069Accident · 2 fatalClosedCessna 182C · Wrightwood, CANTSB UNK65X0863Accident · No injuriesClosedCessna 182C · Vacaville, CA