NTSB investigations
13 cases where NTSB found Recip eng front section.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2021 | 2 |
| 2023 | 1 |
| 2024 | 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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01058510')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01058510')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 ERA24LA258Accident · Serious injuriesClass 3 · LimitedFinal reportClapp Saberwing · Valdosta, GAThe total loss of engine power due to the shearing of the woodruff key that indexed the crankshaft gear and hub assembly to the crankshaft, which resulted in the gear and hub rotating from their indexed position and caused the crankshaft-to-camshaft timing to…NTSB WPR23LA160Accident · No injuriesClass 3 · LimitedFinal reportRemos Remos GX · Glendale, AZA total loss of engine power caused by fatigue cracking and fracture of the crankshaft. Contributing to the accident was the operator’s failure to properly maintain the airplane.NTSB CEN21LA401Accident · No injuriesClass 3 · LimitedFinal reportBulfer James G Genesis · Fairmont, MNThe pilot’s failure to maintain airspeed during a forced landing, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the loss of power due to the failure of the engine’s…NTSB CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.NTSB ANC17LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bethel, AKThe mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.NTSB ERA16LA041Accident · No injuriesLimited investigationFinal reportWoodrow Larry W Sonex · Morganton, NCThe pilot/owner’s inadequate maintenance inspection following a propeller strike, which resulted in the subsequent in-flight propeller separation due to propagation of fatigue cracks in the crankshaft.NTSB ERA13FA325Accident · Serious injuriesField investigationFinal reportBeech 23 · Laurel, MDThe pilot's inadequate preflight preparation of the airplane, which resulted in a total loss of engine power during takeoff and his decision to operate the unairworthy airplane.NTSB ERA13FA082Accident · 1 fatalField investigationFinal reportCessna 421C · Lake Worth, FLThe pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…NTSB ERA11IA521Incident · No injuriesIncident investigationFinal reportBeech V35 · New Haven, CTThe in-flight fatigue failure of the engine’s crankshaft, which resulted in the separation of the forward portion of the crankshaft and the propeller.NTSB WPR11LA290Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S-1T · Alkali Lake, ORThe loss of engine oil during cruise flight due to the failure of the front bearing oil seal.NTSB ERA09LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Wauchula, FLA loss of engine power due to failure of the Number 3 connecting rod due to oil contamination. Contributing to the accident was the insufficient oil change time intervals performed by company personnel.NTSB ERA09CA054Accident · No injuriesData collectionFinal reportSnow 600 · Nashville, TNThe failure of the propeller shaft seal in flight. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.