NTSB investigations: Franklin 6V4 series, NY

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

19672026

NTSB investigations: Franklin 6V4 series, NY per year, 1967–2026: 7 cases
1967	1
1968	1
1969	1
1970	1
1971	1
1982	1
2003	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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 NYC03LA069Accident · Minor injuriesLimited investigationFinal reportBell 47D · Princetown, NYThe student's failure to maintain control while executing a takeoff to a hover, and the flight instructor's delayed remedial action. A factor in the accident was the muddy ground.Mar 23, 2003 · N74120 · Substantial damage NTSB NYC82DA087Accident · No injuriesFinal reportHiller UH-12A · New Paltz, NYWhile cruising at 400 ft AGL, the pilot noticed a decay in the main rotor RPM; however, the engine RPM was reported to have remained constant. The pilot suspected a mechanical failure and elected to make a precautionary landing in an apple orchard. During the…May 2, 1982 · N116S · Substantial damage NTSB NYC72DFA08Accident · No injuriesClosedBell 47-G · Malone, NYAug 21, 1971 · N932B · Destroyed NTSB NYC71FFA06Accident · Minor injuriesClosedBell 47D-1 · New Hartford, NYJul 28, 1970 · N4117A · Substantial damage NTSB NYC69F0450Accident · 1 fatalClosedBell 47G · Geneseo, NYMay 5, 1969 · N1273 · Destroyed NTSB NYC69D0001Accident · No injuriesClosedBell 47D1 · Mt Morris, NYJun 4, 1968 · N925V · Destroyed NTSB NYC68A0014Accident · No injuriesClosedBell 47G · Wayland, NYJul 21, 1967 · N7895B · Substantial damage