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 ERA14CA165Accident · Serious injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Kill Devil Hills, NCThe pilot's failure to maintain control of the airplane during the landing approach in gusty wind conditions.Mar 23, 2014 · N90650 · Substantial damageNTSB CEN14LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 - II · Menard, TXThe pilot’s inadequate recovery from a practice autorotation, which resulted in an improper touchdown attitude and collision with terrain.Mar 23, 2014 · N44MD · Substantial damageNTSB ERA14FA162Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Safety Harbor, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to cocaine use.Mar 22, 2014 · N8309L · Substantial damageNTSB ERA14CA176Accident · No injuriesData collectionFinal reportCessna 172B · Mt Olive, NCThe pilot's failure to adequately secure the airplane before hand-propping the engine for startup.Mar 22, 2014 · N8988B · Substantial damageNTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.Mar 22, 2014 · N702H · Substantial damageNTSB WPR14LA146Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC42 550FG · Truckee, CAThe pilot’s failure to maintain directional control during both the landing and the subsequent attempted go-around.Mar 21, 2014 · N112FP · Substantial damageNTSB ERA14LA173Accident · No injuriesLimited investigationFinal reportCessna 206H · Philadelphia, PAThe pilot's failure to maintain control of the airplane while landing in gusty wind conditions.Mar 21, 2014 · N309JK · Substantial damageNTSB ERA14LA161Accident · 1 fatalLimited investigationFinal reportCessna LC41-550FG · Palatka, FLThe pilot’s improper management of the fuel mixture and his failure to use the appropriate checklist and guidance during the flight, which resulted in an overrich mixture condition, carbon-fouling of the spark plugs, and a subsequent total loss of engine…Mar 21, 2014 · N717RR · Substantial damageNTSB CEN14LA168Accident · No injuriesLimited investigationFinal reportOlson Perry D Titan 51 Mustang · Evans, COThe builder's improper wiring of both fuel pumps to the battery-powered bus, which resulted in a total loss of engine power when the batteries failed because all power to the fuel pumps was lost.Mar 21, 2014 · N43889 · Substantial damageNTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.Mar 21, 2014 · N739RX · Substantial damageNTSB CEN14CA170Accident · No injuriesData collectionFinal reportDonald G Stokes Challenger II · Crockett, TXThe pilot's failure to maintain control of the airplane, resulting in a hard landing.Mar 21, 2014 · N284DS · Substantial damageNTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.Mar 20, 2014 · N817EV · Substantial damageNTSB WPR14CA140Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Coolidge, AZThe pilot's failure to maintain directional control during landing.Mar 20, 2014 · N4106G · Substantial damageNTSB ERA14LA170Accident · No injuriesLimited investigationFinal reportCessna 421 · Charleston, SCInadequate maintenance, which resulted in the collapse of the right main landing gear during landing.Mar 20, 2014 · N5929M · Substantial damageNTSB WPR14CA139Accident · No injuriesData collectionFinal reportBayer Oscar Starduster SA300 · San Luis Obispo, CAThe pilot's inadequate flare, which resulted in a bounced landing and subsequent loss of aircraft control during landing.Mar 19, 2014 · N490B · Substantial damageNTSB CEN14FA163Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Aurora, COThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control.Mar 19, 2014 · N90464 · DestroyedNTSB CEN14CA440Accident · Serious injuriesData collectionFinal reportMooney M20J · Lamar, COThe pilot allowed the airplane to liftoff without sufficient airspeed which resulted in a stall and subsequent impact with the terrain.Mar 19, 2014 · N201VA · Substantial damageNTSB CEN14CA166Accident · No injuriesData collectionFinal reportSkykits Savannah VGW · Hudson, COThe pilot's inadequate monitoring of his glide path resulting in a collision with a berm prior to landing.Mar 19, 2014 · N508TG · Substantial damageNTSB CEN14CA164Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Ruidoso, NMThe pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance.Mar 19, 2014 · N3398M · Substantial damageNTSB ERA14LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Elizabethton, TNThe pilot’s delayed decision to maneuver around rising terrain, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot’s failure to calculate the performance requirements needed to climb over mountainous terrain…Mar 18, 2014 · N46603 · Substantial damageNTSB CEN14LA165Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Wichita Falls, TXThe loss of engine power due to the misrigging of the fuel mixture control.Mar 18, 2014 · N9532Y · Substantial damageNTSB CEN14LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Greenwood, INThe flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.…Mar 18, 2014 · N9432U · Substantial damageNTSB WPR14CA143Accident · No injuriesData collectionFinal reportGrumman TMB-3E · Glendale, AZThe pilot inadvertently raised the landing gear lever rather than the adjacent flap level while exiting the runway which resulted in the retraction of the left main landing gear.Mar 17, 2014 · N53503 · Substantial damageNTSB ERA14CA157Accident · No injuriesData collectionFinal reportCessna 210N · Marathon, FLThe pilot's failure to ensure that the airplane's landing gear was down and locked prior to touchdown. Contributing to the accident was the possibility of intermittent landing gear operation due to a faulty hydraulic power pack contactor.Mar 17, 2014 · N210JZ · Substantial damageNTSB ERA14LA159Accident · No injuriesLimited investigationFinal reportCessna 500 · Zephyrhills, FLThe pilots' inadequate in-flight planning and improper selection of runway 36 for landing, which resulted in a significant quartering tailwind during the landing, exceedance of the airplane's braking capability, and a subsequent runway overrun.Mar 16, 2014 · N125DS · Substantial damageNTSB WPR14CA138Accident · Minor injuriesData collectionFinal reportDG Flugzeugbau DG 1000S · Wrightwood, CAThe pilot's inadequate in-flight planning/decision to maneuver the glider where the lift was not sufficient to maintain flight, resulting in an off airport landing.Mar 15, 2014 · N624RM · Substantial damageNTSB ERA14LA156Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Stuart, FLThe pilot’s improper preflight planning and fuel management, which resulted in a total loss of power in both engines due to fuel exhaustion.Mar 14, 2014 · N419AR · Substantial damageNTSB ERA14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Brooksville, FLThe pilot's failure to compensate for the reported crosswind conditions resulting in the wings contacting the ground.Mar 14, 2014 · N80457 · Substantial damageNTSB CEN14CA183Accident · No injuriesData collectionFinal reportStinson 108 · Broomfield, COThe pilot's failure to maintain directional control during the landing, which resulted in the airplane departing the runway and nosing over.Mar 14, 2014 · N9538K · Substantial damageNTSB CEN14CA160Accident · Minor injuriesData collectionFinal reportPiper PA 28-235 · De Beque, COThe pilot's failure to maintain control of the airplane while maneuvering at low altitude.Mar 14, 2014 · N9172W · Substantial damageNTSB WPR14CA136Accident · No injuriesData collectionFinal reportNorman Quad City Challenger · Monroe, WAThe pilot's inadequate construction of the propeller bracket, which resulted in its failure during the initial climb and the propeller subsequently departing the airplane.Mar 13, 2014 · N345MN · Substantial damageNTSB DCA14MA081Accident · No injuriesClass 2 · MajorFinal reportAirbus A320 - 214 · Philadelphia, PAthe captain's decision to reject the takeoff after the airplane had rotated. Contributing to the accident was the flight crew's failure to follow standard operating procedures by not verifying that the airplane's flight management computer was properly…Mar 13, 2014 · N113UW · Substantial damageNTSB CEN14CA162Accident · No injuriesData collectionFinal reportBeech 35 C33A · West Union, OHA loss of aircraft control during landing, due to the pilot's excessive braking. Contributing to the accident was the pilot's lack of recent flight experience.Mar 13, 2014 · N242JB · Substantial damageNTSB WPR14FA135Accident · 2 fatalField investigationFinal reportEvolution Trikes Revo · Kekaha, HIThe pilot's reconfiguration of the fuel venting system, which resulted in a loss of engine power and subsequent loss of aircraft control.Mar 11, 2014 · N98EV · Substantial damageNTSB ERA14FA153Accident · 1 fatalField investigationFinal reportWaters Peter T Avid Bandit · Washington, PAThe pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.Mar 11, 2014 · N62PT · DestroyedNTSB CEN14CA158Accident · Minor injuriesData collectionFinal reportAmerican Champion 8GCBC · Chisago City, MNThe unsuitable landing area encountered by the pilot due to wet soft snow conditions that resulted in a nose over.Mar 10, 2014 · N63HE · Substantial damageNTSB WPR14FA132Accident · 1 fatalField investigationFinal reportCessna 120 · Carson City, NVThe pilot’s delayed decision to initiate a course-reversal turn when the airplane was unable to attain sufficient altitude to cross a mountain range, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall…Mar 9, 2014 · N76856 · DestroyedNTSB ERA14LA152Accident · Serious injuriesLimited investigationFinal reportKurtz Jay B RV-9A · Live Oak, FLThe pilot’s improper recovery from a bounced landing, which resulted in an aerodynamic stall, a subsequent nose-down landing, and excessive bending loads to the nose landing gear.Mar 9, 2014 · N125TK · Substantial damageNTSB CEN14CA154Accident · No injuriesData collectionFinal reportCessna 185 · Eden Prairie, MNThe pilot's loss of directional control during takeoff with a gusty crosswind.Mar 9, 2014 · N4764B · Substantial damageNTSB WPR14LA133Accident · No injuriesLimited investigationFinal reportPeter W Stevens Bearhawk Patrol · Salt Lake City, UTThe pilot’s failure to maintain directional control during the landing roll.Mar 8, 2014 · N123WW · Substantial damageNTSB ERA14LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Fairhope, ALThe pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.Mar 8, 2014 · N2755U · DestroyedNTSB ERA14LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Mulberry, FLThe failure of the pilot and the parachutist to see and avoid each other, which resulted in the airplane’s wing colliding with the parachute’s suspension lines.Mar 8, 2014 · N211R · Substantial damageNTSB ERA14FA144Accident · 3 fatalField investigationFinal reportRogers George T Lancair IVP · Hartsville, SCFailure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the…Mar 8, 2014 · N724HP · Substantial damageNTSB ERA14CA160Accident · No injuriesData collectionFinal reportCessna 172N · Charlottesville, VAThe pilot's inadequate landing flare, which resulted in a bounced landing and substantial damage to the firewall.Mar 8, 2014 · N5423J · Substantial damageNTSB ERA14CA150Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Salisbury, NCThe flight instructor's decision to continue the landing in close proximity to a landing helicopter, resulting in an encounter with rotor vortices, loss of airplane control, and collision with terrain.Mar 8, 2014 · N4335T · Substantial damageNTSB CEN14LA159Accident · No injuriesLimited investigationFinal reportCessna 310Q · Wapakoneta, OHA fire due to a fuel leak of the cabin heater system. Contributing to the accident was the inadequate maintenance of the airplane, which failed to identify leaks in the heater system.Mar 8, 2014 · N69980 · Substantial damageNTSB CEN14CA156Accident · No injuriesData collectionFinal reportOlson Kenneth H T Zodiac 601 HDS · Garrison, MNThe pilot's failure to maintain directional control during takeoff which resulted in the airplane striking a snow bank.Mar 8, 2014 · N981HT · Substantial damageNTSB ANC14CA018Accident · No injuriesData collectionFinal reportPiper PA 18 · Tanana, AKThe passenger inadvertently interfered with the rudder control pedal, which resulted in a loss of directional control during takeoff.Mar 8, 2014 · N8281C · Substantial damageNTSB ERA14CA151Accident · No injuriesData collectionFinal reportCessna 172M · Pittstown, NJThe pilot's failure to maintain directional control while landing.Mar 7, 2014 · N1319U · Substantial damageNTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.Mar 6, 2014 · N108WA · Substantial damage