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 ERA22LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Hazard, KYThe pilot's loss of directional control while landing, which resulted in a runway excursion.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB WPR22LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Desert Camp, CAThe airplane’s loss of engine power due to carburetor icing.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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 terrainNTSB ERA22LA139Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Madisonville, TNA partial loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB WPR22LA107Accident · No injuriesClass 4 · LimitedFinal reportRoss Jonathan RV-8 · Pinon, AZThe pilot's failure to maintain clearance from power lines during low-level flight.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB CEN22LA132Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · Crete, NEThe pilot’s failure to maintain control of the airplane during takeoff.NTSB WPR22LA110Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11C-100 · Placerville, CALoss of directional control during landing with a tailwind.NTSB WPR22LA106Accident · No injuriesClass 4 · LimitedFinal reportMckenzie John P Europa XS · Tucson, AZThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB WPR22LA103Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-65 · Murphy, IDThe pilot's failure to maintain directional control during the landing roll.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…