Fatal NTSB investigations: Franklin 6A&6V335 series
7 cases on aircraft whose registry engine model is Franklin 6A&6V335 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.
Cases per year
| 1974 | 1 |
|---|---|
| 1980 | 1 |
| 1982 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2012 | 1 |
| 2014 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27020'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR14FA252Accident · 1 fatalField investigationFinal reportCessna 175 · Moab, UTThe pilot’s decision to approach rising mountainous terrain at too low an altitude to clear it and his subsequent attempt to climb, which exceeded the airplane’s critical angle-of-attack and resulted in a stall/spin.NTSB WPR13LA050Accident · 1 fatalLimited investigationFinal reportSater Coot A-Amphib · San Andreas, CAThe pilot's excessive flight control inputs, which led to flight that exceeded the structural limits of the airplane and resulted in structural failure of both wings.NTSB DEN03FA113Accident · 1 fatalField investigationFinal reportMattison Starduster Too · Ellicott, COthe pilot's improper in-flight planning/decision to perform aerobatics at low altitude and the failed welds at the elevator horn and torque tube. Factors contributing to the accident were the pilot performing aerobatics at low altitude, his inability to…NTSB SEA98FA090Accident · 2 fatalField investigationFinal reportMaule M-5-220C · Kettle Falls, WAThe pilot's failure to maintain terrain clearance. A factor was an attempt to perform aerobatics at low altitude.NTSB SEA82FA111Accident · 4 fatalField investigationFinal reportCessna 172F · Oxbow, ORDuring the final approach the aircraft was observed to descend to approximately 50 feet above the river and then execute a pullup and begin a left turn to either reenter a left downwind or reverse the direction of landing. The pilot lost control, the left…NTSB SEA80DYE47Accident · 2 fatalClosedCoot B · Kelso, WANTSB LAX74AL057Accident · 2 fatalClosedBell 47D1 · Westminster, CA