NTSB investigations, 2012
76 cases where NTSB found Engine (reciprocating).
Cases per year
| 2008 | 65 |
|---|---|
| 2009 | 74 |
| 2010 | 80 |
| 2011 | 88 |
| 2012 | 76 |
| 2013 | 66 |
| 2014 | 60 |
| 2015 | 67 |
| 2016 | 59 |
| 2017 | 64 |
| 2018 | 61 |
| 2019 | 69 |
| 2020 | 59 |
| 2021 | 72 |
| 2022 | 88 |
| 2023 | 93 |
| 2024 | 68 |
| 2025 | 14 |
| 2026 | 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 year(c.\"eventDate\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010585'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010585')) 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 CEN13LA118Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mc Allen, TXA loss of engine power due to carburetor icing.NTSB ERA13LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Lock Haven, PAThe reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…NTSB CEN13LA111Accident · No injuriesLimited investigationFinal reportPiper L-18C · Graham, TXThe failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.NTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.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 CEN13LA091Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Halfway, MOThe pilot's failure to properly maintain the airplane and engine, which resulted in a total loss of engine power due to improperly installed magnetos and a broken camshaft.NTSB CEN13LA076Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lansing, MIA loss of engine power due to the loss of fuel flow through the airplane's fuel tank selector valve.NTSB WPR13LA052Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAA partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.NTSB CEN13FA069Accident · 1 fatalField investigationFinal reportCessna 310B · Mancelona, MIThe pilot's failure to maintain control of the airplane after a loss of right engine power for reasons that could not be determined because postaccident examination revealed no preimpact malfunction or anomaly that would have precluded normal operation.NTSB CEN13LA063Accident · 1 fatalLimited investigationFinal reportRedd Tom Quicksilver GT 400 · Oak Grove, LAThe total loss of engine power, the specific cause of which could not be identified during the postaccident examination, and the airplane’s subsequent impact with trees.NTSB WPR13LA043Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Show Low, AZThe fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.NTSB ERA13FA055Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Jackson, MSThe pilot's inadequate preflight inspection, which resulted in his failure to note the water in the fuel tank due to condensation, which subsequently shut down the engine in flight. Contributing to the accident was the pilot's self-induced pressure to…NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB CEN13FA044Accident · 2 fatalField investigationFinal reportCessna 310 · Stotts City, MOThe pilot's failure to maintain airplane control after he shut down the right engine in flight due a loss of oil pressure. Contributing to the accident was the pilot's decision to reposition the unairworthy airplane during twilight after extensive maintenance…NTSB CEN13LA055Accident · Serious injuriesLimited investigationFinal reportCentral Ohio Dragonfly Club DRAGONFLY-C · Darbyville, OHThe total loss of engine power due to a cold-seizure event that occurred at a low altitude, which precluded the pilot's recovery from an inadvertent aerodynamic stall/spin.NTSB ERA13LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Mansfield, MAThe pilots’ failure to apply carburetor heat during takeoff, which resulted in a partial loss of engine power due to the formation of carburetor ice.NTSB ERA13LA029Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Edison, GAThe total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.NTSB WPR13LA015Accident · No injuriesLimited investigationFinal reportBeech N35 · Phoenix, AZA loss of engine power due to oil starvation due to loose oil cooler attachment bolts. Contributing to the accident was inadequate maintenance during the annual inspection.NTSB WPR12LA437Accident · No injuriesLimited investigationFinal reportMccleery Rans S6ES · Elverta, CAA loss of engine power during initial climb due to a failed piston ring.NTSB ERA12LA574Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Corinth, MSThe improper torque application on the crankshaft gear bolt by maintenance personnel during an engine overhaul, which resulted in the fatigue failure of the locking tab washer and gear alignment dowel and subsequent engine stoppage. Contributing to the…NTSB CEN12LA648Accident · No injuriesLimited investigationFinal reportHughes 269A · Mc Cool Junction, NEThe flight instructor’s inadequate supervision of the student pilot’s entry into the autorotation, which resulted in a hard landing. Contributing to the accident was the loss of engine power as a result of the student pilot rapidly lowering the helicopter’s…NTSB CEN12FA653Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Kiowa, COA catastrophic engine failure due to unrecognized and unrepaired corrosion within the engine, which was consistent with engine operations after an extended period of inactivity.NTSB CEN12LA623Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Gilmer, TXThe partial loss of engine power due to the loss of cylinder compression. The loss of cylinder compression was the result of the No. 3 piston ring failure due to excessive heat because of the lean fuel mixture from a partially clogged fuel nozzle.NTSB CEN12CA625Accident · No injuriesData collectionFinal reportBeech 35 · Geary, OKThe student pilot failed to maintain control of the airplane during a forced landing attempt which resulted in an aerodynamic stall. Contributing to the accident was the instructor pilot's delay in taking control of the airplane and the loss of engine power…NTSB CEN12FA616Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Kingsland, TXThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power resulting from an engine intake valve that became stuck open. Contributing to the accident was the pilot’s decision to operate the airplane when a required maintenance…NTSB CEN12LA609Accident · No injuriesLimited investigationFinal reportCessna 175B · Hamilton, TXThe partial loss of engine power due to an exhaust valve that was stuck in the open position.NTSB CEN12FA601Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brighton, MIThe pilot’s failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the severity of…NTSB WPR12LA382Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Chelan, WAA loss of engine power during climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA539Accident · No injuriesLimited investigationFinal reportCessna 172M · Canadensis, PAThe pilot’s failure to attain a proper glidepath.NTSB CEN12LA589Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Ralls, TXThe total loss of engine power due to a fatigue failure of the rocker arm journal casting of the rocker arm cap.NTSB CEN12FA586Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Canton, MOThe pilot's improper decision to attempt to execute a forced landing to an open field with obstacles. Contributing to the accident was the left engine’s total loss of power due to fuel starvation as a result of the introduction of air into the fuel system…NTSB ERA12LA524Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Riverview, FLDamage to the propeller governor gasket during installation by unknown persons, which resulted in a total loss of engine oil in flight and a subsequent forced landing.NTSB ERA12TA542Accident · No injuriesFinal reportRidge Lowell H Jabiru J230 · Otter Lake, NYA failure of an engine cylinder exhaust valve due to the buildup of lead deposits on the valve stem and fatigue cracking of the valve stem, resulting in a total loss of engine power, and the loss of the propeller. Contributing to the accident was the lack of…NTSB WPR12LA356Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe loss of engine power due to the separation of the No. 2 cylinder exhaust rocker boss housing, which prevented the exhaust valve from opening.NTSB CEN12LA543Accident · Serious injuriesLimited investigationFinal reportCross David L Glasair III · Westcliffe, COThe loss of oil pressure due to the failure of an oil filter gasket, which resulted in a total loss of engine power.NTSB CEN12LA524Accident · No injuriesLimited investigationFinal reportCessna 177B · Carthage, TXThe loss of engine power during a low-level aerial observation flight as the result of the wearing of the rocker arm tip due to a thin carburized case layer, which resulted in a forced landing.NTSB CEN12LA501Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Holly Lake Ranch, TXThe incomplete maintenance performed by maintenance personnel, which resulted in a total loss of engine power.NTSB CEN12CA496Accident · No injuriesData collectionFinal reportBlack Donald Cozy III · Los Lunas, NMA loose oil line, which allowed oil to leak onto the hot engine turbocharger and resulted in a fire.NTSB ERA12LA473Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Pickens, SCA total loss of engine power due to the failure of the crankshaft, which resulted from the application of insufficient torque on the cylinder through-bolts by maintenance personnel.NTSB CEN12FA463Accident · Minor injuriesField investigationFinal reportMooney M20E · Marked Tree, ARThe loss of engine power during cruise flight due to a malfunction of the fuel injection servo due to a damaged O-ring.NTSB ERA12LA469Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Statesboro, GAA total loss of engine power as a result of oil exhaustion due to the mechanic's failure to apply appropriate torque to the oil filter.NTSB CEN12LA491Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fergus Falls, MNA total loss of engine power due to a cracked No. 2 cylinder head.NTSB WPR12LA306Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockford, IDA partial loss of engine power during cruise flight due to the failure of the No. 3 cylinder exhaust valve for reasons that could not be determined due to the damage to the valve head and the missing valve stem. Contributing to the accident was the flight…NTSB CEN12LA437Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Mott, NDThe rupture of a corroded oil line, which resulted in a total loss of engine power due to oil starvation.NTSB CEN12LA508Accident · Serious injuriesLimited investigationFinal reportCessna 172M · South Wayne, WIInternal engine component failures, which resulted from oil starvation due to debris in the oil system.NTSB ERA12LA428Accident · No injuriesLimited investigationFinal reportCessna R172K · Greene, NYAn undetected fatigue crack on the outer surface of the No. 3 cylinder barrel that could only have been detected visually and not by a differential compression test , resulting in separation of the head from the barrel and a subsequent partial loss of engine…NTSB WPR12LA281Accident · No injuriesLimited investigationFinal reportTecnam P2002 Sierra · Watsonville, CAA partial loss of engine power during initial climb due to the blockage of the carburetor’s main jet by deteriorated float material. Contributing to the accident was an inadequate maintenance inspection by maintenance personnel.NTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…NTSB ERA12LA422Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Mc Kinnon, TNThe separation of the piston connecting rod from the crankshaft due to inadequate installation from a mechanic, resulting in a total loss of engine power.NTSB ANC12LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gustavus, AKThe fatigue failure of the engine crankshaft for reasons that could not be determined during postaccident metallurgical examination.