NTSB investigations, 2005
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ANC05CA083Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in a loss of control and an inadvertent ground-loop. A factor associated with the accident was a crosswind.NTSB SEA05LA114Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-4B · Wenatchee, WAThe pilot's failure to maintain terrain clearance for undetermined reasons.NTSB NYC05CA097Accident · Minor injuriesData collectionFinal reportBurkhart Grob G103 Twin Astir · Wellington, OHThe pilot's misjudgment of distance and altitude which resulted in an undershoot of the runway.NTSB LAX05WA217Accident · Serious injuriesForeign investigationRobinson Helicopter R-44 · Hong Kong, ChinaNTSB IAD05LA074Accident · No injuriesLimited investigationFinal reportWaco GXE · Paducah, KYThe pilot's failure to maintain directional control during landing resulting in a ground loop and impact with the runway. A factor in the accident was the limited authority of the tailwheel steering system.NTSB DFW05CA166Accident · No injuriesData collectionFinal reportRockwell International S-2R · Watson, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB DFW05CA155Accident · No injuriesData collectionFinal reportCessna A188B · Goodlett, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain (soft) for the forced landing.NTSB DFW05CA154Accident · No injuriesData collectionFinal reportCessna 152 · Marietta, OKThe pilot's failure to maintain directional control while executing a soft field take off. A factor was the prevailing dark night conditions.NTSB DEN05LA090Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-319-114 · Scottsbluff, NEthe inflight encounter with moderate turbulence.NTSB DEN05LA088Accident · No injuriesLimited investigationFinal reportBeech S35 · Colorado Spring, COthe flight instructor and pilot's improper decision to continue the attempted high altitude takeoff when Vy airspeed was not obtained, and failure to abort the takeoff which resulted in an off-field landing and subsequent impact with terrain. A contributing…NTSB DCA05WA073Incident · No injuriesForeign investigationCanada/US bordeNTSB CHI05LA145Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Mapleton, NDThe pilot's continued flight into instrument meteorological conditions and his failure to maintain clearance from an object during the precautionary landing. The heavy rain and the unknown object were factors.NTSB CHI05LA140Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Ray, MIThe loss of power on the left engine for undetermined reasons and the flightcrew's failure to maintain aircraft control following the loss of power.NTSB CHI05LA137Accident · Minor injuriesLimited investigationFinal reportMazzon Dragonfly · Garden City, KSThe student pilot's failure to maintain a proper glidepath during landing and his misjudged flare which resulted in the hard landing and subsequent failure of the nose landing gear. Factors were the aborted landing performed by the pilot and the degradation…NTSB ANC05CA084Accident · No injuriesData collectionFinal reportPiper PA-18 · Pamler, AKThe student pilot's failure to obtain/maintain adequate airspeed during takeoff-initial climb, which resulted in an in-flight collision with trees. Factors associated with the accident are a tailwind and diminished braking capability.NTSB LAX05LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Carlsbad, CAthe other pilot's inadequate visual lookout and failure to maintain separation while taxiing.NTSB DFW05IA156Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace Avro 146-RJ85A · Oklahoma City, OKFailure of a high pressure hydraulic line from fatigue as a result of a manufacturing defect.NTSB DFW05CA176Accident · No injuriesData collectionFinal reportCessna A188B · Truman, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A contributing factor was the sunglare.NTSB DFW05CA158Accident · Minor injuriesData collectionFinal reportRose Parakeet A-1 · Boyd, TXThe in-flight separation of the outboard section of the propeller for unknown reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA05IA072Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2D15 · colorado spring, COUndetermined.NTSB CHI05CA139Accident · Minor injuriesData collectionFinal reportGrimes SNS-9 · Niles, MIThe pilot's failure to maintain airspeed which led to the inadvertent stall/mush, and subsequent impact with the ground.NTSB ANC05LA082Accident · No injuriesLimited investigationFinal reportdeHavilland DHC-2 · King Salmon, AKThe pilot's failure to correct for torque/P-Factor during the takeoff run, and his delay in aborting the takeoff, which resulted in a loss of directional control and subsequent wing collision with the surface of the water. A factor contributing to the…NTSB SEA05CA113Accident · No injuriesData collectionFinal reportMicco MAC-145A · Aurora, ORThe demonstration pilot's (pilot in command) inadequate supervision of the pilot-passengers descent on final for landing. A contributing factor was the pilot-passengers improper descent on final for landing.NTSB NYC05IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A330-301 · Boston, MAThe local east controller's failure to follow FAA Order 7110.65, para 3-9-8 and Boston Tower Order 7110.11, Standard Operating Procedures, which resulted in a runway incursion during takeoff involving two transport category airplanes.NTSB NYC05IA093Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Dulles, VAFailure of the right main landing gear to extend and lock for undetermined reasons, which resulted in the right main landing gear collapsing during touchdown.NTSB DFW05FA152Accident · 1 fatalField investigationFinal reportBeech 76 · Conroe, TXThe pilot's failure to maintain sufficient airspeed resulting in a loss of control. Contributing factors were the high density altitude, the pilot's improper decision to secure the left engine, and his attempt to perform a single-engine go-around.NTSB DFW05CA160Accident · Minor injuriesData collectionFinal reportCessna 150H · Morrilton, ARThe pilot's failure to maintain proper alignment with the runway during landing. A contributing factor was the dark night lighting condition.NTSB DEN05FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Telluride, COthe pilot's failure to maintain clearance from terrain. Contributing to the accident were the high, rising terrain and fatigue.NTSB SEA05CA112Accident · No injuriesData collectionFinal reportCessna 150G · Buckley, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power due to carburetor ice and a forced landing. Contributing factors were the carburetor icing conditions and the lack of suitable terrain for the forced landing.NTSB NYC05WA114Incident · No injuriesForeign investigationIsrael Aircraft Industries 1124A · Shannon, IrelandNTSB DFW05CA149Accident · No injuriesData collectionFinal reportBell 206L-1 · Moulton Cove, LAThe loss of engine power due to foreign object ingestion into the compressor. A contributing factor was the lack of suitable terrain (swampy) for the forced landing.NTSB ATL05CA096Accident · Serious injuriesData collectionFinal reportPiper PA-18A-150 · Griffin, GAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was the pilot's inadequate preflight preparation which failed to verify the fuel amount.NTSB ANC05LA081Accident · No injuriesLimited investigationFinal reportCessna 170B · Ninilchick, AKThe pilot's failure to maintain control of the airplane during the landing roll on a beach, which resulted in an on-ground collision with terrain. A factor associated with the accident is a tailwind.NTSB SEA05CA123Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ontario, ORThe pilot's failure to maintain aircraft control during landing roll. A contributing factor was the cross wind weather condition.NTSB NYC05LA092Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Wadsworth, OHThe flight instructor's failure to verify that the engine controls were completely retarded during an aborted takeoff, which resulted in a runway overrun.NTSB NYC05FA094Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11F · Louisville, KYThe flying pilot's improper aircraft handling after main landing gear touchdown, which resulted in the collapse of the nose landing gear assembly. Conributing to the accident was the pilot-in-command's inadequate supervision during the landing.NTSB MIA05CA118Accident · No injuriesData collectionFinal reportHerbert O. Kellerman 173 RG · Venice, FLThe owner/pilot mechanic's inadequate maintenance inspection resulting in a partial loss of engine power due to a loose fuel line.NTSB LAX05LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Santa Ynez, CAthe pilot's failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in a stall and collision with terrain.NTSB LAX05LA196Accident · Minor injuriesLimited investigationFinal reportElan DG 300 · Jean, NVthe glider pilot's failure to release from the towline in a timely manner, and to maintain adequate airspeed. Contributing to the accident was the glider pilot's failure to recognize and correctly recover from the stall in a timely manner, and the inadequate…NTSB DFW05IA150Incident · No injuriesIncident investigationFinal reportCessna 208B · Clarendon, TXThe loss of total engine power due to damage of the compressor stator vanes caused by a foreign object. A contributing factor was an in-flight ingestion of bird(s).NTSB DEN05LA086Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Broomfield, COthe pilot's failure to maintain adequate airspeed which resulted in a stall, and his failure to abort the takeoff. The loss of power for undetermined reasons is a contributing factor.NTSB DEN05CA085Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Wallsburg, UTthe flight instructor's inadequate in-flight planning and decision making and failure to maintain aircraft control. Contributing factor's include the flight instructor's inadequate supervision of the flight, the student pilot's failure to maintain rotor rpm,…NTSB DCA05MA070Accident · 1 fatalMajor investigationFinal reportEmbraer 170 · Washington, DCThe inexperience of the driver (fleet service agent) in the operation of a belt loader, which resulted in the belt loader being driven under, and colliding with, the airplane.NTSB CHI05LA136Accident · No injuriesLimited investigationFinal reportCessna 182TR · Wheeling, ILThe pilot failed to verify that the landing gear were fully extended and failed to perform the emergency landing gear extention procedures. Factors to the accident included the low hydraulic fluid level, and the weak battery that resulted in a partial…NTSB IAD05LA075Accident · Minor injuriesLimited investigationFinal reportHughes TH-55 · Paintsville, KYthe pilot's inadvertent encounter with ground resonance which resulted in destruction of the helicopter.NTSB ATL05LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301T · Tazewell, TNLoss of engine power due to oil starvation; the reason for the oil starvation could not be determined.NTSB ANC05LA079Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Stony River, AKA partially blocked fuel pump, which resulted in a loss of engine power while in cruise flight. A factor associated with the accident was an inoperative electric auxiliary fuel pump.NTSB LAX05LA194Accident · No injuriesLimited investigationFinal reportMaule 7-235 · Truckee, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB LAX05CA195Accident · No injuriesData collectionFinal reportBoeing A75N-1 · Paulden, AZthe pilot's inadequate compensation for wind conditions, and his failure to maintain airspeed which resulted in a stall mush and collision with objects.NTSB IAD05LA072Accident · Serious injuriesLimited investigationFinal reportWeiss Vans RV-8 · Canandaigua, NYPartial blocking of the flight controls by unsecured items in the cockpit, which resulted in a loss of control during takeoff.