NTSB investigations: Franklin 6A8 series, 1985
3 cases on aircraft whose registry engine model is Franklin 6A8 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 | 1 |
|---|---|
| 1965 | 6 |
| 1966 | 4 |
| 1967 | 3 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 3 |
| 1971 | 2 |
| 1972 | 3 |
| 1974 | 1 |
| 1975 | 1 |
| 1978 | 2 |
| 1979 | 2 |
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 3 |
| 1991 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2012 | 2 |
| 2016 | 2 |
| 2020 | 1 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27030'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27030'))
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 DEN85LA218Accident · No injuriesLimited investigationFinal reportDowner Aircraft Industries REP. Seabee RC-3 · Haugan, MTThe plt had reconditioned N6305K and was flying the acft to his home in Texas. He continued to state that while climbing through 6500 ft, he heard an unusual noise followed by a substantial loss in pwr. The plt executed an emergency landing on a forest…NTSB CHI85FA234Accident · 1 fatalField investigationFinal reportRepublic RC-3 · Eveleth, MNOn takeoff from ely lake the acft turned sharp left at an altitude of 80-100 ft. at this point the acft ceased rated to climb and decended into trees and a lakeside house. The a cft was in excess of 400 lbs over gross weight. The lading gear and nose ballast…NTSB MIA85LA116Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Lake Placid, FLThe plt heard a loud noise & noticed that a fire had immediately started in the eng compartment. He made an emergency landing on a nearby lake; however, the amphibious acft continued burning & was destroyed. An investigation revealed that the fire had started…