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 ERA14CA205Accident · Minor injuriesData collectionFinal reportCirrus Design SR20 · Sanford, FLThe student pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was his failure to compensate for torque, P-factor, and the reported crosswind conditions.NTSB CEN14LA221Accident · No injuriesLimited investigationFinal reportAmerican AA 1 · Peyton, COThe loss of directional control during takeoff for reasons that could not be determined due to the extent of fire damage.NTSB CEN14CA209Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Put in Bay, OHAn inflight collision with a goose while on an approach.NTSB ERA14CA203Accident · Minor injuriesData collectionFinal reportEvolution Revo · Concord, NHThe student pilot's failure to maintain control during a go around, which resulted in a collision with terrain.NTSB CEN14WA206Accident · 7 fatalForeign investigationSui RY, Laurinen Janne, KääRiä Comp AIR 8 · Jamijarvi, FinlandOn April 20, 2014, at 1240 UTC, a Comp Air 8, Finnish registration OH-XDZ, was destroyed when it departed controlled flight and subsequently impacted in a forest near Jamijarvi Airfield (EFJM), Jamijarvi, Finland. A post-impact fire ensued. Eight of the 10…NTSB CEN14RA212Accident · 8 fatalForeign investigationBritish Aerospace HS 125 700A · Saltillo, MexicoOn April 19, 2014, about 1945 hours central daylight time, a British Aerospace HS 125 700A, XA-UKR, impacted an industrial complex and terrain while on final approach to Plan de Guadalupe International Airport (SLW), near Saltillo, Mexico. A postimpact ground…NTSB ERA14CA267Accident · No injuriesData collectionFinal reportChampion Aeronca 7AC · Port Gibson, MSThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was sun glare.NTSB ERA14CA204Accident · No injuriesData collectionFinal reportCessna A185E · Somerville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind.NTSB CEN14LA210Accident · No injuriesLimited investigationFinal reportRockwell International 114 · Sturgis, MIA cracked nose landing gear pulley, which resulted in the binding of the nosewheel steering system.NTSB CEN14LA202Accident · 2 fatalLimited investigationFinal reportNanchang CJ6 - A · Flushing, MIThe pilot’s failure to maintain adequate airspeed during an off-airport forced landing after a loss of engine power due to carburetor icing and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to…NTSB CEN14CA242Accident · No injuriesData collectionFinal reportCessna 170A · Huron, SDThe pilot's inadequate flare resulting in a hard landing.NTSB CEN14CA215Accident · Serious injuriesData collectionFinal reportFirefly 8B-15 · Security, COAn unexpected increase in wind velocity which resulted in a hard landing and the subsequent passenger injury.NTSB CEN14CA207Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Bloomington, INThe pilot did not maintain control of the airplane while landing.NTSB CEN14CA203Accident · Minor injuriesData collectionFinal reportPiper PA-28 · Kalamazoo, MIAn inadvertent stall during gusting crosswind conditions.NTSB WPR14LA253Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Santa Monica, CAThe fracture of the right aft landing gear strut due to undetected fatigue cracking in an inboard rivet hole.NTSB ERA14LA202Accident · No injuriesLimited investigationFinal reportOconnor Paul A Ultimate Aero 10-200 · Saint Albans, VTThe propeller blade’s failure due to fatigue cracks that initiated from pitch change pin attachment holes that had been drilled too deep during manufacture.NTSB CEN14LA205Accident · 1 fatalLimited investigationFinal reportQuicksilver GT400 · Hillsboro, KSThe pilot’s failure to maintain control of the unregistered airplane in gusting wind conditions.NTSB CEN14LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Searcy, ARThe pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.NTSB CEN14LA200Accident · Serious injuriesLimited investigationFinal reportCessna O 1E · Fredericksburg, TXThe loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB WPR14CA168Accident · Minor injuriesData collectionFinal reportLinstrand 240A · Mayer, AZThe balloon's encounter with unexpected increased wind, which resulted in a hard landing on rough terrain.NTSB ERA14CA200Accident · No injuriesData collectionFinal reportKaldor Gregory N Zenith 701 · Eutaw Springs, SCThe pilot's improper decision to execute a precautionary landing to unsuitable terrain following an inflight encounter with a wind gust, resulting in substantial damage to the airplane.NTSB WPR14FA167Accident · 1 fatalField investigationFinal reportSands Helicycle · Reno, NVThe pilot’s failure to maintain control of the helicopter while in the traffic pattern.NTSB WPR14CA170Accident · No injuriesData collectionFinal reportPiper PA 18S-150 · Browning, MTThe pilot's failure to maintain directional control during the landing roll which resulted in a veer off the airstrip and collision with a ditch.NTSB ERA14LA199Accident · Serious injuriesLimited investigationFinal reportAircraft Industries A.S. L33 Solo · Bunn, NCThe pilot’s failure to maintain airspeed while approaching the airport, which resulted in a stall/mush.NTSB ERA14LA198Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Aguas Buenas, PRThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14FA198Accident · 1 fatalField investigationFinal reportBeech C24 · Denton, TXThe pilot mistakenly manipulated the airplane's mixture knob rather than the propeller control knob during the descent, reducing the airplane's mixture knob to where the fuel-air mixture to the engine was too lean, which caused the engine to fail, and the…NTSB WPR14WA191Accident · 1 fatalForeign investigationMaule M-5-235C · Lismore Aerodrome, Australia, AustraliaOn April 12, 2014, at 1230 universal coordinated time, a Maule M-5-235C, VH-HOG, struck a power line and subsequently impacted terrain near Lismore Aerodrome, Australia. The airplane was operated by the pilot under the pertinent civil regulation of the…NTSB WPR14CA166Accident · Serious injuriesData collectionFinal reportPiper PA 18-135 · Kent, ORThe pilot's failure to maintain aircraft control during takeoff.NTSB ERA14CA201Accident · No injuriesData collectionFinal reportWSK PZL Mielec M 18A · Blountstown, FLThe pilot's inadequate compensation for the tailwind conditions and failure to maintain directional control during landing.NTSB CEN14LA199Accident · Serious injuriesLimited investigationFinal reportErcoupe 415 C · Cookson, OKThe pilot’s failure to properly secure the primer, which resulted in the loss of engine power during takeoff.NTSB CEN14LA195Accident · No injuriesLimited investigationFinal reportLarsen Mark V · Amelia, OHThe distributor failure, which resulted in a total loss of engine power during cruise climb.NTSB WPR14FA165Accident · 1 fatalField investigationFinal reportWilliams Myron G Bowers FLY Baby 1A · Mariposa, CAThe partial loss of engine power due to an improperly maintained carburetor and the pilot's subsequent failure to maintain aircraft control.NTSB ERA14LA193Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Louisa, VAThe pilot's decision to continue operation of the airplane with known mechanical issues (fluctuating oil pressure and metal in the oil filter), which was the result of undertorqued cylinder through bolts. Contributing to the accident was the mechanic's…NTSB ERA14FA192Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Hugheston, WVThe pilot's loss of airplane control while operating in instrument flight rules conditions.NTSB ERA14CA197Accident · No injuriesData collectionFinal reportCessna 162 · Leesburg, FLThe student pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN14LA196Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · West Chicago, ILThe failure of the nose gear actuator attachment to the engine mount due to overstress, which resulted in the loss of directional control during landing.NTSB WPR14WA189Accident · 1 fatalForeign investigationBell 407 · Beijing, P.R. China, ChinaOn April 10, 2014, at 0323 universal coordinated time, a Bell 407GX, B-7475, was substantially damaged when it impacted water under unknown circumstances near Beijing, P.R. China. The helicopter was operated by Eastern General Aviation Limited Corporation…NTSB WPR14CA163Accident · No injuriesData collectionFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain directional control during a takeoff, which resulted in the airplane veering off the runway surface and colliding with a sign.NTSB ERA14CA195Accident · No injuriesData collectionFinal reportCessna 140 · Colebrook, NHThe pilot's decision to power out of soft snow with a gusty quartering tailwind which resulted in the tail of the airplane rising and the airplane nosing over.NTSB ERA14CA190Accident · Minor injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Tavares, FLThe pilot's improper landing flare resulting in a bounced landing and his delay in performing a go around which resulted in a collision with trees.NTSB WPR14WA164Accident · 2 fatalForeign investigationQuest Kodiak · Jayapura, Papua, Indonesia, IndonesiaOn April 9, 2014, at 0025 universal coordinated time, a Quest Aircraft Company, Kodiak-100, PK-SDF, during takeoff from Doyo Baru Airstrip, Jayapura, Papua, Indonesia, the airplane lost altitude and struck the airport fence and subsequently came to rest on a…NTSB CEN14LA192Accident · 1 fatalLimited investigationFinal reportAerotrike Safari · Littlefield, TXThe non-certificated pilot's in-flight loss of control for reasons that could not be determined from the available evidence.NTSB CEN14FA193Accident · Minor injuriesField investigationFinal reportAirbus AS350 B3E · Albuquerque, NMThe pilot's loss of yaw control during takeoff due to the absence of hydraulic boost to the tail rotor pedals for reasons that could not be determined based on the available information. A finding in the accident was the lack of a caution indicator to alert…NTSB WPR14LA161Accident · 1 fatalLimited investigationFinal reportNorthwing Apache Sport · Brigham City, UTThe pilot’s failure to maintain aircraft control while maneuvering near power lines.NTSB WPR14CA162Accident · No injuriesData collectionFinal reportCessna 207 · Shaw Island, WAThe pilot's loss of directional control during the landing flare with a gusting tailwind.NTSB ERA14CA189Accident · No injuriesData collectionFinal reportMoore Thomas O Zenith Stol CH701 · Frostproof, FLThe pilot's failure to maintain directional control during a precautionary landing. Contributing to the accident was the pilot's delayed decision to divert due to deteriorating weather.NTSB ERA14CA185Accident · No injuriesData collectionFinal reportCessna 205A · Leesburg, VAThe pilot's inadequate compensation for the wind conditions during landing, resulting in a runway excursion and impact with terrain. Contributing to the accident was the pilot's inadequate evaluation of the wind conditions.NTSB CEN14CA191Accident · No injuriesData collectionFinal reportCessna 172S · Albuquerque, NMThe student pilot's improper flare that resulted in a bounced landing.NTSB ANC14FA022Accident · 2 fatalField investigationFinal reportCessna 208B · Kwethluk, AKThe check airman's delayed remedial action and initiation of a recovery procedure after a simulated pitch trim excursion, which resulted in a loss of airplane control.NTSB ERA14CA184Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe inadvertent encounter with a microburst during taxi from landing that resulted in the aircraft being turned over inverted and receiving substantial damage.