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 OPS18IA003IncidentClass 3 · IncidentFinal reportBombardier CL600 2D24 · Medford, ORThe incident was caused by the air traffic controller assigning an altitude below the published procedure altitude for the approach segment to be flown prior to the aircraft being established on a published portion of the approach. Contributing to the…Dec 25, 2017 · N162PQ · No damageNTSB CEN18LA052Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Riverton, WYThe pilot's loss of directional control during the rejected takeoff. Contributing to the accident were the pilot's lack of familiarity with the airport runway configuration, which led to his premature attempt to take off, and the airplane’s inoperative…Dec 25, 2017 · N550D · Substantial damageNTSB ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.Dec 24, 2017 · N91SP · Substantial damageNTSB CEN18FA061Accident · 5 fatalField investigationFinal reportCessna 340 · Bartow, FLThe pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.Dec 24, 2017 · N247AT · DestroyedNTSB WPR18LA055Accident · Minor injuriesClass 3 · LimitedFinal reportKelley Derrick/Leza Aircam · Newport, ORThe pilot’s failure to maintain airplane control while on final approach for landing in crosswind conditions, which resulted in a collision with trees.Dec 23, 2017 · N959M · Substantial damageNTSB GAA18CA093Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot’s failure to maintain directional control during the landing flare.Dec 23, 2017 · N389BA · Substantial damageNTSB CEN18FA060Accident · 1 fatalField investigationFinal reportX-Air XA85 · Oskaloosa, IAThe pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.Dec 23, 2017 · N20XA · Substantial damageNTSB ERA18LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Venice, FLA failure of the normal landing gear extension system for reasons that could not be determined due to damage to the system and the pilot's failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the…Dec 22, 2017 · N5254G · Substantial damageNTSB WPR18FA053Accident · 1 fatalField investigationFinal reportBrowning Gregory S Zodiac 601XL · Thompson's Station, TNThe sport pilot's decision to depart in and continue flight in instrument meteorological conditions, which resulted in controlled flight into terrain.Dec 21, 2017 · N929GB · Substantial damageNTSB GAA18CA097Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, MIThe student pilot’s improper yaw control during the landing flare and the flight instructor’s failure to take remedial action, which resulted in a hard landing.Dec 21, 2017 · N4491R · Substantial damageNTSB ERA18FA056Accident · 1 fatalField investigationFinal reportBeech G35 · Cross City, FLThe pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control.Dec 21, 2017 · N354WD · DestroyedNTSB GAA18CA092Accident · Minor injuriesData collectionFinal reportPiper PA28 · Mankato, MNThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent go-around during which the student exceeded the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Dec 20, 2017 · N284MK · Substantial damageNTSB CEN18LA071Accident · No injuriesLimited investigationFinal reportPiper PA 12 · Angleton, TXThe passenger's inadvertent activation of the left brake during landing, which resulted in a loss of directional control and a runway excursion.Dec 20, 2017 · N47FP · Substantial damageNTSB CEN18LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Longmont, COThe failure of the landing gear through bolt primarily due to fatigue during a hard landing, which resulted in a landing gear collapse and runway excursion. Contributing to the accident was noncompliance with the manufacturer service letter.Dec 20, 2017 · N519MA · Substantial damageNTSB GAA18CA091Accident · No injuriesData collectionFinal reportAviat A-1 · Phoenix, AZThe pilot’s failure to maintain directional control of the airplane during the landing.Dec 19, 2017 · N33HY · Substantial damageNTSB ERA18LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ridgeland, SCThe student pilot’s improper control inputs, which resulted in a loss of control on takeoff. Contributing to the accident was the flight instructor’s inadequate remedial action.Dec 19, 2017 · N3179T · Substantial damageNTSB ANC18LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA 23-250 · Knoxville, TNThe flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel…Dec 19, 2017 · N40285 · Substantial damageNTSB GAA18CA090Accident · No injuriesData collectionFinal reportPiper PA22 · Yentna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and subsequent nose-over.Dec 18, 2017 · N4805Z · Substantial damageNTSB GAA18CA087Accident · No injuriesData collectionFinal reportMaule MX7 · Willow, AKThe pilot’s failure to see and avoid another airplane stopped on the taxiway while taxiing in sun glare conditions.Dec 18, 2017 · N61SR · 2 aircraft · Substantial damageNTSB DCA18CA049Accident · Serious injuriesData collectionFinal reportEmbraer S A ERJ170-200LR · Saint Louis, MOthe abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle.Dec 18, 2017 · N128SY · No damageNTSB CEN18FA054Accident · 2 fatalField investigationFinal reportPiper PA28 · Reeds Spring, MOThe noninstrument-rated pilot's inadequate pre-flight planning and in-flight decision-making, which resulted in flight into known instrument meteorological conditions and the subsequent collision with terrain.Dec 18, 2017 · N6433J · DestroyedNTSB CEN18CA058Accident · No injuriesData collectionFinal reportPiaggio P.180 · Georgetown, TXThe pilot's inadequate compensation for crosswind conditions, which resulted in a hard landing and the right main landing gear collapsing.Dec 18, 2017 · N141JT · Substantial damageNTSB GAA18CA105Accident · No injuriesData collectionFinal reportGolden Circle Air T Bird II · Wiscassett, METhe pilot’s failure to maintain directional control during the takeoff roll.Dec 17, 2017 · N5619Z · Substantial damageNTSB GAA18CA086Accident · No injuriesData collectionFinal reportHalley KFT Apollo · North Las Vegas, NVThe pilot’s failure to stop the main rotor rotation before taxiing the gyroplane in gusting wind conditions, resulting in the main rotor striking the empennage.Dec 17, 2017 · N15LU · Substantial damageNTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…Dec 17, 2017 · N761YZ · DestroyedNTSB ERA18LA055Accident · No injuriesLimited investigationFinal reportCessna 182 · Burlington, NCThe pilot's failure to maintain adequate clearance from another airplane before beginning an inverted flight maneuver, which resulted in a collision with the airplane when he rolled his airplane upright.Dec 16, 2017 · N199RN · 2 aircraft · Substantial damageNTSB ERA18LA048Accident · 1 fatalLimited investigationFinal reportCessna 150 · Castalia, NCThe pilot's exceedance of the airplane's critical angle of attack while performing a turning takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's decision to attempt the takeoff, which he believed…Dec 16, 2017 · N7929Z · Substantial damageNTSB ERA18LA053Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S76 · Islamorada, FLThe pilot's activation of the rotor brake while the No. 2 engine was still set to govern the power turbine speed, which resulted in continuous power being applied to the rotor while the rotor brake was engaged and led to excessive friction, heat, and a…Dec 15, 2017 · N911FK · Substantial damageNTSB WPR18CA048Accident · Serious injuriesData collectionFinal reportCessna 172P · Valley Springs, CAThe pilot's failure to maintain clearance from trees while maneuvering for landing and his decision to land on a surface with obstructions.Dec 14, 2017 · N54873 · Substantial damageNTSB GAA18CA088Accident · No injuriesData collectionFinal reportPiper PA 32R · Kwigillingok, AKThe pilot’s decision to land with the sun in his eyes, which resulted in a short landing.Dec 14, 2017 · N8209C · Substantial damageNTSB GAA18CA089Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Newark, OHThe pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in dynamic rollover.Dec 13, 2017 · N441ML · Substantial damageNTSB ERA18LA062Accident · No injuriesLimited investigationFinal reportPiper PA32 · Oakland Park, FLThe loss of engine power for reasons that could not be determined based on the available evidence.Dec 13, 2017 · C6RVT · Substantial damageNTSB GAA18CA084Accident · No injuriesData collectionFinal reportCorbeil Shawn Corbeil Shawn SER VI · Rogersburg, ORThe pilot’s improper landing flare and his subsequent failure to see and avoid a tree during a go-around.Dec 12, 2017 · N552EZ · Substantial damageNTSB DCA18CA042Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD 88 · Detroit, MIfailure of the flight crew to confirm the left engine throttle lever was at idle during engine start.Dec 12, 2017 · N924DL · Substantial damageNTSB CEN18FA050Accident · 1 fatalField investigationFinal reportSmith Aerostar 601 · Miami, FLThe pilot's loss of control while returning to the airport after takeoff for reasons that could not be determined based on the available information.Dec 10, 2017 · N7529S · DestroyedNTSB ANC18FA012Accident · 2 fatalField investigationFinal reportCessna U206 · Maunaloa, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions while conducting an instrument approach, which resulted in a loss of visual reference and subsequent controlled flight into terrain.Dec 10, 2017 · N732DF · DestroyedNTSB GAA18CA083Accident · No injuriesData collectionFinal reportMichael Adamczyk Zenith CH750 · Franklin, PAThe pilot’s excessive application of aft stick during takeoff, which resulted in an aerodynamic stall. Contributing to this accident was the pilot’s inexperience in the airplane.Dec 9, 2017 · N750AD · Substantial damageNTSB GAA18CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Pocasset, OKThe pilot’s improper approach path, which resulted in the airplane landing short of the runway.Dec 9, 2017 · N8856W · Substantial damageNTSB GAA18CA077Accident · No injuriesData collectionFinal reportCzech Sport Aircraft a.s. Sport Cruiser · Sacramento, CAThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.Dec 9, 2017 · N227US · DestroyedNTSB WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…Dec 8, 2017 · N19LW · DestroyedNTSB GAA18CA078Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.Dec 8, 2017 · N4801D · Substantial damageNTSB GAA18CA075Accident · Minor injuriesData collectionFinal reportJones Kent C Vans RV-10 · Limon, COThe pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing.Dec 8, 2017 · N9738J · Substantial damageNTSB GAA18CA073Accident · No injuriesData collectionFinal reportBrock Steiner Sport Copter Vortex · Spanish Fork, UTThe pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.Dec 8, 2017 · N395SC · Substantial damageNTSB ERA18FA046Accident · 5 fatalField investigationFinal reportBeech 58 · St. CroixThe non-multiengine rated pilot's failure to maintain airplane control during a single-engine approach. Contributing to the accident was a total loss of engine power on the left engine due to detonation for reasons that could not be determined based on the…Dec 8, 2017 · N4494A · DestroyedNTSB GAA18CA070Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Santa Rosa, AZThe pilot’s improper landing flare, which resulted in a hard landing.Dec 6, 2017 · N790AM · Substantial damageNTSB CEN18FA049Accident · 1 fatalField investigationFinal reportRaytheon B36TC · Chesterfield, MOThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 6, 2017 · N679EA · DestroyedNTSB WPR18LA044Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-200T · Glendale, AZThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the fatigue of the left main landing gear assembly.Dec 5, 2017 · N47536 · Substantial damageNTSB GAA18CA081Accident · No injuriesData collectionFinal reportPiper PA 32 · Cheboygan, MIThe pilot’s failure to maintain the airplane’s rate of descent in gusting wind conditions resulting in a hard landing and runway excursion.Dec 5, 2017 · N4887S · Substantial damageNTSB GAA18CA072Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Fort Pierce, FLThe pilot’s improper landing flare, which resulted in a tail strike and hard landing.Dec 5, 2017 · N99RW · Substantial damageNTSB GAA18CA068Accident · No injuriesData collectionFinal reportNorth American T 6 · Chesapeake, VAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and nose over.Dec 5, 2017 · N2996Q · Substantial damage