NTSB investigations, 2011
5 cases where NTSB found Rudder control system.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 6 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 6 |
| 2013 | 7 |
| 2014 | 6 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 7 |
| 2018 | 6 |
| 2019 | 8 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 6 |
| 2023 | 5 |
| 2024 | 3 |
| 2026 | 1 |
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\", '01022720'))
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", '01022720')) 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 CEN11LA542Accident · No injuriesLimited investigationFinal reportT&T Falcon LS · Lee's Summit, MOA binding condition in the left rudder cable which resulted in a loss of directional control during landing.NTSB CEN11CA498Accident · Serious injuriesData collectionFinal reportPiper J3C-65 · Williams Lake, MIA loss of control during approach due to the front seat passenger's belt buckle being wedged between the rear seat,the rudder pedal and floor board.NTSB ERA11CA375Accident · No injuriesData collectionFinal reportTemco GC-1B · Sparta, TNThe improper installation of the right rudder control cable by maintenance personnel, which resulted in the pilot's inability to maintain directional control during takeoff.NTSB CEN11CA282Accident · No injuriesData collectionFinal reportDelf Tim Zenith CH-701 · Davenport, IAThe improper installation of the rudder cable to rudder pedal attachment hardware.NTSB ERA11IA184Incident · No injuriesIncident investigationFinal reportCessna 560XL · Haynesville, VAThe manufacturer's inadequate design fix for previously known tailcone stinger water ingestion and retention.