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 CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…Sep 8, 2019 · N73000 · Substantial damageNTSB GAA19CA528Accident · Minor injuriesData collectionFinal reportSiai-Marchetti SM 1019 · Lakeport, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting, variable wind conditions, which resulted in a loss of airplane control and subsequent impact with water.Sep 7, 2019 · N16XC · Substantial damageNTSB CEN19TA310Accident · No injuriesClass 3Final reportChampion 7KCAB · Winnsboro, LAThe pilot's failure to maintain directional control during a crosswind landing, which resulted in an impact with a tree.Sep 7, 2019 · N4136Y · Substantial damageNTSB CEN19LA306Accident · Serious injuriesClass 3 · LimitedFinal reportPietenpol Sky Scout · Kingsbury, TXThe total loss of engine power for reasons that could not be determined with the available evidence and the pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and spin at a low altitude.Sep 7, 2019 · N1932G · Substantial damageNTSB CEN19FA305Accident · 1 fatalClass 3 · FieldFinal reportChampion 7GCBC · Carpenter, WYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.Sep 7, 2019 · N5502S · DestroyedNTSB WPR19FA251Accident · 2 fatalClass 3 · FieldFinal reportPiper PA18 · Hood River, ORThe total loss of engine power shortly after takeoff as a result of the private pilot’s failure to ensure the fuel selector was in the appropriate position and the certified flight instructor’s exceedance of the airplane’s critical angle of attack at the time…Sep 6, 2019 · N14365 · Substantial damageNTSB GAA19CA531Accident · No injuriesData collectionFinal reportRobinson R44 · Nuiqsut, AKThe pilot's improper decision to land downwind from unsecured debris, which resulted in the helicopter’s main rotor disk ingesting foreign objects.Sep 6, 2019 · N447PA · Substantial damageNTSB CEN19LA322Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Pocahontas, IAOverload failure of the left main landing gear during landing, which resulted in a loss of directional control.Sep 6, 2019 · N9895A · Substantial damageNTSB GAA19CA538Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing.Sep 5, 2019 · N19GB · Substantial damageNTSB GAA19CA536Accident · Minor injuriesData collectionFinal reportCessna 310 · Tahlequah, OKThe total loss of right engine power due to fuel starvation and the pilot's improper fuel management.Sep 5, 2019 · N7673Q · Substantial damageNTSB GAA19CA526Accident · No injuriesData collectionFinal reportPietenpol Pietenpol Aircamper · Glendo, WYThe pilot's overapplication of brakes during the landing roll, which resulted in a noseover.Sep 5, 2019 · N14961 · Substantial damageNTSB GAA19CA525Accident · Minor injuriesData collectionFinal reportCessna 182 · Charleston, WVThe pilot's improper approach path at night and his misjudgment of the landing point, which resulted in landing short of the runway and impact with the runway's engineered materials arrestor system.Sep 5, 2019 · N2408Q · Substantial damageNTSB ANC19LA053Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · Chugiak, AKOne of the pilot’s inadvertent application of the airplane's brakes, which resulted in a nose over.Sep 5, 2019 · N5057Y · Substantial damageNTSB WPR19FA250Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Henefer, UTThe pilots’ decision to enter a canyon at low altitude, which resulted in controlled flight into terrain while attempting to exit the canyon.Sep 4, 2019 · N94262 · Substantial damageNTSB GAA19CA548Accident · No injuriesData collectionFinal reportCessna 180 · Lancaster, TXThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Sep 4, 2019 · N9250T · Substantial damageNTSB GAA19CA539Accident · No injuriesData collectionFinal reportPiper J3C · Winfield, ALThe pilot's failure to maintain proper wind correction input during taxi in a gusting tailwind, which resulted in a nose over.Sep 4, 2019 · N7326H · Substantial damageNTSB CEN19LA303Accident · No injuriesClass 3 · LimitedFinal reportPhantom Aeronautics X-1 · Van Wert, OHA loss of engine power due to the separation of the carburetor from the intake socket resulting from the improper installation of the intake silencer.Sep 4, 2019 · N111JC · Substantial damageNTSB GAA19CA534Accident · No injuriesData collectionFinal reportPiper PA28 · Sawyer, MIThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss…Sep 3, 2019 · N2909U · Substantial damageNTSB GAA19CA523Accident · No injuriesData collectionFinal reportCessna A185 · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 3, 2019 · N34GE · Substantial damageNTSB CEN19LA313Accident · No injuriesClass 3 · LimitedFinal reportJackson Velocity · Mack, COA propeller overspeed due to failure of the electronic ignition timing ring attachment screws, and a runway overrun during the subsequent forced landing.Sep 3, 2019 · N2XF · Substantial damageNTSB ANC19LA051Accident · No injuriesClass 3 · LimitedFinal reportLake LA-4-200 · Girdwood, AKThe pilot's loss of directional control while landing, which resulted in a runway excursion and collision with terrain.Sep 3, 2019 · N6672L · Substantial damageNTSB GAA19CA521Accident · No injuriesData collectionFinal reportPiper PA18 · Beluga, AKThe pilot's failure to maintain an adequate climb rate during takeoff in gusting wind conditions, which resulted in an uncontrolled descent.Sep 2, 2019 · N655HE · Substantial damageNTSB GAA19CA520Accident · No injuriesData collectionFinal reportPiper PA32RT · Mackinac Island, MIThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway light.Sep 2, 2019 · N31934 · Substantial damageNTSB ERA19LA263Accident · 1 fatalClass 3 · LimitedFinal reportWeatherly 620 · Russellville, ALThe pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.Sep 2, 2019 · N90104 · DestroyedNTSB CEN19TA327Accident · No injuriesClass 3Final reportPiper PA60 · Tulsa, OKThe pilot's improper landing flare, which resulted in an aerodynamic stall and hard landing.Sep 2, 2019 · N1R · Substantial damageNTSB CEN19LA302Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · La Grange, TXThe pilot's improper flare, which resulted in a hard landing.Sep 2, 2019 · N212BS · Substantial damageNTSB CEN19CA336Accident · No injuriesData collectionFinal reportPiper PA38 · Taylor, TXThe flight instructor's inadequate supervision of the student's soft-field takeoff, which resulted in an excessive pitch attitude, settling effect, and impact with a ditch off the end of the runway.Sep 2, 2019 · N6400A · Substantial damageNTSB GAA19CA530Accident · No injuriesData collectionFinal reportPiper PA 18 · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing and the pilot's improper pitch control during the landing roll which resulted in a nose over.Sep 1, 2019 · N72842 · Substantial damageNTSB GAA19CA524Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Manchester, NHThe student pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with approach lights.Sep 1, 2019 · N7777W · Substantial damageNTSB GAA19CA522Accident · No injuriesData collectionFinal reportStinson 108 · Bandera, WAThe pilot's selection of unsuitable terrain for a simulated rejected takeoff, which resulted in a runway overrun and noseover.Sep 1, 2019 · N97699 · Substantial damageNTSB WPR19LA247Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 510 · El Monte, CAThe pilot's failure to disengage the parking brake before takeoff, which resulted in decreased acceleration and a subsequent runway overrun following an aborted takeoff.Aug 31, 2019 · N551WH · Substantial damageNTSB GAA19CA527Accident · No injuriesData collectionFinal reportDiamond DA20 · Convington, TNThe student pilot's improper pitch attitude during the takeoff climb, and the flight instructor's delayed remedial action which resulted in an aerodynamic stall and ground impact.Aug 31, 2019 · N98BZ · Substantial damageNTSB WPR19TA248Accident · Minor injuriesClass 3Final reportHall Kitfox · Nampa, IDThe owner's improper installation of the tailwheel, which resulted in the pilot's inability to maintain directional control during landing as a result of severe tailwheel vibrations.Aug 30, 2019 · N87TJ · Substantial damageNTSB GAA19CA568Accident · No injuriesData collectionFinal reportLuscombe 8 · Prescott, AZThe pilot's loss of directional control and subsequent overapplication of rudder pedal, which resulted in a runway excursion and the right wing striking the ground.Aug 30, 2019 · N25100 · Substantial damageNTSB GAA19CA537Accident · No injuriesData collectionFinal reportCzech Sport Sportcruiser · Murrieta, CAThe student pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control and a hard landing.Aug 30, 2019 · N117BF · Substantial damageNTSB ANC19LA048Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18 · Fairbanks, AKThe inappropriate application of paint underneath the engine cylinder hold-down nuts, which resulted in inadequate torque and the subsequent in-flight separation of the No. 3 cylinder, and resulted in a total loss of engine power.Aug 30, 2019 · N1124 · Substantial damageNTSB ANC19CA057Accident · Minor injuriesData collectionFinal reportPiper PA22 · Arctic Village, AKThe pilot's failure to maintain adequate airspeed while maneuvering to avoid mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.Aug 30, 2019 · N7056D · Substantial damageNTSB WPR19FA246Accident · 3 fatalClass 3 · FieldFinal reportBeech 33 · St. Ignatius, MTThe pilot’s decision to maneuver the airplane at a low altitude, which resulted in impact with power lines and terrain.Aug 29, 2019 · N9529Y · Substantial damageNTSB CEN19LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Denver, COA total loss of electrical power for reasons that could not be determined, and the student pilot’s subsequent runway overrun during a no-flap landing.Aug 29, 2019 · N53432 · Substantial damageNTSB WPR19TA245Accident · No injuriesClass 3Final reportBell 47G · North Las Vegas, NVThe noncertificated passenger’s loss of control during attempted hover operations.Aug 28, 2019 · N6064H · Substantial damageNTSB WPR19FA244Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · McKenzie Bridge, ORThe pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…Aug 28, 2019 · N4108F · DestroyedNTSB GAA19CA518Accident · No injuriesData collectionFinal reportPiper PA32RT · Ashland, ORThe pilot's improper landing flare, which resulted in a bounced, hard landing and propeller strike, and his subsequent loss of directional control.Aug 28, 2019 · N2228B · Substantial damageNTSB GAA19CA519Accident · No injuriesData collectionFinal reportBell 206 · San Diego, CAThe pilot's failure to maintain yaw and pitch control while repositioning the helicopter, which resulted in dynamic rollover.Aug 27, 2019 · N218GH · Substantial damageNTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.Aug 27, 2019 · N7184B · Substantial damageNTSB CEN19LA290Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35 · Monroe, WIA total loss of engine power due to the failure of the Nos. 5 and 6 connecting rods from a lack of oil lubrication for reasons that could not be determined.Aug 27, 2019 · N6245V · Substantial damageNTSB WPR19LA243Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20C · Reno, NVThe pilot's improper inflight fuel management, which resulted in fuel starvation and a total loss of engine power.Aug 26, 2019 · N78988 · Substantial damageNTSB WPR19FA241Accident · 1 fatalClass 3 · FieldFinal reportGlaser Dirks DG 300 Elan · Wilkeson, WAThe pilot’s delayed decision to land following a loss of thermal lift, which resulted in collision with trees during the landing approach.Aug 25, 2019 · N300GG · Substantial damageNTSB GAA19CA514Accident · No injuriesData collectionFinal reportHughes 269A · Shamokin, PAThe pilot's improper landing flare during an autorotation, which resulted in a hard landing. Contributing to the accident was a loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of any…Aug 25, 2019 · N653CH · Substantial damageNTSB GAA19CA511Accident · No injuriesData collectionFinal reportPiper PA28 · Cottonwood, AZThe student pilot's improper pitch and lateral control during a soft-field takeoff, which resulted in impact with terrain. Contributing to the accident was the student pilot's failure to relinquish control of the airplane to the instructor.Aug 25, 2019 · N8619W · Substantial damageNTSB CEN19TA330Accident · No injuriesClass 3Final reportCirrus SR22 · Glenwood Springs, COThe pilot’s failure to maintain control of the airplane while landing with a tail wind, which resulted in an aerodynamic stall and a subsequent hard landing..Aug 25, 2019 · N983WP · Substantial damage