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.

NTSB GAA16CA458Accident · No injuriesData collectionFinal reportPiper PA18 · Central, AKThe pilot's decision to taxi on unsuitable terrain after landing, which resulted in an encounter with a washed out ditch.Aug 26, 2016 · N9575D · Substantial damageNTSB WPR16LA167Accident · Minor injuriesClass 3 · LimitedFinal reportSiai-Marchetti SF260 · Fullerton, CAThe failure of the pilot to set the flaps to the proper takeoff setting before takeoff, resulting in an aerodynamic stall during takeoff and loss of control.Aug 25, 2016 · N16FD · Substantial damageNTSB GAA16CA451Accident · No injuriesData collectionFinal reportAyres S 2R · Cordele, GAThe pilot’s failure to maintain clearance from power lines during an agricultural application flight while flying toward the sun.Aug 25, 2016 · N3003N · Substantial damageNTSB CEN16LA348Accident · No injuriesLimited investigationFinal reportPiper PA 18-180 · Colorado Springs, COThe pilot's failure to maintain directional control after encountering a wind gust during the landing roll, which resulted in a ground loop.Aug 25, 2016 · N66898 · Substantial damageNTSB CEN16FA333Accident · 1 fatalField investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain a normal approach path to the runway, which resulted in the airplane colliding with a tree and a house during final approach. Contributing to the accident was the pilot's lack of recent flight experience.Aug 25, 2016 · N17SK · Substantial damageNTSB ANC16CA058Accident · No injuriesData collectionFinal reportPiper J5A · Sterling, AKThe pilot's improper fuel management, which led to fuel exhaustion and a subsequent forced landing on a road too narrow for the airplane.Aug 25, 2016 · N35589 · Substantial damageNTSB GAA16CA502Accident · No injuriesData collectionFinal reportArion Skys Open Sport Lightning · St. Augustine, FLThe pilot’s improper landing flare, which resulted in a hard landing.Aug 24, 2016 · N481SL · Substantial damageNTSB GAA16CA453Accident · No injuriesData collectionFinal reportCessna 150 · Franklin, PAThe student pilot's failure to maintain pitch control resulting in a hard landing and the flight instructor's delayed action to assist the student pilot during the aborted landing, which resulted in a runway excursion, a right main and nose gear collapse, and…Aug 24, 2016 · N8120S · Substantial damageNTSB GAA16CA450Accident · No injuriesData collectionFinal reportAirbus AS350 · Peach Springs, AZThe pilot's failure to maintain clearance from terrain while hover taxiing backward, resulting in the tail striking terrain.Aug 24, 2016 · N839PA · Substantial damageNTSB GAA16CA449Accident · Minor injuriesData collectionFinal reportCessna 182 · Fallbrook, CAThe flight instructor's failure to go-around and the subsequent long landing and his failure to maintain directional control, which resulted in a runway excursion.Aug 24, 2016 · N4810N · Substantial damageNTSB ERA16FA297Accident · 1 fatalField investigationFinal reportHeberlein Ronald Vans RV 9A · Sebring, FLThe pilot's failure to maintain clearance from terrain.Aug 24, 2016 · N379RV · DestroyedNTSB CEN16LA336Accident · No injuriesLimited investigationFinal reportBeech E-55 · Wichita Falls, TXThe failure of the landing gear assembly snap ring, which prevented the pilot from being able to extend the landing gear and resulted in a gear-up landing. Also causal was the lack of the assembly's overhaul in accordance with the airplane maintenance manual.Aug 24, 2016 · N855T · Substantial damageNTSB CEN16FA331Accident · 2 fatalField investigationFinal reportStemme S10 VT · Telluride, COThe pilot's encounter with a downdraft that exceeded the climb performance of the powered glider and resulted in his inability to maintain clearance from the trees. Contributing to the accident was the pilot's decision to fly near building clouds and rain…Aug 24, 2016 · N5021 · Substantial damageNTSB GAA16CA452Accident · No injuriesData collectionFinal reportSimmons Noel SDL · Naches, WAThe pilot’s improper landing flare, which resulted in a bounced landing.Aug 23, 2016 · N945PL · Substantial damageNTSB GAA16CA447Accident · No injuriesData collectionFinal reportCessna 172 · Williamsport, PAThe student pilot's distraction during taxi operations, which resulted in the airplane's left wing impacting a hangar.Aug 23, 2016 · N9480E · Substantial damageNTSB GAA16CA445Accident · No injuriesData collectionFinal reportCessna T207 · Nanwalek, AKThe pilot’s unstabilized approach and a subsequent runway overrun while landing on a short runway in variable wind conditions.Aug 23, 2016 · N91025 · Substantial damageNTSB GAA16CA448Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe pilot's improper pitch control during landing, which resulted in a bounced landing, and a nose landing gear collapse.Aug 21, 2016 · N94939 · Substantial damageNTSB GAA16CA446Accident · No injuriesData collectionFinal reportCessna A185 · Caldwell, IDThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.Aug 21, 2016 · N4477R · Substantial damageNTSB GAA16CA444Accident · Minor injuriesData collectionFinal reportP Z L -Warszawa-Cnpsl PZL 104 Wilga · Austin, NVThe pilot's failure to maintain an appropriate descent rate during the base to final turn, which resulted in a forced landing, and an intentional aerodynamic stall. Contributing to the accident was the pilot's excessive braking, which resulted in a nose over…Aug 21, 2016 · N65ZA · Substantial damageNTSB GAA16CA438Accident · No injuriesData collectionFinal reportCessna A185 · Fayetteville, TNThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and a ground loop.Aug 21, 2016 · N185DK · Substantial damageNTSB ERA16LA305Accident · No injuriesLimited investigationFinal reportDayton A Babcock Storm · Eustis, FLThe pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the loss of engine power due to a malfunctioning alternator, which precipitated the off-field landing, and the pilot’s decision to attempt to take…Aug 20, 2016 · N516VB · Substantial damageNTSB ERA16LA296Accident · No injuriesLimited investigationFinal reportMantell Allan T Kitfox 4 1200 · Canandaigua, NYThe failure of the right rudder pedal torque tube due to fatigue, which resulted in a loss of directional control during landing. Also causal to the accident was the airplane owner/builder's failure to install a rudder torque tube reinforcement or replacement…Aug 20, 2016 · N51TM · Substantial damageNTSB GAA16CA443Accident · No injuriesData collectionFinal reportCessna A185 · Klamath Falls, ORThe pilot's improper landing flare, which resulted in the airplane porpoising and the subsequent loss of directional control.Aug 19, 2016 · N185SC · Substantial damageNTSB GAA16CA440Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Palmer, AKThe pilot's excessive brake application during the landing roll resulting in a nose over.Aug 19, 2016 · N5408Y · Substantial damageNTSB ERA16LA295Accident · No injuriesLimited investigationFinal reportPiper PA34 · Hollywood, FLMaintenance personnel’s failure to comply with an airworthiness directive for the propeller, which resulted in a propeller hub failure due to fatigue.Aug 19, 2016 · N16499 · Substantial damageNTSB CEN16LA326Accident · 1 fatalLimited investigationFinal reportThrush S2R T660 · Ruthton, MNThe pilot's failure to see and avoid the tower guy-wire during an agricultural spraying operation.Aug 19, 2016 · N40499 · DestroyedNTSB CEN16FA328Accident · 1 fatalField investigationFinal reportAero Commander S2R · Center, COThe pilot's failure to maintain airplane control during a low-level maneuver, which resulted in an aerodynamic stall.Aug 19, 2016 · N8870Q · DestroyedNTSB WPR16FA166Accident · Minor injuriesField investigationFinal reportDouglas TA-4K · Las Vegas, NVForeign object debris in the engine's main fuel control unit, which restricted fuel flow and subsequently resulted in the loss of engine power. Contributing to the accident was the installation or addition of an extra seal during the main fuel control unit…Aug 18, 2016 · N140EM · DestroyedNTSB GAA16CA439Accident · No injuriesData collectionFinal reportBell 206 L4 · Broussard, LAThe pilot's failure to attain a proper touchdown point, which resulted in the helicopter sliding off the aft end of the transport dolly.Aug 18, 2016 · N7898X · Substantial damageNTSB CEN16LA329Accident · Serious injuriesLimited investigationFinal reportCollins RV6A · Pekin, ILThe pilot's failure to latch the canopy before takeoff, and his subsequent distraction and failure to maintain control while attempting to close the open canopy, which resulted in an aerodynamic stall.Aug 18, 2016 · N576RV · Substantial damageNTSB GAA16CA455Accident · No injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall and a hard landing.Aug 17, 2016 · N8076Z · Substantial damageNTSB GAA16CA441Accident · No injuriesData collectionFinal reportValloric Carl Stephen Valloric Sport Trnr · Cadiz, OHThe pilot's failure to maintain directional control during landing and the unintentional right brake application, which resulted in a runway excursion and a nose over.Aug 17, 2016 · N772CV · Substantial damageNTSB GAA16CA437Accident · No injuriesData collectionFinal reportCessna 152 · Belle Plaine, MNThe student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.Aug 17, 2016 · N631TK · Substantial damageNTSB GAA16CA434Accident · No injuriesData collectionFinal reportCessna 182 · Anchorage, AKThe pilot's failure to maintain a controlled landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's inattention and distraction.Aug 17, 2016 · N2704Q · Substantial damageNTSB ERA16CA294Accident · No injuriesData collectionFinal reportCessna 152 · Newnan, GAThe student pilot's improper decision to land long and maintain excessive speed during the landing roll. Contributing to the accident was the student pilot's decision to maintain full flaps and aft yoke inputs at a higher speed, reducing his ability to stop…Aug 17, 2016 · N5250B · Substantial damageNTSB GAA16CA436Accident · No injuriesData collectionFinal reportPiper PA18 · Anchor Point, AKThe pilot's failure to maintain clearance from obstacles while landing on a coastal beach.Aug 16, 2016 · N8097N · Substantial damageNTSB GAA16CA432Accident · No injuriesData collectionFinal reportCessna 150 · North Conway, NHThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, a forced landing, and nose over.Aug 15, 2016 · N7157X · Substantial damageNTSB GAA16CA473Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, MOThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the airplane porpoising.Aug 14, 2016 · N78242 · Substantial damageNTSB GAA16CA430Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 6U · Llano, CAThe pilot’s failure to properly secure the two aft canopy latches during the preflight inspection, which resulted in the canopy separating from the glider during the takeoff roll and substantial damage to the vertical stabilizer.Aug 14, 2016 · N212EC · Substantial damageNTSB ERA16FA289Accident · 6 fatalField investigationFinal reportPiper PA 31 · Northport, ALA total loss of power in both engines due to fuel starvation as a result of the pilot's fuel mismanagement, and his subsequent failure to follow the emergency checklist. Contributing to the pilot's failure to follow the emergency checklist was his lack of…Aug 14, 2016 · N447SA · Substantial damageNTSB GAA16CA454Accident · No injuriesData collectionFinal reportPiper PA 34 · Fort Lauderdale, FLThe other pilot's failure to ensure that the brake was fully engaged and his subsequent failure to notice that his airplane was rolling forward, which resulted in it hitting another airplane.Aug 13, 2016 · N8166U · 2 aircraft · Minor damageNTSB GAA16CA429Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Joseph, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and damage to the left aileron and elevator.Aug 13, 2016 · N53331 · Substantial damageNTSB ERA16LA293Accident · No injuriesClass 3 · LimitedFinal reportCessna 150G · Shirley, NYMaintenance personnel’s inadequate maintenance and inspection of the airplane, which resulted in the left elevator attachment bolt backing out of the nutplate, and partial inflight separation and damage of the elevator.Aug 13, 2016 · N3666J · Substantial damageNTSB ERA16LA291Accident · Serious injuriesLimited investigationFinal reportLuscombe 8 · Marlboro, NJThe pilot's inadequate in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power.Aug 13, 2016 · N71497 · Substantial damageNTSB ANC16FA057Accident · 1 fatalField investigationFinal reportChampion 7ECA · Chugiak, AKThe pilot's failure to maintain proper airspeed and his exceedance of the airplane's critical angle of attack during a steep low-altitude turn following a loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control at too low…Aug 13, 2016 · N9541S · DestroyedNTSB GAA16CA431Accident · No injuriesData collectionFinal reportCessna 152 · Hillsboro, ORThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the engine mount.Aug 12, 2016 · N48440 · Substantial damageNTSB GAA16CA428Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5A · Reno, NVThe pilot's failure to see and avoid fence posts during landing, which resulted in substantial damage to the wings.Aug 12, 2016 · N26104 · Substantial damageNTSB ERA16FA288Accident · 6 fatalField investigationFinal reportBeech 95 B55 (T42A) · Fredericksburg, VAThe pilot(s) failure to maintain adequate airspeed during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.Aug 12, 2016 · N128VB · Substantial damageNTSB ERA16CA290Accident · Serious injuriesData collectionFinal reportKessinger Roger L Rans Coyote · London, KYThe student pilot's improper recovery from a bounced landing and his subsequent failure to maintain clearance from trees during an attempted go-around.Aug 12, 2016 · N910RK · Substantial damageNTSB GAA16CA433Accident · No injuriesData collectionFinal reportMaule MXT7 · Quitman, ARThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's limited forward visibility due to sun glare.Aug 11, 2016 · N1665B · Substantial damage