Final NTSB investigations, 2025
27 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases per year
| 1979 | 1 |
|---|---|
| 2008 | 100 |
| 2009 | 75 |
| 2010 | 51 |
| 2011 | 59 |
| 2012 | 52 |
| 2013 | 48 |
| 2014 | 23 |
| 2015 | 40 |
| 2016 | 30 |
| 2017 | 34 |
| 2018 | 30 |
| 2019 | 28 |
| 2020 | 32 |
| 2021 | 43 |
| 2022 | 48 |
| 2023 | 46 |
| 2024 | 53 |
| 2025 | 27 |
| 2026 | 12 |
Where
Latest 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\") = 2025
AND c.\"completionStatus\" = 'Completed'
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") = 2025 AND c."completionStatus" = 'Completed' 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 ERA26LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · East Farmingdale, NYA loss of brake effectiveness during taxi, which resulted in a collision with another airplane.NTSB ERA26LA043Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 · Dothan, ALThe failure of the left main landing gear actuator rods, which resulted in a gear up landing.NTSB ERA26LA028Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Vultee 28-5ACF · Dayton, TNThe collapse of the left main landing gear due to the fatigue fracture of the lower landing gear actuator bolt.NTSB WPR26LA029Accident · No injuriesClass 4 · LimitedFinal reportRoderick James Willmore Kitfox S7 Supersport · Kilgore, IDThe pilot's failure to maintain directional control during the takeoff. Contributing to the accident was the separation of the control stick grip.NTSB CEN25LA398Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-60-601P · Del Norte, COThe loss of directional control during landing roll due to a flat tire.NTSB CEN25LA392Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20-C1 · Terre Haute, INThe failure of the nose landing gear strut and associated nosewheel separation during takeoff.NTSB CEN25LA382Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · South Bend, INThe pilot’s failure to maintain control of the airplane during a go around which resulted in an aerodynamic stall. Contributing to the accident was the loss of directional control during the landing roll.NTSB 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 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 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 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 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 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 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 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.