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 DEN01LA062Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Durango, COthe pilot's failure to maintain directional control. A contributing factor was the blown tire.NTSB IAD01LA035Accident · No injuriesLimited investigationFinal reportCessna 210 · Newark, OHImproper maintenance, which resulted in the failure of the instrument panel shock mounts.NTSB LAX01LA105Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-120 · Monterey, CAmoisture contamination of the elevator trim actuators, which allowed the units to freeze at altitude resulting in an abrupt pitch change when the units thawed at lower altitudes.NTSB MIA01LA084Accident · 1 fatalLimited investigationFinal reportBoeing Helicopters Div. 369D · Inverness, MSThe lineman's failure to use the designed attachment point for securing his safety harness to the helicopter, resulting in overload and failure of the component he did attach to. A factor in the accident was the lineman's failure to follow exact sequential…NTSB CHI01IA124Incident · No injuriesIncident investigationFinal reportBoeing 717-231 · Milwaukee, WIThe failure of the operator to provide complete and comprehensive thrust reverser lock-out maintenance procedures and guidance to the contract maintenance personnel resulting in a partial and inadequate securing of the faulty thrust reverser and a subsequent…NTSB SEA01LA049Accident · No injuriesLimited investigationFinal reportAero Commander AC-690 · Eugene, ORan undetermined malfunction of the nose gear system which resulted in the failure of the nose gear to fully extend and lock prior to landing.NTSB LAX01LA098Accident · No injuriesLimited investigationFinal reportBell 47-G3B1 · Winterhaven, CAA failure of the transmission free wheeling unit due to improper maintenance. A factor was the dark night visual condition.NTSB SEA01LA046Accident · 1 fatalLimited investigationFinal reportWestern International UH-1H · Darby, MTInflight loss of a tail rotor pitch change link-to-blade grip attach bolt, resulting partial loss of tail rotor control, and subsequent entanglement of the helicopter's external load cable with a tree during emergency descent. Factors included the pilot's…NTSB IAD01LA031Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Napoleon, OHThe fatigue failure in the fillet radius of the mast, which resulted in the separation of the main rotor system.NTSB ATL01LA029Accident · Minor injuriesLimited investigationFinal reportRobert D. Wood Velocity Xlfg · Sebastian, FLThe manufacturer's inadequate design of the winglet/rudder assembly, and inadequate bonding techniques for metal to fiber structures, which resulted in control surface flutter.NTSB NYC01LA074Accident · No injuriesLimited investigationFinal reportBeech B-19 · Louisa, VAThe pilot's failure to maintain airspeed, which resulted in a hard landing. Factor's in this accident were the loss of electrical power due to an alternator failure and the night light conditions.NTSB LAX01LA083Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Lihue, HIThe manufacturer's inadequate collective lock design, which resulted in the collective unlocking during a preflight check and subsequent unintentional liftoff and loss of helicopter control. The pilot's loss of control was due in part to the unavailability of…NTSB SEA01LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Renton, WAThe worn condition of the hydraulic pump gears which resulted in a continuous running pump, subsequent pump motor overheat and eventually the tripping of the pump motor circuit breaker. An additional cause was the pilot's failure to verify that the landing…NTSB CHI01IA073Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Grand Rapids, MIThe uncommanded deployment of the right flight spoiler due to the fatigue fracture of the spoiler lug.NTSB SEA01IA039Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Seattle, WAA malfunctioning relay in the aircraft's flight management system (FMS) switching matrix and associated false "on course" indication on the captain's course deviation indicator (CDI), resulting in proper localizer course alignment not being obtained or…NTSB ATL01LA022Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Orlando, FLThe other maintenance personnel's failure to complete prescribed inspections that resulted in the failure of a fuel block drain assembly fitting , corrosion of the battery grounding strap and the subsequent flash explosion.NTSB LAX01FA071Accident · Minor injuriesField investigationFinal reportWorldwide Aeros 40B · Oakland, CAOne or both of the rear ballonet air relief valves remained in an open position for undetermined reasons, which caused an out-of-balance trim condition; also causal was the flight crew’s decision to the fly the airship with a known deficiency (the inoperative…NTSB MIA01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20C · Jacksonville, FLThe failure of maintenance personnel to properly reconnect the aircraft's elevator control system, resulting in an in-flight disconnection of the elevator control and jamming of the rudder control during climb, the subsequent in-flight loss of control, and…NTSB LAX01IA073Incident · No injuriesIncident investigationFinal reportBoeing 747-200F · Honolulu, HIthe failure of the lighting dimmer switch or circuit components for undetermined reasons, which resulted in smoke in the cockpit.NTSB NYC01IA072Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Covington, KYMissing exhaust nozzle bolts for undetermined reasons. A factor was inadequate maintenance inspection of the affected area.NTSB CHI01IA055Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135LR · Chicago, ILThe jammed horizontal stabilizer trim that occurred during the airplane's initial climb after takeoff. Factors relating to the incident were the inadequate capability of the horizontal stabilizer trim actuator to move the stabilizer during all flight phases,…NTSB MIA01IA051Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Hebron, KYThe inadequate design of the flight compartment windshield by the windshield manufacturer resulting in cracking of the center ply.NTSB DEN01LA034Accident · No injuriesLimited investigationFinal reportBarackman Vans RV-6 · Springfield, COTotal failure of the right hand flap control rod due to construction procedures/directives not being followed by the builder.NTSB IAD01LA020Accident · No injuriesLimited investigationFinal reportCessna 172M · Medford, NJThe pilot's failure to attain the proper touchdown point. Factors included the loss of electrical power, the dark night, and the pilot's lack of night experience.NTSB NYC01LA059Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA365-N1 · West Mifflin, PAInsufficient lubrication within the tail rotor gearbox, which resulted in the seizure of the duplex ball bearing and a fixed pitch setting of the tail rotor. Also causal, was the pilot's loss of control, which was the result of a relative low speed/high power…NTSB MIA01LA040Accident · No injuriesLimited investigationFinal reportCessna 421B · Pensacola, FLThe failure of the left main landing gear scissors washer during taxi for takeoff, and collapse of the left main landing gear. A factor in the accident was the failure of unknown maintenance personnel to comply with a manufacturers service letter concerning…NTSB ANC01LA023Accident · No injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe failure of a mechanic to ensure the throttle linkage was secure. A factor in the accident was the pilot's failure to take remedial action during an emergency landing and overrun.NTSB CHI01IA047Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Cloud, MNthe fatigue failure of the propeller blade during the initial takeoff climb. The failure was a result of a material defect, which occurred during the manufacturing process and the manufacturers failure to detect the defect.NTSB FTW01LA034Accident · Minor injuriesLimited investigationFinal reportEvans Varieze · Ingleside, TXthe loss of control during takeoff initial climb due to the binding rudder, which restricted the pilot's control of the aircraft.NTSB DEN01LA025Accident · No injuriesLimited investigationFinal reportCessna 320C · Englewood, COthe failure of the nose landing gear to fully extend due to a bent extension rod.NTSB DCA01MA005Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9 · Atlanta, GAthe leakage of lavatory fluid from the airplane's forward lavatory onto electrical connectors, which caused shorting that led to a fire. Contributing to the accident were the inadequate servicing of the lavatory and the failure of maintenance to ensure…NTSB ATL01LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Merritt Island, FLMaintenance personnel failure to properly install engine cowling fasteners, which allowed the engine cowling to separate in flight.NTSB IAD01IA019Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Newark, NJa short in the left inboard elevator parallel engage solenoid valve for undetermined reasons.NTSB DEN01LA017Accident · 1 fatalLimited investigationFinal report2000 McCoy Genesis · Fort Collins, COFailure of an airframe stringer due to improper construction by the builder/pilot which rendered the aircraft uncontrollable. A factor was failure by the builder pilot to follow procedures and secure the engine prior to deploying the aircraft recovery…NTSB MIA01FA029Accident · 1 fatalField investigationFinal reportAirbus Industrie A300B4-605R · Miami, FLThe failure of the flight crew to perform the cabin pressurization manual control abnormal checklist after experiencing a pressurization system malfunction and switching to manual pressurization control, and the failure of the flight crew to perform the…NTSB LAX01LA045Accident · Serious injuriesLimited investigationFinal reportCollette Glassair III · Guistine, CAMaintenance personnel misrouted the crankcase breather hose so that it was pinched when the cowling was installed. This pressurized the crankcase displacing the oil seal and forcing oil out of the engine. A factor was the unsuitable terrain encountered during…NTSB SEA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Ontario, OROverstress loading to the left wing lift strut resulting in the left wing folding upward during the initial climb.NTSB DEN01LA014Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Longmont, COthe total failure of the left main gear strut during the landing roll. A contributing factor was the 6-foot high snow bank that the airplane impacted when it left the runway.NTSB DEN01LA012Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Mesa Verde, COThe manufacturer's use of improper materials, and inadequate quality control of the tail rotor blades during the manufacturing process, which resulted in fatigue failure of the blade.NTSB LAX01FA026Accident · 2 fatalField investigationFinal reportCessna 340A · Julian, CATotal blockage of the instrument static system due to ice.NTSB SEA01LA008Accident · 1 fatalLimited investigationFinal reportWildman Adventurer · Yelm, WAA main rotor blade strike (impact) with both a pusher propeller blade and the rudder during an unknown phase of operation resulting in a loss of control and uncontrolled descent to terrain.NTSB IAD01IA009Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Morristown, NJThe failure of several relays on the roll trim control printed circuit board, which caused an uncommanded aileron trim input.NTSB MIA01LA011Accident · Serious injuriesLimited investigationFinal reportCamillo Annaloro C A Spcl Quicks · Lucedale, MSThe failure of the pilot to secure a fabric panel during preflight inspection resulting in the panel separating from the aircraft during climb after takeoff, passing through the propeller and damaging wing flap fabric, loss of engine power due to wing flap…NTSB MIA01LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jesup, GAA total failure of the wheel braking system due to the pilot's improper use of braking in downwind, downhill conditions, resulting in overheated brakes, and subsequent encounter with a downslope and terrain collision.NTSB MIA01FA006Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F2 · Burlington, NCThe mechanics failure to comply with manufacturers instructions for correction of a illuminated main rotor gearbox oil pressure warning light resulting in the helicopter being dispatched on a ferry flight with a failed main rotor gearbox oil pump, failure of…NTSB CHI01MA011Accident · 3 fatalClass 1 · MajorFinal reportCessna 335 · Hillsboro, MOThe pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.NTSB CHI01IA016Incident · No injuriesIncident investigationFinal reportBoeing B-727-61 · Wood Dale, ILInadequate overhaul of the flap segment that allowed for corrosion and debonding that resulted in the flap segment departing the airplane during the approach. Factors relating to this incident were insufficient information provided to the overhaul facility by…NTSB LAX01LA016Accident · No injuriesLimited investigationFinal reportAerospatiale AS350-BH · Hilo, HIInadequate maintenance by the helicopter manufacturer during manufacture, which installed skins of inadequate thickness on the tail boom. A factor in the accident was the failure of the manufacturer's quality control system to detect the inadequate thickness.NTSB CHI01LA008Accident · No injuriesLimited investigationFinal reportWalton RV-6 · Saint Paul, MNThe rudder tube failure, and aircraft control not possible during the flare by the pilot. A factor was the service bulletin not being complied with by the mechanic during the condition inspection.NTSB LAX01FA006Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369E · Kernville, CAThe pilot's improper storage of personal items and his inadequate preflight inspection, which resulted in the unlatching of the left rear cabin door during flight and allowing a plastic garment bag to blow out and strike the tail rotor.