Skip to content

NTSB investigations, 2013

21 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") = 2013 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\") = 2013
    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") = 2013
  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 WPR14LA079Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Lodi, CAThe fatigue failure of the crankshaft, which resulted in a total loss of engine power and subsequent forced landing.Dec 27, 2013 · N8848K · Substantial damage NTSB CEN14WA180Accident · No injuriesForeign investigationChristen Industries Pitts S-2B · Meaux-Esbly, FranceOn December 8, 2013, at 1607 coordinated universal time, a Pitts S-2B airplane, F-GEAL, experienced a loss of engine power and conducted a force landing near Meaux-Esbly, France. The pilot and passenger were not injured. The airplane was substantially…Dec 8, 2013 · F-GEAL · Substantial damage NTSB ENG14RA004Incident · No injuriesForeign investigationSaab Saab 2000 · Lugano, SwitzerlandOn November 28, 2013, about 630 UTC, a SAAB 2000 airplane, HB-IZW, experienced an engine failure during climb out after takeoff in Switzerland. The location was not reported. The 2 pilots, 1 crew member and 25 passengers were not injured. Damage to the…Nov 28, 2013 · HB-IZW NTSB CEN14LA031Accident · No injuriesLimited investigationFinal reportCessna T210L · Borger, TXThe failure of the No. 4 connecting rod due to inadequate oil lubrication.Oct 25, 2013 · N398MA · Substantial damage NTSB ERA14LA004Accident · No injuriesLimited investigationFinal reportMcdonald Howard Brian Zenair 701 · Zephyrhills, FLThe failure of the propeller speed reduction unit drive belts due to inadequate belt tension being applied during installation, which resulted in a complete loss of thrust.Oct 19, 2013 · N538HB · Substantial damage NTSB ENG14IA001Incident · No injuriesIncident investigationFinal reportAirbus A319 132 · Greenville, TXA high pressure turbine 2nd stage blade separation due to stress corrosion cracking in the J channel cooling cavity. The failed blade entered the gas path and caused substantial damage to the low pressure turbine. The engine was subsequently left at a high…Oct 15, 2013 · N516NK · Minor damage NTSB ENG14WA002Incident · No injuriesForeign investigationAirbus A330 - 302 · Caines, Australia, AustraliaOn October 4, 2013, a China Airlines Airbus A330-302, powered by General Electric CF6-80E1A4 turbofan engines experienced a No. 1 engine starter failure while at cruise after takeoff from Sydney Airport, Sydney Australia. The flight crew shutdown the engine…Oct 10, 2013 · B-18358 · Minor damage NTSB CEN13LA557Accident · Serious injuriesLimited investigationFinal reportBeech 35 B33 · Urbana, INThe failure of the crankshaft following several overheating events that had led to a stress crack and the subsequent fracture forward of the No. 6 rod journal.Sep 24, 2013 · N8910M · Substantial damage NTSB ENG13RA041Incident · No injuriesForeign investigationATR 72-500 · Makassar, Indonesia, IndonesiaSep 18, 2013 · PK-WFV · Minor damage NTSB ANC13LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Paxson, AKThe partial loss of engine power due to a loose throttle cable clamp.Aug 13, 2013 · N44RT · Substantial damage NTSB CEN13LA433Accident · 1 fatalLimited investigationFinal reportClayton Gerald H Glastar GS-1 · Columbus, INSlippage in the engine clutch and gear reduction module and a resultant uncommanded movement of the propeller blades into reverse thrust.Jul 25, 2013 · N513GC · Destroyed NTSB CEN13LA431Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Gary, SDThe failure of the engine connecting rod due to fatigue.Jul 23, 2013 · N7507A · Substantial damage NTSB CEN13LA346Accident · No injuriesLimited investigationFinal reportRogers T-51 Mustang KIT · St Francis, KSForeign debris in the propeller governor, which led to excessive wear in the governor and its subsequent in-flight failure.Jun 11, 2013 · N548RR · Substantial damage NTSB WPR13LA266Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Grand Canyon, AZA loss of throttle control movement during a practice autorotation that was planned to terminate with a power recovery for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal…Jun 8, 2013 · N130PH · Substantial damage NTSB CEN13WA307Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Tallard, FranceMay 29, 2013 · N68XM · Destroyed NTSB ERA13FA256Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Macon, GAA total loss of engine power due to oil starvation for reasons that could not be determined due to extensive postcrash fire and heat damage to the engine components.May 27, 2013 · N4489F · Destroyed NTSB WPR13FA243Accident · Minor injuriesField investigationFinal reportHiller UH-12E · Wenatchee, WAFatigue failure of the six bolts that secured the bevel gear to the first stage planetary carrier, which caused the transmission to seize while the helicopter and main rotor were still operating.May 26, 2013 · N99090 · Substantial damage NTSB CEN13LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Galena, KSThe loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.May 14, 2013 · N57719 · Substantial damage NTSB CEN13LA258Accident · No injuriesLimited investigationFinal reportCessna 182T · Delta, COThe loss of propeller control for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation and the airplane’s subsequent collision with power lines during the forced landing.May 2, 2013 · N2012Y · Substantial damage NTSB CEN13CA262Accident · Minor injuriesData collectionFinal reportEngineering & Research 415-C · Little Falls, MNThe failure of the airplane's throttle cable.Apr 26, 2013 · N94305 · Substantial damage NTSB ERA13LA180Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Titusville, FLAn engine failure due to the separation of the engine crankcase, which resulted from the lateral movement of the center main bearing and the subsequent blocking of the oil feed hole that supplied oil to the No. 2 connecting rod, which then led to its failure…Mar 19, 2013 · N2099S · Substantial damage