NTSB investigations: Cessna 182M, GA
8 cases on aircraft the registry lists as Cessna 182M. 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
| 1971 | 2 |
|---|---|
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 2002 | 1 |
| 2006 | 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 ('2072728'))
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 ('2072728'))
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 ATL06LA101Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Milledgeville, GAThe improper fabrication of the oil pressure gauge line by maintenance personnel, which resulted in a loss of engine oil and total loss of engine power during cruise flight.NTSB ATL02LA157Accident · No injuriesLimited investigationFinal reportCessna 182M · Brunswick, GAThe pilot's failure to maintain directional control during landing roll, which resulted in an on-ground collision with a runway sign. A factor was the pilot's inadvertent application of the right brake.NTSB ATL84LA081Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Dalton, GAPlt received a wx briefing aprx 1 hr prior to flt during which '...a chance of light icing' was forecast. Aprx 30 mins after takeoff at 6000 ft MSL light rain was encountered. The plt stated that a small amount of ice began to form on the strut and he…NTSB MIA78DKG46Accident · Serious injuriesClosedCessna 182 · Atlanta, GANTSB MIA77FKG36Accident · No injuriesClosedCessna 182M · Hampton, GANTSB MIA76FKG91Accident · No injuriesClosedCessna 182M · Hampton, GANTSB MIA71DKH01Accident · No injuriesClosedCessna 182 · Stone Mtn, GANTSB MIA71DKG73Accident · No injuriesClosedCessna 182 · Fort Valley, GA