NTSB investigations: Franklin 6A4150 series, 1983
4 cases on aircraft whose registry engine model is Franklin 6A4150 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 | 30 |
|---|---|
| 1965 | 26 |
| 1966 | 26 |
| 1967 | 27 |
| 1968 | 16 |
| 1969 | 18 |
| 1970 | 19 |
| 1971 | 14 |
| 1972 | 12 |
| 1973 | 14 |
| 1974 | 14 |
| 1975 | 16 |
| 1976 | 11 |
| 1977 | 16 |
| 1978 | 7 |
| 1979 | 4 |
| 1980 | 6 |
| 1981 | 4 |
| 1982 | 5 |
| 1983 | 4 |
| 1984 | 6 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 9 |
| 1988 | 5 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 2 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 7 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 7 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 4 |
| 2024 | 2 |
| 2025 | 3 |
| 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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27024'))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27024'))
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 ANC84LA015Accident · No injuriesLimited investigationFinal reportStinson 108 · Skwentna, AKAfter takeoff the eng lost 50% of its power & a forced landing was made in trees. The plt believed the eng failure was due to water/ice in fuel.NTSB NYC83LA216Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tully, NYAt 2,000 ft near syracuse the plt decided he had enough fuel to continue on to his home base at cortland. He added full power to climb back to 3,000 ft & encountered turbulence. With full power & 80 KTS indicated the acft was losing altitude. The acft…NTSB ANC83LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Nenana, AKThe acft nose gear failed during a forced landing after the engine lost power during climbout. The plt rptd the engine began to run intermittently then quit completely. The acft had just been serviced with 36 gallons of 80/87 octane fuel. The student pilot…NTSB CHI83LA146Accident · No injuriesLimited investigationFinal reportStinson 108 · Rochester, INThe acft collided with a snow bank and nosed over during landing. The weather was VMC and the wind was from 210 degrees at 5 KTS. The pilot reported his right foot slipped off the the rudder pedal and 'attributes this to stinsons and many other acft were not…