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 CEN21LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Canon City, COThe failure of the alternator drive belt, which resulted in insufficient electrical power to extend the landing gear and a subsequent gear-up landing. .Nov 20, 2020 · N4187H · Substantial damageNTSB ERA21LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Ellenville, NYThe failure of the right brake master cylinder lock seal spring washer.Nov 14, 2020 · N5179G · Substantial damageNTSB CEN21LA108Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Fort Worth, TXA failure of the nose wheel landing strut for reasons that could not be determined based on available information.Nov 6, 2020 · N720TX · Substantial damageNTSB CEN21LA046Accident · Minor injuriesClass 4 · LimitedFinal reportNavion A · Fremont, MIThe pilot’s improper positioning of the fuel selector during takeoff, which was not in accordance with the preflight checklist and resulted in fuel starvation, a subsequent total loss of engine power, and an aerodynamic stall during an attempted forced…Nov 5, 2020 · N4856K · Substantial damageNTSB CEN21LA040Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Weslaco, TXThe pilot of N87715 inadvertently allowed his airplane to drift right of the runway during the climb after a touch-and-go landing, and the pilot of N6463H did not maintain adequate separation from the other airplane during his go-around. Contributing to the…Nov 3, 2020 · N87715 · 2 aircraft · Substantial damageNTSB CEN21LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Edinburg, TXThe collapse of the airplane’s left main landing gear for a reason that could not be determined based upon the available evidence.Oct 30, 2020 · N76933 · Substantial damageNTSB ANC21LA003Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Honolulu, HIA partial loss of engine power due to an obstructed fuel line as a result of the separation of the circlip from the pin used on the fuel start pump. The reason for the circlip separation could not be determined based on the available evidence.Oct 27, 2020 · N58251 · Substantial damageNTSB CEN21LA030Accident · 1 fatalClass 3 · LimitedFinal reportCessna 210 · Lubbock, TXThe pilot’s improper decision to fly into icing conditions with an airplane that was not equipped for icing, which led to structural icing and a subsequent loss of airplane control, and the pilot’s impairment from carbon monoxide poisoning due to a cracked…Oct 26, 2020 · N9622T · DestroyedNTSB WPR21LA028Accident · No injuriesClass 4 · LimitedFinal reportCessna T210K · Los Alamos, NMThe pilot’s failure to extend the landing gear, which resulted in the airplane landing with the landing gear retracted.Oct 24, 2020 · N8251M · Substantial damageNTSB CEN21LA057Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tishomingo, OKThe pilot’s improper adjustment of the engine mixture control, which resulted in a total loss of engine power. Contributing to the accident was a disconnected oil temperature connector, which was likely damaged during maintenance before the accident flight…Oct 24, 2020 · N183V · Substantial damageNTSB WPR21LA024Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8KCAB · Rock Springs, WYThe separation of the control grip which resulted in the pilot’s inability to maintain directional control during takeoff, and collision with terrain.Oct 21, 2020 · N7654S · Substantial damageNTSB WPR21LA019Accident · Serious injuriesClass 3 · LimitedFinal reportGlasair III · Hayward, CAA total loss of engine power due to fuel starvation because of a clogged fuel filter. Contributing to the accident was the improper maintenance and inspection of the fuel filter.Oct 21, 2020 · N1YX · Substantial damageNTSB WPR21LA017Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Puyallup, WAA partial loss of engine power as a result of carburetor icing and the flight instructors failure to use carburetor heat.Oct 18, 2020 · N4673R · Substantial damageNTSB ERA21LA022Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Moneta, VAThe fight instructor’s failure to ensure that the fuel selector handle was in the correct position, which resulted in a total loss of engine power during initial climb due to fuel starvation.Oct 14, 2020 · N7532E · Substantial damageNTSB ERA21LA021Accident · No injuriesClass 3 · LimitedFinal reportBeech 99 · Waterville, MEA failure of the right main landing gear drag leg support fitting and angle bracket as a result of multiple areas of fatigue cracking.Oct 14, 2020 · N499CZ · Substantial damageNTSB CEN21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox Classic 4 · New Carlisle, OHThe pilot’s failure to maintain pitch control of the airplane during landing, which caused the airplane to nose over during landing roll. Contributing to the accident was the main landing gear modification which increased the airplane’s tendency to nose over…Oct 13, 2020 · N47KC · DestroyedNTSB ERA21LA011Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · West Palm Beach, FLThe pilot’s inadequate preflight inspection during which he failed to detect a flight control abnormality, and his failure to expediently abort the takeoff, which resulted in the co-pilot performing a delayed aborted takeoff and the subsequent runway overrun.Oct 8, 2020 · N8132Q · Substantial damageNTSB ERA21LA031Accident · No injuriesClass 4 · LimitedFinal reportSparrowhawk II · North Myrtle Beach, SCA ruptured fuel line, which resulted in fuel starvation to the engine and a total loss of engine power.Oct 7, 2020 · N40380 · Substantial damageNTSB ERA21FA010Accident · 1 fatalClass 3 · FieldFinal reportCzech Sport Cruiser · Waterloo, ALThe improper configuration of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation following the failure of the electric fuel pump.Oct 7, 2020 · N251SC · Substantial damageNTSB CEN21LA033Accident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe improper installation of a clevis pin in the rudder system which led to a loss of directional control during landing.Oct 7, 2020 · N790L · Substantial damageNTSB WPR21LA033Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASK21 · Minden, NVThe student pilot’s improper application of the airbrakes during final approach, which resulted in a landing area undershoot and subsequent hard, bounced landing.Oct 6, 2020 · N684KS · Substantial damageNTSB WPR21LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Rimrock, AZThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.Oct 5, 2020 · N22979 · Substantial damageNTSB CEN21LA023Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revolt · Durango, COThe pilot’s loss of directional control during landing following a hard landing and failure of the right main tire.Oct 4, 2020 · N912RE · Substantial damageNTSB CEN21LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Denver, COFailure of the landing gear motor that prevented the gear from extending fully to the down and locked position, which resulted in a gear collapse on landing and a subsequent loss of directional control.Oct 2, 2020 · N7798M · Substantial damageNTSB ERA21LA005Accident · No injuriesClass 3 · LimitedFinal reportFokker DR1 · Wake, VAA total loss of engine power due to fuel starvation as the result of the improper installation of the ram air fuel vent tube, which resulted in the tube separating from the airplane during taxi and subsequent negative pressure inside the fuel tank.Oct 1, 2020 · N512FH · Substantial damageNTSB ANC20LA100Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Tok, AKThe mechanic’s failure to properly repair the tailwheel, which resulted in a malfunction of the tailwheel and a loss of directional control.Oct 1, 2020 · N926LL · Substantial damageNTSB ERA20LA342Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCB · DeFuniak Springs, FLThe failure of the left landing gear airframe cross tube during landing, due to corrosion hidden under riveted fairing.Sep 30, 2020 · N8950R · Substantial damageNTSB ERA20LA335Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Union, SCA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.Sep 27, 2020 · N33859 · DestroyedNTSB WPR20LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Bridgeport, CAAn inadvertent retraction of the flaps during a go-around by the pilot-rated passenger, which caused the airplane to settle onto the runway with the landing gear retracted.Sep 25, 2020 · N300JS · Substantial damageNTSB CEN20LA420Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Terrell, TXFuel starvation due to a fuel system leak, which resulted in a loss of engine power and the subsequent forced landing on unsuitable terrain.Sep 24, 2020 · N3958A · Substantial damageNTSB ANC20LA099Accident · No injuriesClass 3 · LimitedFinal reportCessna 170B · Big Lake, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive to carburetor icing, which resulted in a total loss of engine power.Sep 23, 2020 · N4380B · Substantial damageNTSB CEN20LA407Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver MX II · Marengo, INA loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s decision to operate the airplane in conditions conducive to carburetor icing without a carburetor heating system, contrary to the engine manufacturer’s guidance.Sep 21, 2020 · UNREG · Substantial damageNTSB CEN20CA416Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172RG · Lafayette, INThe separation failure of a landing gear system hydraulic line and its compression fitting during cruise flight, which resulted in a partial gear up landing.Sep 21, 2020 · N6330V · Substantial damageNTSB CEN20LA412Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montrose, MOA total loss of engine power due to an electrical overload in the engine control unit wiring system; the electrical overload occurred as a result of improper installation by the airplane builder.Sep 20, 2020 · N210WP · Substantial damageNTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.Sep 17, 2020 · N6208T · Substantial damageNTSB ANC20LA093Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA22 · Homer, AKThe total loss of engine power during the initial climb due to fuel contamination. Contributing to the accident was the corrosion of the fuel tank filler necks, which resulted in water intrusion into the fuel tanks.Sep 14, 2020 · N8875C · Substantial damageNTSB ANC20CA090Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Palmer, AKThe pilot’s excessive airspeed during landing and improper application of the brakes, which resulted in a runway overrun.Sep 8, 2020 · N2625Q · Substantial damageNTSB WPR20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 208 · Whitmore, AZA loss of directional control during landing due to a flat main landing gear tire, which resulted in a lateral runway excursion and impact with terrain.Sep 7, 2020 · N186GC · Substantial damageNTSB ERA20LA297Accident · 2 fatalClass 3 · LimitedFinal reportRockwell 500 · Pembroke Park, FLA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the fatigue fracture of an electrical wire in the tank unit or fuel transmitter, which likely resulted in an inaccurate fuel quantity indication.Aug 28, 2020 · N900DT · DestroyedNTSB WPR20LA288Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Chino, CAThe failure of the engine-driven hydraulic pump, which resulted in the main landing gear not fully extending and locking into place during landing. Contributing to the accident was the failure of the emergency gear extension system for reasons that could not…Aug 26, 2020 · N9540T · Substantial damageNTSB WPR20LA301Accident · 1 fatalClass 3 · LimitedFinal reportLake LA4 · Rawlins, WYThe pilot’s decision to depart despite a known mechanical trim malfunction and with a high-density altitude and the airplane at or above its maximum gross weight.Aug 25, 2020 · N93AB · Substantial damageNTSB ERA20LA295Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Nebo, NCA leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.Aug 22, 2020 · N86002 · Substantial damageNTSB CEN20CA363Accident · No injuriesClass 4 · Data collectionFinal reportBeech 55 · Athens, TXThe pilot’s failure to extend the landing gear during the approach and landing.Aug 22, 2020 · N1621W · Substantial damageNTSB WPR20LA290Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA 40 · Benson, AZThe failure of the nose landing due to fatigue cracking.Aug 20, 2020 · N386MA · Substantial damageNTSB WPR20LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Upland, CAThe failure of the right landing gear due to fatigue cracking.Aug 19, 2020 · N79MS · Substantial damageNTSB WPR20LA280Accident · 1 fatalClass 3 · LimitedFinal reportArrow-Falcon Exporters UH-1H · Coalinga, CAThe pilot’s inability to maintain control of the helicopter due to a hydraulic system failure for reasons that could not be fully determined due to the thermal destruction from the postimpact fire.Aug 19, 2020 · N711GH · DestroyedNTSB DCA20LA138Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing 767 · Los Angeles, CAThe left main landing gear’s failure to extend due to the separation of the brake rod retaining hardware from the aft inboard wheel for reasons that could not be determined based on the available evidence.Aug 19, 2020 · N146FE · Substantial damageNTSB ERA20CA291Accident · No injuriesClass 4 · Data collectionFinal reportTeam Rocket F1 Rocket · Finelyville, PAThe pilot's misjudgment of the airplane’s speed and altitude during the landing approach, and his failure to attain the proper touchdown point during landing, which resulted in a runway overrun. Contributing to the accident were his access to a limited set of…Aug 18, 2020 · N88XK · Substantial damageNTSB ERA20LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Surry, METhe pilot’s failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a loss of engine power and a forced ditching in water.Aug 17, 2020 · N45083 · Substantial damageNTSB CEN20LA336Accident · 2 fatalClass 3 · LimitedFinal reportCirrus SR22 · Osage Beach, MOAn in-flight fire and subsequent loss of airplane control shortly after takeoff. The source of the in-flight fire or the reason for the loss of airplane control could not be determined based on the available information.Aug 16, 2020 · N949CG · Destroyed