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 ERA23LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Winston-Salem, NCThe pilot’s loss of directional control upon landing which resulted in substantial damage to the left wing and left horizontal stabilizer.NTSB WPR23FA345Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Reno, NVThe failure of both the Race 14 and Race 6 pilots to see and avoid each other while in the airport traffic pattern. Contributing to the accident was both pilots’ failure to fly the standard downwind and base legs.NTSB CEN23LA420Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · South Saint Paul, MNThe pilot’s inadvertent brake application during takeoff which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot’s improper seat position.NTSB ANC23LA082Accident · No injuriesClass 4 · LimitedFinal reportHelio H-295 · Fairbanks, AKThe pilot’s encounter with windshear during initial climb out, which resulted in a loss of control.NTSB ANC23LA078Accident · No injuriesClass 3 · LimitedFinal reportRhodes Steven D SR3500 · Nenana, AKA total loss of engine power due to fuel starvation. Contributing was the owner/builder’s inadequate maintenance.NTSB WPR23LA346Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Apple, IDFuel starvation due to the pilot’s incorrect movement of the fuel selector valve to OFF, which resulted in a loss of engine power.NTSB ANC23LA085Accident · Serious injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · Johnson River, AKThe ground crew’s failure to remain clear of a tag line during sling load operations, resulting in his entanglement.NTSB ANC23LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s failure to maintain directional control during after encountering a wind gust during landing that resulted in an impact with terrain.NTSB WPR23FA344Accident · 1 fatalClass 3 · FieldFinal reportSeawind 3000 · Bellevue, WAThe pilot’s loss of airplane control after encountering a lake swell and skipping during takeoff.NTSB CEN23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportRans S6 · LIberty, MOThe inflight fire and impact with terrain for reasons that could not be determined due to extensive fire damage.NTSB ERA23LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Cortland, NYThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a noseover. Contributing was the pilot’s lack of familiarity with the airplane.NTSB ERA23LA371Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150G · Cross Keys, NJThe pilot’s failure to maintain adequate airspeed during the banner pickup, which resulted in a low altitude aerodynamic stall/spin.NTSB ERA23FA370Accident · 1 fatalClass 3 · FieldFinal reportErcoupe 415 · Fitzgerald, GAThe pilot’s failure to perform pre-takeoff engine runup and carburetor heat check procedures, which resulted in rotation with inadequate climb performance, and his subsequent failure to maintain adequate airspeed and exceedance of the airplane’s critical…NTSB CEN23LA430Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · West Bend, WIThe pilot’s inadequate landing flare that resulted in a hard landing and impact with the runway.NTSB ANC23LA077Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.NTSB ANC23FA074Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-18-150 · St. Mary's, AKThe pilot’s decision to operate the airplane above its maximum certificated gross weight, and his installation of an unapproved external load that degraded takeoff performance and flight characteristics resulting in a loss of airplane control during takeoff…NTSB CEN23FA409Accident · 1 fatalClass 3 · FieldFinal reportThrush S2R-T660 · Ardoch, NDThe pilot’s failure to maintain clearance from a guy wire during an aerial application flight.NTSB ANC23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Healy, AKThe pilot’s selection of an unsuitable landing site, resulting in a nose over.NTSB CEN23LA414Accident · Minor injuriesClass 4 · LimitedFinal reportBuckeye Dream Machine · Fortuna, MOThe non-certificated pilot’s failure to maintain the unregistered powered parachute’s clearance from power lines.NTSB ANC23LA081Accident · Serious injuriesClass 4 · LimitedFinal reportPiper/Gerbi Charles R PA 18-150 · Juneau, AKThe student pilot’s failure to maintain altitude after the airplane encountered a downdraft while maneuvering over an area of hilly terrain.NTSB WPR23LA338Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Balch Camp, CAThe pilot’s inadequate performance planning for the operation that resulted in an excessive gross weight for the operating conditions, leading to a loss of altitude during maneuvering and contact with trees. Contributing to the accident was the pilot’s…NTSB ANC23LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Beluga, AKThe pilot’s delayed go-around decision with insufficient runway remaining.NTSB CEN23LA406Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Elk Grove Village, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing. Also causal was the pilot’s decision to go around with minimum fuel.NTSB WPR23LA355Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Woodland, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA23LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Norwood, MAThe pilot’s failure to fly an appropriate glide path during the landing approach, which resulted in a collision with approach lights and the ground short of the intended runway.NTSB DCA23LA445Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Hebron, KYAn inadvertent encounter with convectively induced turbulence (CIT) during descent.NTSB CEN23LA408Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Berryville, ARThe pilot’s failure to maintain aircraft control during the attempted go-around.NTSB CEN23LA404Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Arcola, TXThe instructor’s failure to re-apply engine power during a power recovery after a practice autorotation which resulted in a hard landing.NTSB WPR23LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna T210H · Santa Rosa, CAThe pilot’s failure to configure the landing gear during the landing approach.NTSB ERA23LA388Accident · No injuriesClass 3 · LimitedFinal reportRemos GX · Fort Pierce, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.NTSB CEN23FA401Accident · 2 fatalClass 3 · FieldFinal reportCessna 150K · Huntsville, TXA partial loss of engine power due to fuel starvation caused by a fuel system blockage, and the flight instructor’s subsequent failure to maintain adequate airspeed after the loss of engine power, which resulted in the airplane exceeding its critical angle of…NTSB WPR23LA340Accident · No injuriesClass 3 · LimitedFinal reportRutan Long-EZ · Bullhead City, AZThe pilot’s improper flair resulting in a hard landing.NTSB ANC23LA071Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · King Salmon, AKThe failure of both pilots to see and avoid while en route, which resulted in a midair collision.NTSB CEN23LA402Accident · No injuriesClass 3 · LimitedFinal reportVans RV14 · Orchard, TXThe failure of an alternator belt and the builder/previous owner’s incorrect electrical wiring of the airplane’s other alternator, which resulted in a total loss of electrical and engine power.NTSB CEN23LA398Accident · Minor injuriesClass 3 · LimitedFinal reportVan's RV-12 · Crystal, MNThe pilot’s improper landing flare, which resulted in a bounced landing and an overstress fracture of the nose landing gear strut.NTSB CEN23LA397Accident · Serious injuriesClass 4 · LimitedFinal reportTitanium Auto Gyro Titanium Explorer · Falcon, COThe pilot’s failure to establish a proper airspeed before becoming airborne, which resulted in an inability to climb out of ground effect and subsequent hard landing. Contributing to the accident was high-density altitude.NTSB ERA23LA391Accident · Minor injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7 · Anderson, SCThe pilot’s failure to avoid trees during the descent for landing, resulting in substantial damage to the balloon.NTSB ERA23LA389Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Baltimore, MDThe pilot’s failure to maintain control of the airplane during the aborted landing, which resulted in a collision with a taxiway light.NTSB ERA23FA358Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR20 · Toms River, NJThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion), which resulted in impact with trees and terrain.NTSB CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.NTSB CEN23LA396Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Neola, IAThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC23LA069Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Cordova, AKThe pilot’s exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall and loss of airplane control.NTSB WPR23LA334Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Prescott, AZThe pilot-in-command’s inadequate preflight planning for the high density altitude and relative humidity conditions and his failure to recognize the need to reject the takeoff, allowing the student pilot to execute an abnormally long takeoff roll and apply…NTSB WPR23LA333Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Three Rocks, CAThe airplane’s exceedance of the critical angle of attack, resulting in an aerodynamic stall and impact with terrain.NTSB WPR23LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Coolidge, AZThe pilot's failure to extend the landing gear before landing.NTSB ERA23LA360Accident · No injuriesClass 3 · LimitedFinal reportBrown Benjamin C Challenger II · Moultonborough, NHA loss of engine power due to a loss of compression in one of the engine’s two cylinders.NTSB CEN23LA393Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Plover, WIThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA331Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Ennis, MTThe pilot's failure to extend the landing gear before landing.NTSB CEN23LA392Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Midlothian, TXThe pilot’s failure to maintain directional control during landing which resulted in the right main landing gear collapse.NTSB CEN23LA389Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Heli 530FF · Liberty Hill, TXThe pilot’s improper recovery from a practice autorotation resulting in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.