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 WPR12LA009Accident · No injuriesLimited investigationFinal reportSpink Robert M Pietenpol Aircamper · San Rafael, CAA total loss of engine power during the takeoff climb due to fuel starvation, which resulted from the incorrect installation location of the fuel tank supply line screen that allowed debris to partially block the fuel supply line.Oct 13, 2011 · N762S · Substantial damageNTSB WPR12FA010Accident · 1 fatalField investigationFinal reportDG Flugzeugbau DG 1000S · Cle Elum, WAThe pilot’s failure to maintain airspeed and control after takeoff, which resulted in an aerodynamic stall.Oct 13, 2011 · N7760A · Substantial damageNTSB WPR12CA007Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A · San Diego, CAThe pilot's excessive brake application during landing.Oct 13, 2011 · N502GL · Substantial damageNTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.Oct 13, 2011 · N3086X · Substantial damageNTSB WPR12CA008Accident · No injuriesData collectionFinal reportCessna 172P · Cornelius, ORThe airplane’s encounter with an unseen hole or obstacle on the grass runway.Oct 12, 2011 · N52013 · Substantial damageNTSB ERA12FA023Accident · Minor injuriesField investigationFinal reportSocata TBM 700 · Hollywood, FLThe pilot’s failure to terminate the flight after observing multiple conflicting errors associated with the inaccurate right fuel quantity indication. Contributing to the accident were the total loss of engine power due to fuel starvation from the right tank,…Oct 12, 2011 · N37SV · Substantial damageNTSB ERA12CA168Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Zelienople, PAThe pilot did not maintain directional control during landing.Oct 12, 2011 · N567HW · Substantial damageNTSB ERA12CA046Accident · No injuriesData collectionFinal reportCessna 182L · Gainesville, FLThe pilot did not maintain a proper descent rate during the approach, which resulted in a hard landing.Oct 12, 2011 · N42547 · Substantial damageNTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.Oct 12, 2011 · N64MG · Substantial damageNTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.Oct 12, 2011 · N6171B · Substantial damageNTSB WPR12CA005Accident · No injuriesData collectionFinal reportCombs Dale B RV-4 · Madera, CAThe third airplane pilot’s failure to maintain visual contact with the second airplane during the formation flight.Oct 11, 2011 · N506DC · 2 aircraft · Substantial damageNTSB CEN12CA011Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Englewood, COThe student pilot's improper flare, which resulted in a bounced landing from which he was unable to recover.Oct 11, 2011 · N777XG · Substantial damageNTSB WPR12CA006Accident · Minor injuriesData collectionFinal reportLudwig Larry E Bushman · Diamond, WAThe pilot's inadequate recovery from a bounced landing and subsequent failure to maintain aircraft control.Oct 10, 2011 · N132LL · Substantial damageNTSB ERA12CA024Accident · No injuriesData collectionFinal reportCessna 182A · Warrenton, VAThe pilot did not ensure that the forward door latch was secured prior to initiating the descent.Oct 10, 2011 · N6324B · Substantial damageNTSB ERA12CA020Accident · No injuriesData collectionFinal reportCessna 177B · Honesdale, PAThe pilot’s excessive airspeed during final approach and his delayed decision to abort the landing, resulting in the in-flight collision with trees during the go-around.Oct 10, 2011 · N34218 · Substantial damageNTSB CEN12CA064Accident · No injuriesData collectionFinal reportCessna 210F · Phillipsburg, KSThe pilot’s improper recovery from a bounced landing.Oct 10, 2011 · N615BT · Substantial damageNTSB ANC12CA003Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate clearance from a tree during an off-airport landing.Oct 10, 2011 · N124GS · Substantial damageNTSB ERA12LA358Accident · No injuriesLimited investigationFinal reportCessna 182C · Efland, NCThe pilot’s loss of directional control during the landing roll, which resulted in a collision with a ditch.Oct 9, 2011 · N8527T · Substantial damageNTSB ERA12CA022Accident · No injuriesData collectionFinal reportAeronca 0-58A · Westmoreland, TNThe pilot's inadequate visual lookout and failure to maintain clearance from an obstacle during takeoff.Oct 9, 2011 · N46513 · Substantial damageNTSB WPR12CA004Accident · No injuriesData collectionFinal reportCessna T310R · Hilo, HIA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.Oct 8, 2011 · N23BT · Substantial damageNTSB ERA12CA116Accident · No injuriesData collectionFinal reportCessna 188 · Starkville, MSThe pilot did not maintain directional control of the airplane during landing, which resulted in a runway excursion.Oct 8, 2011 · N5424E · Substantial damageNTSB CEN12LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Wadsworth, OHThe failure of the brake system during the landing roll, which was caused by a loss of hydraulic fluid as a result of a leak in the piston seal due to brake plates worn beyond their service limits.Oct 8, 2011 · N9444W · Substantial damageNTSB CEN12LA012Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Easton, MODebris in the fuel system, which resulted in a loss of engine power due to fuel starvation. Also causal was the pilot not maintaining sufficient airspeed, which resulted in an aerodynamic stall.Oct 8, 2011 · N27492 · Substantial damageNTSB ERA12CA038Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe tug driver's inadequate control of the tug while maneuvering the airplane during pushback.Oct 7, 2011 · N922DL · Substantial damageNTSB ERA12CA015Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Elizabethton, TNThe failure of the pilot to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.Oct 7, 2011 · N3491Z · Substantial damageNTSB CEN12LA039Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · South Pass 93AImproper centering of the cyclic during a start in gusty wind conditions.Oct 7, 2011 · N183EH · Substantial damageNTSB CEN12LA013Accident · No injuriesLimited investigationFinal reportWilhelm Calidus · Thompsonville, MIThe pilot 's inability to maintain control of the gyrocraft during the landing roll for undetermined reasons.Oct 7, 2011 · N455BW · Substantial damageNTSB WPR12CA003Accident · No injuriesData collectionFinal reportCessna 172P · AganaThe pilot's failure to avoid the jet blast while taxiing and the ground air traffic controller's failure to advise the pilot of the hazard.Oct 6, 2011 · N9853L · Substantial damageNTSB ERA12LA011Accident · 1 fatalLimited investigationFinal reportRivers William J KR-2 · Wytheville, VAThe pilot's failure to maintain control, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's lack of experience in the airplane make and model.Oct 6, 2011 · N7026G · Substantial damageNTSB ERA12CA028Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Culpeper, VAThe pilot's inadequate knowledge of the airplane's emergency gear extension procedures, which resulted in his failure to successfully perform a manual extension of the landing gear.Oct 6, 2011 · N9268C · Substantial damageNTSB ERA12CA025Accident · No injuriesData collectionFinal reportCessna 177RG · Westerly, RIThe pilot's failure to maintain airplane control while starting the engine.Oct 6, 2011 · N177MW · Substantial damageNTSB ERA12CA010Accident · No injuriesData collectionFinal reportCalvin Nate H CALVIN-VELOCITY · Sebastian, FLThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot and collision with terrain prior to the runway.Oct 6, 2011 · N67WR · Substantial damageNTSB CEN12FA010Accident · 1 fatalField investigationFinal reportBrinkerhuff Gerald G Q200 · Holland, MIThe pilot failed to maintain sufficient altitude during the landing approach, which resulted in the airplane contacting an approach light. Contributing to the accident was the setting sun, which most likely obscured the pilot’s vision.Oct 6, 2011 · N2935R · Substantial damageNTSB CEN12CA006Accident · No injuriesData collectionFinal reportCessna 210A · Wolfe City, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.Oct 6, 2011 · N9448X · Substantial damageNTSB ERA12LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Norfolk, VAThe pilot's inability to maintain directional control during takeoff for undetermined reasons. Contributing to the accident was the pilot's delayed decision to abort the takeoff.Oct 5, 2011 · N180RN · Substantial damageNTSB ERA12LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Punta Gorda, FLThe partial loss of engine power due to contamination of the fuel system that was not detected because of the pilot’s inadequate preflight inspection.Oct 5, 2011 · N11280 · Substantial damageNTSB ERA12FA008Accident · 1 fatalField investigationFinal reportAviat A-1 · Moyock, NCThe operation of the airplane by a non-certificated pilot, and his failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Oct 5, 2011 · N11HU · Substantial damageNTSB ERA12FA007Accident · 1 fatalField investigationFinal reportCessna 207A · Matinicus Island, METhe pilot’s failure to maintain airplane control during the approach after encountering a gusty crosswind, which resulted in an accelerated stall and uncontrolled descent.Oct 5, 2011 · N70437 · Substantial damageNTSB ERA12FA006Accident · 1 fatalField investigationFinal reportHarry L. Weber Arion LI · Hedgesville, WVAn aerodynamic stall at low altitude due to the pilot’s acute cardiac event.Oct 5, 2011 · N747HW · Substantial damageNTSB CEN12LA008Accident · Serious injuriesLimited investigationFinal reportJohnston William Alfred JR Kolb Mark III · Versailles, MOA loss of engine power due to adjustments and modifications that the pilot made to the engine and airplane.Oct 5, 2011 · N9144E · Substantial damageNTSB CEN12LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Centerburg, OHThe pilot's improper pre-flight planning and failure to ensure that there was an adequate fuel supply on board to complete the flight, which resulted in fuel exhaustion. Contributing to the accident was the malfunction of the fuel quantity indicator.Oct 5, 2011 · N6403A · Substantial damageNTSB WPR12FA001Accident · 2 fatalField investigationFinal reportVaughn Pulsar · West Jordan, UTThe pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…Oct 4, 2011 · N91BV · Substantial damageNTSB ERA12MA005Accident · 2 fatalMajor investigationFinal reportBell 206B · New York, NYThe pilot's failure to anticipate and correct for conditions (high gross weight, low indicated airspeed, and a right downwind turn) conducive to loss of tail rotor effectiveness (LTE), which resulted in LTE and an uncontrolled spin. Contributing to the…Oct 4, 2011 · N63Q · Substantial damageNTSB ERA12CA003Accident · Serious injuriesData collectionFinal reportAir Tractor AT-502B · Fort Pierce, FLThe pilot's delayed decision to abort the takeoff.Oct 4, 2011 · N90805 · Substantial damageNTSB CEN12TA004Accident · Minor injuriesFinal reportEurocopter EC120B · McAllen, TXThe pilot's improper use of the collective while landing, which resulted in an unrecoverable forward pitching moment. Contributing to the accident was the pilot's improper decision not to go-around.Oct 4, 2011 · N3925A · Substantial damageNTSB CEN12CA009Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hibbing, MNThe private pilot's failure to maintain control of the helicopter during the landing flare.Oct 4, 2011 · N4170M · Substantial damageNTSB ERA12FA012Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Peru, WVThe non-instrument rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent in-flight collision with mountainous terrain.Oct 3, 2011 · N115CL · Substantial damageNTSB ERA12CA013Accident · Minor injuriesData collectionFinal reportLoehle Loehle P-40 · Tullahoma, TNThe pilot's delayed decision to abort the takeoff.Oct 3, 2011 · N414L · Substantial damageNTSB ERA12FA002Accident · 1 fatalField investigationFinal reportTemco GC-1B · Ewell, MDThe pilot's improper fuel management in that he did not verify the fuel selector position before beginning the flight or after the power loss, which resulted in a total loss of engine power due to fuel starvation and subsequent ditching.Oct 2, 2011 · N3825K · Substantial damageNTSB ERA12CA004Accident · No injuriesData collectionFinal reportCessna 182P · Lincoln Park, NJThe pilot's improper landing flare.Oct 2, 2011 · N1835M · Substantial damage