NTSB investigations, 2012
29 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\") = 2012
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") = 2012 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 WPR13LA093Accident · No injuriesLimited investigationFinal reportKaufmann Vans RV-10 · Las Vegas, NVA missing elevator control assembly attachment bolt, which rendered the elevator control system ineffective and resulted in a loss of pitch control, and the pilot’s incorrect installation of the elevator control assembly.NTSB WPR13LA063Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Billings, MTThe pilot’s inability to maintain directional control during the landing roll because of the failure of the tailwheel support bracket.NTSB 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…NTSB ERA13LA052Accident · No injuriesLimited investigationFinal reportWaller Charles R Rans S12-XL · Gordon, ALA fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.NTSB CEN13FA038Accident · No injuriesField investigationFinal reportPiaggio P180 · Boyne City, MIThe select/bypass valve's failure to seal correctly because of improper shimming, which resulted in an uncommanded and uncontrollable left turn during landing. Contributing to the accident was the overhaul facility's improper overhaul of the steering manifold.NTSB ENG13WA001Incident · No injuriesForeign investigationBeech 1900 · Lyon, FranceOn October 09, 2012, at 9:40 am local time, a Beechcraft 1900, F-GOPE, operated by Hex'Air, experienced a elevator trim system failure after take-off at Lyon-Saint Exupery airport(LFLL), France. A post flight inspection revealed that the elevator trim forward…NTSB WPR12FA421Accident · No injuriesField investigationFinal reportFrederick F 1 · Reno, NVThe pilot’s operation of the airplane above the established never-exceed speed and the incorrect installation of the trim tab control horn, which resulted in the flutter of the left elevator trim tab.NTSB WPR12LA407Accident · 1 fatalLimited investigationFinal reportMoore Edward R MXS · Borrego Springs, CAThe pilot’s inability to maintain control of the airplane following the loss of aileron and elevator control due to the forward flight control torque tube assembly’s detachment from the forward bearing. Contributing to the accident was the inadequate…NTSB WPR12TA364Accident · No injuriesFinal reportAmerican Eurocopter AS350B3 · Sunburst, MTThe improper installation of the engine-to-main gearbox flex coupling, which resulted in the failure of the flex coupling and a loss of power to the rotor system during takeoff.NTSB CEN12IA554Incident · No injuriesIncident investigationFinal reportCessna 560XL · Des Moines, IAA temporary loss of control during cruise flight for reasons that could not be determined because postincident examination of the autopilot, pitch trim systems, and horizontal stabilizer revealed no anomalies consistent with a loss of control.NTSB ERA12LA505Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Bay Minette, ALThe separation of the tailwheel linkage for reasons that could not be determined because the linkage was not located, which resulted in a loss of directional control during landing.NTSB CEN12LA525Accident · No injuriesLimited investigationFinal reportBell 214ST · Avalon, TXMaintenance personnel’s failure to properly torque the retaining nut and install the cotter pin that secured the helicopter’s tail rotor counterweight bellcrank. Contributing to the accident was the lack of detailed maintenance records that documented…NTSB WPR12LA341Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Cody, WYThe failure of a tail rotor driveshaft coupling due to fatigue.NTSB WPR12FA332Accident · No injuriesField investigationFinal reportPiaggio P180 · Henderson, NVThe failure of maintenance personnel to properly torque the elevator attachment hardware in accordance with the maintenance manual, which led to the detachment of the elevator. Contributing to the accident were maintenance personnel's failure to identify the…NTSB WPR12CA293Accident · No injuriesData collectionFinal reportPiper PA-12 · Stevensville, MTThe separation of the left rudder control cable from the rudder bellcrank, which resulted in a loss of directional control during landing roll.NTSB ERA12FA395Accident · 1 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Westminster, MDThe pilot's inadequate preflight inspection, which failed to ensure that the elevator quick-fastener was properly secured, resulting in an inflight elevator control disconnect and subsequent loss of control during the ensuing emergency landing. Contributing…NTSB ERA12LA379Accident · Minor injuriesLimited investigationFinal reportBell 427 · Indiantown, FLThe inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.NTSB ERA12LA368Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Piney Flats, TNThe mechanic’s improper maintenance of the main transmission aft pinion nut and belt drive system, which resulted in the uncoupling of the tail rotor driveshaft and the subsequent loss of helicopter control.NTSB WPR12IA248Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Seattle, WAFailure of maintenance personnel to ensure that the tail rotor pitch change link bolt was properly secured, which resulted in an in-flight separation of the bolt and subsequent vibration.NTSB ERA12LA307Accident · No injuriesLimited investigationFinal reportRice Leo B Kitfox Series 5 · Port Canaveral, FLImpingement of the elevator control by foreign objects (clamp, glove) left in the flight control path by the pilot/owner or maintenance personnel.NTSB WPR12FA155Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA-300 · Salinas, CAA loose portable XM-GPS antenna that migrated to the tail section of the airplane and jammed the elevator bell crank. Contributing to the accident was the pilot’s failure to account for the cockpit portable GPS antenna during preflight or postflight…NTSB WPR12WA167Incident · No injuriesForeign investigationSaab 2000 · Copenhagen, DenmarkOn March 20, 2012, about 0610 UTC, a Saab 2000, registered in Sweden as SE-LOM, experienced an elevator flight control malfunction during landing at Copenhagen Airport (EKCH), Denmark. None of the three flight crew or 47 passengers were injured. The airplane…NTSB ERA12IA237Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Warrenton, VAMaintenance personnel's failure to identify stress corrosion cracking in the stabilator control cable during the most recent inspection, and the subsequent failure of the cable on the flight after the inspection.NTSB ERA12CA215Accident · No injuriesData collectionFinal reportCessna 140A · Mooresville, NCThe separation of the left rudder cable turnbuckle and the pilot’s subsequent loss of directional control during landing.NTSB WPR12LA107Accident · Minor injuriesLimited investigationFinal reportBell AH-1F · Coolidge, AZA flight control malfunction while maneuvering for reasons that could not be determined because postaccident examination revealed no evidence of a mechanical malfunction or failure that would have precluded normal operation.NTSB DCA12CA042Accident · No injuriesData collectionFinal reportEmbraer EMB120 · Iliamna, AKthe maintenance personnel's failure to install the cotter pins that secured castellated nuts on the left elevator vertical hinge bolts, which resulted in the left elevator partially detaching in flight. Contributing to the accident was the failure of…NTSB ERA12LA150Accident · No injuriesLimited investigationFinal reportM-Squared Breese 2 · Bayou La Batre, ALThe pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.NTSB DCA12FA024Accident · 3 fatalField investigationFinal reportBell 214 · Camp Bastion, Afghanistanthe overtravel of the collective sleeve, which led to a severe and sudden reduction in main rotor blade collective pitch, resulting in a loss of control of the helicopter. The reason for the collective sleeve overtravel could not be determined since much of…NTSB CEN12LA120Accident · Serious injuriesLimited investigationFinal reportContinental Copters 47G2 · Lohn, TXThe improper installation of the tail rotor gearbox by maintenance personnel, which led to accelerated wear of the ring and pinion gears, resulting in the loss of tail rotor effectiveness and subsequent forced landing.