NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 CEN09WA016Accident · 2 fatalForeign investigationCessna 421 · Oaxaca, MexicoOn October 6, 008 at approximately 1332 central daylight time (CDT) a Cessna 421C, Mexican Registration XB-KWB was destroyed while attempting to return to Xoxocotlan International Airport (OAX,) Oaxaca, Mexico to land . Both aircraft occupants sustained fatal…NTSB CEN09CA025Accident · Serious injuriesData collectionFinal reportHolmes William E Predator · Branson, MOThe pilot's failure to maintain directional control. Contributing to the accident was the wing's failure to open all cells for undetermined reasons and the trees near the runway.NTSB CEN09CA005Accident · No injuriesData collectionFinal reportCessna 180A · St. Louis, MOThe flight instructor's failure to maintain directional control during the landing.NTSB WPR09LA004Accident · 1 fatalLimited investigationFinal reportBonde TF-51D · Sandy Valley, NVThe pilot's failure to maintain adequate airspeed while maneuvering to land, resulting in an aerodynamic stall. Contributing to the accident was the pilot's diverted attention while attempting to extend the landing gear.NTSB ERA09IA009Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Lakeland, FLA failure of the flap actuator rod end due to low stress, high cycle fatigue, and subsequent overstress failure.NTSB ERA09FA005Accident · Minor injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Swainsboro, GAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB ERA09CA003Accident · No injuriesData collectionFinal reportBuckeye Dream Machine · Lexington, KYThe student pilot's improper decision to continue the takeoff.NTSB WPR09CA003Accident · No injuriesData collectionFinal reportBeech 76 · Eloy, AZThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident were the crosswind wind conditions and terrain induced turbulence.NTSB ERA09LA004Accident · No injuriesLimited investigationFinal reportCessna T210M · Savannah, GAA loss of engine power in flight due to fuel exhaustion as a result of the pilot's improper fuel management.NTSB ERA09CA008Accident · No injuriesData collectionFinal reportAviat A-1B · Mooresville, NCThe pilot's improper flare while landing. Contributing to the accident was the pilot's lack of recent experience.NTSB CEN09CA007Accident · No injuriesData collectionFinal reportLet Blanik · Gardner, KSThe pilot's decision to attempt a takeoff when the climb performance of the tow plane and the glider were inadequate. Contributing to the accident were the high density altitude and the terrain-induced turbulence.NTSB WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.NTSB ERA09CA010Accident · No injuriesData collectionFinal reportCessna 172 · Naples, METhe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the wet condition of the grass runway.NTSB ERA09CA006Accident · No injuriesData collectionFinal reportBeech F17D · Moscow, TNThe mechanical failure of the landing gear actuation chain.NTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.NTSB CEN09CA001Accident · No injuriesData collectionFinal reportLuscombe 8A · Greeley, COThe pilot's failure to maintain directional control during the landing roll resulting in a ground loop. Contributing to the accident was the lack of remedial action from the flight instructor.NTSB ANC09FA003Accident · 1 fatalField investigationFinal reportAntonovich Anton B Challenger II · Chugiak, AKThe pilot’s failure to maintain control of the airplane while maneuvering, resulting in an in-flight collision with trees. Contributing to the accident was the pilot's lack of experience.NTSB WPR09TA001Accident · No injuriesFinal reportEurocopter AS350B3 · Blaine, WAThe pilot's failure to maintain main rotor rpm, which resulted in a hard landing. Contributing to the accident were the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB DCA09WA003Accident · Serious injuriesForeign investigationBoeing 747 · Bangkok, ThailandOn October 2, 2008, at 1058 local Thai time, a China Airlines Boeing 747-400, registered in Taiwan as B-18202, experienced turbulence while enroute to Bangkok, Thailand, from Hong Kong International Airport, Hong Kong. The flight was at flight level 400 and…NTSB ANC09LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB SEA08LA216Accident · No injuriesLimited investigationFinal reportBrennan RV-8 · Idaho Falls, IDThe on-ground fire during taxi due to a loose fuel line "B" nut.NTSB SEA08CA215Accident · No injuriesData collectionFinal reportNorth American AT-6 · Arlington, WAThe front seated pilot's inadequate compensation for the right quartering tailwind and failure to maintain directional control. Also causal was the rear seated pilot's inadequate remedial action and failure to regain directional control.NTSB LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before takeoff.NTSB ERA09WA066Accident · Serious injuriesForeign investigationRobinson R44 · Yoro, HondurasOn October 1, 2008, about 1220 central standard time, a Robinson R44, Honduran registration HR-AUC, was substantially damaged during a takeoff attempt near Yoro, Honduras. The Honduran certificated private pilot was seriously injured and three passengers…NTSB ERA09LA001Accident · Serious injuriesLimited investigationFinal reportBezinque Alisport-Silent · Vero Beach, FLThe failure of the electric fuel boost pump which resulted in a loss of engine power due to fuel starvation.NTSB ENG08IA042IncidentIncident investigationFinal reportBoeing 737 · Chicago, ILThe right nose landing gear axle's failure from intergranular and fatigue cracking due to an earlier bearing failure.NTSB CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…NTSB ANC09FA001Accident · 2 fatalField investigationFinal reportCessna U206C · Anchorage, AKA loss of engine power during takeoff/initial climb for an undetermined reason, and the pilot's decision to make an abrupt and steep low altitude turn toward an intersecting runway, resulting in an aerodynamic stall and loss of aircraft control.NTSB SEA08CA214Accident · No injuriesData collectionFinal reportLaird LC-1B-300 · Spokane, WAThe pilot’s misjudged landing flare that resulted in a hard landing. A contributing factor was the impact related failure of the tail wheel spring attachment bolts due to overload, which resulted in a ground loop.NTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.NTSB DEN08FA162Accident · 1 fatalField investigationFinal reportPilatus PC-12/47E · Santa Fe, NMThe pilot's incapacitation due to fatigue resulting in an in-flight collision with terrain.NTSB WPR09LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fresno, CAThe pilot misjudged the flare resulting in a hard landing.NTSB ERA09IA499Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas Helicopter 369E · Allentown, PAThe fatigue failure of a blade in the second-stage turbine wheel, which resulted in a total loss of engine power.NTSB DFW08LA238Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Leadville, COThe flight instructor's failure to maintain control of the airplane while maneuvering at low altitude.NTSB NYC08CA327Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Beverly, MAAn inadvertent collision with a deer while landing.NTSB NYC08CA325Accident · No injuriesData collectionFinal reportAeronca 7AC · Mt. Pleasant, SCThe pilot's failure to maintain aircraft control during an emergency maneuver. Contributing to the accident was the failure of the left magneto.NTSB MIA08MA203Accident · 4 fatalClass 1 · MajorFinal reportAerospatiale SA365N-1 D · District Heights, MDThe pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…NTSB MIA08LA205Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA42 · Lancaster, PAThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB MIA08LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Falmouth, KYA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB LAX08FA300Accident · 1 fatalField investigationFinal reportBeech A36 · Carlsbad, CAThe pilot's failure to maintain control during the instrument approach and attempted go-around.NTSB DFW08FA237Accident · 2 fatalField investigationFinal reportCessna 320D · Collinsville, OKThe crews' failure to maintain adequate airspeed, which resulted in an aerodynamic stall close to the ground.NTSB DFW08CA239Accident · No injuriesData collectionFinal reportGier Travis H Aventura II · Montgomery, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the wind gust.NTSB DEN08LA163Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Duncan, OKA total loss of engine power due to the fatigue failure of the engine crankshaft. Contributing to the accident were the improper maintenance to the engine crankshaft, improper reassembly of the engine, and failure to follow the engine manufacturer's overhaul…NTSB CHI08CA295Accident · Minor injuriesData collectionFinal reportNorth American Harvard MK · Dayton, OHImproper maintenance on the tail wheel anti-shimmy mechanism and the pilot's decision to continue operating the airplane with a known shimmy in the tail wheel.NTSB ANC08LA131Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC · Cooper Landing, AKThe pilot's failure to maintain separation from a tree during the landing roll at an off-airport site.NTSB ANC08CA129Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Kenai, AKThe pilot's failure to maintain tail rotor clearance from the safety netting during final approach and landing.NTSB SEA08LA213Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woods Landing-Jelm, WYThe pilot's encounter with a loss of tail rotor effectiveness event and his failure to maintain directional control while maneuvering. Contributing to the accident were the tailwind condition and the sloping, uneven terrain.NTSB SEA08CA212Accident · No injuriesData collectionFinal reportSport Flight International Astra · Spokane, WAThe pilot's excessive use of brakes and failure to maintain directional control during the landing roll.NTSB NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.NTSB DEN08CA164Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Double Eagle Airport, NMThe pilot flared high and failed to maintain directional control. Contributing to the accident were the pilot's unfamiliarity with the airplane and the crosswind.