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 CEN20CA231Accident · Serious injuriesClass 4 · Data collectionFinal reportDestiny XLT · Frankfort, OHThe pilot's inadequate preflight inspection of the powered parachute, which resulted in his takeoff with twisted riser lines and impaired aircraft control.Jun 16, 2020 · UNREG · Minor damageNTSB CEN20CA230Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R22 · El Campo, TXThe pilot's failure to maintain adequate clearance from the rice vegetation, which resulted in the helicopter's impact with terrain.Jun 16, 2020 · N797SH · Substantial damageNTSB WPR20CA183Accident · No injuriesClass 4 · Data collectionFinal reportCessna 310 · Butte, MTThe pilot's failure to maintain clearance from a fence post during final approach which resulted in a damage to the left main landing gear, and its subsequent collapse during landing.Jun 15, 2020 · N87395 · Substantial damageNTSB ERA20LA230Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Williston, FLThe pilot’s failure to maintain directional control while landing with a crosswind, which resulted in a runway excursion and nose landing gear collapse.Jun 15, 2020 · N117PR · Substantial damageNTSB ANC20LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Fairbanks, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive carburetor to icing, which resulted in a total loss of engine power.Jun 15, 2020 · N3186D · Substantial damageNTSB WPR20CA188Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 177RG · Lynden, WAThe pilot's failure to maintain control of the airplane during the landing approach, which resulted in the airplane exceeding its critical angle of attack, an aerodynamic stall, hard landing, and a landing gear collapse.Jun 14, 2020 · N1958Q · Substantial damageNTSB ERA20CA215Accident · No injuriesClass 4 · Data collectionFinal reportPipistrel Pipistrel Sinus 912 · Brookline, NHThe pilot's failure to maintain airspeed while landing with a quartering tailwind, which resulted in a loss of control and a hard landing.Jun 13, 2020 · N783TH · Substantial damageNTSB ERA20CA214Accident · No injuriesClass 4 · Data collectionFinal reportWaco YMF F5C · Ghent, NYA loss of directional control on takeoff, which resulted in a runway excursion and collision with trees.Jun 13, 2020 · N323TX · Substantial damageNTSB CEN20LA228Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 24 · Livingston, TXThe total loss of engine power due to the failure of the No. 3 cylinder for reasons that could not be determined based on available evidence.Jun 13, 2020 · N444JR · Substantial damageNTSB CEN20LA227Accident · 1 fatalClass 2 · LimitedFinal reportVans RV8 · Mandan, NDThe pilot's failure to remove the seat belt used as a flight control lock from the aft cockpit control stick before takeoff, which resulted in a loss of control during takeoff and collision with terrain.Jun 13, 2020 · N836JC · DestroyedNTSB WPR20LA180Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Renton, WAMaintenance personnel’s inadequate post-maintenance inspections that resulted in the total loss of engine power due to a blockage in the air intake.Jun 12, 2020 · N36339 · Substantial damageNTSB WPR20CA179Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Lenore, IDThe pilot's failure to maintain clearance from power lines while maneuvering during an aerial application flight, which resulted in a wire strike.Jun 12, 2020 · N40226 · DestroyedNTSB ERA20LA213Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Hampton, GAThe pilot’s excessive maneuvering at low altitude following a partial loss of engine power which resulted in an aerodynamic stall and collision with terrain.Jun 12, 2020 · N553KM · Substantial damageNTSB CEN20CA257Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Reedsburg, WIThe student pilot's improper landing flare, which resulted a hard, bounced landing.Jun 12, 2020 · N738VY · Substantial damageNTSB CEN20CA241Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Bowling Green, MOThe pilot's improper flare, which resulted in a hard, bounced landing.Jun 12, 2020 · N65773 · Substantial damageNTSB CEN20CA229Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna T188 · McCurtain, OKThe pilot's failure to maintain the proper airspeed during a low altitude aerial application maneuver and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodymanic stall at too low of an altiutde to recover.Jun 12, 2020 · N2085J · Substantial damageNTSB WPR20LA177Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH601 · Maricopa, AZThe pilot’s loss of situational awareness and descent below pattern altitude during the landing approach, which resulted in collision with terrain at night.Jun 10, 2020 · N6402X · DestroyedNTSB ERA20LA212Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA32RT · Selma, ALThe mechanic’s failure to clean the oil suction screen during the most recent maintenance, which resulted in oil starvation and subsequent total loss of engine power.Jun 10, 2020 · N543GS · DestroyedNTSB WPR20CA178Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Santa Barbara, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a fence.Jun 9, 2020 · N75989 · Substantial damageNTSB CEN20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Aitkin, MNThe flight instructor's delayed remedial action, which resulted in a hard landing and loss of directional control while landing with a crosswind.Jun 9, 2020 · N2681D · Substantial damageNTSB WPR20CA209Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Lubbock, TXThe pilot's improper approach and descent rate, which resulted in a hard landing.Jun 8, 2020 · N92356 · Substantial damageNTSB ERA20CA210Accident · No injuriesClass 4 · Data collectionFinal reportGreat Lakes 2T 1A · St. Mary's, PAThe pilot's failure to maintain proper glide path during final approach which resulted in a collision with airport equipment short of the runway.Jun 8, 2020 · N863K · Substantial damageNTSB CEN20LA219Accident · 1 fatalClass 3 · LimitedFinal reportFlight Design Ctls · Beecher, ILThe pilot’s decision to continue takeoff after a partial loss of engine power, and the pilot’s subsequent failure to control airplane pitch during a forced landing. Contributing to the accident was the partial loss of engine power for reasons that could not…Jun 8, 2020 · N257V · DestroyedNTSB CEN20CA222Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 15 · Lancaster, TXThe pilot's failure to maintain directional control during landing.Jun 8, 2020 · N4123H · Substantial damageNTSB CEN20CA221Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Hiawatha, KSThe pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.Jun 8, 2020 · N5092J · Substantial damageNTSB WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…Jun 7, 2020 · N595KF · Substantial damageNTSB ERA20CA243Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Greenwood, SCThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the parked airplane's position over the double-yellow taxiway edge lines and into the taxiway object-free movement area.Jun 7, 2020 · N6958J · Substantial damageNTSB ERA20CA209Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA38 · Cumberland, MDThe pilot's failure to maintain directional control during landing and the subsequent go-around in gusting crosswind conditions.Jun 7, 2020 · N2470D · Substantial damageNTSB CEN20LA216Accident · No injuriesClass 3 · LimitedFinal reportTeam 1600R · Marshall, MIMaintenance personnel’s improper installation of an improperly sized clamp on the fuel supply line, which allowed air to enter the supply line, a subsequent loss of engine power, and a forced landing.Jun 7, 2020 · N827WS · Substantial damageNTSB CEN20CA226Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 17 30 · Talihina, OKThe pilot's failure to maintain control of the airplane during a crosswind landing, which resulted in a hard landing and runway excursion.Jun 7, 2020 · N6681V · Substantial damageNTSB CEN20CA217Accident · Minor injuriesClass 4 · Data collectionFinal reportAirborne XT912 · Bristol, WIThe pilot's incorrect flight control input during the landing flare, which resulted in an impact with the ground.Jun 7, 2020 · N88ZT · Substantial damageNTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.Jun 6, 2020 · N13520 · DestroyedNTSB ANC20CA058Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Palmer, AKThe pilot’s improper decision to load the airplane beyond its allowable gross weight limits, which resulted in an impact with a tree and collision with terrain.Jun 6, 2020 · N3824M · Substantial damageNTSB WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.Jun 5, 2020 · N9217B · Substantial damageNTSB WPR20CA181Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20J · Healdsburg, CAThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a landing gear collapse.Jun 5, 2020 · N201JK · Substantial damageNTSB ERA20LA207Accident · 2 fatalClass 3 · LimitedFinal reportQuad City Challenger · Wurtsboro, NYA loss of control after takeoff due to the pilot’s improper use of ballast weight. Contributing was the pilot’s decision to operate the airplane above its maximum gross weight.Jun 5, 2020 · N850RW · Substantial damageNTSB ERA20LA206Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA 31T · Eatonton, GAThe pilot’s failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, which placed the airplane in an unusual attitude from which the pilot could not recover. Contributing to the accident was the convective and…Jun 5, 2020 · N135VE · DestroyedNTSB WPR20CA171Accident · Minor injuriesClass 4 · Data collectionFinal reportEnstrom 480 · Murphy, IDThe pilot's failure to maintain clearance from a power line while maneuvering during an aerial application flight.Jun 4, 2020 · N130JS · Substantial damageNTSB WPR20CA168Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Yakima, WAThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in a ground loop, runway excursion, and subsequent nose over.Jun 4, 2020 · N87607 · Substantial damageNTSB CEN20CA242Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Castroville, TXThe pilot's failure to maintain directional control during landing.Jun 4, 2020 · N88688 · Substantial damageNTSB CEN20CA218Accident · No injuriesClass 4 · Data collectionFinal reportGlasflugel Mosquito · Alvarado, TXThe pilot's decision to divert to the private airport and his subsequent failure to maintain directional control while landing on a turf runway that contained tall grass.Jun 4, 2020 · N24HC · Substantial damageNTSB CEN20CA213Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18 · Cadillac, MIThe pilot’s failure to maintain control of the float-equipped airplane after the float became caught on the trailer used for takeoff.Jun 4, 2020 · N68EE · Substantial damageNTSB CEN20CA212Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Corpus Cristi, TXThe pilot's failure to utilze the emergency landing gear extension procedure after a short-circuit within the normal landing gear system, which resulted in a landing gear collapse during landing.Jun 4, 2020 · N533K · Substantial damageNTSB WPR20LA165Accident · No injuriesClass 3 · LimitedFinal reportOmf 100 · Glendale, AZMaintenance personnel’s failure to comply with the procedures of an airworthiness directive, which resulted in a fatigue failure of the longitudinal frame tube during landing and collapse of the right main landing gear.Jun 3, 2020 · N225CK · Substantial damageNTSB WPR20CA199Accident · No injuriesClass 4 · Data collectionFinal reportBeech D 45 · Ione, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and impact with terrain.Jun 3, 2020 · N341MR · Substantial damageNTSB WPR20CA167Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Las Vegas, NVThe student pilot's failure to maintain directional control of the airplane during a soft-field takeoff and the flight instructor's delayed remedial action.Jun 3, 2020 · N478ER · Substantial damageNTSB WPR20CA166Accident · No injuriesClass 4 · Data collectionFinal reportAviat A 1 · Glendive, MTThe pilot's failure to maintain airplane control during landing in gusting wind condition which resulted in a collision with terrain.Jun 3, 2020 · N8QT · Substantial damageNTSB WPR20CA164Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Sandia, TXThe pilot's failure to maintain airplane control during takeoff from a soft airstrip that resulted in a collision with objects.Jun 3, 2020 · N3107R · Substantial damageNTSB ERA20CA204Accident · Minor injuriesClass 4 · Data collectionFinal reportSonex Sonex · New Smyrna Beach, FLThe pilot failed to maintain an adequate airspeed while on final approach and impacted terrain.Jun 3, 2020 · N187PB · Substantial damageNTSB CEN20LA207Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Duluth, MNThe pilot’s failure to remove an object from the airplane’s exterior, which impacted the propeller blades when he applied full power, causing them to fracture and damage the airplane.Jun 3, 2020 · N838BA · Substantial damage