NTSB investigations
3,633 cases where NTSB found Aircraft systems.
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\", '0102')) 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", '0102')) 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 CEN20LA179Accident · 1 fatalClass 3 · LimitedFinal reportCessna P210 · Burlington, WIThe pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.NTSB ERA20LA179Accident · 1 fatalClass 3 · LimitedFinal reportBeech F33 · Land O Lakes, FLThe partial loss of engine power due to a contaminated fuel system and the pilot’s improper decision to attempt a takeoff with a known deficiency in engine power.NTSB 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.NTSB CEN20LA175Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · San Antonio, TXThe failure of the left main landing gear upper drag leg arm due to substandard mechanical properties, which resulted in a collapse of the landing gear upon landing.NTSB ERA20CA175Accident · No injuriesClass 4 · Data collectionFinal reportWaco QCF · Shirley, NYThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a nose over.NTSB ERA20CA171Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20K · Athens, GAThe collapse of the left main landing gear for reasons that could not be determined based on the available information.NTSB ENG20LA031Incident · No injuriesClass 3 · LimitedFinal reportAirbus Helicopters AS350 · Clewiston, FLSeizure of the hydraulic pump pulley bearing due to its improper installation by the manufacturer, leading to a failure of the hydraulic pump belt and the resultant partial loss of hydraulic assistance to the pedals.NTSB ERA20CA168Accident · No injuriesClass 4 · Data collectionFinal reportDayton-Wright DH-4 · Bowling Green, KYA primary control (aileron) system anomaly that progressively worsened during a test flight that resulted in a loss of control. The reason for the anomaly was not determined due to impact damage.NTSB ANC20CA045Accident · No injuriesClass 4 · Data collectionFinal reportGrumman G44 · Anchorage, AKThe pilot's failure to extend the landing gear for a runway landing, which resulted in a gear-up landing.NTSB WPR20LA135Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-23-250 · Hemet, CAMaintenance personnel’s failure to properly inspect and replace damaged aileron control cables, which resulted in fatigue separation of the aileron control cable and loss of control of the aircraft.NTSB CEN20CA164Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna A185 · Anoka, MNThe pilot's inadvertent extension of the landing gear and his subsequent water landing with the wheels extended.NTSB ERA20LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32RT · Meridianville, ALThe pilot's slip maneuver with a less than full fuel tank selected, which resulted in unporting of the fuel supply, and a total loss of engine power due to fuel starvation.NTSB 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…NTSB DCA20LA100Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S61 · Camp Dwyer, AfghanistanFatigue cracking of the auxiliary servo cylinder’s pedal damper check valve housing and its bolts, which caused the sudden and uncommanded movement of the helicopter’s left pedal and a subsequent left yaw that continued until ground impact. Contributing to…NTSB WPR20LA126Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Corona, CAThe pilot's failure to use carburetor heat while operating in conditions conducive to serious carburetor icing, which resulted in a total loss of engine power.NTSB ANC20CA044Accident · No injuriesData collectionFinal reportPiper PA31 · Buckland, AKThe pilot's failure to extend the landing gear before landing due to distraction by the condition of the runway and his failure to use the Before Landing checklist.NTSB ERA20CA152Accident · No injuriesData collectionFinal reportHolmgren Bearhawk · Ahoskie, NCThe collapse of the right main landing gear during a bounced, crosswind landing.NTSB CEN20LA148Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Cincinnati, OHA loose fuel inlet fitting on the fuel pump due to improper maintenance, which resulted in a total loss of engine power.NTSB ANC20CA042Accident · No injuriesData collectionFinal reportPiper PA18 · Homer, AKThe pilot's overapplication of the brakes during landing and the subsequent loss of directional control and nose-over.NTSB WPR20LA119Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Hillsboro, ORThe total loss of engine power during takeoff due to the delamination of the fuel servo induction air inlet duct tube.NTSB CEN20CA128Accident · No injuriesData collectionFinal reportCessna 172 · Denver, COThe pilot's incorrect right rudder application during a touch-and go-landing, which resulted in a loss of directional control, runway excursion, and a collision with a runway sign.NTSB ERA20LA129Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Conway, SCThe pilot’s incorrect use of the autopilot while approaching the initial approach fix and his subsequent improper primary pitch control input while a pitch mode of the autopilot was engaged, which resulted in pitch excursions and subsequent departure from…NTSB ERA20CA130Accident · No injuriesData collectionFinal reportCessna 172 · West Palm Beach, FLThe failure of the nosewheel steerage linkage during takeoff, which resulted in a loss of directional control and impact with an obstacle during an attempted aborted landing.NTSB ERA20LA126Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Beverly, MAA loss of engine power due to carburetor icing, and the student pilot’s failure to utilize carburetor heat in conditions conducive to carburetor icing.NTSB WPR20CA112Accident · No injuriesData collectionFinal reportDe Havilland DHC6 · Boulder City, NVThe trainee pilot's loss of directional control during landing and his subsequent unintentional control interference with the brakes and/or rudder during the trainer pilot's attempted remedial action, which resulted in a runway excursion and collision with a…NTSB ERA20LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Albemarle, NCThe pilots' failure to ensure that the electric fuel pumps were on before takeoff, which resulted in a partial loss of power on both engines during initial climb.NTSB CEN20CA114Accident · No injuriesData collectionFinal reportVans RV8 · Harrison, OHThe malfunction of the steerable tailwheel, which resulted in a loss of directional control during the landing roll and subsequent impact with the precision approach path indicator lights system.NTSB ANC20CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Big Lake, AKThe pilot's failure to use carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with snow.NTSB 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…NTSB WPR20CA103Accident · No injuriesData collectionFinal reportCubCrafters FX-3 · Sonoma/Schellville, CAThe pilot's inadvertent activation of the left brake during the landing roll, which resulted in a loss of directional control, a runway excursion, and collision with a ditch.NTSB CEN20FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Rogers, MNInadequate maintenance that resulted in improper torque to the engine-driven fuel pump inlet fitting, which led to a loss of engine power and forced landing into unsuitable terrain.NTSB ANC20FA024Accident · 2 fatalClass 3 · FieldFinal reportCessna 305 · Mokuleia, HIA separation of the left rudder cable due to inadequate maintenance, which resulted in an in-flight loss of control and impact with terrain.NTSB ERA20CA125Accident · No injuriesData collectionFinal reportCessna 510 · Daytona Beach, FLThe pilot's failure to lower the landing gear before landing. Contributing to the accident was the examiner’s failure to check that the landing gear was extended.NTSB CEN20LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Chesterfield, MOThe flight instructor’s and student pilot’s failure to ensure that the landing gear was extended before landing.NTSB ERA20LA109Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell 112 · Knoxville, TNA loss of directional control during landing following deflation of a flat-spotted tire for reasons that could not be determined based on available evidence.NTSB ENG20LA016Incident · No injuriesClass 3 · LimitedFinal reportAirbus A319 · Sacramento, CAA worn component within each engine integrated drive generator (IDG) resulted in the loss of electrical power supplied to several flight deck displays and systems while on approach to landing. The component, a fixed cylinder block, had significant wearing of…NTSB CEN20CA087Accident · No injuriesData collectionFinal reportVans RV8 · Columbus, MSThe inadvertent engine start of the unoccupied airplane, which resulted in it moving forward and impacting a hangar and an electrical box.NTSB CEN20LA078Accident · Serious injuriesClass 3 · LimitedFinal reportNavion Navion · Fort Smith, ARThe inadequate inspection of the fuel selector valve, which was degraded, allowed fuel to leak, and resulted in fuel starvation and a loss of engine power.NTSB CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.NTSB ERA20CA103Accident · No injuriesData collectionFinal reportPiper PA28RT · Fort Myers, FLThe fracture of the right main landing gear torque link bolt on landing, which resulted in the landing gear assembly rotating freely, the subsequent loss of directional control, and the landing gear collapsing.NTSB CEN20LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Woody Creek, COWater trapped in the static system, which resulted in incorrect airspeed display information and the pilot’s forced landing.NTSB DCA20MA059Accident · 9 fatalClass 1 · MajorFinal reportSikorsky S76 · Calabasas, CAThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure…NTSB WPR20CA080Accident · No injuriesClass 4 · Data collectionFinal reportMerwin Kitfox · Goodyear, AZThe tail wheel mechanism detachment for reasons that could not be determined due to the lack of available evidence which resulted in the loss of directional control on landing.NTSB ERA20LA089Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Summerland Key, FLThe pilot's failure to remove the flight control gust lock before takeoff, which resulted in an inability to rotate, aborted takeoff, and subsequent runway overrun. Contributing to the accident was a missing piece of the flight control gust lock, which did…NTSB WPR20FA072Accident · 4 fatalClass 3 · FieldFinal reportBeech B36TC · Corona, CAThe pilots’ failure to abort the takeoff, which resulted in a collision with a fence at the end of the runway. Contributing to the accident was the airplane being at or over the maximum gross takeoff weight and the inappropriate elevator trim tab setting.NTSB WPR20CA074Accident · Minor injuriesData collectionFinal reportPiper PA-18 Replica · Jean, NVThe pilot's inadvertent application of the brakes during the landing roll, which resulted in a nose-over.NTSB ERA20CA091Accident · No injuriesData collectionFinal reportCessna 185 · Laytonsville, MDThe failure of the tailwheel attachment tube during the takeoff roll, which resulted in a loss of directional control, a runway excursion, and the left main landing gear collapsing.NTSB CEN20LA063Accident · Serious injuriesClass 3 · LimitedFinal reportPiel CP301 · Paulding, OHThe pilot’s failure to maintain control of the airplane following the loss of engine power. The loss of engine power was the result of fuel starvation due to the degraded fuel tank and fuel contamination.NTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…NTSB ERA20CA081Accident · Minor injuriesData collectionFinal reportPereyra Aventura · East Palatka, FLThe pilot's failure to properly configure the amphibious airplane for a water landing, which resulted in it flipping over.