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 CEN20CA137Accident · No injuriesData collectionFinal reportPiper PA-28-235C · Omaha, NEThe student pilot’s improper landing flare, which resulted in a bounced landing, subsequent loss of directional control, and the airplane going down an embankment.NTSB ERA20CA165Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · New Symrna Beach, FLThe flight instructor's delayed remedial action and decision to not go-around after a bounced landing, which resulted in an inadvertent stall and hard landing.NTSB WPR20LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sedona, AZThe pilot’s loss of pitch control while landing in crosswind conditions, which resulted in a collapsed nose gear and departure of the airplane from the runway.NTSB CEN20LA134Accident · 1 fatalClass 3 · LimitedFinal reportMuse P51D · Mesquite, TXThe pilot’s inadvertent exceedance of the airplane’s critical angle of attack for undetermined reasons, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.NTSB WPR20LA116Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hurricane, UTA total loss of engine power due to the failure of the ignition system as a result of foreign object damage.NTSB ANC20CA040Accident · No injuriesData collectionFinal reportPiper PA32 · Fairbanks, AKThe pilot's inadequate compensation for gusting crosswind conditions, which resulted in a loss of directional control, a runway excursion, and impact with a snowbank.NTSB ERA20CA148Accident · No injuriesData collectionFinal reportAero Commander 500 · Opalocka, FLThe pilot's failure to extend the landing gear due to distraction and his delayed go-around, which allowed the airplane to get too low and contact the runway with the landing gear retracted.NTSB ERA20CA142Accident · No injuriesData collectionFinal reportCirrus SR20 · Stow, MAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with vegetation.NTSB ANC20CA039Accident · No injuriesData collectionFinal reportWag-Aero Sportsman 2+2 · Wasilla, AKThe pilot's loss of directional control during takeoff from an icy ski strip in gusting wind conditions, which resulted in the left wing impacting a tree.NTSB CEN20LA133Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · McKinney, TXThe pilot's inadequate preflight fuel planning and inflight fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN20LA132Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Waxahachie, TXThe partial loss of engine power due to water and contaminants in the fuel, due to the pilot’s inadequate preflight inspection, and the pilot’s decision to conduct a steep turn at low altitude to return to the runway rather than land straight ahead, which…NTSB CEN20LA131Accident · Serious injuriesClass 3 · LimitedFinal reportBower Challenger II · Lettsworth, LAThe owner/pilot's inability to maintain control of the airplane due to his lack of training and experience, resulting in a collision with a tree.NTSB CEN20LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Harrisville, MIThe pilot’s loss of directional control during landing rollout in gusty crosswind conditions, resulting in a runway excursion and collision with trees.NTSB ANC20CA036Accident · No injuriesData collectionFinal reportCessna 175 · Soldotna, AKThe pilot's unintentional selection of the wrong landing surface, which was covered with 2 ft of snow and resulted in a nose-over.NTSB WPR20CA113Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Puyallup, WAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in the wing striking the ground.NTSB ERA20LA132Accident · 1 fatalClass 3 · LimitedFinal reportCessna 310 · Charleston, SCThe pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation.NTSB ERA20CA135Accident · No injuriesData collectionFinal reportAugustaWestland AW119MKII · Philadelphia, PAThe in-flight failure of the lower left side of the engine cowling due to the mechanic’s improper installation of the fasteners, which resulted in the cowling impacting all four main rotor blades.NTSB WPR20LA111Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 30 · Eagle Creek, ORThe pilot's loss of airplane control during takeoff due to his left shoe’s interference with the rudder pedal.NTSB CEN20LA127Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28R · Pleasant Plain, OHThe pilot’s encounter with convective turbulence and low-level wind shear in dark night instrument meteorological conditions that resulted in spatial disorientation and the loss of airplane control.NTSB CEN20CA128Accident · No injuriesData collectionFinal reportCessna 172 · Denver, COThe pilot's incorrect right rudder application during a touch-and go-landing, which resulted in a loss of directional control, runway excursion, and a collision with a runway sign.NTSB ERA20LA129Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Conway, SCThe pilot’s incorrect use of the autopilot while approaching the initial approach fix and his subsequent improper primary pitch control input while a pitch mode of the autopilot was engaged, which resulted in pitch excursions and subsequent departure from…NTSB ERA20CA130Accident · No injuriesData collectionFinal reportCessna 172 · West Palm Beach, FLThe failure of the nosewheel steerage linkage during takeoff, which resulted in a loss of directional control and impact with an obstacle during an attempted aborted landing.NTSB CEN20LA122Accident · 1 fatalClass 3 · LimitedFinal reportCessna 208 · LaCrosse, KSAn infight loss of control as a result of pilot impairment, the cause of which could not be determined.NTSB ANC20CA034Accident · Minor injuriesData collectionFinal reportCessna 172 · Kahului, HIThe student pilot's failure to avoid wake turbulence while landing behind a heavy jet airplane, which resulted in a loss of roll control and subsequent hard landing.NTSB WPR20LA109Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker 800XP · Scottsdale, AZThe pilot’s inability to maintain directional control during landing for undetermined reasons, which resulted in a runway excursion.NTSB CEN20LA123Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Baxterville, MSThe failure of the No. 1 cylinder intake valve due to inadequate valve seating.NTSB WPR20CA138Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Tucson, AZThe student pilot's loss of directional control during landing, which resulted in a runway excursion, collision with a pole, and a subsequent ground loop.NTSB ERA20LA126Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Beverly, MAA loss of engine power due to carburetor icing, and the student pilot’s failure to utilize carburetor heat in conditions conducive to carburetor icing.NTSB ERA20CA141Accident · No injuriesData collectionFinal reportCessna 172 · Ocean City, MDThe pilot's failure to maintain directional control during an attempted go-around to avoid birds, which resulted in a runway excursion and subsequent nose-over.NTSB CEN20LA442Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Sterling City, TXThe pilot’s failure to maintain clearance from power lines during an aerial application flight.NTSB ERA20FA124Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Sterling, MAA total loss of engine power during takeoff due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB CEN20LA118Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32R · Rensselaer, INThe non-instrument rated pilot’s failure to establish a climb while initiating a missed approach after conducting an instrument approach below weather minimums.NTSB ERA20CA131Accident · No injuriesData collectionFinal reportAmerican Legand AL18 · Social Circle, GAThe pilot's failure to maintain airplane control while maneuvering at low altitude, which resulted in the collision with terrain.NTSB ANC20CA032Accident · No injuriesData collectionFinal reportCessna 172 · Big Lake, AKThe pilot's improper decision to initiate the takeoff roll from a snow-covered taxiway, which resulted in a loss of directional control, runway excursion, and impact with a snow berm.NTSB ERA20LA122Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Destin, FLThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN20CA117Accident · Minor injuriesData collectionFinal reportPiper PA28-180 · Eolia, MOThe pilot's improper landing flare in gusting wind conditions, which resulted in a bounced landing, loss of directional control, runway excursion, and impact with a tree.NTSB ERA20CA128Accident · Minor injuriesData collectionFinal reportStolp Starduster Acroduster II SA750 · Senoia, GAThe pilot's failure to see and avoid trees while maneuvering at low altitude, which resulted in a loss of airplane control.NTSB CEN20CA115Accident · No injuriesData collectionFinal reportMooney M20K · New Orleans, LAThe pilot's improper decision to turn the airplane from the runway onto the taxiway at an excessive speed, which resulted in a loss of directional control, runway excursion, and collision with a taxiway sign.NTSB WPR20CA112Accident · No injuriesData collectionFinal reportDe Havilland DHC6 · Boulder City, NVThe trainee pilot's loss of directional control during landing and his subsequent unintentional control interference with the brakes and/or rudder during the trainer pilot's attempted remedial action, which resulted in a runway excursion and collision with a…NTSB WPR20CA100Accident · No injuriesData collectionFinal reportPiper PA28R · Twin Falls, IDThe pilot's loss of directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and impact with a runway approach light.NTSB ERA20FA119Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA 1 · Boynton Beach, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall and…NTSB WPR20LA101Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Needles, CAA loss of engine power for undetermined reasons due to a lack of available evidence.NTSB WPR20LA099Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Moab, UTThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and the airplane’s subsequent noseover.NTSB ERA20LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Albemarle, NCThe pilots' failure to ensure that the electric fuel pumps were on before takeoff, which resulted in a partial loss of power on both engines during initial climb.NTSB CEN20LA113Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Clark, MOThe fatigue failure of the pneumatic line for reasons that could not be determined, which resulted in a loss of engine power and subsequent hard landing.NTSB ANC20LA028Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter EC130 · Kalapana, HIA loss of control due to the fatigue fracture of a tail rotor fenestron blade due to the geometry of the water drain hole positioning on the rib.NTSB WPR20LA098Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Encino, NMA partial loss of engine power due to fuel starvation, which likely resulted from a leak in the fuel system.NTSB CEN20CA114Accident · No injuriesData collectionFinal reportVans RV8 · Harrison, OHThe malfunction of the steerable tailwheel, which resulted in a loss of directional control during the landing roll and subsequent impact with the precision approach path indicator lights system.NTSB ERA20FA118Accident · 3 fatalClass 3 · FieldFinal reportPiper PA46 · Bishop, GAThe pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…NTSB CEN20FA110Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Lincoln, ILThe pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.