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 DFW05IA156Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace Avro 146-RJ85A · Oklahoma City, OKFailure of a high pressure hydraulic line from fatigue as a result of a manufacturing defect.NTSB NYC05IA093Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Dulles, VAFailure of the right main landing gear to extend and lock for undetermined reasons, which resulted in the right main landing gear collapsing during touchdown.NTSB DFW05LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lake Charles, LAThe failure of the propeller governor which resulted in a forced landing. A contributing factor was the transmission wire.NTSB SEA05IA115Incident · No injuriesIncident investigationFinal reportPiper PA-46-350P · Tacoma, WAThe initiation and propagation of a fatigue crack, over 5,273 hours of cyclic in-flight usage, through approximately 80 percent of the aircraft's right wing spar lower cap.NTSB MIA05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fort Myers, FLInadequate maintenance and repair of the engine top cowling by company maintenance personnel, resulting in failure and separation of the cowling in flight.NTSB CHI05CA134Accident · No injuriesData collectionFinal reportTemco GC-1B · Morris, ILMalfunction of the pilot seat positioning mechanism for undetermined reasons resulting in a loss of aircraft control. The runway light struck when the airplane departed the pavement was a contributing factor.NTSB IAD05IA066Incident · No injuriesIncident investigationFinal reportCessna R182 · West Mifflin, PAThe failure of the landing gear actuator downlock pin due to fatigue, which resulted in the nose landing gear collapsing on landing.NTSB ATL05CA083Accident · Minor injuriesData collectionFinal reportRand Robinson Engineering KR-2 · Vienna, GAA loss of engine power due to the owner/pilot mechanic's improper balancing of the modification to engine crankshaft which resulted in an overload failure.NTSB MIA05LA104Accident · Minor injuriesLimited investigationFinal reportBritish 167 StrikemasterMK83 · Boca Raton, FLThe delay by the pilot-in-command to abort the takeoff after recognizing excessive elevator control forces for undetermined reasons during the landing roll, resulting in the on-ground collision with a fence.NTSB DFW05CA124Accident · No injuriesData collectionFinal reportCessna 210L · Houston, TXThe pilot's failure to maintain directional control during landing roll. A contributing factor was reported partial loss of brake control.NTSB SEA05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Puyallup, WAThe fatigue cracking of the upper torque link attach lugs on the right main landing gear strut, which resulted in separation of the right main landing gear.NTSB DEN05LA077Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe failure of the nose gear actuator resulted in penetration of the forward pressure bulkhead and a loss of pressurization.NTSB ATL05LA091Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Newnan, GAThe improper repair to the main landing gear assembly resulted in the actuator bracket failure and the right main gear collapse. A factor was the inadequate inspection of the right main landing gear.NTSB CHI05MA111Accident · Serious injuriesMajor investigationFinal reportMcDonnell Douglas DC-9-51 · Minneapolis, MNthe Captain of the other aircraft's decision to shutdown the left engine during taxi with no hydraulic pressure on the right side hydraulic system to effectively operate the brakes, steering, or thrust reversers. A factor was the fatigue fracture of the…NTSB ANC05LA075Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Elim, AKAn improper installation of a fuel line fitting by company maintenance personnel, which resulted in a fuel leak and subsequent in-flight engine compartment fire during cruise flight that was discovered during the landing roll.NTSB ATL05FA079Accident · 2 fatalField investigationFinal reportNorth American SNJ-6 · Kissimmee, FLThe failure of the outboard right-wing lower attachment bracket due to fatigue cracking and the subsequent in-flight separation of the right wing assembly.NTSB CHI05LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Bismarck, NDRupture of the hydraulic powerpak drain line which resulted in a loss of hydraulic fluid and the inability to properly lower the landing gear despite the pilot's execution of the emergency extension procedures. A contributing factor was the runway light…NTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.NTSB ANC05IA064Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Anchorage, AKThe inadequate installation of the cockpit security door locking device, which resulted in smoke in the cockpit during normal cruise, and a precautionary landing. A factor associated with the incident was the manufacturer's insufficiently defined installation…NTSB SEA05LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kalispell, MTAn airborne fire which was fueled by leaking hydraulic fluid (the ignition source for the fire was undetermined) from the landing gear hydraulic system located under the cockpit instrument panel due to inadequate maintenance from other maintenance personnel.…NTSB DFW05CA107Accident · No injuriesData collectionFinal reportBell P39 · Fredericksburg, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the reported partial failure of the left wheel brake.NTSB CHI05LA097Accident · No injuriesLimited investigationFinal reportCessna 310 · Clear Lake, MNThe collapse of the nose landing gear as a result of the pilot performing improper maintenance on the airplane due to his failure to properly safety the nose landing gear door.NTSB DEN05TA072Accident · No injuriesFinal reportBell OH-58C · Colorado Sprngs, COthe failure of the N1 tachometer generator which resulted in a precautionary landing. Contributing factors include the frayed wire and the unsuitable terrain for a precautionary landing.NTSB ANC05LA055Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A Islander · Klawock, AKThe fracture of the aluminum alloy landing gear bracket assembly, which resulted in a loss of control during the landing roll.NTSB MIA05LA086Accident · Serious injuriesLimited investigationFinal reportFrank D. Amador Searey · Green Cove Spr, FLThe airplane builder's improper installation of the left rudder control cable, which resulted in the cable becoming jammed, a loss of directional control during takeoff, and the airplane departing the runway and impacting a tree.NTSB LAX05LA125Accident · No injuriesLimited investigationFinal reportCessna 182 · Sacramento, CAa fatigue failure of the right side steering link rod for the nose landing gear steering system.NTSB LAX05LA122Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZThe company mechanic's improper maintenance actions, which resulted in the total failure of the main rotor drive belt system on approach to landing. A factor was the soft terrain.NTSB ATL05LA065Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-135LR · Raleigh, NCAn oily smell in the airplane shortly after takeoff for undetermined reasons that resulted in a return to the airport and a passenger injury during the emergency evacuation.NTSB IAD05LA046Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Leet, WVA fatigue fracture of the main transmission drive pinion. Also causal was the manufacturer's failure to remove the affected pinions from service during the period that transpired between the initial failures and the accident flight.NTSB ANC05LA051Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Anchorage, AKA main landing gear collapse during the landing touch down due to a non-secured clevis bolt at the common attach point on the landing gear oleo shock.NTSB MIA05LA079Accident · No injuriesLimited investigationFinal reportRockwell Aero Commander 500 · San Juan, PRThe failure of the pilot to follow the emergency checklist and his inadvertent operation of the airplane with known discrepancies resulting in landing overrun and on-ground collision with a ditch during the landing roll.NTSB CHI05FA077Accident · No injuriesField investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIthe captain's failure to adequately compensate for the crosswind conditions, and his failure to maintain directional control during landing. Contributing factors include the captain's failure to land at the nearest suitable airport after an in-flight…NTSB SEA05LA058Accident · Minor injuriesLimited investigationFinal reportRotorway Exec 162F · Coos Bay, ORThe disintegration, for undetermined reasons, of the upper main drive pulley assembly bearing, while in cruise flight, leading to the decoupling of the main rotor drive assembly from the engine drive assembly. Factors include the absence of any suitable…NTSB ANC05IA048Incident · No injuriesIncident investigationFinal reportReims F406 · Nome, AKThe failure of the nose gear up lock actuator bracket during the landing approach due to fatigue cracking, which resulted in a nose wheel up landing. A factor associated with the incident is the mechanical binding of the nose wheel locking mechanism.NTSB ANC05LA046Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Talkeetna, AKAerodynamic flutter of the ailerons during normal cruise flight due to their improper maintenance/balancing, which resulted in structural damage to the airplane's wings.NTSB MIA05LA066Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe improper installation and securing of the elevator trim tab push-rod attaching hardware by maintenance personal resulting in the rod disconnecting and a partial separation of the right elevator in flight.NTSB ANC05FA039Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Dunnellon, FLThe improper installation of the bolt that connects the throttle linkage to the fuel control arm by an unknown maintenance person, which resulted in a loss of the bolt, a loss of engine rpm control, and subsequent forced landing and collision with trees.NTSB ATL05CA053Accident · Serious injuriesData collectionFinal reportBennett Ra Oliver Zodiac CH 601 HDS · Mt. Olive, NCRupture of the engine's cooling system radiator, which allowed steam to fill the cockpit.NTSB NYC05IA052Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe mechanic's inadequate inspection, which failed to discover cracks in the left wing spar around wing station 114.NTSB CHI05LA071Accident · No injuriesLimited investigationFinal reportTwin Commander Acft. 680V · Fort Wayne, INThe malfunction of the landing gear extension assembly during approach for undetermined reasons.NTSB ANC05LA029Accident · No injuriesLimited investigationFinal reportBeech A36 · Bay St. Louis, MSThe pilot's failure to use the manual emergency landing gear extension mechanism during the approach to land, which resulted in the electrically actuated main landing gear collapsing during the landing roll. A factor associated with the accident is an…NTSB ANC05LA026Accident · No injuriesLimited investigationFinal reportCessna 411A · Hollywood, FLThe failure of the right main landing gear locking mechanism during the landing roll, which resulted in the collapse of the right main landing gear.NTSB CHI05LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe pilot's failure to identify the electrical system failure and to maintain adequate airspeed during the landing approach. Factors associated with the accident were the electrical system failure, the snow covered terrain, and the pilot's lack of experience.NTSB CHI05LA064Accident · No injuriesLimited investigationFinal reportCessna A185F · Minneapolis, MNA failure of the tail wheel locking mechanism which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.NTSB SEA05LA056Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Prineville, OROther maintenance personnel's inadequate reassembly of the tail wheel assembly and the left main landing gear breaking assembly resulting in an inadvertent loss of control during the landing roll. Contributing factors were the pilot's inadvertent swerve…NTSB LAX05LA074Accident · No injuriesLimited investigationFinal reportMdhi 369E · Pahoa, HIthe in-flight separation of the tail rotor blade abrasion strip due to a degraded adhesive bond and fatigue fracture of the metallic abrasion strip. The ultimate cause for the degraded bond is unknown.NTSB LAX05LA065Accident · No injuriesLimited investigationFinal reportCessna T210M · Mesa, AZthe pilot's failure to use the emergency gear extension procedure to manually extend the landing gear to the down and locked position.NTSB MIA05LA046Accident · 1 fatalLimited investigationFinal reportCessna 172M · Orlando, FLThe failure of the CFI to initiate a precautionary landing after noticing zero oil pressure with corresponding oil temperature increase, resulting in total loss of engine power due to oil exhaustion. A contributing factor in the accident was the failure of…NTSB DEN05LA043Accident · No injuriesLimited investigationFinal reportMooney M20E · Telluride, COthe pilot's improper in-flight decision making and inadvertent retraction of the landing gear resulting in a wheels up landing. A contributing factor included the pilot's attention being diverted by the seized engine tachometer.NTSB CHI05LA047Accident · No injuriesLimited investigationFinal reportLearjet 25B · Cedar Rapids, IAThe pilot was not able to maintain directional control of the airplane due to the failure of the nose gear strut seal which prevented the nose wheel from centering. A factor associated with the accident was the berm that the airplane contacted.