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 ERA21LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rochester, NYThe pilot’s excessive speed and improper landing flare which resulted in abnormal runway contact, porpoising, and substantial damage.NTSB ERA21LA295Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Point Harbor, NCThe noncertificated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation over a large body of water and a high velocity impact with the water. Contributing to the accident…NTSB ERA21LA294Accident · No injuriesClass 4 · LimitedFinal reportTurbine Cubs Of Wyoming PA-18 Super CUB · Dinwiddie, VAThe pilot’s failure to maintain control while taxiing on soft ground, which resulted in a nose-over.NTSB CEN21FA330Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Elgin, MNThe pilot’s decision to operate the helicopter under powerlines, which resulted in a main rotor blade striking a powerline, causing the helicopter to descend from a low altitude and impact terrain.NTSB ANC21LA062Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK 1 · King Salmon, AKThe pilot’s exceedance of the floatplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control.NTSB WPR21LA281Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Cascade, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.NTSB ERA21LA293Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Frostproof, FLThe pilot’s loss of directional control during takeoff as a result of a child reaching for and manipulating the flight controls.NTSB CEN21FA327Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8F · Comstock, TXImpact with terrain for reasons that could not be determined based on the available information.NTSB CEN21LA326Accident · Serious injuriesClass 3 · LimitedFinal reportGary James Lail Zenith CH 750 Cruzer · Blossom, TXThe improper swaging of the rudder control cable, which disconnected during flight and resulted in the loss of control.NTSB WPR21FA273Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Angwin, CAThe pilot's exceedance of the airplane’s critical angle of attack during an aborted landing after an unstabilized approach and hard landing, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing to the accident was the pilot’s…NTSB ERA21LA292Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Princeton, KYThe pilot’s inadequate preflight planning in that he failed to accurately determine the takeoff weight of the helicopter, which resulted in exceeding the helicopter’s maximum weight capability.NTSB CEN21LA323Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Refugio, TXThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB ANC21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Skwentna, AKThe pilot’s use of excessive braking which resulted in a nose-over.NTSB ERA21LA329Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Sterling, MAThe pilot’s failure to maintain the glider’s stability in the roll axis during the takeoff roll, which resulted in a dragged wingtip and ground loop.NTSB ERA21LA290Accident · 1 fatalClass 3 · LimitedFinal reportCameron 0-105 · Piermont, NHThe balloon pilot’s delay in relighting the burner, which resulted in a hard landing and his ejection from the balloon.NTSB CEN21LA324Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Rhinelander, WIThe pilot’s failure to maintain directional control during landing.NTSB CEN21LA322Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Edcouch, TXThe pilot’s inadequate compensation for a gusting wind during takeoff.NTSB CEN21FA320Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Muscatine, IAThe noninstrument-rated pilot’s continued visual flight under a thunderstorm, where he encountered reduced visibility due to heavy precipitation, resulting in a loss of control due to spatial disorientation.NTSB WPR21FA270Accident · 2 fatalClass 3 · FieldFinal reportCessna 421C · Monterey, CAThe pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…NTSB CEN21FA314Accident · 1 fatalClass 3 · FieldFinal reportPZL Mielec M18 · Seiling, OKThe pilot’s in-flight loss of control due to the structural failure of a wing fitting and separation of the outboard wing section. Also causal were the inadequate wing fitting inspections, which failed to detect the initial corrosion and crack before it…NTSB WPR21LA267Accident · No injuriesClass 4 · LimitedFinal reportJust JA30 Superstol · May, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground-loop and collision with terrain.NTSB CEN21LA313Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Newell, IAThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.NTSB ANC21LA063Accident · No injuriesClass 4 · LimitedFinal reportBeech F35 · Yakutat, AKThe pilot’s failure to ensure adequate runway distance for landing.NTSB ANC21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Rampart, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose over.NTSB WPR21LA287Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Chandler, AZThe pilot’s delayed decision to abort the takeoff due to insufficient airspeed.NTSB WPR21LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Petaluma, CAThe pilot’s improper landing flare which resulted in a hard landing following a partial loss of electrical power. Contributing to the accident was the pilot’s distraction and hampered visual function.NTSB WPR21FA266Accident · 2 fatalClass 3 · FieldFinal reportBeech C90 · Wikieup, AZThe failure and separation of the left wing’s outboard section due to a fatigue crack in the lower spar cap. Contributing to the accident was the operator’s decision to repair the wing spar instead of replacing it as recommended by the aircraft manufacturer.…NTSB WPR21FA265Accident · 2 fatalClass 3 · FieldFinal reportNorth Wing Mustang · Albany, ORThe noncertificated pilot’s loss of aircraft control after a low-level turn with a bank angle that exceeded the manufacturer’s operating limitations.NTSB ERA21LA283Accident · 1 fatalClass 3 · LimitedFinal reportBailey N Moyes Dragonfly · Charlestown, NHThe passenger’s decision to continue an unstable approach while at low altitude and in proximity to a known obstacle, which resulted in a collision with power lines.NTSB CEN21LA315Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Longmont, COThe loss of performance for reasons that could not be determined.NTSB WPR21LA285Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Missoula, MTThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB WPR21LA276Accident · No injuriesClass 4 · LimitedFinal reportPayne Steven R RV-8 · Hillsboro, ORThe second pilot’s diverted attention while taxing which, resulted in his failure to maintain clearance from another airplane holding short of the runway.NTSB CEN21LA432Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Berlin, ILThe pilot’s failure to maintain control of the helicopter with a stuck skid, which resulted in a dynamic rollover.NTSB ANC21LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2-L-20 · Coffman Cove, AKThe pilot’s impact with a buoy on takeoff which resulted in a nose-over.NTSB WPR21LA274Accident · No injuriesClass 4 · LimitedFinal reportScott Mills CCX-2000 · Independence, ORThe pilot's loss of directional control while landing, which resulted in a runaway excursion and subsequent ground loop.NTSB WPR21LA268Accident · No injuriesClass 3 · LimitedFinal reportBell 212HP · Weed, CAThe pilot’s failure to maintain altitude during an approach to a lake. Contributing to the accident was the pilot’s failure to release the full water bucket as the helicopter was settling, which reduced the helicopter’s out-of-ground-effect performance.NTSB ERA21LA285Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Greensboro, NCThe student pilot’s improper flare which resulted in abnormal ground contact and loss of control.NTSB ERA21LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bishopville, SCThe flight instructor’s inadequate supervision of the student during a go-around, which resulted in a loss of lift and a subsequent collision with the VASI lights.NTSB CEN21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportEslinger C W/Eslinger S M Cassutt · Pryor, OKThe pilot’s high flare and failure to execute a go-around which resulted in a hard landing and runway excursion.NTSB ANC21LA058Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Anchorage, AKThe pilot’s impact with a log while dragging an off-airport landing site.NTSB WPR21LA367Accident · No injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Roche Harbor, WAThe pilot’s failure to maintain bank control during the landing roll which resulted in the right wing impacting the water’s surface.NTSB ERA21LA287Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46-500TP · Manteo, NCThe improperly secured pneumatic compressor discharge air (P3) line coupling nut on the engine, which ultimately allowed the nut to back off resulting in a partial loss of engine power.NTSB ERA21LA279Accident · No injuriesClass 4 · LimitedFinal reportTextron T206 · Statesville, NCThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and collision with terrain.NTSB CEN21LA318Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Nappanee, INThe pilot’s failure to maintain clearance from the tower during low-level agricultural operations.NTSB CEN21LA309Accident · No injuriesClass 3 · LimitedFinal reportTitan T-51D · Ashtabula, OHThe tripped engine control computer circuit breaker caused by an excessive electrical load on the system, which resulted in a complete loss of engine power during the initial climb.NTSB ANC21LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Kenney Lake, AKThe pilot’s failure to maintain adequate clearance from a tree during takeoff, which resulted in a loss of directional control and impact with terrain.NTSB WPR21LA260Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Wells, NVThe pilot’s decision to takeoff with a tailwind, which resulted in an impact with terrain.NTSB CEN21LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Blanco, TXThe unexpected change in wind speed and direction during the landing which resulted a runway overrun.NTSB CEN21LA310Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Wapakoneta, OHThe pilot’s inadequate engine hand propping procedure resulting in the unoccupied airplane’s unintended movement and subsequent impact with a hangar.NTSB WPR21LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182C · Coeur D Alene, IDThe pilot’s failure to attain a proper touchdown point due to excessive airspeed, which resulted in a runway excursion and collision with an object near the end of the runway.