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 ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.Nov 4, 2022 · N7254L · Substantial damageNTSB ERA23LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Athens, GAThe operator’s and the pilot’s continued operation of the airplane with a known electrical problem, resulting in a loss of electrical power and a gear-up landing.Nov 3, 2022 · N101DC · Substantial damageNTSB CEN23LA025Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Greenville, ILThe mechanic’s failure to inspect and clean the entire fuel nozzle assembly in accordance with the engine maintenance manual, which resulted in fuel starvation and a partial loss of engine power, an autorotation, and a hard landing.Nov 3, 2022 · N61KH · Substantial damageNTSB ERA23LA053Accident · Minor injuriesClass 4 · LimitedFinal reportSchmidt Randall M Bushby Mustang II · Statesboro, GAA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the likely inaccurate right fuel quantity indicating system.Nov 2, 2022 · N30RK · Substantial damageNTSB ERA23FA045Accident · 2 fatalClass 3 · FieldFinal reportBearhawk Patrol · Hanover Township, PAThe pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.Oct 29, 2022 · N964RS · Substantial damageNTSB ERA23LA167Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Winter Haven, FLThe pilot’s failure to properly secure the rear seat headset, resulting in an obstruction of the airplane’s rudder controls.Oct 24, 2022 · N6ND · Substantial damageNTSB WPR23LA022Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Nogales, AZThe pilot’s failure to establish a positive rate of climb before retracting the landing gear when he executed an aborted landing, which resulted in a propeller strike, diminished climb performance, and the inadvertent contact with terrain.Oct 20, 2022 · N50JM · DestroyedNTSB WPR23LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Georgetown, CAThe pilot’s failure to maintain control during an attempted go-around, which resulted in a runway excursion and a separation of the right main landing gear.Oct 20, 2022 · N55DC · Substantial damageNTSB WPR23LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Mesa, AZThe failure of maintenance personnel to properly secure the fuel supply line to the fuel flow divider, which resulted in a fuel leak, fuel exhaustion, and a total loss of engine power.Oct 18, 2022 · N747ML · Substantial damageNTSB ERA23FA023Accident · 2 fatalClass 3 · FieldFinal reportPeryera Adventura II · Miramar, FLThe pilot’s failure to remove the ECU select switch per the manufacturer’s service bulletin, which resulted in a loss of engine power.Oct 17, 2022 · N32856 · Substantial damageNTSB CEN23LA014Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 62 · Dallas, TXA total loss of airplane electrical power for undetermined reasons, which resulted in a complete loss of engine power to both engines. Contributing was the worn main battery and the incorrectly wired ECU backup batteries.Oct 15, 2022 · N84LT · Substantial damageNTSB CEN23LA012Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Paola, KSThe pilot’s improper positioning of the fuel selector, which resulted in fuel starvation and a loss of engine power during a departure climb.Oct 12, 2022 · N4171W · Substantial damageNTSB WPR23LA012Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Marana, AZA failure of a retaining ring in the airplane’s left main landing gear door actuator and the subsequent complete loss of hydraulic fluid, which resulted in a gear-up landing.Oct 10, 2022 · N2425S · Substantial damageNTSB CEN23LA009Accident · Minor injuriesClass 4 · LimitedFinal reportYates Mike E Roaring Eagle · Stanwood, IAThe pilot’s exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover. Contributing to the accident was the partial loss of engine…Oct 9, 2022 · N181MY · Substantial damageNTSB ERA23LA009Accident · Minor injuriesClass 3 · LimitedFinal reportSwensen Fisher Celebrity · Greensboro, NCThe pilot/mechanic’s failure to remove excess sealant from the header fuel tank after recent maintenance, which resulted in fuel starvation to the engine and a loss of engine power. Contributing to the accident was the pilot’s inflight decision making…Oct 6, 2022 · N655WP · Substantial damageNTSB ANC23FA001Accident · 1 fatalClass 3 · FieldFinal reportCessna A185F · Fairbanks, AKThe improperly maintained floats, which allowed water to fill the front compartments and resulted in the airplane nosing over during taxi. Contributing to the fatal injury of the pilot was the improperly secured cargo, which prevented the pilot from egressing…Oct 6, 2022 · N217C · No damageNTSB WPR23LA033Accident · No injuriesClass 4 · LimitedFinal reportRaytheon A36 · Freeport, ILThe pilot’s failure to extend the landing gear.Oct 5, 2022 · N147DT · Substantial damageNTSB CEN23LA003Accident · No injuriesClass 3 · LimitedFinal reportEmbraer S A EMB-545 · Houston, TXThe crew failed to ensure the main entry door was locked before departure. Contributing to the accident was a corroded/jammed door sensor that provided an erroneous locked indication to the crew alerting system.Oct 3, 2022 · N179SP · Substantial damageNTSB ERA23LA002Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 7AC · Murray, KYThe incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during post-maintenance checks and the pilot's inadequate preflight check.Oct 2, 2022 · N3005E · Substantial damageNTSB WPR22LA365Accident · Minor injuriesClass 4 · LimitedFinal reportMary Alexander JA30 Superstol · Groveland, CAThe pilot's excessive application of brake during an attempt to avoid wildlife while taxing resulted in a nose over.Oct 1, 2022 · N119AM · Substantial damageNTSB WPR22FA361Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5B · Sahuarita, AZThe pilot's loss of control following a separation of the aileron carry-through cable.Sep 28, 2022 · N74349 · DestroyedNTSB WPR22LA357Accident · No injuriesClass 3 · LimitedFinal reportVashon Ranger R7 · Glendale, AZFailure of the landing gear due to material deficiencies that reduced the strength of the landing gear.Sep 27, 2022 · N151VR · Substantial damageNTSB CEN22LA434Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · McGregor, TXThe flight crew’s failure to ensure the landing gear was down which resulted in a gear up landing and subsequent runway excursion.Sep 27, 2022 · N409ST · Substantial damageNTSB ERA22LA434Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Augusta, GAThe failure of the nose landing gear to fully extend and lock into position for reasons that could not be determined, which resulted in its collapse during landing.Sep 26, 2022 · N745EP · Substantial damageNTSB WPR22LA355Accident · Minor injuriesClass 4 · LimitedFinal reportHartunian Robert Pulsar XP · Big Bear, CAThe pilot’s inability to maintain directional control after landing with an excessive ground speed due to a tailwind which, resulted in a severe shimmy which subsequently damaged a hydraulic brake line.Sep 25, 2022 · N204BH · Substantial damageNTSB ANC22LA080Accident · 1 fatalClass 3 · LimitedFinal reportCessna 180A · Skwentna, AKThe failure of the landing gear float due to inadequate maintenance of the floats and corrosion.Sep 25, 2022 · N9728B · Substantial damageNTSB CEN22LA430Accident · No injuriesClass 3 · LimitedFinal reportAgusta AW139 · Houma, LAThe inflight loss of collective control of the helicopter due to thermal damage of a collective control torque tube that abraded with misrouted electrical wiring, which resulted in an electrical short and inflight fire. Contributing to the accident were the…Sep 24, 2022 · N811TA · Substantial damageNTSB DCA22LA212Incident · No injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Los Angeles, CAUncommanded movement of the trimmable horizontal stabilizer control wheel for reasons that could not be determined based on the available evidence.Sep 22, 2022 · N393HA · No damageNTSB WPR22LA353Accident · No injuriesClass 3 · LimitedFinal reportCessna 525B · Pasco, WAThe failure of the pilot to ensure the landing gear was extended before landing. Contributing was the pilot’s failure to fly a stabilized approach, and his configuration of the airplane that prevented activation of the landing gear not extended warning system…Sep 20, 2022 · N528DV · DestroyedNTSB ANC22LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Tok, AKThe pilot’s improper application of the brakes, which resulted in a nose-over and substantial damage to the rudder and wings.Sep 18, 2022 · N92740 · Substantial damageNTSB ANC22LA077Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot’s inadvertent application of the brakes during the landing roll, which resulted in a nose-over and substantial damage to the rudder and wings.Sep 16, 2022 · N2340S · Substantial damageNTSB CEN22LA427Accident · No injuriesClass 3 · LimitedFinal reportCessna A188A · Canby, MNThe pilot’s failure to maintain airplane control during the landing, which resulted in an overload failure of the tailwheel cross tube and subsequent impact with the runway.Sep 12, 2022 · N2122U · Substantial damageNTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.Sep 10, 2022 · N3670D · Substantial damageNTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…Sep 7, 2022 · N15TZ · Substantial damageNTSB CEN22LA407Accident · No injuriesClass 4 · LimitedFinal reportBeech 36 · Tupelo, MSThe pilot’s failure to extend the landing gear for a landing.Sep 5, 2022 · N7835R · Substantial damageNTSB DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…Sep 4, 2022 · N725TH · DestroyedNTSB WPR22LA337Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Seeley Lake, MTThe loss of engine power due to fuel starvation as a result of unporting of the fuel.Sep 3, 2022 · N3135D · Substantial damageNTSB CEN22FA405Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Tomball, TXThe flight instructor’s inadequate supervision of the flight, which allowed for an unintentional movement of the mixture control to the cutoff position that remained unnoticed until the airplane lost engine power due to fuel starvation and descended below the…Sep 1, 2022 · N420SS · Substantial damageNTSB ERA22LA396Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion · Newburyport, MAThe pilot’s excessive application of brakes while landing, which resulted in a nose gear collapse.Aug 31, 2022 · N4913K · Substantial damageNTSB WPR22LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Tooele, UTLoss of brake pressure to both sets of brakes during taxi due to failed brake caliper O-ring seals, which resulted in a loss of directional control.Aug 30, 2022 · N3094Q · Substantial damageNTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.Aug 27, 2022 · N628LE · Substantial damageNTSB CEN22LA396Accident · Minor injuriesClass 4 · LimitedFinal reportJavron Experimental PA18 Replica · Osceola, IAThe stuck right brake at landing which resulted in a loss of control.Aug 27, 2022 · N954SC · Substantial damageNTSB WPR22LA322Accident · Minor injuriesClass 3 · LimitedFinal reportRay E Roberts Kitfox V Vixen · Caldwell, IDThe partial loss of engine power due to a loose wire leading to the engine’s electronic control unit (ECU). Contributing was the pilot’s exceedance of the critical angle of attack while maneuvering, which resulted in an aerodynamic stall at an altitude too…Aug 26, 2022 · N52367 · Substantial damageNTSB ERA22LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · Georgetown, DEThe pilot's failure to extend the landing gear before landing. Contributing to the accident was an inoperative landing gear warning horn.Aug 25, 2022 · N5132C · Substantial damageNTSB WPR22LA324Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBA · Athol, IDThe failure of the right brake due to a disconnected master cylinder piston rod, which led to the departure of the airplane from the runway surface. Contributing to the accident was the mechanic’s failure to adequately inspect the connection between the…Aug 23, 2022 · N9512S · Substantial damageNTSB WPR22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-30 · St Ignatius, MTA partial loss of power during takeoff for undetermined reasons.Aug 23, 2022 · N4009Y · Substantial damageNTSB ERA22LA382Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7AC · Clermont, FLThe pilot’s inability to maintain directional control while landing due to a worn tailwheel locking mechanism, which resulted in a runway excursion and collision with terrain.Aug 21, 2022 · N44FC · Substantial damageNTSB ERA22LA408Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Hollywood, MDThe pilot's failure to extend the landing gear before landing.Aug 19, 2022 · N7154U · Substantial damageNTSB WPR22LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Avalon, CAThe pilot’s failure to extend the landing gear before landing, resulting in a gear up landing and substantial damage to the airplane’s belly.Aug 18, 2022 · N52946 · Substantial damageNTSB WPR22FA298Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Blyn, WAThe pilot’s continued operation of the airplane with known mechanical malfunctions with the flight displays, and his continued flight into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.Aug 10, 2022 · N379DH · Substantial damage