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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR14CA306Accident · No injuriesData collectionFinal reportBosco Don Searey · Mount Vernon, WAThe pilot's failure to maintain lateral control while taxiing. Contributing to the accident was the incorrect decision to takeoff once the sponson had been damaged.NTSB ERA14CA348Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Titusville, FLThe student pilot's failure to initiate the decelerative flare during autorotation and the CFI's delayed remedial action, which resulted in a hard landing.NTSB CEN14CA381Accident · No injuriesData collectionFinal reportCessna 150D · Greenfield, INThe student pilot failed to maintain directional control while landing with a crosswind.NTSB WPR14FA303Accident · 4 fatalField investigationFinal reportCessna 182L · Sedona, AZThe pilot’s failure to maintain adequate airspeed and his exceedance the airplane’s critical angle-of attack while maneuvering through a canyon in high-density altitude conditions at low altitude, which resulted in an aerodynamic stall.NTSB ERA14LA347Accident · Serious injuriesLimited investigationFinal reportColt Balloons 160A · Clinton, MAThe pilot's inadequate preflight and inflight planning and improper landing site selection and approach path, which resulted in the balloon contacting powerlines during landing. Contributing to the accident was the Federal Aviation Administration's inadequate…NTSB CEN14LA388Accident · No injuriesLimited investigationFinal reportCessna 177B · Georgetown, TXThe pilot’s improper recovery from a bounced landing.NTSB CEN14FA377Accident · 1 fatalField investigationFinal reportOden Weldon Pat Kitfox IV Speedster · Blackwell, TXThe pilot's loss of airplane control following a loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN14CA386Accident · No injuriesData collectionFinal reportBlack Christopher Sparrow Sport Spec · Moriarty, NMThe pilot's loss of directional control while landing in gusty crosswind conditions. Contributing to the accident was the pilot's operation of the engine above its normal temperature limit on takeoff.NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.NTSB WPR14CA319Accident · No injuriesData collectionFinal reportBell 206B · Salinas, CAThe pilot's failure to ensure adequate clearance from ground obstacles during takeoff which resulted in loss of aircraft control.NTSB WPR14CA301Accident · Minor injuriesData collectionFinal reportErcoupe 415 C · Hubbart, ORThe pilot's failure to maintain aircraft control and proper alignment during approach for landing in gusting wind conditions.NTSB ERA14FA345Accident · 3 fatalField investigationFinal reportMooney M20F · North Elba, NYThe pilot’s failure to maintain adequate airspeed for the airplane’s configuration and flight profile, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.NTSB ERA14CA364Accident · No injuriesData collectionFinal reportCessna 177B · Falmouth, MAThe pilot's misjudgment of speed and distance on final approach resulting in a touchdown near the departure end of the runway, a runway excursion, and collision with trees.NTSB CEN14CA384Accident · No injuriesData collectionFinal reportCessna T206H · Sterling City, TXThe pilot's failure to maintain directional control of the airplane during the crosswind landing.NTSB ANC14LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s inadvertent application of excessive brake pressure during landing on a rough surface, which resulted in a nose-over.NTSB WPR14CA299Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Hoopa, CAThe pilot's inadequate approach and excessive airspeed which resulted in a long landing and subsequent runway overrun onto rough terrain.NTSB WPR14CA296Accident · Serious injuriesData collectionFinal reportBell 47G 2A · Merced, CAThe pilot's failure to adequately monitor the environment to maintain clearance from the power pole guide wire during low level maneuvering.NTSB CEN14LA376Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 401B · Ellis, KSThe noninstrument-rated pilot’s inadequate preflight weather planning and subsequent inadvertent encounter with instrument meteorological conditions, which resulted in spatial disorientation and the loss of airplane control. Contributing to the accident was…NTSB CEN14CA383Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · St. Louis, MOThe pilot's decision to operate an airplane with a known deficiency and to not properly secure the airplane before hand-starting the engine.NTSB ERA14CA395Accident · No injuriesData collectionFinal reportBoeing E75N1 · Penridge, PAThe pilot's delayed action in correcting a drift to the right during landing roll and his improper use of the wheel brakes which resulted in the airplane nosing over.NTSB ERA14CA354Accident · No injuriesData collectionFinal reportCessna 172P · Hagerstown, MDThe student pilot's improper landing flare.NTSB CEN14FA369Accident · 3 fatalField investigationFinal reportAgusta A109E · Newkirk, NMThe pilot's inadvertent visual flight into instrument meteorological conditions, which resulted in a loss of helicopter control.NTSB CEN14CA382Accident · Serious injuriesData collectionFinal reportGremminger Greg Magni M 16 · Cape Girardeau, MOThe pilot's failure to maintain sufficient altitude while maneuvering which led to a collision with power lines.NTSB WPR14CA294Accident · Minor injuriesData collectionFinal reportThrush S2RHG T65 · Parma, IDThe pilot's decision to take off with a tailwind, which resulted in the airplane not attaining sufficient airspeed for takeoff.NTSB ERA14LA355Accident · No injuriesLimited investigationFinal reportPipistrel Alpha Trainer · Pompano Beach, FLThe pilot’s miscalculation of the fuel quantity requirements, which resulted in fuel exhaustion.NTSB ERA14LA342Accident · Serious injuriesLimited investigationFinal reportHolmlund Victor P Auriga · Manville, NJThe pilot’s improper preflight fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14FA343Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · North Captiva Island, FLThe pilot’s failure to secure the cargo in the cargo compartment, which resulted in a weight shift that led to the center of gravity exceeding its aft limit during a go-around attempt and a subsequent aerodynamic stall. Also causal to the accident were the…NTSB CEN14LA374Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockville, INA partial loss of engine power due to a failure of the dual magneto system. Contributing to the accident was the improper maintenance of the duel magneto system.NTSB CEN14CA457Accident · No injuriesData collectionFinal reportCessna 172N · Murphysboro, ILA hard landing by person(s) unknown.NTSB CEN14CA370Accident · No injuriesData collectionFinal reportCessna 120 · Midland, MIThe pilot's failure to maintain sufficient airspeed and his delayed application of engine power while on short final which resulted in a hard landing.NTSB CEN14CA367Accident · No injuriesData collectionFinal reportAmerican Eurocopter AS350B3 · Grand Praire, TXThe flight instructor's inadequate supervision during a practice autorotation. Contributing to the accident was the pilot's hard landing during a practice autorotation.NTSB WPR14CA293Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Marysville, CAThe pilot's failure to adequately monitor the environmental conditions to assure the aircraft performance would afford an uneventful takeoff with the loading conditions. Contributing to the accident were the pilot's inability to jettison the load due to the…NTSB WPR14CA292Accident · Serious injuriesData collectionFinal reportJonker Sailplanes JS1-C · Truckee, CAThe pilot's failure to maintain aircraft control in gusting wind conditions while on final approach to the runway.NTSB ERA14LA341Accident · No injuriesLimited investigationFinal reportLet L 23 Super Blanik · Warm Springs, GAThe failure of the flight instructor to move his glider from an active runway in accordance with procedures due to his distraction by having a conversation with the air boss, which resulted in the landing glider colliding with the glider on the runway.NTSB CEN14CA364Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's failure to maintain control during landing.NTSB ANC14LA054Accident · No injuriesLimited investigationFinal reportCessna 180H · Seward, AKThe pilot’s execution of a hard uncoordinated landing, which resulted in the overstress fracture of the right main landing gear (MLG) axle attachment bolts and the subsequent separation of the of the right MLG axle.NTSB ERA14FA339Accident · 2 fatalField investigationFinal reportAllen Steen Skybolt · Carrollton, GAAn in-flight loss of airplane control for reasons that could not be determined during postaccident examinations or based on the available evidence.NTSB CEN14LA372Accident · 1 fatalLimited investigationFinal reportJonker Sailplanes JS1-C · Wallis, TXThe pilot’s loss of glider control and its subsequent impact with terrain for reasons that could not be determined due to a lack of available information.NTSB CEN14CA368Accident · Minor injuriesData collectionFinal reportMckenzie Douglas E Stol CH750 · Dodgeville, MIThe pilot's failure to maintain control of the airplane during takeoff resulting in an impact with a tree and terrain.NTSB ERA14FA337Accident · 1 fatalField investigationFinal reportCulver LFA · Limington, METhe pilot’s failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…NTSB CEN14CA362Accident · No injuriesData collectionFinal reportAeronca 65CA · Pulaski, WIThe student pilot's improper flight control inputs resulting in a loss of control during the landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB WPR14CA290Accident · Minor injuriesData collectionFinal reportBell 47K · Kingston, WAThe pilot's failure to maintain aircraft control during the landing approach, which resulted in an excessive descent angle and settling with power.NTSB WPR14CA289Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll.NTSB ENG14IA019Incident · No injuriesIncident investigationFinal reportBoeing 767 332 · Los Angeles, CAThe combination of fuel leaking from the integrated drive generator (IDG) fuel/oil heat exchanger and the coincident arcing of the IDG power feeder cables that ignited the leaking fuel. Contributing to the ignition of the fuel was the misrouting of the IDG…NTSB CEN14FA356Accident · 1 fatalField investigationFinal reportMooney M20M · Greenwood, INA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. Also causal to the accident was the pilots' decision…NTSB CEN14CA366Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Cavalier, NDThe pilot's loss of control during the takeoff roll.NTSB CEN14CA360Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Englewood, COThe pilot did not maintain control of the helicopter during the takeoff resulting in low rotor rpm and impact of the fuel trailer during the running landing.NTSB ANC14CA053Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Prudhoe Bay, AKThe pilot's failure to maintain directional control during landing and attempted go-around, resulting in contact with terrain and a ground loop.NTSB ERA14LA336Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Titusville, FLThe pilot's failure to secure the fuel strainer drain during the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.