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 MIA05WA159Accident · 4 fatalForeign investigationCessna 207 · La Esmeralda, VenezuelaNTSB MIA05LA158Accident · 2 fatalLimited investigationFinal reportCessna 172C · Saint Cloud, FLThe pilot's failure to maintain the airspeed while maneuvering following loss of engine power resulting in a stall/mush, an uncontrolled descent, and collision with trees and the ground.NTSB LAX05WA325Accident · Serious injuriesForeign investigationRobinson R44 · Denham, United KingdomNTSB LAX05CA307Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Reno, NVthe pilot's inadequate compensation for wind conditions and failure to maintain directional control. Contributing factors to the accident were the gusting quartering tail wind conditions.NTSB DFW05WA243Accident · 2 fatalForeign investigationCessna 525 · Rio de Janeiro, BrazilNTSB DEN05LA141Accident · 2 fatalLimited investigationFinal reportDenight 100D2 · Hudson, COthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB CHI05CA269Accident · No injuriesData collectionFinal reportBeech F33A · Emerson, NEThe loss of engine power due to the pilot's failure to verify the fuel selector position which resulted in fuel starvation. Factors were the low altitude, the crops and the fence.NTSB ATL05CA162Accident · Serious injuriesData collectionFinal reportPiper PA-34-200 · Greenville, ALThe loss of left engine power due to fuel system contamination and the pilot's failure to follow procedures and his improper use of the throttle and flight controls during the forced landing.NTSB SEA05LA194Accident · No injuriesLimited investigationFinal reportCessna 182P · Yellow Pine, IDThe pilot's improper preflight planning/preparation during takeoff. A factor was the windshear.NTSB NYC05LA142Accident · No injuriesLimited investigationFinal reportRaytheon BE-390 · Rockland, METhe pilot's failure to maintain aircraft control during landing.NTSB LAX05CA304Accident · No injuriesData collectionFinal reportBeech 95-B55 · Porterville, CAthe pilot's failure to extend the landing gear prior to landing.NTSB IAD05LA136Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cadiz, KYThe pilot's inadequate in-flight decision, which resulted in fuel exhaustion and subsequent loss of engine power. A factor was the pilot's early flare during the emergency landing.NTSB DFW05FA240Accident · 3 fatalField investigationFinal reportCessna 175B · Cleveland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A contributing factor was the low altitude.NTSB CHI05CA271Accident · No injuriesData collectionFinal reportBell 206B · Elk Point, SDThe loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.NTSB CHI05CA268Accident · Minor injuriesData collectionFinal reportCessna 180A · Lodi, WIThe pilot's failure to maintain directional control of the airplane during landing resulting in a nose-over.NTSB ATL05CA161Accident · Minor injuriesData collectionFinal reportBell 47G-3B · Summerville, TNThe pilot's failure to maintain adequate clearance and adequate visual lookout during take-off which resulted in an in-flight collision with a tree and roll over.NTSB MIA05LA157Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Ponte Vedra, FLA loss of engine power for undetermined reasons, which resulted in the airplane being ditched in a marsh.NTSB DFW05CA238Accident · No injuriesData collectionFinal reportCessna A188B · Paris, TXThe loss of engine power due the failure of a connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA237Accident · Minor injuriesData collectionFinal reportCessna 172M · Amarillo, TXThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Contributing factors were the reported loss of engine power for undetermined reasons and the high density altitude.NTSB DFW05CA236Accident · Serious injuriesData collectionFinal reportGrumman G-164B · Epps, LAThe pilot's failure to maintain clearance with the power lines.NTSB DEN05LA140Accident · No injuriesLimited investigationFinal reportCessna A185F · Boulder, COthe pilot's improper flare which resulted in a hard landing and his subsequent failure to recover from the bounced landing. Contributing factors were the pilot's improper in-flight decision to land in deteriorating weather conditions, turbulence associated…NTSB CHI05CA266Accident · No injuriesData collectionFinal reportRyan Navion G · Lake Geneva, WIThe loss of engine power due to water contamination of the fuel and the pilot's inadequate preflight. A factor was the fence.NTSB CHI05CA264Accident · Minor injuriesData collectionFinal reportMaule MT-7-260 · Decatur, INThe pilot's improper decision to land on a runway with a tailwind, the improper recovery from a bounced landing, and the loss of control during landing roll. Factors included the tailwind and the post.NTSB MIA05LA155Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Ocean Springs, MSThe pilot's mismanagement of available fuel and continued operation with the fuel selector set to the left tank position, which resulted in fuel starvation and subsequent loss of engine power.NTSB MIA05CA156Accident · No injuriesData collectionFinal reportCessna 172-S · Kendall-Tamiami, FLThe pilot's failure to recover from a bounced landing which resulted in damage to the airplane.NTSB IAD05LA135Accident · Serious injuriesLimited investigationFinal reportSikorsky S-76B · Linden, NJThe lineman's failure to maintain adequate clearance from the main rotor system. A factor was his lack of familiarity with the accident helicopter make and model.NTSB DEN05LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Rock Springs, WYthe pilot's failure to maintain control of the helicopter during the attempted autorotation after he experienced an engine overspeed that occurred for reasons undetermined.NTSB DEN05CA144Accident · No injuriesData collectionFinal reportBradford Haines Glastar · Spanish Fork, UTthe pilot's failure to strain the fuel prior to flight resulting in fuel starvation. Contributing to the accident was the loss of engine power due to the plugged fuel filter.NTSB ANC05FA144Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Nenana, AKThe pilot's failure to maintain minimum airspeed to avoid a stall while maneuvering, which resulted in a loss of control, a stall/spin, and impact with terrain. Factors associated with the accident were an aerobatic maneuver, and a stall/spin.NTSB ANC05CA140Accident · No injuriesData collectionFinal reportPiper PA-18 · Nenana, AKThe pilot's improper recovery from a bounced landing during the landing roll, which resulted in a loss of control and a nose over.NTSB SEA05WA193Accident · 2 fatalForeign investigationCessna A185F · Port Hardy, CanadaNTSB SEA05CA191Accident · No injuriesData collectionFinal reportGleason Sky Star Kitfox · Klamath Falls, ORThe binding of the flaperon push pull tube due to deformation of the front seat, which resulted in a loss of control on takeoff initial climb and collision with the runway.NTSB IAD05LA138Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Rangeley, MEA malfunction of the yaw damper system due to fluid contamination. Factors in the accident were the air condition exhaust vent design and the design stress limits of the airplane were exceeded.NTSB IAD05CA143Accident · No injuriesData collectionFinal reportMaule MT7-235 · Capon Bridge, WVThe pilot's misjudged distance/speed which resulted in an overrun and a subsequent impact with trees.NTSB ANC05CA146Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a collision with a tree. A factor contributing to the accident was a tailwind.NTSB ANC05CA141Accident · No injuriesData collectionFinal reportCessna 185F · Bettles, AKThe pilot's inadequate compensation for a gusty crosswind, which resulted in a loss of control and an inadvertent ground-loop during the landing roll. Factors associated with the accident were the ground-loop and gusts.NTSB LAX05FA296Accident · 2 fatalField investigationFinal reportCessna 152 · Lakewood, CAthe certified flight instructor's failure to maintain an adequate airspeed resulting in a stall and loss of control. Also causal was the engine's loss of partial power due to inadequate maintenance, worn spark plugs, worn pistons, and broken piston rings.NTSB LAX05CA295Accident · Minor injuriesData collectionFinal reportRicardo Lopez RAF 2000 Gtxse · Wickenburg, AZthe pilot's failure to obtain and maintain an adequate airspeed and rotor speed during takeoff.NTSB CHI05FA260Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Wabash, INThe pilot's spatial disorientation that resulted in his failure to maintain clearance from terrain. Factors to the accident were the pilot's lack of recent night experience and the hazy night conditions.NTSB CHI05CA265Accident · No injuriesData collectionFinal reportAviat A-1B · Drummond Island, MIThe pilot's failure to adequately compensate for the wind conditions, his failure to perform a go-around, and he flared improperly. Factors included the downdraft and the shoreline.NTSB NYC05LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marstons Mills, MAThe pilot's failure to attain a climb during takeoff which resulted in a diminished climb rate and subsequent collision with trees. Factors were the turf runway and a tailwind.NTSB LAX05CA294Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Peoria, AZthe pilot's encounter with obstacles and unsuitable terrain in the landing area during the pilot's attempted precautionary landing. A factor in the accident was the loose wing root gap seal fairing.NTSB LAX05CA293Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Dunsmuir, CAthe pilot's delayed decision to abort the takeoff.NTSB IAD05CA134Accident · Serious injuriesData collectionFinal reportLamont Aventura II · Hope, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with water. A factor to the accident was the wind gusts.NTSB DFW05CA235Accident · Serious injuriesData collectionFinal reportBell 47G · Swifton, ARThe pilot's failure to maintain clearance with the power lines. A contributing factor was sun glare.NTSB DFW05CA233Accident · No injuriesData collectionFinal reportIsrael Aircraft Industries 1124 · New Braunfels, TXThe airplane's collision with a coyote during the landing roll. A contributing factor was the prevailing night conditions.NTSB DCA06WA002Incident · No injuriesForeign investigationBeech BE-1900D · Valera, VenezuelaNTSB CHI05CA263Accident · Minor injuriesData collectionFinal reportKeith Avid Amphibian · Buchanan, MIThe loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor was the power lines.NTSB ATL05CA160Accident · No injuriesData collectionFinal reportCessna 182T · Wilmington, NCThe pilot's improper flare which resulted in a hard landing, and the collapse of the nose gear.NTSB ATL05CA159Accident · No injuriesData collectionFinal reportPiper 28 · Andulusia, ALThe pilot's inadequate planning of the fuel supply, which resulted in fuel exhaustion and loss of engine power.