Final NTSB investigations, 2020
11 cases where the sequence of events included Flight control sys malf/fail.
Cases per year
| 2008 | 22 |
|---|---|
| 2009 | 15 |
| 2010 | 28 |
| 2011 | 24 |
| 2012 | 27 |
| 2013 | 21 |
| 2014 | 15 |
| 2015 | 22 |
| 2016 | 14 |
| 2017 | 22 |
| 2018 | 12 |
| 2019 | 14 |
| 2020 | 11 |
| 2021 | 14 |
| 2022 | 18 |
| 2023 | 9 |
| 2024 | 15 |
| 2025 | 10 |
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\") = 2020
AND c.\"completionStatus\" = 'Completed'
AND 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 year(c."eventDate") = 2020 AND c."completionStatus" = 'Completed' AND 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 WPR21LA039Accident · Serious injuriesClass 3 · LimitedFinal reportAgusta A109 · Los Angeles, CAThe loss of tail rotor control due to the separation of the tail rotor duplex bearing ring nut from the thrust sleeve, which resulted in the loss of helicopter control.NTSB WPR20LA301Accident · 1 fatalClass 3 · LimitedFinal reportLake LA4 · Rawlins, WYThe pilot’s decision to depart despite a known mechanical trim malfunction and with a high-density altitude and the airplane at or above its maximum gross weight.NTSB ERA20CA246Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA22 · Cortland, NYThe mechanic’s incorrect rigging of the aileron control cables, which resulted in a reversal of aileron control inputs applied by the pilot during the takeoff. Also causal was the mechanic’s inadequate post-maintenance inspection and the pilot's inadequate…NTSB CEN20LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSopwith Type 9400 · Van Alstyne, TXAn inflight loss of aileron control due to movement of a control connector.NTSB ERA20CA232Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Perry, GAThe reported malfunction of the aileron flight control system during takeoff for reasons that could not be determined.NTSB CEN20LA173Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado S · Haskell, OKThe student pilot/builder’s addition of winglets to the stabilator, which resulted in flutter and overstress failure of the stabilator control horn.NTSB ENG20LA031Incident · No injuriesClass 3 · LimitedFinal reportAirbus Helicopters AS350 · Clewiston, FLSeizure of the hydraulic pump pulley bearing due to its improper installation by the manufacturer, leading to a failure of the hydraulic pump belt and the resultant partial loss of hydraulic assistance to the pedals.NTSB ERA20CA168Accident · No injuriesClass 4 · Data collectionFinal reportDayton-Wright DH-4 · Bowling Green, KYA primary control (aileron) system anomaly that progressively worsened during a test flight that resulted in a loss of control. The reason for the anomaly was not determined due to impact damage.NTSB WPR20LA135Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-23-250 · Hemet, CAMaintenance personnel’s failure to properly inspect and replace damaged aileron control cables, which resulted in fatigue separation of the aileron control cable and loss of control of the aircraft.NTSB DCA20LA100Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S61 · Camp Dwyer, AfghanistanFatigue cracking of the auxiliary servo cylinder’s pedal damper check valve housing and its bolts, which caused the sudden and uncommanded movement of the helicopter’s left pedal and a subsequent left yaw that continued until ground impact. Contributing to…NTSB ANC20FA024Accident · 2 fatalClass 3 · FieldFinal reportCessna 305 · Mokuleia, HIA separation of the left rudder cable due to inadequate maintenance, which resulted in an in-flight loss of control and impact with terrain.