# NTSB investigations: Cessna 182E: In flight collision with object

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 DEN06FA043](https://openairdocs.org/ntsb/DEN06FA043.md): Cessna 182E · Austin, CO · Accident · 3 fatal · Field investigation · Final report · Feb 23, 2006 · N9298X · Destroyed
  > the pilot's failure to maintain clearance from the transmission wire resulting in the airplane's outboard wing portion to be severed, and the subsequent loss of control and ground impact. Factors contributing to the accident were the pilot's impairment from…
- [NTSB CHI99FA222](https://openairdocs.org/ntsb/CHI99FA222.md): Cessna 182E · Menominee Falls, WI · Accident · 1 fatal · Field investigation · Final report · Jul 9, 1999 · N2899Y · Destroyed
  > the pilots failure to maintain adequate clearance. A factor was the static wire.
- [NTSB SEA96LA195](https://openairdocs.org/ntsb/SEA96LA195.md): Cessna 182E · Grangeville, ID · Accident · No injuries · Limited investigation · Final report · Aug 18, 1996 · N3270Y · Substantial damage
  > failure of the pilot to maintain proper runway alignment and clearance from a fence post during landing. Factors relating to the accident were: an animal (deer) on the approach end of the runway, an encounter with a downdraft, and a fence post near the edge…
- [NTSB ATL90FA132](https://openairdocs.org/ntsb/ATL90FA132.md): Cessna 182E · Newland, NC · Accident · 1 fatal · Field investigation · Final report · Jun 16, 1990 · N9244X · Destroyed
  > Attempted VFR flight into instrument meteorological conditions.
- [NTSB NYC82FGT13](https://openairdocs.org/ntsb/NYC82FGT13.md): Cessna 182 · Catawissa, PA · Accident · 1 fatal · Final report · Apr 11, 1982 · N9227X · Destroyed
  > Reportedly, the pilot departed the airport to accumulate time on a overhauled engine. The airport manager stated that shortly after takeoff, the pilot called on the UNICOM frequency that the engine and aircraft worked like new and he was completely satisfied…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072712')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072712&occurrence=220

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