Final NTSB investigations
216 cases where the defining event was Part(s) separation from AC.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 14 |
| 2010 | 13 |
| 2011 | 18 |
| 2012 | 13 |
| 2013 | 12 |
| 2014 | 12 |
| 2015 | 9 |
| 2016 | 20 |
| 2017 | 16 |
| 2018 | 14 |
| 2019 | 12 |
| 2020 | 11 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 10 |
| 2024 | 9 |
| 2025 | 9 |
| 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 c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '338')
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 c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '338') 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 ERA26LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Weston, CTThe in-flight opening of the engine cowling, which resulted in engine baffling separating from the airplane and impacting the right elevator.NTSB ERA26LA193Accident · No injuriesClass 4 · LimitedFinal reportBell UH1 · Enterprise, ALThe in-flight separation of a turn lock fastener stud, which resulted in substantial damage to one tail rotor blade.NTSB CEN26LA131Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Van Burensburg, ILPropeller separation due to failure of the propeller attachment bolts.NTSB CEN25LA328Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV14 · Parker, COSeparation of the right landing gear wheel assembly during landing.NTSB WPR25LA209Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Colorado City, AZThe pilot’s exceedance of the airplane’s never-exceed speed (VNE) during maneuvering, which resulted in the in-flight separation of the left flaperon.NTSB ERA25LA236Accident · No injuriesClass 4 · LimitedFinal reportSting Sport TL-2000 · Dunavant, VAThe inflight failure of the propeller due to its exceedance of the manufacturer’s overhaul requirement.NTSB ERA25LA204Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Fort Washington, PAMaintenance personnel’s failure to identify and replace damaged rivet nuts at the air conditioning louver assembly, which resulted in the separation of the louver assembly from the helicopter, the louver assembly’s impact with the tail rotor, and subsequent…NTSB ANC25LA028Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Royal Kunia, HIImproper alteration of the crankshaft propeller flange at an unknown time, which resulted in an in-flight separation of the propeller assembly.NTSB CEN25LA117Accident · No injuriesClass 3 · LimitedFinal reportVans RV-7A · Plainview, TXThe improper machining of the propeller blade bearing seat, which resulted in an inflight propeller blade fatigue failure. Contributing to the accident was the improper machining of the propeller hub and propeller blade root and machining surface quality…NTSB WPR25LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Minersville, UTThe failure of the propeller blade due to fatigue that originated from an impact pit sustained at an unknown time. Contributing to the accident was the failure of unknown maintenance personnel to detect and repair the impact pit before painting the propeller,…NTSB ERA25LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Clarksville, TNThe flight instructor’s inadequate preflight inspection of the airplane, which allowed the partially secured engine cowl to separate in flight.NTSB ERA25LA102Accident · No injuriesClass 4 · LimitedFinal reportDaniel A Robinson High 6 Berkut 540 · Orlando, FLThe pilot’s failure to verify the canopy latches were in the locked position prior to takeoff.NTSB ERA24LA325Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Cuba, NYA separation of the left main landing gear wheel assembly during landing.NTSB ERA24LA303Accident · No injuriesClass 3 · LimitedFinal reportJones LONG-EZ · Thomasville, GAThe pilot reported that he was maneuvering around weather at 11,500 ft mean sea level (msl) when he made a rapid descent to 3,500 ft msl to remain clear of clouds. He reported that he did not exceed the airplane’s maneuvering speed during the descent, and…NTSB WPR24LA211Accident · No injuriesClass 3 · LimitedFinal reportBeech 58P · Escalante, UTThe failure of the windshield for undetermined reasons.NTSB DCA24LA210Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767-316 ER · Milan, INOne or more latches were not fully re-engaged after a service check which resulted in the auxiliary power unit (APU) doors separating from the aircraft during climb out.NTSB WPR24LA122Accident · No injuriesClass 3 · LimitedFinal reportCessna 180A · Nordman, IDMaintenance personnel's improper installation of the left main landing gear wheel assembly, which resulted in a loss of torque and subsequent separation of the wheel and axle assembly from the main landing gear leg during landing.NTSB CEN24LA128Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland MBB-BK 117 C-2 · West Lafayette, INThe failure of maintenance personnel to properly install the tail rotor pitch change slider attachment hardware (T-bolt), which led to the disconnection of the pitch change slider, a loss of tail rotor control, and subsequent hard landing. Contributing to the…NTSB WPR24LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Weippe, IDThe pilot’s failure to secure the oil filler cap during the preflight inspection, which resulted in a precautionary landing on the soft surface and subsequent nose over.NTSB ERA24LA109Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Louisville, KYThe failure of maintenance personnel to thoroughly inspect and repair the worn-out panel fasteners and fastener holes.NTSB DCA24MA063Accident · Minor injuriesClass 1 · MajorFinal reportBoeing 737-9 · Portland, ORthe in-flight separation of the left mid exit door (MED) plug due to Boeing Commercial Airplanes’ failure to provide adequate training, guidance, and oversight necessary to ensure that manufacturing personnel could consistently and correctly comply with its…NTSB ERA24FA075Accident · 1 fatalClass 3 · FieldFinal reportHughes Helicopters 369E · Miami, FLMain rotor contact with the tail boom for unknown reasons, resulting in the separation of the tail boom.NTSB WPR24LA051Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Mesa, AZA failure of the engine cowling right side latch pin and fasteners, which resulted in the partial separation of the engine cowling during flight.NTSB CEN24LA038Accident · Minor injuriesClass 3 · LimitedFinal reportBede BD-4 · Lowell, INFatigue cracking of the propeller blade root, which resulted in the in-flight separation of the propeller blade from its root. Contributing to the accident was the improper machining of the blade root threads, which resulted in chatter/ratchet marks that…NTSB WPR23FA351Accident · 1 fatalClass 3 · FieldFinal reportGolden Circle T Bird · Arlington, WAA failure of the forward left wing spar due to an improper repair, which resulted in an inflight separation of the left wing. Contributing to the accident was improper maintenance by splicing the wing spar.NTSB CEN23LA296Accident · Minor injuriesClass 3 · LimitedFinal reportMagni M24 · Mineral Point, MOThe inflight loss of the engine’s air filter which collided with the propeller which resulted in a vibration.NTSB ERA23LA248Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B300 · Melbourne, FLAn inflight separation of the airplane’s airstair door for undetermined reasons.NTSB CEN23LA218Incident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Romeoville, ILThe inflight failure of the propeller blade due to fatigue cracking from corrosion pits, initiating at the midpoint of the cambered face.NTSB WPR23LA149Accident · No injuriesClass 3 · LimitedFinal reportStevens Kelly C RV-7 · Morgan, UTThe pilot/builder improperly torqued the propeller attachment bolts while reinstalling the propeller, which resulted in the fatigue failure of the bolts and the separation of the propeller assembly.NTSB ERA23FA174Accident · No injuriesClass 3 · FieldFinal reportCessna 525B · Gulf of Mexico (Gulf of Mexico)The separation of the left wing extension and winglet for reasons that could not be determined based on the available evidence.NTSB WPR23LA112Accident · 1 fatalClass 3 · LimitedFinal reportStar Lite SL1 · Corning, CAThe student pilot’s loss of airplane control during an intentional aerobatic maneuver, which resulted in an inflight separation of the left wing and subsequent impact with the terrain.NTSB ERA23LA013Accident · No injuriesClass 3 · LimitedFinal reportSchempp-Hirth Discus CS · Woodstock, VAImproper repair of a crack by maintenance personnel, which resulted in a subsequent failure of the glider canopy.NTSB CEN22LA258Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland EC 135 P2+ · Waukesha, WIThe separation and subsequent ingestion of the fenestron fairing cover into the fenestron blades for undetermined reasons.NTSB ANC22FA041Accident · Serious injuriesClass 3 · FieldFinal reportBell 407 · Kalea, HIThe in-flight separation of the tail boom as a result of abnormal loading and fracture of the upper-left tail boom attachment bolt due to a gap between the upper-left longeron and aft fuselage bulkhead.NTSB CEN22LA250Incident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Evansville, INThe failure of the propeller blade due to high-cycle fatigue that originated from damage that occurred at an unknown time. Contributing to the accident was the failure to identify the damage before the accident flight.NTSB ERA22LA231Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS355 · Palm Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the unlatched engine cowling opening and being struck by a main rotor blade during flight. Contributing to the accident was the mechanic’s failure to properly secure the cowling following…NTSB ERA22LA187Accident · No injuriesClass 3 · LimitedFinal reportLancair IV · Leicester, MAA separation of the window from the airframe for undetermined reasons.NTSB DCA22FA082Accident · No injuriesClass 3 · FieldFinal reportJoby Aero JAS4-2 · Jolon, CAThe separation of a propeller blade during expansion flight testing that resulted in cascading effects to include the separation of multiple propulsion motor/propeller assemblies and the loss of remote pilot control of the aircraft. Contributing to the…NTSB ERA21LA379Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft 400A · Charleston, SCThe in-flight separation of the left engine’s four-panel cowling for reasons that could not be determined based on the available evidence.NTSB CEN21LA450Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Caddo Mills, TXThe missing vertical stabilizer hardware, which resulted in a severe uncommanded yawing motion that necessitated an emergency landing, during which the airplane nosed over and sustained substantial damage to the vertical stabilizer.NTSB ERA21LA246Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Kennesaw, GAThe mechanic’s improper installation of the left main wheel assembly.NTSB ERA21LA223Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 XL · McKenzie, TNThe improper installation and inspection of the propeller, which resulted in an in-flight separation of the propeller assembly.NTSB ERA21FA195Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 429 · Eden, NCThe impact of the main rotor blades with the tail boom during low-altitude maneuvers, which severed the tail rotor drive shaft and resulted in a loss of control and impact with terrain.NTSB ERA21LA396Accident · No injuriesClass 4 · LimitedFinal reportSonex Waiex · Doylestown, PAThe pilot’s failure to maintain a proper glidepath during landing. Contributing to the accident was his failure to ensure the canopy locks were properly configured prior to flight.NTSB WPR21LA142Accident · No injuriesClass 3 · LimitedFinal reportDavis Dan B Lancair Evolution · Phoenix, AZA malfunction of the main cabin door latching mechanism for reasons that could not be determined based on the available information.NTSB ERA21LA155Accident · Minor injuriesClass 3 · LimitedFinal reportSocata MS894A · Monroe, GAMaintenance personnel’s failure to properly inspect and maintain the airplane’s engine cowling latches, which resulted in the in-flight separation of the engine cowling and a subsequent forced landing.NTSB WPR21LA108Accident · No injuriesClass 3 · LimitedFinal reportAbbett Gerry Lancair Evolution · Saratoga, WYA windshield failure during cruise flight due to stress concentrations in the bond area as a result of improper assembly of the windshield.NTSB ANC20LA089Accident · No injuriesClass 3 · LimitedFinal reportEurocopter AS 350 · Fort Greely, AKFailure of the door lock due to interference between the door and a cargo box.NTSB CEN20LA327Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G164 · Alicia, ARInadequate maintenance of panel fasteners, which led to a side panel coming loose during takeoff and the pilot having to make a subsequent forced landing to a flooded rice field when the airplane became difficult to control.NTSB CEN20LA294Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Harlan, IAThe fatigue fracture of the upper rudder hinge that resulted in a partial separation of the rudder from the airplane during a spray pass.