NTSB investigations, ID
37 cases where NTSB found Fluids/misc hardware.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 5 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 1 |
| 2023 | 5 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' 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 WPR25LA183Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300T · Winchester, IDThe pilot’s improper fuel management resulting in fuel starvation, a total loss of engine power, and a subsequent off-airport forced landing. Contributing to the accident was the pilot’s reduced fuel level monitoring due to an inflight distraction.NTSB WPR24LA087Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Burley, IDThe failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…NTSB WPR24LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 310 · Hayden, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control and subsequent stall during a precautionary landing. Contributing to the accident was the improper maintenance…NTSB WPR23LA346Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Apple, IDFuel starvation due to the pilot’s incorrect movement of the fuel selector valve to OFF, which resulted in a loss of engine power.NTSB WPR23LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Indian Creek, IDThe pilot's improper fuel management, which resulted in fuel starvation, and gear up landing on a dirt airstrip.NTSB WPR23LA297Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Blanchard, IDFuel contamination, which resulted in a loss of engine power. The source of the contamination could not be determined.NTSB WPR23LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Lewiston, IDThe flight instructor’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.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 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 WPR21LA234Accident · No injuriesClass 4 · LimitedFinal reportBolstridge Wallace R SKY Raider 1 · Nampa, IDA total loss of engine power due to the pilot’s failure to premix the two-cycle oil/gasoline mixture, which resulted in a forced landing in a field and collision with terrain.NTSB WPR21LA107Accident · Serious injuriesClass 3 · LimitedFinal reportHughes OH-6A · Horseshoe Bend, IDA partial loss of engine power due to a leak in the fuel cell outlet valve.NTSB WPR20CA299Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 182 · Coeur d'Alene, IDThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion and a collision with trees and terrain.NTSB 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.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 WPR18LA050Accident · No injuriesLimited investigationFinal reportGray Jim Robert Exec · Caldwell, IDFailure of the oil pressure gauge line, which resulted in oil exhaustion and a total loss of engine power.NTSB WPR17FA128Accident · 1 fatalField investigationFinal reportPrescot E. Wilkie RV-3 · Payette, IDThe in-flight failure of the left wing due to the owner's use of improper hardware and his improper assembly of the airplane, which reduced the strength of the left wing and resulted in its subsequent failure following a sharp pullup maneuver.NTSB WPR16LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Salmon, IDA loss of engine power due to water in the fuel system. Contributing to the accident was an inadequate preflight inspection that failed to eliminate water from the fuel system.NTSB WPR16LA008Accident · No injuriesLimited investigationFinal reportCessna T210K · Boise, IDThe pilot’s improper in-flight fuel management due to distraction and self-induced pressure, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to conduct the descent checklist, which…NTSB WPR15LA237Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · American Falls, IDThe low flight time pilot's inadequate in-flight fuel planning, which resulted in fuel exhaustion, a loss of engine power, and an off-airport landing in rough terrain.NTSB GAA15CA164Accident · Minor injuriesData collectionFinal reportPiper PA 18-135 · Twin Falls, IDThe pilot's inadequate fuel inspection during his preflight fuel performance planning task, resulting in fuel exhaustion en route, and an emergency landing and collision with terrain.NTSB WPR15LA029Accident · No injuriesLimited investigationFinal reportHenry Steven J Just Acft Superstol · Murphy, IDThe pilot’s failure to properly manage the fuel supply, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR15LA001Accident · 1 fatalLimited investigationFinal reportGaston Thomas D Thunder Mustang · Council, IDThe pilot's failure to maintain control while maneuvering for landing following a loss of oil pressure. Contributing to the accident was foreign material contamination of the oil system due to improper maintenance.NTSB WPR14CA333Accident · Minor injuriesData collectionFinal reportKitfox Series 5 · Kamiah, IDA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.NTSB WPR13LA416Accident · Serious injuriesLimited investigationFinal reportBeech C90 - A · Idaho Falls, IDThe pilot's inadequate preflight fuel planning, which resulted in departure with insufficient fuel to complete the flight, and consequent inflight power loss due to fuel exhaustion.NTSB WPR13LA304Accident · No injuriesLimited investigationFinal reportDorman Bakeng · Garden Valley, IDA mechanical failure of the oil cooler, which resulted in a complete loss of oil and engine power.NTSB WPR13FA281Accident · 2 fatalField investigationFinal reportPiper PA-30 · Idaho Falls, IDA loss of power to the right engine during the initial climb due to fuel contamination and the pilot's failure to maintain adequate airspeed and airplane control. Contributing to the accident was the pilot's inadequate preflight check of the airplane.NTSB WPR12CA401Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Lewiston, IDThe pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.NTSB WPR12LA265Accident · Serious injuriesLimited investigationFinal reportRoetman Ryland K JR Eagle · Rexburg, IDA loss of engine oil pressure, which led to the subsequent uncommanded loss of thrust and decrease in the propeller rpm during a low-level aerobatic maneuver.NTSB WPR11LA269Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Caldwell, IDThe total loss of power in one engine during takeoff due to the blockage of fuel flow by a foreign object in the fuel tank.NTSB WPR10LA319Accident · No injuriesLimited investigationFinal reportPridmore Lancair IV · Caldwell, IDThe failure of maintenance personnel to ensure that a hydraulic line fitting was adequately secured during a conditional inspection, which resulted in a leak and subsequent on-ground fire.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09CA315Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Preston, IDA loss of engine power due to fuel exhaustion that resulted from the pilot's inadequate fuel planning.NTSB WPR09CA305Accident · Minor injuriesData collectionFinal reportCessna 172M · McCall, IDA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to determine the fuel quantity prior to departure.NTSB WPR09CA225Accident · No injuriesData collectionFinal reportRans S-7 · Atomic City, IDA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.NTSB SEA08LA216Accident · No injuriesLimited investigationFinal reportBrennan RV-8 · Idaho Falls, IDThe on-ground fire during taxi due to a loose fuel line "B" nut.