# NTSB investigations: Cessna T207A, 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 MIA05LA063](https://openairdocs.org/ntsb/MIA05LA063.md): Cessna T207A · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Feb 23, 2005 · N207CC · Substantial damage
  > The pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation and subsequent impact with an embankment during an emergency landing.
- [NTSB MIA84FA056](https://openairdocs.org/ntsb/MIA84FA056.md): Cessna T207A · Zolfo Springs, FL · Accident · 2 fatal · Field investigation · Final report · Jan 7, 1984 · N73180 · Destroyed
  > The acft collided with trees and the ground during takeoff in IMC weather. The visibility was zero due to ground fog. There were no known witnesses to the accident but there was evidence of a collision with a 60 ft high tree at the end of the 3000 ft rwy. It…
- [NTSB MIA83LA150](https://openairdocs.org/ntsb/MIA83LA150.md): Cessna 207 · Sebring, FL · Accident · No injuries · Limited investigation · Final report · May 31, 1983 · N75773 · Substantial damage
  > According to the plt, he heard a 'thump' when he was taking off from orlando west arpt, but attributed it to the grass strip. When he landed at Sebring arpt, he heard a scraping sound as he lowered the nose & elected to go around. He decided the nosewheel was…

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

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