NTSB investigations, ID

17 cases where NTSB found Inspection.

Cases per year

20082026
NTSB investigations, ID per year, 2008–2026: 17 cases
20082
20091
20101
20121
20131
20142
20151
20161
20172
20211
20221
20243

Latest 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\", '020615'))
  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 WPR24LA280Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Island Park, IDA loss of lateral control during takeoff due to an accumulation of water in the right wing.Aug 19, 2024 · N9166T · Substantial damageNTSB WPR24LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Weippe, IDThe pilot’s failure to secure the oil filler cap during the preflight inspection, which resulted in a precautionary landing on the soft surface and subsequent nose over.Feb 22, 2024 · N6323B · Substantial damageNTSB 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…Feb 10, 2024 · C-FLQQ · Substantial damageNTSB WPR22LA324Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBA · Athol, IDThe failure of the right brake due to a disconnected master cylinder piston rod, which led to the departure of the airplane from the runway surface. Contributing to the accident was the mechanic’s failure to adequately inspect the connection between the…Aug 23, 2022 · N9512S · Substantial damageNTSB WPR21FA283Accident · 1 fatalClass 3 · FieldFinal reportSiai-Marchetti SM-1019B · Lewiston, IDThe pilot’s failure to remove the flight control lock before departure, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was his failure to perform an adequate preflight inspection and flight control check…Jul 24, 2021 · N28U · Substantial damageNTSB WPR18FA026Accident · 1 fatalClass 2 · FieldFinal reportPiper PA 18-150 · Murphy, IDFailure of the left aileron control cable that resulted in a loss of aircraft control during takeoff. Contributing to the accident was inadequate maintenance inspections to the aileron cable connections.Nov 3, 2017 · N4393Z · Substantial damageNTSB WPR17LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA226 · Boise, IDCompany maintenance personnel's failure to remove a screwdriver that was left lodged in the windshield wiper area of the forward fuselage during maintenance and subsequently became dislodged on takeoff/initial climb and collided with a left propeller blade.Mar 20, 2017 · N158WA · Substantial damageNTSB 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.Jul 2, 2016 · N7748U · Substantial damageNTSB 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.Jul 3, 2015 · N8086C · Substantial damageNTSB WPR14LA345Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-236 · Salmon, IDMaintenance personnel’s improper surface preparation of the accessory mount pad for the installation of the engine’s dry vacuum pump, which resulted in the loss of engine oil, oil pressure, and engine power during flight. Contributing to the accident was the…Aug 13, 2014 · N2190H · Substantial damageNTSB 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.Aug 9, 2014 · N910MK · Substantial damageNTSB 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.Jun 22, 2013 · N830SS · Substantial damageNTSB 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.Sep 4, 2012 · N4798Z · Substantial damageNTSB WPR10LA483Accident · No injuriesLimited investigationFinal reportBoam Rans S-6S · Roberts, IDA loss of engine power due to the detachment of the left carburetor from the engine inlet manifold. Contributing to the accident was the pilot's failure to address a known engine vibration.Sep 18, 2010 · N4427M · Substantial damageNTSB 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.Jun 22, 2009 · N12463 · Substantial damageNTSB WPR09CA041Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Mountain Home, IDThe pilot's inadequate preflight inspection, and, his failure to properly secure the aircraft as he left the cockpit with the engine operating, which resulted in the unoccupied airplane inadvertently becoming airborne and colliding with a fence and terrain.Nov 8, 2008 · N81705 · Substantial damageNTSB LAX08LA083Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Genesee, IDThe in-flight failure of the rudder attachment point due to severe corrosion, which made directional control of the airplane not possible during landing.Mar 22, 2008 · N8148K · Substantial damage