NTSB investigations
410 cases where the sequence of events included Flight control sys malf/fail.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '333' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '333' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN24LA366Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Ackerman, MSThe excessive airplane speed during a no-flap landing, and the pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun. Contributing to the accident was the interference of the instrument panel wiring with the flight control…NTSB GAA24WA309Incident · No injuriesClass 5 · ForeignMarquart MA5 · Sussex, United KingdomNTSB GAA24WA290Incident · No injuriesClass 5 · ForeignEmbraer EMB550 · Bromma, SwedenNTSB CEN24LA270Incident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Hillrose, COThe binding of the left flap due to improper maintenance.NTSB DCA24WA223Incident · No injuriesClass 5 · ForeignBoeing 777 · London, United KingdomNTSB ERA24LA263Accident · No injuriesClass 3 · LimitedFinal reportRotorway Exec · Alva, FLA loss of tail rotor control as a result of unsecured tail rotor drive belt tensioner bolts.NTSB DCA24WA207Incident · No injuriesClass 5 · ForeignBoeing 727 · Cardiff, United KingdomNTSB ERA24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportWilliam Loren Noggle JA30 Superstol · Tennille, GAThe loss of elevator control during flight due to the elevator control rod and its hardware disconnecting from its installation area, which resulted in an uncontrolled descent into trees and terrain. Contributing to the accident was the pilot’s inadequate…NTSB WPR24FA182Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Auburn, WAThe pilot’s improper installation of the control stick pushrod assemblies, which resulted in separation of the left pushrod and a total loss of roll control during flight. Contributing to the accident was the failure to detect the installation error during…NTSB DCA24LA206Incident · No injuriesClass 3 · LimitedPreliminary reportBoeing 737-8 · Oakland, CAOn May 25, 2024, about 0744 Pacific daylight time, Southwest Airlines (SWA) flight 746, a Boeing 737-8, N8825Q, experienced a rudder control system anomaly while operating as a Title 14 Code of Federal Regulations Part 121 scheduled domestic passenger flight…NTSB DCA24WA153Incident · No injuriesClass 5 · ForeignBoeing 737 · Maiquetía, VenezuelaNTSB ERA24LA128Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters PA18-150 · Edgewater, FLMaintenance personnel’s failure to detect the worn aileron cable during the most recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during landing.NTSB GAA24WA104IncidentClass 5 · ForeignCessna 152 · Hampshire, United KingdomNTSB CEN24LA115Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 400 · Bentonville, ARImproper rigging of the elevator cable over the upper guard pin, which resulted in a cable separation and loss of elevator control.NTSB DCA24LA094Incident · No injuriesClass 2 · LimitedFinal reportBoeing 737-8 · Newark, NJMoisture intrusion through the pressure port inlet of the rudder rollout guidance actuator that accumulated and froze during flight at altitude, resulting in jammed rudder pedal movement.NTSB DCA24WA113OccurrenceClass 5 · ForeignBoeing 737-824 · Vancouver, CanadaNTSB DCA24WA052IncidentClass 5 · ForeignBoeing 737 · Billund, DenmarkNTSB DCA24WA045IncidentClass 5 · ForeignBoeing 737 · Quito, EcuadorNTSB WPR24LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · Yuma, AZAeroelastic flutter of the rudder control surface during the takeoff initial climb for reasons that could not be determined based on the available evidence, which resulted in the fracture of the rudder trim control rod end in flight.NTSB WPR23LA317Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Fullerton, CAThe separation of the stabilator actuator from the stabilator tab, which resulted in pitch control surface flutter and structural damage.NTSB ERA23LA319Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · North Charleston, SCA failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.NTSB ENG23WA043Incident · No injuriesClass 5 · ForeignATR ATR72 · Brazzavillec, Congo - KinshasaNTSB ERA23LA253Accident · Minor injuriesClass 3 · LimitedFinal reportBeech V35A · Statesboro, GAMaintenance personnel’s improper installation of the pitch servo bridle cable clamp, which led to binding in the elevator control system that restricted aft yoke movement during the landing approach.NTSB ERA23FA247Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Lake Worth, FLMaintenance personnel’s failure to detect the corroded aileron cable during recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during takeoff.NTSB ERA23LA245Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-25-260 · Hollywood, FLThe pilot’s improper banner pickup approach, which resulted in the banner tow hook contacting the airplane, and the subsequent overload separation of the right rudder control horn, resulting in a loss of airplane control.NTSB CEN23LA172Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-200 · Coldspring, TXThe stabilator trim rod assembly separated from the stabilator link assembly due to a missing connecting bolt, which resulted in the pilot’s inability to maintain pitch control of the airplane.NTSB CEN23LA170Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8F · Palmer, TXThe installation of an unapproved rudder control cable, which resulted in a fatigue failure and subsequent loss of rudder control during cruise flight. Contributing to the accident was the mechanic’s inadequate inspection of the rudder control system.NTSB DCA23WA242Incident · No injuriesClass 5 · ForeignBoeing 777 · Frankfurt, GermanyNTSB ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.NTSB DCA23WA189OccurrenceClass 5 · ForeignBoeing 737 · Budapest, HungaryNTSB CEN23FA045Accident · No injuriesClass 3 · FieldFinal reportCirrus Design SF50 · Mount Comfort, INThe uncommanded activation of the CAPS autopilot mode due to corrosion of the system’s electrical components. Contributing to the accident was the pilot’s failure to identify the CAPS autopilot mode and promptly follow the procedures in the airplane flight…NTSB ERA23LA167Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Winter Haven, FLThe pilot’s failure to properly secure the rear seat headset, resulting in an obstruction of the airplane’s rudder controls.NTSB ERA23LA002Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 7AC · Murray, KYThe incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during post-maintenance checks and the pilot's inadequate preflight check.NTSB CEN22LA430Accident · No injuriesClass 3 · LimitedFinal reportAgusta AW139 · Houma, LAThe inflight loss of collective control of the helicopter due to thermal damage of a collective control torque tube that abraded with misrouted electrical wiring, which resulted in an electrical short and inflight fire. Contributing to the accident were the…NTSB ERA22LA428Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Cincinnati, OHThe airplane builder’s installation of incorrect hardware in the control yoke assembly, which resulted in a loss of control during takeoff.NTSB DCA22LA212Incident · No injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Los Angeles, CAUncommanded movement of the trimmable horizontal stabilizer control wheel for reasons that could not be determined based on the available evidence.NTSB WPR22LA340Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206L-1 · Banning, CAThe improper attachment of the tail rotor drive shaft to the air conditioner drive pulley without a drive ring, which resulted in the failure of the hardware, a loss of tail rotor drive, and the loss of control of the helicopter followed by a hard landing and…NTSB ENG22WA040IncidentClass 5 · ForeignBombardier CL600 2B16 · Farnborough, United KingdomNTSB ERA22LA358Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Dillingham, AKMaintenance personnel’s failure to detect and correct improper rudder control system alignment, the resulting interference with the pulley’s rotation, and the accelerated corrosion and wear of the control cable, which ultimately led to its failure in flight.NTSB ERA22LA340Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Mariner · Hollywood, FLInadequate maintenance of the helicopter’s tail rotor blades, which resulted in a failure of the tail rotor drive system, and an inflight loss of yaw control from which the flight instructor was unable to recover.NTSB DCA22LA179Incident · No injuriesClass 4 · LimitedFinal reportBoeing 767-332 · New York, NYThe failure of maintenance personnel to close the drain mast heater circuit breakers which resulted in the formation of ice in the forward drain mast, an improper flow of wastewater into the main landing gear wheel well, and the formation of ice on one or…NTSB ERA22LA299Accident · Serious injuriesClass 4 · LimitedFinal reportArnold J/Jones D L AIR CAM · Sebring, FLThe pilot’s loss of control during landing.NTSB WPR22FA216Accident · 1 fatalClass 3 · FieldFinal reportCessna 336 · Porterville, CAMaintenance personnel’s failure to properly secure the elevator control assembly hardware, which resulted in an in-flight disconnection of the elevator and elevator counterweight and the pilot’s inability to maintain pitch control.NTSB ERA22FA257Accident · Serious injuriesClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · Fairfield, NJThe failure of maintenance personnel to properly secure the tail rotor crosshead drive plate and the failure of maintenance personnel, the maintenance pilot, and the accident pilot to detect the error, which led to the helicopter’s loss of tail rotor…NTSB CEN22LA202Accident · No injuriesClass 3 · LimitedFinal reportCessna 421C · Monroe, LAThe failure of the maintenance personnel to properly reinstall the elevator trim tab hardware, which resulted in an in-flight separation of the elevator.NTSB ERA22LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · Connellsville, PAThe pilot/mechanic’s failure to properly secure two airplane avionics units, which resulted in the trays supporting the units to sag downward and become lodged in the movement area of the elevator bellcrank during the accident takeoff.NTSB ENG22WA024IncidentClass 5 · ForeignBoeing 737 · Queensland, AustraliaNTSB ERA22FA189Accident · 1 fatalClass 3 · FieldFinal reportSchleicher ASW-19B · Jacksonville, FLThe pilot’s improper preflight assembly of the glider’s elevator control, which resulted in a loss of control on takeoff, and the pilot’s failure to complete a positive control check before the flight, which would have identified the disconnected elevator…NTSB DCA22WA107IncidentClass 5 · ForeignBoeing 777 · Paris, FranceNTSB WPR22LA136Accident · No injuriesClass 3 · LimitedFinal reportDowner Bellanca 14-19-2 · Prosser, WAAn inadequately welded elevator attachment lug, which caused the elevator to partially detach from its bellcrank, resulting in flutter and structural damage.