NTSB investigations: Cessna 182G, AZ
14 cases on aircraft the registry lists as Cessna 182G. 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
| 1965 | 1 |
|---|---|
| 1967 | 2 |
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2022 | 1 |
| 2023 | 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 ('2072716'))
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 ('2072716'))
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 WPR24LA042Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182G · Casa Grande, AZThe loss of engine power during landing for undetermined reasons.NTSB WPR22LA165AccidentClass 4 · LimitedFinal reportCessna 182G · Eloy, AZThe unoccupied airplanes exceedance of the critical angle of attack which resulted in a stall, subsequent inverted spin, and impact with terrain.NTSB LAX01LA300Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Cottonwood, AZThe pilot's failure to obtain/maintain a proper descent rate, as well as prematurely starting his decent during nighttime operations, subsequently colliding with 60-foot power lines 4 miles from the airport.NTSB LAX00FA346Accident · 2 fatalField investigationFinal reportCessna 182G · Tuba City, AZthe pilot's inadvertent descent into terrain on the downwind leg for landing. Contributing to the accident was the dark night and sparse population.NTSB LAX91LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Portal, AZFailure of the pilot to maintain proper altitude.NTSB LAX85LA234Accident · No injuriesLimited investigationFinal reportCessna 182 · Parker, AZThe pilot stated that he encountered shifting winds on landing at his destination airport and that turbulence was severe. There is no record of a weather briefing prior to departure.NTSB LAX80FA059Accident · 4 fatalClosedCessna 182G · Grand Canyon, AZNTSB LAX74DUJ76Accident · No injuriesClosedCessna 182 · Bagdad, AZNTSB LAX73AL039Accident · 1 fatalClosedCessna 182G · Quartzsite, AZNTSB LAX71AL059Accident · 2 fatalClosedCessna 182 · Jerome, AZNTSB LAX69D0275Accident · No injuriesClosedCessna 182 · Sells, AZNTSB LAX68D0162Accident · Minor injuriesClosedCessna 182 · Clifton, AZNTSB LAX67A0111Accident · 4 fatalClosedCessna 182G · Phoenix, AZNTSB DEN65D0050Accident · No injuriesClosedCessna 182 · Tucson, AZ