# NTSB investigations: Cessna 172I, 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 ERA10CA078](https://openairdocs.org/ntsb/ERA10CA078.md): Cessna 172 · Panancea, FL · Accident · No injuries · Data collection · Final report · Nov 22, 2009 · N35638 · Substantial damage
  > The pilot's failure to maintain directional control during the landing rollout.
- [NTSB MIA92LA176](https://openairdocs.org/ntsb/MIA92LA176.md): Cessna 172I · Navarre, FL · Accident · No injuries · Limited investigation · Final report · Sep 7, 1992 · N35302 · Substantial damage
  > Failure of the pilot-in-command to maintain directional control after touchdown during the forced landing following partial loss of engine power during cruise flight. Contributing to the accident was the divertion of attention of the pilot in command to the…
- [NTSB MIA83LA229](https://openairdocs.org/ntsb/MIA83LA229.md): Cessna 172I · Miami, FL · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 1983 · N8366L · Minor damage
  > The acft landed at aprx 0215 EDT. After arriving at the ramp, the plt's wife exited from the acft thru the right door. She then walked in front of the acft & was struck by the propeller. The plt's wife was fatally injured & he was taken to a hospital & was…
- [NTSB MIA79DLA09](https://openairdocs.org/ntsb/MIA79DLA09.md): Cessna 172 · Live Oak, FL · Accident · No injuries · Closed · Nov 13, 1978 · N8459L · Substantial damage
- [NTSB MIA78DLD42](https://openairdocs.org/ntsb/MIA78DLD42.md): Cessna 172 · Avon Park, FL · Accident · Minor injuries · Closed · May 6, 1978 · N8411L · Destroyed
- [NTSB MIA71DLD53](https://openairdocs.org/ntsb/MIA71DLD53.md): Cessna 172I · Daytona Beach, FL · Accident · Minor injuries · Closed · Mar 3, 1971 · N35401 · Substantial damage
- [NTSB MIA71DLD37](https://openairdocs.org/ntsb/MIA71DLD37.md): Cessna 172I · N.Smyrna Bch, FL · Accident · No injuries · Closed · Nov 22, 1970 · N35562 · Substantial damage
- [NTSB MIA71FLD29](https://openairdocs.org/ntsb/MIA71FLD29.md): Cessna 172I · Daytona Beach, FL · Accident · Minor injuries · Closed · Oct 21, 1970 · N46057 · Substantial damage
- [NTSB MIA70DLD21](https://openairdocs.org/ntsb/MIA70DLD21.md): Cessna 172 · Daytona Beach, FL · Accident · No injuries · Closed · May 13, 1970 · N46051 · Substantial damage
- [NTSB MIA70DKT17](https://openairdocs.org/ntsb/MIA70DKT17.md): Cessna 172 · Sanibel, FL · Accident · Minor injuries · Closed · Apr 18, 1970 · N35509 · Substantial damage
- [NTSB MIA70AM061](https://openairdocs.org/ntsb/MIA70AM061.md): Cessna 172I · Merritt Islnd, FL · Accident · 1 fatal · Closed · Jan 20, 1970 · N35403 · Destroyed
- [NTSB MIA69D0405](https://openairdocs.org/ntsb/MIA69D0405.md): Cessna 172 · Winter Haven, FL · Accident · No injuries · Closed · Mar 2, 1969 · N46057 · Substantial damage
- [NTSB MIA67F0353](https://openairdocs.org/ntsb/MIA67F0353.md): Cessna 150 · Opa Locka, FL · Accident · No injuries · Closed · Jan 24, 1967 · N35375 · 2 aircraft · 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 ('2072426'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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