# NTSB investigations: Cessna 182A, 2006

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 CHI06CA203](https://openairdocs.org/ntsb/CHI06CA203.md): Cessna 182 · Napoleon, MI · Accident · No injuries · Data collection · Final report · Jul 18, 2006 · N6155B · Substantial damage
  > The pilot failed to perform a go-around which resulted in landing long on the airstrip. Factors associated with the accident were the tailwind, the pilot's selection of runway direction, the fence posts, the fence, and the trees which were contacted.
- [NTSB NYC06CA119](https://openairdocs.org/ntsb/NYC06CA119.md): Cessna 182A · Plattsburgh, NY · Accident · Serious injuries · Data collection · Final report · Jul 15, 2006 · N2186G · Substantial damage
  > The pilot's failure to utilize carburetor heat, which resulted in the formation of carburetor ice and subsequent engine failure. Factors included the carburetor icing conditions and trees in the forced landing area.
- [NTSB CHI06CA176](https://openairdocs.org/ntsb/CHI06CA176.md): Cessna 182A · Jackson, MI · Accident · Minor injuries · Data collection · Final report · Jul 6, 2006 · N4780D · Substantial damage
  > The pilot's improper preflight planning which led to the exhaustion of the fuel supply during the flight. The overload failure of the nose landing gear was a factor.

## 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 year(c."eventDate") = 2006
  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
```

This list as a web page: https://openairdocs.org/ntsb?model=2072704&year=2006

---
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.