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 WPR20TA039Accident · Minor injuriesClass 3Final reportEnstrom F28 · Riverton, UTThe noncertificated pilot’s decision to operate a deregistered helicopter, which resulted in a component failure and subsequent loss of control and hard landing. Contributing to the accident was the lack of recent maintenance on the helicopter.Dec 11, 2019 · N65RS · Substantial damageNTSB WPR20LA038Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-34-200T · Phoenix, AZThe pilot’s mismanagement of the fuel onboard, which resulted in a loss of engine power due to fuel starvation. Contributing to the fuel starvation was the erroneous indications on the fuel gauges.Dec 11, 2019 · N2822F · Substantial damageNTSB ERA20LA053Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYThe pilot’s improper flare to land, which resulted in a hard landing and the nose landing gear collapsing.Dec 10, 2019 · N9097W · Substantial damageNTSB CEN20FA032Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Victoria, TXThe pilot’s loss of control due to spatial disorientation. Contributing to the accident were the inoperative attitude indicator and horizontal situation indicator on the pilot’s side of the cockpit, and the pilot’s failure to reference the flight instruments…Dec 10, 2019 · N4602B · DestroyedNTSB ANC20CA037Accident · No injuriesData collectionFinal reportCessna 207 · Kwigillingok, AKThe pilot's improper decision to depart from an ice-covered runway with a strong crosswind, which resulted in a loss of directional control, runway excursion, and impact with a ditch.Dec 10, 2019 · N9728M · Substantial damageNTSB ERA20LA050Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH-650 · Willow Springs, MOImproper maintenance practices on the fuel system causing fuel starvation and a total loss of engine power.Dec 8, 2019 · N914AR · Substantial damageNTSB CEN20FA034Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Flower Pot, AZThe noninstrument-rated pilot’s decision to initiate and continue the visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of airplane control. Contributing was…Dec 8, 2019 · N5557Q · DestroyedNTSB CEN20TA030Accident · Serious injuriesClass 3Final reportRotary RAF 2000 · Omaha, NEThe pilot's loss of directional control while landing in gusting wind conditions.Dec 7, 2019 · N47EB · Substantial damageNTSB CEN20TA031Accident · No injuriesClass 3Final reportBeech 36 · Spring Branch, TXThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified weight and balance limitations, which resulted in a failure of the airplane to become airborne, an aborted takeoff, and subsequent…Dec 6, 2019 · N408P · Substantial damageNTSB WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.Dec 5, 2019 · N52458 · Substantial damageNTSB ERA20LA047Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Potts Camp, MSThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.Dec 4, 2019 · N2876Q · Substantial damageNTSB CEN20LA029Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Baldwin City, KSThe pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.Dec 4, 2019 · N45606 · Substantial damageNTSB WPR20CA036Accident · No injuriesData collectionFinal reportJavron PA-18 Replica · Nephi, UTThe passenger’s inadvertent application of the brakes during landing, which resulted in a nose-over.Dec 3, 2019 · N864SC · Substantial damageNTSB CEN20LA028Accident · No injuriesClass 3 · LimitedFinal reportBAE BAE125 · Detroit, MIThe pilots’ failure to increase approach speed as recommended for flight in icing conditions, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the failure of the stall warning system to advise the…Dec 3, 2019 · N469RJ · Substantial damageNTSB ERA20TA046Accident · No injuriesClass 3Final reportPiper PA28 · Vero Beach, FLThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power.Dec 2, 2019 · N558PU · Substantial damageNTSB ERA20CA048Accident · No injuriesData collectionFinal reportCirrus SR22 · Union City, TNThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a runway excursion and the left wing impacting grass.Dec 1, 2019 · N991WS · Substantial damageNTSB CEN20FA022Accident · 9 fatalClass 3 · FieldFinal reportPilatus PC12 · Chamberlain, SDThe pilot’s loss of control shortly after takeoff, which resulted in an inadvertent, low-altitude aerodynamic stall. Contributing to the accident was the pilot’s improper loading of the airplane, which resulted in reduced static longitudinal stability and his…Nov 30, 2019 · N56KJ · DestroyedNTSB CEN20CA027Accident · No injuriesData collectionFinal reportSkystar Kitfox · Williamston, MIThe pilot's improper decision to continue taxiing the airplane on unsuitable terrain, which resulted in a nose-over.Nov 30, 2019 · N58CD · Substantial damageNTSB ANC20FA007Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Cooper Landing, AKThe pilot’s failure to maintain clearance from terrain during gusty wind and reduced visibility night conditions.Nov 30, 2019 · N4087G · DestroyedNTSB WPR20LA035Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH701 · Byron, CAThe pilot/builder's improper construction of the cowling, which resulted in inadequate venting of the engine, its overheating, and a partial loss of engine power.Nov 29, 2019 · N701WJ · Substantial damageNTSB WPR20FA034Accident · 3 fatalClass 3 · FieldFinal reportCirrus SR-22 · North Las Vegas, NVThe pilot’s failure to maintain clearance from terrain during cruise flight in dark night conditions.Nov 27, 2019 · N7GA · DestroyedNTSB ANC20FA005Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Blythe, CAA loss of control in flight due to the pilot’s decision to fly into a mountain range, at night, in conditions conducive to high wind, mountain waves, and turbulence.Nov 26, 2019 · N14UC · DestroyedNTSB WPR20CA058Accident · No injuriesData collectionFinal reportAeronca 11AC · San Diego, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind, which resulted in a collision with an airport sign and subsequent ground-loop.Nov 25, 2019 · N9510E · Substantial damageNTSB DCA20CA028Accident · No injuriesData collectionFinal reportGeneral Atomics MQ-9 · Palmdale, CAIncorrect control inputs by the student pilot during a crosswind landing, resulting in control saturation and a runway excursion.Nov 25, 2019 · N341HK · Substantial damageNTSB CEN20TA025Accident · No injuriesClass 3Final reportPiper PA34 · Mount Pleasant, TXThe pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.Nov 25, 2019 · N15412 · Substantial damageNTSB ERA20FA043Accident · 1 fatalClass 3 · FieldFinal reportBushby Bushby Mustang M II · Milton, FLThe pilot’s failure to maintain control of the airplane on takeoff, which resulted in an aerodynamic stall.Nov 24, 2019 · N24GL · Substantial damageNTSB WPR20FA031Accident · 2 fatalClass 3 · FieldFinal reportGrumman AA5 · Jackpot, NVThe pilot’s loss of control due to spatial disorientation while departing in dark night conditions, which resulted in impact with terrain. Contributing to the accident was the pilot’s limited experience flying in night conditions.Nov 23, 2019 · N310PD · DestroyedNTSB GAA20CA094Accident · Minor injuriesData collectionFinal reportPiper PA28 · Simsbury, CTThe automobile driver's incursion onto an active runway, which resulted in a collision with a landing airplane.Nov 23, 2019 · N5776W · Substantial damageNTSB GAA20CA092Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportscruiser · Lamar, COThe pilot's distraction due to an open canopy during final approach, which resulted in a loss of altitude and ground impact short of the runway.Nov 23, 2019 · N595SC · Substantial damageNTSB ERA20LA044Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E35 · Okeechobee, FLThe separation of the throttle control cable from the carburetor throttle control lever resulting in the near total loss of engine power. Contributing to the separation of the throttle cable was the lack of proper securing hardware by unknown maintenance…Nov 23, 2019 · N3315C · DestroyedNTSB CEN20CA033Accident · No injuriesData collectionFinal reportPiper PA18 · Kerrville, TXThe pilot’s loss of airplane control during the landing flare, which resulted in a loss of directional control and ground-loop.Nov 23, 2019 · N530AK · Substantial damageNTSB CEN20CA026Accident · No injuriesData collectionFinal reportBellanca 1730 · Clear Lake, MNThe pilot's focus inside the cockpit during the base turn and final approach, which led to a high sink rate developing and a subsequent hard landing short of the runway.Nov 23, 2019 · N28037 · Substantial damageNTSB CEN20FA019Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · San Marcos, TXThe pilot’s loss of control shortly after takeoff in instrument meteorological conditions for reasons that could not be determined based on the available information.Nov 20, 2019 · N88855 · DestroyedNTSB GAA20CA090Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Brogue, PAThe pilot's failure to see and avoid wires during approach to landing.Nov 19, 2019 · N71707 · Substantial damageNTSB ERA20LA038Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · College Park, MDThe pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.Nov 18, 2019 · N1031M · Substantial damageNTSB WPR20LA024Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Ogden, UTThe flight instructor’s failure to raise the landing gear using the alternate system, which resulted in a reduced climb rate and impact with an obstacle. Contributing to the accident was the flight instructor’s lack of understanding of the backup landing gear…Nov 17, 2019 · N3206R · Substantial damageNTSB GAA20CA089Accident · No injuriesData collectionFinal reportCessna 172 · DuBois, PAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…Nov 17, 2019 · N683SP · Substantial damageNTSB GAA20CA081Accident · No injuriesData collectionFinal reportStinson SR9 · West Jefferson, OHThe pilot's use of excessive braking during landing, which resulted in a nose-over.Nov 17, 2019 · N18416 · Substantial damageNTSB GAA20CA086Accident · No injuriesData collectionFinal reportCessna 152 · Sherman/Dennison, TXThe pilot's improper landing flare, which resulted in a bounced landing.Nov 16, 2019 · N4705Q · Substantial damageNTSB ERA20LA039Accident · No injuriesClass 3 · LimitedFinal reportRans Rans S7 Courier · West Liberty, KYThe pilot's failure to verify that the engine oil tank contained adequate oil for the cross-country flight, which resulted in a total loss of engine power as a result of lack of lubrication. Contributing to the accident was the incorrect oil consumption…Nov 15, 2019 · N831RS · Substantial damageNTSB GAA20CA087Accident · No injuriesData collectionFinal reportFisher FP 202 Koala · Erwin, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with vegetation.Nov 14, 2019 · N47CV · Substantial damageNTSB WPR20LA029Accident · No injuriesClass 3 · LimitedFinal reportAgusta A109 · Salt Lake City, UTThe flight nurse’s inadvertent application of left anti-torque pedal during cruise flight, which resulted in a rapid yaw and pitch movement that caused the tail rotor blades to contact the tailboom.Nov 13, 2019 · N271HC · Substantial damageNTSB WPR20LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Red Rock, AZA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s improper use of carburetor heat.Nov 13, 2019 · N704QJ · Substantial damageNTSB ERA20LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Toms River, NJThe failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…Nov 13, 2019 · N3958S · 2 aircraft · Substantial damageNTSB GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.Nov 12, 2019 · N3803S · Substantial damageNTSB GAA20CA071Accident · No injuriesData collectionFinal reportCessna 182 · San Luis, COThe pilot's improper pitch attitude during landing on rising terrain in flat light conditions, which resulted in a hard landing.Nov 12, 2019 · N91846 · Substantial damageNTSB GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.Nov 12, 2019 · N739UA · Substantial damageNTSB GAA20CA070Accident · No injuriesData collectionFinal reportCessna 195 · Kalispell, MTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the left main landing gear collapsing.Nov 11, 2019 · N195BG · Substantial damageNTSB DCA20LA013Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB145 · Chicago, ILThe flight crew’s inability to maintain the airplane on the runway centerline after touchdown due to the reduced braking action resulting from the deteriorating weather conditions, which caused the airplane’s departure from the runway surface. Contributing to…Nov 11, 2019 · N619AE · Substantial damageNTSB ANC20LA004Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Goodnews Bay, AKThe pilot’s failure to monitor the airplane instruments during a night visual flight rules departure in dark light conditions, which resulted in spatial disorientation and the airplane’s descent into water.Nov 11, 2019 · N7721C · Substantial damage