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 CEN24LA007Accident · Minor injuriesClass 4 · LimitedFinal reportFairchild 24 G · Peyton, COThe pilot’s excessive brake application during landing rollout led to the airplane nosing over.NTSB ERA24LA004Accident · No injuriesClass 4 · LimitedFinal reportMichael J Wright SA300 · Georgetown, KYThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting a gusting crosswind, resulting in a runway excursion and nose over.NTSB ERA24FA003Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · Croydon, NHThe pilot’s loss of control during the initial climb in dark night conditions due to spatial disorientation, which resulted in a steep banking descent into trees and terrain. Contributing to the accident was the pilot’s lack of recent night flight experience,…NTSB CEN24LA006Accident · 1 fatalClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Saint Peter, MNThe pilot's failure to maintain clearance from power lines during low-level maneuvering through a river valley.NTSB ANC24LA001Accident · No injuriesClass 4 · LimitedFinal reportNathan A Rehak CAW-12 · Beluga, AKThe pilot’s loss of control after failing to determine wind direction during landing in variable, gusting wind conditions.NTSB ERA24LA005Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Harrisonburg, VAThe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of control and subsequent runway excursion.NTSB WPR24LA007Accident · No injuriesClass 4 · LimitedFinal reportScott And Laura Hoisington CCX-2000 · South Lake Tahoe, CAThe pilot’s loss of directional control during landing roll, which resulted in a ground loop and collision with terrain.NTSB ERA24LA013AccidentClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Chesterfield, VAA hard landing that resulted in substantial damage to the airplane’s right wing.NTSB WPR24FA004Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-44-180 · Newberg, ORThe pilot receiving instruction’s failure to maintain control of the airplane and the flight instructor’s inadequate supervision of the flight, which resulted in a stall/spin from which they were unable to recover.NTSB WPR24LA006Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-300 · Phoenix, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR24LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 340A · Hayward, CAThe pilot’s sudden incapacitation from effects of a previously undiagnosed underlying heart disease, which resulted in his loss of control of the airplane and subsequent impact with terrain.NTSB WPR24FA002Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Moab, UTThe pilot’s loss of visual reference to the horizon while departing during dark night, which resulted in the pilot experiencing spatial disorientation and subsequent controlled flight into terrain.NTSB CEN24LA005Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia Heights, ILThe student pilot’s failure to maintain helicopter control which resulted in impact with the ground.NTSB WPR24FA001Accident · 1 fatalClass 3 · FieldFinal reportCubcrafters CCK-1865 · Twisp, WAThe pilot’s failure to see and avoid a rock during an aborted landing on a hillside, the collision with which resulted in damage to the aileron system that precluded subsequent control of the airplane.NTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.NTSB CEN24LA004Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Hochatown, OKA total loss of engine power during a practice autorotation due to the improper engine idle setting and rigging of the carburetor heat control which resulted in a hard landing.NTSB CEN24LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Olathe, KSThe pilot’s mismanagement of the available fuel which resulted in a total loss of engine power due to fuel starvation.NTSB CEN24LA001Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Waupaca, WIThe pilot’s failure to maintain directional control during the go-around, that resulted in a runway excursion and an impact with terrain.NTSB ERA23LA386Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, GAThe pilot’s failure to maintain clearance from a light pole during taxi.NTSB ERA23LA385Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206 · Port Clinton, OHThe pilot’s failure to detect and avoid unmarked powerline(s) while attempting to take off from a river.NTSB ERA23FA384Accident · 1 fatalClass 3 · FieldFinal reportCessna 150K · Gilford, NHThe pilot’s loss of control during visual flight rules flight in night instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s motivation to depart on the flight despite being made aware that conditions…NTSB DCA23LA468Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Denver, COOverheated brakes due to the extended taxi at a higher power setting in an attempt to burn off fuel to achieve the proper takeoff weight that resulted in a wheel fire during takeoff.NTSB ERA23LA387Accident · No injuriesClass 4 · LimitedFinal reportJohn W Moll Vans RV-7 · Liberty, SCThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and substantial damage to the left wing and left horizontal stabilizer.NTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…NTSB CEN23LA423Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Broken Bow, OKThe pilot’s failure to maintain the runway centerline during landing and subsequent failure to maintain clearance from the airport grounds worker during the landing roll. Contributing to the accident was the absence of a NOTAM for mowing operations at the…NTSB WPR23LA361Accident · Minor injuriesClass 4 · LimitedFinal reportGleim James M MG-1 · Madera, CAAn emergency landing on uneven terrain that resulted in the loss of directional control during landing.NTSB ERA23FA380Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Whitesville, KYThe flight instructor’s improper decision to continue flight into a known area of thunderstorms, which resulted in an in-flight breakup.NTSB CEN23LA426Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Boerne, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA424Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Caddo Mills, TXThe pilot’s inadequate rolling preflight, which resulted in a loss of directional control in flight and subsequent collision with an object during landing.NTSB WPR23LA359Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · San Diego, CAThe pilot’s failure to maintain directional control during landing in gusty wind conditions that resulted in a ground loop.NTSB WPR23LA358Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Salt Lake City, UTThe student pilot’s failure to maintain directional control during landing.NTSB WPR23LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.NTSB ERA23LA379Accident · Minor injuriesClass 4 · LimitedFinal reportDorr Dan W Sequoia F.8L Falco · Sanford, FLThe pilot’s failure to maintain airplane control after an engine access cover opened during the initial climb.NTSB WPR23LA352Accident · Serious injuriesClass 3 · LimitedFinal reportWayne Toddun Sling 4 TSI · San Pedro, CAA total loss of engine power due to a failure of the No. 4 cylinder exhaust valve from overheating and excessive wear.NTSB CEN23LA418Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C23 · Gonzales, TXThe loss of engine power during go-around due to a failed muffler flame tube, which resulted in an exhaust blockage. Contributing to the accident was maintenance personnel's inadequate inspection of the exhaust system during the most recent maintenance.NTSB ANC23LA087Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Beluga, AKThe pilot’s excessive application of brakes during landing that resulted in a nose over.NTSB ANC23LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 182K · Trimble River Valley, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the separation of the main landing gear wheel and the subsequent loss of directional control.NTSB WPR23LA356Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Eatonville, WAThe pilot's failure to maintain directional control during the takeoff roll, in gusty wind conditions, which resulted in a runway excursion.NTSB WPR23FA351Accident · 1 fatalClass 3 · FieldFinal reportGolden Circle T Bird · Arlington, WAA failure of the forward left wing spar due to an improper repair, which resulted in an inflight separation of the left wing. Contributing to the accident was improper maintenance by splicing the wing spar.NTSB CEN23LA421Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, TXThe student pilot’s improper landing flare, which resulted in a hard, bounced landing, and the nose landing gear collapse.NTSB WPR23LA353Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Monument Valley, UTThe pilot’s failure to maintain directional control after encountering a wind gust on the landing roll, which resulted in a ground loop.NTSB ERA23LA377Accident · Serious injuriesClass 4 · LimitedFinal reportAvian Balloon Skyhawk · Bucyrus, OHThe balloon pilot’s bounced landing, which resulted in the basket tipping over and a serious injury to a passenger.NTSB CEN23LA416Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Montrose, COThe pilot’s failure to maintain directional control during the landing roll with a gusting quartering headwind.NTSB WPR23LA350Accident · No injuriesClass 3 · LimitedFinal reportCessna U206C · Challis, IDThe failure of the left main landing gear spring assembly due to a fatigue crack. Contributing to the accident was the improper maintenance on the landing gear spring assembly which allowed corrosion to develop.NTSB WPR23LA349Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Compton, CAThe total loss of engine power on takeoff due to water-contaminated fuel. Contributing to the accident was the inadequately maintained fuel system, which resulted in water entering the fuel tanks through the filler caps.NTSB CEN23LA413Incident · 1 fatalClass 3 · LimitedFinal reportPowrachute Airwolf · Erie, COThe pilot’s inadvertent manipulation of the throttle, which resulted in the aircraft traveling on the ground and the unsecured pilot being ejected from the aircraft and sustaining fatal injuries.NTSB ANC23LA084Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.NTSB WPR23LA348Accident · No injuriesClass 3 · LimitedFinal reportChampion 7KCAB · Benson, AZThe pilots’ failure to maintain control of the aircraft during takeoff.NTSB ERA23LA381Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75 · Erwinna, PAThe pilot’s failure to maintain control of the airplane while taking off in a crosswind.NTSB CEN23FA412Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · New Rockford, NDThe pilot’s failure to maintain clearance from overhead power lines during an aerial application flight. Contributing to the accident was the pilot’s decision to fly under the power lines with a small area of clearance available for the airplane.