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 NYC95LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Belmont, NHThe pilot's inadequate preflight of the airplane that failed to detect the ice clogged breather which resulted in the loss of oil and a subsequent emergency landing.NTSB LAX95LA096Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Chowchilla, CAthe in-flight failure and separation of the main rotor hub due to a fatigue crack.NTSB MIA95LA064Accident · No injuriesLimited investigationFinal reportBeebe, Dale G. RV-6 · Zellwood, FLThe improper in-flight decision by the pilot to abort takeoff with insufficient runway remaining.NTSB CHI95IA079Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-300 · Madison, WIA fuel leak in the no. 2 engine left fuel manifold segment due to a design defect which led to a fatigue crack.NTSB MIA95LA061Accident · No injuriesLimited investigationFinal reportGlassair III · Boynton Beach, FLa violent shimmy of the nose gear for undetermined reason(s), which resulted in an on-ground loss of directional control and a subsequent nose over.NTSB LAX95FA082Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Joshua Tree, CAthe operator's inadequate annual inspection by failing to find that the flight control's horizontal section of the 'T' bar was rubbing against the vacuum hoses behind the instrument panel. The jammed 'T' bar and the rough terrain were factors in this accident.NTSB ATL95LA042Accident · No injuriesLimited investigationFinal reportMatto KR-2A Modified · Boone, NCThe failure of the propeller retaining bolts for an undetermined reason, which resulted in the separation of the propeller from the engine. The rising, mountainous terrain was a factor.NTSB FTW95IA096Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Dfw Airport, TXThe uncommanded activation of the brake system on the right main landing gear for undetermined reason.NTSB CHI95IA066Incident · No injuriesIncident investigationFinal reportBeech 1900D · Williston, NDthe improper installation and inadequate quality assurance inspection of the elevator trim cable during original manufacture, which resulted in fraying and failure of the cable prior to the first routine scheduled inspection of the system.NTSB ANC95LA026Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Dutch Harbor, AKThe partial failure of the right brake due to a leaky brake line.NTSB FTW95FA080Accident · 2 fatalField investigationFinal reportBeech 65-90 · Royal, ARThe pilot inadvertently allowed the airplane to descend and collide with trees, after he became diverted by an inoperative cabin heater. Darkness was a related factor.NTSB LAX95LA067Accident · 1 fatalLimited investigationFinal reportHarris BD-10 · Gardnerville, NVthe in-flight overload failure of the left vertical stabilizer spars, at force levels substantially below the predicted ultimate failure loads, due to inadequate substantiation by the designer.NTSB NYC95DNC01Accident · No injuriesFinal reportWyman Scorpion II · Cornish Flat, NHPartial failure and subsequent partial separation of skin on the underside of one main rotor blade, which resulted in a severe vibration, in-flight loss of aircraft control, and impact with the ground during an attempted autorotation.NTSB MIA95FA042Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Plant City, FLThe opening of the engine cowling latch in cruise flight for undetermined reasons. This resulted in the puncture of the engine oil cooler, total exhaustion of the engine oil, failure of the No. 6 connecting rod, rod bolts, forced landing while on final…NTSB SEA95LA030Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Heber City, UTAn open connection clip. A factor to the accident was a locked tail wheel assembly.NTSB DCA95MA007Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Fresno, CA1) Improperly installed electrical wiring for special mission operations that led to an in-flight fire that caused airplane systems and structural damage and subsequent airplane control difficulties; 2) improper maintenance and inspection procedures followed…NTSB BFO95LA021Accident · Minor injuriesLimited investigationFinal reportElvin N. Kier Varieze · Cleveland, OHA fatigue crack in the right elevator torque tube resulting in the disconnection of the elevator torque tubes and subsequent loss of airplane control.NTSB FTW95IA064Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Dfw Airport, TXFire due to the internal failure of the number one DC starter-generator.NTSB LAX95LA048Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Cabazon, CAAn unknown event (presumably a component/system failure) that resulted in loss of drive train power to the main rotor system. Factors related to the accident were: darkness and the obstruction (transmission line) in the emergency landing area.NTSB ANC95FA019Accident · Serious injuriesField investigationFinal reportBoeing 737-3M8 (300) · Anchorage, AKThe failure of the b system channel autopilot elevator actuator.NTSB CHI95IA052Incident · No injuriesIncident investigationFinal reportCessna 402 · Saint Louis, MOimproper maintenance installation (fuel line fitting)by other maintenance personnel. A factor was the cross threaded fuel line fitting.NTSB FTW95LA060Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Las Cruces, NMThe inadequate maintenance by unknown maintenance personnel. A factor was the collapsed landing gear.NTSB CHI95IA045Incident · No injuriesIncident investigationFinal reportFokker F-28-4000 · Evansville, INthe failure of company maintenance personnel to adequately service (fill) the horizontal stabilizer drive actuator with hydraulic fluid.NTSB FTW95IA049Incident · No injuriesIncident investigationFinal reportBoeing B-737-200 · Springfield, MOThe failure of either the inboard or the outboard wheel bearing assembly due to undetermined reasons.NTSB CHI95LA036Accident · 1 fatalLimited investigationFinal reportLessel KR-2 · Portland, INthe failure of the elevator control cable attach point and the pilot's subsequent inability to control the airplane.NTSB ATL95LA011Accident · No injuriesLimited investigationFinal reportCessna 185 · Elizabethton, TNThe flexing of the rudder pedal control locking assembly which resulted in the collapse of the co-pilot's left pedal during heavy braking.NTSB CHI95LA029Accident · No injuriesLimited investigationFinal reportHughes 269C · Garden City, KSinadvertant engagement of the rotor drive system, while the helicopter had been left unattended by the pilot.NTSB MIA95LA015Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Madison, MSThe pilots improper use of brakes during a precautionary landing.NTSB MIA95LA013Accident · Minor injuriesLimited investigationFinal reportSemco Challenger · Miami, FLFailure of the basket suspension cables due to corrosion and overstress separations. Contributing to the accident was an inadequate annual inspection of the basket suspension cables by an authorized FAA repairman.NTSB LAX95LA023Accident · No injuriesLimited investigationFinal reportGlen A. Senecal 5151 · Apple Valley, CAthe manufacturer's (owner/operator) improper balancing of the aileron flight controls which resulted in a cable separation due to overload from the aileron flutter. The rough/uneven terrain was also a factor.NTSB LAX95IA027Incident · No injuriesIncident investigationFinal reportFairchild SA-227AC · Oakland, CAthe company maintenance personnel's improper installation of the aileron cable.NTSB FTW95LA034Accident · 1 fatalLimited investigationFinal reportBrisendine Pterodactyl/Ascender · Las Animas, COA failure of the right wing into the propeller.NTSB CHI95IA030Incident · Minor injuriesIncident investigationFinal reportCessna 150 · Chesterfield, MOthe cracked heater exhaust muffler which resulted from an improper repair. Factors were the physical impairment of the solo flight student as a result of her inadequate training concerning carbon monoxide hazards.NTSB NYC95LA017Accident · Minor injuriesLimited investigationFinal reportPitts S-1C · Galeville, NYInadequate maintenance inspection which resulted in disengagement of the rudder clevis bolt and the inflight loss of control during aerobatic manuevers.NTSB MIA95LA011Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Mulberry, FLThe failure of the pilot-in-command to perform an adequate preflight inspection resulting in a leaking brake going undetected. This resulted in the failure of the brake due to loss of hydraulic fluid and collision with a sign and a ditch when the aircraft…NTSB FTW95LA031Accident · No injuriesLimited investigationFinal reportHerron Little Wing Autogyro · Little Rock, ARThe fractured tail wheel mounting bracket and loose tailwheel. A factor was the pilot's continued flight testing after experiencing tail wheel shimmy on the prior test flight.NTSB FTW95IA023Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Dfw Airport, TXImproper maintenance by unknown persons resulting in a jammed spoiler. A factor was the reversed aileron fitting.NTSB NYC95IA020Incident · No injuriesIncident investigationFinal reportCessna 310R · Rochester, NYInadequate maintenance which resulted in undertorqued bolts, fatigue cracking of the hub, and the separation of the propeller assembly from the engine.NTSB SEA95LA007Accident · Minor injuriesLimited investigationFinal reportBony MB-1 · Madras, ORThe jamming of the rudder during due to undetermined reasons. Contributing to the accident was the pilot-in-command's failure to maintain adequate flying speed while attempting to take remedial action.NTSB SEA95LA004Accident · No injuriesLimited investigationFinal reportMonocoupe 110 Special · Langley, WACorrosion and subsequent failure of the elevator hinge attach fitting weld. This allowed the elevator to bend and impinge upon the rudder, subsequently jamming it to the full right position and rendering the aircraft impossible to control.NTSB ATL95LA004Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Ashburn, GAThe failure of a blade counterweight bearing shaft, allowing one propeller blade to go to high pitch.NTSB CHI95LA003Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Decatur, ILthe failure of the roller springs in the freewheeling unit of the transmission which caused the unit to disengage.NTSB FTW94IA321Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11-F · Anchorage, AKRight inboard flap vane component separation due to undetermined reasons.NTSB ATL94FA179Accident · 1 fatalField investigationFinal reportRobinson R-22B · Knightdale, NCDivergence of the main rotor from its normal plane of rotation for an undetermined reason(s) resulting in rotor blade contact with the tailcone.NTSB MIA94IA217Incident · No injuriesIncident investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe first officer's failure to maintain directional control on landing roll out due to improper use of brakes, resulting in the airplane veering off the runway, and subsequent on-ground collision with a runway light and sign. Contributing to the incident was…NTSB LAX94LA387Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)failure of the helicopter's main rotor pitch change link (control rod). The helicopter was not recovered and the Safety Board was unable to determine the pitch change link's failure mode.NTSB LAX94FA367Accident · 1 fatalField investigationFinal reportAlon A2 · Orland, CAthe pilot's intentional performance of an aerobatic maneuver which overloaded the outboard portion of the left wing and caused it to fail. Factors which contributed to the accident were the pilot's overconfidence in his ability to perform the maneuver and his…NTSB CHI94LA319Accident · Serious injuriesLimited investigationFinal reportSnider CP328 Super Emeraude · Painton, MOin flight delamination and subsequent failure of the hand carved wooden propeller.NTSB LAX94LA356Accident · No injuriesLimited investigationFinal reportHawker Siddeley HS-125-700A · Reno, NVthe rupture of fuel and hydraulic lines and the fuselage fuel tank, by tire pieces during the tire blow-out sequence.NTSB DCA94MA076Accident · 132 fatalClass 1 · MajorFinal reportBoeing B-737-300 · Aliquippa, PAA 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…