NTSB investigations
1,932 cases where NTSB found Fluids.
Cases per year
| 2008 | 86 |
|---|---|
| 2009 | 116 |
| 2010 | 126 |
| 2011 | 114 |
| 2012 | 123 |
| 2013 | 99 |
| 2014 | 123 |
| 2015 | 122 |
| 2016 | 108 |
| 2017 | 112 |
| 2018 | 116 |
| 2019 | 115 |
| 2020 | 110 |
| 2021 | 95 |
| 2022 | 105 |
| 2023 | 101 |
| 2024 | 84 |
| 2025 | 63 |
| 2026 | 14 |
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\", '010710')) 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", '010710')) 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 ERA26LA323Accident · No injuriesClass 4 · LimitedFinal reportMooney M-20 · Stanfield, NCThe pilot’s failure to adequately manage the available fuel onboard the airplane, which resulted in a total loss of power due to fuel starvation and a forced landing on uneven terrain.NTSB WPR26LA268Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18 · Colusa, CAThe pilot's inadequate fuel planning and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN26LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Ellsworth, KSThe pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to complete the flight.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 CEN26LA194Accident · No injuriesClass 4 · LimitedFinal reportLockwood AIR CAM · Hutchinson, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN26LA189Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Morris, ILThe pilot’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA26LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Enterprise, ALThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing into trees.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 ERA26LA181Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Mfg SP Z O O A32 · Lexington, KYThe flight instructor’s improper in-flight fuel management, which resulted in fuel starvation, a total loss of engine power, and a forced landing to rough terrain.NTSB CEN26LA165Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Peyton, COThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing to a field.NTSB ERA26LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Naples, FLThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN26LA144Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20 · Northlake, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB ERA26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Thonotosassa, FLThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN26LA128Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Larose, LAThe pilot’s improper fuel planning and his failure to adequately monitor the fuel level during flight, which resulted in fuel exhaustion, and a total loss of engine power. Contributing to the accident was the pilot’s lack of attention performing the task,…NTSB CEN26LA074Accident · Minor injuriesClass 3 · LimitedFinal reportPitts S1S · Carbondale, ILA loss of engine power due to fuel starvation resulting from an uncommanded change to the fuel servo mixture position due to the improperly installed mixture cable.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 CEN26LA073Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International 114 · Stroud, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of power due to fuel exhaustion.NTSB ERA26LA063Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · DeLand, FLThe flight instructor’s inadequate fuel quantity inspection, 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 ERA26LA018Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cynthiana, KYThe pilot's inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a forced landing. Contributing to the accident was the impact with powerlines during final approach.NTSB ERA26LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · North Lauderdale, FLA total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.NTSB CEN26LA003Accident · No injuriesClass 4 · LimitedFinal reportQuartz Mountain Aerospace 11E · Earlham, IAThe flight instructor’s inadequate fuel management which resulted in the total loss of engine power due to fuel exhaustion.NTSB CEN25LA403Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Longmont, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.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 CEN25LA391Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Seagoville, TXThe pilot’s inadequate fuel planning 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 CEN25LA359Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Nashville, ARThe pilot’s inadequate fuel planning which resulted in a total loss of power due to fuel exhaustion. Contributing to the accident was the landing zone being unlit.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 CEN25LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lubbock, TXThe pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C35 · Lakeview, TXThe pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA342Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Granbury, TXThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.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 ERA25LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Miami, FLAn inflight loss of hydraulic fluid from the landing gear system through a cracked fitting, which resulted in a landing gear collapse upon touchdown.NTSB ERA25LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Fordsville, KYThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a subsequent forced landing.NTSB CEN25LA298Accident · No injuriesClass 4 · LimitedFinal reportBell 47G · Assumption, MNA total loss of engine power due to fuel starvation, which resulted from attitude-inducing unporting of the fuel.NTSB ERA25LA382Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Destin, FLThe pilot’s inadequate fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.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 ANC25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna U206C · Gulkana, AKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA25LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna TP206C · Versailles, KYThe pilot’s mismanagement of the airplane’s available fuel supply, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB ERA25LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · St. Augustine, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA239Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Newaygo, MIThe pilot’s inadequate fuel planning and his failure to adequately monitor the fuel level during the flight which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA250Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Eustis, FLThe pilot’s inadequate preflight fuel planning and his failure to maintain directional control of the airplane after a total loss of right engine power during takeoff due to fuel starvation.NTSB WPR25LA183Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300T · Winchester, IDThe pilot’s improper fuel management resulting in fuel starvation, a total loss of engine power, and a subsequent off-airport forced landing. Contributing to the accident was the pilot’s reduced fuel level monitoring due to an inflight distraction.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 CEN25LA208Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E90 · New Century, KSThe flight instructor’s inadequate fuel planning that resulted in a loss of engine power to the left engine due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate supervision of the flight that resulted in diminished…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 ERA25LA226Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Murfreesboro, TNThe pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.NTSB ERA25LA273Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · New Port Richey, FLThe pilot's mismanagement of the available fuel, which resulted in fuel starvation and a total loss of engine power.