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 WPR12CA095Accident · No injuriesData collectionFinal reportAlon A2 · Forks, WAThe pilot's incorrect placement of the throttle prior to starting the airplane by hand. Contributing to the accident was that the pilot did not ensure that the airplane was restrained in a manner that would keep it from moving forward.Feb 4, 2012 · N5687F · Substantial damageNTSB DCA12CA035Accident · No injuriesData collectionFinal reportBombardier CL600 2B19 · San Francisco, CAthe driver's failure to ensure that the belt loader was clear of the airplane before turning.Feb 4, 2012 · N912SW · Substantial damageNTSB CEN12CA157Accident · Minor injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot did not extend the landing gear before landing.Feb 4, 2012 · N2696C · Substantial damageNTSB WPR12LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Dinsmore, CAThe flight instructor's delayed remedial action, inadequate recovery from a bounced landing, and failure to attain/maintain adequate airspeed during an attempted go-around.Feb 3, 2012 · N3879S · Substantial damageNTSB WPR12FA089Accident · 1 fatalField investigationFinal reportGarza Lancair IV-TP · Boise, IDA loss or commanded reduction of engine power during the initial climb for reasons that could not be determined because of postaccident impact damage and fire destruction to engine systems and components. Also causal were the pilot's failure to maintain…Feb 3, 2012 · N321LC · DestroyedNTSB CEN12FA151Accident · No injuriesField investigationFinal reportGates Lear Jet 35 · Pueblo, COThe captain's failure to maintain airplane control during an attempted crosswind takeoff on a contaminated runway.Feb 3, 2012 · N31WS · Substantial damageNTSB WPR12CA088Accident · No injuriesData collectionFinal reportCessna 172S · Mokuleia, HIThe pilot's improper landing flare and inadequate recovery from a bounced landing.Feb 2, 2012 · N5026C · Substantial damageNTSB ANC12CA021Accident · No injuriesData collectionFinal reportBeech 99 · Anchorage, AKThe pilot's premature power reduction, which resulted in a runway undershoot.Feb 1, 2012 · N991AK · Substantial damageNTSB CEN12LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Sheridan, ARThe passenger’s interference with the flight controls during the initial climb, which resulted in a loss of control and impact with terrain.Jan 31, 2012 · N2677A · Substantial damageNTSB WPR12LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · San Diego, CAThe pilot's failure to turn the magneto switch to the off position before moving the propeller to start the engine by hand.Jan 30, 2012 · N746R · No damageNTSB WPR12CA086Accident · No injuriesData collectionFinal reportCessna 180 · Cascade, IDThe pilot's inadequate compensation for a wind gust during landing, which resulted in a runway excursion. Contributing to the accident was a windsock partially sheltered by trees that provided inaccurate wind information.Jan 30, 2012 · N3242D · Substantial damageNTSB ERA12IA166Incident · No injuriesIncident investigationFinal reportGulfstream G150 · Baltimore, MDThe pilot-in-command's failure to obtain the proper touchdown point or landing reference speed and failure to initiate a go-around when it became evident that the airplane was landing long and fast. Contributing to the incident was a lack of effective flight…Jan 30, 2012 · N272CB · Minor damageNTSB ERA12FA163Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Thomasville, PAThe pilot's failure to maintain airspeed during an approach in gusty crosswind conditions, which resulted in an inadvertent aerodynamic stall.Jan 29, 2012 · N1352T · Substantial damageNTSB ERA12CA167Accident · No injuriesData collectionFinal reportRemos G-3/600 · Sarasota, FLThe student pilot’s loss of directional control during the landing roll.Jan 29, 2012 · N133LS · Substantial damageNTSB WPR12CA084Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-33A · Peoria, AZThe glider pilot released from the tow airplane at a lower altitude than the planned altitude, which resulted in an off-airport landing.Jan 28, 2012 · N17873 · Substantial damageNTSB ERA12LA165Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Palm Beach, FLThe pilot’s in-flight misjudgment of fuel remaining resulting in fuel exhaustion and a total loss of engine power. Contributing to the accident was an inadequate fuel quantity for the flight for reasons that could not be determined during postaccident…Jan 28, 2012 · N30DC · Substantial damageNTSB ERA12LA164Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Clearwater, FLThe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident testing of the engine did not reveal any malfunctions or failures that would preclude normal operation. Contributing to the accident was the…Jan 28, 2012 · N761HW · Substantial damageNTSB WPR12LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chehalis, WAThe pilot did not correctly manage his glide profile during a simulated engine-out forced landing. Contributing to the accident was the pilot's decision not to add additional engine power, which resulted in a runway undershoot.Jan 27, 2012 · N15791 · Substantial damageNTSB ERA12FA161Accident · 1 fatalField investigationFinal reportCessna 340A · Ocala, FLThe pilot's failure to maintain adequate airspeed and altitude on final approach, resulting in an impact with terrain short of the airport.Jan 27, 2012 · N340HF · Substantial damageNTSB WPR12CA083Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Barbara, CAThe pilot did not maintain directional control during takeoff.Jan 26, 2012 · N4297S · Substantial damageNTSB WPR12CA082Accident · No injuriesData collectionFinal reportCessna 172P · Honolulu, HIThe student pilot’s improper landing flare and inadequate directional control while performing an aborted landing.Jan 26, 2012 · N66540 · Substantial damageNTSB ANC12CA020Accident · No injuriesData collectionFinal reportHelio H-295 · Old Minto, AKThe pilot's decision to land on unsuitable terrain, which resulted in the airplane nosing over.Jan 26, 2012 · N713C · Substantial damageNTSB OPS12IA303Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Farmersville, TXThe flight's continued operation through an area containing substantial convective weather activity. Contributing to the accident was the air traffic control/traffic management unit's lack of awareness and recognition of the effect of weather movement on the…Jan 25, 2012 · N639AE · No damageNTSB WPR12LA081Accident · Minor injuriesLimited investigationFinal reportMas Events Nemesis · Camarillo, CAA partial loss of engine power during cruise flight due to incorrectly installed airframe components, which came into contact with a high pressure fuel line and resulted in its failure. Contributing to the accident was an undetermined failure of the primary…Jan 24, 2012 · F-WNXT · Substantial damageNTSB ERA12CA156Accident · No injuriesData collectionFinal reportBeech 58 · Walterboro, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident was the sunglare.Jan 24, 2012 · N358CC · Substantial damageNTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…Jan 23, 2012 · N73JK · Substantial damageNTSB ANC12CA019Accident · No injuriesData collectionFinal reportCessna 207A · Nikiski, AKThe pilot's improper identification of the runway surface. Contributing to the accident was the snow covering the runway lights.Jan 23, 2012 · N800DF · Substantial damageNTSB WPR12CA079Accident · No injuriesData collectionFinal reportCessna 172M · Richland, WAThe student pilot's improper landing flare and inadequate directional control during landing.Jan 22, 2012 · N64270 · Substantial damageNTSB CEN12LA141Accident · No injuriesLimited investigationFinal reportBell 206B · Irving, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Jan 22, 2012 · N555NB · Substantial damageNTSB CEN12FA143Accident · 2 fatalField investigationFinal reportCessna 177A · North Vernon, INThe non-instrument-rated pilot's decision to fly into known instrument meteorological conditions, which resulted in the pilot's spatial disorientation and loss of airplane control.Jan 22, 2012 · N3435T · Substantial damageNTSB ANC12CA018Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Beluga, AKGround personnel's movement of cargo in windy conditions, which allowed a previously secured cargo sack to blow into the main rotor blades.Jan 21, 2012 · N4510T · Substantial damageNTSB ERA12LA150Accident · No injuriesLimited investigationFinal reportM-Squared Breese 2 · Bayou La Batre, ALThe pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.Jan 19, 2012 · N582MS · Substantial damageNTSB ERA12LA148Accident · No injuriesLimited investigationFinal reportCessna 172I · Springfield, TNThe pilot did not apply carburetor heat during approach to landing, which resulted in a total loss of engine power due to carburetor icing.Jan 19, 2012 · N35571 · Substantial damageNTSB CEN12FA139Accident · 2 fatalField investigationFinal reportRobinson R44 II · Centerville, LAThe pilot allowed the helicopter to settle with power while maneuvering at low altitude.Jan 19, 2012 · N369TL · Substantial damageNTSB ERA12LA147Accident · No injuriesLimited investigationFinal reportBoeing DHC-8-102 · Huntington, WVThe inadequate communication among ground crew personnel, which resulted in the airplane’s collision with a deice truck.Jan 16, 2012 · N839EX · Substantial damageNTSB ERA12FA146Accident · 1 fatalField investigationFinal reportAerostar PA-60-601P · Philadelphia, MSThe pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…Jan 16, 2012 · N700PS · Substantial damageNTSB ERA12LA145Accident · 2 fatalLimited investigationFinal reportPiper PA-24-180 · Brewster, MAThe flight crew’s loss of airplane control.Jan 15, 2012 · N7648P · Substantial damageNTSB CEN12CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Angle Fire, NMThe pilot did not maintain control of the airplane during the takeoff in gusting crosswind conditions.Jan 15, 2012 · N513CW · Substantial damageNTSB ANC12LA017Accident · No injuriesLimited investigationFinal reportPzl-Swidnik SW-4 · Fairbanks, AKA loss of control during a simulated hydraulic emergency, which resulted in an inadvertent dynamic rollover from the which the pilot could not recover.Jan 15, 2012 · SP-SSW · Substantial damageNTSB WPR12CA077Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · San Diego, CAThe pilot's inadequate directional control during the landing roll.Jan 14, 2012 · N409EV · Substantial damageNTSB CEN12LA134Accident · Minor injuriesLimited investigationFinal reportAero Commander 500-B · Bartlesville, OKThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection, which did not correctly identify the airplane’s fuel quantity before departure.Jan 14, 2012 · N524HW · Substantial damageNTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.Jan 13, 2012 · N262RW · Substantial damageNTSB CEN12LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Denmark, WIThe pilot’s loss of control due to his alcohol impairment. Contributing to the accident was the pilot's decision to fly at night with a known interior lighting malfunction.Jan 12, 2012 · N60676 · Substantial damageNTSB ERA12FA143Accident · Serious injuriesField investigationFinal reportCessna 150G · Fitchburg, MAA partial loss of engine power due to the formation of carburetor ice and the flight instructor's improper application of carburetor heat.Jan 11, 2012 · N4041J · Substantial damageNTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…Jan 8, 2012 · N580TC · Substantial damageNTSB ERA12LA141Accident · 1 fatalLimited investigationFinal reportBowers Fly Baby 1-A · Jefferson, GAThe pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…Jan 8, 2012 · N4626 · DestroyedNTSB WPR12LA076Accident · No injuriesLimited investigationFinal reportPiper PA28 · Phoenix, AZThe pilot’s inability to maintain directional control during the landing roll for reasons that could not be determined because impact damage precluded determination of the preaccident functionality of the braking and steering systems.Jan 6, 2012 · N4175V · Substantial damageNTSB WPR12LA074Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic WT9 · Glendale, AZThe pilot did not shut down the engine upon recognizing a brake malfunction. Contributing to the accident was the airplane's brake malfunction for undetermined reasons.Jan 6, 2012 · N247DY · Substantial damageNTSB ERA12CA137Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · St Petersburg, FLThe flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…Jan 6, 2012 · N8066U · Substantial damageNTSB CEN12LA129Accident · Minor injuriesLimited investigationFinal reportAviat A-1C-180 · Chetek, WIThe passenger’s interference with the flight controls, which resulted in the airplane’s failure to climb after an aborted landing. Contributing was the pilot's failure to maintain directional control during landing roll, which resulted in the need to abort…Jan 6, 2012 · N11HY · Substantial damage