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 GAA18CA163Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe pilot’s improper landing flare, which resulted in substantial damage.NTSB GAA18CA158Accident · Minor injuriesData collectionFinal reportJohnson Gerald CR-1 · Altamont, NYThe pilot’s failure to maintain the runway heading during the approach in gusting crosswind conditions.NTSB GAA18CA156Accident · No injuriesData collectionFinal reportStinson 108 · Cedar Rapids, IAThe pilot’s improper landing flare, which resulted in a loss of directional control and a nose-over.NTSB GAA18CA181Accident · No injuriesData collectionFinal reportPiper PA22 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in tailwind conditions.NTSB GAA18CA165Accident · No injuriesData collectionFinal reportBellanca 1413 · Anacortes, WAThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA159Accident · No injuriesData collectionFinal reportHughes 269 · Jacksonville, FLThe pilot’s failure to maintain rotor rpm during a practice autorotation, which resulted in ground contact and a dynamic rollover.NTSB CEN18LA119Accident · Serious injuriesClass 2 · LimitedFinal reportCzech Sport Piper Sport · Addison, TXThe operator’s use of improper fuel, which resulted in partial loss of engine power due to vapor lock.NTSB GAA18CA171Accident · No injuriesData collectionFinal reportBeech 76 · Oshkosh, WIThe pilot’s failure to extend the landing gear and the flight instructor’s failure to ensure that the landing gear were extended during landing. Contributing to the accident were the pilot’s and the instructor’s improper use of checklist.NTSB GAA18CA164Accident · No injuriesData collectionFinal reportCessna 180 · Mount Vernon, WAThe pilot’s failure to maintain directional control of the airplane during landing.NTSB GAA18CA152Accident · Minor injuriesData collectionFinal reportPiper PA 32R · Big Spring, TXThe pilot’s failure to manage the airplane’s fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s decision to attempt the flight with an inoperative fuel gauge.NTSB GAA18CA153Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Many, LAThe pilot’s improper application of the brakes during landing, which resulted in a nose-over.NTSB CEN18LA118Accident · Minor injuriesLimited investigationFinal reportBereznak Lancair Legacy · Temple, TXThe failure of the fuel selector valve in a nearly closed position, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN18FA116Accident · 2 fatalField investigationFinal reportPiper PA 31P · Laredo, TXAn engine malfunction for undetermined reasons and the subsequent loss of control, due to the pilot's improper decision to maneuver the airplane below minimum controllable airspeed and his improper response to the loss of engine power.NTSB WPR18LA101Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Paso Robles, CAThe pilots' inadequate preflight inspection, which failed to ensure that the oil filler cap was secured and resulted in oil starvation and a total loss of engine power.NTSB GAA18CA160Accident · No injuriesData collectionFinal reportCessna 172 · England, ARThe pilot’s failure to detect water in the fuel system during the preflight inspection, which resulted in a loss of engine power during departure and a subsequent impact with terrain.NTSB GAA18CA151Accident · No injuriesData collectionFinal reportCessna 172 · Lakeland, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.NTSB ERA18LA098Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Churchville, MDThe pilot's improper landing flare, which resulted in the airplane ballooning on touchdown, and his subsequent failure to maintain directional control during the attempted landing and subsequent go-around.NTSB CEN18LA177Accident · No injuriesLimited investigationFinal reportCessna 150M · Sinton, TXThe inadequate service and repair of the airplane's carburetor, which led to a partial loss of engine power during takeoff and resulted in a forced landing.NTSB CEN18LA121Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Blair, WIThe pilot’s failure to recognize and compensate for hazards during the external load operation, which led to a collision between a lineman (external load) and a powerline.NTSB ERA18LA097Accident · Minor injuriesLimited investigationFinal reportReilly Charles W Escapade · Palatka, FLThe interruption of fuel to the engine during final approach, which resulted in a total loss of engine power due to fuel starvation, and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.NTSB WPR18LA102Accident · No injuriesClass 3 · LimitedFinal reportMacdonald Craig MAC CUB · Ogden, UTThe pilot’s failure to use carburetor heat during the flight, which resulted in a partial loss of engine power due to carburetor icing.NTSB ERA18LA095Accident · 1 fatalLimited investigationFinal reportRobert Snyder Autogyro Calidus · Beaufort, SCThe gyroplane pilot's failure to maintain rotor speed and aircraft control as he was attempting to return to the runway during a low-altitude simulated engine-out maneuver.NTSB GAA18CA184Accident · No injuriesData collectionFinal reportPiper PA32 · Camas, WAThe pilot’s inadequate inflight fuel management and his failure to switch to a fuel tank with adequate fuel, which resulted in fuel starvation.NTSB GAA18CA204Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot’s failure to maintain a stabilized approach, which resulted in overcorrection with the rudder during the landing, loss of control, and a runway excursion.NTSB CEN18LA113Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Deport, TXA total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot/owner's inadequate maintenance of the fuel caps.NTSB GAA18CA149Accident · Minor injuriesData collectionFinal reportBeech B · Ferris, TXThe pilot’s improper preflight inspection of the fuel level, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to lower the landing gear before the emergency landing.NTSB ERA18LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 32-300 · Pompano Beach, FLThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall, loss of control, and impact with terrain. Contributing to the accident was the pilot’s failure to maintain a proper approach…NTSB ERA18LA094Accident · 2 fatalLimited investigationFinal reportCessna 172 · Ocean City, MDThe pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information.NTSB CEN18LA114Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Odessa, TXThe pilot’s improper takeoff procedures and his failure to abort the takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB WPR18CA096Accident · Serious injuriesData collectionFinal reportBell 47G · Pixley, CAA total loss of engine power due to fuel starvation, which resulted from the pilot’s failure to ensure that adequate fuel was on board for the flight. Contributing to the accident was the pilot’s self-induced pressure to complete the flight due to impending…NTSB GAA18CA146Accident · Minor injuriesData collectionFinal reportCessna 172 · Gatesvile, TXThe pilot’s failure to maintain directional control during initial climb in a gusty condition.NTSB GAA18CA145Accident · No injuriesData collectionFinal reportPiper PA28R · Milton-Freewater, ORThe pilot receiving instruction’s and flight instructor’s improper decision to enter a canyon surrounded by steep rising terrain and their subsequent failure to maintain clearance from terrain while maneuvering at a low altitude.NTSB ERA18FA092Accident · 2 fatalField investigationFinal reportQuest Kodiac 100 · Georgetown, FLThe pilots' spatial disorientation while maneuvering for landing in night conditions over unlighted terrain, which resulted in an uncontrolled descent and impact with water.NTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.NTSB GAA18CA154Accident · No injuriesData collectionFinal reportCessna 207 · Newtok, AKThe pilot’s failure to maintain directional control during takeoff. Contributing to the accident was the pilot’s failure to properly check that the flight controls were correctly configured before takeoff.NTSB GAA18CA142Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna Astore · Apopka, FLThe student pilot’s failure to maintain directional control during takeoff.NTSB ERA18LA089Accident · 1 fatalClass 2 · LimitedFinal reportAirborne Windsports PTY Edge XT 912 L · Eustis, FLThe pilot's exceedance of the weight-shift-control aircraft's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot's lack of experience in the…NTSB GAA18CA147Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a dynamic rollover.NTSB GAA18CA140Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Woodland, CAThe pilot’s distraction due to her malfunctioning iPad, which led to her inadvertent forward cyclic application.NTSB ERA18LA087Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander Callair A 9 · Bunn, NCThe glider instructor's delayed remedial action when the glider became out of position during aerotow, which resulted in excessive side-loading of the release hook and a delay in the glider's release from tow, which resulted in the towplane’s descent and…NTSB GAA18CA141Accident · No injuriesData collectionFinal reportCessna 172 · Show Low, AZThe flight instructor’s failure to maintain directional control during the landing roll in gusting crosswind and tailwind conditions.NTSB ERA18LA086Accident · Minor injuriesClass 3 · LimitedFinal reportStearman B75 · Zephryhills, FLThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power and impact with a pole during a forced landing.NTSB CEN18FA107Accident · 3 fatalField investigationFinal reportCessna 441 · Rossville, INAn in-flight loss of control for reasons that could not be determined based on the available evidence.NTSB WPR18FA095Accident · 4 fatalField investigationFinal reportPiper PA32R · Monticello, UTThe noninstrument-rated pilot's continued flight into a region of deteriorating ceiling and visibility conditions, which resulted in controlled flight into terrain event.NTSB GAA18CA198Accident · No injuriesData collectionFinal reportCessna 172 · Brunswick, GAThe pilot receiving instruction’s failure to see and avoid an airplane holding short of the runway on the taxiway and the flight instructor’s lack of situational awareness.NTSB WPR18FA093Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · San Diego, CAThe pilot's exceedance of the airplane's critical angle of attack during an attempted return to the runway following a total loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the excessive amount of…NTSB ERA18FA084Accident · 1 fatalField investigationFinal reportPiper PA28 · Bonifay, FLA partial loss of engine power due to a stuck exhaust valve. Contributing to the accident was the pilot's decision to operate an airplane with a known mechanical deficiency and his failure to fly an appropriate traffic pattern that would have allowed the…NTSB GAA18CA174Accident · No injuriesData collectionFinal reportCessna P210 · Jacksonville, FLThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were pilot fatigue and his failure to use the before landing checklist.NTSB WPR18LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Obyan, SarkThe pilot's inadequate preflight fuel planning and inadequate in-flight fuel monitoring which resulted in a total loss of engine power due to fuel exhaustion and an emergency landing and subsequent impact with a ditch.