NTSB investigations, 2005
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 2005 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 WHERE year(c."eventDate") = 2005 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 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.NTSB ANC05LA143Accident · No injuriesLimited investigationFinal reportCessna 180C · Igiugig, AKThe failure of the airplane's starter to disengage, which resulted in an overheated starter, smoke in the cockpit, and an emergency landing. A factor associated with the accident was soft terrain encountered during the emergency landing.NTSB ANC05LA142Accident · No injuriesLimited investigationFinal reportCessna 185E · Pilot Point, AKThe pilot's misjudged landing flare, which resulted in a hard landing and an overload failure of the main landing gear during the landing touchdown.NTSB SEA05LA192Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Chehalis, WAThe pilot's failure to follow the checklist to switch to the fullest fuel tank prior to departure which resulted in fuel starvation and a loss of engine power during the initial takeoff climb. Subsequently, the aircraft landed hard damaging the landing gear…NTSB DFW05CA234Accident · No injuriesData collectionFinal reportCessna 152 · Galveston, TXThe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05CA138Accident · No injuriesData collectionFinal reportRobinson R44 II · Jackson, WYthe pilot's failure to maintain aircraft control during initial takeoff climb resulting in an uncontrolled descent and impact with terrain. A contributing factor was the pilot's encounter in settling with power.NTSB DEN05CA136Accident · Minor injuriesData collectionFinal reportCessna T207A · Telluride, COthe pilot's improper in-flight planning/decision and failure to maintain aircraft control. Contributing factors were the pilot's failure to maintain airspeed which resulted in an inadvertent stall, and the rising terrain and encounter with downdrafts.NTSB CHI05LA261Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Faulkton, SDThe pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.NTSB CHI05CA262Accident · No injuriesData collectionFinal reportCessna 310Q · Boscobel, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the pilot's diverted attention due to the open cabin door.NTSB CHI05CA259Accident · Minor injuriesData collectionFinal reportDixon RV-4 · Grafton, ILThe loss of engine power due to contamination of the fuel system, gascolator and carburetor inlet screen. A factor to the accident was the soybean crop.NTSB MIA05WA154Accident · 1 fatalForeign investigationBeech BE-58 · Exuma Cay, BahamasNTSB LAX05CA291Accident · No injuriesData collectionFinal reportRobinson R22 · Santa Clarita, CAthe pilot's improper use of the collective control while attempting to free the right skid, which induced a dynamic rollover.NTSB LAX05FA290Accident · 2 fatalField investigationFinal reportCessna 172RG · Avalon, CAan in-flight loss of control for undetermined reasons.NTSB ENG06WA011Accident · 2 fatalForeign investigationRobinson R44 · Slieve Aughty Mountains, Co Galway, Ireland, IrelandNTSB DFW05WA232Accident · 2 fatalForeign investigationCessna 152 · Guadalajara, Mexico