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 ATL95LA019Accident · 2 fatalLimited investigationFinal reportWeeks Glasair SH2F · Timmonsville, SCThe pilot's continued operation into known adverse weather conditions with a known aircraft deficiency, and his ensuing spatial disorientation, which resulted in ground impact during an uncontrolled descent.NTSB ATL95FA021Accident · 1 fatalField investigationFinal reportBeech 95B55 · Mableton, GAThe pilot's inadequate weather evaluation in that he failed to account for forecasted winds at altitude that resulted in an increased time en route and fuel exhaustion.NTSB FTW95LA054Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks DG-600 · Alamogordo, NMThe inadvertent stall.NTSB FTW95IA053Incident · No injuriesIncident investigationFinal reportBoeing B-737-300 · Houston, TXThe failure of maintenance personnel to follow the taxi checklist resulting in the hydraulic pumps not being turned on.NTSB CHI95LA046Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Dickinson, NDThe flight instructor (CFI) misjudged the flare, which resulted in a hard landing. Factors related to the accident were: the adverse weather (icing) condition, structural ice, windshield ice, darkness, and the lack of visual cues for the pilot to land.NTSB NYC95LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Waldoboro, METhe pilot's premature lift off which resulted in insufficient climb performance and collision with trees.NTSB FTW95LA055Accident · No injuriesLimited investigationFinal reportBoeing 757-24APF · Tulsa, OKThe pilot's failure to maintain vref during approach and his improper flare touchdown that resulted in an excessive pitch up attitude following touchdown.NTSB ATL95LA018Accident · Minor injuriesLimited investigationFinal reportBartholomew Firestar · High Point, NCThe inadvertent deactivation of the engine ignition system by the pilot, which resulted in loss of engine power.NTSB NYC95LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenburn, METhe pilot's (1) improper decision to initiate a takeoff with ice on the wing.NTSB MIA95LA028Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Tunica, MSThe pilot's delay in obtaining ATC assistance after becoming lost/disoriented resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was failure of the pilot to navigate using the VOR system.NTSB CHI95LA047Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Aurora, MOAn undetermined failure of the engine crankshaft resulting in total loss of engine power. The terrain at the emergency landing site and nighttime darkness were contributing factors.NTSB MIA95LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLThe pilot in command's failure to maintain visual outlook during taxiing.NTSB MIA95FA027Accident · 2 fatalField investigationFinal reportChampion 7ECA · Arcadia, FLThe failure of the dual-student to maintain airspeed while maneuvering resulting in an inadvertent stall and uncontrolled descent. Contributing to the accident was improper supervision of the dual-student by the flight instructor.NTSB LAX95LA040Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Santa Monica, CAfuel starvation to both engines due to the CFI's inadequate fuel consumption calculations during the flight, and his failure to ensure that adequate fuel existed in the main tanks to complete the traffic pattern circuit.NTSB CHI95MA044Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-82 · Bridgeton, MOThe Cessna 441 pilot's mistaken belief that his assigned departure runway was runway 30R, which resulted in his undetected entrance onto runway 30R, which was being used by the MD-82 for its departure. Contributing to the accident was the lack of Automatic…NTSB CHI95IA045Incident · No injuriesIncident investigationFinal reportFokker F-28-4000 · Evansville, INthe failure of company maintenance personnel to adequately service (fill) the horizontal stabilizer drive actuator with hydraulic fluid.NTSB BFO95LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Blooming Grove, PAThe malfunction of the carburetor heat control which resulted in loss of engine power. The carburetor icing weather condition was a factor.NTSB NYC95FA033Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Doylestown, PAthe pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.NTSB MIA95LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Indiantown, FLAn evasive maneuver to avoid collision with animals.NTSB MIA95LA026Accident · Serious injuriesLimited investigationFinal reportBoeing 727-100 · Miami, FLThe failure of the truck driver to maintain visual lookout while operating his truck on an unlit ramp near an aircraft.NTSB LAX95LA039Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Honolulu, HIthe student pilot's improper use of the collective and throttle controls and his failure to maintain adequate main rotor rpm during a practice autorotation.NTSB LAX95LA038Accident · Minor injuriesLimited investigationFinal reportCessna T210H · Mount Hamilton, CAthe pilot's failure to obtain/maintain an adequate airspeed and inadvertent entry into a stall/mush condition during the initial climb due to frost on the airframe which impeded the airplane's climb performance. Contributing factors were the pilot's improper…NTSB CHI95LA043Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Thief Rvr Falls, MNthe flight instructor's delayed remedial action during a simulated forced landing. A factor in the accident is the student pilot's improper landing flare.NTSB BFO95LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Bethel, MEthe flight instructor's failure to ensure adequate control of the airplane during a go-around. The gusty wind conditions were contributing factors.NTSB MIA95WA025Accident · 3 fatalForeign investigationPiper PA28 · St. Vincent, SpainNTSB MIA95LA024Accident · Serious injuriesLimited investigationFinal reportAyres S2R-R1820 · Arcadia, FLFailure of the engine due to a undetermined failure in the engine power section.NTSB FTW95LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Blanco, TXThe pilot's use of unsuitable terrain for takeoff. Factors were the uphill terrain, the long vegetation, and short takeoff area available.NTSB MIA95FA023Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Daytona Beach, FLThe pilot's failure to maintain aircraft control while maneuvering in instrument flight conditions during an instrument approach, resulting in the pilot becoming spatially disoriented, and a subsequent in-flight collision with terrain. Contributing to the…NTSB BFO95LA016Accident · No injuriesLimited investigationFinal reportCessna 150M · Manville, NJthe certificated flight instructor's failure to maintain adequate supervision of the student pilot and ensure control of the airplane during the landing flare/touchdown. The student pilot's lack of total experience and improper aircraft handling were related…NTSB ATL95LA017Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec TS-11 Iskra · Shelby, NCThe pilot's failure to maintain landing approach speed, which resulted in a final approach stall. Factors were the night lighting conditions, and the pilot's failure to use the landing light.NTSB ANC95LA012Accident · 1 fatalLimited investigationFinal reportBell 206 · Juneau, AKThe employee's disregard for company training and policies about the dangers of helicopter rotor blades. The running aircraft with the rotors turning was a factor in the accident.NTSB SEA95LA023Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Yamhill, ORFailure of the pilot to maintain adequate altitude/clearance, while maneuvering to a hover, which allowed the external load cable/hook to become snagged and to rebound into the path of the main rotor blades.NTSB NYC95LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Freeport, PAThe pilot's attempted takeoff in an overweight airplane, his failure to follow approved short field takeoff procedures, not attaining a positive rate of climb, and attempting an operation beyond his experience level.NTSB NYC95FA031Accident · 1 fatalField investigationFinal reportMooney M20J · Brewster, MAFailure of the pilot to maintain control of the airplane during a missed approach. A factor related to the accident was: the deteriorating weather condition with a low ceiling and rain.NTSB NYC95FA030Accident · 1 fatalField investigationFinal reportCessna 402C · Hyannis, MAthe pilot's failure to maintain a proper glide path during an ILS approach, which resulted in a collision with power lines. Factors in this accident were; adverse weather conditions with turbulence, down drafts and fog.NTSB BFO95LA015Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hilltown, PAImproper in-flight planning decision by the pilot, which resulted in insufficient altitude to maintain clearance from trees.NTSB BFO95LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Magnolia, DEthe pilot's failure to maintain adequate rotor rpm while hovering.NTSB ATL95LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Johns Island, SCA loss of engine power due to a partially blocked fuel line to the gascolator.NTSB ANC95LA011Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKThe pilot's selection of unsuitable terrain for landing. The pilot's disregard of a NOTAM that closed the runway and a slush covered runway area were factors in the accident.NTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.NTSB MIA95FA021Accident · 2 fatalField investigationFinal reportPiper PA-18 · Bainbridge, GAInadvertent stall/spin and altitude inadequate for recovery by the pilot-in-command (CFI).NTSB LAX95WA056Accident · No injuriesForeign investigationPiper PA-32R-300 · Tripui, MexicoNTSB LAX95FA262Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Flagstaff, AZthe pilot's intentional flight into known adverse weather conditions, his misjudged evaluation of the weather, and his inexperience in actual instrument flying.NTSB FTW95IA049Incident · No injuriesIncident investigationFinal reportBoeing B-737-200 · Springfield, MOThe failure of either the inboard or the outboard wheel bearing assembly due to undetermined reasons.NTSB FTW95FA050Accident · 2 fatalField investigationFinal reportCessna 172P · Deming, NMThe pilot's failure to maintain sufficient altitude and clearance in moutainous terrain. Factors were rising terrain and gusty, high wind conditions.NTSB ANC95LA013Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot's inadequate compensation for crosswind. Crosswind conditions and an icy runway surface were factors in the accident.NTSB SEA95IA021Incident · No injuriesIncident investigationFinal reportFairchild SA227 · Missoula, MTThe fatigue failure of the first stage compressor impeller.NTSB NYC95FA027Accident · 1 fatalField investigationFinal reportCessna 195A · Broadview Hts, OHthe improper installation of a cabin heater system, resulting in an in-flight fire and subsequent loss of control and collision with trees.NTSB FTW95LA051Accident · No injuriesLimited investigationFinal reportCessna P210N · Alamosa, COFailure by the pilot to properly judge the touch down point. Factors were: failure of the nose landing gear to extend and rough and uneven terrain.NTSB ATL95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Luray, SCThe pilot's improper landing flare which resulted in a hard landing.