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 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.NTSB 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.NTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN21LA157Accident · Minor injuriesClass 4 · LimitedFinal reportPost Thorp T-18 · Indianapolis, INThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB CEN21LA148Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Moorhead, MSThe pilot did not maintain clearance from a powerline during an aerial application flight.NTSB 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…NTSB 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.NTSB 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.NTSB ERA21FA148Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Purcellville, VAThe pilot's improper decision to depart from the short turf runway with a tailwind.NTSB 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.NTSB 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.NTSB 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.NTSB ANC21LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · McGrath, AKThe pilot’s selection of an unsuitable landing surface.NTSB 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.NTSB 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…NTSB CEN21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Aspen, COThe pilot’s failure to maintain directional control on landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN21LA139Accident · No injuriesClass 4 · LimitedFinal reportHughes 369 · Kaufman, TXThe pilot’s failure to maintain clearance from a power line during low-level maneuvering.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.