NTSB investigations, 2001
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 LAX01LA083Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Lihue, HIThe manufacturer's inadequate collective lock design, which resulted in the collective unlocking during a preflight check and subsequent unintentional liftoff and loss of helicopter control. The pilot's loss of control was due in part to the unavailability of…NTSB FTW01LA057Accident · Minor injuriesLimited investigationFinal reportBeech BE-58 · Brinkley, ARthe pilot's poor inflight planning and decision making which resulted in his executing a precautionary landing in a soft field. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB ATL01LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Concord, NCThe pilots failure to follow the auxiliary fuel tank procedures, which resulted in the fuel starvation and the loss of engine power.NTSB MIA01WA069Accident · 3 fatalForeign investigationYopal, ColombiaNTSB DEN01LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Junction, COFailure by the pilot to maintain directional control of the aircraft during landing roll. A factor was lack of total pilot experience in aircraft make and model.NTSB DCA01WA018Accident · No injuriesForeign investigationCessna CitationJET (525) · Salcea, RomaniaNTSB CHI01LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sunfield, MIThe pilot's inadequate preflight preparation and the unsuitable terrain for takeoff encountered. Factors included the slushy runway and the snowbank.NTSB CHI01LA076Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fulton, MOthe pilot not maintaining altitude/clearance from the power line during the circling approach. Factors were the power transmission wire, the plowed field, and that the pilot's lookout was not possible through the built up ice on the windshield.NTSB ATL01LA032Accident · No injuriesLimited investigationFinal reportCessna 208 · Key West, FLThe airplanes' inadvertent collision with a swell during a water landing near a ferry boat that resulted the overload failure of the rear float/strut assembly.NTSB ANC01LA034Accident · No injuriesLimited investigationFinal reportDouglas DC-6B · Crooked Creek, AKThe flight crew's misjudged flare while landing. Factors associated with the accident were flat light conditions, snow-covered terrain, and an uphill runway grade.NTSB NYC01FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Edgartown, MAThe pilot's failure to maintain a stabilized approach with an adequate vertical and lateral track. Also causal was his failure to maintain obstacle clearance.NTSB FTW01LA055Accident · No injuriesLimited investigationFinal reportSchmidt Questair Venture · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll. Factors were the crosswind and soft terrain condition.NTSB DEN01LA046Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Spring, COthe student pilot's inadequate compensation for the crosswind during landing roll. A contributing factor was the cross wind weather condition.NTSB DCA01WA019Incident · No injuriesForeign investigationBoeing B-777-300 · AustraliaNTSB SEA01LA043Accident · No injuriesLimited investigationFinal reportS.N.I.A.S SE 3130 Alouette II · Driggs, IDThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.NTSB SEA01LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Renton, WAThe worn condition of the hydraulic pump gears which resulted in a continuous running pump, subsequent pump motor overheat and eventually the tripping of the pump motor circuit breaker. An additional cause was the pilot's failure to verify that the landing…NTSB NYC01FA071Accident · 1 fatalField investigationFinal reportSchempp-Hirth Discus CS · Wurtsboro, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while on base leg.NTSB MIA01WA067Accident · 7 fatalForeign investigationAero Commander 500 · Tamboril, Dominican RepublicNTSB MIA01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tifton, GAThe pilot's failure to properly judge his altitude (too high) during a forced landing to a runway. The pilot made a 270-degree turn in an attempt to lose altitude resulting in a forced landing in a swampy/marshy area short of the runway. Contributing to the…NTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.NTSB MIA01LA064Accident · No injuriesLimited investigationFinal reportRobinson R22 · Long Beach, MSThe student pilot's failure to relinquish the flight controls while the CFI was demonstrating a takeoff to a hover. This resulted in an in-flight loss of directional control, in-flight collision with terrain, and subsequent roll over.NTSB LAX01LA082Accident · No injuriesLimited investigationFinal reportBeech BE-55 · San Bernardino, CAThe failure of the pilot under instruction to extend the landing gear during the landing approach. A factor was the flight instructor's inadequate supervision.NTSB LAX01LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Camarillo, CAThe failure of the pilot to maintain directional control during takeoff.NTSB FTW01LA056Accident · No injuriesLimited investigationFinal reportNeely B D Kit Fox 4 · Cedar Park, TXthe pilot's excessive braking during the landing roll.NTSB FTW01LA053Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Damon, TXthe pilot's failure to maintain helicopter control during takeoff to a hover, which resulted in a dynamic rollover.NTSB DCA01MA017Accident · 10 fatalClass 1 · MajorFinal reportBeech 200 · Strasburg, COThe pilot’s spatial disorientation resulting from his failure to maintain positive manual control of the airplane with the available flight instrumentation. Contributing to the cause of the accident was the loss of a.c. electrical power during instrument…NTSB NYC01LA069Accident · Minor injuriesLimited investigationFinal reportMooney M-20 · S. Charleston, WVThe pilot's failure to maintain runway alignment during the landing roll.NTSB LAX01WA084Accident · 4 fatalForeign investigationCessna 310R · Newman, AustraliaNTSB FTW01LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Lancaster, TXmaintenance personnel's improper installation of the throttle lever lock nut. A contributory factor was the lack of suitable terrain for the forced landing.NTSB MIA01WA063Accident · 4 fatalForeign investigationPiper PA-34-200T · Augeburg, GermanyNTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.NTSB DEN01FA045Accident · 2 fatalField investigationFinal reportCessna 182K · Elbert, COthe pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC), which resulted in an in-flight collision with terrain. Contributing factors to the accident were the low clouds, reduced visibilities due to fog, and the…NTSB DCA01WA016Accident · 24 fatalForeign investigationDouglas DC-3 · Cuidad Bolivar, VenezuelaNTSB CHI01LA075Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Dryden, MIThe pilots failure to maintain altitude/clearance from the terrain. The dark night was a factor.NTSB CHI01IA073Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Grand Rapids, MIThe uncommanded deployment of the right flight spoiler due to the fatigue fracture of the spoiler lug.NTSB FTW01WA059Accident · No injuriesForeign investigationCessna T310R · Jeddah, Saudi ArabiaNTSB DEN01FA044Accident · 2 fatalField investigationFinal reportAero Vodochody Aero. Works L-39CT · Watkins, COThe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush. Factors were the pilot's diverted attention due to the failure of the rear canopy's acrylic transparency and the loss of communication with his back seat passenger,…NTSB ATL01FA027Accident · 4 fatalField investigationFinal reportBeech F90-42 · Nashville, TNThe pilot's failure to follow loss of engine power emergency procedures by not feathering the propeller following the loss of engine power for undetermined reasons, resulting in a descent and collision with trees and the ground.NTSB ANC01FA033Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Unalaska, AKThe airplane flightcrew's failure to maintain adequate distance/altitude from mountainous terrain during a departure climb to cruise flight, and the captain's impairment from drugs. Factors in the accident were dark night conditions, and the first officer's…NTSB LAX01LA080Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Douglas, AZThe student's failure to maintain control of the airplane during the go-around and his premature retraction of the landing gear. A factor was the flight instructor's inadequate supervision of the flight.NTSB LAX01LA079Accident · No injuriesLimited investigationFinal reportHughes 369D · Ely, NVThe mechanic's inadvertent activation of the bleed valve, which resulted in a loss of engine oil and loss of engine power while in cruise flight.NTSB ANC01TA032Accident · No injuriesFinal reportCessna 172 · Kipnuk, AKThe pilot's inadequate compensation for a crosswind during the landing roll. Factors in the accident were the presence of a crosswind, an icy runway and snow covered terrain, the pilot's inadequate preflight planning/preparation, and an inaccurate wind…NTSB NYC01LA070Accident · 1 fatalLimited investigationFinal reportWhittman Tailwind DN-1 · Grafton, WVThe pilot's improper preflight planning, which resulted in fuel exhaustion. A factor was the pilot's lack of familiarity with the airplane.NTSB CHI01LA070Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Quincy, ILThe security guard failed to maintain clearance with the operating tail rotor.NTSB NYC01IA068Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Jamaica, NYThe pilot's decision to perform an auto rollout on a snow contaminated runway, which had not been demonstrated, and which resulted in a loss of directional control, when the capability of the autoland system to maintain directional control was exceeded.…NTSB FTW01LA052Accident · 2 fatalLimited investigationFinal reportNanchang CJ-6A · Edgewood, TXthe pilot's failure to maintain obstacle clearance with the tower guy wire while the airplane was in cruise flight. A contributing factor was the pilot's failure to update his navigation chart with the location of the tower during his preflight…NTSB CHI01LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Prairie Du Sac, WIthe improper trim setting and the pilot failed to maintain control of the airplane. A factor was the snowbank.NTSB CHI01LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culver, INthe proper glide path not attained by both pilots during a short field landing. The snow bank was a contributing factor.NTSB SEA01LA041Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Arlington, WAThe pilot's failure to maintain directional control during landing roll.