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 WPR23LA321Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Napa, CAInsufficient hydraulic pressure to the landing gear system following the completion of the emergency gear extension checklist, which resulted in the main landing gear collapsing during landing. Contributing to the accident was a loss of electrical power for…Aug 21, 2023 · N6535B · Substantial damageNTSB DCA23FA417Accident · No injuriesClass 2 · FieldFinal reportBoeing 737-890 · Santa Ana, CAMaintenance personnel’s excessive grinding of the left main landing gear’s aft trunnion pin during machining, which imparted heat damage to the base metal and led to the fatigue cracking that caused the pin to fracture during landing.Aug 21, 2023 · N516AS · Substantial damageNTSB CEN23LA403Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Wheeling, ILA loss of braking effectiveness during landing for reasons that could not be determined, which resulted in a runway excursion.Aug 21, 2023 · N39TT · Substantial damageNTSB ERA23LA345Accident · No injuriesClass 4 · LimitedFinal reportWaco UPF-7 · Warrenton, VAA ground loop during landing resulting from a partial separation of the right main landing gear strut during takeoff.Aug 20, 2023 · N39721 · Substantial damageNTSB CEN23LA363Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C-99 · Lansing, MIThe pilot’s failure to properly set the rudder trim position which resulted in a loss of directional control during takeoff. Contributing was the pilot’s inadequate checklist procedures prior to takeoff.Aug 15, 2023 · N261SW · Substantial damageNTSB ERA23LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · North Myrtle Beach, SCThe pilot’s failure to properly secure the left wing fuel cap, which resulted in a loss of engine power due to fuel exhaustion.Aug 13, 2023 · N22RE · Substantial damageNTSB ERA23LA337Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Haines City, FLA total loss of engine power due to fuel starvation for reasons that could not be determined.Aug 12, 2023 · N898CP · Substantial damageNTSB CEN23FA359Accident · 1 fatalClass 3 · FieldFinal reportVans RV14 · Virden, ILThe pilot/builder’s improper configuration of the canopy latch micro switch, which incorrectly signaled a closed canopy before flight that resulted in an inflight opening of the airplane’s canopy, an upset of the airplane, and a loss of control from which the…Aug 12, 2023 · N6161 · Substantial damageNTSB CEN23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Chillicothe, MOThe pilot’s decision to operate the airplane with a known tailwheel anomaly, which resulted in a loss of directional control.Aug 11, 2023 · N9237R · Substantial damageNTSB ANC23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Chaka Creek, AKA partial loss of engine power as a result of carburetor ice. Contributing to the outcome was the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.Aug 10, 2023 · N42610 · Substantial damageNTSB WPR23LA312Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Dixon, CAThe pilot’s loss of directional control after striking an unidentified object during landing on an unimproved runway, and his subsequent use of excessive braking that resulted in a nose-over.Aug 9, 2023 · N50443 · Substantial damageNTSB WPR23LA317Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Fullerton, CAThe separation of the stabilator actuator from the stabilator tab, which resulted in pitch control surface flutter and structural damage.Aug 8, 2023 · N503JA · Substantial damageNTSB WPR23LA306Accident · No injuriesClass 3 · LimitedFinal reportBoeing CH-46E · Springerville, AZThe flight crew’s misidentification of a No. 2 torque sensing system signal conditioner malfunction when both engines were performing normally, which resulted in their attempt to execute a single-engine steep approach and landing without sufficient engine…Aug 5, 2023 · N461WY · DestroyedNTSB ERA23LA325Accident · No injuriesClass 3 · LimitedFinal reportLong Charles Jackson Avid Flyer · Wetumpka, ALA loss of engine power due to fuel exhaustion because of a leaking fuel drain valve.Aug 3, 2023 · N3HH · Substantial damageNTSB ENG23LA033Incident · No injuriesClass 3 · LimitedFinal reportAirbus A320 · Jacksonville, FLThe loss of both Integrated Drive Generators (IDG) due to worn fixed cylinder block bores, which caused the IDGs to be tripped offline and caused the airplane to enter an emergency electrical configuration.Aug 3, 2023 · N649JB · No damageNTSB DCA23LA409AccidentClass 4 · LimitedFinal reportBoeing 767-322 · Chantilly, VAImproper overhaul of the trunnion cross-pin hole that resulted in the development of stress corrosion cracking and eventual failure of the right forward trunnion.Aug 3, 2023 · N676UA · Substantial damageNTSB ERA23LA320Accident · 1 fatalClass 3 · LimitedFinal reportMesnard Velocity Twin · Sandersville, GAA total loss of power in the right engine due to the right ECU injector wires being severed by the main landing gear actuator piston teeter bar as a result of a lack of clearance and protection of the wiring bundle.Aug 1, 2023 · N106VT · Substantial damageNTSB ERA23LA319Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · North Charleston, SCA failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.Aug 1, 2023 · N31PB · Substantial damageNTSB WPR23LA290Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Coolin, IDThe pilot’s failure to maintain clearance from trees after takeoff, during high density altitude weather conditions.Jul 30, 2023 · N2362Z · Substantial damageNTSB WPR23FA286Accident · 1 fatalClass 3 · FieldFinal reportRisen 915 iS · Glendive, MTThe pilot’s failure to maintain airspeed, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/spin.Jul 28, 2023 · N2442 · DestroyedNTSB ERA23LA347Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Knoxville, TNAn in-flight fire that resulted from an inadequate 100-hr inspection, which failed to detect and correct improper electrical cable routing in the engine compartment.Jul 27, 2023 · N15417 · Substantial damageNTSB CEN23LA322Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415-D · Waupun, WIThe pilot’s decision to take off without correcting a misinstalled fuel cap, which resulted in a loss of engine power due to fuel starvation caused by improper venting of the fuel system.Jul 23, 2023 · N415JC · Substantial damageNTSB CEN23LA344Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Oberlin, KSThe blockage of the left fuel tank vent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident of the pilot’s failure to use his checklist to address the loss of engine power.Jul 20, 2023 · N36900 · Substantial damageNTSB WPR23LA272Accident · No injuriesClass 3 · LimitedFinal reportMellinger B L III/Briebleb R Glasair III · Pahrump, NVA fuel leak due to damaged threads on a fuel line fitting, which resulted in an interruption of fuel flow and a total loss of engine power due to fuel starvation.Jul 17, 2023 · N196G · Substantial damageNTSB ERA23LA302Accident · No injuriesClass 4 · LimitedFinal reportPollock Michael D Velocity 173RG · Lebanon, NHThe pilot’s failure to store the nose landing gear securing bar within reach in the cabin, which resulted in a nose gear collapse following a manual landing gear extension.Jul 17, 2023 · N173DT · Substantial damageNTSB ERA23LA301Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-310 · Lumberton, NJThe pilot's failure to extend the landing gear before landing.Jul 14, 2023 · N400S · Substantial damageNTSB CEN23FA304Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Osage Beach, MOThe pilot’s failure to properly set the stabilator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Jul 13, 2023 · N8225N · Substantial damageNTSB ERA23LA298Accident · Serious injuriesClass 3 · LimitedFinal reportDouglas A-4K · MCAS Cherry Point, NCThe pilot’s failure to identify and appropriately respond to an anomalous nose-down trim condition during the takeoff roll, which resulted in his decision to eject and the airplane’s subsequent runway excursion.Jul 12, 2023 · N143EM · Substantial damageNTSB ANC23LA052Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · McCarthy, AKA failure of the right brake caliper bolts during landing, which resulted in a runway excursion and subsequent impact with terrain.Jul 12, 2023 · N814DW · Substantial damageNTSB WPR23LA270Accident · No injuriesClass 3 · LimitedFinal reportSling Sling LSA · Palm Springs, CAFailure of the landing gear strut during takeoff due to a preexisting cracks that were caused by a manufacturing anomaly during the composite fiber layup process.Jul 11, 2023 · N294JY · Substantial damageNTSB WPR23LA263Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Marble Falls, TXA total loss of engine power due to fuel contamination from an unknown source.Jul 9, 2023 · N163RK · Substantial damageNTSB CEN23LA298Accident · No injuriesClass 4 · LimitedFinal reportMariner Unknown · Lino Lakes, MNThe pilot’s failure to retract the landing gear on the amphibious airplane before landing on water.Jul 9, 2023 · UNREG · Substantial damageNTSB CEN23FA284Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-30 · Sherman, TXThe pilot’s failure to maintain control during a forced landing following a loss of engine power. Contributing was the pilot’s failure to feather the left propeller following the loss of engine power.Jul 8, 2023 · N4743M · Substantial damageNTSB CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.Jul 6, 2023 · N100PB · DestroyedNTSB ERA23LA284Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Macclenny, FLThe improper maintenance of the landing gear dampers and main rotor elastomeric dampers, resulting in ground resonance during an unsuccessful takeoff attempt with the helicopter near its maximum gross weight for the density altitude.Jul 1, 2023 · N9WZ · Substantial damageNTSB DCA23LA340Accident · No injuriesClass 4 · LimitedFinal reportSupernal SUP83-1 · California City, CAErroneous signal processing that resulted in a total loss of propulsion power.Jun 29, 2023 · N283TD · Substantial damageNTSB DCA23FA339Accident · No injuriesClass 3 · FieldFinal reportBoeing 717-200 · Charlotte, NCA fatigue fracture of the upper lock link that initiated along scratch features on the lower surface at the parting line of the forged aluminum component. Contributing to the accident was the overhaul facilities noncompliance with Service Bulletin 717-32-002.Jun 28, 2023 · N955AT · Substantial damageNTSB ERA23FA274Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Claxton, GAThe flight crew’s improper fuel management, which resulted in the airplane’s right engine being starved of fuel and its subsequent total loss of power.Jun 25, 2023 · N7240Y · Substantial damageNTSB CEN23LA264Accident · No injuriesClass 3 · LimitedFinal reportBeech B19 · Scott City, KSA partial loss of engine power as a result of carburetor icing that formed while the engine was operating at a low power setting for an extended period before departure.Jun 24, 2023 · N9721Q · Substantial damageNTSB ERA23LA275Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Pence Springs, WVA total loss of engine power due to carburetor icing.Jun 23, 2023 · N9543E · Substantial damageNTSB CEN23LA250Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7EC · Waunakee, WIA total loss of engine power during the initial takeoff climb due to a worn manual fuel primer pump locking mechanism, which resulted in an unlocked primer and an overly rich fuel mixture.Jun 21, 2023 · N80461 · Substantial damageNTSB CEN23LA249Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Mesquite, TXThe pilot’s inability to maintain directional control during the landing roll due to corroded brake caliper pins.Jun 21, 2023 · N9354B · Substantial damageNTSB ANC23LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Talkeetna, AKA loss of directional control, while landing, due to a flat main landing gear tire.Jun 19, 2023 · N9214C · Substantial damageNTSB WPR23LA232Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Rochester, NVA broken fuel line fitting that resulted in a total loss of engine power due to fuel starvation.Jun 17, 2023 · N3508K · Substantial damageNTSB ERA23LA281Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Indian Trail, NCA loss of control during the landing roll due to a brake failure for reasons that could not be determined based on available evidence.Jun 16, 2023 · N3662Z · Substantial damageNTSB WPR23LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · Olivehurst, CAThe pilot’s failure to extend the landing gear before landing.Jun 10, 2023 · N4761A · Substantial damageNTSB WPR23LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Nephi, UTA total loss of engine power due to fuel contamination as a result of the inadequate removal of fuel system corrosion during previous maintenance.Jun 8, 2023 · N7318Y · Substantial damageNTSB WPR23LA218Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Chillicothe, MOA partial loss of engine power due to a tear in the fuel manifold diaphragm, which prevented sufficient fuel flow to the engine.Jun 7, 2023 · N731UF · DestroyedNTSB ERA23FA258Accident · 2 fatalClass 3 · FieldFinal reportCirrus SR22 · Jamestown, NYThe pilots’ failure to maintain airplane control following an anomalous engine indication during the initial climb, which resulted in a loss of control and parachute deployment at an altitude too low for the system to operate effectively. Contributing to the…Jun 6, 2023 · C-GNMT · DestroyedNTSB WPR23LA216Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Santa Monica, CAA failure of the nose wheel upper torque link bolt, which resulted in a loss of steering control. Contributing to the accident were maintenance personnel’s failure to inspect and replace the fractured bolt and the pilot’s oversight of the bolt during his…Jun 5, 2023 · N819KS · Substantial damage