NTSB investigations: Cessna 182J, AZ
15 cases on aircraft the registry lists as Cessna 182J. 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
| 1966 | 2 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1982 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 2003 | 1 |
| 2021 | 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 ('2072722'))
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 ('2072722'))
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 WPR21LA177Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182J · Sedona, AZThe pilot’s failure to maintain directional control during landing with a crosswind, which resulted in a collision with a fuel truck and a parked airplane.NTSB LAX03CA272Accident · No injuriesData collectionFinal reportCessna 182J · Marble Canyon, AZthe failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.NTSB LAX86LA162Accident · No injuriesLimited investigationFinal reportCessna 182J · Saint Johns, AZThe plt said his wx briefing indcd VFR conds along the route with ocnl thunderstorm (tstm) activity that might require diversion. As he was apchg the st Johns arpt, the plt saw tstms & ovrcst clds ahead & decided to land & wait for the wx to improve. The…NTSB LAX83LA118Accident · No injuriesLimited investigationFinal reportCessna 182J · Peoria, AZThe acft collided with a sign and a wall during an attempted go-around after an overrun. The pilot was practicing and had made 2 short field landings on the 3rd approach he forgot to lower flaps. His approach was fast and long and he landed too FAR down the…NTSB LAX82DA243Accident · No injuriesFinal reportCessna 182J · Deer Valley, AZWhile climbing through about 6500 ft, a loud bang was heard and the pilot saw the engine cowling buckle. About 10 seconds later, the engine ceased to operate. The pilot declared an emergency and landed on an uncontrolled airport. After landing, an examination…NTSB LAX78FA003Accident · 1 fatalClosedCessna 182J · Buckeye, AZNTSB LAX78FUJ05Accident · No injuriesClosedCessna 182J · Phoenix, AZNTSB LAX76AL064Accident · 1 fatalClosedCessna 182J · Gila Bend, AZNTSB LAX75DUJ59Accident · No injuriesClosedCessna 182J · Tucson, AZNTSB LAX73DUJ05Accident · No injuriesClosedCessna 182 · Flagstaff, AZNTSB LAX72DUJ11Accident · No injuriesClosedCessna 182J · Nogales, AZNTSB LAX68D0405Accident · No injuriesClosedCessna 182 · Flagstaff, AZNTSB LAX67F0413Accident · No injuriesClosedCessna 182 · Phoenix, AZNTSB LAX67F0015Accident · Serious injuriesClosedCessna 182J · Navajo, AZNTSB DEN66D0290Accident · No injuriesClosedCessna 182 · Douglas, AZ