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 WPR22LA330Accident · Minor injuriesClass 3 · LimitedFinal reportSikorsky S-61N · Shady Cove, ORA total loss of engine power due to the failure of the No. 2 engine’s stage 1 turbine blades as a result of an unreported hot start two days earlier.Sep 1, 2022 · N617CK · Substantial damageNTSB ERA22LA400Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Marysville, OHThe pilot’s failure to maintain directional control during landing.Sep 1, 2022 · N85748 · Substantial damageNTSB ERA22LA395Accident · 1 fatalClass 3 · LimitedFinal reportDiamond Aircraft Industries DA 42 · Orlando, FLThe flight crew’s insufficient evaluation of the deteriorating weather conditions in the area, which resulted in an encounter with a microburst.Sep 1, 2022 · N43RG · Substantial damageNTSB CEN22FA405Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Tomball, TXThe flight instructor’s inadequate supervision of the flight, which allowed for an unintentional movement of the mixture control to the cutoff position that remained unnoticed until the airplane lost engine power due to fuel starvation and descended below the…Sep 1, 2022 · N420SS · Substantial damageNTSB ANC22LA072Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Point MacKenzie, AKThe pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.Sep 1, 2022 · N9622V · Substantial damageNTSB ERA22LA396Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion · Newburyport, MAThe pilot’s excessive application of brakes while landing, which resulted in a nose gear collapse.Aug 31, 2022 · N4913K · Substantial damageNTSB ERA22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportSutphin John E Rans S-12 · Hilliard, FLThe pilot’s failure to maintain an adequate airspeed, which resulted in an aerodynamic stall.Aug 31, 2022 · N8028W · Substantial damageNTSB CEN22LA409Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Eden Prairie, MNThe student pilot's failure to maintain directional control of the airplane during the takeoff phase of a touch and go landing.Aug 31, 2022 · N6628J · Substantial damageNTSB ERA22LA392Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172N · Gates Mills, OHThe instructor pilot’s decision to perform an inflight magneto check with no suitable area to land. Contributing to the accident was the pilot's failure to correctly perform a magneto check that resulted in a total loss of engine power.Aug 30, 2022 · N204BE · Substantial damageNTSB CEN22LA404Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Beardsley, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with terrain.Aug 30, 2022 · N7048C · Substantial damageNTSB CEN22LA402Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopters 369E · Pearland, TXThe pilot receiving instruction’s failure to maintain aircraft control, and the flight instructor’s delayed remedial action, which resulted in a hard landing.Aug 30, 2022 · N1576F · Substantial damageNTSB ANC22LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Palmer, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and impact with terrain.Aug 30, 2022 · N1129 · Substantial damageNTSB WPR22LA321Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Twin Bridges, MTThe student pilot’s failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action.Aug 29, 2022 · N3268B · Substantial damageNTSB ERA22LA393Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Bennington, VTThe pilot’s failure to maintain airspeed during a go-around, resulting in an aerodynamic stall, loss of control, and collision with terrain.Aug 29, 2022 · N3768T · Substantial damageNTSB ERA22FA391Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7AC · Jacksboro, TNThe pilot's exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control.Aug 29, 2022 · N1478E · DestroyedNTSB ERA22LA390Accident · No injuriesClass 4 · LimitedFinal reportBell Textron Canada 505 · Chamblee, GAThe pilot’s failure to ensure that the helicopter was properly positioned over a dolly before attempting to land on it, which resulted in a rollover.Aug 28, 2022 · N6SD · Substantial damageNTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…Aug 28, 2022 · N505DB · Substantial damageNTSB ERA22FA386Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · French Lick, INThe pilot’s failure to make a stabilized approach, which resulted in a loss of directional control during landing.Aug 28, 2022 · N8741A · DestroyedNTSB WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.Aug 27, 2022 · N305SU · Substantial damageNTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.Aug 27, 2022 · N628LE · Substantial damageNTSB CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.Aug 27, 2022 · N132JD · Substantial damageNTSB WPR22LA329Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Clipper 1 · Deadhorse, AKThe pilot's failure to maintain helicopter control during a descent, which resulted in a collision with terrain.Aug 26, 2022 · N240RM · Substantial damageNTSB WPR22LA320Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Ione, CAThe flight instructor’s delayed decision to abort the takeoff, which resulted in impact with a fence and a tree. Contributing to the accident was the instructor’s decision to land at the unfamiliar airstrip without determining whether it was within the…Aug 26, 2022 · N49430 · Substantial damageNTSB ERA22LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · Georgetown, DEThe pilot's failure to extend the landing gear before landing. Contributing to the accident was an inoperative landing gear warning horn.Aug 25, 2022 · N5132C · Substantial damageNTSB ERA22LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kissimmee, FLThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nose landing gear impacting the runway.Aug 25, 2022 · N9968F · Substantial damageNTSB CEN22LA408Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Murray, NEThe pilot’s failure to maintain airplane control during landing resulting in an impact with crop and a subsequent ground-loop. Contributing was the wet turf airstrip.Aug 25, 2022 · N5951B · Substantial damageNTSB ERA22FA384Accident · 2 fatalClass 3 · FieldFinal reportMXR Technologies MX2 · Osteen, FLThe pilot’s loss of airplane control while performing aerobatic maneuvers, which resulted in the airplane entering an inverted flat spin that continued until the airplane impacted terrain.Aug 24, 2022 · N263MX · Substantial damageNTSB CEN22LA411Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Atoka, OKThe pilot's failure to land the airplane within the desired touchdown zone, which resulted in a long landing and collision with a fence.Aug 24, 2022 · N2317G · Substantial damageNTSB CEN22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Liberty, MOThe flight instructor’s improper decision to take off without adequate airspeed which resulted in degraded performance and a collision with trees.Aug 24, 2022 · N1815J · Substantial damageNTSB WPR22LA326Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Egegik, AKThe pilot's failure to maintain directional control during takeoff from a lake.Aug 23, 2022 · N6455X · Substantial damageNTSB WPR22LA324Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBA · Athol, IDThe failure of the right brake due to a disconnected master cylinder piston rod, which led to the departure of the airplane from the runway surface. Contributing to the accident was the mechanic’s failure to adequately inspect the connection between the…Aug 23, 2022 · N9512S · Substantial damageNTSB ERA22FA383Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Whiteside, TNThe pilot’s failure to maintain clearance from the powerlines.Aug 23, 2022 · N770HP · Substantial damageNTSB CEN22LA444Accident · No injuriesClass 4 · LimitedFinal reportRockwell International 112A · Lee's Summit, MOThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapse.Aug 23, 2022 · N1462J · Substantial damageNTSB WPR22LA325Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Hope, AKThe pilot’s failure to maintain clearance from a tree while taxiing.Aug 22, 2022 · N96095 · Substantial damageNTSB WPR22LA314Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Wilder, IDCatastrophic engine failure during the initial climb due to an incorrectly installed crankshaft counterweight retaining ring.Aug 21, 2022 · N4133S · Substantial damageNTSB WPR22FA312Accident · 2 fatalClass 3 · FieldFinal reportJackson Dennis RV-8 · Scio, ORThe pilot’s decision to perform a low-altitude aerobatic maneuver and his improper execution of the maneuver, which resulted in impact with terrain.Aug 21, 2022 · N184DJ · Substantial damageNTSB ERA22LA382Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7AC · Clermont, FLThe pilot’s inability to maintain directional control while landing due to a worn tailwheel locking mechanism, which resulted in a runway excursion and collision with terrain.Aug 21, 2022 · N44FC · Substantial damageNTSB CEN22LA400Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · San Isidro, TXThe pilot’s improper decision to conduct an autorotation with a tailwind, which resulted in a hard landing and substantial damage.Aug 21, 2022 · N4447A · Substantial damageNTSB WPR22LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Donnelly, IDThe pilot’s improper decision to takeoff from a wet grass runway which did not allow for adequate braking traction when the pilot aborted the takeoff, which resulted in a runway excursion.Aug 20, 2022 · N735DU · Substantial damageNTSB WPR22FA311Accident · 1 fatalClass 3 · FieldFinal reportSmyth Sidewinder TD · Wichita Falls, TXThe pilot’s inexperience with the airplane and inadequate takeoff procedures, which led to exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Aug 20, 2022 · N60JV · Substantial damageNTSB ERA22LA379Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Bealeton, VAThe pilot of the departing airplane’s failure to see and avoid the landing airplane before takeoff, resulting in a collision with the landing airplane. Contributing was the airport’s failure to encourage pilots to use radios for traffic deconfliction when…Aug 20, 2022 · N55267 · 2 aircraft · Substantial damageNTSB WPR22LA328Accident · No injuriesClass 4 · LimitedFinal reportFall Martin Super CUB · Stanley, IDThe pilot’s failure to maintain airplane control during takeoff with a crosswind.Aug 19, 2022 · N25MF · Substantial damageNTSB ERA22LA408Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Hollywood, MDThe pilot's failure to extend the landing gear before landing.Aug 19, 2022 · N7154U · Substantial damageNTSB ERA22LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Orlando, FLThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 19, 2022 · N6241A · Substantial damageNTSB ERA22LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Marathon, FLA total loss of power for undetermined reasons.Aug 19, 2022 · N587FL · Substantial damageNTSB DCA22LA188Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Pharisburg, OHThe airplane’s inadvertent encounter with convective turbulence.Aug 19, 2022 · N73270 · No damageNTSB CEN22LA435Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Grand Glaize, MOThe pilot’s improper landing flare which resulted in a bounced landing.Aug 19, 2022 · N711DM · Substantial damageNTSB WPR22LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Avalon, CAThe pilot’s failure to extend the landing gear before landing, resulting in a gear up landing and substantial damage to the airplane’s belly.Aug 18, 2022 · N52946 · Substantial damageNTSB WPR22LA310Accident · Serious injuriesClass 3 · LimitedFinal reportStucker Gary Banty · Camarillo, CAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Aug 18, 2022 · N995GS · Substantial damageNTSB WPR22LA308Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 195 · El Cajon, CAThe pilot’s failure to verify the fuel quantity prior to departure, which led to a loss of engine power due to fuel exhaustion.Aug 18, 2022 · N1097D · Substantial damage