NTSB investigations, 2001
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 MIA01LA199Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pelham, GAThe ground refueler's inadequate visual lookout resulting in his walking into the rotating propeller of the airplane and receiving fatal injuries.NTSB MIA01LA197Accident · No injuriesLimited investigationFinal reportCessna 182B · Headland, ALThe pilot's improper decision to perform a go-around while on short final to an available runway following loss of engine power for undetermined reasons when engine power was regained momentarily, which resulted in an impact with terrain while maneuvering at…NTSB LAX01LA264Accident · No injuriesLimited investigationFinal reportWilliams RV-6A · Hawthorne, CAThe pilot's failure to maintain control of his airplane during the landing flare.NTSB IAD01FA086Accident · 2 fatalField investigationFinal reportAeronca S-65-CA · Esperance, NYThe pilot's inadequate decision and his failure to maintain obstacle clearance. Contributing factors are a transmission wire and the pilot's intentional low pass.NTSB FTW01FA171Accident · 4 fatalField investigationFinal reportCessna 205 · De Queen, ARthe pilot's VFR flight into IMC, which resulted in spatial disorientation and a loss of aircraft control. A contributing factor to the accident was the pilot's lack of total instrument flight time.NTSB DEN01LA131Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Spanish Fork, UTthe pilot's inadequate compensation for the wind conditions which resulted in a loss of control during landing. A contributing factor was the gusty crosswind.NTSB DEN01LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Gunnison, COthe pilot's failure to attain the proper climb rate, and his improper inflight planning/decision to attempt to cross mountainous terrain at an inadequate altitude. Contributing factors were the downdraft and the pilot's total lack of experience in mountain…NTSB CHI01LA252Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Edmore, NDThe incorrect installation of the wheel assembly bolts by maintenance personnel resulting in the stripped bolt threads and ultimate failure of the wheel, and directional control not possible by the pilot. A factor was the ditchNTSB CHI01LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Jeffersonville, INThe airplane was struck by deer during landing roll at night. A factor was the dark night.NTSB ANC01LA113Accident · No injuriesLimited investigationFinal reportCessna 180 · McCarthy, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was a sudden wind shift.NTSB NYC01LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · West Milford, NJThe student pilot's failure to maintain directional control while landing. Factor’s in this accident were a wind gust and the rocks located off the left side of the runway.NTSB NYC01LA192Accident · Serious injuriesLimited investigationFinal reportMontgomery Teenie Two · Cambridge, OHthe pilot's improper maintenance which resulted in the engine retarding to idle, and subsequent forced landing. A factor was the tall grass in the field where the forced landing was performed.NTSB IAD01LA087Accident · Serious injuriesLimited investigationFinal reportCharles Lancair 320 · Charleston, NYThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in a collision with trees.NTSB DEN01LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMthe pilot's failure to maintain clearance from the powerline while descending for an emergency landing. A contributing factor was the loss of engine power for an undetermined reason.NTSB CHI01LA254Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wall, SDThe student pilot failed to maintain a proper glidepath, failed to obtain proper climb rate, and executed the go-around improperly. Additional factors included the pilot's lack of experience, the crop, and the soft, wet ground.NTSB CHI01IA248Incident · No injuriesIncident investigationFinal reportBoeing 727-2Q6 · Oshkosh, WIThe unsafe condition caused when the pilot taxied onto the runway. Factors relating to this accident were the pilot not following the instructions given him by the ground marshaller, his wrong taxi route, and his not obtaining clearance to taxi onto the…NTSB CHI01IA246Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Kenesaw, NEThe propeller blade fatigue leading to its tip separating during an aerial application. Factors were no suitable terrain for an emergency landing, high vegetation, and soft terrain encountered during the emergency landing.NTSB ANC01WA091Accident · 1 fatalForeign investigationCessna 185 · Yakutat, AKNTSB SEA01LA159Accident · No injuriesLimited investigationFinal reportCessna TU-206F · Minden, NVThe pilot's inadequate recovery from a bounced landing, and his improper remedial action after it became clear that he was not successfully salvaging the landing attempt. Factors include an improperly serviced nose gear strut.NTSB MIA01WA196Accident · Minor injuriesForeign investigationBeechcraft BE-36 · Aruba, NTNTSB MIA01LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Orlando, FLthe pilot's improper visual lookout, which resulted in the aircraft colliding with a fence.NTSB DEN01LA128Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bountiful, UTthe loss of engine power for an undetermined reason. A contributing factor was inadequate clearance of an obstacle during the forced landing by the pilot.NTSB CHI01LA261Accident · No injuriesLimited investigationFinal reportMcIntosh Steen Skybolt · Lebanon, INThe pilot misjudged his altitude during the landing. A factor was the soybean crop which the airplane contacted.NTSB CHI01LA253Accident · No injuriesLimited investigationFinal reportCessna 150M · Rapid City, SDThe student solo pilot failed to compensate for the wind conditions. Factors included the high wind, gusts, and tailwind.NTSB CHI01LA243Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Wheeler, WIThe pilot not maintaining altitude/clearance from the power transmission line. A factor to the accident was the power transmission line.NTSB CHI01LA242Accident · No injuriesLimited investigationFinal reportAg-Cat G-164B · Wallace, NEThe inadequate preflight planning by the pilot, the pilot initiating the flight with an inadequate fuel supply, and the unsuitable terrain encountered during the forced landing. Factors were the fuel exhaustion, the low altitude and the soft field.NTSB CHI01FA244Accident · 1 fatalField investigationFinal reportSchuchart Stoddard HamiltonSH3 · Oshkosh, WIThe inadvertent stall/spin by the pilot.NTSB ANC01LA090Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident were trees.NTSB SEA01LA144Accident · No injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA total loss of power for undetermined reasons and the pilot's misjudgment of distance and speed while maneuvering to a forced landing at a nearby airport. Contributing factors were the 8 knot tailwind and the fence which the aircraft impacted when it over…NTSB NYC01LA188Accident · No injuriesLimited investigationFinal reportCessna 172P · Odenton, MDA loss of engine power for undetermined reasons.NTSB NYC01LA187Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Sandy Hook, NJA total loss of engine power for undetermined reasons.NTSB MIA01TA194Accident · Minor injuriesFinal reportBell 206B-III · Jacksonville, FLthe pilot's failure to recognize and correct for unanticipated right yaw/loss of tail rotor effectiveness (LTE) during an approach to hover at a low altitude, which resulted in a loss of control and the helicopter descending and colliding with a house and the…NTSB LAX01LA260Accident · No injuriesLimited investigationFinal reportCessna 140 · San Luis Obispo, CAThe pilot's failure to maintain directional control during landing that resulted in dragging the wing and nosing over.NTSB LAX01LA259Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Placerville, CAInadequate airspeed during climb out following an aborted landing that was precipitated by the pilot's misjudged speed/distance on final approach. Also, contributing to the accident was the pilot's inexperience in the type of operation, his failure to…NTSB LAX01IA262Incident · No injuriesIncident investigationFinal reportMdhi 520N · Los Angeles, CAthe excitation of the first bending mode natural frequency of the aft tube assembly that is installed through the rotating NOTAR fan drive system. Contributing factors to the incident included the operator's maintenance practice of hand-sanding the pitch…NTSB ENG01RA004Incident · No injuriesForeign investigationAirbus Industrie A330 · Brussels, BelgiumNTSB CHI01LA245Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Detroit, MIThe passenger (an off duty flight attendant) disregarded the flight crews warning regarding turbulence along with the seat belt sign which had been turned on.NTSB CHI01LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hastings, NEAircraft control not being maintained by the pilot which resulted in the encountered settling with power flight condition during the initial climb. Factors to the accident were the reported variable winds during the takeoff and the corn crop.NTSB ANC01LA117Accident · No injuriesLimited investigationFinal reportCessna 207 · Kalskag, AKThe pilot's failure to maintain adequate clearance from an object during the initial climb after takeoff.NTSB SEA01TA143Accident · No injuriesFinal reportBoeing Helicopters Div. H500D · Union Gap, WAThe complete loss of engine power at cruise for undetermined reasons. Factors include a landing area that was restricted/confined due to adjacent trees, and an intentional abrupt flare resulting in a hard landing.NTSB IAD01LA085Accident · No injuriesLimited investigationFinal reportCessna 195 · Moultonboro, NHThe pilot's failure to maintain directional control of the airplane. A factor was the crosswind.NTSB IAD01LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallipolis, OHcollision with a deer during take-off roll.NTSB CHI01LA237Accident · 1 fatalLimited investigationFinal reportVeith Kolb Sling Shot · Goodview, MNThe loss of engine power due to fuel starvation caused by a blocked, unsecured, fuel vent line. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall at a low…NTSB CHI01FA235Accident · 1 fatalField investigationFinal reportPayne Giles G-202 · Oshkosh, WIThe pilot failed to maintain aircraft control which resulted in an inadvertant stall. Factors with the accident were the pilot misjudged the approach and the pilot's lack of total experience in the Giles G-202.NTSB ATL01LA092Accident · Serious injuriesLimited investigationFinal reportKolb Twin Star Mark III · Edgewater, FLThe loss of flight control in-flight for undetermined reasons, that resulted in the uncontrolled collision with the ground.NTSB ATL01LA091Accident · Serious injuriesLimited investigationFinal reportMitchell T-10 · Ashland City, TNThe restricted movement of the rudder cable, resulting in a loss of control and collision with trees.NTSB ATL01FA093Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Anniston, ALThe inadvertent activation of the flight control gust locks by the pilot rated passenger that resulted in the loss of control inflight. Contributing was the pilot in commands failure to follow the airplane's pre-flight inspection check list.NTSB NYC01LA186Accident · No injuriesLimited investigationFinal reportMooney M20J · Mitchellville, MDThe flight instructor's failure to maintain control of the airplane during an aborted landing, and her delay in remedial action. A factor related to the accident was the excessive trim setting.NTSB NYC01LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Dayton, OHThe pilot excessive flare, which resulted in a hard landing.NTSB NYC01LA184Accident · No injuriesLimited investigationFinal reportPohl Lancair IV-P · Fryeburg, MEA partial blockage of the air intake system, due to the pilot's failure to ensure the engine compartment was clear of paper towels after a maintenance inspection.