NTSB investigations: Cessna 182F, AZ

13 cases on aircraft the registry lists as Cessna 182F. 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

19642026

NTSB investigations: Cessna 182F, AZ per year, 1964–2026: 13 cases
1964	1
1965	1
1967	1
1968	1
1969	1
1972	1
1979	2
1987	2
1991	1
1993	1
2019	1

Where

Open the map

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 ('2072714')) 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 ('2072714'))
  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 ('2072714'))
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 WPR20FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Goodyear, AZThe pilot’s failure to maintain clearance from power lines due to his impairment from cannabis.Dec 22, 2019 · N3371U · Substantial damage NTSB LAX93LA156Accident · No injuriesLimited investigationFinal reportCessna 182F · Chandler, AZThe pilot's inadequate weather evaluation resulting in an inadvertent encounter with gusty wind conditions while taxiing.Mar 19, 1993 · N3211U · Substantial damage NTSB LAX91FA173Accident · 4 fatalField investigationFinal reportCessna 182F · Young, AZThe pilot's inadequate in-flight decision to continue VFR flight into instrument meteorological conditions and the loss of control of the airplane resulting in an inflight collision with terrain.Mar 22, 1991 · N3458U · Destroyed NTSB LAX87LA263Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Keams Canyon, AZDuring a business flight to a private dirt strip, while on final approach the plt was distracted for a few seconds. When his attention was back on the acft, it had drifted east of the strip. The plt applied pwr, however, he stated that the engine did not…Jul 10, 1987 · N3598U · Substantial damage NTSB LAX87LA074Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Wickenburg, AZDuring a pleasure cross-country flight, the engine quit approximately 2 miles west of the Wickenburg airport and the pilot made a forced landing off the arpt in a field. Examination of the aircraft revealed that the fuel selector was positioned to the right…Jan 4, 1987 · N3587U · Substantial damage NTSB LAX79FUK01Accident · Serious injuriesClosedCessna 182F · Munds Park, AZAug 12, 1979 · N3529U · Substantial damage NTSB LAX79DUJ90Accident · No injuriesClosedCessna 182 · Mesa, AZJun 1, 1979 · N3244U · Minor damage NTSB LAX73DUJ10Accident · No injuriesClosedCessna 182 · Mesa, AZJul 12, 1972 · N3392U · Substantial damage NTSB LAX69D0340Accident · No injuriesClosedCessna 182 · Flagstaff, AZApr 24, 1969 · N3106U · Substantial damage NTSB LAX69D0067Accident · No injuriesClosedCessna 182 · Lake Havasu, AZJun 29, 1968 · N3121U · Substantial damage NTSB LAX68A0045Accident · 5 fatalClosedCessna 182 · Grand Canyon, AZNov 1, 1967 · N3555Y · Destroyed NTSB DEN66D0167Accident · No injuriesClosedCessna 182F · Casa Grande, AZOct 29, 1965 · N3536Y · Substantial damage NTSB UNK64X2571Accident · No injuriesClosedCessna 182 · Tucson, AZJun 29, 1964 · N3616U · Substantial damage