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 CHI07CA143Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cincinnati, OHThe pilot's improper decision to leave the aircraft unattended while the engine was running. A factor in the accident was the disengagement of the parking brake.NTSB CHI07CA134Accident · Minor injuriesData collectionFinal reportCessna 172I · Shelby, OHThe pilot's failure to properly achieve the correct touch down point which resulted in a runway over run and subsequent nose over into a ditch. Other factors were the pilot's improper decision to land with a tailwind and the ditch.NTSB MIA07CA095Accident · Minor injuriesData collectionFinal reportCessna 172-M · Oxford, METhe student pilot's failure to maintain a climb during a go-around resulting in collision with an embankment.NTSB LAX07LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZA loss of engine power while maneuvering due to a broken exhaust valve. Contributing to the accident was the rough terrain.NTSB DFW07LA107Accident · No injuriesLimited investigationFinal reportCessna 210 · Sulphur, LAThe collapsed of the right main landing gear for undetermined reasons.NTSB CHI07CA137Accident · No injuriesData collectionFinal reportAeronca 7AC · Mason, MIThe pilot's failure to maintain directional control during the landing roll and failure to maintain sufficient airspeed during the aborted landing attempt, leading to an inadvertent stall. An additional factor was the tree.NTSB CHI07CA132Accident · No injuriesData collectionFinal reportCessna 172P · Kenosha, WIThe pilot's improper recovery from a bounced landing, which resulted in a flat nose wheel tire and a buckled firewall. A factor was the porpoising that was encountered during the flare.NTSB SEA07FA124Accident · 1 fatalField investigationFinal reportCessna P210N · Spanish Fork, UTAn engine oil line leak and subsequent engine compartment fire while in cruise flight.NTSB SEA07CA123Accident · No injuriesData collectionFinal reportPiper PA28-235 · San Jose, CAWind shear encounter during approach for landing.NTSB LAX07CA171Accident · No injuriesData collectionFinal reportCessna 172S · Payson, AZThe pilot's inadequate in-flight planning/decision, excessive airspeed on final approach, and failure to execute a go-around resulting in a misjudged flare and hard landing.NTSB ENG08WA004Incident · No injuriesForeign investigationAgusta A.109 Mk.II · Cork, IrelandNTSB CHI07LA164Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOInadequate flare during landing. The induced oscillation, not performing a go-around, the pilot's lack of experience and the failure to perform remedial action were factors.NTSB NYC07CA113Accident · No injuriesData collectionFinal reportMooney M-18L · Bessemer, ALThe pilot's failure to maintain control which resulted in a hard landing and subsequent gear collapse during the landing roll. A factor in the accident was wind gusts.NTSB NYC07CA110Accident · No injuriesData collectionFinal reportLuscombe 8A · Whitefield, NHThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB MIA07CA093Accident · No injuriesData collectionFinal reportPiper J5A · Richmond, VAThe improper positioning of the elevator flight control surface by the pilot-in-command while taxiing with a tailwind, resulting in the airplane nosing over.NTSB LAX07CA284Accident · Minor injuriesData collectionFinal reportCessna 150M · Sonoma, CAThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control while landing.NTSB CHI07LA135Accident · No injuriesLimited investigationFinal reportCessna 414A · Sturgeon Bay, WIWorn brakes which resulted in an overrun during landing. A fence was a factor.NTSB SEA07CA121Accident · No injuriesData collectionFinal reportCessna 180G · Lopez Island, WAThe pilot's failure to maintain directional control during takeoff. Geese were a factor.NTSB NYC07LA114Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · New Holland, PAUnfavorable winds and terrain during a precautionary landing.NTSB NYC07CA112Accident · No injuriesData collectionFinal reportCessna 172SP · Daytona Beach, FLThe pilot's improper flare at night, which resulted in a hard landing. A factor in the accident was the pilot's lack of recent night experience.NTSB NYC07CA111Accident · Minor injuriesData collectionFinal reportCessna 172S · Montgomery, NYThe pilot's improper flare while landing, which resulted in a loss of directional control and collision with terrain.NTSB MIA07LA092Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Marstons Mill, MAThe pilot's improper preflight planning and preparation resulting in an in-flight loss of engine power due to fuel exhaustion.NTSB MIA07LA091Accident · 1 fatalLimited investigationFinal reportLee Stevens Sorrell SNS-2 Guppy · Stewartstown, PAThe pilot's failure to maintain airspeed resulting in inadvertent stall. Contributing to the accident was the pilot's lack of experience in the airplane.NTSB MIA07CA094Accident · Serious injuriesData collectionFinal reportRotor Flight Dynamics Dominator · Mountain City, TNThe pilot's decision to attempt operation of the airplane with a known physical impairment (loss of leg control) which resulted in his loss of aircraft control during takeoff and the airplane nosing over.NTSB LAX07CA152Accident · No injuriesData collectionFinal reportStinson 108 · Auburn, CAThe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in a stall/mush.NTSB LAX07CA151Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Las Vegas, NVfuel starvation due to the pilot's inadequate fuel system management.NTSB DFW07LA105Accident · Serious injuriesLimited investigationFinal reportAviat A-1A · Farmingdale, NYThe pilot's failure to maintain control of the airplane during a short-field takeoff, which resulted in an inadvertent stall.NTSB DCA07RA040Accident · 114 fatalForeign investigationBoeing B737-800 · Douala, CameroonNTSB SEA07CA122Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Chiloquin, ORThe pilot's failure to maintain aircraft control during takeoff and initial climb. High vegetation was a factor.NTSB NYC07FA109Accident · Serious injuriesField investigationFinal reportPiper PA38-112 · Odenton, MDThe pilot's mismanagement of the airplane's fuel supply, which resulted in fuel starvation and a total loss of engine power.NTSB NYC07CA115Accident · No injuriesData collectionFinal reportAeronca 7AC · Lagrangeville, NYThe pilot's failure to identify a partially buried rock in the landing surface of an unimproved grass runway, which resulted in an inadvertent collision during the landing roll.NTSB NYC07CA108Accident · No injuriesData collectionFinal reportPiper PA28R-201 · Leesburg, FLThe flight instructor's failure to take remedial action, and the private pilot's failure to maintain proper airspeed, which resulted in a hard landing.NTSB CHI07CA131Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Humphrey, ARThe pilot's failure to maintain sufficient clearance between the airplane and the power lines. A factor was the power lines.NTSB ATL07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Asheville, NCThe failure of the directional gyro and attitude indicator due to a vacuum system leak caused by a loose fitting. Contributing to the accident was the pilot's failure to execute a partial panel, no-gyro approach.NTSB ANC07LA036Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Girdwood, AKThe pilot's failure to maintain sufficient altitude/clearance from terrain while maneuvering, which resulted in an in-flight collision with a glacier. Factors contributing to the accident were snow-covered terrain, and flat light conditions.NTSB ANC07FA037Accident · 1 fatalField investigationFinal reportCessna 170 · Wasilla, AKA total loss of engine power during takeoff initial climb due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB NYC07LA107Accident · Serious injuriesLimited investigationFinal reportGrumman S-2B · Cherry Point, NCThe flightcrew's failure to comply with the published emergency procedure following a loss of engine power on the right engine. Contributing to the accident was the failure of a magneto in the right engine.NTSB LAX07FA150Accident · 2 fatalField investigationFinal reportCessna S550 · Dillon, MTAn in-flight loss of control for undetermined reasons.NTSB CHI07LA129Accident · No injuriesLimited investigationFinal reportCessna 210 · Vienna, OHLoss of engine power during approach for undetermined reasons. Unsuitable terrain encountered during the forced landing and a vehicle were factors.NTSB SEA07LA118Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Kayenta, AZThe overstress separation of both ruddervators during cruise flight. Contributing to the accident was the flight's encounter with turbulence.NTSB MIA07IA088Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Atlanta, GAThe improper overhaul of the horizontal stabilizer chain drive unit drive assembly.NTSB MIA07CA090Accident · No injuriesData collectionFinal reportCessna 172R · Lantana, FLThe student pilot's failure to maintain directional control of the airplane during landing roll.NTSB DFW07LA103Accident · 2 fatalLimited investigationFinal reportLivpt Lancair IV-P · McAllen, TXA loss of power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA102Accident · 1 fatalLimited investigationFinal reportWalker Zenith Zodiac 601 XL · Canadian, TXThe pilot's improper pre-flight planning and decision to depart into deteriorating weather conditions, which resulted in a loss of control and subsequent in-flight break up.NTSB ANC07LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Haines, AKThe main landing gear attachment bolts to the right ski sheared during the landing roll in deep snow, resulting in a nose down, and structural damage to the right wing and aileron.NTSB SEA07CA120Accident · No injuriesData collectionFinal reportCessna 172R · Livermore, CAThe pilot's improper flare during landing.NTSB LAX07LA147Accident · 1 fatalLimited investigationFinal reportCeridono Vegas Sport Flyer · Mountain Pass, CAThe loss of airplane control while maneuvering after takeoff for an undetermined reason.NTSB CHI07WA133Accident · No injuriesForeign investigationEurocopter AS355F2 · Peterborough, United KingdomNTSB CHI07LA126Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Fruitport, MIThe flight instructor failed to use carburetor heat during takeoff in icing conditions. A factor was the power line pole.NTSB CHI07CA128Accident · No injuriesData collectionFinal reportCessna 172P · West Chicago, ILThe instructor's inadequate remedial action following the student pilot's loss of control during the crosswind landing and the instructor's failure to compensate for the wind conditions. Contributing factors were, the crosswind, the gusting wind conditions…