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 NYC00WA237Accident · 5 fatalForeign investigationCessna 340 · Glarus, SwitzerlandNTSB NYC00LA268Accident · No injuriesLimited investigationFinal reportAerosports Connection FB-582 · Perth Amboy, NJThe pilot's failure to maintain directional control while taxiing for take off on water.NTSB MIA00LA276Accident · Serious injuriesLimited investigationFinal reportChristian Quicksilver · Booneville, MSan inadvertent stall at too low an altitude to allow recovery, which resulted in impact with trees. Factors in this accident were the owner/pilot was not a certified pilot, and lacked training.NTSB LAX00LA309Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Scottsdale, AZFailure of the pilot to maintain directional control on the landing rollout. Also causal to the accident was his failure to retract flaps during the aborted landing attempt, which lead to a loss of lift and a hard landing followed by a ground loop.NTSB FTW00LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · San Antonio, TXThe pilot's failure to maintain control during landing. A factor was the reported wind gust.NTSB FTW00LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAthe failure of the supercharger during takeoff. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA238Accident · No injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe student pilot's delayed landing flare and failure to recover from the ensuing bounced landing.NTSB DEN00LA156Accident · No injuriesLimited investigationFinal reportCessna 180K · Douglas, WYThe pilot's failure to maintain control of the aircraft during landing roll. Factors were high winds and crosswinds.NTSB CHI00WA307Accident · No injuriesForeign investigationBeech 55 · Sydney, CanadaNTSB CHI00LA267Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · North Platte, NEthe brake fire while taxiing for undetermined reasons.NTSB ATL00LA083Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Key West, FLFailure of the right brake expander tube which limited the pilots control of the aircraft.NTSB SEA00LA168Accident · No injuriesLimited investigationFinal reportCessna 172B · Sunriver, ORThe pilot's improper decision to continue the takeoff after the aircraft failed to climb or accelerate immediately after the initial liftoff. Factors were inadequate preflight planning, to include the pilot's failure to calculate takeoff performance data,…NTSB SEA00LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's excessive use of brakes. Contributing factors were the pilot's misjudgment of distance/speed (landing long and fast) and lack of experience in the make/model of aircraft.NTSB NYC00LA236Accident · No injuriesLimited investigationFinal reportCessna 172K · Warwick, RIThe pilot's delayed recovery from a bounced landing.NTSB NYC00LA233Accident · Serious injuriesLimited investigationFinal reportGrooms Titan Tornado · Libertytown, MDAn engine seizure due to improper reconditioning of piston/cylinder after a previous seizure. A factor was the unsuitable terrain, to which, the forced landing was made.NTSB NYC00LA232Accident · Serious injuriesLimited investigationFinal reportTriple S Aero Lancair IVP · Moraine, OHThe pilot's failure to maintain a proper glide path to the runway which resulted in the airplane contacting a 15-foot levee just short of the runway.NTSB MIA00LA243Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · St. Petersburg, FLThe pilot's improper judgment not to sit in the pilot's seat (rear seat) and improper use of brakes on landing roll resulting in a loss of directional control and subsequent nose over.NTSB LAX00LA308Accident · Minor injuriesLimited investigationFinal reportPulsar 100 · Victorville, CAthe pilot's failure to provide enough fuel for the intended flight. Contributing to the accident was an improper fuel vapor return system.NTSB FTW00LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ennis, TXThe loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel selector positioning.NTSB DEN00LA155Accident · Serious injuriesLimited investigationFinal reportTrammell Avid Flyer · Trinidad, COthe failure of wing lift strut attachment rod for an unknown reason, which resulted in a loss of aircraft control during initial takeoff climb.NTSB NYC00LA234Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAThe partial loss of power due to an inadequate annual inspection, which resulted in the throttle linkage becoming disconnected from the throttle.NTSB MIA00LA242Accident · No injuriesLimited investigationFinal reportRyan ST3KR · St. Lucie, FLThe pilot's improper judgment to conduct a precautionary landing when he first experienced a partial loss of engine power, and his subsequent failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with a tree.…NTSB LAX00LA307Accident · No injuriesLimited investigationFinal reportHickey SE5-A · San Bernardino, CAthe pilot's inadequate preflight inspection, and his failure to verify adequate fuel for the planned flight, which resulted in a loss of engine power with no suitable forced landing site.NTSB LAX00FA306Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Watsonville, CAThe divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in mast bumping and rotor contact with the fuselage.NTSB IAD00LA077Accident · No injuriesLimited investigationFinal reportFoulke Europa TRI-GEAR · Doylestown, PAThe pilot's failure to maintain directional control during landing.NTSB FTW00FA236Accident · 1 fatalField investigationFinal reportCessna 150 · Collinsville, OKthe pilot's failure to maintain control of the aircraft while maneuvering after takeoff, which resulted in an inadvertent stall/spin and impact with terrain.NTSB FTW00FA235Accident · 4 fatalField investigationFinal reportGulfstream American AA-5B · Barrett, TXthe pilot's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent stall. A contributing factor was the loss of engine power for undetermined reasons.NTSB CHI00LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mackinac Island, MIthe pilot not maintaining aircraft control in response to the uncommanded roll, and the excessive descent to the runway resulting in the hard landing. Factors relating to the accident were the pilot's attempted recovery from the uncommanded roll, the high…NTSB CHI00FA266Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Valparaiso, INThe in-flight fracture of the main rotor mast and the separation of the main rotor. Factors to the accident were the corroded main rotor mast that resulted in fatigue.NTSB CHI00FA262Accident · 2 fatalField investigationFinal reportBell OH-58C · Watertown, WIThe spatial disorientation by the pilot during continued flight into instrument conditions and the inadequate surveillance by the operator. The inoperative attitude indicator and night conditions were contributing factors.NTSB ATL00FA082Accident · 1 fatalField investigationFinal reportBeech B60 · Austell, GAThe pilot's failure to preflight plan adequate fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB SEA00LA166Accident · No injuriesLimited investigationFinal reportFairchild 24G · Cascade Locks, ORThe pilot's failure to apply carburetor heat after experiencing a partial power loss while flying under conditions conducive to the formation of carburetor ice. Factors include the presence of carburetor icing conditions and an expanse of water (Columbia…NTSB SEA00LA164Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe pilot's failure to maintain directional control during the balked landing.NTSB MIA00LA241Accident · 1 fatalLimited investigationFinal reportBurgess AIR Command · Punta Gorda, FLThe pilot's failure to maintain aircraft control while performing aerobatic flight resulting in an in-flight loss of control, inadvertent stall, and subsequent in-flight collision with power lines, fence, and terrain. Contributing to the accident was the…NTSB LAX00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZThe pilot's improper go-around procedure and his failure to maintain directional control on landing.NTSB IAD00FA076Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Kennebunkport, MEFracture of the #4 connecting rod for undetermined reasons, which resulted in a loss of engine power. A factor was the forced ocean ditching.NTSB CHI00LA313Accident · No injuriesLimited investigationFinal reportCessna 152 · Cumberland, WIthe go-around not performed and the inadequate flare by the pilot.NTSB ATL00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Vero Beach, FLThe pilot's inability to control the aircraft after landing due to a loss of engine power and landing gear failure for undetermined reasons. A factor in the severity of the accident was the impact with the airport marker lights.NTSB ANC00LA106Accident · No injuriesLimited investigationFinal reportBeech C-99 · Deadhorse, AKAn in-flight collision with a bird.NTSB NYC00IA231Incident · No injuriesIncident investigationFinal reportFokker F-100 · Norfolk, VAThe failure of the airplane's ground/flight switch and a malfunction of the thrust reverser deploy switch, which resulted in an in-flight thrust reverser deployment.NTSB MIA00LA240Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Pensacola, FLThe pilot receiving instruction failure to achieve the proper touch down point during a water landing, and the CFI's improper supervision and failure to initiate a go-around in sufficient time to avoid and in-flight collision with trees, water, and subsequent…NTSB CHI00LA261Accident · No injuriesLimited investigationFinal reportCessna 152 · New London, MOthe fuel exhaustion and inadequate preflight planning/preparation by the pilot.NTSB CHI00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chapin, ILthe pilot's failure to refuel the aircraft prior to the flight and exhaustion of the fuel supply. A factor to the accident was the embankment.NTSB CHI00LA259Accident · No injuriesLimited investigationFinal reportCessna 172M · Harbor Springs, MIthe pilot's long touchdown, and inadequate braking to stop on the runway. Factors relating to this accident were the pilot's improper in-flight planning and decision resulting in the long touchdown, and the fence.NTSB ANC00LA105Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe total fatigue failure of the right main landing gear leg.NTSB ANC00LA104Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Chenega Bay, AKThe pilot's failure to maintain an adequate lookout. Factors involved in this accident were sunglare, and a tall bush next to the airstrip.NTSB ANC00LA103Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area on the airstrip. Factors associated with this accident were the rough takeoff area, and the pilot's loss of directional control.NTSB ANC00LA102Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Anchorage, AKThe loss of engine power due to water contamination of the fuel system, the airplane's lack of the required center fuel tank quick drain, and the pilot's inadequate preflight.NTSB NYC00FA229Accident · 2 fatalField investigationFinal reportCessna 182RG · Princeton, KYThe pilot's failure to clear trees, for undetermined reasons.NTSB MIA00LA239Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Zephyrhills, FLThe student pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall/spin and subsequent in-flight collision with terrain.