# NTSB investigations: Cessna 180, 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 ATL03FA075](https://openairdocs.org/ntsb/ATL03FA075.md): Cessna 180 · Oxford, AL · Accident · 2 fatal · Field investigation · Final report · Apr 10, 2003 · N3166D · Destroyed
  > The pilot's continued VFR flight into IMC conditions and his failure to maintain obstacle clearance. A factor was low ceilings.
- [NTSB ATL82DA240](https://openairdocs.org/ntsb/ATL82DA240.md): Cessna 180 · Grand Bay, AL · Accident · Minor injuries · Final report · Aug 15, 1982 · N42GC · Substantial damage
  > Reportedly, the pilot was preparing to fly the aircraft, but the battery was dead, so he hand propped the engine to start it. According to the pilot's father, the aircraft was left unattended with the engine operating at idle speed. The pilot reported that he…
- [NTSB MIA76AM039](https://openairdocs.org/ntsb/MIA76AM039.md): Cessna 180 · Eufaula, AL · Accident · 2 fatal · Closed · Nov 2, 1975 · N9100C · Substantial damage
- [NTSB MIA71DKJ29](https://openairdocs.org/ntsb/MIA71DKJ29.md): Cessna 180 · Tuscaloosa, AL · Accident · No injuries · Closed · Nov 7, 1970 · N7640A · Substantial damage
- [NTSB MIA69D0075](https://openairdocs.org/ntsb/MIA69D0075.md): Cessna 180 · Alexander Cty, AL · Accident · No injuries · Closed · Jul 19, 1968 · N4971A · 2 aircraft · Minor damage
- [NTSB MIA68D0168](https://openairdocs.org/ntsb/MIA68D0168.md): Cessna 180 · Montgomery, AL · Accident · No injuries · Closed · Jun 25, 1967 · N2953A · Destroyed

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

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