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 LAX98LA026Accident · Minor injuriesLimited investigationFinal reportStriplin Lone Ranger Slvr CLD · Agua Dulce, CAFailure of the propeller system/drive assembly, and the pilot's failure to maintain flying speed, which resulted in a stall and subsequent impact with the ground. Inadequate maintenance/inspection of the propeller system was a contributing factor.NTSB CHI98LA027Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Augusta, KSfailure of the aircraft owner to reinstall the quick release hinge pins/safety pins, and failure of the pilot to notice the missing pins during the aircraft preflight, which resulted in separation of the main entry door during flight.NTSB FTW98LA027Accident · No injuriesLimited investigationFinal reportHelio H-800 · Ogden, UTfailure of the tail wheel assembly, which rendered the aircraft uncontrollable during landing roll.NTSB CHI98LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · St Charles, MOfailure of the alternator's front bearing, depletion of battery power, and failure of the emergency landing gear extension handcrank to engage during the pilot's attempt to perform the emergency procedure.NTSB ATL98LA005Accident · No injuriesLimited investigationFinal reportMooney M20C · Hendersonville, NCThe undetermined malfunction of the nose gear steering assembly that resulted in the loss of directional control during a full stop landing. A factor was the rough and uneven runway condition. .NTSB ANC98IA004Incident · No injuriesIncident investigationFinal reportCessna 208B · Kasigluk, AKinadequate inspection of the aileron by company maintenance personnel, and the pilot's inadequate preflight inspection of the aileron, which led to the jamming of the left aileron due to loose balance weight retaining screws.NTSB FTW98IA019Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Seattle, WAMaintenance personnel's failure to properly secure the left off-wing slide door after routine slide replacement, allowing an inflight separation of the slide. Factors were inadequate training of maintenance personnel and inadequate written instructions by the…NTSB FTW98TA051Incident · No injuriesFinal reportCessna P210N · Bryce Canyon, UTThe failure of the resistor (inverter) in the door seal pressurization air pump due to continuous operation. Factors were a failure in the door seal pressurization system, its inadequate design by the manufacturer, its inadequate written instructions for…NTSB CHI98FA017Accident · No injuriesField investigationFinal reportBeech G35 · Poplar Grove, ILflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.NTSB NYC98LA006Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Bennington, VTThe failure of the cyclic control due to an improper modification by the pilot/owner.NTSB CHI98IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILan improper repair to a crack in a brake flange hole on the left main landing gear outboard axle, and subsequent fatigue failure of the axle.NTSB CHI97LA306Accident · Serious injuriesLimited investigationFinal reportBell 47 · Pipestone, MNthe fracture of the pitch control rod assembly.NTSB ANC97LA157Accident · No injuriesLimited investigationFinal reportCessna 180 · King Salmon, AKThe distorted/misaligned main landing gear, and an improper maintenance repair of the main landing gear. A factor associated with the accident was rough and uneven terrain.NTSB SEA97IA219Incident · No injuriesIncident investigationFinal reportBoeing 737-3T0 · Seattle, WASeparation of the ABSB-4 aileron bus cable, resulting in reduced lateral controllability of the aircraft. Related factors were wear in the cable and inadequate inspection of the cable by company maintenance personnel.NTSB FTW97IA363Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200RS · Salt Lake City, UTThe captain's failure to maintain directional control during landing roll. Factors were the loss of hydraulic pressure in the 'A' hydraulic system, the thrust reverser failure on the number one engine, and flight crew coordination not being maintained.NTSB FTW97FA352Accident · Minor injuriesField investigationFinal reportBell 407 · Grand Isle S108The tail rotor blade strike(s) that severed the aft portion of the tailboom, subsequently rendering the pilot with no tail rotor control while in cruise flight. A factor was the lack of suitable terrain for the forced autorotative landing.NTSB MIA97LA245Accident · No injuriesLimited investigationFinal reportLouttit Celebrity · Ridgeland, SCthe in-flight failure of the upper wing spar wood resulting in a forced landing in swampy terrain.NTSB ANC97TA148Accident · No injuriesFinal reportPiper PA-18-150 · Saint Mary'S, AKThe excessive pressure in the brake system resulting from heating of the recently serviced hydraulic fluid in the brake master cylinders, and the resultant locked brakes and inability to maintain directional control of the airplane.NTSB NYC97LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Leroy, OHa lack of fluid in the brake reservoir, and the pilot's decision to operate the airplane with defective brakes, which led to an overrun during landing and a collision with trees.NTSB NYC97FA178Accident · 2 fatalField investigationFinal reportCessna U206B · Gilbertsville, KYThe improper repair of a float by maintenance personnel which resulted in the total failure of the float.NTSB ANC97LA142Accident · No injuriesLimited investigationFinal reportMaule ML-4-220C · Aniak, AKThe inadvertent swerve during landing on calm water. A factor was the pilot's lack of certification in single engine seaplanes.NTSB ANC97LA144Accident · No injuriesLimited investigationFinal reportCessna 185 · Kotzebue, AKThe collapse/deflation of the right main tire when the tire slipped on the tire wheel rim which resulted in the collapse of the right main landing gear due to overload.NTSB LAX97LA312Accident · No injuriesLimited investigationFinal reportCessna T210J · Avra Valley, AZThe pilot became lost/disoriented during his taxiing into the ramp area. Factors in the accident were the lack of taxiway lights, the pilot's lack of familiarity with the layout of the airport, and the airport operator's failure to either identify the…NTSB SEA97FA196Accident · 1 fatalField investigationFinal reportSouthern Aero UH-1B · Skykomish, WAA fatigue fracture in the main rotor mast, which resulted in an in flight separation of the main rotor from the helicopter. Contributing to the accident was insufficient Federal Aviation Administration airworthiness standards and requirements for the aircraft.NTSB FTW97LA331Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Pineland, TXfailure of the right main wheel brake, during the landing roll. A factor relating to the accident was: the pilot's failure (or inability) to maintain directional control of the airplane, after loss of right braking action.NTSB FTW97LA328Accident · No injuriesLimited investigationFinal reportFingerhut Revolution Mini 500 · Huffman, TXThe disengagement of the helicopter's collective control tube due to improper installation by the builder. Factors were the lack of sufficient information provided by the kit manufacturer and the pilot's inability to cushion the landing.NTSB FTW97FA330Accident · 1 fatalField investigationFinal reportSouthwest Florida SW204 · Manila, ARFatigue failure of the main rotor blade resulting in the in-flight separation of the main rotor system due to the use of an unairworthy blade, and failure of the maintenance personnel who modified the rotor blade and the mechanic who complied with the…NTSB LAX97IA300Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300 B4-203 · Los Angeles, CASeparation of the landing gear tire tread and subsequent ingestion of the tread into the intake of the engine.NTSB FTW97LA326Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAThe disconnect of the #5 tail rotor drive segment due to the debonding of the joint between the shaft tube and the flange fitting. Factors were the improper bead blasting of the tail rotor drive segment by an unknown maintenance personnel, and the lack of…NTSB CHI97LA266Accident · Minor injuriesLimited investigationFinal reportSwearingen SA226TC · Des Moines, IAthe pilot's improper in-flight planning/decision and failure to perform the emergency procedure for shut-down of the right engine. Factors relating to the accident were: the power lever cable became disconnected from the fuel control unit, due to improper…NTSB FTW97IA305Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lafayette, LAThe failure of the AC generator due to the failure of the anti-drive end bearing.NTSB LAX97FA276Accident · Serious injuriesField investigationFinal reportLockheed L-1011-385-1-15 · Honolulu, HIthe cumulative distance taxied immediately prior to takeoff that precipitated an excessive heat buildup in the tires and resulted in the bead separation of a single tire during the takeoff roll. The absence of cockpit procedures/directives or monitoring…NTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…NTSB NYC97LA158Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Quinton, VAThe pilot's failure to identify an unsafe landing gear condition. A factor in the accident was the loss of electrical power.NTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.NTSB LAX97LA270Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee PBY-5A(28-5ACF) · Moreno, CAthe implosion of the unlocked left nose gear door which resulted in the hydraulic disintegration of the forward fuselage. The cause of the locking pin actuator malfunction was not determined.NTSB ATL97LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadia, FLfailure of the right nose wheel steering linkage. The close proximity of the fence was a related factor.NTSB LAX97LA257Accident · No injuriesLimited investigationFinal reportFronsman Rotorway Exec · Lakeport, CAan undetermined failure of the oil system (lines or filter), while hovering, which resulted in an engine compartment fire that erupted and subsequently destroyed the helicopter after it was landed.NTSB FTW97LA264Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Crossett, ARfailure of maintenance personnel to perform an adequate inspection of the fuselage center frame and detect a fatigue fracture of a longeron tube on the upper left side of the center frame, which resulted in a disconnect of the tail rotor drive shaft from the…NTSB SEA97LA167Accident · No injuriesLimited investigationFinal reportCessna 140 · Arlington, WAFailure of the right-main landing gear axle after landing.NTSB ATL97LA100Accident · No injuriesLimited investigationFinal reportBeech 55 · Murfreesboro, TNThe failure of the aircraft braking system due to low brake pressure resulting from the undetermined loss of brake fluid from the brake reservoir.NTSB ATL97LA101Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fajardo, PRa malfunction (jamming) of the elevator flight control system for undetermined reason(s).NTSB MIA97IA206Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-61 · Miami, FLfailure of the right main landing gear cylinder due to stress corrosion.NTSB CHI97IA195Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-30 · Flint, MIAn electrical short in the wiring of the left wingtip oscillating position light auto transformer and a failure of the system circuit breaker.NTSB CHI97LA201Accident · Serious injuriesLimited investigationFinal reportWeber RV-4 · Hermann, MOthe pilot's inadequate in-flight planning/decision and encounter with a stall. Related factors were the chafed throttle cable, which became jammed; and failure of the pilot to perform an engine shut down in order to land on the runway.NTSB MIA97LA201Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Altha, FLThe failure of the left main landing gear spring due to a preexisting fatigue crack resulting in the separation of the left main landing gear, and subsequent nose down during taxi.NTSB FTW97IA248Incident · No injuriesIncident investigationFinal reportBeech 95-B55 · Longview, TXThe failure of the rudder pedal bell crank from the right seat side due to an overload fracture.NTSB SEA97LA156Accident · No injuriesLimited investigationFinal reportStiritz Eipper MX II · Newport, WAThe failure of the owner/builder to adequately inspect his homebuilt aircraft, which subsequently led to the failure of the right wing lift cable attach bolt and resulted in the collapse of the right wing during flight.NTSB NYC97LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Tioga, PAThe pilot's improper inflight decision to land downwind with an inoperative airspeed indicator, and his improper landing flare.NTSB FTW97LA243Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gorman, TXthe student pilot's improper inflight planning/decision, and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: a fluctuation in the electrical system, due to an undetermined reason, the student pilot's lack of…