NTSB investigations
19 cases where NTSB found Accessory gear-boxes.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2022 | 2 |
| 2023 | 3 |
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\", '010583')) 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", '010583')) 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 ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…NTSB CEN24LA027Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Rowlett, TXA malfunction of the helicopter’s Engine Monitoring Unit (EMU)/Governor Controller for undetermined reasons. Contributing to the accident was the flight instructor’s failure to turn off the EMU/Governor Controller per the emergency checklist when the…NTSB WPR23LA215Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Belfair, WAThe total loss of engine power due to the fatigue failure of the crankshaft accessory drive gear.NTSB ERA22LA268Accident · No injuriesClass 3 · LimitedFinal reportWingren Norman Escapade · Brasstown, NCThe failure of the engine gearbox drive flange, which resulted in a nose gear collapse during the subsequent precautionary landing in tall grass.NTSB ERA22LA117Accident · No injuriesClass 3 · LimitedFinal reportHughes 369D · Bel Air, MDA loss of engine power due to bearing failures in the turbine section resulting from a fatigue fracture of the oil supply line that fed oil to the Nos. 6 and 7 bearings. The oil line failure led to rapid deterioration of the bearings from oil starvation.…NTSB CEN19LA156Accident · No injuriesClass 3 · LimitedFinal reportRockwell S 2R · Oakes, NDThe failure of the helical cam gear of the engine assembly due to fatigue cracks in the gear teeth, which resulted in a total loss of engine power.NTSB WPR19LA029Accident · No injuriesClass 3 · LimitedFinal reportBKF Backcountry Supercub · Casper, WYThe seizure of two bearings in the reduction gearbox, resulting in the total loss of engine power. Contributing to the accident was a high descent rate which resulted in a hard landing.NTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN16LA035Accident · Minor injuriesLimited investigationFinal reportGlimn Kitfox 2-3 · Escanaba, MIThe airplane owner's inadequate maintenance and servicing of the propeller gearbox, which resulted in oil starvation, failure of the gearbox in flight, and a subsequent loss of propeller thrust. Contributing to the outcome was the airplane's low altitude at…NTSB WPR15LA248Accident · Minor injuriesLimited investigationFinal reportSikorsky S 61A · Ironside, ORA loss of power to the No. 2 engine due to the failure of the accessory gearbox drivetrain. Also causal was the pilot’s inability to release the external longline due to the use of a safety wire across the coupling of the quick-disconnect mechanism, which…NTSB ERA14LA130Accident · Serious injuriesLimited investigationFinal reportVictor M Cordero RV-9A · Apopka, FLThe failure of the propeller spline shaft, the drive disk adapter, and the propeller speed reduction unit (PSRU) input spline due to a lack of inspection and lubrication, which resulted in a total loss of propeller drive and a subsequent forced landing.…NTSB WPR13LA358Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chualar, CAMaintenance personnel's failure to properly tighten the bolts securing the main driveshaft to the transmission, which resulted in fatigue failure of the bolts and disconnection of the driveshaft during low-altitude flight.NTSB CEN13FA352Accident · Serious injuriesField investigationFinal reportAero Commander 685 · Victoria, TXMaintenance personnel's failure to secure the left engine idler pin during overhaul, which resulted in a catastrophic engine failure and subsequent forced landing.NTSB CEN12LA551Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Holton, KSThe mechanic's failure to adequately torque the right magneto attachment nuts, allowing the right magneto to come loose, which allowed engine oil to escape, causing the engine to seize.NTSB CEN12LA470Accident · Minor injuriesLimited investigationFinal reportYamokoski William Glastar · Chicago, ILFailure of the automotive engine's reduction gearbox while in cruise flight.NTSB ERA11FA512Accident · 1 fatalField investigationFinal reportHeronimus Kevin A Glasair III · Falls of Rough, KYThe failure of the propeller power speed reduction unit, which resulted in a loss of engine power at low altitude.NTSB ERA10LA316Accident · Minor injuriesLimited investigationFinal reportMcculloch Jerry RV-4 · Pageland, SCMaintenance personnel’s improper installation and inspection of the crankshaft idler gear, which resulted in a loss of engine power.NTSB ERA09LA490Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAA total loss of engine power due to the loss of camshaft timing as a result of the displacement of the idler gear assembly.NTSB CHI08LA274Accident · Minor injuriesLimited investigationFinal reportSadler Vampire · Findlay, OHA total loss of engine power due to the failure of the reduction drive assembly as a result of excessive wear and high temperatures. Contributing to the accident were the pilot's lack of total experience in the airplane and the unsuitable terrain for a forced…