NTSB investigations: Franklin 6A4150 series, 1988
5 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\") = 1988
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") = 1988
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 FTW89LA020Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Powderly, TXThe pilot was receiving his biennial flight review and was on approach to the airport when he heard a loud snap and lost elevator control. He was able to put the airplane down on the runway, but could not get the tail down. When he applied the brakes, the…NTSB ANC88LA126Accident · No injuriesLimited investigationFinal reportStinson 108 · Mt Spur, AKAt 1500 feet m.s.l. a complete engine failure occurred. An emergency landing was made on a gravel bar. During the rollout the airplane collided with a gravel bank. An on site examination of the engine revealed a hole in the case next to the left exhaust…NTSB DEN88LA164Accident · No injuriesLimited investigationFinal reportStinson 108 · Lordsburg, NMDuring takeoff the plane swerved to the lt and the plt aborted the takeoff. On the second takeoff, the airplane again swerved lt and departed the rwy. The plane entered loose sand off the lt side of the rwy and nosed over. The plt stated that he had made 10…NTSB NYC88LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Robbinsville, NJThe acft ground looped during landing roll and collided with terrain off the runway. The acft was landed on rwy 29 with the wind from 180 degrees at 15 KTS, gusting to 25 KTS. The acft turned into the wind and ran off the rwy to the south after traveling 1/3…NTSB NYC88LA095Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Burlington, VTThe flight was taking off for an instructional flight in the local area. During ground run, the aircraft veered to the left and the pilot was unable to bring the aircraft under control. The aircraft collided with a snowbank and flipped inverted. The aircraft…