NTSB investigations
19,218 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 ERA26LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · Southern Pines, NCThe pilot’s failure to maintain directional control during takeoff at night, while distracted by an animal approaching the runway, which resulted in collision with a runway light.NTSB CEN26LA040Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Lakeview, ARThe pilot’s decision to continue an approach that resulted in a long landing and inability to stop prior to the end of the runway. Contributing to the accident were the light conditions and a road with vehicles on it immediately adjacent to the end of the…NTSB ERA26LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Cuthbert, GAThe pilot’s failure to maintain clearance from trees and terrain while maneuvering for a precautionary landing, at low altitude and at night.NTSB ERA26LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Suffolk, VAThe pilot’s failure to maintain control of the airplane during landing, which resulted in a nose over.NTSB CEN26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Brainerd, MNThe pilot’s failure to extended to landing gear before landing.NTSB CEN26LA036Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Gueydan, LAThe pilot’s failure to maintain situational awareness and clearance from terrain while maneuvering to avoid birds.NTSB WPR26LA038Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182P · San Andreas, CAThe pilot’s decision to adjust his seat during the takeoff roll, which resulted in the seat sliding aft and a subsequent loss of directional control.NTSB CEN26LA041Accident · No injuriesClass 4 · LimitedFinal reportDouglas B-26B · Ponca City, OKFailure of the nose landing gear link which resulted in a loss of directional.NTSB ERA26LA028Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Vultee 28-5ACF · Dayton, TNThe collapse of the left main landing gear due to the fatigue fracture of the lower landing gear actuator bolt.NTSB CEN26LA033Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182H · Lakeview, ARThe pilot’s failure to maintain a proper approach path during landing which resulted in a collision with terrain short of the runway. Contributing to the accident was the improper flap position during landing, and the pilot being fatigued.NTSB ERA26LA030Accident · No injuriesClass 4 · LimitedFinal reportHugh Nunnally Farrior Cozy MK IV · McRae-Helena, GAThe pilot’s failure to extend the nose landing gear, which resulted in a nose gear up landing. Contributing to the accident was the pilot’s inappropriate decision to continue to fly with known delamination damage to the propeller.NTSB ERA26LA022Accident · No injuriesClass 4 · LimitedFinal reportRans Employee Flying Club Rans S-6ES Coyote II · Williston, SCThe pilot’s failure to maintain directional control of the airplane during the initial climb in gusting crosswind conditions.NTSB ERA26LA026Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS350 · Wetumpka, ALThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving instruction.NTSB ERA26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · St. Augustine, FLThe student pilot’s failure to properly set the elevator trim prior to takeoff, which resulted in her inability to effectively control the airplane’s pitch and a collision with trees at the end of the runway during initial climb.NTSB DCA26FA019Accident · No injuriesClass 4 · FieldFinal reportAir Vev AIR ZERO2 · Indiantown, FLA cascading shutoff of multiple aft motors due to a sudden increase in motor loads during maneuvering, resulting in a loss of control.NTSB CEN26LA028Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Hondo, TXThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the Before Landing checklist.NTSB CEN26LA027Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Springfield, MOThe pilot’s failure to maintain directional control and the flight instructor’s lack of proper remedial action during the practice autorotation that resulted in the helicopter impacting terrain. Contributing to the accident was the presence of the gusting…NTSB CEN26LA025Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Eau Claire, WIThe pilot’s failure to ensure that the landing gear was properly extended before landing. Contributing to the accident was the pilot’s unfamiliarity with the landing gear warning horn and failure to verify the gear was extended with the cockpit position…NTSB WPR26LA029Accident · No injuriesClass 4 · LimitedFinal reportRoderick James Willmore Kitfox S7 Supersport · Kilgore, IDThe pilot's failure to maintain directional control during the takeoff. Contributing to the accident was the separation of the control stick grip.NTSB WPR26LA028Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Phoenix, AZA worn tailwheel steering mechanism, which resulted in a locked tailwheel and a ground loop during a landing roll.NTSB ERA26LA018Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cynthiana, KYThe pilot's inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a forced landing. Contributing to the accident was the impact with powerlines during final approach.NTSB CEN26LA021Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Tulsa, OKThe pilot’s improper landing flare which resulted in a hard bounced landing.NTSB CEN26LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Reserve, LAThe pilot’s inadvertent application of the wheel brakes after touchdown.NTSB ERA26LA020Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Canon, GAThe pilot’s inadvertent application of brakes during the landing roll, which resulted in a noseover.NTSB ERA26LA017Accident · Serious injuriesClass 4 · LimitedFinal reportTricks Trike Storm · Gaffney, SCThe pilot’s failure to maintain aircraft control during the initial climb, which resulted in an impact with terrain.NTSB ERA26LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · North Lauderdale, FLA total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.NTSB CEN26LA017Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Springfield, COThe pilot's failure to maintain directional control during the takeoff with a right crosswind.NTSB CEN26LA018Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Wallis, TXThe pilot’s failure to maintain control during landing roll that resulted in an impact with terrain.NTSB WPR26LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 185C · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll with a left crosswind.NTSB WPR26LA018Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Imnaha, ORThe pilot’s continued application of brakes during an aborted takeoff in a tailwind on down-sloping terrain, which resulted in a nose-over.NTSB WPR26LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Watsonville, CAThe pilot’s decision to program avionics during taxi, resulting in an inadvertent throttle input and collision with a hangar.NTSB ERA26LA008Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · East Rockingham, NCThe pilot’s failure to maintain control of the airplane during initial climb, resulting in an aerodynamic stall and impact with terrain.NTSB WPR26LA021Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Albuquerque, NMThe pilot's failure to maintain clearance from a power line during a descent for landing.NTSB WPR26LA007Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Gila Bend, AZThe pilot’s improper throttle input and failure to maintain aircraft control during landing.NTSB ERA26LA003Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · West Milford, NJThe pilot’s failure to adequate clearance from obstacles while maneuvering during the landing approach and the instructor pilot’s delayed remedial action, which resulted in the airplane contacting a tree and terrain.NTSB WPR26LA010Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel STD Libelle 201B · Moriarty, NMThe glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.NTSB CEN26LA007Accident · Serious injuriesClass 4 · LimitedFinal reportCessna R172 · Mount Carroll, ILThe pilot’s failure to maintain aircraft control during a go around in gusty wind conditions.NTSB WPR26LA048Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A1 · Evanston, WYThe airplane’s encounter with downdrafts in mountainous terrain, which resulted in a collision with terrain. Contributing to the accident was the pilot’s decision to continue the flight through mountainous terrain in marginal weather conditions.NTSB WPR26LA014Accident · No injuriesClass 4 · LimitedFinal reportMaye James A Just Aircraft Escapade · Flanigan, NVThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR26LA003Accident · No injuriesClass 4 · LimitedFinal reportWilley Frank C Jr. Avid Mark 4 · Boulder City, NVThe pilot’s failure to maintain directional control while landing.NTSB ERA26LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Venice, FLThe pilot’s failure to maintain directional control while taxiing in gusty, quartering tailwind conditions.NTSB ERA26LA009Accident · No injuriesClass 4 · LimitedFinal reportCessna 182H · Smithfield, RIMaintenance personnel’s improper rigging of the elevator trim system, which resulted in a hard landing. Contributing was the maintenance personnel and pilot’s failure to perform adequate post maintenance/preflight inspections.NTSB ERA26LA005Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Reedville, VAThe pilot’s sudden incapacitation by an episode of abnormal heartbeat due to heart disease during a takeoff attempt, which resulted in a loss of directional control and runway excursion.NTSB ERA26LA002Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260 · Parkland, FLThe pilot’s failure to retract the amphibious airplane’s landing gear before conducting a forced landing on the water, which resulted in a nose over.NTSB ERA26LA016Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Bluffton, OHThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN26LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · North La Junta, COThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB CEN26LA011Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Portage, WIThe student pilot’s failure to maintain proper airspeed and attitude for a short field landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN26LA003Accident · No injuriesClass 4 · LimitedFinal reportQuartz Mountain Aerospace 11E · Earlham, IAThe flight instructor’s inadequate fuel management which resulted in the total loss of engine power due to fuel exhaustion.NTSB CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB ANC25LA117Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31 · Kotlik, AKThe pilot’s failure to extend the landing gear before landing.