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 ERA23LA170Accident · No injuriesClass 4 · LimitedFinal reportNorth American T-6G · Lakeland, FLA loss of control on the ground as a result of left tailwheel steering cable separation.Mar 29, 2023 · N791MH · Substantial damageNTSB WPR23LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Springfield, KYThe pilot’s failure to activate the pitot heat in a timely manner during flight into icing conditions, which resulted in a temporary failure of the flight instruments and a subsequent loss of control.Mar 24, 2023 · N146MS · Substantial damageNTSB ERA23LA179Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18AS-125 · Lakeland, FLThe pilot’s failure to ensure that the landing gear was properly configured for a water landing.Mar 22, 2023 · N1907A · Substantial damageNTSB WPR23LA130Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander 100-180 · Gordonville, TXA fatigue fracture of the nose landing gear scissor link, which resulted in a separation of the nose landing gear piston assembly.Mar 18, 2023 · N4064X · Substantial damageNTSB CEN23FA139Accident · 1 fatalClass 3 · FieldFinal reportBeech 58P · Lubbock, TXThe pilot’s failure to ensure a proper fuel selector position before takeoff, which resulted in a loss of left engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain airplane control after the loss of left engine…Mar 17, 2023 · N2061K · DestroyedNTSB ERA23LA166Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Cleveland, TNThe retraction of the landing gear after landing for unknown reasons.Mar 16, 2023 · N8702 · Substantial damageNTSB WPR23LA136Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Spanish Fork, UTThe retraction of the main landing gear for undetermined reasons.Mar 15, 2023 · N2572V · Substantial damageNTSB CEN23LA135Accident · No injuriesClass 3 · LimitedFinal reportBell Helicopter Textron APT70 · Mineral Wells, TXThe flight crew’s loss of control of the unmanned aircraft due to software limitations. Contributing to the accident was the overly restrictive low voltage threshold limits.Mar 14, 2023 · N314AL · Substantial damageNTSB CEN23LA130Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · De Kalb, TXThe pilot’s inability to maintain control of the helicopter due to his failure to maintain rotor speed. Contributing to the accident was the failure of the helicopter’s low rotor speed warning system.Mar 11, 2023 · N4164T · Substantial damageNTSB ERA23FA137Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Lindenhurst, NYAn in-flight fire due to a compromised oil pressure line fitting, which resulted in a collision with terrain during a subsequent emergency landing.Mar 5, 2023 · N8149R · DestroyedNTSB ERA23FA136Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-150 · Blue Ridge, GAA loss of engine power due to fuel starvation due to the improper positioning of the fuel selector.Mar 5, 2023 · N3410Z · Substantial damageNTSB ERA23LA135Accident · 1 fatalClass 2 · LimitedFinal reportBombardier BD-100-1A10 · Windsor Locks, CTThe flight crew’s failure to remove the right side pitot probe cover before flight, their decision to depart with a No-Go advisory message following an aborted takeoff, and their selection of the incorrect non-normal checklist in flight, which resulted in an…Mar 3, 2023 · N300ER · Minor damageNTSB ERA23LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Slaughters, KYMaintenance personnel’s failure to secure the fuel strainer bowl with safety wire, which resulted in the fuel strainer bowl leaking and starving the engine of fuel. Also causal was the obstruction of two fuel injector nozzles.Mar 2, 2023 · N9420N · Substantial damageNTSB ERA23LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 182S · Labelle, FLA malfunction of the airplane’s right main wheel brake, which resulted in a loss of control and runway excursion during landing.Feb 28, 2023 · N397ME · Substantial damageNTSB ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.Feb 28, 2023 · N945HS · Substantial damageNTSB WPR23MA113Accident · 5 fatalClass 2 · MajorFinal reportPilatus PC-12/45 · Stagecoach, NVThe pilot’s loss of control due to spatial disorientation while operating in night instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the disengagement of the autopilot for undetermined reasons, as…Feb 25, 2023 · N273SM · Substantial damageNTSB DCA23LA191Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ 190-100 IGW · New York, NYElectrical sparking caused by a faulty connection between the aircraft and ground power unit resulting in a serious injury to a ground service agent.Feb 25, 2023 · N337JB · No damageNTSB WPR23LA116Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · San Jose, CAA landing gear collapse due to an inadequately maintained landing gear extension and retraction system.Feb 20, 2023 · N9267P · Substantial damageNTSB CEN23LA116Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Grand Prairie, TXThe pilot’s failure to extend the landing gear before landing.Feb 20, 2023 · N4210D · Substantial damageNTSB ERA23LA129Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Chatham, MAThe pilot’s failure to lower the landing gear before touchdown.Feb 19, 2023 · N711PD · Substantial damageNTSB ERA23LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Buckhannon, WVA total loss of engine power due to fuel starvation. Contributing was the pilot’s decision to depart on the flight with an inoperative fuel selector valve.Feb 18, 2023 · N6597X · Substantial damageNTSB CEN23LA110Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado II · Windom, MNThe fatigue failure of the right landing gear leg that resulted in its separation from the airplane during takeoff.Feb 18, 2023 · N9168P · Substantial damageNTSB CEN23LA115Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Cahokia, ILThe pilot’s failure to extent the landing gear before landing.Feb 15, 2023 · N7681F · Substantial damageNTSB ERA23LA124Accident · Serious injuriesClass 3 · LimitedFinal reportCanton Paul A RV-6 · Milton, FLThe incorrect installation of the fuel pickups, which resulted in a total loss of engine power due to fuel starvation. Contributing was the lack of documentation of the airplane’s unusable fuel.Feb 6, 2023 · N330PC · Substantial damageNTSB CEN23LA103Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 425 · Bismarck, NDA loss of braking due to inadequate servicing of brake fluid by the pilot/mechanic, which resulted in a loss of airplane control on the ground.Feb 6, 2023 · N425Z · Substantial damageNTSB DCA23FA149Incident · No injuriesClass 1 · FieldFinal reportBoeing 737-79P · Austin, TXthe local controller’s incorrect assumption that the Southwest Airlines (SWA) airplane would depart from the runway before the Federal Express airplane arrived on the same runway, which resulted in a loss of separation between both airplanes. Contributing to…Feb 4, 2023 · N7827A · 2 aircraft · No damageNTSB CEN23LA101Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7ACA · Bayport, MNThe pilot’s poor inflight fuel monitoring that resulted in a total loss of engine power due to fuel starvation.Feb 4, 2023 · N9111L · Substantial damageNTSB WPR23LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Hayden, IDThe failure of the right main landing gearbox assembly due to fatigue cracking, which resulted in a loss of directional control during the landing roll.Jan 31, 2023 · N9235B · Substantial damageNTSB ERA23LA121Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Brinkman Lancair 4P · Hartford, CTThe pilot’s takeoff with a significant fuel imbalance, which resulted in the airplane lacking the roll authority to overcome the left rolling tendency and subsequently impacting terrain. Contributing to the accident was the pilot’s inadequate preflight…Jan 28, 2023 · N550LX · Substantial damageNTSB WPR23LA097Accident · No injuriesClass 3 · LimitedFinal reportKaman Aerospace K-1200 · Sweet Home, ORImproper installation of the hardware retaining the adjustment screw in the N2 topping governor lever and roller assembly, which resulted in a partial loss of engine power.Jan 24, 2023 · N202WM · Substantial damageNTSB WPR23LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Mesa, AZThe pilot’s failure to maintain directional control during the landing roll out and the preexisting fatigue cracks in the left main landing gear leg, which resulted in the leg’s premature overstress fracture during the ground loop.Jan 23, 2023 · N9534A · Substantial damageNTSB WPR23FA092Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Modesto, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain proper airspeed during a turn to final, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction…Jan 18, 2023 · N4765G · Substantial damageNTSB ERA23LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-31-350 · Middlefield, OHA runway overrun during a precautionary landing following a total loss of right engine power due to detonation and subsequent oil starvation. Contributing was the pilot’s failure to lower the flaps and the excessive airspeed at touchdown.Jan 18, 2023 · N101MA · Substantial damageNTSB DCA23LA125Incident · No injuriesClass 1 · LimitedFinal reportBoeing 737-900ER · Queens, NYThe American Airlines flight 106 (AAL106) crew’s surface navigation error due to distractions caused by their performance of concurrent operational tasks during taxi, which resulted in a loss of situational awareness. Contributing to the incident was the air…Jan 14, 2023 · N914DU · 2 aircraft · No damageNTSB CEN23LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPitts Model 12 · Conroe, TXThe failure of the engine-driven fuel pump, which resulted in a total loss of engine power. Contributing to the failure of the fuel pump was an unknown non-ferrous metallic debris that was noted throughout the airplane’s fuel system.Jan 14, 2023 · N512P · Substantial damageNTSB ERA23LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · Atlantic Ocean, Turks & Caicos IslandsA fuel system malfunction for reasons that could not be determined, which resulted in fuel starvation to both engines.Jan 3, 2023 · N824BC · Substantial damageNTSB WPR23FA080Accident · 1 fatalClass 3 · FieldFinal reportEmbraer Executive EMB-505 · Provo, UTThe pilot’s failure to deice the airplane before takeoff in weather conditions conducive to ice accumulation, which resulted in an ice-contaminated wing and subsequent stall during takeoff.Jan 2, 2023 · N555NR · Substantial damageNTSB WPR23LA078Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Boulder City, NVThe pilot’s failure to apply anti-torque pedal input in a sufficient, timely, and sustained manner while attempting to arrest a turn during a hover-taxi, which resulted in a loss of directional control. Contributing to the severity of the occupants’ injuries…Dec 28, 2022 · N835GC · Substantial damageNTSB WPR23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 210N · Morgan, UTFailure of the brake system O-rings on the left landing gear trunnion, which allowed the hydraulic fluid to drain from the left brake system, resulting in a runway excursion and impact with a fence.Dec 26, 2022 · N210CU · Substantial damageNTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.Dec 21, 2022 · N321GD · Substantial damageNTSB ERA23LA091Accident · Minor injuriesClass 3 · LimitedFinal reportCessna R172K · Brooksville, FLA hard landing that fractured the nose landing gear assembly, resulting in a loss of directional control and a nose-over.Dec 16, 2022 · N5405V · Substantial damageNTSB ERA23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Lexington, KYA main landing gear collapse due to a landing gear actuator overtravel for reasons that could not be determined.Dec 15, 2022 · N3844C · Substantial damageNTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…Dec 15, 2022 · N13GZ · Substantial damageNTSB ERA23LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Alabaster, ALFailure of the tailwheel locking mechanism, which resulted in a loss of control during landing and a runway excursion.Dec 10, 2022 · N5301G · Substantial damageNTSB ERA23LA075Accident · No injuriesClass 3 · LimitedFinal reportGates Lear Jet 36 · Newport News, VAA left main landing gear tire rupture during takeoff, which resulted in a runway overrun.Nov 30, 2022 · N12FN · Substantial damageNTSB CEN23FA045Accident · No injuriesClass 3 · FieldFinal reportCirrus Design SF50 · Mount Comfort, INThe uncommanded activation of the CAPS autopilot mode due to corrosion of the system’s electrical components. Contributing to the accident was the pilot’s failure to identify the CAPS autopilot mode and promptly follow the procedures in the airplane flight…Nov 25, 2022 · N15VJ · Substantial damageNTSB ERA23LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Manassas, VAAn engine fire caused by chafing and subsequent electrical arcing of the alternator wire near a fuel source.Nov 18, 2022 · N8129M · Substantial damageNTSB CEN23LA037Accident · Minor injuriesClass 3 · LimitedFinal reportFairchild SA227-AT · Pewaukee, WIThe flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…Nov 15, 2022 · N247DH · Substantial damageNTSB CEN23LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manchester, MIA partial loss of engine power as a result of carburetor ice.Nov 13, 2022 · N222UM · Substantial damageNTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…Nov 4, 2022 · N150NE · Substantial damage