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 GAA19CA463Accident · No injuriesData collectionFinal reportHughes 269A · Springfield, TNThe pilot’s failure to maintain helicopter control and a loss of tail rotor effectiveness while hover-taxiing and turning toward a taxiway in gusting crosswind conditions, which resulted in a dynamic rollover.NTSB GAA19CA454Accident · No injuriesData collectionFinal reportCessna T188 · Deshler, NEThe pilot's failure to maintain clearance from wires during low-altitude maneuvering.NTSB GAA19CA453Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Stanton, TXThe pilot's failure to maintain clearance from wires during an agricultural application flight.NTSB GAA19CA452Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Welsh, LAThe pilot's failure to maintain clearance from a telephone pole during an agricultural application flight.NTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…NTSB CEN19FA236Accident · 3 fatalClass 2 · FieldFinal reportBeech 95B55 · Chadron, NEThe pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN19CA237Accident · No injuriesData collectionFinal reportNorth American AT 6F · Oshkosh, WIThe pilot's loss of directional control during landing with a quartering tailwind, which resulted in a runway excursion and subsequent substantial damage.NTSB GAA19CA448Accident · No injuriesData collectionFinal reportCessna 172 · Van Nuys, CAThe pilot's failure to maintain directional control during landing with a left quartering crosswind, which resulted in a runway excursion and impact with runway lighting.NTSB DCA19CA186Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · San Francisco, CAfailure of the ground crew to maintain clearance from the parked airplane during pushback.NTSB CEN19LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Kingston, OKThe partial loss of engine power due to a stuck exhaust valve.NTSB GAA19CA446Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Tracy, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing and collision with a tree.NTSB CEN19LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305A · Houston, MOA total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.NTSB CEN19IA234Incident · No injuriesClass 3 · IncidentFinal reportMooney M20J · Oshkosh, WIThe failure of both pilots to remain clear of the other while flying in formation.NTSB ANC19TA037Accident · Serious injuriesClass 4Final reportPiper PA19 · Skwentna, AKThe pilot’s loss of directional control during a go-around and his failure to assess the wind conditions appropriately before a landing attempt.NTSB WPR19CA197Accident · Minor injuriesData collectionFinal reportAvid Avid Magnum · Yellow Pine, IDThe pilot's improper decision to land on a rough, grass airstrip, which resulted in the nose landing gear collapsing and a subsequent nose-over.NTSB GAA19CA443Accident · No injuriesData collectionFinal reportValldejuli John A Aerocomp · Jefferson City, MOThe pilot's failure to maintain directional control during a touch-and-go landing in gusting crosswind conditions, which resulted in a runway excursion, impact with runway lights, and a nose-over.NTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.NTSB CEN19CA227Accident · No injuriesData collectionFinal reportVans RV-8 · Oshkosh, WIThe pilot’s failure to maintain adequate spacing from the lead airplane while landing following revised landing instructions, which necessitated that the pilot conduct an improper landing flare and resulted in a hard landing.NTSB WPR19LA196Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 5(205) · Dallesport, ORThe pilot’s improper pitch control during the aborted takeoff, which resulted in a bounced landing and landing gear collapse.NTSB GAA19CA450Accident · No injuriesData collectionFinal reportRockwell 112A · Cove, ORThe pilot's delayed decision to abort the takeoff from a grass runway, which resulted in a runway overrun and subsequent impact with a pole.NTSB GAA19CA445Accident · No injuriesData collectionFinal reportCessna 170 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the right wing striking the ground.NTSB GAA19CA440Accident · No injuriesData collectionFinal reportCessna 172 · Denver, COThe student pilot's failure to maintain lateral control during a soft-field takeoff, which resulted in the left wing striking the runway and a runway excursion.NTSB ERA19TA233Accident · No injuriesClass 3Final reportBeech 95B55 · Sanford, FLThe pilot's failure to extend the landing gear during landing.NTSB ERA19LA232Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7 · Ocean City, MDThe disconnection of the propeller governor control arm from the propeller governor due to a missing attachment bolt, which resulted in a partial loss of engine power during takeoff when the governor control vibrated to a high pitch, low rpm setting.NTSB ERA19LA231Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Poughkeepsie, NYA total loss of engine power due to fuel exhaustion as the result of a higher-than-expected fuel quantity reduction. Contributing was the pilot’s continued flight away from his selected precautionary landing site after identification of a fuel emergency,…NTSB ANC19FA035Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland Beaver DHC 2 · Seldovia, AKThe airplane's floats impact with an ocean wave or swell, which exceeded the design load specifications of the flying wire assemblies and resulted in a partial separation of the float assemblies.NTSB WPR19TA193Accident · Minor injuriesClass 3Final reportCessna 550 · Mesquite, NVThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control on landing.NTSB GAA19CA433Accident · No injuriesData collectionFinal reportBrumbaugh David R DRB Raider · Laramie, WYThe pilot's improper landing flare, which resulted in a hard landing.NTSB WPR19LA191Accident · 1 fatalClass 3 · LimitedFinal reportBolkow Phoebus · Alvord Desert, ORPilot’s failure to properly respond to a slack towline during takeoff, which resulted in a loss of control of the glider.NTSB GAA19CA432Accident · Minor injuriesData collectionFinal reportAviat A1 · Ennis, MTThe pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's distraction due to looking at wildlife.NTSB ANC19LA036Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Chattanooga, TNThe pilot's failure to switch to the secondary electrical system after the primary electrical system failed for unknown reasons.NTSB GAA19CA428Accident · Minor injuriesData collectionFinal reportRobinson R44 · Council Bluff, IAThe pilot's improper cyclic input during liftoff from a landing deck, which resulted in the right skid hooking onto an opening on the landing deck and a subsequent dynamic rollover.NTSB GAA19CA425Accident · No injuriesData collectionFinal reportAeros Skyranger · Brownville, METhe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control while attempting a go-around, which resulted in a runway excursion and impact with trees.NTSB GAA19CA424Accident · No injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.NTSB GAA19CA423Accident · No injuriesData collectionFinal reportCessna 182 · Salmon, IDThe pilot's delayed decision to abort the landing on a wet grass runway and the flight instructor's delayed remedial action. Contributing to the accident was the wet runway which degraded braking.NTSB ERA19LA229Accident · Serious injuriesClass 3 · LimitedFinal reportProgressive Aerodyne Searey · Crescent, FLThe pilot’s misjudgment of his altitude during landing and subsequent decrease in pitch attitude, which resulted in a collision with the water.NTSB WPR19LA195Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Hurricane, UTMaintenance personnel's improper installation of a throttle cable to the throttle body arm, which resulted in a throttle detachment during takeoff and subsequent loss of power. Contributing to the accident was the inadequate inspection of the throttle…NTSB WPR19FA188Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Hayward, CAThe pilots’ loss of control during a low altitude maneuver for undetermined reasons, which resulted in impact with terrain.NTSB GAA19CA487Accident · No injuriesData collectionFinal reportCessna 170 · Bison, SDThe pilot's improper landing flare, which resulted in a hard landing and subsequent ground loop.NTSB GAA19CA437Accident · Minor injuriesData collectionFinal reportPiper PA36 · Bancroft, IDThe pilot's exceedance of the airplane's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall.NTSB GAA19CA421Accident · Minor injuriesData collectionFinal reportWillie Bennett Glastar · Lompoc, CAThe pilot's failure to maintain a proper glidepath during a night landing, which resulted in impact with a tree.NTSB GAA19CA416Accident · No injuriesData collectionFinal reportThomas Wild Avid · York, SCThe pilot's inadvertent reduction of power during the initial climb, which resulted in an aerodynamic stall. Contributing to the pilot’s inadvertent reduction of power was his lack of experience with his left hand on the control stick and right hand on the…NTSB GAA19CA411Accident · No injuriesData collectionFinal reportPiper J3C · San Diego, CAThe pilot's failure to maintain directional control during landing, which resulted a ground loop.NTSB WPR19LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna P206 · Cascade, IDA loss of engine power due to the pilot’s improper leaning of the engine.NTSB GAA19CA447Accident · No injuriesData collectionFinal reportBiuro Projektowe B Bogumil Ber SZD-56-2 · Sparks, NVThe pilot’s failure to abort the takeoff in a timely manner, which resulted in glider settling into sage brush.NTSB GAA19CA412Accident · No injuriesData collectionFinal reportCessna 172 · Elkton, FLThe pilot under instruction's failure to follow the flight instructor’s directions and the flight instructor's delayed remedial action and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA19LA227Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Hastings, FLThe pilot’s failure to secure the engine primer control, which resulted in an overly rich fuel/air mixture and degraded engine performance. Contributing to the accident was the pilot’s failure to abort the takeoff in a timely manner.NTSB CEN19LA225Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T188 · Knox, INThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN19LA224Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · Osceola, WIThe failure of the right horizontal stabilizer during takeoff, resulting in a loss of control and forced landing. Contributing to the accident was the installation of an unapproved stabilizer frame and failure of maintenance personnel to identify…NTSB CEN19LA223Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Elkhart, INAn inadvertent engine start of the airplane and subsequent takeoff without the pilot on-board for reasons that could not be determined based on available evidence.