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 LAX00LA239Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Arbuckle, CAthe partial failure of the tail rotor pitch change control rod that resulted in an attempted run-on landing in dark night conditions.NTSB ATL00LA067Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Tylertown, MSLoss of directional control due to separation of the tail-wheel spring assembly. A factor was the ditch which run adjacent to the runway.NTSB ANC00LA072Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe fatigue failure of the left main landing gear leg at the main landing gear axle attachment bolt holes.NTSB SEA00IA108Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73 · Seattle, WAAuxiliary hydraulic pump leak resulting in a failure of the hydraulic system.NTSB MIA00IA186Incident · No injuriesIncident investigationFinal reportGrumman G-73T · Watson Island, FLthe overload separations of the control yoke on the captain's side.NTSB SEA00LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Hillsboro, ORThe pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…NTSB CHI00IA152Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Lafayette, INThe blocked drain lines in the canted pressure deck and the frozen aileron cable.NTSB SEA00LA097Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene, ORInadequate quality control by the manufacturer during the manufacturing process, which led to the total failure of a fastener, and the separation of the tail rotor blade balance weight. An adhesive debond between the adhesive and the surface was a factor.NTSB DEN00LA100Accident · No injuriesLimited investigationFinal reportCulver LFA · Moab, UTOverheating of the left brake, causing the wheel to lock. Factors were the pilot not being able to maintain directional control, a dirt berm, and a drainage ditch.NTSB DEN00LA099Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Milford, UTThe failure of the turbocharger scavenging pump resulting in the total failure of the engine, and the pilot's failure to compensate for wind conditions that led him to over fly the runway during his forced landing. Factors were the pilot's diverted attention…NTSB SEA00LA090Accident · No injuriesLimited investigationFinal reportCessna T210M · Boise, IDThe deterioration and subsequent leakage of a hydraulic line which resulted in the total loss of hydraulic fluid and the inability of the pilot to extend the landing gear into the locked position.NTSB MIA00LA170Accident · No injuriesLimited investigationFinal reportSouthwest Florida SW204 · Fort Pierce, FLAn in-flight separation of a tail rotor blade tip weight resulting in tail rotor assembly imbalance and separation due to the installation of an unapproved rotor blade by company maintenance personnel, and the subsequent collision with trees during an…NTSB FTW00LA153Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Patterson, LAthe failure of the tail rotor spider bearing, the pilot's failure to follow the proper emergency procedures as stated in the helicopter's checklist by not performing a run-on landing, and the inadvertent deactivation of the hydraulic system.NTSB FTW00LA149Accident · Serious injuriesLimited investigationFinal reportPZL-Mielec M-18A · Kilbourne, LAThe corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight.NTSB NYC00LA134Accident · 1 fatalLimited investigationFinal reportHing FLY Baby 1A · Keymar, MDAn overload failure of both flying wires, on the underside of the right wing, while the airplane was climbing, due to improper balance between the two flying wires, by unknown person(s).NTSB CHI00LA135Accident · 1 fatalLimited investigationFinal reportRotorway Exec 162F · Ithaca, MIthe door separation for undetermined reasons and the foreign object damage due to the door impact to the tailboom and tail rotor drive system.NTSB MIA00LA150Accident · No injuriesLimited investigationFinal reportCessna 172H · Picayune, MSAn in-flight fire in the vicinity of the firewall from an undetermined source. This resulted in a forced landing to an airport and total consumption of the airplane by fire after landing.NTSB ATL00LA055Accident · Minor injuriesLimited investigationFinal reportJackson Velocity RG · Kennesaw, GAA separation of the lower engine cowling and subsequent partial separation of propeller blades during a low high-speed pass. A factor was the recent maintenance work performed by the owner/pilot mechanic.NTSB MIA00FA146Accident · No injuriesField investigationFinal reportBeech F35 · Jackson, MSimproper rigging of the rudder/elevators and differential mechanism assembly by unknown person(s), which resulting in what the pilot describes as inflight flutter of the tail section, which resulted in damage to the aft empennage area.NTSB LAX00GA185Accident · Serious injuriesFinal reportBeech 65-90 · China Lake, CAthe inadvertent early deployment of the test parachute lines and dummy and it's entanglement with the horizontal stabilizer, which resulted from the operator's inadequate test plan substantiation process for shortening the parachute's static line. .NTSB NYC00IA124Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · White Plains, NYThe pilots of the CRJ were conducting a visual approach at night. As the wing flaps were extended from 30 degrees, to 45 degrees, there was an uncommanded extension of the right wing flight spoiler. A roll to the right accompanied the extension, which was…NTSB FTW00LA137Accident · No injuriesLimited investigationFinal reportBell 206L3 · Salt MarshThe company mechanic's failure to replace the bolt's cotter key properly and the subsequent loss of the nut, which then resulted in the tail rotor control disconnection and the pilot's inability to maintain aircraft control.NTSB DEN00FA078Accident · No injuriesField investigationFinal reportDouglas DC-8-62F · Denver, COThe failure of the clamp that secured the high-pressure bleed air duct to the high-pressure relief valve. Factors were the resulting excessive pressurization of the engine nacelle, and the subsequent separation of the engine cowling.NTSB LAX00FA169Accident · 1 fatalField investigationFinal reportAir Tractor 502A · Queen Creek, AZThe fatigue failure and in-flight separation of the left wing due to the manufacturer's underestimation during the aircraft design process of the time interval from fatigue crack initiation to failure, and, the manufacturer's subsequent specification of an…NTSB CHI00LA118Accident · No injuriesLimited investigationFinal reportCessna 170A · St. Paul, MNthe broken landing gear axle.NTSB LAX00TA163Accident · Minor injuriesFinal reportHughes OH-6A · Green Valley, AZCompany maintenance personnel's failure to secure an attachment nut to a control link. While maneuvering, the parts separated and resulted in the total cyclic control system failure and impact into rough terrain.NTSB ATL00LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Rock Hill, SCThe maintenance personnel's failure to re-torque the engine driven fuel pump in accordance with an Airworthiness Directive that resulted in a fuel leak and a subsequent engine fire.NTSB DEN00FA074Accident · No injuriesField investigationFinal reportBell 206L-3 · Lakewood, COThe complete loss of the tail rotor blades due to a fatigue failure of one blade. Factors were sloping and rough uneven terrain for the ensuing forced landing.NTSB MIA00LA134Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Lakeland, FLThe disconnection of the tail rotor drive shaft and subsequent lack of tail rotor control. Contributing factors were the worn drive shaft splines and the pilots' failure to apply collective on the touchdown resulting in a hard landing and subsequent roll over.NTSB LAX00LA155Accident · Minor injuriesLimited investigationFinal reportSmith RV-4 · Willows, CADisconnection of the elevator push rod due to the owner/builder's improper installation of the rear jam nut on the elevator pushrod.NTSB MIA00LA131Accident · Minor injuriesLimited investigationFinal reportMcCan Velox REV II · Mulberry, FLThe bending overstress separation of the elevator pitch control rod for undetermined reasons. This resulted in an in-flight loss of control, bail out, and subsequent in-flight collision with terrain.NTSB SEA00IA069Incident · No injuriesIncident investigationFinal reportCessna 182P · Tacoma, WAFlap attachment failure. Restricted movement of the aileron was a factor.NTSB MIA00LA137Accident · Minor injuriesLimited investigationFinal reportWalden A. Cooper Pitts S1S · Daytona Beach, FLCollapse of the tail wheel to the right during landing rollout when the forward attach bolt sheared for undetermined reasons. This resulted in the aircraft's rudder deflecting to the right, the pilot losing directional control, and the aircraft running off…NTSB SEA00LA065Accident · No injuriesLimited investigationFinal reportAero Design Eleven 12 · Spokane, WACracking of the weld between the tailwheel stinger housing and longitudinal cross tube, resulting in separation of the tube/tail wheel assembly from the airframe.NTSB SEA00LA066Accident · No injuriesLimited investigationFinal reportBeech A200 · Seattle, WAThe pilot's failure to properly follow pre-takeoff checklists (resulting in the engine starters remaining engaged after engine start, generators not being activated, discharge of the aircraft battery and consequent total electrical failure during flight with…NTSB IAD00FA034Accident · No injuriesField investigationFinal reportTaylorcraft BC12D-4-85 · Dameron, MDThe failure of the float landing gear system due to non-standard repairs, improper modifications, and corrosion.NTSB LAX00LA173Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Chandler, AZThe inadequate maintenance inspection of the secondary shaft which resulted in its fatigue failure that emanated from a corroded circumferential score mark. A factor was the fence that the pilot flared to avoid, resulting in a hard landing.NTSB MIA00IA128Incident · No injuriesIncident investigationFinal reportDassault DA-20 · Opa Locka, FLThe failure of the PIC to execute the complete procedure for emergency extension of the landing gear and the subsequent landing with the left main landing gear not locked fully down, resulting in an excursion off the runway and collision with a runway…NTSB NYC00IA116Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1125 · Pine Knot, KYThe partial failure of an inverter and the inadequate design of the electrical circuit breaker system.NTSB SEA00FA061Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Stanwood, WAThe disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…NTSB SEA00LA059Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WADisintegration of a lining of the right brake and subsequent lodging of brake lining debris between the brake housing and brake disc, resulting in seizure of the right brake. A factor was that directional control was not possible.NTSB CHI00LA100Accident · No injuriesLimited investigationFinal reportPiper J-3C · Eureka, SDthe foreign object (shot gun shell) which jammed the control stick. Factors associated with the accident were the low altitude at which the control stick jammed and the rough terrain which the airplane contacted.NTSB LAX00FA136Accident · Serious injuriesField investigationFinal reportAerospatiale AS350B · Van Nuys, CAthe pilot's failure to land as soon as practical and to utilize the available accumulator pressure to transition from hover to flight. Contributing to the accident was the pilot's physical stature and strength, and the inadequate and incomplete emergency…NTSB LAX00FA130Accident · 1 fatalField investigationFinal reportBell 212 · Snelling, CAthe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.NTSB NYC00LA206Accident · Serious injuriesLimited investigationFinal reportBeechcraft 1900D · Plattsburgh, NYThe failure of the upper anchor bracket for the airstair door.NTSB MIA00LA111Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLThe pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.NTSB MIA00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLSeparation of the right main landing gear tire recap during takeoff resulting in the pilot's loss of directional control, the aircraft departing the runway, collapse of the landing gear, and collision with the airport fence.NTSB LAX00GA114Accident · Minor injuriesFinal reportBell OH-58C · Compton, CAAn undetermined electrical system voltage surge.NTSB LAX00IA127Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · San Francisco, CAfailure of the right main landing gear to fully extend for undetermined reasons.NTSB IAD00IA026Incident · No injuriesIncident investigationFinal reportBoeing - Canada DHC-8-102 · Baltimore, MDthe missing elevator stop bumper that resulted in elevator over-travel and damage to the elevator. A factor in the incident was the abrupt release of the elevator control lock in windy conditions.