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 GAA19CA015Accident · No injuriesData collectionFinal reportTitan Titan Tornado 912 · Corry, PAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.Oct 7, 2018 · N912R · Substantial damageNTSB WPR18LA278Accident · No injuriesClass 3 · LimitedFinal reportHoward DGA 15P · Kernville, CAA total loss of engine power during initial climb due to fuel starvation.Sep 30, 2018 · N9471H · DestroyedNTSB GAA18CA574Accident · No injuriesData collectionFinal reportPiper PA24 · Crewe, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper fuel management, which resulted in fuel starvation…Sep 29, 2018 · N6148P · Substantial damageNTSB ANC18LA073Accident · No injuriesLimited investigationFinal reportCessna A185 · Fairbanks, AKThe total loss of engine power due to fuel exhaustion.Sep 27, 2018 · N70391 · Substantial damageNTSB WPR18LA280Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Kapolei, HILoss of engine power due to water in the fuel lines.Sep 21, 2018 · N66201 · Substantial damageNTSB CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…Sep 21, 2018 · N7152S · Substantial damageNTSB WPR18LA271Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Brenham, TXThe pilot's improper fuel management during the landing approach, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was his failure to follow the published emergency procedures after the loss of engine power.Sep 20, 2018 · N756NN · Substantial damageNTSB GAA18CA565Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 · Igiugig, AKThe pilot’s selection of an empty fuel tank for takeoff, which resulted in fuel starvation and the subsequent total loss of engine power.Sep 20, 2018 · N121AK · Substantial damageNTSB CEN18LA381Accident · No injuriesLimited investigationFinal reportPiper PA28 · Pagosa Springs, COThe student pilot's mismanagement of the fuel selector valve during the simulated forced landing demonstration and the flight instructor's inadequate supervision to ensure the fuel selector was properly set, which resulted in a loss of engine power and…Sep 19, 2018 · N8003W · Substantial damageNTSB WPR18LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Upland, CALoss of engine power due to fuel contamination.Sep 17, 2018 · N7472P · Substantial damageNTSB WPR18FA266Accident · 1 fatalClass 2 · FieldFinal reportBeech 33 · Cottonwood, AZThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.Sep 17, 2018 · N2031D · Substantial damageNTSB ERA18TA250Accident · Minor injuriesFinal reportAmerican AA1 · Warthen, GAA fuel leak from the carburetor float bowl due to a missing plug, which resulted in excessive fuel consumption and a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision to depart on the accident flight leg…Sep 14, 2018 · N9218L · Substantial damageNTSB WPR18LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to secure his seat position prior to takeoff, which resulted in a loss of airplane control and subsequent hard landing.Sep 12, 2018 · N24ME · Substantial damageNTSB CEN18FA371Accident · 1 fatalField investigationFinal reportCessna 340A · Port Huron, MIThe pilot's improper fuel management, which resulted in a total loss of right engine power due to fuel starvation; the pilot's inadequate flight planning; the pilot's failure to secure the right engine following the loss of power; and his failure to properly…Sep 6, 2018 · C-GLKX · Substantial damageNTSB GAA18CA537Accident · No injuriesData collectionFinal reportCessna 180 · Richmond, VAThe pilot's improper preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and the total loss of engine power.Sep 5, 2018 · C-GODA · Substantial damageNTSB WPR18FA249Accident · 1 fatalField investigationFinal reportCessna 150L · Pacoima, CAA loss of engine power shortly after takeoff due to fuel exhaustion, and the exceedance of the airplane's critical angle of attack when the flight instructor made an abrupt turn back toward the runway, which resulted in an aerodynamic stall/spin at an…Sep 4, 2018 · N10789 · Substantial damageNTSB ERA18LA242Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Indiana, PAA total loss of engine power as a result of debris contamination of the fuel, which resulted in fuel starvation.Sep 2, 2018 · N4059C · Substantial damageNTSB CEN18LA361Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 55 · Waupaca, WIThe total loss of engine power due to fuel exhaustion.Sep 1, 2018 · N10DS · Substantial damageNTSB WPR18LA246Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Tehachapi, CAThe pilot's inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb.Aug 31, 2018 · N2167V · Substantial damageNTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 27, 2018 · N1701Q · Substantial damageNTSB CEN18LA354Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bowman, NDThe loss of engine power due to fuel starvation.Aug 26, 2018 · N666WW · Substantial damageNTSB ERA18LA229Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Quincy, FLA loss of engine power due to decreased fuel flow for reasons that could not be determined based on the available evidence.Aug 24, 2018 · N773CB · Substantial damageNTSB CEN18LA349Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Minneapolis, MNThe fire during approach for reasons that could not be determined based on the available evidence, which resulted in impact with terrain during approach for a precautionary landing.Aug 23, 2018 · N215SF · DestroyedNTSB ANC18LA066Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Kaktovik, AKA loss of engine power due to fuel starvation during a steep turn with a low fuel state.Aug 22, 2018 · N8041R · Substantial damageNTSB WPR18TA236Accident · Minor injuriesClass 3Final reportPiper PA28 · Mokuleia, HIA total loss of engine power due to fuel starvation as a result of the flight instructor's inadequate preflight inspection.Aug 21, 2018 · N98146 · Substantial damageNTSB WPR18LA233Accident · No injuriesLimited investigationFinal reportBlue Oak CCK-1865 · Deadwood, CAA loss of engine power due to fuel exhaustion and the pilot's failure to ensure that the left-wing fuel cap was secure before flight. Contributing to the accident was the pilot's failure to monitor fuel levels while in flight.Aug 20, 2018 · N14CK · Substantial damageNTSB CEN18LA340Accident · No injuriesLimited investigationFinal reportBeech B36TC · LaPorte, TXThe loss of engine power due to a torn intercooler hose that resulted in an overly rich fuel mixture, which, when combined with the pilot's activation of the auxiliary fuel pump, flooded the engine.Aug 20, 2018 · N6860W · DestroyedNTSB WPR18TA243Accident · No injuriesFinal reportBeech 36 · Kelso, WAThe pilot's fuel mismanagement, which led to fuel starvation, a total loss of engine power, and the subsequent forced landing to a field.Aug 19, 2018 · N9031S · Substantial damageNTSB WPR18LA226Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369 · Riverside, CAThe instructor’s delayed remedial action to an excessive descent rate during a simulated autorotation, which resulted in a hard landing.Aug 17, 2018 · N105JL · Substantial damageNTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…Aug 17, 2018 · N2893Q · Substantial damageNTSB WPR18TA223Accident · No injuriesFinal reportZenair Zenith Stol CH750 · Napa, CAThe pilot's use of fuel below the required octane rating, which caused engine detonation and damage and subsequently led to oil exhaustion and a total loss of engine power in flight. Contributing to the accident was the pilot's inadequate service/maintenance…Aug 11, 2018 · N328SK · Substantial damageNTSB GAA18CA515Accident · No injuriesData collectionFinal reportDell Lawrence Kitfox · Hunter, NYThe pilot’s inadequate in-flight fuel management, which necessitated an off-airport precautionary landing, and his failure to maintain airplane control during the landing roll on rough terrain.Aug 9, 2018 · N26LD · Substantial damageNTSB CEN18LA317Accident · No injuriesLimited investigationFinal reportCessna 120 · Pomona, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a forced landing.Aug 6, 2018 · N76524 · Substantial damageNTSB GAA18CA468Accident · No injuriesData collectionFinal reportCessna 185 · Lovelock, NVThe pilot's improper in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Aug 5, 2018 · N9867X · Substantial damageNTSB GAA18CA465Accident · No injuriesData collectionFinal reportBellanca 8GCBC · El Dorado, ARThe pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jul 27, 2018 · N391KM · Substantial damageNTSB CEN18LA300Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Le Sueur, MNThe pilot's inadequate preflight and in-flight fuel planning, during which he did not visually check the fuel quantity in the fuel tanks and instead relied on the fuel gauges that were showing erroneous fuel quantity indications, which resulted in fuel…Jul 27, 2018 · N9005T · Substantial damageNTSB GAA18CA454Accident · No injuriesData collectionFinal reportCessna 172 · Meadow Lakes, AKThe pilot’s selection of the wrong fuel tank for departure, which resulted in fuel starvation and the subsequent total loss of engine power.Jul 25, 2018 · N171Q · Substantial damageNTSB CEN18LA287Accident · No injuriesLimited investigationFinal reportCessna 210C · Blum, TXThe pilot's excessive leaning of the fuel mixture, which resulted in a loss of engine power, and the pilot's failure to extend the landing gear in accordance with the airplane emergency checklist, which resulted in a gear-up landing.Jul 21, 2018 · N3611Y · Substantial damageNTSB CEN18LA285Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Baton Rouge, LAThe loss of right engine power due to fuel starvation, which resulted from corrosion debris in the fuel lines. Contributing to the accident was the mechanic’s and pilot’s inadequate maintenance of the airplane before the flight.Jul 20, 2018 · N327BK · Substantial damageNTSB WPR18LA199Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC19 · Hyrum, UTThe pilot’s improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent loss of engine power. Contributing to the accident was the pilot’s distraction due to a malfunctioning hangar door and a…Jul 19, 2018 · N70DD · Substantial damageNTSB CEN18LA276Accident · No injuriesLimited investigationFinal reportBeech V35 · Katy, TXMaintenance personnel’s failure to remove a paper towel from the engine during recent maintenance, which resulted in oil starvation, the failure of a connecting rod, and a catastrophic engine failure and subsequent total loss of engine power.Jul 17, 2018 · N228Q · Substantial damageNTSB ERA18TA193Accident · Serious injuriesFinal reportQuicksilver MXL II · Arecibo, PRThe noncertificated pilot's improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 14, 2018 · N594TC · Substantial damageNTSB CEN18LA275Accident · No injuriesLimited investigationFinal reportWhittman Tailwind · Orient, OHThe pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…Jul 12, 2018 · N619NT · Substantial damageNTSB CEN18IA273Incident · No injuriesIncident investigationFinal reportCessna A188B · Rockford, OHThe total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.Jul 12, 2018 · N2483J · Minor damageNTSB GAA18CA421Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, ILThe pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jul 11, 2018 · N2394G · Substantial damageNTSB ERA18LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Gulf Shores, ALThe pilot's improper preflight and in-flight fuel planning, which resulted in fuel exhaustion to the left engine and a total loss of engine power during an attempted go-around maneuver.Jul 7, 2018 · N294AB · Substantial damageNTSB CEN18LA260Accident · No injuriesLimited investigationFinal reportBell 206 · Bentley, ILThe pilot's failure to ensure that adequate fuel was on board for the maneuvering flight, which resulted in a total loss of engine power due to fuel starvation.Jul 6, 2018 · N224KM · Substantial damageNTSB CEN18FA258Accident · 1 fatalField investigationFinal reportBell 47G · Arlington, INThe inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.Jul 6, 2018 · N96195 · Substantial damageNTSB GAA18CA431Accident · Minor injuriesData collectionFinal reportCessna 172 · King and Queen, VAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jul 5, 2018 · N1401F · Substantial damageNTSB GAA18CA419Accident · No injuriesData collectionFinal reportCessna 152 · Panama City, FLThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jun 30, 2018 · N89887 · Substantial damage