NTSB investigations, 2021
57 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases per year
| 1979 | 1 |
|---|---|
| 2008 | 100 |
| 2009 | 77 |
| 2010 | 54 |
| 2011 | 64 |
| 2012 | 58 |
| 2013 | 49 |
| 2014 | 28 |
| 2015 | 43 |
| 2016 | 40 |
| 2017 | 42 |
| 2018 | 35 |
| 2019 | 34 |
| 2020 | 39 |
| 2021 | 57 |
| 2022 | 61 |
| 2023 | 66 |
| 2024 | 62 |
| 2025 | 53 |
| 2026 | 33 |
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\") = 2021
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '330' 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" = '330' 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 WPR22FA048Accident · 1 fatalClass 3 · FieldFinal reportZenith Zodiac CH601XL · Temecula, CAThe failure of the airplane’s canopy latch system, which resulted in the canopy opening in flight and a loss of airplane control. Contributing to the accident was the lack of a secondary canopy latch as recommended by the kit manufacturer.NTSB WPR22LA040Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Boulder City, NVThe installation of an improper right main landing gear door rod-end bolt, which resulted in the right main landing gear not extending during landing.NTSB ENG22LA004Occurrence · No injuriesClass 3 · LimitedFinal reportBeech F33 · Bellefontaine, OHThe internal failure of the autopilot pitch servo actuator that caused the autopilot to command a nose down movement of the pitch trim.NTSB ERA22LA054Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Sarasota, FLA partial loss of engine power due to a failed throttle cable.NTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.NTSB GAA22WA034Accident · No injuriesClass 5 · ForeignPiper PA34 · Luqa, MaltaNTSB GAA22WA026IncidentClass 5 · ForeignSikorsky S92 · North Sea, United KingdomNTSB WPR22LA015Accident · Serious injuriesClass 3 · LimitedFinal reportWsk-Mielec AN-2TD · Wilton, CAThe pilot’s inability to control the airplane’s pitch during departure for reasons that could not be determined because of the extensive fragmentation and thermal damage the airplane sustained in the accident sequence.NTSB ERA22LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Columbia, SCA failure of the landing gear hydraulic power pack for reasons that could not be determined.NTSB CEN22LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195 · Watkins, COThe separation of the left main landing gear spring during landing roll due to a preexisting fatigue crack.NTSB WPR22LA003Accident · No injuriesClass 4 · LimitedFinal reportInterstate S-1A · Independence, ORThe separation of the left rudder pedal interconnect cable during takeoff, which resulted in the student pilot’s inability to maintain directional control.NTSB ERA21LA386Accident · Minor injuriesClass 3 · LimitedFinal reportHiller UH-12E · Millen, GAThe improper reassembly of the tail rotor gearbox following maintenance, which resulted in fatigue failure of the input pinion gear shaft, and the subsequent loss of tail rotor drive.NTSB ERA21LA385Accident · No injuriesClass 4 · LimitedFinal reportDoan Vernon D W10-WITTMAN Tailwind · Brooksville, FLThe failure of the nose landing gear retention bolt during taxi which resulted in a loss of control and subsequent impact with the taxiway.NTSB CEN21LA460Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · El Paso, TXA faulty landing gear pressure switch prematurely deactivated the landing gear motor during extension, which resulted in the landing gear collapsing during rollout.NTSB ENG21WA045Incident · No injuriesClass 5 · ForeignSikorsky S92 · North Sea, NorwayNTSB ERA21LA358Accident · Minor injuriesClass 4 · LimitedFinal reportAlon A2 · Abingdon, VAThe failure of a nosewheel steering actuator arm, which resulted in a loss of control during the landing rollout.NTSB CEN21LA395Accident · 1 fatalClass 3 · LimitedFinal reportKlapp Peter A Klapp KR-2S · Wadsworth, OHA loss of airplane control for a reason that could not be determined based on available information.NTSB WPR21LA337Accident · No injuriesClass 3 · LimitedFinal reportCessna 172E · Enterprise, ORThe fatigue fracture of the nose gear upper torque link, which resulted in the separation of the torque link from the shock strut and a loss of directional control.NTSB CEN21LA389Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Arnaudville, LAThe loss of tail rotor drive due to a fatigue failure of the tail rotor gearbox output shaft, which resulted in a loss of control during landing.NTSB ERA21LA339Accident · No injuriesClass 3 · LimitedFinal reportEnstrom 280 · Port Orange, FLThe failure of the tail rotor drive shaft at the coupling due to torsionally applied shear stress.NTSB ERA21LA336Accident · No injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G-IV · Fort Lauderdale, FLThe pilot-in-command’s (PIC) and second-in-command’s (SIC) failure during preflight inspection to ensure that the nose landing gear’s pip pin was properly installed, which resulted in separation of the pip pin during takeoff. Contributing to the accident was…NTSB GAA21WA217Accident · No injuriesClass 5 · ForeignEurocopter BO105 · Archerfield, AustraliaNTSB WPR21LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Albuquerque, NMThe failure of the nose gear hydraulic flex line, which resulted in a loss of hydraulic fluid which prevented the main landing gear from fully extending and locking into place during landing.NTSB ERA21LA367Accident · Minor injuriesClass 4 · LimitedFinal reportCollins Robert S Just Acft Highlander · Brasstown, NCFailure of the left main landing gear wheel lock nuts, which resulted in a wheel separation and nose over during landing.NTSB CEN21LA363Accident · No injuriesClass 3 · LimitedFinal reportRotary RAF2000 · Anahuac, TXThe pilot’s incorrect trim system installation, which resulted in a loss of gyroplane control and impact with terrain.NTSB DCA21WA214IncidentClass 5 · ForeignAirbus A319 · Edinburgh, United KingdomNTSB CEN21LA352Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6F · Adrian, MIThe loss of control during landing due to the out of rig condition of the tailwheel which resulted in a ground loop and impact with the runway.NTSB GAA21WA238Incident · No injuriesClass 5 · ForeignPiper PA31 · Doncaster, United KingdomNTSB CEN21LA326Accident · Serious injuriesClass 3 · LimitedFinal reportGary James Lail Zenith CH 750 Cruzer · Blossom, TXThe improper swaging of the rudder control cable, which disconnected during flight and resulted in the loss of control.NTSB CEN21LA323Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Refugio, TXThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB ERA21LA289Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Easton, MDA total loss of left engine power and uncommanded feathering of the left propeller for reasons that could not be determined.NTSB CEN21LA319Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Carroll, IAThe wear-related failure of the airframe fuel boost pump, which resulted in fuel starvation and a loss of engine power.NTSB CEN21LA276Accident · No injuriesClass 3 · LimitedFinal reportAutogyro Cavalon · Collinsville, TXThe total loss of engine power due to the failure of both fuel pumps, which resulted in fuel starvation. The reason for the failure of both fuel pumps could not be determined based on available evidence.NTSB CEN21LA267Accident · Minor injuriesClass 4 · LimitedFinal reportGreat Lakes 2T-1A-1 · Roanoke, TXInadequate maintenance of the brake system which resulted in the caliper binding closed and the subsequent loss of directional control during the landing roll.NTSB DCA21WA154IncidentClass 5 · ForeignBoeing 777 · London, United KingdomNTSB GAA21WA131Accident · No injuriesClass 5 · ForeignCessna 340 · Essex, United KingdomNTSB ERA21FA233Accident · 4 fatalClass 3 · FieldFinal reportBhi H60 Helicopters UH-60A · Leesburg, FLThe failure of the water tank snorkel support structure, which allowed the snorkel to contact the main rotor blades. Contributing to the accident was insufficient Federal Aviation Administration oversight of the supplemental type certificate process for the…NTSB WPR21FA203Accident · 1 fatalClass 3 · FieldFinal reportDassault Mirage F-1 · Las Vegas, NVThe pilot’s exceedance of the airplane’s critical angle of attack on approach and failure to fly a traffic pattern track consistent with a no-flap configuration. Contributing to the accident was the failure of the airplane’s flaps to extend while in the…NTSB CEN21LA244Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 MK.I · Oak Island, MNThe failure of an O-ring in the landing gear system, which resulted in the inadvertent extension of the main wheel in the amphibious float. Contributing to the accident was the pilot’s decision to depart with a known hydraulic leak in the landing gear system.NTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.NTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…NTSB ERA21LA208Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aerospace Industries Gulfstream G150 · Ridgeland, SCThe flight crew’s continuation of an unstable approach and the failure of the ground air brakes to deploy upon touchdown, both of which resulted in the runway overrun. Contributing was the crew’s motivation and response to external pressures to complete the…NTSB ENG21WA030IncidentClass 5 · ForeignDe Havilland DHC6 · Wallis & Futuna, Wallis & FutunaNTSB ERA21LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Fredericksburg, VAThe student pilot reported that, during the landing roll, he applied brakes and the airplane veered right. He was unable to correct back to the centerline or brake effectively; the airplane exited the runway and struck an embankment before coming to rest. The…NTSB ERA21LA183Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Weyers Cave, VAMaintenance personnel’s inadequate inspection of the rudder control system, which resulted in failure of the rudder control assembly and the pilot’s loss of control during a go-around.NTSB ERA21LA177Accident · No injuriesClass 3 · LimitedFinal reportForisch Edward Bushby Mustang M II · Worcester, MABinding of the left aileron bellcrank push/pull rod, which resulted in an uncommanded right turn.NTSB WPR21LA362Accident · No injuriesClass 3 · LimitedFinal reportMaule MX-7-235 · Ontario, ORA loss of hydraulic fluid and failure of the right brake for reasons that could not be determined due to a lack of available evidence.NTSB DCA21WA107IncidentClass 5 · ForeignBoeing 757-24APF · San Salvador, El SalvadorNTSB CEN21LA164Accident · No injuriesClass 4 · LimitedFinal reportCameron Balloons Z-90 · Celina, TXThe malfunction of the balloon’s envelope venting system during landing in high wind, which resulted in the balloon being dragged along the ground, substantially damaging the envelope.NTSB ANC21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKInstallation of improper hardware on the ski check cable. Contributing to the accident was the inadequate inspection of the ski yokes, which resulted in the subsequent failure of the right main landing gear ski yoke and collapse of the right main landing gear…