NTSB investigations, 1994
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\") = 1994 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") = 1994 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 LAX95FA035Accident · 1 fatalField investigationFinal reportBeech C-99 · Avenal, CAloss of aircraft control at night by the pilot for unknown reasons.NTSB FTW95LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder, COThe pilot's loss of directional control.NTSB FTW95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Haskell, OKThe total loss of engine power due to contaminated fuel. Factors were the improper maintenance procedures resulting in fuel contamination, the pilot's inadequate preflight inspection, and the lack of suitable terrain available for the forced landing.NTSB FTW95LA043Accident · No injuriesLimited investigationFinal reportCessna 206E · San Benito, TXThe pilot's improper attempt to make an off airport landing at night and the inadvertent ground loop. A factor was the dark night light condition.NTSB FTW95FA047Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G-164B · Wisner, LAThe pilot's failure to maintain minimum required airspeed for flight. A factor was the pilot's lack of total experience in the type of aircraft.NTSB LAX95LA036Accident · Serious injuriesLimited investigationFinal reportThunder and Colt TC-180 · Peoria, AZthe flight's encounter with unforecasted high winds which resulted in a hard landing.NTSB LAX95FA037Accident · 3 fatalField investigationFinal reportCessna 172K · Springerville, AZthe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall/spin. The pilot's diverted attention and overconfidence in the aircraft's ability to fly slow were factors in this accident.NTSB CHI95LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Carlock, ILThe total failure of the connecting rod bolts.NTSB SEA95LA020Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYFuel exhaustion due to the pilot's failure to refuel.NTSB MIA95LA020Accident · No injuriesLimited investigationFinal reportCessna 182-D · Deland, FLThe failure of the pilot to compensate for the gusty wind conditions during taxi for takeoff.NTSB LAX95LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150K · El Monte, CAfuel exhaustion due to the failure of both pilots to ensure that an adequate supply was on board prior to departure.NTSB ATL95T#A01Accident · No injuriesClass 3Final reportCessna T210N · Montgomery, ALNTSB NYC95LA025Accident · 1 fatalLimited investigationFinal reportLee Pazmany PL-4A · Orange, MAThe pilot's improper flare which resulted in a hard landing, collapse of the main gear, and inflight collision with the ground.NTSB NYC95LA024Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Goode, VAthe inadequate preflight by the pilot, resulting in engine failure due to water ingestion.NTSB MIA95WA022Accident · No injuriesForeign investigationFairchild Hiller F-27F · Cordoba, ArgentinaNTSB FTW95LA044Accident · 1 fatalLimited investigationFinal reportPezetel 106A · Gulf Of MexicoThe pilot became lost or disoriented, allowing the airplane to get off-course/over water; and loss of engine power for an undetermined reason. Factors related to the accident were: clouds and high winds associated with the prevailing tropical storm, the…NTSB CHI95FA041Accident · 4 fatalField investigationFinal reportCessna P210N · Savoy, ILThe failure of the pilot to maintain a positive rate of climb during the night takeoff. Factors related to the accident were: lack of visual cues, the weather conditions, and the dark night.NTSB ATL95FA014Accident · 2 fatalField investigationFinal reportCessna 172H · Louisville, GAThe pilot's failure to maintain clearance from trees during a low pass maneuver. A factor was the trees at the vicinity of the low pass.NTSB MIA95T#A02Accident · No injuriesClass 3Final reportCessna U-206G · Kenansville, FLNTSB CHI95LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Alton, ILthe pilot's failure to refuel. Factors associated with the accident were unsuitable terrain, the vehicle and building which the airplane contacted, and the dark night conditions.NTSB CHI95LA036Accident · 1 fatalLimited investigationFinal reportLessel KR-2 · Portland, INthe failure of the elevator control cable attach point and the pilot's subsequent inability to control the airplane.NTSB BFO95LA012Accident · No injuriesLimited investigationFinal reportBeech A23 · Campbellsville, KYthe mechanic's improper maintenance adjustment, which involved the misalignment of the fuel selector handle with the fuel selector valve. Related factors are the pilot's inadequate fuel management, and the rough/uneven terrain.NTSB ANC95LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's inadequate compensation for crosswind conditions. A crosswind and icy runway conditions were factors in the accident.NTSB NYC95LA023Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Coventry, RIimproper emergency procedures by the pilot and inadequate supervision by the flight instructor which resulted in their failure to restart the engine after it lost power due to a failed engine driven fuel pump.NTSB MIA95LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Venice, FLThe loss of engine power for undetermined cause. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX95FA033Accident · 1 fatalField investigationFinal reportSchweizer 269C · Valencia, CAthe pilot's failure to maintain adequate clearance from a dirt embankment while performing an undetermined maneuver.NTSB FTW95LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Seguin, TXThe pilot's failure to attain a proper climb rate after takeoff. A factor was the dark night light condition.NTSB FTW95LA041Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Johnson City, TXThe pilot's failure to maintain clearance with the trailer while landing.NTSB CHI95LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Zeeland, MIthe pilot's loss of directional control during touch and go landings. Factors were the crosswind and the pilot's lack of total experience.NTSB CHI95LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rochelle, ILthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the student pilot's improper use of the brakes.NTSB CHI95LA037Accident · Minor injuriesLimited investigationFinal reportBeech G35 · Frankfort, ILFailure of the pilot to see-and-avoid the vehicle, and the vehicle driver's disregard for the need to remain clear of the aircraft's approach path. A factor related to the accident was: the proximity of a parked airplane to the runway.NTSB FTW95LA040Accident · No injuriesLimited investigationFinal reportFighter Escort Wings P-51D · Seymour, TXThe failure of the propeller speed unit. A factor was the lack of suitable terrain for the forced landing.NTSB BFO95LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bucyrus, OHThe pilot's faliure to maintain directional control during the takeoff roll.NTSB SEA95FA018Accident · 1 fatalField investigationFinal reportCessna 172N · Klamath Falls, ORThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with the mountainous terrain below him. Contributing to the accident was a downdraft.NTSB NYC95LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Dawson Springs, KYThe pilot's failure to maintain adequate obstacle clearance. Other related factors are night conditions and the pilot's improper inflight planning/decision.NTSB CHI95LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Tomahawk, WIthe collision with deer during landing - flare/touchdown.NTSB CHI95FA035Accident · 1 fatalField investigationFinal reportSikorsky S-76A · Cameron, LAthe copilot's failure to maintain altitude and the pilot-in-command's inadequate supervision of the operation. Factors include the dark night and low ceiling, and the flightcrew's failure to set the proper altimeter setting.NTSB ATL95FA013Accident · 2 fatalField investigationFinal reportCessna 152 · Dresden, TNThe pilot in command's (CFI) impairment of judgment and performance due to alcohol and drugs, which led to his failure to maintain separation from terrain.NTSB SEA95LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · Lewiston, IDFuel exhaustion due to the pilot's failure to refuel en route. Factors include the embankment on the side of the road on which he made his forced landing.NTSB SEA95FA017Accident · 4 fatalField investigationFinal reportBeech 58P · Great Falls, MTThe pilot's failure to maintain airspeed. A factor to the accident was: inadequate aircraft preflight.NTSB FTW95LA039Accident · No injuriesLimited investigationFinal reportHughes 269A · Monticello, ARThe loss of engine power due to a fatigued rod end bolt. A factor was the lack of suitable terrain for landing.NTSB CHI95LA034Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mc Cordsville, INthe pilot's improper use of the cyclic control. Factors were the diversion of attention and total lack of experience in the type of aircraft, by the pilot.NTSB ANC95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's selection of unsuitable terrain for landing/taxi. Factors associated with the accident were the soft and snow covered terrain.NTSB ATL95FA012Accident · Serious injuriesField investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate management of the fuel supply which resulted in fuel exhaustion and a complete loss of engine power.NTSB LAX95LA032Accident · Serious injuriesLimited investigationFinal reportBeech 65-90 · San Diego, CAthe inadvertent and premature deployment of the jumper's reserve parachute as he exited the aircraft.NTSB FTW95LA046Accident · Serious injuriesLimited investigationFinal reportRaven S100A · Las Vegas, NMThe pilot's improper in-flight planning/decision. A factor related to the accident was: the high wind condition.NTSB FTW95LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Radium Springs, NMFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor was the lack of suitable terrain available for the forced landing.NTSB CHI95LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hudson, WIinadequate maintenance (major overhaul) by maintenance personnel which resulted in the total loss of engine power. Soft terrain was a related factor.NTSB CHI95LA031Accident · Serious injuriesLimited investigationFinal reportBoeing 757-231 · St Paul, MNFailure of ground personnel to identify the unsafe/hazardous situation regarding the closeness of the airplane to the baggage carts, and the captain's improper planning/decision concerning the situation.NTSB NYC95LA021Accident · 2 fatalLimited investigationFinal reportBoeing A-75N1 · Sayville, NYA loss of control in flight by the pilot(s) while maneuvering, with insufficient altitude for recovery.