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 GAA20CA072Accident · No injuriesData collectionFinal reportCessna U206 · Mexico, MOThe pilot's failure to properly set the parking brake before exiting an operating airplane, which resulted in a runaway airplane and subsequent impact with trees.Nov 10, 2019 · N29173 · Substantial damageNTSB GAA20CA063Accident · Minor injuriesData collectionFinal reportSikorsky S 58JT · Lebanon, INThe pilot's failure to maintain proper clearance from a tractor trailer during landing.Nov 10, 2019 · N827MW · Substantial damageNTSB GAA20CA085Accident · No injuriesData collectionFinal reportPiper PA60 · Salt Lake City, UTThe pilot's failure to follow the taxiway centerline guide and his distraction due to adjusting the radio, which resulted in his failure to maintain clearance from a taxiway light after landing and while taxiing to a ramp.Nov 9, 2019 · N914MB · Substantial damageNTSB GAA20CA084Accident · No injuriesData collectionFinal reportBeech 55 · Broomfield, COThe pilot's unintentional retraction of the landing gear during the landing roll.Nov 9, 2019 · N6206V · Substantial damageNTSB GAA20CA064Accident · Minor injuriesData collectionFinal reportNew Glasair Sportsman GS-2 · Huntsville, ARThe pilot's failure to maintain proper pitch control during takeoff from a muddy, turf runway and his exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.Nov 9, 2019 · N24EP · Substantial damageNTSB ERA20LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Griffin, GAThe pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.Nov 9, 2019 · N686DR · Substantial damageNTSB CEN20LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Houston, TXThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.Nov 9, 2019 · N7703J · Substantial damageNTSB GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.Nov 8, 2019 · N9925N · Substantial damageNTSB WPR20FA019Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Upland, CAThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.Nov 7, 2019 · N220MT · DestroyedNTSB GAA20CA062Accident · No injuriesData collectionFinal reportBell 47G · Groveland, FLThe student pilot's improper cyclic input after a reported hydraulic failure, the reason for which could not be determined, and his failure to follow the emergency procedures, which resulted in a hard landing.Nov 7, 2019 · N6746D · Substantial damageNTSB DCA20IA014Incident · No injuriesClass 3 · IncidentFinal reportEmbraer ERJ170 · Atlanta, GAThe captain’s use of his pitch trim switch, which had been placarded inoperative but not deactivated, resulting in the airplane pitching up when the captain was trying to trim down. The trim commands were reversed due to maintenance personnel’s incorrect…Nov 7, 2019 · N117HQ · No damageNTSB GAA20CA075Accident · No injuriesData collectionFinal reportCessna 182 · Broomfield, COThe pilot’s inadvertent flight into icing conditions, which resulted in the accumulation of structural icing and an aerodynamic stall.Nov 6, 2019 · N97596 · Substantial damageNTSB WPR20LA032Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Hurricane, UTThe pilot’s failure to ensure that the landing gear was in the fully extended and locked position before landing. Contributing to the accident was the overload of the landing gear circuit for reasons that could not be determined.Nov 4, 2019 · N936TC · Substantial damageNTSB GAA20CA060Accident · No injuriesData collectionFinal reportRobinson R22 · Smoketown, PAThe student pilot's improper cyclic input while hovering and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.Nov 4, 2019 · N8560A · Substantial damageNTSB ERA20TA030Accident · No injuriesClass 3Final reportBeech 76 · Doral, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.Nov 4, 2019 · N6015Z · Substantial damageNTSB ERA20FA031Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · New Bedford, MAPilot impairment due to exposure to carbon monoxide as a result of undetected corrosion and holes in the engine’s left exhaust muffler.Nov 4, 2019 · N714LK · DestroyedNTSB ERA20FA029Accident · 1 fatalClass 3 · FieldFinal reportPavel Tango2 · Cedartown, GAThe pilot's loss of control of the gyroplane for reasons that could not be determined based on available evidence.Nov 4, 2019 · N875FV · Substantial damageNTSB GAA20CA059Accident · No injuriesData collectionFinal reportErcoupe 415 · Greer, SCThe pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.Nov 3, 2019 · N87173 · Substantial damageNTSB GAA20CA056Accident · No injuriesData collectionFinal reportPitts S1 · Monument Valley, UTThe pilot's failure to maintain directional control during landing after a wing struck vegetation, which resulted in a runway excursion and subsequent ground-loop.Nov 3, 2019 · C-GMEE · Substantial damageNTSB GAA20CA068Accident · No injuriesData collectionFinal reportIcon A5 · Chester, CTThe pilot's failure to maintain a proper approach angle in dark night conditions, which resulted in a collision with treetops and a subsequent hard landing.Nov 2, 2019 · N59WE · Substantial damageNTSB GAA20CA066Accident · No injuriesData collectionFinal reportAmerican AA 5 · Gilbert, SCThe pilot's improper approach path, which resulted in impact with a tree.Nov 2, 2019 · N24AU · Substantial damageNTSB GAA20CA057Accident · No injuriesData collectionFinal reportCub Crafters CC11 · Palmyra, PAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain lateral control during a go-around, which resulted in impact with a tree.Nov 2, 2019 · N718CC · Substantial damageNTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.Nov 2, 2019 · UNREG · Substantial damageNTSB GAA20CA053Accident · No injuriesData collectionFinal reportZenair CH701 · Salem, ORThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to make his first flight in an airplane he unfamiliar with before waiting for calm winds.Nov 1, 2019 · N102PH · Substantial damageNTSB ERA20LA028Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Odessa, TXA loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.Nov 1, 2019 · N732JW · Substantial damageNTSB ERA20FA027Accident · 1 fatalClass 3 · FieldFinal reportGrumman OV-1 · Stuart, FLThe pilot’s improper recovery from a low-altitude aerobatic maneuver, which resulted in descent into terrain.Nov 1, 2019 · N10VD · DestroyedNTSB ERA20FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Paducah, KYThe pilot’s failure to fully seat the fuel selector in the proper tank position during the descent for landing, which resulted in fuel starvation and a total loss of engine power.Nov 1, 2019 · N181AG · DestroyedNTSB CEN20LA017Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TB 30 Epsilon · Kalamazoo, MIA total loss of engine power for undetermined reasons, which resulted in an aerodynamic stall during the pilot’s attempted forced landing at low altitude and impact with terrain.Nov 1, 2019 · N50TB · Substantial damageNTSB WPR20FA018Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Brawley, CAThe pilot’s decision to perform a flight while impaired by the effects of alcohol and cocaine, and his failure to maintain terrain clearance during the flight.Oct 31, 2019 · N7158X · Substantial damageNTSB ERA20FA025Accident · 1 fatalClass 3 · FieldFinal reportVans RV 4 · Middleburg, FLImpact with power lines for reasons that could not be determined based on available evidence.Oct 31, 2019 · N425JW · DestroyedNTSB ERA20FA022Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Ocala, FLThe pilot’s failure to maintain control of the airplane due to an acute medical event and/or his use of impairing medications.Oct 31, 2019 · N959CM · DestroyedNTSB ANC20LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Honolulu, HIThe pilot of the Cessna's failure to set the parking brake before diverting his attention inside the airplane, which resulted in his airplane colliding with the airplane ahead of it on the taxiway.Oct 31, 2019 · N926FE · 2 aircraft · Minor damageNTSB ERA20FA021Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Atlanta, GAThe pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.Oct 30, 2019 · N56258 · DestroyedNTSB GAA20CA082Accident · No injuriesData collectionFinal reportCessna 170 · Albuquerque, NMThe pilot receiving instruction's failure to maintain directional control and his inadvertent left brake pedal application during the landing roll, which resulted in a runway excursion and ground-loop.Oct 29, 2019 · N3016A · Substantial damageNTSB GAA20CA052Accident · No injuriesData collectionFinal reportRobinson R66 · Alexandria, LAThe pilot's fixation on the instrument panel, which resulted in a hard landing.Oct 29, 2019 · N661CG · Substantial damageNTSB ERA20FA020Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Colonia, NJThe pilot’s failure to maintain airspeed during a circling instrument approach procedure, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall and spin.Oct 29, 2019 · N959MJ · DestroyedNTSB GAA20CA058Accident · No injuriesData collectionFinal reportLet L13 · Enumclaw, WAThe pilot's failure to maintain a proper glidepath, which resulted in a collision with trees.Oct 28, 2019 · N213TA · Substantial damageNTSB GAA20CA055Accident · No injuriesData collectionFinal reportCessna 172 · Augusta, GAThe student pilot's failure to attain sufficient airspeed to climb out of ground effect, which resulted in a descent, loss of directional control, runway excursion, and impact with a fence.Oct 28, 2019 · N80931 · Substantial damageNTSB GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.Oct 27, 2019 · N35HW · DestroyedNTSB GAA20CA048Accident · Minor injuriesData collectionFinal reportBeech A36 · Le Roy, NYThe pilot's improper pitch control during takeoff in high, gusting wind conditions, which resulted in a runway overrun and the nose landing gear collapsing.Oct 27, 2019 · N9008V · Substantial damageNTSB ERA20LA023Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Grand Bay, ALA loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay, and the pilot's failure to use carburetor heat before initiating the takeoff.Oct 27, 2019 · N7009H · Substantial damageNTSB CEN20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · White Bear Township, MNThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.Oct 27, 2019 · N2621P · DestroyedNTSB GAA20CA051Accident · No injuriesData collectionFinal reportPereyra Aventura · Tavares, FLThe pilot's improper landing flare, which resulted in a bounced landing on water, and his failure to maintain airplane control during a go-around, which resulted in the airplane nosing over.Oct 26, 2019 · N170AV · Substantial damageNTSB WPR20FAMS1Accident · 2 fatalClass 3 · Missing aircraftFinal reportPiper PA28R · Shelter Cove, CAUndetermined due to lack of available evidence.Oct 25, 2019 · N4958J · DestroyedNTSB WPR20FA016Accident · 1 fatalClass 3 · FieldFinal reportEnstrom 280F · Jordan Valley, ORA partial loss of engine power due to a worn engine air induction hose, and a subsequent uncontrolled descent into terrain. Contributing to the accident was the failure of maintenance personnel to adequately inspect the hose, and the pilot’s decision to fly…Oct 25, 2019 · N280F · Substantial damageNTSB WPR20FA015Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · American Falls, IDThe pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…Oct 25, 2019 · N201BJ · Substantial damageNTSB GAA20CA050Accident · No injuriesData collectionFinal reportPiper PA 30 · Opa Locka, FLThe pilot receiving instruction's failure to relinquish the flight controls to the flight instructor during a simulated engine failure during takeoff, which resulted in the airplane touching down in a left banking attitude and the landing gear collapsing.Oct 25, 2019 · N8816Y · Substantial damageNTSB CEN20LA014Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Swea City, IAThe pilot's failure to replace the oil filler cap during his preflight inspection, which resulted in oil starvation and a subsequent total loss of engine power.Oct 25, 2019 · N1443E · Substantial damageNTSB WPR20LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 205 · Red Creek, AZThe pilot’s failure to properly configure the flaps for an aborted landing, which resulted in degraded climb performance and impact with vegetation at the end of the runway.Oct 24, 2019 · N8326Z · Substantial damageNTSB GAA20CA091Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 · Apopka, FLThe student pilot's improper landing flare, which resulted in a hard, bounced landing and subsequent nose-over.Oct 24, 2019 · N639BV · Substantial damage