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 LAX95LA331Accident · No injuriesLimited investigationFinal reportBell 47G-3B2 · Yuma, AZthe failure of the pilot and company maintenance personnel to detect a crack in the clevis ears during the required daily inspection and the recent annual inspection. A factor in the accident was the improper welding and stress relief procedure used to…NTSB FTW95LA383Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Greeley, COThe pilot's improper in-flight planning/decision by inadvertently selecting a less suitable area for landing (than the runway). Factors relating to the accident were: a malfunction of the nose landing gear micro-switch, which resulted in a false indication…NTSB CHI95IA313Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72 · Chicago, ILimproper installation of the #7 and #8 fuel nozzle manifold transfer tubes by company maintenance personnel, and an inadequate exhaust drain fitting gasket, which resulted in fuel leaks at the respective 'O' ring/gasket fittings; blockage of the fuel/oil…NTSB LAX95LA318Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Dos Palos, CAthe fatigue failure of the tail rotor tension torsion bar plates.NTSB FTW95LA373Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Broomfield, COThe pilot's attempt to taxi with a known inoperative brake. A factor was partial brake failure due to a leaking seal.NTSB SEA95LA200Accident · No injuriesLimited investigationFinal reportCessna 210 · Sunriver, ORThe failure of the landing gear hydraulic drive motor.NTSB BFO95LA094Accident · Minor injuriesLimited investigationFinal reportCessna 310K · Columbiana, OHThe improper maintenance installation and the subsequent separation of the torque links on the left main landing gear during the landing roll.NTSB MIA95LA217Accident · No injuriesLimited investigationFinal reportCessna 337D · Carthage, MSFailure of the normal brake system for undetermined reasons. Contributing to the accident was the failure of the pilot's seatback.NTSB SEA95LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ogden, UTthe pilot's failure to use brakes to maintain directional control following a tailwheel steering malfunction. Partial failure of the tailwheel steering system contributed to the accident.NTSB MIA95IA214Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Fort Lauderdale, FLLow electrical resistance of the autopilot aileron actuator for unspecified reasons which resulted in an uncommanded roll to the right.NTSB LAX95FA303Accident · No injuriesField investigationFinal reportLockheed L-1011-385-1 · Pacific Ocean (Pacific Ocean)inadequate certification/approval of the airframe structure. Contributing was the lack of required inspections of the failure area.NTSB CHI95LA287Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Anderson, INseizure of the landing gear wheel bearing and separation of the landing gear outer wheel-half and tire from the aircraft after which directional control of the aircraft by the pilot was not possible.NTSB FTW95LA355Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fayetteville, ARThe pilot's inability to extend the landing gear due to the failure of an emergency gear extension valve.NTSB CHI95LA288Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-1 · Hammond, WIan overload failure of the right horizontal support tube assembly which the pilot/owner had modified to be adjustable. A factor in the accident was the corn.NTSB BFO95FA082Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · East Moriches, NYthe structural failure of the wing for undetermined reasons.NTSB FTW95IA348Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Lubbock, TXinstallation of an incorrect bearing in the number three main wheel by the wheel assembly supplier, which led to subsequent failure of the wheel bearing and separation of the wheel during takeoff.NTSB NYC95LA197Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340-A · Philadelphia, PAthe failure of a titanium hydraulic line, which resulted in an uncontained hydraulic fluid wing fire. A factor was the use of a procedure by the operator, approved by the FAA, but not approved by the airplane manufacturer, which resulted in compartment…NTSB NYC95FA195Accident · 2 fatalField investigationFinal reportCessna 310R · Altoona, PApropagation of corrosion cracks in the right engine overboard exhaust stack and fatigue failure of the exhaust stack, which resulted in escape of hot/high velocity gases, in-flight fire, emergency descent, and subsequent collision with trees during an…NTSB FTW95LA346Accident · No injuriesLimited investigationFinal reportCessna 150F · Manila, ARA blown (tripped) fuse, which rendered flap retraction inoperative. Factors relating to the accident were: the hot weather condition, the aircraft's lack of climb performance with the flaps extended, and the lack of suitable terrain in the forced landing area.NTSB ANC95LA140Accident · No injuriesLimited investigationFinal reportCessna 185A · Teller, AKDeflation of the left main tundra tire due to valve stem damage (failure) when the tire rotated independently of the wheel rim, resulting in loss of directional control and a ground swerve.NTSB CHI95LA274Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSa fatigue failure of the propeller blade, and inadequate maintenance inspection performed by the propeller shop.NTSB LAX95LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Truckee, CAA failure in the aircraft electrical system, and the pilot's failure (or inability) to extend the landing gear with the emergency extension system. A factor relating to the accident was: the pilot's decision to continue the flight with a known deficiency.NTSB FTW95LA338Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon Newport AX8 · Houston, TXThe loss of lift and subsequent hard landing as result of the disengagement of a velcro strip at the top of the balloon's envelope.NTSB ATL95LA152Accident · Serious injuriesLimited investigationFinal reportAero Commander 100-180 · Ocracoke, NCA shattered windshield which precluded maintaining level flight due to increased aerodynamic drag.NTSB SEA95LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · Bullfrog, UTThe right brake locking for undetermined reasons.NTSB LAX95LA288Accident · No injuriesLimited investigationFinal reportCessna 152 · Camarillo, CAThe failure of the landing gear strut due to fatigue.NTSB ATL95LA151Accident · No injuriesLimited investigationFinal reportCessna 188T · Town Creek, ALThe chafing of the fuel flow gage pressure line with an electrical system wire which resulted in arcing.NTSB BFO95LA078Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-5 · Luray, VAthe pilot's failure to attain the proper touchdown point on the runway during a precautionary landing. A factor was an undetermined lubricating system problem.NTSB LAX95LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355-F1 · Daggett, CAthe failure of the Starflex arm due to fatigue, and the manufacturer's inadequate maintenance procedure. The operator's maintenance personnel failure to understand the repair procedure was a factor in the accident.NTSB FTW95LA335Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus A · Rocksprings, TXDebonding of mylar tape that was used to seal a gap on the elevator, which resulted in inadequate elevator control authority.NTSB MIA95IA194Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Charlotte, NCImproper installation of the 'a' system flight control computer by company maintenance personnel, which resulted in pin connector(s) being pushed loose and subsequent malfunction of the autopilot.NTSB LAX95LA278Accident · 1 fatalLimited investigationFinal reportFox Peregrine PJ-2 · Minden, NVa failure of the wing flap control system due to inadequate design, which led to an asymmetrical flap deployment during a critical flight condition and in-flight loss of control. A related factor was the lack of a split-flaps warning system.NTSB ANC95LA122Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Kodiak, AKOverload failure of the main landing gear wheel.NTSB SEA95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Shelley, IDThe left main landing gear tire burst during takeoff.NTSB SEA95LA159Accident · No injuriesLimited investigationFinal reportCessna 402B · Wenatchee, WAImproper installation (failure to install cotter key) by company maintenance personnel.NTSB LAX95FA272Accident · 2 fatalField investigationFinal reportRockwell 112TC · Los Angeles, CAan undetermined aircraft system malfunction, and the pilot's delayed remedial action in response to insufficient braking action and/or inability to control engine power.NTSB FTW95LA320Accident · No injuriesLimited investigationFinal reportPiper PA-60-601A · Fulshear, TXThe pilot's failure to maintain a proper climb rate after take off. Factors were the pilot's diverted attention toward the malfunctioning landing gear, his intentional shutdown of operational engines, and the lack of suitable terrain for landing.NTSB FTW95LA316Accident · No injuriesLimited investigationFinal reportGulfstream GV-1 · Englewood, COFailure of the left main landing gear strut attachment for undetermined reasons.NTSB SEA95LA156Accident · No injuriesLimited investigationFinal reportFairchild 24G · Nyssa, ORLock-up of the mechanical cable-actuated right wheel brake system, rendering directional control of the aircraft impossible. Contributing to the accident was a crosswind from the left during the landing.NTSB MIA95IA187Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Orlando, FLContamination of the wiring harness and electrical connectors to the E-1-2 and E-1-3 shelf disconnect brackets in the electronics compartment, which resulted in an electrical fault and an uncommanded roll malfunction of the autopilot. A factor relating to the…NTSB MIA95LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Aberdeen, MSThe operator's and pilot's procedure of leaving the aircraft unattended with the engine running while loading agricultural chemicals into the aircraft. This resulted in the aircraft moving unattended and colliding with a ditch. Contributing to the accident…NTSB ANC95LA103Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Ketchikan, AKThe cracks in the trailing edge of the elevator servo tab, which resulted in its subsequent failure and partial separation.NTSB NYC95LA161Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Warren, VTa failed elevator cable which resulted in an inflight loss of control and uncontrolled contact with trees.NTSB ATL95LA132Accident · No injuriesLimited investigationFinal reportCessna 310 · Ridgeland, SCThe pilot's failure to assure that the airplane's alternators were on which led to a complete loss of electrical power, and his failure to attempt to lower the landing gear by emergency procedures.NTSB NYC95LA157Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Queenstown, MDfailure of the fuselage longeron tubes due to fatigue, which resulted in partial separation (distortion) of the fuselage, partial loss of aircraft control, and a partial loss of engine power.NTSB NYC95LA147Accident · 1 fatalLimited investigationFinal reportBell 47G-3B-1 · Hammonton, NJfailure of the collective yoke bearing, which resulted in an uncontrolled descent and collision with trees. A factor relating to the accident was: the manufacturer's inadequate inspection interval of the yoke bearing.NTSB FTW95FA278Accident · 2 fatalField investigationFinal reportNorth American T-28B · Ramah, COThe aircrew allowed the airplane's design stress limits to be exceeded.NTSB NYC95LA142Accident · No injuriesLimited investigationFinal reportBell 206-BIII · New York, NYThe pilot' inadequate preflight inspection. A factor was the pilot's diverted attention.NTSB FTW95IA271Incident · No injuriesIncident investigationFinal reportSaab-Scania SF340A · Temple, TXImproper installation of the right main gear outboard wheel, which resulted in separation of the wheel from the axle during takeoff.NTSB LAX95LA240Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Long Beach, CAthe inadvertent entanglement of the banner tow cable with the rudder control system, which resulted in a full and uncorrectable deflection of the rudder, and the pilot's inability to control the aircraft.