NTSB investigations, 1995
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE year(c.\"eventDate\") = 1995 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 WHERE year(c."eventDate") = 1995 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 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…NTSB FTW95LA379Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Loop, TXThe pilot's failure to maintain clearance with the power line. A factor was the sun glare light conditions.NTSB CHI95LA308Accident · No injuriesLimited investigationFinal reportLet L-23 Super Blanik · White Bear Lake, MNthe pilot's delayed retraction of the spoilers. Factors were the excessive sink rate and the power lines.NTSB CHI95LA306Accident · Serious injuriesLimited investigationFinal reportPiper PA-11 · Badger, SDthe pilot's failure to maintain adequate airspeed while making a steep right turn. A contributing factor was the insufficient altitude needed to make a recovery.NTSB SEA95LA208Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Salem, ORA loss of power for undetermined reasons and the pilot's failure to maintain airspeed while maneuvering for a forced landing.NTSB SEA95LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mt Pleasant, UTThe pilot in command's failure to maintain airspeed during climbout. Factors include wind shear and high density altitude.NTSB SEA95LA204Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Corvallis, ORShearing of the right main landing gear shock strut retainer cap retaining pins.NTSB SEA95FAMS1Accident · 3 fatalMissing aircraftFinal reportPiper PA-28-140 · Missing, WAUndetermined until the Missing aircraft is located.NTSB NYC95LA214Accident · 1 fatalLimited investigationFinal reportGillet C.P. 328 · Fire Island, NYthe failure of the pilots to maintain control of the airplane while performing aerobatics.NTSB LAX95LA325Accident · 1 fatalLimited investigationFinal reportChambers C1C · Turlock, CAa loss of engine power due to fuel system contamination and the pilot's failure to maintain an adequate airspeed while maneuvering for an emergency landing. Factors in the accident were: the inadequate procedures used to purge the fuel system of known…NTSB LAX95LA324Accident · No injuriesLimited investigationFinal reportWelles Kitfox Speedster · San Luis Obispo, CAthe pilot's failure to maintain directional control.NTSB FTW95LA381Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Boulder, COFailure by the pilot to maintain control of the aircraft during landing roll.NTSB SEA95LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Stehekin, WAThe pilot's failure to maintain airspeed after takeoff.