NTSB investigations, 2011
4 cases where NTSB found Elevator control system.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 7 |
| 2016 | 4 |
| 2017 | 4 |
| 2019 | 1 |
| 2020 | 5 |
| 2021 | 5 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 5 |
| 2025 | 4 |
| 2026 | 2 |
Where
Latest 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\") = 2011
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01022730'))
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") = 2011 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01022730')) 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 CEN11LA605Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Freeport, ILThe pilot's decision to operate the airplane with a known defect in the elevator control system that led to his inability to control the airplane during the initial climb.NTSB CEN11LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oklahoma City, OKThe loss of aircraft control due to the failure of the stabilator control cable turnbuckle.NTSB WPR11CA197Accident · No injuriesData collectionFinal reportXtremeair Sbach 342 · Springerville, AZThe pilot's failure to properly secure loose objects in the cockpit area which resulted in a personal locator beacon becoming lodged in the elevator control torque tubes, restricting flight control movement.NTSB WPR11CA112Accident · Minor injuriesData collectionFinal reportHarvey Patten Rans S-6ES · Buckeye, AZA disconnection of the elevator control linkage due to incorrect installation or maintenance, which was due to the retaining nut backing off the bolt and allowing the bolt to fall out.