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 CEN14LA255Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 602 · Gueydan, LAThe pilot's failure to maintain airplane control, which resulted in a stall and subsequent collision with power lines.NTSB CEN14CA260Accident · No injuriesData collectionFinal reportCessna 120 · Wadsworth, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.NTSB WPR14CA213Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Cedar Valley, UTThe pilot's failure to maintain aircraft control during the takeoff roll, which resulted in inadvertent terrain contact by the wing.NTSB WPR14CA210Accident · No injuriesData collectionFinal reportMeyers OTW 160 · Tehachapi, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with a fence.NTSB ERA14LA261Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Cooperstown, NYThe pilot’s delayed use of carburetor heat during the approach to landing, which resulted in the formation of carburetor ice, a partial loss of engine power, and the airplane’s subsequent inability to sustain flight.NTSB ERA14FA256Accident · 1 fatalField investigationFinal reportStolp Starduster SA-300 · Newton, NCThe pilot’s failure to recover from an intentional spin. Contributing to the accident was the pilot’s lack of adequate spin entry and recovery training.NTSB CEN14CA268Accident · No injuriesData collectionFinal reportFlight Design Ctsw · New Carlisle, OHThe pilot did not maintain control of the airplane while landing.NTSB ANC14CA029Accident · No injuriesData collectionFinal reportPiper PA 18-105 Special · Anchorage, AKThe pilot's loss of control of the airplane during landing roll on a rough, grass airstrip in gusting wind.NTSB ERA14FA255Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Fountain, FLThe pilot's decision to depart from a soft runway with a tailwind and toward obstructions, and his failure to follow the manufacturer's recommended procedures for the takeoff. Contributing to the accident were the degradation of airplane and engine…NTSB ERA14CA265Accident · No injuriesData collectionFinal reportDivis S L/Waltrip A J RV 4 · Harpswell, METhe pilot's inadequate preflight and in-flight planning which resulted in total loss of engine power due to fuel exhaustion.NTSB ERA14CA262Accident · Minor injuriesData collectionFinal reportEvolution Trikes Revo · Williamsburg, VAThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with water.NTSB ERA14CA259Accident · No injuriesData collectionFinal reportBrantly B 2B · Essex, MDThe pilot's failure to maintain helicopter control during landing resulting in a hard landing and a roll over.NTSB CEN14CA252Accident · No injuriesData collectionFinal reportAerospatiale AS 365 N2 Dauphin · Constantine, MIThe pilot's loss of control while entering a vortex ring state (settling with power) condition, which resulted in a hard landing.NTSB WPR14LA208Accident · No injuriesLimited investigationFinal reportCessna 182P · Mammoth Lakes, CAThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to carburetor icing.NTSB WPR14FA209Accident · 1 fatalField investigationFinal reportKenneth A Berger Searey LSX · Electric City, WAThe pilot’s failure to maintain pitch control during takeoff after encountering a boat wake, which resulted in the airplane bouncing, impacting the water’s surface, and subsequently becoming submerged.NTSB WPR14CA211Accident · No injuriesData collectionFinal reportFdr601 Zodiac 601XL · Lewiston, IDThe pilot's improper flare during landing.NTSB ERA14CA263Accident · Minor injuriesData collectionFinal reportCessna 182J · Perkasie, PAThe pilot's failure to select and attain a proper touchdown point during landing which resulted in a runway overrun.NTSB CEN14LA259Accident · Serious injuriesLimited investigationFinal reportSibley Glasair · Midlothian, TXThe pilot’s failure to maintain lateral control during the initial climb. Contributing to the accident was the pilot’s failure to obtain sufficient training and experience to operate the high-performance airplane.NTSB CEN14LA251Accident · Serious injuriesLimited investigationFinal reportSmythe Donald F Kitfox Classic IV · Slaughter, LAThe pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.NTSB CEN14CA310Accident · No injuriesData collectionFinal reportCessna 421A · Dallas, TXThe improper rigging of the landing gear by maintenance personnel, which resulted in the landing gear collapse.NTSB CEN14CA258Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hunter, ARThe pilot's downwind takeoff from a grass airstrip, which resulted in inadequate climb performance and the subsequent impact with terrain.NTSB CEN14CA257Accident · Minor injuriesData collectionFinal reportPiper PA 28R-200 · La Pointe, WIThe pilot's failure to maintain control of the airplane during the landing.NTSB WPR14LA206Accident · Minor injuriesLimited investigationFinal reportWilliams Helicopter UH 1H · Waitsburg, WAAn extreme vibration immediately after entering forward flight for reasons that could not be determined because postaccident examination of the helicopter did not reveal any anomalies that would have precluded normal operation. Contributing to the accident…NTSB WPR14FA203Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Santa Paula, CAThe pilot's failure to maintain clearance from power lines while flying at a low altitude.NTSB WPR14CA401Accident · No injuriesData collectionFinal reportPiper PA 22 · Roundup, MTThe pilot's delayed action to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude.NTSB WPR14CA214Accident · No injuriesData collectionFinal reportOlson Kitfox II · Helena, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane nosing over.NTSB ERA14FA260Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA1B · Chester, SCThe pilot's inadequate inflight fuel monitoring, which resulted in fuel exhaustion and the subsequent total loss of engine power. Contributing to the accident was the loose fuel cap, which allowed fuel to syphon out in flight.NTSB ERA14CA273Accident · No injuriesData collectionFinal reportCessna 172S · Harrisburg, PAThe pilot's failure to compensate for wind conditions during landing, which resulted in a hard landing.NTSB CEN14FA249Accident · 4 fatalField investigationFinal reportRaytheon G36 · Silver City, NMThe airplane’s encounter with a strong tailwind and/or windshear, which resulted in an inadvertent stall. Contributing to the accident was the pilot’s continuation of the unstable approach, long landing, and delayed decision to conduct a go-around.NTSB WPR14LA199Accident · No injuriesLimited investigationFinal reportBeech H35 · Parker, AZThe improperly attached fuel line and cracked fuel diaphragm due to unknown personnel’s inadequate maintenance, which resulted in the loss of engine power during cruise flight and the subsequent forced landing onto rough terrain.NTSB WPR14CA204Accident · No injuriesData collectionFinal reportCessna 150C · Wellington, NVThe pilot's failure to maintain aircraft control while departing from a wet runway.NTSB ERA14LA257Accident · Serious injuriesLimited investigationFinal reportP&M Quikr · Gulf Shores, ALThe pilot’s failure to maintain aircraft control during engine startup, which resulted in a collision with a parked airplane. Contributing to the accident was the pilot’s failure to follow engine startup procedures and a sudden surge of engine power for…NTSB ERA14LA253Accident · Serious injuriesLimited investigationFinal reportPiper J3C - 65 · Hopkinsville, KYThe failure of the pilot to identify poor engine performance during the engine run-up before takeoff. Also causal to the accident was the mistimed right magneto and the poor condition of the spark plugs in the No. 4 cylinder.NTSB ERA14CA320Accident · No injuriesData collectionFinal reportFairchild M 62C(PT-23A) · Petersburg, VAThe flight instructor's failure to maintain control of the airplane during the landing attempt. Contributing to the accident was the changing wind conditions.NTSB WPR14LA198Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Medicine Lake, MTThe pilot’s failure to maintain airplane control and sufficient altitude to clear terrain during a low-altitude maneuver.NTSB WPR14CA200Accident · No injuriesData collectionFinal reportCessna 180 · Cameron Park, CAThe pilot's failure to maintain directional control during landing which resulted in a ground-loop and nose over.NTSB WPR14CA197Accident · Minor injuriesData collectionFinal reportCessna 140 · Vacaville, CAThe pilot's use of excessive brakes during landing, which resulted in a nose over. Contributing to the accident was a partial loss of engine power during takeoff initial climb, likely due to carburetor ice.NTSB ERA14LA254Accident · Serious injuriesLimited investigationFinal reportJohn V Rawson JR Sprint II · Princeton, NJThe pilot’s failure to maintain airplane control during the approach to land. Contributing to the accident was the pilot’s unfamiliarity with and lack of training in the accident airplane make and model.NTSB ERA14LA248Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron Canada 206 L4 · Beverly, MAMaintenance personnel’s inadequate inspection of the engine’s outer combustion case, which resulted in the failure of the case due to fatigue cracks that initiated on the inside surface of the case and the subsequent total loss of engine power.NTSB ERA14IA249Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Warren, VTThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14CA270Accident · No injuriesData collectionFinal reportWonder Michael S Harmon Rocket · Winston Salem, NCThe pilot's failure to maintain directional control during landing in a gusty crosswind which resulted in a runway excursion and collision with terrain.NTSB ERA14CA250Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Sussex, NJThe pilot's failure to maintain proper airspeed while on approach, and his subsequent failure to recover from a bounced landing, which resulted in a hard landing.NTSB CEN14CA264Accident · No injuriesData collectionFinal reportLauritsen Ralph M RV 4 · Rockwell City, IAThe pilot's improper landing flare which resulted in a hard landing.NTSB ERA14CA258Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe student pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB WPR14CA274Accident · No injuriesData collectionFinal reportCessna 172 - R · Buckeye, AZThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN14LA245Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Yuma, COThe pilot's failure to maintain directional control after the airplane encountered a wind gust during takeoff roll. Contributing to the accident was the pilot inadvertently using a runway that resulted in a gusty tailwind condition.NTSB CEN14CA330Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8E · Douglass, KSThe pilot's excessive use of wheel brakes during landing, which resulted in a nose-over. Contributing to the accident were high winds and a short, downhill sloped runway.NTSB WPR14FA195Accident · 1 fatalField investigationFinal reportAmerican Eurocopter AS350B3 · Peach Springs, AZThe pilot’s decision to exit the helicopter while it was running and his failure to properly secure the flight controls with the engine operating at flight idle before exiting the helicopter.NTSB WPR14CA212Accident · No injuriesData collectionFinal reportPiper PA 18A · Arlington, WAThe pilot's improper application of brakes during taxi in tailwind conditions, which resulted in a loss of aircraft control and subsequent nose over.NTSB WPR14CA196Accident · No injuriesData collectionFinal reportBell 47G · Bakersfield, CAThe pilot's failure to maintain aircraft control after the helicopter's skid catching on the side of a trailer during takeoff, which resulted in a dynamic rollover.