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 BFO93LA106Accident · 1 fatalLimited investigationFinal reportWernega Benson KB-2 · Mount Holly, NJThe pilot's improper use of the gyroplane's flight controls.NTSB BFO93FA107Accident · Serious injuriesField investigationFinal reportUS/Lta 138S Airship · New York, NYInadequate design of, and design standards for, the airship which resulted in an envelope failure following separation of a portion of the night sign equipment.NTSB DEN93LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Haswell, COFailure of the student pilot to maintain control of the aircraft during landing roll. Factors were: alternator failure, failure of the student pilot to follow procedures and directives, and failure of the student pilot to perform fuel consumption calculations.NTSB DEN93LA069Accident · 1 fatalLimited investigationFinal reportIrving Siewert Osprey GP-4 · Canon City, COFailure by the pilot/builder to follow construction specifications and the use of improper materials during construction of the aircraft.NTSB NYC93LA116Accident · No injuriesLimited investigationFinal reportGritter Quest AIR 20 · Baltimore, MDThe failure of the left main gear tire which resulted in a loss of directional control and collision with a taxiway sign.NTSB ATL93IA111Incident · No injuriesIncident investigationFinal reportSikorsky S-76A · Cullman, ALThe failure of company maintenance personnel to properly inspect the tail rotor control cable at the last 750 hour inspection, and the subsequent total failure of the cable due to wear.NTSB NYC93IA113Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60-200 · Atlantic City, NJA malfunction of the cargo fire warning system which resulted in a false alarm.NTSB CHI93DCG01Accident · 2 fatalFinal reportEmory W. Greer, JR. VARI-EZE · Olathe, KSthe pilot's failure to secure a fuel cap during the preflight inspection of the airplane, and the pilot's failure to maintain aircraft control during the emergency landing. Factors associated with the accident are the unsecured fuel cap and the foreign object…NTSB FTW93FA185Accident · No injuriesField investigationFinal reportConvair 440 · Greenville, TXThe pilot-in-command's failure to follow the published emergency procedures. Factors were engine fire warning system activating for undetermined reasons, and the resultant ac power loss when that engine was secured. The lack of recent expereince in type…NTSB FTW93LA177Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Crowley, LASevere propeller and airframe vibration for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL93LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Ravenel, SCThe continuation of the landing attempt into the short sod field without the use of flaps and the use of excessive airspeed by the pilot. Factors in the accident were the failure of the aircraft flaps to extendNTSB CHI93DEM01Accident · No injuriesFinal reportAmato Corben JR. ACE · Traverse City, MIinadequate lubrication of the tailwheel bearings and inadequate preflight by the pilot/owner which resulted in a seized tailwheel.NTSB ATL93LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Tuskegee, ALThe pilot's failure to establish a final approach course to the runway surface during a night landing. A factor was the inoperative aircraft landing light.NTSB ANC93FA070Accident · No injuriesField investigationFinal reportCessna 320 · Anchorage, AKAn undetermined failure that resulted in an overvoltage condition of the electrical system, overheating of the battery, overdrive (overtorque) of the landing gear extension system, a disconnect of the emergency extension system, and a susbsequent collapse of…NTSB LAX93IA235Incident · No injuriesIncident investigationFinal reportUS/Lta 138-S · Santa Maria, CAInadequate specifications in the design and manufacture of a rudder control tube rod end bearing by the airship manufacturer.NTSB LAX93LA222Accident · No injuriesLimited investigationFinal reportCessna 182P · Reno, NVIncorrect installation of a bearing in the airplane's alternator during overhaul by maintenance personnel. A factor in the accident was the rough, uneven terrain.NTSB CHI93DCD02Accident · 1 fatalFinal reportPiper PA-25 · Essex, IAFatigue failure of the forward spar fuselage attachment assembly for the right wing. A factor related to the accident was: the lack of a directed inspection procedure that could have been provided with the issuance of an airworthiness directive.NTSB ATL93LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Grandview, TNFailure of the aircraft battery.NTSB ATL93LA092Accident · Minor injuriesLimited investigationFinal reportJones Lightning BUG 2 · Walterboro, SCThe disconnection of an elevator rod end fitting in flight, which disabled the elevatorNTSB SEA93LA105Accident · 1 fatalLimited investigationFinal reportKaman HH-43F · Anatone, WAFatigue failure of the rotor transmission drive system, resulting from the improper certification/approval of the aircraft modification by the federal aviation administration.NTSB BFO93LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Towanda, PAThe failure of the aileron control cable which resulted in loss of control in flight.NTSB LAX93LA211Accident · No injuriesLimited investigationFinal reportCessna 140 · Ramona, CAA jammed control yoke.NTSB ANC93LA058Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKThe failure of the right brake due to improper installation of the brake line. Factors were the pilot's improper in flight planning/decision by not checking the brakes prior to landing, and the berm.NTSB BFO93LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Willimantic, CTFailure of the pilot to follow emergency procedures to ensure that the gear was locked. A factor related to the accident was the total electrical failure and the construction site located beside the runway.NTSB ANC93FA056Accident · 1 fatalField investigationFinal reportBell 204B · Copper Harbor, AKFatigue failure of the tail rotor gearbox, and improper helicopter operations being conducted by the operator resulting in repetitive at and over maximum loads. Factors in the accident were: material defect of the tail rotor gear box (inadequate quality…NTSB MIA93LA130Accident · 2 fatalLimited investigationFinal reportSmith FW2C80TD · Lucedale, MSThe pilot in command's operation of the aircraft in a manner which exceeded design limitations which resulted in inflight failure and separation of the wings.NTSB CHI93LA145Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Port Huron, MIfailure of the landing gear actuator cable.NTSB MIA93LA106Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Zephyrhills, FLThe pilot-in-command's failure to maintain best single-engine rate-of-climb speed which resulted in a forced landing. A factor which contributed to the accident was a possible exhaust system clamp failure.NTSB DCA93GA042Accident · 8 fatalClass 1Final reportMitsubishi MU-2B-60 · Zwingle, IAThe fatigue cracking and fracture of the propeller hub arm. The resultant separation of the hub arm and the propeller blade damaged the engine, nacelle, wing, and fuselage, thereby causing significant degradation to aircraft performance and control that made…NTSB FTW93LA131Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 · Walnut Ridge, ARA corroded bleed air check valve and subsequent failure ot the right wing's fuel transfer system. A factor was the unfavorable windNTSB FTW93IA125Incident · No injuriesIncident investigationFinal reportBoeing 747-269BC · Alexandria, LAThe inflight delamination of the wing panel skin. Factors were the water contamination of the honeycomb panel.NTSB FTW93LA124Accident · No injuriesLimited investigationFinal reportViolet Dragonfly · Carlsbad, NMThe improper installation of the control stick assembly and the subsequent separation of the flight control stick assembly from the mountNTSB CHI93IA152Incident · No injuriesIncident investigationFinal reportBoeing 767-233 · Kansas City, MOA frozen aileron control bearing after it had become worn, corroded and exposed to water, and the manufacturer's inadequate maintenance/inspection requirment of the bearing(s).NTSB FTW93LA120Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Midlothian, TXFailure of the engine cowling latch resulting in deteriorating airplane performance and a forced landing.NTSB DCA93MA037Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas MD-11 · Shemya, AKThe national transportation safety board determines that the probable cause of this accident was the inadequate design of the flap/slat actuation handle by the Douglas aircraft company that allowed the handle to be easily and inadvertently dislodged from the…NTSB CHI93FA129Accident · 1 fatalField investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe unqualified baggage handler's attempting to load an unfamiliar airplane and inadequate training by the airline which employed the baggage handler.NTSB NYC93LA067Accident · Minor injuriesLimited investigationFinal reportSilva Seawind 3000 · Coatesville, PAImproper adjustment setting of the propeller pitch change mechanism and/or propeller governor output pressure, which resulted in a loss of positive thrust and a forced landing.NTSB LAX93LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Diego, CAThe failure of the wing flap control due to the improper type of fuse installed by unidentified persons. Factors relating to this accident were the flap motor partial failure due to corrosion and the total failure of the fuse due to the wrong type amperage.NTSB ATL93LA069Accident · No injuriesLimited investigationFinal reportJohn Thomason Laco 145 · Tuskegee, ALThe overload failure of the tail wheel leaf springs, which resulted in a loss of directional control during the landing roll.NTSB DEN93FA038Accident · 3 fatalField investigationFinal reportAerospatiale SA316B · Aspen, COFailure of the flight control lower mixing unit due to fatigue, which resulted in the loss of control.NTSB BFO93IA057Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE3201 · Rochester, NYFailure of the main cabin door to be adequately secured for flight for an unknown REAS0N.NTSB LAX93LA181Accident · Minor injuriesLimited investigationFinal reportCessna U-206G · Yuma, AZAn inadequate annual inspection which led to a loss of the electrical system due to loose alternator belt, and the pilot's failure to attain the proper touchdown point during a night precautionary landing on an unlit runway.NTSB NYC93IA059Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Newark, NJInadequate maintenance/inspection by company maintenance personnel, the manufacturer's inadequate inspection and/or replacement procedures for the aileron cables, and subsequent failure of the 'down' aileron control cable due to wear.NTSB FTW93FA105Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Radium Springs, NMA total failure of the airplane's vacuum system. Factors which contributed to the accident were: the dark night, snow, the pilot's loss of aircraft control, and the pilot's lack of experience in flying in actual intrument meteorological conditions.NTSB LAX93FA149Accident · 3 fatalField investigationFinal reportCessna 421C · Eagle Mountain, CAFailure of the left elevator for undetermined reason(s), which resulted in flutter and failure of the empennage, and subsequent uncontrolled collision with the terrain.NTSB MIA93IA083Incident · No injuriesIncident investigationFinal reportAero Commander 500 · Everglades City, FLThe preexisting fatigue cracking of the propeller hub arm in the bearing retention radius due to polishing and wear of the radius from contact with the split rings, resulting in a propeller blade separating from the propeller hub on the takeoff ground run,…NTSB ANC93LA036Accident · No injuriesLimited investigationFinal reportMaule M5 · Chena Hot Sprng, AKThe total failure of the landing gear axle as a result of a pre existing fracture in the axle.NTSB ANC93FA033Accident · 2 fatalField investigationFinal reportBell 214B1 · Ketchikan, AKInadequate maintenance of the hydraulic servo actuator which led to the fatigue failure and loss of flight control. In addition, the flightcrew did not, or was unable to, jettison the external load. Factors which contributed to the accident were: the pilot…NTSB CHI93LA091Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Evansville, INThe partial failure of the normal brake system.NTSB DEN93IA027Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Grand Junction, COFailure of the left generator control unit (gcu), integrated drive generator (idg), right (side) engine indicator and crew alert system (eicas), and bus tie bar (btb).