Skip to content

NTSB investigations, 2021

26 cases where the sequence of events included Flight control sys malf/fail.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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") = 2021 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

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\") = 2021
    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") = 2021
  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 DCA22WA079IncidentClass 5 · ForeignBeech 1900 · Lorraine, FranceDec 10, 2021 · F-GLNH · No damage NTSB GAA22WA048Incident · No injuriesClass 5 · ForeignBAE ATP · Belfast, United KingdomNov 27, 2021 · SE-MAP · No damage NTSB WPR22LA045Accident · No injuriesClass 4 · LimitedFinal reportElvin Jack R JR Rotorway Exec 162F · Scio, ORThe pilot’s improper maintenance on the tail rotor assembly, which resulted in the loss of control and roll over.Nov 22, 2021 · N102LD · Substantial damage NTSB CEN22LA038Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · West Union, OHA malfunction of the flight controls for reasons that could not be determined based on available information.Nov 15, 2021 · N3463Z · Substantial damage NTSB GAA22WA017Incident · No injuriesClass 5 · ForeignCessna 525 · Bristol, United KingdomOct 20, 2021 · N498YY · No damage NTSB DCA22MA009Accident · Serious injuriesClass 2 · MajorFinal reportMcdonnell Douglas DC-9-87 (MD-87) · Brookshire, TXThe jammed condition of both elevators, which resulted from exposure to localized, dynamic high wind while the airplane was parked and prevented the airplane from rotating during the takeoff roll. Also causal was the failure of Everts Air Cargo, the pilots’…Oct 19, 2021 · N987AK · Destroyed NTSB ERA22FA015Accident · 1 fatalClass 3 · FieldFinal reportVelocity SE RG · Titusville, FLThe separation of the airplane’s elevator control push-pull tube, which resulted in a loss of control during the approach.Oct 14, 2021 · N755V · Destroyed NTSB ANC21LA093Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Chandalar Shelf, AKA separation of the rudder cable from the rudder pedal due to the connecting bolt detaching for undetermined reasons, which resulted in a loss of directional control.Sep 17, 2021 · N8061D · Substantial damage NTSB ERA21LA360Accident · No injuriesClass 3 · LimitedFinal reportZenith 750 Cruzer · New Smyrna, FLThe mechanic’s inadequate inspection of the flight control system, which resulted in a loss of airplane control.Sep 14, 2021 · N161AR · Substantial damage NTSB DCA21WA219IncidentClass 5 · ForeignEmbraer ERJ190 · Maiquetia, VenezuelaAug 25, 2021 · YV2912 · No damage NTSB DCA21WA221IncidentClass 5 · ForeignAirbus A300 · Marquetia, VenezuelaAug 21, 2021 · YV562T · No damage NTSB ANC21LA075Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-18 · Talkeetna, AKThe malfunction of the control stick during initial climb for reasons that could not be determined based on available evidence.Aug 10, 2021 · N1264A · Substantial damage NTSB DCA21WA205IncidentClass 5 · ForeignBoeing 737 · Perth, AustraliaJul 31, 2021 · UNK · No damage NTSB GAA21WA191Accident · No injuriesClass 5 · ForeignBell 206 · Policka, CzechiaJul 30, 2021 · OK-BWR NTSB CEN21LA346Accident · Serious injuriesClass 3 · LimitedFinal reportHpH, Spol. S.R.O. Glasflügel 304S · Briggs, TXThe overstress fracture of the elevator control tube due to reduced wall thickness from water intrusion and subsequent corrosion. Contributing to the accident was the lack of a drain hole at the bottom of the elevator control tube, which allowed the tube to…Jul 30, 2021 · N304AB · Substantial damage NTSB ANC21LA064Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-14 · Anchorage, AKThe fatigue fracture of the American Iron and Steel Institute (AISI) 1025 carbon steel rudder post, which resulted in structural failure of the rudder. Contributing to the fatigue failure was the post’s susceptibility to fatigue cracking under normal service…Jul 23, 2021 · N4206H · Substantial damage NTSB ENG21WA046Incident · No injuriesClass 5 · ForeignBoeing 737 · Enroute, GermanyJul 7, 2021 · EI-STM · No damage NTSB WPR21LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Twisp, WAAn in-flight separation of the control stick from the torque tube assembly, which resulted in a loss of directional control during the landing roll and subsequent on-ground collision.Jun 20, 2021 · N6917Z · Substantial damage NTSB CEN21FA272Accident · 2 fatalClass 3 · FieldFinal reportAntenor Velazco Lancair Evolution · Parker, COThe pilot’s diversion of attention following an asymmetric flap deployment, which resulted in a descent and collision with powerlines. Contributing to the accident was maintenance personnel’s failure to properly secure the flap control rod attachment bolts,…Jun 16, 2021 · N704AK · Destroyed NTSB GAA21WA074Accident · No injuriesClass 5 · ForeignPiper J3 · Epse, NetherlandsApr 15, 2021 · NC50601 · Destroyed NTSB ENG21WA024Incident · No injuriesClass 5 · ForeignBAE ATP · Ronaldsway, Isle of ManApr 9, 2021 · SE-LPS · No damage NTSB DCA21WA111Incident · No injuriesClass 5 · ForeignAirbus A320 · Lima, PeruMar 27, 2021 · CC-AZE · Minor damage NTSB DCA21LA094AccidentClass 4 · LimitedFinal reportBell APT70 · Fort Benning, GAfailure of an electronic speed controller that resulted in a descent and impact with trees.Mar 1, 2021 · N314AQ · Substantial damage NTSB ERA21LA131Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Lake Placid, FLThe pilot’s failure to ensure that the aft seat cushion was adequately secured, which resulted in its movement, subsequent interference with the flight controls, and a hard landing.Feb 10, 2021 · N8183C · Substantial damage NTSB ERA21LA106Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA5 · Leesburg, VAThe weakened structure of the left horizontal stabilizer, which resulted in elevator flutter and subsequent partial separation of the left elevator in flight. Contributing to the accident were the lack of elevator authority while landing due to the damaged…Jan 19, 2021 · N5880L · Substantial damage NTSB DCA21WA081Incident · No injuriesClass 5 · ForeignBoeing 737 · Mexico City, MexicoJan 6, 2021 · HP-1526CMP · No damage