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 WPR22LA041Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmington, NMThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.Nov 17, 2021 · N9467J · Substantial damageNTSB WPR22LA036Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Mackay, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in the airplane veering into a ditch and nosing over.Nov 17, 2021 · N2YQ · Substantial damageNTSB WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.Nov 15, 2021 · N3463C · Substantial damageNTSB ERA22LA064Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · Tampa, FLThe total loss of engine power due to the failure of maintenance personnel to properly tighten the fuel supply line b-nut at the manifold valve during installation.Nov 15, 2021 · N21890 · Substantial damageNTSB CEN22LA040Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 23 · Abilene, TXThe flight instructor’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the missing placard showing the usable fuel quantity.Nov 15, 2021 · N8701M · Substantial damageNTSB CEN22FA032Accident · 2 fatalClass 3 · FieldFinal reportBeech E-90 · Boyne City, MIThe pilot’s failure to maintain sufficient airspeed and his exceedance of the airplane’s critical angle of attack while in icing conditions, which resulted in an aerodynamic stall and subsequent ground impact.Nov 15, 2021 · N290KA · DestroyedNTSB WPR22LA039Accident · No injuriesClass 3 · LimitedFinal reportIai 1125 Westwind Astra · North Las Vegas, NVThe pilot landed long and failed to deploy the thrust reversers, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s decision to operate the airplane as a single pilot instead of the required minimum crew…Nov 14, 2021 · N771DX · Substantial damageNTSB ERA22LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Palm Coast, FLThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, resulting in a hard landing and substantial damage to the lower fuselage and firewall.Nov 14, 2021 · N61237 · Substantial damageNTSB ERA22LA060Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Wilkes-Barre, PAThe pilot’s decision to commence the flight in marginal visual flight rules conditions at night, and his failure to maintain a safe altitude once instrument conditions were encountered.Nov 14, 2021 · N6714S · Substantial damageNTSB ERA22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Burnsville, NCThe pilot’s failure to compensate for the high density altitude and the tailwind component while landing at a mountaintop airport, which resulted in an aerodynamic stall and a loss of aircraft control.Nov 14, 2021 · N633CD · Substantial damageNTSB ERA22LA063Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Denver, NCThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.Nov 13, 2021 · N3063E · Substantial damageNTSB ERA22LA062Accident · Serious injuriesClass 4 · LimitedFinal reportMaxair Drifter · Sebring, FLThe non-certificated pilot’s decision to operate the airplane without flight training or a pilot certificate and his loss of control shortly after takeoff, which resulted in an aerodynamic stall at low altitude and collision with terrain.Nov 13, 2021 · UNREG · Substantial damageNTSB CEN22FA031Accident · 4 fatalClass 3 · FieldFinal reportBritten-Norman BN-2A · Beaver Island, MIThe pilot's exceedance of the airplane's critical angle of attack during final approach, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Nov 13, 2021 · N866JA · Substantial damageNTSB WPR22FA033Accident · 2 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Randsburg, CAThe pilot’s improper landing approach, which failed to account for wind conditions, and his exceedance of the airplane’s critical angle of attack following an overshoot of the runway extended centerline, resulting in an accelerated aerodynamic stall.…Nov 12, 2021 · N984LD · DestroyedNTSB ERA22LA066Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · St. Petersburg, FLThe pilot’s inadvertent selection of an off fuel selector position, which resulted in a total loss of engine power due to fuel starvation.Nov 12, 2021 · N5862W · Substantial damageNTSB ERA22LA061Accident · No injuriesClass 4 · LimitedFinal reportEric A Munzer Dornier D027-B2 · Martinsville, VAThe pilot’s failure to maintain directional control during landing rollout, which resulted in a runway excursion and an impact with a ditch.Nov 12, 2021 · N27TQ · Substantial damageNTSB ERA22FA058Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Branchville, NJThe flight instructor’s failure to recover from a steep spiral turn during an instructional flight.Nov 11, 2021 · N90559 · DestroyedNTSB CEN22LA034Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Fort Davis, TXThe pilot’s encounter of a downdraft from which there was insufficient altitude to recover.Nov 10, 2021 · N3027W · Substantial damageNTSB CEN22LA033Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Freer, TXThe pilot’s encounter with ‘settling with power’ while maneuvering at a low altitude, which resulted in a rapid descent and subsequent hard landing.Nov 10, 2021 · N7198A · Substantial damageNTSB WPR22LA032Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Holtville, CAThe pilot’s failure to maintain helicopter control after becoming spatially disoriented when the helicopter entered low-level haze/fog.Nov 9, 2021 · N902SF · Substantial damageNTSB ANC22LA006Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC-18-180 · Yukon Charlie River, AKThe pilot’s selection of an unsuitable landing site, which resulted in a nose-over.Nov 9, 2021 · N413CC · Substantial damageNTSB WPR22LA028Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4 · Redding, CAThe pilot’s improper landing flare which resulted in a hard landing and subsequent ground loop.Nov 8, 2021 · N360WM · Substantial damageNTSB ERA22FA050Accident · 1 fatalClass 3 · FieldFinal reportMooney M20F · Villa Rica, GAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin.Nov 8, 2021 · N3284F · Substantial damageNTSB CEN22LA056Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Madison, MSThe student pilot’s failure to maintain aircraft control following a bounced landing.Nov 8, 2021 · N5321A · Substantial damageNTSB ERA22LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna/Air Repair 305F · Anne Arundel, MDThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and substantial damage.Nov 7, 2021 · N619JB · Substantial damageNTSB ERA22LA052Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Ridgeway, VAThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.Nov 7, 2021 · N51127 · Substantial damageNTSB CEN22LA030Accident · No injuriesClass 4 · LimitedFinal reportRaytheon G36 · Frankenmuth, MIThe pilot’s failure to maintain directional control while landing on a wet grass strip.Nov 7, 2021 · N754HC · Substantial damageNTSB ANC22FA005Accident · 1 fatalClass 3 · FieldFinal reportGerald Jones 2+2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Nov 7, 2021 · N540AK · Substantial damageNTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.Nov 5, 2021 · N8924Y · Substantial damageNTSB CEN22FA029Accident · 1 fatalClass 3 · FieldFinal reportVans RV · Harrison, MIThe pilot’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during landing approach, which resulted in an aerodynamic stall.Nov 5, 2021 · N16TG · DestroyedNTSB WPR22LA029Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Challis, IDThe pilot’s loss of directional control after the airplane encountered a gust of wind during the landing roll.Nov 4, 2021 · N727SS · Substantial damageNTSB WPR22LA027Accident · No injuriesClass 4 · LimitedFinal reportSanta Fe CCX-2300 · Taos, NMThe pilot’s failure to maintain directional control during a landing roll, which resulted in a ground loop and impact with the ground.Nov 4, 2021 · N24PK · Substantial damageNTSB ERA22LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ringwood, NJA loss of engine power in flight due to fuel exhaustion as a result of the pilot’s failure to secure the left wing’s fuel cap.Nov 4, 2021 · N423LL · Substantial damageNTSB ERA22LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Margarettsville, NCThe pilot’s delayed application of carburetor heat during the descent, which resulted in a total loss of engine power due to carburetor icing.Nov 4, 2021 · N704HQ · Substantial damageNTSB WPR22FA026Accident · 1 fatalClass 3 · FieldFinal reportAyres S-2R · Shafter, CAThe pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.Nov 3, 2021 · N8960Q · Substantial damageNTSB WPR22LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna R172K · Rexburg, IDA total loss of engine power for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical issue.Oct 31, 2021 · N1082V · Substantial damageNTSB ERA22LA043Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-236 · Orleans, MAThe pilot’s spatial disorientation and subsequent loss of airplane control while maneuvering over water in dark night conditions.Oct 31, 2021 · N2186U · DestroyedNTSB ERA22FA036Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Chattahoochee, FLThe pilot’s failure to properly secure the canopy before takeoff, allowing the canopy to open and then separate in flight, which resulted in the pilot’s failure to maintain control of the airplane for reasons that could not be determined based on the…Oct 31, 2021 · N479JJ · DestroyedNTSB CEN22LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Hudson Oaks, TXThe partial loss of engine power due to fuel exhaustion. Contributing was the pilot’s improper fuel planning.Oct 31, 2021 · N29615 · Substantial damageNTSB CEN22LA025Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Cresson, TXThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with trees.Oct 31, 2021 · N46370 · Substantial damageNTSB CEN22LA024Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150L · Forrest City, ARThe pilot’s loss of control during landing. Contributing to the pilot’s injuries was his ejection from the airplane resulting from him not wearing his available seat restraints.Oct 31, 2021 · N6713G · Substantial damageNTSB CEN22FA023Accident · 2 fatalClass 3 · FieldFinal reportBeech P35 · Harrison, NEThe pilot’s decision to continue the flight into instrument and icing conditions, which resulted in loss of control and impact with terrain. Contributing to the accident was the pilot’s failure to obtain a timely weather briefing.Oct 31, 2021 · N8625M · Substantial damageNTSB ERA22LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Waverly, TNThe pilot’s improper pre-flight fuel planning, which resulted in a total loss of engine power to both engines due to fuel exhaustion.Oct 29, 2021 · N30SH · Substantial damageNTSB CEN22LA028Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Greeley, COThe pilot’s loss of directional control during the landing roll.Oct 29, 2021 · N125WB · Substantial damageNTSB WPR22LA031Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Covelo, CAA passenger’s unsecured object departed the cabin resulted in a collision with the tail rotor drive shaft.Oct 28, 2021 · N27TK · Substantial damageNTSB WPR22LA030Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe flight instructor’s failure to monitor the flight to ensure terrain clearance during the dark night conditions.Oct 28, 2021 · N1671J · Substantial damageNTSB WPR22FA023Accident · 1 fatalClass 3 · FieldFinal reportMooney M20M · Snoqualmie, WAThe pilot’s decision to fly the airplane into known icing conditions, which resulted in a loss of airplane control and collision with terrain.Oct 28, 2021 · N40KA · Substantial damageNTSB WPR22FA022Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Ukiah, CAA power interruption due to water-contaminated fuel, which resulted in the student pilot aborting the takeoff and landing hard. Contributing to the accident were a leak in the left fuel tank that allowed water to enter and damage to the fuel tank that…Oct 28, 2021 · N1870V · Substantial damageNTSB ERA22LA040Accident · No injuriesClass 4 · LimitedFinal reportJack A Frohbieter Questair Venture · Robbinsville, NJThe pilot’s failure to extend the landing gear prior to landing, which resulted in substantial damage to the lower fuselage. Contributing to the accident was the pilot’s failure to utilize the aircraft checklist.Oct 28, 2021 · N281F · Substantial damageNTSB CEN22LA037Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Hammond, LAA complete loss of engine power due to oil starvation as a result of the oil filter safety wire fracturing and the oil filter becoming loose in flight for a reason that could not be determined given the evidence available during the investigation.Oct 28, 2021 · N899RW · Substantial damage