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 ERA23FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna 560 · Montebello, VAPilot incapacitation due to loss of cabin pressure for undetermined reasons. Contributing to the accident was the pilot’s and owner/operator’s decision to operate the airplane without supplemental oxygen.Jun 4, 2023 · N611VG · DestroyedNTSB ANC23LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's excessive braking during landing on a sand bar, which resulted in a nose over.Jun 4, 2023 · N83330 · Substantial damageNTSB CEN23LA233Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Carrington, NDA total loss of engine power as a result of carburetor ice that formed while the engine was operating at a low power setting for an extended period of time before departure.Jun 3, 2023 · N8843L · Substantial damageNTSB CEN23LA230Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Rutherfordton, NCThe disengagement of the tailwheel locking mechanism during the landing roll which resulted in a loss of directional control during landing with a crosswind.Jun 3, 2023 · N5068X · Substantial damageNTSB CEN23LA222Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2S · Garden Plain, KSThe pilot’s inability to maintain directional control during landing roll due to a flat tire.Jun 3, 2023 · N1PW · Substantial damageNTSB CEN23LA227Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Twinstar · Starbuck, MNThe pilot’s improper landing flare and hard landing, which resulted in the left axle fracturing from bending overstress.Jun 2, 2023 · N1025T · Substantial damageNTSB WPR23LA269Accident · Minor injuriesClass 3 · LimitedFinal reportCSP Leasing MTO Sport · Gardiner, MTFailure of the rudder/nosewheel steering system for reasons that could not be determined, which resulted in loss of yaw control and a subsequent rollover.Jun 1, 2023 · N207AG · Substantial damageNTSB ERA23LA253Accident · Minor injuriesClass 3 · LimitedFinal reportBeech V35A · Statesboro, GAMaintenance personnel’s improper installation of the pitch servo bridle cable clamp, which led to binding in the elevator control system that restricted aft yoke movement during the landing approach.Jun 1, 2023 · N8074R · Substantial damageNTSB CEN23LA217Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Pellston, MIThe failure of the left main landing gear strut and clevises due to fatigue cracks that initiated at multiple casting solidification voids.Jun 1, 2023 · N4376H · Substantial damageNTSB ERA23LA277Accident · No injuriesClass 3 · LimitedFinal reportRockwell International 695 · Philadelphia, PAFailure of the nose gear support structure for unknown reasons, which resulted in the nose landing gear collapsing during landing.May 31, 2023 · N515AM · Substantial damageNTSB ERA23LA262Accident · No injuriesClass 3 · LimitedFinal reportBurton Searey · Sherrills Ford, NCThe pilot’s failure to configure the amphibious airplane’s landing gear before conducting a forced landing to a lake after a loss of engine power. Also causal was the occluded gascolator and the pilot’s lack of knowledge about the airplane’s fuel system,…May 31, 2023 · N2440S · Substantial damageNTSB CEN23LA211Accident · No injuriesClass 3 · LimitedFinal reportW10 Tailwind · Penrose, COThe failure of the right rudder pedal stop due to an inadequate weld, which resulted in a loss of control on the ground.May 31, 2023 · N456TW · Substantial damageNTSB WPR23LA213Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Tacoma, WAA fatigue failure of the left main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position and maintaining directional control after landing.May 30, 2023 · N9574X · Substantial damageNTSB WPR23LA203Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · West Jordan, UTLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl.May 29, 2023 · N456Y · Substantial damageNTSB WPR23LA205Accident · No injuriesClass 4 · LimitedFinal reportPiaggio Aero Industries P180 · Sugar Land, TXThe pilot’s failure to complete required preflight checklist items and properly configure the flaps for takeoff.May 27, 2023 · N327A · Substantial damageNTSB WPR23LA207Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Kingman, AZThe failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.May 26, 2023 · N94599 · Minor damageNTSB WPR23LA202Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M-18C 55 · Napa, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.May 26, 2023 · N201MM · Substantial damageNTSB ERA23FA247Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Lake Worth, FLMaintenance personnel’s failure to detect the corroded aileron cable during recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during takeoff.May 26, 2023 · N3KV · DestroyedNTSB WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.May 25, 2023 · N6PK · Substantial damageNTSB ERA23LA378Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Savannah, GAFailure and collapse of the nose landing gear during landing.May 25, 2023 · N177EM · Substantial damageNTSB ERA23LA245Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-25-260 · Hollywood, FLThe pilot’s improper banner pickup approach, which resulted in the banner tow hook contacting the airplane, and the subsequent overload separation of the right rudder control horn, resulting in a loss of airplane control.May 25, 2023 · N454AB · Substantial damageNTSB ERA23LA240Accident · 1 fatalClass 3 · LimitedFinal reportCessna R182 · Macon, NCThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.May 21, 2023 · N182LG · DestroyedNTSB WPR23LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · American Falls, IDThe pilot’s inadvertent selection of the off position of the fuel tank selector inflight, which resulted in a total loss of engine power due to fuel starvation.May 20, 2023 · N77J · Substantial damageNTSB WPR23LA192Accident · 2 fatalClass 3 · LimitedFinal reportViking Air DHC-6-400 · Half Moon Bay, CAThe failure of the ferry fuel tank system to transfer fuel during a trans-Pacific flight for reasons that could not be determined, which resulted in fuel starvation and a subsequent ditching into the water.May 20, 2023 · N153QS · Substantial damageNTSB CEN23LA192Accident · No injuriesClass 4 · LimitedFinal reportNorth American-Buehn T-6G · Ankeny, IAThe pilot’s inadvertent retraction of the landing gear control lever, resulting in a gear-up landing on the runway.May 20, 2023 · N42JM · Substantial damageNTSB CEN23LA208Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Cortez, COFailure of the right main landing gear due to prolonged corrosion of the landing gear tube, which weakened the gear.May 19, 2023 · N2515K · Substantial damageNTSB ERA23LA237Accident · No injuriesClass 4 · LimitedFinal reportBeech 65-A90-1 · Petersburg, WVThe flight crew’s failure to ensure that the landing gear were properly configured before landing.May 18, 2023 · N80Y · Substantial damageNTSB CEN23LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-C33A · Indianola, MSAn in-flight fire for undetermined reasons.May 18, 2023 · N63B · DestroyedNTSB CEN23FA190Accident · 1 fatalClass 3 · FieldFinal reportBeech E-90 · Winslow, ARThe pilot’s poor preflight decision to depart into known instrument meteorological conditions (IMC) without a functional autopilot system, which resulted in spatial disorientation and his failure to maintain aircraft control while flying in IMC during the…May 17, 2023 · N522MJ · DestroyedNTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…May 10, 2023 · N56PA · DestroyedNTSB WPR23LA186Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1C-180 Husky · Lakewood, WAAn erroneous landing gear warning that led to the pilot’s decision to abort the landing, which resulted in a collision with trees during a go-around.May 9, 2023 · N416AG · DestroyedNTSB WPR23LA181Accident · No injuriesClass 4 · LimitedFinal reportSteven Radenbaugh JA35 Superstol · Moorpark, CAThe pilot’s failure to maintain control of the airplane during an off airport precautionary landing. Contributing to the accident was the pilot’s decision to continue the flight with a possible mechanical malfunction.May 6, 2023 · N799CP · Substantial damageNTSB CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.May 6, 2023 · N6798T · DestroyedNTSB ERA23LA221Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC-CONV · Fort Mill, SCThe pilot’s failure to apply carburetor heat before initiating a descent in conditions conducive to the development of carburetor icing, which resulted in a partial loss of engine power due to carburetor ice.May 5, 2023 · N3058E · Substantial damageNTSB WPR23LA177Accident · No injuriesClass 3 · LimitedFinal reportCessna 210M · Pasco, WAImproper maintenance on the fuel outlet line to the fuel servo, which resulted in the line partially separating from the fuel outlet fitting and the subsequent fuel starvation and total loss of engine power.May 4, 2023 · N777CF · Substantial damageNTSB CEN23LA180Accident · No injuriesClass 4 · LimitedFinal reportSearey LSX · Pottsboro, TXThe pilot’s failure to retract the landing gear before a water landing.May 3, 2023 · N40SR · Substantial damageNTSB CEN23LA172Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-200 · Coldspring, TXThe stabilator trim rod assembly separated from the stabilator link assembly due to a missing connecting bolt, which resulted in the pilot’s inability to maintain pitch control of the airplane.May 3, 2023 · N28HE · Substantial damageNTSB WPR23LA176Accident · No injuriesClass 4 · LimitedFinal reportAkroTech Giles G-202 · Santa Barbara, CAA fire that resulted from venting fuel coming into contact with hot exhaust surfaces or exhaust gases. Contributing to the fire was the design and location of the main tank fuel vent.May 2, 2023 · C-GXGS · Substantial damageNTSB CEN23LA170Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8F · Palmer, TXThe installation of an unapproved rudder control cable, which resulted in a fatigue failure and subsequent loss of rudder control during cruise flight. Contributing to the accident was the mechanic’s inadequate inspection of the rudder control system.Apr 30, 2023 · N1113B · Substantial damageNTSB ERA23LA216Accident · No injuriesClass 4 · LimitedFinal reportGilbert R. Ringer GP4 · Stratford, CTA failure of the left main landing gear down locking mechanism, which resulted in a collapse of that landing gear and a subsequent runway excursion.Apr 27, 2023 · C-GPEX · Substantial damageNTSB CEN23LA166Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Columbia, MSThe pilot’s lack of proper maintenance, which allowed the fuel filters to become obstructed, leading to fuel starvation and a subsequent engine power loss.Apr 25, 2023 · N44048 · Substantial damageNTSB CEN23LA163Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Buffalo, IAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning. Contributing to the accident were the unreliable fuel quantity gauges and the improperly adjusted mixture control, which increased the fuel consumption…Apr 22, 2023 · N60860 · Substantial damageNTSB WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.Apr 19, 2023 · N4166C · Substantial damageNTSB ERA23LA210Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · St. Augustine, FLThe pilot’s failure to extend the landing gear before landing.Apr 18, 2023 · N751WW · Substantial damageNTSB ERA23LA202Accident · No injuriesClass 3 · LimitedFinal reportRockwell International 112 · Miami, FLFailure of the right main landing gear due to inadequate hydraulic pressure as result of a torn O-ring that was installed on the hydraulic pack’s check valve during overhaul.Apr 18, 2023 · N12RX · Substantial damageNTSB WPR23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna T337G · Upland, CAThe pilot’s failure to properly flare the airplane, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to fly a nonstandard traffic pattern, which resulted in an unstable approach.Apr 16, 2023 · N38C · Substantial damageNTSB ERA23LA189Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Ft. Lauderdale, FLThe pilot’s ineffective use of the airplane’s brakes, which resulted in a runway overrun.Apr 9, 2023 · N404PJ · Substantial damageNTSB CEN23LA150Accident · Minor injuriesClass 3 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe lack of proper attachment of the cyclic control that resulted in a loss of control during a landing approach and impact with terrain. Contributing to the accident was the improper maintenance performed.Apr 9, 2023 · N372PA · Substantial damageNTSB WPR23LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · Bremerton, WAFailure of the down limit and down indicator switch and the warning horn switch assemblies, which prevented the landing gear from extending and at the same time providing a false indication that the landing gear was extended.Apr 5, 2023 · N21RS · Substantial damageNTSB WPR23FA138Accident · 1 fatalClass 3 · FieldFinal reportAerotrike Cobra · Santa Teresa, NMThe pilot’s exceedance of the aircraft’s critical angle of attack, which resulted in an aerodynamic stall.Apr 1, 2023 · UNREG · Destroyed