NTSB investigations, 2015
26 cases where the defining event was Powerplant sys/comp malf/fail.
Cases per year
| 2008 | 48 |
|---|---|
| 2009 | 35 |
| 2010 | 20 |
| 2011 | 28 |
| 2012 | 28 |
| 2013 | 21 |
| 2014 | 20 |
| 2015 | 26 |
| 2016 | 33 |
| 2017 | 28 |
| 2018 | 29 |
| 2019 | 37 |
| 2020 | 21 |
| 2021 | 28 |
| 2022 | 48 |
| 2023 | 50 |
| 2024 | 57 |
| 2025 | 36 |
| 2026 | 35 |
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\") = 2015
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") = 2015 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 ERA16LA066Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Fayetteville, NCMaintenance personnel's application of an unapproved sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in lubrication restriction due to a bearing shift and the subsequent internal failure of the…NTSB CEN16WA057Accident · No injuriesForeign investigationCessna 560 · Farnborough, United KingdomThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On November 29, 2015, at 1350 UTC, a Cessna Citation 560XL, SE-RHJ, experienced an in-flight cowling departure during descent…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 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 CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.NTSB ERA15LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28RT-201T · Dawson Springs, KYThe fatigue failure of a crankshaft counterweight, which resulted in a total loss of engine power during cruise flight.NTSB ERA15LA332Accident · Serious injuriesLimited investigationFinal reportLancair IV · Fort Lauderdale, FLThe mechanic's improper installation of the turbocharger assembly, which resulted in oil starvation and a subsequent total loss of the engine power.NTSB ANC15FA066Accident · 2 fatalField investigationFinal reportCessna 180 · Kasilof, AKThe total loss of engine power for reasons that could not be determined based on postaccident examination and testing.NTSB CEN15IA365Incident · No injuriesIncident investigationFinal reportBeech V35 · Mount Vernon, OHThe loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.NTSB ERA15FA312Accident · 1 fatalField investigationFinal reportCessna T206H · West Caldwell, NJA loss of engine power due to a malfunction of the turbocharging system likely due to contaminated oil. Also causal were the pilot's decision to continue the takeoff although the airplane was not performing normally and his failure to maintain adequate…NTSB ERA15LA300Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hot Springs, VAA partial loss of engine power during initial climb due to the failure of a magneto. Contributing to the accident was the pilot's decision to operate the airplane without a current annual inspection.NTSB WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.NTSB ENG15RA038Incident · No injuriesForeign investigationATR ATR72 · Lampedusa, ItalyThe Agenzia Nazionale per la Sicurrezza del Volo (ANSV) has notified the NTSB of an incident involving an ATR 72 that occurred August 7, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the provisions of…NTSB DCA15WA182Incident · No injuriesForeign investigationBombardier CL600 2E25 · Makassar, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a CRJ-1000, which occurred on August 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…NTSB ENG15RA028Incident · No injuriesForeign investigationAirbus A330 - 223 · Riyadh, Saudi Arabia, Saudi ArabiaOn July 23, 2015, at about 12:23 UTC, a Korean Air Airbus A330-223, registration number HL8211, experienced a No. 1 (left engine) stall after initial takeoff from the King Khalid International Airport (KSA) in Riyadh, Saudi Arabia. The flight crew received a…NTSB CEN15LA270Accident · No injuriesLimited investigationFinal reportPiper PA28-200 · Jonesboro, ARMaintenance personnel's improper engine oil drain valve installation, which led to engine oil exhaustion and the subsequent loss of engine power after takeoff at an altitude too low for the pilot to execute a forced landing in a suitable area.NTSB WPR15LA175Accident · No injuriesLimited investigationFinal reportMooney M20K · Fresno, CAA total loss of engine power during cruise flight due to a failure of the No. 1 piston and connecting rod assembly.NTSB WPR15LA178Accident · No injuriesLimited investigationFinal reportGarlick Helicopters UH 1H · Cove, ORThe failure of the engine-to-transmission drive shaft coupling assembly due to a fatigue fracture of one of its attachment bolts, which resulted in a loss of power to the main rotor.NTSB CEN15LA233Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Piggott, ARThe loss of engine power due to a malfunctioning magneto. Contributing to the accident was maintenance personnel's improper use of a drill bit instead of a timing pin during magneto installation, which resulted in a section of the drill bit breaking off and…NTSB ENG15WA022Incident · Minor injuriesForeign investigationBoeing 727-2F9 · Bogotá, Colombia, ColombiaOn May 6, 2015 at about 1215 coordinated universal time, a Boeing 727-200F, operated by Líneas Aéreas Suramericanas experienced an uncontained No.1 engine failure shortly after takeoff from El Dorado International Airport (SKBO), Bogotá, Colombia. The…NTSB CEN15IA230Incident · No injuriesIncident investigationFinal reportCessna 152 · Pilot Point, TXThe loss of engine power due to the separation of the distributor gear arm on the left magneto.NTSB CEN15LA175Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · New Roads, LAThe loss of engine power due to three stuck exhaust valves.NTSB CEN15CA155Accident · No injuriesData collectionFinal reportGaddis Michael Exec 162 F · Plymouth, INThe failure of the helicopter's main drive belt resulting in the pilot performing a forced landing, during which the helicopter's fuselage was substantially damage.NTSB WPR15LA109Accident · No injuriesLimited investigationFinal reportBell/Garlick UH 1H · Shelton, WAThe fatigue failure of the engine-to-transmission driveshaft adapter attachment bolt due to the application of inadequate torque on the bolt during assembly.NTSB ENG15WA034Incident · No injuriesForeign investigationAirbus A320 · Tehran, IranThe Civil Aviation Organization of the Islamic Republic of Iran (CAO.IRI) has notified the NTSB of an incident involving an Airbus A320-200, which occurred on February 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAO…NTSB WPR15LA085Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · San Luis Obispo, CAThe pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…