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 GAA17CA149Accident · No injuriesData collectionFinal reportPiper PA28 · Palm Coast, FLThe pilot’s failure to maintain clearance from the taxiway sign.Dec 13, 2016 · N3563K · Substantial damageNTSB WPR17LA036Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210M · Mecca, CAThe total loss of engine power due to fuel starvation during approach, which necessitated a gear-up landing on unsuitable terrain.Dec 12, 2016 · N761SZ · Substantial damageNTSB WPR17FA035Accident · 1 fatalField investigationFinal reportQuest Kodiak 100 · Moab, UTThe pilot's loss of control shortly after takeoff due to spatial disorientation.Dec 12, 2016 · N772RT · DestroyedNTSB ERA17CA068Accident · Minor injuriesData collectionFinal reportBeech A36 · New Smyrna Beach, FLThe pilot's inappropriate response to an emergency exit window opening in flight, which resulted in a loss of control, precautionary off-airport landing, and subsequent impact with trees. Contributing to the accident was the pilot's improper repair of the…Dec 12, 2016 · N776WM · Substantial damageNTSB WPR17LA037Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 24 · Anacortes, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and separation of the left main landing gear.Dec 11, 2016 · N7998L · Substantial damageNTSB GAA17CA097Accident · No injuriesData collectionFinal reportCessna 195 · Jacksonville, FLThe other pilot’s failure to see and avoid the stationary airplane during taxi.Dec 11, 2016 · N195PC · 2 aircraft · Substantial damageNTSB ERA17LA067Accident · Serious injuriesLimited investigationFinal reportMathias Linda B Lightning · Franklin, VAA partial loss of engine power due to pre-ignition damage to the No. 2 cylinder piston and the pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall.Dec 10, 2016 · N59JL · Substantial damageNTSB CEN17LA055Accident · Serious injuriesLimited investigationFinal reportHiller OH 23B · Tynan, TXThe student pilot's delayed and improper landing flare during a practice autorotation, which resulted in the tail rotor striking terrain.Dec 10, 2016 · N5776 · DestroyedNTSB GAA17CA094Accident · No injuriesData collectionFinal reportSchauer William A JR Starduster TOO SA300 · Kapolei, HIThe pilot's failure to maintain directional control during the landing roll.Dec 8, 2016 · N2822T · Substantial damageNTSB GAA17CA093Accident · No injuriesData collectionFinal reportPiper PA 34 · Denton, TXThe flight instructor’s decision to continue to taxi the airplane to the parking area with a known brake malfunction, which resulted in a loss of directional control and subsequent impact with a parked airplane.Dec 7, 2016 · N2844T · Substantial damageNTSB CEN17FA050Accident · 1 fatalField investigationFinal reportCub Crafters PA18 · Basin, WYThe pilot exceeded the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.Dec 7, 2016 · N444GB · Substantial damageNTSB ANC17FA009Accident · 1 fatalClass 3 · FieldFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot’s decision to operate the airplane at an altitude too low to allow for recovery from an intentional aerodynamic stall. Contributing to the accident was the pilot’s lack of knowledge of the stall performance characteristics of the airplane modified…Dec 7, 2016 · N88452 · Substantial damageNTSB WPR17FA033Accident · 1 fatalField investigationFinal reportAirborne Windsports PTY Edge XT-912-L · Santa Barbara, CAThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern.Dec 6, 2016 · N188M · Substantial damageNTSB ERA17FA066Accident · 1 fatalField investigationFinal reportFairchild SA227 · Camilla, GAThe pilot's decision to initiate and continue the flight into known adverse weather conditions, which resulted spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.Dec 6, 2016 · N765FA · DestroyedNTSB GAA17CA091Accident · No injuriesData collectionFinal reportCessna 170 · Martinsville, VAThe pilot's failure to maintain directional control during the landing roll.Dec 5, 2016 · N9002A · Substantial damageNTSB CEN17LA047Accident · No injuriesLimited investigationFinal reportCessna Citation 500 · Gunnison, COThe pilot’s failure to fly a stabilized approach and his inadequate landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to ensure that the airplane was properly serviced with fuel before departing on the…Dec 5, 2016 · N332SE · Substantial damageNTSB WPR17LA032Accident · Minor injuriesLimited investigationFinal reportHoskins Lonnie F Velocity XL RG · Petaluma, CAThe pilot’s failure to maintain adequate airspeed during an aborted landing, which resulted in an exceedance of the airplane’s critical angle of attack and an inadvertent aerodynamic stall. Contributing to the accident was the pilot’s distraction while on…Dec 4, 2016 · N84KJ · Substantial damageNTSB GAA17CA087Accident · No injuriesData collectionFinal reportJack Fehling Celebrity · North Hampton, NHThe pilot’s unstabilized approach, which resulted in the biplane being low and striking trees.Dec 4, 2016 · N28JF · Substantial damageNTSB GAA17CA139Accident · No injuriesData collectionFinal reportPiper PA46 · Midland, VAThe pilot’s improper landing flare and subsequent hard landing while demonstrating a short-field landing and the flight instructor’s delayed remedial action.Dec 2, 2016 · N4149R · Substantial damageNTSB GAA17CA089Accident · No injuriesData collectionFinal reportPiper PA 28 · Thomson, GAThe pilot’s improper preflight planning, which resulted in fuel exhaustion and the total loss of engine power.Dec 2, 2016 · N2367R · Substantial damageNTSB GAA17CA088Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA-20 · Payson, UTThe student pilot's improper in-flight fuel planning, which resulted in fuel exhaustion.Dec 2, 2016 · N992CT · Substantial damageNTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.Dec 2, 2016 · N129LZ · DestroyedNTSB ANC17LA011Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Unalaska, AKThe pilot’s failure to maintain adequate clearance from terrain during a precautionary landing in whiteout conditions, which resulted in an in-flight collision with terrain.Dec 2, 2016 · N7085K · Substantial damageNTSB WPR17LA030Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Scottsdale, AZThe pilot’s loss of directional control during the landing roll, which resulted in the runway excursion onto the rock-covered runway safety area.Dec 1, 2016 · N9175N · Substantial damageNTSB GAA17IA083Incident · No injuriesIncident investigationFinal reportCessna 560 · Salinas, CAThe pilot's failure to maintain clearance from a parked helicopter.Nov 29, 2016 · N22AF · Minor damageNTSB GAA17CA120Accident · No injuriesData collectionFinal reportPiper PA28 · St. Louis, MOThe student pilot's improper landing flare, which resulted in a bounced landing.Nov 27, 2016 · N56809 · Substantial damageNTSB WPR17FA029Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Glamis, CAThe pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an…Nov 25, 2016 · N88373 · Substantial damageNTSB ANC17LA008Accident · No injuriesLimited investigationFinal reportAirborne Extreme SQ-12 · Palmer, AKThe fuel injector manufacturer's inappropriate guidance to use a 5-ampere circuit breaker in place of the required 10-ampere circuit breaker on the fuel injector circuit, which resulted in the circuit breaker opening, a loss of electrical power to the…Nov 25, 2016 · N37PX · Substantial damageNTSB GAA17CA084Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Pensacola, FLThe student pilot’s incorrect brake application during the landing roll, which resulted in a loss of directional control.Nov 23, 2016 · N155WB · Substantial damageNTSB CEN17LA044Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Bridgeport, TXThe pilot's failure to properly position the fuel selector before takeoff, which resulted a total loss of engine power due to fuel starvation.Nov 23, 2016 · N7392Q · Substantial damageNTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.Nov 23, 2016 · N80RT · Substantial damageNTSB WPR17FA025Accident · 1 fatalField investigationFinal reportPiper PA 28-181 · Upland, CAThe pilot's failure to maintain clearance from rising terrain in dark night conditions, which resulted in controlled flight into terrain.Nov 22, 2016 · N6912C · Substantial damageNTSB GAA17CA085Accident · No injuriesData collectionFinal reportHundley Michael J Vans RV8 · Roopville, GAThe pilot’s overcorrection with the right rudder during the landing roll, which resulted in a loss of directional control and a runway excursion.Nov 22, 2016 · N880KM · Substantial damageNTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.Nov 22, 2016 · N169WT · Substantial damageNTSB GAA17CA077Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR 4000 · San Diego, CAThe other pilot’s failure to see and avoid the airplane stopped ahead of him during taxi.Nov 22, 2016 · N3242 · 2 aircraft · Substantial damageNTSB ERA17LA063Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bluefield, WVThe pilot's failure to maintain directional control during the aborted takeoff.Nov 22, 2016 · N217CE · Substantial damageNTSB ERA17LA053Accident · Minor injuriesLimited investigationFinal reportBroussard Broussard MH 1521 · Simpsonville, SCThe pilot’s inability to maintain directional control during the landing roll due to a flat left main landing gear tire.Nov 22, 2016 · N315XC · Substantial damageNTSB ANC17LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bethel, AKThe mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.Nov 22, 2016 · N83641 · Substantial damageNTSB DCA17CA096Accident · Serious injuriesData collectionFinal reportBoeing 717 200 · Hopewell, VAthe flight attendant's inadvertent bump into a retractable galley tray.Nov 21, 2016 · N930AT · No damageNTSB ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.Nov 20, 2016 · N4976K · Substantial damageNTSB GAA17CA080Accident · No injuriesData collectionFinal reportCessna 172 · Woodbine, NJThe student pilot's improper landing flare, which resulted in a porpoised landing.Nov 19, 2016 · N5249R · Substantial damageNTSB CEN17LA042Accident · Serious injuriesLimited investigationFinal reportNorthwing Navajo · Daingerfield, TXThe noncertificated pilot’s unfamiliarity with the aircraft, which resulted in a loss of control during an unintentional takeoff.Nov 19, 2016 · N360XL · Substantial damageNTSB WPR17FA023Accident · 1 fatalField investigationFinal reportCessna 172N · Moss Beach, CAThe pilot's loss of airplane control following an encounter with low level wind shear and turbulence during final approach for landing. Contributing to the loss of control was the pilot's decision to retract the wing flaps on final approach, which resulted in…Nov 18, 2016 · N6610D · Substantial damageNTSB GAA17CA092Accident · No injuriesData collectionFinal reportPitcairn PA 18 · Philadelphia, PAThe pilot’s failure to correct the gyroplane’s right roll during the landing, which resulted in the exceedance of its critical angle and a subsequent roll-over. Contributing to the accident were the pilot’s focus on preventing a potential ground loop instead…Nov 18, 2016 · N12680 · Substantial damageNTSB GAA17CA081Accident · No injuriesData collectionFinal reportCessna 172 · Destin, FLThe student pilot’s overcorrection with right rudder, which resulted in a loss of directional control, and the flight instructor’s delayed remedial action.Nov 17, 2016 · N9358L · Substantial damageNTSB ERA17LA048Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS126 · Moscow, TNThe pilot's failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall/spin.Nov 17, 2016 · N65968 · Substantial damageNTSB ERA17FA050Accident · 2 fatalField investigationFinal reportCurtiss JN4 · Williamson, GAThe in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…Nov 17, 2016 · N1662 · DestroyedNTSB WPR17FA021Accident · 2 fatalField investigationFinal reportHughes 369 · Pukoo, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions at night in rain, which resulted in his geographic disorientation and controlled flight into terrain.Nov 16, 2016 · N81GG · DestroyedNTSB ERA17LA046Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · West Chester, PAThe flight instructor's decision to continue the practice autorotation in known gusting wind conditions, which resulted in a hard landing and roll over.Nov 15, 2016 · N306RL · Substantial damageNTSB GAA17CA082Accident · Serious injuriesData collectionFinal reportCameron A315 · Winters, CAThe passenger's improper egress from the balloon basket, which resulted in a serious injury.Nov 14, 2016 · N69520 · No damage