# NTSB investigations: Franklin 4AC199D&E series, 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 MIA83LA107](https://openairdocs.org/ntsb/MIA83LA107.md): Stinson 10A · Miami, FL · Accident · No injuries · Limited investigation · Final report · Mar 30, 1983 · N39431 · Destroyed
  > The owner of the acft said that the plt was negotiating to buy the acft but conducted this flt without proper authority in the acft that was not airworthy. The plt had landed the acft earlier in an emergency situation declaring a loss of oil pressure and RPM.…
- [NTSB MIA83LA097](https://openairdocs.org/ntsb/MIA83LA097.md): Stinson 10A · Defuniak Spring, FL · Accident · No injuries · Limited investigation · Final report · Mar 19, 1983 · N32260 · Substantial damage
  > The engine failed in cruise at 4500 ft MSL. The weather was clear and the pilot could see the airport but did not try for it because of the intervening town. During the landing over wires the landing gear and wings were damaged. The pilotreported that there…
- [NTSB MIA77FLD63](https://openairdocs.org/ntsb/MIA77FLD63.md): Baby GR LKS BGL B1 · Lakeland, FL · Accident · Minor injuries · Closed · May 30, 1977 · N65165 · Substantial damage
- [NTSB MIA71DKT38](https://openairdocs.org/ntsb/MIA71DKT38.md): Stinson 10A · Ft Lauderdale, FL · Accident · No injuries · Closed · Feb 15, 1971 · N34676 · 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.engine_model_code IN ('27009'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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