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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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…NTSB CEN22LA254Accident · No injuriesClass 4 · LimitedFinal reportKitfox Model 2 · San Marcos, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB 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.NTSB CEN22LA231Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC1B · El Paso, TXThe pilot’s failure to maintain directional control of the airplane during take off.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA22LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Simsbury, CTThe pilot’s delayed decision to abort the landing, which resulted in a runway overrun.NTSB 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.NTSB CEN22FA217Accident · 1 fatalClass 3 · FieldFinal reportCessna 162 · Memphis, TNPilot incapacitation due to an acute cardiac event.NTSB 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.NTSB WPR22LA191Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Carlsbad, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.NTSB 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.NTSB 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…NTSB 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.NTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA22LA246Accident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Perry, GAThe pilot’s failure to properly configure the landing gear before landing.NTSB 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.NTSB 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.NTSB 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…NTSB ANC22LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Big Lake, AKA hard landing for an unknown reason, resulting in substantial damage to the airplane.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC22LA037Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Willow, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.NTSB 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…NTSB 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.NTSB DCA22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Springfield, MOThe flight’s encounter with clear air moderate turbulence.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.