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 ERA22LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Hazard, KYThe pilot's loss of directional control while landing, which resulted in a runway excursion.Mar 5, 2022 · N767RT · Substantial damageNTSB ANC22LA022Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206F · Newhalen, AKThe pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain.Mar 5, 2022 · N1853Q · Substantial damageNTSB CEN22LA139Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 7CCM · Winnsboro, LAThe pilot’s loss of airplane control during takeoff and subsequent impact with trees and terrain. Contributing to the accident was the pilot’s lack of experience in the accident airplane.Mar 4, 2022 · N555EK · Substantial damageNTSB WPR22LA117Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter Legend · Toquerville, UTThe pilot’s improper throttle input which resulted in a loss of engine power and subsequent impact with terrain.Mar 2, 2022 · N290TQ · DestroyedNTSB WPR22LA116Accident · No injuriesClass 4 · LimitedFinal reportLiberty Aerospace Liberty XL-2 · Las Cruces, NMThe airplane’s inability to climb during takeoff due to a degradation of engine performance due to high density altitude. Contributing to the accident was the pilot’s decision to continue the takeoff.Mar 2, 2022 · N552XL · Substantial damageNTSB WPR22LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Desert Camp, CAThe airplane’s loss of engine power due to carburetor icing.Mar 2, 2022 · N8814X · Substantial damageNTSB ERA22LA143Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Manassas, VAThe student pilot’s improper left rudder input after power application during the touch-and-go landing which resulted in a runway excursion and collision with airport lighting equipment. Contributing to the accident was the flight instructor’s inadequate…Mar 2, 2022 · N5627W · Substantial damageNTSB ERA22FA141Accident · 1 fatalClass 3 · FieldFinal reportExtra NG · St. Augustine, FLThe pilot’s excessive airspeed during landing, which resulted in a runway excursion and collision with terrain. Contributing to the accident was the loss of engine power for undetermined reasons and contributing to the severity of the accident were the…Mar 2, 2022 · N100NG · Substantial damageNTSB ERA22LA151Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · The Hammocks, FLThe pilot's failure to maintain an appropriate altitude above obstacles, which resulted controlled flight into a powerline.Mar 1, 2022 · N21EU · Substantial damageNTSB ERA22LA140Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Fallston, MDThe student pilot's unstabilized hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor's inadequate supervision of the student and his delayed remedial action.Mar 1, 2022 · N786SH · Substantial damageNTSB WPR22LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Buffalo, WYThe pilot’s failure to compensate for a wind gust during the landing roll, which resulted in a loss of directional control and collision with terrainFeb 28, 2022 · N1799P · Substantial damageNTSB ERA22LA139Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Madisonville, TNA partial loss of engine power for undetermined reasons.Feb 28, 2022 · N68218 · Substantial damageNTSB ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.Feb 28, 2022 · N7943Y · Substantial damageNTSB CEN22LA142Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Kokomo, INThe pilot’s decision to perform the takeoff on the soft, wet, turf runway, with the tailwheel equipped airplane, which resulted in a nose-over.Feb 28, 2022 · N72831 · Substantial damageNTSB CEN22LA134Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Campbellton, TXThe pilot’s fuel mismanagement, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with trees during a forced landing.Feb 28, 2022 · N108RF · Substantial damageNTSB ERA22LA142Accident · 2 fatalClass 3 · LimitedFinal reportVans RV-12IS · Big Pine Key, FLThe pilot’s inadequate preflight and in-flight weather planning and his improper decision to continue visual flight rules flight into an area of limited visibility in moderate precipitation, which resulted in a loss of airplane control due to spatial…Feb 27, 2022 · N123RR · DestroyedNTSB CEN22LA133Accident · No injuriesClass 4 · LimitedFinal reportKitfox 4-1200 · Woodstock, 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.Feb 27, 2022 · N494KF · Substantial damageNTSB WPR22LA112Accident · Minor injuriesClass 4 · LimitedFinal reportGregory S Miller GM CUB · Monument, ORThe failure of the pilot to maintain directional control during takeoff, which resulted in an impact with a tree.Feb 26, 2022 · N9013F · Substantial damageNTSB WPR22LA111Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Banning, CAThe solo student pilot's improper landing flare and bounced landing, which resulted in a runway excursion and impact with a parked vehicle and hanger.Feb 26, 2022 · N9010H · Substantial damageNTSB ERA22LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-150 · Savannah, GAThe student pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Feb 26, 2022 · N5208W · Substantial damageNTSB WPR22LA114Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 208B · Oceanside, CAThe pilot’s intentional inflight operation of the propeller in beta, which led to an aerodynamic lock, his inability to restore forward thrust, and subsequent collision with terrain.Feb 24, 2022 · N10JA · Substantial damageNTSB WPR22LA107Accident · No injuriesClass 4 · LimitedFinal reportRoss Jonathan RV-8 · Pinon, AZThe pilot's failure to maintain clearance from power lines during low-level flight.Feb 24, 2022 · N207RV · Substantial damageNTSB WPR22FA109Accident · 1 fatalClass 3 · FieldFinal reportDistar CZ D 13/15 SUN Dancer · Boulder City, NVThe pilot’s failure to maintain clearance from powerlines while maneuvering, which resulted in a wire strike and impact with terrain. Contributing to the accident was the pilot’s impairment from alcohol consumption and his use of diphenhydramine before the…Feb 24, 2022 · N588V · DestroyedNTSB ERA22FA137Accident · 2 fatalClass 3 · FieldFinal reportBeech 35 · Hilltown Township, PAThe pilots’ exceedance of the airplane’s critical angle of attack while practicing maneuvers during an instructional flight, which resulted in an aerodynamic stall and and a loss of airplane control.Feb 24, 2022 · N6129V · DestroyedNTSB CEN22FA131Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Fostoria, OHThe pilot’s loss of airplane control in night instrument meteorological conditions during the procedure turn of an instrument approach due to spatial disorientation, which resulted in a collision with terrain.Feb 23, 2022 · N3952W · DestroyedNTSB ANC22FA018Accident · 4 fatalClass 3 · FieldFinal reportSikorsky S-61N · Kekaha, HIThe improper installation of the fore/aft primary servo by maintenance personnel, which resulted in the attaching hardware backing out and which subsequently rendered the helicopter uncontrollable. Contributing to the accident was the company’s quality…Feb 22, 2022 · N615CK · DestroyedNTSB CEN22LA130Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker 800XP · Aspen, COThe flight crew’s decision to takeoff in tailwind conditions that were consistently above the airplane’s tailwind limitation, which resulted in a runway overrun following an aborted takeoff. Contributing was the flight crew’s use of the instantaneous wind…Feb 21, 2022 · N99AP · Substantial damageNTSB CEN22LA129Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Franklin, INThe pilot’s loss of control in the landing pattern resulting in an aerodynamic stall and impact with terrain.Feb 21, 2022 · N2521Z · Substantial damageNTSB ANC22LA019Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-3 · Deadhorse, AKThe pilot's failure to maintain a proper approach path in flat light conditions, which resulted in landing short of the runway and impact with terrain.Feb 21, 2022 · N413JP · Substantial damageNTSB WPR22LA108Accident · No injuriesClass 4 · LimitedFinal reportKitfox S7 · Phoenix, AZThe pilot’s improper landing flare and subsequent failure to maintain directional control of the airplane during landing, which resulted in a runway excursion.Feb 20, 2022 · N1248 · Substantial damageNTSB WPR22LA102Accident · No injuriesClass 4 · LimitedFinal reportDarrell D. Dugger Mustang II · Cheyenne, WYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in an aborted takeoff and collision with terrain.Feb 20, 2022 · N121DD · Substantial damageNTSB WPR22FA101Accident · 1 fatalClass 3 · FieldFinal reportMcdonnell Douglas 500N · Newport Beach, CAThe helicopter’s encounter with unanticipated right yaw during a low-altitude, low-airspeed, tight-radius orbit. Contributing to the accident was the pilot’s distraction during the orbit, which resulted in the loss of control, his fatigue due to his early…Feb 20, 2022 · N521HB · Substantial damageNTSB ERA22LA134Accident · Minor injuriesClass 3 · LimitedFinal reportSpangenberg AR-1KC · Sarasota, FLThe pilot’s improper control input during an aborted takeoff procedure, which resulted in a main rotor blade contacting the vertical stabilizer, a loss of control, and subsequent runway excursion.Feb 20, 2022 · N65PC · Substantial damageNTSB CEN22LA132Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · Crete, NEThe pilot’s failure to maintain control of the airplane during takeoff.Feb 20, 2022 · N6750U · Substantial damageNTSB WPR22LA110Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11C-100 · Placerville, CALoss of directional control during landing with a tailwind.Feb 19, 2022 · N800SW · Substantial damageNTSB WPR22LA106Accident · No injuriesClass 4 · LimitedFinal reportMckenzie John P Europa XS · Tucson, AZThe pilot’s improper landing flare, which resulted in a bounced landing.Feb 19, 2022 · N523WS · Substantial damageNTSB WPR22LA105Accident · No injuriesClass 4 · LimitedFinal reportShelton Joseph G S-7 · Buckeye, AZThe pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land which resulted in an aerodynamic stall and hard landing.Feb 19, 2022 · N242K · Substantial damageNTSB WPR22FA100Accident · 1 fatalClass 3 · FieldFinal reportMoynihan Richard D Vans RV-7A · White Hills, AZThe pilot’s improper aerobatic maneuver leading to an airspeed that exceeded the airplane’s design limits, which resulted in rudder flutter and an in-flight breakup.Feb 19, 2022 · N787NV · DestroyedNTSB CEN22LA127Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger II · Mountain Home, TXThe non-certificated pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.Feb 19, 2022 · N438RN · Substantial damageNTSB WPR22LA104Accident · No injuriesClass 4 · LimitedFinal reportChristopher P Gage Shortfield Explorer · Coeur d'Alene, IDThe pilot’s improper landing flare which, resulted in a bounced landing, loss of airplane control and subsequent nose over.Feb 18, 2022 · N141E · Substantial damageNTSB WPR22LA103Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-65 · Murphy, IDThe pilot's failure to maintain directional control during the landing roll.Feb 18, 2022 · N36430 · Substantial damageNTSB CEN22LA126Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-500 · Detroit, MIThe pilot’s decision to land on the contaminated runway with previous reports of unfavorable braking action.Feb 18, 2022 · N68NH · Substantial damageNTSB WPR22FA098Accident · 1 fatalClass 3 · FieldFinal reportBell UH-1H · Coalinga, CAThe pilot’s loss of situational awareness for reasons that could not be determined given the available evidence, which led to controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the helicopter while ill and…Feb 17, 2022 · N72297 · Substantial damageNTSB ERA22LA135Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · White Plains, NYThe pilot’s failure to maintain stabilized lateral control during landing in gusty conditions which resulted in a dynamic rollover when the skids contacted the platform unevenly.Feb 17, 2022 · N929WA · Substantial damageNTSB CEN22LA123Accident · Serious injuriesClass 3 · LimitedFinal reportPitts S-1T · Spring, TXThe failure of maintenance personnel to properly connect the throttle cable, which led to the pilot’s inability to control engine power during the initial climb. Contributing to the accident was the pilot’s misjudgment of the headwind during the forced…Feb 17, 2022 · N731FL · Substantial damageNTSB ERA22LA130Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Washington, NCThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.Feb 16, 2022 · N114BR · Substantial damageNTSB ERA22LA128Accident · No injuriesClass 4 · LimitedFinal reportStinson 108 · Pahokee, FLThe student pilot’s incorrect tail wheel takeoff procedure, and the flight instructor’s lack of remedial action, which resulted in a nose over.Feb 16, 2022 · N6493 · Substantial damageNTSB ERA22FA126Accident · 1 fatalClass 3 · FieldFinal reportBeech 58 · Lexington, NCInadequate maintenance, which led to a partial loss of both right and left engine power during takeoff, and the pilot’s subsequent failure to maintain airspeed while maneuvering with one engine at low altitude. Contributing to the accident was the pilot’s…Feb 16, 2022 · N58LF · DestroyedNTSB ERA22LA123Accident · No injuriesClass 3 · LimitedFinal reportBritten-Norman BN-2A-9 · Culebra, PRThe flight crew’s failure to arrest the descent rate during the non-standard approach, which resulted in a hard landing and failure of the right-wing structure. Contributing was the flight instructor’s selection of a challenging approach for initial training.Feb 15, 2022 · N821RR · Substantial damageNTSB ERA22LA120Accident · 8 fatalClass 3 · LimitedFinal reportPilatus PC-12/47E · Beaufort, NCThe pilot’s inadequate preflight planning, inadequate inflight monitoring of the airplane’s flight parameters, and his failure to regain control of the airplane following entry into an inadvertent aerodynamic stall. The pilot’s likely spatial disorientation…Feb 13, 2022 · N79NX · Destroyed