NTSB investigations
19,222 cases where NTSB found Aircraft.
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\", '01')) 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", '01')) 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 GAA19CA524Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Manchester, NHThe student pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with approach lights.NTSB ERA19LA264Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Foley, ALTotal loss of engine power due to a fatigue failure of the camshaft gear.NTSB WPR19LA247Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 510 · El Monte, CAThe pilot's failure to disengage the parking brake before takeoff, which resulted in decreased acceleration and a subsequent runway overrun following an aborted takeoff.NTSB GAA19CA527Accident · No injuriesData collectionFinal reportDiamond DA20 · Convington, TNThe student pilot's improper pitch attitude during the takeoff climb, and the flight instructor's delayed remedial action which resulted in an aerodynamic stall and ground impact.NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR19TA248Accident · Minor injuriesClass 3Final reportHall Kitfox · Nampa, IDThe owner's improper installation of the tailwheel, which resulted in the pilot's inability to maintain directional control during landing as a result of severe tailwheel vibrations.NTSB GAA19CA568Accident · No injuriesData collectionFinal reportLuscombe 8 · Prescott, AZThe pilot's loss of directional control and subsequent overapplication of rudder pedal, which resulted in a runway excursion and the right wing striking the ground.NTSB GAA19CA537Accident · No injuriesData collectionFinal reportCzech Sport Sportcruiser · Murrieta, CAThe student pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control and a hard landing.NTSB ANC19LA048Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18 · Fairbanks, AKThe inappropriate application of paint underneath the engine cylinder hold-down nuts, which resulted in inadequate torque and the subsequent in-flight separation of the No. 3 cylinder, and resulted in a total loss of engine power.NTSB ANC19CA057Accident · Minor injuriesData collectionFinal reportPiper PA22 · Arctic Village, AKThe pilot's failure to maintain adequate airspeed while maneuvering to avoid mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB WPR19FA246Accident · 3 fatalClass 3 · FieldFinal reportBeech 33 · St. Ignatius, MTThe pilot’s decision to maneuver the airplane at a low altitude, which resulted in impact with power lines and terrain.NTSB CEN19LA295Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Olney, TXA loss of thrust control due to a propeller surge event, which resulted in a forced landing shortly after takeoff.NTSB CEN19LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Denver, COA total loss of electrical power for reasons that could not be determined, and the student pilot’s subsequent runway overrun during a no-flap landing.NTSB ANC19LA047Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Talkeetna, AKA failure of the aft left weld-on fuselage landing gear fitting due to a poor weld joint.NTSB GAA19CA518Accident · No injuriesData collectionFinal reportPiper PA32RT · Ashland, ORThe pilot's improper landing flare, which resulted in a bounced, hard landing and propeller strike, and his subsequent loss of directional control.NTSB GAA19CA519Accident · No injuriesData collectionFinal reportBell 206 · San Diego, CAThe pilot's failure to maintain yaw and pitch control while repositioning the helicopter, which resulted in dynamic rollover.NTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.NTSB CEN19LA290Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35 · Monroe, WIA total loss of engine power due to the failure of the Nos. 5 and 6 connecting rods from a lack of oil lubrication for reasons that could not be determined.NTSB WPR19LA243Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20C · Reno, NVThe pilot's improper inflight fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB WPR19LA242Accident · No injuriesClass 3 · LimitedFinal reportLockheed C130 · Santa Barbara, CAThe failure of the No. 3 bleed air duct due to corrosion, which resulted in numerous system failures and the pilot’s inability to maintain directional control during the landing roll.NTSB WPR19LA240Accident · No injuriesClass 3 · LimitedFinal reportScoda Aeronautical Super Petrel · Lancaster, CAThe improper sealing of both carburetor bowls, which resulted in a total loss of engine power.NTSB WPR19FA241Accident · 1 fatalClass 3 · FieldFinal reportGlaser Dirks DG 300 Elan · Wilkeson, WAThe pilot’s delayed decision to land following a loss of thermal lift, which resulted in collision with trees during the landing approach.NTSB GAA19CA514Accident · No injuriesData collectionFinal reportHughes 269A · Shamokin, PAThe pilot's improper landing flare during an autorotation, which resulted in a hard landing. Contributing to the accident was a loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of any…NTSB GAA19CA511Accident · No injuriesData collectionFinal reportPiper PA28 · Cottonwood, AZThe student pilot's improper pitch and lateral control during a soft-field takeoff, which resulted in impact with terrain. Contributing to the accident was the student pilot's failure to relinquish control of the airplane to the instructor.NTSB CEN19TA330Accident · No injuriesClass 3Final reportCirrus SR22 · Glenwood Springs, COThe pilot’s failure to maintain control of the airplane while landing with a tail wind, which resulted in an aerodynamic stall and a subsequent hard landing..NTSB CEN19TA293Accident · No injuriesClass 3Final reportPiper J3C · Russiaville, INThe pilot's failure to reinstall the oil cap after adding oil, which resulted to oil starvation and a precaautionary landing.NTSB CEN19LA300Accident · No injuriesClass 3 · LimitedFinal reportCessna 425 · Bethany, OKA loss of control during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.NTSB WPR19LA239Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Wendover, UTFailure of the landing gear solenoid, which resulted in failure of the landing gear position switch, and the pilot's subsequent inability to extend the gear using the manual emergency extension system for undetermined reasons.NTSB GAA19CA510Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Waco, TXThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover.NTSB ERA19LA260Accident · Serious injuriesClass 3 · LimitedFinal reportDG Flugzeugbau DG-500MB · Robertsdale, ALImpact with trees during the landing approach for reasons that could not be determined based on the available information.NTSB ERA19LA258Accident · No injuriesClass 3 · LimitedFinal reportBeech F33 · Hobe Sound, FLA bearing shift, which resulted in a loss of lubrication to the crankshaft, the failure of the crankshaft, and a total loss of engine power.NTSB ERA19FA256Accident · 1 fatalClass 3 · FieldFinal reportMoriarty Marvin Aventura II · Minneola, FLThe pilot’s improper modifications to the airplane’s engine, which resulted in the partial loss of engine power. Contributing to the outcome was the pilot's exceedance of the airplane’s critical angle of attack during an attempted return to the airport…NTSB CEN19TA328Accident · Serious injuriesClass 3Final reportLindstrand 105A · Lawton, OKA hard landing, which resulted the basket tipping over and a passenger sustaining a serious injury.NTSB GAA19CA513Accident · Minor injuriesData collectionFinal reportCessna A185 · Rangeley Lake, METhe pilot's inadequate preflight inspection of the floats, which led to his subsequent attempt to depart from a lake with damaged floats and led to a loss of roll control and the right wing impacting the water.NTSB GAA19CA508Accident · No injuriesData collectionFinal reportPiper PA28 · Hemet, CAThe student pilot's failure to maintain directional control while attempting to go around, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA507Accident · No injuriesData collectionFinal reportMaule M5 · Anchorage, AKThe pilot's excessive braking during landing on a dry lakebed, which resulted in a nose-over.NTSB GAA19CA506Accident · No injuriesData collectionFinal reportGrob G103 · San Antonio, TXThe failure of the glider tow rope, which lodged in the glider's rudder and resulted in a hard landing. Contributing to the accident was the pilot's failure to properly secure the glider's aft canopy.NTSB GAA19CA505Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Oxford, FLThe pilot’s continued use of battery power during a nonpowered flight in a powered-glider, which depleted the battery to a level that was insufficient to power the starter during the engine restart sequence and resulted in a forced landing to a soft field and…NTSB ERA19LA257Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Burnsville, NCThe pilot’s reliance on latent satellite weather imagery for tactical weather avoidance, which resulted in flight into thunderstorms and a loss of control. Also causal was an engine overspeed during the uncontrolled descent, which resulted in catastrophic…NTSB WPR19LA238Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Half Moon Bay, CAA total loss of engine power for reasons that could not be determined.NTSB WPR19LA233Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 120 · Livermore, CAA partial loss of engine power due to fouled spark plugs in the No. 4 cylinder. Contributing to the accident was the pilot’s exceedance of the airplane’s critical angle of attack and a subsequent loss of control during the initial climb.NTSB WPR19FA230Accident · No injuriesClass 3 · FieldFinal reportCessna 560XL · Oroville, CAThe pilot’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane nose down pitching moment. Also causal was the flight crew’s delayed decision to abort the takeoff, which…NTSB GAA19CA509Accident · Serious injuriesData collectionFinal reportRobinson R44 · Cypress Island, WAThe pilot's failure to maintain adequate clearance from a tree while maneuvering at a low altitude.NTSB ERA19LA255Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Tampa, FLThe failure of the right main landing gear to fully extend and lock for reasons that could not be determined.NTSB ERA19LA253Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity XL-5 · St. Cloud, FLThe pilot’s failure to properly secure the airplane electrical system’s positive/negative leads to the 24v battery, which resulted in a total loss of electrical and engine power in flight.NTSB WPR19LA237Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Eugene, ORThe failure of the landing gear electric motor to shut off after landing gear retraction, which resulted in the motor overheating, burning out, and producing smoke in the cockpit. The pilot’s decision to land with the landing gear retracted resulted in…NTSB GAA19CA517Accident · Minor injuriesData collectionFinal reportCessna 180 · Arlington, WAThe pilot's failure to properly secure the seat before takeoff, which resulted in it sliding back during takeoff and rendering him unable to reach the rudder pedals and throttle lever, a subsequent runway excursion, ground loop, and impact with a berm.NTSB ERA19LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 31P · East Brady, PAA total loss of left engine power for undetermined reasons.NTSB CEN19TA280Accident · Serious injuriesClass 3Final reportBell 47G · Montrose, COA loss of engine power due to fuel starvation, which resulted from attitude-induced unporting of the fuel.NTSB CEN19FA279Accident · 2 fatalClass 3 · FieldFinal reportAero Commander 200 · Howell, MIThe improper installation of the engine’s metal intake screen, which allowed the filter element to become displaced and subsequently lodge in the intake, blocking intake air and causing the total loss of engine power, at low altitude and low airspeed…