NTSB investigations, 2001
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CHI01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Morris, ILthe directional control not maintained by the pilot. The crosswind was a contributing factor.NTSB CHI01LA173Accident · No injuriesLimited investigationFinal reportCessna 172S · Cambridge, NEthe pilot's high airspeed and improper emergency procedures during the emergency landing. Factors relating to this accident were the fractured engine exhaust valve push rod, the bent intake valve push rod, and oil exhaustion during cruise flight, the…NTSB CHI01LA172Accident · Serious injuriesLimited investigationFinal reportShanklin RV-6A · Poseyville, INthe premature flare by the pilot.NTSB CHI01LA168Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · HIghland, ILThe pilot's failure to extend the spoilers during landing approach, which resulted in a touchdown at a higher than normal airspeed. An additional cause was the intentional ground loop/swerve maneuver performed by the pilot to avoid overrunning the end of the…NTSB CHI01LA167Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 Twin Otter · Ottawa, ILthe failure of the passenger to maintain clearance from the windmilling propeller after exiting the airplane.NTSB CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.NTSB CHI01FA180Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 · La Crosse, WIThe fatigue failure of the aircraft's left wing tip fuel tank rear attachment, while the aircraft was being maneuvered in a low approach, leading to the tank's in-flight separation and subsequent in-flight break up of the airplane and the aircraft's control…NTSB CHI01FA169Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Springfield, MOthe lack of experience in the type of airplane and directional control not maintained by the pilot. The improper flare and parked airplane were contributing factors.NTSB ANC01LA101Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Homer, AKThe student pilot's inadvertent ground loop. A factor in the accident was the pilot's lack of total experience.NTSB ANC01LA069Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's inadequate bounced landing recovery, and his failure to correct for torque/P-factor during an aborted landing.NTSB NYC01FA145Accident · 2 fatalField investigationFinal reportAeronca 7DC · Fulton, KYThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin to the ground. A factor was the pilot's decision to fly from the rear seat, which reduced his visibility of critical flight instruments, including the…NTSB MIA01FA163Accident · 1 fatalField investigationFinal reportCessna 172RG · Waveland, MSThe incapacitation of the pilot (cardiovascular) resulting in his inability to fly the airplane and subsequent in-flight collision with trees then a house.NTSB LAX01LA209Accident · No injuriesLimited investigationFinal reportCessna 170B · Payson, AZThe pilot's failure to maintain directional control and improper corrective action while landing in a quartering tailwind condition. A contributing factor was his lack of experience in the type of operation.NTSB LAX01FA208Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Lanai City, HIthe CFI's inadequate in-flight planning/decision making, inadequate supervision, and his delayed remedial action, which resulted in controlled flight into terrain.NTSB IAD01LA069Accident · Serious injuriesLimited investigationFinal reportBucker Jungmann C.A.S.A. 1.131 · Plymouth, MAThe pilot's failure to maintain altitude during an approach and inadequate visual lookout, which resulted in a collision with a runway sign.NTSB FTW01LA144Accident · No injuriesLimited investigationFinal reportCessna 182A · Baytown, TXThe unqualified person's failure to maintain clearance with the power lines while maneuvering. A factor was the dark night light conditions.NTSB ENG01RA008Incident · No injuriesForeign investigationDornier 228-101 · Pokhara, NepalNTSB CHI01FA165Accident · Serious injuriesField investigationFinal reportVanderBeek Christen Eagle II · Plainfield, ILthe improper in-flight planning/decision and the aircraft control not maintained by the pilot. The thunderstorm outflow was a contributing factor.NTSB ANC01LA068Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Seward, AKThe pilot's inadequate compensation for crosswind conditions during taxi from landing. A factor in the accident was a crosswind.NTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.NTSB NYC01LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150J · West Mifflin, PAThe pilot's failure to maintain airspeed while picking up a banner, and subsequent delay in releasing the banner, resulting in a stall/mush.NTSB NYC01LA144Accident · Minor injuriesLimited investigationFinal reportEurocopter France AS-350-BA · Hopewell, NJthe pilot's improper decision to continue flight in instrument meteorological conditions, and which resulted in an in-flight collision with trees. Factors were the fog, and dark night conditions.NTSB MIA01LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Venice, FLan on ground fire that started in the engine due to an excessive fuel flow causing the engine to flood. A factor in this accident was the pilot-in-command did not follow all the emergency procedures for an engine fire during start.NTSB MIA01LA168Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Key West, FLThe improper installation of the cylinders by other maintenance personnel for failure to assure that the cylinders were properly torqued resulting in fatigue crack in the crankshaft, and crankshaft failure. A finding in the investigation was fretting of both…NTSB MIA01FA162Accident · 1 fatalField investigationFinal reportBeech C90 · Fort Lauderdale, FLthe pilot's failure to properly plan fuel consumption and to perform an en route refueling, resulting in a total loss of engine power due to fuel exhaustion while on downwind leg for landing at eventual destination, causing an emergency descent and collision…NTSB LAX01FA207Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Stockton, CAa loss of engine power for undetermined reasons. Also causal was the inadequate supervision of the flight by the CFI for allowing a simulated emergency maneuver to continue below an altitude which would not allow for recovery contingencies.NTSB FTW01LA143Accident · Minor injuriesLimited investigationFinal reportCommander 114-B · Okmulgee, OKthe failure of the #6 cylinder's connecting rod, which resulted in a complete loss of engine power. A contributing factor to the accident was the lack of suitable terrain for the forced landing.NTSB FTW01LA142Accident · No injuriesLimited investigationFinal reportCessna 340A · Lancaster, TXA loss of engine power for undetermined reasons. Contributing to the accident was the collapse of the landing gear for undetermined reasons.NTSB CHI01LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Green Bay, WIThe pilot not performing the pre-landing checklist, and the wheels-up landing made by the pilot.NTSB CHI01LA174Accident · No injuriesLimited investigationFinal reportSmith Aerostar 600 · Wonewoc, WIThe deer on the runway as the airplane was landing.NTSB SEA01LA178Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Glide, ORInadequate compensation for wind conditions during takeoff resulting in the pilot's failure to maintain directional control. Wind gusts, down sloping terrain and a fence post were factors.NTSB DEN01LA116Accident · Serious injuriesLimited investigationFinal reportCameron Balloons N-210 · Rio Rancho, NMthe pilot's inadvertent weather encounter with wind shear, and the resulting inability to maintain the proper landing descent rate, which resulted in a hard landing. A factor was the high wind weather condition.NTSB MIA01LA161Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennettsville, SCThe pilot's improper correction for wind conditions and his failure to maintain control of the airplane resulting in the airplane sliding off an embankment during taxi from landing.NTSB MIA01LA160Accident · No injuriesLimited investigationFinal reportCessna 182S · Corolla, NCThe pilots failure to maintain directional control during landing flare and touchdown resulting in the airplane touching down on the left side of the runway and the left wing contacting trees.NTSB FTW01LA145Accident · No injuriesLimited investigationFinal reportCessna 172S · Baton Rouge, LAthe student pilot's improper recovery from a bounced landing.NTSB FTW01LA141Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvell, ARthe improper decision of the driver of the vehicle(ATV) to enter an active airstrip.NTSB CHI01MA163Accident · Serious injuriesMajor investigationFinal reportLearjet 25D · Salina, KSThe PIC's delayed remedial action during the elevator system oscillation, resulting in the failure of the aft elevator sector clevis due to reverse bending fatigue caused by vibration, and subsequent loss of elevator control. Factors contributing to the…NTSB CHI01LA162Accident · No injuriesLimited investigationFinal reportGiackino Exec 162F · Manistique, MIThe contamination of the main rotor drive belts causing them to slip. Factors were the low altitude, unsuitable terrain for the forced landing, and the water.NTSB SEA01LA118Accident · No injuriesLimited investigationFinal reportHughes 369D · Canby, ORFuel starvation as a result of a collapsed fuel nozzle filter screen. Contamination that blocked the fuel nozzle screen and water contamination were factors.NTSB SEA01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Billings, MTThe pilot-in-command's failure to maintain directional control of the aircraft during the landing roll. A contributing factor was the gusty crosswind conditions.NTSB NYC01LA142Accident · Minor injuriesLimited investigationFinal reportCessna 170A · South Charlesto, WVThe pilot's failure to maintain directional control while landing.NTSB NYC01FA141Accident · 3 fatalField investigationFinal reportCessna P210N · Honesdale, PAAn improperly manufactured torquemeter gearshaft assembly, which resulted in gearshaft assembly failure, an N2 overspeed, and a subsequent uncontained engine failure.NTSB MIA01LA159Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Dahlonega, GAThe failure of the No. 3 exhaust valve due to fatigue cracking for undetermined reasons, which resulted in a partial loss of engine power and an in-flight collision with a building during an attempted forced landing to unsuitable terrain..NTSB FTW01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Magnolia, TXthe pilot's failure to maintain clearance over the wires while on final approach.NTSB CHI01LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · West Fargo, NDthe pilot's inadequate preflight planning and the unsuitable landing area selected by the pilot. Additional factors were the uneven terrain and the failed float assembly in overload.NTSB CHI01LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Raymore, MOThe pilot failed to see and avoid the guy wires associated with a lighted tower. A factor associated with the accident was the guy wire.NTSB SEA01LA116Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Custer, WAThe first pilot's failure to maintain aircraft control while maneuvering. Factors include an inadvertent stall.NTSB NYC01LA143Accident · No injuriesLimited investigationFinal reportYakovlev 52 · Fredericksburg, VAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun.NTSB DEN01FA113Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-20 · Cerrillos, NMthe pilot's loss of aircraft control inflight for reasons undetermined. Contributing factors were the pilot's inadequate transition/upgrade training and his total lack of experience in aircraft make/model.NTSB CHI01LA157Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Milltown, WIThe stall/mush encountered by the pilot during that takeoff. Factors were the pilot's excessive lowering of the flaps during the takeoff and the trees.