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 WPR25LA112Accident · Serious injuriesClass 4 · LimitedFinal reportEnstrom 280FX · Waterford, CAThe pilot’s failure to maintain clearance from water while operating at a low altitude.NTSB ERA25LA150Accident · No injuriesClass 4 · LimitedFinal reportTextron T240 · Midland, VAThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapsing.NTSB CEN25LA129Accident · No injuriesClass 4 · LimitedFinal reportStemme S10-VT · Kiowa, COThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA144Accident · 1 fatalClass 3 · LimitedFinal reportSchweizer 269C · Mogadore, OHThe pilot’s decision to fly at low altitude, at night, and over water, which resulted in the helicopter’s collision with power lines.NTSB ERA25FA143Accident · 2 fatalClass 3 · FieldFinal reportRaytheon A36 · Greenville, NCThe pilot’s loss of airplane control shortly after climbing into instrument meteorological conditions due to spatial disorientation (somatogyral illusion).NTSB CEN25LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Lakeview, ARThe pilot landed short of the runway.NTSB CEN25LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCaldwell C W 162F · Mounds, OKThe student pilot’s failure to maintain control of the helicopter during a precautionary landing, which resulted in a dynamic roll over and postimpact fire.NTSB ERA25LA142Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206G · Wedgefield, FLA total loss of engine power as a result of an excessively rich fuel-to-air ratio due to the pilot’s failure to properly lean the engine’s fuel air mixture and the inadvertent activation of the auxiliary fuel pump.NTSB ERA25LA141Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Hollywood, FLA total loss of engine power was due to a fracture of the crankshaft at the No. 3 main journal, which originated from a preexisting, thermally induced crack that had gone undetected by maintenance personnel during an inspection performed as part of the…NTSB CEN25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lincoln, NEA failure of the flight crew to ensure that the landing gear was properly extended before landing.NTSB CEN25LA118Accident · No injuriesClass 4 · LimitedFinal reportJust Superstol · Paonia, COThe pilot’s failure to maintain the airplane’s directional control during the takeoff roll.NTSB WPR25LA110Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Las Vegas, NVThe pilot’s loss of helicopter control after the door opened during takeoff. Contributing to the accident was the pilot’s failure to confirm that the door was properly closed before departure.NTSB CEN25LA116Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Chicago, ILA failure of the main drive system due to the inadequate lubrication of the bearing shaft.NTSB ANC25LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Cantwell, AKThe pilot’s failure to maintain altitude during a low-altitude maneuver which resulted in inadvertent ground contact and a nose over.NTSB ERA25LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB ERA25LA137Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Lititz, PAThe pilot’s failure to maintain adequate airspeed after takeoff due to his distraction by the opening of the cabin door, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/mush condition at too low of an…NTSB ANC25LA032Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Redding, CAThe pilot's failure to maintain a stabilized approach and his delayed action to perform a go-around, resulting in a collision with the runway surface.NTSB CEN25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Romeo, MIThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the soft, wet grass.NTSB ANC25LA030Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKMaintenance personnel’s reuse of worn hardware during the installation of the landing gear assembly and the hardware’s failure and subsequent separation of the gear leg from the landing gear box assembly during taxi.NTSB ERA25LA136Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · North Myrtle Beach, SCThe pilot’s failure to maintain directional control while attempting to land in a gusty crosswind, which resulted in a runway excursion.NTSB CEN25LA111Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Pearland, TXBoth pilots’ failure to follow emergency procedures pertaining to the partial loss of engine power by either applying carburetor heat to address the carburetor icing or to abort the takeoff when they observed a partial loss of engine power during the takeoff…NTSB CEN25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Weslaco, TXThe pilot’s improper landing flare while attempting to land with a tailwind, which resulted in a hard landing.NTSB ERA25LA208Accident · No injuriesClass 4 · LimitedFinal reportWagoner Richard Searey · Zellwood, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing.NTSB CEN25LA109Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · San Antonio, TXThe pilot’s failure to maintain directional control during a gusty crosswind landing.NTSB ERA25LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Knoxville, TNThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB ANC25LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain an appropriate airspeed during the landing approach, which resulted in exceedance of the critical angle of attack and an aerodynamic stall, during gusting wind conditions.NTSB ERA25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Arcadia, FLThe pilot’s failure to maintain directional control while landing.NTSB ANC25LA022Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchor Point, AKA complete loss of engine power as a result of carburetor ice due to the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ANC25LA021Accident · Minor injuriesClass 3 · LimitedFinal reportGippsland GA-8 · Lihue, HIThe failure of the right landing gear leg due to a fatigue crack, which resulted in its separation from the airplane during taxi. Contributing to the accident, was the mechanic’s inadequate inspection of the landing gear leg during the last maintenance…NTSB CEN25LA105Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Edgemont, SDThe pilot’s failure to properly identify the proper anchor point for the supplemental harness and the crew’s incorrect use of the restraint system structure as an anchor point, which resulted in the separation of the structure.NTSB ERA25LA380Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter UH-1D · DeLand, FLThe pilot’s loss of helicopter control during landing approach in strong wind conditions, which resulted in tail rotor contact with the ground during landing.NTSB ERA25LA130Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Manchester, VTThe pilot’s improper decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the accumulation of airframe icing and a subsequent aerodynamic stall/spin.NTSB ERA25LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech E33 · Lenoir, NCThe mechanic’s inadequate annual inspection of the airplane and failure to comply with an applicable airworthiness directive, which resulted in a total loss of engine power due to oil starvation.NTSB ERA25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportIcon A5 · Smithville, TNThe pilot’s failure to retract the landing gear prior to landing in water. Contributing to the accident was the pilot’s failure to use the manufacturer’s provided checklist.NTSB ERA25LA131Accident · No injuriesClass 4 · LimitedFinal reportMallory Horton AQUA-BEE · Miami, FLThe pilot’s failure to lower the landing gear before touchdown.NTSB CEN25LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Iron River, MIThe airplane’s collision with runway lights during takeoff due to reduced airplane climb performance. Contributing to the accident was the shifting winds during takeoff which likely developed into a tailwind.NTSB ERA25LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Gainesville, GAThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane while landing in gusty crosswind conditions.NTSB ERA25LA128Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Alton Bay, NHThe pilot’s failure to maintain an appropriate glide path during the landing approach, which resulted in in the airplane contacting a snowbank short of the runway.NTSB ERA25LA124Accident · Minor injuriesClass 4 · LimitedFinal reportDecker Daniel B Searey · Tavares, FLThe pilot’s improper flare during a bounced water landing, which resulted in a nose-down and submersion of the airplane’s open cockpit in the water.NTSB WPR25LA101Accident · No injuriesClass 3 · LimitedFinal reportHughes OH-6A · Santa Teresa, NMThe flight instructor's failure to maintain helicopter control during a practice autorotation, which resulted in a hard landing and structural damage to the tail boom and subsequent failure of the tail rotor drive system.NTSB WPR25LA103Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe unmanned aircraft system’s failure to maintain clearance from an obstacle, which resulted in a loss of control and impact with terrain.NTSB WPR25LA105Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Cottonwood, AZThe pilot undergoing instructions’ loss of aircraft control during landing, and the flight instructor’s failure to promptly intervene.NTSB WPR25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Waterville, WAThe pilot’s failure to maintain directional control during landing roll.NTSB WPR25FA100Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 505 · Ririe, IDThe pilot’s inadequate preflight planning and decision to maneuver the helicopter at a low altitude, and his subsequent failure to maintain clearance from power lines.NTSB ERA25LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Argyle, NYThe mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…NTSB CEN25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 177A · Farlinville, KSA loss of engine power that resulted from fuel contamination when it was treated with a 70% isopropyl alcohol solution (antiseptic) that contained water. Contributing to the accident were vague fuel treatment instructions provided by the operator.NTSB ANC25LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Kapolei, HIThe flight instructor’s failure to avoid wake turbulence from a heavy airplane departing from a parallel runway, which resulted in a loss of airplane control during initial climb after a touch-and-go landing.NTSB WPR25LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Oxnard, CAThe student pilot’s failure to maintain directional control during landing roll.NTSB CEN25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · Greenville, MSThe pilots’ inadequate fuel planning and failure to monitor the fuel consumption which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing into wooded terrain. Contributing to the accident was the flight…NTSB CEN25LA096Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA-5A · Gladewater, TXThe failure of the carburetor inlet rubber duct after installation, which resulted in a partial loss of engine power during takeoff and subsequent impact with terrain.