# NTSB investigations: Cessna 182E, MS

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 MIA99LA166](https://openairdocs.org/ntsb/MIA99LA166.md): Cessna 182E · Rolling Fork, MS · Accident · No injuries · Limited investigation · Final report · Jun 6, 1999 · N9267X · Substantial damage
  > Improper torqueing of the connecting rod bolts which resulted in the bolts being loose and rubbing in the dowel area which resulted in fatigue emanation and cracking and separation of the number 3 connecting rod after bolt failure.
- [NTSB MIA73FRQ23](https://openairdocs.org/ntsb/MIA73FRQ23.md): Cessna 182E · Mccomb, MS · Accident · Minor injuries · Closed · Dec 26, 1972 · N3288Y · Destroyed
- [NTSB MIA65F0103](https://openairdocs.org/ntsb/MIA65F0103.md): Cessna 182E · Cleveland, MS · Accident · No injuries · Closed · May 3, 1965 · N9270X · Substantial damage
- [NTSB UNK65X0948](https://openairdocs.org/ntsb/UNK65X0948.md): Cessna 182 · Belzoni, MS · Accident · Serious injuries · Closed · Dec 7, 1964 · N3062Y · 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" = 'MS' 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 ('2072712'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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