NTSB investigations, 2001
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI01LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Saint Cloud, MNThe inadvertent wheels-up landing by the pilot. A factor was the pilots failure to follow the before landing checklist.NTSB CHI01FA117Accident · 1 fatalField investigationFinal reportBeech F35 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed which resulted in a stall. The low altitude was a contributing factor.NTSB ATL01LA049Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Jacksonville, FLThe flight dispatcher failure to provide the flight crew with current in-flight turbulence information that resulted in the in-flight encounter with turbulence during climb. A factor was the pilots failure to obtain adequate weather information.NTSB ANC01TA047Accident · Minor injuriesFinal reportCessna 207 · Mtn. Village, AKThe pilot's continued VFR flight into instrument meteorological conditions while maneuvering. Factors in the accident were low ceilings, snow showers, whiteout conditions, and snow-covered terrain.NTSB SEA01LA072Accident · Minor injuriesLimited investigationFinal reportMaule M-4-210C · Bonners Ferry, IDInadequate preflight inspection/preparation of the aircraft by the pilot and consequent foreign object fouling of the rudder control, rendering directional control impossible. A factor was the pilot's distraction/preoccupation with personal problems.NTSB MIA01LA123Accident · No injuriesLimited investigationFinal reportCessna A185F · Fayetteville, NCThe pilot's failure to maintain directional control of the airplane after encounter wind gusts during landing roll resulting in the airplane ground looping to the left and the right wing, right horizontal stabilizer, and right elevator contacting the runway…NTSB ANC01LA082Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Talkeetna, AKThe instructor pilot's lack of adequate supervision of the training flight, and subsequent loss of directional control during the landing roll out. Factors on the accident were the lack of brake pedals installed on the right pilot position of the airplane,…NTSB SEA01LA071Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Gig Harbor, WAThe pilot's failure to extend the airplane's landing gear while landing.NTSB NYC01LA101Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kent, OHThe flight instructor's inadequate supervision during the landing. Factors were the improper use of the flight controls by the pilot/owner, the crosswind, and the muddy terrain.NTSB MIA01LA122Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Dade City, FLthe pilot's inadequate recovery from a bounced landing, and loss of directional control which resulted in an in-flight collision with a fence during the go-around, resulting in a subsequent forced landing in a pasture.NTSB LAX01LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Flagstaff, AZThe loss of engine power during cruise flight for undetermined reasons that resulted in a forced landing in rough terrain.NTSB LAX01LA146Accident · No injuriesLimited investigationFinal reportArthur Lee Beer ALB Special · Santa Rosa, CAThe failure of the pilot to maintain directional control during landing roll.NTSB LAX01FA144Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Williams, CAThe failure of the pilot to attach the elevator control rod to the elevator, resulting in a loss of pitch control and subsequent ground impact. Additional factors were the failure to complete a positive control check and the lack of clear guidance in the…NTSB IAD01LA043Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Painesville, OHThe pilot's failure to maintain the proper descent rate and the flight instructor's inadequate supervision.NTSB FTW01FA100Accident · 1 fatalField investigationFinal reportFairchild PT-19A · Midland, TXthe pilot's failure to maintain airspeed which resulted in an inadvertant stall during initial takeoff climb. A contributing factor was wind gusts.NTSB CHI01LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Grain Valley, MOThe normal brake system was inoperative due to undetermined reasons. A factor associated with the accident was the ditch that the airplane encountered.NTSB CHI01LA115Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180AC · Buffalo, MNthe water contamination of the aircraft's fuel system and the inadequate preflight performed by the pilot. The muddy terrain was a contributing factor.NTSB ANC01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Emmonak, AKThe pilot's inadvertent stall while maneuvering. A factor associated with the accident was soft, snow-covered terrain.NTSB NYC01WA100Accident · 4 fatalForeign investigationCessna 182 · Sulmona, ItalyNTSB NYC01LA125Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135LR · Cleveland, OHAn overload force being exerted on the nosewheel gear assembly for undetermined reason.NTSB NYC01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hagerstown, MDThe pilot's failure to maintain runway alignment during the landing phase. A factor in the accident was a sudden change in wind direction and speed.NTSB MIA01TA121Accident · Minor injuriesFinal reportBell OH-58C · Panama City, FLThe poor in-flight planning by the pilot for failure to maintain adequate airspeed while maneuvering to begin spray operations resulting in the loss of tail rotor effectiveness, subsequent in flight loss of control, and in flight collision with terrain.NTSB FTW01FA098Accident · 1 fatalField investigationFinal reportCessna 172E · Bay City, TXthe pilot's delay in taking remedial action (contacting ATC) after he became lost/disoriented during a night cross country flight, which resulted in a forced landing due to fuel exhaustion. Contributing factors to the accident were the pilot's failure to…NTSB DEN01LA086Accident · Minor injuriesLimited investigationFinal reportBellanca 1731A · Hobbs, NMthe pilot's failure to maintain directional control during flare/landing.NTSB CHI01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Culver, INthe CFI delayed remedial action during the takeoff. Additional factors were the wrong runway was selected, the tailwind, and the trees.NTSB FTW01LA099Accident · No injuriesLimited investigationFinal reportCessna 150L · Iowa Park, TXfuel exhaustion during takeoff due to the pilot's failure to refuel.NTSB SEA01FA070Accident · 2 fatalField investigationFinal reportCessna 182P · Fairfield, WAThe pilot's failure to maintain altitude and/or clearance over trees, resulting in a collision with trees, separation of a wing and uncontrolled collision with terrain. Factors included the pilot's inadequate preflight planning and preparation, dark night…NTSB LAX01FA145Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Sierra Vista, AZthe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in an in-flight collision with mountainous terrain. Factors in the accident included the adverse weather conditions and the dusk lighting conditions.NTSB IAD01WA049Accident · No injuriesForeign investigationRobinson R-22B · Weston, IrelandNTSB DEN01LA085Accident · Minor injuriesLimited investigationFinal reportBoyd Young Kolb Mark III · Brigham City, UTthe pilot's misjudged landing flare, which resulted in a hard landing. A factor was the propeller tip separation due to foreign object damage.NTSB SEA01WA097Accident · 4 fatalForeign investigationAero Commander 500S · Thornton Peak, AustraliaNTSB NYC01LA096Accident · Serious injuriesLimited investigationFinal reportDornier 328-100 · Springfield, VAAn inadvertent encounter with turbulence during descent.NTSB MIA01FA119Accident · 1 fatalField investigationFinal reportBeech A-45/T-34A · Claxton, GAThe pilot in command's failure to maintain airspeed while performing an emergency landing after having just taken off with an unsecured fuel cap, which resulted in an inadvertent stall mush, an uncontrolled descent, and an impact with trees.NTSB NYC01LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200ER · Boston, MAThe Boeing 767 captain's misjudgment of the distance between his airplane and the stationary Boeing 737, which resulted in a ground collision. A factor was sunglare.NTSB MIA01LA120Accident · 1 fatalLimited investigationFinal reportHenry Pelican · Lakeland, FLThe pilot's delay in aborting the takeoff in a downwind condition resulting in an overrun and subsequent collision with a ditch. Contributing to the accident was the pilot's failure to conduct performance planning for the flight.NTSB MIA01LA118Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLthe flight instructor's inadequate supervision and the dual student's improper use of brakes which resulted in the loss of directional control and collision with a wind sock. Contributing to the accident was the flight instructor's failure to follow…NTSB MIA01FA117Accident · 2 fatalField investigationFinal reportPiper PA-46-500TP · Vero Beach, FLThe pilot's excessive bank angle and his failure to maintain airspeed while returning to the airport after takeoff due to an unspecified problem resulting in the airplane stalling and colliding with trees during the resultant uncontrolled descent.NTSB LAX01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chino, CAThe pilot's failure to extend the landing gear. A factor was the pilot's failure to use the landing checklist.NTSB IAD01LA042Accident · No injuriesLimited investigationFinal reportCessna 172R · Lawrence, MAThe pilot's improper flare.NTSB NYC01LA098Accident · Minor injuriesLimited investigationFinal reportFobes CGS Hawk Plus · West Middlesex, PAThe partial loss of engine power, for undetermined reasons. Factors included the headwinds on base leg, and the unsuitable terrain for a forced landing.NTSB MIA01LA116Accident · No injuriesLimited investigationFinal reportCessna 170B · Penrose, NCfailure of the pilot to maintain directional control of the aircraft during the landing rollout while landing in a crosswind which resulted in a ground swerve and substantial damage to the aircraft.NTSB LAX01LA142Accident · Minor injuriesLimited investigationFinal reportSchweizer 2-33A · Peoria, AZThe glider's encounter with a dust devil during takeoff that resulted in a loss of control.NTSB IAD01LA041Accident · Minor injuriesLimited investigationFinal reportBell BH-206-B · Ringgold, VApilot's failure to properly control the helicopter during a slope landing, which resulted in a dynamic rollover.NTSB FTW01LA097Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roe, ARthe inadvertent stall by the pilot while maneuvering at low altitude. A contributory factor was the tailwind.NTSB DEN01LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Telluride, COthe pilot's failure to maintain control of the airplane during initial climb. Factors include the gusty wind and high density altitude conditions.NTSB DEN01FA082Accident · 2 fatalField investigationFinal reportSandell Zenith CH 200 · Canon City, COthe pilot in command inadvertently allowing the airplane to stall/spin. Contributing factors were the pilot's total lack of experience in airplane make/model, and high wind conditions.NTSB DCA01WA051Accident · No injuriesForeign investigationCessna Citation · Helsinki, FinlandNTSB CHI01LA114Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Gary, INThe inadequate preflight performed by the pilot which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. Factors associated with the accident were the inaccurate fuel quantity indicator, the rock which resulted in the overload failure…NTSB NYC01LA095Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Slanesville, WVa loose mixture control cable housing which resulted in an intermittent running engine, and the pilot's subsequent decision to perform a precautionary landing. A factor was the soft terrain.NTSB MIA01LA115Accident · Minor injuriesLimited investigationFinal reportJerome Wells KR-2 · Nashville, NCthe pilot's improper preflight inspection, which resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and and a forced landing to a field and damage to the aircraft during the forced landing.