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 CEN24LA213Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Shuteston, LAThe pilot failure to maintain directional control while landing on a wet grass strip.NTSB WPR24LA183Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Maricopa, AZThe flight instructor’s unstabilized approach during an autorotation that resulted in hard landing.NTSB WPR24FA182Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Auburn, WAThe pilot’s improper installation of the control stick pushrod assemblies, which resulted in separation of the left pushrod and a total loss of roll control during flight. Contributing to the accident was the failure to detect the installation error during…NTSB CEN24LA216Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Perryton, TXThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level turn, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB ANC24LA047Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Nenana, AKThe pilot providing instruction’s delayed remedial action, resulting in a loss of control during landing roll.NTSB WPR24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Santa Ynez, CAThe pilot’s failure to maintain airspeed which resulted in exceedance of the critical angle of attack and an aerodynamic stall/spin, with insufficient altitude for recovery. The student pilot’s exceedance of the critical angle of attack which resulted in a…NTSB WPR24LA180Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Butte, MTThe pilot’s failure to maintain control of the airplane during the takeoff with a gusty left quartering crosswind.NTSB ERA24LA247Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Southampton Township, NJThe flight instructor’s failure to maintain control of the airplane during a low approach and subsequent go-around in turbulent wind conditions.NTSB CEN24LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Gypsum, COThe failure of the flight instructor and the pilot to visually confirm the airplane’s fuel quantity during preflight, which resulted in a loss of engine power due to fuel exhaustion and an off-airport forced landing in rough terrain.NTSB WPR24LA173Accident · No injuriesClass 4 · LimitedFinal reportSikorsky S-55QT · Benton City, WAThe pilot’s failure to maintain clearance from power lines during a low altitude operation.NTSB ANC24LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe pilot’s improper short-field takeoff procedure, which resulted in an aerodynamic stall and subsequent hard landing.NTSB WPR24LA167Accident · Minor injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Modesto, CAThe pilot’s improper fuel tank selection, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was a malfunctioning fuel selector at low fuel levels.NTSB ERA24LA243Accident · Minor injuriesClass 4 · LimitedFinal reportEide Turner T-40A · Middleburg, FLThe pilot’s loss of control during climb out, which resulted in a collision with a tree.NTSB ERA24LA236Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Gilbertsville, KYThe pilot's failure to maintain control of the helicopter while attempting to take off from sloping terrain.NTSB CEN24LA209Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 90A · Hebron, INThe pilot’s failure to maintain clearance from powerlines while landing in a field.NTSB ANC24LA051Accident · No injuriesClass 4 · LimitedFinal reportMorgan Edward L Edge X 582 · Fairbanks, AKThe pilot’s selection of an unsuitable landing site, resulting in a collision with a hole during landing rollout.NTSB WPR24LA168Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Hooper, UTThe inadvertent application of brakes during landing that resulted in a nose over.NTSB WPR24LA166Accident · No injuriesClass 4 · LimitedFinal reportThomas J Spencer RV-10 · Snohomish, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway overrun.NTSB ERA24LA244Accident · No injuriesClass 4 · LimitedFinal reportRuth Hummingbird · New Hill, NCThe pilot's failure to maintain control of the helicopter while hovering.NTSB ERA24LA242Accident · Serious injuriesClass 4 · LimitedFinal reportHughes 269A · Danbury, NHThe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of control during landing.NTSB ERA24LA240Accident · Serious injuriesClass 4 · LimitedFinal reportAero Commander Callair A-9B · Zebulon, NCA total loss of engine power while maneuvering due to fuel starvation.NTSB ERA24LA238Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Geneseo, NYThe pilot’s failure to maintain directional control during the takeoff roll resulting in a runway excursion, and subsequent nose over.NTSB ERA24LA235Accident · No injuriesClass 3 · LimitedFinal reportTemco/Lazier TT-1 · Laurel Hill, FLThe pilot’s delay in turning on the fuel tip tank transfer pumps after departure, resulting in fuel starvation to the engine, engine flameout, and a subsequent forced landing.NTSB CEN24LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Dalhart, TXThe pilot’s improper decision to take off with the airplane over its maximum allowable gross weight at a high density altitude, which degraded its climb performance and led an off airport landing.NTSB CEN24LA207Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus SR20 · Aitkin, MNThe pilot’s failure to maintain adequate airspeed, which resulted in a loss of airplane control during the go-around. Contributing to the accident was the pilot’s failure to properly configure the airplane’s flaps during the go-around.NTSB ANC24LA048Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Bethel, AKThe uncertificated pilot’s decision to fly an unairworthy airplane and his failure to maintain directional control during landing, which resulted in a landing gear collapse. Contributing was the failure of the right main landing gear oleo strut.NTSB ANC24LA040Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Soldotna, AKThe pilot’s failure to recognize and avoid an obstacle on the runway environment during takeoff roll. Contributing was flat light conditions.NTSB WPR24LA178Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Nephi, UTThe pilot’s incorrect movement of the fuel selector valve to an off or restricted position, which resulted in fuel starvation and a loss of engine power.NTSB ANC24LA044Accident · No injuriesClass 4 · LimitedFinal reportJordan Harry James Sportsman 2+2 · Fairbanks, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR24LA176Accident · No injuriesClass 4 · LimitedFinal reportOklahoma Fat Tire Flyers CCX-2000 · Pinedale, WYThe pilot's failure to maintain directional control during the landing roll, which resulted in aground loop.NTSB ERA24LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Greensboro, NCThe pilot's improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.NTSB ERA24LA233Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · Palmetto, FLThe pilot’s improper decision to re-attempt a takeoff with little runway remaining, after rejecting a takeoff in gusting wind conditions, which resulted in a runway overrun at a higher speed and collision with terrain.NTSB CEN24LA205Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Palmyra, MOThe pilot’s failure to maintain clearance from power lines during approach.NTSB ANC24LA039Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kailua-Kona, HIThe flight instructor’s failure to implement the correct action for low rotor RPM recovery.NTSB WPR24LA169Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Hillsboro, ORThe pilot’s failure to maintain direction control during the landing roll with a left crosswind.NTSB CEN24LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Forest Lake, MNThe flight instructor’s delayed remedial action and failure to maintain aircraft control during the simulated forced landing.NTSB WPR24LA170Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · McCall, IDThe pilot’s failure to maintain directional control during the landing roll with a gusty right crosswind.NTSB CEN24LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oscoda, MIThe pilot’s failure to maintain directional control during landing rollout with a gusting crosswind that resulted in the airplane nosing over and impacting on the runway.NTSB ANC24LA037Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Fairbanks, AKThe pilot’s improper fuel management resulting in a loss of engine power due to fuel starvation.NTSB ANC24FA038Accident · 1 fatalClass 3 · FieldFinal reportSchweizer G-164B · Richvale, CAThe pilot’s failure to maintain clearance from a trailer located on the edge of the runway during takeoff. Contributing to the accident was the location of the trailer on the side of the runway.NTSB WPR24LA164Accident · No injuriesClass 4 · LimitedFinal reportBoeing-Stearman PT-17 · Heber City, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR24LA162Accident · No injuriesClass 4 · LimitedFinal reportNelson Lawrence K 601 HDS · Somerton, AZThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR24LA161Accident · Minor injuriesClass 3 · LimitedFinal reportAerospatiale SA315B · Hildale, UTMaintenance personnel’s failure to properly secure the EGT thermocouples, which resulted in catastrophic overtemperature of the engine and a total loss of engine power.NTSB ANC24LA041Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Knik, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB WPR24LA165Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Rome, ORThe pilot’s failure to maintain airplane control during landing.NTSB ERA24LA231Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Pierson, FLThe flight instructor’s failure to attain a proper touchdown point during a precautionary landing, which resulted in a runway excursion during landing.NTSB ERA24LA230Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Hope Mills, NCA loss of engine performance due to carbon fouling of three spark plugs that, when combined with the airplane’s high gross weight condition, resulted in a collision with trees and terrain.NTSB ERA24LA229Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T-1(Menasco Special) · Salisbury, MDThe pilot’s exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB ERA24LA227Accident · 1 fatalClass 3 · LimitedFinal reportBrallier Scott Glasair I · Gulf of Mexico, FLThe non-instrument-rated pilot’s loss of airplane control due to spatial disorientation while flying over water in dark night conditions. Contributing to the accident was the pilot’s decision to conduct the overwater flight in conditions conducive to the…NTSB CEN24LA198Accident · No injuriesClass 4 · LimitedFinal reportBrant T Phillips Super Cub EXP · Franktown, COThe pilot’s failure to maintain aircraft control during final approach and attempted go-around after encountering a sudden windshear.