# NTSB investigations: Franklin 6A4150 series, 2005

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 LAX05CA246](https://openairdocs.org/ntsb/LAX05CA246.md): Stinson 108 · Hesperia, CA · Accident · Minor injuries · Data collection · Final report · Jul 26, 2005 · N97492 · Substantial damage
  > the pilot's failure to maintain directional control during landing rollout.
- [NTSB LAX05LA220](https://openairdocs.org/ntsb/LAX05LA220.md): Stinson 108-2 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Jun 29, 2005 · N8000K · Substantial damage
  > the pilot's failure to maintain directional control during the landing rollout.
- [NTSB LAX05FA184](https://openairdocs.org/ntsb/LAX05FA184.md): Bellanca 14-13-3 · Caliente, CA · Accident · 2 fatal · Field investigation · Final report · May 20, 2005 · N6511N · Destroyed
  > The pilot's inadvertent encounter with instrument meteorological conditions and failure to maintain adequate terrain clearance, which resulted in controlled flight into the terrain. Contributing factors were the pilots' delayed decision to reverse course, the…

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

This list as a web page: https://openairdocs.org/ntsb?engine=27024&year=2005

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