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 WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.Apr 24, 2011 · N23295 · Substantial damageNTSB ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.Apr 24, 2011 · N304EB · Substantial damageNTSB CEN11LA307Accident · 1 fatalLimited investigationFinal reportCessna 320 · Lake Heron, NMThe pilot’s controlled flight into terrain while conducting a flight at low altitude in instrument meteorological conditions.Apr 24, 2011 · N320AZ · Substantial damageNTSB WPR11CA206Accident · No injuriesData collectionFinal reportTew William P Team Rocket F1 · Heber, UTThe pilot's failure to maintain directional control during landing.Apr 23, 2011 · N5491W · Substantial damageNTSB ERA11LA263Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass Aquilla · Starke, FLThe pilot's loss of airplane control while taxiing, which resulted in the weight-shift-controlled airplane becoming inadvertently airborne and subsequently impacting the ground. Contributing to the accident was the pilot's lack of experience in the make and…Apr 23, 2011 · N94370 · Substantial damageNTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.Apr 23, 2011 · N3963Y · Substantial damageNTSB ERA11CA260Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Belhaven, NCThe pilot's failure to maintain adequate clearance above crops while performing an aerial application flight.Apr 23, 2011 · N8896H · Substantial damageNTSB ERA11CA259Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Lake Wales, FLThe pilot’s failure to maintain directional control during the landing roll.Apr 23, 2011 · N57WV · Substantial damageNTSB CEN11FA304Accident · 2 fatalField investigationFinal reportCubcrafters CC11-160 · Parker, COThe pilot’s excessive and unsafe maneuvering during gusty wind conditions, which resulted in an inadvertent stall-spin.Apr 23, 2011 · N143FJ · Substantial damageNTSB CEN11CA306Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Crosby, NDThe pilot’s failure to maintain directional control of the airplane during the crosswind landing.Apr 23, 2011 · N3854P · Substantial damageNTSB ERA11LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTMaintenance personnel's inadequate inspection of the main landing gear, which resulted in a failure of the right main landing gear’s inboard torque link lug due to a fatigue fracture. Contributing to the accident was owner's lack of compliance with a factory…Apr 22, 2011 · N2838D · Substantial damageNTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.Apr 22, 2011 · N10674 · Substantial damageNTSB CEN11FA302Accident · 4 fatalField investigationFinal reportBeech 58 · Topeka, KSThe pilot failed to maintain control of the airplane while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot’s minimal experience flying in actual instrument conditions.Apr 22, 2011 · N580EA · DestroyedNTSB WPR11CA204Accident · No injuriesData collectionFinal reportCessna 172P · Palm Springs, CAThe pilot's failure to maintain aircraft control after landing with a crosswind.Apr 21, 2011 · N62145 · Substantial damageNTSB ERA11CA280Accident · No injuriesData collectionFinal reportBombardier BD700 1A10 · Teterboro, NJThe pilot's loss of aircraft control during landing in gusty wind conditions.Apr 21, 2011 · N113CS · Substantial damageNTSB ERA11CA256Accident · No injuriesData collectionFinal reportVans RV8 · Locust Grove, GAThe pilot's failure to maintain aircraft control during the takeoff roll.Apr 21, 2011 · N190GE · Substantial damageNTSB CEN11FA300Accident · 1 fatalField investigationFinal reportDahlman-Dower Tailwind W-8 · Elk City, OKThe pilot's decision to attempt flight into instrument meteorological conditions in an airplane that was equipped for flight in visual meteorological conditions only, which resulted in the pilot’s spatial disoriented and loss of control of the airplane.Apr 21, 2011 · N7804C · Substantial damageNTSB CEN11LA296Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · New Madrid, MOThe failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.Apr 19, 2011 · N802KC · 2 aircraft · Substantial damageNTSB CEN11CA298Accident · Minor injuriesData collectionFinal reportAviat A-1C-180 · Greensburg, INThe pilot's decision to land on the grass which contained standing water. Contributing to the accident was the partial loss of power due to carburetor ice.Apr 19, 2011 · N18WY · Substantial damageNTSB OPS11IA499Incident · No injuriesIncident investigationFinal reportBoeing 737 · Camp Springs, MDThe misapplication of wake turbulence and instrument flight rules (IFR) separation criteria by air traffic controllers.Apr 18, 2011 · 2 aircraft · No damageNTSB CEN11CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT-802A · Horseshoe Lake, ARThe pilot's failure to maintain clearance from the tower due to his inadequate visual lookout.Apr 17, 2011 · N42015 · Substantial damageNTSB WPR11LA202Accident · No injuriesLimited investigationFinal reportRans S-12 · Marana, AZThe pilot's failure to conduct an adequate preflight inspection, which resulted in a loss of engine coolant during climb due to an unsecured tank cap. Contributing to the accident was the pilot's failure to use available engine power to ensure a landing on an…Apr 16, 2011 · N107JL · Substantial damageNTSB WPR11LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Payson, AZThe pilot's decision to conduct a touch-and-go arrival during his first flight to a high elevation airport, which resulted in an improper mixture adjustment and a partial loss of engine power for the takeoff and attempted climbout.Apr 16, 2011 · N1835U · Substantial damageNTSB CEN11FA292Accident · Minor injuriesField investigationFinal reportPiper PA-22/20 · New Orleans, LAThe pilot’s inadequate in-flight fuel management, which resulted in fuel starvation and a total loss of engine power.Apr 16, 2011 · N3621Z · Substantial damageNTSB CEN11CA293Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, TXThe pilot's delayed action in performing a go-around maneuver, which resulted in an impact with trees.Apr 16, 2011 · N6933A · Substantial damageNTSB ERA11CA248Accident · No injuriesData collectionFinal reportWalker J C Lancair 320 · Baltimore, MDThe pilot's improper recovery from a bounced landing.Apr 15, 2011 · N57CW · Substantial damageNTSB CEN11FA285Accident · 1 fatalField investigationFinal reportHawker-Beechcraft E-55 · De Queen, ARThe pilot’s loss of control during takeoff for undetermined reasons.Apr 15, 2011 · N3959W · Substantial damageNTSB ERA11LA249Accident · No injuriesLimited investigationFinal reportBeech D-45 (T-34B) · Linden, NCThe pilot's inadequate takeoff performance planning and procedures, which resulted in an attempted takeoff on a grass runway that was not long enough for the given conditions and airplane configuration.Apr 14, 2011 · N93013 · Substantial damageNTSB ERA11CA254Accident · No injuriesData collectionFinal reportFlight Design Ctls · Jacksonville, FLThe student pilot's improper flare, which resulted in a hard landing.Apr 14, 2011 · N178CT · Substantial damageNTSB ERA11CA250Accident · No injuriesData collectionFinal reportAviat A-1B · Burgaw, NCThe pilot's inadvertent application of brakes during the landing rollout.Apr 14, 2011 · N555XP · Substantial damageNTSB CEN11CA290Accident · No injuriesData collectionFinal reportCessna 182H · Park Falls, WIThe student pilot's failure to maintain aircraft control during an aborted landing.Apr 14, 2011 · N8364S · Substantial damageNTSB WPR11CA196Accident · No injuriesData collectionFinal reportCessna T188C · Palouse, WAThe pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.Apr 13, 2011 · N4562J · Substantial damageNTSB OPS11IA476Incident · No injuriesIncident investigationFinal reportBeech 400 · Midland, TXInadequate planning and control instructions issued to the pilots involved by the trainee controller operating the local control position and inadequate supervision by the instructor responsible for the position.Apr 13, 2011 · Military · 2 aircraft · No damageNTSB ERA11CA244Accident · No injuriesData collectionFinal reportCessna 172S · Saint Petersburg, FLThe failure of the student pilot to maintain directional control during a touch-and-go landing.Apr 13, 2011 · N2468Z · Substantial damageNTSB CEN11CA303Accident · Minor injuriesData collectionFinal reportBell 206 · Venice, LAThe pilot's improper use of the collective and cyclic control during taxi operations, which induced a dynamic rollover.Apr 13, 2011 · N887T · Substantial damageNTSB CEN11CA287Accident · Minor injuriesData collectionFinal reportAir Tractor AT503 · Telephone, TXThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.Apr 13, 2011 · N503AD · Substantial damageNTSB CEN11CA284Accident · No injuriesData collectionFinal reportPiper PA38 · Peyton, COThe pilot's loss of directional control during landing.Apr 13, 2011 · N107WC · Substantial damageNTSB WPR11LA195Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Corona, CAThe pilot’s loss of airplane control during the landing flare.Apr 12, 2011 · N11630 · Substantial damageNTSB ERA11LA240Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Richmond, VAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and subsequent impact with the ground.Apr 12, 2011 · N3547C · Substantial damageNTSB DCA11LA045Accident · No injuriesLimited investigationFinal reportAirbus A380 · Jamaica, NYthe A380 flight crew's inability to identify that the wingtip path of their airplane would not maintain safe clearance from the CRJ701. Contributing to the accident was the failure of the CRJ701 flight crew to advise ATC that they were stopped with a portion…Apr 12, 2011 · F-HPJD · 2 aircraft · Substantial damageNTSB ERA11CA238Accident · No injuriesData collectionFinal reportMooney M20K · Augusta, GAThe pilot's failure to extend the landing gear prior to landing. Contributing to the accident was the pilot’s reported fatigue.Apr 11, 2011 · N777CV · Substantial damageNTSB CEN11IA280Incident · No injuriesIncident investigationFinal reportBeech 90B · Chickasha, OKThe mechanic's improper installation of the aileron.Apr 11, 2011 · N37OU · Minor damageNTSB ERA11LA239Accident · No injuriesLimited investigationFinal reportBeech BE99 · Cedartown, GAThe failure of the left main landing gear bearings and supports due to inadequate lubrication by unknown maintenance personnel.Apr 10, 2011 · N899AE · Substantial damageNTSB ERA11LA234Accident · 1 fatalLimited investigationFinal reportLet L 33 Solo · New Castle, VAPilot incapacitation shortly after takeoff for unknown reasons.Apr 10, 2011 · N286BA · Substantial damageNTSB ERA11FA233Accident · 1 fatalField investigationFinal reportCessna 402B · Biddeford, METhe pilot did not maintain minimum controllable airspeed while on final approach with a partial loss of power in the right engine, which resulted in a loss of control. Contributing to the accident was the partial loss of engine power in the right engine due…Apr 10, 2011 · N402RC · Substantial damageNTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.Apr 10, 2011 · N100TK · Substantial damageNTSB ERA11CA237Accident · No injuriesData collectionFinal reportCessna 182A · Lesage, WVA loss of engine power due to fuel exhaustion. Contributing to the accident was the improper installation of snap fasteners to the rubberized type fuel cells which resulted in wrinkling of the fuel bladders and incorrect fuel quantity for the flight.Apr 10, 2011 · N4810D · Substantial damageNTSB ERA11CA236Accident · No injuriesData collectionFinal reportCessna 172N · Millville, NJThe pilot’s improper recovery from a bounced landing which resulted in a loss of aircraft control during the go-around.Apr 10, 2011 · N6338F · Substantial damageNTSB ERA11CA235Accident · No injuriesData collectionFinal reportRobinson R22 · Marlboro, MAThe student pilot's failure to maintain directional control during takeoff.Apr 10, 2011 · N791SH · Substantial damageNTSB CEN11LA283Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lake Charles, LAThe pilot's loss of control of the helicopter while in a hover.Apr 10, 2011 · N372LE · Substantial damage