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 CHI01LA156Accident · No injuriesLimited investigationFinal reportCessna R182 · White Bear Lake, MNthe takeoff checklist not followed and the inadequete soft field takeoff proecedure by the pilot. The short/soft field was a factor.NTSB SEA01LA115Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Eastsound, WAFailure of the engine driven fuel pump due to a worn snap ring which resulted in a loss of engine power during initial climb. Failure to comply with Service Bulletin inspection instructions, and collision with trees were factors.NTSB NYC01LA150Accident · Serious injuriesLimited investigationFinal reportRaven S60A · Mumford, NYThe ground handler's failure to follow instructions to release her line during the balloon's unintended ascent, due to panic.NTSB MIA01LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bennettsville, SCThe pilot failure to obtain the proper touchdown point on the runway resulting in the airplane landing long, over running the runway, colliding with a telephone pole separating the right wing, and coming to rest in the parking lot of a restaurant.NTSB LAX01LA206Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Winnemucca, NVThe pilot's failure to obtain weather information or an in-flight advisory that would have described current wind information at the destination airport and his subsequent failure to maintain directional control during landing.NTSB LAX01LA203Accident · No injuriesLimited investigationFinal reportMooney M20J · Jackson, CAFailure of the pilot to maintain proper airspeed for landing and airplane control with an existing crosswind. A contributing factor was the distraction of the pilot by a yelling passenger.NTSB IAD01LA068Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Danbury, CTthe pilot's misjudged altitude and excessive airspeed resulting in a collision with a pole. A factor was the cracked exhaust stack, which resulted in a partial loss of engine power.NTSB FTW01LA140Accident · Serious injuriesLimited investigationFinal reportBeech BE-35 · Springdale, ARthe loss of engine power due to an undetermined reason.NTSB DEN01LA115Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COthe pilot's failure to maintain directional control during landing. A contributing factor was the tailwind.NTSB DEN01LA114Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Provo, UTinadvertent retraction of the landing gear by the pilot rated student during landing roll. A contributing factors was the failure of the instructor to adequately supervise the student.NTSB CHI01LA159Accident · No injuriesLimited investigationFinal reportCessna 172M · Middleton, WIThe pilot attempted a touch and go on unsuitable terrain. A factor associated with the accident was the tall wet grass airstrip on which the touch and go was attempted.NTSB CHI01LA158Accident · No injuriesLimited investigationFinal reportPackwood Packwood 1 · Pierce City, MOan engine failure during initial climbout and the fence struck during the runway overrun.NTSB SEA01LA114Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mattawa, WAThe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors were the gusty crosswind condition and the high vegetation (sage brush) which the aircraft rolled into before nosing over.NTSB MIA01LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Miami, FLThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling, descending uncontrolled, impacting the runway, and sliding off the runway and nosing over.NTSB FTW01LA138Accident · No injuriesLimited investigationFinal reportCessna 172M · Hot Springs, ARthe student pilot's delayed go-around, which resulted in the airplane impacting trees during the aborted landing.NTSB FTW01LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Oil Trough, ARthe pilot's failure to refuel the airplane which resulted in the loss of engine power due to fuel exhaustion. A contributory factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA164Accident · No injuriesLimited investigationFinal reportBoeing Stearman A-75 · Marissa, ILThe pilot's manuever to avoid obstructions and his failure to abort takeoff. The pilot's failure to establish adequate climb, and the transmission wire are contributing factors.NTSB CHI01LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · La Porte, INthe inadequate planned approach by the pilot. Contributing factors were the fuel starvation and tailwind.NTSB CHI01LA155Accident · Serious injuriesLimited investigationFinal reportTorno Micro Mong · Petersburg, MIAircraft control not being maintained by the pilot during the forced landing. Factors to the accident were the loss of engine power, the overtemperature of the piston, the hole in the top of the number-one piston, and the encountered stall.NTSB NYC01LA139Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHThe CFI's improper decision to abort the takeoff and his improper flare, which resulted in a hard landing.NTSB MIA01LA155Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kill Devil Hill, NCThe loss of engine power due to fuel starvation for undetermined reasons resulting in the forced landing and subsequent on-ground collision with a sand dune with a resulting nose over. A factor in the accident was the unsuitable terrain encountered during the…NTSB LAX01TA204Accident · No injuriesFinal reportGates Learjet LR-24A · Victorville, CAThe copilot inadvertently induced a lateral oscillation resulting in an in-flight loss of control. The pilot-in-command failed to adequately surpervise the copilot.NTSB IAD01FA066Accident · 1 fatalField investigationFinal reportHughes 369A · Perry, WVThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain terrain clearance. A contributing factor was mountainous terrain.NTSB MIA01WA157Accident · No injuriesForeign investigationCessna 182Q · Stella Maris, BahamasNTSB MIA01FA151Accident · 3 fatalField investigationFinal reportMooney M-20J · Monroe, NCThe pilot in command’s failure to maintain airspeed while maneuvering to avoid objects, resulting in a stall/mush and collision with the terrain during uncontrolled descent. Contributing to the accident was the improper approach to land and his failure to…NTSB FTW01LA136Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Powhatan, ARthe pilot's failure to maintain obstacle clearance while maneuvering after takeoff.NTSB DEN01LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Akron, COthe pilot's failure to adequately compensate for wind conditions, resulting in a loss of directional control during landing roll. A contributing factor was the crosswind.NTSB DCA01WA053Incident · No injuriesForeign investigationBoeing B-777 · Danang, VietnamNTSB ATL01LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pomaria, SCThe pilot's improper operation of the flight controls while attempting a takeoff from an unimproved surface. A factor was rough and uneven terrain.NTSB NYC01LA138Accident · Serious injuriesLimited investigationFinal reportInterplane Sky Boy · Sayre, PAThe pilot's failure to maintain an adequate climb airspeed.NTSB NYC01LA137Accident · No injuriesLimited investigationFinal reportGraham Acro Sport · Hampton, NHA soft area in the turf runway, which resulted in a loss of directional control during the landing rollout.NTSB MIA01LA153Accident · Minor injuriesLimited investigationFinal reportEnstrom F28A · Double Springs, ALThe failure of the pilot to maintain clearance between the skid and trailer while attempting to lift from a trailer resulting in dynamic roll-over.NTSB LAX01FA201Accident · No injuriesField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVfatigue failure of the right main landing gear retraction arm.NTSB IAD01WA064Accident · 3 fatalForeign investigationPiper 31-310 · Prince Edward, CanadaNTSB IAD01LA063Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Louisville, KYThe flight instructor's failure to maintain directional control after landing.NTSB DCA01WA045Incident · No injuriesForeign investigationBoeing B-747-400 · Tokyo, JapanNTSB CHI01LA154Accident · Serious injuriesLimited investigationFinal reportBoeing B757-200 · Kokomo, INthe turbulence encountered during descent and the passenger failure to return to his seat.NTSB ATL01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Blakely, GAThe pilot's inadequate in-flight decision to go-around after a reported loss of right brake pressure during the landing roll resulted in the in-flight collision with trees.NTSB ATL01IA064Incident · No injuriesIncident investigationFinal reportBoeing 757 · Atlanta, GAThe pilots improper landing flare that resulted in the tail section collision with the runway.NTSB WAS01WA010Accident · 3 fatalForeign investigationBell UH-IH · Taumarunui, New ZealandNTSB NYC01WA140Accident · Minor injuriesForeign investigationBell 47G · Merseburg, GermanyNTSB LAX01FA308Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lytle Creek, CAThe pilot's inadequate decision to fly into an area of rising terrain.NTSB LAX01FA200Accident · No injuriesField investigationFinal reportHughes 369D · Hanapepe, HIa loss of engine power while in cruise flight resulting from the failure and liberation of several turbine blades due to hot corrosion effects which weakened the blades. The hot corrosion damage was the result of multiple turbine over temperature events which…NTSB LAX01FA199Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Big Bear City, CAthe student pilot's selection of a takeoff runway conducive to a tailwind weather condition and his failure to maintain airspeed and his inadvertent stall during takeoff initial climb. Factors in the accident were the partial loss engine power resulting from…NTSB ATL01LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Picayune, MSThe pilot's inflight fuel planning /decision that resulted in fuel starvation and a loss of engine power. A factor was the failure of the fuel transfer pump.NTSB ANC01LA065Accident · No injuriesLimited investigationFinal reportCessna 170B · Sand Point, AKThe pilot's inadequate compensation for wind conditions while on approach, and the inadvertent stall of the airplane while attempting a go-around. A factor associated with the accident was a crosswind.NTSB ANC01LA062Accident · No injuriesLimited investigationFinal reportNoorduyn UC-64A · Seward, AKThe pilot's inadvertent stall of the airplane during takeoff. Factors associated with the accident were the pilot's inadequate weather evaluation, his inadequate compensation for wind conditions, and turbulence.NTSB SEA01LA112Accident · No injuriesLimited investigationFinal reportCessna 150F · Arlington, WAA fire that originated in the aircraft's carburetor.NTSB NYC01WA136Accident · Serious injuriesForeign investigationPartenavia P68TC · Gratwich, United KingdomNTSB MIA01FA152Accident · 5 fatalField investigationFinal reportPiper PA-31-T2 · Jackson, TNThe pilot's shutting down the left engine following loss of control of the left propeller resulting in an in-flight loss of control of the airplane due to the windmilling propeller. Factors in the accident were the failure of the propeller control bracket…