NTSB investigations, 2024
24 cases where the defining event was Flight control sys malf/fail.
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 10 |
| 2010 | 24 |
| 2011 | 20 |
| 2012 | 26 |
| 2013 | 19 |
| 2014 | 15 |
| 2015 | 20 |
| 2016 | 15 |
| 2017 | 24 |
| 2018 | 15 |
| 2019 | 13 |
| 2020 | 16 |
| 2021 | 25 |
| 2022 | 20 |
| 2023 | 13 |
| 2024 | 24 |
| 2025 | 26 |
| 2026 | 12 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2024
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '333')
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 year(c."eventDate") = 2024 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '333') 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 ERA25FA082Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Cintrona, PRMaintenance personnel’s inadequate inspection of the airplane, which resulted in inflight the failure of the right aileron carry through cable due to wear, reduced effectiveness of the airplane’s ailerons, and a subsequent loss of control.NTSB ERA25LA079Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT504 · Big Cypress, FLThe pilot’s decision to depart with cargo outside of the designated baggage compartment, which resulted in the cargo interfering with the rudder control system.NTSB GAA25WA040AccidentClass 5 · ForeignCessna 172 · Örebro, SwedenNTSB ENG25LA009Incident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2C11 · Dulles, VAThe elevator control restriction was caused by the failure of the elevator autopilot servo control cable, which failed due to cyclic fatigue. The slack in the broken cable wrapped around the elevator autopilot servo mount in such a way that it was bound…NTSB CEN25LA043Accident · No injuriesClass 3 · LimitedFinal reportPitts S1E · Seguin, TXThe improper construction of the rudder cable assembly by the airplane builder, which resulted in the fatigue failure of the left rudder cable during the landing roll and the pilot’s subsequent inability to maintain directional control.NTSB ANC25LA008Accident · Serious injuriesClass 3 · LimitedFinal reportCub Crafters CC18-180 · Anchorage, AKThe incorrect installation of the rear flight control stick, resulting in the pilot’s inability to control the pitch attitude, coupled with the pilot’s inadequate control system check before departure, all which resulted in an aerodynamic stall during takeoff.NTSB CEN25FA033Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 58 · Arlberg, AROn October 29, 2024, about 1426 central daylight time, a Beech 58 airplane, N811PB, was destroyed when it was involved in an accident near Arlberg, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN25LA029Accident · Minor injuriesClass 3 · LimitedFinal reportCub Crafters Carbon CUB · Ogallala, NEThe improper installation of the elevator control cable hardware, which resulted in the separation of the elevator control cable and a loss of pitch control in flight.NTSB DCA25WA246Incident · No injuriesForeign investigationEmbraer ERJ190 · Brisbane, AustraliaNTSB 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 DCA24LA206Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737-8 · Oakland, CADamage to the standby rudder power control unit connection to the vertical fin due to an extreme high wind event while the airplane was parked, which remained undetected and resulted in anomalous operation of the standby rudder power control unit.…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, Canada