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 LAX05LA248Accident · Minor injuriesLimited investigationFinal reportScandinavian Aero Industry KZ VII · Elko, NVThe pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the total loss of engine power.NTSB LAX05LA247Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Fallbrook, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB DEN05CA116Accident · No injuriesData collectionFinal reportCessna 210E · Saratoga, WYthe pilot's failure to maintain aircraft control and the pilot's improper preflight planning/preparation. Contributing factors include the pilot's failure to maintain airspeed resulting in an inadvertent stall/mush, the pilot's failure to calculate a weight…NTSB CHI05CA204Accident · Minor injuriesData collectionFinal reportWilson Acrolite 1T · Oshkosh, WIThe partial loss of engine power due to an obstructed carburetor fuel metering jet. Factors to the accident included the low altitude at which the loss of engine power occurred, the contamination of the fuel system from degraded automobile-style fuel lines,…NTSB ATL05LA137Accident · 1 fatalLimited investigationFinal reportCessna T210 · Muscle Shoals, ALThe pilot's inadequate visual lookout, and failure to maintain clearance, which resulted in an in flight collision with a transmission wire.NTSB SEA05LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Sunriver, ORThe loss of engine power as a result of both sets of magneto points failing to open due to excessive wear of the nylon cam followers. The excessive wear of the cam followers was due to maintenance personnel's failure to follow the magneto manufacturer's…NTSB SEA05CA154Accident · Minor injuriesData collectionFinal reportGrumman American AA1B · Camas, WAThe student pilot's failure to maintain aircraft control during landing roll. A contributing factor was the gusty cross-wind weather condition.NTSB SEA05CA152Accident · No injuriesData collectionFinal reportCessna 180 · McCall, IDThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the crosswind.NTSB NYC05LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Caldwell, NJThe pilot's improper flare, which resulted in a hard landing. A factor was a partial loss of engine power, as reported by the pilot, for undetermined reasons.NTSB IAD05CA106Accident · No injuriesData collectionFinal reportGrumman American AA-5B · Stow, MAAn inadvertent collision with a deer during the landing roll. A factor was the night lighting conditions.NTSB DFW05CA194Accident · No injuriesData collectionFinal reportCessna 175A · Graham, OKThe impending loss of engine power as result of the failure of the generator mounting gasket resulting in engine oil starvation. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB CHI05CA255Accident · No injuriesData collectionFinal reportLet L 33 Solo · Stanton, MNThe pilot's failure to maintain a proper descent rate during landing due to the wind gusts. The wind gusts were a factor.NTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.NTSB ANC05TA111Accident · No injuriesFinal reportMcDonnell Douglas 500D · Delta Junction, AKThe pilot's failure to maintain clearance from trees during the approach to landing, which resulted in the main rotor blades striking a tree. A factor associated with the accident was the tree.NTSB ANC05LA110Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Ketchikan, AKAn electrical arc on the exterior of a fuel pressure line that initiated a fuel leak and fire during cruise flight, which resulted in serious injuries to the pilot as he performed an emergency landing on the water. A factor contributing to the accident was an…NTSB DFW05FA192Accident · 2 fatalField investigationFinal reportAero Commander 112 · Junction, TXThe pilot's failure to attain the proper climb rate resulting in the airplane's wing colliding with a tree and subsequent impact with the ground. Contributing factors were the pilot's improper use of the airplane's flaps, and the rising terrain.NTSB DFW05CA198Accident · Minor injuriesData collectionFinal reportAmateur Built Varieze · Alco, ARThe pilot's pilots failure to refuel the airplane. Contributing factors were the low ceilings and the lack of suitable terrain for the precautionary landing.NTSB CHI05LA200Accident · Minor injuriesLimited investigationFinal reportVans RV-9A · Neenah, WIThe pilot failed to maintain sufficient airspeed on final approach to avoid a stall, resulting in an inadvertent stall and uncontrolled descent to the terrain.NTSB CHI05FA199Accident · 1 fatalField investigationFinal reportGlasair GS-2 · Wautoma, WIthe abrupt maneuver that was performed while failing to maintain airpeed, resulting in a stall, and uncontrolled impact with the ground without sufficient altitude to recover.NTSB ANC05CA109Accident · No injuriesData collectionFinal reportMaule MX7-180 · Yakutat, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a nose-over. A factor contributing to the accident was soft terrain.NTSB MIA05WA138Accident · 2 fatalForeign investigationCessna 208B · Cuilco, GuatemalaNTSB LAX05LA245Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Oroville, CAa binding and/or activation of the brakes that lead to an inadvertent nose over. The underlying root cause of the brake binding/activation could not be determined.NTSB LAX05CA246Accident · Minor injuriesData collectionFinal reportStinson 108 · Hesperia, CAthe pilot's failure to maintain directional control during landing rollout.NTSB IAD05FA110Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Georgetown, DEThe pilot's misjudged distance/altitude while on final approach to land, which resulted in an in-flight collision with a vehicle. Factors associated with the accident are the pilot's improper use of the flaps, and the state of Delaware's insufficient…NTSB CHI05GA198Accident · Serious injuriesFinal reportBell 206L-3 · Justice, ILThe pilot's improper in-flight decision while maneuvering which resulted in a tailwind during low airspeed helicopter flight and subsequent loss of tail rotor effectiveness. The struck sign and fence were factors in the accident.NTSB CHI05FA197Accident · 1 fatalField investigationFinal reportNorth American F-51D · Malone, WIThe pilot not maintaining aircraft control and clearance from terrain for undetermined reasons during a low level maneuver.NTSB CHI05CA201Accident · No injuriesData collectionFinal reportCessna 188 · Mexico, MOThe pilot's failure to maintain directional control. Factors were the grass terrain adjacent to the runway and the collapse of the main landing gear.NTSB ATL05CA136Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Rogersville, TNThe flight instructor's failure to maintain directional control which resulted in a on ground collision with terrain.NTSB ANC05CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Aleknagik, AKThe pilot's inadequate compensation for the gusty crosswind conditions during an aborted takeoff, which resulted in an on ground collision with a tree. Factors associated with the accident are the gusty crosswind, and the pilot's failure to maintain…NTSB SEA05WA155Accident · 3 fatalForeign investigationBell 206 L4 · Balaga, Sarawak, MalaysiaNTSB ANC05LA107Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350BA · Juneau, AKA loss of engine power during takeoff initial climb due to the separation of the engine power turbine shaft, the failure of which was due to a disconnected adjacent leaf spring, which resulted in an emergency landing after takeoff and subsequent hard landing.NTSB NYC05CA124Accident · No injuriesData collectionFinal reportWaco AQC-6 · Leonardtown, MDThe pilot's inadequate compensation for wind and his failure to maintain aircraft control while landing, which resulted in a nose over. A factor in this accident was the crosswind condition.NTSB MIA05LA136Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2B · Ft. Pierce, FLThe pilot's inadequate preflight planning/preparation, and failure to refuel the helicopter prior to takeoff which resulted in fuel exhaustion and a loss of engine power during the landing.NTSB IAD05LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chatham, VAThe pilot's failure to ensure that the fuel selector valve was properly engaged, which resulted in fuel starvation and subsequent loss of engine power.NTSB IAD05LA107Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Plymouth, MAFatigue failure of the intermediate tailrotor driveshaft, which resulted in a loss of directional control at a hover.NTSB DFW05FA188Accident · 3 fatalField investigationFinal reportCessna 310Q · Ada, OKThe loss of engine power as a result of a fatigue fracture in one of the crankshaft gear teeth for undetermined reasons. Also causal was the pilot's failure to maintain control of the twin-engine airplane after the power loss, which resulted in an inadvertent…NTSB DEN05FA114Accident · 3 fatalField investigationFinal reportBeech N35 · West Jordan, UTthe pilot's improper preflight planning, his attempted flight into adverse weather conditions, and the stall resulting in the loss of control and subsequent crash. Factors contributing to the accident were the pilot's inadequate evaluation of the weather…NTSB CHI05CA196Accident · No injuriesData collectionFinal reportSimmons GP-4 · Oshkosh, WIThe pilot's failure to maintain airspeed sufficient enough to compensate for the gusty crosswind condition and prevent a stall during the landing flare. A factor associated with the accident was the gusting crosswind condition.NTSB ATL05FA135Accident · 2 fatalField investigationFinal reportBeech V35B · Rock Hill, SCThe pilot's mismanagement of the fuel supply , which resulted in fuel starvation and subsequent loss of engine power.NTSB ANC05LA104Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to compensate for wind conditions and his failure to maintain directional control of the airplane during the landing roll, which resulted in an excursion off the side of the runway and a nose over.NTSB SEA05CA150Accident · No injuriesData collectionFinal reportAmerican Champion 7ECA · Hailey, IDThe pilot's inadequate recovery from a bounced landing and his failure to maintain directional control during the landing roll. Factors include a crosswind, and soft terrain just off the side of the runway surface.NTSB DFW05LA187Accident · 1 fatalLimited investigationFinal reportYakovlev Yak 52 · Claremore, OKThe pilot's failure to obtain adequate airspeed while executing a low altitude aerobatic maneuver, which resulted in an aerodynamic stall while inverted. A factor was the low altitude.NTSB DFW05CA191Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Gassoway, LAThe pilot's premature lift-off which resulted in an inadequate climb for terrain clearance. Also causal was the pilot's failure to abort the takeoff. A contributing factor was the high density altitude.NTSB DFW05CA189Accident · No injuriesData collectionFinal reportRockwell International S-2R · Hamlin, TXThe failure of the propeller blade seal resulting in an oil leak. Contributing factors were the limited forward visibility and lack of suitable terrain for the precautionary landing.NTSB ANC05CA105Accident · No injuriesData collectionFinal reportJeska Murphy Rebel · Kivalina, AKThe pilot's failure to attain adequate airspeed during takeoff-initial climb, which resulted in a stall and collision with a ditch. A factor contributing to the accident was the ditch.NTSB MIA05CA141Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Kissimmee, FLFailure of the student pilot to maintain control of the airplane during a go around resulting in the airplane descending and colliding with the ground.NTSB LAX05LA244Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Globe, AZThe fatigue failure of the compressor turbine stator vane, the liberation of vane material into the compressor turbine, and the total loss of engine power. Also causal was the operator's failure to inspect the compressor turbine vane during fuel nozzle checks.NTSB LAX05GA243Accident · Serious injuriesFinal reportAero Commander 680 FL · Las Vegas, NVThe pilot's excessive selection of flaps prior to takeoff, which resulted in a failure to obtain/maintain an appropriate climb airspeed, and an inadvertent stall/mush during takeoff-initial climb. A factor contributing to the accident was a high density…NTSB IAD05LA108Accident · No injuriesLimited investigationFinal reportRobinson R22 · Nashua, NHThe flight instructor's failure to maintain aircraft control during a introductory flight and his inadequate remedial actions.NTSB SEA05CA149Accident · Minor injuriesData collectionFinal reportHughes 269A · Laurel, MTthe pilot's failure to maintain rotor rpm while executing a pinnacle approach, which resulted in a loss of control and collision with terrain.