NTSB investigations, 1995
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 LAX96LA033Accident · No injuriesLimited investigationFinal reportRussell KR-2 · Adelanto, CAthe pilot's misjudgement of the height above touchdown and his premature flare, which resulted in a hard landing.NTSB LAX96LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Congress, AZfailure of the #3 cylinder exhaust valve. A factor was the pilot's need to perform an evasive maneuver to avoid colliding with an automobile.NTSB FTW96LA038Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Reklaw, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DCA96IA005Incident · No injuriesIncident investigationFinal reportBoeing B-737-500 · San Francisco, CAThe inadvertant stall for undertermined reasons.NTSB CHI96LA023Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Lapeer, MIfuel exhaustion resulting in engine failure, the inadvertant stall, and improper decision by the pilot to attempt a large heading change at low altitude and airspeed. A factor relating to this accident is no fuel quantity gage installed in the airplane.NTSB CHI96LA022Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Rochester, INfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall. A factor relating to the accident was: the gusty wind condition.NTSB ATL96WA026Accident · Minor injuriesForeign investigationCessna 340 · Vienna, AustriaNTSB SEA96LA013Accident · No injuriesLimited investigationFinal reportCessna TR182 · Salt Lake City, UTmaintenance personnel improperly installed a landing gear system hydraulic line and the throttle cable which resulted in chaffing and subsequent loss of hydraulic fluid disabling the landing gear extention systems.NTSB MIA96LA015Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Morganton, NCThe pilot-in-command's excessive rate of descent on short final.NTSB LAX96LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Mecca, CAthe pilot/applicant's failure to maintain a glide path angle sufficient to maintain adequate clearance from all obstructions, and the examiner's inadequate supervision of the flight.NTSB LAX96LA026Accident · No injuriesLimited investigationFinal reportCessna 172H · Borrego Springs, CAthe pilot's inadequate preflight inspection which failed to detect a bird's nest in the air induction system. Factors in the accident were carburetor icing conditions and the pilot's improper use of carburetor heat.NTSB FTW96FA030Accident · 1 fatalField investigationFinal reportBeech 95-B95 · Tulsa, OKInadequate preflight by the pilot by failing to remove the flight control lock and failing to check the flight controls before takeoff, and the pilot's failure to abort the takeoff.NTSB ANC96TA011Accident · Minor injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's inadequate recovery from a bounced landing. The snow-covered landing surface and the pilot's decision not to perform a go-around were factors.NTSB NYC96LA020Accident · No injuriesLimited investigationFinal reportCessna 414A · Grt Barrington, MAthe pilot's inadequate compensation for wind conditions, which resulted in an undershoot of the proper touchdown point for landing. Factors relating to the accident were: the unfavorable wind conditions and the exposed runway lip.NTSB NYC96LA019Accident · Serious injuriesLimited investigationFinal reportPezold Lancair IV-P · Somerset, PAfailure of the fuel pump driveshaft, which resulted in fuel starvation and loss of engine power.NTSB LAX96LA025Accident · No injuriesLimited investigationFinal reportCessna 172 · Livermore, CAthe pilot's failure to maintain directional control during the landing roll. A contributing factor was the rough/uneven terrain.NTSB LAX96LA024Accident · No injuriesLimited investigationFinal reportCessna 206 · Long Beach, CAthe failure of the pilot to maintain control of the aircraft while maneuvering by visual reference to the surface in IFR conditions. An additional factor was the pilot's failure to continue with the missed approach.NTSB FTW96LA044Accident · 1 fatalLimited investigationFinal reportCessna 150M · Port Arthur, TXUndetermined.NTSB FTW96LA034Accident · No injuriesLimited investigationFinal reportCessna T210F · Tulsa, OKthe pilot's failure to secure a cellular telephone which jammed the rudder pedals.NTSB CHI96LA020Accident · No injuriesLimited investigationFinal reportCessna 180A · Goose Lake, IAinadequate maintenance, inadequate preflight by the pilot, and a loose fuel tank cap that allowed siphoning of fuel, buckling of the right fuel bladder, fuel exhaustion, and loss of engine power. Factors relating to the accident were: darkness, and the soft…NTSB ANC96LA010Accident · No injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe check pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the rough water and adverse wind conditions.NTSB LAX96LA023Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Chandler, AZthe improper installation of an intake manifold tube assembly during engine overhaul which permitted leakage into the induction system resulting in detonation and piston failure in the associated cylinder.NTSB LAX96LA022Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Hemet, CAthe pilot's failure to maintain adequate airspeed and the inadvertent stall while performing a short field landing.NTSB FTW96LA029Accident · No injuriesLimited investigationFinal reportCessna 150L · Norman, OKThe student pilot's improper recovery from a bounced landing and the flight instructor's inadequate supervision of the flight. Factors were the gusty wind conditions and the student pilot's failure to obtain and maintain proper compensation for the wind…NTSB FTW96FA028Accident · 2 fatalField investigationFinal reportMbb BO-105S · League City, TXthe pilot's failure to maintain aircraft control. Factors were the pilot's lack of total experience in the MBB BO-105 helicopter and the dark night light conditions.NTSB FTW96FA027Accident · 1 fatalField investigationFinal reportBeech 65-B80 · Paint Rock, TXThe pilot's impairment of judgment and performance due to alcohol which resulted in his improper decision to shutdown an engine, and his failure to maintain adequate airspeed for single-engine flight.NTSB CHI96LA021Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Indianapolis, INthe pilot's failure to lower the landing gear. Factors which contributed to the accident were: inadequate preflight necessitating a precautionary landing and the pilot's failure to use the pre-landing checklist.NTSB SEA96FA012Accident · Serious injuriesField investigationFinal reportBeech A-36 · Newport, ORthe pilot's inadvertent shut-off of the fuel mixture control. Factors contributing to the accident were: the pilot's failure to perform adequate remedial action to regain engine power, his lack of familiarity with the accident airplane, and his failure to…NTSB LAX96LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Auburn, CAthe pilot's failure to maintain directional control following a hard landing. His physical impairment was a factor.NTSB FTW96LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · Strasburg, COThe pilot's delayed application of carburetor heat. A factor was the unsuitable terrain.NTSB CHI96LA019Accident · No injuriesLimited investigationFinal reportCessna 150M · Centralia, ILthe pilot's improper use of flaps leading to the inadvertant stall.NTSB CHI96LA016Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Oconomowoc, WIa loss of engine power for undetermined reasons. A factor associated with the accident was the unsuitable terrain on which to make the forced landing.NTSB ANC96LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's inadequate compensation for the wind conditions, and failure to maintain sufficient altitude/clearance from mountainous/hilly terrain.NTSB SEA96LA011Accident · No injuriesLimited investigationFinal reportCessna 210L · Lincoln, MTThe failure of the pilot to follow the landing checklist and assure that the landing gear was extended. Factors relating to the accident were: the pilot's diverted attention, and an inoperative landing gear warning system.NTSB NYC96WA018Accident · 1 fatalForeign investigationCessna P210N · (Atlantic Ocean)NTSB LAX96LA020Accident · No injuriesLimited investigationFinal reportPitts Special S-1C · San Carlos, CAthe pilot's misjudged landing approach, failure to achieve the proper touchdown point, and his delayed decision to abort the landing.NTSB FTW96LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Dibble, OKan overload failure of the #1 connecting rod bolt and resulting connecting rod fatigue failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96IA024Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Dfw Airport, TX'O' ring failure in the fuel line to the left engine nozzle assemblies, which resulted in a fuel line leak and a left engine compartment fire.NTSB CHI96LA024Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Liberal, KSthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control and an inadvertent ground swerve.NTSB BFO96LA019Accident · No injuriesLimited investigationFinal reportCessna T210L · College Park, MDthe pilot's improper recovery from a bounced landing and his failure to initiate a go-around. Related factors were the crosswind and the pilot's concern about being late for meetings he had scheduled.NTSB SEA96FA010Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Alta, WYthe corrosion, consequent fatigue cracking and ultimate separation of the right wing forward lift strut.NTSB MIA96FA013Accident · No injuriesField investigationFinal reportBoeing 747-121 · Miami, FLfailure of the No. 4 engine fifth stage turbine hub due to a cyclic stress rupture for undetermined reasons, which resulted in an uncontained failure of the engine.NTSB NYC96LA017Accident · No injuriesLimited investigationFinal reportCessna 182B · Lebanon, MEthe pilot's improper use of the mixture control which resulted in fuel starvation and loss of engine power.NTSB NYC96LA016Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Barre, MAThe pilot's improper inflight planning/decision, which resulted in his failure to return to the airport after encountering an area of no thermal lift, and his failure to maintain adequate airspeed, while maneuvering to avoid an obstruction during an off…NTSB FTW96TA021Accident · No injuriesFinal reportBeech 95 · Albuquerque, NMThe pilot's improper inflight decision to make a landing on an unlit runway and his failure to maintain directional control of the airplane. Factors were the inoperative runway lights, bright lights from surrounding areas, and the pilot's attention being…NTSB FTW96LA032Accident · No injuriesLimited investigationFinal reportCessna 175 · Deer, ARThe pilot's selection of a downwind runway for landing. Factors were the tailwind and the pilot's misinterpretation of the wind conditions.NTSB FTW96LA023Accident · No injuriesLimited investigationFinal reportCessna 172D · Pryor, OKThe high wind and the pilot's poor judgment in attempting the flight.NTSB CHI96FA017Accident · 1 fatalField investigationFinal reportCessna 421C · Battle Creek, MIthe pilot's decision to fly in adverse weather (icing) conditions; the accumulation of airframe ice; and the pilot's failure to maintain adequate airspeed for the situation, which resulted in a loss of aircraft control. The icing condition was a related…NTSB BFO96LA014Accident · No injuriesLimited investigationFinal reportMooney M20E · Shady Side, MDthe partial loss of engine power due to a leaking fuel line.NTSB BFO96LA013Accident · Serious injuriesLimited investigationFinal reportZenair CH 2000 · Saluda, VAthe pilot's failure to maintain control of the airplane during an attempted go around.