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 ERA12LA541Accident · 1 fatalLimited investigationFinal reportJohnston Douglas S Safari · McVeytown, PAThe pilot's lack of proficiency and certification, which resulted in his failure to enter an autorotation when the engine lost power. Contributing to the accident was the pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a subsequent…Sep 1, 2012 · N70415 · Substantial damageNTSB ERA12FA540Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Falmouth, MAThe flight instructor’s inadequate remedial action. Contributing to the accident was the student pilot’s poor control of the airplane during the approach.Sep 1, 2012 · N221DV · Substantial damageNTSB ERA12CA569Accident · No injuriesData collectionFinal reportCessna 172S · Farmingdale, NYThe student pilot's improper landing flare, which resulted in a hard landing.Sep 1, 2012 · N2409E · Substantial damageNTSB ERA12CA548Accident · Serious injuriesData collectionFinal reportHandy James L Buckeye Dream Mach · West Caln, PAThe pilot’s inadequate compensation for the wind during the initial climb, which resulted in collision with a tree and terrain.Sep 1, 2012 · N4258M · Substantial damageNTSB CEN12LA655Accident · No injuriesLimited investigationFinal reportTL Ultralight Sro Stingsport · Longmont, COThe failure of the wood propeller blades in flight. Contributing to the accident was the owner/operator’s failure to complete required inspections on the propeller within the specified interval, which reduced the likelihood of detecting the cracks and may…Sep 1, 2012 · N898N · Substantial damageNTSB CEN12LA605Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G 103 Twin II · El Paso, TXThe pilot‘s failure to maintain glider control while attempting to take off using a ground winch, which resulted in an inadvertent stall low to the ground. Contributing to the accident was the ground winch, which was unable to produce enough speed for a…Sep 1, 2012 · N5489X · Substantial damageNTSB CEN12LA602Accident · 1 fatalLimited investigationFinal reportAero Vodochody L39C · Davenport, IAThe loss of airplane control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded operation.Sep 1, 2012 · N139GS · DestroyedNTSB CEN12FA601Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brighton, MIThe pilot’s failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the severity of…Sep 1, 2012 · N82383 · Substantial damageNTSB CEN12CA614Accident · No injuriesData collectionFinal reportCessna L-19E · Lancaster, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 1, 2012 · N4431F · Substantial damageNTSB CEN12CA596Accident · No injuriesData collectionFinal reportArvold Jordon R CH 750 · Colfax, WIThe pilot did not maintain control of the airplane while landing with a gusty crosswind.Sep 1, 2012 · N32JA · Substantial damageNTSB WPR12LA396Accident · No injuriesLimited investigationFinal reportBeech G35 · Oceano, CAThe pilot’s exceedance of the design maneuvering speed during descent in turbulence, which resulted in structural damage to the aft fuselage.Aug 31, 2012 · N4454D · Substantial damageNTSB WPR12LA384Accident · Minor injuriesLimited investigationFinal reportCessna 182R · St. Johns, AZThe pilot’s delay in executing a go-around, which resulted in a runway overrun. Contributing to the accident were the pilot’s failure to establish the proper glidepath and airspeed on final approach and his improper use of flaps during the go-around.Aug 31, 2012 · N5458N · Substantial damageNTSB WPR12FA385Accident · Serious injuriesField investigationFinal reportEaston Searey · Friday Harbor, WAThe pilot’s inadequate glidepath and failure to maintain clearance from the transmission wire during a landing approach.Aug 31, 2012 · N346PE · Substantial damageNTSB WPR12CA381Accident · No injuriesData collectionFinal reportCessna A185F · Gerlach, NVThe pilot's failure to maintain directional control during the takeoff roll.Aug 31, 2012 · N3946Q · Substantial damageNTSB ERA12TA538Accident · Minor injuriesFinal reportBell 407 · Bath, NYThe pilot's improper recovery from an in-flight upset, which resulted in the main rotor striking and separating the tail boom. Contributing to the accident was the helicopter manufacturer's failure to warn pilots of unanticipated and unequal aft cyclic…Aug 31, 2012 · N11SP · Substantial damageNTSB ERA12LA539Accident · No injuriesLimited investigationFinal reportCessna 172M · Canadensis, PAThe pilot’s failure to attain a proper glidepath.Aug 31, 2012 · N391R · Substantial damageNTSB ERA12IA550Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MACompany maintenance personnel’s failure to comply with the airplane manufacturer’s service instructions by not removing the cracked drag brace from service nor inspecting the repaired drag brace at the appropriate interval, which resulted in the failure of…Aug 31, 2012 · N769EA · Minor damageNTSB CEN12FA594Accident · 2 fatalField investigationFinal reportPiper PA-12 · Rye, COThe pilot’s selection of a flightpath toward rising terrain that exceeded the climb capability of the airplane.Aug 31, 2012 · N3031M · Substantial damageNTSB CEN12CA603Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Pittsford, MIThe student pilot’s failure to maintain directional control of the airplane while maneuvering at a low altitude.Aug 31, 2012 · N995LS · Substantial damageNTSB ANC12FA095Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Homer, AKThe pilot's failure to see and avoid high tension power lines.Aug 31, 2012 · N57511 · Substantial damageNTSB ANC12CA109Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in an aborted takeoff and collision with terrain.Aug 31, 2012 · N1620A · Substantial damageNTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.Aug 31, 2012 · N3615M · Substantial damageNTSB ANC12CA098Accident · No injuriesData collectionFinal reportMaule M-5-210C · Juneau, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, resulting in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.Aug 31, 2012 · N378X · Substantial damageNTSB WPR12FA378Accident · 2 fatalField investigationFinal reportAircraft Mfg & Development CH 2000 · Nephi, UTThe pilot's inability to maintain airplane control due to an encounter with a microburst/downdraft that exceeded the climb performance capabilities of the airplane.Aug 30, 2012 · N651AM · Substantial damageNTSB WPR12CA380Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe flight instructor’s delayed response in correcting the student pilot’s improper landing flare, which resulted in a hard landing.Aug 30, 2012 · N309PA · Substantial damageNTSB WPR12CA376Accident · Serious injuriesData collectionFinal reportChampion 7FC · Terrebonne, ORThe pilot's physical impairment, which adversely affected his ability to properly operate the airplane.Aug 30, 2012 · N4849E · Substantial damageNTSB ERA12LA537Accident · 2 fatalLimited investigationFinal reportQuad City Ultralights Challenger II · Ocala, FLThe pilot's inadvertent overstress of the airplane, which resulted in the in-flight separation of the outer section of the right wing.Aug 30, 2012 · N2481P · Substantial damageNTSB ERA12CA546Accident · No injuriesData collectionFinal reportCessna 172M · Bardstown, KYThe flight instructor's decision to turn the fuel selector to the off position and his delayed remedial actions to restart the engine, which resulted in fuel starvation and a subsequent forced landing.Aug 30, 2012 · N21214 · Substantial damageNTSB CEN12LA593Accident · No injuriesLimited investigationFinal reportMudge Ray KIT FOX 5 · Bowling Green, OHThe pilot receiving instruction's excessive braking during the landing roll, which resulted in a loss of control.Aug 30, 2012 · N84KF · Substantial damageNTSB ERA12LA535Accident · 1 fatalLimited investigationFinal reportBeech 95-A55 · Millville, NJThe pilot receiving instruction failed to maintain airplane control during the simulated engine-out landing. Contributing to the accident was the flight instructor's failure to take timely remedial action.Aug 29, 2012 · N71BM · Substantial damageNTSB CEN12LA587Accident · No injuriesLimited investigationFinal reportAviat A-1 · Rolla, NDThe pilot's failure to secure the right wing's fuel cap before the flight and to properly manage the available fuel supply during the flight, which resulted in a loss of engine power due to fuel exhaustion.Aug 29, 2012 · N49363 · Substantial damageNTSB CEN12IA592Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3101 · Kansas City, MOThe flight crew’s failure to ensure that the cargo door was properly fastened before departure.Aug 29, 2012 · N695MA · Minor damageNTSB CEN12FA586Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Canton, MOThe pilot's improper decision to attempt to execute a forced landing to an open field with obstacles. Contributing to the accident was the left engine’s total loss of power due to fuel starvation as a result of the introduction of air into the fuel system…Aug 29, 2012 · N1486P · Substantial damageNTSB CEN12CA671Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Goldsby, OKThe commercial pilot did not attain the proper touchdown point during the landing, which resulted in a premature touchdown and an impact with the edge of the runway surface.Aug 29, 2012 · N7602C · Substantial damageNTSB WPR12LA377Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Everett, WAA hard landing likely made by the private pilot on a solo flight that preceded the dual instructional flight during which the wing damage became obvious.Aug 28, 2012 · N4922T · Substantial damageNTSB CEN12FA579Accident · 1 fatalField investigationFinal reportLee Paul SQ 2000 · Pierre, SDThe airplane's entry into a pilot-induced oscillation and the pilot’s loss of airplane control during the takeoff initial climb. Contributing to the accident was the left entrance door opening in flight for undetermined reasons.Aug 28, 2012 · N416 · Substantial damageNTSB CEN12CA631Accident · No injuriesData collectionFinal reportPowrachute Pegasus · Luling, TXCollision with a powerline resulting from the pilot's not maintaining adequate clearance while on a day VFR approach to land.Aug 28, 2012 · N554E · Substantial damageNTSB CEN12CA585Accident · No injuriesData collectionFinal reportCessna 180 · Brookville, OHThe pilot's failure to maintain directional control of the airplane during the attempted takeoff in gusting crosswind conditions.Aug 28, 2012 · N2909A · Substantial damageNTSB ANC12CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to identify the appropriate touchdown point, which resulted in a nose over.Aug 28, 2012 · N4316Z · Substantial damageNTSB WPR12LA373Accident · No injuriesLimited investigationFinal reportCessna P210 · Alturas, CAA loss of engine power due to fuel vaporization. Contributing to the accident was the pilot’s failure to use the auxiliary fuel pump when he noticed a degradation in the airplane’s climb performance.Aug 27, 2012 · C-GFCK · Substantial damageNTSB WPR12LA371Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH58 · Escalon, CAThe pilot’s failure to maintain clearance from trees during a low-altitude agricultural application, which resulted in a loss of control and impact with the ground.Aug 27, 2012 · N503DR · Substantial damageNTSB CEN12LA584Accident · 1 fatalLimited investigationFinal reportTop Dog TD2 · Bemidji, MNThe pilot's failure to maintain aircraft control and his inadequate flare during landing. Contributing to the accident was the pilot’s failure to obtain training on the operation of the accident aircraft.Aug 27, 2012 · N71314 · Substantial damageNTSB WPR12FA369Accident · 5 fatalField investigationFinal reportPiper PA-32-301T · South Lake Tahoe, CAA partial loss of engine power for reasons that could not be determined because examinations revealed no evidence of mechanical anomalies with the airframe or engine that would have precluded normal operation and the pilots’ decision to continue the departure…Aug 26, 2012 · N588ET · Substantial damageNTSB WPR12CA370Accident · Minor injuriesData collectionFinal reportCessna 150G · Madera, CAThe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion.Aug 26, 2012 · N6346S · Substantial damageNTSB ERA12FA526Accident · 1 fatalField investigationFinal reportBeech B24R · Dayton, VAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the noninstrument-rated pilot's decision to attempt a visual flight rules flight in instrument meteorological conditions…Aug 26, 2012 · N9200S · Substantial damageNTSB CEN12FA572Accident · Serious injuriesField investigationFinal reportEberle John S Fokker DR-1 Triplane · Parker, COThe pilot's loss of control of the airplane due to the airplane’s reduced climb performance during high density altitude operations.Aug 26, 2012 · N152RB · Substantial damageNTSB CEN12CA588Accident · Minor injuriesData collectionFinal reportTrick Trikes Stss · Wanamingo, MNThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.Aug 26, 2012 · N5152E · Substantial damageNTSB WPR12LA367Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Pacoima, CAA total loss of engine power on approach for landing due to a combination of the low fuel level and fuel contamination.Aug 25, 2012 · N9409E · Substantial damageNTSB ERA12LA528Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Dansville, NYThe pilot’s failure to maintain glider control while maneuvering. Contributing to the accident was the pilot’s impairment due to an over-the-counter sedating antihistamine.Aug 25, 2012 · N438AS · Substantial damageNTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…Aug 25, 2012 · N407N · Substantial damage