NTSB investigations
996 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases, newest first
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.\"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 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 DCA22WA137Incident · No injuriesClass 5 · Foreign737 800 · Cairo, EgyptNTSB WPR22LA236Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Merced, CAThe in-flight failure of the engine-to-transmission drive shaft due to a fatigue fracture of one of the KAflex flex frames caused by a loose bolt, which resulted in a total loss of power to the transmission and a subsequent hard landing.NTSB WPR22LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna TR182 · Santa Barbara, CAA failure of the right main landing gear actuator pressure line O-ring, which resulted in a gear-up landing on the runway.NTSB ERA22LA272Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Monongahela, PALoss of braking authority due to a loosened brake line fitting for reasons that could not be determined, which resulted in a runway overrun.NTSB ERA22LA275Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Gulf Shores, ALThe improper maintenance of the brake system, which resulted in the brakes overheating and catching fire and subsequent substantial damage to the airplane.NTSB ERA22LA319Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Charleston, SCThe failure of the torsion spring inside the drive clutch assembly of the landing gear actuator which prevented normal and manual extension of the landing gear.NTSB CEN22LA225Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Roanoke, TXInadequate maintenance of the airplane’s brake system that resulted in a hole in the brake line, the loss of brake fluid, and the subsequent loss of brake functionality.NTSB ERA22LA256Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · North Myrtle Beach, SCThe fractured attachment lug on the forward clutch shaft yoke due to fatigue failure with multiple origins.NTSB GAA22WA192Accident · No injuriesClass 5 · ForeignDiamond Aircraft Ind DA 42 · Ontario, CanadaNTSB DCA22WA146IncidentClass 5 · ForeignAirbus A320 · Paris, FranceNTSB WPR22LA183AccidentClass 4 · LimitedFinal reportPyka Pelican · Winters, CADelamination of the uncrewed aircraft systems’ right wing skin surfaces from the wing spar that resulted in a spin and impact with terrain.NTSB CEN22LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Traverse City, MIThe failure of maintenance personnel to properly torque a fuel line “B” nut, which resulted in a total loss of engine power.NTSB CEN22LA186Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Loogootee, INThe inadequate maintenance and subsequent failure of an internal component in the fuel servo that prevented adequate fuel flow to the engine, which resulted in a partial loss of engine power.NTSB DCA22WA115Incident · No injuriesClass 5 · ForeignBoeing MD82 · Tehran, IranNTSB WPR22LA149Accident · No injuriesClass 3 · LimitedFinal reportDietrich Ryan S-4 Coyote 1 · Chula Vista, CAThe pilot/owner and maintenance personnel’s improper installation of the right wing’s aft lift strut to the right wing, which resulted in a loss of lift during takeoff, an uncommanded right roll, and an impact with terrain.NTSB DCA22WA159IncidentClass 5 · ForeignBoeing 737-800 · Tawau, MalaysiaNTSB WPR22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Lanark, NMThe pilot’s loss of control of the airplane after the inadvertent unlocking and opening of the canopy for reasons that could not be determined based on available evidence.NTSB WPR22LA128Accident · No injuriesClass 4 · LimitedFinal reportNewell Michael J Lancair ES · Hurricane, UTLoss of brake pressure on the left brake due to air in the brake line which, resulted in a runway over run and collision with a ditch.NTSB ERA22LA148Accident · No injuriesClass 3 · LimitedFinal reportCessna 525 · Middle River, MDAnd undetermined failure of the brake system. Contributing to the accident was the failure of the pilots to locate and operate the emergency brake control, which resulted in a runway excursion and collision with terrain and an object.NTSB CEN22LA138Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · Gulfport, MSThe failure of the right main landing gear actuator, which led to a gear-up landing.NTSB ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.NTSB ERA22LA132Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · New Bern, NCThe loss of brake pressure on the left brake due to a failed O-ring seal.NTSB WPR22LA084Accident · No injuriesClass 3 · LimitedFinal reportBell UH-1E · Gustine, CAFailure of the 90° gearbox due to the lack of lubricating oil, which resulted in a loss of rotational drive to the tail rotor and a subsequent loss of control of the helicopter.NTSB GAA22WA205AccidentClass 5 · ForeignCessna 560 · South Ruislip, United KingdomNTSB CEN22LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Grand Forks, NDFailure of the landing gear to properly extend before landing for reasons that could not be determined.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.