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 ERA21FA225Accident · 2 fatalClass 3 · FieldFinal reportFlight Design Ctsw · Winterville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and a loss of control.May 22, 2021 · N708JM · DestroyedNTSB CEN21LA244Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 MK.I · Oak Island, MNThe failure of an O-ring in the landing gear system, which resulted in the inadvertent extension of the main wheel in the amphibious float. Contributing to the accident was the pilot’s decision to depart with a known hydraulic leak in the landing gear system.May 22, 2021 · N218RD · Minor damageNTSB CEN21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · McAllen, TXThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a runway sign.May 22, 2021 · N999MA · Substantial damageNTSB WPR21LA207Accident · No injuriesClass 4 · LimitedFinal reportCessna TU206 · Phoenix, AZThe pilot's failure to maintain directional control after an encounter with a windshear during the landing roll, which resulted in a runway excursion.May 21, 2021 · XBBLB · Substantial damageNTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.May 21, 2021 · N575BC · DestroyedNTSB DCA21LA133Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Chicago, ILthe failure of the flight crew of N8686A to provide sufficient clearance while taxiing past N289CT, which was stopped.May 21, 2021 · N289CT · 2 aircraft · Substantial damageNTSB ERA21LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPilatus B4-PC11 · Sterling, MAThe pilot’s misjudged approach angle which resulted in impact with trees and terrain.May 20, 2021 · N65317 · Substantial damageNTSB ERA21LA228Accident · Minor injuriesClass 4 · LimitedFinal reportRobert Trembly JA20 Highlander · Central City, KYThe pilot’s failure to properly secure the left wing fuel cap before flight, which resulted in a loss of engine power due to fuel exhaustion.May 20, 2021 · N743BT · Substantial damageNTSB ERA21LA222Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Dawson, GAMaintenance personnel’s failure to properly secure the No. 4 connecting rod bolt nut with a cotter pin, resulting in a total loss of engine power.May 20, 2021 · N9514R · Substantial damageNTSB CEN21LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Washington Court House, OHThe pilot's failure to maintain directional control during a soft field takeoff.May 20, 2021 · N15033 · Substantial damageNTSB ERA21LA268Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Bloomsburg, PAThe pilot’s unstable approach and delayed go-around attempt, which resulted in a porpoised landing, a nose landing gear collapse, and runway excursion.May 19, 2021 · N7568N · Substantial damageNTSB WPR21LA202Accident · No injuriesClass 4 · LimitedFinal reportGoodsell Lynn A Classic 4 · Richmond, UTThe pilot’s failure to maintain clearance from powerlines while maneuvering for landing, which resulted in a wire strike and impact with terrain.May 18, 2021 · N549Z · Substantial damageNTSB WPR21LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Minden, NVThe pilot’s failure to maintain airplane control while on approach in microburst or windshear conditions, which resulted in impact with a runway sign.May 18, 2021 · N8488M · Substantial damageNTSB WPR21LA199Accident · Minor injuriesClass 4 · LimitedFinal reportHarry Crosby RV-6 · Byron, CAThe pilot’s failure to maintain directional control of the airplane during takeoff while operating in gusting wind conditions, which resulted in a runway excursion and subsequent collision with terrain.May 18, 2021 · N16CX · Substantial damageNTSB CEN21LA225Accident · 1 fatalClass 3 · LimitedFinal reportBell OH58A · Ulysses, KSThe pilot’s failure to maintain clearance from a power line during the aerial application flight, which resulted in collision with the power line and subsequent impact with terrain.May 18, 2021 · N176SJ · DestroyedNTSB CEN21LA223Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-502A · Clayton, LAThe pilot’s loss of airplane control resulting in an aerodynamic stall while executing a steep turnaround during an aerial application flight.May 18, 2021 · N887LA · Substantial damageNTSB WPR21LA197Accident · No injuriesClass 4 · LimitedFinal reportStearman 4E · Porterville, CAThe pilot’s loss of directional control while landing, which resulted in a landing gear collapse.May 17, 2021 · N663K · Substantial damageNTSB CEN21LA228Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Pinecreek, MNThe pilot’s failure to maintain control of the airplane in gusting crosswind conditions.May 17, 2021 · N416RP · Substantial damageNTSB CEN21FA220Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · St. Louis, MIThe pilot’s failure to maintain adequate visual lookout to ensure clearance from the radio tower and its guy wires. Contributing to the accident was the pilot’s unnecessary use of his mobile device during the flight, which diminished his attention/monitoring…May 17, 2021 · N2430X · DestroyedNTSB WPR21LA198Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Paris, IDThe pilot's improper flare which resulted in a bounced landing, loss of directional control and collision with terrain.May 16, 2021 · N321PF · Substantial damageNTSB CEN21LA226Accident · Serious injuriesClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Hampshire, ILThe flight instructor’s failure to maintain aircraft control resulting in the exceedance of the glider’s critical angle of attack following the breakage of the weak/safety link during a winch launch, which resulted in an aerodynamic stall and spin, and…May 16, 2021 · N41CR · Substantial damageNTSB WPR21LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Las Vegas, NVThe flight instructor’s failure to compensate for a downdraft during takeoff, which resulted in a loss of control and collision with terrain.May 15, 2021 · N1996T · Substantial damageNTSB WPR21LA196Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Wallowa, ORThe pilots failure to maintain airplane control during the landing roll after experiencing a tailwind gust which required excessive braking and resulted in the airplane nosing over.May 15, 2021 · N101BC · Substantial damageNTSB ERA21LA223Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 XL · McKenzie, TNThe improper installation and inspection of the propeller, which resulted in an in-flight separation of the propeller assembly.May 15, 2021 · N493TG · Substantial damageNTSB ERA21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Brewton, ALThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with the ground.May 15, 2021 · N3396J · Substantial damageNTSB ERA21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Daytona Beach, FLBoth pilots’ failure to maintain control during the landing flare and the flight instructor’s failure to maintain control during an attempted go-around, in gusting quartering headwind conditions, which resulted in the exceedance of the airplane’s critical…May 14, 2021 · N62568 · Substantial damageNTSB ERA21LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gulf Shores, ALThe flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.May 13, 2021 · N5170K · Substantial damageNTSB CEN21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B24R · New Lenox, ILThe total loss of engine power due to fuel contamination as a result of the pilot’s improper fueling of the airplane.May 13, 2021 · N9199S · Substantial damageNTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…May 13, 2021 · N8051B · Substantial damageNTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.May 13, 2021 · N154T · Substantial damageNTSB WPR21LA221Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Truckee, CAThe pilot’s improper flare during a landing attempt in crosswind conditions, which resulted in a bounced landing and impact with the ground.May 12, 2021 · N2010P · Substantial damageNTSB WPR21LA200Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164C · Glenn, CAThe pilot’s fuel mismanagement, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.May 12, 2021 · N6596K · Substantial damageNTSB WPR21LA195Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Hillsboro, ORThe pilot’s delayed remediation following an aborted takeoff run, which resulted in a runway overrun and collision with trees.May 12, 2021 · N51LL · Substantial damageNTSB ERA21LA255Accident · No injuriesClass 4 · LimitedFinal reportPage Joseph E Vans RV-4 · Martinsburg, WVThe pilot’s improper landing flare in variable crosswind conditions, which resulted in a hard landing.May 12, 2021 · N54RV · Substantial damageNTSB ERA21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Johnson City, TNThe student pilot’s excessive airspeed during the landing approach and his delayed remedial action, which resulted in the airplane striking obstacles during an aborted landing. Contributing was the pilot’s decision to land with a tailwind.May 12, 2021 · N6344E · Substantial damageNTSB CEN21LA227Accident · No injuriesClass 4 · LimitedFinal reportVarner David L Vans RV-8 · Watkins, COThe pilot’s failure to maintain control of the airplane during landing.May 12, 2021 · N51LV · Substantial damageNTSB CEN21LA217Accident · No injuriesClass 4 · LimitedFinal reportSmith Miniplane DSA-1 · Fulton, MOThe pilot’s failure to maintain control of the airplane during landing in gusty crosswinds.May 12, 2021 · N179VP · Substantial damageNTSB CEN21LA216Accident · No injuriesClass 3 · LimitedFinal reportAerospatiale AS350 B2 Ecureuil · Yukon, OKThe pilot receiving instruction’s untimely and unidentified inadvertent activation of the hydraulic cut-off switch, which turned off the hydraulic system while the helicopter was at slow airspeed followed by a rapid power increase, which resulted in a loss of…May 12, 2021 · N841BP · DestroyedNTSB CEN21FA215Accident · No injuriesClass 3 · FieldFinal reportSwearingen SA226TC · Englewood, COThe Cirrus pilot’s failure to maintain the final approach course for the assigned runway, which resulted in a collision with the Swearingen which was on final approach to the parallel runway. Contributing to the accident was the failure of the controller to…May 12, 2021 · N280KL · 2 aircraft · Substantial damageNTSB ANC21LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Kenai, AKThe pilot's excessive application of the airplane’s wheel brakes while landing, which resulted in a nose over.May 12, 2021 · N92793 · Substantial damageNTSB WPR21LA193Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172R · Chandler, AZThe pilot’s failure to locate the airport which resulted in an approach to a road and subsequent collision with powerlines during a go-around in low light conditions.May 11, 2021 · N47AF · Substantial damageNTSB WPR21LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Coeur d' Alene, IDThe student pilot’s failure to maintain directional control during the landing roll, and the flight instructors delayed remedial action which resulted in a runway excursion and collision with terrain.May 11, 2021 · N7296K · Substantial damageNTSB WPR21LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Palm Springs, CAThe Kingair pilot’s failure to maintain clearance from another airplane while taxiing, which resulted in a ground collision.May 10, 2021 · N206DT · 2 aircraft · Substantial damageNTSB ERA21LA220Accident · No injuriesClass 4 · LimitedFinal reportDouglas K Thompson Justaircraft Superst · Brunswick, METhe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of directional control during the approach and landing.May 10, 2021 · N184DT · Substantial damageNTSB CEN21LA212Accident · No injuriesClass 4 · LimitedFinal reportRichards Heavylift Helo UH-1H · Norris City, ILThe pilot’s improper positioning of the helicopter on the landing pad, and his failure to monitor and control the helicopter as fuel and chemical product were loaded, which led to the helicopter tipping and sliding off the landing pad, and subsequently…May 10, 2021 · N567VF · Substantial damageNTSB ANC21LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Gakona, AKThe pilot’s decision to initiate a flight with a failed mixture control cable which resulted in a total loss of engine power.May 10, 2021 · N5489H · Substantial damageNTSB WPR21LA187Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Sacramento, CAThe pilot’s failure to maintain directional control during landing in gusty wind conditions which resulted in a runway excursion and collision with terrain.May 9, 2021 · N104GX · Substantial damageNTSB WPR21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · San Bernardino, CAThe pilot’s improper landing flare, which resulted in a hard landing and his subsequent inadequate pitch and airplane control during a go around which resulted in a nose landing gear collapse.May 8, 2021 · N54PW · Substantial damageNTSB WPR21LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Tucson, AZThe student pilot’s improper pitch control and landing flare, which resulted in a hard bounce and subsequent porpoised landing.May 8, 2021 · N54140 · Substantial damageNTSB WPR21LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Arlington, WAThe pilot’s failure to maintain directional control during landing, with a crosswind, which resulted in a runway excursion and subsequent impact with terrain.May 7, 2021 · N31B · Substantial damage