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 DCA10WA002Incident · No injuriesForeign investigationBoeing 737 · Bologna, ItalyOn September 24, 2009, a Bluebird Cargo Boeing 737-300, registration TF-BBD, conducted an emergency descent after experiencing a rapid decompression and diverted into Bologna Airport (LIPE), Bologna, Italy. There were no injuries to the 2 crew members and the…NTSB DCA09WA079Accident · 1 fatalForeign investigationBAE Jetstream 41 · Durban, South AfricaOn September 24, 2009 about 0557 UTC, a BAE Jetstream 4100, ZS-NRM, operated by South African Air Link on a positioning flight, crashed shortly after takeoff from runway 06 at Durban Airport, South Africa. The pilot reported a loss of power in one engine…NTSB CEN09FA603Accident · 1 fatalField investigationFinal reportCessna 182Q · Houma, LAThe pilot’s decision to take off into instrument meteorological conditions.NTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.NTSB ERA09CA535Accident · No injuriesData collectionFinal reportC A Tecnam P2002 Sier · Enterprise, ALThe student pilot's failure to maintain control during the landing roll.NTSB CEN09CA604Accident · No injuriesData collectionFinal reportBell 407 · Fort Worth, TXFailure of the pilot to maintain control during landing.NTSB ANC09CA106Accident · Serious injuriesData collectionFinal reportRittal Alfred Timothy Glastar · Tuluksak, AKA loss of control for an undetermined reason during the takeoff portion of an aborted landing at an off-airport site, resulting in a collision with terrain.NTSB WPR09CA462Accident · No injuriesData collectionFinal reportAgusta A109 · Page, AZA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning and his decision to continue flight with a known low fuel level state.NTSB CEN09WA598Accident · 2 fatalForeign investigationSchweizer 269C · Blackpool, United KingdomOn September 22, 2009, at 1104 universal coordinated time, a Schweizer 269C helicopter, United Kingdom registered G-LINX, registered to Heli-Lynx Limited, was destroyed when it impacted terrain near Blackpool, Lancashire, England. Visual meteorological…NTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…NTSB CEN09CA600Accident · No injuriesData collectionFinal reportCessna 402B · Omaha, NEThe pilot’s improper decision to taxi with an obstructed windscreen and his failure to maintain clearance from the parked airplane.NTSB WPR09CA461Accident · No injuriesData collectionFinal reportCessna 172S · San Carlos, CAThe student pilot's failure to maintain clearance with a fence post during taxi.NTSB CEN09CA599Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sibley, IAThe pilot's long and fast landing and her delayed decision to execute a go-around.NTSB ANC09CA105Accident · No injuriesData collectionFinal reportPiper PA-22 · Seward, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control and a nose over during the takeoff roll.NTSB WPR09LA460Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Valley Center, CAThe failure of the engine’s camshaft due to fatigue of unknown origin.NTSB WPR09FA459Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Forest Grove, ORThe flight crew’s failure to maintain adequate main rotor speed while maneuvering, which resulted in a main rotor blade stall and an uncontrolled descent into terrain.NTSB ERA09LA532Accident · No injuriesLimited investigationFinal reportRyan Navion · Fire Island, NYA total loss of engine power during cruise flight due to fuel starvation as a result of a deteriorated fuel gasket.NTSB ERA09LA531Accident · Minor injuriesLimited investigationFinal reportDaniel L Patrick Kolb Mark · Mystic, CTThe pilot's failure to maintain airspeed during final approach, resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of total flight experience.NTSB ERA09FA526Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Fort Lauderdale, FLFatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…NTSB ERA09CA534Accident · No injuriesData collectionFinal reportAeromot AMT200 · Wheeling, WVThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the pilot's failure to properly secure the canopy latch which resulted in an in-flight canopy opening.NTSB CEN09IA595Incident · No injuriesIncident investigationFinal reportBeech V35 · Nacogdoches, TXThe complete loss of engine power due to failure of the number two connecting rod. The reason for the connecting rod failure could not be determined.NTSB WPR09LA458Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Reno, NVThe loss of engine power due to failure of the No. 2 connecting rod as a result of operation of the engine at excessive temperatures.NTSB ERA09LA530Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Fairmont, WVThe pilot's delay in aborting the takeoff, resulting in an overun. Contributing to the accident was the overweight condition of the airplane.NTSB ERA09LA527Accident · 2 fatalLimited investigationFinal reportCessna 172 · Lowndesville, SCThe pilot's inadequate preflight planning and improper decision to continue flight into deteriorating weather conditions, which resulted in spatial disorientation after entering instrument flight conditions.NTSB ERA09CA533Accident · No injuriesData collectionFinal reportCessna 182 · Montauk, NYThe pilot’s failure to attain the proper touchdown point while landing.NTSB CEN09CA596Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Princeton, MNThe pilot's failure to maintain directional control during landing.NTSB WPR09LA454Accident · Minor injuriesLimited investigationFinal reportLewis Jennings Nieuport 11 · Pahrump, NVA total loss of engine power during cruise flight due to a failure of the engine's sole magneto.NTSB WPR09CA456Accident · No injuriesData collectionFinal reportAviat A-1C · McArthur, CAThe pilot's failure to maintain aircraft control during landing due to animals unexpectedly running onto the runway.NTSB ERA09LA528Accident · No injuriesLimited investigationFinal reportMooney M20K · Farmville, VAThe pilot’s failure to maintain directional control during the landing rollout.NTSB ENG09IA018Incident · No injuriesIncident investigationFinal reportBoeing 767 · Newark, NJFailure of Main Landing Gear (MLG) truck beam was due to contamination of the inner surface corrosion protective layers from hydraulic fluid and deice fluid that resulted in corrosion and intergranular stress corrosion cracking.NTSB CEN09LA594Accident · No injuriesLimited investigationFinal reportMcclish Funk B85C · Coffeyville, KSAn in-flight fire for undetermined reasons.NTSB CEN09CA593Accident · Minor injuriesData collectionFinal reportLinke KR-2 · Mt. Vernon, ILThe inadequate preflight planning/preparation and fuel management by the pilot which led to fuel exhaustion and a total loss of engine power during approach. Contributing to the accident was the inoperative fuel indicator.NTSB CEN09CA592Accident · No injuriesData collectionFinal reportBordelon Kitfox IV · Dodge Center, MNThe pilot's improper glide path during landing.NTSB ANC09LA104Accident · No injuriesLimited investigationFinal reportCASA 212-200 · Savoonga, AKThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind.NTSB ANC09LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nabesna, AKThe pilot's selection of an unsuitable takeoff area with an unfavorable wind.NTSB ERA09FA524Accident · Serious injuriesField investigationFinal reportCurtis John P SEA REY · Winter Haven, FLThe flightcrew's failure to maintain adequate airspeed while maneuvering during a simulated engine failure, resulting in an aerodynamic stall and uncontrolled descent.NTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.NTSB ENG09WA022Incident · No injuriesForeign investigationAirbus A319 · Copenhagen, Denmark, DenmarkOn September 17, 2009, a British Airways Airbus A319-131, powered by two International Aero Engines V2522-A5 engines, experienced a bird strike and subsequent engine stall in the No. 1 engine (left-hand) during climb after takeoff at approximately 5,000 feet.…NTSB CEN09CA589Accident · Serious injuriesData collectionFinal reportDiehl KR-2 · Mt. Vernon, ILThe pilot's improper landing flare while landing with gusting winds and his failure to perform a go-around.NTSB ANC09LA100Accident · No injuriesLimited investigationFinal reportGrumman G-44A · Anchorage, AKA fatigue fracture of an unapproved hydraulic brake line fitting, which resulted in a loss of control during the landing roll. Contributing to the accident was the installation of an unapproved part by an unknown maintenance personnel.NTSB ANC09CA101Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Tok, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in a runway excursion and a nose over during takeoff.NTSB WPR09LA453Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Redlands, CAStructural failure of the right wing during the landing approach due to the separation of the wing's fabric covering.NTSB WPR09LA452Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Santa Paula, CAA total loss of engine power during takeoff for undetermined reasons.NTSB WPR09LA451Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Hayward, CAThe pilot's failure to maintain directional control after takeoff. Contributing to the accident was the pilot's inadequate preflight and failure to follow the airplane manufacturer's checklist to ensure that the rudder trim control and right propeller control…NTSB ANC09LA102Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lime Village, AKThe passenger's inadvertent interference with, and application of the right brake pedal during takeoff.NTSB ANC09CA099Accident · No injuriesData collectionFinal reportPiper PA-18 · Chickaloon, AKThe pilot's decision to land on unsuitable terrain, which resulted in a nose-over on landing.NTSB WPR09CA448Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Irvine, CAThe flight instructor's failure to maintain an adequate airspeed and his delayed recovery action during the practice autorotation, which resulted in a hard landing.NTSB ERA09LA523Accident · No injuriesLimited investigationFinal reportCessna 208 · Sheffield, MAA total loss of engine power due to a failure of the 1st stage sun gear output splines for unknown reasons, which resulted in a power turbine overspeed condition, with subsequent blade distress/release.NTSB ERA09CA522Accident · No injuriesData collectionFinal reportCessna 152 · Merritt Island, FLThe student pilots failure to maintain directional control after landing.NTSB CEN09RA590Accident · 3 fatalClass 5 · ForeignPiper PA34 · Castro Verde, PortugalOn September 15, 2009, at 2055 Western European Summer Time, a Piper PA-34-220T, OO-TML, registered to Ben-Air Flight Academy was destroyed upon impact with terrain during a night navigation training flight. The airplane had disappeared from radar and no…