NTSB investigations

19,008 cases where NTSB found Personnel issues.

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\", '02'))
  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 ERA22LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Ellington, CTThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, an emergency landing, and runway excursion.Jun 4, 2022 · N90JF · Substantial damageNTSB ERA22LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Spencer, VAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to use the landing checklist.Jun 4, 2022 · N8429X · Substantial damageNTSB ERA22FA257Accident · Serious injuriesClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · Fairfield, NJThe failure of maintenance personnel to properly secure the tail rotor crosshead drive plate and the failure of maintenance personnel, the maintenance pilot, and the accident pilot to detect the error, which led to the helicopter’s loss of tail rotor…Jun 4, 2022 · N98ZA · Substantial damageNTSB CEN22LA254Accident · No injuriesClass 4 · LimitedFinal reportKitfox Model 2 · San Marcos, TXThe pilot’s failure to maintain directional control during the landing roll.Jun 4, 2022 · N596JW · Substantial damageNTSB CEN22LA233Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Amarillo, TXThe loss of engine power due to a leak in the fuel control assembly. Contributing to the accident was the inadequate maintenance of the fuel control assembly.Jun 4, 2022 · N9087S · Substantial damageNTSB CEN22LA231Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC1B · El Paso, TXThe pilot’s failure to maintain directional control of the airplane during take off.Jun 4, 2022 · CF-DYB · Substantial damageNTSB WPR22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Oceanside, CAThe right-seated pilot’s failure to correct the left-seated pilot’s mismanagement of the engine thrust, which resulted in undesired speed and thrust oscillations during the final approach and a subsequent descent into terrain.Jun 3, 2022 · N7581F · Substantial damageNTSB ERA22LA260Accident · No injuriesClass 4 · LimitedFinal reportBoyle Joseph E BOYLE-JN 1 · Hagerstown, MDThe pilot’s failure to maintain control during takeoff in a crosswind, which resulted in abnormal runway contact and a runway excursion.Jun 3, 2022 · N68902 · Substantial damageNTSB ERA22LA258Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D1 · Pittsboro, NCThe student pilot, and flight instructor’s, inadequate preflight inspection, during which they failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.Jun 3, 2022 · N44374 · Substantial damageNTSB WPR22LA205Accident · No injuriesClass 4 · LimitedFinal reportBell HH-1H · Reno, NVThe pilot’s loss of control following the inadvertent placement of his foot behind the anti-torque pedal.Jun 2, 2022 · N91JK · Substantial damageNTSB WPR22FA196Accident · 2 fatalClass 3 · FieldFinal reportBeech 19A · Oroville, CAThe pilot’s failure to maintain proper airspeed during a turn and his exceedance of the airplane’s critical angle of attack, which resulted in an accelerated stall. Contributing to the accident was the improper placement of the fuel selector, which resulted…Jun 2, 2022 · N7641R · Substantial damageNTSB WPR22FA195Accident · 1 fatalClass 3 · FieldFinal reportMeyer Fred J Hornet · Lucerne Valley, CAThe pilot’s failure to maintain altitude during an aerobatic maneuver, which resulted in an impact with terrain.Jun 2, 2022 · N6366M · Substantial damageNTSB CEN22LA236Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Houston, TXThe pilot’s inability to compensate for a downdraft during the landing flare, which resulted in a hard, bounced landing, and subsequent loss of directional control.Jun 2, 2022 · N1396D · Substantial damageNTSB CEN22LA221Accident · Serious injuriesClass 3 · LimitedFinal reportCameron Balloons Z-90 · Burlington, WIThe pilot’s selection of an inappropriate landing location and his failure to avoid an oncoming freight train, which resulted in the train colliding with and dragging the balloon.Jun 2, 2022 · N65009 · Substantial damageNTSB CEN22FA223Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Bowling Green, MOThe pilots’ failure to maintain adequate airspeed while maneuvering, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Jun 2, 2022 · N1976E · Substantial damageNTSB ERA22LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Pemberton Township, NJThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of control.Jun 1, 2022 · N3658T · Substantial damageNTSB CEN22LA228Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Allport, ARA partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.Jun 1, 2022 · N5007R · Substantial damageNTSB CEN22LA220Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA-1B · River Falls, WIThe student pilot’s and flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jun 1, 2022 · N6298L · Substantial damageNTSB WPR22LA193Accident · No injuriesClass 3 · LimitedFinal reportVans RV-8 · Galice, ORThe in-flight failure of the crankshaft gear’s alignment dowel as a result of the retaining bolt not being installed, which lead to a total loss of engine power.May 31, 2022 · N298DM · Substantial damageNTSB ERA22LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Simsbury, CTThe pilot’s delayed decision to abort the landing, which resulted in a runway overrun.May 31, 2022 · N2973K · Substantial damageNTSB CEN22LA219Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cameron, TXThe flight crew not maintaining lateral control of the helicopter during hovering operation which resulted in a dynamic rollover.May 31, 2022 · N27574 · Substantial damageNTSB CEN22FA217Accident · 1 fatalClass 3 · FieldFinal reportCessna 162 · Memphis, TNPilot incapacitation due to an acute cardiac event.May 31, 2022 · N162KG · Substantial damageNTSB WPR22LA194Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · East Sound, WAThe pilot's failure to attain a proper touchdown point which, resulted in a runway overrun and collision with trees.May 30, 2022 · N20487 · Substantial damageNTSB WPR22LA191Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Carlsbad, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.May 30, 2022 · N722PA · Substantial damageNTSB ERA22LA248Accident · No injuriesClass 4 · LimitedFinal reportFoster William D Elite · Winter Haven, FLThe pilot’s improper flare and inadequate application of power during landing, resulting in a hard landing and substantial damage to the airplane.May 30, 2022 · N136WF · Substantial damageNTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…May 30, 2022 · N44508 · DestroyedNTSB WPR22FA189Accident · 2 fatalClass 3 · FieldFinal reportAirborne Windsports PTY Edge XT-912-L · Granite Shoals, TXThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while landing with a gusting wind.May 29, 2022 · N490F · Substantial damageNTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.May 29, 2022 · N1294E · Substantial damageNTSB ERA22LA247Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Jacksonville, FLThe pilot’s failure to maintain directional control during a touch-and-go landing after applying power for takeoff, which resulted in a runway excursion and noseover.May 29, 2022 · N8919S · Substantial damageNTSB ERA22LA245Accident · No injuriesClass 4 · LimitedFinal reportVan Lehn Hatz Classic · Frederick, MDThe pilot’s inadvertent application of the brakes during the landing roll which resulted in a nose over.May 29, 2022 · N85EX · Substantial damageNTSB CEN22LA227Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Morgan, TXA partial loss of engine power due to a corrosion-related fatigue crack of the No. 3 cylinder barrel.May 29, 2022 · N2148J · Substantial damageNTSB ANC22LA038Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Glacier View, AKThe pilot's failure to maintain adequate airspeed during the landing approach, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at an altitude too low to recover.May 29, 2022 · N4024Z · Substantial damageNTSB ERA22LA246Accident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Perry, GAThe pilot’s failure to properly configure the landing gear before landing.May 28, 2022 · N120PA · Substantial damageNTSB ERA22FA243Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · North Myrtle Beach, SCThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall at an altitude that was too low for recovery.May 28, 2022 · N4421M · Substantial damageNTSB CEN22LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Canyon Lake, TXThe pilot’s failure to retract the flaps during a go-around, which resulted in decreased climb performance and a subsequent collision with trees and terrain.May 28, 2022 · N3842Q · Substantial damageNTSB CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…May 28, 2022 · N178LB · DestroyedNTSB ANC22LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Big Lake, AKA hard landing for an unknown reason, resulting in substantial damage to the airplane.May 28, 2022 · N5896B · Substantial damageNTSB ANC22LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Gulkana, AKThe pilot’s failure to maintain directional during the landing rollout in crosswind conditions, which resulted in a runway excursion and impact with terrain.May 28, 2022 · N5773M · Substantial damageNTSB ERA22LA244Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7AC · Monongahela, PAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall.May 27, 2022 · N84583 · Substantial damageNTSB CEN22LA226Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Weiner, ARThe pilot’s failure to maintain clearance from the telephone pole during a low-level aerial application pass.May 27, 2022 · N579LA · DestroyedNTSB CEN22LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Princeton, MNThe pilot’s failure to maintain proper approach glide path, which resulted in a collision with trees.May 27, 2022 · N2899N · Substantial damageNTSB ANC22LA037Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Willow, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.May 27, 2022 · N1694M · Substantial damageNTSB WPR22FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna 172F · Show Low, AZThe pilot’s improper leaning of the engine during an extended period of time, which caused an exhaust valve to become stuck and led to the partial loss of engine power during the accident flight. Contributing to the accident was the pilot’s decision to…May 26, 2022 · N5532R · Substantial damageNTSB CEN22FA214Accident · 1 fatalClass 3 · FieldFinal reportCessna 152 · Wauwatosa, WIThe student pilot’s exceedance of the airplane’s critical angle of attack, which resulted in a stall from which the student pilot could not recover.May 26, 2022 · N4978B · Substantial damageNTSB DCA22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Springfield, MOThe flight’s encounter with clear air moderate turbulence.May 25, 2022 · N483UA · No damageNTSB CEN22LA212Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Madison, MNThe pilot’s failure to maintain aircraft control during landing that resulted in an impact with terrain.May 25, 2022 · N125WY · Substantial damageNTSB CEN22FA211Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Seagraves, TXThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and loss of control.May 24, 2022 · N78466 · DestroyedNTSB ANC22LA035Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-3 · Yakutat, AKThe pilot’s failure to determine the actual weight and balance of the airplane before departure, which resulted in the airplane being operated outside of the aft center of gravity limits and the subsequent aerodynamic stall on final approach. Contributing to…May 24, 2022 · N703TH · Substantial damageNTSB WPR22LA185Accident · No injuriesClass 4 · LimitedFinal reportFrazier Robert L RV-6A · Prineville, ORThe pilot’s improper landing flare which resulted in a bounced landing and loss of directional control.May 23, 2022 · N811RF · Substantial damageNTSB ERA22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · St. Petersburg-Clearwater, FLThe pilot’s inability to stop the airplane on the available runway, which resulted in a runway excursion and collision with an airport perimeter fence.May 23, 2022 · N47BP · Substantial damage