NTSB investigations: Franklin 6A-350SER, 1983
3 cases on aircraft whose registry engine model is Franklin 6A-350SER. 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
| 1967 | 1 |
|---|---|
| 1971 | 2 |
| 1973 | 4 |
| 1974 | 5 |
| 1975 | 1 |
| 1978 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 3 |
| 1984 | 1 |
| 1988 | 1 |
| 1991 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2008 | 1 |
| 2009 | 2 |
| 2011 | 2 |
| 2013 | 2 |
| 2015 | 1 |
| 2018 | 1 |
| 2020 | 2 |
| 2023 | 2 |
| 2025 | 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 ('27023'))
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 ('27023'))
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 NYC84LA045Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Somersworth, NHThe acft was damaged in a forced landing after the engine quit during a descent. The plt had been cruising at 2500 ft. upon descending to 800 ft in the skyhaven area the plt applied power but the engine did not respond. An airstart attemptwas unsuccessful and…NTSB SEA83LA090Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Malad City, IDDuring an interview, the plt reported that he had removed ice from the acft & attempted to depart from a snow covered alfalfa field, aprx 1000 ft long. The acft did not become airborne & the plt elected to abort the takeoff. During the abort, the acft…NTSB CHI83LA082Accident · No injuriesLimited investigationFinal reportMaule M4-180C · Brainerd, MNThe aircraft experienced power failure during slow descent to enter traffic pattern after a test hop. A landing was accomplished in an open snow covered field. During the roll-out in the 18 inch deep snow the aircraft nosed over. Preliminary examination of…