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 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.NTSB NYC05CA122Accident · No injuriesData collectionFinal reportGulfstream American AA-5A · Schroon Lake, NYThe pilot's misjudgment of speed/distance which resulted in an overrun.NTSB LAX05LA241Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Beaumont, CAthe pilot's failure to maintain an adequate airspeed while maneuvering that led to an inadvertent stall/mush. The pilot's delayed decision to release the banner was also causal.NTSB DFW05CA186Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Tallulah, LAThe partial loss of engine power as result of the fracture of the number five-cylinder exhaust valve rocker arm mounting boss. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC05CA103Accident · No injuriesData collectionFinal reportCessna 172 · Kenai, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was swampy terrain.NTSB SEA05CA148Accident · No injuriesData collectionFinal reportPiper PA-16 · Park City, MTThe failure of the pilot to maintain directional control of the airplane on the takeoff roll. Factors contributing to the accident included the loose gravel, ditch, and the fence.NTSB LAX05LA242Accident · 1 fatalLimited investigationFinal reportQuicksilver Mxlii 101 Sport · Galt, CAloss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and uncontrolled descent into terrain.NTSB LAX05CA275Accident · No injuriesData collectionFinal reportCessna 172S · Edwards AFB, CAthe pilot's misjudged flare and inadequate recovery technique from the subsequent bounces.NTSB LAX05CA240Accident · No injuriesData collectionFinal reportCessna 172N · North Las Vegas, NVthe student pilot's failure to maintain directional control.NTSB IAD05LA111Accident · No injuriesLimited investigationFinal reportCessna 182T · Chatham, MAthe pilot's improper recovery from a bounced landing.NTSB IAD05LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Copake, NYThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB DFW05FA185Accident · 3 fatalField investigationFinal reportMooney M20J · Saginaw, TXThe pilot's loss of control for undetermined reasons while maneuvering.NTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.NTSB SEA05LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jerome, IDFailure to maintain clearance from terrain during takeoff and initial climb. A high density altitude was a factor.NTSB NYC05LA121Accident · 1 fatalLimited investigationFinal reportRatliff Hummel Bird · Pittsville, MDA loss of control for undetermined reasons, which resulted in an uncontrolled descent into terrain.