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.

NTSB CEN20LA322Accident · Serious injuriesClass 3 · LimitedFinal reportQuad City Challenger · Jonesboro, LALoss of engine power due to the use of improper fuel in the airplane by the non-certificated pilot.Aug 2, 2020 · N990SS · Substantial damageNTSB ERA20LA270Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA31 · Sumter, SCThe pilot’s fuel mismanagement during flight, which resulted in a total loss of engine power from both engines due to fuel starvation.Aug 1, 2020 · C-GXKS · Substantial damageNTSB CEN20CA331Accident · No injuriesClass 4 · Data collectionFinal reportCessna A188 · Hartington, NEThe pilot's failure to ensure that the engine oil cap was installed before takeoff, which resulted in the oil obscuring the pilot’s view through the windshield and necessitated a forced landing on unsuitable terrain. Contributing to the accident were the…Jul 27, 2020 · N9278G · Substantial damageNTSB CEN20CA316Accident · Minor injuriesClass 4 · Data collectionFinal reportRobinson R44 · Hebron, NEA loss of engine power due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight to sump the fuel tanks prior to flight.Jul 27, 2020 · N771GB · Substantial damageNTSB ERA20LA261Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Salinas, PRContamination and corrosion within the fuel system that resulted in a blockage, starvation of fuel to the engine, and the total loss of engine power.Jul 24, 2020 · N1813Q · Substantial damageNTSB WPR20LA234Accident · No injuriesClass 3 · LimitedFinal reportMontana Coyote · Jamul, CAA total loss of engine power due to an obstructed fuel line and fuel starvation, which resulted in a forced landing and collision with a fence. Contributing to the accident was the long duration of aircraft storage that allowed for contaminants to develop and…Jul 23, 2020 · N125MC · Substantial damageNTSB CEN20LA301Accident · No injuriesClass 3 · LimitedFinal reportVans RV4 · Idabel, OKThe pilot’s improper installation of an oil line, resulting in the loss of oil and subsequent total loss of engine power.Jul 22, 2020 · N54WP · Substantial damageNTSB CEN20CA303Accident · No injuriesClass 4 · Data collectionFinal reportStearman N2S 3 · Jacksonville, ARThe pilot's failure to adequately monitor his fuel quantity during flight, which resulted in fuel exhaustion and a total loss of engine power.Jul 22, 2020 · N2158P · Substantial damageNTSB ERA20LA258Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Pottstown, PAThe pilot's failure to ensure that sufficient fuel was onboard for nonlevel flight, which resulted in a total loss of engine power due to fuel starvation.Jul 21, 2020 · N4092D · Substantial damageNTSB CEN20LA292Accident · No injuriesClass 3 · LimitedFinal reportBeech A23-24 · Burns Flat, OKThe mechanic’s improper maintenance when he reinstalled the fuel servo during the last annual inspection, which resulted in a loss of engine power during cruise flight when the throttle control rod-end disconnected from the fuel servo throttle linkage.Jul 19, 2020 · N3412C · Substantial damageNTSB CEN20LA290Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Loveland, OHThe loss of engine power due to fuel starvationJul 18, 2020 · N4816A · Substantial damageNTSB WPR20LA223Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Vaughn, NMThe total loss of power in the right engine due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer-recommended procedure after the loss of power in the right engine.Jul 15, 2020 · N8488Y · Substantial damageNTSB ERA20LA245Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Falmouth, KYThe pilot’s failure to ensure that an adequate supply of fuel was available for the flight, which resulted in total loss of engine power due to fuel exhaustion.Jul 12, 2020 · N30309 · Substantial damageNTSB CEN20CA274Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Springfield, OHThe pilot’s inadequate inflight planning that resulted in a loss of engine power due to fuel exhaustion.Jul 11, 2020 · N22111 · Substantial damageNTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…Jul 10, 2020 · N6917K · DestroyedNTSB CEN20LA265Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado · Marksville, LAThe student pilot’s failure to ensure sufficient fuel onboard, which resulted in a total loss of engine power due to fuel exhaustion, which resulted in impact with terrain.Jul 2, 2020 · N5082N · Substantial damageNTSB CEN20LA252Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Denver, COThe total loss of engine power during climbout due to fuel starvation. Contributing to the accident was the pilot’s inadequate fuel planning.Jun 28, 2020 · N811MS · Substantial damageNTSB ERA20LA229Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Coconut Creek, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to recognize the illumination of the low-fuel caution light.Jun 25, 2020 · N5013G · Substantial damageNTSB CEN20LA245Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Winfield, TXThe total loss of engine power due to the pilot’s improper fuel management, which led to fuel starvation. Contributing to the accident was the low altitude at which the loss of engine power occurred.Jun 24, 2020 · N958HP · Substantial damageNTSB ERA20CA226Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Shelby, NCThe pilot's inadequate preflight and inflight fuel planning, which resulted in fuel exhaustion.Jun 22, 2020 · N1718Q · Substantial damageNTSB WPR20CA199Accident · No injuriesClass 4 · Data collectionFinal reportBeech D 45 · Ione, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and impact with terrain.Jun 3, 2020 · N341MR · Substantial damageNTSB CEN20CA249Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Lahoma, OKThe loss of engine power due to fuel exhaustion and the pilot’s improper fuel planning before the flight.Jun 1, 2020 · N6728U · Substantial damageNTSB ERA20LA197Accident · 1 fatalClass 3 · LimitedFinal reportSchweizer 269C-1 · Ozark, ALA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight school’s inadequate maintenance of the helicopter’s fuel quantity and caution systems.May 30, 2020 · N9421P · DestroyedNTSB ERA20LA198Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-180 · Humboldt, TNA partial loss of engine power due to contaminated fuel.May 29, 2020 · N6989P · Substantial damageNTSB ANC20LA050Accident · Serious injuriesClass 3 · LimitedFinal reportRockwell 500 · Aniak, AKA loss of engine power due to the use of improper fuel. Contributing to the accident was the failure of the pilot and ground personnel to ensure that the airplane was serviced with the proper fuel.May 29, 2020 · N909AK · Substantial damageNTSB WPR20LA161Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Cascade Locks, ORThe pilot’s improper fuel tank selection which resulted in fuel starvation to the engine and a loss of engine power.May 17, 2020 · N8359D · Substantial damageNTSB CEN20CA181Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Colchester, ILThe pilot's inadequate preflight of the fuel quantity which resulted in a loss of engine power due to fuel starvation during cruise flight.May 15, 2020 · N92036 · Substantial damageNTSB WPR20LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Tucson, AZThe pilot improper fuel management, which resulted in running the left fuel tank empty and a subsequent total loss of engine power due to fuel starvation.May 14, 2020 · N63931 · Substantial damageNTSB WPR20LA144Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Phoenix, AZA total loss of engine power due to oil starvation for reasons that could not be determined due to a lack of available evidence, which resulted in impact with terrain during a subsequent forced landing.May 13, 2020 · N201HH · Substantial damageNTSB WPR20LA172Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Imperial, CAThe pilot's loss of control during a landing roll due to a failure of the main O-ring in the right brake assembly, which resulted in a loss of brake pressure and subsequent brake failure.May 9, 2020 · N2245S · Substantial damageNTSB ERA20CA176Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 402 · Hampton, GAA dual total loss of engine power as a result of fuel exhaustion.May 9, 2020 · N4661N · Substantial damageNTSB CEN20LA172Accident · 1 fatalClass 3 · LimitedFinal reportCessna T210L · Burleson, TXThe loss of engine power due to fuel starvation.May 7, 2020 · N2074S · DestroyedNTSB CEN20LA170Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Hallettsville, TXThe partial loss of engine power due to contaminated fuel and carburetor ice.Apr 30, 2020 · N2275H · Substantial damageNTSB CEN20LA162Accident · Minor injuriesClass 2 · LimitedFinal reportCessna T210 · New Braunfels, TXThe pilot's inadequate preflight inspection and fuel planning, which resulted in the loss of engine power due to fuel exhaustion.Apr 28, 2020 · N210HH · Substantial damageNTSB ERA20LA160Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Pylesville, MDThe loss of engine power due to fuel starvation as a result of unporting of the fuel tank supply pickup while the helicopter was maneuvered to move a conductor wire. Contributing to the accident was the helicopter’s inappropriate configuration for the type of…Apr 25, 2020 · N9159F · Substantial damageNTSB WPR20LA130Accident · 1 fatalClass 3 · LimitedFinal reportBell UH 1H · Mesa, AZAn in-flight separation of the tail rotor gearbox from the airframe due to fatigue failure of the gearbox attachment studs, resulting in a loss of directional control and subsequent ground impact. Contributing to the accident were 1) the improper application…Apr 24, 2020 · N3276T · Substantial damageNTSB WPR20LA123Accident · 1 fatalClass 3 · LimitedFinal reportCessna TU206 · Auburn, CAThe total loss of engine power after takeoff due to water contamination of the fuel.Apr 18, 2020 · N756TH · DestroyedNTSB CEN20CA146Accident · Minor injuriesData collectionFinal reportPitts S2 · Fort Worth, TXThe pilot's inadequate preflight inspection of the fuel level, which resulted in a total loss of engine power due to fuel exhaustion.Apr 10, 2020 · N487J · Substantial damageNTSB WPR20LA117Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Santa Paula, CAThe pilot’s failure to ensure adequate fuel onboard for the planned flight, which resulted in a total loss of engine power due to fuel exhaustion.Apr 5, 2020 · N98SW · Substantial damageNTSB CEN20LA133Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · McKinney, TXThe pilot's inadequate preflight fuel planning and inflight fuel management, which resulted in fuel exhaustion and a total loss of engine power.Mar 25, 2020 · N4729U · Substantial damageNTSB CEN20LA132Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Waxahachie, TXThe partial loss of engine power due to water and contaminants in the fuel, due to the pilot’s inadequate preflight inspection, and the pilot’s decision to conduct a steep turn at low altitude to return to the runway rather than land straight ahead, which…Mar 25, 2020 · N5553C · Substantial damageNTSB ERA20LA132Accident · 1 fatalClass 3 · LimitedFinal reportCessna 310 · Charleston, SCThe pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation.Mar 21, 2020 · N8080M · Substantial damageNTSB ERA20CA135Accident · No injuriesData collectionFinal reportAugustaWestland AW119MKII · Philadelphia, PAThe in-flight failure of the lower left side of the engine cowling due to the mechanic’s improper installation of the fasteners, which resulted in the cowling impacting all four main rotor blades.Mar 21, 2020 · N982SS · Substantial damageNTSB ERA20FA124Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Sterling, MAA total loss of engine power during takeoff due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.Mar 11, 2020 · N1572H · Substantial damageNTSB ERA20LA122Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Destin, FLThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Mar 8, 2020 · N581U · Substantial damageNTSB ERA20FA119Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA 1 · Boynton Beach, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall and…Mar 6, 2020 · N5757L · Substantial damageNTSB WPR20LA098Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Encino, NMA partial loss of engine power due to fuel starvation, which likely resulted from a leak in the fuel system.Mar 4, 2020 · N505MA · Substantial damageNTSB WPR20LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · San Jose, CAThe failure to properly service the hydraulic power pack prevented a normal landing gear extension. Contributing to the accident was the failure of the landing gear emergency release valve to function properly for reasons that could not be determined based on…Feb 28, 2020 · N304LA · Substantial damageNTSB WPR20LA097Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Baker City, ORThe failure of the No. 2 connecting rod bearing as a result of oil starvation due to a contaminated oil filter screen.Feb 27, 2020 · N5478C · Substantial damageNTSB WPR20LA096Accident · Minor injuriesClass 3 · LimitedFinal reportLightning Avion Eab Arion Lightning · Jerome, IDThe pilot’s mismanagement of fuel, which resulted in fuel starvation and the pilot’s loss of airplane control during an emergency descent, which resulted in a stall and subsequent impact with terrain.Feb 26, 2020 · N1XF · Substantial damage