NTSB investigations: Franklin 6A4150 series
8 cases on aircraft whose registry engine model is Franklin 6A4150 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1997 | 1 |
| 2003 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27024')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27024')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 CHI03LA306Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Moline, ILThe partial failure of the engine driven fuel pump and fuel starvation. An additional cause was the pilot misjudging the proper glidepath and his improper in-flight decision during the precautionary landing to pull back the power and lower the flaps prior to…NTSB LAX03FA108Accident · Minor injuriesField investigationFinal reportStinson 108-1 · Eloy, AZa loss of engine power caused by the fatigue failure of the number 4 cylinder exhaust valve.NTSB LAX97LA134Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Oroville, CAa loss of engine power due to connecting rod bolt failure. The reason for the bolt failure was not determined. A contributing factor was the presence of trees in the emergency landing path.NTSB MIA89LA069Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Sebring, FLFailure of the cam gear snap ring, which allowed the camshaft gear to become disconnected. Factors related to the accident were trees in the emergency landing area.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 LAX87LA148Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rio Vista, CAThe aircraft nosed over in soft soil after a forced landing. The aircraft's engine failed during the departure climb and the pilot was unable to restart it. The pilot accomplished a forced landing to a field. The aircraft nosed over when the nose gear became…NTSB LAX84LA358Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Sacramento, CAThe plt reported that the fuel pump failed in flt & he made an emergency landing on a private strip. He said that he landed hard & the acft nosed over.NTSB ANC82DAG29Accident · Serious injuriesFinal reportStinson 181 · Talkeetna, AKThe pilot made a forced landing after a spark plug blew out of the engine. During the landing the aircraft collided with a tree.