NTSB investigations, 2019
123 cases where NTSB found Fluids/misc hardware.
Cases per year
| 2008 | 96 |
|---|---|
| 2009 | 124 |
| 2010 | 128 |
| 2011 | 120 |
| 2012 | 132 |
| 2013 | 106 |
| 2014 | 126 |
| 2015 | 126 |
| 2016 | 118 |
| 2017 | 119 |
| 2018 | 122 |
| 2019 | 123 |
| 2020 | 115 |
| 2021 | 104 |
| 2022 | 109 |
| 2023 | 107 |
| 2024 | 94 |
| 2025 | 65 |
| 2026 | 18 |
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\") = 2019
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0107'))
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") = 2019 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0107')) 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 ERA20LA082Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Farmingdale, NYThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.NTSB WPR20CA056Accident · Serious injuriesData collectionFinal reportCosmos Phase II · Lake Havasu City, AZThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel inspection.NTSB ERA20CA059Accident · Minor injuriesData collectionFinal reportEipper Quicksilver · Mayaguez, PRThe student pilot's inadvertent movement of the fuel shutoff switch to the “off” position while attempting to take a picture of himself, which resulted in a total loss of engine power due to fuel starvation and a subsequent ditching in open water.NTSB CEN20LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Rush City, MNThe total loss of engine power due to fuel starvation because the student pilot failed to reposition the fuel mixture control to full rich before takeoff.NTSB ERA20CA090Accident · No injuriesClass 4 · Data collectionFinal reportPitts A · Hickory Valley, TNThe pilot’s improper fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN20LA036Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7ECA · Starkville, MSThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision not to visually confirm the remaining fuel onboard during the intermediate stop.NTSB WPR20LA038Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-34-200T · Phoenix, AZThe pilot’s mismanagement of the fuel onboard, which resulted in a loss of engine power due to fuel starvation. Contributing to the fuel starvation was the erroneous indications on the fuel gauges.NTSB ERA20LA050Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH-650 · Willow Springs, MOImproper maintenance practices on the fuel system causing fuel starvation and a total loss of engine power.NTSB ERA20TA046Accident · No injuriesClass 3Final reportPiper PA28 · Vero Beach, FLThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB ERA20LA044Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E35 · Okeechobee, FLThe separation of the throttle control cable from the carburetor throttle control lever resulting in the near total loss of engine power. Contributing to the separation of the throttle cable was the lack of proper securing hardware by unknown maintenance…NTSB GAA20CA089Accident · No injuriesData collectionFinal reportCessna 172 · DuBois, PAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…NTSB WPR20LA025Accident · No injuriesClass 3 · LimitedFinal reportNorth American SNJ-4 · Heber City, UTThe pilot’s loss of directional control during landing as a result of the separated tailwheel-to-rudder link rodNTSB ERA20LA039Accident · No injuriesClass 3 · LimitedFinal reportRans Rans S7 Courier · West Liberty, KYThe pilot's failure to verify that the engine oil tank contained adequate oil for the cross-country flight, which resulted in a total loss of engine power as a result of lack of lubrication. Contributing to the accident was the incorrect oil consumption…NTSB CEN20LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Houston, TXThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.NTSB ERA20TA030Accident · No injuriesClass 3Final reportBeech 76 · Doral, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB ERA20LA028Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Odessa, TXA loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB ERA20FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Paducah, KYThe pilot’s failure to fully seat the fuel selector in the proper tank position during the descent for landing, which resulted in fuel starvation and a total loss of engine power.NTSB CEN20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · White Bear Township, MNThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.NTSB WPR20FA015Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · American Falls, IDThe pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…NTSB CEN20LA014Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Swea City, IAThe pilot's failure to replace the oil filler cap during his preflight inspection, which resulted in oil starvation and a subsequent total loss of engine power.NTSB ERA20LA018Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Madisonville, TNThe pilot's unstable approach and delayed decision to go-around. Contributing to the accident was the unporting of the fuel supply following a forward slip maneuver during the approach, which resulted in the loss of engine power during the go-around.NTSB GAA20CA031Accident · No injuriesData collectionFinal reportErcoupe 415 · Alvin, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport landing, during which the airplane landed hard and then ground looped.NTSB GAA20CA017Accident · No injuriesData collectionFinal reportPiper PA28 · Dayton, OHThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing, during which the airplane struck a vehicle.NTSB GAA20CA010Accident · No injuriesData collectionFinal reportCessna 150 · Fallon, NVThe pilot's improper preflight fuel planning and quantity inspection, which resulted in fuel exhaustion, a total loss of engine power, a forced landing on unsuitable terrain, and a subsequent nose-over.NTSB GAA20CA006Accident · Minor injuriesData collectionFinal reportCessna 172 · Kaplan, LAThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with a pole during an off-airport landing.NTSB CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…NTSB ERA20TA005Accident · No injuriesClass 3Final reportSilverlight AR-1 · Fort Meade, FLThe student pilot’s inadequate preflight inspection that failed to detect water contamination of the fuel and resulted in a total loss of engine power during cruise flight.NTSB GAA20CA001Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Longs, SCThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing, and impact with trees.NTSB ERA20LA052Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Grove City, PAThe pilot’s mismanagement of the airplane’s available fuel, which resulted in a partial loss of engine power to the left engine, and his subsequent failure to maintain directional control of the airplane while on final approach to the runway.NTSB WPR19LA265Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Gresham, ORA total loss of engine power due to fuel starvation as a result of the instructor’s inadequate in-flight fuel management.NTSB CEN19FA325Accident · 2 fatalClass 3 · FieldFinal reportCessna A185 · Conroe, TXA partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall.NTSB GAA19CA569Accident · No injuriesData collectionFinal reportDiamond DA20 · Fort Wayne, INThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and impact with a tree during an off-airport landing.NTSB CEN19TA335Accident · Minor injuriesClass 3Final reportVans RV 4 · De Soto, MSA total loss of engine power due to fuel exhaustion.NTSB CEN19LA311Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Grassy Butte, NDA total loss of engine power due to water contamination of the fuel, and the pilot's failure to conduct a preflight inspection.NTSB CEN19LA309Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Walkerton, INThe partial loss of engine power due to fuel contamination.NTSB CEN19LA304Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28D-180 · Midlothian, TXMisalignment of the fuel selector valve when the right fuel tank was selected, which restricted fuel flow and resulted in a total loss of engine power due to fuel starvation.NTSB GAA19CA536Accident · Minor injuriesData collectionFinal reportCessna 310 · Tahlequah, OKThe total loss of right engine power due to fuel starvation and the pilot's improper fuel management.NTSB GAA19CA534Accident · No injuriesData collectionFinal reportPiper PA28 · Sawyer, MIThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss…NTSB CEN19LA290Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35 · Monroe, WIA total loss of engine power due to the failure of the Nos. 5 and 6 connecting rods from a lack of oil lubrication for reasons that could not be determined.NTSB WPR19LA243Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20C · Reno, NVThe pilot's improper inflight fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB WPR19LA240Accident · No injuriesClass 3 · LimitedFinal reportScoda Aeronautical Super Petrel · Lancaster, CAThe improper sealing of both carburetor bowls, which resulted in a total loss of engine power.NTSB CEN19TA293Accident · No injuriesClass 3Final reportPiper J3C · Russiaville, INThe pilot's failure to reinstall the oil cap after adding oil, which resulted to oil starvation and a precaautionary landing.NTSB ERA19LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 31P · East Brady, PAA total loss of left engine power for undetermined reasons.NTSB CEN19TA280Accident · Serious injuriesClass 3Final reportBell 47G · Montrose, COA loss of engine power due to fuel starvation, which resulted from attitude-induced unporting of the fuel.NTSB GAA19CA495Accident · Minor injuriesData collectionFinal reportFlight Design CT2K · Hooper, WAThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing to a field, and a subsequent nose-over.NTSB WPR19LA218Accident · No injuriesClass 3 · LimitedFinal reportExtra EA300 · Mesa, AZThe flight instructor’s operation of the airplane outside of the manufacturer’s limitations, which resulted in fuel starvation and a partial loss of engine power. Contributing to the accident was an inoperative electric fuel boost pump.NTSB CEN19LA252Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Miami, FLThe flight instructor's and student pilot's inadequate preflight inspection of the fuel system for water contamination, which resulted in a loss of engine power during takeoff and subsequent forced landing.NTSB CEN19LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Jacksonville, FLThe pilot's failure to select a fuel tank with adequate fuel, which resulted in fuel starvation and a total loss of engine power.NTSB ERA19LA239Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Chattanooga, TNThe improper maintenance of the airplane’s landing gear system, which resulted in a hydraulic fluid leak and insufficient pressure to extend and lock the landing gear during the accident flight.NTSB CEN19CA239Accident · No injuriesData collectionFinal reportCessna 172 · Oshkosh, WIThe pilot's improper fuel planning and decision to not divert to a closer airport when the planned flight profile changed, which resulted in a total loss of engine power due to fuel exhaustion.