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 CEN17FA100Accident · 1 fatalField investigationFinal reportBell 206B · Galveston, TXThe pilot's failure to recognize the flight had encountered instrument meteorological conditions at night, which resulted in an unrecognized descent and collision with water.Feb 7, 2017 · N978RH · DestroyedNTSB GAA17CA150Accident · No injuriesData collectionFinal reportBeech F90 · Poplar Bluff, MOThe pilot’s descent below the minimum descent altitude during a nonprecision approach, which resulted in a tree strike.Feb 6, 2017 · N246CA · Substantial damageNTSB ERA17CA101Accident · No injuriesData collectionFinal reportRobinson R22 · West Palm Beach, FLThe flight instructor’s failure to maintain helicopter control while demonstrating low rotor rpm operations from a hover.Feb 6, 2017 · N7685H · Substantial damageNTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.Feb 5, 2017 · N4853U · Substantial damageNTSB ERA17CA099Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Fallston, MDThe student pilot's failure to relinquish the flight controls to the flight instructor, which resulted in a collision with terrain.Feb 4, 2017 · N7518G · Substantial damageNTSB GAA17CA169Accident · No injuriesData collectionFinal reportCessna 152 · Bonifay, FLThe student pilot's failure to maintain directional control during landing in crosswind conditions.Feb 3, 2017 · N6318M · Substantial damageNTSB CEN17LA101Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Ellendale, MNThe pilot’s incapacitation from carbon monoxide poisoning in flight due to cracks in the exhaust muffler, which resulted in the airplane’s continued flight until it ran out of fuel and its subsequent collision with terrain.Feb 3, 2017 · N9149V · Substantial damageNTSB GAA17CA132Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206 · Carson City, NVThe pilot-in-command’s delayed remedial action to arrest the right yaw after the bounced landing while operating in a flight regime conducive to the loss of tail rotor effectiveness, which resulted in a roll-over.Feb 2, 2017 · N519EH · Substantial damageNTSB WPR17LA059Accident · Minor injuriesLimited investigationFinal reportBeech E 55 · Bakersfield, CAThe pilot’s failure to select the proper fuel boost pump setting for the left auxiliary fuel pump, which allowed for an excessive fuel flow to the left engine, which resulted in a total loss of engine power and airplane control during an attempted go-around.Feb 1, 2017 · N711YK · Substantial damageNTSB GAA17CA130Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Armstrong, TXThe pilot’s failure to remove the left helicopter skid tie-down before takeoff, which resulted in dynamic roll-over.Jan 31, 2017 · N883KC · Substantial damageNTSB CEN17FA095Accident · 1 fatalField investigationFinal reportCessna 177 · Price, TXThe pilot's failure to maintain clearance from a communications tower guy-wire. Contributing to the accident was the pilot's decision to conduct a long distance transition flight at a low altitude.Jan 31, 2017 · N2810X · DestroyedNTSB GAA17CA134Accident · No injuriesData collectionFinal reportCessna 180 · Tyonek, AKThe pilot’s improper decision to land on a snow-covered airstrip with a tundra tire-equipped airplane, which resulted in a nose-over.Jan 30, 2017 · N5222E · Substantial damageNTSB ERA17LA098Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Pottsville, PAA total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.Jan 30, 2017 · N4796P · Substantial damageNTSB GAA17CA128Accident · No injuriesData collectionFinal reportCessna 210 · Charleston, WVThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard landing and runway excursion.Jan 28, 2017 · N59196 · Substantial damageNTSB GAA17CA127Accident · No injuriesData collectionFinal reportVaughan Gerald R Side Winder TD · McCook, NEThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Jan 28, 2017 · N60JV · Substantial damageNTSB GAA17CA125Accident · No injuriesData collectionFinal reportGreat Lakes 2T1A · Canon City, COThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s unstabilized approach.Jan 28, 2017 · N16GL · Substantial damageNTSB CEN17LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Butterfield, TXA malfunction of the fuel transfer system for reasons that could not be determined based on the available information, a stuck float in the header tank sight gauge that resulted in an inaccurate fuel quantity indication, and the pilot’s inadequate monitoring…Jan 28, 2017 · N94694 · Substantial damageNTSB ERA17LA096Accident · No injuriesLimited investigationFinal reportBeech 200 · West Palm Beach, FLThe pilot's failure to ensure that the landing gear were down and locked before touchdown. Contributing to the accident was the pilot’s self-reported fatigue at the time of the accident.Jan 27, 2017 · N60RA · Substantial damageNTSB CEN17IA094Incident · No injuriesClass 2 · IncidentFinal reportEurocopter Deutschland MBB BK 117 C-2 · Sioux Falls, SDThe gas generator rear bearing oil scavenge line blocked with coke, which resulted in a failed rear bearing due to an excess of oil lubrication. Contributing to the incident was the operator not completely performing the maintenance items and not utilizing an…Jan 27, 2017 · N911MK · Minor damageNTSB GAA17CA129Accident · No injuriesData collectionFinal reportCessna 182 · Midland, TXThe student pilot's improper landing flare, which resulted in a bounced landing.Jan 26, 2017 · N38EE · Substantial damageNTSB GAA17CA126Accident · No injuriesData collectionFinal reportPiper PA32R · Fort Mohave, AZThe pilot's failure to extend the landing gear for landing.Jan 26, 2017 · N6885F · Substantial damageNTSB ERA17LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Clearwater, FLThe pilot's improper landing flare, which resulted in damage to the engine firewall.Jan 26, 2017 · N2382R · Substantial damageNTSB CEN17LA097Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Ozark, MOThe pilot's failure to adequately monitor the environment and to maintain sufficient altitude to clear power lines.Jan 26, 2017 · N4213B · Substantial damageNTSB CEN17FA085Accident · 1 fatalField investigationFinal reportCessna 172 · Jay, OKThe pilot's negligent maintenance of the airplane, which resulted in improper fuel management, fuel starvation, and a loss of engine power during takeoff due to a missing securing pin in the fuel selector handle, and a subsequent forced landing on unsuitable…Jan 25, 2017 · N5639A · Substantial damageNTSB CEN17FA084Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · San Antonio, TXThe pilot's uncoordinated flight control inputs and subsequent inadvertent cross-control aerodynamic stall in the airport traffic pattern that resulted in a loss of control and uncontrolled descent with insufficient altitude for recovery.Jan 25, 2017 · N401SC · DestroyedNTSB GAA17CA123Accident · No injuriesData collectionFinal reportPiper PA 28R · Wichita, KSThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.Jan 24, 2017 · N4792T · Substantial damageNTSB CEN17LA188Accident · No injuriesLimited investigationFinal reportBell 407 · Fort Worth, TXThe flight instructor's failure to prevent the engine/rotor overspeed condition during the demonstration maneuver and the excessive descent rate during the emergency landing, which resulted in a hard landing. Contributing to the engine/rotor overspeed…Jan 24, 2017 · N6040Y · Substantial damageNTSB CEN17LA123Accident · No injuriesLimited investigationFinal reportBeech C 99 · Durango, COThe pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.Jan 24, 2017 · N216CS · Substantial damageNTSB WPR17FA057Accident · 2 fatalField investigationFinal reportBeech 300 · Tucson, AZThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.Jan 23, 2017 · N385KA · DestroyedNTSB GAA17CA121Accident · No injuriesData collectionFinal reportCessna 150 · Denton, TXThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jan 23, 2017 · N3545L · Substantial damageNTSB GAA17CA133Accident · No injuriesData collectionFinal reportCessna 182 · Sebring, OHThe pilot’s failure to maintain the proper glidepath during landing, which resulted in the airplane landing short of the runway, the nose landing gear separating, and the airplane nosing over during a second landing.Jan 22, 2017 · N3828D · Substantial damageNTSB ERA17LA092Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Beechcraft G36 · West Caldwell, NJThe pilot’s failure to maintain airplane control after takeoff, which resulted in an aerodynamic stall.Jan 21, 2017 · N979BA · DestroyedNTSB CEN17FA080Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Wellington, TXThe pilot's improper decision to perform a steep turn at low altitude, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.Jan 21, 2017 · N91Z · DestroyedNTSB GAA17CA112Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Champaign, ILThe flight instructor’s failure to arrest the descent rate during the practice autorotation, which resulted in a hard landing.Jan 18, 2017 · N8042B · Substantial damageNTSB WPR17LA054Accident · 1 fatalLimited investigationFinal reportJohnson Harmon Rocket · Corona, CAA total loss of engine power during takeoff due to fuel starvation as a result of a failure of internal components of the fuel servo.Jan 17, 2017 · N275JS · Substantial damageNTSB GAA17CA118Accident · No injuriesData collectionFinal reportCessna 140 · Markleeville, CAThe pilot’s failure to maintain altitude during a low pass and the subsequent impact with a snow berm, which resulted in a nosed-over.Jan 17, 2017 · N5623C · Substantial damageNTSB GAA17CA117Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Vernon, UTThe pilot’s failure to maintain clearance from mountainous terrain.Jan 17, 2017 · N20361 · Substantial damageNTSB ERA17LA091Accident · Serious injuriesLimited investigationFinal reportAmerican Legend AL3 · Pierson, FLThe pilot's improper braking during takeoff, which resulted in a nose-over.Jan 17, 2017 · N841ML · Substantial damageNTSB ANC17TA015Accident · Serious injuriesFinal reportPiper PA-32 · Pilot Point, AKThe pilot's continued flight into known icing conditions, which resulted in structural icing and a forced landing on icy, snow-covered terrain.Jan 17, 2017 · N4261T · Substantial damageNTSB GAA17CA115Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Bainbridge, GAThe student pilot's exceedance of the airplane’s critical angle of attack during final approach, which resulted in an aerodynamic stall, and his subsequent loss of directional control after touchdown.Jan 16, 2017 · N2540F · Substantial damageNTSB CEN17LA078Accident · Serious injuriesLimited investigationFinal reportTextron 525C · Howell, MIThe pilot's attempted landing on the ice-covered runway, which resulted in a runway excursion and impact with terrain. Contributing to the accident was airport personnel's lack of training regarding issuance of NOTAMsJan 16, 2017 · N525PZ · Substantial damageNTSB GAA17CA113Accident · No injuriesData collectionFinal reportAeronca 7AC · Compton, CAThe pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.Jan 15, 2017 · N1659E · Substantial damageNTSB WPR17LA053Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Buckeye, AZThe pilot's failure to maintain directional control of the airplane during the landing roll.Jan 14, 2017 · N6366B · Substantial damageNTSB GAA17CA116Accident · No injuriesData collectionFinal reportCessna 170 · Coeur D'Alene, IDThe pilot’s failure to maintain an appropriate descent rate during approach, which resulted in landing short of the runway threshold.Jan 14, 2017 · N3210A · Substantial damageNTSB GAA17CA114Accident · No injuriesData collectionFinal reportBeech B200 · Coalinga, CAThe pilot’s failure to maintain directional control during takeoff.Jan 14, 2017 · N795DE · Substantial damageNTSB ERA17FA088Accident · 1 fatalField investigationFinal reportSharpe William L Buccaneer II B · Mayo, FLThe pilot's failure to see and avoid power lines while flying at low altitude.Jan 14, 2017 · N696FT · Substantial damageNTSB ERA17CA089Accident · Minor injuriesData collectionFinal reportCessna 182 · Mobile, ALThe pilot’s failure to maintain airplane control during the initial climb.Jan 14, 2017 · N707RB · Substantial damageNTSB WPR17FA052Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Port Orford, ORThe pilot's loss of vision during cruise flight, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to fly with a known medical condition.Jan 13, 2017 · N81839 · Substantial damageNTSB WPR17FA055Accident · 1 fatalField investigationFinal reportMooney M20J · Lake Hughes, CAThe pilot's controlled flight into mountainous terrain while attempting to operate under visual flight rules in instrument meteorological conditions (IMC).Jan 12, 2017 · N6201N · Substantial damageNTSB GAA17CA122Accident · No injuriesData collectionFinal reportCessna 172 · Punta Gorda, FLThe student pilot’s failure to maintain proper pitch control, which resulted in a hard, bounced landing.Jan 12, 2017 · N10897 · Substantial damage