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 NYC97LA129Accident · Serious injuriesLimited investigationFinal reportLockheed L-1011-385-1 · Covington, KYthe failure of the primary and secondary elevator driveshafts, and the failure of maintenance personnel to detect the failure of the primary shaft during scheduled inspections.NTSB LAX97LA222Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · San Diego, CAthe pilot-in-command's failure to maintain an adequate airspeed which resulted in a stall/mush.NTSB IAD97LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Defiance, OHThe failure of a wheel rim due to overstress separation with no clear evidence initiating event.NTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…NTSB CHI97LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Benton, MOthe pilot's inadequate preflight by failing to insure that the secondary flight control lock was stowed properly, and subsequently the secondary flight control lock becoming engaged during the takeoff run. A factor relating to the accident was: inadequate…NTSB NYC97IA123Incident · No injuriesIncident investigationFinal reportBeech 1900D · Clarksburg, WVThe right outboard flap detaching from the flap aft roller bearings, at the flap track, which was a result of the manufacturer's inadequate inspection program.NTSB FTW97FA220Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Corning, ARThe in-flight separation of the left wing as result of fatigue crack of the lower spar cap due to inadequate materials by the manufacturer. A factor was the operator's failure to comply with a published service bulletin on the airframe.NTSB NYC97LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Easton, PAA failed aileron pulley which resulted in loss of tension and subsequent loss of aileron control. A factor was the failure of the mechanic to detect the failed aileron pulley during the annual inspection.NTSB SEA97LA129Accident · No injuriesLimited investigationFinal reportCessna 210D · Renton, WALanding gear hydraulic system power pack failure.NTSB SEA97LA126Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Addy, WAThe inflight failure of the K-FLEX engine-to-gear box drive shaft and no suitable site in which to make a forced/emergency landing. A factor was the mountainous/hilly terrain.NTSB MIA97LA177Accident · No injuriesLimited investigationFinal reportCessna T-210-N · Hollywood, FLfailure of the pilot to ensure the landing gear was locked down before landing, following an electrical system failure, resulting in the left main landing gear collapsing during landing rollout. The electrical malfunction and resultant discharged battery were…NTSB LAX97LA221Accident · No injuriesLimited investigationFinal reportStaudaucher S300D · Chandler, AZThe owner/pilot's decision to use automotive hardware, which had not been heat treated, and the practice of adding aluminum plates to the trailing edge of the aileron without rebalancing the flight controls, which resulted in the separation of the aileron at…NTSB LAX97LA197Accident · 1 fatalLimited investigationFinal reportRotorway 162F · Phoenix, AZthe owner/builder incorrectly installed the tail rotor drive pulley mounting scissors, overtorqued the pivot belts, did not perform the required maintenance lubrication of the pivot belts, and failed to perform adequate visual maintenance checks of these…NTSB NYC97LA101Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Granby, NYfailure of the pilot/owner to replace the torsional clutch as specified by the manufacturer, and subsequent failure of the helicopter's clutch, which resulted in a forced landing (autorotation). A related factor was: the encounter with trees in the emergency…NTSB FTW97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Greeley, COunlatching of the left outboard engine cowling latches for undetermined reason(s), which allowed the left engine cowling to separate inflight and strike the vertical stabilizer.NTSB CHI97FA149Accident · No injuriesField investigationFinal reportBell 206L3 · Boise, IDthe improper torque meter installation by maintenance personnel, attempting flight with known discrepancies by the pilot-in-command and the check airman, and an improper autorotation by the pilot-in-command with improper oversight of the autorotation maneuver…NTSB SEA97FA120Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Bend, OROverload of the airframe structure. Thunderstorms and turbulence were factors.NTSB ANC97TA074Accident · No injuriesFinal reportSchweizer SGS 1-26E · Fort Wainwright, AKthe pilot's inadequate preflight and improper planning/decision. Factors relating to the accident were: an unlatched canopy, and unsuitable terrain for landing.NTSB FTW97LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28R-210T · Fort Collins, COthe pilot's failure to know and follow the emergency procedure for extending the landing gear after loss of electrical power. Factors relating to the accident were: an inoperative alternator, inadequate maintenance by the operator, a depleted battery, and…NTSB CHI97IA134Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Saint Louis, MOfailure of company maintenance personnel to properly install a mounting eyebolt (and associated cotter pin, washer, spacer and castellated nut) on the lower forward bracket of the left main landing gear strut door.NTSB LAX97LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Burbank, CAimproperly secured upper cowl fasteners by unknown person(s).NTSB MIA97IA160Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Miami, FLfatigue failure of a segment of the elevator trim cable system. A factor relating to the incident was: inadequate procedure for inspection of the cable system by the airplane manufacturer.NTSB ATL97LA080Accident · No injuriesLimited investigationFinal reportLearjet 31A · Atlantic Ocean (Atlantic Ocean)the pilot-in-command's failure to maintain airspeed within the design structural limits of the airplane.NTSB NYC97LA085Accident · 1 fatalLimited investigationFinal reportMarsh-Turner BG-12A · Marion, OHDisconnection of the elevator control rod which resulted in the loss of elevator control. A factor was failure to complete the required maintenance inspection.NTSB SEA97LA096Accident · Minor injuriesLimited investigationFinal reportHendrix Talon XP · Redmond, ORincomplete installation (omission of the aft control stick and interlink tube) of the flight control system, resulting in failure of the combined (torque) elevator and aileron rod and a disconnection of the forward flight control stick from the ailerons and…NTSB CHI97LA119Accident · No injuriesLimited investigationFinal reportBeech D35 · Lexington, KYflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.NTSB CHI97IA122Incident · No injuriesIncident investigationFinal reportBeech 35 · Spokane, WAthe vibration of the fuselage was due to flutter.NTSB ATL97LA069Accident · No injuriesLimited investigationFinal reportBeech 33 · Carrollton, GAThe inadequate maintenance inspection of the airplane that resulted in the disconnection of the propeller governor linkage and the subsequent reduction in engine power. The pilot also failed to maintain flying speed that resulted in an inadvertent stall…NTSB MIA97IA147Incident · No injuriesIncident investigationFinal reportBoeing 747-2R7F · Miami, FLdisbonding and separation of the right inboard wing fixed trailing edge panel during cruise flight, which resulted in damage to the inboard fore flap and inboard mid flap, and a subsequent precautionary landing at the departure airport.NTSB ANC97LA053Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nikiski, AKthe pilot's improper installation of the landing gear wheel.NTSB MIA97TA139Accident · No injuriesFinal reportBell 204-B · Calderwood, TNThe inadequate maintenance inspection of the helicopter resulting in loss of lubrication from the main drive shaft going undetected until failure of the drive shaft.NTSB NYC97FA076Accident · 1 fatalField investigationFinal reportEurocopter MBB-BK117-B2 · New York, NYFatigue failure of the vertical fin, accelerated by the installation of blind rivets in lieu of solid rivets in the replacement of the yaw SAS mount support, which resulted in the loss of helicopter directional control and collision with the terrain (water).…NTSB ATL97LA059Accident · No injuriesLimited investigationFinal reportCessna 210D · Huntsville, ALcorrosion and subsequent failure of the elevator trim tab, which resulted in vibration and failure of the elevator. Failure of maintenance personnel to comply with a service bulletin was a related factor.NTSB MIA97LA120Accident · 1 fatalLimited investigationFinal reportBasinski Kolb MK3 · Winter Haven, FLfailure of the pilot to maintain airspeed after an oil leak occurred, which resulted in an inadvertent stall/spin and subsequent collision with a residence and the terrain. The oil leak and the pilot's diverted attention were related factors.NTSB FTW97LA157Accident · No injuriesLimited investigationFinal reportBeech BE-95 · San Antonio, TXThe failure of the right main gear due to improper repair by the company maintenance personnel.NTSB FTW97LA156Accident · No injuriesLimited investigationFinal reportRockwell 114 · Oklahoma City, OKThe exhaust manifold cracking due to the pilot's inadequate maintenance modification of the exhaust system which resulted in a fire. A factor was the lack of suitable terrain for the forced landing.NTSB MIA97IA151Incident · No injuriesIncident investigationFinal reportBeech 100 · Kenly, NCInadequate inspection procedures by the airframe manufacturer for failure to require removal of the metal retaining ring to inspect the entire area of the window for cracks.NTSB LAX97FA143Accident · 2 fatalField investigationFinal reportCessna T210N · Grand Canyon, AZThe pilot's failure to maintain aircraft control due to spatial disorientation and his lack of proficiency in conducting instrument flight. Contributing were the inoperative alternator, cockpit lighting, and vacuum system.NTSB ATL97LA056Accident · 1 fatalLimited investigationFinal reportCessna A188B · Waynesboro, GAThe failure of the right wing after the pilot exceeded the design stress limit of the airplane, leading to a loss of control in flight.NTSB NYC97LA066Accident · 2 fatalLimited investigationFinal reportLowe Super Koala · Perry Township, PAimproper construction by the builder which led to the failure of the strut and wing assembly.NTSB CHI97FA095Accident · 1 fatalField investigationFinal reportCessna 140 · Big Lake, MNThe pilot's maneuvers which exceeded the design stress limits of the airplane and resulted in structural overload of the horizontal tail followed by a structural overload of the wings.NTSB FTW97IA144Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Dfw Airport, TXThe manufacturer's improper installation of the flap, which resulted in fatigue cracking of the flap attach bolts and separation of the flap.NTSB ANC97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKa fuel leak from an engine driven fuel pump which initiated an engine fire, and the fuel pump manufacturer's inadequate quality control of the fuel pump.NTSB ANC97LA040Accident · No injuriesLimited investigationFinal reportCessna 185 · Chugiak, AKThe pilot's improper installation of the main landing gear wheel penetration skis, which allowed the skis to rotate to a vertical position in flight and subsequently separate during landing.NTSB FTW97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Abilene, TXThe unlatching of the front bench seat for an undetermined reason.NTSB FTW97FA135Accident · 1 fatalField investigationFinal reportTeschendorf Cassutt Sport · Stilwell, OKfailure of the right wing spar and/or debonding of the right wing skin, which resulted in separation of the wing skin and a portion of the right wing, during high speed flight. Factors related to the accident were: previous wing damage and inadequate…NTSB LAX97LA125Accident · No injuriesLimited investigationFinal reportCessna 425 · Fresno, CAfailure of the right brake to function, due to the installation mechanic's failure to completely bleed all air from the lines. A factor in the accident was the pilot's decision to fly the unairworthy aircraft before the engine/propeller installation had been…NTSB LAX97FA123Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Pacoima, CAimproper maintenance/installation of electrical wiring, the lack of circuit protection, and subsequent in-flight electrical fire.NTSB ANC97IA035Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Kotzebue, AKthe jammed main landing gear which was caused by a binding main landing gear door with a broken hinge. The fractured, inadequate main landing gear door hinge was also causal.NTSB SEA97IA071Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Portland, ORimproper installation of four attach bolts on the elevator drive torque tube.