Skip to content

NTSB investigations: Cessna 180, AZ

29 cases on aircraft the registry lists as Cessna 180. 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" = 'AZ' 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 ('2072602')) 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\" = 'AZ' 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 ('2072602'))
  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" = 'AZ' 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 ('2072602'))
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 WPR14LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Johns, AZA total loss of engine power while on final approach due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning.Nov 3, 2013 · N3148C · Substantial damage NTSB WPR11CA162Accident · No injuriesData collectionFinal reportCessna 180 · Pine, AZThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with terrain.Mar 10, 2011 · N9330C · Substantial damage NTSB WPR11CA106Accident · No injuriesData collectionFinal reportCessna 180 · Prescott, AZThe pilot's loss of airplane control during the landing roll.Jan 25, 2011 · N2229C · Substantial damage NTSB WPR11CA097Accident · No injuriesData collectionFinal reportCessna 180 · Flagstaff, AZThe pilot's failure to maintain directional control during landing that resulted in a ground loop.Dec 31, 2010 · N67F · Substantial damage NTSB LAX06FA206Accident · 4 fatalField investigationFinal reportCessna 180 · Payson, AZThe pilot's failure to maintain clearance from the terrain during a low level flyby maneuver. A factor was glare from the sun and shadows created by the mountainous terrain.Jun 18, 2006 · N1535C · Substantial damage NTSB LAX03CA249Accident · No injuriesData collectionFinal reportCessna 180 · St. Johns, AZThe pilot's inadequate compensation for a crosswind condition that resulted in a loss of directional control and ground loop. The crosswind was a contributing factor.Jul 31, 2003 · N2935A · Substantial damage NTSB LAX96LA188Accident · No injuriesLimited investigationFinal reportCessna 180 · Lake Havasu Cty, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control. The wind was a factor.May 4, 1996 · N4691B · Substantial damage NTSB LAX95LA224Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chandler, AZFuel exhaustion resulting from the pilot's failure to determine the amount of fuel onboard at departure. The reduced ambient lighting was a factor in this accident.Jun 26, 1995 · N2362C · Substantial damage NTSB LAX95LA135Accident · 2 fatalLimited investigationFinal reportCessna 180 · Winslow, AZThe pilot's poor judgement by intentionally deciding to buzz.Mar 15, 1995 · N1520C · Destroyed NTSB LAX92LA269Accident · No injuriesLimited investigationFinal reportCessna 180 · Glendale, AZThe failure of the left main gear inner tube due to dry rot, and, the inadequate maintenance and preflight inspections conducted on the aircraft.Jun 30, 1992 · N2362C · Substantial damage NTSB LAX90LA344Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZThe pilot's failure to maintain adequate distance from a MD-80'S jet exhaust.Aug 2, 1990 · N9463C · Substantial damage NTSB LAX88LA115Accident · No injuriesLimited investigationFinal reportCessna 180A · Prescott, AZDuring the dual primary cross country flight, the student was making the approach and landing at Prescott. The CFI said that the approach and touchdown were normal, however, the aircraft began drifting to the right in a gradual turn as the aircraft slowed.…Feb 24, 1988 · N26AW · Substantial damage NTSB LAX87LA319Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Glendale, AZDuring landing roll, in crosswind conditions, the aircraft left the runway and went into a ditch. During a telephone interview the pilot stated that he lost control of the aircraft. The pilot was landing on runway 01 and winds were reported to be from 090…Aug 28, 1987 · N3164D · Substantial damage NTSB LAX87LA131Accident · No injuriesLimited investigationFinal reportCessna 180 · Oatman, AZAt the end of a cross-country flight, the pilot reported that while on final approach, the aircraft encountered moderate turbulence. The pilot set up for a full stall to land in a three point attitude. During the flare, a gust of wind from the right rear blew…Feb 28, 1987 · N4786B · Substantial damage NTSB LAX82DA277Accident · No injuriesFinal reportCessna 180 · Goodyear, AZThe left main landing gear of the aircraft broke off during a touch and go landing and the aircraft was damaged further on a subsequent landing. The weather was VMC and no flight plan was filed. The landing gear bolts failed in overload and showed no evidence…Jul 25, 1982 · N2223C · Substantial damage NTSB LAX79FUJ49Accident · No injuriesClosedCessna 180 · Scottsdale, AZMar 1, 1979 · N3861C · Substantial damage NTSB LAX78DUJ43Accident · No injuriesClosedCessna 180C · Phoenix, AZMar 25, 1978 · N9221C · Substantial damage NTSB LAX77DUJ39Accident · No injuriesClosedCessna 180 · St.Johns, AZMar 27, 1977 · N9303T · Substantial damage NTSB LAX76DUJ74Accident · No injuriesClosedCessna 180 · Wickenburg, AZMay 5, 1976 · N999DK · Substantial damage NTSB LAX76DUJ24Accident · No injuriesClosedCessna 180 · Page, AZAug 24, 1975 · N1750C · Substantial damage NTSB LAX76DUJ19Accident · No injuriesClosedCessna 180 · Glendale, AZAug 14, 1975 · N2952C · Substantial damage NTSB LAX71AL056Accident · No injuriesClosedCessna 180 · Grnd Canyon, AZFeb 21, 1971 · N9488C · Destroyed NTSB LAX70FUJ07Accident · Serious injuriesClosedCessna 180 · Casa Grande, AZFeb 1, 1970 · N4633B · Substantial damage NTSB LAX67D0303Accident · No injuriesClosedCessna 180 · Winslow, AZJan 14, 1967 · N9254C · Substantial damage NTSB LAX67D0116Accident · No injuriesClosedCessna 180 · Parker, AZSep 14, 1966 · N2821A · Substantial damage NTSB LAX67F0102Accident · No injuriesClosedCessna 180 · Tucson, AZSep 3, 1966 · N4913A · Substantial damage NTSB DEN66D0135Accident · No injuriesClosedCessna 180 · Pearce, AZSep 28, 1965 · N3633C · Substantial damage NTSB DEN66D0005Accident · No injuriesClosedCessna 180 · Casa Grande, AZMay 30, 1965 · N1789C · Substantial damage NTSB DEN65D0051Accident · No injuriesClosedCessna 180 · Gila Bend, AZMar 31, 1965 · N7742A · Substantial damage