# NTSB investigations: Cessna 172F, 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 ATL01LA026](https://openairdocs.org/ntsb/ATL01LA026.md): Cessna 172 F · Greenwood, MS · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 2001 · N7882U · Destroyed
  > An in-flight fire for undetermined reasons. Finding: A factor is the maintenance modification was performed by company personnel prior to the flight.
- [NTSB ATL86LA022](https://openairdocs.org/ntsb/ATL86LA022.md): Cessna 172F · Hazelhurst, MS · Accident · No injuries · Limited investigation · Final report · Nov 8, 1985 · N8852U · Substantial damage
  > During cruise flight the engine experienced a loss of power and the pilot applied carb heat. The engine operated normally with the carb heat on and when it was turned off the engine again ran rough. The pilot again turned on the carb heat and the engine ran…
- [NTSB ATL84LLT05](https://openairdocs.org/ntsb/ATL84LLT05.md): Cessna C-172F · Pascagoula, MS · Accident · Minor injuries · Final report · Mar 3, 1984 · N8662U · Substantial damage
  > The plt ditched the acft after a complete loss of power. The acft fuel system was damaged during the recovery process and a complete evaluation could not be made.
- [NTSB MIA71FKQ17](https://openairdocs.org/ntsb/MIA71FKQ17.md): Cessna 172F · Valley Park, MS · Accident · No injuries · Closed · Oct 3, 1970 · N8594U · Substantial damage
- [NTSB MIA67F0379](https://openairdocs.org/ntsb/MIA67F0379.md): Cessna 172F · Port Gibson, MS · Accident · No injuries · Closed · Jan 30, 1967 · N8594U · Substantial damage
- [NTSB MIA66F0487](https://openairdocs.org/ntsb/MIA66F0487.md): Cessna 172 · Tchula, MS · Accident · No injuries · Closed · Apr 5, 1966 · N5483R · Substantial damage
- [NTSB MIA66D0239](https://openairdocs.org/ntsb/MIA66D0239.md): Cessna 172 · Tchula, MS · Accident · No injuries · Closed · Aug 29, 1965 · N7987U · 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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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