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 LAX91LA217Accident · No injuriesLimited investigationFinal reportFarrington 18A · Long Beach, CAGround resonance remedial action not performed by the pilot.NTSB SEA91LA106Accident · No injuriesLimited investigationFinal reportBeech A36 · Rawlins, WYThe pilot's lack of familiarity with the aircraft, his lack of understanding of the electrical system, and a premature precautionary landing. Contributing to the accident were an alternator failure and the resultant false readings of the powerplant…NTSB LAX91LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G164B · Yuba City, CAFatigue in the propeller blade which led to its ultimate failure. Factors relating to this accident were the soft terrain conditions on which the airplane landed and a berm across the airplane's ground path.NTSB MIA91LA144Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Tutwiler, MSFatigue failure of one of the propeller blades resulting in the forced landing. Contributing to the accident was lack of suitable terrain.NTSB NYC91LA134Accident · Minor injuriesLimited investigationFinal reportTierra II · Cooperstown, NYThe mechanical failure of the flight control system, which resulted in a a loss or airplane control and subsequent forced landing in trees.NTSB CHI91FA152Accident · No injuriesField investigationFinal reportShort Brothers SD3-60 · Chicago, ILThe failure of the nose wheel steering hydraulic line during after landing ground operations. A related factor is the manufacturer's inadequate inspection and/or replacement standards.NTSB FTW91LA077Accident · Serious injuriesLimited investigationFinal reportVuncannon Rotoway Exec 152 · Jonesboro, ARThe pilot's inadequate lookout and failure to maintain sufficient clearance from the wires for safe operation.NTSB SEA91FA099Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Ravensdale, WAThe in-flight breakup of the airplane as a result of the pilot exceeding the speed and stress limits for the airplane. A factor relating to the accident was the center of gravity loading that exceeded the aft limits.NTSB DEN91FA068Accident · Serious injuriesField investigationFinal reportBell 206B-3 · Houston, TXEngine mount delamination and lack lubrication, causing the drive shaft to fail. Poor servicing of the helicopter was a related factor.NTSB LAX91LA191Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Delano, CAThat the pilot improperly performed the autorotation by misjudging the flare altitude. Contributing to this accident was the total failure of the freewheeling sprag clutch due to excessive wear and the soft dirt terrain.NTSB NYC91FA125Accident · No injuriesField investigationFinal reportBoeing 727-100QC · Windsor Locks, CTA catastrophic and uncontained failure of the no.3 engine which resulted in a fuel fed fire.NTSB DEN91FA065Accident · 1 fatalField investigationFinal reportPiper PA-31B-310 · Bennett, COIn-flight separation of the left engine cowl assembly that was not properly latched, and failure of the pilot to maintain minimum control speed, which resulted in his loss of aircraft control. Factors related to the accident were: an inadequate preflight…NTSB FTW91LA064Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Corpus Christi, TXThe initial restricted movement and eventual locking of the cyclic control as a result of the failure of the lateral servo. A factor was the installation of the failed component by an unqualified person.NTSB CHI91FA140Accident · 1 fatalField investigationFinal reportCessna P210 · Kansas City, MOThe pilot in command's intentional flight with known mechanical deficiencies in the aircraft which resulted in a fire & forced landing in unsuitable terrain. A factor contributing to the accident was improper maintenance to the turbocharger waste gate by…NTSB FTW91FA070Accident · 2 fatalField investigationFinal reportBell 206B · So. Marsh 275The inflight structural failure and separation of the vertical fin which led to a loss of control and mast bumping. The failure of the fin was due to inadequate corrosion control efforts by the operator.NTSB NYC91LA102Accident · 1 fatalLimited investigationFinal reportSchweizer SGS-1-30 · Wurtsboro, NYAn inflight failure of the left wing spar due to overload from pilot induced control inputs, while recovering from a dive. Factors related to the accident were, the pilot's decision to fly with the trim system disconnected and lack of recent experience in…NTSB LAX91LA160Accident · No injuriesLimited investigationFinal reportBurnett, Jerry D. Challenger II · Bullhead City, AZThe disintegration of the propeller. Contributing to this accident was the deterioration of aircraft control and the nonavilability of suitable landing terrain.NTSB DCA91MA033Accident · 23 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Brunswick, GAThe loss of control in flight as a result of a malfunction of the left engine propeller control unit which allowed the propeller blade angles to go below the flight idle position. Contributing to the accident was the deficient design of the propeller control…NTSB BFO91LA042Accident · No injuriesLimited investigationFinal reportBeech P35 · Gilbertsville, KYThe pilot's failue to ensure the gear was fully extended during a precautionary landing after the loss of electrical power for undetermined reasons.NTSB ATL91LA076Accident · No injuriesLimited investigationFinal reportDavid Lowe ULTRA-PUP · Waycross, GAThe failure of the airplane battery, which prohibited the complete extension of the landing gear, resulting in a landing with the nose gear retracted. A factor in the accident was the soft terrain at the selected landing area.NTSB LAX91LA172Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Papua, Papua New GuineaThe loss of control of the helicopter due to a restriction of the cyclic control system.NTSB CHI91IA120Incident · No injuriesIncident investigationFinal reportCessna 172RG · West Chicago, ILFailure of the splined shaft on the right main landing gear pivot assembly. A factor related to the incident was inadequate design of the landing gear pivot assembly.NTSB SEA91LA077Accident · No injuriesLimited investigationFinal reportBell BH-47G2A · Waitsburg, WAThe improper installation of the main rotor mast nut and lock washer by maintenance personnel which resulted in the separation of the main rotor system.NTSB ANC91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Kenai, AKThe failed nose gear shimmy dampner, contributing to the accident was the rough ice and snow covered ramps where the airplane had been operating and the lack of maintenance on the runways.NTSB LAX91LA135Accident · No injuriesLimited investigationFinal reportMooney M20D · Herlong, CAThe inadequate preparation of the propeller during overhaul. The installation of an improper pitched propeller and the fatigue failure of the propeller blade emanating from corrosion were factors in the accident.NTSB ATL91FA067Accident · 2 fatalField investigationFinal reportPiper PA-28-201T · Hamilton, NCThe pilot's improper use of equipment which affected the operation of the standby vacuum pump, the pilot's loss of aircraft control after experiencing spatial disorientation, and his exceeding the design stress limits of the aircraft. Factors related to the…NTSB LAX91FA134Accident · 2 fatalField investigationFinal reportCessna 172RG · Buckeye, AZThe pilot of the airplane exceeding the certificated never exceed velocity. The overloading of the wing attachment fittings while maneuvering was a factor in the accident.NTSB ATL91LA066Accident · 1 fatalLimited investigationFinal reportBenson B8M · Hartselle, ALThe improper installation of the main rotor bearing block by the owner/pilot which resulted in the separation of the main rotor system.NTSB MIA91LA113Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Vero Beach, FLImproper maintenance adjustment by company maintenance personnel resulting in overtorque of a tailboom attach bolt which allowed the tailboom to shift. This disengaged the tail rotor drive shaft at a coupling resulting in the loss of tail rotor drive.NTSB MIA91FA095Accident · 3 fatalField investigationFinal reportBeech 35-C33A · Key West, FLThe pilot-in-command's failure to maintain airspeed, while returning for an emergency landing following propeller failure, resulting in the aircraft stalling and entering a spin.NTSB ANC91LA033Accident · No injuriesLimited investigationFinal reportCessna A185-F · Shageluk, AKThe collapse of the left main landing gear during the landing roll due to preexisting cracks.NTSB DCA91MA023Accident · 25 fatalClass 1 · MajorFinal reportBoeing 737-291 · Colorado Spgs, COA loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…NTSB ATL91LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Suches, GAThe pilot's failure to maintain altitude during cruise flight after loss of electrical power for an undetermined reason.NTSB DEN91IA047Incident · No injuriesIncident investigationFinal reportCessna 421C · Fort Morgan, COThe total failure of the flight compartment windshield (copilot's side) for undetermined reasons.NTSB MIA91LA084Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ldl-By-The-Sea, FLTail rotor blade failure due to undetermined reasons and unsuitable terrain during a precautionary landing.NTSB CHI91LA097Accident · Serious injuriesLimited investigationFinal reportHughes 269C · North Mankato, MNThe fatique failure of the tail boom support strut attachment cluster and the improper inspection of the cluster attachment.NTSB LAX91FA103Accident · Serious injuriesField investigationFinal reportCessna 172 · Bullhead City, CAThe pilot's poor in-flight planning and decision and physical impairment from fatigue; he also failed to maintain flying speed. The lineman's failure to secure the access door and the pilot's impairment due to consumption of alcohol were factors in the…NTSB LAX91LA123Accident · No injuriesLimited investigationFinal reportBeech B95 · Riverside, CAFailure of the pilot to follow the emergency gear extension procedure to fully extend the landing gear. Contributing to the accident was the failure of the pilot to monitor the condition of the electrical power system, leading to the complete loss of…NTSB LAX91LA092Accident · No injuriesLimited investigationFinal reportCessna 150M · Buckeye, AZThat maintenance personnel failed to properly install the wings by not reconnecting the bolts at the bellcrank and performed an inadequate annual inspection.NTSB LAX91LA090Accident · Serious injuriesLimited investigationFinal reportRiddell Lancair 235 · Agua Caliente, CAThe failure of the propeller blades due to a weakening of the wood structure due to acid hydrolysis. A factor in the accident was the inadequate maintenance of the propeller assembly by allowing exposure to excessive moisture and heat.NTSB CHI91LA086Accident · No injuriesLimited investigationFinal reportBeech 200 · Indianapolis, INSeparation of the aft, upper, accessory case cowl assembly from the airplane, and inadequate airframe equipment provided by the manufacturer.NTSB NYC91DFA02Accident · 1 fatalFinal reportHayes Kolb/Twinstar · Round Lake, NYIn-flight structural failure of the outboard wing attachment fittings on both wings due to an undetermined reason.NTSB FTW91FA033Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oppella, ARThe pilot's failure to maintain a proper climb rate following loss of his visual references and allowing himself to become diverted during the takeoff. Factors in the accident were interrupted instrument lighting and the dark night conditions.NTSB LAX91LA099Accident · Minor injuriesLimited investigationFinal reportWalter Chandler Phoenix · Cayucos, CAThe pilot's selection of unsuitable terrain and his misjudgment of the proper touch down point following the pilot's decision to make a precautionary landing. Contributing to the accident was an in-flight separation of the trim tab rod from the trim tab,…NTSB LAX91LA079Accident · No injuriesLimited investigationFinal reportRobinson R-22 HP · Scottsdale, AZThe failure of the drive belts due to excessive wear of the clutch assembly upper sheave and the pilot's inaccurate flare during the termination of the autorotation. A factor in the accident was the inadequate design of the clutch assembly upper sheave.NTSB NYC91LA062Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Cleveland, OHFatigue failure of the number two propeller blade actuating pin, due to improper installation of the pins and non-compliance with an airworthiness directive (AD 77-13-77).NTSB SEA91FA261Accident · No injuriesField investigationFinal reportBeech 35 · Walla Walla, WAImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter. Improper installation of the trim tabs and an encounter with turbulence were related factors.NTSB MIA91LA064Accident · No injuriesLimited investigationFinal reportCessna 175 · Okeechobee, FLFailure of the right brake line at the caliper during the landing roll rendering the brakes ineffective. A factor was the pilot's misjudgement of wind direction.NTSB FTW91FA029Accident · Serious injuriesField investigationFinal reportBeech F-90 · Nacogdoches, TXThe loss of thrust due to the propeller's feathering on liftoff as a result of improper adjustments made during an engine change. A factor was the lack of suitable terrain to which the pilot could execute a forced landing.NTSB ATL91FA020Accident · 2 fatalField investigationFinal reportMooney M20F · Pageland, SCFailure of the pilot to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the weather conditions and the malfunction of a gyro instrument (probably the attitude indicator).