NTSB investigations
777 cases where NTSB found Inspection.
Cases per year
| 2008 | 59 |
|---|---|
| 2009 | 48 |
| 2010 | 59 |
| 2011 | 44 |
| 2012 | 52 |
| 2013 | 37 |
| 2014 | 61 |
| 2015 | 42 |
| 2016 | 34 |
| 2017 | 43 |
| 2018 | 28 |
| 2019 | 29 |
| 2020 | 34 |
| 2021 | 43 |
| 2022 | 43 |
| 2023 | 40 |
| 2024 | 39 |
| 2025 | 34 |
| 2026 | 8 |
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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020615')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020615')) 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 WPR26LA229Accident · Minor injuriesClass 4 · LimitedFinal reportRyan Navion · Bismarck, MOThe pilot’s failure to remove the maintenance spacer before takeoff, which resulted in restricted flight control movement and a loss of control.NTSB CEN26LA215Accident · No injuriesClass 4 · LimitedFinal reportEaa Acro Sport II · Sheridan, ARThe pilot’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA203Accident · No injuriesClass 4 · LimitedFinal reportPzl-Swidnik PW-5 · Soap Lake, WAThe pilot’s failure to ensure the proper preflight assembly of the glider's wing attachment system, which resulted in substantial damage to the wing structure during flight.NTSB ERA26LA201Accident · No injuriesClass 4 · LimitedFinal reportSky Ranger SKY Ranger 1 · Front Royal, VAThe pilot’s inadequate preflight inspection, which resulted in him taking off with the fuel selector in the OFF position, and the subsequent total loss of engine power due to fuel starvation.NTSB WPR26LA173Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Salinas, CAThe flight instructor’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA130Accident · No injuriesClass 4 · LimitedFinal reportTextron 680A · Miami, FLThe flight crew’s failure to maintain adequate clearance from the blast fence during taxi to the runway for departure, and their inadequate inspection of the airplane after it contacted the blast fence.NTSB ERA26LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 320C · Bartow, FLMaintenance personnel’s failure to perform an adequate inspection of the airplane’s landing gear, which resulted in a collapse of the left main landing gear during landing.NTSB WPR26LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-23 · Newkirk, NMThe pilots inadequate preflight planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.NTSB WPR26LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Temecula, CAThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC26LA007Accident · No injuriesClass 4 · LimitedFinal reportDanchini Aero Danchini Cub · Wasilla, AKThe pilot’s inadequate preflight inspection, and inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing.NTSB ERA26LA009Accident · No injuriesClass 4 · LimitedFinal reportCessna 182H · Smithfield, RIMaintenance personnel’s improper rigging of the elevator trim system, which resulted in a hard landing. Contributing was the maintenance personnel and pilot’s failure to perform adequate post maintenance/preflight inspections.NTSB ANC25LA116Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Alpine, WYThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off airport landing.NTSB WPR25LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 185A · Ilwaco, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA377Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Lancaster, TXThe pilot’s inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA361Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Caro, MIThe pilot’s failure to remove the tow bar before flight.NTSB ERA25LA324Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · New Smyrna Beach, FLMaintenance personnel’s failure to detect and address water contamination of the airplane’s fuel system, which resulted in a total loss of engine power during initial climb.NTSB CEN25LA332Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Air Force Academy, COThe student pilot’s failure to perform an adequate preflight inspection.NTSB ERA25LA315Accident · Serious injuriesClass 4 · LimitedFinal reportPatriot CX1900A · Centreville, ALThe pilot’s failure to detect and remove water contamination from the airplane’s fuel system before the flight, which resulted in a total loss of engine power during initial climb.NTSB ERA25LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCentrair 101A · Springfield, VTThe pilot’s failure to assemble the glider’s elevator control before takeoff.NTSB CEN25LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · Kerrville, TXThe pilot’s failure to confirm the fuel quantity before flight which resulted in a loss of engine power due to fuel starvation.NTSB ERA25LA256Accident · Serious injuriesClass 4 · LimitedFinal reportKyle Koncak Aventura II · DeLand, FLThe uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.NTSB WPR25LA184Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180E · Rockford, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB WPR25LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Willow Creek, MTThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Columbus, MSThe pilot's inadequate preflight inspection and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB ERA25LA194Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Hastings, FLThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR25FA146Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Grass Valley, CAAn improperly tightened B-nut fitting at the fuel flow divider, which resulted in a fuel leak and loss of engine power due to fuel starvation, and the inadequate maintenance inspection, which failed to detect and correct the discrepancy.NTSB ERA25LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Louisburg, NCMaintenance personnel’s failure to identify and remediate water contamination of the airplane’s fuel system, which resulted in a partial loss of engine power during initial climb.NTSB ERA25LA186Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Lakin, WVThe pilot’s inadequate preflight inspection, and inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing.NTSB ERA25LA162Accident · Serious injuriesClass 4 · LimitedFinal reportRuys Nicholas G RV-8 · Bennettsville, SCThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing.NTSB ERA25LA159Accident · No injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · New Port Richey, FLMaintenance personnel’s inadequate inspection of the exhaust system, which allowed exhaust gases to enter the induction system from cracks in the exhaust manifold, resulting in a total loss of engine power and a subsequent forced landing.NTSB CEN25LA165Accident · No injuriesClass 3 · LimitedFinal reportCessna T206 · Natchez, MSMaintenance personnel’s improper maintenance, which resulted in a loss of engine power due to fuel starvation as the result of a loose fuel line B-nut. Contributing to the accident was an inadequate 100-hour inspection performed after the recent maintenance.NTSB CEN25LA129Accident · No injuriesClass 4 · LimitedFinal reportStemme S10-VT · Kiowa, COThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA141Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Hollywood, FLA total loss of engine power was due to a fracture of the crankshaft at the No. 3 main journal, which originated from a preexisting, thermally induced crack that had gone undetected by maintenance personnel during an inspection performed as part of the…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 ERA25LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech E33 · Lenoir, NCThe mechanic’s inadequate annual inspection of the airplane and failure to comply with an applicable airworthiness directive, which resulted in a total loss of engine power due to oil starvation.NTSB WPR25LA095Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver Aeronautics L-S2S · Geyserville, CAThe pilot’s failure to secure the coolant cap during the preflight inspection, which resulted in a total loss of engine power due to overheating and a subsequent forced landing.NTSB ERA25LA122Accident · No injuriesClass 4 · LimitedFinal reportAllyn Kaste Rans S-19 (KIT) · Doylestown, PAThe pilot’s inadequate maintenance and preflight inspection.NTSB WPR25LA099Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Salome, AZThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection.NTSB ERA25LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Clarksville, TNThe flight instructor’s inadequate preflight inspection of the airplane, which allowed the partially secured engine cowl to separate in flight.NTSB CEN25LA080Accident · Serious injuriesClass 4 · LimitedFinal reportLuscombe 8 · Omaha, NEThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR25LA073AccidentClass 4 · LimitedFinal reportCessna 150D · Temple City, CAThe flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.NTSB WPR25LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Gallup, NMThe pilot’s improper fuel management, which resulted in a total loss of engine power.NTSB CEN25LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Pagosa Springs, COThe pilot’s inadequate preflight planning and poor preflight inspection and decision-making, which led to a takeoff attempt above the airplane’s certified maximum takeoff weight with snow-contaminated wings, resulting in a rejected takeoff at an airspeed…NTSB CEN25LA060Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Victoria, TXThe pilot’s inadequate preflight planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA062Accident · Serious injuriesClass 3 · LimitedFinal reportAlexander S Rolinski BOT Journey · Ocean Isle Beach, NCMaintenance personnel’s failure to identify and remediate a buildup of oxides in one of the engine’s carburetors, which resulted in the seizure of the carburetor’s piston slide and a subsequent total loss of engine power during initial climb.NTSB ANC25LA008Accident · Serious injuriesClass 3 · LimitedFinal reportCub Crafters CC18-180 · Anchorage, AKThe incorrect installation of the rear flight control stick, resulting in the pilot’s inability to control the pitch attitude, coupled with the pilot’s inadequate control system check before departure, all which resulted in an aerodynamic stall during takeoff.NTSB WPR25LA030Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Prescott Valley, AZSeparation of the No. 3 engine cylinder due to a loss of torque on the cylinder base nuts, which resulted in a loss of engine power and in-flight fire. Contributing to the accident was maintenance personnel’s failure to ensure the engine case and cylinder…NTSB WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…NTSB CEN25LA029Accident · Minor injuriesClass 3 · LimitedFinal reportCub Crafters Carbon CUB · Ogallala, NEThe improper installation of the elevator control cable hardware, which resulted in the separation of the elevator control cable and a loss of pitch control in flight.