# NTSB investigations: Franklin 4ACG199H3

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 ERA13LA366](https://openairdocs.org/ntsb/ERA13LA366.md): Interstate S-1B1 · Lititz, PA · Accident · No injuries · Limited investigation · Final report · Aug 17, 2013 · N46336 · Substantial damage
  > The pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…
- [NTSB ANC02LA026](https://openairdocs.org/ntsb/ANC02LA026.md): Interstate S-1B1 · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Mar 29, 2002 · N48027 · Substantial damage
  > The separation of the exhaust system stack from the heat exchanger. A factor associated with the accident was an engine compartment fire.
- [NTSB ANC99LA030](https://openairdocs.org/ntsb/ANC99LA030.md): Interstate S-1B1 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1999 · N48027 · Substantial damage
  > Fuel starvation resulting from the pilot not understanding the fuel system procedures, and selecting the improper fuel selector position.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27010'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=27010

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