NTSB investigations, 2009
15 cases where the sequence of events included Flight control sys malf/fail.
Cases per year
| 2008 | 23 |
|---|---|
| 2009 | 15 |
| 2010 | 30 |
| 2011 | 26 |
| 2012 | 29 |
| 2013 | 23 |
| 2014 | 16 |
| 2015 | 24 |
| 2016 | 20 |
| 2017 | 25 |
| 2018 | 16 |
| 2019 | 16 |
| 2020 | 17 |
| 2021 | 26 |
| 2022 | 24 |
| 2023 | 14 |
| 2024 | 25 |
| 2025 | 27 |
| 2026 | 14 |
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\") = 2009
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") = 2009 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 CEN10IA084Incident · No injuriesIncident investigationFinal reportATR ATR72 · Dallas, TXA fatigue failure of an elevator stop bracket, which resulted in a partial jam of the elevator control. Contributing to the failure was the improper installation of shim stacks, poor alignment of the brackets, and cyclic stresses acting on the lower stop,…NTSB CEN10CA022Accident · Serious injuriesData collectionFinal reportGottelt Herbert R Kitfox IV/ · Crystal Falls, MIThe pilot's inability to maintain control due to an undetermined problem affecting lateral control of the airplane.NTSB WPR10FA009Accident · 1 fatalField investigationFinal reportPiper PA-12 · Burlington, WAThe pilot's in-flight loss of control due to his failure to correctly connect the elevator control cables during the restoration/rebuild of the airplane. Contributing to this accident was the pilot's decision to perform a high-speed taxi test prior to having…NTSB ANC09CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKA tailwheel malfunction that limited directional control, which resulted in a runway excursion, and collision with a building.NTSB CEN09LA571Accident · Minor injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105S · Thibodaux, LAThe pilot's inability to maintain control due to the mechanic's inadvertent switching of two cyclic control tubes of different lengths during maintenance.NTSB CEN09IA578Incident · No injuriesIncident investigationFinal reportCessna 421 · Sugar Land, TXThe improper installation of the pitch trim cable which resulted in it making improper contact with a guard pin that led to the fatigue failure of the cable.NTSB ERA09CA495Accident · No injuriesData collectionFinal reportUnderland/Grothe/Finstrom Mmii (Must · Lantana, FLThe delay by both pilots to abort the takeoff resulting in a runway overrun. Contributing to the accident was the unintentional forward movement of the pilot's seat resulting in interference with the control stick.NTSB CEN09LA526Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Worthington, MNA fatigue failure of the elevator push-pull rod which resulted in the pilot's inability to control the aircraft's pitch attitude while landing.NTSB CEN09CA522Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Evansville, WIA jam of the elevator flight control for undetermined reasons.NTSB CEN09LA486Accident · No injuriesLimited investigationFinal reportGallagher Junior ACE · Oshkosh, WIThe failure of a weld joint on the right rudder pedal leading to the loss of directional control during landing.NTSB ENG09IA011Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Diyarbakir, TürkiyeAn uncommanded elevator surface deflection as a result of a left elevator PCU input arm assembly jam due to FOD lodged between the input arm assembly and the PCU housing. The FOD was a roller element from an elevator upper torque tube output crank bearing,…NTSB ERA09IA315Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Greenville, SCA pitch control malfunction for undetermined reasons.NTSB WPR09LA202Accident · 1 fatalLimited investigationFinal reportAlexander Thomas P Sportsman GS-2 · El Dorado HIlls, CAThe in-flight separation of the elevator control torque tube rod end bearing from the elevator torque tube as a result of incorrectly tightened rod end bearing lock nuts.NTSB CEN09LA198Accident · No injuriesLimited investigationFinal reportBell 206 · Galliano, LAThe failure of the tail rotor driveshaft and coupling during engine start due to the mechanic's failure to properly reattach the tail rotor driveshaft and coupling during maintenance.NTSB ERA09FA141Accident · 1 fatalField investigationFinal reportRemos Remos GX · Sebring, FLThe pilot's inadequate preflight assembly and inspection which resulted in the pushrod connection to the left aileron not being connected, which led to a subsequent inflight loss of control and impact with terrain.