NTSB investigations: Cessna R182, AL
7 cases on aircraft the registry lists as Cessna R182. 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
| 1981 | 1 |
|---|---|
| 1982 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 2007 | 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\" = 'AL' 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 ('2072734'))
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" = 'AL' 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 ('2072734'))
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 ERA18FA118Accident · 1 fatalField investigationFinal reportCessna R182 · Ashville, ALDescent and impact with terrain for reasons that could not be determined.NTSB MIA08FA026Accident · 2 fatalField investigationFinal reportCessna R182 · Woodland, ALThe flight instructor’s failure to maintain control of the airplane while attempting to conduct visual flight in reduced visibility conditions at night. Factors contributing to the accident include the flight instructor’s inadequate preflight planning, and…NTSB ATL95LA176Accident · No injuriesLimited investigationFinal reportCessna 182R · Tuscaloosa, ALEngine oil starvation for undetermined reasons, which resulted in a connecting rod cap failure.NTSB ATL88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, ALThe pilot had just purchased the aircraft and it had less than one hour on the overhauled engine. The pilot was at 1500 feet when the engine quit. On final approach to the emergency landing area, the aircraft collided with trees. The engine examination…NTSB ATL87LA224Accident · No injuriesLimited investigationFinal reportCessna R182 · Calera, ALThe airplane collided with trees during a forced ldg attempt. The plt reported that he observed the fuel gauges indicating near empty shortly after departure. As he executed a 'steep' 180 deg turn back toward the arpt, the engine sputtered and 'quit'. During…NTSB ATL83LA057Accident · No injuriesLimited investigationFinal reportCessna 182B · Huntsville, ALThe aircraft collided with trees during a landing approach in instrument meeorological conditions on a dark night. A VFR flight plan was filed. The aircraft was damaged in the collision but the pilot managed to continue the approach and land. No injuries were…NTSB ATL81FKJ21Accident · No injuriesClosedCessna 182RG · Gadsden, AL