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 ANC09WA084Accident · 2 fatalForeign investigationKawasaki BK117 · Kinmen, TaiwanOn July 10, 2009, about 0420 Taiwan standard time, a Kawasaki BK-117-B1 helicopter, Taiwanese registration B-77088, collided with ocean water about 1 mile south of the Kinmen Island Airport, Kinmen, Taiwan. The helicopter sustained substantial damage due to…NTSB CEN09FA425Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Simla, COThe pilot’s failure to maintain control of the airplane while practicing aerobatic maneuvers and his subsequent failure to recover from an inadvertent spin.NTSB WPR09FA334Accident · 2 fatalField investigationFinal reportCessna 182P · Mammoth Lakes, CAThe pilot's improper in-flight planning/decision to attempt to fly at a low altitude in a confined area of mountainous terrain in a high density altitude weather condition, and his failure to maintain clearance from the trees.NTSB WPR09CA333Accident · No injuriesData collectionFinal reportBell 47G-2 · Turlock, CAThe pilot's failure to maintain rotor RPM while maneuvering at a low altitude.NTSB ERA09LA392Accident · 1 fatalLimited investigationFinal reportNoles Vance L Vans RV7A · Sanderson, FLThe pilot's continued visual flight into instrument meteorological conditions with convective activity and thunderstorms. Contributing to the accident was his failure to get an adequate weather briefing.NTSB ERA09LA388Accident · Serious injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Oakland, MSA total loss of engine power while maneuvering (after performing aerobatics) for undetermined reasons.NTSB ERA09FA389Accident · 5 fatalField investigationFinal reportCessna 421C · Gulf of MexicoThe pilot’s decision to operate into a known area of adverse weather, which resulted in the inadvertent penetration of a severe thunderstorm, a subsequent loss of control, and in-flight breakup of the airplane.NTSB ERA09CA390Accident · No injuriesData collectionFinal reportPiper J3C · South Charleston, WVThe pilot's failure to maintain control during the attempted go-around.NTSB CEN09CA423Accident · No injuriesData collectionFinal reportLewis Keith O Viggenite · Chesterfield, MOThe loss of engine power for unknown reasons.NTSB CEN09CA421Accident · No injuriesData collectionFinal reportPitts S-2A · Springfield, ILThe pilot's inability to maintain directional control while landing due to the unintentional obstruction of the rudder by the passenger.NTSB WPR09LA340Accident · No injuriesLimited investigationFinal reportBender Kitfox · Valencia, CAThe failure and separation of a propeller blade for undetermined reasons.NTSB WPR09CA352Accident · No injuriesData collectionFinal reportCessna T210N · Corona, CAThe pilot's inadequate flare during touchdown, which resulted in a hard landing.NTSB WPR09CA331Accident · Minor injuriesData collectionFinal reportBell 47G-3B-2 · Ocean Shores, WAThe pilot's failure to maintain clearance from the water while maneuvering due to the pilot's diverted attention.NTSB ERA09LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Brinson, GAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA09LA383Accident · Minor injuriesLimited investigationFinal reportRans S5 Coyote · Greeneville, TNThe pilot's failure to maintain airspeed during a forced landing. Contributing to the accident was the loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.NTSB ERA09CA387Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Winder, GAThe pilot's failure to obtain the proper touchdown point during a practice forced landing, and the flight instructor's delayed decision to initiate a go-around.NTSB CEN09CA419Accident · No injuriesData collectionFinal reportCessna 182Q · Ballinger, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate pre-flight planning.NTSB ANC09LA064Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Skwentna, AKA fracture of the airplane's tailwheel shock absorber linkage during taxi, resulting in the collapse of the tailwheel.NTSB ANC09CA060Accident · Serious injuriesData collectionFinal reportBellanca 8GCBC · Sutton, AKThe pilot’s failure to maintain control of the airplane after an in-flight encounter with a downdraft in mountainous terrain, and his decision to fly at an altitude where such an encounter made a successful recovery unlikely.NTSB WPR09LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taylor, AZThe loss of engine power for undetermined reasons.NTSB WPR09CA332Accident · Minor injuriesData collectionFinal reportCessna 182M · Wilson Bar, IDThe pilot’s misjudged approach that led to a long landing and his failure to execute a go-around when he realized that he overshot his intended point of landing.NTSB CEN09IA416Incident · No injuriesIncident investigationFinal reportMooney M20J · Midland, TXThe pilot’s failure to ensure the airplane was properly configured, which resulted in a wheels-up landing.NTSB ANC09CA067Accident · No injuriesData collectionFinal reportCessna A185F · Skwentna, AKThe pilot's failure to recognize his proximity to the glassy water landing surface while flying in smoke haze, and his failure to maintain a proper descent rate during the landing approach.NTSB WPR09LA336Accident · Minor injuriesLimited investigationFinal reportThomas C. Piper Murphy Rebel · Idaho Falls, IDA total loss of engine power during initial climb due to fuel starvation. The underlying reason for the fuel starvation condition could not be determined.NTSB WPR09FA326Accident · 1 fatalField investigationFinal reportCessna 150 · South Lake Tahoe, CAA partial loss of engine power due to a malfunctioning carburetor and the pilot’s failure to maintain adequate airspeed while maneuvering to return to the runway. Contributing to the accident was the high density altitude.NTSB WPR09CA335Accident · No injuriesData collectionFinal reportCessna 180 · La Grande, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB WPR09CA329Accident · No injuriesData collectionFinal reportNalis Glastar · Arlington, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.NTSB WPR09CA328Accident · No injuriesData collectionFinal reportBoeing A75N1 · Gig Harbor, WAThe pilot's inadequate compensation for the crosswind and failure to maintain directional control.NTSB ERA09FA377Accident · 2 fatalField investigationFinal reportCessna 400 · Huntington, WVThe pilot's failure to maintain control of the airplane due to spatial disorientation.NTSB ERA09FA376Accident · 4 fatalField investigationFinal reportPilatus PC-12/45 · Raphine, VAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions following a reported instrumentation failure for undetermined reasons.NTSB ERA09CA381Accident · Serious injuriesData collectionFinal reportThompson David Challenger · Waymart, PAThe pilot's failure to maintain adequate airspeed during approach to land resulting in a stall.NTSB CEN09CA408Accident · Serious injuriesData collectionFinal reportCessna 150B · Conway, ARThe total loss of engine power for undetermined reasons.NTSB ANC09CA061Accident · No injuriesData collectionFinal reportAirborne Edge 582 T · Fairbanks, AKThe pilot's failure to maintain control of the airplane while on approach to land, resulting in an in-flight collision with terrain. Contributing to the accident was the pilot's lack of experience.NTSB WPR09LA325Accident · 2 fatalLimited investigationFinal reportAero Vodochody L-29 · Tehachapi, CAThe pilot’s failure to maintain clearance from terrain while performing a low altitude maneuver.NTSB ERA09LA384Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Ocean City, NJAn in-flight collision with birds during landing. Contributing to the accident was the airport's lack of a wildlife mitigation program.NTSB ERA09LA380Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Westerly, RIThe pilot's failure to use carburetor heat resulting in a complete loss of engine power due to carburetor icing.NTSB ERA09LA379Accident · No injuriesLimited investigationFinal reportCessna 172M · Princeton, NJThe partial loss of engine power for undetermined reasons.NTSB ERA09CA391Accident · No injuriesData collectionFinal reportCessna 172RG · Morristown, NJThe pilot's failure to maintain clearance from a parked aircraft during taxi operations.NTSB ERA09CA375Accident · Minor injuriesData collectionFinal reportWaco UPF-7 · Manteo, NCThe pilot's improper decision to exit the airplane, with the engine operating. Contributing to the accident was the inadvertent throttle movement by the passenger.NTSB CEN09LA424Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Racine, WIThe pilot's improper landing flare that resulted in a hard landing and subsequent separation of the airplane's sponson.NTSB CEN09CA510Accident · No injuriesData collectionFinal reportWohnoutka Steven M Team Z MAX · Iowa, LAA total loss of engine thrust during initial climb due to the failure of the airplane's propeller as a result of preexisting damage.NTSB CEN09CA406Accident · Serious injuriesData collectionFinal reportNorth American T-28B · Waxahachie, TXThe total loss of engine power for undetermined reasons.NTSB WPR09LA330Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Tracy, CAThe loss of engine power for undetermined reasons.NTSB WPR09LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Tucson, AZThe pilot’s failure to maintain directional and lateral aircraft control during takeoff. Contributing to the accident was the partial loss of left engine power for undetermined reasons.NTSB ERA09WA406Accident · Serious injuriesForeign investigationPiper PA-34-200T · Imperatrize, Maranhao, BrazilOn July 3, 2009, at 2146 UTC, a Piper PA-34-200T, PT-RFU, registered to and operated by Heringer Taxi Aereo LTD, as a cargo flight,lost engine power on one engine after takeoff from Imperatriz, Maranhao Airport, Brazil. The pilot attempted to return to the…NTSB ERA09LA378Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Loris, SCThe crew's failure to see and avoid a steel pole during a nighttime approach to the helipad.NTSB ERA09CA386Accident · No injuriesData collectionFinal reportChampion 7AC · Westminster, MDThe pilot's failure to properly set the throttle for start.NTSB ERA09CA382Accident · No injuriesData collectionFinal reportCessna 172H · Clifton, METhe pilot's mismanagement of his fuel supply which resulted in fuel starvation and a loss of engine power.NTSB CEN09LA415Accident · No injuriesLimited investigationFinal reportCessna 441 · Albuquerque, NMA malfunction of the landing gear selector switch and a loose fitting on the emergency extension system which rendered the landing gear system inoperable.NTSB CEN09LA409Accident · 1 fatalLimited investigationFinal reportCessna 172 · Latimer, IAThe pilot's failure to maintain clearance from the power line while flying at a low altitude.