NTSB investigations, 2001
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2001 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") = 2001 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 MIA01LA233Accident · No injuriesLimited investigationFinal reportBeech A45 · Eatonton, GAThe inadvertent sliding of the airplane on tall grass when the pilot aborted takeoff and the swerved the airplane to the left of the runway to avoid deer which had walked onto the runway, resulting in the airplanes left wing contacting a tree.NTSB IAD01LA108Accident · No injuriesLimited investigationFinal reportVon Claparede Clemen Preceptor-Ultra · Dublin, VAThe pilot's failure to maintain sufficient altitude/clearance, which resulted in the airplane's collision with terrain. A factor was the downdraft.NTSB FTW01LA213Accident · Serious injuriesLimited investigationFinal reportCameron Balloon N-77 · McKinney, TXthe pilot's failure to maintain clearance with the fence while landing. A contributing factor was the high wind condition.NTSB DEN01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Deming, NMthe pilot's failure to maintain aircraft control during takeoff roll. A contributing factor was the gusting crosswind weather condition.NTSB CHI01LA332Accident · Serious injuriesLimited investigationFinal reportAviaStrottel AC 4C · Marshfield, MIThe pilot's decision to release from the tow plane during the takeoff. A factor associated with the accident was the pilot's vision was restricted by his hat during the takeoff.NTSB CHI01FA329Accident · 3 fatalField investigationFinal reportCessna 414 Riley Super-8 · Marshfield, WIThe pilot's failure to maintain adequate airspeed (Vmc) which resulted in a loss of control. Contributing factors were the improper in-flight planning/decision not to land at a closer airport and the lack of recent experience in multiengine airplanes by the…NTSB NYC01LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Wildwood, NJthe pilot's inadequate compensation for wind conditions. Factors were the crosswind and the gusts.NTSB FTW01LA211Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL M18B · Plainview, TXthe pilot's failure to maintain clearance from the stand pipe while maneuvering during aerial application.NTSB CHI01LA333Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Duluth, MNThe pilots failure to maintain directional control during the landing. Factors were the crosswind and the soft terrain.NTSB ANC01LA150Accident · No injuriesLimited investigationFinal reportSlepcev Storch SS-MK4 · Anchorage, AKThe pilot's failure to maintain directional control and an inadvertent ground loop/swerve during the landing roll.NTSB MIA01LA231Accident · No injuriesLimited investigationFinal reportBell OH-58A · Sevierville, TNThe failure of the pilot to maintain control of the helicopter while approach to land resulting in a hard landing, a tail rotor ground strike, and the main rotor striking the tail boom.NTSB FTW01LA210Accident · No injuriesLimited investigationFinal reportCessna T188C · Aiken, TXthe application of silicon sealant to the crankcase mating surfaces by maintenance personnel, which resulted in improper torque on the bolts which mate the crankcase halves, vibration, and the subsequent failure of the #2 main crankshaft bearing. A factor was…NTSB DEN01LA164Accident · No injuriesLimited investigationFinal reportCessna 172RG · Englewood, COthe failure of the dual student to verify that the landing gear was down and locked, and the failure of the flight instructor to adequately supervise the dual student.NTSB DEN01LA163Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Parowan, UTthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush into terrain. Contributing factors were the pilot's diverted attention, the rising terrain, and the high density altitude weather condition.NTSB CHI01LA327Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Park Rapids, MNThe pilot not maintaining altitude/clearance when he maneuvered above the glassy lake. A factor to the accident was the glassy lake condition.NTSB CHI01LA326Accident · No injuriesLimited investigationFinal reportCessna 208 · Aurora, MNThe pilot not maintaining the proper descent rate during the landing. Factors were the flap's popped circuit breaker, the pilot not verifying the flap's position, the glassy water, and the dock.NTSB CHI01LA325Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Grand Haven, MIAircraft control not maintained by the pilot.NTSB SEA01LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDThe pilot's inadequate compensation for wind conditions. A factor was variable winds.NTSB FTW01LA214Accident · No injuriesLimited investigationFinal reportBell 206L-1 · W Cameron 168the failure of the rotor tachometer generator, which resulted in a precautionary landing in the Gulf of Mexico. A contributing factor to the accident was the rough water condition.NTSB CHI01LA330Accident · No injuriesLimited investigationFinal reportColonial C-2 · Faribault, MNThe failure of the landing gear shock strut.NTSB CHI01LA324Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · East Troy, WIThe inadvertent dynamic rollover the student pilot encountered following his excessive control inputs during the takeoff portion of the instructional flight and the instructor not performing the remedial action necessary to reduce the excessive control inputs…NTSB ANC01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Skwentna, AKA loss of engine power due to an undetermined reason.NTSB ANC01LA146Accident · Minor injuriesLimited investigationFinal reportDouglas DC-6B · Nuiqsut, AKThe flightcrew's continued use of an unstabilized GPS approach. Factors associated with the accident were low ceilings, and the inadequate coordination between the crew.NTSB SEA01LA173Accident · 1 fatalLimited investigationFinal reportKaman HH-43 · Bonners Ferry, IDThe pilot's inadequate visual lookout which lead to his failure to maintain clearance from the nearby trees while in a high-hover. Factors include mountainous/hilly terrain, and tall trees in the area where the helicopter was hovering.NTSB IAD01LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Medina, OHfatigue failure of the dual magneto mounting flanges that resulted from undetected contact damage sustained during a previous installation, which resulted in its separation from the engine during take-off.NTSB CHI01LA323Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Clear Lake, MNThe pilot not maintaining directional control of the airplane during the takeoff. A factor was the soybean crop.NTSB DEN01FA162Accident · 1 fatalField investigationFinal reportCessna 337B · St. George, UTtotal loss of engine power on both engines due to fuel starvation and the pilot's inability to access the available fuel supply. Contributing factors were the pilot's inadequate supervision of the refueling operation, and his intentional operation of the…NTSB DEN01FA161Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Pagosa Springs, COthe flight crews' intentional low altitude flight, and failure to maintain obstacle clearance.NTSB DCA01WA061Incident · No injuriesForeign investigationDouglas DC-8 · Mexico City, MexicoNTSB CHI01LA331Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Indianapolis, INthe inadequate crew/group coordination and the parking brakes not set by the pilot in command.NTSB ANC01LA147Accident · No injuriesLimited investigationFinal reportCessna 206 · Galena, AKThe pilot's inadequate preflight planning and preparation for takeoff from an off-airport, short field site. Factors associated with the accident are a variable wind, and the pilot's inadequate weather evaluation.NTSB NYC01LA229Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Rhinebeck, NYA partial power loss for undetermined reasons.NTSB LAX01LA305Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAA hard landing due to the dual student's failure to maintain main rotor speed, his improper landing flare, and the flight control interference by the flight instructor.NTSB LAX01LA304Accident · 1 fatalLimited investigationFinal reportAerospatiale AS350BA · Chico, CAthe pilot's inadequate in-flight decision and delay in initiating a go-around during an encounter with brown out conditions, which led to his failure to maintain alignment of the helicopter with the intended go-around flight path and a resulting collision…NTSB IAD01LA106Accident · Serious injuriesLimited investigationFinal reportDigimas Starduster Too · Watertown, CTthe student pilot's inattention while maneuvering at low altitude, which resulted in collision with trees. A factor in the accident was the student pilot's intentional low-altitude maneuvering.NTSB CHI01LA328Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Lebanon, INThe unsuitable terrain for landing encountered by the pilot. Factors were the carburetor icing conditions, the carburetor ice, and the bean crop.NTSB CHI01LA322Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Petoskey, MIThe pilot's inadequate preflight planning, the pilot's improper in-flight decisions, and the unsuitable terrain for landing. A factor relating to this accident was fuel exhaustion.NTSB CHI01LA321Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Carbondale, ILThe pilot misjudged the proper alignment with the landing area. Contributing to the accident was the light conditions.NTSB ANC01LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · North Pole, AKA loss of engine power, due to contaminated fuel, during approach for landing. A factor associated with the accident was unsuitable terrain.NTSB NYC01LA230Accident · No injuriesLimited investigationFinal reportCarver RAF 2000 GTX SE · Barre, VTThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident were wind gusts.NTSB NYC01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kenton, OHThe pilot's failure to stop the airplane within the available runway. Factors included the uneven braking and the pilot's lack of experience in airplane make and model.NTSB LAX01LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Skull Valley, AZthe loss of engine power during takeoff for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing emergency landing.NTSB ANC01LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tanana, AKAn unlocked landing gear mechanism during landing roll. A factor associated with the accident was an electrical system failure.NTSB ANC01LA144Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Mentasta, AKThe pilot's inadequate compensation for wind conditions while landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing, and a variable wind.NTSB ANC01LA143Accident · No injuriesLimited investigationFinal reportCessna U206 · Paxson, AKThe pilot's failure to maintain clearance from a sign while taxiing after landing in mixed rain and snow. Factors associated with the accident are reduced visibility conditions due to the snow and rain.NTSB FTW01LA208Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Waco, TXthe mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent engine failure during takeoff climb. A contributing factor was the lack of…NTSB ANC01LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot's inadequate evaluation of the wind conditions. A factor in the accident was the presence of a tailwind.NTSB FTW01LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eagle Lake, TXthe partial loss of engine power for an undetermined reason, which resulted in an in flight collision with trees and terrain.NTSB FTW01LA207Accident · No injuriesLimited investigationFinal reportAyres S2R-T11 · Spur, TXthe loss of engine power while in cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA318Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-20 · St. Bonifacius, MNImproper servicing of the airplane by other maintenance personnel, inadequate inspection of the airplane by the other maintenance personnel prior to the airplane's flight, and the unsuitable terrain encountered during the forced landing. Factors relating to…