# NTSB investigations: Cessna 182B, 1997

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 ANC98LA002](https://openairdocs.org/ntsb/ANC98LA002.md): Cessna 182B · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Oct 12, 1997 · N7269E · Substantial damage
  > The pilot misjudging the touchdown point, which resulted in landing short of the sand bar and the airplane nosing over.
- [NTSB MIA97LA241](https://openairdocs.org/ntsb/MIA97LA241.md): Cessna 182B · Paris, TN · Accident · No injuries · Limited investigation · Final report · Sep 7, 1997 · N2794G · Substantial damage
  > Temporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.
- [NTSB LAX97LA316](https://openairdocs.org/ntsb/LAX97LA316.md): Cessna 182B · Madera, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1997 · N81MK · Substantial damage
  > fuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.
- [NTSB NYC97LA135](https://openairdocs.org/ntsb/NYC97LA135.md): Cessna 182B · Medford, NJ · Accident · No injuries · Limited investigation · Final report · Jul 6, 1997 · N166KM · Destroyed
  > An inflight engine fire of undetermined origin.
- [NTSB MIA97LA127](https://openairdocs.org/ntsb/MIA97LA127.md): Cessna 182B · Tullahoma, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 1997 · N2515G · Substantial damage
  > Fuel exhaustion for undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the failure of the pilot to divert to an alternate airport while en route after recognizing that the fuel consumed was…

## 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") = 1997
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072706'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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