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 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…NTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.NTSB DCA21WA087IncidentClass 5 · ForeignBoeing 757 · Leipzig, GermanyNTSB GAA21WA026Accident · No injuriesClass 5 · ForeignCessna 340A · Toulouse, FranceNTSB GAA21WA020Accident · No injuriesClass 5 · ForeignCessna 414 · Guerrero Negro, MexicoNTSB GAA21WA160Accident · No injuriesClass 5 · ForeignSocata TB10 · Salamanca, SpainNTSB ERA21LA100Accident · No injuriesClass 4 · LimitedFinal reportMurphy Rebel · O'Brien, FLA partially engaged right wheel brake, which restricted the airplane’s acceleration and the pilot’s ability to pitch to takeoff attitude, and resulted in an aborted takeoff and subsequent runway excursion.NTSB ERA21LA068Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35A · Attalla, ALA loss of control inflight and the failure of a component of the up elevator flight control system due to fatigue, which rendered recovery from a right descending turn improbable.NTSB ERA21LA062Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · South Boston, VAThe improper installation of a fuel filter screen cover gasket, which resulted in its failure, fuel starvation, and a subsequent total loss of engine power during cruise flight. Contributing to the accident was the unapproved fuel sight gauge, which obscured…NTSB CEN21LA070Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA38 · Franklin, ARThe impairment of both pilots from carbon monoxide exposure due to a degraded muffler. Contributing to the accident was the inadequate maintenance inspection, which failed to detect the degraded muffler.NTSB ERA21LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Ellenville, NYThe failure of the right brake master cylinder lock seal spring washer.NTSB CEN21WA038Incident · No injuriesClass 5 · ForeignCessna 208 · Pickle Lake, CanadaNTSB ERA21LA031Accident · No injuriesClass 4 · LimitedFinal reportSparrowhawk II · North Myrtle Beach, SCA ruptured fuel line, which resulted in fuel starvation to the engine and a total loss of engine power.NTSB CEN21LA023Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revolt · Durango, COThe pilot’s loss of directional control during landing following a hard landing and failure of the right main tire.NTSB ENG21WA005IncidentClass 5 · ForeignATR ATR72 · Makassar, IndonesiaNTSB CEN20WA418Incident · No injuriesClass 4 · ForeignSikorsky S92 · Sola, NorwayNTSB CEN20CA416Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172RG · Lafayette, INThe separation failure of a landing gear system hydraulic line and its compression fitting during cruise flight, which resulted in a partial gear up landing.NTSB ANC20LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · King Salmon, AKThe fatigue fracture failure of the left main landing gear U-bolt during landing, which resulted in the collapse and separation of the left main landing gear spring.NTSB WPR20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 208 · Whitmore, AZA loss of directional control during landing due to a flat main landing gear tire, which resulted in a lateral runway excursion and impact with terrain.NTSB WPR20LA288Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Chino, CAThe failure of the engine-driven hydraulic pump, which resulted in the main landing gear not fully extending and locking into place during landing. Contributing to the accident was the failure of the emergency gear extension system for reasons that could not…NTSB WPR20LA301Accident · 1 fatalClass 3 · LimitedFinal reportLake LA4 · Rawlins, WYThe pilot’s decision to depart despite a known mechanical trim malfunction and with a high-density altitude and the airplane at or above its maximum gross weight.NTSB DCA20WA141Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB CEN20LA353Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT602 · Inverness, MSThe pilot’s decision to move the power control lever into beta during flight, which resulted in the power control lever and associated linkage becoming stuck in the beta position.NTSB DCA20LA138Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing 767 · Los Angeles, CAThe left main landing gear’s failure to extend due to the separation of the brake rod retaining hardware from the aft inboard wheel for reasons that could not be determined based on the available evidence.NTSB CEN20LA330Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Logan, IAThe failure of the lower actuator bearing support brackets, which resulted in the misalignment of the clutch actuator, a loss of belt tension on the main rotor drive system, and a subsequent forced landing.