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 WPR11GA115Accident · 1 fatalFinal reportMcdonnell Douglas Heli 369FF · Marana, AZAn inadvertent tail rotor strike during an attempted pinnacle landing, which resulted in the pilot's loss of control of the helicopter. Inhospitable terrain/topography contributed to the severity of the accident.Jan 31, 2011 · N530RL · Substantial damageNTSB WPR11FA117Accident · Serious injuriesField investigationFinal reportCessna 172 · Glendora, CAThe flight crew's failure to maintain adequate terrain clearance while maneuvering in downdraft conditions over mountains.Jan 31, 2011 · N6922A · Substantial damageNTSB WPR11LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Big Bear City, CAThe pilot’s failure to maintain the minimum single-engine control speed while on final approach for landing. Contributing to the accident was the pilot's decision to fly with a known deficiency in one engine and a loss of power in that engine for reasons that…Jan 30, 2011 · N64RJ · Substantial damageNTSB WPR11FA116Accident · 3 fatalField investigationFinal reportCessna 182K · Adrian, ORThe non-instrument-rated pilot did not maintain sufficient altitude to clear mountainous terrain while in cruise flight in the dark.Jan 30, 2011 · N3083Q · Substantial damageNTSB ERA11CA153Accident · No injuriesData collectionFinal reportOtterback Nicholas J Lightning · Crescent City, FLThe pilot's inadequate flare and failure to recover from a bounced landing which resulted in a runway excursion.Jan 30, 2011 · N324AL · Substantial damageNTSB ERA11CA129Accident · Serious injuriesData collectionFinal reportKolb Kolb Mark III · Rutherfordton, NCThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude resulting in a stall/spin and ground impact.Jan 30, 2011 · N457A · Substantial damageNTSB CEN11LA169Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHThe partial loss of engine power due to carburetor icing and the pilot’s delayed use of carburetor heat and failure to attain the proper touchdown point on the runway during the precautionary landing.Jan 30, 2011 · N55212 · Substantial damageNTSB CEN11LA164Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Bennett, COThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.Jan 30, 2011 · N787CB · Substantial damageNTSB CEN11CA191Accident · No injuriesData collectionFinal reportErcoupe 415-CD · Newaygo, MIThe pilot's loss of directional control during takeoff from a frozen lake.Jan 30, 2011 · N127G · Substantial damageNTSB ERA11CA132Accident · No injuriesData collectionFinal reportCessna 172S · St. Petersburg, FLThe student pilot's failure to maintain directional control while attempting to turn the airplane onto a taxiway after landing.Jan 29, 2011 · N6013J · Substantial damageNTSB ERA11CA131Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Atlanta, GAThe pilot's wrong turn while taxiing resulting in a collision with a sign.Jan 29, 2011 · N9127F · Substantial damageNTSB CEN11LA168Accident · No injuriesLimited investigationFinal reportErtz Mark G Zodiac 601XL · Burlington, IAThe Model 1 pilot's inadequate visual lookout and subsequent failure to see and avoid the Zodiac.Jan 29, 2011 · N200BE · 2 aircraft · Substantial damageNTSB CEN11CA170Accident · No injuriesData collectionFinal reportCessna 182 · Meeker, COThe pilot’s loss of directional control while taxiing due to his improper seat position.Jan 29, 2011 · N7199E · Substantial damageNTSB CEN11CA167Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Anoka, MNThe student pilot's control inputs that resulted in an inadvertent dynamic rollover and the CFI's inadequate supervision of the flight.Jan 29, 2011 · N7195B · Substantial damageNTSB CEN11CA166Accident · No injuriesData collectionFinal reportMcholland C L Solitare · Wellington, COThe glider pilot’s misjudgment while approaching to land, which resulted in an off-airport landing.Jan 29, 2011 · N15XP · Substantial damageNTSB CEN11CA163Accident · Minor injuriesData collectionFinal reportMooney M20R · Cypress, TXThe student pilot’s delayed decision to execute a go-around.Jan 29, 2011 · N64FM · Substantial damageNTSB ANC11CA011Accident · No injuriesData collectionFinal reportMiller Gregory Scott GOT Rocks · Anchorage, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.Jan 29, 2011 · N9015U · Substantial damageNTSB ERA11LA130Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Cross City, FLA total loss of engine power resulting from the failure of the camshaft due to fatigue cracks. Contributing to the accident was the inadequate quality inspection of the camshaft after initial manufacture.Jan 28, 2011 · N8135B · Substantial damageNTSB CEN11LA162Accident · No injuriesLimited investigationFinal reportPiper PA24 · Huntsville, TXThe pilot’s inadequate preflight inspection to ensure the main tanks were full, which resulted in a total loss of engine power due to fuel starvation.Jan 28, 2011 · N8023P · Substantial damageNTSB CEN11CA171Accident · No injuriesData collectionFinal reportCessna 172R · Shreveport, LAThe student pilot's loss of directional control during the landing.Jan 28, 2011 · N5929T · Substantial damageNTSB WPR11CA110Accident · No injuriesData collectionFinal reportWalker Louie H Super 18 Cuby · Toutle, WAThe pilot's excessive braking during the landing roll, which resulted in the airplane nosing over onto its back. Contributing to the accident was the pilot's decision to land on a sandbar that he had not adequately inspected and his improper airspeed while on…Jan 26, 2011 · N92LW · Substantial damageNTSB WPR11CA109Accident · No injuriesData collectionFinal reportCessna 180H · Helena, MTThe certified flight instructor's loss of airplane control during the landing roll in a gusting crosswind.Jan 26, 2011 · N9067M · Substantial damageNTSB ERA11CA127Accident · No injuriesData collectionFinal reportPiper PA28 · Monroeville, ALThe pilot's failure to maintain directional control during the landing rollout.Jan 26, 2011 · N9742J · Substantial damageNTSB WPR11CA107Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Meadview, AZThe pilot's failure to properly secure the airplane while manually starting the engine with the propeller, resulting in inadvertent movement of the airplane and collision with the ground.Jan 25, 2011 · N3751U · Substantial damageNTSB WPR11CA106Accident · No injuriesData collectionFinal reportCessna 180 · Prescott, AZThe pilot's loss of airplane control during the landing roll.Jan 25, 2011 · N2229C · Substantial damageNTSB CEN11CA165Accident · No injuriesData collectionFinal reportCulver Glenn Kitfox III · Terlingua, TXThe pilot's loss of directional control on takeoff.Jan 25, 2011 · N947RG · Substantial damageNTSB ERA11LA124Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pittsburg, PAThe pilot’s excessive engine rpm and speed during taxi and subsequent braking, which resulted in a wheel brake fire.Jan 24, 2011 · N690KY · Substantial damageNTSB ERA11CA123Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Jasper, ALThe pilot's loss of directional control on a wet runway during takeoff from a touch and go landing resulting in a runway excursion.Jan 24, 2011 · N1116C · Substantial damageNTSB CEN11CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Corsicana, TXThe student pilot’s failure to maintain directional control during landing.Jan 24, 2011 · N81800 · Substantial damageNTSB WPR11FA103Accident · 1 fatalField investigationFinal reportCessna T206H · Stanwood, WAThe pilot did not confirm retraction of the landing gear before landing on water as a result of distraction. Contributing to the accident was the pilot coping with the death of a close family member in the days before the accident, which resulted in a…Jan 22, 2011 · N142HF · Substantial damageNTSB CEN11CA158Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with terrain.Jan 22, 2011 · N348ME · Substantial damageNTSB WPR11LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Santa Ana, CAThe failure of the left main landing gear due to the lack of lubrication.Jan 21, 2011 · N47589 · Substantial damageNTSB OPS11IA246Incident · No injuriesIncident investigationFinal reportBoeing 777 · 80 SE of JFK (Atlantic Ocean), NYIncomplete and incorrect coordination between air traffic controllers that resulted in the 777 and the two C17s being cleared to maintain the same altitude. Contributing to the incident was the controllers’ non-adherence to established communications…Jan 21, 2011 · N766AN · No damageNTSB CEN11CA176Accident · Serious injuriesData collectionFinal reportPiper PA-28-180 · Pekin, ILThe student pilot's failure to maintain adequate airspeed during the landing approach, which resulted in an aerodynamic stall.Jan 19, 2011 · N5658W · Substantial damageNTSB CEN11CA155Accident · No injuriesData collectionFinal reportCessna R182 · Houston, TXThe failure of the landing gear to fully extend and lock in the down position due to the inoperative electric pump motor.Jan 19, 2011 · N6187S · Substantial damageNTSB WPR11CA141Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Aurora, ORThe pilot's failure to lower the landing gear prior to landing.Jan 18, 2011 · N3TP · Substantial damageNTSB ERA11FA118Accident · 2 fatalField investigationFinal reportCessna 172S · North Myrtle Beach, SCThe pilot's loss of airplane control during a missed approach due to spatial disorientation.Jan 18, 2011 · N2100V · Substantial damageNTSB ERA11LA117Accident · No injuriesLimited investigationFinal reportConvair 340-71 · Charlotte AmalieThe captain’s decision to continue the flight with the left engine backfiring, resulting in an engine fire shortly after takeoff. Contributing to the accident were the captain’s decision to continue the flight following a report of black smoke trailing the…Jan 17, 2011 · N8277Q · Substantial damageNTSB CEN11LA153Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Clarendon, TXThe pilot's failure to correctly set the altimeter, which resulted in his erroneous perception that the airplane was at a safe altitude.Jan 17, 2011 · N7262T · Substantial damageNTSB ERA11IA172Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-20 · Walterboro, SCThe inadequate inspection and rigging of the nose landing gear downlock mechanism by maintenance personnel, which resulted in the failure of a bolt and the subsequent collapse of the nose gear during the landing roll.Jan 16, 2011 · N52CD · Minor damageNTSB WPR11CA101Accident · No injuriesData collectionFinal reportBell 206B3 · Three Forks, MTThe pilot’s inadequate use of throttle during the practice autorotation that resulted in a hard landing.Jan 15, 2011 · N78BR · Substantial damageNTSB ERA11LA116Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Stuart, FLThe student pilot's inadvertent activation of the collective control, which allowed the helicopter to become airborne and impact the ramp.Jan 15, 2011 · N21086 · Substantial damageNTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.Jan 15, 2011 · N1946F · Substantial damageNTSB WPR11CA100Accident · No injuriesData collectionFinal reportCessna 180 · Fullerton, CAThe pilot’s failure to maintain directional control during landing.Jan 14, 2011 · N1630C · Substantial damageNTSB WPR11CA099Accident · No injuriesData collectionFinal reportDiamond DA20C1 · Spanish Fork, UTThe pilot’s failure to maintain directional control during landing.Jan 14, 2011 · N376DC · Substantial damageNTSB WPR11CA098Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Austin, NVThe pilot’s failure to maintain directional control during the takeoff roll.Jan 13, 2011 · N4030Z · Substantial damageNTSB WPR11LA096Accident · 1 fatalLimited investigationFinal reportRyan Aeronautical ST3KR · Warner Springs, CAThe pilot's failure to maintain clearance from the wind sock pole during landing.Jan 11, 2011 · N57027 · Substantial damageNTSB WPR11LA094Accident · 1 fatalLimited investigationFinal reportRockwell International S-2R · Oakley, CAAn in-flight collision with an unmarked meteorological evaluation tower (MET) during an aerial application flight due to the pilot's failure to see and avoid the obstacle. Contributing to the accident was the lack of visual conspicuity of the MET and the lack…Jan 10, 2011 · N4977X · Substantial damageNTSB WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.Jan 9, 2011 · N1755H · Substantial damageNTSB WPR11FA093Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Phoenix, AZThe pilot did not maintain directional control during the landing roll. Contributing to the accident was low nosewheel tire pressure.Jan 9, 2011 · N5365D · Substantial damage