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 ATL96LA008Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Tuscaloosa, ALFatigue failure of the number one piston assembly, which resulted in a loss of engine power.NTSB ANC96LA008Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe pilot's improper planning/decision, which resulted in his failure (or inability) to maintain directional control of the airplane, while attempting to negotiate a bend (dog-leg) in the runway. Factors relating to the accident were: variable/gusty wind…NTSB NYC96LA015Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chester, CTThe pilot's failure to attain adequate airspeed, and his delay in aborting the takeoff, which resulted in a runway overrun and collision with trees. Factors relating to the accident were: the wet runway and hydroplaning conditions.NTSB MIA96TA014Accident · No injuriesFinal reportCessna 182R · Redstone Arsena, ALthe pilot's poor inflight planning decision for not flying the scheduled time and electing to perform 3 additional takeoffs not planned during fuel consumption calculations. Contributing to the accident was the use of an inaccurate dipstick.NTSB MIA96LA012Accident · 1 fatalLimited investigationFinal reportGlasflugel Mosquito · Dunlap, TNthe failure of the pilot to maintain airspeed resulting in a spin at an altitude insufficient for recovery.NTSB LAX96LA019Accident · Serious injuriesLimited investigationFinal reportEaa Chapter 163 Breezy RLU-1A · Henderson, NVthe pilot's failure to maintain a proper cruise altitude and his inadequate in-flight planning. Contributing factors were encountering rising terrain and a downdraft.NTSB LAX96LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Battle Mountain, NVthe pilot's failure to see and avoid utility transmission wires suspended across the final approach flight path.NTSB LAX96LA003Accident · 1 fatalLimited investigationFinal reportFallbeck Dyke Delta JD2 · Safford, AZImproper planning/decision by the owner/builder (pilot), which resulted in his failure or inability to recover from a stall/mush condition.NTSB CHI96LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocie, MOfailure of the number three exhaust valve.NTSB ATL96LA009Accident · No injuriesLimited investigationFinal reportCessna 150F · Charlotte, NCThe pilot's inadequate preflight/planning which resulted in fuel exhaustion due to an inadequate fuel supply.NTSB MIA96LA011Accident · No injuriesLimited investigationFinal reportCessna 172Q · Ormond Beach, FLThe student pilot's improper recovery from a bounced landing and his failure to execute a go-around. Contributing to the accident were: the student pilot's high, fast approach and his misjudgment of the flare during landing.NTSB LAX96TA016Accident · No injuriesFinal reportHughes OH-6A · Imperial, CAThe pilot's improper planning/decision and failure to ensure there was an adequate supply of fuel, which led to fuel exhaustion and a forced (autorotative) landing.NTSB FTW96LA022Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Tahoka, TXthe pilot's failure to maintain clearance from wires. Factors were the loss of aileron control and the lack of suitable terrain for a forced landing.NTSB FTW96LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Kingston, OKthe pilot's inadequate compensation for the wind gusts. Factors were the gusts and the dark night conditions.NTSB CHI96LA018Accident · No injuriesLimited investigationFinal reportCessna 180G · Belle Fourche, SDthe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the airplane while landing. A factor in the accident was the crosswind conditions.NTSB ATL96LA007Accident · No injuriesLimited investigationFinal reportBeech 23 · Newnan, GAa loose fuel line fitting, which resulted in a fuel leak and premature emptying of the left fuel tank; failure of the pilot to follow the checklist (select the fullest fuel tank for landing); fuel starvation; and subsequent Loss of engine power, while on…NTSB ANC96LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot's selection of unsuitable terrain for landing. Soft sandy terrain was a related factor.NTSB SEA96LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Laurel, MTthe student pilot's improper planning/decision, which resulted in inadequate altitude/clearance from hangar buildings and a subsequent emergency landing, while attempting to evade a flock of geese. The flock of geese was a related factor.NTSB NYC96LA014Accident · No injuriesLimited investigationFinal reportCessna 210C · Burlington, VTa fractured hydraulic line and loss of hydraulic fluid, which resulted in an inoperative landing gear extension system for both normal and emergency operation of the gear.NTSB NYC96FA012Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Atlantic Ocean (Atlantic Ocean)a total loss of left engine power as a result of an in-flight separation of the #2 cylinder. The cylinder separated due to high stress fatigue cracking of the cylinder hold down studs and the #3 main bearing thru-studs. Factors in this accident were: improper…NTSB LAX96LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Mobile, AZa loss of engine power for undetermined reasons.NTSB LAX96LA015Accident · Minor injuriesLimited investigationFinal reportPetrik Questair Venture · Crescent City, CAthe pilot's failure to maintain directional control.NTSB FTW96LA019Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Waller, TXa loss of power for undetermined reasons, and the pilot misjudging distance and airspeed resulting in his failure to attain the proper touchdown point.NTSB FTW96LA018Accident · No injuriesLimited investigationFinal reportCessna 175 · Batesville, ARthe pilot's failure to maintain control of the airplane during landing.NTSB CHI96LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Anderson, INinadequate maintenance in that an engine oil line was not properly tightened after routine maintenance. A factor was the disconnected oil line.NTSB CHI96LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Peosta, IAthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion.NTSB ANC96LA006Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Ninilchik, AKThe pilot's improper inflight planning/decision and inadequate compensation for the wind conditions. Turbulence and downdrafts were related factors.NTSB MIA96LA010Accident · No injuriesLimited investigationFinal reportRockwell 112A · Meridianville, ALLoss of engine power due to inadequate maintenance during the 100-hour annual. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX96WA014Accident · 1 fatalForeign investigationCessna 182 · Bahia De Los An, MexicoNTSB CHI96LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Wakeeney, KSFailure of the pilot to maintain sufficient altitude and airspeed on final approach to reach the proper touchdown point for landing. A factor relating to the accident was: the pilot's selection of the wrong runway for landing.NTSB ANC96LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Red Devil, AKLoss of engine power for an undetermined reason. The lack of suitable terrain for a forced landing was a related factor.NTSB MIA96LA009Accident · Minor injuriesLimited investigationFinal reportSIAI-Marchetti SF.260 · Atlantic Ocean (Atlantic Ocean)loss of engine power for undetermined reason(s), which result in a ditching at sea.NTSB LAX96LA013Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)an inadvertent encounter with unreported and unforecasted severe turbulence. A factor in the accident was the passengers' non-use of seat belts during cruise flight.NTSB FTW96LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Norman, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB NYC96LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Honsdale, PAthe pilot's improper evaluation of the weather briefing, and his decision to fly into known forecasted moderate to severe icing conditions. Factors in the accident were the adverse weather conditions encountered during the flight and landing.NTSB NYC96LA009Accident · No injuriesLimited investigationFinal reportCessna 172G · Wilkes-Barre, PAthe instructor's inadequate supervision of the flight. Contributing factors were the instructor's inexperience and the student pilot's failure to maintain aircraft control.NTSB LAX96LA012Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lost Hills, CAthe pilot misjudged the aircraft's altitude.NTSB LAX96LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Brea, CAfuel exhaustion due to the pilot's improper leaning procedures and his failure to use the performance charts in the pilot operating handbook to determine fuel consumption rates for the selected cruise power setting.NTSB BFO96LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Dayton, OHthe student pilot's poor in-flight planning and decision making during the approach to landing/go around. Related factors are his inadequate compensation for crosswind wind conditions.NTSB SEA96LA008Accident · No injuriesLimited investigationFinal reportNord Stampe SV4C · Cottage Grove, ORA propeller blade separation due to inadequate material. The lack of a suitable area for the forced landing was a factor.NTSB NYC96LA011Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102CS · Lake Placid, NYthe pilot's inadequate evaluation of the weather. Contributing factors were the high winds and downdrafts.NTSB NYC96LA010Accident · No injuriesLimited investigationFinal reportCessna 140 · Albion, NYthe pilot's inadequate planning/decision and compensation for wind conditions, resulting in the airplane nosing over during the taxi.NTSB MIA96LA007Accident · No injuriesLimited investigationFinal reportForney ERCOUPE-2 · Cartersville, GAThe pilot-in-command's decision to continue flight with the inoperative fuel transfer pump which resulted in loss of engine power due to fuel starvation. The inoperative fuel transfer pump and the unsuitable terrain encountered during the forced landing were…NTSB CHI96LA010Accident · No injuriesLimited investigationFinal reportCrowley/Zenair Zodiac CH-600 · Columbia, MOA loss of elevator control as a result of the top elevator control cable working its way out of a fitting.NTSB CHI96LA009Accident · No injuriesLimited investigationFinal reportCessna 180R · Seattle, WAthe pilot's failure to maintain control of the airplane during the landing roll. A factor in the accident was the gusty wind conditions.NTSB CHI96LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Crawfordsville, INThe pilot's premature raising of the flaps and the low airspeed.NTSB ATL96FA006Accident · 2 fatalField investigationFinal reportLuscombe 8E · Picayune, MSa worn left magneto distributor gear, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB NYC96LA008Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Bethpage, NYthe pilot's inadequate preflight and inflight planning/preparation, which resulted in fuel exhaustion and the loss of engine power.NTSB MIA96LA006Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eastman, GAThe failure of the pilot-in-command to perform fuel consumption calculations, and the decision not to refuel. Contributing to the accident was fuel exhaustion, and the pilot- in-command's decision to operate the airplane with the fuel gauges inoperative.NTSB LAX96LA010Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Dixon, CAfuel starvation due to debris blocking the carburetor main jet.