NTSB investigations: Cessna 182Q, GA
12 cases on aircraft the registry lists as Cessna 182Q. 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
| 1977 | 1 |
|---|---|
| 1979 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2025 | 1 |
| 2026 | 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\" = 'GA' 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 ('2072732'))
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" = 'GA' 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 ('2072732'))
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 ERA27LA025Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182Q · Ball Ground, GANTSB ERA25LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Nahunta, GAThe pilot’s decision to fly an unairworthy airplane, which resulted in fire due to an unsecured carburetor bowl drain plug.NTSB ATL03LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182 · LaFayette, GAIn flight loss of engine power for undetermined reasons.NTSB ATL03FA017Accident · 1 fatalField investigationFinal reportCessna 182Q · Cornelia, GAThe pilot's failure to follow IFR approach procedures and continue below the minimum descent altitude, which resulted in an inflight collision with trees, and the ground. A factor was the pilot's impairment from a prescription drug.NTSB MIA01LA215Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Savannah, GAThe delay of the pilot to perform a go-around following a bounced landing and porpoise, and failure of the pilot to maintain directional control resulting in the airplane departing the runway and colliding with a berm.NTSB ATL01LA051Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ball Ground, GAThe student pilot's failure to maintain directional control during landing roll. A factor is the ditch.NTSB MIA96LA022Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Snellville, GAThe pilot's failure to attain the proper touchdown point on landing. The sunglare and wet grass were factors.NTSB ATL91LA057Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brunswick, GAA hidden hole in the runway surface, which was contacted by the nose wheel during the landing roll.NTSB ATL90LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cumming, GAA lack of fluid in the brake system and an inadequate annual inspection.NTSB ATL86LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Stone Mountain, GAAfter an IFR flight into his home area, pilot changed dest to land on his home airport. Made a VFR pattern to land on rwy 17. Plt stated that he flared too late, hit the runway, bounced real high and went around. Made a soft field ldg and when tying acft down…NTSB MIA79DKG71Accident · No injuriesClosedCessna 182Q · Brooklet, GANTSB MIA78FKG06Accident · Minor injuriesClosedCessna 182Q · Albany, GA