NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 CHI92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Breezy Point, MNThe partial failure of the tail wheel assembly due to a fatigue fracture of an internal spring.NTSB NYC92LA097Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Hazard, KYThe internal failure of the brake's master cylinder. Factors contributing to this accident were; the pilot's improperly planned approach and failure to touch down at the proper point.NTSB ATL92IA113Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-1 · Atlanta, GAThe overheating of the number 2 air cycle machine which resulted in an emergency evacuation via slides; the failure of the flight attendants to secure the slide girt bars.NTSB CHI92LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Round Lake, ILThe pilot-in-command's failure to follow emergency procedures, and the fire in the electrical system for reasons undetermined.NTSB LAX92LA225Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus A/16.6 · Tucson, AZThe inflight disconnection of the right aileron 'otellier coupler fitting due to lubricants on the coupler slide lock plate, and the failure of the glider manufacturer to include appropriate precautionary information in the maintenance and/or flight manual.…NTSB ATL92LA110Accident · 1 fatalLimited investigationFinal reportWicks Bobcat · White House, TNThe pilot/owner's improper design change of the wing spar which resulted in the overload failure of the left wing. A factor was the pilot/owner's failure to perform a periodic inspection.NTSB SEA92LA220Accident · No injuriesLimited investigationFinal reportBellanca 7ACA · Rosalia, WAFailure of the tailwheel spring bracket. A factor to the accident was: directional control was not maintained.NTSB CHI92DCG02Accident · No injuriesFinal reportA. H. Gettings Glassair SH2 · Marshall, MOThe pilot's inadequate pre-takeoff flight control check.NTSB ATL92LA112Accident · No injuriesLimited investigationFinal reportCessna 210F · Manteo, NCThe pilot's inadequate emergency procedures, in that he failed to note the discharge of electrical power on the ammeter, and his loss of directional control during the off airport landing. Factors were the disabled alternator and a low cloud ceiling.NTSB BFO92LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Coatesville, PAThe passengers interference with the control yoke, which resulted in the airplane entering an unusual attitude, and the pilot overstressing the wings during the recovery.NTSB LAX92IA209Incident · Minor injuriesIncident investigationFinal reportBoeing 767-222 · Los Angeles, CAA rupture in the airplane's air condition/heat/pressurization/apu duct, along its welded seam. Contributing to the incident was the manufacturers' failure to issue a service bulletin applicalbe to all APU ducts in the systems.NTSB CHI92LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Olathe, KSThe in flight separation of the propeller tip. An associated factor is the rough and uneven terrain.NTSB BFO92LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Falmouth, KYThe pilot misjudged the airplane's altitude and distance in reference to the runway. Contributing to the accident was the fuel system leak.NTSB CHI92DEM02Accident · No injuriesFinal reportGillespie/Pitts S1C · Freeland, MIA total failure of the rudder control cable and unavailability of rudder to control the airplane during its landing process. Factors which contributed to the accident were directional control and remedial action not being possible on behalf of the pilot.NTSB FTW92LA125Accident · Serious injuriesLimited investigationFinal reportShewmaker BD5 · Castroville, TXThe pilot's failure to maintain aircraft control during the flare. Factors were the engagement of the propeller feathering system and the pilot's total lack of experience in type aircraft and the slipped propeller pitch change system.NTSB NYC92GA089Accident · No injuriesFinal reportMcdonnell Douglas 500E · Mount Zion, KYAn in-flight separation of the tail rotor assembly as the result of the loss of an abrasion strip from the leading edge of one of the tail rotor blades, which induced vibrational stresses high enough to initiate fatigue failure in the tail rotor gear box…NTSB CHI92LA137Accident · Serious injuriesLimited investigationFinal reportBell 47-G2A · Dousman, WIThe in-flight loss of the swash plate drive link bolt which allowed the swash plate drive assembly to disconnect.NTSB MIA92FA115Accident · No injuriesField investigationFinal reportBoeing 707-324C · Miami, FLFailure of the #3 engine pylon inboard midspar support fitting due to fatigue cracking which resulted in the separation of the number three engine and pylon. Contributing to the accident was the inadequate inspection requirements of the manufacturer and the…NTSB LAX92LA187Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Van Nuys, CAThe inadequate inspection of the airplane's brakes system by maintenance personnel and the maintenance personnel not replacing brake linings that were worn beyond their service limits. The runway lights and fence that were in the airplane's ground path after…NTSB LAX92LA179Accident · No injuriesLimited investigationFinal reportHomebuilt Dragonfly · Parker, AZAn oil leak from an unidentified source. The high vegetation along the forced landing area contributed to this accident.NTSB NYC92DHM02Accident · No injuriesFinal reportCarey Glassair SH2 · West Milford, NJImproper installation of the wheel brakes, which resulted in failure of a left brake line during the landing roll and subsequent loss of directional control and collision with an object after departing the runway.NTSB LAX92LA175Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Pacific Ocean (Pacific Ocean)An undetermined failure in the rotor system.NTSB NYC92LA076Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-32 · Dayton, OHA failed wheel rim following an inadvertent over inflation by the mechanic. Additional causes were the failure of the mechanic to be aware of the pressure being used and his failure to follow procedures. A factor related to the accident was the failure of the…NTSB MIA92FA108Accident · 2 fatalField investigationFinal reportGlobe GC1-B · Miami, FLAn abrupt pitch up maneuver during acrobatic flight resulting in an overload failure of the right wing spar.NTSB FTW92LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Denver, COThe loss of hydraulic fluid due to a ruptured hydraulic line in the landing gear system.NTSB LAX92LA252Accident · No injuriesLimited investigationFinal reportBeech B-35 · Newhall, CAImproper ruddervator balancing that resulted in ruddervator flutter. Contributing to the accident was insufficient maintenance information to assure that AD compliance and elevator balancing was performed, and an inadequate annual inspection procedure that…NTSB CHI92LA118Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Joliet, ILThe pilot-in-command's failure to follow emergency procedures, and the failure of the electrical system. Factors contributing to the accident were electrical arcing, and the lack of total experience in the type of aircraft by the pilot-in-command.NTSB BFO92LA047Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Pikeville, KYDelamination and subsequent failure of a main rotor blade.NTSB LAX92FA149Accident · Serious injuriesField investigationFinal reportAyres S2R-T34 · Bakersfield, CAA catastrophic wing spar failure precipitated by hidden corrosion and the restricted view of the area of corrosion by the airplane's wing structure.NTSB CHI92DCA01Accident · No injuriesFinal reportGrumman G-164 · Malden, MOThe pilot could not maintain directional control after one of the main landing gear brakes jammed during a landing roll. The operator did not comply with an airworthiness directive issued to prevent a possible braking system malfunction.NTSB LAX92LA146Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Huron, CAA separation of the control rotor cuff due to fatigue.NTSB CHI92LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Langdon, NDFailure of the pilot to fully extend the landing gear using manual procedures after an electrical system failure. A factor associated with the accident is the pilot misreading a published emergency procedure.NTSB ANC92LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shageluk, AKThe left main landing gear ski being partially disconnected at the time of the landing. Contributing factors were the inadequate preflight by the pilot, and the snow covered landing area.NTSB LAX92LA150Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Austin, NVThe pilot's loss of control due to the failure of his control wheel during an attempted go around.NTSB CHI92FA104Accident · 3 fatalField investigationFinal reportCessna 414 · Freeland, MIThe pilot's poor judgement in attempting flight after the airplane's fuselage was damaged during a loading operation. Factors which contributed to the accident were: the operator's failure to provide proper weight and balance data for the airplane, the…NTSB LAX92FA137Accident · 1 fatalField investigationFinal reportRobinson R22 · Maricopa, AZDestructive mast bumping for an undetermined reason(s).NTSB CHI92IA101Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Chicago, ILContaminated anti-skid braking system electrical connectors which resulted in a partial loss of the anti-skid system and locking up of the brakes on the left main gear.NTSB FTW92FA077Accident · 1 fatalField investigationFinal reportBell 212 · Morgan City, LAThe inflight separation of the main rotor system as results of the main rotor static stop contacting the mast for undetermined reasons.NTSB FTW92LA072Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Oklahoma City, OKThe propeller hydraulic control pitch setting being incorrect for undetermined reasons. A factor in the accident was the pilot's failure to identify and correct the pitch setting as the propeller went to a higher setting.NTSB ANC92FA040Accident · 6 fatalField investigationFinal reportBell 214B-1 · Hobart Bay, AKSeparation of the tail rotor and 90 degree gearbox due to the pilot's failure to follow procedures/directives which resulted in the external load cable becoming entangled in the tail rotor. Factors were the turbulent weather and the lack of suitable terrain…NTSB LAX92LA118Accident · Minor injuriesLimited investigationFinal reportAvions Mudry CAP-10B · Santa Paula, CAThe failure of the airplanes's left wing spar due to stress overloading caused by pre-existing compression failures in the laminate.NTSB MIA92IA081Incident · No injuriesIncident investigationFinal reportBoeing 727-214A · San Juan, PRThe flight engineer's lack of training in emergency procedures and his failure to follow published emergency procedures, resulting in his not being able to manually extend the right main landing gear, following the loss of the 'a' hydraulic system.…NTSB LAX92LA108Accident · Serious injuriesLimited investigationFinal reportSikorsky S55B · Richvale, CAThe failure of the lateral control arm in the cyclic control system.NTSB FTW92LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXThe pilot's failure to fully extend the landing gear by the alternate gear extention system. Factors were the dark night, low ceiling, fog, drizzle and failure of the electrical system.NTSB ANC92LA032Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Metlakatla, AKTotal failure of the rivets attaching the trim tab control horn to the right elevator trim tab.NTSB CHI92DCD01Accident · 1 fatalFinal reportRaymond Bristow Rand KR-2 · Boone, IAFailure of the pilot to maintain aircraft control. A factor in the accident is total failure of the airplane canopy.NTSB CHI92LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Cedar Rapids, IAA result of the pilot-in-command not understanding the airplanes emergency procedures and not performing the appropriate emergency procedures. A factor associated with the accident was an electrical system failure.NTSB LAX92LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ft Mojave, AZAn inadequate annual inspection performed by other maintenance personnel. Contributing to this accident was the flap cable failure due to corrosion.NTSB CHI92IA079Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355F1 · Lansing, MIA fatigue failure of a fuel system line fitting during cruise flight.NTSB DEN92FA028Accident · No injuriesField investigationFinal reportBeech 35 · Nucla, COImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.