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 WPR21LA275Accident · No injuriesClass 4 · LimitedFinal reportCessna 180C · Ogden, UTThe pilot’s loss of directional control while taxiing at high speed, which resulted in a ground loop.Jul 4, 2021 · N9193T · Substantial damageNTSB WPR21LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Lander, WYThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence.Jul 4, 2021 · N7802K · Substantial damageNTSB CEN21FA305Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G36 · Aspen, COThe pilot’s failure to navigate through mountainous terrain, which resulted in controlled flight into terrain.Jul 4, 2021 · N36JJ · DestroyedNTSB CEN21FA304Accident · 1 fatalClass 3 · FieldFinal reportFocke-Wulf FWP-149D · Killeen, TXThe total loss of engine power due to a fatigue failure of a crankshaft counterweight mounting lobe, which resulted in a counterweight separation and catastrophic secondary damage to the engine drivetrain. Contributing to the accident was the mislabeled…Jul 4, 2021 · N9145 · DestroyedNTSB ANC21LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s improper flight control inputs which resulted in a loss of directional control and a nose-over.Jul 4, 2021 · N82547 · Substantial damageNTSB ANC21LA052Accident · Serious injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Palmer, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose-over.Jul 4, 2021 · N5213X · Substantial damageNTSB CEN21LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Pottsboro, TXThe airplane’s degraded performance from the rough, grass runway surface and the pilot’s delayed decision to abort the takeoff resulting in a runway excursion.Jul 3, 2021 · N181BW · Substantial damageNTSB ANC21LA051Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Hoonah, AKThe pilot’s failure to maintain directional control during landing.Jul 3, 2021 · N1199Q · Substantial damageNTSB ERA21LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 402A · Fort Lauderdale, FLThe pilot’s loss of directional control during takeoff with a fogged wind screen and sun glare, which resulted in a runway excursion and a collision with a taxiway sign.Jul 2, 2021 · N4550Q · Substantial damageNTSB DCA21FA174Accident · Serious injuriesClass 2 · FieldFinal reportBoeing 737-275C · Honolulu, HIThe flight crewmembers’ misidentification of the damaged engine (after leveling off the airplane and reducing thrust) and their use of only the damaged engine for thrust during the remainder of the flight, resulting in an unintentional descent and forced…Jul 2, 2021 · N810TA · DestroyedNTSB CEN21LA302Accident · Minor injuriesClass 3 · LimitedFinal reportPiper Aerostar 600A · Wichita, KSThe pilot’s improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 2, 2021 · N10HK · Substantial damageNTSB CEN21FA300Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-33 · Roff, OKThe pilot’s loss of airplane control due to spatial disorientation during low-level nighttime flight.Jul 2, 2021 · N302Z · DestroyedNTSB WPR21LA264Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Twin Falls, IDPartial loss of engine power during a low pass, due to carburetor icing and the pilot’s failure to use carburetor heat during the landing approach.Jul 1, 2021 · N9609H · Substantial damageNTSB WPR21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 172R · Missoula, MTThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.Jul 1, 2021 · N2388L · Substantial damageNTSB ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.Jul 1, 2021 · N561QL · Substantial damageNTSB CEN21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Tyler, TXThe pilot’s failure to maintain proper airspeed on approach resulting in an extended touchdown, bounced landing, and runway excursion.Jul 1, 2021 · N42084 · Substantial damageNTSB CEN21FA299Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Lamoni, IAThe pilot did not maintain aircraft control during an attempted go-around after a bounced landing, which resulted in impact with terrain and a postimpact fire.Jul 1, 2021 · N123RE · DestroyedNTSB ANC21LA056Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · North Pole, AKThe pilot’s exceedance of the airplane’s takeoff performance limitations, which prevented the airplane from gaining sufficient altitude to clear the trees off the departure end of the runway.Jul 1, 2021 · N2746D · DestroyedNTSB ANC21LA054Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s excessive use of brakes during landing, which resulted in a nose-over. Contributing to the accident was the flight instructor’s inadequate supervision and the gusty tailwind conditions.Jul 1, 2021 · N8996Y · Substantial damageNTSB WPR21LA255Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Terreton, IDThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.Jun 30, 2021 · N1972L · Substantial damageNTSB CEN21FA297Accident · 1 fatalClass 3 · FieldFinal reportEarthstar Gull 2000 · Curtiss, WIThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions with dense fog and low clouds, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot’s self-imposed…Jun 30, 2021 · N1712L · Substantial damageNTSB WPR21LA261Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · North Las Vegas, NVThe pilot’s inability to maintain directional control during landing roll due to a flat tire.Jun 29, 2021 · N764SU · Substantial damageNTSB WPR21LA257Accident · No injuriesClass 4 · LimitedFinal reportWheeler C / Wheeler K Lancair 235 · Borrego Springs, CAThe pilot’s failure to maintain airplane control during a crosswind landing which resulted in an impact with terrain.Jun 29, 2021 · N43KC · Substantial damageNTSB WPR21LA252Accident · No injuriesClass 4 · LimitedFinal reportSilverLight AR-1 · Lakeside, ORThe pilot’s inadequate decision to continue the takeoff after sufficient airspeed was not attained and his failure to maintain aircraft control while maneuvering to avoid obstructions, which resulted in a collision with the ground.Jun 29, 2021 · N159WT · Substantial damageNTSB ERA21LA275Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rome, NYThe pilot's improper termination of a practice autorotation with power recovery, which resulted in low rotor rpm, an unstable landing, and a rollover. Contributing to the accident was the evaluator's inadequate oversight.Jun 29, 2021 · N134VG · Substantial damageNTSB ERA21FA274Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · St. Augustine, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during the landing approach.Jun 29, 2021 · N25513 · DestroyedNTSB CEN21LA296Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Hoxie, ARThe pilot’s failure to ensure an adequate fuel supply for the intended flight.Jun 29, 2021 · N6611K · Substantial damageNTSB WPR21LA256Accident · No injuriesClass 4 · LimitedFinal reportMooney M20 · Nampa, IDThe pilot’s failure to use the landing checklist and to extend the landing gear, which resulted in a gear-up landing.Jun 28, 2021 · N381KH · Substantial damageNTSB ERA21LA273Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Woodland, TNThe student pilot’s inadequate monitoring of his fuel state during a solo training flight, which resulted in fuel starvation, a total loss of engine power, and a forced landing.Jun 28, 2021 · N818TF · Substantial damageNTSB ERA21LA272Accident · Minor injuriesClass 4 · LimitedFinal reportBell 47G-2A-1 · Brasstown, NCThe pilot’s inflight loss of control while conducting a hovering maneuver.Jun 28, 2021 · N147AH · Substantial damageNTSB ERA21LA271Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Bentleyville, PAThe flight instructor and student pilot’s inadequate preflight performance planning which resulted in a takeoff attempt with insufficient available runway, a loss of control, and impact with terrain.Jun 28, 2021 · N22307 · Substantial damageNTSB CEN21LA295Accident · Serious injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Ray, MIThe flight instructor’s improper decision to direct the student pilot to exit the airplane with the engine running, which resulted in serious injury when the student walked into the propeller arc.Jun 28, 2021 · N920SS · Minor damageNTSB CEN21LA294Accident · No injuriesClass 3 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Mio, MIThe pilot’s failure to abort the takeoff roll when the engine did not produce full power.Jun 28, 2021 · N963L · Substantial damageNTSB ANC21LA050Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Dillingham, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in a loss of control and impact with terrain.Jun 28, 2021 · N8216J · Substantial damageNTSB WPR21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20F · Marion, MTThe pilot’s improper rotation during takeoff from a high-altitude airport and his failure to abort the takeoff, which resulted in an impact with trees and terrain. Contributing to the accident was the pilot’s improper management of the turbocharger, which…Jun 27, 2021 · N9613M · Substantial damageNTSB WPR21FA243Accident · 1 fatalClass 3 · FieldFinal reportFeraca Edward M Searey LSX · Logan, UTThe pilot’s loss of airplane control while maneuvering at a low altitude, which resulted in a collision with a house.Jun 27, 2021 · N62EF · Substantial damageNTSB ERA21LA270Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Waxhaw, NCThe pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight.Jun 27, 2021 · N7078V · Substantial damageNTSB CEN21LA292Accident · Minor injuriesClass 4 · LimitedFinal reportCurnutt Elton E SKY Ranger B · Ellicott, COThe pilot’s loss of control while maneuvering at low altitude.Jun 27, 2021 · N7714E · Substantial damageNTSB WPR21LA248Accident · No injuriesClass 4 · LimitedFinal reportDewsnup Dave Zenair CH 701 SP · Chester, CAThe pilot’s failure to properly position of the fuel selector valve, which resulted in a loss of engine power during initial climb due to fuel starvation.Jun 26, 2021 · N41XY · Substantial damageNTSB WPR21LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Ririe, IDThe pilot’s encounter with a tailwind during takeoff roll, which resulted in an aborted takeoff, collision with a ditch and subsequent nose over.Jun 26, 2021 · N3208Y · Substantial damageNTSB WPR21FA242Accident · 5 fatalClass 3 · FieldFinal reportCameron Balloons US O-120 · Albuquerque, NMThe failure of the pilot to maintain adequate clearance from power lines while maneuvering for landing. Contributing to the accident was the pilot’s use of impairing, illicit drugs.Jun 26, 2021 · N158NM · DestroyedNTSB WPR21LA247Accident · No injuriesClass 4 · LimitedFinal reportShort Bros SD-360-300 · Las Vegas, NVThe pilot’s failure to extend the landing gear during landing and the check pilot’s inadequate supervision.Jun 25, 2021 · N970AA · Substantial damageNTSB ERA21LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Mount Pocono, PAThe pilot’s loss of aircraft control following a bounced landing.Jun 25, 2021 · N5185U · Substantial damageNTSB ERA21LA269Accident · 1 fatalClass 3 · LimitedFinal reportGarlick Helicopters OH-58A+ · Alpine, ALThe pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight, resulting in main rotor blade impact with a fiber-optic cable, a loss of control, and the helicopter’s subsequent impact with terrain.Jun 25, 2021 · N372NS · Substantial damageNTSB CEN21LA298Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Jennings, LAThe pilot’s failure to extend the landing gear before landing.Jun 25, 2021 · N9038N · Substantial damageNTSB CEN21LA293Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Porter, TXThe pilot’s decision to continue the takeoff with degraded engine performance, which resulted in an inability to climb and a subsequent forced landing. The reason for the engine’s degraded performance could not be determined based on available information.Jun 25, 2021 · N4216J · Substantial damageNTSB CEN21LA291Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Loveland, COThe flight instructor’s failure to maintain aircraft control during the landing flare and subsequent attempted go-around with a strong quartering crosswind.Jun 25, 2021 · N9277J · Substantial damageNTSB WPR21LA246Accident · No injuriesClass 4 · LimitedFinal reportAirborne Australia XT582 · Carson City, NVThe student pilot's failure to maintain directional control during landing in gusting wind, which resulted in a runway excursion and impact with terrain.Jun 24, 2021 · N8003K · Substantial damageNTSB CEN21LA312Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · St. Louis, MOThe pilot’s failure to maintain directional control during the landing roll with hydroplaning conditions.Jun 24, 2021 · N110ST · Substantial damageNTSB WPR21LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna T206 · Apple Valley, CAThe pilot's distraction due to adjusting the radio while taxing at night, which resulted in a taxiway excursion and subsequent impact with terrain.Jun 23, 2021 · N881HP · Substantial damage