NTSB investigations, TN
9 cases where NTSB found Flight control system.
Cases per year
| 2011 | 2 |
|---|---|
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 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 c.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010227'))
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 c."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010227')) 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 ERA17CA137Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Cleveland, TNThe flight instructor's inadequate supervision, which resulted in a premature rotation for a no-flap takeoff and subsequent loss of airplane control during the initial climb.NTSB ERA16LA191Accident · Minor injuriesLimited investigationFinal reportSikes Zenith CH750 Stol · Lawrenceburg, TNThe pilot's failure to perform an adequate preflight inspection, which resulted in a loss of control due to an improperly-rigged rudder. Contributing to the accident was the pilot's failure to implement and follow proper flight-testing plans.NTSB ERA14CA458Accident · No injuriesData collectionFinal reportBeech C90 · Oneida, TNThe pilot's failure to properly configure the rudder trim for takeoff and his failure to maintain directional control during a precautionary landing, which resulted in a runway excursion and collision with terrain.NTSB ERA13CA310Accident · No injuriesData collectionFinal reportSchleicher Alexander ASH 26 E · Tullahoma, TNThe pilot's improper use of wing spoilers during approach resulting in an altitude loss and collision with a tree.NTSB ERA13FA017Accident · Serious injuriesField investigationFinal reportArion Lightning · Chuckey, TNThe pilot’s inadequate preflight planning, which resulted in an attempted takeoff at a high gross weight, near the limit of its aft center of gravity, and with the airplane incorrectly configured with fully extended flaps. Contributing to the accident was the…NTSB ERA12CA454Accident · Minor injuriesData collectionFinal reportLet L-23 Super Blanik · Benton, TNThe pilot's inadvertent extension of the wing airbrakes, which resulted in a loss of lift and subsequent landing prior to the runway.NTSB ERA12LA292Accident · Serious injuriesLimited investigationFinal reportMooney M20F · McKinnon, TNThe pilot's delayed decision to go-around after failing to recognize that he was attempting to land with a tailwind, and his failure to retract the landing gear and wing flaps for the go-around, which resulted in a collision with trees and terrain near the…NTSB ERA12CA013Accident · Minor injuriesData collectionFinal reportLoehle Loehle P-40 · Tullahoma, TNThe pilot's delayed decision to abort the takeoff.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.