NTSB investigations: Cessna 180J, CA
10 cases on aircraft the registry lists as Cessna 180J. 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
| 1977 | 1 |
|---|---|
| 1982 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2018 | 1 |
| 2023 | 1 |
| 2025 | 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 ('2072622'))
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 ('2072622'))
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 WPR25LA132Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Oakland, CAThe pilot’s failure to maintain directional control during takeoff roll with a left crosswind.NTSB WPR24LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Modesto, CAThe failure of the pilot to maintain directional control of the airplane during landing, which resulted in a nose over.NTSB GAA18CA190Accident · No injuriesData collectionFinal reportCessna 180 · Salina, CAThe pilot’s failure to maintain directional control during landing.NTSB LAX03LA140Accident · No injuriesLimited investigationFinal reportCessna 180J · Angwin, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control of the airplane during the landing roll.NTSB LAX02LA127Accident · No injuriesLimited investigationFinal reportCessna 180J · Saline Valley, CAThe pilot's loss of directional control during landing rollout after encountering a water erosion rut in the runway's uneven surface.NTSB LAX89FA287Accident · 2 fatalField investigationFinal reportCessna 180J · Tracy, CAInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: the lack of a conflict alert system for the stockton arts ii radar.NTSB LAX87FA117Accident · 1 fatalField investigationFinal reportCessna 180J · Newhall, CABased on available evidence, it is believed that the accident occurred between 0700 and 0830 hrs during a period of low ceilings and restricted visibilities in the area where the accd took place. The accd site is located in a mountain pass area between two…NTSB LAX84LA165Accident · Serious injuriesLimited investigationFinal reportCessna 180J · Hayward, CADuring arrival, the plt had descended to stay below the tca & was approaching his destination when the eng lost power. He turned back toward the Hayward arpt, but was unable to reach it or restart the eng. During a forced landing at night, the acft was…NTSB LAX82DA280Accident · Minor injuriesFinal reportCessna 180J · Ramona, CAThe plt was practicing landings on a 15 ft wide remote dirt strip. The right brake failed & the acft veered off the rwy.NTSB OAK77DVD42Accident · No injuriesClosedCessna 180 · Santa Rosa, CA