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 NYC04LA167Accident · No injuriesLimited investigationFinal reportCessna 210M · Quarryville, PAImproper maintenance performed on the airplane, which resulted in a total electrical failure during cruise flight in IMC, and a subsequent precautionary landing. A factor in the accident was the low ceiling.NTSB ATL04LA148Accident · No injuriesLimited investigationFinal reportCessna 401B · Naples, FLThe fracture of the right landing gear down lock stud which resulted in the right main landing gear collapse during landing roll.NTSB ATL04CA154Accident · No injuriesData collectionFinal reportGlassic Composites SQ-2000 XL · Dayton, TNThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop and the subsequent collapse of the landing gear.NTSB CHI04LA183Accident · No injuriesLimited investigationFinal reportCessna 340A · Mason City, IAThe proper touchdown point not obtain/maintained by the pilot following a single-engine approach to landing. Contributing factors were the vacuum pump oil leak, the low oil pressure of the propeller control system, and the unfeathered propeller.NTSB LAX04LA253Accident · 1 fatalLimited investigationFinal reportAnderson Harmon Rocket II · Seal Beach, CAthe in-flight separation of the elevator, which resulted in a loss of airplane control and an uncontrolled descent. The underlying cause and mechanism of the elevator separation could not be determined.NTSB CHI04CA172Accident · No injuriesData collectionFinal reportCessna 310P · Knox, INThe fatigue fracture of the main landing gear assembly.NTSB SEA04LA117Accident · No injuriesLimited investigationFinal reportCessna 185F · Bozeman, MTThe failure of the right main gear brake disk attach flange during the landing roll, due to fatigue cracks emanating from numerous corrosion pits present on the surface of the disk, leading to the right brake becoming totally inoperative, and resulting in a…NTSB CHI04CA159Accident · Serious injuriesData collectionFinal reportBracken CB540 · Lapeer, MIThe pilot's loss of control due to an undetermined flight control system malfunction. Contributing factors to the accident were the wires and trees.NTSB FTW04LA164Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe separation of the right main landing gear wheel and axle during take-off. Contributing factors were the fatigue of the bolts on the right main landing gear and the rough and uneven terrain.NTSB DEN04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTfracture and subsequent total failure of the nose gear strut. A contributing factor was the pilot not being able to control the airplane.NTSB ATL04LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301 · Baxley, GAThe mechanical malfunction of the autopilot pitch servo, and the pilot's inability to maintain adequate control pressure to manually retrim the pitch attitude.NTSB NYC04LA140Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Hamilton, OHThe pilot's failure to maintain directional control after experiencing a brake system malfunction during landing. Factors related to the accident were the malfunction of a landing gear brake as reported by the pilot, and the crosswind conditions.NTSB FTW04LA159Accident · No injuriesLimited investigationFinal reportAyres S-2R · Eagle Lake, TXThe partial collapse of the left main landing gear as a result of a failure of the fuselage structure due to corrosion.NTSB FTW04IA160Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-135LR · Dallas, TXThe loss of pressure in Electrohydraulic Servovalve (EHSV) within the nose wheel steering manifold due to contamination in the C1 orifice of the valve, which resulted in an uncommanded turn of the nose wheel during landing rollout. A contributing factor was…NTSB ATL04LA128Accident · 1 fatalLimited investigationFinal reportGrover J3 Kitten · Mohawk, TNThe pilot's decision to perform aerobatic flight in an airplane with known deficiencies that resulted in the in-flight separation of the airframe and the uncontrolled collision with the ground.NTSB SEA04LA103Accident · No injuriesLimited investigationFinal reportD'Amico Kitfox Series 7 · Caldwell, IDThe disconnection of the elevator pitch control assembly and the pitch rod during the takeoff as a result of an unsecured bolt.NTSB MIA04LA092Accident · 1 fatalLimited investigationFinal reportNorth American T-28B · Wesley Chapel, FLThe pilot's failure to verify security of the left engine cowling and its subsequent separation in-flight and collision with the vertical stabilizer resulting in the loss of aircraft control.NTSB LAX04LA230Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Rosa, CAMaintenance personnel's improper installation and servicing of a retaining ring, which resulted in the failure of the landing gear door actuator and failure of the landing gear extension system during landing.NTSB LAX04LA227Accident · No injuriesLimited investigationFinal reportBeech A36 · Hollister, CAthe pilot's inadequate preflight inspection which failed to detect the mis-rigged elevator trim system, and the pilot's delay in aborting the takeoff.NTSB DEN04LA082Accident · No injuriesLimited investigationFinal reportLockheed TV-2 · Calhan, COthe failure of the fuel tank float which resulted in the draining of fuel out the vents, and a low fuel supply. Contributing factors include the insufficient runway length, the ditch, and the rough, uneven terrain.NTSB FTW04LA148Accident · No injuriesLimited investigationFinal reportBruce Moore Skybolt · Altus, OKThe partial in-flight separation of the wing fabric and rib structure due to an inadequate material installed by the airplane builder.NTSB FTW04IA134Incident · No injuriesIncident investigationFinal reportBeech A23A · Kress, TXThe in-flight separation of the crankshaft for undetermined reasons.NTSB ATL04IA119Incident · No injuriesIncident investigationFinal reportBeech 200 · Millington, TNThe pilots failure to follow the checklist for emergency landing gear extension resulting in the collapse of the main landing gear on touchdown.NTSB FTW04IA128Incident · No injuriesIncident investigationFinal reportLockheed 1329-23E · Houston, TXThe fatigue failure of the inboard left wing actuator fitting.NTSB ATL04TA116Accident · 1 fatalFinal reportHughes 269A · Louisburg, NCFatigue failure of the tailboom saddle fitting which resulted in a loss of aircraft control. Also causal was inadequate maintenance due to non-compliance to an airworthiness directive requiring inspection of the saddle fitting. A contributing factor was the…NTSB CHI04LA119Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Winsted, MNThe failure of the main rotor drive belts for an undetermined reason, and the pilot's misjudged flare during the autorotation.NTSB ATL04IA138Incident · No injuriesIncident investigationFinal reportCessna 172RG · Chamblee, GAThe fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.NTSB MIA04IA088Incident · No injuriesIncident investigationFinal reportBeech A36 · Daytona Beach, FLImproper maintenance/installation by the propeller overhaul/repair facility, which resulted in stress related fatigue and the eventual separation of the propeller pitch change pin.NTSB LAX04LA203Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Reno, NVthe pilot's failure to maintain an adequate airspeed margin while performing a return to runway maneuver, which led to a stall and spin. Factors in the accident were: 1) the deteriorated condition of the glider towrope, which resulted in towrope failure…NTSB NYC04FA117Accident · Serious injuriesField investigationFinal reportEurocopter AS-350BA · Brooklyn, NYThe pilot's failure to maintain control of the helicopter after a loss of hydraulic system pressure due to a failure of the hydraulic pump belt. Factors in this accident were the pilot's misidentification of a hydraulic failure, the pilot's subsequent failure…NTSB DEN04LA075Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Rifle, COthe pilot's failure to verify the manual extension of the landing gear resulting in an inadvertent wheels up landing. Contributing factors include the electrical systems failure for undetermined reasons, the pilot's diverted attention and the pilot's improper…NTSB ATL04IA098Incident · No injuriesIncident investigationFinal reportCessna 208B · Tunica, MSThe pilot's improper use of the emergency power lever which resulted in excessive operating temperatures. A factor was the improper adjustment of the emergency power lever dead band.NTSB FTW04LA111Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Holliday, TXThe failure of the upper tail rotor shaft due to excessive misalignment after two hard landings. Also causal was the manufacturer's failure to provide specific maintenance procedures for checking the alignment of the upper tail rotor shaft.NTSB FTW04LA113Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sweetwater, TXThe propeller overspeed for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX04LA194Accident · No injuriesLimited investigationFinal reportCessna 205 · Page, AZthe fatigue fracture and separation of the pilot's control wheel, which resulted in a momentary loss of control and a hard landing.NTSB DEN04IA063Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Colorado Spring, COThe failed air conditioning fan by-pass check valve and the subsequent overtemperature of the air conditioning pack.NTSB DEN04IA060Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2C10 · Denver, COThe total failure of the airplane's number 1 system hydraulic pump.NTSB MIA04LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · N. Lauderdale, FLThe erratic operation of the pitot-static system associated flight instruments due to water contamination, and the pilot's failure to take the appropriate corrective actions.NTSB IAD04LA016Accident · 2 fatalLimited investigationFinal reportPilatus P3-05 · Edgewater, FLThe delamination of the no. 2 connecting rod bearing for undetermined reasons, resulting in a total loss of engine power. A factor in the accident was the pilot's inability to complete a successful forced landing due to oil on the windscreen, and smoke and…NTSB DEN04IA059Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COarcing of the windshield deicing system. Factors contributing to the incident were the improper inspection of the windshield's exterior seal, deterioration of the windshield seal, and water penetration through the deteriorated seal.NTSB ATL04LA094Accident · 1 fatalLimited investigationFinal reportFirefly F8B · Eatonton, GAThe overload failure of the windline quick release tiedown eyebolt.NTSB LAX04LA176Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAa loss of tail rotor drive due to a disconnection of the drive shaft's splined coupling at the tail rotor gear box. The splined coupling to tail rotor gear box disconnection occurred as a result of tail boom flexing due to the combined effects of an…NTSB CHI04CA090Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Yoder, KSThe pilot's failure to secure the elevator Louis L'Hotellier connector with a safety pin or wire as directed in several airworthiness directives and his inadequate preflight inspection of the sailplane, both of which resulted in the in-flight loss of elevator…NTSB LAX04LA174Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-26A · La Verne, CAthe pilot's failure to adequately compensate for an asymmetrical thrust condition and to maintain directional control during the landing flare. The owner/pilot's failure to comply with the applicable service bulletin concerning propeller/power control rigging…NTSB DEN04LA055Accident · 1 fatalLimited investigationFinal reportMikoyan MiG Mig-17 · Truth or Conseq, NMthe loss of aircraft control for undetermined reasons resulting in impact with desert terrain.NTSB LAX04LA163Accident · Serious injuriesLimited investigationFinal reportWallace Skybolt · Reno, NVFailure of the left wing spar during an aerobatic maneuver.NTSB MIA04LA062Accident · No injuriesLimited investigationFinal reportBeech BE90 · Fort Lauderdale, FLThe inadequate inspection of the landing gear system by company maintenance personnel resulting in a crack in the left main landing actuator mount going undetected and collapse of the left landing gear during landing roll when the actuator attachment failed.NTSB MIA04LA058Accident · 1 fatalLimited investigationFinal reportOrtmayer/Parson none · Bunnell, FLThe owner/pilot mechanic's failure to comply with a manufacture notice to replace the rotor blades and hub bar assembly, resulting in a failure of the hub bar to hub bar wing attaching bolt and separation of a main rotor blade.NTSB LAX04FA150Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Oakdale, CAthe in-flight separation of the main spar due to corrosion in the wing center section not detectable by inspection methods described in manufacturer's service bulletins and FAA Airworthiness Directives.NTSB ATL04IA085Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Atlanta, GAThe failure of the tantalum capacitor and the permanent magnet generator input transformer which resulted in total electrical system failure.