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 LAX05FA229Accident · No injuriesField investigationFinal reportEurocopter AS350BA · Kapaau, HIthe in-flight separation of the tail rotor system as a result of a loss of clamp force and fatigue fracturing of the attachment nut plates. The cause of the loss of clamp force was likely due to an inadvertent tail rotor blade strike during the previous…NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.NTSB DFW05LA179Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance with terrain during aerial application.NTSB CHI05CA183Accident · Serious injuriesData collectionFinal reportRockwell S-2R · Guelph, NDThe pilot's failure to maintain clearance to the guy wire during the agricultural application pass. Contributing factors were the guy wire, and low altitude flight.NTSB IAD05LA101Accident · No injuriesLimited investigationFinal reportAeronca 65CA · Cadiz, OHCarburetor icing, which resulted in a partial loss of engine power. A factor was an unanticipated hill in the forced landing rollout area.NTSB DFW05LA180Accident · No injuriesLimited investigationFinal reportBell 430 · Gulf of MexicoThe helicopter's tail rotor blade's contact with an unknown object during landing.NTSB DCA05MA083Accident · Serious injuriesMajor investigationFinal reportBoeing 767-232 · Raleigh-Durham, NCAn inadvertent in-flight encounter with clear air turbulence.NTSB NYC05LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Elyria, OHA loss of engine power during initial climb, as reported by the pilot, for an undetermined reason which resulted in a collision with trees.NTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.NTSB IAD05CA100Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Altoona, PAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with a hangar.NTSB CHI05WA182Accident · 2 fatalForeign investigationWaco UPF-7 · Moose Jaw, CanadaNTSB ATL05FA128Accident · 1 fatalField investigationFinal reportCessna 172N · Penrose, NCA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to use the full length of the runway for takeoff, and the inadvertent stall.NTSB LAX05WA234Accident · 2 fatalForeign investigationRobinson R44 · Derrybrien, IrelandNTSB DEN05LA108Accident · No injuriesLimited investigationFinal reportGrob G103 · Moriarty, NMthe glider pilot's intentional tow release at too low an altitude when he erroneously perceived the tow plane was about to crash. A contributing factor was the unsuitable terrain on which to make a landing.NTSB DEN05LA106Accident · Serious injuriesLimited investigationFinal reportClarke YAK 3UR 2000 · Heber City, UTloss of engine power due to a leaking carburetor and an inoperative float, and the pilot's failure to maintain aircraft control during the restart attempt. Contributing factors were the sudden engine power surge during the attempted restart, and unsuitable…NTSB DEN05CA107Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Roosevelt, UTthe pilot's failure to maintain control of the aircraft during landing. A factor contributing to the accident was the crosswind.NTSB CHI05LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · La Gygne, KSThe failure of the throttle control cable which resulted from wear followed by fatigue cracking. A factor associated with the accident was the corn crop which the airplane contacted during the forced landing.NTSB CHI05LA177Accident · Serious injuriesLimited investigationFinal reportNorth American P-51D · Tarkio, MOA loss of engine power due to undetermined reasons and the unsuitable terrain encountered during the forced landing.NTSB ATL05LA126Accident · 1 fatalLimited investigationFinal reportEllsworth Sky Bolt · Cumming, GAThe pilot's improper fuel management while maneuvering resulting in a total loss of engine power due to fuel starvation.NTSB ATL05CA127Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Landrum, SCThe pilot's improper use of the flight controls (collective pitch and cylic controls) during a take off to a hover resulting in the helicopter encountering dynamic roll over and rolling over on its right side.NTSB ANC05CA099Accident · No injuriesData collectionFinal reportCessna 172 · Akiachak, AKThe pilot's delay in aborting the landing, which resulted in the airplane running off the end of the runway and nosing over. A factor associated with the accident was the rough/uneven terrain off the end of the runway.NTSB SEA05LA141Accident · No injuriesLimited investigationFinal reportCessna 206E · Stuart Island, WAThe pilot's excessive airspeed on final for the current runway surface conditions, and the intentional obstruction avoidance maneuver he executed when it became clear the aircraft was about to go off the end of the runway. Factors include the pilot's improper…NTSB MIA05WA137Accident · No injuriesForeign investigationMooney M20C · Albenga, ItalyNTSB LAX05WA228Accident · 3 fatalForeign investigationPiper PA-31-350 · Mount Hotham, AustraliaNTSB DEN05LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Rocky Ford, COthe pilot's misjudged distance/altitude. A contributing factor was the inadvertent flap retraction.NTSB CHI05LA179Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Chicago, ILThe pushback tow driver not maintaining visual lookout for the wing walker's visual signal, and the driver not maintaining clearance from the vehicle during the pushback for taxi. Factors to the accident were the standing vehicle behind the airplane, the…NTSB ANC05CA101Accident · No injuriesData collectionFinal reportHughes 500D · Ambler, AKThe pilot's failure to maintain clearance from an object while landing, which resulted in the main rotor blades striking a tree.NTSB NYC05LA116Accident · No injuriesLimited investigationFinal reportCessna 421B · Medina, OHAn overload failure of the left main landing gear attachment assembly.NTSB MIA05CA133Accident · Minor injuriesData collectionFinal reportRobinson R44 · St. Cloud, FLThe failure of the pilot to maintain clearance with a palm tree resulting in the in-flight collision with it, and subsequent uncontrolled descent and in-flight collision with the ground.NTSB LAX05TA226Accident · Minor injuriesFinal reportAyres S2R-G10 · Wickenburg, AZthe partial loss of engine power for undetermined reasons.NTSB CHI05LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Buxton, NDA loss of engine power on takeoff due to undetermined reasons. A factor was the ditch that the airplane contacted during the forced landing.NTSB ATL05CA125Accident · No injuriesData collectionFinal reportCessna 172P · Monroeville, ALThe student pilot's failure to maintain directional control and the subsequent collision with the ground during landing.NTSB ANC05LA097Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKA fracture failure of the main landing gear leg during the landing roll, which resulted in the collapse of the main landing gear.NTSB ANC05FA098Accident · 1 fatalField investigationFinal reportMaule M-7-235 · Seward, AKThe pilot's failure to maintain minimum airspeed during final approach, which resulted in an inadvertent stall, and impact with the surface of the lake.NTSB SEA05RA139Accident · 1 fatalForeign investigationErickson Air-Crane S-64F · Rome, ItalyNTSB NYC05CA115Accident · Minor injuriesData collectionFinal reportWagner Kitfox II · Albion, NYThe pilot's loss of airplane control after inadvertently taking off while conducting high-speed taxi runs. A factor related to the accident was the pilot's lack of experience in the airplane.NTSB DFW05FA178Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Norman, OKThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A contributing factor was the pilot's attempted aborted landing following a hard landing and propeller strike.NTSB ANC05TA106Accident · No injuriesFinal reportCessna 185 · Delta Junction, AKThe pilot's misjudged distance/altitude during the landing touchdown and subsequent undershoot, and his failure to maintain directional control of the airplane during the landing roll, which resulted in an on-ground encounter with high vegetation.NTSB ANC05CA096Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Hope, AKThe pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with trees and tundra-covered terrain. A factor in the accident was trees.NTSB SEA05LA138Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Oroville, WAThe failure of the throttle cable housing, which permitted the engine's RPM to decay to the idle position. Contributing factors were the trees and the lack of suitable terrain for a forced landing.NTSB MIA05IA132Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Titusville, FLThe pilot's continued operation of the airplane with known intermittent deficiencies of the electric pitch trim switch, resulting in a mis-trim condition of the airplane (nose-up), and subsequent hard landing on the nose landing gear causing it to collapse. A…NTSB IAD05LA096Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cape May, NJA partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.NTSB IAD05LA095Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Branchville, NJAn electrical fire of unknown origin. A factor in the accident was the pilot's failure to perform the In-Flight Electrical Fires checklist.NTSB IAD05LA094Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Conesus, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with terrain.NTSB DFW05CA157Accident · Serious injuriesData collectionFinal reportGrumman AA1B · Llano, TXThe partial loss of engine power for undetermined reasons during takeoff resulting in an overrun. A factor was the high density altitude.NTSB CHI05LA164Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bristol, SDThe pilot's failure to maintain clearance with the static lines between the transmission towers. A factor associated with the accident were the static lines.NTSB NYC05LA113Accident · Serious injuriesLimited investigationFinal reportMeyer Atlantis · Pittstown, NJThe pilot's failure to maintain clearance from power lines, while returning to the airport after takeoff.NTSB IAD05CA092Accident · No injuriesData collectionFinal reportCallahan Rotorway Exec 90 · Weston, WVA loss of engine power for undetermined reasons during an attempted power recovery. A factor in the accident was the pilot's failure to maintain rotor rpm, which resulted in a hard landing and subsequent post crash fire.NTSB ENG05RA021Incident · No injuriesForeign investigationBoeing 747-200B · Sapporo, JapanNTSB CHI05LA163Accident · 1 fatalLimited investigationFinal reportBecker RAF 2000 · Gladwin, MIThe pilot's failure to maintain control of the gyrocopter while in the traffic pattern. A factor associated with the accident was the pilot's lack of gyrocopter experience.