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 WPR25LA247Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Etna, WYThe pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…NTSB ERA25LA296Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Muskeget Island, MAThe pilot’s failure to obtain a proper touchdown point while attempting to land on a very short and rough turf runway, which resulted in a runway overrun and collision with vegetation and terrain.NTSB CEN25LA314Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Goodland, KSThe pilot’s failure to maintain aircraft control during the landing and go-around with variable wind direction and speed.NTSB CEN25LA319Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Lowell, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN25LA312Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Ozark, ARThe pilot’s failure to maintain clearance from a tree which resulted in the right wing impacting the tree and a subsequent collision with trees and terrain. Contributing to the accident was the pilot’s decision to operate the airplane at a low altitude over…NTSB ANC25LA085Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK 1 · Soldotna, AKThe pilot’s failure to maintain clearance from rising terrain while maneuvering at low altitude.NTSB WPR25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Ronan, MTThe student pilot's inadequate landing flare and recovery from a bounced landing.NTSB ERA25LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pottstown, PAThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in substantial damage to the engine mounts.NTSB ERA25LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rangeley, METhe pilot’s failure to maintain control of the airplane during landing, which resulted in a runway excursion and subsequent nose over.NTSB ERA25LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Memphis, TNFailure of the left main landing gear due to the loss of the protective paint coating and a change in the local surface finish from impermissible grinding, which resulted in fatigue cracking.NTSB ERA25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Inverness Highlands South, FLThe pilot’s inadequate monitoring of the airplane during taxi which resulted in collision with a sign.NTSB CEN25FA307Accident · 2 fatalClass 3 · FieldFinal reportHughes 369D · West Alton, MOThe pilot’s failure to maintain helicopter clearance from the powerline during the powerline maintenance operation for reasons that could not be determined.NTSB ERA25LA291Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 35-C33 · Kingston, TNThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with haybales.NTSB CEN25LA311Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Monee, ILThe student pilot’s failure to maintain airspeed and altitude resulting in a collision with the ground during the base to final turn.NTSB ANC25LA106Accident · No injuriesClass 4 · LimitedFinal reportBrian Turner Northern Explorer · Delta Junction, AKThe pilot’s failure to maintain obstacle clearance during landing, which resulted in an impact with trees.NTSB WPR25LA239Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ponderosa Pines, MTThe pilot’s improper pedal application during an approach to a hover.NTSB CEN25LA303Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Lamoni, IAThe pilot’s failure to maintain airplane control during an aborted takeoff.NTSB CEN25LA302Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Taylor, TXThe flight instructor’s inadequate supervision and delayed remedial action which resulted in a skid contacting the terrain. Contributing to the accident was the flight instructor’s improper judgement to allow the student pilot to manipulate the flight…NTSB ANC25LA083Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Chisana, AKThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.NTSB ANC25LA082Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Yakutat, AKThe pilot’s failure to maintain clearance during approach in gusting wind conditions to a remote airstrip, resulting in a collision with brush.NTSB WPR25LA235Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Kamiah, IDThe pilot’s loss of airplane control following an encounter with a microburst during takeoff.NTSB ERA25LA285Accident · No injuriesClass 4 · LimitedFinal reportCessna TU206 · Ellsworth, METhe pilot’s decision to operate the airplane with a known deficiency of the floats, which resulted in an accumulation of water in the forward compartments of the floats, a forward center of gravity, and subsequent nose over during a water landing.NTSB ANC25LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Anchorage, AKThe pilot’s decision to continue an unstabilized approach, which resulted in a landing touchdown with insufficient runway remaining and a subsequent runway overrun and a collision with a fence.NTSB WPR25LA242Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Moriarty, NMThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR25LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Thermal, CAThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB WPR25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Cashmere, WAThe pilot’s failure to maintain clearance from obstacles during an aborted landing, while flying in tailwind conditions. Contributing to the accident was the high density altitude weather condition.NTSB ERA25LA319Accident · No injuriesClass 4 · LimitedFinal reportWaco UBF · Tampa, FLThe pilot’s failure to maintain directional control during landing roll, which resulted in a runway excursion and collision with an object.NTSB ERA25LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPaul Dennis Berg Exec 162F · Holley, NYThe pilot’s failure to maintain clearance with the ground while hovering, which resulted in a dynamic rollover.NTSB WPR25LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Inhama, ORThe pilot’s failure to maintain clearance from trees while taxiing, which resulted in a wing strike.NTSB WPR25LA229Accident · No injuriesClass 4 · LimitedFinal reportLake Tahoe Properties CA 8 · Davenport, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR25LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 182L · Tucson Estates, AZThe pilot’s inability to stop the airplane on the runway during a rejected takeoff for undetermined reasons, which resulted in the airplane’s impact with a ditch.NTSB CEN25LA292Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · North Bend, NEThe pilot’s failure to maintain clearance from wires while maneuvering at a low altitude, and the ground crew failure to inform the pilot that the support truck had been moved.NTSB ERA25LA382Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Destin, FLThe pilot’s inadequate fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31T3 · Appleton, WIThe pilot’s failure to maintain control of the airplane on the ground, which resulted in a collision with a parked airplane.NTSB ERA25LA279Accident · No injuriesClass 4 · LimitedFinal reportBeech A23-24 · Windham, CTThe pilot’s inadequate preflight planning, which resulted in a rejected takeoff and subsequent runway excursion.NTSB CEN25LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · Kerrville, TXThe pilot’s failure to confirm the fuel quantity before flight which resulted in a loss of engine power due to fuel starvation.NTSB ANC25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna U206C · Gulkana, AKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR25LA221Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B35 · Helena, MTThe pilot’s failure to properly configure the airplane during a go-around which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.NTSB ERA25LA287Accident · No injuriesClass 4 · LimitedFinal reportGrob-Werke Twin Astir · Franconia, NHThe pilot’s failure to detect the inadvertent deployment of the spoilers, which resulted in a prolonged, excessive descent rate. Contributing to the accident was the pilot’s decision to conduct a downwind approach versus a straight in approach to the…NTSB CEN25LA299Accident · No injuriesClass 4 · LimitedFinal reportPiper J5A · Grenada, MSThe flight instructor’s inadequate supervision of the flight and improper decision to continue with a takeoff after the airplane swerved off the runway. Contributing to the accident was the student pilot’s failure to maintain directional control of the…NTSB CEN25LA286Accident · Minor injuriesClass 4 · LimitedFinal reportWeatherly 620B · Rushmore, MNThe pilot’s failure to maintain clearance from a tree during low-level maneuvering.NTSB CEN25LA285Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Walcott, IAThe pilot’s failure to maintain clearance from the crops during an aerial application flight.NTSB CEN25LA284Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · New Hudson, MIThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action during landing that resulted in a loss of control and impact with terrain.NTSB CEN25LA283Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Hartsburg, ILThe pilot’s failure to maintain control of the airplane during takeoff with a tailwind from a wet turf airstrip.NTSB CEN25FA281Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron 206L-1 · Thibodaux, LAThe pilot’s failure to maintain clearance to powerlines during an agricultural application pass.NTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB CEN25LA290Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Lansing, ILThe pilot's failure to extend the landing gear before landing due to his distraction of other traffic and failure to follow his landing procedures.NTSB CEN25LA279Accident · No injuriesClass 4 · LimitedFinal reportDyke Delta JD-2 · Oshkosh, WIThe pilot’s failure to maintain control of the airplane while landing with a tailwind.NTSB CEN25LA276Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Centralia, MOThe pilot’s failure to maintain clearance from power lines during low-level maneuvering.NTSB CEN25LA274Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Hastings, NEThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.