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.

NTSB ERA13LA276Accident · No injuriesLimited investigationFinal reportCessna 170 · Plainville, CTThe pilot’s overflight of the landing runway during a forced landing after a loss of engine power. Contributing to the accident was the pilot’s inadequate preflight which resulted in his failure to detect water contamination of the fuel system.Jun 9, 2013 · N2585V · Substantial damageNTSB ERA13FA275Accident · 1 fatalField investigationFinal reportCessna 340A · Boynton Beach, FLThe pilot’s loss of situational awareness, which resulted in an inadvertent aerodynamic stall/spin after he climbed the airplane back into instrument meteorological conditions (IMC). Contributing to the accident was the pilot’s improper decision to continue…Jun 8, 2013 · N217JP · DestroyedNTSB WPR13LA262Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Burlington, WAThe failure of the rudder bar assembly during landing due to a fatigue crack. Contributing to the accident was the failure of maintenance personnel to perform an adequate inspection of the rudder bar assembly.Jun 4, 2013 · N5808U · Substantial damageNTSB ERA13IA267Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tallahassee, FLThe failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.Jun 3, 2013 · N633TC · No damageNTSB CEN13CA315Accident · No injuriesData collectionFinal reportCub Crafters CCK · Cookson, OKA total loss of engine power due to water contamination in the fuel. Contributing to the accident was the pilot's failure to check the fuel during the preflight, and failure to check the fuel storage tank’s fuel filter/water separator.Jun 3, 2013 · N319MA · Substantial damageNTSB CEN13LA330Accident · No injuriesLimited investigationFinal reportCessna TP206B · Sturgeon Bay, WIThe pilot’s improper reselection of the left fuel tank, which had an obstructed vent system and resulted in a total loss of engine power during the approach for landing.Jun 1, 2013 · N3350J · Substantial damageNTSB WPR13CA259Accident · No injuriesData collectionFinal reportDressen Escape LS · Fruitland, IDThe pilot’s failure to maintain airplane control during the landing roll as a result of the parking brake lever not being positioned in the full off position.May 26, 2013 · N3932D · Substantial damageNTSB CEN13CA319Accident · No injuriesData collectionFinal reportCessna TR182 · Emporia, KSThe pilot's failure to lower the landing gear prior to landing.May 25, 2013 · N757QT · Substantial damageNTSB WPR13LA237Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chandler, AZThe failure of the alternator and/or battery, which prevented the operation of the landing gear extension system and resulted in the nose landing gear collapsing during the landing roll.May 19, 2013 · N8197W · Substantial damageNTSB ANC13LA049Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Big Lake, AKThe pilot’s execution of a hard landing, which resulted in the overstress fracture of the right main axle housing and the subsequent nosedown.May 19, 2013 · N56464 · Substantial damageNTSB DCA13FA094Accident · No injuriesField investigationFinal reportBombardier DHC8 · Newark, NJthe frozen left main landing gear (MLG) uplock roller due to lack of lubrication and the uplock latch that had worn beyond acceptable tolerances, which prevented the flight crew from extending the left MLG using the alternate extension system. Contributing to…May 18, 2013 · N934HA · Substantial damageNTSB CEN13IA285Incident · No injuriesIncident investigationFinal reportCirrus SR22 · Dallas, TXThe failure of the airplane’s parachute to deploy when activated during a loss of control in cruise flight due to the dynamic maneuvering of the airplane at the time of the activation, which exceeded the parachute system’s certification requirements.May 16, 2013 · N715CD · No damageNTSB ERA13CA244Accident · No injuriesData collectionFinal reportCessna 170B · Roxboro, NCThe pilot’s excessive use of wheel brakes while turning off the runway after landing resulting in a noseover.May 13, 2013 · N3115B · Substantial damageNTSB CEN13LA304Accident · Minor injuriesLimited investigationFinal reportAnkestar, Bradley D. RAND-ROBINSON KR2 · Hamilton, OHThe loss of engine power due to vapor lock in the fuel system. Contributing to the accident was the operation of the airplane with automotive gasoline and the installation of noninsulated fuel components near heat sources in the engine compartment.May 11, 2013 · N774A · Substantial damageNTSB CEN13LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT-302 · Winnie, TXThe improper decision by the pilot to attempt a flight with a known fuel system-related maintenance discrepancy, which resulted in a fuel imbalance and subsequent fuel starvation during an approach to an alternate airport with a rough field. Contributing to…May 9, 2013 · N3650B · Substantial damageNTSB WPR13LA238Accident · No injuriesLimited investigationFinal reportCessna 310R · Bakersfield, CAThe failure of the right main landing gear link assembly, which resulted in the right main landing gear collapsing during landing.May 8, 2013 · N6096C · Substantial damageNTSB WPR13LA216Accident · Minor injuriesLimited investigationFinal reportRans S-17 · Fontana, CAA loss of engine power due to improper construction and inadequate maintenance of the fuel system and engine. Contributing to the accident was the airplane’s inadvertent contact with an unseen guy wire during the landing flare.May 4, 2013 · N6171R · Substantial damageNTSB ERA13LA229Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Erwinna, PAThe pilot’s loss of glider control due to improper rigging of the rudder control cables, the mechanic’s inadequate flight control checks following the glider’s most recent annual inspection, and the pilot’s failure to perform a thorough preflight inspection.May 4, 2013 · N2045T · Substantial damageNTSB WPR13LA217Accident · No injuriesLimited investigationFinal reportRobinson R44 II · Pomeroy, WAThe pilot's failure to ensure that the helicopter was properly loaded, which resulted in the helicopter being in excess of its maximum allowable gross weight and led to a loss of main rotor rpm on takeoff. Contributing to the accident were the ground…May 2, 2013 · N442RN · Substantial damageNTSB WPR13LA214Accident · No injuriesLimited investigationFinal reportCessna 421A · Oakland, CAA failure of the left main landing gear pivot bolt in overstress during landing.May 1, 2013 · N216WA · Substantial damageNTSB DCA13MA081Accident · 7 fatalClass 1 · MajorFinal reportBoeing 747-400 BCF · Bagram, AfghanistanNational Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…Apr 29, 2013 · N949CA · DestroyedNTSB WPR13CA207Accident · No injuriesData collectionFinal reportWaco YKS-7 · Rialto, CAThe pilot’s failure to maintain directional control and his improper brake usage during the landing roll in a crosswind condition.Apr 26, 2013 · N17472 · Substantial damageNTSB ERA13LA224Accident · No injuriesLimited investigationFinal reportCessna 140A · Newburgh, NYThe pilot’s failure to maintain directional control when the brakes bound and a subsequent ground loop. Contributing to the accident was the inadequate maintenance of the brakes by the pilot/owner.Apr 26, 2013 · N5314C · Substantial damageNTSB CEN13LA245Accident · No injuriesLimited investigationFinal reportRaytheon G36 · Hoxie, KSThe loss of engine power due to fuel starvation for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Apr 26, 2013 · N222GL · Substantial damageNTSB CEN13IA270Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Clearwater, FLThe failure of the nose landing gear steering manifold during landing, which resulted in an uncommanded and uncontrollable right turn, and the overhaul facility’s improper overhaul of the nose landing gear steering manifold.Apr 24, 2013 · N139SL · Minor damageNTSB ANC13CA046Accident · No injuriesData collectionFinal reportCessna U206G · Nenana, AKIce accretion in the right main landing gear wheel brake during departure, which prevented the right main landing gear from rotating on landing and resulted in a runway excursion and subsequent impact with a snow bank.Apr 24, 2013 · N756DJ · Substantial damageNTSB WPR13LA212Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Santa Rosa, CAThe partial loss of engine power due to fuel contamination and partially blocked fuel screens.Apr 20, 2013 · N985SS · Substantial damageNTSB ERA13CA206Accident · Minor injuriesData collectionFinal reportPoole Robert C JR Van's · Salisbury, NCThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent decision to exit the paved runway onto the soft terrain.Apr 17, 2013 · N439RP · Substantial damageNTSB ERA13CA207Accident · No injuriesData collectionFinal reportCessna A185F · Palatka, FLThe pilot’s failure to retract the landing gear after takeoff from a runway, and his subsequent water landing with the wheels extended.Apr 16, 2013 · N812F · Substantial damageNTSB WPR13CA193Accident · No injuriesData collectionFinal reportCessna 210B · Caldwell, IDThe pilot’s failure to lower the landing gear, which resulted in a gear-up hard landing.Apr 15, 2013 · N9685X · Substantial damageNTSB CEN13CA302Accident · Serious injuriesData collectionFinal reportJans Robert Falcon XP · Diboll, TXThe pilot did not properly secure a sand bag in the airplane's rear seat causing its flight controls to become jammed and resulting in the airplane's inability to avoid a collision with power lines.Apr 15, 2013 · N86FB · DestroyedNTSB ANC13CA038Accident · No injuriesData collectionFinal reportBeech A36 · Port Alsworth, AKThe failure of the left main landing gear retraction brace assembly, resulting in the collapse of the left main landing gear.Apr 15, 2013 · N1820L · Substantial damageNTSB CEN13LA231Accident · No injuriesLimited investigationFinal reportNeedham Stoddard-Hamilton TD · Bloomington, INThe improper installation of a rudder control cable connector and its subsequent separation from the bellcrank, which resulted in the loss of directional control during takeoff.Apr 14, 2013 · N95RL · Substantial damageNTSB WPR13LA190Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · San Manuel, AZA loss of engine power due to fuel starvation during the landing approach. Contributing to the accident was the pilot’s failure to follow the emergency checklist and switch tanks. Contributing to the severity of the pilot's injuries was the lack of a shoulder…Apr 13, 2013 · N6841Q · Substantial damageNTSB CEN13CA226Accident · No injuriesData collectionFinal reportEdward W Gray Lancair 360 · Alexandria, LAThe pilot's failure to attain the proper touchdown point, and his decision to continue the landing, which resulted in a runway excursion.Apr 13, 2013 · N77ZG · Substantial damageNTSB WPR13LA189Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Santa Monica, CAThe left main wheel locking up during the landing roll, which resulted in the deflation of the tire, the left main landing gear collapse, and the subsequent loss of control during the runway exit.Apr 12, 2013 · N153NL · Substantial damageNTSB ERA13CA310Accident · No injuriesData collectionFinal reportSchleicher Alexander ASH 26 E · Tullahoma, TNThe pilot's improper use of wing spoilers during approach resulting in an altitude loss and collision with a tree.Apr 12, 2013 · N26EL · Substantial damageNTSB CEN13LA225Accident · Minor injuriesLimited investigationFinal reportAtkins ACRO-SPORT I · Midland, LAThe failure of the left elevator torque tube due to poor quality welds by the manufacturer, which resulted in the loss of pitch control.Apr 12, 2013 · N5897 · Substantial damageNTSB ERA13LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Winston Salem, NCFatigue failure of the right main landing gear attach bolts due to an unreported hard landing at an unknown time, and subsequent collapse of the landing gear.Apr 7, 2013 · N3060B · Substantial damageNTSB WPR13CA228Accident · No injuriesData collectionFinal reportSocata TBM 700 · Sandy Valley, NVThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.Apr 6, 2013 · N751J · Substantial damageNTSB ERA13LA191Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Hammonton, NJA loss of control during landing due to the failure of the nose landing gear's left trunnion lug.Apr 5, 2013 · N37480 · Substantial damageNTSB ERA13IA192Incident · No injuriesIncident investigationFinal reportEmbraer EMB-500 · Meridian, MSThe failure of the main landing gear brake system’s antiskid system, which resulted in locked wheels during landing.Apr 5, 2013 · N196EC · No damageNTSB ERA13LA188Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe disconnection of the nose landing gear actuator, which resulted in the subsequent collapse of the nose landing gear. Contributing to the accident was the repair station’s inadequate maintenance, postmaintenance inspection process, and oversight of the…Apr 1, 2013 · VQ-TIN · Substantial damageNTSB CEN13LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonewoc, WIThe restricted vented fuel cap and obstructed fuel vent lines, which resulted in a total loss of engine power due to fuel starvation.Apr 1, 2013 · N8033B · Substantial damageNTSB ERA13LA183Accident · 1 fatalLimited investigationFinal reportAndrews Zodiac · Collegedale, TNThe pilot's failure to ensure that his seatbelt was fastened and the pilots' failure to ensure that the canopy was latched properly, which resulted in the pilot's ejection from the cockpit following the opening of the canopy and the subsequent in-flight upset.Mar 29, 2013 · N999NA · Minor damageNTSB ENG13IA020Incident · No injuriesIncident investigationFinal reportEmbraer ERJ-145 · Houston, TXThe uncommanded left deflection of the airplane's nose wheel due to a malfunction of the electrohydraulic servo valve (EHSV) within the nose wheel steering manifold assembly. The reason for the malfunction could not be determined; however, a foreign substance…Mar 29, 2013 · N12922 · No damageNTSB CEN13LA212Accident · Minor injuriesLimited investigationFinal reportCirrus SR22T · Alexandria, MNThe failure of maintenance personnel to install a safety wire during reinstallation of the right flap, which led to the separation of the right flap rod from the right flap actuation fitting during flap extension. Contributing to the accident were inadequate…Mar 29, 2013 · N1967N · Substantial damageNTSB CEN13LA208Accident · No injuriesLimited investigationFinal reportCessna 421C · Amarillo, TXMaintenance personnel's failure to detect the misadjustment of the left landing gear actuator's switch after recent maintenance, which prevented the landing gear from locking in the extended position and resulted in the landing gear collapsing during landing.Mar 27, 2013 · N805DC · Substantial damageNTSB CEN13CA207Accident · No injuriesData collectionFinal reportBeech A36 · Fort Stockton, TXThe student pilot inadvertently switching the fuel selector to the OFF position and the flight instructor's failure to monitor the student pilot's actions.Mar 27, 2013 · N888TT · Substantial damageNTSB CEN13LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe failure of the nose landing gear fork during landing due to fatigue.Mar 26, 2013 · N48693 · Substantial damage