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 GAA16CA058Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot of the following airplane failed to maintain adequate spacing during the taxi to the runway, resulting in a collision with the lead airplane.NTSB ERA16LA041Accident · No injuriesLimited investigationFinal reportWoodrow Larry W Sonex · Morganton, NCThe pilot/owner’s inadequate maintenance inspection following a propeller strike, which resulted in the subsequent in-flight propeller separation due to propagation of fatigue cracks in the crankshaft.NTSB GAA16CA062Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4 · Morganton, NCThe pilot's failure to maintain directional control during the departure, resulting in substantial damage to the airplanes right wing.NTSB GAA16CA049Accident · No injuriesData collectionFinal reportCurtiss Wright Travel Air · Carlsbad, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a ground-loop, and substantial damage to the right wing and wing strut.NTSB WPR16LA028Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Lancaster, CAThe flight instructor's failure to comply with published instrument approach procedures during an instrument approach in dark night, visual meteorological conditions, which resulted in impact with terrain. Contributing to the accident was the controller's…NTSB GAA16CA053Accident · Minor injuriesData collectionFinal reportSweeney Timothy J Rans S6-ES · Winter Haven, FLThe pilot's improper landing flare, which resulted in a nose gear collapse and nose over.NTSB GAA16CA050Accident · No injuriesData collectionFinal reportCessna 182Q · Bowstring, MNThe pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with a wind sock and terrain.NTSB CEN16LA039Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Alpine, TXThe pilot’s failure to maintain adequate rotor speed while maneuvering at low altitude, which resulted in a descent from which he was unable to recover. Contributing to the accident was the pilot's decision to conduct the flight at or near the helicopter's…NTSB CEN16LA089Accident · No injuriesLimited investigationFinal reportCessna 208B · Grand Forks, NDThe pilot's failure to properly calculate the airplane's weight and balance and center of gravity, which resulted in the tail striking the ground.NTSB CEN16MA036Accident · 9 fatalClass 1 · MajorFinal reportBritish Aerospace HS 125 700A · Akron, OHThe flight crew's mismanagement of the approach and multiple deviations from company standard operating procedures, which placed the airplane in an unsafe situation and led to an unstabilized approach, a descent below minimum descent altitude without visual…NTSB GAA16CA047Accident · No injuriesData collectionFinal reportCessna 172M · Miami, FLThe student pilot's failure to maintain pitch control during the landing flare, which resulted in a hard landing.NTSB ERA16FA035Accident · 2 fatalField investigationFinal reportCessna 441 · Climax, GAThe pilot’s loss of airplane control due to spatial disorientation. Also causal to the accident was the pilot’s impairment by the combined effects of multiple medications and drugs.NTSB CEN16FA034Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Colorado Springs, COThe pilot's loss of airplane control during the turn back to the airport after takeoff in high density altitude conditions, which resulted in an inadvertent aerodynamic stall and subsequent spin. Contributing to the accident was the pilot's impaired…NTSB WPR16LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172S · San Jose, CAThe pilot's failure to maintain directional control during the landing roll at night, which resulted in a runway excursion.NTSB GAA16LA046Accident · Serious injuriesLimited investigationFinal reportU-Fly-It Aerolite 103 · Midland, VAThe pilot’s failure to attain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during takeoff with the airplane’s center of gravity aft of its limit, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA16CA048Accident · No injuriesData collectionFinal reportCessna 172 · Mesa, AZThe pilot's failure to maintain pitch control during landing, resulting in a porpoise, and firewall damage.NTSB WPR16CA022Accident · No injuriesData collectionFinal reportKnox Marion L RV-6A · Lebanon, ORThe pilot's failure to maintain airplane control following an aborted landing which resulted in a collision with trees.NTSB ERA16LA042Accident · No injuriesLimited investigationFinal reportCessna P210 · Atlanta, GAThe pilot's delayed extension of the landing gear and his failure to ensure that the main landing gear (MLG) were down and locked before touchdown, which resulted in the collapse of both MLG. Contributing to the landing gear collapse was the mis-set landing…NTSB CEN16LA033Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Gonzales, LAMaintenance personnel’s improper installation of the carburetor during recent maintenance, including the omission of a required cotter pin, which resulted in a total loss of engine power.NTSB GAA16CA052Accident · No injuriesData collectionFinal reportCessna 172S · Alcoa, TNThe pilot's failure to identify the taxiway, which resulted in a runway excursion and impact with terrain while turning off the runway at night.NTSB ERA16FA032Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Cornelia, GAThe pilot's decision to initiate the flight into known adverse weather conditions, which resulted in his spatial disorientation and loss of airplane control.NTSB ERA16FA031Accident · 1 fatalField investigationFinal reportFlight Design Ctls · Queens, NYThe noninstrument-rated pilot's spatial disorientation and subsequent loss of airplane control while maneuvering at low altitude, over water with no visible horizon, in dark night conditions, which resulted in a collision with the water.NTSB GAA16CA045Accident · No injuriesData collectionFinal reportSchweizer 269C 1 · Mount Pocono, PAThe student pilot's failure to remove the tension applied to the cyclic before takeoff, which resulted in a loss of directional control and the tail rotor striking the ground.NTSB ANC16LA005Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Haines, AKA loss of engine power due to fuel exhaustion for reasons that could not be determined based on available evidence and the pilot’s decision to continue the flight after realizing the remaining fuel quantity was near 0.NTSB CEN16LA052Accident · No injuriesLimited investigationFinal reportCessna 208B · Chicago, ILThe failure of the driver of the service vehicle to yield to the taxiing airplane, which resulted in a near-collision and tail strike.NTSB CEN16LA029Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Tecumseh, MIThe pilot's failure to maintain directional control during the landing and his subsequent improper decision to attempt an aborted landing after the airplane had departed the runway.NTSB GAA16CA067Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 65 · New Lisbon, WIThe pilot's exceedance of the airplane's critical angle of attack, resulting in an inadvertent aerodynamic stall and impact with terrain.NTSB GAA16CA043Accident · No injuriesData collectionFinal reportCessna 182 · Douglas Bisbee, AZThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion, left main landing gear collapse, and a collision with terrain.NTSB GAA16CA038Accident · No injuriesData collectionFinal reportAeronca 7AC · Auburn, PAThe pilot's use of excessive brake pressure during the landing roll, which resulted in a nose over.NTSB GAA16CA037Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Perry, NYThe student pilot's failure to maintain vigilance, which resulted in a loss of directional control during the landing roll.NTSB GAA16CA039Accident · No injuriesData collectionFinal reportBell 407 · Cameron, LAThe pilot's failure to remove a main rotor blade tiedown, which resulted in substantial damage to a main rotor blade when the engine was started.NTSB DCA16FA013Accident · Serious injuriesField investigationFinal reportBoeing 767 · Fort Lauderdale, FLthe separation of the flexible fuel line coupling and subsequent fuel leak due to the failure of maintenance personnel to install the required safety lockwire. Contributing to the severity of the accident was the initiation of the evacuation before the right…NTSB CEN16FA024Accident · 4 fatalField investigationFinal reportRaytheon A36 · Pottsville, ARThe pilot's failure to maintain a sufficient climb rate during departure in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB GAA16LA032Accident · Serious injuriesLimited investigationFinal reportPhilip D Anderson 601 · Hemet, CAThe pilot's failure to maintain the airplane's descent rate during a precautionary landing, which resulted in hard landing. Contributing to the accident was the pilot's failure to secure the canopy before takeoff, which precipitated the precautionary landing.NTSB GAA16LA031Accident · No injuriesLimited investigationFinal reportAirbus AS350 · Deadhorse, AKThe noninstrument-rated pilot's continued visual flight into adverse weather conditions, which resulted in spatial disorientation, and his subsequent failure to maintain terrain clearance while attempting to land in flat light and whiteout conditions.NTSB ERA16LA028Accident · 3 fatalLimited investigationFinal reportSchumacher Lancair Super ES · Pascagoula, MSThe pilot's failure to maintain airplane control after encountering convective shower activity. Contributing to the accident was the pilot's decision to continue flight into an area of known adverse weather.NTSB ERA16LA026Accident · 1 fatalLimited investigationFinal reportPiper PA31 · Weston, FLThe pilot's feathering of the incorrect propeller following a total loss of right engine power due to fuel starvation, which resulted from maintenance personnel’s failure to reinstall the flapper valve in the right main fuel tank. Contributing to the accident…NTSB CEN16LA022Accident · 1 fatalLimited investigationFinal reportDelwyn Schmidt No model · Bennington, KSThe unregistered airplane’s loss of engine power due to piston seizure. Contributing to the accident was the pilot’s loss of airplane control while maneuvering back to the runway.NTSB WPR16LA019Accident · No injuriesLimited investigationFinal reportAmerican Eurocopter AS350B3 · Folsom, CAThe flight instructor's failure to perform simulated engine failure training in accordance with manufacturer guidance, including his improper recovery from the maneuver, which resulted in an overshoot of the intended landing zone when the engine did not…NTSB WPR16LA017Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Prescott, AZThe pilot's failure to maintain directional control during landing, and his inability to recover due to a malfunction of the tailwheel.NTSB GAA16CA035Accident · No injuriesData collectionFinal reportBrandon Evans Gyroplane · Buckeye, AZThe student pilot's incorrect control input during takeoff which resulted in a runaway excursion and impact with terrain.NTSB GAA16CA028Accident · No injuriesData collectionFinal reportMaule M5 · Goodland, KSThe pilot's inadequate crosswind compensation and subsequent loss of directional control during the landing roll, resulting in a runway excursion and nose over.NTSB GAA16CA027Accident · No injuriesData collectionFinal reportCessna A188A · Elberta, UTThe pilot's failure to compensate for wind while maneuvering at a low altitude, resulting in a collision with terrain and a postcrash fire.NTSB ERA16FA023Accident · 1 fatalField investigationFinal reportMooney M20M · Worcester, MAA total loss of engine power during the initial climb due to a fatigue failure of the engine's crankshaft. Contributing to the accident was the pilot's failure to maintain control of the airplane, which resulted in an aerodynamic stall.NTSB ERA16CA024Accident · Minor injuriesData collectionFinal reportMaule M5 · Warrentown, VAThe pilot's failure to maintain clearance of a cattle-guard fence on landing. Contributing to the accident was his lack of recent flying experience.NTSB CEN16LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Century, KSThe pilot’s application of excessive brake pressure to maintain a safe taxi speed during a long, slightly downhill taxi with a strong quartering tailwind, which resulted in a brake fire.NTSB WPR16LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Primm, NVThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision. Contributing to the accident was the pilots' failure to tune to, monitor, and communicate over the common traffic advisory frequency their relative positions…NTSB GAA16CA040Accident · No injuriesData collectionFinal reportCessna 182J · Skwentna, AKThe pilot's failure to maintain pitch control during landing, which resulted in a porpoise and structural damage to the airplane.NTSB GAA16CA033Accident · No injuriesData collectionFinal reportCessna 150 · Millbrook, NYThe pilot's loss of heading control during the go-around in gusty crosswind conditions, which resulted in a collision with trees.NTSB GAA16CA030Accident · No injuriesData collectionFinal reportMcpherson John G Pietenpol Aircamper · Placerville, CAThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and an impact with terrain.