NTSB investigations, 2015
35 cases where the sequence of events included Part(s) separation from AC.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 24 |
| 2010 | 26 |
| 2011 | 31 |
| 2012 | 30 |
| 2013 | 26 |
| 2014 | 30 |
| 2015 | 35 |
| 2016 | 38 |
| 2017 | 37 |
| 2018 | 63 |
| 2019 | 36 |
| 2020 | 24 |
| 2021 | 24 |
| 2022 | 22 |
| 2023 | 33 |
| 2024 | 33 |
| 2025 | 25 |
| 2026 | 12 |
Where
Latest 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '338' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '338' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.NTSB WPR16FA036Accident · 2 fatalClass 3 · FieldFinal reportBarnett Allen S RV7 · Hurricane, UTThe pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.NTSB GAA16LA056Accident · No injuriesLimited investigationFinal reportAirbus EC135 · Apple Valley, CAThe ingestion of a towel from an unsecured storage container at the landing site into the helicopter's fenestron during the landing.NTSB DCA16WA020Accident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Civil Aviation Authority (CAA) of Pakistan has notified the NTSB of an accident involving a Boeing 737-400, registration AP-BJO, which occurred on November 3, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation…NTSB GAA16CA043Accident · No injuriesData collectionFinal reportCessna 182 · Douglas Bisbee, AZThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion, left main landing gear collapse, and a collision with terrain.NTSB GAA16CA039Accident · No injuriesData collectionFinal reportBell 407 · Cameron, LAThe pilot's failure to remove a main rotor blade tiedown, which resulted in substantial damage to a main rotor blade when the engine was started.NTSB WPR16LA018Accident · No injuriesLimited investigationFinal reportCessna 120 · Lone Pine, CAThe fracture of the left main landing gear (MLG) wheel axle due to fatigue, which resulted in the separation of the left MLG wheel during takeoff from a dirt airstrip.NTSB GAA16CA023Accident · Serious injuriesData collectionFinal reportCessna 140 · Fort Benton, MTA hard landing which resulted in a loss of directional control, main landing gear collapse, and damage to the left wing spar.NTSB GAA16CA010Accident · No injuriesData collectionFinal reportGrosch Starduster TOO SA 30 · Lincoln, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop, left main landing gear collapse, and the left wing striking the runway.NTSB GAA15CA294Accident · No injuriesData collectionFinal reportHoward DGA 15P · Englewood, COThe separation of the elevator control system linkage at a push/pull tube and cable joint, for an unknown reason, because the bolt and associated hardware securing the joint was not found for examination.NTSB CEN15FA422Accident · 2 fatalField investigationFinal reportPierce, Henry Bushby Mustang II · Granbury, TXThe pilot's exceedance of the airplane's critical angle of attack resulting in an aerodynamic stall and collision with terrain.NTSB ANC15LA073Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fort Glenn, AKThe separation of the tail rotor gearbox from the tailboom attachment point due to overstress loads imposed by a tail rotor blade imbalance as the result of impact with an undetermined object during low-level flight operations.NTSB CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…NTSB CEN15LA379Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ketchum, OKThe separation of the tail rotor gearbox from the tailboom aft bulkhead due to overstress loads imposed by a blade imbalance from an in-flight impact with an undetermined object.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 GAA15CA226Accident · No injuriesData collectionFinal reportStick & Rag Flying Club CB 1 · Kingman, KSThe separation of the left wheel from the landing gear assembly during the landing touchdown, which precipitated a loss of directional control, runway excursion, and nose over.NTSB DCA15WA163Incident · No injuriesForeign investigationBoeing 737 - 4Q8 · St Georges sur Meuse, BelgiumThe Air Accidents Investigation Unit (AAIU) of Belgium has notified the NTSB of an incident involving a Boeing 737-4Q8, which occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB DCA15WA196Incident · No injuriesForeign investigationBoeing 747 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747-400 that occurred on July 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…NTSB GAA15CA181Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDAbnormal ground contact during a 180 degree autorotation, resulting in a severed tail rotor driveshaft by a main rotor blade. A factor contributing to the accident was the rotor blowback condition due to the aft tilting of the main rotor disk.NTSB GAA15CA187Accident · No injuriesData collectionFinal reportHier James A Long EZ · Show Low, AZThe right main landing gear leg fracture, which resulted in the landing gear wheel separation and a runway excursion.NTSB GAA15CA159Accident · No injuriesData collectionFinal reportVans RV-12 · Oshkosh, WIThe pilot's failure to monitor the airplane's glide path during the final approach, which resulted in a low approach path and impact with terrain.NTSB ERA15LA240Accident · No injuriesClass 3 · LimitedFinal reportWeatherly 201B · Pell City, ALThe inadequate inspection of the airplane's landing gear, which resulted in a collapse of the right main landing gear due to cracking and corrosion.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 GAA15CA100Accident · No injuriesData collectionFinal reportCessna 305 · Richfield, UTThe pilot's loss of directional control during landing, which resulted in a ground loop.NTSB CEN15LA202Accident · No injuriesLimited investigationFinal reportFairchild SA227 AC · Rifle, COThe uncontained engine failure due to the fatigue failure of the second-stage turbine rotor disk.NTSB WPR15LA142Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 27 · Reno, NVThe glider's encounter with severe turbulent atmospheric conditions after the pilot inadvertently entered clouds, which led to his inability to maintain a proper airspeed and the subsequent in-flight breakup of the glider.NTSB CEN15CA201Accident · Minor injuriesData collectionFinal reportFiebich Paul Dean Airbike RX40 · Derby, KSThe pilot's inadequate compensation for wind conditions during the landing, which resulted in a hard landing and separation of the left main landing gear.NTSB CEN15WA193Accident · 2 fatalForeign investigationRans S6 - ES · Tan Rouge, RéunionOn March 30, 2015, about 0630 universal coordinated time (UTC), a Rans S6-ES airplane, French registration 974-GQ, impacted terrain near Tan Rouge, Reunion. The pilot and passenger on board were fatally injured. The airplane was destroyed. The local flight…NTSB CEN15LA183Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Gordonville, TXThe pilot's decision to depart from an upsloping, soft grass runway at or near the airplane's maximum gross weight and with a high density altitude, which increased the airplane's ground roll and placed the airplane in close proximity to trees during the…NTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.NTSB DCA15WA075Accident · No injuriesForeign investigationBoeing 747 - 468 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau of the Kingdom of Saudi Arabia has notified the NTSB of an accident involving a Boeing 747-400, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under…NTSB ERA15LA138Accident · No injuriesLimited investigationFinal reportBell 206 · Sevierville, TNAn uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.NTSB CEN15LA131Accident · No injuriesLimited investigationFinal reportBell-Watson 47 G · North Little Rock, ARThe flight instructor’s failure to maintain adequate rotor rpm during the practice touchdown autorotation, which resulted in a subsequent loss of helicopter control and impact with terrain.NTSB WPR15LA092Accident · 1 fatalLimited investigationFinal reportAlexander RV-7 · Seabeck, WAA loss of airplane control for reasons that could not be determined because the airplane impacted water, and the majority of the wreckage was not recovered.NTSB ERA15FA109Accident · 2 fatalField investigationFinal reportPiper PA-23 · Lakeland, FLAn in-flight loss of control for reasons that could not be determined during postaccident investigation; the loss of control likely occurred during a simulated loss of power in the right engine during an instructional flight.