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 NYC95FA042Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Colonie, NYFailure of the pilot to maintain control of the aircraft, possibly from falling asleep.NTSB MIA95LA036Accident · Serious injuriesLimited investigationFinal reportColvin Kitfox II · Fort Pierce, FLThe failure of the pilot to abort the takeoff when he encountered water on the grass runway.NTSB LAX95LA047Accident · Serious injuriesLimited investigationFinal reportBenson B8M · Adelanto, CAthe pilot's inadequate compensation for the wind conditions during the downwind turn and his resulting failure to maintain adequate rotor rpm. A factor in the accident was the lack of an airspeed indicator.NTSB ANC95FA016Accident · 5 fatalField investigationFinal reportCessna 402C · Elim, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: darkness and the adverse weather conditions.NTSB CHI95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNthe student pilot's failure to maintain directional control during the takeoff roll. A factor in the accident was the pilot's lack of total experience.NTSB CHI95LA053Accident · 1 fatalLimited investigationFinal reportBeech E18S · Kansas City, MOFailure of the pilot to maintain adequate airspeed on final approach, which resulted in an inadvertent stall/spin. Factors related to the accident were: the adverse weather (icing) conditions, the accumulation of airframe/wing ice, the pilot's improper use of…NTSB BFO95LA019Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Montrose, PATotal loss of engine power for undetermined reasons.NTSB ATL95LA025Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Greenwood, SCUnapproved maintenance work done by uncertificated persons which resulted in a broken starter drive which was not properly removed from the engine. The particles sheared the magneto shafts causing the loss of engine power.NTSB SEA95LA027Accident · No injuriesLimited investigationFinal reportCessna 180 · Lonetree, WYThe restricted movement of the carburebor float.NTSB LAX95LA045Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Oxnard, CAthe pilot's failure to ensure the aircraft was secured prior to attempting an engine start by handpropping.NTSB ATL95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · N. Myrtle Beach, SCThe pilot's failure to properly pre-flight the airplane to ensure the left fuel tank cover was properly secured.NTSB FTW95LA062Accident · No injuriesLimited investigationFinal reportCessna 172B · Seguin, TXThe pilot's failure to attain proper touchdown point.NTSB MIA95WA043Accident · No injuriesForeign investigationIsrael Aircraft Industries WESTWIND-1123 · Caracas, VenezuelaNTSB LAX95FA044Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Groveland, CAthe failure of the pilot to maintain adequate terrain clearance during a nighttime descent into the airport over an unlighted mountainous area. Contributing to the accident was the pilot's distraction by attempting to make several cellular telephone calls…NTSB CHI95IA052Incident · No injuriesIncident investigationFinal reportCessna 402 · Saint Louis, MOimproper maintenance installation (fuel line fitting)by other maintenance personnel. A factor was the cross threaded fuel line fitting.NTSB FTW95LA059Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Village Mills, TXThe pilot's selection of unsuitable terrain for takeoff. A factor was the rough condition of the grass runway.NTSB ANC95LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Angoon, AKThe pilot's continued flight into adverse weather. A factor related to the accident was the snow conditions.NTSB SEA95LA026Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Kent, WAFuel starvation due to the unporting of the useable fuel supply, and the pilot's failure to follow the airplane's published engine starting procedures after the loss of fuel flow during descent. Factors contributing to the accident are the pilot's lack of…NTSB NYC95LA041Accident · No injuriesLimited investigationFinal reportCessna T210M · Wadsworth, OHThe loss of engine power for undetermined reasons which resulted in a forced landing on unsuitable terrain.NTSB NYC95LA040Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Blairstown, NJThe pilot's failure to maintain the proper descent rate.NTSB NYC95LA039Accident · 1 fatalLimited investigationFinal reportWilliam MC Glumphy Kitfox III · Cadiz, OHThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall, and uncontrolled collision with the ground. A factor was pilot's lack of total experience in this make and model.NTSB MIA95LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fajardo, PRThe malfunction of a magneto resulting in a partial loss of power over unsuitable terrain.NTSB LAX95LA042Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Santa Paula, CAThe failure of both pilots to maintain an adequate visual lookout for other traffic in the pattern, and the other pilot's failure to effectively use the CTAF for position reports while in the pattern.NTSB FTW95LA058Accident · No injuriesLimited investigationFinal reportCessna 177 · Katy, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the unsuitable terrain at the pilot's disposal for the forced landing.NTSB BFO95LA018Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sabinsville, PAThe pilot's inadequate visual lookout during cruise flight which resulted in inflight collision with wires.NTSB ATL95FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Statesboro, GAThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, flight into adverse weather conditions, and failure to maintain proper altitude/clearance from wooded terrain. Factors related to the accident were: darkness and…NTSB ANC95LA014Accident · No injuriesLimited investigationFinal reportBell 206B · Kenai, AKThe pilot's failure to follow the information in the flight manual concerning the use of the particle separator kit and deflector kit when operating in falling snow. Factors were the rough terrain in the forced landing area and no installation of the…NTSB MIA95LA032Accident · 1 fatalLimited investigationFinal reportCessna 172D · Miami, FLThe passenger committed suicide.NTSB MIA95GA033Accident · No injuriesFinal reportSikorsky UH-60A · St. Petersburg, FLThe pilot-in-command's failure to maintain separation while ground taxiing between two hangers, resulting in the main rotor blades colliding with a hanger. Contributing to the accident was the lack of written procedures pertaining to ground marshalling of…NTSB LAX95FA043Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260C · North Las Vegas, NVthe pilot's failure to maintain control of the airplane by inadvertently allowing the flying passenger to enter a stall/spin. Factors in the accident were the passenger's interference with the pilot's attempted recovery from the spin, and the pilot's lack of…NTSB FTW95LA060Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Las Cruces, NMThe inadequate maintenance by unknown maintenance personnel. A factor was the collapsed landing gear.NTSB CHI95LA051Accident · 2 fatalLimited investigationFinal reportP. D. Chambers Swift PC-1V8 · Lincoln, NEThe pilot's failure to maintain control of the airplane, resulting in a stall-spin. Factors were an inadequate preflight and the loss of engine power resulting from water contamination in the automotive fuel.NTSB ANC95FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 206 · Kenai, AKUndetermined.NTSB NYC95LA038Accident · No injuriesLimited investigationFinal reportCessna 172J · Batavia, OHFailure of the pilot to maintain control of the airplane during the landing flare/toughdown. Factors related to the accident were: the crosswind and proximity of the ditch to the runway.NTSB LAX95LA041Accident · Serious injuriesLimited investigationFinal reportBritten-Norman Islander BN2B-20 · Pacific Ocean (Pacific Ocean)An undetermined failure of the left engine. The inability of the airplane to maintain level flight and exceeding the one-engine capability was a factor in the accident.NTSB FTW95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Goldthwaite, TXThe pilot's attempted flight into known adverse weather conditions. Factors were the unsuitable terrain, reduced visibility due fog and low ceilings, and the reduced light conditions.NTSB CHI95FA050Accident · 3 fatalField investigationFinal reportAgusta A109A II · Ann Arbor, MIthe pilot's failure to obtain/maintain a successful autorotation. Factors were: a loss of engine power of one engine for undetermined reasons, and the pilot's shutdown of the wrong engine.NTSB SEA95FA025Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Brockway, MTa loss of control for undetermined reasons.NTSB FTW95LA057Accident · 1 fatalLimited investigationFinal reportCessna 172 · Lawton, OKThe pilot's failure to attain sufficient airspeed during takeoff resulting in a stall. Factors were the pilot's selection of the downwind runway and his failure to use all availabble runway.NTSB CHI95LA049Accident · Serious injuriesLimited investigationFinal reportDouglas DC-8-71F · Chicago, ILthe failure of the ground crew to maintain an appropriate center of gravity while downloading cargo from the airplane. A factor was the ground crew's failure to follow established downloading procedures.NTSB FTW95LA056Accident · No injuriesLimited investigationFinal reportBell 206B · Natchitoches, LAThe delayed flare and the improper touchdown by the pilot in command. Factors were the operation of the aircraft with known deficiencies by the operator and the pilot, delayed maintenance, and, an engine compressor assembly stall, combined with erosion and…NTSB CHI95LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · La Porte City, IAa material defect which resulted in the fatigue failure of the crankshaft and the aircraft owner's failure to comply with a Mandatory Service Bulletin addressing the defect. A factor related to the accident was the rough terrain on which the forced landing…NTSB CHI95DCA01Accident · 1 fatalFinal reportYakovlev YAK-52 · Caruthersville, MOThe insufficient altitude (300 feet above the airport) at which an aerobatic maneuver was attempted by the pilot.NTSB ATL95T#A02Accident · No injuriesClass 3Final reportMcdonnell Douglas 369E · Smyrna, TNNTSB ATL95FA022Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Gastonia, NCThe pilot's failure to adequately plan the fuel requirements for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power. The pilot also failed to maintain flying airspeed which resulted in a loss of control, during the…NTSB SEA95LA022Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Twisp, WAAn unexplained loss of power and the student pilot's delayed application of collective during the landing flare.NTSB NYC95LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Niagra Falls, NYThe pilot's inadequate weather evaluation and the on ground encounter with gusty winds.NTSB MIA95LA029Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Lakeport, FLFailure of the pilot to reposition the fuel selector after total loss of engine power due to fuel starvation. Contributing to the accident was her lack of total experience.NTSB LAX95FA046Accident · 2 fatalField investigationFinal reportMaule M-5-235C · Springville, CAthe pilot's entry into a box canyon at an altitude insufficient to maintain clearance from the surrounding terrain and obstacles. Factors in the accident were the high density altitude condition and the steep, rapidly rising nature of the mountainous terrain.NTSB ATL95LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greer, SCThe pilot's failure to follow instrument approach procedures and his premature descent below the published decision height. A factor was pilot fatigue.