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 BFO93FA188Accident · 2 fatalField investigationFinal reportErcoupe 415-CD · Charles City, VAthe pilot exceeded the design stress limits of the airplane which resulted in an in-flight break-up.NTSB CHI93FA378Accident · 2 fatalField investigationFinal reportAero Commander 690A · Lansing, MIwas the pilot-in-command not maintaining aircraft control during the intermittent operation of the electrically operated attitude gyro. Factor's associated with this accident are an fluctuating (intermittent) electrical system inverter and the…NTSB MIA93FA200Accident · 1 fatalField investigationFinal reportBeech C35 · Ocklawaha, FLFailure of a propeller blade for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: low pass performed by the pilot, and his possible impairment from…NTSB SEA93LA207Accident · No injuriesLimited investigationFinal reportBell UH-1B · Pierce, IDSeparation of the 90 degree gearbox after fatigue failure of the gearbox attach bolts. Factors include hilly/mountainous terrain.NTSB MIA93LA202Accident · No injuriesLimited investigationFinal reportCessna 172M · Hollywood, FLInadvertent exceeding of vfe with the flaps extended by the student pilot while practicing maneuvers.NTSB CHI93IA372Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Indianapolis, INan undetermined problem which resulted in the physical impairment of flight attendants, passengers and the first officer.NTSB CHI93LA373Accident · No injuriesLimited investigationFinal reportBeech 18-C45G · Jeffersonville, INthe mechanical binding of the landing gear extension mechanism.NTSB CHI93LA365Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Aurora, ILthe fatigue failure and separation of a portion of propeller blade during cruise flight. Related factors are the damage to the flat face of the blade, and inadequate maintenance inspection of the propeller.NTSB FTW93LA261Accident · Minor injuriesLimited investigationFinal reportCulver V · Carlsbad, NMAn inadvertent stall when the pilot lowered the landing gear. A factor was a leaking o-ring in the propeller governor.NTSB SEA93LA217Accident · No injuriesLimited investigationFinal reportBeech G35 · Arlington, WAFracture of the left stabilizer spar.NTSB BFO93IA176Incident · No injuriesIncident investigationFinal reportDouglas DC-8-63 · Toledo, OHThe operator maintenance personnel's failure to perform an adequate inspection of the airplane, which led to a worn aileron cable which separated in flight and caused a loss of control.NTSB BFO93IA175Incident · No injuriesIncident investigationFinal reportBoeing 757-200ER · Jamaica, NYThe failure of the left hydraulic pressure switch, which caused the left yaw damper module to become inoperative resulting in uncommanded rudder movements during flight.NTSB NYC93IA184Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · New York, NYThe improper installation of the fairing by company maintenance personnel, resulting in the infligh separation of the fairing in flight.NTSB BFO93FA167Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Marshall, VAAn inadequate annual inspection of the airplane and non-compliance with airworthiness directives by company maintenance personnel.NTSB CHI93IA354Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · St. Louis, MOa failure of the left outboard foreflap due to the loss of the bolts that hold the inboard sequencing carriage to the foreflap attach lug.NTSB CHI93LA353Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 Twin Astir · New Douglas, ILFailure of the glider tow attachment. Factors related to the accident were the improper emergency procedure by the student, and the flight instructor's delayed remedial action..NTSB CHI93IA352Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · St. Louis, MOa fatigue failure of the power transfer unit caused by a material defect which resulted in a total hydraulic system failure.NTSB BFO93LA149Accident · Serious injuriesLimited investigationFinal reportLach Bensen B-8M · Fall River, MAFATIGUE FAILURE OF THE GYROCOPTER'S MAIN ROTOR CONTROL ARM. fACTORS RELATED TO THE ACCIDENT WERE: A LOOSE CLAMP ON THE ROTOR CONTROL ARM, DUE TO INADEQUATE MAINTENANCE OR INSPECTION, WHICH RESULTED IN CHAFING OF THE CONTROL ARM.NTSB CHI93IA382Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Grand Rapids, MNthe fractured aileron cable and other maintenance personnel's inadequate maintenance/adjustment.NTSB LAX93LA338Accident · No injuriesLimited investigationFinal reportBeech 95 · Kingman, AZthe fatigue cracking of the propeller blade retention screw. A factor was the maintenance service bulletins for the propeller were not performed on the accident airplane.NTSB MIA93LA185Accident · Serious injuriesLimited investigationFinal reportKeuthan Buccaneer II · Cocoa, FLFailure of maintenance personnel to properly reinstall a bolt and nut in the elevator control linkage, which resulted in a disconnect of the linkage and loss of elevator control.NTSB SEA93FA186Accident · No injuriesField investigationFinal reportDassault DA-10 · Hailey, IDThe pilot-in-command's improper procedures. Factors include failure of an electrical relay, inoperative thrust reverser, poor crew coordination, and the second-in-command's improper procedures.NTSB BFO93FA147Accident · No injuriesField investigationFinal reportMooney M20B · Landover, MDFatigue failure of a propeller blade, which resulted in severe engine vibration and subsequent damage to the airplane. The lack of suitable terrain for a forced landing was a related factor.NTSB CHI93LA334Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Hinckley, ILthe failure of the cockpit canopy.NTSB CHI93DEM02Accident · Minor injuriesFinal reportSheats FALCON-XP · Zeeland, MIan inadequate maintenance inspection by the pilot/owner and the separation of the wing skin.NTSB CHI93FA329Accident · 2 fatalField investigationFinal reportCessna 310N · Rockford, ILan arcing electrical relay (solenoid) and subsequent overheating/fire of the starter wiring and adjacent fuel lines.NTSB LAX93LA326Accident · Serious injuriesLimited investigationFinal reportPilatus B4-PC11AF · Truckee, CAFailure of the pilot to conduct adequate preflight checks which resulted in the glider taking off with a frayed release hook cable, the pilot's failure to maintain airspeed, and the inadvertent stall.NTSB FTW93IA242Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B16 · San Antonio, TXThe fracture of the rudder quadrant due to stress corrosion. A factor was the manufacturer's improper selection of material.NTSB NYC93LA157Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Beach Haven, NJFailure of the banner release system to function for an undetermined reason, which resulted in an inability of the aircraft to sustain flight once the banner began dragging in the water. A factor related to the accident was: lack of coordination between the…NTSB NYC93LA156Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Lawrence, MAThe improper installation of the battery box cover by maintenance personnel.NTSB LAX93LA323Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Chico, CAthe observer's failure to properly secure stowed items in the rear compartment prior to takeoff and the resultant foreign object damage to the tail rotor system which precluded the pilot from maintaining directional control.NTSB FTW93LA236Accident · No injuriesLimited investigationFinal reportBeech F35 · Mena, ARThe inflight separation of the ruddervator as result of improper balancing.NTSB SEA93LA172Accident · No injuriesLimited investigationFinal reportBeech 76 · Portland, ORJamming of the nose landing gear assembly and the pilot-in-command not maintaining the proper glidepath during the nose gear up landing.NTSB FTW93LA233Accident · Minor injuriesLimited investigationFinal reportAero Falcon Intl. Knight Falcon · Mineral Wells, TXFailure of the autopilot which resulted in an improper flight control condition. A factor was the pilot's inability to regain control.NTSB DEN93FA099Accident · 6 fatalField investigationFinal reportPiper PA-32-300 · Delight, ARThe failure of the vacuum pump, and an inoperative turn coordinator. Factors which contributed to the accident were: the pilot's loss of control of the airplane as a result of spatial disorientation, the pilot exceeding the design stress limits of the…NTSB MIA93IA168Incident · No injuriesIncident investigationFinal reportBoeing 707-341 · Miami, FLThe improper inspection of the engine core cowling, which resulted in fatigue cracks in the forward inboard hinge support structure to go undetected. This resulted in the hinge separating and the cowling separating in flight.NTSB LAX93LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fresno, CAThe pilot's inadequate flare and his improper recovery from the resulting bounced landing. Factors related to this accident were the alternator failure and the night condition.NTSB LAX93LA310Accident · Minor injuriesLimited investigationFinal reportNall Varieze · Newark, CAImproper annual inspection performed by other maintenance personnel. Factors relating to this accident were the loose exhaust bolts.NTSB LAX93FA311Accident · 3 fatalField investigationFinal reportRobinson R44 · El Monte, CAFatigue failure of the cyclic control (stick) assembly, which resulted in loss of cyclic (pitch & roll) control.NTSB DEN93LA091Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Duson, LAFailure of the transmission mast bearing, resulting in oil contamination and subsequent blockage of the internal oil ports and passages. Factors were: total loss of collective control and partial loss of cyclic control.NTSB ANC93LA127Accident · Minor injuriesLimited investigationFinal reportBeech D18S · Kodiak, AKThe pilot's improper in flight planning/decision. A factor was the partial loss of power on one engine.NTSB DEN93LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garner, ARTotal failure of one propeller blade. Factors were the continued operation of the engine during the forced landing, despite the pilot's efforts to shut it down, and the lack of suitable terrain for the forced landing.NTSB CHI93IA312Incident · No injuriesIncident investigationFinal reportBritish Aerospace 146-300A · Chicago, ILwas a crack in the fuel system fuel flow distribution manifold which resulted from an inadequate design by the manufacturer.NTSB FTW93LA262Accident · No injuriesLimited investigationFinal reportZbacnick Challenger II · Alamogordo, NMThe seizure of the propeller shaft bearing and the resultant propeller blade separation. Factors were the unfavorable winds and the lack of suitable terrain available for the forced landing.NTSB DEN93LA080Accident · Minor injuriesLimited investigationFinal reportGlasflugel Standard Libell · Boulder, COImproper rigging of the spoiler system by maintenance personnel, which caused an uncommanded spoiler deployment and prevented spoiler retraction by the pilot. A factor was unsuitable terrain for a forced landingNTSB DEN93LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Burkburnett, TXThe disconnection of the up elevator cable from the control horn. A factor was the incorrect installation of the bolt and castle nut by unknown maintenance personnel.NTSB DEN93LA076Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAFailure of the spray rig which sprayed chemicals into the pilot's eyes temporarily blinding him.NTSB MIA93LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Atlantic Ocean (Atlantic Ocean)Total loss of engine power from both engines due to fuel exhaustion after the pilot became lost/disoriented. Contributing to the accident was the delay by the pilot-in-command to execute the emergency procedure by resetting the alternators and voltage…NTSB CHI93IA248Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Detroit, MIthe failure of a navigation system (#1 INS) for reason or reasons undetermined.NTSB DEN93LA074Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Grand Junction, COFailure of the pilot in command to follow manual gear extension procedures. A factor was a total electrical failure.