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 CEN13CA282Accident · No injuriesData collectionFinal reportCessna 172RG · Abbeville, LAThe pilot's failure to properly secure the airplane before hand starting the engine and the failure of the brass tie down hook.NTSB WPR13LA230Accident · No injuriesLimited investigationFinal reportCessna T188C · Pine Bluffs, WYThe loss of engine power during takeoff 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 WPR13CA231Accident · No injuriesData collectionFinal reportCessna 182P · Carson City, NVThe pilot's failure to maintain aircraft control after an encounter with downdrafts while flying over mountainous terrain.NTSB CEN13CA281Accident · No injuriesData collectionFinal reportHughes 369D · Camdenton, MOThe piece of wood/tree that contacted the main rotor blade during the low altitude tree-trimming flight.NTSB WPR13CA246Accident · No injuriesData collectionFinal reportCessna U206G · Friday Harbor, WAA collision with a bird while on the downwind leg of the traffic pattern.NTSB ERA13CA246Accident · No injuriesData collectionFinal reportCessna 152 · Oxford, NCThe student pilot’s improper flare, which resulted in a hard landing.NTSB ERA13CA245Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23H-15 · Yadkinville, NCThe pilot's improper altitude management while maneuvering for an off-airport landing, which resulted in a collision with trees.NTSB CEN13LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Galena, KSThe loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.NTSB CEN13CA289Accident · No injuriesData collectionFinal reportCessna 172S · Ankeny, IAThe student pilot's improper flare which resulted in a hard landing.NTSB WPR13FA227Accident · No injuriesField investigationFinal reportGates Learjet 35A · McMinnville, ORFailure of maintenance personnel to reattach the landing gear squat switches following maintenance, which rendered the airplane's steering, braking, and thrust reverser systems inoperative during landing. Contributing to the accident were the failure of both…NTSB ERA13LA241Accident · No injuriesLimited investigationFinal reportCessna 182E · Southwick, MAThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any malfunctions or failures that would have precluded normal operation.NTSB ERA13CA244Accident · No injuriesData collectionFinal reportCessna 170B · Roxboro, NCThe pilot’s excessive use of wheel brakes while turning off the runway after landing resulting in a noseover.NTSB CEN13CA279Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Meriden, KSThe pilot electing to land at an airport with a runway environment that precluded a go-around with the tailwind weather conditions present which resulted in a runway excursion during the landing.NTSB ANC13CA045Accident · No injuriesData collectionFinal reportPiper PA-18A · Nikiski, AKThe pilot's failure to maintain directional control during landing, resulting in contact with terrain, and a ground loop.NTSB ERA13CA272Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-55-1 · Henderson, NCA loss of aerodynamic lift that resulted in a forced landing to unsuitable terrain.NTSB CEN13CA290Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Pella, IAThe pilot's failure to maintain directional control during landing.NTSB ERA13LA238Accident · No injuriesLimited investigationFinal reportSteele Ralph Bruce Steen Skybolt · Windsor, NCThe pilot's decision to initiate an aerobatic maneuver with insufficient altitude to recover before ground impact.NTSB ERA13CA240Accident · No injuriesData collectionFinal reportPiper PA-44-180T · Loxahatchee, FLAn in-flight collision with a bird.NTSB DCA13CA090Accident · Serious injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170-200 LR · Flushing, NYThe flight attendant's decision to move two galley carts simultaneously that resulted in the second cart tipping over onto her foot.NTSB CEN13WA271Accident · 1 fatalClass 5 · ForeignCirrus Design SR22 · Aix, FranceOn May 11, 2013, at 1422 universal coordinated time (UTC), a Cirrus SR22, F-HTAV, impacted terrain near Aix, France. The pilot was fatally injured and two passengers received minor injuries. The airplane was substantially damaged. The flight originated from…NTSB CEN13LA304Accident · Minor injuriesLimited investigationFinal reportAnkestar, Bradley D. RAND-ROBINSON KR2 · Hamilton, OHThe loss of engine power due to vapor lock in the fuel system. Contributing to the accident was the operation of the airplane with automotive gasoline and the installation of noninsulated fuel components near heat sources in the engine compartment.NTSB CEN13CA278Accident · No injuriesData collectionFinal reportBalloon Works Firefly 8B-15 · Anthony, KSThe pilot’s failure to monitor the balloon's altitude, which resulted in the balloon impacting an airport rotating beacon tower.NTSB CEN13CA277Accident · No injuriesData collectionFinal reportCessna 140 · Groesbeck, TXThe pilot's failure to maintain control of the airplane during an aborted takeoff.NTSB WPR13IA226Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Phoenix, AZThe failure of the tug operator and wing walker to adequately monitor the environment during pushback of the airplane from the gate in preparation for flight, which led to the collision of the airplane with an adjacently parked airplane.NTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB ERA13LA236Accident · No injuriesLimited investigationFinal reportBell 206B · Hartford, KYThe pilot’s failure to avoid a powerline that crossed a field that he was spraying. Contributing to the collision was the company’s failure to specifically mention that flight hazards be identified during a pre-work conference.NTSB DCA13CA088Accident · No injuriesData collectionFinal reportGeneral Atomics MQ-9 · Cocoa Beach, FLan improper flare leading to a nose-wheel first touchdown, which resulted in a pilot induced oscillation (PIO). The PIO caused the UAS to pitch up abruptly on the third nose gear contact with the runway, resulting in the separation of the nose wheel assembly…NTSB CEN13LA273Accident · Serious injuriesLimited investigationFinal reportPhillips Zenith 250 · Taos, NMThe pilot’s improper decision to take off in gusting wind conditions and the airplane’s loss of climb performance following an encounter with turbulence and downdrafts.NTSB CEN13CA276Accident · No injuriesData collectionFinal reportBell 206-L4 · Fort Worth, TXThe flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB WPR13LA223Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Biggs, CAThe pilot’s failure to adequately monitor the runway environment during taxi, which resulted in an on-ground collision.NTSB WPR13LA222Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Honolulu, HIThe mechanic’s failure to properly inspect the helicopter following maintenance performed by an apprentice, which resulted in a total loss of engine power due to the improper rigging of the mixture control assembly.NTSB ERA13TA237Accident · No injuriesFinal reportBell OH-58C · Jekyll Island, GAThe pilot's failure to maintain rotor rpm in the normal operating range during a practice autorotation, which resulted in a hard landing. Contributing to the accident was the inadequate supervision by the flight instructor.NTSB ERA13LA239Accident · No injuriesLimited investigationFinal reportCessna 182G · Clewiston, FLThe private pilot’s inadequate preflight planning and fuel management and the flight instructor’s inadequate supervision, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA13CA235Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jacksonville, NCThe student pilot's failure to maintain adequate airspeed during the go-around attempt, which resulted in an aerodynamic stall and collision with the ground.NTSB ERA13CA234Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Selma, NCThe instructor pilot’s inadequate visual lookout, which resulted in a collision with power lines and then the ground.NTSB DCA13CA091Accident · Serious injuriesData collectionFinal reportAirbus 320 · Dallas, TXThe flight attendant's inadvertent trip over the jumpseat that had not retracted automatically.NTSB CEN13LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT-302 · Winnie, TXThe improper decision by the pilot to attempt a flight with a known fuel system-related maintenance discrepancy, which resulted in a fuel imbalance and subsequent fuel starvation during an approach to an alternate airport with a rough field. Contributing to…NTSB CEN13FA269Accident · 2 fatalField investigationFinal reportCessna 182T · Fredericksburg, TXThe pilot’s failure to maintain airspeed while transitioning from instrument to visual flight while still in instrument conditions, which resulted in an inadvertent stall.NTSB CEN13CA272Accident · No injuriesData collectionFinal reportCessna 172M · Thief River Falls, MNThe pilot’s failure to maintain clearance from the power line while on approach to landing.NTSB ANC13WA047Accident · 2 fatalForeign investigationErickson Air Crane S-64E · Keongbuk, South KoreaOn May 9, 2013, about 0938 local time, a Korean registered Erickson Air-Crane S-64E helicopter, HL9467, crashed in a lake near the Andong Dam, Kyeongbuk Province, South Korea. The helicopter was owned and operated by the Korean Forest Service. The pilot and…NTSB WPR13LA238Accident · No injuriesLimited investigationFinal reportCessna 310R · Bakersfield, CAThe failure of the right main landing gear link assembly, which resulted in the right main landing gear collapsing during landing.NTSB ERA13LA242Accident · No injuriesLimited investigationFinal reportSud SA 318C · South Bay, FLThe pilot’s failure to maintain proper rotor rpm while hovering in sideways flight.NTSB CEN13WA275Accident · 1 fatalForeign investigationCessna 172P · Den Helder, NetherlandsOn May 8, 2013, about 0645 hours universal coordinated time, a Cessna 172P, Dutch registration PH-ACM, impacted the North Sea near Den Helder, Netherlands, during a photo reconnaissance flight. The pilot was fatally injured. The passenger (photographer) was…NTSB CEN13LA265Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lyons, KSThe pilot's diverted attention after the door hinge failed and a piece of door glass struck the pilot, resulting in the airplane's descent into the crops and impact with terrain.NTSB WPR13CA219Accident · Serious injuriesData collectionFinal reportPiper PA-28 · Cottonwood, AZThe student pilot's decision to attempt a night landing on an unlit runway, which resulted in a misaligned approach and subsequent collision with a fence. Contributing to the accident was the student pilot's improper set-up of the airplane radios, which…NTSB ERA13CA233Accident · Minor injuriesData collectionFinal reportHughes Charles R Zodiac 601XL · Meriden, CTThe pilot's decision to land with a tailwind and his failure to maintain aircraft control during landing.NTSB CEN13LA310Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · La Junta, COThe pilot's inadequate compensation for wind during low-altitude operations, which resulted in a loss of tail rotor effectiveness.NTSB CEN13LA260Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Lyons, KSThe partial loss of engine power due to fuel contamination, which resulted in impact with terrain. Contributing to the accident was the pilot's inadequate preflight inspection, during which he failed to detect the fuel contamination.NTSB CEN13CA266Accident · No injuriesData collectionFinal reportCessna 140 · Glenwood Springs, COThe pilot's failure to maintain airplane control during the landing roll and his excessive use of right brake, which resulted in a noseover.NTSB ANC13CA044Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.