# NTSB investigations: Cessna 172D, FL

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 ERA17LA234](https://openairdocs.org/ntsb/ERA17LA234.md): Cessna 172 · Cape Coral, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2017 · N2492U · Substantial damage
  > A total loss of engine power due to fuel contamination with water and the pilot's inadequate preflight inspection that detected, but did not fully resolve, the water contamination of the fuel system.
- [NTSB MIA96FA089](https://openairdocs.org/ntsb/MIA96FA089.md): Cessna 172D · Hawthorne, FL · Accident · 2 fatal · Field investigation · Final report · Mar 2, 1996 · N2456U · Destroyed
  > the pilot's failure to maintain the proper glidepath during an instrument approach.
- [NTSB MIA95LA032](https://openairdocs.org/ntsb/MIA95LA032.md): Cessna 172D · Miami, FL · Accident · 1 fatal · Limited investigation · Final report · Dec 3, 1994 · N707PP · No damage
  > The passenger committed suicide.
- [NTSB MIA86FA135](https://openairdocs.org/ntsb/MIA86FA135.md): Cessna 172D · St. Petersburg, FL · Accident · Serious injuries · Field investigation · Final report · Apr 26, 1986 · N2321U · Substantial damage
  > While on second attempt to pick up an aerial advertising banner the flight captured the banner and as it pulled up to climb out the pilot stated the aircraft would not climb. The aircraft then stalled and crashed to the ground in a nose low left wing low…
- [NTSB MIA76DLA24](https://openairdocs.org/ntsb/MIA76DLA24.md): Cessna 172 · Keystone Hts, FL · Accident · Minor injuries · Closed · Nov 24, 1975 · N2847U · Substantial damage
- [NTSB MIA76FLD88](https://openairdocs.org/ntsb/MIA76FLD88.md): Cessna 172D · Tampa Bay, FL · Accident · 1 fatal · Closed · Apr 27, 1975 · N2844U · Destroyed
- [NTSB MIA73DLA35](https://openairdocs.org/ntsb/MIA73DLA35.md): Cessna 172D · Sunnyside Bch, FL · Accident · No injuries · Closed · May 5, 1973 · N2500X · Substantial damage
- [NTSB MIA71DLD08](https://openairdocs.org/ntsb/MIA71DLD08.md): Cessna 172D · Bradenton, FL · Accident · No injuries · Closed · Aug 8, 1970 · N2740U · Substantial damage
- [NTSB MIA70FLA21](https://openairdocs.org/ntsb/MIA70FLA21.md): Cessna 172C · Jacksonville, FL · Accident · No injuries · Closed · May 22, 1970 · N2063Y · Substantial damage
- [NTSB MIA68D0156](https://openairdocs.org/ntsb/MIA68D0156.md): Cessna 172 · Vero Beach, FL · Accident · No injuries · Closed · Aug 21, 1967 · N2494U · Substantial damage
- [NTSB MIA67D0359](https://openairdocs.org/ntsb/MIA67D0359.md): Cessna 172 · Sanford, FL · Accident · Minor injuries · Closed · Jan 7, 1967 · N2611U · Substantial damage
- [NTSB MIA67D0200](https://openairdocs.org/ntsb/MIA67D0200.md): Cessna 172 · Mulberry, FL · Accident · No injuries · Closed · Sep 24, 1966 · N2523U · Substantial damage
- [NTSB MIA66F0012](https://openairdocs.org/ntsb/MIA66F0012.md): Cessna 172 · Tampa, FL · Accident · No injuries · Closed · Apr 7, 1965 · N2372U · 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" = 'FL' 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 ('2072410'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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