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 NYC01LA156Accident · No injuriesLimited investigationFinal reportPiper J3F-65 · Findlay, OHTwo chafed ignition switch leads, which resulted in a failure of the ignition system and subsequent total loss of engine power.NTSB LAX01LA227Accident · No injuriesLimited investigationFinal reportBell 206B · Salinas, CAthe student's improper use of the cyclic controls and his failure to relinquish aircraft control, and the flight instructor's inadequate supervision.NTSB LAX01LA224Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZThe pilot's improper use of the rudder control to correct for torque and P-factor effects, which resulted in a loss of directional control and an inadvertent ground loop/swerve.NTSB FTW01LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Gladewater, TXthe pilot's inadvertent visual flight into instrument meteorological conditions while maneuvering, which resulted in her spatial disorientation and subsequent loss of control of the airplane.NTSB ATL01LA069Accident · No injuriesLimited investigationFinal reportCessna 177 · Milledgeville, GAThe student pilot's failure to maintain directional control and the subsequent collision with an object during an attempted landing. A factor was porpoise induced oscillation.NTSB ANC01LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKFuel starvation due to the pilot's selection of an empty fuel tank during takeoff.NTSB SEA01LA123Accident · Minor injuriesLimited investigationFinal reportBreiter Aerosport Quail · Idaho Falls, IDThe pilot's failure to maintain an airspeed above stall velocity (Vs) during his attempt to stretch a reduced power forced landing glide. Factors include fuel starvation, a partial loss of power due to fuel contamination, and the pilots inadequate preflight…NTSB LAX01LA226Accident · No injuriesLimited investigationFinal reportMooney M20C · Tucson, AZThe airplane's collision with a perimeter roadway vehicular traffic sign due to the pilot's diverted attention and inadequate visual lookout while taxiing from landing. A contributing factor was the lack of sign conspicuity.NTSB LAX01LA225Accident · No injuriesLimited investigationFinal reportCessna U206D · Boulder City, NVthe pilot's inadequate compensation for the tailwind gust and subsequent failure to maintain directional control of the airplane while landing.NTSB FTW01LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Uvalde, TXThe pilot's failure to verify the landing gear was down and locked, which resulted in a wheels up landing and subsequent ground fire.NTSB FTW01LA156Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Sabinal, TXa loss of engine power due to a crack in the #9 cylinder, which result in the failure of the connecting rod during the aerial application flight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA01WA052Incident · No injuriesForeign investigationBoeing 757 · Copenhagen, DenmarkNTSB ANC01LA077Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Willow, AKA loss of engine power for an undetermined reason.NTSB SEA01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bozeman, MTThe pilot of another aircraft failed to maintain clearance while maneuvering for a formation flight. An updraft was a factor.NTSB LAX01LA228Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Meridian, CAThe pilot's misjudged and inadequate altitude while maneuvering during an aerial application flight.NTSB LAX01IA241Incident · No injuriesIncident investigationFinal reportBeech A36 · Bakersfield, CADuring landing approach, mechanical binding of the elevator control cable occurred due to a contract mechanic's improper maintenance.NTSB IAD01LA072Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Berlin, MDpilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB DEN01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bryce Canyon, UTthe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.NTSB CHI01LA189Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Hudson, MIUnsuitable terrain for landing encountered by the pilot during the forced landing attempt. Factors relating to this accident were fuel starvation caused by foreign material blocking the fuel tank lines which led to the engine failure, annual inspection…NTSB ANC01TA076Accident · No injuriesFinal reportBell 212 · Clear, AKThe pilot's selection of an unsuitable landing site following a partial loss of power during approach to landing in a multiengine helicopter. Factors associated with the accident are an automatic fuel control unit that had a restricted fuel flow due to an…NTSB SEA01LA121Accident · Minor injuriesLimited investigationFinal reportKaman HH-43B · Mullan, IDThe development of multiple fatigue cracks which ultimately resulted in the fracture of the 1st stage gas producer turbine rotor sealing disc. Factors contributing to the accident were mountainous/hilly and unsuitable terrain conditions.NTSB NYC01LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Watch Hill, RILoss of engine power for undetermined reason.NTSB NYC01LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rochester, NYFuel exhaustion, due to the student pilot's failure to monitor his fuel supply.NTSB LAX01LA223Accident · No injuriesLimited investigationFinal reportRudolph Venture · Grass Valley, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB FTW01LA155Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Paris, TXthe excessive pull up by the passenger along with the certified flight instructor's inadequate supervision leading to a loss of control during the takeoff initial climb.NTSB ANC01LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Soldotna, AKThe loss of engine power due to fuel exhaustion and the pilot's failure to refuel the airplane.NTSB ANC01GA075Accident · 1 fatalFinal reportPiper PA-18-150 · King Salmon, AKThe pilot's selection of the incorrect fuel tank, subsequent fuel starvation, and inadvertent stall during initial climb. Factors associated with the accident were inadequate transition training, and insufficient training standards of the operator/management.NTSB MIA01WA177Accident · 6 fatalForeign investigationCessna 206 · Baborigame, MexicoNTSB MIA01LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Tampa, FLThe pilot's failure to maintain a visual look out while taxing an airplane for parking resulting in an on ground collision with a fixed object (Hangar/Building.)NTSB MIA01LA171Accident · No injuriesLimited investigationFinal reportLockheed P-38L-5LD · Greenwood, MSthe failure and uncontained separation of supercharger impeller blades for undetermined reasons during normal descent, resulting in a punctured fuel line and the subsequent in-flight engine fire and emergency descent and forced landing to a farm field.NTSB LAX01LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Napa, CALoss of engine power due to the restricted movement of the number 1 exhaust valve that subsequently bent the exhaust push rod and push rod housing.NTSB LAX01LA219Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Paso Robles, CAthe pilot's failure to maintain rotor rpm during a practice autorotational landing, which resulted in a hard landing.NTSB LAX01FA222Accident · 1 fatalField investigationFinal reportBeech 35-B33 · Lakeside, CALoss of control in flight due to cardiovascular incapacitation.NTSB FTW01LA152Accident · 1 fatalLimited investigationFinal reportMottier RV-6 · Hammond, LAthe pilot's failure to maintain aircraft control following a loss of engine power. A factor was the loss of engine power during takeoff initial climb for undetermined reasons.NTSB ENG01RA003Incident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Guadalajara, MexicoNTSB CHI01LA203Accident · No injuriesLimited investigationFinal reportBellanca 14-13-3 · Pierce, NEThe improper management of the fuel system by the pilot. Factors were the fuel starvation, the pilot's lack of familiarity with the airplane, the berm, and the unsuitable terrain for landing encountered by the pilot.NTSB MIA01LA175Accident · 1 fatalLimited investigationFinal reportBucker-Jungmann Aero Z-131 · Rupert, GAThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB MIA01LA173Accident · No injuriesLimited investigationFinal reportBeech 77 · Rock Hill, SCThe poor weather evaluation by the pilot for landing with a tailwind and failure of the pilot to perform a go-around after the first bounced landing.NTSB MIA01LA172Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Garner, NCThe pilot's failure to maintain altitude clearance above the terrain while maneuvering, resulting in a collision with the terrain, and subsequent rollover.NTSB LAX01LA220Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Nimbus 3/24.5 · Montague, CAA loss of control during landing flare. Contributing to the accident was the gusty wind condition.NTSB LAX01LA218Accident · No injuriesLimited investigationFinal reportStolp Starduster SA-300 · El Cajon, CAThe pilot's failure to maintain directional control during landing rollout.NTSB FTW01FA151Accident · 1 fatalField investigationFinal reportErcoupe 415-CD · McAlester, OKthe inadvertent stall by the pilot-in-command.NTSB DEN01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, COthe pilot's inadequate wind evaluation, and his inadequate planning/decision to land with a tailwind, at a density altitude of 13,418 feet. Contributing factors were the tailwind and the high density altitude weather condition.NTSB CHI01LA190Accident · Serious injuriesLimited investigationFinal reportTerminella Glasair II RG · Bolivar, MOThe pilot not maintaining aircraft control during the initial climb after takeoff. A factor to the accident was the pilot's decision to operate the airplane over the kit manufacture's recommended maximum gross weight.NTSB CHI01LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brooklyn, MIThe proper touchdown point exceeded, all of the available runway not used, and aircraft control not being maintained by the pilot during the landing. Factors to the accident were the pilot mistaking the taxiway for the runway, the pilot not performing a…NTSB ANC01LA072Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Petersburg, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was soft terrain.NTSB NYC01WA152Accident · Serious injuriesForeign investigationCessna 182S · Newquay, United KingdomNTSB MIA01LA174Accident · No injuriesLimited investigationFinal reportSocata TB-20 · Naples, FLThe collapse of the left main landing gear for undetermined reasons resulting in the loss of directional control and subsequent on-ground collision with a ravine.NTSB MIA01LA170Accident · 2 fatalLimited investigationFinal reportUnknown DragonFly B · LaBelle, FLThe inadvertent stall/spin by the pilot resulting in an uncontrolled descent and impact with the ground.