NTSB investigations, 2012

5 cases where NTSB found Aileron control system.

Cases per year

20082026
NTSB investigations, 2012 per year, 2008–2026: 45 cases
20085
20092
20104
20113
20125
20131
20152
20162
20175
20181
20193
20205
20222
20231
20244

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\") = 2012
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01022710'))
  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.

NTSB CEN13CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Okaton, SDThe pilot's failure to perform an adequate preflight inspection of the airplane and obstruction of the aileron control system by snow and ice, which led to a loss of control during flight.Dec 11, 2012 · N3471Z · Substantial damageNTSB ERA13LA069Accident · Serious injuriesLimited investigationFinal reportLawson J/Bowie R/Smith M CA-8 · Merritt Island, FLThe pilot's improper decision to continue a cross-country flight as a primary control (aileron) system anomaly progressively worsened. Contributing to the accident was an aileron control system anomaly, the reason for which could not be determined because the…Nov 28, 2012 · N155JD · Substantial damageNTSB WPR13CA018Accident · No injuriesData collectionFinal reportAlbright Stan Kitfox Super Sport · Twin Bridges, MTThe airplane builder’s failure to rig the flight controls correctly, which resulted in a loss of control after takeoff.Oct 18, 2012 · N960WM · Substantial damageNTSB WPR12LA428Accident · Minor injuriesLimited investigationFinal reportRockwell International 690A · Ellensburg, WAThe pilot’s failure to avoid a turbulent smoke column, which resulted in an overstress failure of the left aileron control rod.Sep 16, 2012 · N57112 · Substantial damageNTSB ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…Jul 25, 2012 · N73115 · Substantial damage