# NTSB investigations: Franklin 6A4150 series: In flight collision with terrain/water

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 NYC03LA175](https://openairdocs.org/ntsb/NYC03LA175.md): Stinson 108 · White Post, VA · Accident · No injuries · Limited investigation · Final report · Jul 31, 2003 · N97168 · Substantial damage
  > The pilot/ mechanic's improper annual inspection including his rigging of the elevator flight control, and his subsequent inadequate preflight inspection of the airplane prior to flight, when he failed to detect the improperly rigged elevator flight control,…
- [NTSB CHI01LA137](https://openairdocs.org/ntsb/CHI01LA137.md): Bellanca 14-13-3 · Scott City, KS · Accident · 1 fatal · Limited investigation · Final report · May 16, 2001 · N6522N · Destroyed
  > The low level roll maneuver the pilot performed on final to runway 17 and his not maintaining clearance from terrain during the maneuver.
- [NTSB LAX89LA168](https://openairdocs.org/ntsb/LAX89LA168.md): Stinson 108 · Avalon, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1989 · N97169 · Substantial damage
  > The pilot's inadequate compensation for the downdrafts he encountered and the delay in his decision to perform a go-around.

## 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 ('27024')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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