# NTSB investigations: Cessna 172, 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 NYC08CA303](https://openairdocs.org/ntsb/NYC08CA303.md): Cessna 172 · Newton, MS · Accident · No injuries · Data collection · Final report · Aug 30, 2008 · N6478E · Substantial damage
  > The pilot's failure to maintain aircraft control while landing.
- [NTSB ATL96LA050](https://openairdocs.org/ntsb/ATL96LA050.md): Cessna 172 · Jackson, MS · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1996 · N166F · Substantial damage
  > loss of engine power during takeoff for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB MIA89FA090](https://openairdocs.org/ntsb/MIA89FA090.md): Cessna 172 · Blue Mountain, MS · Accident · 2 fatal · Field investigation · Final report · Feb 20, 1989 · N3937F · Destroyed
  > The continuation of a VFR flight into night, instrument meteorological conditions and the spatial disorientation of the non-instrument rated pilot. Contributing to the accident were the adverse weather conditions and the overconfidence of the pilot.
- [NTSB ATL82DA097](https://openairdocs.org/ntsb/ATL82DA097.md): Cessna 172 · Brook Haven, MS · Accident · No injuries · Final report · Apr 8, 1982 · N6444B · Substantial damage
  > The pilot visually checked the fuel level before takeoff and estimated that he had 15 to 16 gallons remaining. Since the flight was planned for 30 to 45 minutes, no fuel was added. However, after flying for 30 to 35 minutes, the engine lost power. The pilot…
- [NTSB MIA78FA069](https://openairdocs.org/ntsb/MIA78FA069.md): Cessna 172 · Benoit, MS · Accident · 1 fatal · Closed · Apr 22, 1978 · N2304U · Destroyed
- [NTSB MIA75DKQ35](https://openairdocs.org/ntsb/MIA75DKQ35.md): Cessna 172 · Forest, MS · Accident · No injuries · Closed · Jun 14, 1975 · N4125F · Substantial damage
- [NTSB MIA73AM073](https://openairdocs.org/ntsb/MIA73AM073.md): Cessna 172 · Biloxi, MS · Accident · 1 fatal · Closed · Dec 12, 1972 · N8015B · Destroyed
- [NTSB MIA71FLT13](https://openairdocs.org/ntsb/MIA71FLT13.md): Cessna 172 · Holly Spgs, MS · Accident · No injuries · Closed · Apr 25, 1971 · N8181B · Substantial damage
- [NTSB MIA70F0076](https://openairdocs.org/ntsb/MIA70F0076.md): Cessna 172 · Kosciusko, MS · Accident · Minor injuries · Closed · Jul 17, 1969 · N5843A · Substantial damage
- [NTSB MIA68D0515](https://openairdocs.org/ntsb/MIA68D0515.md): Cessna 172 · Tutwiler, MS · Accident · No injuries · Closed · May 12, 1968 · N8229B · Substantial damage
- [NTSB MIA68F0294](https://openairdocs.org/ntsb/MIA68F0294.md): Cessna 172 · Cleveland, MS · Accident · Minor injuries · Closed · Nov 24, 1967 · N6321E · Substantial damage
- [NTSB MIA68F0295](https://openairdocs.org/ntsb/MIA68F0295.md): Cessna 172 · Yazoo City, MS · Accident · No injuries · Closed · Nov 18, 1967 · N4070F · Substantial damage
- [NTSB MIA67F0057](https://openairdocs.org/ntsb/MIA67F0057.md): Cessna 172 · Lamar, MS · Accident · Minor injuries · Closed · Jul 14, 1966 · N6744A · Substantial damage
- [NTSB MIA66D0040](https://openairdocs.org/ntsb/MIA66D0040.md): Cessna 172 · Wayside, MS · Accident · No injuries · Closed · Jun 18, 1965 · N6417B · Substantial damage
- [NTSB UNK64X3872](https://openairdocs.org/ntsb/UNK64X3872.md): Cessna 172 · Louisville, MS · Accident · No injuries · Closed · Sep 8, 1964 · N7991B · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=2072402&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.