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 WPR11CA387Accident · Serious injuriesData collectionFinal reportP&M GT450 · Teton Village, WYThe pilot's failure to maintain an adequate airspeed, which resulted in a stall mush to ground impact.Aug 17, 2011 · N988AZ · Substantial damageNTSB ERA11LA459Accident · Serious injuriesLimited investigationFinal reportEvans Robert W SR Pegazair 100 · Maysville, NCThe student pilot's failure to maintain adequate airspeed during initial takeoff climb, which resulted in an aerodynamic stall.Aug 17, 2011 · N523RE · Substantial damageNTSB ERA11FA463Accident · 1 fatalField investigationFinal reportQuad City Ultralight Challenger II · Ransom Township, PAThe non-certificated pilot's failure to maintain aircraft control while maneuvering, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot's lack of overall flight experience and lack of experience in the same make…Aug 17, 2011 · N6613Z · Substantial damageNTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…Aug 17, 2011 · N444YM · Substantial damageNTSB ANC11CA081Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Valdez, AKThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot.Aug 17, 2011 · N91134 · Substantial damageNTSB ERA11LA457Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Graham, NCThe individual's fuel mismanagement, which resulted in fuel exhaustion and a subsequent engine failure. Contributing the accident was the individual’s failure to maintain adequate airspeed following the engine failure, which resulted in an aerodynamic stall.Aug 16, 2011 · N492ST · Substantial damageNTSB ERA11CA460Accident · No injuriesData collectionFinal reportMooney M20R · West Chester, PAThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.Aug 16, 2011 · N121RP · Substantial damageNTSB CEN11LA579Accident · No injuriesLimited investigationFinal reportCessna 180 · Stillwater, OKThe pilot's on-ground loss of control during the landing roll upon encountering a sudden wind shift and gust.Aug 16, 2011 · N3316D · Substantial damageNTSB CEN11CA631Accident · No injuriesData collectionFinal reportCessna A188 · Ord, NEThe pilot's loss of directional control during a crosswind takeoff.Aug 16, 2011 · N9742V · Substantial damageNTSB WPR11LA384Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Oakesdale, WAThe pilot's decision to land with a high tailwind, which resulted in a nose-over.Aug 15, 2011 · N6628Q · Substantial damageNTSB WPR11FA383Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Silver Bow, MTThe pilot's failure to maintain airplane control while maneuvering.Aug 15, 2011 · N2584N · Substantial damageNTSB ERA11LA454Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Hodgenville, KYThe pilot's inadequate takeoff performance planning, which resulted in collision with an obstacle during takeoff from a turf runway that was not long enough for the given conditions.Aug 15, 2011 · N316MA · Substantial damageNTSB WPR11LA380Accident · No injuriesLimited investigationFinal reportBeech B36TC · Lemoore, CAA loss of engine power during cruise flight due to maintenance personnel's failure to adequately torque the number 4 cylinder retaining nuts, which resulted in the in-flight separation of the cylinder.Aug 14, 2011 · N6465X · Substantial damageNTSB WPR11LA379Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Los Banos, CAThe pilot’s inadequate preflight, and contamination of both the engine compressor section and the main rotor blades, which resulted in reduced performance of the engine and rotor system.Aug 14, 2011 · N475AL · Substantial damageNTSB WPR11FA382Accident · 4 fatalField investigationFinal reportCessna P210N · Burley, IDThe pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.Aug 14, 2011 · N7825K · Substantial damageNTSB WPR11FA381Accident · 2 fatalField investigationFinal reportBeech A36 · Lander, WYThe pilot’s failure to maintain clearance from mountainous terrain.Aug 14, 2011 · N324AT · DestroyedNTSB WPR11CA376Accident · No injuriesData collectionFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain clearance from obstacles while taxiing.Aug 14, 2011 · N216AF · Substantial damageNTSB ERA11CA452Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Front Royal, VAThe pilot’s failure to attain the proper touchdown point.Aug 14, 2011 · N4341M · Substantial damageNTSB CEN11LA578Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Fabens, TXThe pilot’s decision to continue the high density altitude takeoff with reduced engine power and his decision to initiate a turn back to the runway with insufficient airspeed, which resulted in an aerodynamic stall.Aug 14, 2011 · N53473 · Substantial damageNTSB CEN11LA575Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sabetha, KSThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Contributing to the accident was the pilot's lack of certification to act as a pilot and his lack of recent experience.Aug 14, 2011 · N6953S · Substantial damageNTSB CEN11CA576Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Stanberry, MOThe pilot’s failure to maintain directional control during takeoff.Aug 14, 2011 · N42860 · Substantial damageNTSB ANC11FA077Accident · 2 fatalField investigationFinal reportCessna 207 · McGrath, AKThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.Aug 14, 2011 · N91099 · Substantial damageNTSB ERA11CA455Accident · No injuriesData collectionFinal reportG-Dawg Just Acft Highlander · Abingdon, VAThe pilot's inadequate compensation for wind conditions during the aborted takeoff.Aug 13, 2011 · N376CG · Substantial damageNTSB ERA11CA453Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · West Liberty, KYThe pilot's failure to obtain the proper touchdown point during landing, which resulted in a runway excursion.Aug 13, 2011 · N5080M · Substantial damageNTSB ERA11CA450Accident · No injuriesData collectionFinal reportCessna 172M · Elkins, WVThe flight instructor's unfamiliarity with the geographic area, resulting in controlled flight into terrain.Aug 13, 2011 · N5399Q · Substantial damageNTSB ERA11CA449Accident · Minor injuriesData collectionFinal reportNorth American AT-6D · Canon, GAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Aug 13, 2011 · N7435U · Substantial damageNTSB CEN11LA672Accident · Serious injuriesLimited investigationFinal reportPorbeck John M Slipstream Genesis · Bryan, TXThe pilot’s failure to maintain adequate airspeed and attitude during a turn toward downwind, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's limited experience in the experimental airplane.Aug 13, 2011 · N53QB · Substantial damageNTSB CEN11LA671Accident · Serious injuriesLimited investigationFinal reportFisher Michael E Hyster · Lake Jackson, TXThe improper maintenance of the throttle control cable, which resulted in the engine going to idle power after takeoff.Aug 13, 2011 · N7167S · Substantial damageNTSB CEN11LA573Accident · 1 fatalLimited investigationFinal reportStevens R P/Mccright D W Vans RV-6 · Conroe, TXThe failure of the pilot of the RV-6 airplane to maintain clearance from the RV-8 airplane while practicing formation flight.Aug 13, 2011 · N16DD · 2 aircraft · Substantial damageNTSB CEN11LA571Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Uvalde, TXThe pilot’s failure to maintain airspeed while maneuvering to avoid power lines during a precautionary landing, which resulted an aerodynamic stall. Contributing to the accident was the fluctuating engine power for undetermined reasons and the pilot's…Aug 13, 2011 · N10119 · Substantial damageNTSB CEN11LA569Accident · 2 fatalLimited investigationFinal reportFairchild M-62 · Madrid, IAThe pilot's improper decision to conduct low-level flight along a river, which resulted in a collision with power lines.Aug 13, 2011 · N53956 · Substantial damageNTSB ANC11CA076Accident · Minor injuriesData collectionFinal reportPiper PA-18-135 · Coldfoot, AKThe pilot's inadvertent application of the right brake pedal during the landing roll, which resulted in a nose-over.Aug 13, 2011 · N1258C · Substantial damageNTSB WPR11CA399Accident · No injuriesData collectionFinal reportRichmond Jim R CCK-1865 · Dubois, WYThe pilot's failure to maintain clearance from a wire during cruise flight.Aug 12, 2011 · N56WY · Substantial damageNTSB ERA11LA451Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Arcadia, FLThe pilot’s decision to take off in high density altitude conditions with the airplane over its maximum gross weight, due to the pilot’s improper weight and balance calculations, which resulted in the airplane’s inability to climb or maintain altitude.Aug 12, 2011 · N8737Q · Substantial damageNTSB ANC11CA075Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Kodiak, AKA partial loss of engine power while on approach to land due to a disconnected throttle control linkage, and the maintenance director's inadequate inspection of the throttle linkage during maintenance.Aug 12, 2011 · N8152Z · Substantial damageNTSB ERA11CA448Accident · No injuriesData collectionFinal reportRobinson R22 · Titusville, FLThe private pilot's incorrect manipulation of the engine mixture control which resulted in an inadvertent engine shutdown.Aug 11, 2011 · N62JF · Substantial damageNTSB CEN11LA566Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Nelson, NEFailure of the fuel control unit's spool cap bearing for reasons that could not be determined during extensive postaccident examination, and the pilot’s decision to shut the engine down without sufficient altitude and distance to reach the runway.Aug 11, 2011 · N3659N · Substantial damageNTSB CEN11CA564Accident · No injuriesData collectionFinal reportBeech 35-C33 · Rockwall, TXThe pilot's loss of control while landing with a tailwind due to his misinterpretation of the wind conditions.Aug 11, 2011 · N12CA · Substantial damageNTSB ANC11CA078Accident · No injuriesData collectionFinal reportPiper PA-11 · Chenga Bay, AKThe pilot's improper decision to land on an unsuitable landing surface which resulted in a nose over.Aug 11, 2011 · N78635 · Substantial damageNTSB WPR11CA360Accident · No injuriesData collectionFinal reportAircraft Mfg & Design CH750 Stol · New Washoe City, NVThe pilot under instruction's control interference and the CFI's inadequate supervision of the flight.Aug 10, 2011 · N799US · Substantial damageNTSB CEN11CA567Accident · No injuriesData collectionFinal reportFlight Design Ctls · Ankeny, IAThe pilot's improper landing flare, which resulted in a hard landing.Aug 10, 2011 · N227CT · Substantial damageNTSB CEN11CA565Accident · No injuriesData collectionFinal reportWeatherly 201C · Bronson, IAThe pilot's failure to maintain clearance from terrain while maneuvering during an aerial application flight.Aug 10, 2011 · N9054W · Substantial damageNTSB ERA11CA445Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Charleston, SCThe pilot's decision to continue the approach and landing at a high airspeed, which resulted in an improper touchdown point and subsequent runway excursion.Aug 9, 2011 · N30731 · Substantial damageNTSB CEN11CA561Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to extend the landing gear prior to landing.Aug 9, 2011 · N9281R · Substantial damageNTSB WPR11LA389Accident · No injuriesLimited investigationFinal reportGlasair Sportsman · Pinedale, WYThe pilot's failure to maintain directional control during the landing roll.Aug 8, 2011 · N117CE · Substantial damageNTSB WPR11LA377Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Deer Park, WAThe student pilot's failure to maintain control of the helicopter and his delay in relinquishing control to the flight instructor, which resulted in the instructor’s delayed remedial actions and subsequent hard landing.Aug 8, 2011 · N8332T · Substantial damageNTSB WPR11LA375Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Willcox, AZThe pilot's failure to maintain clearance from a tower while maneuvering at low altitude. Contributing to the accident was the recent installation of the unmarked tower.Aug 8, 2011 · N5123L · Substantial damageNTSB OPS11IA819Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Chicago, ILThe improper air traffic control takeoff clearance issued by the local controller because of his lack of monitoring and lack of awareness of the conflicting arrival airplane.Aug 8, 2011 · N377SK · 2 aircraft · No damageNTSB ERA11CA446Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot's loss of directional control while attempting to close the airplane's door during takeoff roll.Aug 8, 2011 · N65777 · Substantial damageNTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.Aug 8, 2011 · N2286P · Substantial damage