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 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.NTSB ERA19TA235Accident · No injuriesClass 3Final reportCessna 152 · Wakefield, VAThe pilot's inadequate preflight inspection, which failed to detect and remove all water from fuel, and maintenance personnel’s unapproved repair of the right wing fuel cap, which resulted in fuel contamination and a subsequent partial loss of engine power…NTSB CEN19LA243Accident · Serious injuriesClass 3 · LimitedFinal reportCulver LCA · Viroqua, WIA total loss of engine power due to fuel exhaustion.NTSB CEN19LA244Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Walls, MSThe improper fuel servicing of the airplane, which resulted in water contamination of the airplane's fuel supply and a subsequent loss of engine power.NTSB CEN19FA236Accident · 3 fatalClass 2 · FieldFinal reportBeech 95B55 · Chadron, NEThe pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA19CA446Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Tracy, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing and collision with a tree.NTSB ERA19LA231Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Poughkeepsie, NYA total loss of engine power due to fuel exhaustion as the result of a higher-than-expected fuel quantity reduction. Contributing was the pilot’s continued flight away from his selected precautionary landing site after identification of a fuel emergency,…NTSB ERA19LA224Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Carlisle, PAWater contamination of the fuel system, which resulted in a total loss of engine power. Contributing to the accident was the pilot's inadequate preflight inspection, which failed to remove all the water from the airplane's fuel system.NTSB CEN19LA222Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Clinton, ARA partial loss of engine power for undetermined reasons.NTSB CEN19LA220Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Wheeling, ILThe pilot’s decision to operate the engine above its maximum continuous speed for most of the flight, which led to fuel exhaustion and a subsequent total loss of engine power.NTSB ANC19LA032Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Newport, ORThe pilot's improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CEN19FA210Accident · 1 fatalClass 2 · FieldFinal reportBeech A36 · Chebanse, ILA total loss of engine power due to fuel starvation.NTSB CEN19LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 140 · Reeves, LAThe pilot's failure to secure the oil filler cap, which resulted in oil starvation and a precautionary off-airport landing, during which the airplane was substantially damaged.NTSB WPR19LA185Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Waikoloa Village, HIThe total loss of engine power due to the failure of the No. 4 connecting rod crankshaft end and cap.NTSB WPR19TA186Accident · No injuriesClass 3Final reportGlasair SH II · San Bernardino, CAA fuel leak caused by age-degraded fuel hoses, which resulted in a total loss of engine power and fire before takeoff. Contributing to the accident was inadequate maintenance.NTSB CEN19LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 · Fort Smith, ARA total loss of engine power due to fuel starvation as a result of the flight instructor's fuel mismanagement.NTSB WPR19LA187Accident · No injuriesClass 3 · LimitedFinal reportBeech C23 · Ludlow, CAMaintenance personnel’s failure to properly tighten an oil line fitting, which resulted in a total loss of engine power.NTSB GAA19CA382Accident · No injuriesData collectionFinal reportPiper PA24 · Brunswick, GAThe pilot's failure to properly lean the fuel mixture in flight, which resulted in fuel exhaustion, a subsequent total loss of engine power, and a forced landing with the landing gear retracted.NTSB CEN19LA186Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Omaha, NEThe loss of engine power due to fuel starvation.NTSB ERA19LA219Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 4 · Williamson, GAThe pilot's inadvertent misplacement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca S7EC · Jasper, ALA total loss of engine power due to fuel contamination.NTSB GAA19CA426Accident · Minor injuriesData collectionFinal reportNorth American T28 · Hollister, CAThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB GAA19CA361Accident · Minor injuriesData collectionFinal reportQuicksilver Aircraft Northeast Sport · Ledgedale, PAThe pilot's selection of unsuitable terrain for takeoff, which resulted a nose-over. Contributing to the accident was the pilot's improper in-flight fuel management, which resulted in the precautionary landing on unsuitable terrain.NTSB CEN19FA170Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Huntsville, TXA total loss of engine power as a result of the pilot's inadvertent placement of the fuel selector to the "off" position.NTSB ERA19FA193Accident · 2 fatalField investigationFinal reportCessna 182 · Maitland, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR19LA166Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Romona, CAA total loss of engine power due to oil starvation as a result of the failure of an oil filter adapter fiber gasket.NTSB GAA19CA336Accident · Minor injuriesData collectionFinal reportCessna 180 · Ontario, ORThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB WPR19TA162Accident · Minor injuriesClass 3Final reportBeech 35 · Medford, ORThe pilot’s mismanagement of fuel onboard, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR19LA160Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Davis City, CAA total loss of engine power due to water contamination in the fuel, which resulted in a forced landing and collision with terrain. Contributing to the accident was the pilot's improper decision to proceed with the flight after discovering the contaminated…NTSB GAA19CA344Accident · No injuriesData collectionFinal reportBell UH 1H · Bethel, AKThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power, and his improper landing flare during a forced autorotation, which resulted in a hard landing. Contributing to the accident were the inoperative fuel…NTSB GAA19CA297Accident · No injuriesData collectionFinal reportQuicksilver 2S Sport · Waverly, MNThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced, hard landing in a field.NTSB GAA19CA295Accident · No injuriesData collectionFinal reportPipistrel Alpha Trainer · Salida, COThe pilot's failure to replace the fuel cap after fueling, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing to a field and subsequent collision with a fence.NTSB CEN19LA159Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Cleburne, TXA total loss of engine power due to oil starvation as the result of the oil pressure switch failure due to a manufacturing defect.NTSB ANC19FA021Accident · 1 fatalClass 2 · FieldFinal reportBradshaw / McCauley Giles G-202 · Wasilla, AKThe pilot's failure to maintain control after the partial loss of engine power. Contributing to the accident was a contamination of the fuel system, which likely seized the electric fuel pump and restricted fuel flow to the engine.NTSB CEN19LA157Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Palm City, FLA total loss of engine power due to fuel starvation.NTSB CEN19LA153Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 8KCAB · Fredericksburg, TXA total loss of engine power due to fuel exhaustion.NTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.NTSB WPR19LA165Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Medford, ORA total loss of engine power due to fuel starvation.NTSB CEN19LA146Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S76 · Morrilton, ARThe improper securing of the exhaust duct bolts, which resulted in the duct becoming unseated and substantial heat damage to the tail rotor drive shaft.