NTSB investigations, 1995
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 LAX96LA051Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · San Carlos, CAthe pilot's improper recovery from a bounced landing and failure to maintain directional control, while landing at night.NTSB FTW96LA050Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Estancia, NMimproper maintenance and inspection of the engine, ingestion of an air intake bypass door into the engine intake, detonation (or preignition), and failure of the #1 and #2 piston and connecting rod assemblies. A factor relating to the accident was: the lack…NTSB FTW96FA048Accident · 1 fatalField investigationFinal reportBeech A35 · Hudson, COThe pilot's failure to maintain clearance. A factor was improper in-flight planning.NTSB CHI96LA036Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Lacon, ILwas the compensation for wind conditions inadequate and aircraft control not maintained. A factor was directional control inadequately maintained.NTSB LAX96FA050Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Fullerton, CAthe pilot-in-command's failure to follow IFR procedures in that he descended below the minimum descent altitude and failed to execute a missed approach. Contributing to the accident was the pilot-in-command's self-induced pressure to get to work.NTSB CHI96LA035Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Montrose, MIa loss of engine power as a result of the separation of the throttle push-pull cable.NTSB BFO96LA025Accident · No injuriesLimited investigationFinal reportSellors Kitfox IV · Pasadena, MDThe pilot's improper (abrupt) application of brakes during the landing roll. Factors relating to the accicent were: the pilot's failure to attain the proper touchdown point during the landing, and his lack of experience in the make and model of airplane.NTSB ATL96LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Durham, NCThe aircraft mechanic's failure to follow engine overhaul procedures which resulted in the failure of the camshaft drive gear.NTSB MIA96LA025Accident · No injuriesLimited investigationFinal reportCessna 150L · Lantana, FLThe failure of the pilot-in-command to use the checklist and to set the parking brakes prior to engine start.NTSB LAX96FA049Accident · 1 fatalField investigationFinal reportBeech S35 · Oxnard, CAfailure of the pilot to maintain adequate airspeed during a missed approach, after encountering an undetermined propeller malfunction, which resulted in a stall and collision with the terrain. Factors relating to the accident were: darkness, fog, and the…NTSB BFO96LA024Accident · No injuriesLimited investigationFinal reportCessna 210J · Bellefontaine, OHThe pilot unknownly left the ignition switch in right magneto-only position, while moving the propeller by hand, which allowed an inadvertent start of the engine. The weak battery was a related factor.NTSB BFO96LA023Accident · No injuriesLimited investigationFinal reportBeech A23-24 · New Carlisle, OHthe pilot-in-command's failure to reach the proper touchdown point. Related factors were the pilot's failure to obtain/maintain the proper glidepath during the approach, and the rough/uneven terrain encountered after the airplane touched down short of the…NTSB BFO96FA022Accident · 3 fatalField investigationFinal reportBeech 58 · Cleveland, OHthe pilot's improper IFR procedure, by failing to maintain a positive rate of climb (and terrain clearance) after takeoff. Factors relating to the accident were: darkness, and the lack of visual references over water and under overcast cloud conditions.NTSB ATL96LA013Accident · No injuriesLimited investigationFinal reportFleet ONE · Holly Springs, NCa loss of engine power due to a cracked crankshaft. A factor was the rough/uneven terrain encountered during the forced landing.NTSB SEA96FA021Accident · 3 fatalField investigationFinal reportCessna 210D · Yellow Pine, IDimproper planning/decision by the pilot, his resultant VFR flight into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance from mountainous terrain. Factors relating to the accident were: the adverse weather…NTSB LAX96LA048Accident · 1 fatalLimited investigationFinal reportCessna 150H · Imperial, CAthe student pilot's misreading of the altimeter while in the traffic pattern, which put the aircraft in dangerous proximity to the ground and obstructions. A factor in the accident was the pilot's inability to see the power pole due to sun glare as the…NTSB FTW96FA046Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Cypress, TXThe pilot's failure to maintain aircraft control while flying in instrument meteorological conditions. Factors were the weather, and the failure of the airplane's vacuum pump which rendered the attitude indicator and the directional gyro inoperative.NTSB CHI96FA034Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Stafford, KSthe pilot misjudged his distance and altitude and flew into transmission wires. A factor was the pilot's lack of recent night flying experience.NTSB ATL96LA012Accident · No injuriesLimited investigationFinal reportWaco ASO · Ridgeland, SCFailure of the ignition system after takeoff, which resulted the loss of engine power.NTSB ANC96LA017Accident · No injuriesLimited investigationFinal reportCessna 207 · Aniak, AKfatigue failure of the engine crankshaft at the number 2 main bearing journal, where rubbing contact had occurred with the number 2 main bearing. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB LAX96LA047Accident · No injuriesLimited investigationFinal reportBeech D-50 · Jackson, CAthe failure of the pilot-in-command to follow the pre-landing checklist which resulted in his failure to extend the landing gear and an inadvertent wheels-up landing.NTSB FTW96WA342Accident · No injuriesForeign investigationPiper PA-23-160 · Tipejuanes, MexicoNTSB FTW96IA045Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Corsicana, TXTotal loss of power in the left engine from ice ingestion; and failure of the left-engine auto-relight system caused by an open fuse in the Digital Electronic Control Unit (DECU), which prevented an automatic relight of the left engine. Factors relating to…NTSB ATL96LA011Accident · No injuriesLimited investigationFinal reportCessna 421 · Peachtree City, GADeer on the runway during a night landing that resulted in the collision.NTSB SEA96LA020Accident · No injuriesLimited investigationFinal reportSnow S2C · Dufer, ORA loss of engine power due to a cracked cylinder head. A factor was the evasive maneuver to avoid a ditch.NTSB LAX96TA046Accident · No injuriesFinal reportPiper PA-28-181 · Edwards, CAthe pilot's failure to completely release the parking brakes prior to taxi, which produced a brake over temperature condition and brake fire.NTSB FTW96LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Heber Springs, ARFailure of the pilot to maintain directional control of the airplane during transition from landing roll to taxi. A factor relating to the accident was: a soft area in the grass runway.NTSB SEA96LA019Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Wisdom, MTThe pilot's failure to maintain clearance from the fence post. Factors include sunglare, slush covered terrain, and the pilot's selection of unsuitable terrain for takeoff.NTSB SEA96LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Seeley Lake, MTThe pilot's selection of unsuitable terrain for landing. The snow covered runway was a factor.NTSB SEA96LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22 · La Grande, ORThe pilot's poor judgment in attempting flight in the existing wind conditions.NTSB MIA96LA028Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Jasper, FLImproper maintenance and inspection of the carburetor system by maintenance personnel during the last annual inspection which resulted in a partial loss of engine power due to carburetor ice. Contributing to the accident were: the pilot's failure to perform…NTSB SEA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Syracuse, UTFuel exhaustion due to the pilot's failure to refuel.NTSB NYC96LA025Accident · No injuriesLimited investigationFinal reportCessna 150J · Norwood, MAthe student's inadvertent use of the mixture control and the flight instructor's inadequate supervision during the final approach resulting in the loss of engine power due to fuel starvation and the subsequent nose over during the forced landing.NTSB MIA96LA024Accident · 2 fatalLimited investigationFinal reportRans S-12 · Plant City, FLfailure of the non-certificated pilot (unqualified person) to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall and collision with the terrain.NTSB MIA96LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Saltillo, MSThe failure of the pilot-in-command to perform fuel comsumption calculations before and during the flight.NTSB FTW96LA043Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Berryville, ARThe pilot's failure to conduct an adequate preflight and remove the control locks.NTSB BFO96LA021Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Manassas, VAfailure of the pilot to maintain control of the airplane, when the left engine lost power shortly after liftoff. Related factors were the pilot's failure to follow the checklist procedure, and his failure to ensure that the fuel selector was in the proper…NTSB SEA96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Douglas, WAThe pilot fell asleep.NTSB LAX96FA045Accident · 2 fatalField investigationFinal reportBell 47D1 · Shafter, CAthe pilot misjudged the altitude and ground clearance while performing an unwarranted low altitude flight maneuver.NTSB FTW96LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Keller, TXthe inadequate visual lookout by the driver of the vehicle resulting in his obstructing the runway.NTSB DCA96MA008Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-83 · East Granby, CTthe flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…NTSB CHI96LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Niles, MIfuel exhaustion as a result of the pilot's improper fuel consumption calculations. Factors related to the accident were: the pilot's lack of familiarity with the aircraft and operating with a known malfunctioning fuel gauge.NTSB CHI96LA028Accident · No injuriesLimited investigationFinal reportCessna 421 · Romeo, MIthe failure of the pilot to maintain sufficient airspeed during landing, causing the inadvertent stall. A factor was the icing conditions.NTSB ANC96LA014Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Yakutat, AKThe pilot's attempt to fly into known adverse weather, not maintaining a proper forward visual lookout, and not maintaining a proper altitude while maneuvering the airplane for landing.NTSB NYC96FA024Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Ashville, NYthe pilot's misjudgment of altitude and distance to the runway during an approach to land. Factors relating to the accident were: the night and adverse weather conditions.NTSB MIA96LA021Accident · Serious injuriesLimited investigationFinal reportLynch Starduster SA-300 · Ormond Beach, FLThe pilot's failure to maintain adequate airspeed and control of the airplane resulting in an inadvertent stall and collision with the ground.NTSB LAX96TA044Accident · Minor injuriesFinal reportMcDonnell Douglas 369D · Mather, CAFuel starvation due to the right seat safety pilot's inadvertent engine shutdown when he closed the throttle to simulate an engine failure, and his failure to perform the throttle rigging check before takeoff. Contributing to the accident was the improper…NTSB FTW96LA047Accident · No injuriesLimited investigationFinal reportCessna 210B · Loveland, COFailure of the pilot to extend the landing gear.NTSB FTW96LA042Accident · Serious injuriesLimited investigationFinal reportLodge RV-4 · Mcckinney, TXthe pilot's failure to refuel the airplane which led to a loss of engine power due to fuel exhaustion, and the pilot's failure to maintain adequate airspeed.NTSB CHI96LA033Accident · No injuriesLimited investigationFinal reportForney F-1 · Estherville, IAthe pilot's failure to maintain directional control of the airplane during the landing. A factor associated with the accident was the crosswind condition.