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 CEN13LA484Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Larchwood, IAA complete loss of engine power during an agricultural application flight for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB ANC13CA078Accident · No injuriesData collectionFinal reportPiper PA-18-150 · McCarthy, AKThe pilot's loss of directional control during takeoff.NTSB WPR13CA367Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Hesperia, CAThe pilot’s failure to maintain sufficient airspeed on final approach to landing which resulted in an inadvertent stall.NTSB ERA13LA361Accident · No injuriesLimited investigationFinal reportBryant Frederick M Rans S-12 · Vienna, MDThe student pilot’s inadequate control of the airplane, which resulted in an aerodynamic stall and subsequent impact with water.NTSB ERA13LA360Accident · Minor injuriesLimited investigationFinal reportQuest Kodiak 100 · Westport, MAA failure to achieve a positive climb rate after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB ERA13CA369Accident · No injuriesData collectionFinal reportMaule M-5-210C · Verona, NYThe pilot’s delay in applying power after a bounced landing, resulting in collision with terrain during a go-around.NTSB CEN13WA492Accident · 1 fatalForeign investigationAerostar International S-55A · Mont-St-Grégoire, CanadaOn August 11, 2013, at 0730 eastern daylight time, an Aerostar International Inc. model S-55A, United States registration N25QL, serial number S55A1-1017, was not damaged when a member of the balloon ground-support team was fatally injured after falling to…NTSB CEN13FA476Accident · 2 fatalField investigationFinal reportBeechcraft F33A · Ennis, TXThe loss of engine power for reasons that could not be determined during postaccident examinations due to postcrash fire damage.NTSB WPR13LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Overgaard, AZThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow. Contributing to the accident was inadequate maintenance of the exhaust system.NTSB WPR13CA375Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot’s improper flare, which resulted in a hard landing.NTSB WPR13CA365Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Independence, ORThe pilot's improper flare with a crosswind condition, and unsuccessful attempt to correct a bounced landing, which resulted in a runway excursion and subsequent nose over.NTSB CEN13LA487Accident · No injuriesLimited investigationFinal reportBell 206B · Albers, ILFuel contamination, which resulted in the loss of engine power.NTSB CEN13LA478Accident · No injuriesLimited investigationFinal reportDouglas Brian G BA-100 · Killeen, TXThe pilot’s improper management of the fuel mixture, which resulted in an over-rich fuel mixture condition and a subsequent partial loss of engine power.NTSB CEN13CA510Accident · No injuriesData collectionFinal reportErcoupe 415-C · Mackinac Island, MIThe pilot's failure to maintain aircraft control while on final approach.NTSB CEN13CA481Accident · No injuriesData collectionFinal reportSuper 18 S18-STD · Humboldt, SDThe pilot's inadvertent addition of water into the fuel system and his improper preflight inspection, which resulted in a loss of engine power due to fuel contamination.NTSB CEN13CA479Accident · Minor injuriesData collectionFinal reportKerr Matthew Starduster TOO · Frankenmuth, MIThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and subsequent impact with a corn field.NTSB CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.NTSB ERA13FA358Accident · 4 fatalField investigationFinal reportRockwell International 690B · East Haven, CTThe pilot's failure to maintain airspeed while banking aggressively in and out of clouds for landing in gusty tailwind conditions, which resulted in an aerodynamic stall and uncontrolled descent.NTSB CEN13WA576Accident · No injuriesForeign investigationSocata TB10 - NO Series · Zamora, SpainOn August 9, 2013, about 0930 UTC, a Socata TB-10 airplane, EC-FPN, (s/n 1485) was involved in a forced landing following an engine failure. The airplane was substantially damaged and there were no injuries. This investigation is under the jurisdiction and…NTSB CEN13LA486Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Dumas, ARThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN13LA482Accident · No injuriesLimited investigationFinal reportGlos Wallis Richard JR LONG-EZ · Schaumburg, ILThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.NTSB ANC13CA077Accident · No injuriesData collectionFinal reportAviat A-1B · Arctic Village, AKThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.NTSB WPR13LA364Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Burlington, WAThe pilot's inadequate control inputs during a crosswind landing, which resulted in a hard landing and loss of directional control.NTSB WPR13CA369Accident · No injuriesData collectionFinal reportCessna 172RG · Kent, WAFailure of the certified flight instructor and student pilot to complete the landing checklist resulting in a gear-up landing.NTSB CEN13WA480Accident · 3 fatalForeign investigationSocata TBM-700 · Vertaizon, FranceNTSB ANC13TA076Accident · No injuriesFinal reportBell UH-1B · Tok, AKThe failure of the tail rotor crosshead bearing, which resulted in a loss of tail rotor control.NTSB ANC13CA075Accident · No injuriesData collectionFinal reportCessna 185D · North Pole, AKThe malfunction of the right main wheel brake during taxi due to a faulty O-ring in the right brake pedal master cylinder.NTSB ENG13WA040Incident · No injuriesForeign investigationSikorsky S76 - A · Macae, BrazilWhile the helicopter was running on the runway, the pilots noticed that the number two engine parameters were below prescribed values and decided to abort the take-off. After leaving the runway and entering the company apron, the pilots saw company mechanics…NTSB CEN13WA471Accident · 2 fatalForeign investigationBeech B200 · Akureyri, IcelandOn August 7, 2013, at 1328 coordinated universal time, a Hawker Beechcraft Corporation, B200, multi-engine airplane, TF-MYX, was destroyed when it impacted terrain near Akureyri Airport, (BIAR), Akureyri, Iceland. The three crewmembers were fatally injured.…NTSB CEN13WA468Accident · No injuriesForeign investigationCessna F172N · Heist, GermanyOn August 7, 2013, about 0935 coordinated universal time, a Cessna F172N, registered D-EGUP, operated as a pleasure flight, was destroyed when it impacted terrain near Heist, Germany, following a loss of control. The pilot and passenger were fatally injured.…NTSB CEN13CA474Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Clare, MIThe flight instructor's failure to adequately monitor the landing approach, his delayed corrective action and his failure to maintain directional control that resulted in the airplane's collision with a ditch adjacent to the runway. The student pilot's…NTSB ERA13WA359Accident · 2 fatalForeign investigationRobinson R-44 · Davidovo, RussiaOn August 6, 2013, at 1506 coordinated universal time (August 7, 2013, 0006 local time), an emergency locator beacon signal was detected for a Robinson R44, RA-06302, which was subsequently found destroyed on rising terrain about 7 nautical miles southwest of…NTSB ERA13CA354Accident · No injuriesData collectionFinal reportStetson Norman B Challenger II · Orange, MAThe pilot’s failure to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of total flight experience in the accident airplane make and model.NTSB CEN13LA464Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Santa Teresa, NMThe pilot’s failure to maintain clearance from a tree at the completion of an agricultural spray run. Contributing to the accident was the pilot’s decision to accept a high level of risk to spray a small field bordered by multiple obstacles and his fatigue…NTSB CEN13LA463Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Vinton, IAThe pilot's operation of the helicopter at high gross weight and high density altitude while still in ground effect, which reduced the efficiency of the rotor system and the amount of lift produced, which resulted in a collision with terrain. Contributing to…NTSB ANC13LA074Accident · No injuriesClass 3 · LimitedFinal reportHughes 500D · Delta Junction, AKA total loss of engine power for undetermined reasons, which necessitated an emergency hovering autorotation, during which the helicopter impacted trees and terrain.NTSB WPR13LA360Accident · No injuriesLimited investigationFinal reportVersteeg Helicycle · Richland, WAThe pilot’s failure to maintain helicycle control during hover due to an inadvertent control input.NTSB CEN13LA462Accident · No injuriesLimited investigationFinal reportEmbraer S A EMB-505 · Eden Prairie, MNThe flight crew's failure to execute a go-around during a non-stabilized approach, which resulted in a runway overrun.NTSB CEN13LA461Accident · 2 fatalLimited investigationFinal reportHughes 369D · Ackerly, TXThe pilot’s failure to identify and maintain adequate clearance from a shield wire that was suspended between power transmission line towers.NTSB CEN13FA465Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Balko, OKThe pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.NTSB CEN13CA469Accident · No injuriesData collectionFinal reportCessna 182T · Mackinac Island, MIThe pilot's delayed response to abort the takeoff, which resulted in an excursion and collision with a fence. Contributing to the accident was the pilot's failure to check the pitot tube for debris during preflight.NTSB ANC13CA073Accident · No injuriesData collectionFinal reportCessna U206F · Kokhanok, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.NTSB WPR13LA359Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Stanwood, WAThe pilot’s unstabilized approach and his subsequent failure to maintain airspeed during the aborted landing, which resulted in a stall and the airplane bouncing hard on the runway.NTSB WPR13LA358Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chualar, CAMaintenance personnel's failure to properly tighten the bolts securing the main driveshaft to the transmission, which resulted in fatigue failure of the bolts and disconnection of the driveshaft during low-altitude flight.NTSB WPR13CA377Accident · No injuriesData collectionFinal reportAviat A-1B · West Jordan, UTThe pilot’s failure to maintain directional control during landing.NTSB ERA13WA387Accident · 1 fatalForeign investigationEmbraer 711ST · Paragominas, BrazilOn August 4, 2013, about 2230 universal coordinated time, an Embraer EMB-711ST (Piper PA-28RT-201T), Brazilian registration PT-RHI, operated by a private individual, was substantially damaged when it impacted terrain while on approach to the Aeroporto de…NTSB ERA13LA363Accident · No injuriesLimited investigationFinal reportMooney M20R · Tallahassee, FLThe pilot's failure to troubleshoot the in-flight electrical problem and restore power using the operable redundant battery and his decision not to manually extend the airplane's landing gear, which resulted in a gear-up landing. Contributing to the accident…NTSB ERA13FA349Accident · 2 fatalField investigationFinal reportBeech A36 · Alma, GADescent from cruise flight until impact with trees and the ground for reasons that could not be determined because postaccident examination of the wreckage did not reveal any anomalies that would have precluded normal operation and the pilot's autopsy and…NTSB ERA13CA357Accident · No injuriesData collectionFinal reportPiper PA-34-200T · West Mifflin, PAThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA13CA352Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Erwinna, PAThe student pilot's improper altitude and energy management in the landing pattern which resulted in the glider impacting a tree and landing short of the runway.