NTSB investigations: Franklin 6V 350 series, 1975
8 cases on aircraft whose registry engine model is Franklin 6V 350 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
| 1964 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1967 | 4 |
| 1968 | 6 |
| 1969 | 5 |
| 1970 | 8 |
| 1971 | 9 |
| 1972 | 10 |
| 1973 | 12 |
| 1974 | 8 |
| 1975 | 8 |
| 1976 | 7 |
| 1977 | 4 |
| 1978 | 9 |
| 1979 | 3 |
| 1980 | 1 |
| 1982 | 6 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 4 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2021 | 2 |
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 year(c.\"eventDate\") = 1975
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27043'))
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 year(c."eventDate") = 1975
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27043'))
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 SEA76DYG03Accident · No injuriesClosedEL Tomcat MK5A · Moses Lake, WANTSB MKC75FCG52Accident · No injuriesClosedBell 47D-1 · Lowry City, MONTSB MKC75FCJ59Accident · Minor injuriesClosedCarson Rell 47G · Oakdale, NENTSB LAX75FUJ78Accident · Serious injuriesClosedBell 47G · Apache Jnctn, AZNTSB NYC75FGM28Accident · No injuriesClosedSiai-Marche S205 · Drifting, PANTSB MIA75FKG58Accident · Minor injuriesClosedMaule 220C · Chamblee, GANTSB LAX75DUG34Accident · No injuriesClosedMaule M4220C · Chiraco Summit, CANTSB LAX75FUQ21Accident · No injuriesClosedM-Saulnier MS894A · Inyokern, CA