NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 WPR10LA316Accident · No injuriesLimited investigationFinal reportMcGlashan T-51 Mustang · Columbia, CAA loss of engine power during approach due to thermal damage to the engine's electronic ignition module. Contributing to the accident was the builder’s placement of the ignition module near the engine’s exhaust.NTSB WPR10FA330Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Dixon, MTThe pilot’s failure to maintain adequate airspeed and aircraft control while maneuvering, resulting in an aerodynamic stall and collision with mountainous terrain.NTSB WPR10CA329Accident · No injuriesData collectionFinal reportCornett Steven M Glastar · Smiley Creek, IDThe pilot's decision to not use all available runway length and his delay in aborting the takeoff, which resulted in the airplane sliding off the end of the grass strip and colliding with a ditch.NTSB ERA10CA336Accident · No injuriesData collectionFinal reportSchooley Sonex · Punta Gorda, FLThe pilot's improper flare, resulting in a hard landing.NTSB CEN10CA357Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Harrison, ARThe pilot’s failure to maintain control of the balloon during landing.NTSB CEN10CA356Accident · No injuriesData collectionFinal reportBeech C23 · Eden Prairie, MNThe student pilot’s loss of airplane control while landing with gusting wind.NTSB CEN10CA354Accident · No injuriesData collectionFinal reportCessna 175 · Brainerd, MNThe pilot's loss of airplane control while taking off with gusting wind.NTSB WPR10FA315Accident · 1 fatalField investigationFinal reportAero Commander CallAir · Salt Lake City, UTThe pilot’s failure to maintain airspeed, which resulted in a stall/spin to the ground.NTSB WPR10CA348Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Moreno Valley, CAA total loss of engine power due to fuel exhaustion.NTSB ERA10CA334Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Gordonsville, VAThe student pilot’s failure to maintain directional control, and his excessive braking during the landing rollout.NTSB CEN10TA355Accident · No injuriesFinal reportLockheed P2V-5 · Broomfield, COThe pilot’s failure to follow published emergency procedures by taxiing to the parking ramp with a known hydraulic system failure. Contributing to the accident was the co-pilot’s improper selection of the bypass position on the emergency nose gear extension…NTSB CEN10LA351Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Indianapolis, INThe pilot's inability to maintain directional control during landing due to the airplane not being equipped with a steerable or locking tailwheel as required by the airplane's design.NTSB CEN10CA358Accident · No injuriesData collectionFinal reportCessna 180K · Cahokia, ILThe fatigue failure of the axle's attaching bolts during landing.NTSB CEN10CA352Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Lake Charles, LAThe flight instructor’s inadvertent entry into ground resonance when demonstrating a hydraulic failure running landing, which resulted in substantial damage to the helicopter. Contributing to the accident was the pilot's and instructor pilot's failure to…NTSB CEN10CA350Accident · No injuriesData collectionFinal reportAviat A-1B · Idabell, OKThe pilot's failure to maintain directional control during a go-around.NTSB CEN10CA347Accident · No injuriesData collectionFinal reportMooney M20F · Lubbock, TXThe student pilot's failure to maintain control during a go-around.NTSB WPR10WA321Accident · 1 fatalForeign investigationErickson S64E · Borneo Island, IndonesiaNTSB WPR10CA360Accident · No injuriesData collectionFinal reportMeyer MEYER-LEGACY · Burns, ORThe pilot's inadequate compensation for the wind conditions, resulting in a loss of lateral and directional control during takeoff.NTSB ERA10LA335Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Babylon, NYThe loss of engine power due to the failure of the oil filter gasket and the subsequent engine oil depletion.NTSB ERA10CA350Accident · No injuriesData collectionFinal reportCessna 172S · Salisbury, MDThe student pilot's improper recovery from a bounced landing.NTSB ERA10CA333Accident · No injuriesData collectionFinal reportQuartz Mountain Aerospace 11E · Inglis, FLA loss of engine power due to fuel exhaustion as a result of the pilot's fuel mismanagement.NTSB ERA10CA332Accident · No injuriesData collectionFinal reportCrabtree RV6 · Sewanne, TNThe pilot's improper recovery from a bounced landing.NTSB CEN10LA348Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Fremont, NEThe pilot’s loss of control for undetermined reasons.NTSB CEN10CA423Accident · No injuriesData collectionFinal reportAirborne Outback · Denver, COThe student pilot’s improper flare at touchdown.NTSB CEN10CA362Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Grand Junction, COThe total loss of engine power for undetermined reasons.NTSB CEN10CA346Accident · No injuriesData collectionFinal reportCessna 152 · St. Charles, MOThe pilot's improper takeoff procedure that led to a decreased climb rate and subsequent off-airport landing.NTSB CEN10CA344Accident · Serious injuriesData collectionFinal reportAir Creation GTE · Neenah, WIThe pilot's improper landing flare that resulted in a hard landing.NTSB WPR10TA318Accident · No injuriesFinal reportBell UH-1H · Santa Barbara, CAThe failure of left tailboom upper attachment fitting as a result of fatigue.NTSB WPR10LA313Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-1 · Port Orchard, WAA loss of engine power during initial climb due to water contamination in the fuel.NTSB CEN10CA436Accident · Minor injuriesData collectionFinal reportCessna 310C · Ashdown, ARThe pilot’s loss of directional control during the takeoff roll and his lack of experience in the airplane.NTSB CEN10CA342Accident · Minor injuriesData collectionFinal reportVans RV-12 · Salida, COThe pilot’s incorrect elevator trim setting and his inexperience in the airplane make/model.NTSB ANC10CA055Accident · No injuriesData collectionFinal reportCessna 180 · Cooper Landing, AKThe pilot's failure to maintain airspeed during takeoff, resulting in an uncontrolled descent and collision with terrain.NTSB WPR10LA312Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Parker, AZThe pilot's failure to maintain directional control while landing with a crosswind.NTSB WPR10LA310Accident · Serious injuriesLimited investigationFinal reportRice KR-2 · Richfield, UTA loss of engine power during initial climb due to a carburetor malfunction.NTSB WPR10CA314Accident · No injuriesData collectionFinal reportBell 206B · Rickreall, ORA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to ensure that adequate fuel was aboard for the flight.NTSB WPR10CA304Accident · No injuriesData collectionFinal reportCessna A185F · Bryce Canyon, UTThe pilot's inadequate compensation for the crosswinds during takeoff.NTSB ERA10LA328Accident · No injuriesLimited investigationFinal reportParks J L/Dreffin D Seawind 3000 · Sanibel Island, FLAn overstress failure of the elevator. Contributing to the accident was the owner/builder's modification of the experimental airplane beyond the recommendations of the kit manufacturer.NTSB CEN10RA337Accident · 7 fatalForeign investigationHawker Beechcraft A100 · Quebec City, CanadaOn June 23, 2010, approximately 0558 eastern daylight time, a Canadian-registered Hawker Beechcraft Corp. A100 multiengine airplane, C-FGIN, operated by Aeropro as Aeropro flight 20, was destroyed when it collided with terrain after takeoff from runway 30…NTSB CEN10LA339Accident · 1 fatalLimited investigationFinal reportAirborne Windsport Edge · Ft. Lupton, COThe pilot intentionally performed prohibited aerobatic maneuvers that damaged the carriage wing attachment hang point and collapsed the wing.NTSB WPR10LA308Accident · No injuriesLimited investigationFinal reportHughes 369HS · Paicines, CAAn in-flight fire for undetermined reasons.NTSB ERA10WA327Accident · Serious injuriesForeign investigationCessna · Pavacachi, EcuadorOn June 22, 2010, about 1345 universal time, a Cessna TU-206F, HC-BYA, registered to and operated by Servicio Aero Quichua De Pasta, as a cargo flight, initiated a descent in the vicinity of Pavacachi, Ecuador. Visual meteorological conditions prevailed and a…NTSB CEN10CA341Accident · No injuriesData collectionFinal reportCessna R182RG · Albuquerque, NMThe pilot's failure to lower the landing gear. Contributing to the accident was the pilot's distraction with an erroneous airspeed indicator.NTSB WPR10WA309Accident · 1 fatalClass 5 · ForeignCessna 172N · Broken Hill, AustraliaOn June 21, 2010, about 0145 coordinated universal time, a Cessna 172N, VH-UFN, registered to a private owner, collided with water during an unknown flight phase near Broken Hill, New South Wales (NSW), Australia. The airplane was reported missing and was…NTSB WPR10LA307Accident · 1 fatalLimited investigationFinal reportCessna 172N · Angels Camp, CAThe pilot’s failure to maintain airplane control while maneuvering.NTSB WPR10CA301Accident · No injuriesData collectionFinal reportCessna 180 · Big Creek, IDThe pilot’s failure to maintain directional control while taxiing at an unfamiliar airstrip.NTSB ERA10LA323Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Asheville, NCThe pilot's failure to maintain forward airspeed, which resulted in a settling with power encounter.NTSB ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…NTSB ERA10CA324Accident · No injuriesData collectionFinal reportCessna 150G · Jasper, TNThe pilot under instruction's failure to maintain directional control during landing, and his failure to relinquish the flight controls when directed.NTSB CEN10LA335Accident · No injuriesLimited investigationFinal reportCessna 525A · Storm Lake, IAThe pilot’s decision to land on a water contaminated runway, which resulted in a runway excursion during the landing roll. Contributing to the accident was the pilot’s lack of knowledge regarding the landing distance required and the limited braking…NTSB CEN10LA334Accident · 1 fatalLimited investigationFinal reportDrone Paul E Pulsar III · Carmi, ILThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.