# NTSB investigations: Franklin 6V4 series, MS

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 MIA98LA254](https://openairdocs.org/ntsb/MIA98LA254.md): Bell 47-D1 · Oxford, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1998 · N755E · Substantial damage
  > The pilot's failure to maintain directional control due to vibration from the main rotor blade for undetermined reasons. A related finding was the improper repair of a crack in the laminant of the blue main rotor blade by other maintenance personnel.
- [NTSB ATL97LA121](https://openairdocs.org/ntsb/ATL97LA121.md): Bell 47-D1 · Holcomb, MS · Accident · No injuries · Limited investigation · Final report · Aug 11, 1997 · N908B · Substantial damage
  > The failure of the pilot to adequately see and avoid all obstructions while doing aerial application work.
- [NTSB MIA92LA102](https://openairdocs.org/ntsb/MIA92LA102.md): Bell 47-D-1 · Fayette, MS · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1992 · N322A · Substantial damage
  > The pilot in commands failure to insure the proper fuel quantity for the flight was placed on the aircraft and his failure to monitor fuel quantity during flight resulting in fuel exhaustion.
- [NTSB MIA88LA212](https://openairdocs.org/ntsb/MIA88LA212.md): Bell 47D1 · Ruleville, MS · Accident · No injuries · Limited investigation · Final report · Jul 4, 1988 · N903B · Substantial damage
  > During an aerial application flt while spraying chemicals the plt reported that the engine quit. The pilot attempted an autorotation but was too low and slow to complete it. The aircraft landed hard in the field of crops and nosed over. Examination of the…
- [NTSB MIA79FKQ11](https://openairdocs.org/ntsb/MIA79FKQ11.md): Bell 47D · Parchman, MS · Accident · No injuries · Closed · Jun 8, 1979 · N4227A · Substantial damage
- [NTSB MIA77FKQ35](https://openairdocs.org/ntsb/MIA77FKQ35.md): Bell MK5-B · Lambert, MS · Accident · Serious injuries · Closed · Aug 23, 1977 · N4227A · Substantial damage
- [NTSB MIA70F0090](https://openairdocs.org/ntsb/MIA70F0090.md): Bell 47D1 · Belzoni, MS · Accident · No injuries · Closed · Jul 30, 1969 · N54154 · Substantial damage
- [NTSB MIA66A0106](https://openairdocs.org/ntsb/MIA66A0106-201516.md): Bell 47D1 · Shelby, MS · Accident · No injuries · Closed · Mar 12, 1966 · N3103G · 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" = 'MS' 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 ('27033'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=27033&state=MS

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