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 WPR12CA257Accident · No injuriesData collectionFinal reportCessna 182A · Colfax, WAThe total loss of engine power during cruise flight due to the missing carburetor drain plug, which had not been secured with safety wire.Jun 11, 2012 · N4715D · Substantial damageNTSB ERA12CA393Accident · No injuriesData collectionFinal reportNorth American AT-6C · Delmar, DEThe pilot's failure to go around after not attaining the proper touchdown point, which resulted in a runway excursion and noseover.Jun 11, 2012 · N7055K · Substantial damageNTSB CEN12CA356Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Indianapolis, INThe student pilot’s failure to maintain control of the airplane during takeoff.Jun 11, 2012 · N902LA · Substantial damageNTSB ERA12CA389Accident · Serious injuriesData collectionFinal reportBuckeye Breeze · Lower Burrell, PAThe pilot’s failure to maintain directional control of the powered parachute, which resulted in a collision with trees during final approach. Contributing to the accident was the pilot's lack of flight training.Jun 10, 2012 · N786DS · Substantial damageNTSB CEN12LA359Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Teresa, NMThe sudden decrease in headwind during takeoff in a gusty wind and near a passing train, which resulted in a loss of lift and main rotor rpm. Contributing to the accident was the pilot's decision to operate the helicopter near its maximum performance…Jun 10, 2012 · N744JS · Substantial damageNTSB CEN12CA361Accident · No injuriesData collectionFinal reportCessna 172H · Moscow Mills, MOThe pilot's failure to maintain control of the airplane during takeoff in a gusty crosswind, which resulted in a runway excursion.Jun 10, 2012 · N3736R · Substantial damageNTSB WPR12LA285Accident · No injuriesLimited investigationFinal reportSchweizer SGS233 · Truckee, CAThe pilot's failure to maintain control of the glider while taking off with a gusting wind, which resulted in the glider impacting a runway sign.Jun 9, 2012 · N2061T · Substantial damageNTSB WPR12FA255Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Mountain Home, IDThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.Jun 9, 2012 · N8990N · Substantial damageNTSB WPR12CA254Accident · No injuriesData collectionFinal reportCessna 162 · Santa Ana, CAThe pilot’s failure to compensate for the gusting wind and failure to maintain airplane control during the approach to land.Jun 9, 2012 · N5211Y · Substantial damageNTSB ERA12FA387Accident · 1 fatalField investigationFinal reportPhillips William L Challenger · Plant City, FLThe non-certificated pilot’s loss of control during approach and landing. Contributing to the accident was the pilot’s lack of both total and recent flight experience.Jun 9, 2012 · N2571T · Substantial damageNTSB ERA12CA403Accident · No injuriesData collectionFinal reportLuscombe 8E · Selinsgrove, PAThe pilot's failure to maintain airplane control during the takeoff.Jun 9, 2012 · N2052K · Substantial damageNTSB ERA12CA402Accident · No injuriesData collectionFinal reportAeronca 7AC · Blairs, VAThe pilot's failure to maintain directional control during a takeoff into sun glare.Jun 9, 2012 · N2067 · Substantial damageNTSB ERA12CA390Accident · No injuriesData collectionFinal reportCessna 150H · Alabaster, ALThe pilot's failure to maintain directional control while landing in gusting wind conditions.Jun 9, 2012 · N6963S · Substantial damageNTSB CEN12CA360Accident · No injuriesData collectionFinal reportBirchler Boyd Eagle 540 · Kokomo, INThe pilot's failure to maintain adequate clearance from the trees during a low-level aerobatic maneuver.Jun 9, 2012 · N34BJ · Substantial damageNTSB CEN12CA355Accident · Minor injuriesData collectionFinal reportRyan Navion · Rockville, INThe pilot’s failure to attain the proper touchdown point during landing, which resulted in a runway overrun.Jun 9, 2012 · N4943K · Substantial damageNTSB ERA12LA386Accident · 1 fatalLimited investigationFinal reportBowen Christopher W Dogbee · Wrens, GAThe pilot’s loss of control during a low-altitude maneuver for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision…Jun 8, 2012 · N1481 · Substantial damageNTSB ERA12CA415Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Smyrna, TNThe pilot's inadequate landing flare, which resulted in a hard landing.Jun 8, 2012 · N232E · Substantial damageNTSB CEN12LA369Accident · No injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Norwalk, OHThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.Jun 8, 2012 · N721R · Substantial damageNTSB CEN12CA392Accident · No injuriesData collectionFinal reportCessna P210N · Detroit, MIThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jun 8, 2012 · N7588K · Substantial damageNTSB WPR12LA250Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Sparks, NVThe failure of both pilots to see and avoid each other, which resulted in a midair collision.Jun 7, 2012 · N943SB · 2 aircraft · Substantial damageNTSB ERA12FA385Accident · 6 fatalField investigationFinal reportPilatus PC-12/47 · Lake Wales, FLThe failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…Jun 7, 2012 · N950KA · Substantial damageNTSB CEN12LA346Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Clark, SDThe pilot’s improper fuel management, which led to fuel exhaustion, and his failure to maintain adequate airspeed resulting in an aerodynamic stall.Jun 7, 2012 · N18012 · Substantial damageNTSB CEN12LA345Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe first officer’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the final approach in known low-level windshear conditions, which resulted in an aerodynamic stall. Contributing to the accident…Jun 7, 2012 · N500SW · Substantial damageNTSB CEN12CA347Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Sellersburg, INThe balloon pilot’s failure to maintain clearance from power lines.Jun 7, 2012 · N401DJ · Minor damageNTSB ANC12CA049Accident · No injuriesData collectionFinal reportCessna U206G · Homer, AKThe pilot's selection of unsuitable terrain for landing.Jun 7, 2012 · N9049G · Substantial damageNTSB ANC12CA048Accident · No injuriesData collectionFinal reportCessna 207A · Platinum, AKThe pilot inadvertently taxied the airplane into a ditch.Jun 7, 2012 · N9874M · Substantial damageNTSB CEN12LA373Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Gardner, KSThe pilot's delay in aborting the takeoff when the airplane was not accelerating as expected. Contributing to the accident was a wind shift during takeoff.Jun 6, 2012 · N334Z · Substantial damageNTSB CEN12LA348Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Bangor, MIThe pilot’s failure to properly service the fuel system, and subsequent decision to conduct the flight with known fuel system deficiencies, which led to the total loss of engine power.Jun 6, 2012 · N3431A · Substantial damageNTSB CEN12CA363Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · New Douglas, ILThe pilot’s improper landing flare and inadequate recovery from a bounced landing.Jun 6, 2012 · N400HK · Substantial damageNTSB WPR12LA261Accident · No injuriesLimited investigationFinal reportPiper PA46R-350T · Cameron Park, CAThe fatigue failure of the nose landing gear actuator attach foot during the landing roll. Contributing to the accident was the non-compliance with the manufacturer’s service bulletin.Jun 5, 2012 · N488EA · Substantial damageNTSB CEN12LA340Accident · 1 fatalLimited investigationFinal reportQuicksilver Sport II · Manchester, IAAn inadvertent aerodynamic stall while maneuvering at a low altitude.Jun 5, 2012 · N4396H · Substantial damageNTSB WPR12LA244Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Pasco, WAThe pilot's failure to maintain the helicopter's rotor rpm while maneuvering at a low altitude over a fruit orchard.Jun 4, 2012 · N93467 · Substantial damageNTSB CEN12LA344Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Kenmare, NDThe pilot's failure to maintain directional control during an aborted takeoff.Jun 4, 2012 · N4547Q · Substantial damageNTSB CEN12LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Put-in-Bay, OHThe pilot's failure to attain a proper touchdown point at the proper speed, his failure to initiate a go-around, and the airplane’s inadequate climb gradient after the aborted landing, which resulted in impact with the trees.Jun 4, 2012 · N2434M · Substantial damageNTSB CEN12LA336Accident · 1 fatalLimited investigationFinal reportBellanca 8GCBC · Zahl, NDThe non-certificated pilot's improper preflight planning, which resulted in fuel exhaustion, and his failure to maintain airplane control after a total loss of engine power.Jun 4, 2012 · N88095 · Substantial damageNTSB CEN12CA341Accident · No injuriesData collectionFinal reportCessna 170A · Houston, TXThe pilot’s failure to maintain directional control of the airplane during landing.Jun 4, 2012 · N9753A · Substantial damageNTSB WPR12GA243Accident · 2 fatalFinal reportLockheed P2V-7 · Modena, UTThe flight crew's misjudgment of terrain clearance while maneuvering for an aerial application run, which resulted in controlled flight into terrain. Contributing to the accident was the flight crew's failure to follow the lead airplane's track and to…Jun 3, 2012 · N14447 · Substantial damageNTSB WPR12CA242Accident · No injuriesData collectionFinal reportGrumman G-164A · Riverton, WYThe pilot's loss of directional control during the landing roll and his deliberate application of excessive braking pressure, which resulted in a noseover.Jun 3, 2012 · N5291 · Substantial damageNTSB ANC12CA050Accident · No injuriesData collectionFinal reportWalls Craig C Snowyriver Special · Chugiak, AKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.Jun 3, 2012 · N207CW · Substantial damageNTSB ANC12CA045Accident · No injuriesData collectionFinal reportCessna 150G · Ketchikan, AKThe pilot’s decision to take off with a quartering tailwind, which resulted in a loss of control.Jun 3, 2012 · N3235J · Substantial damageNTSB WPR12CA245Accident · No injuriesData collectionFinal reportCessna 180 · Wenatchee, WAThe pilot's failure to maintain directional control during takeoff in a crosswind condition.Jun 2, 2012 · N3184D · Substantial damageNTSB ERA12LA380Accident · Minor injuriesLimited investigationFinal reportPittman Eddie G CGS Hawk Arrow II · Monroe, VAThe pilot’s improper preflight planning and inflight fuel management, which resulted in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s unfamiliarity with the airplane’s systems.Jun 2, 2012 · N443EP · Substantial damageNTSB CEN12LA343Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Denver, COThe inadequately overhauled landing gear dampers that allowed initiation of a ground resonance event from which the pilot was unable to recover. Contributing to the accident was the overhaul facility's failure to identify the overcharged dampers and a lack of…Jun 2, 2012 · N2196F · Substantial damageNTSB ANC12LA046Accident · No injuriesLimited investigationFinal reportCessna A185F · Skwentna, AKThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power in cruise flight. Contributing to the accident was the pilot's failure to follow the checklist after the loss of engine power.Jun 2, 2012 · N1795R · Substantial damageNTSB WPR12LA241Accident · 1 fatalLimited investigationFinal reportWestcott Prowler Jaguar · Salinas, CAThe pilot's inability to maintain airplane control during takeoff due to an incapacitating cardiac event.Jun 1, 2012 · N125CW · DestroyedNTSB ERA12LA373Accident · Minor injuriesLimited investigationFinal reportFaltin John R Rotorway Exec 162F · Smoketown, PAA loss of control during a post-maintenance test flight due to improper tracking of the helicopter’s main rotor blades by the pilot/aircraft builder.May 31, 2012 · N8707E · Substantial damageNTSB ERA12FA376Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Macon, MSThe pilot's decision to continue flight into an area of known thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the pilot's lack of experience in actual instrument meteorological conditions and his reliance on datalink…May 31, 2012 · N976S · Substantial damageNTSB ERA12CA377Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1B · Lawrence, MAThe pilot's delayed decision to abort the takeoff, which resulted in a runway excursion.May 31, 2012 · N1608R · Substantial damageNTSB ERA12CA375Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor’s inadequate supervision and delayed remedial action during a simulated engine-out procedure, which resulted in a hard landing.May 31, 2012 · N1803R · Substantial damageNTSB CEN12LA333Accident · Serious injuriesLimited investigationFinal reportWalters RV-8 · Hutchinson, MNThe pilot's failure to maintain proper airspeed during the landing attempt, his failure to maintain directional control, and his delayed attempted aborted landing at an airspeed that was too low, which resulted in an aerodynamic stall.May 31, 2012 · N808WW · Substantial damage