NTSB investigations
995 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 ERA23LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 182S · Labelle, FLA malfunction of the airplane’s right main wheel brake, which resulted in a loss of control and runway excursion during landing.NTSB GAA23WA281Accident · No injuriesClass 4 · ForeignCessna T337 · Montevideo, UruguayNTSB CEN23LA110Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado II · Windom, MNThe fatigue failure of the right landing gear leg that resulted in its separation from the airplane during takeoff.NTSB DCA23WA389IncidentClass 5 · ForeignAirbus A330 · Chennai, IndiaNTSB GAA23WA069Incident · No injuriesClass 5 · ForeignPiper PA-23-250 · Nassau, BahamasNTSB DCA23WA159Incident · No injuriesClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaNTSB CEN23LA103Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 425 · Bismarck, NDA loss of braking due to inadequate servicing of brake fluid by the pilot/mechanic, which resulted in a loss of airplane control on the ground.NTSB ENG23WA021Incident · No injuriesClass 4 · ForeignSikorsky S-92 · Derry, United KingdomNTSB ENG23WA016IncidentClass 5 · ForeignCessna 560 · Toronto, CanadaNTSB DCA23WA146IncidentClass 5 · ForeignBombardier CL600 2D24 · Sault Ste. Marie, CanadaNTSB CEN23LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPitts Model 12 · Conroe, TXThe failure of the engine-driven fuel pump, which resulted in a total loss of engine power. Contributing to the failure of the fuel pump was an unknown non-ferrous metallic debris that was noted throughout the airplane’s fuel system.NTSB GAA23WA057Incident · No injuriesClass 5 · ForeignRobinson R44 · Hamilton Island, AustraliaNTSB ERA23LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · Atlantic Ocean, Turks & Caicos IslandsA fuel system malfunction for reasons that could not be determined, which resulted in fuel starvation to both engines.NTSB WPR23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 210N · Morgan, UTFailure of the brake system O-rings on the left landing gear trunnion, which allowed the hydraulic fluid to drain from the left brake system, resulting in a runway excursion and impact with a fence.NTSB ERA23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Lexington, KYA main landing gear collapse due to a landing gear actuator overtravel for reasons that could not be determined.NTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…NTSB ERA23LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Alabaster, ALFailure of the tailwheel locking mechanism, which resulted in a loss of control during landing and a runway excursion.NTSB ERA23LA075Accident · No injuriesClass 3 · LimitedFinal reportGates Lear Jet 36 · Newport News, VAA left main landing gear tire rupture during takeoff, which resulted in a runway overrun.NTSB ERA23FA070Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Charlotte, NCThe inadequate inspections of the forward left control rod end attachment hardware to the stationary swashplate by the pilot and by maintenance personnel, resulting in an eventual loosening and backing out of the hardware and subsequent loss of helicopter…NTSB DCA23WA064Occurrence · No injuriesClass 5 · ForeignBoeing 747-44AF · Almaty, KazakhstanNTSB DCA23WA051IncidentClass 5 · ForeignBoeing 737 · Amman, JordanNTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…NTSB ERA23LA063Accident · No injuriesClass 3 · LimitedFinal reportHagerty Glasair Super IIS-TD · Jasper, GAThe loss of engine power due to the failure of the engine-driven fuel pump and the pilot’s failure to use the electric fuel pump, which resulted in a forced, hard landing.NTSB DCA23WA054IncidentClass 5 · ForeignSaab 340 · Whitemark, AustraliaNTSB WPR23LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Mesa, AZThe failure of maintenance personnel to properly secure the fuel supply line to the fuel flow divider, which resulted in a fuel leak, fuel exhaustion, and a total loss of engine power.NTSB CEN23LA003Accident · No injuriesClass 3 · LimitedFinal reportEmbraer S A EMB-545 · Houston, TXThe crew failed to ensure the main entry door was locked before departure. Contributing to the accident was a corroded/jammed door sensor that provided an erroneous locked indication to the crew alerting system.NTSB WPR23LA004Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206B · Fresno, CAThe disbond of a tail rotor drive shaft splined adapter, which resulted in a loss of tail rotor drive and a subsequent hard landing.NTSB WPR22LA357Accident · No injuriesClass 3 · LimitedFinal reportVashon Ranger R7 · Glendale, AZFailure of the landing gear due to material deficiencies that reduced the strength of the landing gear.NTSB ANC22LA080Accident · 1 fatalClass 3 · LimitedFinal reportCessna 180A · Skwentna, AKThe failure of the landing gear float due to inadequate maintenance of the floats and corrosion.NTSB GAA22WA317Accident · No injuriesClass 4 · ForeignPiper PA38 · Jujuy, ArgentinaNTSB ERA22LA427Accident · 1 fatalClass 3 · LimitedFinal reportNorthwing Design Apache Sport · Southern Shores, NCA loss of aircraft control due to movement of the outer portion of the right wing fabric and displacement of wing ribs for reasons that could not be determined based on the available information.NTSB CEN22LA427Accident · No injuriesClass 3 · LimitedFinal reportCessna A188A · Canby, MNThe pilot’s failure to maintain airplane control during the landing, which resulted in an overload failure of the tailwheel cross tube and subsequent impact with the runway.NTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…NTSB CEN22LA396Accident · Minor injuriesClass 4 · LimitedFinal reportJavron Experimental PA18 Replica · Osceola, IAThe stuck right brake at landing which resulted in a loss of control.NTSB WPR22LA324Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBA · Athol, IDThe failure of the right brake due to a disconnected master cylinder piston rod, which led to the departure of the airplane from the runway surface. Contributing to the accident was the mechanic’s failure to adequately inspect the connection between the…NTSB ERA22LA382Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7AC · Clermont, FLThe pilot’s inability to maintain directional control while landing due to a worn tailwheel locking mechanism, which resulted in a runway excursion and collision with terrain.NTSB DCA22WA184Incident · No injuriesClass 5 · ForeignBoeing 737 · Banjarmasin, IndonesiaNTSB CEN22LA378Accident · No injuriesClass 3 · LimitedFinal reportCessna 210B · Clinton, ARA fatigue crack in the hydraulic actuator, which resulted in the loss of hydraulic fluid and the pilot’s inability to fully extend the landing gear.NTSB WPR22LA291Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3 · Chino, CAThe subsequent delamination of the main rotor blades as a result of an unidentified main rotor blade impact with vegetation during a previous flight by another pilot.NTSB CEN22LA333Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Waterloo, ILThe malfunction of the flight controls for undetermined reasons.NTSB CEN22LA328Accident · No injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC 135 · Mount Vernon, ILThe inadequate securement of the cloth fire extinguisher cover, which resulted in it being blown off the fire extinguisher and ingested into the helicopter’s fenestron during the landing.NTSB WPR22LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB21 · San Marcos, CAThe failure of the mechanical fuel pump due to internal friction for reasons that could not be determined based on available evidence, which resulted in a total loss of engine power.NTSB DCA22WA150OccurrenceClass 5 · ForeignBoeing 737 · Athens, GreeceNTSB CEN22LA318Accident · Serious injuriesClass 3 · LimitedFinal reportHiller UH12E · Becker, MNThe in-flight failure of the main rotor mast hub due to several undetected fatigue fractures.NTSB ERA22LA310Accident · No injuriesClass 3 · LimitedFinal reportCubcrafters CC11-160 · Findlay, OHThe pilot/mechanic’s inadequate inspection of the faulty horizontal stabilizer trim switch, which resulted in an uncommanded trim movement during the takeoff roll, which resulted in an aborted takeoff, and subsequent nose over.NTSB CEN22FA298Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · St. Jacob, ILThe inadequate maintenance of the airplane fuel system that resulted in fuel exhaustion and a loss of engine power.NTSB GAA22WA303OccurrenceClass 5 · ForeignUas Sea Fly Alta-X · South Oxfordshire, United KingdomNTSB ERA22LA296Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Knoxville, TNThe inadequate maintenance of the left main landing gear through bolt, which resulted in a left main landing gear collapse and subsequent runway excursion during landing.NTSB WPR22FA229Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Kerrville, TXThe pilot’s failure to maintain aircraft control during a base leg turn in the airport traffic pattern, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of recent flight training experience.NTSB DCA22WA137Incident · No injuriesClass 5 · Foreign737 800 · Cairo, Egypt