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 LAX05TA156Accident · No injuriesFinal reportSikorsky S-70A · Calabasas, CAfatigue of the forward keeper due to known flaws in the manufacturing process.NTSB IAD05CA059Accident · No injuriesData collectionFinal reportCessna 152 · Millville, NJThe pilot's misjudgment of the airplane's distance to the restaurant sundeck.NTSB DFW05CA121Accident · No injuriesData collectionFinal reportBell 206L-1 · Georgetown, TXThe pilot's improper flare resulting in a hard landing.NTSB CHI05LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Bismarck, NDRupture of the hydraulic powerpak drain line which resulted in a loss of hydraulic fluid and the inability to properly lower the landing gear despite the pilot's execution of the emergency extension procedures. A contributing factor was the runway light…NTSB SEA06WA060Accident · 2 fatalForeign investigationFairchild Swearingen SA227-AC · Stratford, New ZealandNTSB SEA05FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Kalispell, MTLoss of aircraft control during climb while in instrument meteorological conditions. Icing conditions was a factor.NTSB SEA05CA093Accident · No injuriesData collectionFinal reportJohnson Johnson Chris-Tena · Lebanon, ORThe loss of engine power on takeoff for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA05CA121Accident · No injuriesData collectionFinal reportCessna 172SP · Clearwater, FLThe pilot's improper flare and recovery from a bounced landing.NTSB LAX05LA155Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Peach Springs, AZa loss of power for undetermined reasons.NTSB DFW05LA115Accident · No injuriesLimited investigationFinal reportLancair Legacy · Nacogdoches, TXThe loss of engine power for undetermined reasons.NTSB SEA05FA090Accident · 1 fatalField investigationFinal reportCessna 170B · Portland, ORThe pilot's inability to control the airplane due to his incapacitation (carbon monoxide poisoning) from a deteriorated engine exhaust muffler. A contributing factor was the inadequate annual inspection by other maintenance personnel.NTSB NYC05CA079Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's inadequate recovery from a bounced landing. A factor was the crosswind.NTSB MIA05WA102Accident · Minor injuriesForeign investigationCessna TU206F · Tela, HondurasNTSB LAX05LA154Accident · No injuriesLimited investigationFinal reportKittleson Quickie Q-200 · Santa Barbara, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB LAX05CA153Accident · Minor injuriesData collectionFinal reportAerotek Pitts S-2A · Tracy, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control, which resulted in a ground loop and nose over.NTSB ENG05RA011Incident · No injuriesForeign investigationBritish Aerospace BAE-146-200 · Verona, ItalyimportNTSB DFW05LA116Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fenton, LAThe loss of engine power due to fuel starvation as a result of blockage of the firewall fuel filter with an unknown contaminant. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC05FA070Accident · 1 fatalField investigationFinal reportTaylorcraft F-19 · Fairbanks, AKThe pilot's failure to maintain a minimum airspeed during a low-altitude turn to return to the airport, and his improper in-flight decision to initiate a steep, low altitude turn, which resulted in an inadvertent stall/spin, and an in-flight collision with…NTSB NYC05LA087Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Clay Center, OHThe loss of engine power for undetermined reasons.NTSB NYC05CA078Accident · No injuriesData collectionFinal reportCessna 150F · China, METhe pilot's improper inflight decision to land in a field instead of a nearby airport, after encountering deteriorating weather conditions. A factor was the deteriorating weather conditions.NTSB LAX05LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Yuba City, CAa partial loss of engine power due to multiple cracks in the number 7 cylinder. The reasons for the cracks were not determinedNTSB IAD05WA149Accident · No injuriesForeign investigationCessna 206 · Klagenfurt, AustriaNTSB DFW05WA114Accident · 1 fatalForeign investigationBell 407 · La Primavera, MexicoNTSB ATL05CA077Accident · No injuriesData collectionFinal reportBell 206L 1 · Cherokee, NCThe pilot's improper use of the helicopter flight controls during a hover that resulted in a dynamic rollover.NTSB ANC05CA067Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing roll, and a collision with willows and a creek bank. A factor associated with the accident was the soft landing area.NTSB DFW05LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Houston, TXA loss of engine power due to the pilot's inadequate preflight planning/preparation in detecting contaminated fuel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA112Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Little Rock, ARAn encounter with moderate turbulence during cruise flight.NTSB SEA05WA102Accident · Minor injuriesForeign investigationKaman K-1200 · Korea, South KoreaNTSB SEA05LA089Accident · No injuriesLimited investigationFinal reportAeronca 0-58B · Kennewick, WALoss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over. A factor was the unsuitable terrain.NTSB MIA05CA099Accident · No injuriesData collectionFinal reportPiper PA32-301 · Brooksville, FLThe pilot-in-command failure to maintain directional control during takeoff after landing, which resulted in the airplane exiting the runway.NTSB DFW05FA111Accident · 2 fatalField investigationFinal reportCessna 172 · Midland, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the low altitude.NTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.NTSB ANC05LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Wasilla, AKThe pilot's selection of an unsuitable landing area, which resulted in a loss of control during the landing roll, and a collision with a ditch. A factor associated with the airplane was a leaking brake assembly and diminished braking efficiency.NTSB ANC05LA063Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKA total loss of engine power during descent due to a loose mixture control linkage, and the pilot/owner's failure to maintain the airplane's annual inspection schedule, which resulted in a forced landing in an area that contained power lines and trees.NTSB ANC05IA064Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Anchorage, AKThe inadequate installation of the cockpit security door locking device, which resulted in smoke in the cockpit during normal cruise, and a precautionary landing. A factor associated with the incident was the manufacturer's insufficiently defined installation…NTSB SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.NTSB NYC05CA076Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Indian Head, MDThe pilot's failure to maintain adequate altitude/clearance while on final approach, which resulted in an in-flight collision with trees. A factor in this accident was the gusty wind conditions.NTSB LAX05LA149Accident · 2 fatalLimited investigationFinal reportSchlitter Randy J Rans S6ES Coyote II · Tombstone, AZloss of engine power for undetermined reasons and the flying pilot's failure to maintain an adequate airspeed that resulted in a stall and uncontrolled descent into terrain.NTSB LAX05CA148Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe student's failure to maintain directional control and the CFI's failure to adequately supervise the flight.NTSB IAD05TA058Accident · Minor injuriesFinal reportHughes 369FF · Quantico, VAThe flight crew's failure to maintain adequate altitude/clearance from a building, which resulted in contact with the building, dynamic rollover, and collision with terrain.NTSB DFW05CA109Accident · No injuriesData collectionFinal reportRobinson R22 · Bandera, TXThe pilot's loss of control while hovering after encountering settling with power.NTSB CHI05CA107Accident · No injuriesData collectionFinal reportWhittman Tailwind · Lyndon, KSThe pilot improper recovery from a bounced landing, and his inadequate compensation for a tailwind, which resulted in a loss of control and subsequent collision with the ground. Contributing to the accident was the pilot's selection of a wrong runway, the…NTSB ANC05CA069Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from a sign while taxiing from landing, which resulted in an on ground collision with the sign.NTSB ANC05CA066Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground encounter with terrain during the landing roll, and subsequent nose down of the airplane. A factor associated with the accident was soft terrain.NTSB ENG05WA009Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Buenos Aires, ArgentinaNTSB DFW05LA110Accident · Minor injuriesLimited investigationFinal reportFriddle Super Cub Replica · Springtown, TXThe pilot's failure to compensate for wind conditions and his failure to maintain aircraft control during a go-around, which resulted in collision with trees.NTSB CHI05FA180Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lake Michigan, WIThe pilot's inaccurate preflight planning and his delayed en route decision to make a fuel stop, which resulted in the loss of engine power due to fuel exhaustion and subsequent ditching.NTSB ATL05LA075Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-26AT · Lawrenceville, GAThe pilot's improper landing flare that resulted in a hard landing.NTSB SEA05CA086Accident · No injuriesData collectionFinal reportWilliams Helicopter UH-1B · Uniontown, WAThe pilot's failure to maintain clearance from an object while maneuvering, which resulted in the main rotor blades striking a power pole. The power pole was a factor in the accident.NTSB MIA05LA098Accident · Serious injuriesLimited investigationFinal reportGordon E. Brown Nieuport C-1 · Homestead, FLThe reported loss of engine power for undetermined reasons on the downwind leg which resulted in a forced landing, and subsequent in-flight collision with a guy-wire and terrain.