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 WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…NTSB ANC22LA077Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot’s inadvertent application of the brakes during the landing roll, which resulted in a nose-over and substantial damage to the rudder and wings.NTSB WPR22LA349Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Henderson, NVThe flight instructor’s failure to verify the fuel quantity and improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB ERA22LA420Accident · Minor injuriesClass 4 · LimitedFinal reportYakovlev YAK-55M · Waldo, FLThe pilot’s inadequate preflight fuel planning and preflight inspection of the airplane, which resulted in fuel exhaustion, a total loss of engine power, and the subsequent off-airport landing.NTSB WPR22FA347Accident · 2 fatalClass 3 · FieldFinal reportSkiles Kenneth C RV-6A · Preston, IDThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA22LA423Accident · Serious injuriesClass 4 · LimitedFinal reportKumhyr David B Vans RV-8A · Elberta, ALThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a loss of control and subsequent nose over during landing.NTSB CEN22FA419Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28R-201 · Conway, SCThe mechanic’s failure to install the required gasket on the vacuum pump drive pad in accordance with the maintenance manual, which resulted in oil exhaustion and the subsequent loss of engine power. Contributing to the accident was the Director of…NTSB WPR22FA345Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46 · Seligman, AZThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup.NTSB ERA22LA413Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Chattanooga, TNA total loss of engine power due to of carburetor ice. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB CEN22LA418Accident · No injuriesClass 4 · LimitedFinal reportZenith CH701 · Stanton, MNThe pilot’s improper landing flare which resulted in a bounced landing and the nose landing gear collapsing.NTSB CEN22LA414Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Fort Collins, COThe pilot’s failure to maintain clearance from rising terrain while intentionally maneuvering the airplane at low altitudes, which resulted in substantial damage to the fuselage and both wings.NTSB CEN22FA416Accident · 1 fatalClass 3 · FieldFinal reportPipistrel Italia S R L Sinus 912 LSA · Waller, TXThe pilot’s failure to maintain aircraft control, which led to an aerodynamic stall at an altitude where recovery was not possible.NTSB ERA22LA419Accident · No injuriesClass 4 · LimitedFinal reportAutogyro USA Calidus · Jasper, GAThe pilot’s failure to maintain control of the gyroplane during a touch-and-go landing.NTSB DCA22LA201Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Chicago, ILSouthwest Airlines flight crew’s misjudgment of the distance required to safely pass the American Airlines airplane.NTSB WPR22LA369Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Maxwell, CAThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion.NTSB WPR22LA346Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Las Vegas, NVThe pilot’s failure to maintain airplane control during landing in gusting wind conditions.NTSB WPR22LA340Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206L-1 · Banning, CAThe improper attachment of the tail rotor drive shaft to the air conditioner drive pulley without a drive ring, which resulted in the failure of the hardware, a loss of tail rotor drive, and the loss of control of the helicopter followed by a hard landing and…NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB ERA22LA414Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-39 · Caldwell, NJThe pilot’s acute cerebrovascular event, which caused symptoms that diminished his situational awareness and prompted him to abort the takeoff, resulting in a runway excursion.NTSB ERA22LA410Accident · No injuriesClass 3 · LimitedFinal reportCessna U206 · Buckland, AKThe installation of incompatible rocker arms and rocker arm bushings during an engine overhaul, which resulted in a complete loss of engine power.NTSB ERA22LA404Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Saint Cloud, FLThe pilot’s continuation of the instrument approach into known extreme precipitation and turbulence associated with a thunderstorm, resulting in excessive altitude deviations that required him to activate the Cirrus Airframe Parachute System.NTSB CEN22LA420Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe student pilot’s incorrect application of rudder during landing and the flight instructor’s delayed response to the student pilot’s action.NTSB CEN22LA417Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Delta Junction, AKThe pilot’s decision to depart during high, gusty wind conditions which resulted sink and subsequent impact with terrain.NTSB WPR22FA338Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport Piper Sport · Santa Monica, CAThe pilot’s inability to maintain control of the airplane during the landing flare due to the passenger’s excessive control inputs, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall.NTSB WPR22LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Salt Lake City, UTThe airplane’s encounter with a microburst during initial climb that resulted in a loss of altitude and subsequent collision with a tree.NTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…NTSB ERA22LA402Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206G · Millinocket, METhe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.NTSB CEN22LA422Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Galena, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.NTSB CEN22LA412Accident · Serious injuriesClass 3 · LimitedFinal reportZenith 750 · Silex, MOThe pilot’s failure to maintain clearance from the powerlines during takeoff.NTSB ERA22FA399Accident · 2 fatalClass 3 · FieldFinal reportConway Philip J Glasair Super II SFT · Bay City, WIThe continuation of a poorly-flown, unstabilized approach and the flight instructor’s failure to direct a discontinuance of that approach, resulting in a collision with terrain during turn to final.NTSB WPR22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 120 · Scappoose, ORThe pilot's failure to maintain airplane control while taxing in gusty wind conditions.NTSB WPR22LA334Accident · Serious injuriesClass 3 · LimitedFinal reportBuxbaum Mark Edward Long EZ · Medicine Bow, WYA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve head.NTSB ERA22LA406Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177B · Ivanhoe, NCThe pilot's inadequate preflight and inflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA407Accident · No injuriesClass 4 · LimitedFinal reportBeech 36 · Tupelo, MSThe pilot’s failure to extend the landing gear for a landing.NTSB CEN22FA406Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Cleveland, TNThe pilot’s loss of airplane control while operating in instrument meteorological conditions.NTSB WPR22LA368Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons Firefly 8B-15 · Las Cruces, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB WPR22LA333Accident · Serious injuriesClass 3 · LimitedFinal reportBell 407 · Mount Baldy, CAThe pilot’s failure to ensure the throttle was properly positioned before commencing an approach to land, which resulted in a low rotor rpm condition and impact with terrain. Contributing to the accident was a worn throttle detent.NTSB WPR22FA332Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Galt, CAThe certified flight instructor's failure to maintain control of the airplane and inadequate supervision of the flight, which resulted in an aerodynamic stall/spin from which he could not recover.NTSB ERA22LA409Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Blairstown, NJThe pilot’s decision to cross the taxiway at an unsuitable location.NTSB DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB ANC22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180H · McCarty, AKThe pilot’s failure to initiate a go around maneuver when the airplane past the intended touch down point.NTSB WPR22LA370Accident · No injuriesClass 4 · LimitedFinal reportAlisport Silent 2 Electro · Hood River, ORThe pilot’s improper landing flare which resulted in a hard landing. Contributing to the accident was the pilot’s failure to follow the checklist to remove the wing wheel and tail dolly before takeoff.NTSB WPR22LA337Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Seeley Lake, MTThe loss of engine power due to fuel starvation as a result of unporting of the fuel.NTSB ERA22FA397Accident · 1 fatalClass 3 · FieldFinal reportRotorway Jetexec · Arthur, KYThe pilot’s decision to attempt the cross-country flight in thunderstorm conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to obtain a weather briefing.NTSB CEN22LA428Accident · No injuriesClass 4 · LimitedFinal reportBeech C90A · Tupelo, MSThe uncertificated pilot’s criminal act of stealing the airplane and later performing an off-airport landing that resulted in an impact with terrain.NTSB ANC22LA071Accident · No injuriesClass 4 · LimitedFinal reportStinson 10A · Port Alsworth, AKThe pilot's delayed decision to execute a go-around maneuver while landing with a tailwind into a short strip, which resulted in a runway overrun and subsequent loss of control.NTSB ANC22LA070Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain centerline in dusk light conditions which resulted in impact with trees.NTSB WPR22FA331Accident · 1 fatalClass 3 · FieldFinal reportYakovlev YAK-11 · Shafter, CAThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the loss of engine oil pressure shortly after takeoff.NTSB CEN22LA410Accident · Minor injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Coldwater, MIThe pilot receiving instruction’s improper flare during landing and the flight instructor’s inadequate remedial action, which resulted in the airplane exceeding its critical angle-of-attach and experiencing an aerodynamic stall.NTSB WPR22LA372Accident · Minor injuriesClass 4 · LimitedFinal reportCessna P210N · Weston, ORThe pilot’s improper landing flare which resulted in a bounced landing and runway excursion.