# NTSB investigations: Cessna 182Q, 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 ERA19LA031](https://openairdocs.org/ntsb/ERA19LA031.md): Cessna 182 · Elba, AL · Accident · No injuries · Class 3 · Limited · Final report · Oct 28, 2018 · N20BK · Substantial damage
  > A leak in the pitot-static system for reasons that could not be determined based on the available information, which resulted in an airspeed indication error, an aborted takeoff, and a subsequent runway overrun.
- [NTSB MIA99FA027](https://openairdocs.org/ntsb/MIA99FA027.md): Cessna C-182Q · Piedmont, AL · Accident · 2 fatal · Field investigation · Final report · Nov 2, 1998 · N735JZ · Destroyed
  > The pilot's decision to continue the flight under visual flight rules into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.
- [NTSB MIA97LA236](https://openairdocs.org/ntsb/MIA97LA236.md): Cessna 182Q · Butler, AL · Accident · No injuries · Limited investigation · Final report · Aug 18, 1997 · N86TC · Substantial damage
  > The failure of the pilot to maintain directional control during a landing attempt after adding power to recover from a bounced landing.
- [NTSB ATL93LA096](https://openairdocs.org/ntsb/ATL93LA096.md): Cessna 182Q · Hartselle, AL · Accident · No injuries · Limited investigation · Final report · May 23, 1993 · N47GE · Substantial damage
  > The pilot's misjudgement of distance and speed during the approach and landing.
- [NTSB ATL82DA210](https://openairdocs.org/ntsb/ATL82DA210.md): Cessna 182 · Mobile, AL · Accident · Minor injuries · Final report · Jul 25, 1982 · N735RF · Substantial damage
  > The pilot experienced a power loss during takeoff and made an emergency landing in a soft soybean field. The aircraft nosed over after landing. Water was found in the fuel in the left tank and carburetor. The pilot had also found water inthe left tank during…

## 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 ('2072732'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072732&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.