NTSB investigations
288 cases where the defining event was Part(s) separation from AC.
Cases, newest first
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.\"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."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 WPR20LA062Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · El Monte, CAThe inflight separation of a section of a propeller blade due to a fatigue crack which resulted in a forced landing.NTSB CEN20LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 525A · Scotts Bluff, NEThe installation of incorrect mounting hardware to secure the right engine cowl, which resulted in an in-flight separation and impact with the horizontal stabilizer and elevator.NTSB WPR20WA251Incident · No injuriesForeign investigationDe Havilland DHC8 · Eaton, AustraliaThe government of Australia has notified the NTSB of an accident involving a De Havilland DHC8 airplane that occurred on December 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB WPR20LA026Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Livermore, CAThe improper installation of the flight control stick, which resulted in separation of the flight control stick from the stick stub assembly and an uncontrolled descent and impact with terrain.NTSB DCA20WA016Incident · No injuriesForeign investigationBoeing 747 · Leipzig, GermanyThe government of Germany has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB GAA20CA039Accident · No injuriesData collectionFinal reportZenair CH 701 · Safford, AZThe in-flight separation of a propeller blade for reasons that could not be determined based on the available evidence, which resulted in an off-airport landing on soft sand and the separation of main landing gear. Contributing to the accident was the pilot’s…NTSB WPR20WA011Incident · No injuriesClass 5 · ForeignDiamond DA42 · Singapore, SingaporeNTSB WPR19LA273Accident · No injuriesClass 3 · LimitedFinal reportSmyth Sidewinder · Tucumcari, NMThe in-flight separation of a section of a propeller blade due to a fatigue crack, which resulted in a forced landing.NTSB WPR19LA255Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S58 · Azusa, CAThe in-flight separation of a section of the tail rotor blade due to a fatigue crack, which resulted in the pilot’s forced autorotation into a field.NTSB CEN19LA322Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Pocahontas, IAOverload failure of the left main landing gear during landing, which resulted in a loss of directional control.NTSB WPR19LA242Accident · No injuriesClass 3 · LimitedFinal reportLockheed C130 · Santa Barbara, CAThe failure of the No. 3 bleed air duct due to corrosion, which resulted in numerous system failures and the pilot’s inability to maintain directional control during the landing roll.NTSB CEN19WA289Accident · 1 fatalForeign investigationCapella XS · San Juan del Puerto, SpainOn August 23, 2019, about 1905 hours universal coordinated time, an amateur-built Capella XS airplane, Spanish registration EC-YTA, impacted terrain after an inflight separation of a wing near San Juan del Puerto, Spain. The pilot was fatally injured, and the…NTSB GAA19WA547Accident · No injuriesForeign investigationPiper PA28R · Sligo, IrelandThe government of Ireland has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on August 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB CEN19LA251Accident · No injuriesClass 3 · LimitedFinal reportRyan Navion · Chicago, ILThe failure of the left main landing gear upper side brace assembly during landing due to reverse bending fatigue as a result of the incomplete penetration of the circumferential weld during initial production of the component.NTSB DCA19WA183Incident · No injuriesForeign investigationBoeing 747 · Harare, ZimbabweThe CAA of Zimbabwe has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on July 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAAZ's investigation under the provisions of ICAO Annex 13 as State…NTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.NTSB CEN19LA166Accident · No injuriesClass 3 · LimitedFinal reportBeech E90 · Greenville, TXThe fatigue failure of the right main landing gear upper torque knee.NTSB ANC19LA024Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC · Nome Creek, AKThe failure of the airplane's structural tubing due to corrosion, which resulted in a tailwheel separation and a subsequent loss of control. Also causal was the mechanic's failure to perform a detailed inspection of the aft fuselage during the most recent…NTSB CEN19LA133Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Mineral Wells, TXThe in-flight separation of the right aileron when the inboard hinge bolt disengaged from its nut plate due to excessively twisted safety wire, which resulted in a torsional overstress fracture that caused the inboard hinge bolt to become unsecured.NTSB DCA19WA072Incident · No injuriesForeign investigationBoeing 787 · Casablanca, MoroccoThe BEA of Morocco has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on February 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of Morocco's investigation under the provisions of ICAO Annex…NTSB ERA19LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Simsbury, CTMaintenance personnel's inadequate inspection of the wheel brake system during the airplane's most recent 100-hour inspection, which resulted in a loss of hydraulic fluid and the pilot's inability to control the airplane during the landing.NTSB WPR19LA028Accident · No injuriesClass 3 · LimitedFinal reportBell 430 · Kailua, HIThe separation of one of the tail rotors blades’ root enclosures due to improper repair.NTSB GAA18CA544Accident · No injuriesData collectionFinal reportHalladay Roy Lockheed · Denver, COThe pilot's failure to verify that the emergency canopy release was in the correct position when opening the canopy during landing, which resulted in the canopy separating from the airplane and subsequently impacting the empennage.NTSB WPR18TA239Accident · Minor injuriesClass 3Final reportEurocopter EC130 · Hilo, HIThe separation of the left sliding door in flight after it opened for reasons that could not be determined based on the available evidence, which resulted in damage to the main rotor blades.NTSB ANC18LA067Accident · No injuriesLimited investigationFinal reportCessna U206 · Pedro Bay, AKThe fatigue fracture of both main landing gear legs during the landing roll, which resulted in the collapse and separation of both main landing gear legs.NTSB CEN18LA313Accident · No injuriesLimited investigationFinal reportBrantly B-2 · Midland, MIThe in-flight separation of the tail rotor blade due to fatigue, which resulted in the subsequent emergency landing and dynamic rollover.NTSB CEN18FA258Accident · 1 fatalField investigationFinal reportBell 47G · Arlington, INThe inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.NTSB ANC18WA060Accident · No injuriesForeign investigationBell 205 · Hudson Bay, CanadaOn June 27, 2018, at 1713 central standard time, a Canadian registered Bell 205A helicopter, C-FYHD, operated by Transwest Air Ltd Partnership, was substantially damaged during a precautionary landing due to severe airframe vibration at Buckmayer Lake,…NTSB ERA18WA156Incident · No injuriesForeign investigationCessna 152 · Tulua, ColombiaThe government of Colombia has notified the NTSB of an accident involving a CESSNA 152 airplane that occurred on May 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions of…NTSB WPR18LA147Accident · Serious injuriesClass 3 · LimitedFinal reportBell UH 1H · Olympia, WAA loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…NTSB WPR18LA158Accident · No injuriesClass 3 · LimitedFinal reportRhoads Autogyro MTO Sport · San Manuel, AZThe fracture of the propeller hub due to corrosion pitting along the propeller blade root seat, which led to cracking that was propagated due to high-cycle fatigue.NTSB WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.NTSB DCA18WA155Incident · No injuriesForeign investigationBoeing 737 · MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ERA18WA132Accident · No injuriesForeign investigationBell 206 · Vereda Plateado, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.NTSB GAA18CA108Accident · No injuriesData collectionFinal reportPiper J3L · Astoria, ORThe control stick handgrip separation from the control stick resulting in the airplane pitching forward, which resulted in hard landing.NTSB CEN18CA072Accident · No injuriesData collectionFinal reportBell Helicopter Textron Canada 407 · Norfolk, NEMaintenance personnel’s failure to properly secure the tail rotor drive shaft cover, which resulted in the cover departing the helicopter in flight.NTSB ANC18LA018Accident · No injuriesClass 2 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006 · Lynchburg, VAThe failure of the left main landing gear assembly due to a fatigue fracture along the inside circumferential weld on the trailing arm’s attachment flange, which resulted from the manufacturer’s inadequate welding of the trailing arm connecting the lower arm…NTSB GAA18CA077Accident · No injuriesData collectionFinal reportCzech Sport Aircraft a.s. Sport Cruiser · Sacramento, CAThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB ANC18LA008Accident · No injuriesLimited investigationFinal reportCloud Jeffrey Ferrell Long EZ · Eufaula, ALThe in-flight separation of a portion of the propeller, which subsequently penetrated the right rudder, as a result of the failure of the bond line between two of the propeller’s wood layers. Contributing to the failure of the propeller was the manufacturer’s…NTSB CEN18LA027Accident · Serious injuriesLimited investigationFinal reportRiggs Kenneth W T Bird II · St Mary's, KSThe loss of engine power due to a propeller failure when the passenger’s hat exited the cockpit and impacted the three-bladed pusher propeller, separating one of the propeller blades.NTSB DCA17WA205Incident · No injuriesForeign investigationBoeing 777 · Osaka, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 777 airplane that occurred on September 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…NTSB CEN17LA333Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA 5B · Carbondale, ILThe failure of the propeller due to fatigue as a result of improper installation by unknown maintenance personnel at some point during the life of the propeller.NTSB ERA17LA298Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Wurtsboro, NYA fatigue fracture of the left main landing gear axle.NTSB ANC17LA052Accident · No injuriesLimited investigationFinal reportCessna A185 · Aniak, AKThe pilot's inadequate preflight inspection, which failed to detect a crack in the propeller blade, which led to the separation of a section of a propeller blade due to fatigue.NTSB CEN17LA312Accident · No injuriesLimited investigationFinal reportRalph Marine Devil DOG · Danville, ARA separation of the left tire from its wheel because of the use of an improper substance and wheel size, which resulted in a loss of directional control during landing.NTSB CEN17LA264Accident · No injuriesLimited investigationFinal reportBell 47D1 · Big Lake, MNThe failure of the metal core assembly within a wooden main rotor blade due to undetected corrosion and fatigue, which caused the wooden blade to separate from the rotor mast.NTSB CEN17LA235Accident · No injuriesLimited investigationFinal reportCessna 182A · Buffalo, OKThe separation of the nose wheel axle bolt and the nose wheel during the landing roll for reasons that could not be determined because the bolt was not recovered.NTSB GAA17CA321Accident · No injuriesData collectionFinal reportAg-Cat G 164 · Tulelake, CAThe pilot’s improper decision to perform a low altitude fly-by over ground equipment, which resulted in the airplane striking the equipment.NTSB WPR17LA119Accident · No injuriesClass 3 · LimitedFinal reportPaul R Seipt Sonex · Garfield, WAThe pilot’s improper torque of screws that attached the flywheel mounting flange to the crankshaft during engine assembly, which resulted in heavy vibrations and the subsequent in-flight loss of the propeller.