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 SEA95FA214Accident · 3 fatalField investigationFinal reportAgusta A109A II · Winslow, WAthe pilot failed to maintain sufficient altitude/clearance above the surface of water, while flying over calm water conditions at night. Factors relating to the accident were: darkness, low ceiling, fog, glassy (calm) water conditions, and the lack of visual…NTSB LAX95LA333Accident · No injuriesLimited investigationFinal reportBeech 23 · Las Vegas, NVthe loss of engine power for undetermined reasons. The soft and rough nature of the terrain available for the forced landing was a factor in the accident.NTSB FTW95LA389Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Salida, COFailure by the pilot to adequately plan the flight and the aircraft altitude capability. Factors are: high altitude, high density altitude, inadequate training in mountain flying, and lack of familiarity with the geographic area.NTSB FTW95LA388Accident · No injuriesLimited investigationFinal reportBeech A36 · Broomfield, COThe pilot's inadequate compensation for the wind conditions, and his failure to maintain proper alignment with the runway after lift-off. A factor relating to the accident was: the unfavorable wind condition (gusty crosswind).NTSB CHI95LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lyons, WIThe pilot's lack of experience in the type of operation being conducted, the pilot not maintaining the proper airspeed while on final approach to landing, and a delayed decision to abort the landing.NTSB SEA95LA215Accident · No injuriesLimited investigationFinal reportSocata Rallye 150 ST · Yakima, WAThe pilot's inadequate compensation for wind conditions. The downdraft was a factor.NTSB SEA95LA203Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20B · Ephrata, WAThe pilot's failure to maintain clearance from from the fence post. The sunglare was a factor.NTSB SEA95FA213Accident · 1 fatalField investigationFinal reportCessna P210N · Black Diamond, WAimproper maintenance which led to oil starvation due to a inadequately tightened B-nut in an oil line. A factor was the lack of suitable terrain for a forced landing.NTSB NYC95MA220Accident · 12 fatalMajor investigationFinal reportBeech 65 · West Point, VAThe pilot's inadequate preflight/preparation, his failure to ensure proper weight and balance of the airplane, and his failure to obtain/maintain minimum control speed, which resulted in a loss of aircraft control after loss of power in one engine. A factor…NTSB NYC95FA221Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Akron, OHthe pilot's failure to maintain control of the rotor RPM, and his improper remedial action, which resulted in the rotor stalling. A contributing factor was the pilot's lack of recent experience in helicopters, and his lack of total experience in make and…NTSB MIA95LA220Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF.260TP · Lakeland, FLWater contamination in the fuel, and an inadequate preflight inspection by the pilot, which resulted in a loss of engine power.NTSB MIA95LA219Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sarasota, FLThe pilot's failure to abort the takeoff resulting in a premature takeoff, and subsequent in-flight collision with terrain. The pilot's failure to perform the necessary performance data computations for the flight and his diverted attention due to…NTSB MIA95IA243Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · New Smyrna Bch, FLfatigue failure of the piston assembly (piston and piston pin).NTSB LAX95LA332Accident · 1 fatalLimited investigationFinal reportEnstrom F-28C · Livermore, CAthe pilot's inadequate preflight fuel load determination procedures which resulted in fuel exhaustion. In addition, the pilot's delayed and improper use of the collective and cyclic flight controls following the engine failure led to his failure to maintain…NTSB LAX95LA331Accident · No injuriesLimited investigationFinal reportBell 47G-3B2 · Yuma, AZthe failure of the pilot and company maintenance personnel to detect a crack in the clevis ears during the required daily inspection and the recent annual inspection. A factor in the accident was the improper welding and stress relief procedure used to…NTSB FTW95LA387Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cibolo, TXThe pilot's improper planning/decision and failure to abort the takeoff, while there was sufficient runway remaining.NTSB CHI95LA318Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Belvidere, ILinadequate visual lookout by the pilots of both airplanes, which resulted in failure of each pilot to see-and-avoid the other airplane.NTSB ATL95LA167Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mooresville, NCThe pilot's improper use of the carburetor heat resulting in the formation of carburetor ice and subsequent loss of engine power.NTSB ANC95TA166Accident · Serious injuriesFinal reportBell 206B · Glennallen, AKThe pilot's improper in-flight planing/decision and inadequate supervision of the passenger, which allowed the helicopter's lateral center-of-gravity to be exceeded. Factors relating to the accident were: pressure (compelling influence) on the pilot and…NTSB ANC95LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's inadequate compensation for the wind conditions. A factor relating to the accident was: the gusty crosswind condition.NTSB ANC95LA164Accident · No injuriesLimited investigationFinal reportCessna 180A · Glennallen, AKThe pilot's selection of an unsuitable area for takeoff. The water condition with large waves/swells was a related factor.NTSB ANC95LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKFailure of the pilot to maintain adequate altitude/clearance from terrain, during a low pass over a prospective (off-airport) landing area. Factors relating to the accident were: rain and rising/uneven terrain.NTSB FTW95LA386Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Kerrville, TXthe pilot's inadequate preflight preparation and his failure to use all the available runway. A factor was the dark night.NTSB FTW95LA385Accident · No injuriesLimited investigationFinal reportCessna 210F · Montrose, COThe pilot's inattentiveness to the low fuel supply and his failure to switch fuel tanks in a timely manner. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA384Accident · 1 fatalLimited investigationFinal reportJohnson Rebel 300 · Keenesburg, COInadvertent stall during approach. A factor was the pilot's lack of total experience in make and model.NTSB CHI95LA315Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Milwaukee, WIthe pilot's premature liftoff which resulted in a stall.NTSB CHI95FA320Accident · No injuriesField investigationFinal reportBell 230 · Ann Arbor, MIthe manufacturer's inadequate quality control which led to a fatigue failure of the tail rotor blade.NTSB ATL95LA166Accident · No injuriesLimited investigationFinal reportCessna 170 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll and failure to take appropriate remedial action. A factor was trees.NTSB ATL95LA165Accident · 2 fatalLimited investigationFinal reportAllen Mustang II · Jasper, TNThe pilot's failure to maintain flying speed which resulted in an aerodynamic stall.NTSB ANC95LA162Accident · No injuriesLimited investigationFinal reportCessna 140 · Anchorage, AKfailure of the pilot to maintain sufficient altitude/clearance from terrain during a low pass over a prospective (off-airport) landing area. Factors relating to the accident were: the 'flat' lighting condition, and uneven terrain.NTSB ANC95LA161Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aniak, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB SEA95LA211Accident · 2 fatalLimited investigationFinal reportGift Challenger II · Scappoose, ORFailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall/spin. Although the aircraft recovery parachute had been activated, there was not enough time (or altitude) for it to fully deploy.NTSB SEA95FA212Accident · 2 fatalField investigationFinal reportAero Commander 560 · Ketchum, IDThe pilot-in-command's failure to maintain adequate airspeed during a turn resulting in a stall/spin. Factors contributing to the accident were the pilot-in-command's becoming geographically disoriented as well as his improper in-flight decision, and…NTSB LAX95TA328Accident · Serious injuriesFinal reportMcdonnell Douglas 369D · Pearl City, HIThe pilot's failure to secure his cargo/personal belongings which departed from the aircraft and struck the tail rotor.NTSB LAX95LA329Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Mariposa, CAthe pilot's inadequate compensation for the existing crosswind condition, and his failure to maintain an adequate airspeed during the attempted go-around, which led to an inadvertent stall/mush.NTSB FTW95LA383Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Greeley, COThe pilot's improper in-flight planning/decision by inadvertently selecting a less suitable area for landing (than the runway). Factors relating to the accident were: a malfunction of the nose landing gear micro-switch, which resulted in a false indication…NTSB CHI95LA319Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Yale, MIloss of engine power due to an inadequate fuel supply leading to fuel exhaustion. The inadvertent stall during the forced landing was a factor.NTSB CHI95LA316Accident · 1 fatalLimited investigationFinal reportCessna 188 · Greenville, MIpilot incapacitation.NTSB ANC95LA160Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Glennallen, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB SEA95LA210Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Castle Rock, WAsabotage by a hunter (shooting at the helicopter with a crossbow).NTSB SEA95FA209Accident · 1 fatalField investigationFinal reportCessna 180J · Browning, MTClearance from the ground was not maintained while attempting a VFR flight into IMC weather conditions. A factor to the accident was fog.NTSB FTW95LA391Accident · No injuriesLimited investigationFinal reportCessna 172D · Prim, ARThe loss of engine power for undetermined reasons. Factors were the pilot's inability to initiate a flare due to the fracture of the yoke assembly, and the lack of suitable terrain for the forced landing.NTSB FTW95LA382Accident · No injuriesLimited investigationFinal reportCessna 421B · Albuquerque, NMThe pilot's inadequate compensation for the crosswind condition. A factor was the crosswind.NTSB FTW95FA380Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Midland, TXthe pilot's selection of a downwind runway for takeoff. Factors were the tailwind, the density altitude, and the overloading of the airplane.NTSB CHI95LA314Accident · No injuriesLimited investigationFinal reportCessna 210L · Springfield, MOthe pilot's inadequate preflight and his failure to ensure an adequate supply of fuel for the intended trip, which resulted in a total loss of engine power due to fuel exhaustion.NTSB MIA95LA218Accident · No injuriesLimited investigationFinal reportBoeing 737-4Q8 · Miami, FLImproper planning/decision by the company driver of the vehicle (paymover) and uncommanded movement of the paymover for undetermined reasons.NTSB LAX95LA326Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Porterville, CAthe flight instructor's inadequate supervision of the flight; the dual student's improper use of the flight controls; and improper remedial action.NTSB FTW95LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Lago Vista, TXThe loss of engine power due to the failure of a connecting rod for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95IA313Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72 · Chicago, ILimproper installation of the #7 and #8 fuel nozzle manifold transfer tubes by company maintenance personnel, and an inadequate exhaust drain fitting gasket, which resulted in fuel leaks at the respective 'O' ring/gasket fittings; blockage of the fuel/oil…NTSB ANC95LA159Accident · No injuriesLimited investigationFinal reportCessna 206 · Homer, AKThe pilot's inadequate compensation for the wind conditions, which resulted in his failure to reach the proper touchdown point for landing. Factors related to the accident were: the variable wind condition, and rising terrain (no overrun) at the approach end…