Skip to content

NTSB investigations, 2011

28 cases where the defining event was Powerplant sys/comp malf/fail.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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") = 2011 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '340') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 2011
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '340')
  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") = 2011
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '340')
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 CEN12CA035Accident · Minor injuriesData collectionFinal reportHouts Avid Mark IV · Hibbing, MNThe improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.Oct 21, 2011 · N43280 · Substantial damage NTSB CEN12FA025Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Watertown, WIThe separation of the number 2 connecting rod from the crankshaft for reasons that could not be determined during postaccident metallurgical examination, which ultimately resulted in a total loss of engine power.Oct 17, 2011 · N300KR · Substantial damage 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.Sep 30, 2011 · N43KH · Substantial damage 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.Sep 18, 2011 · N275BM · Minor damage NTSB WPR11GA431Accident · Minor injuriesFinal reportBell 205 · Tehachapi, CAThe pilot's inability to adequately execute an emergency autorotation due to the flight's low altitude during external load operations, which resulted in a hard landing. Contributing to the accident was a torsionally overstressed tachometer shaft, which sent…Sep 4, 2011 · N205WW · Substantial damage NTSB ERA11LA483Accident · Minor injuriesLimited investigationFinal reportDurling James RV-6A · Hollywood, FLParticulate ingestion from the engine, which resulted in the malfunction of the propeller governor during the airplane’s initial climb.Sep 3, 2011 · N241BD · Substantial damage NTSB WPR11LA423Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters UH-1H · Stockton, CAA total loss of engine power due to the separation of a tooth from the starter-generator drive gear, which resulted in failure of the engine oil pump and subsequent oil starvation.Sep 2, 2011 · N205PJ · Substantial damage NTSB CEN11LA568Accident · Serious injuriesLimited investigationFinal reportQuad City Challenger · Granbury, TXThe leak in the plastic connectors in the fuel lines, which resulted in decreased engine power during the initial climb.Aug 16, 2011 · N979JP · Substantial damage NTSB CEN11LA566Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Nelson, NEFailure of the fuel control unit's spool cap bearing for reasons that could not be determined during extensive postaccident examination, and the pilot’s decision to shut the engine down without sufficient altitude and distance to reach the runway.Aug 11, 2011 · N3659N · Substantial damage NTSB CEN11LA563Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Mansfield, SDThe loss of engine power due to debris in the engine air intake system.Aug 10, 2011 · N127FC · Substantial damage NTSB ERA11LA461Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Elizabethtown, NCThe improper securing of a “B” nut on the power turbine control (Py) line by unknown maintenance personnel, which resulted in a total loss of engine power. Contributing to the accident was the pilot's failure to use the manual fuel override switch.Aug 6, 2011 · N469CC · Substantial damage NTSB CEN11LA491Accident · No injuriesLimited investigationFinal reportBeech C35 · Medina, OHThe loss of engine power due to fuel starvation due to an age-related failure of the engine-driven fuel pump. Also causal was the failure of the maintenance facility to overhaul the fuel pump and the failure of the operator to ensure that the pump was…Jul 20, 2011 · N1883D · Substantial damage NTSB CEN11LA460Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Pine Bluff, ARThe use of an incorrect mounting bolt by maintenance persons to attach the engine torque sensor, which resulted in an internal failure of the torque sensor and subsequent loss of engine power due to fuel starvation.Jul 6, 2011 · N3101S · Substantial damage NTSB ERA11LA383Accident · No injuriesLimited investigationFinal reportCessna 150L · Plymouth, MAA partial loss of engine power during initial climb due to a stuck cylinder valve, which resulted from excessive corrosion and carbon deposits on the valve springs due to inadequate maintenance.Jul 4, 2011 · N150ET · Substantial damage 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.Jun 26, 2011 · N77MN · Substantial damage NTSB ENG11IA035Incident · Minor injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAFuel leaking from the fuel flow transmitter that ignited on contact with the engine’s hot cases which resulted in an engine undercowl fire. The fuel leak resulted from the fuel flow transmitter end housing backing off from the main housing, creating a gap…Jun 21, 2011 · N6714Q · No damage NTSB CEN11LA413Accident · No injuriesLimited investigationFinal reportCessna 172N · Bedford Park, ILA loss of engine power due to a fractured push rod precipitated by a stuck exhaust valve.Jun 18, 2011 · N172NT · Substantial damage NTSB CEN11LA404Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Athleimer, ARFailure of the first stage planetary gearset in the propeller reduction gearbox, which resulted in catastrophic engine failure. Contributing to the failure was the misrepresentation of the gearset being zero-timed by the company that sold the gearset to the…Jun 16, 2011 · N30902 · Substantial damage NTSB CEN11LA367Accident · Minor injuriesLimited investigationFinal reportJones Cozy Mark IV · Sioux City, IAThe pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.May 30, 2011 · N204TJ · Substantial damage NTSB CEN11LA370Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Lakeville, MNThe loss of engine power due to a loose B-nut on the compressor discharge pressure bleed line.May 25, 2011 · N96SH · Substantial damage NTSB ERA11LA216Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Culpeper, VAMechanical failure of the transmission for reasons that could not be determined because the transmission could not be torn down.Mar 25, 2011 · N4033P · Substantial damage NTSB ERA11LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Goshen, NYThe pilot’s failure to adhere to published preflight checklist limitations and procedures, resulting in excessive slack and subsequent failure of the power transmission belts and a total loss of rotor system drive.Mar 22, 2011 · N259TW · Substantial damage NTSB ENG11IA021Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 402 · Pittsburgh, PAthe flight crew's delay in shutting down the left engine following an engine oil pressure master warning, which led to a hard rub inside the engine that served as an ignition point for a titanium fire. Contributing to the event was a PW150 No. 5 seal design…Mar 17, 2011 · N339NG · Minor damage NTSB WPR11LA167Accident · No injuriesLimited investigationFinal reportRotorway A600 · Chandler, AZA design modification that changed the fasteners and components used to attach the main rotor drive pulley to the engine, which resulted in fatigue failure of those fasteners and a complete loss of power to the main rotor.Mar 15, 2011 · N602RW · Substantial damage NTSB CEN11FA202Accident · Minor injuriesField investigationFinal reportCessna T210M · Independence, MOLatent dimensional discrepancies related to the engine crankcase main bearing saddle bores, which precipitated the fatigue failure of the crankshaft and a complete loss of engine power. Contributing to the accident was the engine manufacturer's failure to…Feb 24, 2011 · N6149B · Substantial damage NTSB ERA11LA130Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Cross City, FLA total loss of engine power resulting from the failure of the camshaft due to fatigue cracks. Contributing to the accident was the inadequate quality inspection of the camshaft after initial manufacture.Jan 28, 2011 · N8135B · Substantial damage NTSB WPR11LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · San Luis Obispo, CAThe loss of engine power due to the fatigue fracture of one attachment bolt for the left idler gear shaft, which resulted from an insufficient preload on both attachment bolts.Jan 20, 2011 · N8608W · Substantial damage NTSB ERA11LA117Accident · No injuriesLimited investigationFinal reportConvair 340-71 · Charlotte AmalieThe captain’s decision to continue the flight with the left engine backfiring, resulting in an engine fire shortly after takeoff. Contributing to the accident were the captain’s decision to continue the flight following a report of black smoke trailing the…Jan 17, 2011 · N8277Q · Substantial damage