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 DFW05CA120Accident · No injuriesData collectionFinal reportMayfield Sparrowhawk · Hondo, TXThe pilot's failure to maintain control of the gyrocraft during takeoff. A contributing factor was the failure of the pre-rotator cable.NTSB DEN05LA077Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe failure of the nose gear actuator resulted in penetration of the forward pressure bulkhead and a loss of pressurization.NTSB DEN05LA075Accident · No injuriesLimited investigationFinal reportCessna T188C · Fowler, COthe pilot's failure to maintain visual lookout and clearance, resulting in an in-flight collision with transmission lines.NTSB CHI05LA114Accident · 1 fatalLimited investigationFinal reportCessna A188B · Ludell, KSThe pilot's failure to maintain clearance from trees during an aerial application maneuver. The trees and the sun glare were contributing factors.NTSB ATL05LA091Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Newnan, GAThe improper repair to the main landing gear assembly resulted in the actuator bracket failure and the right main gear collapse. A factor was the inadequate inspection of the right main landing gear.NTSB ANC05LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident are a crosswind, and an inadvertent ground loop/swerve.NTSB NYC05MA083Incident · No injuriesMajor investigationFinal reportBoeing 717-200 · Union Star, MOA loss of reliable airspeed indication due to an accumulation of ice on the air data/pitot sensors. Contributing to the incident was the flight crew's improper response to the erroneous airspeed indications, their lack of coordination during the initial…NTSB IAD05LA063Accident · 2 fatalLimited investigationFinal reportAeronca 65-TAC · Harrisonburg, VAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with the ground.NTSB IAD05LA062Accident · Minor injuriesLimited investigationFinal reportAeronca 65 · Sanborn, NYThe pilot's inadequate preflight preparation, which resulted in fuel exhaustion, and subsequent loss of engine power during cruise flight.NTSB DFW05IA119Incident · No injuriesIncident investigationFinal reportEurocopter France EC120B · S.Timbalier 265The loss of engine power as result of the failure of the oil pump assembly.NTSB SEA05LA100Accident · No injuriesLimited investigationFinal reportCessna 152TW · Missoula, MTThe pilot's failure to maintain clearance from a taxiway identification sign as he attempted to turn off the runway onto the taxiway during the last part of the landing roll. Factors include a taxiway identification sign in the vicinity of the intersection of…NTSB MIA05LA103Accident · No injuriesLimited investigationFinal reportAmerican General AG-5B · St. Augustine, FLThe separation of the throttle control for undetermined reasons, and the unsuitable terrain encountered by the pilot during the forced landing, resulting in a nose-over after touchdown.NTSB LAX05LA166Accident · No injuriesLimited investigationFinal reportBeech C35 · Rancho Santa Fe, CAfailure of the engine driven fuel pump due to the improper overhaul procedure of the fuel pump by an overhaul facility, and the use of parts that did not meet hardness specification.NTSB LAX05FA167Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Elko, NVThe pilot's continued VFR cruise flight into instrument meteorological conditions in mountainous terrain, and his failure to maintain clearance from terrain. A contributing factor was mountain obscuration and clouds.NTSB ENG05RA020Incident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Rome, ItalyimportNTSB DCA05WA078Incident · No injuriesForeign investigationBoeing 757 · Manchester, United KingdomNTSB SEA05CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Snohomish, WAThe pilot's failure to maintain aircraft control during the landing roll on a sandbar which resulted in the aircraft nosing over.NTSB NYC05LA081Accident · No injuriesLimited investigationFinal reportZeidman RV-6A · Kennett Square, PAA fuel pump malfunction, as reported by the pilot, which resulted in a loss of engine power due to fuel starvation.NTSB NYC05CA082Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's improper flare and recovery from a bounced landing.NTSB LAX05LA164Accident · No injuriesLimited investigationFinal reportRobinson R44 · Gustine, CAthe improper installation of the nut/bolt assembly connecting the left cyclic push-pull tube to the non-rotating swashplate by maintenance personnel, which led to a loss of roll control during takeoff.NTSB DEN05FA074Accident · 4 fatalField investigationFinal reportCessna T210G · Ouray, COthe pilot's inadvertent flight into adverse weather conditions, loss of control, and resulting exceedence of the design stress limits of the aircraft. which led to an in-flight structural failure. Factors in the accident included the pilot's inadequate…NTSB CHI05MA111Accident · Serious injuriesMajor investigationFinal reportMcDonnell Douglas DC-9-51 · Minneapolis, MNthe Captain of the other aircraft's decision to shutdown the left engine during taxi with no hydraulic pressure on the right side hydraulic system to effectively operate the brakes, steering, or thrust reversers. A factor was the fatigue fracture of the…NTSB DEN05CA073Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Fort Collins, COthe pilot's inadequate preflight planning/preparation which failed to assure adequate takeoff performance to clear obstacles. Contributing factors included the miscalculated weight and balance and the high density altitude.NTSB CHI05LA113Accident · No injuriesLimited investigationFinal reportMattson Zenith 601XL · Dike, IAA loss of engine power for undetermined reasons and the pilot misjudged the forced landing approach. Factors associated with the accident were the fence and the ditch which the airplane contacted.NTSB CHI05CA115Accident · No injuriesData collectionFinal reportCessna 172H · Plattsmouth, NEThe student pilot's inadequate compensation for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusting crosswind.NTSB ANC05LA075Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Elim, AKAn improper installation of a fuel line fitting by company maintenance personnel, which resulted in a fuel leak and subsequent in-flight engine compartment fire during cruise flight that was discovered during the landing roll.NTSB ANC05LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Homer, AKThe flight instructor's inadequate supervision of the flight during the landing roll, which resulted in a loss of control, and collision with a ditch. A factor associated with the accident was the student pilot's failure to maintain directional control.NTSB SEA05FA097Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Lowell, IDThe number four exhaust valve sticking in the open position during cruise flight. Factors include the pilot's failure to have an Airframe and Powerplant mechanic look at the engine after it had run rough immediately after start-up prior to this and a number…NTSB NYC05CA080Accident · No injuriesData collectionFinal reportPalen Sopwith Camel · Rhinebeck, NYThe pilot's failure to maintain aircraft control during the takeoff roll. A factor in the accident was the uneven runway, and the pilot's lack of total experience in make and model.NTSB LAX05LA162Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Del Mar, CAThe pilot's failure to arrest the high rate of descent and an inadequate bounced landing recovery technique. a factor in the accident was the rough, uneven terrain.NTSB LAX05CA161Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus 2b · Peoria, AZthe glider pilot encountered a downdraft that forced him to land in rough terrain.NTSB DFW05LA117Accident · No injuriesLimited investigationFinal reportRockwell International NA-265-80 · Brownwood, TXThe loss of engine power due to damage to the first stage compressor by a foreign object (bird).NTSB ATL05FA079Accident · 2 fatalField investigationFinal reportNorth American SNJ-6 · Kissimmee, FLThe failure of the outboard right-wing lower attachment bracket due to fatigue cracking and the subsequent in-flight separation of the right wing assembly.NTSB SEA05WA095Accident · 4 fatalForeign investigationCessna 207 · Tanauan City, PhilippinesNTSB MIA05WA101Accident · 6 fatalForeign investigationPiper PA-31-350 · Cordoba, ArgentinaNTSB LAX05LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Willows, CAthe loss of engine power due to the fractured piston pin boss on the number 5 cylinder.NTSB LAX05LA163Accident · Serious injuriesLimited investigationFinal reportCessna 140 · New Cuyama, CAthe pilot's failure to properly use carburetor heat during conditions conducive to carburetor icing, which resulted in the loss of engine power. A factor in the accident was the unsuitable landing terrain.NTSB IAD05LA061Accident · Serious injuriesLimited investigationFinal reportSchneidhorst Slingshot · Lima, OHThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall. A factor to the accident was the overheating of the powerplant which resulted in a partial loss of engine power.NTSB CHI05LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Buffalo Grove, ILA loss of engine power due to fuel exhaustion during approach, inadequate preflight planning/preparation by the certified flight instruction (CFI), and the unsuitable terrain encountered by the CFI during the forced landing. An additional cause was the…NTSB MIA05CA100Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Fort Pierce, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. A contributing factor in the accident was the pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply was available for the intended flight.NTSB LAX05LA160Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot-in-command's failure to properly lean the mixture, 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 condition while departing during high density…NTSB LAX05LA159Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Tucson, AZa loss of engine power due to the fatigue fracture and separation of the mixture control cable. The fatigue crack resulted from inadequate installation techniques by unknown maintenance personnel.NTSB LAX05LA158Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · San Luis Obispo, CAa loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB ANC05LA073Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Palmer, AKThe pilot's misjudged distance and speed, which resulted in an overrun during the landing roll, and subsequent nose over. Factors contributing to the accident were a tailwind and a short landing area.NTSB ANC05LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain control of the airplane, which resulted in a nose over during the landing roll. A factor contributing to the accident was uneven terrain.NTSB NYC05CA077Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Portland, MEA loss of engine power due to the pilot's improper decision not to land and refuel resulting in fuel exhaustion.NTSB LAX05CA157Accident · No injuriesData collectionFinal reportCessna 182R · Camarillo, CAthe pilot's failure to maintain directional control during a touch-and-go landing. A contributing factor was the wet dirt at the runway edge.NTSB ATL05LA078Accident · 1 fatalLimited investigationFinal reportEarnest Jodel D-9 · Memphis, TNThe pilot's misjudgment of distance/altitude, and his failure to maintain adequate airspeed resulting in a stall and subsequent undershoot.NTSB SEA05LA094Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, IDThe pilot's failure to maintain directional control during the landing roll. An inadvertent ground loop was a factor.NTSB LAX05LA151Accident · 1 fatalLimited investigationFinal reportGulfstream 695A · North Las Vegas, NVThe incapacitation of the pilot.