NTSB investigations: Franklin 6V4 series, AZ

7 cases on aircraft whose registry engine model is Franklin 6V4 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19702026

NTSB investigations: Franklin 6V4 series, AZ per year, 1970–2026: 7 cases
1970	1
1973	1
1977	2
1981	1
1985	1
2021	1

Where

Open the map

Latest cases

Query with 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" = 'AZ' 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

duckdb -csv -c "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\" = 'AZ' 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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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" = 'AZ' 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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR21LA077Accident · Minor injuriesClass 4 · LimitedFinal reportBell 47D · Marana, AZThe pilot's failure to maintain helicopter control, which resulted in a hard landing.Jan 1, 2021 · N74823 · Substantial damage NTSB LAX85LA249Accident · No injuriesLimited investigationFinal reportHiller 12-C · Casa Grande, AZThe plt was demonstrating autorotations to a touchdown on a dirt rwy into a 5 kt headwind. On the final landing he said that the touchdown felt the same as others he had done. Speed at touchdown was 15 mph and the helicopter slid forward in a straight line…May 9, 1985 · N38767 · Substantial damage NTSB LAX81FUJ85Accident · Minor injuriesClosedBell 47D1 · Poston, AZAug 10, 1981 · N8060E · Substantial damage NTSB LAX77DUK02Accident · No injuriesClosedBell 47D1 · Poston, AZSep 14, 1977 · N8060E · Substantial damage NTSB LAX77FUJ19Accident · No injuriesClosedBell 47D1 · Parker, AZJan 10, 1977 · N8060E · Substantial damage NTSB LAX74DUJ24Accident · No injuriesClosedHiller Acft UH-12B · Tucson, AZSep 28, 1973 · N7299 · Substantial damage NTSB LAX71DUJ19Accident · No injuriesClosedBell 47G · Queen Creek, AZJul 27, 1970 · N5237A · Substantial damage