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 CHI05IA273Incident · No injuriesIncident investigationFinal reportConvair Div. of Gen. Dynamics 440 · Kenosha, WIThe flight crew failed to verify that the cargo was secured before takeoff.NTSB ANC05LA149Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Wasilla, AKThe pilot's failure to maintain adequate airspeed while maneuvering over wildlife, which resulted in an uncontrolled descent and subsequent collision with trees. A factor contributing to the accident was an inadvertent stall.NTSB SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.NTSB LAX05WA316Accident · 2 fatalForeign investigationRobinson R-22 Mariner · Falaise, FranceNTSB LAX05TA306Accident · No injuriesFinal reportBell 407 · Inyokern, CAThe pilot failed to maintain tail rotor clearance from obstacles during landing.NTSB LAX05LA309Accident · Serious injuriesLimited investigationFinal reportThomas RV4 · Kernville, CAa loss of engine power due to fuel starvation caused by the pilot's failure to select a tank containing fuel for takeoff. A factor in the accident was the lack of a runway overrun area beyond the departure end of the runway.NTSB LAX05LA308Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350B3 · Running Springs, CAThe pilot's failure to maintain an adequate clearance from trees while performing long line external lift operations.NTSB DFW05WA245Accident · 9 fatalForeign investigationBell 412EP · Llano Grande, MexicoNTSB DFW05FA244Accident · 2 fatalField investigationFinal reportDiamond Aircraft Industries DA20-C1 · Pleasanton, TXThe flight instructor's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.NTSB DFW05CA250Accident · No injuriesData collectionFinal reportRobinson R44 · Batesville, TXThe pilot's failure to maintain rotor rpm and his subsequent encounter with settling with power.NTSB CHI05CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mount Ayr, IAThe pilot's selection of a wrong runway, and the misjudged distance/speed which resulted in an overrun. Contributing factors were the tailwind, and the ditch.NTSB NYC05LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Millville, NJThe flight instructor's improper in-flight decision to perform a emergency landing to a runway, with a tailwind, and his failure to maintain airspeed after aborting that landing, which resulted in an inadvertent stall and subsequent impact with terrain.…NTSB LAX05FA311Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Baker, CAThe pilot's continued VFR flight into adverse weather conditions that resulted in a collision with mountainous terrain. Contributing to the accident was the obscuration of mountainous terrain by rain and low clouds, moderate turbulence, and the pilot's…NTSB LAX05CA310Accident · Minor injuriesData collectionFinal reportClark Vans RV8 · Sonoma, CAa loss of engine power due to the failure of the master electrical power switch, which removed power to the electronic ignition.NTSB DFW05CA246Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Guion, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.NTSB NYC05CA143Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB LAX05LA305Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Bisbee, AZthe pilot's failure to lean the mixture in accordance with the pilot operating handbook specified procedures, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush…NTSB LAX05LA303Accident · Minor injuriesLimited investigationFinal reportNorth American Navion A · Chowchilla, CAthe loss of engine power for undetermined reasons.NTSB IAD05LA139Accident · No injuriesLimited investigationFinal reportHart None · Broadalbin, NYA loss of engine power for undetermined reasons.NTSB DEN05LA143Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Torrington, WYfailure of the #7 connecting rod, causing engine seizure. A contributing factor was the berm.NTSB DEN05CA146Accident · No injuriesData collectionFinal reportSchleicher ASW-20B · Moriarty, NMthe pilot's failure to maintain control of the glider during the takeoff roll which resulted in a ground loop.NTSB CHI06CA018Accident · No injuriesData collectionFinal reportStinson 108-1 · Tea, SDThe pilot's failure to maintain directional control during the landing rollout which resulted in the encountered ground loop.NTSB SEA05LA196Accident · No injuriesLimited investigationFinal reportCessna 152 · Olympia, WAThe pilot's loss of aircraft control during landing roll, and airplane's subsequent inadvertent ground loop.NTSB SEA05CA195Accident · Minor injuriesData collectionFinal reportEiland RAF-200 Gyro · Bend, ORThe malfunction of the flight controls for an undetermined reason, which resulted in a loss of control and in-flight collision with terrain.NTSB LAX05CA302Accident · No injuriesData collectionFinal reportCessna 172S · Show Low, AZthe pilot's selection of a downwind runway for landing and his inadequate compensation for the strong and gusty quartering tail wind conditions, which resulted in a tail strike during landing.NTSB IAD05LA137Accident · 1 fatalLimited investigationFinal reportPiper PA-24-260 · Tiffin, OHThe pilot's decision to takeoff in weather below the published takeoff minimums, which resulted in spatial disorientation and the airplane's collision with trees and terrain. Factors in the accident were the instrument meteorological conditions, and the…NTSB DFW05FA242Accident · 1 fatalField investigationFinal reportAkro Tech Aviation Inc. Giles G-300 · Yukon, OKThe catastrophic separation of the canopy as result of the failure of the forward canopy hinge while performing aerobatics and the subsequent incapacitation of the pilot.NTSB DFW05FA241Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Houston, TXThe pilot's improper in-flight decision to maneuver back to the departure airport following a loss of engine power on initial climb. Contributing factors were the loss of engine power for undetermined reasons, and the dark night conditions.NTSB DEN05LA142Accident · Serious injuriesLimited investigationFinal reportShea Vans RV6A · Glendo, WYfailure of the nose gear during the landing roll.NTSB DCA05MA099Accident · No injuriesMajor investigationFinal reportAirbus A321-231 · Fort Lauderdale, FLFollowing a bounced landing, the pilot in command activated his sidestick controller while the first officer was in control of the airplane, which subsequently resulted in the overcontrol of pitch and a tailstrike. Contributing to the circumstances of this…NTSB CHI05CA270Accident · No injuriesData collectionFinal reportCessna 182S · Waukesha, WIThe misjudged flare by the pilot.NTSB LAX05CA301Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Petaluma, CAa loss of engine power due to fuel exhaustion.NTSB DEN05LA148Accident · 1 fatalLimited investigationFinal reportBrown Hi-MAX 1700R · Fort Morgan, COThe pilot's failure to maintain control of the airplane during a forced landing. Contributing factors were the resultant and inadvertent stall, the loss of engine power for undetermined reasons, and the pilot's lack of familiarity with the airplane.NTSB ANC05CA148Accident · No injuriesData collectionFinal reportAeronca 7AC · Coldfoot, AKThe pilot's misjudgment of distance/altitude during the landing flare/touchdown, which resulted in an undershoot and subsequent nosing down of the airplane when the main landing gear tires contacted shallow water prior to the intended landing site.NTSB ANC05CA147Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe pilot's misjudgment of distance/speed during landing, which resulted in an overrun, a loss of directional control, and a nose over during the landing roll.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.