NTSB investigations
563 cases where the sequence of events included 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 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 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 ERA14LA235Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Warrenton, VAThe pilot’s improper landing flare, which resulted in a hard landing and separation of the left main landing gear.NTSB ERA14LA223Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 · Hamburg, NYWear in the left cabin door assembly parts, which resulted in the door partially opening in flight, dislodging from the lower door track assembly, and then separating from the helicopter.NTSB WPR14LA179Accident · No injuriesLimited investigationFinal reportCoulter Hugh Clarke Pulsar XP Series I · Bremerton, WAFatigue failure of the nose landing gear retention and pivot shaft, which resulted in the in-flight separation of the nose gear wheel and tire assembly.NTSB ERA14LA202Accident · No injuriesLimited investigationFinal reportOconnor Paul A Ultimate Aero 10-200 · Saint Albans, VTThe propeller blade’s failure due to fatigue cracks that initiated from pitch change pin attachment holes that had been drilled too deep during manufacture.NTSB ERA14FA168Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Brunswick, GAAn inflight failure of the airplane's only operating vacuum pump, which resulted in the loss of attitude information provided by vacuum-driven flight instruments. Also causal was the pilots' failure to maintain control of the airplane while operating in…NTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB CEN14CA160Accident · Minor injuriesData collectionFinal reportPiper PA 28-235 · De Beque, COThe pilot's failure to maintain control of the airplane while maneuvering at low altitude.NTSB CEN14FA143Accident · 1 fatalField investigationFinal reportHawker SEA Fury ISS 25 · Breckenridge, TXThe pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.NTSB CEN14LA129Accident · No injuriesLimited investigationFinal reportCessna 525 · Elk City, OKThe pilot’s descent below the published minimum descent altitude for the instrument approach procedure, which resulted in impact with a utility pole.NTSB DCA14WA042Incident · No injuriesForeign investigationBoeing 767 332 · Buenos Aires, ArgentinaThe Direccion Nacional de Aviacion Civil e Infraestructura Aeronautica (DINACIA) has notified the NTSB of an incident involving Boeing 767-300, which occurred on January 21, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DINACIA…NTSB CEN14LA118Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5B · Willow Park, TXThe improper reinstallation of the propeller assembly, which resulted in the subsequent in-flight separation of the propeller.NTSB WPR14LA096Accident · 2 fatalLimited investigationFinal reportMorrisey 2150 · Pismo Beach, CAThe in-flight separation of a wing for reasons that could not be determined because the wreckage was not recovered from the ocean.NTSB ERA14LA098Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Savannah, GAMaintenance personnel’s failure to properly secure the auxiliary power unit service door before returning the airplane to service, which resulted in substantial damage to the rudder.NTSB CEN14LA075Accident · No injuriesLimited investigationFinal reportCessna 560 · Walton, INThe inflight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.NTSB CEN14FA072Accident · 1 fatalField investigationFinal reportBiesemeier David I Smyth Sidewinder · Boulder, COThe pilot’s abrupt maneuver, which exceeded the structural limits of the left wing and resulted in its in-flight separation.NTSB ERA14LA094Accident · No injuriesLimited investigationFinal reportCessna 150H · Livingston, ALThe pilot's inadequate soft-field technique during the precautionary landing, which resulted in a nose-over. Contributing to the accident was the pilot's inadequate preflight inspection, which resulted in departure with an open fuel port and the subsequent…NTSB CEN14FA009Accident · 2 fatalField investigationFinal reportCessna 500 · Derby, KSThe airplane's encounter with severe icing conditions, which resulted in structural icing, and the pilot's increased workload and subsequent disorientation while maneuvering in instrument flight rules (IFR) conditions with malfunctioning flight instruments,…NTSB WPR13FA417Accident · 2 fatalField investigationFinal reportBell UH-1V · Cordes Lakes, AZThe pilot's improper maintenance on the helicopter’s main rotor blade pitch control system, which resulted in an in-flight loss of main rotor blade pitch control, mast bumping, and mast failure.NTSB ERA13FA424Accident · 1 fatalField investigationFinal reportBrown Robert K RV7A · Hamilton Township, NJThe pilot's improper aerobatic maneuver that resulted in a loss of control, exceedance of the airplane's design limitations, and a subsequent in-flight breakup of the airplane.NTSB WPR13FA411Accident · 1 fatalField investigationFinal reportBell UH 1B · Detroit, ORThe fatigue failure of the upper two tailboom attachment points, which resulted in the tailboom separating from the fuselage during logging operations. Contributing to the accident was poor maintenance throughout the helicopter’s operational life.NTSB ENG13IA036Incident · No injuriesIncident investigationFinal reportBoeing Company, Long Beach Div Boeing MD-11 · Aguadilla, PRan insufficiently robust flange attachment hardware design, which failed to contain engine components that were liberated during an LPT mechanical failure, resulting in engine/nacelle uncontainment. A factor in the incident was the lack of a module-level LPT…NTSB CEN13CA515Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1B · Valparaiso, INThe pilot's improper recovery from a bounced landing.NTSB ERA13LA379Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe use of an improper nose landing gear through bolt, which decreased the overall strength of the gear and resulted in overload failure during a hard landing. Contributing to the accident was the student pilot's inadequate landing flare, which resulted in…NTSB CEN13CA445Accident · No injuriesData collectionFinal reportCessna 170 · Burnet, TXThe pilot's improper recovery from a bounced landing.NTSB CEN13LA409Accident · 1 fatalLimited investigationFinal reportFlight Design Ctsw · Taos, NMThe airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.NTSB CEN13LA402Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Tillar, ARThe loss of engine throttle control during takeoff due to an unsecured cockpit throttle control pin, which resulted in a runway overrun.NTSB CEN13LA384Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Heth, ARThe partial collapse of the right main landing gear during landing due to an improper previous weld repair to the right main landing gear and subsequent corrosion, which resulted in a loss of directional control and impact with terrain.NTSB CEN13IA387Incident · No injuriesIncident investigationFinal reportMartin Charles A Zenith Stol CH 750 · Paragould, ARThe improper installation of the propeller flange, which resulted in an in-flight separation of the propeller assembly.NTSB ANC13RA061Accident · No injuriesForeign investigationDe Havilland DHC-2 MK 1 · Half Moon Bay, CanadaOn June 24, 2013, at 1544 coordinated universal time, a DeHavilland DHC-2MK 1, Canadian registered C-FPCG, owned and operated by Seair Seaplanes, was substantially damaged near Half Moon Bay, Canada. Visual meteorological conditions prevailed at the time of…NTSB CEN13FA344Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Talihina, OKThe helicopter pilot's failure to see and avoid the 40-ft-tall lamp post during takeoff. Contributing to the accident was the pilot's inadequate preflight evaluation of the obstructions in the takeoff path.NTSB CEN13LA321Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Abbeville, LAFailure of maintenance personnel to ensure adequate torque of a tailrotor drive shaft coupling bolt, which resulted in the partial disconnection of the drive shaft.NTSB CEN13LA308Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Elyria, OHThe failure of the canopy latch spring, which caused the canopy to open during initial climb. Contributing to the accident was the installation of an improper part in the canopy latch assembly, which led to the failure of the canopy latch spring.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.NTSB CEN13LA298Accident · No injuriesLimited investigationFinal reportAllen Jan A Challenger II · Greeley, COThe loss of engine power due to the engine seizure, which resulted from damage caused by the ingestion of carburetor ice into the engine intake ports.NTSB ENG13IA027Incident · No injuriesIncident investigationFinal reportBoeing 747 · Atlanta, GAFailure of the right inboard foreflap outboard fitting due to fatigue and bearing anomalies on the sequence carriages which resulted in the partial separation of the right inboard foreflap. Contributing to the incident was the failure of maintenance personnel…NTSB CEN13LA260Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Lyons, KSThe partial loss of engine power due to fuel contamination, which resulted in impact with terrain. Contributing to the accident was the pilot's inadequate preflight inspection, during which he failed to detect the fuel contamination.NTSB WPR13LA191Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Mesquite, NVSeparation of the propeller from the engine during initial climb due to the incorrect torque applied to the propeller hub nut during maintenance.NTSB ERA13FA186Accident · 2 fatalField investigationFinal reportRobinson R44 · Miami, FLThe mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and the pilot's subsequent loss of control. Contributing to the accident was the…NTSB WPR13LA174Accident · No injuriesLimited investigationFinal reportVans RV12 · Waldport, ORThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB ERA13FA070Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Apollo Beach, FLMast bumping for reasons that could not be determined because one main rotor blade was not recovered.NTSB WPR13FA056Accident · 2 fatalField investigationFinal reportMcdaniel RV-6-CH · Scio, ORThe pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.NTSB WPR13FA006Accident · Minor injuriesField investigationFinal reportGarlick Helicopters UH-1H · Shady Cove, ORThe separation of the tail rotor gearbox and tail rotor assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs.NTSB ERA13LA007Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Parkersburg, WVThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR12CA401Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Lewiston, IDThe pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.NTSB ERA12TA538Accident · Minor injuriesFinal reportBell 407 · Bath, NYThe pilot's improper recovery from an in-flight upset, which resulted in the main rotor striking and separating the tail boom. Contributing to the accident was the helicopter manufacturer's failure to warn pilots of unanticipated and unequal aft cyclic…NTSB CEN12IA592Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3101 · Kansas City, MOThe flight crew’s failure to ensure that the cargo door was properly fastened before departure.NTSB CEN12LA577Accident · No injuriesLimited investigationFinal reportJones Kitfox III · Rockford, ILThe pilot's improper installation of a spark plug, which led to a partial loss of engine power after takeoff and the resultant forced landing.NTSB ERA12TA542Accident · No injuriesFinal reportRidge Lowell H Jabiru J230 · Otter Lake, NYA failure of an engine cylinder exhaust valve due to the buildup of lead deposits on the valve stem and fatigue cracking of the valve stem, resulting in a total loss of engine power, and the loss of the propeller. Contributing to the accident was the lack of…NTSB ERA12LA500Accident · No injuriesLimited investigationFinal reportBeech V35B · Effingham, SCThe pilot's failure to avoid an encounter with known adverse weather conditions, which resulted in an in-flight upset, temporary loss of control, and loading of the airframe, engine, and propeller that led to the in-flight separation of the propeller and the…