NTSB investigations: Cessna 182A, GA
13 cases on aircraft the registry lists as Cessna 182A. 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 | 3 |
|---|---|
| 1966 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1977 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2018 | 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 ('2072704'))
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 ('2072704'))
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 ERA18FA231Accident · 4 fatalField investigationFinal reportCessna 182 · Swainsboro, GAThe total loss of engine power for reasons that could not be determined based on available information.NTSB ATL98LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Waycross, GAa loss of engine power for undetermined reasons.NTSB ATL91LA045Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAAn electrical short related to the alternator from an undetermined source.NTSB ATL90LA103Accident · No injuriesLimited investigationFinal reportCessna 182 · Griffin, GAImproper flare by the pilot.NTSB ATL87LA217Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAPIC dpted, intending to fly 0.5 hours on tach. Acft had 11 gals of fuel, 5 in left tank & 6 in right tank. PIC made left climbing spiral to 9000 feet and maneuvered in left turn around airport. On a long staight in, final appch eng quit at about 500 feet AGL.…NTSB MIA77FA045Accident · 2 fatalClosedCessna 182A · Ochlocknee, GANTSB MIA69F0452Accident · No injuriesClosedCessna 182 · Norcross, GANTSB MIA69D0160Accident · Minor injuriesClosedCessna 182 · Toccoa, GANTSB MIA67F0246Accident · No injuriesClosedCessna 182A · Cairo, GANTSB MIA67F0048Accident · Minor injuriesClosedCessna 182A · Ocilla, GANTSB MIA66F0075Accident · Minor injuriesClosedCessna 182 · Stockbridge, GANTSB MIA66F0073Accident · Minor injuriesClosedCessna 182A · St Simons Is, GANTSB MIA66F0001Accident · No injuriesClosedCessna 182A · Brunswick, GA