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 GAA15CA022Accident · No injuriesData collectionFinal reportBeech A36 · New Market, INThe pilot's improper fuel planning, which resulted in fuel exhaustion, and a loss of engine power en-route.NTSB CEN15FA174Accident · 1 fatalField investigationFinal reportCessna 182Q · El Paso, TXThe pilot's decision to continue a visual flight rules flight into known instrument flight rules conditions, which resulted in controlled flight into terrain.NTSB GAA15CA031Accident · Minor injuriesData collectionFinal reportCessna 140 · Easton, MDThe pilot's failure to maintain directional control during the landing roll.NTSB GAA15CA011Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Boulder, COThe pilot's loss of directional control during a bounced landing, which resulted in a runway excursion.NTSB GAA15CA009Accident · No injuriesData collectionFinal reportBeech 76 · Juda, WIThe pilot's improper fuel planning, which resulted in fuel exhaustion, and a loss of engine power enroute.NTSB ERA15CA157Accident · No injuriesData collectionFinal reportMooney M20K · Laurel, MDThe pilot's improper decision to attempt a nighttime landing at an unsuitable airport, which resulted in a collision with the precision approach path indicator.NTSB ERA15LA156Accident · 1 fatalLimited investigationFinal reportKolb Twinstar · Reynolds, GAThe student pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the student pilot's decision to operate…NTSB WPR15CA128Accident · No injuriesData collectionFinal reportEnstrom F28 - C · Shelby, MTThe pilot's failure to maintain main rotor RPM during a low altitude operation, which resulted in a loss of aircraft control and collision with terrain.NTSB GAA15LA015Accident · Serious injuriesLimited investigationFinal reportUltramagic N210 · Peoria, AZThe pilot's selection of unsuitable terrain for landing after noting a higher-than-anticipated wind speed and the balloon's high descent rate, which resulted in a hard landing.NTSB GAA15CA007Accident · No injuriesData collectionFinal reportAviat A1 - B · Afton, WYThe pilot's failure to maintain directional control during landing.NTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.NTSB ANC15LA015Accident · No injuriesLimited investigationFinal reportAirbus AS350 B2 · Anchorage, AKThe failure of the ball bearing within the pitch change spider assembly due to its operation with no grease within the bearing, which resulted in the subsequent fracture of the spider assembly and a loss of tail rotor control authority. Also causal to the…NTSB GAA15CA010Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Hondo, TXThe student pilot's failure to maintain directional control during landing roll, which resulted in a loss of control. Contributing to this accident was the flight instructor's delayed remedial action.NTSB GAA15CA008Accident · No injuriesData collectionFinal reportCessna 170A · Palmetto, FLThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane.NTSB ERA15CA162Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · St Marys, PAThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and a nose over.NTSB WPR15FA125Accident · 1 fatalField investigationFinal reportBAE Systems MK-67 Hawk · Yuma, AZThe pilot’s initiation of an early rotation during takeoff, which led to an aerodynamic stall and loss of airplane control. Contributing to the accident were the pilot's use of nose up pitch trim and the operator's policy to use nose-up pitch trim during…NTSB GAA15CA005Accident · No injuriesData collectionFinal reportCessna 208B · Muskegon, MIThe pilot's improper decision to continue the landing when the airplane was not in a safe position to land, resulting in the collision with ground-based approach lighting.NTSB ERA15CA152Accident · No injuriesData collectionFinal reportCessna 182L · Waycross, GAThe pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.NTSB ANC15CA012Accident · No injuriesData collectionFinal reportBell 206B · Palmer, AKThe pilot's failure to maintain control while hovering at a low altitude, which resulted in an impact with frozen lake ice. Contributing to the accident was the pilot's decision to operate the helicopter from the left seat contrary to the rotorcraft flight…NTSB GAA15CA004Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Hurricane, UTThe pilot's failure to maintain directional control during the landing roll.NTSB ERA15LA219Accident · 1 fatalLimited investigationFinal reportRainbow Aerotrike · Chesnee, SCThe pilot’s failure to maintain lateral or bank control during takeoff, which resulted in collision with, and subsequent suspension from, a tree. Contributing to the pilot’s fatal injuries was his attempt to jump out of the trike to a nearby tree limb.NTSB ERA15LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Fort Myers, FLThe pilot's inadvertent placement of both fuel selectors to the "off" position, which resulted in fuel starvation and a total loss of engine power.NTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.NTSB ERA15FA147Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Kosciusko, MSThe pilot's decision to make a low pass over a lake near trees and his subsequent failure to maintain airplane control while maneuvering at a low altitude to avoid trees, which resulted in an inadvertent cross-control aerodynamic stall from which he was…NTSB ERA15CA153Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe student pilot's failure to maintain aircraft control during landing, and his subsequent failure to recover from a bounced landing, which resulted in a hard landing.NTSB CEN15CA168Accident · No injuriesData collectionFinal reportJones Ronald C Bearhawk · Walters, OKThe pilot did not maintain control of the airplane during the landing roll at night on an unlit grass strip.NTSB ANC15CA014Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Talkeetna, AKThe pilot's failure to maintain control of the airplane during takeoff from an icy surface in gusty wind conditions.NTSB WPR15LA126Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Merced, CAThe separation of the flight control stick from the stub due to its improper installation.NTSB GAA15CA003Accident · No injuriesData collectionFinal reportSchupp Edward W SKY Ranger II · San Manuel, AZThe pilot's failure to maintain directional control during landing.NTSB ERA15CA150Accident · No injuriesData collectionFinal reportCessna 172S · Richmond, VAThe student pilot's inadequate landing flare which resulted in a hard landing and substantial damage to the airplane.NTSB ERA15CA146Accident · No injuriesData collectionFinal reportCub Crafter CC11-160 · Elizabethton, TNThe pilot's failure to maintain directional control during the landing roll.NTSB CEN15LA169Accident · Serious injuriesLimited investigationFinal reportHoke Bobby F Rans S 12 · Rusk, TXA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's failure to maintain control while maneuvering for a forced landing, which resulted in the airplane…NTSB CEN15FA164Accident · 1 fatalField investigationFinal reportAirbus Helicopters (Eurocopte EC-130-B4 · St Louis, MOThe pilot's decision to land during unfavorable wind conditions, which resulted in a loss of control due to settling with power. Contributing to the accident were the lack of an adequate approach path due to numerous obstructions and the lack of available…NTSB CEN15FA163Accident · 1 fatalField investigationFinal reportAhrens Gerd H RV 6 · Pratt, KSA hard landing, which resulted in the pilot’s loss of directional control and the airplane’s subsequent nose-over.NTSB GAA15CA001Accident · No injuriesData collectionFinal reportWaco UPF 7 · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN15CA166Accident · No injuriesData collectionFinal reportFunk B85C · Leonard, OKThe improper installation of the UP elevator cable turnbuckle which became disconnected during the flight.NTSB WPR15FA121Accident · Serious injuriesField investigationFinal reportRyan Aeronautical ST3KR · Santa Monica, CAA total loss of engine power during initial climb when the carburetor main metering jet became unseated, which led to an extremely rich fuel-to-air ratio. Contributing to the accident was the lack of adequate carburetor maintenance instructions. Contributing…NTSB GAA15CA006Accident · No injuriesData collectionFinal reportChampion 7EC · Upland, CAThe pilot's failure to maintain directional control during landing.NTSB GAA15CA002Accident · No injuriesData collectionFinal reportBell 407 · Justin, TXAbnormal ground contact during an autorotation demonstration, resulting in a severed tailrotor driveshaft.NTSB DCA15FA085Accident · No injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD 88 · New York, NYthe captain's inability to maintain directional control of the airplane due to his application of excessive reverse thrust, which degraded the effectiveness of the rudder in controlling the airplane's heading. Contributing to the accident were the captain's…NTSB ERA15FA144Accident · 3 fatalField investigationFinal reportMooney M20F · Norfolk, VAThe pilot's failure to properly execute the instrument approach procedure. Contributing to the accident were the pilot's improper preflight planning and his decision to conduct the flight in instrument meteorological conditions at night into forecast moderate…NTSB ERA15CA154Accident · No injuriesData collectionFinal reportBeech 58 · Monroe, NCThe pilot's failure to maintain a proper glidepath and failure to perform a go-around once a safe landing could not accomplished, which resulted in a landing area overshoot and runway excursion.NTSB WPR15LA123Accident · Minor injuriesLimited investigationFinal reportGoudie Fisher Classic · Redlands, CAA loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inadequate planning for the test flight, which resulted in insufficient altitude and no suitable place to land in the event of an emergency.NTSB WPR15CA119Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · San Bernardino, CAThe pilot's failure to maintain adequate clearance from the ground, which resulted in a loss of control and subsequent dynamic rollover.NTSB WPR15CA118Accident · No injuriesData collectionFinal reportChristopher Jon Brown Stol CH750 · Palmdale, CAThe pilot's failure to maintain airplane control when he exceeded the airplane's critical angle of attack during climb out which resulted in a loss of airspeed and subsequent aerodynamic stall.NTSB ERA15CA148Accident · No injuriesData collectionFinal reportPiper PA 18 · Murfreesboro, TNThe student pilot's failure to maintain directional control while landing and the flight instructor's delayed remedial action, which resulted in a ground-loop and the left wing dragging the runway.NTSB CEN15CA158Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Kansas City, MOThe loss of engine power due to fuel starvation.NTSB ERA15LA140Accident · Serious injuriesLimited investigationFinal reportBombardier Canadair CL600-2A12 · Marco Island, FLThe failure of a spring inside the No. 2 brake’s upper brake control valve and the fracture of the coupling subassembly of the No. 1 wheel speed sensor during landing, which resulted in the loss of braking action, and the pilot-in-command’s (PIC) deactivation…NTSB ERA15CA143Accident · No injuriesData collectionFinal reportPiper J3C 65 · Clermont, FLThe pilot's failure to land the airplane within the desired touchdown zone, resulting in a long landing and collision with a fence.NTSB CEN15CA165Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lee's Summit, MOThe pilot-receiving-instruction's excessive pitch control during takeoff, which resulted in an aerodynamic stall shortly after liftoff and the subsequent loss of control. Contributing to the accident was the flight crew's decision to have the flight…