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 GAA17CA409Accident · No injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Spicewood, TXThe pilot’s failure to retract the landing gear before landing on water.NTSB ERA17LA239Accident · No injuriesClass 3 · LimitedFinal reportCessna 210L · Wilkes-Barre/Scranton, PAFailure of the left landing gear door actuator, which resulted in a loss of all hydraulic pressure and subsequent gear collapse on landing.NTSB WPR17FA146Accident · 1 fatalField investigationFinal reportChicco Miguel E Quicksilver Sport II · Point Mugu, CAA partial loss of engine power for reasons that could not be determined during postaccident examination in combination with the low cruise altitude selected by the pilots, which resulted in an ocean ditching. The lack of personal flotation devices likely…NTSB ERA17CA236Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Lake Ashby, FLThe pilot's incorrect configuration of the landing gear for a water landing in an amphibious airplane, which resulted in a nose-over.NTSB DCA17IA148Incident · No injuriesClass 1 · IncidentFinal reportAirbus A320-211 · San Francisco, CAThe flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…NTSB GAA17CA423Accident · No injuriesData collectionFinal reportCessna T210L · Yuba City, CAThe pilot’s failure to extend the landing gear before landing.NTSB GAA17CA418Accident · No injuriesData collectionFinal reportPiper PA32 · San Antonio, TXThe pilot’s failure to extend the landing gear before touchdown.NTSB GAA17CA461Accident · No injuriesData collectionFinal reportCessna A188B · Kankakee, ILThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent incorrect brake application, which led to the loss of directional control.NTSB ERA17TA233Accident · No injuriesFinal reportLawrence O Nolte Zodiac CH650B · Dover, PAA total loss of engine power as a result of the loss of all electric fuel pumps due to a loss of electric power because of the installation of an improper battery on the airplane and the use of improper charging cables on the battery.NTSB CEN17FA252Accident · Minor injuriesField investigationFinal reportAirbus Helicopters Deutschland MBB-BK 117 B-2 · Perryville, MOFuel starvation due to the pilot’s failure to turn on the fuel transfer pump switches during takeoff, which led to a total loss of engine power. Contributing to the accident was the pilot's improper decision to activate the annunciator panel’s dimming…NTSB CEN17FA249Accident · 1 fatalField investigationFinal reportFlight Design Ctsw · Monticello, IAThe pilot's decision to fly with his large dog in the two-seat, light sport airplane, and the dog's likely contact with the flight controls during landing, which resulted in the pilot's loss of airplane control and a subsequent aerodynamic stall when the…NTSB WPR17LA136Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 310R · Santa Ana, CAThe pilot’s inability to maintain adequate airspeed after a loss of power to the right engine while maneuvering in the pattern to return to the airport. Contributing to the accident were the loss of power to the right engine for reasons that could not be…NTSB ERA17LA215Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Ocean Isle Beach, NCThe pilot's improper positioning of the fuel selector between the left and right fuel tank positions, which resulted in a partial loss of engine power due to fuel starvation and a subsequent forced landing into trees.NTSB ERA17LA217Accident · No injuriesLimited investigationFinal reportBarnes Richard B/Howe Michael Vans RV 10 · Blairsville, GAThe pilot’s loss of directional control upon landing.NTSB GAA17CA361Accident · No injuriesData collectionFinal reportCessna 182 · Doniphan, MOThe pilot’s improper decision to take off with a known fuel leak, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA17LA209Accident · No injuriesLimited investigationFinal reportHughes 369 · Dennis, WVThe unporting of fuel due to the helicopter's nose-up attitude during long line operations, which resulted in fuel starvation and a total loss of engine power.NTSB GAA17CA372Accident · No injuriesData collectionFinal reportCessna 172RG · El Cajon, CAThe pilot's failure to extend the landing gear with sufficient time to allow the landing gear to fully extend and the flight instructor's failure to visually check to see if the right main landing gear were extended.NTSB CEN17LA236Accident · Minor injuriesLimited investigationFinal reportWells John L JR Stol CH 701 · Canon City, COFuel starvation due to the deterioration of a fuel hose.NTSB CEN17LA235Accident · No injuriesLimited investigationFinal reportCessna 182A · Buffalo, OKThe separation of the nose wheel axle bolt and the nose wheel during the landing roll for reasons that could not be determined because the bolt was not recovered.NTSB ANC17LA033Accident · No injuriesClass 2 · LimitedFinal reportPiper PA 12 · Skwentna, AKThe pilot's failure to properly secure the external load, which resulted in the load shifting during flight, interference with the water rudder cable, and a subsequent loss of controlNTSB GAA17CA335Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot’s rudder overcorrection during the landing roll, which resulted in a loss of directional control.NTSB ERA17LA204Accident · No injuriesLimited investigationFinal reportPiper PA 44-180 · Gaithersburg, MDThe failure of the right main landing gear trunnion bracket due to an undetermined overstress event.NTSB CEN17LA216Accident · No injuriesLimited investigationFinal reportWilliam D Telfair/Zia Z Telfai Excalibur · Albuquerque, NMThe loss of pitch control due to the overload failure of the control rod.NTSB CEN17LA212Accident · No injuriesLimited investigationFinal reportCessna 210F · Anoka, MNThe failure of the landing gear to fully extend due to insufficient hydraulic fluid in the hydraulic system as a result of inadequate maintenance by the airplane owner.NTSB WPR17LA114Accident · No injuriesLimited investigationFinal reportTappen Chris Velocity SUV · Puyallup, WAThe airplane builder's failure to install safety wires on the brake disc attachment bolts, and the mechanic’s failure to identify the omission during the condition inspection. The subsequent brake disc separation resulted in a loss of directional control…NTSB GAA17CA314Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Logan, UTThe pilot’s failure to maintain directional control during the landing roll due to the high placement of his feet on the rudder pedals, which led to the inadvertent application of the brakes.NTSB ERA17TA196Accident · No injuriesFinal reportErnest T Christley Zenith Zodiac 601XL · Sanford, NCThe pilot’s selection of a threaded metal rod of insufficient strength to connect the fuel tank selector handle to the fuel valve, which resulted in his inability to switch fuel tanks and a subsequent total loss of engine power due to fuel starvation.NTSB WPR17FA108Accident · 2 fatalField investigationFinal reportPiper PA 30 · Haines, AKThe pilot's decision to turn toward the inoperative engine after conducting a low-level pass, which resulted in an aerodynamic stall at too low an altitude to recover. Contributing to the accident was the pilot's decision to perform the flight and the engine…NTSB GAA17CA305Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Maxwell, CAThe pilot's failure to visually check the fuel quantity during the preflight inspection and ensure that sufficient fuel was onboard for the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA205Accident · No injuriesLimited investigationFinal reportAmstutz Curtis J BD-5B · Portland, INA failure of the wiring between the engine control unit and the fuel injector, which resulted in a total loss of engine power.NTSB ERA17LA189Accident · No injuriesLimited investigationFinal reportBeech 58 · Augusta, GAThe pilot’s failure to properly configure the airplane for landing. Contributing to the accident were the pilot’s fatigue and self-induced distractions.NTSB CEN17FA196Accident · 1 fatalField investigationFinal reportPiper J3C · Chetek, WIThe pilot's failure to maintain control of the airplane while flying at a low altitude, which resulted in the airplane exceeding the critical angle of attack and a subsequent aerodynamic stall.NTSB GAA17CA306Accident · Minor injuriesData collectionFinal reportCessna 150 · Zepp, VAA partial loss of engine power due to the formation of carburetor icing, which resulted from the student pilot’s failure to apply carburetor heat and the flight instructor’s delayed response in applying carburetor heat while operating in conditions conducive…NTSB CEN17LA184Accident · No injuriesLimited investigationFinal reportMooney M20E · Dowling, MIInnacurate airspeed indications due to contamination of the pitot-static system with insect remains, which resulted in a high approach and landing speed and subsequent runway overrun.NTSB CEN17LA180Accident · Serious injuriesLimited investigationFinal reportBrokaw Bergon F Zodiac · Orangeville, ILThe total loss of engine power due to fuel starvation.NTSB WPR17LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA 18A · Coeur D'Alene, IDThe loss of yaw control due to an inadequately compressed rudder swage, which resulted from inadequate maintenance and led to the separation of the forward right rudder cable.NTSB CEN17LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Beech Grove, ARA tire failure for reasons that could not be determined, which resulted in a loss of directional control during takeoff.NTSB WPR17LA098Accident · Serious injuriesLimited investigationFinal reportRobert E Bounds Bounds Bearcoupe · Hanksville, UTThe flight instructor's failure to maintain airplane control during landing when he inadvertently applied brake pressure to the toe brakes when the airplane touched down.NTSB GAA17CA257Accident · Minor injuriesData collectionFinal reportNelson Sydney Vans Acft RV8A · Englewood, COThe pilot's improper landing flare and inadvertent selection of the mixture control, which resulted in a hard, bounced landing during gusting crosswind wind conditions.NTSB GAA17CA268Accident · No injuriesData collectionFinal reportCessna 172 · Kaunakakai, HIThe student pilot’s incorrect flap configuration during the go-around, which resulted in a hard, forced landing.NTSB GAA17CA260Accident · Minor injuriesData collectionFinal reportMooney M20 · Olathe, KSThe separated fuel tank selector knob roll pin, which prevented the fuel selector from moving to the fuel tank position for the tank with usable fuel and resulted in fuel starvation and the subsequent total loss of engine power.NTSB ANC17LA022Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Chugiak, AKA fracture and collapse of the main landing gear. Contributing to the accident was corrosion to the hydrasorb lug fitting.NTSB WPR17FA089Accident · 1 fatalField investigationFinal reportAppleby Nieuport 28 · Paso Robles, CAThe failure of unknown personnel to properly safety an elevator control cable turnbuckle, which disconnected in flight resulting in loss of pitch control. Contributing to the accident was the inadequate design of the experimental airplane, which did not…NTSB ERA17LA165Accident · No injuriesLimited investigationFinal reportGanjoo Amit Sonex · Leesburg, VAThe pilot's failure to use carburetor heat appropriately, which resulted in a total loss of engine power due to the formation of carburetor ice.NTSB ERA17LA163Accident · No injuriesLimited investigationFinal reportRobinson R44 · Orlando, FLA partial failure of the helicopter's engine tachometer due to the separation of one of the magnet assemblies and engine roughness, which precipitated the pilot’s initiation of an off-airport autorotation, during which he applied improper aft cyclic flight…NTSB WPR17LA087Accident · Serious injuriesLimited investigationFinal reportTitan Tornado I · Spanaway, WAMaintenance personnel’s improper attachment of the aileron system components, which resulted in the pilot's inability to maintain flight control.NTSB WPR17IA086Incident · No injuriesClass 3 · IncidentFinal reportBeech A36TC · Livermore, CAA mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…NTSB CEN17LA150Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201 · Pontiac, MIMaintenance personnel’s improper securing of an unused instrument lamp socket during recent maintenance, which resulted in an electrical short of the landing gear controls and stopped the landing gear while it was transitioning to the down position and led to…NTSB ERA17FA148Accident · 1 fatalField investigationFinal reportPiper PA 12 · Sanford, FLThe incorrect rigging of the elevator control cables, which resulted in a reversal of elevator control inputs applied by the pilot during the takeoff, an excessive nose-high pitch, and subsequent aerodynamic stall after takeoff. Also causal was the inadequate…NTSB GAA17CA224Accident · No injuriesData collectionFinal reportStinson 108 · Woodruff, WIThe pilot receiving instruction's incorrect brake usage and failure to maintain directional control during the landing roll.