# NTSB investigations: Cessna R182, AL

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA18FA118](https://openairdocs.org/ntsb/ERA18FA118.md): Cessna R182 · Ashville, AL · Accident · 1 fatal · Field investigation · Final report · Mar 28, 2018 · N3167C · Destroyed
  > Descent and impact with terrain for reasons that could not be determined.
- [NTSB MIA08FA026](https://openairdocs.org/ntsb/MIA08FA026.md): Cessna R182 · Woodland, AL · Accident · 2 fatal · Field investigation · Final report · Dec 8, 2007 · N2643C · Destroyed
  > The 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 ATL95LA176](https://openairdocs.org/ntsb/ATL95LA176.md): Cessna 182R · Tuscaloosa, AL · Accident · No injuries · Limited investigation · Final report · Sep 29, 1995 · N9119C · Substantial damage
  > Engine oil starvation for undetermined reasons, which resulted in a connecting rod cap failure.
- [NTSB ATL88LA095](https://openairdocs.org/ntsb/ATL88LA095.md): Cessna 182RG · Jacksonville, AL · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 1988 · N1703R · Substantial damage
  > The 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 ATL87LA224](https://openairdocs.org/ntsb/ATL87LA224.md): Cessna R182 · Calera, AL · Accident · No injuries · Limited investigation · Final report · Jul 25, 1987 · N737ZZ · Substantial damage
  > The 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 ATL83LA057](https://openairdocs.org/ntsb/ATL83LA057.md): Cessna 182B · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Dec 9, 1982 · N4718S · Substantial damage
  > The 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 ATL81FKJ21](https://openairdocs.org/ntsb/ATL81FKJ21.md): Cessna 182RG · Gadsden, AL · Accident · No injuries · Closed · May 25, 1981 · N4949S · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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" = '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
```

This list as a web page: https://openairdocs.org/ntsb?model=2072734&state=AL

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.