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 WPR21LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 190 · Camarillo, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll which resulted in a runway excursion and subsequent nose over.Mar 7, 2021 · N190RC · Substantial damageNTSB ERA21LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300 · Brevard, NCThe pilot’s improper landing flare, which resulted in a hard landing, overstress fracture of components of the left main landing gear, and subsequent runway excursion.Mar 7, 2021 · N94GF · Substantial damageNTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.Mar 7, 2021 · N185RF · Substantial damageNTSB CEN21LA151Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35 · Palestine, TXA total loss of engine power due to the flight crew incorrectly placing the fuel selector between fuel tank detents, which resulted in fuel starvation. Contributing to the accident was the lack of a placard on the fuel selector, the lack of obvious fuel tank…Mar 6, 2021 · N3394V · Substantial damageNTSB CEN21LA149Accident · No injuriesClass 4 · LimitedFinal reportAeropro CZ S R O A220 · Loveland, COThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with terrain.Mar 6, 2021 · N135C · Substantial damageNTSB CEN21FA150Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1B · Berwyn, NEA loss of control and subsequent impact with terrain as a result of spatial disorientation during cruise in dark night conditions.Mar 6, 2021 · N166WW · DestroyedNTSB ANC21LA021Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusty tailwind conditions, which resulted in a runway excursion and nose down.Mar 6, 2021 · N7054K · Substantial damageNTSB WPR21LA123Accident · Serious injuriesClass 3 · LimitedFinal reportAermacchi Impala MB-326M · Edwards, CAThe flight crew’s restricted rudder inputs while in an inverted spin that precluded spin recovery.Mar 5, 2021 · N155TP · DestroyedNTSB CEN21LA157Accident · Minor injuriesClass 4 · LimitedFinal reportPost Thorp T-18 · Indianapolis, INThe pilot’s failure to maintain directional control during landing with a crosswind.Mar 5, 2021 · N763LG · Substantial damageNTSB CEN21LA148Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Moorhead, MSThe pilot did not maintain clearance from a powerline during an aerial application flight.Mar 5, 2021 · N41068 · Substantial damageNTSB ANC21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKInstallation of improper hardware on the ski check cable. Contributing to the accident was the inadequate inspection of the ski yokes, which resulted in the subsequent failure of the right main landing gear ski yoke and collapse of the right main landing gear…Mar 5, 2021 · N1848R · Substantial damageNTSB WPR21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172G · Sisters, ORA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.Mar 4, 2021 · N4456L · Substantial damageNTSB ERA21LA158Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Hampton, GAThe student pilot’s improper flare while landing with a gusting crosswind which resulted in a hard landing and separation of the left landing gear.Mar 4, 2021 · N150VR · Substantial damageNTSB ERA21FA148Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Purcellville, VAThe pilot's improper decision to depart from the short turf runway with a tailwind.Mar 4, 2021 · N67013 · Substantial damageNTSB ANC21LA023Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s selection of unsuitable terrain for taxi, which resulted in the airplane encountering a crevasse.Mar 4, 2021 · N43300 · Substantial damageNTSB ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.Mar 3, 2021 · N2374J · Substantial damageNTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.Mar 2, 2021 · N4629K · Substantial damageNTSB ANC21LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · McGrath, AKThe pilot’s selection of an unsuitable landing surface.Mar 1, 2021 · N1748R · Substantial damageNTSB ERA21LA143Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C · Panacea, FLThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack during short final approach, which resulted in an aerodynamic stall at low altitude.Feb 28, 2021 · NC7014H · Substantial damageNTSB ERA21FA142Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8E · Jupiter, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane, resulting in an unsecured engine cowl that…Feb 28, 2021 · N2960K · Substantial damageNTSB CEN21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Aspen, COThe pilot’s failure to maintain directional control on landing.Feb 28, 2021 · N6962S · Substantial damageNTSB WPR21LA120Accident · No injuriesClass 4 · LimitedFinal reportPiggott John H Bearhawk · Eatonville, WAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.Feb 27, 2021 · N347JP · Substantial damageNTSB ERA21LA145Accident · No injuriesClass 4 · LimitedFinal reportGeorge Matthew Wagoner Zenith 601 HD · Englewood, FLThe pilot’s inadequate compensation for gusty wind conditions, which resulted in a hard landing. The rough terrain of the runway also contributed to the outcome.Feb 27, 2021 · N2614 · Substantial damageNTSB WPR21LA134Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Tucson, AZThe pilot’s distraction in the cockpit which interrupted his pre-landing checklist which resulted in his failure to configure the landing gear prior to touchdown.Feb 26, 2021 · N4499D · Substantial damageNTSB ERA21FA140Accident · 3 fatalClass 3 · FieldFinal reportCessna R182 · Gainesville, GAThe pilot’s loss of control due to spatial disorientation. Contributing to the accident was the pilot’s decision to depart into low instrument meteorological conditions.Feb 26, 2021 · N3652C · DestroyedNTSB CEN21LA139Accident · No injuriesClass 4 · LimitedFinal reportHughes 369 · Kaufman, TXThe pilot’s failure to maintain clearance from a power line during low-level maneuvering.Feb 26, 2021 · N58431 · Substantial damageNTSB CEN21LA153Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC130 · Tulsa, OKThe pilot’s improper decision to approach the airport and enter a low altitude hover with a gusting quartering tailwind, which resulted in a loss of tail rotor effectiveness during a turn at a low altitude.Feb 25, 2021 · N259AM · Substantial damageNTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.Feb 25, 2021 · UNREG · Substantial damageNTSB WPR21LA118Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-1B · St Johns, AZThe pilot’s decision to operate with a demonstrated crosswind velocity above the airplane’s performance capabilities which resulted in a loss of airplane control and collision with terrain.Feb 24, 2021 · N30JL · Substantial damageNTSB ERA21LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Winchester, VAThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.Feb 24, 2021 · N7832X · Substantial damageNTSB ERA21LA136Accident · Serious injuriesClass 4 · LimitedFinal reportTurcotte JR Robert L RV6 · North Hampton, NHThe pilot’s failure to maintain directional control during the landing in a crosswind condition, which resulted in a runway excursion.Feb 24, 2021 · N642LT · Substantial damageNTSB ERA21LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot under instruction’s improper landing flare and attempted go-around which resulted in an aerodynamic stall, and subsequent loss of control. Contributing to the accident was the flight instructor’s delayed remedial action.Feb 22, 2021 · N885AC · Substantial damageNTSB ERA21LA134Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · St. Marys, PAThe pilot’s decision to continue the approach to a snow-covered runway in low-visibility conditions with limited ability to visually differentiate the left runway edge from the snow berm that ran along that side of the runway.Feb 22, 2021 · N84HA · Substantial damageNTSB ERA21FA135Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Mayfield, KYThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall, loss of airplane control, and subsequent impact with terrain.Feb 22, 2021 · N383DB · Substantial damageNTSB CEN21LA135Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58 · Greensburg, LAThe pilot’s failure to maintain lateral control and terrain clearance while hovering, which resulted in a dynamic rollover.Feb 22, 2021 · N902LP · Substantial damageNTSB CEN21LA134Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Indianapolis, INThe pilot’s improper landing flare that resulted in a bounced touch and go landing and subsequent nose wheel separation.Feb 21, 2021 · N465US · Substantial damageNTSB CEN21LA136Accident · No injuriesClass 3 · LimitedFinal reportLearjet 55 · Jeffersonville, INThe flight crew’s failure to verify the correct runway for landing, which resulted in a landing on a snow contaminated runway and resulting damage to the airplane. The illumination of the lights associated with the closed runway contributed to the accident.Feb 19, 2021 · N559RA · Substantial damageNTSB ERA21LA132Accident · No injuriesClass 3 · LimitedFinal reportCessna 150G · Indian Head, MDThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a total loss of engine power. Contributing was the flight instructor’s mismanagement of the precautionary landing approach.Feb 17, 2021 · N8428J · Substantial damageNTSB WPR21LA113Accident · No injuriesClass 4 · LimitedFinal reportCubcrafter CCK-1865 · Quartzite, AZThe pilot’s failure to maintain airplane control during takeoff while operating in gusting wind conditions, which resulted in a collision with a cactus and the subsequent impact with terrain.Feb 16, 2021 · N53KK · Substantial damageNTSB CEN21FA130Accident · 2 fatalClass 3 · FieldFinal reportVelocity Vtwin · Janesville, WIThe exceedance of the maximum airspeed for flight with the landing gear extended, which resulted in a separation of the right main landing gear door that subsequently impacted the right propeller and resulted in a total loss of right engine power.…Feb 16, 2021 · N13VT · Substantial damageNTSB ERA21FA130Accident · 4 fatalClass 3 · FieldFinal reportBell 206 · St Thomas, CBA total loss of engine power due to fatigue failure of two of the stage 3 compressor blades. Contributing to the failure of the compressor blades was the failure of maintenance personnel to inspect the compressor at the recommended interval for operation in…Feb 15, 2021 · N13AT · DestroyedNTSB WPR21LA111Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA46R-350T · Tehachapi, CAThe pilot’s encounter with mountain wave activity with severe turbulence, which resulted in a loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a preflight weather briefing.Feb 14, 2021 · N40TS · DestroyedNTSB WPR21LA110Accident · No injuriesClass 3 · LimitedFinal reportDassault FALCON900EX · San Diego, CAThe flight crew’s operation of the airplane outside of the manufacturer’s specified weight and balance limitations and with an improper trim setting, which resulted in the airplane’s inability to rotate during the attempted takeoff. Contributing to the…Feb 13, 2021 · N823RC · Substantial damageNTSB ANC21LA017Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-6-235 · Tyonek, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the airplane encountering deep snow and coming to rest inverted.Feb 13, 2021 · N56517 · Substantial damageNTSB CEN21LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Prairie du Sac, WIThe student pilot’s loss of directional control during takeoff, which resulted in the collision with a snowbank. Contributing to the accident was the compacted snow conditions on the runway surface.Feb 12, 2021 · N3477E · Substantial damageNTSB ERA21LA131Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Lake Placid, FLThe pilot’s failure to ensure that the aft seat cushion was adequately secured, which resulted in its movement, subsequent interference with the flight controls, and a hard landing.Feb 10, 2021 · N8183C · Substantial damageNTSB ERA21LA127Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7 · Thonotosassa, FLThe pilot’s failure to apply adequate torque on the fuel pressure line aluminum adaptor fitting, which resulted in the loosening of the adapter, a loss of fuel flow, and a total loss of engine power. Contributing to the accident was the pilot’s choice of a…Feb 9, 2021 · N611E · Substantial damageNTSB WPR21LA112Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-180C · Price, UTThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a ground loop, runway excursion and collision with terrain.Feb 8, 2021 · N62055 · Substantial damageNTSB WPR21LA109Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopter 369 · Mesa, AZThe pilot’s improper pitch attitude for landing and the inadequate supervision of the flight instructor, resulted in the main rotor blades impacting the tail boom.Feb 8, 2021 · N7032V · Substantial damageNTSB WPR21LA108Accident · No injuriesClass 3 · LimitedFinal reportAbbett Gerry Lancair Evolution · Saratoga, WYA windshield failure during cruise flight due to stress concentrations in the bond area as a result of improper assembly of the windshield.Feb 8, 2021 · N7569A · Substantial damage