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 WPR12CA028Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll.Oct 30, 2011 · N82213 · Substantial damageNTSB WPR12CA025Accident · No injuriesData collectionFinal reportCessna 172K · Florence, MTThe pilot's failure to maintain clearance from a power line during a low-level flight along a river. Contributing to the accident was the pilot's decision to fly at a low altitude.Oct 30, 2011 · N7276G · Substantial damageNTSB ERA12CA055Accident · No injuriesData collectionFinal reportTacchi Torello F Vans Aircraft RV10 · Folkston, GAThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Oct 30, 2011 · N968TP · Substantial damageNTSB ERA12CA054Accident · Serious injuriesData collectionFinal reportAeros Trike · Amherst, VAThe student pilot's inadequate aircraft control and improper airspeed while maneuvering to land, which resulted in a stall. Contributing to the accident was the pilot's lack of experience in the make and model of the accident aircraft.Oct 30, 2011 · N6111F · Substantial damageNTSB CEN12LA056Accident · No injuriesLimited investigationFinal reportCessna 182K · Branson West, MOThe pilot's failure to ensure that his seat was in a locked position before takeoff, which resulted in the seat sliding rearward and the subsequent loss of directional control.Oct 30, 2011 · N2893R · Substantial damageNTSB ANC12FA006Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Iliamna, AKThe pilot's loss of control due to sudden medical impairment or incapacitation.Oct 30, 2011 · N165EH · DestroyedNTSB ERA12FA052Accident · 2 fatalField investigationFinal reportInterplane S R O Skyboy · Miami, FLThe pilot’s failure to maintain control of the airplane while flying at low speed, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the outcome of the accident was the pilot’s decision to operate the airplane…Oct 29, 2011 · N58784 · Substantial damageNTSB WPR12LA023Accident · No injuriesLimited investigationFinal reportCessna 185 · Prineville, ORA total loss of engine power due to fuel starvation, which resulted from the pilot inadvertently leaving the fuel selector set to the left tank. Contributing to the accident was the pilot’s deviation from his normal habit pattern and his failure to refer to…Oct 28, 2011 · N520YH · Substantial damageNTSB ERA12CA053Accident · Serious injuriesData collectionFinal reportCessna 172F · Smoketown, PAThe pilot did not maintain a proper approach path, which resulted in a collision with a tree.Oct 28, 2011 · N5613R · Substantial damageNTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.Oct 27, 2011 · N6545E · Substantial damageNTSB CEN12FA043Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 76 · Fort Worth, TXThe flight instructor's failure to maintain airspeed above the air minimum control airspeed (Vmca), which resulted in a loss of control and impact with terrain. Contributing to the accident was the instructor's failure to follow published procedures to…Oct 26, 2011 · N6018U · Substantial damageNTSB WPR12FA020Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · St. Paul, ORThe pilot was unable to see the other aircraft to avoid a collision.Oct 25, 2011 · N3062H · 2 aircraft · Substantial damageNTSB ERA12CA050Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · McAlpin, FLThe pilot's misjudgment of the airplane's distance from known transmission lines.Oct 24, 2011 · N3169C · Substantial damageNTSB CEN12FA037Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · Carrollton, TXThe pilot's failure to adequately preflight the airplane prior to departure, which resulted in a loss of engine power due to fuel exhaustion.Oct 24, 2011 · N227TX · Substantial damageNTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.Oct 24, 2011 · N7949 · Substantial damageNTSB CEN12CA041Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Pueblo, COThe certified flight instructor’s delayed remedial action. Contributing to the accident was the student pilot's failure to maintain control prior to the landing.Oct 24, 2011 · N942DA · Substantial damageNTSB ERA12FA021Accident · 1 fatalField investigationFinal reportElkind Bruce Cozy MK IV · Lexington, NCThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Oct 23, 2011 · N795DB · Substantial damageNTSB ERA12CA047Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Dyersburg, TNThe pilot's inadvertent excessive braking during the landing roll.Oct 23, 2011 · N27295 · Substantial damageNTSB CEN12CA036Accident · No injuriesData collectionFinal reportCessna 210J · West Chicago, ILThe pilot's failure to extend the landing gear before touchdown due to his failure to use a checklist.Oct 23, 2011 · N3309S · Substantial damageNTSB ERA12CA019Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Manassas, VAThe pilot did not maintain adequate airspeed while turning to the downwind leg, which resulted in an aerodynamic stall and spin.Oct 22, 2011 · N4300E · Substantial damageNTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.Oct 22, 2011 · N82481 · Substantial damageNTSB ANC12CA004Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Aniak, AKThe pilot's excessive use of brakes during landing.Oct 22, 2011 · N11668 · Substantial damageNTSB CEN12CA035Accident · Minor injuriesData collectionFinal reportHouts Avid Mark IV · Hibbing, MNThe improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.Oct 21, 2011 · N43280 · Substantial damageNTSB ERA12CA044Accident · Serious injuriesData collectionFinal reportBoeing 767-2B7 · New York, NYThe passenger's lack of compliance with the illuminated seatbelt sign, which resulted in her injury during a turbulence encounter.Oct 20, 2011 · N253AY · No damageNTSB CEN12CA044Accident · No injuriesData collectionFinal reportAviat A-1 · Wolverton, MNThe pilot's inadvertent excessive braking during the landing roll due to momentary pain.Oct 20, 2011 · N93HU · Substantial damageNTSB WPR12CA016Accident · No injuriesData collectionFinal reportBeech D17S · Phoenix, AZThe pilot's failure to extend the landing gear.Oct 18, 2011 · N44562 · Substantial damageNTSB ERA12LA045Accident · No injuriesLimited investigationFinal reportGraff Wilbur C Bearhawk · Woodrow, WVThe pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.Oct 18, 2011 · N5456C · Substantial damageNTSB ERA12CA042Accident · Minor injuriesData collectionFinal reportMoyes Bailey Dragonfly · Massey, MDThe pilot did not maintain airspeed during approach to landing, which resulted in an aerodynamic stall.Oct 18, 2011 · N103ST · Substantial damageNTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.Oct 18, 2011 · N8485D · Substantial damageNTSB ERA12FA030Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Danbury, CTThe pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.Oct 17, 2011 · N438CP · Substantial damageNTSB ERA12CA043Accident · Minor injuriesData collectionFinal reportFehlner-Shelton Aerosport Scamp WTB1 · Grantham, NCThe pilot's inadequate clearance from unmarked power lines while on approach to land at a private airport.Oct 17, 2011 · N25WS · Substantial damageNTSB ERA12CA036Accident · Serious injuriesData collectionFinal reportCessna 172F · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 17, 2011 · N5419R · Substantial damageNTSB ERA12CA035Accident · Serious injuriesData collectionFinal reportAmerican Champion 7AC · Berkley, MAThe pilot did not maintain clearance from a tree during the final approach in solar glare conditions.Oct 17, 2011 · N3662E · Substantial damageNTSB CEN12CA030Accident · No injuriesData collectionFinal reportCessna 172N · Covington, LAThe pilot’s failure to maintain adequate airspeed during a banner drop, resulting in an aerodynamic stall.Oct 17, 2011 · N2401E · Substantial damageNTSB WPR12FA012Accident · 3 fatalField investigationFinal reportBeech E33 · Daggett, CAA loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…Oct 16, 2011 · N7011N · Substantial damageNTSB WPR12CA014Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Las Vegas, NVThe inadvertent opening of the airplane’s canopy during takeoff, which distracted the pilot and resulted in his failure to maintain control of the airplane. Contributing to the accident was the pilot's failure to comply with the manufacturer's recommended…Oct 16, 2011 · N999VS · Substantial damageNTSB ERA12CA040Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Mebane, NCThe pilot's delay in aborting the takeoff.Oct 16, 2011 · N3760H · Substantial damageNTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 16, 2011 · N6085W · Substantial damageNTSB CEN12CA026Accident · Serious injuriesData collectionFinal reportJantzen Evans VP · Terrell, TXThe pilot’s inadequate preflight planning, in that he did not determine whether the airplane’s climb performance would be sufficient to clear obstacles before initiating take off.Oct 16, 2011 · N331EJ · Substantial damageNTSB CEN12CA024Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Moriarty, NMThe pilot's failure to maintain control of the airplane during the landing roll.Oct 16, 2011 · N415WW · Substantial damageNTSB OPS12IA041Incident · No injuriesIncident investigationFinal reportCessna 172S · Daytona Beach, FLThe departing pilot's incorrect runway selection and non-compliance with an air traffic control clearance. Contributing to the incident was the air traffic controller's inadequate monitoring of the departing aircraft to ensure that the pilot complied with the…Oct 15, 2011 · N488ER · 2 aircraft · No damageNTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.Oct 15, 2011 · N929SC · Substantial damageNTSB ERA12CA029Accident · No injuriesData collectionFinal reportCessna 180H · Houston, MSThe pilot did not maintain directional control during the landing roll.Oct 15, 2011 · N4764U · Substantial damageNTSB CEN12CA032Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Radnor, OHThe pilot's failure to properly secure the engine controls prior to manually rotating the propeller, which led to an inadvertent engine start and runaway airplane.Oct 15, 2011 · N8746W · Substantial damageNTSB CEN12CA029Accident · Minor injuriesData collectionFinal reportHunt Sparrowhawk · Blair, NEThe pilot/builder’s inadequate installation of a nosewheel steering component, which resulted in a shimmy and a loss of directional control during the takeoff roll.Oct 15, 2011 · N29HT · Substantial damageNTSB WPR12CA011Accident · Minor injuriesData collectionFinal reportCessna 170B · Ramona, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.Oct 14, 2011 · N8261A · Substantial damageNTSB ERA12CA027Accident · No injuriesData collectionFinal reportIca Brasov IS-29D2 · Benton, TNThe pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.Oct 14, 2011 · N1339X · Substantial damageNTSB CEN12CA031Accident · No injuriesData collectionFinal reportHughes 269A · Fort Worth, TXThe inadvertent entry into ground resonance after a hovering autorotation.Oct 14, 2011 · N10375 · Substantial damageNTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.Oct 14, 2011 · N610EC · Substantial damageNTSB CEN12CA022Accident · No injuriesData collectionFinal reportCessna 172P · Ozark, MOThe pilot’s inadequate compensation for gusty crosswind conditions while on approach.Oct 14, 2011 · N54356 · Substantial damage