NTSB investigations
2,052 cases where NTSB found Fluids/misc hardware.
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 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 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 WPR22LA041Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmington, NMThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB CEN22LA040Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 23 · Abilene, TXThe flight instructor’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the missing placard showing the usable fuel quantity.NTSB WPR22LA040Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Boulder City, NVThe installation of an improper right main landing gear door rod-end bolt, which resulted in the right main landing gear not extending during landing.NTSB ERA22LA052Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Ridgeway, VAThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB ERA22LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ringwood, NJA loss of engine power in flight due to fuel exhaustion as a result of the pilot’s failure to secure the left wing’s fuel cap.NTSB ERA22LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Decatur, GAOil exhaustion due to an oil leak that resulted in a total loss of engine power.NTSB CEN22LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Hudson Oaks, TXThe partial loss of engine power due to fuel exhaustion. Contributing was the pilot’s improper fuel planning.NTSB ERA22LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Waverly, TNThe pilot’s improper pre-flight fuel planning, which resulted in a total loss of engine power to both engines due to fuel exhaustion.NTSB WPR22FA022Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Ukiah, CAA power interruption due to water-contaminated fuel, which resulted in the student pilot aborting the takeoff and landing hard. Contributing to the accident were a leak in the left fuel tank that allowed water to enter and damage to the fuel tank that…NTSB CEN22LA037Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Hammond, LAA complete loss of engine power due to oil starvation as a result of the oil filter safety wire fracturing and the oil filter becoming loose in flight for a reason that could not be determined given the evidence available during the investigation.NTSB ERA22LA033Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Ballston Spa, NYThe flight instructor’s and student pilot’s inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR22LA024Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · St Ignatius, MTThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA22LA028Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Sligo, PAA total loss of engine power due to fuel exhaustion as a result of the pilots mismanagement of fuel.NTSB ERA22FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Walterboro, SCThe pilot’s inadequate fuel planning and fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB WPR22LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · White Swan, WAA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB WPR22LA014Accident · No injuriesClass 3 · LimitedFinal reportAvid Mark IV · Payette, IDA total loss of engine power during cruise flight due to fuel starvation. Contributing to the accident was the lack of an outlet screen on the fuel system header tank.NTSB ERA22LA002Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Oxford, NCA total loss of engine power due to fuel contamination.NTSB CEN22LA007Accident · Minor injuriesClass 3 · LimitedFinal reportSoneral L2 · Minot, NDThe pilot’s failure to maintain proper airspeed and exceedance of the airplane’s critical angle of attack on final landing approach, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the pilot’s inexperience with the…NTSB CEN21LA461Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Hancock, MNA total loss of engine power as a result of fuel starvation. Contributing to the accident was the pilot’s failure to properly manage the fuel on board the airplane and his failure to perform an adequate preflight inspection.NTSB ERA21LA383Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Miramar, FLThe flight instructor’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation. Contributing to the flight instructor’s injury was her failure to wear the shoulder harness.NTSB ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.NTSB CEN21LA457Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Lancaster, OHThe loss of engine power due to fuel starvation.NTSB ERA21LA382Accident · No injuriesClass 4 · LimitedFinal reportWyder Robert G Marquart MA-5 · Waycross, GAThe pilot’s inadequate fuel management, which resulted in a total loss of engine power on approach due to fuel starvation.NTSB WPR21FA352Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28R-200 · Page, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion and a total loss of engine power.NTSB WPR21LA363Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Orcas Island, WAThe total loss of engine power due to the pilot’s mismanagement of the fuel system which resulted in fuel starvation.NTSB ANC21LA093Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Chandalar Shelf, AKA separation of the rudder cable from the rudder pedal due to the connecting bolt detaching for undetermined reasons, which resulted in a loss of directional control.NTSB CEN21LA423Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Howell, MIThe pilot’s inadequate preflight inspection of the airplane’s fuel quantity, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR21LA342Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 58 · Palo Alto, CAThe fuelers addition of the incorrect fuel to the fuel tanks which resulted in a total loss of engine power.NTSB CEN21LA418Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Magnolia, TXA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight planning.NTSB ERA21LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Ayer, MAThe pilot’ improper preflight and inflight planning which resulted in fuel exhaustion.NTSB CEN21LA419Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Marshalltown, IAThe pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.NTSB CEN21LA406Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Kingsley, IAThe total loss of engine power due to fuel exhaustion as a result of an unsecured fuel bladder, which reduced the fuel capacity of the affected tank.NTSB ERA21LA393Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Delray, FLThe pilot’s inadequate preflight inspection and improper fuel planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ERA21LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Spartanburg, SCThe flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB CEN21LA386Accident · No injuriesClass 3 · LimitedFinal reportAcro Sport II · Fishers, INThe airplane’s total loss of engine power due to fuel exhaustion as a result of leaking fuel from a loose fuel inlet fitting to the fuel control unit.NTSB ERA21LA338Accident · No injuriesClass 3 · LimitedFinal reportSchmitt Just Acft Highlander · Crittenden, KYThe pilot’s inadequate fuel planning, which resulted in fuel starvation and a total loss of engine power.NTSB CEN21LA383Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Gypsum, COA loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…NTSB CEN21LA375Accident · No injuriesClass 3 · LimitedFinal reportHaley Highlander · Waller, TXA loss of engine power due to fuel exhaustion.NTSB WPR21LA315Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14-19-3 · Whitefish, MTA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to accomplish a preflight inspection.NTSB CEN21LA371Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210D · West Fargo, NDA total loss of engine power due to fuel starvation.NTSB CEN21LA362Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Topeka, KSThe pilot’s decision to continue low-level aerial application flight maneuvers after the low fuel warning light illuminated, which resulted in a partial loss of engine power due to fuel exhaustion.NTSB CEN21LA357Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Mer Rouge, LAThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot and ground personnel’s miscalculation of available fuel.NTSB CEN21LA365Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Urbana, OHThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21LA343Accident · Minor injuriesClass 3 · LimitedFinal reportStinson JR. SR · Ripon, WIA total loss of engine power due to fuel starvation.NTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.NTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.NTSB CEN21LA302Accident · Minor injuriesClass 3 · LimitedFinal reportPiper Aerostar 600A · Wichita, KSThe pilot’s improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.NTSB CEN21LA296Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Hoxie, ARThe pilot’s failure to ensure an adequate fuel supply for the intended flight.