NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 CEN09CA485Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Flushing, MIThe pilot's failure to maintain adequate descent rate and airspeed on final resulting in a hard landing.NTSB CEN09CA480Accident · No injuriesData collectionFinal reportBoring Robert Burton RV6A · Demming, NMThe loss of engine power due to fuel starvation as a result of the pilot's failure to manage and monitor fuel usage.NTSB CEN09CA479Accident · Serious injuriesData collectionFinal reportPiper PA28-151 · Purcell, OKThe student pilot's failure to see and avoid the power lines.NTSB WPR09LA383Accident · No injuriesLimited investigationFinal reportBeech 76 · Glendale, AZThe fatigue failure of the left main landing gear enhanced side brace assembly.NTSB ERA09LA438Accident · No injuriesLimited investigationFinal reportChristopher John P CHR-1 · Norridgewock, MEA loss of engine power due to a broken crankshaft for undetermined reasons.NTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.NTSB CEN09CA478Accident · Minor injuriesData collectionFinal reportP&M Quik GT450 · Oshkosh, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB CEN09CA477Accident · No injuriesData collectionFinal reportCessna A185F · River Falls, WIThe pilot not checking the security of the fuel caps prior to flight leading to fuel exhaustion and the subsequent non-mechanical loss of engine power during descent.NTSB WPR09LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Firebaugh, CAA total loss of engine power due to fuel exhaustion that was due to the failure of company ground personnel to refuel the airplane. Contributing to the accident was unsuitable terrain for a forced landing.NTSB WPR09CA376Accident · No injuriesData collectionFinal reportSchweizer SGS 2-32 · Heber City, UTThe pilot's excessive speed as he turned off the runway.NTSB WPR09CA375Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe flight instructor's failure to maintain adequate main rotor RPM.NTSB ERA09CA505Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Geneva, FLOil starvation due to air in the engine oil supply line, which resulted in engine seizure during initial climb.NTSB ERA09CA428Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Dundee, MSThe pilot's failure to maintain aircraft control during takeoff.NTSB CEN09CA500Accident · No injuriesData collectionFinal reportCessna P210N · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC09CA075Accident · No injuriesData collectionFinal reportCessna 180 · Buckland, AKThe improper installation of the right brake cylinder, which allowed a portion of the cylinder to disengage and jam the right rudder/brake pedal, resulting in a loss of directional control during landing. Contributing to the accident was an inadequate…NTSB WPR09LA457Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ely, NVThe pilot's failure to maintain directional control during the landing roll.NTSB WPR09LA373Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Riverdale, CAThe partial loss of engine power due to the failure of the engine's supercharger-blower.NTSB ERA09CA439Accident · No injuriesData collectionFinal reportMooney M20S · Mayfield, KYThe pilot prematurely retracting the landing gear and flaps during the aborted landing.NTSB ERA09CA426Accident · No injuriesData collectionFinal reportCessna 150M · Lexington, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel manangement.NTSB WPR09CA377Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe student pilot's improper use of the collective control and the flight instructor’s delayed reaction to the student pilot’s incorrect control inputs.NTSB ERA09LA427Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mount Holly, NJA hard landing on an unknown date, resulting in damage to the left main landing gear support fitting.NTSB ERA09CA425Accident · Minor injuriesData collectionFinal reportCessna 177 · Towanda, PAThe failure of the pilot to maintain control of the airplane during a go around following a bounced landing.NTSB DCA09FA068Accident · Serious injuriesField investigationFinal reportEmbraer EMB170 · Norfolk, VAan inadvertent encounter with convective turbulence that resulted in serious injuries to a flight attendant.NTSB ERA09CA424Accident · No injuriesData collectionFinal reportWhite New Standard · Rhinebeck, NYThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was a depression near the edge of the turf runway that the airplane encountered during the takeoff roll.NTSB CEN09CA475Accident · Minor injuriesData collectionFinal reportGlasflugel Standard Libelle · Faribault, MNThe pilot's inability to maintain proper airspeed on approach to land.NTSB CEN09CA472Accident · No injuriesData collectionFinal reportFisher RV-7A · Brodhead, WIThe pilot's improper landing flare and recovery from a bounced landing.NTSB WPR09LA369Accident · Minor injuriesLimited investigationFinal reportBrown Michael Kitfox IV · Escondido, CAA total loss of power due to an oil exhaustion induced seizure of the engine. The pilot's decision to continue flight to the original destination after becoming aware of the in-flight oil leak instead of landing at an intermediate airport to investigate the…NTSB WPR09CA481Accident · No injuriesData collectionFinal reportS.C. Aerostar YAK-52W · Kaunakakai, HIThe pilot's failure to maintain clearance from terrain while in the airport traffic pattern in dark night conditions.NTSB WPR09CA365Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Hemet, CAThe student pilot’s failure to maintain directional control during the landing roll and excessive use of the brakes.NTSB ERA09CA422Accident · Minor injuriesData collectionFinal reportDart GW · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the wet turf landing surface.NTSB CEN09LA467Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12 · Sawyer, MIThe pilot's failure to maintain adequate airspeed while taking off from a short, grass runway.NTSB CEN09LA466Accident · 1 fatalLimited investigationFinal reportLuscombe 8C · Mount Carmel, ILThe reason for this accident was not determined.NTSB CEN09LA463Accident · No injuriesLimited investigationFinal reportPilgrim Samuel W JR RV-6 · Oshkosh, WIThe failure of the rudder pedal which resulted in the pilot's inability to maintain directional control of the aircraft.NTSB CEN09FA462Accident · 1 fatalField investigationFinal reportBeech V35 · Oklahoma City, OKThe pilot’s decision to operate an airplane with known deficiencies, and the loss of engine power during climb for undetermined reasons.NTSB CEN09CA521Accident · No injuriesData collectionFinal reportMaule M-4-220C · Abernathy, TXThe failure of the fuselage's tube structure due to corrosion during a hard landing.NTSB WPR09LA371Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Chelan, WAFailure of a seal in the hydraulic system resulting in a loss of hydraulic pressure while maneuvering at low altitude.NTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.NTSB WPR09CA368Accident · Minor injuriesData collectionFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe premature launch signal given by the wing walker.NTSB WPR09CA367Accident · No injuriesData collectionFinal reportXtremeair XP-30/2002339 · Santa Ynez, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB WPR09CA366Accident · Minor injuriesData collectionFinal reportRans S-12 XL Airaile · Marana, AZThe pilot's failure to maintain directional control during takeoff.NTSB ERA09LA421Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Dunedin, FLA partial loss of engine power for undetermined reasons.NTSB ERA09LA420Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Fort Pierce, FLA loss of engine power due to fuel starvation as a result the failure of the engine fuel pump diaphragms during climb.NTSB ERA09FA417Accident · 4 fatalField investigationFinal reportRobinson Helicopter R44 · Boonsboro, MDThe pilot’s improper decision to depart on a visual flight rules (VFR) flight at night in adverse weather conditions in close proximity to rising mountainous terrain in a helicopter that was only certified to be operated under VFR and his subsequent failure…NTSB ENG09WA010Incident · No injuriesForeign investigationBoeing · Melbourne, AustraliaOn July 24, 2009, about 2230 UTC, a Virgin Blue, Boeing 737-700 airplane, registration VH-VBA, sufferend a failue of the nose landing gear axle. During taxi for takeoff, the right nosewheel separated from the nose landing gear leg. The aircraft was able to be…NTSB CEN09LA494Accident · No injuriesLimited investigationFinal reportCrisman Flightstar Iisc · Malta, ILThe loss of engine power due to the separation of the flywheel, resulting in a high-cycle fatigue fracture of the crankshaft following takeoff, which resulted in a forced landing on an agricultural field.NTSB CEN09CA474Accident · No injuriesData collectionFinal reportBeech H-18 · Dayton, OHThe pilot's failure to lock the tailwheel during landing resulting in the loss of directional control.NTSB WPR09CA363Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Metaline Falls, WAThe pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.NTSB ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.NTSB CEN09CA470Accident · No injuriesData collectionFinal reportRaytheon C90A · Bismarck, NDThe cabin entry door inadvertently opening during initial climb.NTSB CEN09CA469Accident · Serious injuriesData collectionFinal reportPiper PA-25-235 · Miller, MOThe failure of the operator to shut down aircraft while conducting servicing which resulted in a ground person being struck by the rotating aircraft propeller.