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 ANC15LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA 22 · Skwentna, AKThe pilot's failure to follow the airplane's operating limitations by rapidly opening the throttle, which resulted in a loss of engine power. Contributing to the accident was the pilot's decision to maneuver the airplane at low altitude even though he was not…Jun 1, 2015 · N2828P · Substantial damageNTSB ANC15LA033Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe other pilot’s failure to maintain an adequate visual lookout, which resulted in a midair collision. Contributing to the accident was the other pilot’s failure to follow Federal Aviation Administration-recommended traffic pattern procedures.Jun 1, 2015 · N1694M · 2 aircraft · Substantial damageNTSB WPR15CA173Accident · No injuriesData collectionFinal reportCessna T188C · Ismay, MTThe pilot's incorrect action to continue the takeoff when he failed to maintain directional control during the takeoff roll.May 31, 2015 · N9987J · Substantial damageNTSB GAA15LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Archer City, TXThe pilot’s failure to maintain adequate clearance from power transmission lines during an aerial application flight.May 31, 2015 · N120TF · Substantial damageNTSB GAA15CA115Accident · Minor injuriesData collectionFinal reportSmiley James E RAG Wing RW-6 · Mocksville, NCThe pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with a building.May 30, 2015 · N2305J · Substantial damageNTSB GAA15CA104Accident · No injuriesData collectionFinal reportCessna 150F · Harlingen, TXThe student pilot's failure to maintain directional control while landing with a crosswind.May 30, 2015 · N8126S · Substantial damageNTSB GAA15CA098Accident · No injuriesData collectionFinal reportSchweizer SGS 1 26B · Mocksville, NCThe glider pilot over-ran the runway and impacted a structure after encountering a strong updraft on short final.May 30, 2015 · N8683R · Substantial damageNTSB CEN15FA245Accident · 3 fatalField investigationFinal reportBeech A36 · Plainview, TXThe pilot’s decision to take off ahead of an approaching severe thunderstorm, which resulted in an encounter with hazardous weather conditions that led to a loss of airplane control.May 30, 2015 · N221D · DestroyedNTSB ANC15FA032Accident · 1 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain altitude, which resulted in collision with the terrain. Contributing to the accident was the pilot's impairment from carbon monoxide exposure in flight. The source of the carbon monoxide could not be determined because the…May 30, 2015 · N1653U · Substantial damageNTSB GAA15CA124Accident · No injuriesData collectionFinal reportBeech D35 · Sunriver, ORThe pilot's failure to extend the landing gear, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's distraction from completing his before landing checklist and inability to hear the gear warning…May 29, 2015 · N2984B · Substantial damageNTSB GAA15CA102Accident · No injuriesData collectionFinal reportBell 206 - B11 · Caledonia, MIA loss of tail rotor effectiveness while maneuvering at low altitude, resulting in a collision with trees.May 29, 2015 · N206ED · Substantial damageNTSB ERA15LA228Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Churchville, MDThe pilot's improper reduction of the fuel mixture while the airplane was descending on the final leg of the traffic pattern, which resulted in a total loss of engine power and subsequent aerodynamic stall.May 29, 2015 · N2009B · Substantial damageNTSB CEN15CA246Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Winnsboro, LAThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot and collision with trees.May 29, 2015 · N1036S · Substantial damageNTSB GAA15CA119Accident · No injuriesData collectionFinal reportCessna 172R · Beaver Falls, PAThe student pilot's failure to maintain airplane attitude control during the landing, resulting in a hard landing.May 28, 2015 · N984WU · Substantial damageNTSB GAA15CA099Accident · No injuriesData collectionFinal reportCessna 172 - R · State College, PAThe student pilot's failure to maintain adequate airspeed during the approach to landing which resulted in an aerodynamic stall and a hard landing.May 28, 2015 · N2254U · Substantial damageNTSB GAA15CA097Accident · No injuriesData collectionFinal reportBell 47G 3B 1 · Fort Pierre, SDThe pilot's inadequate preflight fuel planning that resulted in a total loss of engine power due to fuel exhaustion, and the pilot's failure to maintain control of the helicopter during the subsequent autorotation landing.May 28, 2015 · N112SH · Substantial damageNTSB GAA15CA096Accident · No injuriesData collectionFinal reportAero Vodochody L39 · Grand Junction, COThe pilot's inadequate preflight planning and subsequent failure to remain clear of power line wires while maneuvering at low altitude.May 28, 2015 · N6175C · Substantial damageNTSB CEN15LA247Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon G36 · Horseshoe Bay, TXThe pilot’s failure to abort the takeoff after the partial loss of engine power before liftoff, and the partial loss of engine power for undetermined reasons.May 28, 2015 · N224TB · DestroyedNTSB GAA15CA100Accident · No injuriesData collectionFinal reportCessna 305 · Richfield, UTThe pilot's loss of directional control during landing, which resulted in a ground loop.May 27, 2015 · N16708 · Substantial damageNTSB ERA15LA224Accident · No injuriesLimited investigationFinal reportCessna 337 · Melbourne, FLThe pilot’s failure to maintain directional control while taxiing as a result of his impairment due to alcohol ingestion.May 27, 2015 · N1732M · Substantial damageNTSB CEN15LA250Accident · No injuriesLimited investigationFinal reportCessna T188C · Pine Bluffs, WYThe pilot's loss of directional control to the right for reasons that could not be determined during examination of the right main landing gear wheel and brake drum.May 27, 2015 · N1965J · Substantial damageNTSB ANC15CA031Accident · No injuriesData collectionFinal reportAeronca 7EC · Palmer, AKThe instructor's delayed remedial actions, and the student pilot's failure to maintain adequate airspeed, which resulted in a stall just above the ground and the subsequent hard landing.May 27, 2015 · N84116 · Substantial damageNTSB ANC15CA030Accident · Minor injuriesData collectionFinal reportCessna U206G · Port Alsworth, AKThe pilot's inadequate preflight and mismanagement of the fuel supply, which resulted fuel exhaustion.May 27, 2015 · N888KD · Substantial damageNTSB GAA15CA089Accident · No injuriesData collectionFinal reportCessna 188 · Polson, MTThe pilot's failure to maintain airplane pitch, power, and turn coordination while maneuvering at low altitude, resulting in an aerodynamic stall and a collision with terrain.May 26, 2015 · N53141 · Substantial damageNTSB GAA15CA095Accident · No injuriesData collectionFinal reportCessna 182Q · Honesdale, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane.May 25, 2015 · N759EB · Substantial damageNTSB GAA15CA094Accident · No injuriesData collectionFinal reportCessna 182E · Galion, OHThe pilot's failure to maintain adequate airspeed on final approach, which resulted in an in-flight loss of control and hard landing.May 25, 2015 · N25AW · Substantial damageNTSB GAA15CA090Accident · Minor injuriesData collectionFinal reportPiper PA 25-260 · Casselton, NDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance, which resulted in the inflight collision with power transmission line wires.May 25, 2015 · N4793Y · Substantial damageNTSB ERA15CA222Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s improper landing flare, which resulted in a bounced landing and damage to the airplane.May 25, 2015 · N6155K · Substantial damageNTSB CEN15LA241Accident · No injuriesLimited investigationFinal reportGarratt Mansfield W IV-P · Hamilton, TXThe pilot’s decision to continue flight into known severe thunderstorm conditions, which resulted in the loss of engine power during the descent due to the engine’s ingestion of water and ice and a subsequent forced landing.May 25, 2015 · N725HP · Substantial damageNTSB CEN15FA240Accident · 1 fatalField investigationFinal reportYakovlev YAK 52 · Syracuse, KSThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall .May 25, 2015 · N124FS · Substantial damageNTSB GAA15CA110Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Wickenburg, AZThe pilot's failure to monitor the airplane's wing clearance during taxi, which resulted in a collision with a parked airplane.May 24, 2015 · N442PA · Substantial damageNTSB GAA15LA085Accident · Serious injuriesLimited investigationFinal reportDestiny 2000 · Eltopia, WAThe flight instructor’s failure to tell the student pilot to abort the takeoff after the powered parachute experienced wing oscillations, which resulted in the student pilot’s loss of aircraft control during initial climb and subsequent impact with terrain.…May 23, 2015 · N3376 · Substantial damageNTSB GAA15CA093Accident · No injuriesData collectionFinal reportRogers Homer/Rogers Sheila RV 6A · Lorain/Elyria, OHThe pilot's failure to maintain airplane attitude control during the landing flare, which resulted in an aerodynamic stall, hard landing, and runway excursion.May 23, 2015 · N3086Q · Substantial damageNTSB GAA15CA091Accident · Minor injuriesData collectionFinal reportLefever Paul M RV12 · Caledonia, MOThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a nose over.May 23, 2015 · N198PR · Substantial damageNTSB GAA15CA088Accident · Minor injuriesData collectionFinal reportCessna 172M · Sussex, NJThe pilot's failure to remove the gust lock during the preflight inspection, resulting in a loss of control and collision with trees during takeoff.May 23, 2015 · N9959V · Substantial damageNTSB ERA15FA221Accident · 1 fatalField investigationFinal reportBR Legend Turbine Legend · West Columbia, SCAn engine flame-out due to fuel starvation as the result of an improperly-installed auxiliary fuel pump fitting, and the pilot's failure to promptly feather the propeller following the engine-flame out, which resulted in decreased glide capability and impact…May 23, 2015 · N42BR · DestroyedNTSB ERA15CA226Accident · Serious injuriesData collectionFinal reportAerostar International S-60A · LaGrangeville, NYThe pilot's decision to conduct a landing to a field in high wind conditions, which resulted in a hard landing and subsequent injury to a passenger.May 23, 2015 · N6517X · No damageNTSB DCA15CA125Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Atlanta, GAthe flight attendant's failure to secure her lap belt and shoulder harness prior to the takeoff that resulted in her being thrown from her jumpseat shortly after takeoff.May 23, 2015 · N334NW · No damageNTSB GAA15CA087Accident · No injuriesData collectionFinal reportSmith Vilas Kitfox · McLeansboro, ILThe pilot's failure to maintain attitude control during the landing roll. A contributing factor was the pilot's lack of training and experience in this airplane make and model.May 22, 2015 · N4100T · Substantial damageNTSB GAA15CA086Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA 4 200 · Glenwood, MNThe pilot's improper lateral/ bank level off during the landing flare, which resulted in the right wing impacting the water and a subsequent loss of control.May 22, 2015 · N613LC · Substantial damageNTSB ERA15CA229Accident · Minor injuriesData collectionFinal reportWilson Michael A Challenger II · Lebanon, TNThe non-certificated pilot's failure to maintain airspeed during takeoff, which resulted in an aerodynamic stall, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's lack of training and flight experience in the…May 22, 2015 · N8547W · Substantial damageNTSB WPR15FA166Accident · 1 fatalField investigationFinal reportCessna 210F · Pleasanton, CAThe pilot’s continued visual flight into instrument flight rules conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.May 21, 2015 · N1842F · DestroyedNTSB ERA15FA220Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Rowdy, KYThe noninstrument-rated pilot’s decision to continue visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.May 21, 2015 · N26886 · DestroyedNTSB GAA15CA084Accident · No injuriesData collectionFinal reportFaunce PA-11 · Morrisville, VTThe pilot's failure to maintain directional control during the landing roll and his deliberate application of excessive braking pressure.May 20, 2015 · N710JF · Substantial damageNTSB GAA15CA082Accident · Minor injuriesData collectionFinal reportBoeing PT 17 · Williamson, GAThe pilot landed off the right side of the runway resulting in a collision with terrain.May 20, 2015 · N55528 · Substantial damageNTSB GAA15CA081Accident · Serious injuriesData collectionFinal reportCitabria 7GCBC · Winnsboro, SCThe pilot's execution of a steep left turn at low altitude during an aborted landing, which resulted in an aerodynamic stall, and a collision with terrain.May 20, 2015 · N50595 · Substantial damageNTSB ERA15LA218Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Kearny, NJThe deliberate concealment and reuse of an unairworthy tail rotor driveshaft by unknown personnel, which resulted in an overstress separation at a bonded flange adapter as a result of driveshaft imbalance.May 20, 2015 · N210MH · Substantial damageNTSB CEN15LA239Accident · Minor injuriesLimited investigationFinal reportAyres S2R G6 · Tivoli, TXThe failure of the fuel control unit due to the worn stub shaft spline, which resulted in an engine overspeed. Contributing to the accident was maintenance personnel's inadequate inspection of the fuel control unit.May 20, 2015 · N3300U · Substantial damageNTSB WPR15FA163Accident · 3 fatalField investigationFinal reportRockwell Commander 114 · Laughlin, NVA partial loss of engine power due to the turbocharger's seizure as a result of a severely worn turbowheel. Contributing to the accident was the failure of the pilot/owner to have the turbo normalization system inspected every 100 hours as required, which…May 18, 2015 · N4775W · DestroyedNTSB ERA15FA215Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Saltville, VAThe pilot’s flight into developing rain showers and updrafts, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident were the pilot’s continued flight into forecast adverse weather conditions, and his reliance on…May 18, 2015 · N5816S · Destroyed