# NTSB investigations: Cessna 182K: In flight encounter with weather

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 DEN01FA045](https://openairdocs.org/ntsb/DEN01FA045.md): Cessna 182K · Elbert, CO · Accident · 2 fatal · Field investigation · Final report · Jan 25, 2001 · N2898R · Destroyed
  > the pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC), which resulted in an in-flight collision with terrain. Contributing factors to the accident were the low clouds, reduced visibilities due to fog, and the…
- [NTSB DEN00LA065](https://openairdocs.org/ntsb/DEN00LA065.md): Cessna 182K · Hanksville, UT · Accident · Serious injuries · Limited investigation · Final report · Mar 25, 2000 · N2722Q · Destroyed
  > The pilot inadvertently allowing the airplane to porpoise after landing hard, and inadvertently stalling the airplane after aborting the landing attempt. Factors were wind gusts, and the pilot failing to reconfigure the airplane (resetting the elevator trim…
- [NTSB MIA99LA141](https://openairdocs.org/ntsb/MIA99LA141.md): Cessna 182K · Picayune, MS · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 1999 · N2699Q · Substantial damage
  > The failure of the pilot to recover from the bounced landing resulting in collapse of the nose landing gear. A finding in the accident was the crosswind weather condition that existed at the time of the accident.
- [NTSB LAX93LA056](https://openairdocs.org/ntsb/LAX93LA056.md): Cessna 182K · Flagstaff, AZ · Accident · 2 fatal · Limited investigation · Final report · Nov 28, 1992 · N2622Q · Destroyed
  > The pilot's continued flight into instrument meteorological conditions and improper remedial action by descending into high terrain. Contributing to this accident were the prevailing cloud condition.

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

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

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