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 FTW95IA397Incident · No injuriesIncident investigationFinal reportMBB BO-105C · Lafayette, LAa short in the 'jam proof system' solenoid valve which prevented activation of the backup hydraulic system and resulting in a cyclic hardover. Factors were the contaminated hydraulic fluid and the resulting jammed actuator (longitudinal control slider).NTSB SEA95LA220Accident · No injuriesLimited investigationFinal reportHiller UH-12A · Bonners Ferry, IDThe flight instructor's misjudging his flare during a simulated autorotation.NTSB MIA95LA225Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU-2-22K · Picayune, MSThe pilot-in-command's disregard of a weather forecast and flight into known adverse weather condition (thunderstorm). The thunderstorm, and associated wind gusts, were factors.NTSB LAX95LA337Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Parker Dam, CAthe pilot's failure to maintain adequate airspeed during a go-around.NTSB CHI95LA341Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · South Bend, INthe Pilot-in-Command's inadequate supervision of the flight and failure to assure that proper airspeed, rate of climb, and clearance from trees were obtained/maintained.NTSB CHI95LA323Accident · 1 fatalLimited investigationFinal reportHaugen Kolb Firestar II · Souris, NDthe pilot's failure to maintain control of the ultralight vehicle.NTSB CHI95LA322Accident · Minor injuriesLimited investigationFinal reportBenham F8L Falco · Augusta, KSa sudden shift in wind direction which resulted in diminished airspeed during takeoff.NTSB ANC95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Aniak, AKThe pilot's selection of an unsuitable portion of the 6,000 foot long gravel runway for landing. A factor associated with the accident was: the soft gravel berm on the runway.NTSB FTW95LA400Accident · No injuriesLimited investigationFinal reportCessna 150K · Victoria, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA324Accident · No injuriesLimited investigationFinal reportCessna 177 · Camp Lake, WIthe pilot's inadequate compensation for wind conditions, and failure to maintain altitude/clearance from the power line, while on short final approach. The downdraft was a related factor.NTSB CHI95FA326Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Danville, INthe pilot-in-command's inadequate recovery while maneuvering.NTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.NTSB SEA95LA218Accident · No injuriesLimited investigationFinal reportCessna 180 · Pray, MTThe loss of directional control due to the loss of right tailwheel steering. Factors in the accident were: a left quartering crosswind and the sloped side of the road.NTSB NYC95LA222Accident · No injuriesLimited investigationFinal reportMooney M20J · Jonestown, PAthe pilot's failure to maintain adequate airspeed during a go-around.NTSB MIA95WA232Accident · No injuriesForeign investigationAyres AY-65 · Bogota, ColombiaNTSB MIA95FA224Accident · 3 fatalField investigationFinal reportAerospatiale TB-9 · New Smyrna Bch, FLthe failure of the pilots of both aircraft to see and avoid each other.NTSB MIA95FA223Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Dalton, GAthe pilot's improper action by turning off the right engine fuel selector valve after the left engine had failed, and her failure to maintain control of the airplane after losing power in both engines. Factors relating to the accident were: a worn rocker arm…NTSB LAX95LA335Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bakersfield, CAa loss of engine power for undetermined reasons.NTSB BFO95LA095Accident · No injuriesLimited investigationFinal reportSnow S2A · Pasadena, MDthe pilot's inability to maintain directional control due to the failure of the right brake during the landing roll.NTSB ANC95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKFailure of the main landing gear wheel that had been modified for a tundra tire.NTSB SEA95LA217Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Morgan, UTFailure of the pilot to maintain adequate airspeed, while maneuvering to land after a low altitude tow release, which resulted in a stall/spin and collision with terrain.NTSB MIA95WA222Accident · 5 fatalForeign investigationCessna 402B · Marsh Harbour, BahamasNTSB LAX95LA336Accident · No injuriesLimited investigationFinal reportSjostrand Wheeler Express · Mariposa, CAthe pilot's premature rotation and liftoff, which resulted in an inadvertent stall and subsequent hard touchdown.NTSB FTW95LA395Accident · Serious injuriesLimited investigationFinal reportSinclair 1100R · Guthrie, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall.NTSB FTW95FA394Accident · No injuriesField investigationFinal reportMBB BO-105C · Houston, TXthe failure of the main transmission's #1 (left) input pinion assembly, due to the partially blocked oil passage which reduced oil flow, resulting in the disconnect of the drive shaft.NTSB CHI95LA325Accident · No injuriesLimited investigationFinal reportBede BD12 · Chesterfield, MOThe airplane's inadequate handling characteristics which resulted in the inability to control pitch attitude during landing.NTSB ANC95FA167Accident · 2 fatalField investigationFinal reportCessna 185 · Petersburg, AKThe pilot's failure to maintain sufficient airspeed above the airplane's stall speed. The high terrain and low ceiling (clouds) were related factors.NTSB MIA95LA221Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Hendersonville, NCThe failure of the pilot-in-command to perform preflight weight and balance calculations resulting in the airplane exceeding the maximum gross takeoff weight limitations.NTSB FTW95LA396Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Searcy, ARThe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB FTW95FA393Accident · 3 fatalField investigationFinal reportCessna 172M · Witter, ARfailure of the pilot to maintain sufficient altitude/clearance from high/wooded terrain. Factors relating to the accident were: darkness, high terrain, and foggy weather conditions. Also, the pilot's use of Methamphetamine (not approved by the FAA) was a…NTSB CHI95LA321Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Boyne Falls, MIthe pilot's failure to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB ATL95LA168Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Minter City, MSInadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the excessive gross weight of the airplane and the high outside air temperature, which would have reduced the performance of the airplane.NTSB SEA95LA219Accident · No injuriesLimited investigationFinal reportPietenpol AIR-CAMPER · Redmond, ORa loss of engine power for undetermined reasons.NTSB LAX95GA334Accident · 2 fatalFinal reportCessna U206G · Dos Palos, CAthe pilot-in-command's failure to assure that adequate airspeed was maintained.NTSB DCA95RA061Accident · 2 fatalForeign investigationBalloonbau Woerner · Bereza, BelarusNTSB ANC95LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Delta, AKThe pilot's selection of an unsuitable step taxi/takeoff area. The submerged object was a related factor.NTSB ANC95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Kivalina, AKThe pilot's selection of unsuitable terrain for takeoff. A factor relating to the accident was: the rough/uneven terrain.NTSB SEA95LA216Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moab, UTThe pilot-in-command's landing long, precluding a go-around and not maintaining a proper descent rate. Factors were trees and the crosswind.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…