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 DCA25WA345Incident · No injuriesClass 5 · ForeignBoeing 777-222 · Ezeiza, ArgentinaNTSB ERA25LA337Accident · No injuriesClass 4 · LimitedFinal reportLarocca Roch B Eracer MK II · Mount Pleasant, SCThe failure of the nose gear actuator bolt during the landing roll, which resulted in the collapse of the nose landing gear and subsequent runway excursion.NTSB WPR25LA300Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Firebaugh, CAA loss of directional control during landing due to the partial separation of the right main landing gear oleo strut from a failed weld.NTSB ERA25LA339Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Charleston, WVA flat left main landing gear tire, which resulted in a loss of directional control and runway excursion during landing.NTSB CEN25LA333Accident · No injuriesClass 4 · LimitedFinal reportParks Fokker D-VII Replica · Englewood, COA malfunction of the tailwheel which resulted in a runway excursion and ground loop.NTSB ERA25LA378Accident · Minor injuriesClass 3 · LimitedPreliminary reportThrush S2R-T660 · Albany, GAOn August 18, 2025, about 0944 EST, a Thrush Aircraft LLC S2R-T660, N7001B, was substantially damaged when it was involved in an accident at Southwest Georgia Regional Airport, Albany, Georgia. The commercial pilot sustained minor injuries. The airplane was…NTSB CEN25LA326Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Cape Girardeau, MOOn August 16, 2025, at 1150 central daylight time, a Robinson R44 II helicopter, N24DF was substantially damaged when it was involved in an accident near Cape Girardeau, Missouri. The pilot and three passengers were not injured. The helicopter was operated as…NTSB CEN25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182P · Bolivar, MOOn July 28, 2025, at about 1800 central daylight time, a Cessna 182P, N8243M, was destroyed when it was involved in an accident near Bolivar, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB DCA25LA275Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Denver, COThe failure of the airplane’s left main landing gear tires and wheels during the takeoff roll due to the thermal relief plugs melting and releasing tire pressure, which resulted in abnormal airplane handling characteristics and led the flight crew to reject…NTSB CEN25LA287Accident · No injuriesClass 4 · LimitedFinal reportAerotek Pitts S-2A · New Holstein, WIThe pilot’s loss of direction control during landing due to an unapproved tailwheel assembly and tail spring that resulted in a tailwheel shimmy and a subsequent ground loop.NTSB ANC25LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Gulkana, AKThe failure of the left rudder assembly which resulted in a runway excursion and ground loop.NTSB CEN25LA233Accident · No injuriesClass 3 · LimitedPreliminary reportICP Savannah S · Slaughter, LAOn June 30, 2025, about 1932 central daylight time an I.C.P. Srl Savannah S light sport airplane, N5000S was substantially damaged when it was involved in an accident near Slaughter, LA. The pilot and passenger were not injured. The flight was operated under…NTSB ANC25LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Denali Park, AKThe failure of the left main landing gear spring due to a fatigue fracture during landing on uneven terrain.NTSB GAA25WA231AccidentClass 5 · ForeignPiper PA-28-181 · Gloucestershire, United KingdomNTSB ERA25LA229Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R66 · Valparaiso, FLOn June 12, 2025, about 1850 eastern daylight time, a Robinson Helicopter R66, N633AF, was substantially damaged when it was involved in an accident near Valparaiso, Florida. The pilot and passenger sustained minor injuries, and a second passenger was not…NTSB DCA25LA233Incident · No injuriesClass 4 · LimitedInvestigation openBoeing 747-47UF · Guayaquil, EcuadorNTSB ERA25LA223Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Hebron, OHThe airplane owner and pilot’s intentional allowance of unapproved maintenance and maintenance personnel’s failure to adequately maintain or service the brake system, which resulted in a total loss of brake pressure.NTSB DCA25WA223Incident · No injuriesClass 5 · ForeignBoeing 737-8 Max · Muscat, OmanNTSB CEN25FA178Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Broomfield, COOn May 17, 2025, about 1003 mountain daylight time, a Beechcraft 95-B55, was destroyed when it was involved in an accident near Broomfield, Colorado. The pilot and pilot-rated passenger sustained fatal injuries. The flight was being operated as a Title 14…NTSB CEN25LA174Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Saint James, MNThe failure of the left main landing gear tire casing and tube due to excessive wear which resulted in a loss of directional control during the landing.NTSB WPR25LA148Accident · No injuriesClass 3 · LimitedPreliminary reportRutan LONG-EZE · Tucson, AZOn May 1, 2025, about 1030 mountain standard time, an experimental amateur-built Long EZE, N433EZ, was substantially damaged when it was involved in an accident near Tucson, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Vancouver, WAA failure of the brake system during landing due to a hydraulic fluid leak, which resulted in a runway excursion.NTSB WPR25LA122Accident · No injuriesClass 3 · LimitedFinal reportBeech C90A · Helena, MTThe failure of the left main landing gear to fully extend and lock as a result of broken downlock switch wires and the failure of the pilots to complete the manual gear extension checklist.NTSB ANC25LA030Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKMaintenance personnel’s reuse of worn hardware during the installation of the landing gear assembly and the hardware’s failure and subsequent separation of the gear leg from the landing gear box assembly during taxi.NTSB GAA25WA121Accident · No injuriesClass 5 · ForeignPiper PA46 · Aarhus, DenmarkNTSB ANC25LA021Accident · Minor injuriesClass 3 · LimitedFinal reportGippsland GA-8 · Lihue, HIThe failure of the right landing gear leg due to a fatigue crack, which resulted in its separation from the airplane during taxi. Contributing to the accident, was the mechanic’s inadequate inspection of the landing gear leg during the last maintenance…NTSB WPR25LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · La Verne, CAThe failure of the right main landing gear tubular spring due to a fatigue crack that originated at the airframe connecting bolt hole and progressed to an overstress fracture.NTSB ENG25WA025Incident · No injuriesClass 5 · ForeignLeonardo AW139 · Rio de Janeiro, BrazilNTSB GAA25WA106Incident · No injuriesClass 4 · ForeignSling LSA · Melbourne, AustraliaNTSB GAA25WA087Accident · No injuriesClass 5 · ForeignCessna 172 · Pará De Minas - Minas Gerais, BrazilNTSB CEN25LA083Accident · No injuriesClass 4 · LimitedFinal reportRaytheon Hawker 800XP · Minneapolis, MNThe failure of the nose landing gear to extend for undetermined reasons.NTSB ERA25LA100Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Orange, MAFailure of the left main landing gear to fully extend and lock for undetermined reasons as a functional test of the landing gear system could not duplicate the anomaly.NTSB ERA25LA096Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Pompano Beach, FLThe separation of the securing hardware for the right main landing gear upper and lower torque links for undetermined reasons, which prevented extension of the right main landing gear.NTSB ERA25LA091Accident · No injuriesClass 3 · LimitedFinal reportHelio HT-295 · Marion, OHThe failure of the right main landing gear spring due to intergranular stress-corrosion cracking that progressed into fatigue. Contributing to the accident was the improper rework of the spring at an undetermined time.NTSB CEN25LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lubbock, TXThe loss of directional control during the takeoff roll for undermined reasons that resulted in an impact with trees.NTSB ERA25LA094Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Florence, SCThe pilot’s failure to follow the emergency procedures and extend the landing gear manually after the landing gear did not initially extend normally.NTSB CEN25LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Crystal, MNThe malfunction of the landing gear system which resulted in a collapse of the main landing gear during the landing roll.NTSB WPR25LA059Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · El Cajon, CAThe pilot’s inability to maintain directional control during landing with a flat tire.NTSB ERA25LA070Accident · Serious injuriesClass 4 · LimitedFinal reportWilliam M Clapp CLAPP-SABERWING · Valdosta, GAA hard landing and subsequent gear collapse due to the pilot’s failure to securely close the airplane canopy and its subsequent opening on short final.NTSB ANC25LA009Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Egegik, AKA failure of the right main landing gear leg for reasons that could not be determined.NTSB ERA25LA068Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Daytona Beach, FLThe maintenance technician’s failure to follow the manufacturer’s recommended procedures during a wheel and tire change to ensure proper clearance of the tire to the wheel well resulting in the right main wheel becoming stuck in the well and subsequent…NTSB GAA25WA289Accident · No injuriesClass 4 · ForeignBombardier N/A · Hannover, GermanyNTSB ERA25LA030Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 HDS · Altoona, PAThe total loss of engine power due to fuel starvation as a result of a deteriorated gascolator gasket. Contributing was the failure of the mechanic to replace the gasket during the most recent condition inspection.NTSB CEN25LA013Accident · Minor injuriesClass 3 · LimitedFinal reportRotorway Exec · Plymouth, INA loss of control due to the failed forward tail rotor belt as a result of the owner’s failure to follow the helicopter manufacturer’s tail rotor belt replacement recommendations.NTSB CEN25LA009Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver GT 400 · Garden Ridge, TXA loss of engine power that resulted from improper fuel system maintenance and the subsequent fuel starvation due to the leaking fuel pump outlet fuel line.NTSB CEN25LA007Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Richmond, TXThe partial separation of a portion of the propeller spinner and its mounting bulkhead along with the upper cowl fairing while in a full-power climb.NTSB CEN25LA002Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Moffett, OKThe tail wheel assembly’s fractured bolt which resulted in the pilot’s loss of directional control during landing.NTSB WPR24LA319Accident · No injuriesClass 3 · LimitedFinal reportBell 206L · Fern Prairie, WAAn aeroelastic interaction between the helicopter’s main rotor blades and nodal beam system, which resulted in oscillations that exceeded the design limits of the tailboom. Contributing to the accident was the failure of the main rotor blade manufacturer to…NTSB GAA24WA297Accident · No injuriesClass 5 · ForeignPiper PA-31 · Gloucestershire, United KingdomNTSB GAA24WA295Accident · No injuriesClass 5 · ForeignPilatus PC12 · Thunder Bay, Canada