NTSB investigations: Cessna 182H, AZ
16 cases on aircraft the registry lists as Cessna 182H. 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
| 1969 | 1 |
|---|---|
| 1970 | 2 |
| 1972 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 1993 | 2 |
| 2003 | 1 |
| 2007 | 1 |
| 2017 | 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\" = '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 ('2072718'))
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 ('2072718'))
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 GAA18CA051Accident · No injuriesData collectionFinal reportCessna 182H · Tucson, AZThe pilot’s failure to use taxiways shown on the airport diagrams and his subsequent failure to avoid a ditch.NTSB SEA07CA076Accident · No injuriesData collectionFinal reportCessna 182H · Phoenix, AZThe pilot's inadequate preflight inspection, resulting in fuel exhaustion and the loss of power. A factor was the sign.NTSB LAX03FA066Accident · 2 fatalField investigationFinal reportCessna 182H · Parker, AZfailure of both pilot's to see and avoid one another while maneuvering in the traffic pattern. A factor in the accident was the inability of the Cessna pilot to communicate on the CTAF frequency due to the limitations of his radios.NTSB LAX93LA366Accident · 1 fatalLimited investigationFinal reportCessna 182H · Flagstaff, AZthe pilot's sudden incapacation due to a fatal heart attack.NTSB LAX93LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lake Havasu, AZThe improper welding of the inboard boss by an unknown person resulting in a fatigue failure on the inboard boss. A factor related to the accident was the vehicle that was struck during the forced landing.NTSB LAX92LA059Accident · No injuriesLimited investigationFinal reportCessna 182H · Tucson, AZFuel exhaustion due to the pilot's inadequate preflight inspection, her failure to ensure that an adequate fuel supply was onboard and her decision not to refuel the aircraft prior to departure. Factors in the accident were: 1) the inoperative left fuel gage;…NTSB LAX91LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Phoenix, AZThe decision of the flight instructor to conduct a simulated power failure emergency in a manner which was inappropriate.NTSB LAX88LA026Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Willcox, AZThe plt reported that the takeoff ground roll was unusually long. After liftoff the acft stayed in ground effect until just before the end of the rwy then climbed to aprx 100 ft. the plt landed in a soft field. During the landing roll the acft nosed over.…NTSB LAX86LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Lake Havasucity, AZOn January 25, 1986 a Cessna 182 collided with the runway surface after the nose wheel collapsed on runway 5 at lake havasu city airport, Arizona. VMC prevailed at the time with the UNICOM reported winds from 270 degrees at 17 knots and gusting. The…NTSB LAX81FA061Accident · 2 fatalClosedPiper PA-28 · Tucson, AZNTSB LAX77FA035Accident · 1 fatalClosedCessna 182H · Tuscon, AZNTSB LAX75DUJ52Accident · No injuriesClosedCessna 182 · Bullhead City, AZNTSB LAX72FUJ83Accident · No injuriesClosedCessna 182H · Phoenix, AZNTSB LAX70DUJ45Accident · Minor injuriesClosedCessna 182 · Kayenta, AZNTSB LAX70AL069Accident · 3 fatalClosedCessna 182H · Young, AZNTSB LAX70D0239Accident · No injuriesClosedCessna 182 · Sedona, AZ